PACKAGE: APPS.PAY_PAYJPNUI_XMLP_PKG

Source

1 PACKAGE PAY_PAYJPNUI_XMLP_PKG AS
2 /* $Header: PAYJPNUIS.pls 120.0 2007/12/13 12:05:19 amakrish noship $ */
3   P_BUSINESS_GROUP_ID NUMBER;
4 
5   P_REPORT_TYPE VARCHAR2(1);
6 
7   P_TARGET_DATE_FROM DATE;
8 
9   P_TARGET_DATE_TO DATE;
10 
11   P_ORGANIZATION_ID NUMBER;
12 
13   P_ASSIGNMENT_ID1 NUMBER;
14 
15   P_ASSIGNMENT_ID2 NUMBER;
16 
17   P_ASSIGNMENT_ID3 NUMBER;
18 
19   P_ASSIGNMENT_ID4 NUMBER;
20 
21   P_ASSIGNMENT_ID5 NUMBER;
22 
23   P_ASSIGNMENT_ID6 NUMBER;
24 
25   P_ASSIGNMENT_ID7 NUMBER;
26 
27   P_ASSIGNMENT_ID8 NUMBER;
28 
29   P_ASSIGNMENT_ID9 NUMBER;
30 
31   P_ASSIGNMENT_ID10 NUMBER;
32 
33   P_WHERE_CLAUSE_FOR_ASSID VARCHAR2(150):=' ';
34 
35   P_CONC_REQUEST_ID NUMBER;
36 
37   CP_UI_NUMBER VARCHAR2(13);
38 
39   CP_TARGET_DATE VARCHAR2(6);
40 
41   CP_DATE_OF_BIRTH VARCHAR2(8);
42 
43   CP_QUALIFIED_DATE VARCHAR2(6);
44 
45   CP_OUTPUT_DATE_GLOBAL VARCHAR2(21);
46 
47   CP_REPORT_TITLE VARCHAR2(255);
48 
49   CP_TARGET_DATE_TITLE VARCHAR2(255);
50 
51   CP_NOTE_TITLE VARCHAR2(255);
52 
53   FUNCTION CF_DETAILS_DUMMYFORMULA(ASSIGNMENT_ID IN NUMBER
54                                   ,EFFECTIVE_DATE IN DATE
55                                   ,TARGET_DATE IN DATE
56                                   ,DATE_OF_BIRTH IN DATE) RETURN NUMBER;
57 
58   FUNCTION AFTERPFORM RETURN BOOLEAN;
59 
60   FUNCTION BEFOREREPORT RETURN BOOLEAN;
61 
62   FUNCTION AFTERREPORT RETURN BOOLEAN;
63 
64   FUNCTION CP_UI_NUMBER_P RETURN VARCHAR2;
65 
66   FUNCTION CP_TARGET_DATE_P RETURN VARCHAR2;
67 
68   FUNCTION CP_DATE_OF_BIRTH_P RETURN VARCHAR2;
69 
70   FUNCTION CP_QUALIFIED_DATE_P RETURN VARCHAR2;
71 
72   FUNCTION CP_OUTPUT_DATE_GLOBAL_P RETURN VARCHAR2;
73 
74   FUNCTION CP_REPORT_TITLE_P RETURN VARCHAR2;
75 
76   FUNCTION CP_TARGET_DATE_TITLE_P RETURN VARCHAR2;
77 
78   FUNCTION CP_NOTE_TITLE_P RETURN VARCHAR2;
79 
80   G_UI_NUMBER_IV_ID NUMBER;
81 
82   G_QUALIFIED_DATE_IV_ID NUMBER;
83 
84 END PAY_PAYJPNUI_XMLP_PKG;