DBA Data[Home] [Help]

APPS.CN_PAY_GROUP_DTLS_PVT dependencies on FND_API

Line 7: NAME CN_PAY_GROUPS.NAME%TYPE := FND_API.G_MISS_CHAR,

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,

Line 8: PERIOD_SET_NAME CN_PERIOD_SETS.PERIOD_SET_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,

Line 9: PERIOD_TYPE CN_PAY_GROUPS.PERIOD_TYPE%TYPE := FND_API.G_MISS_CHAR,

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,

Line 11: PERIOD_NAME CN_PERIOD_STATUSES.PERIOD_NAME%TYPE := FND_API.G_MISS_CHAR,

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

Line 14: START_DATE CN_PERIOD_STATUSES.START_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

Line 15: END_DATE CN_PERIOD_STATUSES.END_DATE%TYPE := FND_API.G_MISS_DATE

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: (

Line 21: NAME CN_PAY_GROUPS.NAME%TYPE := FND_API.G_MISS_CHAR,

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,

Line 22: PERIOD_SET_NAME CN_PERIOD_SETS.PERIOD_SET_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,

Line 23: PERIOD_TYPE CN_PAY_GROUPS.PERIOD_TYPE%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:

Line 25: SALESREP_NAME CN_SALESREPS.NAME%TYPE := FND_API.G_MISS_CHAR,

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

Line 26: EMPLOYEE_NUMBER CN_SALESREPS.EMPLOYEE_NUMBER%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
30: ) ;

Line 28: START_DATE CN_SRP_PAY_GROUPS.START_DATE%TYPE := FND_API.G_MISS_DATE,

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

Line 29: END_DATE CN_SRP_PAY_GROUPS.END_DATE%TYPE := FND_API.G_MISS_DATE

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: (

Line 35: NAME CN_PAY_GROUPS.NAME%TYPE := FND_API.G_MISS_CHAR,

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,

Line 36: PERIOD_SET_NAME CN_PERIOD_SETS.PERIOD_SET_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,

Line 37: PERIOD_TYPE CN_PAY_GROUPS.PERIOD_TYPE%TYPE := FND_API.G_MISS_CHAR,

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:

Line 39: ROLE_NAME CN_ROLES.NAME%TYPE := FND_API.G_MISS_CHAR,

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

Line 42: START_DATE CN_ROLE_PAY_GROUPS.START_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:

Line 43: END_DATE CN_ROLE_PAY_GROUPS.END_DATE%TYPE := FND_API.G_MISS_DATE

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:

Line 72: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 73: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 74: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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:

Line 90: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 91: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 92: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 104: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 105: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 106: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,