3:
4: TYPE pay_group_dtls_rec_type IS RECORD
5: (
6: PAY_GROUP_ID CN_PAY_GROUPS.PAY_GROUP_ID%TYPE := CN_API.G_MISS_ID,
7: NAME CN_PAY_GROUPS.NAME%TYPE := FND_API.G_MISS_CHAR,
8: PERIOD_SET_NAME CN_PERIOD_SETS.PERIOD_SET_NAME%TYPE := FND_API.G_MISS_CHAR,
9: PERIOD_TYPE CN_PAY_GROUPS.PERIOD_TYPE%TYPE := FND_API.G_MISS_CHAR,
10:
11: PERIOD_NAME CN_PERIOD_STATUSES.PERIOD_NAME%TYPE := FND_API.G_MISS_CHAR,
4: TYPE pay_group_dtls_rec_type IS RECORD
5: (
6: PAY_GROUP_ID CN_PAY_GROUPS.PAY_GROUP_ID%TYPE := CN_API.G_MISS_ID,
7: NAME CN_PAY_GROUPS.NAME%TYPE := FND_API.G_MISS_CHAR,
8: PERIOD_SET_NAME CN_PERIOD_SETS.PERIOD_SET_NAME%TYPE := FND_API.G_MISS_CHAR,
9: PERIOD_TYPE CN_PAY_GROUPS.PERIOD_TYPE%TYPE := FND_API.G_MISS_CHAR,
10:
11: PERIOD_NAME CN_PERIOD_STATUSES.PERIOD_NAME%TYPE := FND_API.G_MISS_CHAR,
12: PERIOD_YEAR CN_PERIOD_STATUSES.PERIOD_YEAR%TYPE := CN_API.G_MISS_ID,
5: (
6: PAY_GROUP_ID CN_PAY_GROUPS.PAY_GROUP_ID%TYPE := CN_API.G_MISS_ID,
7: NAME CN_PAY_GROUPS.NAME%TYPE := FND_API.G_MISS_CHAR,
8: PERIOD_SET_NAME CN_PERIOD_SETS.PERIOD_SET_NAME%TYPE := FND_API.G_MISS_CHAR,
9: PERIOD_TYPE CN_PAY_GROUPS.PERIOD_TYPE%TYPE := FND_API.G_MISS_CHAR,
10:
11: PERIOD_NAME CN_PERIOD_STATUSES.PERIOD_NAME%TYPE := FND_API.G_MISS_CHAR,
12: PERIOD_YEAR CN_PERIOD_STATUSES.PERIOD_YEAR%TYPE := CN_API.G_MISS_ID,
13: QUARTER_NUM CN_PERIOD_STATUSES.QUARTER_NUM%TYPE := CN_API.G_MISS_ID,
7: NAME CN_PAY_GROUPS.NAME%TYPE := FND_API.G_MISS_CHAR,
8: PERIOD_SET_NAME CN_PERIOD_SETS.PERIOD_SET_NAME%TYPE := FND_API.G_MISS_CHAR,
9: PERIOD_TYPE CN_PAY_GROUPS.PERIOD_TYPE%TYPE := FND_API.G_MISS_CHAR,
10:
11: PERIOD_NAME CN_PERIOD_STATUSES.PERIOD_NAME%TYPE := FND_API.G_MISS_CHAR,
12: PERIOD_YEAR CN_PERIOD_STATUSES.PERIOD_YEAR%TYPE := CN_API.G_MISS_ID,
13: QUARTER_NUM CN_PERIOD_STATUSES.QUARTER_NUM%TYPE := CN_API.G_MISS_ID,
14: START_DATE CN_PERIOD_STATUSES.START_DATE%TYPE := FND_API.G_MISS_DATE,
15: END_DATE CN_PERIOD_STATUSES.END_DATE%TYPE := FND_API.G_MISS_DATE
10:
11: PERIOD_NAME CN_PERIOD_STATUSES.PERIOD_NAME%TYPE := FND_API.G_MISS_CHAR,
12: PERIOD_YEAR CN_PERIOD_STATUSES.PERIOD_YEAR%TYPE := CN_API.G_MISS_ID,
13: QUARTER_NUM CN_PERIOD_STATUSES.QUARTER_NUM%TYPE := CN_API.G_MISS_ID,
14: START_DATE CN_PERIOD_STATUSES.START_DATE%TYPE := FND_API.G_MISS_DATE,
15: END_DATE CN_PERIOD_STATUSES.END_DATE%TYPE := FND_API.G_MISS_DATE
16: ) ;
17:
18: TYPE pay_group_sales_rec_type IS RECORD
11: PERIOD_NAME CN_PERIOD_STATUSES.PERIOD_NAME%TYPE := FND_API.G_MISS_CHAR,
12: PERIOD_YEAR CN_PERIOD_STATUSES.PERIOD_YEAR%TYPE := CN_API.G_MISS_ID,
13: QUARTER_NUM CN_PERIOD_STATUSES.QUARTER_NUM%TYPE := CN_API.G_MISS_ID,
14: START_DATE CN_PERIOD_STATUSES.START_DATE%TYPE := FND_API.G_MISS_DATE,
15: END_DATE CN_PERIOD_STATUSES.END_DATE%TYPE := FND_API.G_MISS_DATE
16: ) ;
17:
18: TYPE pay_group_sales_rec_type IS RECORD
19: (
17:
18: TYPE pay_group_sales_rec_type IS RECORD
19: (
20: PAY_GROUP_ID CN_PAY_GROUPS.PAY_GROUP_ID%TYPE := CN_API.G_MISS_ID,
21: NAME CN_PAY_GROUPS.NAME%TYPE := FND_API.G_MISS_CHAR,
22: PERIOD_SET_NAME CN_PERIOD_SETS.PERIOD_SET_NAME%TYPE := FND_API.G_MISS_CHAR,
23: PERIOD_TYPE CN_PAY_GROUPS.PERIOD_TYPE%TYPE := FND_API.G_MISS_CHAR,
24:
25: SALESREP_NAME CN_SALESREPS.NAME%TYPE := FND_API.G_MISS_CHAR,
18: TYPE pay_group_sales_rec_type IS RECORD
19: (
20: PAY_GROUP_ID CN_PAY_GROUPS.PAY_GROUP_ID%TYPE := CN_API.G_MISS_ID,
21: NAME CN_PAY_GROUPS.NAME%TYPE := FND_API.G_MISS_CHAR,
22: PERIOD_SET_NAME CN_PERIOD_SETS.PERIOD_SET_NAME%TYPE := FND_API.G_MISS_CHAR,
23: PERIOD_TYPE CN_PAY_GROUPS.PERIOD_TYPE%TYPE := FND_API.G_MISS_CHAR,
24:
25: SALESREP_NAME CN_SALESREPS.NAME%TYPE := FND_API.G_MISS_CHAR,
26: EMPLOYEE_NUMBER CN_SALESREPS.EMPLOYEE_NUMBER%TYPE := FND_API.G_MISS_CHAR,
19: (
20: PAY_GROUP_ID CN_PAY_GROUPS.PAY_GROUP_ID%TYPE := CN_API.G_MISS_ID,
21: NAME CN_PAY_GROUPS.NAME%TYPE := FND_API.G_MISS_CHAR,
22: PERIOD_SET_NAME CN_PERIOD_SETS.PERIOD_SET_NAME%TYPE := FND_API.G_MISS_CHAR,
23: PERIOD_TYPE CN_PAY_GROUPS.PERIOD_TYPE%TYPE := FND_API.G_MISS_CHAR,
24:
25: SALESREP_NAME CN_SALESREPS.NAME%TYPE := FND_API.G_MISS_CHAR,
26: EMPLOYEE_NUMBER CN_SALESREPS.EMPLOYEE_NUMBER%TYPE := FND_API.G_MISS_CHAR,
27:
21: NAME CN_PAY_GROUPS.NAME%TYPE := FND_API.G_MISS_CHAR,
22: PERIOD_SET_NAME CN_PERIOD_SETS.PERIOD_SET_NAME%TYPE := FND_API.G_MISS_CHAR,
23: PERIOD_TYPE CN_PAY_GROUPS.PERIOD_TYPE%TYPE := FND_API.G_MISS_CHAR,
24:
25: SALESREP_NAME CN_SALESREPS.NAME%TYPE := FND_API.G_MISS_CHAR,
26: EMPLOYEE_NUMBER CN_SALESREPS.EMPLOYEE_NUMBER%TYPE := FND_API.G_MISS_CHAR,
27:
28: START_DATE CN_SRP_PAY_GROUPS.START_DATE%TYPE := FND_API.G_MISS_DATE,
29: END_DATE CN_SRP_PAY_GROUPS.END_DATE%TYPE := FND_API.G_MISS_DATE
22: PERIOD_SET_NAME CN_PERIOD_SETS.PERIOD_SET_NAME%TYPE := FND_API.G_MISS_CHAR,
23: PERIOD_TYPE CN_PAY_GROUPS.PERIOD_TYPE%TYPE := FND_API.G_MISS_CHAR,
24:
25: SALESREP_NAME CN_SALESREPS.NAME%TYPE := FND_API.G_MISS_CHAR,
26: EMPLOYEE_NUMBER CN_SALESREPS.EMPLOYEE_NUMBER%TYPE := FND_API.G_MISS_CHAR,
27:
28: START_DATE CN_SRP_PAY_GROUPS.START_DATE%TYPE := FND_API.G_MISS_DATE,
29: END_DATE CN_SRP_PAY_GROUPS.END_DATE%TYPE := FND_API.G_MISS_DATE
30: ) ;
24:
25: SALESREP_NAME CN_SALESREPS.NAME%TYPE := FND_API.G_MISS_CHAR,
26: EMPLOYEE_NUMBER CN_SALESREPS.EMPLOYEE_NUMBER%TYPE := FND_API.G_MISS_CHAR,
27:
28: START_DATE CN_SRP_PAY_GROUPS.START_DATE%TYPE := FND_API.G_MISS_DATE,
29: END_DATE CN_SRP_PAY_GROUPS.END_DATE%TYPE := FND_API.G_MISS_DATE
30: ) ;
31:
32: TYPE pay_group_roles_rec_type IS RECORD
25: SALESREP_NAME CN_SALESREPS.NAME%TYPE := FND_API.G_MISS_CHAR,
26: EMPLOYEE_NUMBER CN_SALESREPS.EMPLOYEE_NUMBER%TYPE := FND_API.G_MISS_CHAR,
27:
28: START_DATE CN_SRP_PAY_GROUPS.START_DATE%TYPE := FND_API.G_MISS_DATE,
29: END_DATE CN_SRP_PAY_GROUPS.END_DATE%TYPE := FND_API.G_MISS_DATE
30: ) ;
31:
32: TYPE pay_group_roles_rec_type IS RECORD
33: (
31:
32: TYPE pay_group_roles_rec_type IS RECORD
33: (
34: PAY_GROUP_ID CN_PAY_GROUPS.PAY_GROUP_ID%TYPE := CN_API.G_MISS_ID,
35: NAME CN_PAY_GROUPS.NAME%TYPE := FND_API.G_MISS_CHAR,
36: PERIOD_SET_NAME CN_PERIOD_SETS.PERIOD_SET_NAME%TYPE := FND_API.G_MISS_CHAR,
37: PERIOD_TYPE CN_PAY_GROUPS.PERIOD_TYPE%TYPE := FND_API.G_MISS_CHAR,
38:
39: ROLE_NAME CN_ROLES.NAME%TYPE := FND_API.G_MISS_CHAR,
32: TYPE pay_group_roles_rec_type IS RECORD
33: (
34: PAY_GROUP_ID CN_PAY_GROUPS.PAY_GROUP_ID%TYPE := CN_API.G_MISS_ID,
35: NAME CN_PAY_GROUPS.NAME%TYPE := FND_API.G_MISS_CHAR,
36: PERIOD_SET_NAME CN_PERIOD_SETS.PERIOD_SET_NAME%TYPE := FND_API.G_MISS_CHAR,
37: PERIOD_TYPE CN_PAY_GROUPS.PERIOD_TYPE%TYPE := FND_API.G_MISS_CHAR,
38:
39: ROLE_NAME CN_ROLES.NAME%TYPE := FND_API.G_MISS_CHAR,
40: ROLE_ID CN_ROLES.ROLE_ID%TYPE := CN_API.G_MISS_ID,
33: (
34: PAY_GROUP_ID CN_PAY_GROUPS.PAY_GROUP_ID%TYPE := CN_API.G_MISS_ID,
35: NAME CN_PAY_GROUPS.NAME%TYPE := FND_API.G_MISS_CHAR,
36: PERIOD_SET_NAME CN_PERIOD_SETS.PERIOD_SET_NAME%TYPE := FND_API.G_MISS_CHAR,
37: PERIOD_TYPE CN_PAY_GROUPS.PERIOD_TYPE%TYPE := FND_API.G_MISS_CHAR,
38:
39: ROLE_NAME CN_ROLES.NAME%TYPE := FND_API.G_MISS_CHAR,
40: ROLE_ID CN_ROLES.ROLE_ID%TYPE := CN_API.G_MISS_ID,
41:
35: NAME CN_PAY_GROUPS.NAME%TYPE := FND_API.G_MISS_CHAR,
36: PERIOD_SET_NAME CN_PERIOD_SETS.PERIOD_SET_NAME%TYPE := FND_API.G_MISS_CHAR,
37: PERIOD_TYPE CN_PAY_GROUPS.PERIOD_TYPE%TYPE := FND_API.G_MISS_CHAR,
38:
39: ROLE_NAME CN_ROLES.NAME%TYPE := FND_API.G_MISS_CHAR,
40: ROLE_ID CN_ROLES.ROLE_ID%TYPE := CN_API.G_MISS_ID,
41:
42: START_DATE CN_ROLE_PAY_GROUPS.START_DATE%TYPE := FND_API.G_MISS_DATE,
43: END_DATE CN_ROLE_PAY_GROUPS.END_DATE%TYPE := FND_API.G_MISS_DATE
38:
39: ROLE_NAME CN_ROLES.NAME%TYPE := FND_API.G_MISS_CHAR,
40: ROLE_ID CN_ROLES.ROLE_ID%TYPE := CN_API.G_MISS_ID,
41:
42: START_DATE CN_ROLE_PAY_GROUPS.START_DATE%TYPE := FND_API.G_MISS_DATE,
43: END_DATE CN_ROLE_PAY_GROUPS.END_DATE%TYPE := FND_API.G_MISS_DATE
44: ) ;
45:
46:
39: ROLE_NAME CN_ROLES.NAME%TYPE := FND_API.G_MISS_CHAR,
40: ROLE_ID CN_ROLES.ROLE_ID%TYPE := CN_API.G_MISS_ID,
41:
42: START_DATE CN_ROLE_PAY_GROUPS.START_DATE%TYPE := FND_API.G_MISS_DATE,
43: END_DATE CN_ROLE_PAY_GROUPS.END_DATE%TYPE := FND_API.G_MISS_DATE
44: ) ;
45:
46:
47:
68:
69:
70: PROCEDURE Get_Pay_Group_Dtls
71: (p_api_version IN NUMBER,
72: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
73: p_commit IN VARCHAR2 := FND_API.G_FALSE,
74: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
75: p_start_record IN NUMBER := -1,
76: p_fetch_size IN NUMBER := -1,
69:
70: PROCEDURE Get_Pay_Group_Dtls
71: (p_api_version IN NUMBER,
72: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
73: p_commit IN VARCHAR2 := FND_API.G_FALSE,
74: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
75: p_start_record IN NUMBER := -1,
76: p_fetch_size IN NUMBER := -1,
77: p_pay_group_id IN NUMBER,
70: PROCEDURE Get_Pay_Group_Dtls
71: (p_api_version IN NUMBER,
72: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
73: p_commit IN VARCHAR2 := FND_API.G_FALSE,
74: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
75: p_start_record IN NUMBER := -1,
76: p_fetch_size IN NUMBER := -1,
77: p_pay_group_id IN NUMBER,
78:
86:
87:
88: PROCEDURE Get_Pay_Group_Sales
89: (p_api_version IN NUMBER,
90: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
91: p_commit IN VARCHAR2 := FND_API.G_FALSE,
92: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93: p_start_record IN NUMBER := -1,
94: p_fetch_size IN NUMBER := -1,
87:
88: PROCEDURE Get_Pay_Group_Sales
89: (p_api_version IN NUMBER,
90: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
91: p_commit IN VARCHAR2 := FND_API.G_FALSE,
92: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93: p_start_record IN NUMBER := -1,
94: p_fetch_size IN NUMBER := -1,
95: p_pay_group_id IN NUMBER,
88: PROCEDURE Get_Pay_Group_Sales
89: (p_api_version IN NUMBER,
90: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
91: p_commit IN VARCHAR2 := FND_API.G_FALSE,
92: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93: p_start_record IN NUMBER := -1,
94: p_fetch_size IN NUMBER := -1,
95: p_pay_group_id IN NUMBER,
96: x_pay_group_sales OUT NOCOPY pay_group_sales_tbl_type,
100: x_msg_data OUT NOCOPY VARCHAR2);
101:
102: PROCEDURE Get_Pay_Group_Roles
103: (p_api_version IN NUMBER,
104: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
105: p_commit IN VARCHAR2 := FND_API.G_FALSE,
106: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
107: p_start_record IN NUMBER := -1,
108: p_fetch_size IN NUMBER := -1,
101:
102: PROCEDURE Get_Pay_Group_Roles
103: (p_api_version IN NUMBER,
104: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
105: p_commit IN VARCHAR2 := FND_API.G_FALSE,
106: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
107: p_start_record IN NUMBER := -1,
108: p_fetch_size IN NUMBER := -1,
109: p_pay_group_id IN NUMBER,
102: PROCEDURE Get_Pay_Group_Roles
103: (p_api_version IN NUMBER,
104: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
105: p_commit IN VARCHAR2 := FND_API.G_FALSE,
106: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
107: p_start_record IN NUMBER := -1,
108: p_fetch_size IN NUMBER := -1,
109: p_pay_group_id IN NUMBER,
110: x_pay_group_roles OUT NOCOPY pay_group_roles_tbl_type,