1: PACKAGE CN_RT_QUOTA_ASGNS_PVT AS
2: /* $Header: cnxvrqas.pls 120.1 2005/09/05 05:12:46 rarajara noship $ */
3:
4: -- Record type
5:
4: -- Record type
5:
6: TYPE rate_date_seq_rec_type IS RECORD
7: (
8: start_date cn_rt_quota_asgns.start_date%TYPE := NULL,
9: start_date_old cn_rt_quota_asgns.start_date%TYPE := NULL,
10: end_date cn_rt_quota_asgns.end_date%TYPE := NULL,
11: end_date_old cn_rt_quota_asgns.end_date%TYPE := NULL,
12: quota_id cn_rt_quota_asgns.quota_id%TYPE := NULL,
5:
6: TYPE rate_date_seq_rec_type IS RECORD
7: (
8: start_date cn_rt_quota_asgns.start_date%TYPE := NULL,
9: start_date_old cn_rt_quota_asgns.start_date%TYPE := NULL,
10: end_date cn_rt_quota_asgns.end_date%TYPE := NULL,
11: end_date_old cn_rt_quota_asgns.end_date%TYPE := NULL,
12: quota_id cn_rt_quota_asgns.quota_id%TYPE := NULL,
13: rt_quota_asgn_id cn_rt_quota_asgns.rt_quota_asgn_id%TYPE
6: TYPE rate_date_seq_rec_type IS RECORD
7: (
8: start_date cn_rt_quota_asgns.start_date%TYPE := NULL,
9: start_date_old cn_rt_quota_asgns.start_date%TYPE := NULL,
10: end_date cn_rt_quota_asgns.end_date%TYPE := NULL,
11: end_date_old cn_rt_quota_asgns.end_date%TYPE := NULL,
12: quota_id cn_rt_quota_asgns.quota_id%TYPE := NULL,
13: rt_quota_asgn_id cn_rt_quota_asgns.rt_quota_asgn_id%TYPE
14: := NULL,
7: (
8: start_date cn_rt_quota_asgns.start_date%TYPE := NULL,
9: start_date_old cn_rt_quota_asgns.start_date%TYPE := NULL,
10: end_date cn_rt_quota_asgns.end_date%TYPE := NULL,
11: end_date_old cn_rt_quota_asgns.end_date%TYPE := NULL,
12: quota_id cn_rt_quota_asgns.quota_id%TYPE := NULL,
13: rt_quota_asgn_id cn_rt_quota_asgns.rt_quota_asgn_id%TYPE
14: := NULL,
15: org_id cn_rt_quota_asgns.org_id%type:=NULL
8: start_date cn_rt_quota_asgns.start_date%TYPE := NULL,
9: start_date_old cn_rt_quota_asgns.start_date%TYPE := NULL,
10: end_date cn_rt_quota_asgns.end_date%TYPE := NULL,
11: end_date_old cn_rt_quota_asgns.end_date%TYPE := NULL,
12: quota_id cn_rt_quota_asgns.quota_id%TYPE := NULL,
13: rt_quota_asgn_id cn_rt_quota_asgns.rt_quota_asgn_id%TYPE
14: := NULL,
15: org_id cn_rt_quota_asgns.org_id%type:=NULL
16: );
9: start_date_old cn_rt_quota_asgns.start_date%TYPE := NULL,
10: end_date cn_rt_quota_asgns.end_date%TYPE := NULL,
11: end_date_old cn_rt_quota_asgns.end_date%TYPE := NULL,
12: quota_id cn_rt_quota_asgns.quota_id%TYPE := NULL,
13: rt_quota_asgn_id cn_rt_quota_asgns.rt_quota_asgn_id%TYPE
14: := NULL,
15: org_id cn_rt_quota_asgns.org_id%type:=NULL
16: );
17:
11: end_date_old cn_rt_quota_asgns.end_date%TYPE := NULL,
12: quota_id cn_rt_quota_asgns.quota_id%TYPE := NULL,
13: rt_quota_asgn_id cn_rt_quota_asgns.rt_quota_asgn_id%TYPE
14: := NULL,
15: org_id cn_rt_quota_asgns.org_id%type:=NULL
16: );
17:
18: --
19: -- User Defined Quota Rules Record Table Type
144: p_rt_quota_asgns_rec_tbl IN cn_plan_element_pub.rt_quota_asgns_rec_tbl_type
145: := cn_plan_element_pub.g_miss_rt_quota_asgns_rec_tbl,
146: x_loading_status OUT NOCOPY VARCHAR2
147: );
148: END CN_RT_QUOTA_ASGNS_PVT;