1 PACKAGE inv_wwacst AUTHID CURRENT_USER AS
2 /* $Header: INVWWACS.pls 115.5 2002/12/01 01:44:41 rbande ship $ */
3
4
5 Procedure get_cost_group_ids(
6 p_TRX_ACTION_ID IN NUMBER,
7 p_TRX_SOURCE_TYPE_ID IN NUMBER,
8 p_TRX_TYPE_ID IN NUMBER,
9 p_FM_ORG_COST_MTD IN NUMBER,
10 p_TO_ORG_COST_MTD IN NUMBER,
11 p_FM_ORG_ID IN NUMBER,
12 p_TO_ORG_ID IN NUMBER,
13 p_FM_PROJECT_ID IN NUMBER,
14 p_TO_PROJECT_ID IN NUMBER,
15 p_SOURCE_PROJECT_ID IN NUMBER,
16 p_TRX_ID IN NUMBER,
17 p_ITEM_ID IN NUMBER,
18 p_TRX_SRC_ID IN NUMBER,
19 p_FM_ORG_PRJ_ENABLED IN NUMBER,
20 p_TO_ORG_PRJ_ENABLED IN NUMBER,
21 x_COST_GROUP_ID IN OUT NOCOPY NUMBER,
22 x_XFR_COST_GROUP_ID IN OUT NOCOPY NUMBER,
23 x_PRJ_CST_COLLECTED OUT NOCOPY VARCHAR2,
24 x_XPRJ_CST_COLLECTED OUT NOCOPY VARCHAR2,
25 x_CATEGORY_ID OUT NOCOPY NUMBER,
26 x_ERR_MESG OUT NOCOPY VARCHAR2) ;
27
28
29 Procedure populate_cost_details(
30 V_TRANSACTION_ID IN NUMBER,
31 V_ORG_ID IN NUMBER,
32 V_ITEM_ID IN NUMBER,
33 V_TXN_COST IN NUMBER,
34 V_NEW_AVG_COST IN NUMBER,
35 V_PER_CHANGE IN NUMBER,
36 V_VAL_CHANGE IN NUMBER,
37 V_MAT_ACCNT IN NUMBER,
38 V_MAT_OVHD_ACCNT IN NUMBER,
39 V_RES_ACCNT IN NUMBER,
40 V_OSP_ACCNT IN NUMBER,
41 V_OVHD_ACCNT IN NUMBER,
42 V_USER_ID IN NUMBER,
43 V_LOGIN_ID IN NUMBER,
44 V_REQUEST_ID IN NUMBER,
45 V_PROG_APPL_ID IN NUMBER,
46 V_PROG_ID IN NUMBER,
47 V_ERR_NUM OUT NOCOPY NUMBER,
48 V_ERR_CODE OUT NOCOPY VARCHAR2,
49 V_ERR_MESG OUT NOCOPY VARCHAR2,
50 V_TXN_SRC_TYPE_ID IN NUMBER,
51 V_TXN_ACTION_ID IN NUMBER,
52 V_COST_GROUP_ID IN NUMBER) ;
53
54 Procedure call_prj_loc_validation(
55 V_LOCID IN NUMBER,
56 V_ORGID IN NUMBER,
57 V_MODE IN VARCHAR2,
58 V_REQD_FLAG IN VARCHAR2,
59 V_PROJECT_ID IN NUMBER,
60 V_TASK_ID IN NUMBER,
61 V_RESULT OUT NOCOPY NUMBER,
62 V_ERROR_MESG OUT NOCOPY VARCHAR2);
63
64
65 END inv_wwacst;