DBA Data[Home] [Help]

APPS.CN_RT_QUOTA_ASGNS_PVT dependencies on CN_RT_QUOTA_ASGNS

Line 1: PACKAGE CN_RT_QUOTA_ASGNS_PVT AS

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:

Line 8: start_date cn_rt_quota_asgns.start_date%TYPE := NULL,

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,

Line 9: start_date_old cn_rt_quota_asgns.start_date%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

Line 10: end_date cn_rt_quota_asgns.end_date%TYPE := NULL,

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,

Line 11: end_date_old cn_rt_quota_asgns.end_date%TYPE := 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

Line 12: quota_id cn_rt_quota_asgns.quota_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: );

Line 13: rt_quota_asgn_id cn_rt_quota_asgns.rt_quota_asgn_id%TYPE

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:

Line 15: org_id cn_rt_quota_asgns.org_id%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:
18: --
19: -- User Defined Quota Rules Record Table Type

Line 148: END CN_RT_QUOTA_ASGNS_PVT;

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;