DBA Data[Home] [Help]

APPS.GMD_LM_MIGRATION dependencies on GMD_TECHNICAL_SEQUENCE_HDR

Line 243: INSERT INTO gmd_technical_sequence_hdr

239: BEGIN
240: SELECT gmd_tech_seq_id_s.nextval INTO x_tech_seq_id
241: FROM sys.dual;
242:
243: INSERT INTO gmd_technical_sequence_hdr
244: ( tech_seq_id
245: , orgn_code
246: , item_id
247: , category_id

Line 270: FROM gmd_technical_sequence_hdr

266: , v_lm_prlt_asc_rec.last_update_login
267: FROM
268: sys.dual
269: WHERE NOT EXISTS (SELECT 1
270: FROM gmd_technical_sequence_hdr
271: WHERE orgn_code = v_lm_prlt_asc_rec.orgn_code);
272: EXCEPTION
273: WHEN OTHERS THEN
274: P_line_no := P_line_no + 1;

Line 276: ,p_table_name => 'GMD_TECHNICAL_SEQUENCE_HDR'

272: EXCEPTION
273: WHEN OTHERS THEN
274: P_line_no := P_line_no + 1;
275: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id
276: ,p_table_name => 'GMD_TECHNICAL_SEQUENCE_HDR'
277: ,p_db_error => sqlerrm
278: ,p_param1 => NULL
279: ,p_param2 => NULL
280: ,p_param3 => NULL

Line 430: ,p_table_name => 'GMD_TECHNICAL_SEQUENCE_HDR'

426: EXCEPTION
427: WHEN OTHERS THEN
428: P_line_no := P_line_no + 1;
429: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id
430: ,p_table_name => 'GMD_TECHNICAL_SEQUENCE_HDR'
431: ,p_db_error => sqlerrm
432: ,p_param1 => NULL
433: ,p_param2 => NULL
434: ,p_param3 => NULL