1 PACKAGE PAY_GB_MULTI_DML_AND_VAL
2 /* $Header: pygbmpdml.pkh 120.0.12020000.1 2013/03/09 07:02:23 ssanjays noship $ */
3 AS
4
5
6 FUNCTION GET_GROUP_MAX_ID
7 RETURN NUMBER ;
8
9
10 FUNCTION VALIDATE_FREQUENCY(
11 P_PAYROLL_ID IN NUMBER
12 ,P_PAYROLL_GROUP_ID IN NUMBER
13 )
14 RETURN NUMBER;
15
16
17 FUNCTION CHK_ALREADY_ROLLED_BACK(P_REQUEST_ID NUMBER)
18 RETURN NUMBER;
19
20 FUNCTION VAL_PAYROLLS_IN_GROUP
21 (
22 P_PAYROLL_GROUP_ID NUMBER
23 ,P_PAYROLL_ID NUMBER
24 ,P_PAYROLL_GROUP_NAME VARCHAR2
25 )
26 RETURN NUMBER;
27
28 FUNCTION VAL_MASTER_CONCURRENT_REQUEST
29 (
30 P_CONCURRENT_REQUEST_ID NUMBER
31 ,P_PAYROLL_GROUP_ID NUMBER
32 )
33 RETURN NUMBER;
34
35 FUNCTION VAL_CHILD_CONCURRENT_REQUEST
36 (
37 P_CHILD_CONCURRENT_REQUEST_ID NUMBER
38 ,P_PARENT_CONC_REQUEST_ID NUMBER
39 )
40 RETURN NUMBER;
41
42
43 PROCEDURE CREATE_PAYROLL_GROUP
44 (
45 P_PAYROLL_GROUP_NAME IN VARCHAR2
46 ,P_FREQUENCY IN VARCHAR2
47 ,P_BUSINESS_GROUP_ID IN NUMBER
48 ,P_DESCRIPTION IN VARCHAR2
49 ,P_PAYROLL_GROUP_ID OUT NOCOPY NUMBER
50 ,P_RETURN_STATUS OUT NOCOPY VARCHAR2
51 );
52
53 PROCEDURE ADD_PAYROLLS
54 (
55 P_PAYROLL_ID IN NUMBER
56 ,P_PAYROLL_GROUP_ID IN NUMBER
57 ,P_BUSINESS_GROUP_ID IN NUMBER
58 );
59 PROCEDURE ADD_MASTER_CON_DETAILS
60 (
61 P_CONCURRENT_REQUEST_ID IN NUMBER
62 ,P_PAYROLL_GROUP_ID IN NUMBER
63 ,P_PROCESS_NAME IN VARCHAR2
64 ,P_REQUEST_PARAMETERS IN VARCHAR2
65 ,P_REQUEST_SUBMISSION_DATE IN DATE
66 );
67
68 PROCEDURE ADD_CHILD_CON_DETAILS
69 (
70 P_CHILD_CON_ID IN NUMBER
71 ,P_PARENT_CON_ID IN NUMBER
72 );
73
74
75 PROCEDURE UPDATE_MASTER_ROLLBACK_DETAILS
76 (
77 P_MASTER_REQUEST_ID IN NUMBER
78 ,P_PAYROLL_GROUP_ID IN NUMBER
79 ,P_ROLLBACK_REQUEST_ID IN NUMBER
80 );
81
82 PROCEDURE UPDATE_CHILD_ROLLBACK_DETAILS
83 (
84 P_MASTER_REQUEST_ID IN NUMBER
85 ,P_PAYROLL_GROUP_ID IN NUMBER
86 ,P_ROLLBACK_REQUEST_ID IN NUMBER
87 ,P_CHILD_REQUEST_ID IN NUMBER
88 );
89
90 PROCEDURE DEL_PAYROLL_GROUP
91 (
92 P_PAYROLL_GROUP_ID IN NUMBER
93 ,P_BUSINESS_GROUP_ID IN NUMBER
94 );
95
96 PROCEDURE DELETE_PAYROLL_FROM_GRP
97 (
98 P_PAYROLL_ID IN NUMBER
99 ,P_PAYROLL_GROUP_ID IN NUMBER);
100
101 PROCEDURE UPDATE_ALREADY_ROLLEDBACK
102 (P_REQUEST_ID IN NUMBER);
103
104 END PAY_GB_MULTI_DML_AND_VAL;
[Home] [Help]