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