APPS.PMI_COST_ANALZ_PACK dependencies on FM_FORM_MST

Line 253: formula_id_vi IN fm_form_mst.formula_id%TYPE,

249:
250:
251: FUNCTION gmca_variance(
252: batch_id_vi IN gme_batch_header.batch_id%TYPE,
253: formula_id_vi IN fm_form_mst.formula_id%TYPE,
254: batch_line_id_vi IN gme_material_details.material_detail_id%TYPE,
255: cost_mthd_vi IN cm_cmpt_dtl.cost_mthd_code%TYPE,
256: plan_qty_vi IN gme_material_details.plan_qty%TYPE,
257: item_um_vi IN gme_material_details.item_um%TYPE,

Line 295: cost_formula_id_v fm_form_mst.formula_id%TYPE;

291: cost_date_v DATE := NULL;
292: cost_calendar_v cm_cldr_dtl.calendar_code%TYPE;
293: cost_period_v cm_cldr_dtl.period_code%TYPE;
294: cost_fmeff_id_v fm_form_eff.fmeff_id%TYPE;
295: cost_formula_id_v fm_form_mst.formula_id%TYPE;
296:
297: all_linear BOOLEAN := TRUE;
298: b NUMBER := 0; /* Secondary Scaling Factor */
299:

Line 305: CURSOR primary_product_cur(formula_id_p fm_form_mst.formula_id%TYPE)

301: fm_scale_type_v NUMBER := 1; /* linear by default */
302:
303: /* Need a cursor to select primary product from formula since
304: there can be blank lines? */
305: CURSOR primary_product_cur(formula_id_p fm_form_mst.formula_id%TYPE)
306: IS
307: SELECT item_id
308: FROM
309: fm_matl_dtl

Line 317: CURSOR costing_pri_product_cur(formula_id_p fm_form_mst.formula_id%TYPE,

313: ORDER BY
314: line_no;
315:
316: /* Select fm_qty and fm_qty_um from costing formula */
317: CURSOR costing_pri_product_cur(formula_id_p fm_form_mst.formula_id%TYPE,
318: item_id_p ic_item_mst.item_id%TYPE)
319: IS
320: SELECT qty, item_um
321: FROM

Line 489: CURSOR prod_cur(formula_id_p fm_form_mst.formula_id%TYPE) IS

485: tmp_qty_v NUMBER := 0;
486:
487: /* products are primary items per scaling routine */
488:
489: CURSOR prod_cur(formula_id_p fm_form_mst.formula_id%TYPE) IS
490: SELECT formulaline_id, item_id, qty, 0 as scaled_qty, scale_type, item_um
491: FROM fm_matl_dtl
492: WHERE formula_id = formula_id_p
493: AND line_type in (1,2)

Line 496: CURSOR ing_cur(formula_id_p fm_form_mst.formula_id%TYPE) IS

492: WHERE formula_id = formula_id_p
493: AND line_type in (1,2)
494: ORDER BY line_type;
495:
496: CURSOR ing_cur(formula_id_p fm_form_mst.formula_id%TYPE) IS
497: SELECT formulaline_id, item_id, qty, 0 as scaled_qty, scale_type, item_um
498: FROM fm_matl_dtl
499: WHERE formula_id = formula_id_p
500: AND line_type = -1;