DBA Data[Home] [Help]

APPS.CN_SRP_PAYGROUP_PVT dependencies on CN_SRP_PAY_GROUPS

Line 5: ( srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE := cn_api.g_miss_id,

1: PACKAGE CN_Srp_PayGroup_PVT AUTHID CURRENT_USER as
2: -- $Header: cnvsdpgs.pls 120.1 2005/08/25 02:16:40 sjustina noship $
3:
4: TYPE PayGroup_assign_rec IS RECORD
5: ( srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE := cn_api.g_miss_id,
6: pay_group_id cn_srp_pay_groups.pay_group_id%TYPE := cn_api.g_miss_id,
7: salesrep_id cn_srp_pay_groups.salesrep_id%TYPE := cn_api.g_miss_id,
8: assignment_start_date cn_srp_pay_groups.start_date%TYPE := cn_api.g_miss_date,
9: assignment_end_date cn_srp_pay_groups.end_date%TYPE := cn_api.g_miss_date,

Line 6: pay_group_id cn_srp_pay_groups.pay_group_id%TYPE := cn_api.g_miss_id,

2: -- $Header: cnvsdpgs.pls 120.1 2005/08/25 02:16:40 sjustina noship $
3:
4: TYPE PayGroup_assign_rec IS RECORD
5: ( srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE := cn_api.g_miss_id,
6: pay_group_id cn_srp_pay_groups.pay_group_id%TYPE := cn_api.g_miss_id,
7: salesrep_id cn_srp_pay_groups.salesrep_id%TYPE := cn_api.g_miss_id,
8: assignment_start_date cn_srp_pay_groups.start_date%TYPE := cn_api.g_miss_date,
9: assignment_end_date cn_srp_pay_groups.end_date%TYPE := cn_api.g_miss_date,
10: lock_flag cn_srp_pay_groups.lock_flag%TYPE := cn_api.g_miss_char,

Line 7: salesrep_id cn_srp_pay_groups.salesrep_id%TYPE := cn_api.g_miss_id,

3:
4: TYPE PayGroup_assign_rec IS RECORD
5: ( srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE := cn_api.g_miss_id,
6: pay_group_id cn_srp_pay_groups.pay_group_id%TYPE := cn_api.g_miss_id,
7: salesrep_id cn_srp_pay_groups.salesrep_id%TYPE := cn_api.g_miss_id,
8: assignment_start_date cn_srp_pay_groups.start_date%TYPE := cn_api.g_miss_date,
9: assignment_end_date cn_srp_pay_groups.end_date%TYPE := cn_api.g_miss_date,
10: lock_flag cn_srp_pay_groups.lock_flag%TYPE := cn_api.g_miss_char,
11: role_pay_group_id cn_srp_pay_groups.role_pay_group_id%TYPE:= cn_api.g_miss_id,

Line 8: assignment_start_date cn_srp_pay_groups.start_date%TYPE := cn_api.g_miss_date,

4: TYPE PayGroup_assign_rec IS RECORD
5: ( srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE := cn_api.g_miss_id,
6: pay_group_id cn_srp_pay_groups.pay_group_id%TYPE := cn_api.g_miss_id,
7: salesrep_id cn_srp_pay_groups.salesrep_id%TYPE := cn_api.g_miss_id,
8: assignment_start_date cn_srp_pay_groups.start_date%TYPE := cn_api.g_miss_date,
9: assignment_end_date cn_srp_pay_groups.end_date%TYPE := cn_api.g_miss_date,
10: lock_flag cn_srp_pay_groups.lock_flag%TYPE := cn_api.g_miss_char,
11: role_pay_group_id cn_srp_pay_groups.role_pay_group_id%TYPE:= cn_api.g_miss_id,
12: org_id cn_srp_pay_groups.org_id%TYPE := cn_api.g_miss_id,

Line 9: assignment_end_date cn_srp_pay_groups.end_date%TYPE := cn_api.g_miss_date,

5: ( srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE := cn_api.g_miss_id,
6: pay_group_id cn_srp_pay_groups.pay_group_id%TYPE := cn_api.g_miss_id,
7: salesrep_id cn_srp_pay_groups.salesrep_id%TYPE := cn_api.g_miss_id,
8: assignment_start_date cn_srp_pay_groups.start_date%TYPE := cn_api.g_miss_date,
9: assignment_end_date cn_srp_pay_groups.end_date%TYPE := cn_api.g_miss_date,
10: lock_flag cn_srp_pay_groups.lock_flag%TYPE := cn_api.g_miss_char,
11: role_pay_group_id cn_srp_pay_groups.role_pay_group_id%TYPE:= cn_api.g_miss_id,
12: org_id cn_srp_pay_groups.org_id%TYPE := cn_api.g_miss_id,
13: object_version_number cn_srp_pay_groups.object_version_number%TYPE,

Line 10: lock_flag cn_srp_pay_groups.lock_flag%TYPE := cn_api.g_miss_char,

6: pay_group_id cn_srp_pay_groups.pay_group_id%TYPE := cn_api.g_miss_id,
7: salesrep_id cn_srp_pay_groups.salesrep_id%TYPE := cn_api.g_miss_id,
8: assignment_start_date cn_srp_pay_groups.start_date%TYPE := cn_api.g_miss_date,
9: assignment_end_date cn_srp_pay_groups.end_date%TYPE := cn_api.g_miss_date,
10: lock_flag cn_srp_pay_groups.lock_flag%TYPE := cn_api.g_miss_char,
11: role_pay_group_id cn_srp_pay_groups.role_pay_group_id%TYPE:= cn_api.g_miss_id,
12: org_id cn_srp_pay_groups.org_id%TYPE := cn_api.g_miss_id,
13: object_version_number cn_srp_pay_groups.object_version_number%TYPE,
14: attribute_category cn_srp_pay_groups.attribute_category%TYPE

Line 11: role_pay_group_id cn_srp_pay_groups.role_pay_group_id%TYPE:= cn_api.g_miss_id,

7: salesrep_id cn_srp_pay_groups.salesrep_id%TYPE := cn_api.g_miss_id,
8: assignment_start_date cn_srp_pay_groups.start_date%TYPE := cn_api.g_miss_date,
9: assignment_end_date cn_srp_pay_groups.end_date%TYPE := cn_api.g_miss_date,
10: lock_flag cn_srp_pay_groups.lock_flag%TYPE := cn_api.g_miss_char,
11: role_pay_group_id cn_srp_pay_groups.role_pay_group_id%TYPE:= cn_api.g_miss_id,
12: org_id cn_srp_pay_groups.org_id%TYPE := cn_api.g_miss_id,
13: object_version_number cn_srp_pay_groups.object_version_number%TYPE,
14: attribute_category cn_srp_pay_groups.attribute_category%TYPE
15: := cn_api.g_miss_char,

Line 12: org_id cn_srp_pay_groups.org_id%TYPE := cn_api.g_miss_id,

8: assignment_start_date cn_srp_pay_groups.start_date%TYPE := cn_api.g_miss_date,
9: assignment_end_date cn_srp_pay_groups.end_date%TYPE := cn_api.g_miss_date,
10: lock_flag cn_srp_pay_groups.lock_flag%TYPE := cn_api.g_miss_char,
11: role_pay_group_id cn_srp_pay_groups.role_pay_group_id%TYPE:= cn_api.g_miss_id,
12: org_id cn_srp_pay_groups.org_id%TYPE := cn_api.g_miss_id,
13: object_version_number cn_srp_pay_groups.object_version_number%TYPE,
14: attribute_category cn_srp_pay_groups.attribute_category%TYPE
15: := cn_api.g_miss_char,
16: attribute1 cn_srp_pay_groups.attribute1%TYPE

Line 13: object_version_number cn_srp_pay_groups.object_version_number%TYPE,

9: assignment_end_date cn_srp_pay_groups.end_date%TYPE := cn_api.g_miss_date,
10: lock_flag cn_srp_pay_groups.lock_flag%TYPE := cn_api.g_miss_char,
11: role_pay_group_id cn_srp_pay_groups.role_pay_group_id%TYPE:= cn_api.g_miss_id,
12: org_id cn_srp_pay_groups.org_id%TYPE := cn_api.g_miss_id,
13: object_version_number cn_srp_pay_groups.object_version_number%TYPE,
14: attribute_category cn_srp_pay_groups.attribute_category%TYPE
15: := cn_api.g_miss_char,
16: attribute1 cn_srp_pay_groups.attribute1%TYPE
17: := cn_api.g_miss_char,

Line 14: attribute_category cn_srp_pay_groups.attribute_category%TYPE

10: lock_flag cn_srp_pay_groups.lock_flag%TYPE := cn_api.g_miss_char,
11: role_pay_group_id cn_srp_pay_groups.role_pay_group_id%TYPE:= cn_api.g_miss_id,
12: org_id cn_srp_pay_groups.org_id%TYPE := cn_api.g_miss_id,
13: object_version_number cn_srp_pay_groups.object_version_number%TYPE,
14: attribute_category cn_srp_pay_groups.attribute_category%TYPE
15: := cn_api.g_miss_char,
16: attribute1 cn_srp_pay_groups.attribute1%TYPE
17: := cn_api.g_miss_char,
18: attribute2 cn_srp_pay_groups.attribute2%TYPE

Line 16: attribute1 cn_srp_pay_groups.attribute1%TYPE

12: org_id cn_srp_pay_groups.org_id%TYPE := cn_api.g_miss_id,
13: object_version_number cn_srp_pay_groups.object_version_number%TYPE,
14: attribute_category cn_srp_pay_groups.attribute_category%TYPE
15: := cn_api.g_miss_char,
16: attribute1 cn_srp_pay_groups.attribute1%TYPE
17: := cn_api.g_miss_char,
18: attribute2 cn_srp_pay_groups.attribute2%TYPE
19: := cn_api.g_miss_char,
20: attribute3 cn_srp_pay_groups.attribute3%TYPE

Line 18: attribute2 cn_srp_pay_groups.attribute2%TYPE

14: attribute_category cn_srp_pay_groups.attribute_category%TYPE
15: := cn_api.g_miss_char,
16: attribute1 cn_srp_pay_groups.attribute1%TYPE
17: := cn_api.g_miss_char,
18: attribute2 cn_srp_pay_groups.attribute2%TYPE
19: := cn_api.g_miss_char,
20: attribute3 cn_srp_pay_groups.attribute3%TYPE
21: := cn_api.g_miss_char,
22: attribute4 cn_srp_pay_groups.attribute4%TYPE

Line 20: attribute3 cn_srp_pay_groups.attribute3%TYPE

16: attribute1 cn_srp_pay_groups.attribute1%TYPE
17: := cn_api.g_miss_char,
18: attribute2 cn_srp_pay_groups.attribute2%TYPE
19: := cn_api.g_miss_char,
20: attribute3 cn_srp_pay_groups.attribute3%TYPE
21: := cn_api.g_miss_char,
22: attribute4 cn_srp_pay_groups.attribute4%TYPE
23: := cn_api.g_miss_char,
24: attribute5 cn_srp_pay_groups.attribute5%TYPE

Line 22: attribute4 cn_srp_pay_groups.attribute4%TYPE

18: attribute2 cn_srp_pay_groups.attribute2%TYPE
19: := cn_api.g_miss_char,
20: attribute3 cn_srp_pay_groups.attribute3%TYPE
21: := cn_api.g_miss_char,
22: attribute4 cn_srp_pay_groups.attribute4%TYPE
23: := cn_api.g_miss_char,
24: attribute5 cn_srp_pay_groups.attribute5%TYPE
25: := cn_api.g_miss_char,
26: attribute6 cn_srp_pay_groups.attribute6%TYPE

Line 24: attribute5 cn_srp_pay_groups.attribute5%TYPE

20: attribute3 cn_srp_pay_groups.attribute3%TYPE
21: := cn_api.g_miss_char,
22: attribute4 cn_srp_pay_groups.attribute4%TYPE
23: := cn_api.g_miss_char,
24: attribute5 cn_srp_pay_groups.attribute5%TYPE
25: := cn_api.g_miss_char,
26: attribute6 cn_srp_pay_groups.attribute6%TYPE
27: := cn_api.g_miss_char,
28: attribute7 cn_srp_pay_groups.attribute7%TYPE

Line 26: attribute6 cn_srp_pay_groups.attribute6%TYPE

22: attribute4 cn_srp_pay_groups.attribute4%TYPE
23: := cn_api.g_miss_char,
24: attribute5 cn_srp_pay_groups.attribute5%TYPE
25: := cn_api.g_miss_char,
26: attribute6 cn_srp_pay_groups.attribute6%TYPE
27: := cn_api.g_miss_char,
28: attribute7 cn_srp_pay_groups.attribute7%TYPE
29: := cn_api.g_miss_char,
30: attribute8 cn_srp_pay_groups.attribute8%TYPE

Line 28: attribute7 cn_srp_pay_groups.attribute7%TYPE

24: attribute5 cn_srp_pay_groups.attribute5%TYPE
25: := cn_api.g_miss_char,
26: attribute6 cn_srp_pay_groups.attribute6%TYPE
27: := cn_api.g_miss_char,
28: attribute7 cn_srp_pay_groups.attribute7%TYPE
29: := cn_api.g_miss_char,
30: attribute8 cn_srp_pay_groups.attribute8%TYPE
31: := cn_api.g_miss_char,
32: attribute9 cn_srp_pay_groups.attribute9%TYPE

Line 30: attribute8 cn_srp_pay_groups.attribute8%TYPE

26: attribute6 cn_srp_pay_groups.attribute6%TYPE
27: := cn_api.g_miss_char,
28: attribute7 cn_srp_pay_groups.attribute7%TYPE
29: := cn_api.g_miss_char,
30: attribute8 cn_srp_pay_groups.attribute8%TYPE
31: := cn_api.g_miss_char,
32: attribute9 cn_srp_pay_groups.attribute9%TYPE
33: := cn_api.g_miss_char,
34: attribute10 cn_srp_pay_groups.attribute10%TYPE

Line 32: attribute9 cn_srp_pay_groups.attribute9%TYPE

28: attribute7 cn_srp_pay_groups.attribute7%TYPE
29: := cn_api.g_miss_char,
30: attribute8 cn_srp_pay_groups.attribute8%TYPE
31: := cn_api.g_miss_char,
32: attribute9 cn_srp_pay_groups.attribute9%TYPE
33: := cn_api.g_miss_char,
34: attribute10 cn_srp_pay_groups.attribute10%TYPE
35: := cn_api.g_miss_char,
36: attribute11 cn_srp_pay_groups.attribute11%TYPE

Line 34: attribute10 cn_srp_pay_groups.attribute10%TYPE

30: attribute8 cn_srp_pay_groups.attribute8%TYPE
31: := cn_api.g_miss_char,
32: attribute9 cn_srp_pay_groups.attribute9%TYPE
33: := cn_api.g_miss_char,
34: attribute10 cn_srp_pay_groups.attribute10%TYPE
35: := cn_api.g_miss_char,
36: attribute11 cn_srp_pay_groups.attribute11%TYPE
37: := cn_api.g_miss_char,
38: attribute12 cn_srp_pay_groups.attribute12%TYPE

Line 36: attribute11 cn_srp_pay_groups.attribute11%TYPE

32: attribute9 cn_srp_pay_groups.attribute9%TYPE
33: := cn_api.g_miss_char,
34: attribute10 cn_srp_pay_groups.attribute10%TYPE
35: := cn_api.g_miss_char,
36: attribute11 cn_srp_pay_groups.attribute11%TYPE
37: := cn_api.g_miss_char,
38: attribute12 cn_srp_pay_groups.attribute12%TYPE
39: := cn_api.g_miss_char,
40: attribute13 cn_srp_pay_groups.attribute13%TYPE

Line 38: attribute12 cn_srp_pay_groups.attribute12%TYPE

34: attribute10 cn_srp_pay_groups.attribute10%TYPE
35: := cn_api.g_miss_char,
36: attribute11 cn_srp_pay_groups.attribute11%TYPE
37: := cn_api.g_miss_char,
38: attribute12 cn_srp_pay_groups.attribute12%TYPE
39: := cn_api.g_miss_char,
40: attribute13 cn_srp_pay_groups.attribute13%TYPE
41: := cn_api.g_miss_char,
42: attribute14 cn_srp_pay_groups.attribute14%TYPE

Line 40: attribute13 cn_srp_pay_groups.attribute13%TYPE

36: attribute11 cn_srp_pay_groups.attribute11%TYPE
37: := cn_api.g_miss_char,
38: attribute12 cn_srp_pay_groups.attribute12%TYPE
39: := cn_api.g_miss_char,
40: attribute13 cn_srp_pay_groups.attribute13%TYPE
41: := cn_api.g_miss_char,
42: attribute14 cn_srp_pay_groups.attribute14%TYPE
43: := cn_api.g_miss_char,
44: attribute15 cn_srp_pay_groups.attribute15%TYPE

Line 42: attribute14 cn_srp_pay_groups.attribute14%TYPE

38: attribute12 cn_srp_pay_groups.attribute12%TYPE
39: := cn_api.g_miss_char,
40: attribute13 cn_srp_pay_groups.attribute13%TYPE
41: := cn_api.g_miss_char,
42: attribute14 cn_srp_pay_groups.attribute14%TYPE
43: := cn_api.g_miss_char,
44: attribute15 cn_srp_pay_groups.attribute15%TYPE
45: := cn_api.g_miss_char);
46: PROCEDURE Create_Srp_Pay_Group

Line 44: attribute15 cn_srp_pay_groups.attribute15%TYPE

40: attribute13 cn_srp_pay_groups.attribute13%TYPE
41: := cn_api.g_miss_char,
42: attribute14 cn_srp_pay_groups.attribute14%TYPE
43: := cn_api.g_miss_char,
44: attribute15 cn_srp_pay_groups.attribute15%TYPE
45: := cn_api.g_miss_char);
46: PROCEDURE Create_Srp_Pay_Group
47: ( p_api_version IN NUMBER ,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,