APPS.PMI_COST_ANALZ_PACK dependencies on CM_CMPT_DTL

Line 6: inv_whse_code_vi IN cm_cmpt_dtl.whse_code%TYPE,

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
10: IS

Line 7: cost_mthd_code_vi IN cm_cmpt_dtl.cost_mthd_code%TYPE,

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
10: IS
11: cost_v NUMBER := 0;

Line 39: cost_whse_code_v IN cm_cmpt_dtl.whse_code%TYPE,

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)
43: IS

Line 40: calendar_code_v IN cm_cmpt_dtl.calendar_code%TYPE,

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)
43: IS
44: SELECT sum(cmpnt_cost)

Line 41: period_code_v IN cm_cmpt_dtl.period_code%TYPE,

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)
43: IS
44: SELECT sum(cmpnt_cost)
45: FROM cm_cmpt_dtl

Line 42: cost_mthd_code_v IN cm_cmpt_dtl.cost_mthd_code%TYPE)

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)
43: IS
44: SELECT sum(cmpnt_cost)
45: FROM cm_cmpt_dtl
46: WHERE

Line 45: FROM cm_cmpt_dtl

41: period_code_v IN cm_cmpt_dtl.period_code%TYPE,
42: cost_mthd_code_v IN cm_cmpt_dtl.cost_mthd_code%TYPE)
43: IS
44: SELECT sum(cmpnt_cost)
45: FROM cm_cmpt_dtl
46: WHERE
47: item_id = item_id_v
48: AND whse_code = cost_whse_code_v
49: AND calendar_code = calendar_code_v

Line 255: cost_mthd_vi IN cm_cmpt_dtl.cost_mthd_code%TYPE,

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,
258: line_type_vi IN gme_material_details.line_type%TYPE,
259: line_no_vi IN gme_material_details.line_no%TYPE,

Line 403: FROM cm_cmpt_dtl

399: AND d.delete_mark = 0;
400:
401: /* Now select the fmeff_id if available */
402: SELECT max(fmeff_id) INTO cost_fmeff_id_v
403: FROM cm_cmpt_dtl
404: WHERE item_id = primary_product_v
405: AND whse_code = cost_whse_v
406: AND calendar_code = cost_calendar_v
407: AND period_code = cost_period_v