DBA Data[Home] [Help]

APPS.IBY_MERGE dependencies on HZ_CUSTOMER_MERGE_LOG

Line 123: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

119: ext_payer_to_list(i) := get_external_payer_id(num_col1_new_list(i),num_col3_new_list(i));
120: END LOOP;
121: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
122: FORALL I in 1..merge_header_id_list.COUNT
123: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
124: merge_log_id,
125: table_name,
126: merge_header_id,
127: primary_key_id,

Line 141: ) VALUES ( hz_customer_merge_log_s.nextval,

137: creation_date,
138: last_update_login,
139: last_update_date,
140: last_updated_by
141: ) VALUES ( hz_customer_merge_log_s.nextval,
142: 'IBY_TRXN_SUMMARIES_ALL',
143: merge_header_id_list(i),
144: primary_key_id_list(i),
145: num_col1_orig_list(i),

Line 867: INSERT INTO hz_customer_merge_log (

863:
864: END LOOP;
865: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
866: FORALL I in 1..merge_header_id_list.COUNT
867: INSERT INTO hz_customer_merge_log (
868: merge_log_id,
869: table_name,
870: merge_header_id,
871: primary_key_id,

Line 883: ) VALUES ( hz_customer_merge_log_s.nextval,

879: creation_date,
880: last_update_login,
881: last_update_date,
882: last_updated_by
883: ) VALUES ( hz_customer_merge_log_s.nextval,
884: 'IBY_EXTERNAL_PAYERS_ALL',
885: merge_header_id_list(i),
886: primary_key_id_list(i),
887: num_col1_orig_list(i),