DBA Data[Home] [Help]

APPS.PAY_ASSG_COST_WF dependencies on HR_API_TRANSACTIONS

Line 18: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;

14: itemkey in varchar2,
15: actid in number,
16: funcmode in varchar2) RETURN NUMBER IS
17:
18: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
19: l_result varchar2(100);
20: l_performer_id number(10);
21: l_proc varchar2(100) := g_package||'GET_TRANSACTION_ID';
22: BEGIN

Line 67: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;

63: resultout out nocopy varchar2)
64: is
65: all_approvers ame_util.approversTable2;
66: next_approver ame_util.approversTable2;
67: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
68: l_apprvl_process_complete varchar2(1000);
69: l_proc varchar2(72) := g_package||'check_approvers_exist';
70: l_flagApproversAsNotified varchar2(10);
71: l_role_name varchar2(240);

Line 159: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;

155:
156: l_current_approver ame_util.approversTable2 := g_approver;
157: l_next_approver ame_util.approversTable2;
158:
159: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
160: l_apprvl_process_complete varchar2(1000);
161: l_proc varchar2(72);
162: l_flagApproversAsNotified varchar2(10);
163: l_role_name varchar2(240);

Line 321: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;

317: ,itemkey in varchar2
318: ,actid in number
319: ,funmode in varchar2
320: ,result out nocopy varchar2) is
321: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
322: l_transaction_step_id HR_UTIL_WEB.G_VARCHAR2_TAB_TYPE;
323: l_api_name HR_UTIL_WEB.G_VARCHAR2_TAB_TYPE;
324: l_row number;
325: l_proc varchar2(255) := g_package||'APPROVE_PROCESS';