1 package Fnd_Product_Initialization_Pkg as
2 /* $Header: AFPINITS.pls 120.8 2006/09/28 19:09:06 rsheh ship $ */
3 /*#
4 * Table Handler to insert or update data in FND_PRODUCT_INITIALIZATION table.
5 * @rep:scope public
6 * @rep:product FND
7 * @rep:displayname Product Initialization
8 * @rep:lifecycle active
9 * @rep:compatibility S
10 * @rep:category BUSINESS_ENTITY FND_PRODUCT_INITIALIZATION
11 * @rep:ihelp FND/@o_funcsec#o_funcsec See the related online help
12 */
13
14
15
16 init_conditions varchar2(80) := '';
17 type TextArrayTyp is table of varchar2(80) index by binary_integer;
18 ExecInitSuccess number := 1;
19 ExecInitFailure number := 0;
20
21 --
22 -- Register (PUBLIC)
23 -- Called by product team to register their re-initialization function
24 -- and invoking sequence
25 -- Input
26 -- x_apps_name: application short name
27 -- x_invoke_seq: invoking sequence
28 -- x_init_function: re-initialization function
29 procedure Register(x_apps_name in varchar2,
30 x_init_function in varchar2 default null,
31 x_owner in varchar2 default 'SEED');
32 --
33 -- Remove (PUBLIC)
34 -- Called by product team to delete their re-initialization function
35 -- Input
36 -- x_apps_name: application short name
37 -- x_init_function: re-initialization function
38 procedure Remove(x_apps_name in varchar2);
39
40 -- AddInitCondition (PUBLIC)
41 -- Called by anybody who wants to register their product's re-initialization
42 -- conditions.
43 --
44 -- Input
45 -- x_apps_name: the application short name
46 -- x_condition: one of the following conditions:
47 -- 'APPL', 'RESP', 'USER', 'NLS', 'ORG'
48 --
49 procedure AddInitCondition(x_apps_name in varchar2,
50 x_condition in varchar2,
51 x_owner in varchar2);
52
53 -- RemoveInitCondition (PUBLIC)
54 -- Called by anybody who wants to remove their product's re-initialization
55 -- conditions.
56 --
57 -- Input
58 -- x_apps_name: the application short name
59 -- x_condition: one of the following conditions:
60 -- 'APPL', 'RESP', 'USER', 'NLS', 'ORG'
61 --
62 procedure RemoveInitCondition(x_apps_name in varchar2,
63 x_condition in varchar2);
64
65 --
66 -- AddDependency (PUBLIC)
67 -- Called by anybody who wants to register their product dependency
68 --
69 -- Input
70 -- x_apps_name: the application short name
71 -- x_dependency: the dependency application short name
72 --
73 procedure AddDependency(x_apps_name in varchar2,
74 x_dependency in varchar2,
75 x_owner in varchar2);
76
77 --
78 -- RemoveDependency (PUBLIC)
79 -- Called by anybody who wants to remove their product dependency
80 --
81 -- Input
82 -- x_apps_name: the application short name
83 -- x_dependency: the dependency application short name
84 --
85 procedure RemoveDependency(x_apps_name in varchar2,
86 x_dependency in varchar2);
87
88 --
89 -- ExecInitFunction (PUBLIC)
90 -- Called by fnd_global.initialize() which decides the current application
91 -- short name and the conditions occurred.
92 --
93 -- Input
94 -- x_apps_name: the application short name
95 -- x_conditions: it is assumed in the format of ('APPL', 'USER')
96 --
97 -- Note:
98 -- WE HAVE TO HAVE GOOD ERROR HANDLING HERE BECAUSE IT IS CALLED BY
99 -- BY GLOBAL.INITIALIZE()
100 procedure ExecInitFunction(x_apps_name in varchar2,
101 x_conditions in varchar2);
102
103
104 procedure Test(x_apps_name in varchar2);
105
106 --
107 -- Register (PUBLIC) - Overloaded
108 -- Called by product team to register their re-initialization function
109 -- and invoking sequence
110 -- Input
111 -- x_apps_name: application short name
112 -- x_invoke_seq: invoking sequence
113 -- x_init_function: re-initialization function
114 procedure Register(x_apps_name in varchar2,
115 x_init_function in varchar2 default null,
116 x_owner in varchar2 default 'SEED',
117 x_last_update_date in varchar2,
118 x_custom_mode in varchar2);
119 --
120 --
121 --
122 -- AddDependency (PUBLIC) - Overloaded
123 -- Called by anybody who wants to register their product dependency
124 --
125 -- Input
126 -- x_apps_name: the application short name
127 -- x_dependency: the dependency application short name
128 --
129 procedure AddDependency(x_apps_name in varchar2,
130 x_dependency in varchar2,
131 x_owner in varchar2,
132 x_last_update_date in varchar2,
133 x_custom_mode in varchar2);
134
135 -- AddInitCondition (PUBLIC) - Overloaded
136 -- Called by anybody who wants to register their product's re-initialization
137 -- conditions.
138 --
139 -- Input
140 -- x_apps_name: the application short name
141 -- x_condition: one of the following conditions:
142 -- 'APPL', 'RESP', 'USER', 'NLS', 'ORG'
143 --
144 procedure AddInitCondition(x_apps_name in varchar2,
145 x_condition in varchar2,
146 x_owner in varchar2,
147 x_last_update_date in varchar2,
148 x_custom_mode in varchar2);
149
150 -- DiscoInit (PUBLIC)
151 -- Called by Disco trigger to run all product initialization code inside
152 -- fnd_product_initialization table with all true conditions.
153 --
154 -- Input
155 -- no input argument
156 --
157 -- Output
158 -- ExecInitSuccess or ExecInitFailure
159 /*#
160 * This is called by Discoverer to run all left over product initialization
161 * inside fnd_product_initialization table with all true conditions.
162 * Please note that even this is public procedure, it does not mean for
163 * other public usage. This is mainly for Discoverer to use.
164 * @return success(1) or failure(0)
165 * @rep:scope public
166 * @rep:lifecycle active
167 * @rep:displayname Discoverer Initialization
168 * @rep:compatibility S
169 * @rep:ihelp FND/@mesgdict#mesgdict See the related online help
170 */
171
172 function DiscoInit return number;
173
174 -- RemoveAll (PUBLIC)
175 -- Called by anybody who wants to remove all their product initialization
176 -- data.
177 --
178 -- Input
179 -- x_apps_short_name: the application short name
180 --
181 procedure RemoveAll(apps_short_name in varchar2);
182
183
184 end Fnd_Product_Initialization_Pkg;