APPS.GMD_FORMULA_ANALYSIS dependencies on GMD_FORMULA_ANALYSIS

Line 1: PACKAGE BODY gmd_formula_analysis AS

1: PACKAGE BODY gmd_formula_analysis AS
2: /* $Header: GMDFANLB.pls 120.6.12000000.2 2007/09/13 07:21:34 kannavar ship $ */
3:
4: G_PKG_NAME VARCHAR2(32);
5:

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 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);

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,

Line 1254: END gmd_formula_analysis;

1250: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_ing_rec.item_no);
1251: FND_MESSAGE.SET_TOKEN('ORGN', l_orgn_code);
1252: END get_density;
1253:
1254: END gmd_formula_analysis;