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_SRP_PAYOUT_DTLS_PKG dependencies on CN_SRP_PAYOUT_DTLS

Line 1: PACKAGE BODY CN_SRP_PAYOUT_DTLS_PKG AS

1: PACKAGE BODY CN_SRP_PAYOUT_DTLS_PKG AS
2: /*$Header: cntmdtlb.pls 115.0 2003/08/25 21:47:57 nkodkani noship $*/
3:
4: PROCEDURE insert_row
5: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,

Line 5: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,

1: PACKAGE BODY CN_SRP_PAYOUT_DTLS_PKG AS
2: /*$Header: cntmdtlb.pls 115.0 2003/08/25 21:47:57 nkodkani noship $*/
3:
4: PROCEDURE insert_row
5: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
6: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
7: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE := NULL,
8: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
9: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,

Line 6: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,

2: /*$Header: cntmdtlb.pls 115.0 2003/08/25 21:47:57 nkodkani noship $*/
3:
4: PROCEDURE insert_row
5: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
6: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
7: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE := NULL,
8: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
9: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
10: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,

Line 7: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE := NULL,

3:
4: PROCEDURE insert_row
5: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
6: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
7: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE := NULL,
8: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
9: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
10: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
11: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,

Line 8: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,

4: PROCEDURE insert_row
5: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
6: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
7: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE := NULL,
8: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
9: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
10: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
11: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
12: p_percent IN cn_srp_payout_dtls.percent%TYPE,

Line 9: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,

5: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
6: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
7: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE := NULL,
8: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
9: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
10: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
11: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
12: p_percent IN cn_srp_payout_dtls.percent%TYPE,
13: p_payout IN cn_srp_payout_dtls.payout%TYPE,

Line 10: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,

6: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
7: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE := NULL,
8: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
9: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
10: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
11: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
12: p_percent IN cn_srp_payout_dtls.percent%TYPE,
13: p_payout IN cn_srp_payout_dtls.payout%TYPE,
14: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,

Line 11: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,

7: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE := NULL,
8: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
9: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
10: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
11: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
12: p_percent IN cn_srp_payout_dtls.percent%TYPE,
13: p_payout IN cn_srp_payout_dtls.payout%TYPE,
14: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
15: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,

Line 12: p_percent IN cn_srp_payout_dtls.percent%TYPE,

8: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
9: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
10: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
11: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
12: p_percent IN cn_srp_payout_dtls.percent%TYPE,
13: p_payout IN cn_srp_payout_dtls.payout%TYPE,
14: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
15: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
16: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,

Line 13: p_payout IN cn_srp_payout_dtls.payout%TYPE,

9: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
10: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
11: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
12: p_percent IN cn_srp_payout_dtls.percent%TYPE,
13: p_payout IN cn_srp_payout_dtls.payout%TYPE,
14: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
15: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
16: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
17: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,

Line 14: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,

10: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
11: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
12: p_percent IN cn_srp_payout_dtls.percent%TYPE,
13: p_payout IN cn_srp_payout_dtls.payout%TYPE,
14: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
15: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
16: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
17: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
18: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,

Line 15: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,

11: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
12: p_percent IN cn_srp_payout_dtls.percent%TYPE,
13: p_payout IN cn_srp_payout_dtls.payout%TYPE,
14: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
15: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
16: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
17: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
18: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
19: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,

Line 16: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,

12: p_percent IN cn_srp_payout_dtls.percent%TYPE,
13: p_payout IN cn_srp_payout_dtls.payout%TYPE,
14: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
15: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
16: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
17: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
18: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
19: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
20: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,

Line 17: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,

13: p_payout IN cn_srp_payout_dtls.payout%TYPE,
14: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
15: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
16: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
17: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
18: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
19: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
20: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
21: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,

Line 18: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,

14: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
15: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
16: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
17: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
18: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
19: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
20: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
21: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
22: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,

Line 19: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,

15: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
16: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
17: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
18: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
19: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
20: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
21: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
22: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
23: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,

Line 20: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,

16: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
17: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
18: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
19: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
20: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
21: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
22: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
23: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
24: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,

Line 21: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,

17: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
18: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
19: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
20: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
21: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
22: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
23: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
24: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
25: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,

Line 22: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,

18: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
19: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
20: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
21: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
22: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
23: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
24: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
25: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
26: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,

Line 23: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,

19: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
20: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
21: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
22: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
23: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
24: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
25: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
26: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
27: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,

Line 24: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,

20: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
21: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
22: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
23: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
24: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
25: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
26: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
27: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
28: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,

Line 25: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,

21: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
22: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
23: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
24: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
25: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
26: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
27: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
28: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
29: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,

Line 26: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,

22: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
23: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
24: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
25: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
26: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
27: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
28: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
29: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
30: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,

Line 27: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,

23: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
24: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
25: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
26: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
27: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
28: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
29: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
30: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
31: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,

Line 28: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,

24: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
25: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
26: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
27: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
28: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
29: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
30: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
31: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,
32: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE := NULL,

Line 29: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,

25: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
26: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
27: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
28: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
29: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
30: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
31: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,
32: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE := NULL,
33: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE := NULL,

Line 30: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,

26: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
27: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
28: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
29: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
30: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
31: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,
32: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE := NULL,
33: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE := NULL,
34: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE := NULL)

Line 31: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,

27: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
28: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
29: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
30: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
31: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,
32: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE := NULL,
33: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE := NULL,
34: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE := NULL)
35: IS

Line 32: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE := NULL,

28: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
29: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
30: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
31: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,
32: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE := NULL,
33: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE := NULL,
34: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE := NULL)
35: IS
36: MN NUMBER := FND_API.G_MISS_NUM;

Line 33: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE := NULL,

29: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
30: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
31: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,
32: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE := NULL,
33: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE := NULL,
34: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE := NULL)
35: IS
36: MN NUMBER := FND_API.G_MISS_NUM;
37: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;

Line 34: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE := NULL)

30: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
31: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,
32: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE := NULL,
33: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE := NULL,
34: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE := NULL)
35: IS
36: MN NUMBER := FND_API.G_MISS_NUM;
37: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
38: MD DATE := FND_API.G_MISS_DATE;

Line 42: INSERT INTO cn_srp_payout_dtls(

38: MD DATE := FND_API.G_MISS_DATE;
39:
40: BEGIN
41:
42: INSERT INTO cn_srp_payout_dtls(
43: SRP_payout_dtl_ID,
44: srp_role_id,
45: role_model_id,
46: role_id,

Line 76: cn_srp_payout_dtls_s.nextval,

72: LAST_UPDATED_BY,
73: object_version_number
74: )
75: SELECT
76: cn_srp_payout_dtls_s.nextval,
77: p_srp_role_id,
78: p_role_model_id,
79: decode(p_role_id,mn,null,p_role_id),
80: decode(p_attain_tier_id,mn,null,p_attain_tier_id),

Line 113: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,

109: END insert_row;
110:
111:
112: PROCEDURE update_row
113: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
114: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
115: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE :=NULL,
116: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
117: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,

Line 114: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,

110:
111:
112: PROCEDURE update_row
113: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
114: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
115: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE :=NULL,
116: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
117: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
118: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,

Line 115: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE :=NULL,

111:
112: PROCEDURE update_row
113: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
114: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
115: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE :=NULL,
116: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
117: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
118: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
119: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,

Line 116: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,

112: PROCEDURE update_row
113: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
114: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
115: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE :=NULL,
116: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
117: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
118: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
119: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
120: p_percent IN cn_srp_payout_dtls.percent%TYPE,

Line 117: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,

113: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
114: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
115: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE :=NULL,
116: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
117: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
118: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
119: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
120: p_percent IN cn_srp_payout_dtls.percent%TYPE,
121: p_payout IN cn_srp_payout_dtls.payout%TYPE,

Line 118: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,

114: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
115: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE :=NULL,
116: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
117: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
118: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
119: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
120: p_percent IN cn_srp_payout_dtls.percent%TYPE,
121: p_payout IN cn_srp_payout_dtls.payout%TYPE,
122: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,

Line 119: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,

115: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE :=NULL,
116: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
117: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
118: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
119: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
120: p_percent IN cn_srp_payout_dtls.percent%TYPE,
121: p_payout IN cn_srp_payout_dtls.payout%TYPE,
122: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
123: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,

Line 120: p_percent IN cn_srp_payout_dtls.percent%TYPE,

116: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
117: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
118: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
119: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
120: p_percent IN cn_srp_payout_dtls.percent%TYPE,
121: p_payout IN cn_srp_payout_dtls.payout%TYPE,
122: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
123: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
124: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,

Line 121: p_payout IN cn_srp_payout_dtls.payout%TYPE,

117: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
118: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
119: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
120: p_percent IN cn_srp_payout_dtls.percent%TYPE,
121: p_payout IN cn_srp_payout_dtls.payout%TYPE,
122: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
123: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
124: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
125: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,

Line 122: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,

118: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
119: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
120: p_percent IN cn_srp_payout_dtls.percent%TYPE,
121: p_payout IN cn_srp_payout_dtls.payout%TYPE,
122: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
123: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
124: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
125: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
126: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,

Line 123: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,

119: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
120: p_percent IN cn_srp_payout_dtls.percent%TYPE,
121: p_payout IN cn_srp_payout_dtls.payout%TYPE,
122: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
123: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
124: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
125: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
126: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
127: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,

Line 124: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,

120: p_percent IN cn_srp_payout_dtls.percent%TYPE,
121: p_payout IN cn_srp_payout_dtls.payout%TYPE,
122: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
123: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
124: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
125: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
126: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
127: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
128: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,

Line 125: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,

121: p_payout IN cn_srp_payout_dtls.payout%TYPE,
122: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
123: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
124: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
125: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
126: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
127: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
128: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
129: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,

Line 126: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,

122: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
123: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
124: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
125: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
126: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
127: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
128: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
129: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
130: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,

Line 127: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,

123: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
124: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
125: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
126: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
127: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
128: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
129: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
130: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
131: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,

Line 128: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,

124: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
125: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
126: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
127: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
128: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
129: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
130: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
131: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
132: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,

Line 129: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,

125: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
126: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
127: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
128: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
129: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
130: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
131: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
132: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
133: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,

Line 130: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,

126: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
127: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
128: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
129: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
130: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
131: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
132: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
133: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
134: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,

Line 131: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,

127: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
128: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
129: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
130: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
131: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
132: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
133: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
134: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
135: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,

Line 132: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,

128: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
129: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
130: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
131: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
132: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
133: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
134: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
135: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
136: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,

Line 133: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,

129: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
130: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
131: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
132: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
133: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
134: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
135: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
136: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
137: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,

Line 134: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,

130: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
131: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
132: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
133: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
134: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
135: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
136: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
137: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
138: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,

Line 135: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,

131: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
132: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
133: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
134: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
135: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
136: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
137: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
138: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,
139: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE,

Line 136: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,

132: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
133: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
134: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
135: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
136: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
137: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
138: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,
139: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE,
140: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE,

Line 137: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,

133: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
134: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
135: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
136: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
137: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
138: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,
139: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE,
140: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE,
141: p_object_version_number IN cn_srp_payout_dtls.object_version_number%TYPE) IS

Line 138: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,

134: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
135: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
136: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
137: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
138: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,
139: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE,
140: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE,
141: p_object_version_number IN cn_srp_payout_dtls.object_version_number%TYPE) IS
142:

Line 139: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE,

135: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
136: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
137: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
138: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,
139: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE,
140: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE,
141: p_object_version_number IN cn_srp_payout_dtls.object_version_number%TYPE) IS
142:
143: CURSOR l_old_csr IS

Line 140: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE,

136: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
137: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
138: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,
139: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE,
140: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE,
141: p_object_version_number IN cn_srp_payout_dtls.object_version_number%TYPE) IS
142:
143: CURSOR l_old_csr IS
144: SELECT *

Line 141: p_object_version_number IN cn_srp_payout_dtls.object_version_number%TYPE) IS

137: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
138: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,
139: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE,
140: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE,
141: p_object_version_number IN cn_srp_payout_dtls.object_version_number%TYPE) IS
142:
143: CURSOR l_old_csr IS
144: SELECT *
145: FROM cn_srp_payout_dtls

Line 145: FROM cn_srp_payout_dtls

141: p_object_version_number IN cn_srp_payout_dtls.object_version_number%TYPE) IS
142:
143: CURSOR l_old_csr IS
144: SELECT *
145: FROM cn_srp_payout_dtls
146: WHERE srp_role_id = p_srp_role_id;
147:
148: l_old_rec l_old_csr%ROWTYPE;
149:

Line 174: UPDATE cn_srp_payout_dtls SET

170: fnd_msg_pub.add;
171: raise fnd_api.g_exc_error;
172: END IF;
173:
174: UPDATE cn_srp_payout_dtls SET
175: (percent,
176: payout,
177: quota_category_id,
178: attribute_category,

Line 231: (p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE) IS

227: END update_row;
228:
229:
230: PROCEDURE delete_row
231: (p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE) IS
232: BEGIN
233: DELETE FROM cn_srp_payout_dtls
234: WHERE srp_role_id = p_srp_role_id;
235:

Line 233: DELETE FROM cn_srp_payout_dtls

229:
230: PROCEDURE delete_row
231: (p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE) IS
232: BEGIN
233: DELETE FROM cn_srp_payout_dtls
234: WHERE srp_role_id = p_srp_role_id;
235:
236: END delete_row;
237:

Line 238: END CN_SRP_payout_dtlS_pkg;

234: WHERE srp_role_id = p_srp_role_id;
235:
236: END delete_row;
237:
238: END CN_SRP_payout_dtlS_pkg;