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 1401: l_transaction_id hr_api_transactions.transaction_id%type;

1397: document_type in out nocopy varchar2,
1398: flowmode in varchar2) is
1399: --
1400: l_vacancy_name per_all_vacancies.name%type;
1401: l_transaction_id hr_api_transactions.transaction_id%type;
1402: l_originators_name per_all_people_f.full_name%type;
1403: --
1404: Begin
1405: --

Line 1526: l_transaction_id hr_api_transactions.transaction_id%type;

1522: document_type in out nocopy varchar2,
1523: flowmode in varchar2) is
1524: --
1525: l_vacancy_name per_all_vacancies.name%type;
1526: l_transaction_id hr_api_transactions.transaction_id%type;
1527: l_applicant_name per_all_people_f.full_name%type;
1528: --
1529: Begin
1530: --