APPS.PMI_COST_ANALZ_PACK dependencies on IC_ITEM_MST

Line 5: item_id_vi IN ic_item_mst.item_id%TYPE,

1: PACKAGE BODY pmi_cost_analz_pack as
2: /* $Header: PMICTANB.pls 120.0 2005/05/24 16:58:01 appldev noship $ */
3:
4: FUNCTION gmca_get_cost(
5: item_id_vi IN ic_item_mst.item_id%TYPE,
6: inv_whse_code_vi IN cm_cmpt_dtl.whse_code%TYPE,
7: cost_mthd_code_vi IN cm_cmpt_dtl.cost_mthd_code%TYPE,
8: cost_date_vi IN DATE)
9: RETURN NUMBER

Line 38: item_id_v IN ic_item_mst.item_id%TYPE,

34: AND h.delete_mark = 0
35: AND d.delete_mark = 0;
36:
37: CURSOR get_cost_cur(
38: item_id_v IN ic_item_mst.item_id%TYPE,
39: cost_whse_code_v IN cm_cmpt_dtl.whse_code%TYPE,
40: calendar_code_v IN cm_cmpt_dtl.calendar_code%TYPE,
41: period_code_v IN cm_cmpt_dtl.period_code%TYPE,
42: cost_mthd_code_v IN cm_cmpt_dtl.cost_mthd_code%TYPE)

Line 271: primary_product_v ic_item_mst.item_id%TYPE := 0;

267: )
268: RETURN NUMBER
269: IS
270: /* Declare and Initialize variables */
271: primary_product_v ic_item_mst.item_id%TYPE := 0;
272: fm_qty_v fm_matl_dtl.qty%TYPE := 0;
273: fm_qty_um_v sy_uoms_mst.um_code%TYPE := ' ';
274: pm_qty_v gme_material_details.plan_qty%TYPE := 0;
275: pm_qty_um_v sy_uoms_mst.um_code%TYPE := ' ';

Line 318: item_id_p ic_item_mst.item_id%TYPE)

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
322: fm_matl_dtl

Line 437: FROM ic_item_mst

433: /* The fm_qty and pm_qty can be in different uoms. do uom conversion
434: to the item's primary uom */
435: /* get the prim product's uom */
436: SELECT item_um INTO pri_prod_um_v
437: FROM ic_item_mst
438: WHERE
439: item_id = primary_product_v;
440:
441: /* for now pass 0 as lot id (default lot?) */

Line 729: FROM ic_item_mst im

725: -- Get the primary UOM for the item
726: BEGIN
727: SELECT im.item_um
728: INTO prim_um_v
729: FROM ic_item_mst im
730: WHERE im.item_id = item_id_vi;
731:
732: to_qty_v := gmca_uomcv(item_id_vi, lot_id_vi,
733: from_uom_vi, from_qty_vi, prim_um_v);

Line 797: FROM sy_uoms_typ ut,sy_uoms_mst um, ic_item_mst im

793: INTO prim_um,
794: prim_um_type,
795: prim_std_um,
796: prim_stnd_factor
797: FROM sy_uoms_typ ut,sy_uoms_mst um, ic_item_mst im
798: WHERE im.item_id = item_id_vi
799: AND um.um_code = im.item_um
800: AND um.um_type = ut.um_type ;
801: EXCEPTION WHEN NO_DATA_FOUND THEN