[Home] [Help]
PACKAGE: APPS.FEM_WEBADI_FEM_BAL_UTILS_PVT
Source
1 PACKAGE FEM_WEBADI_FEM_BAL_UTILS_PVT AS
2 /* $Header: FEMVADIBALUTILS.pls 120.1 2008/02/20 06:47:33 jcliving noship $ */
3
4 PROCEDURE UPLOAD_FEM_BALANCES_INTERFACE(
5
6 P_DATA_TABLE_NAME VARCHAR2,
7 P_LOAD_METHOD_CODE VARCHAR2,
8 P_BAL_POST_TYPE_CODE VARCHAR2,
9 P_DATASET_CODE NUMBER,
10 P_CAL_PERIOD_ID VARCHAR2,
11 P_CCTR_ORG_DISPLAY_CODE VARCHAR2 DEFAULT NULL,
12 P_CURRENCY_CODE VARCHAR2,
13 P_CURRENCY_TYPE_CODE VARCHAR2,
14 P_SOURCE_SYSTEM_DISPLAY_CODE VARCHAR2,
15 P_LEDGER_DISPLAY_CODE VARCHAR2,
16 P_BUDGET_DISPLAY_CODE VARCHAR2 DEFAULT NULL,
17 P_ENCUMBRANCE_TYPE_CODE VARCHAR2 DEFAULT NULL,
18 P_FINANCIAL_ELEM_DISPLAY_CODE VARCHAR2 DEFAULT NULL,
19 P_PRODUCT_DISPLAY_CODE VARCHAR2 DEFAULT NULL,
20 P_NATURAL_ACCOUNT_DISPLAY_CODE VARCHAR2 DEFAULT NULL,
21 P_CHANNEL_DISPLAY_CODE VARCHAR2 DEFAULT NULL,
22 P_LINE_ITEM_DISPLAY_CODE VARCHAR2 DEFAULT NULL,
23 P_PROJECT_DISPLAY_CODE VARCHAR2 DEFAULT NULL,
24 P_CUSTOMER_DISPLAY_CODE VARCHAR2 DEFAULT NULL,
25 P_ENTITY_DISPLAY_CODE VARCHAR2 DEFAULT NULL,
26 P_INTERCOMPANY_DISPLAY_CODE VARCHAR2 DEFAULT NULL,
27 P_TASK_DISPLAY_CODE VARCHAR2 DEFAULT NULL,
28 P_USER_DIM1_DISPLAY_CODE VARCHAR2 DEFAULT NULL,
29 P_USER_DIM2_DISPLAY_CODE VARCHAR2 DEFAULT NULL,
30 P_USER_DIM3_DISPLAY_CODE VARCHAR2 DEFAULT NULL,
31 P_USER_DIM4_DISPLAY_CODE VARCHAR2 DEFAULT NULL,
32 P_USER_DIM5_DISPLAY_CODE VARCHAR2 DEFAULT NULL,
33 P_USER_DIM6_DISPLAY_CODE VARCHAR2 DEFAULT NULL,
34 P_USER_DIM7_DISPLAY_CODE VARCHAR2 DEFAULT NULL,
35 P_USER_DIM8_DISPLAY_CODE VARCHAR2 DEFAULT NULL,
36 P_USER_DIM9_DISPLAY_CODE VARCHAR2 DEFAULT NULL,
37 P_USER_DIM10_DISPLAY_CODE VARCHAR2 DEFAULT NULL,
38 P_XTD_BALANCE_E NUMBER DEFAULT NULL,
39 P_XTD_BALANCE_F NUMBER DEFAULT NULL,
40 P_YTD_BALANCE_E NUMBER DEFAULT NULL,
41 P_YTD_BALANCE_F NUMBER DEFAULT NULL,
42 P_QTD_BALANCE_E NUMBER DEFAULT NULL,
43 P_QTD_BALANCE_F NUMBER DEFAULT NULL,
44 P_PTD_DEBIT_BALANCE_E NUMBER DEFAULT NULL,
45 P_PTD_CREDIT_BALANCE_E NUMBER DEFAULT NULL,
46 P_YTD_DEBIT_BALANCE_E NUMBER DEFAULT NULL,
47 P_YTD_CREDIT_BALANCE_E NUMBER DEFAULT NULL,
48 P_ATTR1 VARCHAR2 DEFAULT NULL,
49 P_ATTR2 VARCHAR2 DEFAULT NULL);
50
51 FUNCTION GET_BUDGET_ID(P_BUDGET_DISPLAY_CODE VARCHAR2) RETURN NUMBER;
52
53 FUNCTION GET_ENC_TYPE_ID(P_ENC_TYPE_CODE VARCHAR2) RETURN NUMBER;
54
55 PROCEDURE SET_ALL_REQD_COLS(X_ERROR_FLAG OUT NOCOPY VARCHAR2);
56
57 END FEM_WEBADI_FEM_BAL_UTILS_PVT;
58