APPS.IRC_APPROVALS dependencies on HR_API_TRANSACTIONS

Line 24: transactionDoc hr_api_transactions.transaction_document%type;

20: ,p_path in varchar2)
21: return varchar2 is
22: --
23: l_retval varchar2(32000);
24: transactionDoc hr_api_transactions.transaction_document%type;
25: --
26: cursor get_doc is
27: select transaction_document
28: from hr_api_transactions

Line 28: from hr_api_transactions

24: transactionDoc hr_api_transactions.transaction_document%type;
25: --
26: cursor get_doc is
27: select transaction_document
28: from hr_api_transactions
29: where transaction_id = p_transaction_id;
30: --
31: begin
32: --

Line 1283: cursor csr_trans(c_transaction_id hr_api_transactions.transaction_id%TYPE) is

1279: and trunc(sysdate)
1280: between effective_start_date
1281: and effective_end_date;
1282: --
1283: cursor csr_trans(c_transaction_id hr_api_transactions.transaction_id%TYPE) is
1284: select creator_person_id
1285: from hr_api_transactions
1286: where transaction_id = c_transaction_id;
1287: --

Line 1285: from hr_api_transactions

1281: and effective_end_date;
1282: --
1283: cursor csr_trans(c_transaction_id hr_api_transactions.transaction_id%TYPE) is
1284: select creator_person_id
1285: from hr_api_transactions
1286: where transaction_id = c_transaction_id;
1287: --
1288: BEGIN
1289: --

Line 1423: l_transaction_id hr_api_transactions.transaction_id%type;

1419: document_type in out nocopy varchar2,
1420: flowmode in varchar2) is
1421: --
1422: l_vacancy_name per_all_vacancies.name%type;
1423: l_transaction_id hr_api_transactions.transaction_id%type;
1424: l_originators_name per_all_people_f.full_name%type;
1425: --
1426: Begin
1427: --

Line 1540: l_transaction_id hr_api_transactions.transaction_id%type;

1536: document_type in out nocopy varchar2,
1537: flowmode in varchar2) is
1538: --
1539: l_vacancy_name per_all_vacancies.name%type;
1540: l_transaction_id hr_api_transactions.transaction_id%type;
1541: l_applicant_name per_all_people_f.full_name%type;
1542: --
1543: Begin
1544: --