eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_ROLE_PLANS_PUB dependencies on CN_ROLE_PLANS

Line 1: PACKAGE CN_ROLE_PLANS_PUB AUTHID CURRENT_USER AS

1: PACKAGE CN_ROLE_PLANS_PUB AUTHID CURRENT_USER AS
2: /* $Header: cnprlpls.pls 120.1 2005/07/08 04:42:00 appldev ship $ */
3: /*#
4: * There are three APIs for CN_ROLE_PLANS_PUB.
5: * Create Role Plans: This procedure creates a Role-Plan Assignment. Records are inserted into cn_role_plans.

Line 4: * There are three APIs for CN_ROLE_PLANS_PUB.

1: PACKAGE CN_ROLE_PLANS_PUB AUTHID CURRENT_USER AS
2: /* $Header: cnprlpls.pls 120.1 2005/07/08 04:42:00 appldev ship $ */
3: /*#
4: * There are three APIs for CN_ROLE_PLANS_PUB.
5: * Create Role Plans: This procedure creates a Role-Plan Assignment. Records are inserted into cn_role_plans.
6: * There is a call to procedure cn_srp_plan_assign_pvt.create_srp_plan_assigns. This inserts records into
7: * cn_srp_plan_Assigns for all salesreps with the role. This results in records being created in
8: * cn_srp_quota_assigns, cn_srp_period_quotas, cn_Srp_periods, cn_srp_rollover_quotas(if exists),

Line 5: * Create Role Plans: This procedure creates a Role-Plan Assignment. Records are inserted into cn_role_plans.

1: PACKAGE CN_ROLE_PLANS_PUB AUTHID CURRENT_USER AS
2: /* $Header: cnprlpls.pls 120.1 2005/07/08 04:42:00 appldev ship $ */
3: /*#
4: * There are three APIs for CN_ROLE_PLANS_PUB.
5: * Create Role Plans: This procedure creates a Role-Plan Assignment. Records are inserted into cn_role_plans.
6: * There is a call to procedure cn_srp_plan_assign_pvt.create_srp_plan_assigns. This inserts records into
7: * cn_srp_plan_Assigns for all salesreps with the role. This results in records being created in
8: * cn_srp_quota_assigns, cn_srp_period_quotas, cn_Srp_periods, cn_srp_rollover_quotas(if exists),
9: * cn_srp_quota_rules, and cn_srp_rate_assigns.

Line 11: * Update Role Plans: This procedure updates Role-Plan Assignment. Records are updated in cn_role_plans.

7: * cn_srp_plan_Assigns for all salesreps with the role. This results in records being created in
8: * cn_srp_quota_assigns, cn_srp_period_quotas, cn_Srp_periods, cn_srp_rollover_quotas(if exists),
9: * cn_srp_quota_rules, and cn_srp_rate_assigns.
10: *
11: * Update Role Plans: This procedure updates Role-Plan Assignment. Records are updated in cn_role_plans.
12: * There is a call to procedure .cn_srp_plan_assign_pvt.update_srp_plan_assigns. This results in update to
13: * cn_srp_quota_assigns, cn_srp_rate_tiers, cn_srp_periods, cn_srp_rollover, quotas.
14: *
15: * Delete Role Plans: This procedure deletes the Role-Plan assignment from cn_role_plans. This results in records being deleted from cn_srp_plan_assigns, cn_srp_quota_Assigns, and cn_srp_rate_tiers.

Line 15: * Delete Role Plans: This procedure deletes the Role-Plan assignment from cn_role_plans. This results in records being deleted from cn_srp_plan_assigns, cn_srp_quota_Assigns, and cn_srp_rate_tiers.

11: * Update Role Plans: This procedure updates Role-Plan Assignment. Records are updated in cn_role_plans.
12: * There is a call to procedure .cn_srp_plan_assign_pvt.update_srp_plan_assigns. This results in update to
13: * cn_srp_quota_assigns, cn_srp_rate_tiers, cn_srp_periods, cn_srp_rollover, quotas.
14: *
15: * Delete Role Plans: This procedure deletes the Role-Plan assignment from cn_role_plans. This results in records being deleted from cn_srp_plan_assigns, cn_srp_quota_Assigns, and cn_srp_rate_tiers.
16: * @rep:scope public
17: * @rep:product CN
18: * @rep:displayname Role to Compensation Plan Assignment
19: * @rep:lifecycle active

Line 32: role_id cn_role_plans.role_id%TYPE := NULL,

28:
29: TYPE role_plan_rec_type IS RECORD
30: (
31: role_name cn_roles.name%TYPE := cn_api.G_MISS_CHAR,
32: role_id cn_role_plans.role_id%TYPE := NULL,
33: comp_plan_name cn_comp_plans.name%TYPE := cn_api.G_MISS_CHAR,
34: comp_plan_id cn_role_plans.comp_plan_id%TYPE := NULL,
35: start_date cn_role_plans.start_date%TYPE := cn_api.G_MISS_DATE,
36: end_date cn_role_plans.end_date%TYPE := cn_api.G_MISS_DATE,

Line 34: comp_plan_id cn_role_plans.comp_plan_id%TYPE := NULL,

30: (
31: role_name cn_roles.name%TYPE := cn_api.G_MISS_CHAR,
32: role_id cn_role_plans.role_id%TYPE := NULL,
33: comp_plan_name cn_comp_plans.name%TYPE := cn_api.G_MISS_CHAR,
34: comp_plan_id cn_role_plans.comp_plan_id%TYPE := NULL,
35: start_date cn_role_plans.start_date%TYPE := cn_api.G_MISS_DATE,
36: end_date cn_role_plans.end_date%TYPE := cn_api.G_MISS_DATE,
37: attribute_category cn_role_plans.attribute_category%TYPE := cn_api.G_MISS_CHAR,
38: attribute1 cn_role_plans.attribute1%TYPE := cn_api.G_MISS_CHAR,

Line 35: start_date cn_role_plans.start_date%TYPE := cn_api.G_MISS_DATE,

31: role_name cn_roles.name%TYPE := cn_api.G_MISS_CHAR,
32: role_id cn_role_plans.role_id%TYPE := NULL,
33: comp_plan_name cn_comp_plans.name%TYPE := cn_api.G_MISS_CHAR,
34: comp_plan_id cn_role_plans.comp_plan_id%TYPE := NULL,
35: start_date cn_role_plans.start_date%TYPE := cn_api.G_MISS_DATE,
36: end_date cn_role_plans.end_date%TYPE := cn_api.G_MISS_DATE,
37: attribute_category cn_role_plans.attribute_category%TYPE := cn_api.G_MISS_CHAR,
38: attribute1 cn_role_plans.attribute1%TYPE := cn_api.G_MISS_CHAR,
39: attribute2 cn_role_plans.attribute2%TYPE := cn_api.G_MISS_CHAR,

Line 36: end_date cn_role_plans.end_date%TYPE := cn_api.G_MISS_DATE,

32: role_id cn_role_plans.role_id%TYPE := NULL,
33: comp_plan_name cn_comp_plans.name%TYPE := cn_api.G_MISS_CHAR,
34: comp_plan_id cn_role_plans.comp_plan_id%TYPE := NULL,
35: start_date cn_role_plans.start_date%TYPE := cn_api.G_MISS_DATE,
36: end_date cn_role_plans.end_date%TYPE := cn_api.G_MISS_DATE,
37: attribute_category cn_role_plans.attribute_category%TYPE := cn_api.G_MISS_CHAR,
38: attribute1 cn_role_plans.attribute1%TYPE := cn_api.G_MISS_CHAR,
39: attribute2 cn_role_plans.attribute2%TYPE := cn_api.G_MISS_CHAR,
40: attribute3 cn_role_plans.attribute3%TYPE := cn_api.G_MISS_CHAR,

Line 37: attribute_category cn_role_plans.attribute_category%TYPE := cn_api.G_MISS_CHAR,

33: comp_plan_name cn_comp_plans.name%TYPE := cn_api.G_MISS_CHAR,
34: comp_plan_id cn_role_plans.comp_plan_id%TYPE := NULL,
35: start_date cn_role_plans.start_date%TYPE := cn_api.G_MISS_DATE,
36: end_date cn_role_plans.end_date%TYPE := cn_api.G_MISS_DATE,
37: attribute_category cn_role_plans.attribute_category%TYPE := cn_api.G_MISS_CHAR,
38: attribute1 cn_role_plans.attribute1%TYPE := cn_api.G_MISS_CHAR,
39: attribute2 cn_role_plans.attribute2%TYPE := cn_api.G_MISS_CHAR,
40: attribute3 cn_role_plans.attribute3%TYPE := cn_api.G_MISS_CHAR,
41: attribute4 cn_role_plans.attribute4%TYPE := cn_api.G_MISS_CHAR,

Line 38: attribute1 cn_role_plans.attribute1%TYPE := cn_api.G_MISS_CHAR,

34: comp_plan_id cn_role_plans.comp_plan_id%TYPE := NULL,
35: start_date cn_role_plans.start_date%TYPE := cn_api.G_MISS_DATE,
36: end_date cn_role_plans.end_date%TYPE := cn_api.G_MISS_DATE,
37: attribute_category cn_role_plans.attribute_category%TYPE := cn_api.G_MISS_CHAR,
38: attribute1 cn_role_plans.attribute1%TYPE := cn_api.G_MISS_CHAR,
39: attribute2 cn_role_plans.attribute2%TYPE := cn_api.G_MISS_CHAR,
40: attribute3 cn_role_plans.attribute3%TYPE := cn_api.G_MISS_CHAR,
41: attribute4 cn_role_plans.attribute4%TYPE := cn_api.G_MISS_CHAR,
42: attribute5 cn_role_plans.attribute5%TYPE := cn_api.G_MISS_CHAR,

Line 39: attribute2 cn_role_plans.attribute2%TYPE := cn_api.G_MISS_CHAR,

35: start_date cn_role_plans.start_date%TYPE := cn_api.G_MISS_DATE,
36: end_date cn_role_plans.end_date%TYPE := cn_api.G_MISS_DATE,
37: attribute_category cn_role_plans.attribute_category%TYPE := cn_api.G_MISS_CHAR,
38: attribute1 cn_role_plans.attribute1%TYPE := cn_api.G_MISS_CHAR,
39: attribute2 cn_role_plans.attribute2%TYPE := cn_api.G_MISS_CHAR,
40: attribute3 cn_role_plans.attribute3%TYPE := cn_api.G_MISS_CHAR,
41: attribute4 cn_role_plans.attribute4%TYPE := cn_api.G_MISS_CHAR,
42: attribute5 cn_role_plans.attribute5%TYPE := cn_api.G_MISS_CHAR,
43: attribute6 cn_role_plans.attribute6%TYPE := cn_api.G_MISS_CHAR,

Line 40: attribute3 cn_role_plans.attribute3%TYPE := cn_api.G_MISS_CHAR,

36: end_date cn_role_plans.end_date%TYPE := cn_api.G_MISS_DATE,
37: attribute_category cn_role_plans.attribute_category%TYPE := cn_api.G_MISS_CHAR,
38: attribute1 cn_role_plans.attribute1%TYPE := cn_api.G_MISS_CHAR,
39: attribute2 cn_role_plans.attribute2%TYPE := cn_api.G_MISS_CHAR,
40: attribute3 cn_role_plans.attribute3%TYPE := cn_api.G_MISS_CHAR,
41: attribute4 cn_role_plans.attribute4%TYPE := cn_api.G_MISS_CHAR,
42: attribute5 cn_role_plans.attribute5%TYPE := cn_api.G_MISS_CHAR,
43: attribute6 cn_role_plans.attribute6%TYPE := cn_api.G_MISS_CHAR,
44: attribute7 cn_role_plans.attribute7%TYPE := cn_api.G_MISS_CHAR,

Line 41: attribute4 cn_role_plans.attribute4%TYPE := cn_api.G_MISS_CHAR,

37: attribute_category cn_role_plans.attribute_category%TYPE := cn_api.G_MISS_CHAR,
38: attribute1 cn_role_plans.attribute1%TYPE := cn_api.G_MISS_CHAR,
39: attribute2 cn_role_plans.attribute2%TYPE := cn_api.G_MISS_CHAR,
40: attribute3 cn_role_plans.attribute3%TYPE := cn_api.G_MISS_CHAR,
41: attribute4 cn_role_plans.attribute4%TYPE := cn_api.G_MISS_CHAR,
42: attribute5 cn_role_plans.attribute5%TYPE := cn_api.G_MISS_CHAR,
43: attribute6 cn_role_plans.attribute6%TYPE := cn_api.G_MISS_CHAR,
44: attribute7 cn_role_plans.attribute7%TYPE := cn_api.G_MISS_CHAR,
45: attribute8 cn_role_plans.attribute8%TYPE := cn_api.G_MISS_CHAR,

Line 42: attribute5 cn_role_plans.attribute5%TYPE := cn_api.G_MISS_CHAR,

38: attribute1 cn_role_plans.attribute1%TYPE := cn_api.G_MISS_CHAR,
39: attribute2 cn_role_plans.attribute2%TYPE := cn_api.G_MISS_CHAR,
40: attribute3 cn_role_plans.attribute3%TYPE := cn_api.G_MISS_CHAR,
41: attribute4 cn_role_plans.attribute4%TYPE := cn_api.G_MISS_CHAR,
42: attribute5 cn_role_plans.attribute5%TYPE := cn_api.G_MISS_CHAR,
43: attribute6 cn_role_plans.attribute6%TYPE := cn_api.G_MISS_CHAR,
44: attribute7 cn_role_plans.attribute7%TYPE := cn_api.G_MISS_CHAR,
45: attribute8 cn_role_plans.attribute8%TYPE := cn_api.G_MISS_CHAR,
46: attribute9 cn_role_plans.attribute9%TYPE := cn_api.G_MISS_CHAR,

Line 43: attribute6 cn_role_plans.attribute6%TYPE := cn_api.G_MISS_CHAR,

39: attribute2 cn_role_plans.attribute2%TYPE := cn_api.G_MISS_CHAR,
40: attribute3 cn_role_plans.attribute3%TYPE := cn_api.G_MISS_CHAR,
41: attribute4 cn_role_plans.attribute4%TYPE := cn_api.G_MISS_CHAR,
42: attribute5 cn_role_plans.attribute5%TYPE := cn_api.G_MISS_CHAR,
43: attribute6 cn_role_plans.attribute6%TYPE := cn_api.G_MISS_CHAR,
44: attribute7 cn_role_plans.attribute7%TYPE := cn_api.G_MISS_CHAR,
45: attribute8 cn_role_plans.attribute8%TYPE := cn_api.G_MISS_CHAR,
46: attribute9 cn_role_plans.attribute9%TYPE := cn_api.G_MISS_CHAR,
47: attribute10 cn_role_plans.attribute10%TYPE := cn_api.G_MISS_CHAR,

Line 44: attribute7 cn_role_plans.attribute7%TYPE := cn_api.G_MISS_CHAR,

40: attribute3 cn_role_plans.attribute3%TYPE := cn_api.G_MISS_CHAR,
41: attribute4 cn_role_plans.attribute4%TYPE := cn_api.G_MISS_CHAR,
42: attribute5 cn_role_plans.attribute5%TYPE := cn_api.G_MISS_CHAR,
43: attribute6 cn_role_plans.attribute6%TYPE := cn_api.G_MISS_CHAR,
44: attribute7 cn_role_plans.attribute7%TYPE := cn_api.G_MISS_CHAR,
45: attribute8 cn_role_plans.attribute8%TYPE := cn_api.G_MISS_CHAR,
46: attribute9 cn_role_plans.attribute9%TYPE := cn_api.G_MISS_CHAR,
47: attribute10 cn_role_plans.attribute10%TYPE := cn_api.G_MISS_CHAR,
48: attribute11 cn_role_plans.attribute11%TYPE := cn_api.G_MISS_CHAR,

Line 45: attribute8 cn_role_plans.attribute8%TYPE := cn_api.G_MISS_CHAR,

41: attribute4 cn_role_plans.attribute4%TYPE := cn_api.G_MISS_CHAR,
42: attribute5 cn_role_plans.attribute5%TYPE := cn_api.G_MISS_CHAR,
43: attribute6 cn_role_plans.attribute6%TYPE := cn_api.G_MISS_CHAR,
44: attribute7 cn_role_plans.attribute7%TYPE := cn_api.G_MISS_CHAR,
45: attribute8 cn_role_plans.attribute8%TYPE := cn_api.G_MISS_CHAR,
46: attribute9 cn_role_plans.attribute9%TYPE := cn_api.G_MISS_CHAR,
47: attribute10 cn_role_plans.attribute10%TYPE := cn_api.G_MISS_CHAR,
48: attribute11 cn_role_plans.attribute11%TYPE := cn_api.G_MISS_CHAR,
49: attribute12 cn_role_plans.attribute12%TYPE := cn_api.G_MISS_CHAR,

Line 46: attribute9 cn_role_plans.attribute9%TYPE := cn_api.G_MISS_CHAR,

42: attribute5 cn_role_plans.attribute5%TYPE := cn_api.G_MISS_CHAR,
43: attribute6 cn_role_plans.attribute6%TYPE := cn_api.G_MISS_CHAR,
44: attribute7 cn_role_plans.attribute7%TYPE := cn_api.G_MISS_CHAR,
45: attribute8 cn_role_plans.attribute8%TYPE := cn_api.G_MISS_CHAR,
46: attribute9 cn_role_plans.attribute9%TYPE := cn_api.G_MISS_CHAR,
47: attribute10 cn_role_plans.attribute10%TYPE := cn_api.G_MISS_CHAR,
48: attribute11 cn_role_plans.attribute11%TYPE := cn_api.G_MISS_CHAR,
49: attribute12 cn_role_plans.attribute12%TYPE := cn_api.G_MISS_CHAR,
50: attribute13 cn_role_plans.attribute13%TYPE := cn_api.G_MISS_CHAR,

Line 47: attribute10 cn_role_plans.attribute10%TYPE := cn_api.G_MISS_CHAR,

43: attribute6 cn_role_plans.attribute6%TYPE := cn_api.G_MISS_CHAR,
44: attribute7 cn_role_plans.attribute7%TYPE := cn_api.G_MISS_CHAR,
45: attribute8 cn_role_plans.attribute8%TYPE := cn_api.G_MISS_CHAR,
46: attribute9 cn_role_plans.attribute9%TYPE := cn_api.G_MISS_CHAR,
47: attribute10 cn_role_plans.attribute10%TYPE := cn_api.G_MISS_CHAR,
48: attribute11 cn_role_plans.attribute11%TYPE := cn_api.G_MISS_CHAR,
49: attribute12 cn_role_plans.attribute12%TYPE := cn_api.G_MISS_CHAR,
50: attribute13 cn_role_plans.attribute13%TYPE := cn_api.G_MISS_CHAR,
51: attribute14 cn_role_plans.attribute14%TYPE := cn_api.G_MISS_CHAR,

Line 48: attribute11 cn_role_plans.attribute11%TYPE := cn_api.G_MISS_CHAR,

44: attribute7 cn_role_plans.attribute7%TYPE := cn_api.G_MISS_CHAR,
45: attribute8 cn_role_plans.attribute8%TYPE := cn_api.G_MISS_CHAR,
46: attribute9 cn_role_plans.attribute9%TYPE := cn_api.G_MISS_CHAR,
47: attribute10 cn_role_plans.attribute10%TYPE := cn_api.G_MISS_CHAR,
48: attribute11 cn_role_plans.attribute11%TYPE := cn_api.G_MISS_CHAR,
49: attribute12 cn_role_plans.attribute12%TYPE := cn_api.G_MISS_CHAR,
50: attribute13 cn_role_plans.attribute13%TYPE := cn_api.G_MISS_CHAR,
51: attribute14 cn_role_plans.attribute14%TYPE := cn_api.G_MISS_CHAR,
52: attribute15 cn_role_plans.attribute15%TYPE := cn_api.G_MISS_CHAR,

Line 49: attribute12 cn_role_plans.attribute12%TYPE := cn_api.G_MISS_CHAR,

45: attribute8 cn_role_plans.attribute8%TYPE := cn_api.G_MISS_CHAR,
46: attribute9 cn_role_plans.attribute9%TYPE := cn_api.G_MISS_CHAR,
47: attribute10 cn_role_plans.attribute10%TYPE := cn_api.G_MISS_CHAR,
48: attribute11 cn_role_plans.attribute11%TYPE := cn_api.G_MISS_CHAR,
49: attribute12 cn_role_plans.attribute12%TYPE := cn_api.G_MISS_CHAR,
50: attribute13 cn_role_plans.attribute13%TYPE := cn_api.G_MISS_CHAR,
51: attribute14 cn_role_plans.attribute14%TYPE := cn_api.G_MISS_CHAR,
52: attribute15 cn_role_plans.attribute15%TYPE := cn_api.G_MISS_CHAR,
53: object_version_number cn_role_plans.object_version_number%TYPE := NULL,

Line 50: attribute13 cn_role_plans.attribute13%TYPE := cn_api.G_MISS_CHAR,

46: attribute9 cn_role_plans.attribute9%TYPE := cn_api.G_MISS_CHAR,
47: attribute10 cn_role_plans.attribute10%TYPE := cn_api.G_MISS_CHAR,
48: attribute11 cn_role_plans.attribute11%TYPE := cn_api.G_MISS_CHAR,
49: attribute12 cn_role_plans.attribute12%TYPE := cn_api.G_MISS_CHAR,
50: attribute13 cn_role_plans.attribute13%TYPE := cn_api.G_MISS_CHAR,
51: attribute14 cn_role_plans.attribute14%TYPE := cn_api.G_MISS_CHAR,
52: attribute15 cn_role_plans.attribute15%TYPE := cn_api.G_MISS_CHAR,
53: object_version_number cn_role_plans.object_version_number%TYPE := NULL,
54: org_id cn_role_plans.org_id%TYPE := NULL

Line 51: attribute14 cn_role_plans.attribute14%TYPE := cn_api.G_MISS_CHAR,

47: attribute10 cn_role_plans.attribute10%TYPE := cn_api.G_MISS_CHAR,
48: attribute11 cn_role_plans.attribute11%TYPE := cn_api.G_MISS_CHAR,
49: attribute12 cn_role_plans.attribute12%TYPE := cn_api.G_MISS_CHAR,
50: attribute13 cn_role_plans.attribute13%TYPE := cn_api.G_MISS_CHAR,
51: attribute14 cn_role_plans.attribute14%TYPE := cn_api.G_MISS_CHAR,
52: attribute15 cn_role_plans.attribute15%TYPE := cn_api.G_MISS_CHAR,
53: object_version_number cn_role_plans.object_version_number%TYPE := NULL,
54: org_id cn_role_plans.org_id%TYPE := NULL
55:

Line 52: attribute15 cn_role_plans.attribute15%TYPE := cn_api.G_MISS_CHAR,

48: attribute11 cn_role_plans.attribute11%TYPE := cn_api.G_MISS_CHAR,
49: attribute12 cn_role_plans.attribute12%TYPE := cn_api.G_MISS_CHAR,
50: attribute13 cn_role_plans.attribute13%TYPE := cn_api.G_MISS_CHAR,
51: attribute14 cn_role_plans.attribute14%TYPE := cn_api.G_MISS_CHAR,
52: attribute15 cn_role_plans.attribute15%TYPE := cn_api.G_MISS_CHAR,
53: object_version_number cn_role_plans.object_version_number%TYPE := NULL,
54: org_id cn_role_plans.org_id%TYPE := NULL
55:
56: );

Line 53: object_version_number cn_role_plans.object_version_number%TYPE := NULL,

49: attribute12 cn_role_plans.attribute12%TYPE := cn_api.G_MISS_CHAR,
50: attribute13 cn_role_plans.attribute13%TYPE := cn_api.G_MISS_CHAR,
51: attribute14 cn_role_plans.attribute14%TYPE := cn_api.G_MISS_CHAR,
52: attribute15 cn_role_plans.attribute15%TYPE := cn_api.G_MISS_CHAR,
53: object_version_number cn_role_plans.object_version_number%TYPE := NULL,
54: org_id cn_role_plans.org_id%TYPE := NULL
55:
56: );
57:

Line 54: org_id cn_role_plans.org_id%TYPE := NULL

50: attribute13 cn_role_plans.attribute13%TYPE := cn_api.G_MISS_CHAR,
51: attribute14 cn_role_plans.attribute14%TYPE := cn_api.G_MISS_CHAR,
52: attribute15 cn_role_plans.attribute15%TYPE := cn_api.G_MISS_CHAR,
53: object_version_number cn_role_plans.object_version_number%TYPE := NULL,
54: org_id cn_role_plans.org_id%TYPE := NULL
55:
56: );
57:
58: --

Line 168: -- Notes : 1. Old role_plan_id must be found in cn_role_plans.

164: -- Version : Current version 1.0
165: -- Initial version 1.0
166: --
167: -- Description : This procedure is used to update a sales role and comp plan assignment.
168: -- Notes : 1. Old role_plan_id must be found in cn_role_plans.
169: -- 2. New role name can not be null.
170: -- 3. New comp plan name can not be null.
171: -- 4. New start date can not be null.
172: -- 5. New start date <= new end date if new end date is not null.

Line 211: p_ovn IN OUT NOCOPY cn_role_plans.object_version_number%TYPE,

207: x_loading_status OUT NOCOPY VARCHAR2 ,
208: x_msg_count OUT NOCOPY NUMBER ,
209: x_msg_data OUT NOCOPY VARCHAR2 ,
210: p_role_plan_rec_old IN role_plan_rec_type := G_MISS_ROLE_PLAN_REC,
211: p_ovn IN OUT NOCOPY cn_role_plans.object_version_number%TYPE,
212: p_role_plan_rec_new IN role_plan_rec_type := G_MISS_ROLE_PLAN_REC,
213: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE
214: );
215:

Line 213: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE

209: x_msg_data OUT NOCOPY VARCHAR2 ,
210: p_role_plan_rec_old IN role_plan_rec_type := G_MISS_ROLE_PLAN_REC,
211: p_ovn IN OUT NOCOPY cn_role_plans.object_version_number%TYPE,
212: p_role_plan_rec_new IN role_plan_rec_type := G_MISS_ROLE_PLAN_REC,
213: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE
214: );
215:
216:
217:

Line 274: END CN_ROLE_PLANS_PUB;

270: x_msg_data OUT NOCOPY VARCHAR2 ,
271: p_role_plan_rec IN role_plan_rec_type := G_MISS_ROLE_PLAN_REC
272: );
273:
274: END CN_ROLE_PLANS_PUB;