DBA Data[Home] [Help]

APPS.OPI_OPM_COMMON_PKG dependencies on IC_WHSE_MST

Line 5: p_Whse_code IN ic_whse_mst.whse_code%TYPE,

1: PACKAGE BODY opi_opm_common_pkg as
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

Line 11: CURSOR cur_whse_orgn_code(l_whse_code IN ic_whse_mst.whse_code%TYPE)

7: p_Transaction_date IN DATE)
8: RETURN NUMBER
9: IS
10: /* Cursor to get Organization code for the Warehouse passed */
11: CURSOR cur_whse_orgn_code(l_whse_code IN ic_whse_mst.whse_code%TYPE)
12: IS
13: SELECT orgn_code
14: FROM ic_whse_mst
15: WHERE whse_code = l_whse_code;

Line 14: FROM ic_whse_mst

10: /* Cursor to get Organization code for the Warehouse passed */
11: CURSOR cur_whse_orgn_code(l_whse_code IN ic_whse_mst.whse_code%TYPE)
12: IS
13: SELECT orgn_code
14: FROM ic_whse_mst
15: WHERE whse_code = l_whse_code;
16: CURSOR CUR_COST_MTHD(l_whse_code IN ic_whse_mst.whse_code%TYPE)
17: IS
18: SELECT b.orgn_code,c.GL_COST_MTHD

Line 16: CURSOR CUR_COST_MTHD(l_whse_code IN ic_whse_mst.whse_code%TYPE)

12: IS
13: SELECT orgn_code
14: FROM ic_whse_mst
15: WHERE whse_code = l_whse_code;
16: CURSOR CUR_COST_MTHD(l_whse_code IN ic_whse_mst.whse_code%TYPE)
17: IS
18: SELECT b.orgn_code,c.GL_COST_MTHD
19: FROM ic_whse_mst a, sy_orgn_mst b, GL_PLCY_MST c
20: WHERE a.whse_code = l_whse_code

Line 19: FROM ic_whse_mst a, sy_orgn_mst b, GL_PLCY_MST c

15: WHERE whse_code = l_whse_code;
16: CURSOR CUR_COST_MTHD(l_whse_code IN ic_whse_mst.whse_code%TYPE)
17: IS
18: SELECT b.orgn_code,c.GL_COST_MTHD
19: FROM ic_whse_mst a, sy_orgn_mst b, GL_PLCY_MST c
20: WHERE a.whse_code = l_whse_code
21: AND a.orgn_code = b.orgn_code
22: AND b.co_code = c.co_code;
23:

Line 25: l_whse_code ic_whse_mst.whse_code%TYPE;

21: AND a.orgn_code = b.orgn_code
22: AND b.co_code = c.co_code;
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;