DBA Data[Home] [Help]

APPS.HR_XML_UTIL dependencies on HR_API_TRANSACTIONS

Line 261: from hr_api_transactions

257: )return varchar2 is
258: -- Cursor to fetch the TXN_DOCUMENT
259: cursor csr_trn is
260: select transaction_document
261: from hr_api_transactions
262: where transaction_id = p_transaction_id;
263: --
264: txn_row csr_trn%rowtype;
265: --

Line 393: -- From the table : HR_API_TRANSACTIONS

389: (p_item_type in varchar2
390: ,p_item_key in varchar2
391: )return number is
392: -- Cursor to select the Txn id
393: -- From the table : HR_API_TRANSACTIONS
394: cursor csr_hat is
395: select transaction_id
396: from hr_api_transactions
397: where ITEM_KEY = p_item_key

Line 396: from hr_api_transactions

392: -- Cursor to select the Txn id
393: -- From the table : HR_API_TRANSACTIONS
394: cursor csr_hat is
395: select transaction_id
396: from hr_api_transactions
397: where ITEM_KEY = p_item_key
398: and ITEM_TYPE = p_item_type;
399: -- RowType
400: hat_row csr_hat%rowType;