DBA Data[Home] [Help]

PACKAGE: APPS.PAY_PYIEBIKA_XMLP_PKG

Source


1 PACKAGE PAY_PYIEBIKA_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PYIEBIKAS.pls 120.2 2007/12/27 05:29:07 amakrish noship $ */
3 
4   P_BUSINESS_GROUP_ID NUMBER;
5 
6   P_PAYROLL_ID NUMBER;
7 
8   P_CONSOLIDATION_SET_ID NUMBER;
9 
10   P_ASSIGNMENT_SET_ID NUMBER;
11 
12   P_SORT_ORDER VARCHAR2(80);
13 
14   P_EFFECTIVE_DATE DATE;
15 
16   P_ASSIGNMENT_SET_NAME VARCHAR2(100);
17 
18   P_CONSOLIDATION_SET_NAME VARCHAR2(100);
19 
20   P_DERIVED_SORT_ORDER VARCHAR2(100) := 'NULL';
21 
22   P_CONC_REQUEST_ID NUMBER;
23 
24   CP_IE_BIK_ARREARAGE NUMBER;
25 
26   CP_IE_BIK_ODD_ARREARAGE NUMBER;
27 
28   CP_IE_BIK_EVEN_ARREARAGE NUMBER;
29 
30   CP_IE_BIK_ARREARAGE_RECOVERY NUMBER;
31 
32   CP_IE_BIK_ODD_ARREARAGE_REC NUMBER;
33 
34   CP_IE_BIK_EVEN_ARREARAGE_REC NUMBER;
35 
36   CP_BUSINESS_GROUP_NAME VARCHAR2(20);
37 
38   CP_EFFECTIVE_DATE DATE;
39 
40   FUNCTION BEFOREREPORT RETURN BOOLEAN;
41 
42   FUNCTION CF_PAYROLL_NAMEFORMULA(PAYROLL_ID IN NUMBER) RETURN CHAR;
43 
44   FUNCTION AFTERPFORM RETURN BOOLEAN;
45 
46   FUNCTION CF_1FORMULA(ASSIGNMENT_ID IN NUMBER) RETURN NUMBER;
47 
48   FUNCTION CF_2FORMULA(ASSIGNMENT_ID IN NUMBER) RETURN NUMBER;
49 
50   FUNCTION CF_3FORMULA(ASSIGNMENT_ID IN NUMBER) RETURN NUMBER;
51 
52   FUNCTION CF_4FORMULA(ASSIGNMENT_ID IN NUMBER) RETURN NUMBER;
53 
54   FUNCTION CF_5FORMULA(ASSIGNMENT_ID IN NUMBER) RETURN NUMBER;
55 
56   FUNCTION CF_1FORMULA0004 RETURN DATE;
57 
58   FUNCTION AFTERREPORT RETURN BOOLEAN;
59 
60   FUNCTION CP_IE_BIK_ARREARAGE_P RETURN NUMBER;
61 
62   FUNCTION CP_IE_BIK_ODD_ARREARAGE_P RETURN NUMBER;
63 
64   FUNCTION CP_IE_BIK_EVEN_ARREARAGE_P RETURN NUMBER;
65 
66   FUNCTION CP_IE_BIK_ARREARAGE_RECOVERY_P RETURN NUMBER;
67 
68   FUNCTION CP_IE_BIK_ODD_ARREARAGE_REC_P RETURN NUMBER;
69 
70   FUNCTION CP_IE_BIK_EVEN_ARREARAGE_REC_P RETURN NUMBER;
71 
72   FUNCTION CP_BUSINESS_GROUP_NAME_P RETURN VARCHAR2;
73 
74   FUNCTION CP_EFFECTIVE_DATE_P RETURN DATE;
75 
76 END PAY_PYIEBIKA_XMLP_PKG;