DBA Data[Home] [Help]

APPS.CN_RT_QUOTA_ASGNS_PVT dependencies on CN_RT_QUOTA_ASGNS

Line 1: PACKAGE CN_RT_QUOTA_ASGNS_PVT AUTHID CURRENT_USER AS

1: PACKAGE CN_RT_QUOTA_ASGNS_PVT AUTHID CURRENT_USER AS
2: /* $Header: cnxvrqas.pls 120.1.12020000.2 2013/01/25 09:00:23 ndamala ship $ */
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: calc_formula_id cn_rt_quota_asgns.calc_formula_id%type:=NULL

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: calc_formula_id cn_rt_quota_asgns.calc_formula_id%type:=NULL
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: calc_formula_id cn_rt_quota_asgns.calc_formula_id%type:=NULL
17: );
18:
19: --

Line 16: calc_formula_id cn_rt_quota_asgns.calc_formula_id%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: calc_formula_id cn_rt_quota_asgns.calc_formula_id%type:=NULL
17: );
18:
19: --
20: -- User Defined Quota Rules Record Table Type

Line 149: END CN_RT_QUOTA_ASGNS_PVT;

145: p_rt_quota_asgns_rec_tbl IN cn_plan_element_pub.rt_quota_asgns_rec_tbl_type
146: := cn_plan_element_pub.g_miss_rt_quota_asgns_rec_tbl,
147: x_loading_status OUT NOCOPY VARCHAR2
148: );
149: END CN_RT_QUOTA_ASGNS_PVT;