1 PACKAGE PA_PAXBAUPD_XMLP_PKG AS
2 /* $Header: PAXBAUPDS.pls 120.0 2008/01/02 11:21:30 krreddy noship $ */
3 P_RULE_OPTIMIZER VARCHAR2(3);
4
5 P_DEBUG_MODE VARCHAR2(3);
6
7 P_CONC_REQUEST_ID NUMBER;
8
9 P_BATCH_ID NUMBER;
10
11 C_COMPANY_NAME_HEADER VARCHAR2(50);
12
13 C_NO_DATA_FOUND VARCHAR2(80);
14
15 C_DUMMY_DATA NUMBER;
16
17 CP_RET_CODE VARCHAR2(2);
18
19 CP_ERRBUF VARCHAR2(2000);
20
21 CP_REQ_ID NUMBER;
22
23 FUNCTION GET_COVER_PAGE_VALUES RETURN BOOLEAN;
24
25 FUNCTION BEFOREREPORT RETURN BOOLEAN;
26
27 FUNCTION GET_COMPANY_NAME RETURN BOOLEAN;
28
29 FUNCTION CF_UPDATE_FLAGFORMULA(UPDATE_FLAG IN VARCHAR2) RETURN VARCHAR2;
30
31 FUNCTION CF_RECAL_FLAGFORMULA(RECALCULATE_FLAG IN VARCHAR2) RETURN VARCHAR2;
32
33 FUNCTION AFTERREPORT RETURN BOOLEAN;
34
35 FUNCTION C_COMPANY_NAME_HEADER_P RETURN VARCHAR2;
36
37 FUNCTION C_NO_DATA_FOUND_P RETURN VARCHAR2;
38
39 FUNCTION C_DUMMY_DATA_P RETURN NUMBER;
40
41 FUNCTION CP_RET_CODE_P RETURN VARCHAR2;
42
43 FUNCTION CP_ERRBUF_P RETURN VARCHAR2;
44
45 FUNCTION CP_REQ_ID_P RETURN NUMBER;
46 /*
47 PROCEDURE INSERT_ROW1(X_ROWID IN OUT NOCOPY VARCHAR2
48 ,X_BATCH_ID IN OUT NOCOPY NUMBER
49 ,X_CREATION_DATE IN DATE
50 ,X_CREATED_BY IN NUMBER
51 ,X_LAST_UPDATED_BY IN NUMBER
52 ,X_LAST_UPDATE_DATE IN DATE
53 ,X_LAST_UPDATE_LOGIN IN NUMBER
54 ,X_BATCH_NAME IN VARCHAR2
55 ,X_BATCH_STATUS_CODE IN VARCHAR2
56 ,X_DESCRIPTION IN VARCHAR2
57 ,X_PROJECT_ATTRIBUTE IN VARCHAR2
58 ,X_EFFECTIVE_DATE IN DATE
59 ,X_ATTRIBUTE_CATEGORY IN VARCHAR2
60 ,X_ATTRIBUTE1 IN VARCHAR2
61 ,X_ATTRIBUTE2 IN VARCHAR2
62 ,X_ATTRIBUTE3 IN VARCHAR2
63 ,X_ATTRIBUTE4 IN VARCHAR2
64 ,X_ATTRIBUTE5 IN VARCHAR2
65 ,X_ATTRIBUTE6 IN VARCHAR2
66 ,X_ATTRIBUTE7 IN VARCHAR2
67 ,X_ATTRIBUTE8 IN VARCHAR2
68 ,X_ATTRIBUTE9 IN VARCHAR2
69 ,X_ATTRIBUTE10 IN VARCHAR2
70 ,X_ATTRIBUTE11 IN VARCHAR2
71 ,X_ATTRIBUTE12 IN VARCHAR2
72 ,X_ATTRIBUTE13 IN VARCHAR2
73 ,X_ATTRIBUTE14 IN VARCHAR2
74 ,X_ATTRIBUTE15 IN VARCHAR2);
75
76 PROCEDURE UPDATE_ROW(X_ROWID IN VARCHAR2
77 ,X_LAST_UPDATED_BY IN NUMBER
78 ,X_LAST_UPDATE_DATE IN DATE
79 ,X_LAST_UPDATE_LOGIN IN NUMBER
80 ,X_BATCH_NAME IN VARCHAR2
81 ,X_BATCH_STATUS_CODE IN VARCHAR2
82 ,X_REJECTION_CODE IN VARCHAR2
83 ,X_DESCRIPTION IN VARCHAR2
84 ,X_PROJECT_ATTRIBUTE IN VARCHAR2
85 ,X_EFFECTIVE_DATE IN DATE
86 ,X_PROCESS_RUN_BY IN NUMBER
87 ,X_PROCESS_RUN_DATE IN DATE
88 ,X_ATTRIBUTE_CATEGORY IN VARCHAR2
89 ,X_ATTRIBUTE1 IN VARCHAR2
90 ,X_ATTRIBUTE2 IN VARCHAR2
91 ,X_ATTRIBUTE3 IN VARCHAR2
92 ,X_ATTRIBUTE4 IN VARCHAR2
93 ,X_ATTRIBUTE5 IN VARCHAR2
94 ,X_ATTRIBUTE6 IN VARCHAR2
95 ,X_ATTRIBUTE7 IN VARCHAR2
96 ,X_ATTRIBUTE8 IN VARCHAR2
97 ,X_ATTRIBUTE9 IN VARCHAR2
98 ,X_ATTRIBUTE10 IN VARCHAR2
99 ,X_ATTRIBUTE11 IN VARCHAR2
100 ,X_ATTRIBUTE12 IN VARCHAR2
101 ,X_ATTRIBUTE13 IN VARCHAR2
102 ,X_ATTRIBUTE14 IN VARCHAR2
103 ,X_ATTRIBUTE15 IN VARCHAR2);
104
105 PROCEDURE LOCK_ROW(X_ROWID IN VARCHAR2
106 ,X_BATCH_NAME IN VARCHAR2
107 ,X_BATCH_STATUS_CODE IN VARCHAR2
108 ,X_DESCRIPTION IN VARCHAR2
109 ,X_PROJECT_ATTRIBUTE IN VARCHAR2
110 ,X_PROCESS_RUN_BY IN NUMBER
111 ,X_PROCESS_RUN_DATE IN DATE
112 ,X_EFFECTIVE_DATE IN DATE
113 ,X_REJECTION_CODE IN VARCHAR2
114 ,X_ATTRIBUTE_CATEGORY IN VARCHAR2
115 ,X_ATTRIBUTE1 IN VARCHAR2
116 ,X_ATTRIBUTE2 IN VARCHAR2
117 ,X_ATTRIBUTE3 IN VARCHAR2
118 ,X_ATTRIBUTE4 IN VARCHAR2
119 ,X_ATTRIBUTE5 IN VARCHAR2
120 ,X_ATTRIBUTE6 IN VARCHAR2
121 ,X_ATTRIBUTE7 IN VARCHAR2
122 ,X_ATTRIBUTE8 IN VARCHAR2
123 ,X_ATTRIBUTE9 IN VARCHAR2
124 ,X_ATTRIBUTE10 IN VARCHAR2
125 ,X_ATTRIBUTE11 IN VARCHAR2
126 ,X_ATTRIBUTE12 IN VARCHAR2
127 ,X_ATTRIBUTE13 IN VARCHAR2
128 ,X_ATTRIBUTE14 IN VARCHAR2
129 ,X_ATTRIBUTE15 IN VARCHAR2);
130
131 PROCEDURE DELETE_ROW(X_ROWID IN VARCHAR2);
132 */
133 PROCEDURE PROC_CONC(ERRBUF OUT NOCOPY VARCHAR2
134 ,RETCODE OUT NOCOPY VARCHAR2
135 ,X_BATCH_ID IN NUMBER
136 ,X_REQUEST_ID OUT NOCOPY NUMBER);
137 /*
138 PROCEDURE PROCESS(ERRBUF OUT NOCOPY VARCHAR2
139 ,RETCODE OUT NOCOPY VARCHAR2
140 ,X_BATCH_ID IN NUMBER
141 ,X_CONCURRENT IN VARCHAR2
142 ,X_ALL_BATCHES IN VARCHAR2);
143 */
144 END PA_PAXBAUPD_XMLP_PKG;