PACKAGE: APPS.INV_INVDRRSV_XMLP_PKG

Source

1 PACKAGE INV_INVDRRSV_XMLP_PKG AS
2 /* $Header: INVDRRSVS.pls 120.2 2008/01/08 06:45:59 dwkrishn noship $ */
3   P_ORG_ID NUMBER;
4 
5   P_CONC_REQUEST_ID NUMBER := 0;
6 
7   P_STRUCT_NUM NUMBER;
8 
9   P_CAT_STRUCT_NUM NUMBER;
10 
11   P_ITEM_FLEX VARCHAR2(800);
12 
13   P_CAT_FLEX VARCHAR2(900) := '(MC.SEGMENT1||''\n''||MC.SEGMENT2||''\n''||MC.SEGMENT3||''\n''||MC.SEGMENT4||''\n''||
14   MC.SEGMENT5||''\n''||MC.SEGMENT6||''\n''||MC.SEGMENT7||''\n''||MC.SEGMENT8||''\n''||MC.SEGMENT9||''\n''||MC.SEGMENT10||''\n''||MC.SEGMENT11||''\n''||MC.SEGMENT12||''\n''||
15   MC.SEGMENT13||''\n''||MC.SEGMENT14||''\n''||MC.SEGMENT15||''\n''||MC.SEGMENT16||''\n''||MC.SEGMENT17||''\n''||MC.SEGMENT18||''\n''||MC.SEGMENT19||''\n''||MC.SEGMENT20)';
16 
17   P_CAT_SET_ID NUMBER;
18 
19   P_LOC_FLEX VARCHAR2(800);
20 
21   P_CONDITION VARCHAR2(40);
22 
23   P_SORT_ID NUMBER;
24 
25   P_ORDER_ITEM VARCHAR2(300);
26 
27   P_SOURCE_TYPE_ID NUMBER;
28 
29   P_ITEM_HI VARCHAR2(900);
30 
31   P_ITEM_LO VARCHAR2(900);
32 
33   P_SOURCE_LO VARCHAR2(900);
34 
35   P_SOURCE_HI VARCHAR2(900);
36 
37   P_DATE_LO VARCHAR2(22);
38 
39   P_DATE_HI VARCHAR2(22);
40   --added as fix 3 variables
41   P_DATE_LO_V VARCHAR2(22);
42 
43   P_DATE_HI_V VARCHAR2(22);
44   QTY_PRECISION varchar2(22);
45 
46   P_SO_FLEX VARCHAR2(900);
47 
48   P_GL_FLEX VARCHAR2(900);
49 
50   P_ALIAS_FLEX VARCHAR2(900);
51 
52   P_CAT_LO VARCHAR2(900);
53 
54   P_CAT_HI VARCHAR2(900);
55 
56   P_CAT_WHERE VARCHAR2(900);
57 
58   P_ITEM_WHERE VARCHAR2(900):=' 2=2 ';
59 
60   P_BREAK_ID NUMBER;
61 
62   P_QTY_PRECISION NUMBER;
63 
64   P_ACCT_STRUCT_NUM NUMBER;
65 
66   P_ORDER_SOURCE VARCHAR2(900) := 'C_sort_flex';
67 
68   P_SOURCE_WHERE VARCHAR2(1200);
69 
70   FUNCTION BEFOREREPORT RETURN BOOLEAN;
71 
72   FUNCTION AFTERREPORT RETURN BOOLEAN;
73 
74   FUNCTION C_CURRENCY_CODEFORMULA(R_CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
75 
76   FUNCTION C_FROM_CATFORMULA RETURN VARCHAR2;
77 
78   FUNCTION C_CAT_WHEREFORMULA RETURN VARCHAR2;
79 
80   FUNCTION BEFOREPFORM RETURN BOOLEAN;
81 
82   FUNCTION C_ORDER_BYFORMULA RETURN VARCHAR2;
83 
84   FUNCTION C_CAT_PADFORMULA(C_CAT_PAD IN VARCHAR2) RETURN VARCHAR2;
85 
86   FUNCTION C_SORT_PADFORMULA(C_SORT_PAD IN VARCHAR2) RETURN VARCHAR2;
87 
88   FUNCTION C_ITEM_PADFORMULA(C_ITEM_PAD IN VARCHAR2) RETURN VARCHAR2;
89 
90   FUNCTION C_SOURCE_WHEREFORMULA RETURN VARCHAR2;
91 
92   FUNCTION C_SOURCE_FROMFORMULA(C_SOURCE_WHERE IN VARCHAR2) RETURN VARCHAR2;
93 
94   FUNCTION C_SOURCE_TYPE_NAMEFORMULA RETURN VARCHAR2;
95 
96   FUNCTION C_CAT_SET_NAMEFORMULA RETURN VARCHAR2;
97 
98   FUNCTION C_DATE_WHEREFORMULA RETURN VARCHAR2;
99 
100   FUNCTION AFTERPFORM RETURN BOOLEAN;
101 
102   FUNCTION C_SRC_WHEREFORMULA RETURN VARCHAR2;
103 
104   FUNCTION C_SORT_DATE_FIELDFORMULA(C_SORT_FLEX IN VARCHAR2) RETURN DATE;
105 
106 END INV_INVDRRSV_XMLP_PKG;
107