[Home] [Help]
PACKAGE: APPS.CN_PAY_GROUP_DTLS_PVT
Source
1 PACKAGE CN_PAY_GROUP_DTLS_PVT AUTHID CURRENT_USER AS
2 /*$Header: cnvpgdts.pls 115.4 2002/11/27 05:31:00 pramadas ship $*/
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,
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 (
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
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 (
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
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
48 TYPE pay_group_dtls_tbl_type IS
49 TABLE OF pay_group_dtls_rec_type INDEX BY BINARY_INTEGER ;
50
51 TYPE pay_group_sales_tbl_type IS
52 TABLE OF pay_group_sales_rec_type INDEX BY BINARY_INTEGER ;
53 TYPE pay_group_roles_tbl_type IS
54 TABLE OF pay_group_roles_rec_type INDEX BY BINARY_INTEGER ;
55
56
57
58
59 -- Global variable that represent missing values.
60
61 G_MISS_PAY_GROUP_DTLS_REC pay_group_dtls_rec_type;
62 G_MISS_PAY_GROUP_DTLS_REC_TB pay_group_dtls_tbl_type;
63 G_MISS_PAY_GROUP_DTLS_REC_RL pay_group_roles_tbl_type;
64
65 G_MISS_PAY_GROUP_SALES_REC pay_group_sales_rec_type;
66 G_MISS_PAY_GROUP_SALES_REC_TB pay_group_sales_tbl_type;
67 G_MISS_PAY_GROUP_ROLES_REC pay_group_roles_rec_type;
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,
77 p_pay_group_id IN NUMBER,
78
79
80 x_pay_group_dtls OUT NOCOPY pay_group_dtls_tbl_type,
81
82 x_total_record OUT NOCOPY NUMBER,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2);
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,
95 p_pay_group_id IN NUMBER,
96 x_pay_group_sales OUT NOCOPY pay_group_sales_tbl_type,
97 x_total_record OUT NOCOPY NUMBER,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
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,
109 p_pay_group_id IN NUMBER,
110 x_pay_group_roles OUT NOCOPY pay_group_roles_tbl_type,
111 x_total_record OUT NOCOPY NUMBER,
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2);
115
116
117
118
119
120
121 END CN_PAY_GROUP_DTLS_PVT;
122