40: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
41: x_return_status OUT NOCOPY VARCHAR2,
42: x_msg_count OUT NOCOPY NUMBER,
43: x_msg_data OUT NOCOPY VARCHAR2,
44: p_plan_element_rec IN OUT NOCOPY cn_plan_element_pub.plan_element_rec_type,
45: p_revenue_class_rec_tbl IN OUT NOCOPY cn_plan_element_pub.revenue_class_rec_tbl_type,
46: p_rev_uplift_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rev_uplift_rec_tbl_type,
47: p_trx_factor_rec_tbl IN OUT NOCOPY cn_plan_element_pub.trx_factor_rec_tbl_type,
48: p_period_quotas_rec_tbl IN OUT NOCOPY cn_plan_element_pub.period_quotas_rec_tbl_type,
41: x_return_status OUT NOCOPY VARCHAR2,
42: x_msg_count OUT NOCOPY NUMBER,
43: x_msg_data OUT NOCOPY VARCHAR2,
44: p_plan_element_rec IN OUT NOCOPY cn_plan_element_pub.plan_element_rec_type,
45: p_revenue_class_rec_tbl IN OUT NOCOPY cn_plan_element_pub.revenue_class_rec_tbl_type,
46: p_rev_uplift_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rev_uplift_rec_tbl_type,
47: p_trx_factor_rec_tbl IN OUT NOCOPY cn_plan_element_pub.trx_factor_rec_tbl_type,
48: p_period_quotas_rec_tbl IN OUT NOCOPY cn_plan_element_pub.period_quotas_rec_tbl_type,
49: p_rt_quota_asgns_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,
42: x_msg_count OUT NOCOPY NUMBER,
43: x_msg_data OUT NOCOPY VARCHAR2,
44: p_plan_element_rec IN OUT NOCOPY cn_plan_element_pub.plan_element_rec_type,
45: p_revenue_class_rec_tbl IN OUT NOCOPY cn_plan_element_pub.revenue_class_rec_tbl_type,
46: p_rev_uplift_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rev_uplift_rec_tbl_type,
47: p_trx_factor_rec_tbl IN OUT NOCOPY cn_plan_element_pub.trx_factor_rec_tbl_type,
48: p_period_quotas_rec_tbl IN OUT NOCOPY cn_plan_element_pub.period_quotas_rec_tbl_type,
49: p_rt_quota_asgns_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,
50: x_loading_status OUT NOCOPY VARCHAR2
43: x_msg_data OUT NOCOPY VARCHAR2,
44: p_plan_element_rec IN OUT NOCOPY cn_plan_element_pub.plan_element_rec_type,
45: p_revenue_class_rec_tbl IN OUT NOCOPY cn_plan_element_pub.revenue_class_rec_tbl_type,
46: p_rev_uplift_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rev_uplift_rec_tbl_type,
47: p_trx_factor_rec_tbl IN OUT NOCOPY cn_plan_element_pub.trx_factor_rec_tbl_type,
48: p_period_quotas_rec_tbl IN OUT NOCOPY cn_plan_element_pub.period_quotas_rec_tbl_type,
49: p_rt_quota_asgns_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,
50: x_loading_status OUT NOCOPY VARCHAR2
51: );
44: p_plan_element_rec IN OUT NOCOPY cn_plan_element_pub.plan_element_rec_type,
45: p_revenue_class_rec_tbl IN OUT NOCOPY cn_plan_element_pub.revenue_class_rec_tbl_type,
46: p_rev_uplift_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rev_uplift_rec_tbl_type,
47: p_trx_factor_rec_tbl IN OUT NOCOPY cn_plan_element_pub.trx_factor_rec_tbl_type,
48: p_period_quotas_rec_tbl IN OUT NOCOPY cn_plan_element_pub.period_quotas_rec_tbl_type,
49: p_rt_quota_asgns_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,
50: x_loading_status OUT NOCOPY VARCHAR2
51: );
52:
45: p_revenue_class_rec_tbl IN OUT NOCOPY cn_plan_element_pub.revenue_class_rec_tbl_type,
46: p_rev_uplift_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rev_uplift_rec_tbl_type,
47: p_trx_factor_rec_tbl IN OUT NOCOPY cn_plan_element_pub.trx_factor_rec_tbl_type,
48: p_period_quotas_rec_tbl IN OUT NOCOPY cn_plan_element_pub.period_quotas_rec_tbl_type,
49: p_rt_quota_asgns_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,
50: x_loading_status OUT NOCOPY VARCHAR2
51: );
52:
53: -- Start of Comments
89: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
90: x_return_status OUT NOCOPY VARCHAR2,
91: x_msg_count OUT NOCOPY NUMBER,
92: x_msg_data OUT NOCOPY VARCHAR2,
93: p_plan_element_rec IN cn_plan_element_pub.plan_element_rec_type,
94: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type,
95: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type,
96: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type,
97: p_period_quotas_rec_tbl IN cn_plan_element_pub.period_quotas_rec_tbl_type,
90: x_return_status OUT NOCOPY VARCHAR2,
91: x_msg_count OUT NOCOPY NUMBER,
92: x_msg_data OUT NOCOPY VARCHAR2,
93: p_plan_element_rec IN cn_plan_element_pub.plan_element_rec_type,
94: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type,
95: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type,
96: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type,
97: p_period_quotas_rec_tbl IN cn_plan_element_pub.period_quotas_rec_tbl_type,
98: p_rt_quota_asgns_rec_tbl IN cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,
91: x_msg_count OUT NOCOPY NUMBER,
92: x_msg_data OUT NOCOPY VARCHAR2,
93: p_plan_element_rec IN cn_plan_element_pub.plan_element_rec_type,
94: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type,
95: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type,
96: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type,
97: p_period_quotas_rec_tbl IN cn_plan_element_pub.period_quotas_rec_tbl_type,
98: p_rt_quota_asgns_rec_tbl IN cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,
99: x_loading_status OUT NOCOPY VARCHAR2
92: x_msg_data OUT NOCOPY VARCHAR2,
93: p_plan_element_rec IN cn_plan_element_pub.plan_element_rec_type,
94: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type,
95: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type,
96: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type,
97: p_period_quotas_rec_tbl IN cn_plan_element_pub.period_quotas_rec_tbl_type,
98: p_rt_quota_asgns_rec_tbl IN cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,
99: x_loading_status OUT NOCOPY VARCHAR2
100: );
93: p_plan_element_rec IN cn_plan_element_pub.plan_element_rec_type,
94: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type,
95: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type,
96: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type,
97: p_period_quotas_rec_tbl IN cn_plan_element_pub.period_quotas_rec_tbl_type,
98: p_rt_quota_asgns_rec_tbl IN cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,
99: x_loading_status OUT NOCOPY VARCHAR2
100: );
101:
94: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type,
95: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type,
96: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type,
97: p_period_quotas_rec_tbl IN cn_plan_element_pub.period_quotas_rec_tbl_type,
98: p_rt_quota_asgns_rec_tbl IN cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,
99: x_loading_status OUT NOCOPY VARCHAR2
100: );
101:
102: -- Start of Comments
135: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
136: x_return_status OUT NOCOPY VARCHAR2,
137: x_msg_count OUT NOCOPY NUMBER,
138: x_msg_data OUT NOCOPY VARCHAR2,
139: p_new_plan_element_rec IN OUT NOCOPY cn_plan_element_pub.plan_element_rec_type,
140: p_quota_name_old IN OUT NOCOPY VARCHAR2,
141: p_revenue_class_rec_tbl IN OUT NOCOPY cn_plan_element_pub.revenue_class_rec_tbl_type,
142: p_rev_uplift_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rev_uplift_rec_tbl_type,
143: p_trx_factor_rec_tbl IN OUT NOCOPY cn_plan_element_pub.trx_factor_rec_tbl_type,
137: x_msg_count OUT NOCOPY NUMBER,
138: x_msg_data OUT NOCOPY VARCHAR2,
139: p_new_plan_element_rec IN OUT NOCOPY cn_plan_element_pub.plan_element_rec_type,
140: p_quota_name_old IN OUT NOCOPY VARCHAR2,
141: p_revenue_class_rec_tbl IN OUT NOCOPY cn_plan_element_pub.revenue_class_rec_tbl_type,
142: p_rev_uplift_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rev_uplift_rec_tbl_type,
143: p_trx_factor_rec_tbl IN OUT NOCOPY cn_plan_element_pub.trx_factor_rec_tbl_type,
144: p_period_quotas_rec_tbl IN OUT NOCOPY cn_plan_element_pub.period_quotas_rec_tbl_type,
145: p_rt_quota_asgns_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,
138: x_msg_data OUT NOCOPY VARCHAR2,
139: p_new_plan_element_rec IN OUT NOCOPY cn_plan_element_pub.plan_element_rec_type,
140: p_quota_name_old IN OUT NOCOPY VARCHAR2,
141: p_revenue_class_rec_tbl IN OUT NOCOPY cn_plan_element_pub.revenue_class_rec_tbl_type,
142: p_rev_uplift_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rev_uplift_rec_tbl_type,
143: p_trx_factor_rec_tbl IN OUT NOCOPY cn_plan_element_pub.trx_factor_rec_tbl_type,
144: p_period_quotas_rec_tbl IN OUT NOCOPY cn_plan_element_pub.period_quotas_rec_tbl_type,
145: p_rt_quota_asgns_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,
146: x_loading_status OUT NOCOPY VARCHAR2
139: p_new_plan_element_rec IN OUT NOCOPY cn_plan_element_pub.plan_element_rec_type,
140: p_quota_name_old IN OUT NOCOPY VARCHAR2,
141: p_revenue_class_rec_tbl IN OUT NOCOPY cn_plan_element_pub.revenue_class_rec_tbl_type,
142: p_rev_uplift_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rev_uplift_rec_tbl_type,
143: p_trx_factor_rec_tbl IN OUT NOCOPY cn_plan_element_pub.trx_factor_rec_tbl_type,
144: p_period_quotas_rec_tbl IN OUT NOCOPY cn_plan_element_pub.period_quotas_rec_tbl_type,
145: p_rt_quota_asgns_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,
146: x_loading_status OUT NOCOPY VARCHAR2
147: );
140: p_quota_name_old IN OUT NOCOPY VARCHAR2,
141: p_revenue_class_rec_tbl IN OUT NOCOPY cn_plan_element_pub.revenue_class_rec_tbl_type,
142: p_rev_uplift_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rev_uplift_rec_tbl_type,
143: p_trx_factor_rec_tbl IN OUT NOCOPY cn_plan_element_pub.trx_factor_rec_tbl_type,
144: p_period_quotas_rec_tbl IN OUT NOCOPY cn_plan_element_pub.period_quotas_rec_tbl_type,
145: p_rt_quota_asgns_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,
146: x_loading_status OUT NOCOPY VARCHAR2
147: );
148:
141: p_revenue_class_rec_tbl IN OUT NOCOPY cn_plan_element_pub.revenue_class_rec_tbl_type,
142: p_rev_uplift_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rev_uplift_rec_tbl_type,
143: p_trx_factor_rec_tbl IN OUT NOCOPY cn_plan_element_pub.trx_factor_rec_tbl_type,
144: p_period_quotas_rec_tbl IN OUT NOCOPY cn_plan_element_pub.period_quotas_rec_tbl_type,
145: p_rt_quota_asgns_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,
146: x_loading_status OUT NOCOPY VARCHAR2
147: );
148:
149: -- Start of Comments
182: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_count OUT NOCOPY NUMBER,
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_new_plan_element_rec IN cn_plan_element_pub.plan_element_rec_type,
187: p_quota_name_old IN VARCHAR2,
188: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type,
189: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type,
190: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type,
184: x_msg_count OUT NOCOPY NUMBER,
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_new_plan_element_rec IN cn_plan_element_pub.plan_element_rec_type,
187: p_quota_name_old IN VARCHAR2,
188: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type,
189: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type,
190: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type,
191: p_period_quotas_rec_tbl IN cn_plan_element_pub.period_quotas_rec_tbl_type,
192: p_rt_quota_asgns_rec_tbl IN cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_new_plan_element_rec IN cn_plan_element_pub.plan_element_rec_type,
187: p_quota_name_old IN VARCHAR2,
188: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type,
189: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type,
190: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type,
191: p_period_quotas_rec_tbl IN cn_plan_element_pub.period_quotas_rec_tbl_type,
192: p_rt_quota_asgns_rec_tbl IN cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,
193: x_loading_status OUT NOCOPY VARCHAR2
186: p_new_plan_element_rec IN cn_plan_element_pub.plan_element_rec_type,
187: p_quota_name_old IN VARCHAR2,
188: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type,
189: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type,
190: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type,
191: p_period_quotas_rec_tbl IN cn_plan_element_pub.period_quotas_rec_tbl_type,
192: p_rt_quota_asgns_rec_tbl IN cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,
193: x_loading_status OUT NOCOPY VARCHAR2
194: );
187: p_quota_name_old IN VARCHAR2,
188: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type,
189: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type,
190: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type,
191: p_period_quotas_rec_tbl IN cn_plan_element_pub.period_quotas_rec_tbl_type,
192: p_rt_quota_asgns_rec_tbl IN cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,
193: x_loading_status OUT NOCOPY VARCHAR2
194: );
195:
188: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type,
189: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type,
190: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type,
191: p_period_quotas_rec_tbl IN cn_plan_element_pub.period_quotas_rec_tbl_type,
192: p_rt_quota_asgns_rec_tbl IN cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,
193: x_loading_status OUT NOCOPY VARCHAR2
194: );
195:
196: -- Start of Comments
228: x_return_status OUT NOCOPY VARCHAR2,
229: x_msg_count OUT NOCOPY NUMBER,
230: x_msg_data OUT NOCOPY VARCHAR2,
231: p_quota_name IN OUT NOCOPY VARCHAR2,
232: p_revenue_class_rec_tbl IN OUT NOCOPY cn_plan_element_pub.revenue_class_rec_tbl_type,
233: p_rev_uplift_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rev_uplift_rec_tbl_type,
234: p_rt_quota_asgns_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,
235: x_loading_status OUT NOCOPY VARCHAR2
236: );
229: x_msg_count OUT NOCOPY NUMBER,
230: x_msg_data OUT NOCOPY VARCHAR2,
231: p_quota_name IN OUT NOCOPY VARCHAR2,
232: p_revenue_class_rec_tbl IN OUT NOCOPY cn_plan_element_pub.revenue_class_rec_tbl_type,
233: p_rev_uplift_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rev_uplift_rec_tbl_type,
234: p_rt_quota_asgns_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,
235: x_loading_status OUT NOCOPY VARCHAR2
236: );
237:
230: x_msg_data OUT NOCOPY VARCHAR2,
231: p_quota_name IN OUT NOCOPY VARCHAR2,
232: p_revenue_class_rec_tbl IN OUT NOCOPY cn_plan_element_pub.revenue_class_rec_tbl_type,
233: p_rev_uplift_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rev_uplift_rec_tbl_type,
234: p_rt_quota_asgns_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,
235: x_loading_status OUT NOCOPY VARCHAR2
236: );
237:
238: -- Start of Comments
270: x_return_status OUT NOCOPY VARCHAR2,
271: x_msg_count OUT NOCOPY NUMBER,
272: x_msg_data OUT NOCOPY VARCHAR2,
273: p_quota_name IN VARCHAR2,
274: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type,
275: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type,
276: p_rt_quota_asgns_rec_tbl IN cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,
277: x_loading_status OUT NOCOPY VARCHAR2
278: );
271: x_msg_count OUT NOCOPY NUMBER,
272: x_msg_data OUT NOCOPY VARCHAR2,
273: p_quota_name IN VARCHAR2,
274: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type,
275: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type,
276: p_rt_quota_asgns_rec_tbl IN cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,
277: x_loading_status OUT NOCOPY VARCHAR2
278: );
279:
272: x_msg_data OUT NOCOPY VARCHAR2,
273: p_quota_name IN VARCHAR2,
274: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type,
275: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type,
276: p_rt_quota_asgns_rec_tbl IN cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,
277: x_loading_status OUT NOCOPY VARCHAR2
278: );
279:
280: -- Start Comments
373: --
374: -- End of comments
375: --
376: FUNCTION ok_to_generate_msg (
377: p_plan_element_rec IN cn_plan_element_pub.plan_element_rec_type := cn_plan_element_pub.g_miss_plan_element_rec,
378: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl,
379: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type := cn_plan_element_pub.g_miss_rev_uplift_rec_tbl,
380: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type := cn_plan_element_pub.g_miss_trx_factor_rec_tbl,
381: p_period_quotas_rec_tbl IN cn_plan_element_pub.period_quotas_rec_tbl_type := cn_plan_element_pub.g_miss_period_quotas_rec_tbl,
374: -- End of comments
375: --
376: FUNCTION ok_to_generate_msg (
377: p_plan_element_rec IN cn_plan_element_pub.plan_element_rec_type := cn_plan_element_pub.g_miss_plan_element_rec,
378: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl,
379: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type := cn_plan_element_pub.g_miss_rev_uplift_rec_tbl,
380: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type := cn_plan_element_pub.g_miss_trx_factor_rec_tbl,
381: p_period_quotas_rec_tbl IN cn_plan_element_pub.period_quotas_rec_tbl_type := cn_plan_element_pub.g_miss_period_quotas_rec_tbl,
382: p_rt_quota_asgns_rec_tbl IN cn_plan_element_pub.rt_quota_asgns_rec_tbl_type := cn_plan_element_pub.g_miss_rt_quota_asgns_rec_tbl,
375: --
376: FUNCTION ok_to_generate_msg (
377: p_plan_element_rec IN cn_plan_element_pub.plan_element_rec_type := cn_plan_element_pub.g_miss_plan_element_rec,
378: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl,
379: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type := cn_plan_element_pub.g_miss_rev_uplift_rec_tbl,
380: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type := cn_plan_element_pub.g_miss_trx_factor_rec_tbl,
381: p_period_quotas_rec_tbl IN cn_plan_element_pub.period_quotas_rec_tbl_type := cn_plan_element_pub.g_miss_period_quotas_rec_tbl,
382: p_rt_quota_asgns_rec_tbl IN cn_plan_element_pub.rt_quota_asgns_rec_tbl_type := cn_plan_element_pub.g_miss_rt_quota_asgns_rec_tbl,
383: p_plan_element_name IN VARCHAR2 := NULL
376: FUNCTION ok_to_generate_msg (
377: p_plan_element_rec IN cn_plan_element_pub.plan_element_rec_type := cn_plan_element_pub.g_miss_plan_element_rec,
378: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl,
379: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type := cn_plan_element_pub.g_miss_rev_uplift_rec_tbl,
380: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type := cn_plan_element_pub.g_miss_trx_factor_rec_tbl,
381: p_period_quotas_rec_tbl IN cn_plan_element_pub.period_quotas_rec_tbl_type := cn_plan_element_pub.g_miss_period_quotas_rec_tbl,
382: p_rt_quota_asgns_rec_tbl IN cn_plan_element_pub.rt_quota_asgns_rec_tbl_type := cn_plan_element_pub.g_miss_rt_quota_asgns_rec_tbl,
383: p_plan_element_name IN VARCHAR2 := NULL
384: )
377: p_plan_element_rec IN cn_plan_element_pub.plan_element_rec_type := cn_plan_element_pub.g_miss_plan_element_rec,
378: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl,
379: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type := cn_plan_element_pub.g_miss_rev_uplift_rec_tbl,
380: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type := cn_plan_element_pub.g_miss_trx_factor_rec_tbl,
381: p_period_quotas_rec_tbl IN cn_plan_element_pub.period_quotas_rec_tbl_type := cn_plan_element_pub.g_miss_period_quotas_rec_tbl,
382: p_rt_quota_asgns_rec_tbl IN cn_plan_element_pub.rt_quota_asgns_rec_tbl_type := cn_plan_element_pub.g_miss_rt_quota_asgns_rec_tbl,
383: p_plan_element_name IN VARCHAR2 := NULL
384: )
385: RETURN BOOLEAN;
378: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl,
379: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type := cn_plan_element_pub.g_miss_rev_uplift_rec_tbl,
380: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type := cn_plan_element_pub.g_miss_trx_factor_rec_tbl,
381: p_period_quotas_rec_tbl IN cn_plan_element_pub.period_quotas_rec_tbl_type := cn_plan_element_pub.g_miss_period_quotas_rec_tbl,
382: p_rt_quota_asgns_rec_tbl IN cn_plan_element_pub.rt_quota_asgns_rec_tbl_type := cn_plan_element_pub.g_miss_rt_quota_asgns_rec_tbl,
383: p_plan_element_name IN VARCHAR2 := NULL
384: )
385: RETURN BOOLEAN;
386: END cn_plan_element_cuhk;