57: SET tech_parm_id = l_tech_parm_id
58: WHERE tech_parm_name = C_get_tech_parms_rec.tech_parm_name
59: AND orgn_code = C_get_tech_parms_rec.orgn_code;
60:
61: /* Create tech_parm_id for lm_sprd_prm */
62: UPDATE lm_sprd_prm
63: SET tech_parm_id = l_tech_parm_id
64: WHERE tech_parm_name = C_get_tech_parms_rec.tech_parm_name
65: AND orgn_code = C_get_tech_parms_rec.orgn_code;
58: WHERE tech_parm_name = C_get_tech_parms_rec.tech_parm_name
59: AND orgn_code = C_get_tech_parms_rec.orgn_code;
60:
61: /* Create tech_parm_id for lm_sprd_prm */
62: UPDATE lm_sprd_prm
63: SET tech_parm_id = l_tech_parm_id
64: WHERE tech_parm_name = C_get_tech_parms_rec.tech_parm_name
65: AND orgn_code = C_get_tech_parms_rec.orgn_code;
66: