PACKAGE: APPS.ONT_OEXOEORR_XMLP_PKG

Source

1 PACKAGE ONT_OEXOEORR_XMLP_PKG AS
2 /* $Header: OEXOEORRS.pls 120.2 2008/05/05 12:40:45 dwkrishn noship $ */
3   P_CONC_REQUEST_ID NUMBER := 0;
4 
5   P_SOB_ID NUMBER;
6 
7   P_RETURN_REASON VARCHAR2(50);
8 
9   P_ORDER_BY VARCHAR2(30);
10 
11   P_ITEM_FLEX_CODE VARCHAR2(32767);
12 
13   P_ORG_ID NUMBER;
14 
15   CP_ORDER_DATE_LOW varchar2(30);
16 
17   CP_ORDER_DATE_HIGH varchar2(30);
18 
19   P_ORDER_DATE_LOW DATE;
20 
21   P_ORDER_DATE_HIGH DATE;
22 
23   LP_ITEM_FLEX_CODE_HIGH VARCHAR2(600);
24 
25   LP_ITEM_FLEX_CODE_LOW VARCHAR2(600);
26 
27   LP_ORDER_DATE VARCHAR2(200):='  ';
28 
29   P_PRINT_DESCRIPTION VARCHAR2(32767);
30 
31   LP_RETURN_REASON VARCHAR2(1000):='  ';
32 
33   P_MIXED_PRECISION NUMBER;
34 
35   P_ITEM NUMBER;
36 
37   LP_ITEM_FLEX_ALL_SEG VARCHAR2(1000):='  ';
38 
39   P_ITEM_STRUCTURE_NUM NUMBER;
40 
41   P_CREDIT_ORDER_TYPE VARCHAR2(80);
42 
43   P_CREDIT_ORDER_LINE_TYPE VARCHAR2(80);
44 
45   LP_CREDIT_ORDER_TYPE VARCHAR2(200):='  ';
46 
47   LP_CREDIT_ORDER_LINE_TYPE VARCHAR2(200):='  ';
48 
49   P_ENABLE_TRACE VARCHAR2(5);
50 
51   L_ORDER_TYPE VARCHAR2(30);
52 
53   L_LINE_TYPE VARCHAR2(30);
54 
55   P_ITEM_NAME VARCHAR2(200);
56 
57   RP_REPORT_NAME VARCHAR2(240);
58 
59   RP_SUB_TITLE VARCHAR2(240);
60 
61   RP_COMPANY_NAME VARCHAR2(100);
62 
63   RP_FUNCTIONAL_CURRENCY VARCHAR2(20);
64 
65   RP_DATA_FOUND VARCHAR2(300);
66 
67   RP_ITEM_FLEX_LPROMPT VARCHAR2(100);
68 
69   RP_ITEM_FLEX_CODE VARCHAR2(500) := 'SI.SEGMENT1';
70 
71   RP_ITEM_FLEX_APROMPT VARCHAR2(100);
72 
73   RP_ORDER_DATE_RANGE VARCHAR2(47);
74 
75   RP_ORDER_BY VARCHAR2(100);
76 
77   RP_RETURN_REASON VARCHAR2(80);
78 
79   RP_FLEX_OR_DESC VARCHAR2(80);
80 
81   RP_ITEM_FLEX_ALL_SEG_WHERE VARCHAR2(1000);
82 
83   RP_ITEM_ORDER_BY VARCHAR2(1000):='  ';
84 
85   RP_ITEM_FLEX_ALL_SEG VARCHAR2(500) := 'SI.SEGMENT1';
86 
87   RP_CREDIT_ORDER_TYPE VARCHAR2(50);
88 
89   RP_CREDIT_LINE_TYPE VARCHAR2(50);
90 
91   RP_DUMMY_ITEM VARCHAR2(240);
92 
93   FUNCTION BEFOREREPORT RETURN BOOLEAN;
94 
95   FUNCTION AFTERREPORT RETURN BOOLEAN;
96 
97   FUNCTION P_ITEM_FLEX_CODEVALIDTRIGGER RETURN BOOLEAN;
98 
99   FUNCTION AFTERPFORM RETURN BOOLEAN;
100 
101   FUNCTION C_SET_LBLFORMULA RETURN VARCHAR2;
102 
103   FUNCTION C_VALUEFORMULA(UNIT_SELLING_PRICE IN NUMBER
104                          ,FULFILLED_QTY IN NUMBER) RETURN NUMBER;
105 
106   FUNCTION C_MASTER_ORGFORMULA RETURN CHAR;
107 
108   FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
109 
110   FUNCTION RP_SUB_TITLE_P RETURN VARCHAR2;
111 
112   FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
113 
114   FUNCTION RP_FUNCTIONAL_CURRENCY_P RETURN VARCHAR2;
115 
116   FUNCTION RP_DATA_FOUND_P RETURN VARCHAR2;
117 
118   FUNCTION RP_ITEM_FLEX_LPROMPT_P RETURN VARCHAR2;
119 
120   FUNCTION RP_ITEM_FLEX_CODE_P RETURN VARCHAR2;
121 
122   FUNCTION RP_ITEM_FLEX_APROMPT_P RETURN VARCHAR2;
123 
124   FUNCTION RP_ORDER_DATE_RANGE_P RETURN VARCHAR2;
125 
126   FUNCTION RP_ORDER_BY_P RETURN VARCHAR2;
127 
128   FUNCTION RP_RETURN_REASON_P RETURN VARCHAR2;
129 
130   FUNCTION RP_FLEX_OR_DESC_P RETURN VARCHAR2;
131 
132   FUNCTION RP_ITEM_FLEX_ALL_SEG_WHERE_P RETURN VARCHAR2;
133 
134   FUNCTION RP_ITEM_ORDER_BY_P RETURN VARCHAR2;
135 
136   FUNCTION RP_ITEM_FLEX_ALL_SEG_P RETURN VARCHAR2;
137 
138   FUNCTION RP_CREDIT_ORDER_TYPE_P RETURN VARCHAR2;
139 
140   FUNCTION RP_CREDIT_LINE_TYPE_P RETURN VARCHAR2;
141 
142   FUNCTION RP_DUMMY_ITEM_P RETURN VARCHAR2;
143 
144  FUNCTION ITEM_DSPFORMULA(ITEM_IDENTIFIER_TYPE IN VARCHAR2,INVENTORY_ITEM_ID1 IN NUMBER,ORDERED_ITEM_ID IN NUMBER,ORDERED_ITEM IN VARCHAR2,C_ORGANIZATION_ID IN VARCHAR2,C_INVENTORY_ITEM_ID IN VARCHAR2) RETURN CHAR;
145 END ONT_OEXOEORR_XMLP_PKG;
146