APPS.GMD_LM_MIGRATION dependencies on GMD_TECHNICAL_DATA_HDR

Line 452: * It inserts a row in gmd_technical_data_hdr table and also

448: * Synopsis : insert_gmd_tech_data_hdr(xTech_data_id)
449: *
450: * Description : This function cannot be called independently. It gets
451: * called within Procedure insert_gmd_tech_data_comps.
452: * It inserts a row in gmd_technical_data_hdr table and also
453: * returns the Tech_data_id, which is used to insert
454: * details in gmd_technical_data_dtl table.
455: * History :
456: * Shyam Sitaraman 02/28/03 Initial Implementation

Line 464: INSERT INTO gmd_technical_data_hdr

460: BEGIN
461: SELECT gmd_tech_data_id_s.nextval INTO x_tech_data_id
462: FROM sys.dual;
463:
464: INSERT INTO gmd_technical_data_hdr
465: ( tech_data_id
466: , orgn_code
467: , item_id
468: , lot_id

Line 495: FROM gmd_technical_data_hdr

491: , v_lm_item_dat_rec.last_update_login
492: FROM
493: sys.dual
494: WHERE NOT EXISTS (SELECT 1
495: FROM gmd_technical_data_hdr
496: WHERE orgn_code = v_lm_item_dat_rec.orgn_code
497: AND item_id = v_lm_item_dat_rec.item_id);
498:
499: EXCEPTION

Line 504: ,p_table_name => 'GMD_TECHNICAL_DATA_HDR'

500:
501: WHEN OTHERS THEN
502: P_line_no := P_line_no + 1;
503: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id
504: ,p_table_name => 'GMD_TECHNICAL_DATA_HDR'
505: ,p_db_error => sqlerrm
506: ,p_param1 => NULL
507: ,p_param2 => NULL
508: ,p_param3 => NULL

Line 591: ,p_table_name => 'GMD_TECHNICAL_DATA_HDR'

587: EXCEPTION
588: WHEN E_Tech_parm_Not_Found THEN
589: P_line_no := P_line_no + 1;
590: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id
591: ,p_table_name => 'GMD_TECHNICAL_DATA_HDR'
592: ,p_db_error => sqlerrm
593: ,p_param1 => NULL
594: ,p_param2 => NULL
595: ,p_param3 => NULL

Line 674: ,p_table_name => 'GMD_TECHNICAL_DATA_HDR'

670: EXCEPTION
671: WHEN OTHERS THEN
672: P_line_no := P_line_no + 1;
673: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id
674: ,p_table_name => 'GMD_TECHNICAL_DATA_HDR'
675: ,p_db_error => sqlerrm
676: ,p_param1 => NULL
677: ,p_param2 => NULL
678: ,p_param3 => NULL