APPS.PMI_SALES_PKG dependencies on CM_CMPT_DTL

Line 7: p_cost_mthd IN cm_cmpt_dtl.cost_mthd_code%TYPE,

3:
4: /* Added New function SKARIMIS 12/28/1999 */
5:
6: FUNCTION PMISA_GET_TOP_N(p_Sales_orgn IN sy_orgn_mst.orgn_code%TYPE,
7: p_cost_mthd IN cm_cmpt_dtl.cost_mthd_code%TYPE,
8: p_Prd_start_date IN DATE,
9: p_Prd_end_date IN DATE,
10: p_item_id IN ic_item_mst.item_id%TYPE DEFAULT NULL,
11: P_customer_id IN op_ordr_hdr.billcust_id%TYPE DEFAULT NULL,

Line 19: p_cost_mthd IN cm_cmpt_dtl.cost_mthd_code%TYPE,

15: IS
16: /* cursor to Fetch Top products with respect to margin */
17:
18: Cursor cur_item ( p_Sales_orgn IN sy_orgn_mst.orgn_code%TYPE,
19: p_cost_mthd IN cm_cmpt_dtl.cost_mthd_code%TYPE,
20: p_Prd_start_date IN DATE,
21: p_Prd_end_date IN DATE
22: )
23: IS

Line 49: p_cost_mthd IN cm_cmpt_dtl.cost_mthd_code%TYPE,

45: GROUP BY orderhdr.orgn_code,orderdetail.item_id
46: ORDER BY Margin desc;
47: /* Cursor to get Top N customers with respect to Margin */
48: Cursor cur_customer ( p_Sales_orgn IN sy_orgn_mst.orgn_code%TYPE,
49: p_cost_mthd IN cm_cmpt_dtl.cost_mthd_code%TYPE,
50: p_Prd_start_date IN DATE,
51: p_Prd_end_date IN DATE
52: )
53: IS

Line 184: p_cost_mthd IN cm_cmpt_dtl.cost_mthd_code%TYPE,

180: END IF;
181: END PMISA_GET_TOP_N;
182:
183: FUNCTION PMISA_GET_TOP_N_BY_OU(p_OU_ID IN hr_operating_units.ORGANIZATION_ID%TYPE,
184: p_cost_mthd IN cm_cmpt_dtl.cost_mthd_code%TYPE,
185: p_Prd_start_date IN DATE,
186: p_Prd_end_date IN DATE,
187: p_item_id IN ic_item_mst.item_id%TYPE DEFAULT NULL,
188: P_customer_id IN hz_parties.PARTY_ID%TYPE DEFAULT NULL,

Line 196: p_cost_mthd IN cm_cmpt_dtl.cost_mthd_code%TYPE,

192: IS
193: /* cursor to Fetch Top products with respect to margin */
194:
195: Cursor cur_item ( p_OU_ID IN hr_operating_units.ORGANIZATION_ID%TYPE,
196: p_cost_mthd IN cm_cmpt_dtl.cost_mthd_code%TYPE,
197: p_Prd_start_date IN DATE,
198: p_Prd_end_date IN DATE
199: )
200: IS

Line 282: p_cost_mthd IN cm_cmpt_dtl.cost_mthd_code%TYPE,

278: ORDER BY Margin desc;
279:
280: /* Cursor to get Top N customers with respect to Margin */
281: Cursor cur_customer ( p_OU_ID IN hr_operating_units.ORGANIZATION_ID%TYPE,
282: p_cost_mthd IN cm_cmpt_dtl.cost_mthd_code%TYPE,
283: p_Prd_start_date IN DATE,
284: p_Prd_end_date IN DATE
285: )
286: IS