[Home] [Help]
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
457: * *************************************************************** */
458: PROCEDURE insert_gmd_tech_data_hdr(x_tech_data_id OUT NOCOPY NUMBER) IS
521: * Synopsis : insert_gmd_tech_data_dtl(1,'DENSITY');
522: *
523: * Description : This function cannot be called independently. It gets
524: * called within Procedure insert_gmd_tech_data_comps.
525: * After it inserts rows in gmd_technical_data_dtl table.
526: * History :
527: * Shyam Sitaraman 02/28/03 Initial Implementation
528: * *************************************************************** */
529: PROCEDURE insert_gmd_tech_data_dtl(vTech_data_id NUMBER) IS
549: RAISE E_Tech_parm_Not_Found;
550: END IF;
551: CLOSE C_get_tech_parm_id;
552:
553: INSERT INTO gmd_technical_data_dtl
554: ( tech_data_id
555: , tech_parm_id
556: , sort_seq
557: , text_data
578: , v_lm_item_dat_rec.last_updated_by
579: , v_lm_item_dat_rec.last_update_login
580: FROM sys.dual
581: WHERE NOT EXISTS
582: (SELECT 1 FROM gmd_technical_data_dtl
583: WHERE tech_parm_id = l_tech_parm_id
584: AND tech_data_id = vTech_data_id);
585: END IF;
586:
603:
604: WHEN OTHERS THEN
605: P_line_no := P_line_no + 1;
606: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id
607: ,p_table_name => 'GMD_TECHNICAL_DATA_DTL'
608: ,p_db_error => sqlerrm
609: ,p_param1 => NULL
610: ,p_param2 => NULL
611: ,p_param3 => NULL