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.
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