APPS.GMD_SPREAD_FETCH_PKG dependencies on LM_SPRD_PRM

Line 788: FROM lm_sprd_prm a, lm_tech_hdr b

784: b.data_type,b.expression_char,b.lm_unit_code,
785: DECODE(b.data_type, 4, NVL(b.signif_figures, 0 ), 11, NVL(b.signif_figures, 0 ),b.signif_figures ),
786: a.min_value,a.max_value,a.optimize_type,
787: b.lowerbound_char,b.upperbound_char,b.max_length
788: FROM lm_sprd_prm a, lm_tech_hdr b
789: WHERE a.tech_parm_id = b.tech_parm_id
790: AND a.sprd_id = V_entity_id
791: AND a.organization_id = V_orgn_id;
792:

Line 1256: DELETE FROM lm_sprd_prm

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
1259: OPEN Cur_sprd_id;
1260: FETCH Cur_sprd_id INTO X_sprd_id;

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

1269: V_last_update_date,l_user_id,
1270: l_user_id, V_text_code, 0, V_move_order_header_id);
1271: END IF;
1272:
1273: INSERT INTO lm_sprd_prm (sprd_id,organization_id,tech_parm_name,tech_parm_id,sort_seq,data_type,
1274: expression_char,min_value,max_value,precision,optimize_type,
1275: last_updated_by,last_update_date,created_by,creation_date)
1276: SELECT X_sprd_id, V_orgn_id,tech_parm_name,tech_parm_id,sort_seq,data_type,
1277: expression_char,lowerbound_num,upperbound_num,signif_figures,optimize_type,