DBA Data[Home] [Help]

APPS.GMD_LM_MIGRATION dependencies on GMD_TECHNICAL_SEQUENCE_DTL

Line 323: INSERT INTO gmd_technical_sequence_dtl

319: RAISE E_Tech_parm_Not_Found;
320: END IF;
321: CLOSE C_get_tech_parm_id;
322:
323: INSERT INTO gmd_technical_sequence_dtl
324: ( tech_seq_id
325: , tech_parm_id
326: , sort_seq
327: , text_code

Line 345: (SELECT 1 FROM gmd_technical_sequence_dtl

341: , v_lm_prlt_asc_rec.last_updated_by
342: , v_lm_prlt_asc_rec.last_update_login
343: FROM sys.dual
344: WHERE NOT EXISTS
345: (SELECT 1 FROM gmd_technical_sequence_dtl
346: WHERE tech_parm_id = l_tech_parm_id
347: AND tech_seq_id = vTech_seq_id);
348: END IF;
349:

Line 354: ,p_table_name => 'GMD_TECHNICAL_SEQUENCE_DTL'

350: EXCEPTION
351: WHEN E_Tech_parm_Not_Found THEN
352: P_line_no := P_line_no + 1;
353: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id
354: ,p_table_name => 'GMD_TECHNICAL_SEQUENCE_DTL'
355: ,p_db_error => sqlerrm
356: ,p_param1 => v_lm_prlt_asc_rec.tech_parm_name
357: ,p_param2 => v_lm_prlt_asc_rec.orgn_code
358: ,p_param3 => NULL

Line 370: ,p_table_name => 'GMD_TECHNICAL_SEQUENCE_DTL'

366:
367: WHEN OTHERS THEN
368: P_line_no := P_line_no + 1;
369: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id
370: ,p_table_name => 'GMD_TECHNICAL_SEQUENCE_DTL'
371: ,p_db_error => sqlerrm
372: ,p_param1 => NULL
373: ,p_param2 => NULL
374: ,p_param3 => NULL