PACKAGE: APPS.INV_INVIRITS_XMLP_PKG

Source

1 PACKAGE INV_INVIRITS_XMLP_PKG AS
2 /* $Header: INVIRITSS.pls 120.1 2007/12/25 10:28:46 dwkrishn noship $ */
3   P_ORG NUMBER;
4 
5 
6   P_CONC_REQUEST_ID NUMBER := 0;
7 
8   P_CATG_LO VARCHAR2(2000);
9 
10   P_CATG_HI VARCHAR2(2000);
11 
12   P_CATG_FLEXDATA VARCHAR2(900) := '(MCAT.SEGMENT1||''\n''||MCAT.SEGMENT2||''\n''||MCAT.SEGMENT3||''\n''||MCAT.SEGMENT4||''\n''||MCAT.SEGMENT5||''\n''||MCAT.SEGMENT6||''\n''||MCAT.SEGMENT7||''\n''||MCAT.SEGMENT8||''\n''||MCAT.SEGMENT9||''\n''||
13   MCAT.SEGMENT10||''\n''||MCAT.SEGMENT11||''\n''||MCAT.SEGMENT12||''\n''||MCAT.SEGMENT13||''\n''||MCAT.SEGMENT14||''\n''||MCAT.SEGMENT15||''\n''||MCAT.SEGMENT16||''\n''||MCAT.SEGMENT17||''\n''||MCAT.SEGMENT18||''\n''||MCAT.SEGMENT19||''\n''
14   ||MCAT.SEGMENT20)';
15 
16   P_ITEM_FLEXDATA VARCHAR2(820);
17 
18   P_CATG_WHERE VARCHAR2(2000);
19 
20   P_STRUCT_NUM NUMBER;
21 
22   P_CATG_STRUCTURE_ID NUMBER;
23 
24   P_CATG_SET_ID NUMBER;
25 
26   P_SORT_ID NUMBER;
27 
28   P_ITEM_WHERE VARCHAR2(2000);
29 
30   P_ICG_FLEXDATA VARCHAR2(2000) := '(ICG.SEGMENT1||''\n''||ICG.SEGMENT2||''\n''||ICG.SEGMENT3||''\n''||ICG.SEGMENT4||''\n''||ICG.SEGMENT5||''\n''||ICG.SEGMENT6||''\n''||ICG.SEGMENT7||''\n''||ICG.SEGMENT8||''\n''||ICG.SEGMENT9
31   ||''\n''||ICG.SEGMENT10||''\n''||ICG.SEGMENT11||''\n''||ICG.SEGMENT12||''\n''||ICG.SEGMENT13||''\n''||ICG.SEGMENT14||''\n''||ICG.SEGMENT15)';
32 
33   P_ICG_WHERE VARCHAR2(2000);
34 
35   P_ICG_LO VARCHAR2(2000);
36 
37   P_ICG_HI VARCHAR2(2000);
38 
39   P_ITEM_LO VARCHAR2(2000);
40 
41   P_ITEM_HI VARCHAR2(2000);
42 
43   P_ITEM_ORDER VARCHAR2(900);
44 
45   P_CATG_FLEXSORT VARCHAR2(2000);
46 
47   P_ICG_FLEXSORT VARCHAR2(2000);
48 
49   P_DESC_OPTION NUMBER;
50 
51   P_SEPARATOR VARCHAR2(32767);
52 
53   P_CURRENCY_CODE VARCHAR2(3);
54   P_CURRENCY_CODE1 VARCHAR2(3);
55 
56   P_EXCHANGE_RATE NUMBER;
57 
58   FUNCTION AFTERREPORT RETURN BOOLEAN;
59 
60   FUNCTION BEFOREREPORT RETURN BOOLEAN;
61 
62   FUNCTION C_FROMFORMULA RETURN VARCHAR2;
63 
64   FUNCTION C_WHEREFORMULA RETURN VARCHAR2;
65 
66   FUNCTION BEFOREPFORM RETURN BOOLEAN;
67 
68   FUNCTION C_CAT_SET_NAMEFORMULA RETURN VARCHAR2;
69 
70   FUNCTION C_BREAK_OPTION_PADFORMULA(C_BREAK_OPTION_PAD IN VARCHAR2) RETURN VARCHAR2;
71 
72   FUNCTION C_CURRENCY_CODEFORMULA(R_CURRENCY_CODE IN VARCHAR2
73                                  ,EXT_PRECISION_SAVED IN VARCHAR2) RETURN VARCHAR2;
74 
75   FUNCTION C_CATG_FROMFORMULA RETURN VARCHAR2;
76 
77   FUNCTION C_CATG_WHEREFORMULA RETURN VARCHAR2;
78 
79   FUNCTION C_ICG_FROMFORMULA RETURN VARCHAR2;
80 
81   FUNCTION C_ICG_WHEREFORMULA RETURN VARCHAR2;
82 
83   FUNCTION C_ICG_DESCFORMULA(ITEM_ID IN NUMBER) RETURN VARCHAR2;
84 
85  FUNCTION C_break_option_pad_F(C_break_option_pad in varchar2) RETURN VARCHAR2;
86  FUNCTION C_break_option_value_F(C_break_option_value in varchar2) RETURN VARCHAR2;
87 END INV_INVIRITS_XMLP_PKG;
88 
89 
90