APPS.IRC_OFFERS_API dependencies on HR_API_TRANSACTIONS

Line 1450: l_transaction_id hr_api_transactions.transaction_id%TYPE;

1446: ,P_OFFER_ID IN number
1447: ) Is
1448: --
1449: l_proc varchar2(72) := g_package||'close_notifications';
1450: l_transaction_id hr_api_transactions.transaction_id%TYPE;
1451: l_item_type hr_api_transactions.item_type%TYPE;
1452: l_item_key hr_api_transactions.item_key%TYPE;
1453: --
1454: cursor csr_get_txn_details is

Line 1451: l_item_type hr_api_transactions.item_type%TYPE;

1447: ) Is
1448: --
1449: l_proc varchar2(72) := g_package||'close_notifications';
1450: l_transaction_id hr_api_transactions.transaction_id%TYPE;
1451: l_item_type hr_api_transactions.item_type%TYPE;
1452: l_item_key hr_api_transactions.item_key%TYPE;
1453: --
1454: cursor csr_get_txn_details is
1455: select transaction_id

Line 1452: l_item_key hr_api_transactions.item_key%TYPE;

1448: --
1449: l_proc varchar2(72) := g_package||'close_notifications';
1450: l_transaction_id hr_api_transactions.transaction_id%TYPE;
1451: l_item_type hr_api_transactions.item_type%TYPE;
1452: l_item_key hr_api_transactions.item_key%TYPE;
1453: --
1454: cursor csr_get_txn_details is
1455: select transaction_id
1456: ,item_type

Line 1458: from hr_api_transactions

1454: cursor csr_get_txn_details is
1455: select transaction_id
1456: ,item_type
1457: ,item_key
1458: from hr_api_transactions
1459: where transaction_ref_table='IRC_OFFERS'
1460: and transaction_ref_id = p_offer_id;
1461: --
1462: cursor csr_get_sfl_txn_details is

Line 1466: from hr_api_transactions hat,

1462: cursor csr_get_sfl_txn_details is
1463: select hat.transaction_id
1464: ,wn.MESSAGE_TYPE
1465: ,wn.item_key
1466: from hr_api_transactions hat,
1467: wf_notifications wn
1468: where hat.transaction_ref_table='IRC_OFFERS'
1469: and hat.STATUS='S'
1470: and wn.MESSAGE_TYPE='HRSFL'