DBA Data[Home] [Help]

APPS.GMD_FORMULA_ANALYSIS dependencies on GMD_FORMULA_ANALYSIS_HDR

Line 186: DELETE FROM gmd_formula_analysis_hdr

182: WHERE formula_id = p_formula_id
183: AND organization_id = p_organization_id
184: AND laboratory_id = p_laboratory_id;
185:
186: DELETE FROM gmd_formula_analysis_hdr
187: WHERE formula_id = p_formula_id
188: AND organization_id = p_organization_id
189: AND laboratory_id = p_laboratory_id;
190:

Line 192: INSERT INTO gmd_formula_analysis_hdr

188: AND organization_id = p_organization_id
189: AND laboratory_id = p_laboratory_id;
190:
191: /* Insert records into tables. */
192: INSERT INTO gmd_formula_analysis_hdr
193: (formula_id, organization_id, laboratory_id, explosion_rule, created_by, creation_date,
194: last_updated_by, last_update_date, last_update_login, analysis_qty, analysis_hdr_uom)
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);