APPS.PMI_SALES_PKG dependencies on CM_CMPT_DTL

Line 27: pv_pmisa_tp_cost_mthd cm_cmpt_dtl.cost_mthd_code%TYPE;

23: ################################################################################# */
24: /*Package Variable for Top N Products */
25:
26: Pv_pmisa_tp_Sales_orgn sy_orgn_mst.orgn_code%TYPE;
27: pv_pmisa_tp_cost_mthd cm_cmpt_dtl.cost_mthd_code%TYPE;
28: Pv_pmisa_tp_Prd_start_dt DATE;
29: Pv_pmisa_tp_Prd_end_dt DATE;
30: Pv_pmisa_tp_top_n number;
31:

Line 35: pv_pmisa_tp_cust_cost_mthd cm_cmpt_dtl.cost_mthd_code%TYPE;

31:
32: /*Package Variable for Top N customers */
33:
34: Pv_pmisa_tp_cust_Sales_orgn sy_orgn_mst.orgn_code%TYPE;
35: pv_pmisa_tp_cust_cost_mthd cm_cmpt_dtl.cost_mthd_code%TYPE;
36: Pv_pmisa_tp_cust_Prd_start_dt DATE;
37: Pv_pmisa_tp_cust_Prd_end_dt DATE;
38: Pv_pmisa_tp_cust_top_n number;
39:

Line 44: pv_pmisa_tp_om_cost_mthd cm_cmpt_dtl.cost_mthd_code%TYPE;

40:
41: /* Added new variable to support OMSO which are at OU Level for Top N Products */
42:
43: Pv_pmisa_tp_om_OU_ID hr_operating_units.ORGANIZATION_ID%TYPE;
44: pv_pmisa_tp_om_cost_mthd cm_cmpt_dtl.cost_mthd_code%TYPE;
45: Pv_pmisa_tp_om_Prd_start_dt DATE;
46: Pv_pmisa_tp_om_Prd_end_dt DATE;
47: Pv_pmisa_tp_om_top_n number;
48:

Line 52: pv_pmisa_tp_om_cust_cost_mthd cm_cmpt_dtl.cost_mthd_code%TYPE;

48:
49: /* Added new variable to support OMSO which are at OU Level for Top N Customers */
50:
51: Pv_pmisa_tp_om_cust_OU_ID hr_operating_units.ORGANIZATION_ID%TYPE;
52: pv_pmisa_tp_om_cust_cost_mthd cm_cmpt_dtl.cost_mthd_code%TYPE;
53: Pv_pmisa_tp_om_cust_Prd_st_dt DATE;
54: Pv_pmisa_tp_om_cust_Prd_end_dt DATE;
55: Pv_pmisa_tp_om_cust_top_n number;
56:

Line 74: P_cost_mthd IN cm_cmpt_dtl.cost_mthd_code%TYPE,

70: pv_pmisa_top_n_item_by_ou pv_pmisa_top_n_item_type;
71:
72:
73: FUNCTION PMISA_GET_TOP_N(P_Sales_orgn IN sy_orgn_mst.orgn_code%TYPE,
74: P_cost_mthd IN cm_cmpt_dtl.cost_mthd_code%TYPE,
75: P_Prd_start_date IN DATE,
76: P_Prd_end_date IN DATE,
77: P_item_id IN ic_item_mst.item_id%TYPE DEFAULT NULL,
78: P_customer_id IN op_ordr_hdr.billcust_id%TYPE DEFAULT NULL,

Line 85: p_cost_mthd IN cm_cmpt_dtl.cost_mthd_code%TYPE,

81: RETURN NUMBER;
82:
83:
84: FUNCTION PMISA_GET_TOP_N_BY_OU(p_OU_ID IN hr_operating_units.ORGANIZATION_ID%TYPE,
85: p_cost_mthd IN cm_cmpt_dtl.cost_mthd_code%TYPE,
86: p_Prd_start_date IN DATE,
87: p_Prd_end_date IN DATE,
88: p_item_id IN ic_item_mst.item_id%TYPE DEFAULT NULL,
89: P_customer_id IN hz_parties.PARTY_ID%TYPE DEFAULT NULL,