DBA Data[Home] [Help]

APPS.PAY_ASSG_COST_WF dependencies on HR_API_TRANSACTIONS

Line 111: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;

107: itemkey in varchar2,
108: actid in number,
109: funcmode in varchar2) RETURN NUMBER IS
110:
111: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
112: l_result varchar2(100);
113: l_performer_id number(10);
114: l_proc varchar2(100) := g_package||'GET_TRANSACTION_ID';
115: BEGIN

Line 160: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;

156: resultout out nocopy varchar2)
157: is
158: all_approvers ame_util.approversTable2;
159: next_approver ame_util.approversTable2;
160: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
161: l_apprvl_process_complete varchar2(1000);
162: l_proc varchar2(72) := g_package||'check_approvers_exist';
163: l_flagApproversAsNotified varchar2(10);
164: l_role_name varchar2(240);

Line 255: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;

251:
252: l_current_approver ame_util.approversTable2 := g_approver;
253: l_next_approver ame_util.approversTable2;
254:
255: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
256: l_apprvl_process_complete varchar2(1000);
257: l_proc varchar2(72);
258: l_flagApproversAsNotified varchar2(10);
259: l_role_name varchar2(240);

Line 428: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;

424: ,itemkey in varchar2
425: ,actid in number
426: ,funmode in varchar2
427: ,result out nocopy varchar2) is
428: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
429: l_transaction_step_id HR_UTIL_WEB.G_VARCHAR2_TAB_TYPE;
430: l_api_name HR_UTIL_WEB.G_VARCHAR2_TAB_TYPE;
431: l_row number;
432: l_proc varchar2(255) := g_package||'APPROVE_PROCESS';