[Home] [Help]
1058: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
1059: SELECT a.sprd_id,c.line_id,a.tech_parm_name,a.tech_parm_id,
1060: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
1061: b.sort_seq,a.num_data,a.text_data,a.boolean_data
1062: FROM lm_sprd_tec a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
1063: WHERE a.tech_parm_id = b.tech_parm_id
1064: AND a.sprd_id = V_entity_id
1065: AND a.line_id = c.sprd_line_id
1066: AND a.organization_id = V_orgn_id
1250: text_code = V_text_code
1251: WHERE sprd_name = V_spread_name;
1252: DELETE FROM lm_sprd_dtl
1253: WHERE sprd_id = V_sprd_id;
1254: DELETE FROM lm_sprd_tec
1255: WHERE sprd_id = V_sprd_id;
1256: DELETE FROM lm_sprd_prm
1257: WHERE sprd_id = V_sprd_id;
1258: ELSE
1297: l_rec.secondary_uom,l_rec.buffer_ind,l_rec.plant_organization_id,
1298: l_rec.organization_id,l_rec.last_updated_by,l_rec.last_update_date,
1299: l_rec.created_by,l_rec.creation_date,l_rec.locator_id);
1300:
1301: INSERT INTO lm_sprd_tec (line_id,organization_id,tech_parm_name,tech_parm_id,sprd_id,sort_seq,num_data,text_data,
1302: boolean_data,last_updated_by,last_update_date,created_by,creation_date)
1303: SELECT X_line_id, V_orgn_id, tech_parm_name,tech_parm_id,
1304: X_sprd_id,sort_seq,num_data,text_data,boolean_data,
1305: l_user_id,sysdate,l_user_id,sysdate