APPS.OPI_OPM_COMMON_PKG dependencies on CM_CMPT_DTL

Line 6: p_Cost_mthd IN cm_cmpt_dtl.cost_mthd_code%TYPE DEFAULT NULL,

2: /* $Header: OPICOMMB.pls 115.4 2002/05/07 13:28:59 pkm ship $ */
3:
4: FUNCTION OPMCO_GET_COST( p_Item_id IN ic_item_mst.item_id%TYPE,
5: p_Whse_code IN ic_whse_mst.whse_code%TYPE,
6: p_Cost_mthd IN cm_cmpt_dtl.cost_mthd_code%TYPE DEFAULT NULL,
7: p_Transaction_date IN DATE)
8: RETURN NUMBER
9: IS
10: /* Cursor to get Organization code for the Warehouse passed */

Line 27: l_cmpntcls_ind CM_CMPT_DTL.COST_CMPNTCLS_ID%TYPE;

23:
24: /* Local Variable Declaration */
25: l_whse_code ic_whse_mst.whse_code%TYPE;
26: l_orgn_code sy_orgn_mst.orgn_code%TYPE;
27: l_cmpntcls_ind CM_CMPT_DTL.COST_CMPNTCLS_ID%TYPE;
28: l_analysis_code CM_CMPT_DTL.COST_ANALYSIS_CODE%TYPE;
29: l_total_cost NUMBER;
30: l_no_of_rows NUMBER;
31: l_cost_mthd cm_cmpt_dtl.cost_mthd_code%TYPE;

Line 28: l_analysis_code CM_CMPT_DTL.COST_ANALYSIS_CODE%TYPE;

24: /* Local Variable Declaration */
25: l_whse_code ic_whse_mst.whse_code%TYPE;
26: l_orgn_code sy_orgn_mst.orgn_code%TYPE;
27: l_cmpntcls_ind CM_CMPT_DTL.COST_CMPNTCLS_ID%TYPE;
28: l_analysis_code CM_CMPT_DTL.COST_ANALYSIS_CODE%TYPE;
29: l_total_cost NUMBER;
30: l_no_of_rows NUMBER;
31: l_cost_mthd cm_cmpt_dtl.cost_mthd_code%TYPE;
32:

Line 31: l_cost_mthd cm_cmpt_dtl.cost_mthd_code%TYPE;

27: l_cmpntcls_ind CM_CMPT_DTL.COST_CMPNTCLS_ID%TYPE;
28: l_analysis_code CM_CMPT_DTL.COST_ANALYSIS_CODE%TYPE;
29: l_total_cost NUMBER;
30: l_no_of_rows NUMBER;
31: l_cost_mthd cm_cmpt_dtl.cost_mthd_code%TYPE;
32:
33: BEGIN
34: IF p_cost_mthd IS NOT NULL THEN
35: OPEN cur_whse_orgn_code(p_Whse_code);

Line 222: l_cost_mthd cm_cmpt_dtl.cost_mthd_code%TYPE;

218: AND b.co_code = c.co_code;
219:
220: /* Local Variable Declaration */
221: l_orgn_code sy_orgn_mst.orgn_code%TYPE;
222: l_cost_mthd cm_cmpt_dtl.cost_mthd_code%TYPE;
223: l_co_code sy_orgn_mst.orgn_code%TYPE;
224: l_calendar_code cm_rsrc_dtl.CALENDAR_CODE%TYPE;
225: l_period_code cm_rsrc_dtl.PERIOD_CODE%TYPE;
226: l_rsrc_cost NUMBER;