DBA Data[Home] [Help]

APPS.GMD_FORMULA_ANALYSIS dependencies on GMD_FORMULA_ANALYSIS_DTL

Line 181: DELETE FROM gmd_formula_analysis_dtl

177: RAISE LOAD_DATA_ERR;
178: END IF;
179:
180: /* Remove any previous analysis data for this formula and organization */
181: DELETE FROM gmd_formula_analysis_dtl
182: WHERE formula_id = p_formula_id
183: AND organization_id = p_organization_id
184: AND laboratory_id = p_laboratory_id;
185:

Line 199: INSERT INTO gmd_formula_analysis_dtl

195: VALUES (p_formula_id, p_organization_id, p_laboratory_id, p_explosion_rule, X_user, SYSDATE,
196: X_user, SYSDATE, X_login_id, p_analysis_qty, p_rep_um);
197:
198: FOR i IN 1..P_dtl_tab.COUNT LOOP
199: INSERT INTO gmd_formula_analysis_dtl
200: (formula_id, organization_id, laboratory_id, inventory_item_id, technical_class, technical_sub_class,
201: direct_weight, direct_weight_percent, indirect_weight, indirect_weight_percent,
202: direct_volume, direct_volume_percent, indirect_volume, indirect_volume_percent)
203: VALUES (p_formula_id, p_organization_id, p_laboratory_id, P_dtl_tab(i).inventory_item_id, P_dtl_tab(i).technical_class,