[Home] [Help]
PACKAGE: APPS.XTR_XTRAUSRM_XMLP_PKG
Source
1 PACKAGE XTR_XTRAUSRM_XMLP_PKG AS
2 /* $Header: XTRAUSRMS.pls 120.1 2007/12/28 12:42:31 npannamp noship $ */
3 P_REPORT_DATE2 DATE;
4
5 P_REPORT_NOS VARCHAR2(30);
6
7 P_REPORT_SHORT_NAME VARCHAR2(80);
8
9 P_REPORT_GROUP VARCHAR2(32767);
10
11 P_USE_DEFAULTS VARCHAR2(1);
12
13 P_VERSION_NUM VARCHAR2(2);
14
15 P_EVENT_TYPE VARCHAR2(50);
16
17 P_REFERENCE_CODE VARCHAR2(50);
18
19 P_COLUMN_CHANGED VARCHAR2(50);
20
21 P_UPDATE_BY VARCHAR2(25);
22
23 P_AUDIT_REQUEST_FROM VARCHAR2(32767);
24
25 P_AUDIT_REQUEST_TO VARCHAR2(32767);
26
27 Z1REPORT_NOS VARCHAR2(100);
28
29 Z2EVENT_TYPE VARCHAR2(100) := 'Event Type';
30
31 Z2REFERENCE_CODE VARCHAR2(100) := 'Reference Code';
32
33 Z2NAME_OF_COLUMN_CHANGED VARCHAR2(100) := 'Column Changed';
34
35 Z2END_OF_REPORT VARCHAR2(100);
36
37 Z2UPDATED_BY VARCHAR2(100) := 'Updated By';
38
39 Z2UPDATE_DATE_TIME VARCHAR2(100) := 'Updated On';
40
41 Z2ORIGINAL_VALUE VARCHAR2(100) := 'Original Value';
42
43 Z2NEW_VALUE VARCHAR2(100) := 'New Value';
44
45 Z1PARAMETERS VARCHAR2(100) := 'Parameters';
46
47 Z1EVENT_TYPE VARCHAR2(100) := 'Event Type';
48
49 Z1UPDATED_BY VARCHAR2(100) := 'Updated By';
50
51 Z1REFERENCE_CODE VARCHAR2(100) := 'Reference Code';
52
53 Z1AUDIT_REQUESTS_FROM VARCHAR2(100) := 'Updated From';
54
55 Z1COLUMN_CHANGED VARCHAR2(100) := 'Column Changed';
56
57 Z1AUDIT_REQUESTS_TO VARCHAR2(100) := 'Updated To';
58
59 Z2PAGE VARCHAR2(100);
60
61 Z2REPORT VARCHAR2(100);
62
63 Z2REQUESTED_BY VARCHAR2(100);
64
65 P_A_REQUEST_FROM DATE;
66
67 P_A_REQUEST_TO DATE;
68
69 P_AUDIT_REQUEST_ID NUMBER;
70
71 P_EVENT_GROUP VARCHAR2(50);
72
73 P_CONC_REQUEST_ID NUMBER;
74
75 CP_PARA VARCHAR2(32767);
76
77 FUNCTION CF_SET_PARAFORMULA RETURN VARCHAR2;
78
79 FUNCTION BEFOREREPORT RETURN BOOLEAN;
80
81 FUNCTION AFTERPFORM RETURN BOOLEAN;
82
83 FUNCTION AFTERREPORT RETURN BOOLEAN;
84
85 FUNCTION CP_PARA_P RETURN VARCHAR2;
86
87 END XTR_XTRAUSRM_XMLP_PKG;
88