APPS.GMD_SPREAD_FETCH_PKG dependencies on LM_SPRD_TEC

Line 1095: FROM lm_sprd_tec a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c

1091: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
1092: SELECT a.sprd_id,c.line_id,a.tech_parm_name,a.tech_parm_id,
1093: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
1094: b.sort_seq,a.num_data,a.text_data,a.boolean_data
1095: FROM lm_sprd_tec a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
1096: WHERE a.tech_parm_id = b.tech_parm_id
1097: AND a.sprd_id = V_entity_id
1098: AND a.line_id = c.sprd_line_id
1099: AND a.organization_id = V_orgn_id

Line 1288: DELETE FROM lm_sprd_tec

1284: text_code = V_text_code
1285: WHERE sprd_name = V_spread_name;
1286: DELETE FROM lm_sprd_dtl
1287: WHERE sprd_id = V_sprd_id;
1288: DELETE FROM lm_sprd_tec
1289: WHERE sprd_id = V_sprd_id;
1290: DELETE FROM lm_sprd_prm
1291: WHERE sprd_id = V_sprd_id;
1292: ELSE

Line 1335: INSERT INTO lm_sprd_tec (line_id,organization_id,tech_parm_name,tech_parm_id,sprd_id,sort_seq,num_data,text_data,

1331: l_rec.secondary_uom,l_rec.buffer_ind,l_rec.plant_organization_id,
1332: l_rec.organization_id,l_rec.tpformula_id,l_rec.last_updated_by,l_rec.last_update_date,--added l_rec.tpformula_id for Bug#7254259
1333: l_rec.created_by,l_rec.creation_date,l_rec.locator_id,l_rec.prod_percent);
1334:
1335: INSERT INTO lm_sprd_tec (line_id,organization_id,tech_parm_name,tech_parm_id,sprd_id,sort_seq,num_data,text_data,
1336: boolean_data,last_updated_by,last_update_date,created_by,creation_date)
1337: SELECT X_line_id, V_orgn_id, tech_parm_name,tech_parm_id,
1338: X_sprd_id,sort_seq,num_data,text_data,boolean_data,
1339: l_user_id,sysdate,l_user_id,sysdate