DBA Data[Home] [Help]

APPS.PMI_COMMON_PKG dependencies on CM_CMPT_DTL

Line 6: p_Cost_mthd IN cm_cmpt_dtl.cost_mthd_code%TYPE,

2: /* $Header: PMICOMMB.pls 120.0 2005/05/24 16:54:43 appldev noship $ */
3:
4: FUNCTION PMICO_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,
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);