PACKAGE: APPS.IGI_IGIPSIAP_XMLP_PKG

Source

1 PACKAGE IGI_IGIPSIAP_XMLP_PKG AS
2 /* $Header: IGIPSIAPS.pls 120.0.12010000.4 2008/11/11 12:10:58 dramired ship $ */
3   P_APPROVAL_GROUP NUMBER;
4 
5   P_APPROVER VARCHAR2(100);
6 
7   P_FLEXFIELD_FROM VARCHAR2(100);
8 
9   P_FLEXFIELD_TO VARCHAR2(100);
10 
11   P_CONC_REQUEST_ID NUMBER;
12 
13  /* P_FLEXDATA VARCHAR2(1200) := '(SEGMENT1_LOW||''-''||SEGMENT2_LOW||''-''||SEGMENT3_LOW||''-''
14   ||SEGMENT4_LOW||''-''||segment5_low||''-''||segment6_low||''-''||segment7_low||''-''
15   ||segment8_low||''-''||segment9_low||''-''||segment10_low)';*/
16   --bug 7431526
17   P_FLEXDATA VARCHAR2(1200) ;
18   P_STRUCT_NUM VARCHAR2(15);
19 
20   P_WHERE VARCHAR2(600) := '1=1';
21 
22   --P_ORDER_FLEX VARCHAR2(298);
23 
24   P_OPERAND1 VARCHAR2(15);
25 
26   P_SET_OF_BOOKS VARCHAR2(15);
27 
28   /*P_FLEXDATA_TO VARCHAR2(1200) := '(segment1_high||''-''||segment2_high||''-''
29   ||segment3_high||''-''||segment4_high||''-''||segment5_high||''-''||segment6_high
30   ||''-''||segment7_high||''-''||segment8_high||''-''||segment9_high||''-''||segment10_high)';*/
31   --bug 7431526
32   P_FLEXDATA_TO VARCHAR2(1200);
33   P_WHERE1 VARCHAR2(600) := '1=1';
34   --bug 7431526
35   P_WHERES VARCHAR2(600):='1=1';
36 
37   FUNCTION AFTERREPORT RETURN BOOLEAN;
38 
39   FUNCTION BEFOREREPORT(P_FLEXFIELD_FROM in out NOCOPY varchar2, P_FLEXFIELD_TO in out NOCOPY varchar2) RETURN BOOLEAN;
40   --bug 7431526
41   /*FUNCTION CONV_FLEX_HIGH(P_FLEX IN VARCHAR2) RETURN VARCHAR2;
42 
43   FUNCTION CONV_FLEX_LOW(P_FLEX IN VARCHAR2) RETURN VARCHAR2;*/
44 
45   FUNCTION CONV_WHERE(P_FLEXFIELD IN VARCHAR2,P_SEGMENT IN VARCHAR2) RETURN VARCHAR2;
46 
47    FUNCTION CONV_WHERE1(P_FLEXFIELD IN VARCHAR2,P_SEGMENT IN VARCHAR2) RETURN VARCHAR2;
48 
49 END IGI_IGIPSIAP_XMLP_PKG;