PACKAGE: APPS.IGI_IGIGBUCC_XMLP_PKG

Source

1 PACKAGE IGI_IGIGBUCC_XMLP_PKG AUTHID CURRENT_USER 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;