APPS.IRC_OFFERS_API dependencies on HR_API_TRANSACTIONS

Line 1557: l_transaction_id hr_api_transactions.transaction_id%TYPE;

1553: ,P_OFFER_ID IN number
1554: ) Is
1555: --
1556: l_proc varchar2(72) := g_package||'close_notifications';
1557: l_transaction_id hr_api_transactions.transaction_id%TYPE;
1558: l_item_type hr_api_transactions.item_type%TYPE;
1559: l_item_key hr_api_transactions.item_key%TYPE;
1560: --
1561: cursor csr_get_txn_details is

Line 1558: l_item_type hr_api_transactions.item_type%TYPE;

1554: ) Is
1555: --
1556: l_proc varchar2(72) := g_package||'close_notifications';
1557: l_transaction_id hr_api_transactions.transaction_id%TYPE;
1558: l_item_type hr_api_transactions.item_type%TYPE;
1559: l_item_key hr_api_transactions.item_key%TYPE;
1560: --
1561: cursor csr_get_txn_details is
1562: select transaction_id

Line 1559: l_item_key hr_api_transactions.item_key%TYPE;

1555: --
1556: l_proc varchar2(72) := g_package||'close_notifications';
1557: l_transaction_id hr_api_transactions.transaction_id%TYPE;
1558: l_item_type hr_api_transactions.item_type%TYPE;
1559: l_item_key hr_api_transactions.item_key%TYPE;
1560: --
1561: cursor csr_get_txn_details is
1562: select transaction_id
1563: ,item_type

Line 1565: from hr_api_transactions

1561: cursor csr_get_txn_details is
1562: select transaction_id
1563: ,item_type
1564: ,item_key
1565: from hr_api_transactions
1566: where transaction_ref_table='IRC_OFFERS'
1567: and transaction_ref_id = p_offer_id;
1568: --
1569: cursor csr_get_sfl_txn_details is

Line 1573: from hr_api_transactions hat,

1569: cursor csr_get_sfl_txn_details is
1570: select hat.transaction_id
1571: ,wn.MESSAGE_TYPE
1572: ,wn.item_key
1573: from hr_api_transactions hat,
1574: wf_notifications wn
1575: where hat.transaction_ref_table='IRC_OFFERS'
1576: and hat.STATUS='S'
1577: and wn.MESSAGE_TYPE='HRSFL'