APPS.HXC_TIMECARD_AUDIT dependencies on HXC_TRANSACTIONS

Line 39: ,p_transaction_id out nocopy hxc_transactions.transaction_id%type

35: Procedure insert_audit_header
36: (p_overall_status in varchar2
37: ,p_transaction_info in hxc_timecard.transaction_info
38: ,p_messages in out nocopy hxc_message_table_type
39: ,p_transaction_id out nocopy hxc_transactions.transaction_id%type
40: ) is
41:
42: cursor c_transaction_sequence is
43: select hxc_transactions_s.nextval from dual;

Line 43: select hxc_transactions_s.nextval from dual;

39: ,p_transaction_id out nocopy hxc_transactions.transaction_id%type
40: ) is
41:
42: cursor c_transaction_sequence is
43: select hxc_transactions_s.nextval from dual;
44:
45: l_transaction_id hxc_transactions.transaction_id%TYPE;
46: l_deposit_process_id hxc_deposit_processes.deposit_process_id%type;
47: l_data_set_id hxc_transactions.data_set_id%TYPE;

Line 45: l_transaction_id hxc_transactions.transaction_id%TYPE;

41:
42: cursor c_transaction_sequence is
43: select hxc_transactions_s.nextval from dual;
44:
45: l_transaction_id hxc_transactions.transaction_id%TYPE;
46: l_deposit_process_id hxc_deposit_processes.deposit_process_id%type;
47: l_data_set_id hxc_transactions.data_set_id%TYPE;
48: l_index BINARY_INTEGER;
49:

Line 47: l_data_set_id hxc_transactions.data_set_id%TYPE;

43: select hxc_transactions_s.nextval from dual;
44:
45: l_transaction_id hxc_transactions.transaction_id%TYPE;
46: l_deposit_process_id hxc_deposit_processes.deposit_process_id%type;
47: l_data_set_id hxc_transactions.data_set_id%TYPE;
48: l_index BINARY_INTEGER;
49:
50: Begin
51:

Line 100: ,p_transaction_id in hxc_transactions.transaction_id%type

96:
97: Procedure insert_audit_details
98: (p_transaction_info in out nocopy hxc_timecard.transaction_info
99: ,p_messages in out nocopy hxc_message_table_type
100: ,p_transaction_id in hxc_transactions.transaction_id%type
101: ) is
102:
103: l_index NUMBER;
104:

Line 164: l_transaction hxc_transactions.transaction_id%type;

160: ) is
161:
162: PRAGMA AUTONOMOUS_TRANSACTION;
163:
164: l_transaction hxc_transactions.transaction_id%type;
165:
166: Begin
167:
168: insert_audit_header