DBA Data[Home] [Help]

PACKAGE: APPS.FEM_WEBADI_FACT_TAB_UTILS_PVT

Source


1 PACKAGE FEM_WEBADI_FACT_TAB_UTILS_PVT AS
2 /* $Header: FEMVADIFCTRUTILS.pls 120.1 2008/02/20 06:49:12 jcliving noship $ */
3 
4 PROCEDURE UPLOAD_FACTOR_TABLE1_INTERFACE(
5 P_RULE_NAME                        VARCHAR2,
6 P_FOLDER_NAME                      VARCHAR2,
7 P_RULE_DESCRIPTION                 VARCHAR2,
8 P_VERSION_NAME                     VARCHAR2,
9 P_START_DATE                       VARCHAR2,
10 P_END_DATE                         VARCHAR2,
11 P_VERSION_DESCRIPTION              VARCHAR2,
12 P_FACTOR_TYPE                      VARCHAR2,
13 P_MATCHING_DIM1                    VARCHAR2,
14 P_HIERARCHY1                       VARCHAR2,
15 P_HIER1_VER                        VARCHAR2,
16 P_LEVEL1                           VARCHAR2,
17 P_HIERARCHY_REL1                   VARCHAR2,
18 P_MATCHING_DIM2                    VARCHAR2,
19 P_HIERARCHY2                       VARCHAR2,
20 P_HIER2_VER                        VARCHAR2,
21 P_LEVEL2                           VARCHAR2,
22 P_HIERARCHY_REL2                   VARCHAR2,
23 P_MATCHING_DIM3                    VARCHAR2,
24 P_HIERARCHY3                       VARCHAR2,
25 P_HIER3_VER                        VARCHAR2,
26 P_LEVEL3                           VARCHAR2,
27 P_HIERARCHY_REL3                   VARCHAR2,
28 P_DISTRIBUTION_DIM                 VARCHAR2,
29 P_FORCE_TO_HUNDRED                 VARCHAR2,
30 P_OBJECT_ACCESS_CODE               VARCHAR2,
31 P_MATCHING_DIM1_MEM                VARCHAR2,
32 P_MATCHING_DIM2_MEM                VARCHAR2,
33 P_MATCHING_DIM3_MEM                VARCHAR2,
34 P_DISTRIBUTION_DIM_MEM             VARCHAR2,
35 P_AMOUNT                           VARCHAR2);
36 
37 PROCEDURE UPLOAD_FACTOR_TABLE2_INTERFACE(
38 P_RULE_NAME                        VARCHAR2,
39 P_FOLDER_NAME                      VARCHAR2,
40 P_RULE_DESCRIPTION                 VARCHAR2,
41 P_VERSION_NAME                     VARCHAR2,
42 P_START_DATE                       VARCHAR2,
43 P_END_DATE                         VARCHAR2,
44 P_VERSION_DESCRIPTION              VARCHAR2,
45 P_FACTOR_TYPE                      VARCHAR2,
46 P_MATCHING_DIM1                    VARCHAR2,
47 P_HIERARCHY1                       VARCHAR2,
48 P_HIER1_VER                        VARCHAR2,
49 P_LEVEL1                           VARCHAR2,
50 P_HIERARCHY_REL1                   VARCHAR2,
51 P_MATCHING_DIM2                    VARCHAR2,
52 P_HIERARCHY2                       VARCHAR2,
53 P_HIER2_VER                        VARCHAR2,
54 P_LEVEL2                           VARCHAR2,
55 P_HIERARCHY_REL2                   VARCHAR2,
56 P_MATCHING_DIM3                    VARCHAR2,
57 P_HIERARCHY3                       VARCHAR2,
58 P_HIER3_VER                        VARCHAR2,
59 P_LEVEL3                           VARCHAR2,
60 P_HIERARCHY_REL3                   VARCHAR2,
61 P_FORCE_TO_HUNDRED                 VARCHAR2,
62 P_OBJECT_ACCESS_CODE               VARCHAR2,
63 P_MATCHING_DIM1_MEM                VARCHAR2,
64 P_MATCHING_DIM2_MEM                VARCHAR2,
65 P_MATCHING_DIM3_MEM                VARCHAR2,
66 P_AMOUNT                           VARCHAR2);
67 
68 PROCEDURE UPLOAD_FACTOR_TABLE3_INTERFACE(
69 P_RULE_NAME                        VARCHAR2,
70 P_FOLDER_NAME                      VARCHAR2,
71 P_RULE_DESCRIPTION                 VARCHAR2,
72 P_VERSION_NAME                     VARCHAR2,
73 P_START_DATE                       VARCHAR2,
74 P_END_DATE                         VARCHAR2,
75 P_VERSION_DESCRIPTION              VARCHAR2,
76 P_FACTOR_TYPE                      VARCHAR2,
77 P_DISTRIBUTION_DIM                 VARCHAR2,
78 P_FORCE_TO_HUNDRED                 VARCHAR2,
79 P_OBJECT_ACCESS_CODE               VARCHAR2,
80 P_DISTRIBUTION_DIM_MEM             VARCHAR2,
81 P_AMOUNT                           VARCHAR2);
82 
83 PROCEDURE POPULATE_RULE_DETAILS(
84 P_RULE_NAME                        VARCHAR2,
85 P_FOLDER_NAME                      VARCHAR2,
86 P_RULE_DESCRIPTION                 VARCHAR2,
87 P_VERSION_NAME                     VARCHAR2,
88 P_START_DATE                       VARCHAR2,
89 P_END_DATE                         VARCHAR2,
90 P_VERSION_DESCRIPTION              VARCHAR2,
91 P_VS_COMBO_ID                      VARCHAR2,
92 P_OBJECT_ACCESS_CODE               VARCHAR2);
93 
94 PROCEDURE POPULATE_FACTOR_TABLE_DIMS(
95 P_VERSION_NAME                     VARCHAR2,
96 P_FACTOR_TYPE                      VARCHAR2,
97 P_MATCHING_DIM1                    VARCHAR2,
98 P_HIERARCHY1                       VARCHAR2,
99 P_HIER1_VER                        VARCHAR2,
100 P_LEVEL1                           VARCHAR2,
101 P_HIERARCHY_REL1                   VARCHAR2,
102 P_MATCHING_DIM2                    VARCHAR2,
103 P_HIERARCHY2                       VARCHAR2,
104 P_HIER2_VER                        VARCHAR2,
105 P_LEVEL2                           VARCHAR2,
106 P_HIERARCHY_REL2                   VARCHAR2,
107 P_MATCHING_DIM3                    VARCHAR2,
108 P_HIERARCHY3                       VARCHAR2,
109 P_HIER3_VER                        VARCHAR2,
110 P_LEVEL3                           VARCHAR2,
111 P_HIERARCHY_REL3                   VARCHAR2,
112 P_DISTRIBUTION_DIM                 VARCHAR2,
113 P_FORCE_TO_HUNDRED                 VARCHAR2);
114 
115 
116 END FEM_WEBADI_FACT_TAB_UTILS_PVT;
117