PACKAGE: APPS.INV_INVIRDIS_XMLP_PKG

Source

1 PACKAGE INV_INVIRDIS_XMLP_PKG AS
2 /* $Header: INVIRDISS.pls 120.1 2007/12/25 10:23:18 dwkrishn noship $ */
3   /* $Header: INVIRDISS.pls 120.1 2007/12/25 10:23:18 dwkrishn noship $ */
4   P_ITEM_WHERE VARCHAR2(2000);
5 
6   P_STAT_EFF DATE;
7 
8   P_STATUS VARCHAR2(10);
9 
10   P_ITEM_LO VARCHAR2(900);
11 
12   P_ITEM_HI VARCHAR2(900);
13 
14   P_CAT_LO VARCHAR2(900);
15 
16   P_CAT_HI VARCHAR2(900);
17 
18   P_CAT_WHERE VARCHAR2(2000);
19 
20   P_ITEM_FLEX VARCHAR2(900);
21 
22   P_CAT_FLEX VARCHAR2(900) := '(MC.SEGMENT1||''\n''||MC.SEGMENT2||''\n''
23 				||MC.SEGMENT3||''\n''||MC.SEGMENT4||''\n''||MC.SEGMENT5
24 				||''\n''||MC.SEGMENT6||''\n''||MC.SEGMENT7
25 				||''\n''||MC.SEGMENT8||''\n''||MC.SEGMENT9||''\n''||MC.SEGMENT10
26 				||''\n''||MC.SEGMENT11||''\n''||MC.SEGMENT12||''\n''
27 				||MC.SEGMENT13||''\n''||MC.SEGMENT14||''\n''||MC.SEGMENT15
28 				||''\n''||MC.SEGMENT16||''\n''||MC.SEGMENT17||''\n''||MC.SEGMENT18
29 				||''\n''||MC.SEGMENT19||''\n''||MC.SEGMENT20)';
30 
31   P_CAT_STRUCT_NUM NUMBER;
32 
33   P_CONC_REQUEST_ID NUMBER := 0;
34 
35   P_ITEM_ORDER VARCHAR2(900);
36 
37   P_BREAK_ID NUMBER;
38 
39   P_CAT_SET_ID NUMBER;
40 
41   P_ORG_ID NUMBER;
42 
43   P_STRUCT_NUM NUMBER;
44 
45   P_ORDER_BY VARCHAR2(40);
46 
47   FUNCTION WHERE_STAT_EFF RETURN VARCHAR2;
48 
49   FUNCTION WHERE_STATUS RETURN VARCHAR2;
50 
51   FUNCTION BEFOREREPORT RETURN BOOLEAN;
52 
53   FUNCTION AFTERREPORT RETURN BOOLEAN;
54 
55   FUNCTION C_CAT_FROMFORMULA RETURN VARCHAR2;
56 
57   FUNCTION C_CAT_WHEREFORMULA RETURN VARCHAR2;
58 
59   FUNCTION C_CAT_PADFORMULA(C_CAT_FIELD IN VARCHAR2
60                            ,C_CAT_PAD IN VARCHAR2) RETURN VARCHAR2;
61 
62   FUNCTION C_CAT_SET_NAMEFORMULA RETURN VARCHAR2;
63 
64   FUNCTION C_ITEM_PADFORMULA(C_ITEM_FIELD IN VARCHAR2
65                             ,C_ITEM_PAD IN VARCHAR2) RETURN VARCHAR2;
66 
67   FUNCTION AFTERPFORM RETURN BOOLEAN;
68 
69   FUNCTION C_MORG_IDFORMULA RETURN VARCHAR2;
70 
71 END INV_INVIRDIS_XMLP_PKG;
72 
73