APPS.GMD_SPREAD_FETCH_PKG dependencies on LM_SPRD_PRM

Line 818: FROM lm_sprd_prm a, lm_tech_hdr b

814: b.data_type,b.expression_char,b.lm_unit_code,
815: DECODE(b.data_type, 4, NVL(b.signif_figures, 0 ), 11, NVL(b.signif_figures, 0 ),b.signif_figures ),
816: a.min_value,a.max_value,a.optimize_type,
817: b.lowerbound_char,b.upperbound_char,b.max_length
818: FROM lm_sprd_prm a, lm_tech_hdr b
819: WHERE a.tech_parm_id = b.tech_parm_id
820: AND a.sprd_id = V_entity_id
821: AND a.organization_id = V_orgn_id;
822:

Line 1290: DELETE FROM lm_sprd_prm

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
1293: OPEN Cur_sprd_id;
1294: FETCH Cur_sprd_id INTO X_sprd_id;

Line 1307: INSERT INTO lm_sprd_prm (sprd_id,organization_id,tech_parm_name,tech_parm_id,sort_seq,data_type,

1303: V_last_update_date,l_user_id,
1304: l_user_id, V_text_code, 0, V_move_order_header_id);
1305: END IF;
1306:
1307: INSERT INTO lm_sprd_prm (sprd_id,organization_id,tech_parm_name,tech_parm_id,sort_seq,data_type,
1308: expression_char,min_value,max_value,precision,optimize_type,
1309: last_updated_by,last_update_date,created_by,creation_date)
1310: SELECT X_sprd_id, V_orgn_id,tech_parm_name,tech_parm_id,sort_seq,data_type,
1311: expression_char,lowerbound_num,upperbound_num,signif_figures,optimize_type,