37:
38:
39: PROCEDURE Evaluation_Update_Handler(
40: p_api_version_number IN NUMBER := 1.0,
41: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
42: p_commit IN VARCHAR2 := FND_API.g_false,
43: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
44: p_opinion_log_id IN NUMBER,
45: x_return_status OUT nocopy VARCHAR2,
38:
39: PROCEDURE Evaluation_Update_Handler(
40: p_api_version_number IN NUMBER := 1.0,
41: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
42: p_commit IN VARCHAR2 := FND_API.g_false,
43: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
44: p_opinion_log_id IN NUMBER,
45: x_return_status OUT nocopy VARCHAR2,
46: x_msg_count OUT nocopy NUMBER,
39: PROCEDURE Evaluation_Update_Handler(
40: p_api_version_number IN NUMBER := 1.0,
41: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
42: p_commit IN VARCHAR2 := FND_API.g_false,
43: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
44: p_opinion_log_id IN NUMBER,
45: x_return_status OUT nocopy VARCHAR2,
46: x_msg_count OUT nocopy NUMBER,
47: x_msg_data OUT nocopy VARCHAR2
48: );
49:
50: PROCEDURE Certification_Update_Handler(
51: p_api_version_number IN NUMBER := 1.0,
52: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
53: p_commit IN VARCHAR2 := FND_API.g_false,
54: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
55: p_opinion_log_id IN NUMBER,
56: x_return_status OUT nocopy VARCHAR2,
49:
50: PROCEDURE Certification_Update_Handler(
51: p_api_version_number IN NUMBER := 1.0,
52: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
53: p_commit IN VARCHAR2 := FND_API.g_false,
54: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
55: p_opinion_log_id IN NUMBER,
56: x_return_status OUT nocopy VARCHAR2,
57: x_msg_count OUT nocopy NUMBER,
50: PROCEDURE Certification_Update_Handler(
51: p_api_version_number IN NUMBER := 1.0,
52: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
53: p_commit IN VARCHAR2 := FND_API.g_false,
54: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
55: p_opinion_log_id IN NUMBER,
56: x_return_status OUT nocopy VARCHAR2,
57: x_msg_count OUT nocopy NUMBER,
58: x_msg_data OUT nocopy VARCHAR2
64: ) return VARCHAR2;
65:
66: PROCEDURE Master_Fin_Proc_Eval_Sum(
67: p_api_version_number IN NUMBER := 1.0,
68: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
69: p_commit IN VARCHAR2 := FND_API.g_false,
70: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
71: p_certification_id IN NUMBER,
72: p_start_date IN DATE := null,
65:
66: PROCEDURE Master_Fin_Proc_Eval_Sum(
67: p_api_version_number IN NUMBER := 1.0,
68: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
69: p_commit IN VARCHAR2 := FND_API.g_false,
70: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
71: p_certification_id IN NUMBER,
72: p_start_date IN DATE := null,
73: p_mode IN VARCHAR2 := 'NEW',
66: PROCEDURE Master_Fin_Proc_Eval_Sum(
67: p_api_version_number IN NUMBER := 1.0,
68: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
69: p_commit IN VARCHAR2 := FND_API.g_false,
70: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
71: p_certification_id IN NUMBER,
72: p_start_date IN DATE := null,
73: p_mode IN VARCHAR2 := 'NEW',
74: x_return_status OUT nocopy VARCHAR2,
77: );
78:
79: PROCEDURE Populate_All_Fin_Proc_Eval_Sum(
80: p_api_version_number IN NUMBER := 1.0,
81: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
82: p_commit IN VARCHAR2 := FND_API.g_false,
83: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
84: p_certification_id IN NUMBER,
85: x_return_status OUT nocopy VARCHAR2,
78:
79: PROCEDURE Populate_All_Fin_Proc_Eval_Sum(
80: p_api_version_number IN NUMBER := 1.0,
81: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
82: p_commit IN VARCHAR2 := FND_API.g_false,
83: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
84: p_certification_id IN NUMBER,
85: x_return_status OUT nocopy VARCHAR2,
86: x_msg_count OUT nocopy NUMBER,
79: PROCEDURE Populate_All_Fin_Proc_Eval_Sum(
80: p_api_version_number IN NUMBER := 1.0,
81: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
82: p_commit IN VARCHAR2 := FND_API.g_false,
83: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
84: p_certification_id IN NUMBER,
85: x_return_status OUT nocopy VARCHAR2,
86: x_msg_count OUT nocopy NUMBER,
87: x_msg_data OUT nocopy VARCHAR2
88: );
89:
90: PROCEDURE Refresh_All_Fin_Proc_Eval_Sum(
91: p_api_version_number IN NUMBER := 1.0,
92: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
93: p_commit IN VARCHAR2 := FND_API.g_false,
94: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
95: p_certification_id IN NUMBER,
96: x_return_status OUT nocopy VARCHAR2,
89:
90: PROCEDURE Refresh_All_Fin_Proc_Eval_Sum(
91: p_api_version_number IN NUMBER := 1.0,
92: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
93: p_commit IN VARCHAR2 := FND_API.g_false,
94: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
95: p_certification_id IN NUMBER,
96: x_return_status OUT nocopy VARCHAR2,
97: x_msg_count OUT nocopy NUMBER,
90: PROCEDURE Refresh_All_Fin_Proc_Eval_Sum(
91: p_api_version_number IN NUMBER := 1.0,
92: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
93: p_commit IN VARCHAR2 := FND_API.g_false,
94: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
95: p_certification_id IN NUMBER,
96: x_return_status OUT nocopy VARCHAR2,
97: x_msg_count OUT nocopy NUMBER,
98: x_msg_data OUT nocopy VARCHAR2
100:
101: /***
102: PROCEDURE Populate_All_Fin_Risk_Ass_Sum(
103: p_api_version_number IN NUMBER := 1.0,
104: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
105: p_commit IN VARCHAR2 := FND_API.g_false,
106: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
107: p_certification_id IN NUMBER,
108: x_return_status OUT nocopy VARCHAR2,
101: /***
102: PROCEDURE Populate_All_Fin_Risk_Ass_Sum(
103: p_api_version_number IN NUMBER := 1.0,
104: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
105: p_commit IN VARCHAR2 := FND_API.g_false,
106: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
107: p_certification_id IN NUMBER,
108: x_return_status OUT nocopy VARCHAR2,
109: x_msg_count OUT nocopy NUMBER,
102: PROCEDURE Populate_All_Fin_Risk_Ass_Sum(
103: p_api_version_number IN NUMBER := 1.0,
104: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
105: p_commit IN VARCHAR2 := FND_API.g_false,
106: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
107: p_certification_id IN NUMBER,
108: x_return_status OUT nocopy VARCHAR2,
109: x_msg_count OUT nocopy NUMBER,
110: x_msg_data OUT nocopy VARCHAR2
111: );
112:
113: PROCEDURE Populate_All_Fin_Ctrl_Ass_Sum(
114: p_api_version_number IN NUMBER := 1.0,
115: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
116: p_commit IN VARCHAR2 := FND_API.g_false,
117: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
118: p_certification_id IN NUMBER,
119: x_return_status OUT nocopy VARCHAR2,
112:
113: PROCEDURE Populate_All_Fin_Ctrl_Ass_Sum(
114: p_api_version_number IN NUMBER := 1.0,
115: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
116: p_commit IN VARCHAR2 := FND_API.g_false,
117: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
118: p_certification_id IN NUMBER,
119: x_return_status OUT nocopy VARCHAR2,
120: x_msg_count OUT nocopy NUMBER,
113: PROCEDURE Populate_All_Fin_Ctrl_Ass_Sum(
114: p_api_version_number IN NUMBER := 1.0,
115: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
116: p_commit IN VARCHAR2 := FND_API.g_false,
117: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
118: p_certification_id IN NUMBER,
119: x_return_status OUT nocopy VARCHAR2,
120: x_msg_count OUT nocopy NUMBER,
121: x_msg_data OUT nocopy VARCHAR2
122: );
123:
124: PROCEDURE Populate_All_Fin_AP_Ass_Sum(
125: p_api_version_number IN NUMBER := 1.0,
126: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
127: p_commit IN VARCHAR2 := FND_API.g_false,
128: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
129: p_certification_id IN NUMBER,
130: x_return_status OUT nocopy VARCHAR2,
123:
124: PROCEDURE Populate_All_Fin_AP_Ass_Sum(
125: p_api_version_number IN NUMBER := 1.0,
126: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
127: p_commit IN VARCHAR2 := FND_API.g_false,
128: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
129: p_certification_id IN NUMBER,
130: x_return_status OUT nocopy VARCHAR2,
131: x_msg_count OUT nocopy NUMBER,
124: PROCEDURE Populate_All_Fin_AP_Ass_Sum(
125: p_api_version_number IN NUMBER := 1.0,
126: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
127: p_commit IN VARCHAR2 := FND_API.g_false,
128: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
129: p_certification_id IN NUMBER,
130: x_return_status OUT nocopy VARCHAR2,
131: x_msg_count OUT nocopy NUMBER,
132: x_msg_data OUT nocopy VARCHAR2
134: ***/
135:
136: PROCEDURE Populate_All_Fin_Org_Eval_Sum(
137: p_api_version_number IN NUMBER := 1.0,
138: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
139: p_commit IN VARCHAR2 := FND_API.g_false,
140: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
141: p_certification_id IN NUMBER,
142: x_return_status OUT nocopy VARCHAR2,
135:
136: PROCEDURE Populate_All_Fin_Org_Eval_Sum(
137: p_api_version_number IN NUMBER := 1.0,
138: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
139: p_commit IN VARCHAR2 := FND_API.g_false,
140: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
141: p_certification_id IN NUMBER,
142: x_return_status OUT nocopy VARCHAR2,
143: x_msg_count OUT nocopy NUMBER,
136: PROCEDURE Populate_All_Fin_Org_Eval_Sum(
137: p_api_version_number IN NUMBER := 1.0,
138: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
139: p_commit IN VARCHAR2 := FND_API.g_false,
140: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
141: p_certification_id IN NUMBER,
142: x_return_status OUT nocopy VARCHAR2,
143: x_msg_count OUT nocopy NUMBER,
144: x_msg_data OUT nocopy VARCHAR2
147:
148:
149: PROCEDURE build_amw_fin_cert_eval_sum(
150: p_api_version_number IN NUMBER := 1.0,
151: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
152: p_commit IN VARCHAR2 := FND_API.g_false,
153: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
154: p_certification_id IN NUMBER,
155: x_return_status OUT nocopy VARCHAR2,
148:
149: PROCEDURE build_amw_fin_cert_eval_sum(
150: p_api_version_number IN NUMBER := 1.0,
151: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
152: p_commit IN VARCHAR2 := FND_API.g_false,
153: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
154: p_certification_id IN NUMBER,
155: x_return_status OUT nocopy VARCHAR2,
156: x_msg_count OUT nocopy NUMBER,
149: PROCEDURE build_amw_fin_cert_eval_sum(
150: p_api_version_number IN NUMBER := 1.0,
151: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
152: p_commit IN VARCHAR2 := FND_API.g_false,
153: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
154: p_certification_id IN NUMBER,
155: x_return_status OUT nocopy VARCHAR2,
156: x_msg_count OUT nocopy NUMBER,
157: x_msg_data OUT nocopy VARCHAR2
158: );
159:
160: PROCEDURE compute_values_for_eval_sum(
161: p_api_version_number IN NUMBER := 1.0,
162: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
163: p_commit IN VARCHAR2 := FND_API.g_false,
164: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
165: p_certification_id IN NUMBER,
166: p_financial_statement_id IN NUMBER ,
159:
160: PROCEDURE compute_values_for_eval_sum(
161: p_api_version_number IN NUMBER := 1.0,
162: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
163: p_commit IN VARCHAR2 := FND_API.g_false,
164: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
165: p_certification_id IN NUMBER,
166: p_financial_statement_id IN NUMBER ,
167: p_statement_group_id IN NUMBER ,
160: PROCEDURE compute_values_for_eval_sum(
161: p_api_version_number IN NUMBER := 1.0,
162: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
163: p_commit IN VARCHAR2 := FND_API.g_false,
164: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
165: p_certification_id IN NUMBER,
166: p_financial_statement_id IN NUMBER ,
167: p_statement_group_id IN NUMBER ,
168: p_financial_item_id IN NUMBER,
175: );
176:
177: PROCEDURE Populate_Fin_Org_Eval_Sum(
178: p_api_version_number IN NUMBER := 1.0,
179: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
180: p_commit IN VARCHAR2 := FND_API.g_false,
181: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
182: p_certification_id IN NUMBER,
183: p_start_date IN DATE,
176:
177: PROCEDURE Populate_Fin_Org_Eval_Sum(
178: p_api_version_number IN NUMBER := 1.0,
179: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
180: p_commit IN VARCHAR2 := FND_API.g_false,
181: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
182: p_certification_id IN NUMBER,
183: p_start_date IN DATE,
184: p_end_date IN DATE,
177: PROCEDURE Populate_Fin_Org_Eval_Sum(
178: p_api_version_number IN NUMBER := 1.0,
179: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
180: p_commit IN VARCHAR2 := FND_API.g_false,
181: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
182: p_certification_id IN NUMBER,
183: p_start_date IN DATE,
184: p_end_date IN DATE,
185: p_organization_id IN NUMBER,
189: );
190:
191: PROCEDURE Populate_Fin_Process_Eval_Sum(
192: p_api_version_number IN NUMBER := 1.0,
193: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
194: p_commit IN VARCHAR2 := FND_API.g_false,
195: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
196: p_certification_id IN NUMBER,
197: p_start_date IN DATE,
190:
191: PROCEDURE Populate_Fin_Process_Eval_Sum(
192: p_api_version_number IN NUMBER := 1.0,
193: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
194: p_commit IN VARCHAR2 := FND_API.g_false,
195: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
196: p_certification_id IN NUMBER,
197: p_start_date IN DATE,
198: p_end_date IN DATE,
191: PROCEDURE Populate_Fin_Process_Eval_Sum(
192: p_api_version_number IN NUMBER := 1.0,
193: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
194: p_commit IN VARCHAR2 := FND_API.g_false,
195: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
196: p_certification_id IN NUMBER,
197: p_start_date IN DATE,
198: p_end_date IN DATE,
199: p_process_org_rev_id IN NUMBER,
207: );
208:
209: PROCEDURE Populate_Fin_Risk_Ass_Sum(
210: p_api_version_number IN NUMBER := 1.0,
211: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
212: p_commit IN VARCHAR2 := FND_API.g_false,
213: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
214: p_certification_id IN NUMBER,
215: x_return_status OUT nocopy VARCHAR2,
208:
209: PROCEDURE Populate_Fin_Risk_Ass_Sum(
210: p_api_version_number IN NUMBER := 1.0,
211: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
212: p_commit IN VARCHAR2 := FND_API.g_false,
213: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
214: p_certification_id IN NUMBER,
215: x_return_status OUT nocopy VARCHAR2,
216: x_msg_count OUT nocopy NUMBER,
209: PROCEDURE Populate_Fin_Risk_Ass_Sum(
210: p_api_version_number IN NUMBER := 1.0,
211: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
212: p_commit IN VARCHAR2 := FND_API.g_false,
213: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
214: p_certification_id IN NUMBER,
215: x_return_status OUT nocopy VARCHAR2,
216: x_msg_count OUT nocopy NUMBER,
217: x_msg_data OUT nocopy VARCHAR2
218: );
219:
220: PROCEDURE Populate_Fin_Risk_Ass_Sum_M(
221: p_api_version_number IN NUMBER := 1.0,
222: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
223: p_commit IN VARCHAR2 := FND_API.g_false,
224: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
225: p_certification_id IN NUMBER,
226: x_return_status OUT nocopy VARCHAR2,
219:
220: PROCEDURE Populate_Fin_Risk_Ass_Sum_M(
221: p_api_version_number IN NUMBER := 1.0,
222: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
223: p_commit IN VARCHAR2 := FND_API.g_false,
224: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
225: p_certification_id IN NUMBER,
226: x_return_status OUT nocopy VARCHAR2,
227: x_msg_count OUT nocopy NUMBER,
220: PROCEDURE Populate_Fin_Risk_Ass_Sum_M(
221: p_api_version_number IN NUMBER := 1.0,
222: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
223: p_commit IN VARCHAR2 := FND_API.g_false,
224: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
225: p_certification_id IN NUMBER,
226: x_return_status OUT nocopy VARCHAR2,
227: x_msg_count OUT nocopy NUMBER,
228: x_msg_data OUT nocopy VARCHAR2
229: );
230:
231: PROCEDURE Populate_Fin_Ctrl_Ass_Sum(
232: p_api_version_number IN NUMBER := 1.0,
233: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
234: p_commit IN VARCHAR2 := FND_API.g_false,
235: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
236: p_certification_id IN NUMBER,
237: x_return_status OUT nocopy VARCHAR2,
230:
231: PROCEDURE Populate_Fin_Ctrl_Ass_Sum(
232: p_api_version_number IN NUMBER := 1.0,
233: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
234: p_commit IN VARCHAR2 := FND_API.g_false,
235: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
236: p_certification_id IN NUMBER,
237: x_return_status OUT nocopy VARCHAR2,
238: x_msg_count OUT nocopy NUMBER,
231: PROCEDURE Populate_Fin_Ctrl_Ass_Sum(
232: p_api_version_number IN NUMBER := 1.0,
233: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
234: p_commit IN VARCHAR2 := FND_API.g_false,
235: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
236: p_certification_id IN NUMBER,
237: x_return_status OUT nocopy VARCHAR2,
238: x_msg_count OUT nocopy NUMBER,
239: x_msg_data OUT nocopy VARCHAR2
240: );
241:
242: PROCEDURE Populate_Fin_Ctrl_Ass_Sum_M(
243: p_api_version_number IN NUMBER := 1.0,
244: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
245: p_commit IN VARCHAR2 := FND_API.g_false,
246: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
247: p_certification_id IN NUMBER,
248: x_return_status OUT nocopy VARCHAR2,
241:
242: PROCEDURE Populate_Fin_Ctrl_Ass_Sum_M(
243: p_api_version_number IN NUMBER := 1.0,
244: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
245: p_commit IN VARCHAR2 := FND_API.g_false,
246: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
247: p_certification_id IN NUMBER,
248: x_return_status OUT nocopy VARCHAR2,
249: x_msg_count OUT nocopy NUMBER,
242: PROCEDURE Populate_Fin_Ctrl_Ass_Sum_M(
243: p_api_version_number IN NUMBER := 1.0,
244: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
245: p_commit IN VARCHAR2 := FND_API.g_false,
246: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
247: p_certification_id IN NUMBER,
248: x_return_status OUT nocopy VARCHAR2,
249: x_msg_count OUT nocopy NUMBER,
250: x_msg_data OUT nocopy VARCHAR2
251: );
252:
253: PROCEDURE Populate_Fin_AP_Ass_Sum(
254: p_api_version_number IN NUMBER := 1.0,
255: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
256: p_commit IN VARCHAR2 := FND_API.g_false,
257: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
258: p_certification_id IN NUMBER,
259: x_return_status OUT nocopy VARCHAR2,
252:
253: PROCEDURE Populate_Fin_AP_Ass_Sum(
254: p_api_version_number IN NUMBER := 1.0,
255: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
256: p_commit IN VARCHAR2 := FND_API.g_false,
257: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
258: p_certification_id IN NUMBER,
259: x_return_status OUT nocopy VARCHAR2,
260: x_msg_count OUT nocopy NUMBER,
253: PROCEDURE Populate_Fin_AP_Ass_Sum(
254: p_api_version_number IN NUMBER := 1.0,
255: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
256: p_commit IN VARCHAR2 := FND_API.g_false,
257: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
258: p_certification_id IN NUMBER,
259: x_return_status OUT nocopy VARCHAR2,
260: x_msg_count OUT nocopy NUMBER,
261: x_msg_data OUT nocopy VARCHAR2
262: );
263:
264: PROCEDURE Populate_Fin_AP_Ass_Sum_M(
265: p_api_version_number IN NUMBER := 1.0,
266: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
267: p_commit IN VARCHAR2 := FND_API.g_false,
268: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
269: p_certification_id IN NUMBER,
270: x_return_status OUT nocopy VARCHAR2,
263:
264: PROCEDURE Populate_Fin_AP_Ass_Sum_M(
265: p_api_version_number IN NUMBER := 1.0,
266: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
267: p_commit IN VARCHAR2 := FND_API.g_false,
268: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
269: p_certification_id IN NUMBER,
270: x_return_status OUT nocopy VARCHAR2,
271: x_msg_count OUT nocopy NUMBER,
264: PROCEDURE Populate_Fin_AP_Ass_Sum_M(
265: p_api_version_number IN NUMBER := 1.0,
266: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
267: p_commit IN VARCHAR2 := FND_API.g_false,
268: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
269: p_certification_id IN NUMBER,
270: x_return_status OUT nocopy VARCHAR2,
271: x_msg_count OUT nocopy NUMBER,
272: x_msg_data OUT nocopy VARCHAR2
273: );
274:
275: PROCEDURE POPULATE_PROC_HIERARCHY(
276: p_api_version_number IN NUMBER := 1.0,
277: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
278: p_commit IN VARCHAR2 := FND_API.g_false,
279: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
280: P_CERTIFICATION_ID IN NUMBER,
281: P_PROCESS_ID IN NUMBER,
274:
275: PROCEDURE POPULATE_PROC_HIERARCHY(
276: p_api_version_number IN NUMBER := 1.0,
277: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
278: p_commit IN VARCHAR2 := FND_API.g_false,
279: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
280: P_CERTIFICATION_ID IN NUMBER,
281: P_PROCESS_ID IN NUMBER,
282: P_ORGANIZATION_ID IN NUMBER,
275: PROCEDURE POPULATE_PROC_HIERARCHY(
276: p_api_version_number IN NUMBER := 1.0,
277: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
278: p_commit IN VARCHAR2 := FND_API.g_false,
279: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
280: P_CERTIFICATION_ID IN NUMBER,
281: P_PROCESS_ID IN NUMBER,
282: P_ORGANIZATION_ID IN NUMBER,
283: p_account_process_flag IN VARCHAR2,
287: );
288:
289: PROCEDURE INSERT_FIN_CERT_SCOPE(
290: p_api_version_number IN NUMBER := 1.0,
291: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
292: p_commit IN VARCHAR2 := FND_API.g_false,
293: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
294: p_certification_id IN NUMBER,
295: x_return_status OUT nocopy VARCHAR2,
288:
289: PROCEDURE INSERT_FIN_CERT_SCOPE(
290: p_api_version_number IN NUMBER := 1.0,
291: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
292: p_commit IN VARCHAR2 := FND_API.g_false,
293: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
294: p_certification_id IN NUMBER,
295: x_return_status OUT nocopy VARCHAR2,
296: x_msg_count OUT nocopy NUMBER,
289: PROCEDURE INSERT_FIN_CERT_SCOPE(
290: p_api_version_number IN NUMBER := 1.0,
291: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
292: p_commit IN VARCHAR2 := FND_API.g_false,
293: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
294: p_certification_id IN NUMBER,
295: x_return_status OUT nocopy VARCHAR2,
296: x_msg_count OUT nocopy NUMBER,
297: x_msg_data OUT nocopy VARCHAR2
298: );
299:
300: PROCEDURE INSERT_FIN_CTRL(
301: p_api_version_number IN NUMBER := 1.0,
302: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
303: p_commit IN VARCHAR2 := FND_API.g_false,
304: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
305: p_certification_id IN NUMBER,
306: x_return_status OUT nocopy VARCHAR2,
299:
300: PROCEDURE INSERT_FIN_CTRL(
301: p_api_version_number IN NUMBER := 1.0,
302: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
303: p_commit IN VARCHAR2 := FND_API.g_false,
304: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
305: p_certification_id IN NUMBER,
306: x_return_status OUT nocopy VARCHAR2,
307: x_msg_count OUT nocopy NUMBER,
300: PROCEDURE INSERT_FIN_CTRL(
301: p_api_version_number IN NUMBER := 1.0,
302: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
303: p_commit IN VARCHAR2 := FND_API.g_false,
304: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
305: p_certification_id IN NUMBER,
306: x_return_status OUT nocopy VARCHAR2,
307: x_msg_count OUT nocopy NUMBER,
308: x_msg_data OUT nocopy VARCHAR2
309: );
310:
311: PROCEDURE INSERT_FIN_RISK(
312: p_api_version_number IN NUMBER := 1.0,
313: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
314: p_commit IN VARCHAR2 := FND_API.g_false,
315: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
316: p_certification_id IN NUMBER,
317: x_return_status OUT nocopy VARCHAR2,
310:
311: PROCEDURE INSERT_FIN_RISK(
312: p_api_version_number IN NUMBER := 1.0,
313: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
314: p_commit IN VARCHAR2 := FND_API.g_false,
315: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
316: p_certification_id IN NUMBER,
317: x_return_status OUT nocopy VARCHAR2,
318: x_msg_count OUT nocopy NUMBER,
311: PROCEDURE INSERT_FIN_RISK(
312: p_api_version_number IN NUMBER := 1.0,
313: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
314: p_commit IN VARCHAR2 := FND_API.g_false,
315: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
316: p_certification_id IN NUMBER,
317: x_return_status OUT nocopy VARCHAR2,
318: x_msg_count OUT nocopy NUMBER,
319: x_msg_data OUT nocopy VARCHAR2
350: );*/
351:
352: procedure insert_fin_cert_eval_sum(
353: p_api_version_number IN NUMBER := 1.0,
354: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
355: p_commit IN VARCHAR2 := FND_API.g_false,
356: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
357: X_FIN_CERTIFICATION_ID IN NUMBER,
358: X_FINANCIAL_STATEMENT_ID IN NUMBER,
351:
352: procedure insert_fin_cert_eval_sum(
353: p_api_version_number IN NUMBER := 1.0,
354: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
355: p_commit IN VARCHAR2 := FND_API.g_false,
356: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
357: X_FIN_CERTIFICATION_ID IN NUMBER,
358: X_FINANCIAL_STATEMENT_ID IN NUMBER,
359: X_FINANCIAL_ITEM_ID IN NUMBER,
352: procedure insert_fin_cert_eval_sum(
353: p_api_version_number IN NUMBER := 1.0,
354: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
355: p_commit IN VARCHAR2 := FND_API.g_false,
356: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
357: X_FIN_CERTIFICATION_ID IN NUMBER,
358: X_FINANCIAL_STATEMENT_ID IN NUMBER,
359: X_FINANCIAL_ITEM_ID IN NUMBER,
360: X_ACCOUNT_GROUP_ID IN NUMBER,
593: ------followings are the procedure for dashboard population
594: /**************
595: PROCEDURE Populate_All_Cert_General_Sum(
596: p_api_version_number IN NUMBER := 1.0,
597: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
598: p_commit IN VARCHAR2 := FND_API.g_false,
599: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
600: p_certification_id IN NUMBER,
601: x_return_status OUT nocopy VARCHAR2,
594: /**************
595: PROCEDURE Populate_All_Cert_General_Sum(
596: p_api_version_number IN NUMBER := 1.0,
597: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
598: p_commit IN VARCHAR2 := FND_API.g_false,
599: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
600: p_certification_id IN NUMBER,
601: x_return_status OUT nocopy VARCHAR2,
602: x_msg_count OUT nocopy NUMBER,
595: PROCEDURE Populate_All_Cert_General_Sum(
596: p_api_version_number IN NUMBER := 1.0,
597: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
598: p_commit IN VARCHAR2 := FND_API.g_false,
599: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
600: p_certification_id IN NUMBER,
601: x_return_status OUT nocopy VARCHAR2,
602: x_msg_count OUT nocopy NUMBER,
603: x_msg_data OUT nocopy VARCHAR2
605: *************/
606:
607: PROCEDURE Populate_Cert_General_Sum(
608: p_api_version_number IN NUMBER := 1.0,
609: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
610: p_commit IN VARCHAR2 := FND_API.g_false,
611: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
612: p_certification_id IN NUMBER,
613: p_start_date IN DATE,
606:
607: PROCEDURE Populate_Cert_General_Sum(
608: p_api_version_number IN NUMBER := 1.0,
609: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
610: p_commit IN VARCHAR2 := FND_API.g_false,
611: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
612: p_certification_id IN NUMBER,
613: p_start_date IN DATE,
614: x_return_status OUT nocopy VARCHAR2,
607: PROCEDURE Populate_Cert_General_Sum(
608: p_api_version_number IN NUMBER := 1.0,
609: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
610: p_commit IN VARCHAR2 := FND_API.g_false,
611: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
612: p_certification_id IN NUMBER,
613: p_start_date IN DATE,
614: x_return_status OUT nocopy VARCHAR2,
615: x_msg_count OUT nocopy NUMBER,
676: );
677:
678: PROCEDURE RISK_EVALUATION_HANDLER(
679: p_api_version_number IN NUMBER := 1.0,
680: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
681: p_commit IN VARCHAR2 := FND_API.g_false,
682: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
683: p_risk_id IN NUMBER,
684: p_org_id IN NUMBER,
677:
678: PROCEDURE RISK_EVALUATION_HANDLER(
679: p_api_version_number IN NUMBER := 1.0,
680: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
681: p_commit IN VARCHAR2 := FND_API.g_false,
682: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
683: p_risk_id IN NUMBER,
684: p_org_id IN NUMBER,
685: p_process_id IN NUMBER,
678: PROCEDURE RISK_EVALUATION_HANDLER(
679: p_api_version_number IN NUMBER := 1.0,
680: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
681: p_commit IN VARCHAR2 := FND_API.g_false,
682: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
683: p_risk_id IN NUMBER,
684: p_org_id IN NUMBER,
685: p_process_id IN NUMBER,
686: p_opinion_log_id IN NUMBER,
690: );
691:
692: PROCEDURE CONTROL_EVALUATION_HANDLER(
693: p_api_version_number IN NUMBER := 1.0,
694: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
695: p_commit IN VARCHAR2 := FND_API.g_false,
696: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
697: p_ctrl_id IN NUMBER,
698: p_org_id IN NUMBER,
691:
692: PROCEDURE CONTROL_EVALUATION_HANDLER(
693: p_api_version_number IN NUMBER := 1.0,
694: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
695: p_commit IN VARCHAR2 := FND_API.g_false,
696: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
697: p_ctrl_id IN NUMBER,
698: p_org_id IN NUMBER,
699: p_opinion_log_id IN NUMBER,
692: PROCEDURE CONTROL_EVALUATION_HANDLER(
693: p_api_version_number IN NUMBER := 1.0,
694: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
695: p_commit IN VARCHAR2 := FND_API.g_false,
696: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
697: p_ctrl_id IN NUMBER,
698: p_org_id IN NUMBER,
699: p_opinion_log_id IN NUMBER,
700: x_return_status OUT nocopy VARCHAR2,
703: );
704:
705: PROCEDURE ORGANIZATION_CHANGE_HANDLER(
706: p_api_version_number IN NUMBER := 1.0,
707: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
708: p_commit IN VARCHAR2 := FND_API.g_false,
709: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
710: p_org_id IN NUMBER,
711: p_opinion_log_id IN NUMBER,
704:
705: PROCEDURE ORGANIZATION_CHANGE_HANDLER(
706: p_api_version_number IN NUMBER := 1.0,
707: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
708: p_commit IN VARCHAR2 := FND_API.g_false,
709: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
710: p_org_id IN NUMBER,
711: p_opinion_log_id IN NUMBER,
712: p_action IN VARCHAR2,
705: PROCEDURE ORGANIZATION_CHANGE_HANDLER(
706: p_api_version_number IN NUMBER := 1.0,
707: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
708: p_commit IN VARCHAR2 := FND_API.g_false,
709: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
710: p_org_id IN NUMBER,
711: p_opinion_log_id IN NUMBER,
712: p_action IN VARCHAR2,
713: x_return_status OUT nocopy VARCHAR2,
716: );
717:
718: PROCEDURE PROCESS_CHANGE_HANDLER(
719: p_api_version_number IN NUMBER := 1.0,
720: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
721: p_commit IN VARCHAR2 := FND_API.g_false,
722: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
723: p_org_id IN NUMBER,
724: p_process_id IN NUMBER,
717:
718: PROCEDURE PROCESS_CHANGE_HANDLER(
719: p_api_version_number IN NUMBER := 1.0,
720: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
721: p_commit IN VARCHAR2 := FND_API.g_false,
722: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
723: p_org_id IN NUMBER,
724: p_process_id IN NUMBER,
725: p_opinion_log_id IN NUMBER,
718: PROCEDURE PROCESS_CHANGE_HANDLER(
719: p_api_version_number IN NUMBER := 1.0,
720: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
721: p_commit IN VARCHAR2 := FND_API.g_false,
722: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
723: p_org_id IN NUMBER,
724: p_process_id IN NUMBER,
725: p_opinion_log_id IN NUMBER,
726: p_action IN VARCHAR2,