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 CN_SRP_PAYOUT_DTLS_PKG AUTHID CURRENT_USER AS

1: PACKAGE CN_SRP_PAYOUT_DTLS_PKG AUTHID CURRENT_USER AS
2: -- $Header: cntmdtls.pls 115.0 2003/08/25 21:52:01 nkodkani noship $
3: -- +======================================================================|
4: -- | Copyright (c) 2000 Oracle Corporation |
5: -- | Redwood Shores, California, USA |

Line 8: -- | CN_SRP_PAYOUT_DTLS_pkg |

4: -- | Copyright (c) 2000 Oracle Corporation |
5: -- | Redwood Shores, California, USA |
6: -- | All rights reserved. |
7: -- | Package Name |
8: -- | CN_SRP_PAYOUT_DTLS_pkg |
9: -- | Purpose |
10: -- | This is the table handler for cn_srp_payout_dtls table; it takes |
11: -- | care of the insert, update and delete on the table. Refer high level|
12: -- | design documentation for the business perspective. |

Line 10: -- | This is the table handler for cn_srp_payout_dtls table; it takes |

6: -- | All rights reserved. |
7: -- | Package Name |
8: -- | CN_SRP_PAYOUT_DTLS_pkg |
9: -- | Purpose |
10: -- | This is the table handler for cn_srp_payout_dtls table; it takes |
11: -- | care of the insert, update and delete on the table. Refer high level|
12: -- | design documentation for the business perspective. |
13: -- | |
14: -- |History |

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

14: -- |History |
15: -- | 06-JUN-2001 sbadami Created |
16: -- +======================================================================|
17: PROCEDURE insert_row
18: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
19: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
20: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE := NULL,
21: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
22: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,

Line 19: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,

15: -- | 06-JUN-2001 sbadami Created |
16: -- +======================================================================|
17: PROCEDURE insert_row
18: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
19: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
20: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE := NULL,
21: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
22: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
23: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,

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

16: -- +======================================================================|
17: PROCEDURE insert_row
18: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
19: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
20: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE := NULL,
21: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
22: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
23: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
24: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,

Line 21: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,

17: PROCEDURE insert_row
18: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
19: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
20: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE := NULL,
21: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
22: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
23: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
24: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
25: p_percent IN cn_srp_payout_dtls.percent%TYPE,

Line 22: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,

18: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
19: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
20: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE := NULL,
21: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
22: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
23: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
24: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
25: p_percent IN cn_srp_payout_dtls.percent%TYPE,
26: p_payout IN cn_srp_payout_dtls.payout%TYPE,

Line 23: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,

19: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
20: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE := NULL,
21: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
22: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
23: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
24: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
25: p_percent IN cn_srp_payout_dtls.percent%TYPE,
26: p_payout IN cn_srp_payout_dtls.payout%TYPE,
27: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,

Line 24: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,

20: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE := NULL,
21: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
22: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
23: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
24: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
25: p_percent IN cn_srp_payout_dtls.percent%TYPE,
26: p_payout IN cn_srp_payout_dtls.payout%TYPE,
27: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
28: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,

Line 25: p_percent IN cn_srp_payout_dtls.percent%TYPE,

21: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
22: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
23: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
24: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
25: p_percent IN cn_srp_payout_dtls.percent%TYPE,
26: p_payout IN cn_srp_payout_dtls.payout%TYPE,
27: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
28: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
29: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,

Line 26: p_payout IN cn_srp_payout_dtls.payout%TYPE,

22: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
23: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
24: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
25: p_percent IN cn_srp_payout_dtls.percent%TYPE,
26: p_payout IN cn_srp_payout_dtls.payout%TYPE,
27: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
28: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
29: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
30: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,

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

23: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
24: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
25: p_percent IN cn_srp_payout_dtls.percent%TYPE,
26: p_payout IN cn_srp_payout_dtls.payout%TYPE,
27: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
28: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
29: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
30: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
31: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,

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

24: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
25: p_percent IN cn_srp_payout_dtls.percent%TYPE,
26: p_payout IN cn_srp_payout_dtls.payout%TYPE,
27: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
28: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
29: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
30: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
31: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
32: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,

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

25: p_percent IN cn_srp_payout_dtls.percent%TYPE,
26: p_payout IN cn_srp_payout_dtls.payout%TYPE,
27: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
28: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
29: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
30: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
31: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
32: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
33: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,

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

26: p_payout IN cn_srp_payout_dtls.payout%TYPE,
27: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
28: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
29: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
30: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
31: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
32: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
33: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
34: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,

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

27: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
28: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
29: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
30: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
31: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
32: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
33: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
34: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
35: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,

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

28: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
29: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
30: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
31: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
32: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
33: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
34: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
35: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
36: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,

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

29: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
30: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
31: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
32: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
33: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
34: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
35: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
36: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
37: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,

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

30: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
31: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
32: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
33: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
34: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
35: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
36: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
37: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
38: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,

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

31: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
32: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
33: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
34: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
35: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
36: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
37: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
38: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
39: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,

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

32: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
33: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
34: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
35: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
36: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
37: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
38: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
39: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
40: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,

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

33: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
34: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
35: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
36: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
37: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
38: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
39: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
40: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
41: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,

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

34: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
35: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
36: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
37: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
38: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
39: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
40: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
41: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
42: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,

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

35: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
36: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
37: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
38: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
39: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
40: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
41: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
42: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
43: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,

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

36: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
37: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
38: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
39: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
40: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
41: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
42: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
43: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
44: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,

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

37: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
38: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
39: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
40: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
41: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
42: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
43: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
44: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,
45: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE := NULL,

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

38: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
39: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
40: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
41: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
42: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
43: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
44: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,
45: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE := NULL,
46: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE := NULL,

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

39: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
40: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
41: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
42: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
43: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
44: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,
45: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE := NULL,
46: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE := NULL,
47: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE := NULL);

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

40: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
41: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
42: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
43: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
44: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,
45: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE := NULL,
46: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE := NULL,
47: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE := NULL);
48:

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

41: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
42: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
43: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
44: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,
45: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE := NULL,
46: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE := NULL,
47: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE := NULL);
48:
49: PROCEDURE update_row

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

42: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
43: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
44: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,
45: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE := NULL,
46: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE := NULL,
47: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE := NULL);
48:
49: PROCEDURE update_row
50: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,

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

43: p_created_by IN cn_srp_payout_dtls.created_by%TYPE := NULL,
44: p_creation_date IN cn_srp_payout_dtls.creation_date%TYPE := NULL,
45: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE := NULL,
46: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE := NULL,
47: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE := NULL);
48:
49: PROCEDURE update_row
50: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
51: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,

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

46: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE := NULL,
47: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE := NULL);
48:
49: PROCEDURE update_row
50: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
51: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
52: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE :=NULL,
53: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
54: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,

Line 51: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,

47: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE := NULL);
48:
49: PROCEDURE update_row
50: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
51: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
52: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE :=NULL,
53: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
54: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
55: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,

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

48:
49: PROCEDURE update_row
50: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
51: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
52: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE :=NULL,
53: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
54: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
55: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
56: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,

Line 53: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,

49: PROCEDURE update_row
50: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
51: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
52: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE :=NULL,
53: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
54: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
55: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
56: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
57: p_percent IN cn_srp_payout_dtls.percent%TYPE,

Line 54: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,

50: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
51: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
52: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE :=NULL,
53: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
54: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
55: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
56: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
57: p_percent IN cn_srp_payout_dtls.percent%TYPE,
58: p_payout IN cn_srp_payout_dtls.payout%TYPE,

Line 55: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,

51: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
52: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE :=NULL,
53: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
54: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
55: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
56: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
57: p_percent IN cn_srp_payout_dtls.percent%TYPE,
58: p_payout IN cn_srp_payout_dtls.payout%TYPE,
59: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,

Line 56: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,

52: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE :=NULL,
53: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
54: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
55: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
56: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
57: p_percent IN cn_srp_payout_dtls.percent%TYPE,
58: p_payout IN cn_srp_payout_dtls.payout%TYPE,
59: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
60: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,

Line 57: p_percent IN cn_srp_payout_dtls.percent%TYPE,

53: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
54: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
55: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
56: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
57: p_percent IN cn_srp_payout_dtls.percent%TYPE,
58: p_payout IN cn_srp_payout_dtls.payout%TYPE,
59: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
60: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
61: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,

Line 58: p_payout IN cn_srp_payout_dtls.payout%TYPE,

54: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
55: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
56: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
57: p_percent IN cn_srp_payout_dtls.percent%TYPE,
58: p_payout IN cn_srp_payout_dtls.payout%TYPE,
59: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
60: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
61: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
62: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,

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

55: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,
56: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
57: p_percent IN cn_srp_payout_dtls.percent%TYPE,
58: p_payout IN cn_srp_payout_dtls.payout%TYPE,
59: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
60: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
61: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
62: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
63: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,

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

56: p_quota_category_id IN cn_srp_payout_dtls.quota_category_id%TYPE,
57: p_percent IN cn_srp_payout_dtls.percent%TYPE,
58: p_payout IN cn_srp_payout_dtls.payout%TYPE,
59: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
60: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
61: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
62: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
63: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
64: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,

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

57: p_percent IN cn_srp_payout_dtls.percent%TYPE,
58: p_payout IN cn_srp_payout_dtls.payout%TYPE,
59: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
60: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
61: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
62: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
63: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
64: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
65: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,

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

58: p_payout IN cn_srp_payout_dtls.payout%TYPE,
59: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
60: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
61: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
62: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
63: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
64: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
65: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
66: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,

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

59: p_attribute_category IN cn_srp_payout_dtls.attribute_category%TYPE := NULL,
60: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
61: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
62: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
63: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
64: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
65: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
66: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
67: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,

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

60: p_attribute1 IN cn_srp_payout_dtls.attribute1%TYPE := NULL,
61: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
62: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
63: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
64: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
65: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
66: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
67: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
68: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,

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

61: p_attribute2 IN cn_srp_payout_dtls.attribute2%TYPE := NULL,
62: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
63: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
64: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
65: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
66: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
67: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
68: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
69: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,

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

62: p_attribute3 IN cn_srp_payout_dtls.attribute3%TYPE := NULL,
63: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
64: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
65: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
66: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
67: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
68: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
69: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
70: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,

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

63: p_attribute4 IN cn_srp_payout_dtls.attribute4%TYPE := NULL,
64: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
65: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
66: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
67: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
68: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
69: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
70: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
71: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,

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

64: p_attribute5 IN cn_srp_payout_dtls.attribute5%TYPE := NULL,
65: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
66: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
67: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
68: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
69: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
70: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
71: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
72: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,

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

65: p_attribute6 IN cn_srp_payout_dtls.attribute6%TYPE := NULL,
66: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
67: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
68: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
69: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
70: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
71: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
72: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
73: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,

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

66: p_attribute7 IN cn_srp_payout_dtls.attribute7%TYPE := NULL,
67: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
68: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
69: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
70: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
71: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
72: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
73: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
74: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,

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

67: p_attribute8 IN cn_srp_payout_dtls.attribute8%TYPE := NULL,
68: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
69: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
70: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
71: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
72: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
73: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
74: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
75: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,

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

68: p_attribute9 IN cn_srp_payout_dtls.attribute9%TYPE := NULL,
69: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
70: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
71: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
72: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
73: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
74: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
75: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,
76: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE,

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

69: p_attribute10 IN cn_srp_payout_dtls.attribute10%TYPE := NULL,
70: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
71: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
72: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
73: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
74: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
75: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,
76: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE,
77: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE,

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

70: p_attribute11 IN cn_srp_payout_dtls.attribute11%TYPE := NULL,
71: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
72: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
73: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
74: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
75: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,
76: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE,
77: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE,
78: p_object_version_number IN cn_srp_payout_dtls.object_version_number%TYPE);

Line 75: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,

71: p_attribute12 IN cn_srp_payout_dtls.attribute12%TYPE := NULL,
72: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
73: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
74: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
75: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,
76: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE,
77: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE,
78: p_object_version_number IN cn_srp_payout_dtls.object_version_number%TYPE);
79:

Line 76: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE,

72: p_attribute13 IN cn_srp_payout_dtls.attribute13%TYPE := NULL,
73: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
74: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
75: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,
76: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE,
77: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE,
78: p_object_version_number IN cn_srp_payout_dtls.object_version_number%TYPE);
79:
80: PROCEDURE delete_row

Line 77: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE,

73: p_attribute14 IN cn_srp_payout_dtls.attribute14%TYPE := NULL,
74: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
75: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,
76: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE,
77: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE,
78: p_object_version_number IN cn_srp_payout_dtls.object_version_number%TYPE);
79:
80: PROCEDURE delete_row
81: (p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE);

Line 78: p_object_version_number IN cn_srp_payout_dtls.object_version_number%TYPE);

74: p_attribute15 IN cn_srp_payout_dtls.attribute15%TYPE := NULL,
75: p_last_update_login IN cn_srp_payout_dtls.last_update_login%TYPE,
76: p_last_update_date IN cn_srp_payout_dtls.last_update_date%TYPE,
77: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE,
78: p_object_version_number IN cn_srp_payout_dtls.object_version_number%TYPE);
79:
80: PROCEDURE delete_row
81: (p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE);
82:

Line 81: (p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE);

77: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE,
78: p_object_version_number IN cn_srp_payout_dtls.object_version_number%TYPE);
79:
80: PROCEDURE delete_row
81: (p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE);
82:
83: END CN_SRP_payout_dtlS_pkg;

Line 83: END CN_SRP_payout_dtlS_pkg;

79:
80: PROCEDURE delete_row
81: (p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE);
82:
83: END CN_SRP_payout_dtlS_pkg;