APPS.PMI_COST_ANALZ_PACK dependencies on GME_MATERIAL_DETAILS

Line 8: Pkg_var_pm_qty_v gme_material_details.plan_qty%TYPE := 0;

4: Pkg_var_Scale_factor_v NUMBER;
5: Pkg_var_b NUMBER;
6: Pkg_var_fm_qty_v fm_matl_dtl.qty%TYPE := 0;
7: Pkg_var_fm_qty_um_v sy_uoms_mst.um_code%TYPE := ' ';
8: Pkg_var_pm_qty_v gme_material_details.plan_qty%TYPE := 0;
9: pkg_var_pm_qty_um_v sy_uoms_mst.um_code%TYPE := ' ';
10: Pkg_var_all_linear boolean;
11:
12:

Line 39: batch_line_id_vi IN gme_material_details.material_detail_id%TYPE,

35:
36: FUNCTION gmca_variance(
37: batch_id_vi IN gme_batch_header.batch_id%TYPE,
38: formula_id_vi IN fm_form_mst.formula_id%TYPE,
39: batch_line_id_vi IN gme_material_details.material_detail_id%TYPE,
40: cost_mthd_vi IN cm_cmpt_dtl.cost_mthd_code%TYPE,
41: plan_qty_vi IN gme_material_details.plan_qty%TYPE,
42: item_um_vi IN gme_material_details.item_um%TYPE,
43: line_type_vi IN gme_material_details.line_type%TYPE,

Line 41: plan_qty_vi IN gme_material_details.plan_qty%TYPE,

37: batch_id_vi IN gme_batch_header.batch_id%TYPE,
38: formula_id_vi IN fm_form_mst.formula_id%TYPE,
39: batch_line_id_vi IN gme_material_details.material_detail_id%TYPE,
40: cost_mthd_vi IN cm_cmpt_dtl.cost_mthd_code%TYPE,
41: plan_qty_vi IN gme_material_details.plan_qty%TYPE,
42: item_um_vi IN gme_material_details.item_um%TYPE,
43: line_type_vi IN gme_material_details.line_type%TYPE,
44: line_no_vi IN gme_material_details.line_no%TYPE,
45: batch_status_vi IN gme_batch_header.batch_status%TYPE,

Line 42: item_um_vi IN gme_material_details.item_um%TYPE,

38: formula_id_vi IN fm_form_mst.formula_id%TYPE,
39: batch_line_id_vi IN gme_material_details.material_detail_id%TYPE,
40: cost_mthd_vi IN cm_cmpt_dtl.cost_mthd_code%TYPE,
41: plan_qty_vi IN gme_material_details.plan_qty%TYPE,
42: item_um_vi IN gme_material_details.item_um%TYPE,
43: line_type_vi IN gme_material_details.line_type%TYPE,
44: line_no_vi IN gme_material_details.line_no%TYPE,
45: batch_status_vi IN gme_batch_header.batch_status%TYPE,
46: actual_cmplt_date_vi IN gme_batch_header.actual_cmplt_date%TYPE,

Line 43: line_type_vi IN gme_material_details.line_type%TYPE,

39: batch_line_id_vi IN gme_material_details.material_detail_id%TYPE,
40: cost_mthd_vi IN cm_cmpt_dtl.cost_mthd_code%TYPE,
41: plan_qty_vi IN gme_material_details.plan_qty%TYPE,
42: item_um_vi IN gme_material_details.item_um%TYPE,
43: line_type_vi IN gme_material_details.line_type%TYPE,
44: line_no_vi IN gme_material_details.line_no%TYPE,
45: batch_status_vi IN gme_batch_header.batch_status%TYPE,
46: actual_cmplt_date_vi IN gme_batch_header.actual_cmplt_date%TYPE,
47: batch_close_date_vi IN gme_batch_header.batch_close_date%TYPE,

Line 44: line_no_vi IN gme_material_details.line_no%TYPE,

40: cost_mthd_vi IN cm_cmpt_dtl.cost_mthd_code%TYPE,
41: plan_qty_vi IN gme_material_details.plan_qty%TYPE,
42: item_um_vi IN gme_material_details.item_um%TYPE,
43: line_type_vi IN gme_material_details.line_type%TYPE,
44: line_no_vi IN gme_material_details.line_no%TYPE,
45: batch_status_vi IN gme_batch_header.batch_status%TYPE,
46: actual_cmplt_date_vi IN gme_batch_header.actual_cmplt_date%TYPE,
47: batch_close_date_vi IN gme_batch_header.batch_close_date%TYPE,
48: wip_whse_code_vi IN gme_batch_header.wip_whse_code%TYPE,

Line 49: item_id_vi IN gme_material_details.item_id%TYPE,

45: batch_status_vi IN gme_batch_header.batch_status%TYPE,
46: actual_cmplt_date_vi IN gme_batch_header.actual_cmplt_date%TYPE,
47: batch_close_date_vi IN gme_batch_header.batch_close_date%TYPE,
48: wip_whse_code_vi IN gme_batch_header.wip_whse_code%TYPE,
49: item_id_vi IN gme_material_details.item_id%TYPE,
50: formulaline_id_vi IN gme_material_details.formulaline_id%TYPE,
51: actual_qty_vi IN gme_material_details.actual_qty%TYPE)
52: RETURN NUMBER;
53:

Line 50: formulaline_id_vi IN gme_material_details.formulaline_id%TYPE,

46: actual_cmplt_date_vi IN gme_batch_header.actual_cmplt_date%TYPE,
47: batch_close_date_vi IN gme_batch_header.batch_close_date%TYPE,
48: wip_whse_code_vi IN gme_batch_header.wip_whse_code%TYPE,
49: item_id_vi IN gme_material_details.item_id%TYPE,
50: formulaline_id_vi IN gme_material_details.formulaline_id%TYPE,
51: actual_qty_vi IN gme_material_details.actual_qty%TYPE)
52: RETURN NUMBER;
53:
54:

Line 51: actual_qty_vi IN gme_material_details.actual_qty%TYPE)

47: batch_close_date_vi IN gme_batch_header.batch_close_date%TYPE,
48: wip_whse_code_vi IN gme_batch_header.wip_whse_code%TYPE,
49: item_id_vi IN gme_material_details.item_id%TYPE,
50: formulaline_id_vi IN gme_material_details.formulaline_id%TYPE,
51: actual_qty_vi IN gme_material_details.actual_qty%TYPE)
52: RETURN NUMBER;
53:
54:
55: FUNCTION gmca_get_onhandqty(p_whse_code IN ic_loct_inv.whse_code%TYPE,