DBA Data[Home] [Help]

APPS.CN_QUOTA_RULE_UPLIFTS_GRP dependencies on CN_QUOTA_RULE_UPLIFTS

Line 1: PACKAGE cn_quota_rule_uplifts_grp AS

1: PACKAGE cn_quota_rule_uplifts_grp AS
2: /* $Header: cnxgqrus.pls 120.2 2005/09/09 17:57:56 sbadami ship $ */
3: TYPE uplift_date_seq_rec_type IS RECORD (
4: start_date cn_quota_rule_uplifts.start_date%TYPE := NULL,
5: start_date_old cn_quota_rule_uplifts.start_date%TYPE := NULL,

Line 4: start_date cn_quota_rule_uplifts.start_date%TYPE := NULL,

1: PACKAGE cn_quota_rule_uplifts_grp AS
2: /* $Header: cnxgqrus.pls 120.2 2005/09/09 17:57:56 sbadami ship $ */
3: TYPE uplift_date_seq_rec_type IS RECORD (
4: start_date cn_quota_rule_uplifts.start_date%TYPE := NULL,
5: start_date_old cn_quota_rule_uplifts.start_date%TYPE := NULL,
6: end_date cn_quota_rule_uplifts.end_date%TYPE := NULL,
7: end_date_old cn_quota_rule_uplifts.end_date%TYPE := NULL,
8: quota_rule_id cn_quota_rule_uplifts.quota_rule_id%TYPE := NULL,

Line 5: start_date_old cn_quota_rule_uplifts.start_date%TYPE := NULL,

1: PACKAGE cn_quota_rule_uplifts_grp AS
2: /* $Header: cnxgqrus.pls 120.2 2005/09/09 17:57:56 sbadami ship $ */
3: TYPE uplift_date_seq_rec_type IS RECORD (
4: start_date cn_quota_rule_uplifts.start_date%TYPE := NULL,
5: start_date_old cn_quota_rule_uplifts.start_date%TYPE := NULL,
6: end_date cn_quota_rule_uplifts.end_date%TYPE := NULL,
7: end_date_old cn_quota_rule_uplifts.end_date%TYPE := NULL,
8: quota_rule_id cn_quota_rule_uplifts.quota_rule_id%TYPE := NULL,
9: quota_rule_uplift_id cn_quota_rule_uplifts.quota_rule_uplift_id%TYPE := NULL

Line 6: end_date cn_quota_rule_uplifts.end_date%TYPE := NULL,

2: /* $Header: cnxgqrus.pls 120.2 2005/09/09 17:57:56 sbadami ship $ */
3: TYPE uplift_date_seq_rec_type IS RECORD (
4: start_date cn_quota_rule_uplifts.start_date%TYPE := NULL,
5: start_date_old cn_quota_rule_uplifts.start_date%TYPE := NULL,
6: end_date cn_quota_rule_uplifts.end_date%TYPE := NULL,
7: end_date_old cn_quota_rule_uplifts.end_date%TYPE := NULL,
8: quota_rule_id cn_quota_rule_uplifts.quota_rule_id%TYPE := NULL,
9: quota_rule_uplift_id cn_quota_rule_uplifts.quota_rule_uplift_id%TYPE := NULL
10: );

Line 7: end_date_old cn_quota_rule_uplifts.end_date%TYPE := NULL,

3: TYPE uplift_date_seq_rec_type IS RECORD (
4: start_date cn_quota_rule_uplifts.start_date%TYPE := NULL,
5: start_date_old cn_quota_rule_uplifts.start_date%TYPE := NULL,
6: end_date cn_quota_rule_uplifts.end_date%TYPE := NULL,
7: end_date_old cn_quota_rule_uplifts.end_date%TYPE := NULL,
8: quota_rule_id cn_quota_rule_uplifts.quota_rule_id%TYPE := NULL,
9: quota_rule_uplift_id cn_quota_rule_uplifts.quota_rule_uplift_id%TYPE := NULL
10: );
11:

Line 8: quota_rule_id cn_quota_rule_uplifts.quota_rule_id%TYPE := NULL,

4: start_date cn_quota_rule_uplifts.start_date%TYPE := NULL,
5: start_date_old cn_quota_rule_uplifts.start_date%TYPE := NULL,
6: end_date cn_quota_rule_uplifts.end_date%TYPE := NULL,
7: end_date_old cn_quota_rule_uplifts.end_date%TYPE := NULL,
8: quota_rule_id cn_quota_rule_uplifts.quota_rule_id%TYPE := NULL,
9: quota_rule_uplift_id cn_quota_rule_uplifts.quota_rule_uplift_id%TYPE := NULL
10: );
11:
12: --

Line 9: quota_rule_uplift_id cn_quota_rule_uplifts.quota_rule_uplift_id%TYPE := NULL

5: start_date_old cn_quota_rule_uplifts.start_date%TYPE := NULL,
6: end_date cn_quota_rule_uplifts.end_date%TYPE := NULL,
7: end_date_old cn_quota_rule_uplifts.end_date%TYPE := NULL,
8: quota_rule_id cn_quota_rule_uplifts.quota_rule_id%TYPE := NULL,
9: quota_rule_uplift_id cn_quota_rule_uplifts.quota_rule_uplift_id%TYPE := NULL
10: );
11:
12: --
13: -- User Defined Quota Rules Record Table Type

Line 23: -- Usage : Used to create entry into cn_quota_rule_uplifts

19:
20: -- API name : Create_Quota_Rule_uplifts
21: -- Type : Group.
22: -- Pre-reqs : None.
23: -- Usage : Used to create entry into cn_quota_rule_uplifts
24: --
25: -- Desc group package can be called from any where from the oracle apps
26: -- currenly it is called from oracle forms and the public package
27: -- Plan Element public package

Line 67: -- Usage : Used to update the cn_quota_rule_uplifts

63:
64: -- API name : Update_Quota_Rule_uplifts
65: -- Type : Group.
66: -- Pre-reqs : None.
67: -- Usage : Used to update the cn_quota_rule_uplifts
68: --
69: -- Desc
70: --
71: -- Parameters :

Line 110: -- Usage : Used to delete a record from cn_quota_rule_uplifts

106:
107: -- API name : Delete_Quota_Rule_uplifts
108: -- Type : Group.
109: -- Pre-reqs : None.
110: -- Usage : Used to delete a record from cn_quota_rule_uplifts
111: --
112: -- Desc
113: --
114: -- Parameters :

Line 149: END cn_quota_rule_uplifts_grp;

145: p_quota_name IN VARCHAR2,
146: p_rev_uplift_rec_tbl IN OUT NOCOPY cn_quota_rule_uplift_pvt.quota_rule_uplift_tbl_type,
147: x_loading_status OUT NOCOPY VARCHAR2
148: );
149: END cn_quota_rule_uplifts_grp;