[Home] [Help]
PACKAGE: APPS.IGI_IGIGBUCC_XMLP_PKG
Source
1 PACKAGE IGI_IGIGBUCC_XMLP_PKG AS
2 /* $Header: IGIGBUCCS.pls 120.0.12010000.1 2008/07/29 08:58:11 appldev ship $ */
3 P_DEBUG_SWITCH VARCHAR2(1);
4
5 P_RUN_AOL VARCHAR2(1);
6
7 P_MIN_FLEX VARCHAR2(1000);
8
9 P_MAX_FLEX VARCHAR2(1000);
10
11 P_SET_OF_BOOKS_ID NUMBER;
12
13 P_CONC_REQUEST_ID NUMBER;
14
15 P_COA_ID NUMBER;
16
17 CP_SELECT_ALL VARCHAR2(4000) := '(CC.SEGMENT1 || ''-'' || SEGMENT2 || ''-'' || SEGMENT3
18 || ''-'' || SEGMENT4 || ''-'' || SEGMENT5 || ''-'' || SEGMENT6 || ''-'' || SEGMENT7
19 || ''-'' || SEGMENT8 || ''-'' || SEGMENT9 || ''-'' || SEGMENT10 || ''-'' || SEGMENT11
20 || ''-'' || SEGMENT12 || ''-'' || SEGMENT13 || ''-'' || SEGMENT14 || ''-'' || SEGMENT15
21 || ''-'' || SEGMENT16 || ''-'' || SEGMENT17 || ''-'' || SEGMENT18 || ''-'' || SEGMENT19
22 || ''-'' || SEGMENT20 || ''-'' || SEGMENT21 || ''-'' || SEGMENT22 || ''-'' || SEGMENT23
23 || ''-'' || SEGMENT24 || ''-'' || SEGMENT25 || ''-'' || SEGMENT26 || ''-'' || SEGMENT27
24 || ''-'' || SEGMENT28 || ''-'' || SEGMENT29 || ''-'' || SEGMENT30)';
25
26 CP_WHERE_FLEX VARCHAR2(5000) := 'CC.SEGMENT3 BETWEEN ''5000'' AND ''5900''';
27
28 CP_NO_DATA_FOUND VARCHAR2(1);
29
30 FUNCTION BEFOREREPORT RETURN BOOLEAN;
31
32 FUNCTION AFTERREPORT RETURN BOOLEAN;
33
34 FUNCTION CF_UPDATEFORMULA(CCID IN NUMBER) RETURN NUMBER;
35
36 FUNCTION CF_NO_DATA_FOUNDFORMULA(NO_DATA IN VARCHAR2) RETURN NUMBER;
37
38 FUNCTION CP_SELECT_ALL_P RETURN VARCHAR2;
39
40 FUNCTION CP_WHERE_FLEX_P RETURN VARCHAR2;
41
42 FUNCTION CP_NO_DATA_FOUND_P RETURN VARCHAR2;
43
44 END IGI_IGIGBUCC_XMLP_PKG;