DBA Data[Home] [Help]

APPS.CN_PLAN_ELEMENT_CUHK dependencies on CN_PLAN_ELEMENT_PUB

Line 44: p_plan_element_rec IN OUT NOCOPY cn_plan_element_pub.plan_element_rec_type,

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,

Line 45: p_revenue_class_rec_tbl IN OUT NOCOPY cn_plan_element_pub.revenue_class_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,

Line 46: p_rev_uplift_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rev_uplift_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

Line 47: p_trx_factor_rec_tbl IN OUT NOCOPY cn_plan_element_pub.trx_factor_rec_tbl_type,

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: );

Line 48: p_period_quotas_rec_tbl IN OUT NOCOPY cn_plan_element_pub.period_quotas_rec_tbl_type,

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:

Line 49: p_rt_quota_asgns_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rt_quota_asgns_rec_tbl_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:
53: -- Start of Comments

Line 93: p_plan_element_rec IN cn_plan_element_pub.plan_element_rec_type,

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,

Line 94: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_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,

Line 95: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_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

Line 96: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type,

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: );

Line 97: p_period_quotas_rec_tbl IN cn_plan_element_pub.period_quotas_rec_tbl_type,

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:

Line 98: p_rt_quota_asgns_rec_tbl IN cn_plan_element_pub.rt_quota_asgns_rec_tbl_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:
102: -- Start of Comments

Line 139: p_new_plan_element_rec IN OUT NOCOPY cn_plan_element_pub.plan_element_rec_type,

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,

Line 141: p_revenue_class_rec_tbl IN OUT NOCOPY cn_plan_element_pub.revenue_class_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,

Line 142: p_rev_uplift_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rev_uplift_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

Line 143: p_trx_factor_rec_tbl IN OUT NOCOPY cn_plan_element_pub.trx_factor_rec_tbl_type,

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: );

Line 144: p_period_quotas_rec_tbl IN OUT NOCOPY cn_plan_element_pub.period_quotas_rec_tbl_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: );
148:

Line 145: p_rt_quota_asgns_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,

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

Line 186: p_new_plan_element_rec IN cn_plan_element_pub.plan_element_rec_type,

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,

Line 188: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_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,

Line 189: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_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

Line 190: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type,

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: );

Line 191: p_period_quotas_rec_tbl IN cn_plan_element_pub.period_quotas_rec_tbl_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: );
195:

Line 192: p_rt_quota_asgns_rec_tbl IN cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,

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

Line 232: p_revenue_class_rec_tbl IN OUT NOCOPY cn_plan_element_pub.revenue_class_rec_tbl_type,

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: );

Line 233: p_rev_uplift_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rev_uplift_rec_tbl_type,

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:

Line 234: p_rt_quota_asgns_rec_tbl IN OUT NOCOPY cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,

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

Line 274: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type,

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: );

Line 275: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type,

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:

Line 276: p_rt_quota_asgns_rec_tbl IN cn_plan_element_pub.rt_quota_asgns_rec_tbl_type,

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

Line 377: p_plan_element_rec IN cn_plan_element_pub.plan_element_rec_type := cn_plan_element_pub.g_miss_plan_element_rec,

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,

Line 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,

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,

Line 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,

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

Line 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,

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: )

Line 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,

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;

Line 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,

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;