Author Topic: Leave absence UPDATE not working properly using Backend ORACLE PLSQL  (Read 1879 times)

0 Members and 1 Guest are viewing this topic.

Offline priyapushpa

  • Newbie
  • *
  • Posts: 1
Hi,

I am new to Oracle EBS Workflow. Our requirement is to create a Leave Absence /Update and Delete it via Backend Procedure.

I am able to Create and Delete a leave absence.  our requirement is to UPDATE  a leave absence once it got Approved.

But when I try to Update the leave (after approval) I am not getting any error. But for the Approver latest updated value is not getting displaying instead only the old values are shown. But once I approve this after approval it is showing the Updated value in the screen.

I really got confused about what is happening. tried a lot with code changes but of vain. my piece of code below.

Pls. help me out in solving this. what I am missing ...

   hr_transaction_swi.create_transaction
   (
P_TRANSACTION_ID                        =>        P_TRANSACTION_ID
..........................................

hr_transaction_swi.create_transaction_step
   (
P_API_NAME                 =>     p_step_api_name
 ,P_API_DISPLAY_NAME         =>     p_step_api_display_name
 ,P_PROCESSING_ORDER         =>     p_step_processing_order
...........................................

hr_transaction_swi.setTransactionStatus(p_transaction_id, NULL,
'PER_ABSENCE_ATTENDANCES', NULL, 'A', hr_api.g_true_num, lv_status);

Offline e_abdelbadea@yahoo.com

  • Newbie
  • *
  • Posts: 1
Re: Leave absence UPDATE not working properly using Backend ORACLE PLSQL
« Reply #1 on: September 06, 2015, 04:49:52 PM »
Hi dear

I have a business case similar to yours.
I already use the following API
                         wf_engine.createprocess
                         wf_engine.setitemattrtext
                         wf_engine.startprocess         

Then Used the following API's to populate Transactions tables

hr_transaction_api.create_transaction
hr_transaction_api.create_transaction_step
hr_transaction_api.set_number_value

The issue that i face now is How to Make (AME) work to get Approvers and send notifications.
Does there any thing must to do to start AME ? if yes kindly Provide me with any API to do this?



thanks alot