[Home] [Help]
PACKAGE: APPS.ONT_OEXOEORD_XMLP_PKG
Source
1 PACKAGE ONT_OEXOEORD_XMLP_PKG AS
2 /* $Header: OEXOEORDS.pls 120.2 2008/05/05 12:39:57 dwkrishn noship $ */
3 P_CONC_REQUEST_ID NUMBER := 0;
4
5 P_SOB_ID NUMBER;
6
7 P_RETURN_TYPE VARCHAR2(50);
8
9 P_ORDER_BY VARCHAR2(30);
10
11 P_RETURN_NUM_LOW VARCHAR2(32767);
12
13 P_RETURN_NUM_HIGH VARCHAR2(32767);
14
15 P_CUSTOMER_NAME_LOW VARCHAR2(360);
16
17 P_ITEM_FLEX_CODE VARCHAR2(32767);
18
19 P_ORGANIZATION_ID VARCHAR2(32767);
20
21 P_RETURN_DATE_LOW DATE;
22
23 P_RETURN_DATE_HIGH DATE;
24
25 P_SALESREP VARCHAR2(240);
26
27 P_MIN_PRECISION NUMBER;
28
29 LP_RETURN_NUM VARCHAR2(500);
30
31 LP_RETURN_DATE VARCHAR2(500);
32
33 SORT_BY_MEANING VARCHAR2(50);
34
35 RETURN_NUM_PARMS VARCHAR2(50);
36
37 RETURN_DATE_PARMS VARCHAR2(50);
38
39 P_PRINT_DESCRIPTION VARCHAR2(1);
40
41 P_CREDIT_ONLY VARCHAR2(3);
42
43 CREDIT_ONLY_MEANING VARCHAR2(5);
44
45 LP_CREDIT_ONLY VARCHAR2(1000);
46
47 P_ITEM NUMBER;
48
49 LP_ITEM VARCHAR2(640);
50
51 LP_RETURN_TYPE VARCHAR2(500);
52
53 LP_SALESREP VARCHAR2(500);
54
55 LP_CUSTOMER_NAME VARCHAR2(500);
56
57 P_ITEM_STRUCTURE_NUM NUMBER;
58
59 LP_RETURN_LINE_TYPE VARCHAR2(500);
60
61 LP_CUSTOMER_NUM VARCHAR2(500);
62
63 P_CUSTOMER_NAME_HIGH VARCHAR2(360);
64
65 P_CUSTOMER_NUM_LOW VARCHAR2(100);
66
67 P_CUSTOMER_NUM_HIGH VARCHAR2(100);
68
69 P_RETURN_LINE_TYPE VARCHAR2(100);
70
71 CUSTOMER_PARMS VARCHAR2(50);
72
73 CUSTOMER_NUM_PARMS VARCHAR2(50);
74
75 P_LINE_CATEGORY VARCHAR2(32767);
76
77 LP_LINE_CATEGORY VARCHAR2(500);
78
79 LP_OPEN_RETURNS_ONLY VARCHAR2(500);
80
81 P_OPEN_RETURNS_ONLY VARCHAR2(32767);
82
83 P_LANG VARCHAR2(32767);
84
85 P_ENABLE_TRACE VARCHAR2(5);
86
87 L_ORDER_TYPE VARCHAR2(30);
88
89 L_LINE_TYPE VARCHAR2(30);
90
91 P_ITEM_NAME VARCHAR2(200);
92
93 RP_REPORT_NAME VARCHAR2(240);
94
95 RP_SUB_TITLE VARCHAR2(80);
96
97 RP_COMPANY_NAME VARCHAR2(50);
98
99 RP_FUNCTIONAL_CURRENCY VARCHAR2(20);
100
101 RP_DATA_FOUND VARCHAR2(300);
102
103 RP_ITEM_FLEX_ALL_SEG VARCHAR2(500) := 'SI.SEGMENT1';
104
105 RP_PRINT_DESCRIPTION VARCHAR2(80);
106
107 RP_OPEN_RETURNS_ONLY VARCHAR2(80);
108
109 RP_CURR_PROFILE VARCHAR2(50);
110
111 FUNCTION BEFOREREPORT RETURN BOOLEAN;
112
113 FUNCTION AFTERREPORT RETURN BOOLEAN;
114
115 FUNCTION P_ITEM_FLEX_CODEVALIDTRIGGER RETURN BOOLEAN;
116
117 FUNCTION AFTERPFORM RETURN BOOLEAN;
118
119 FUNCTION P_ORDER_BYVALIDTRIGGER RETURN BOOLEAN;
120
121 FUNCTION P_ITEM_DISPLAYVALIDTRIGGER RETURN BOOLEAN;
122
123 FUNCTION AMT_EXPECTEDFORMULA(QTY_AUTHORIZED IN NUMBER
124 ,SELLING_PRICE IN NUMBER
125 ,CURRENCY_CODE IN VARCHAR2) RETURN NUMBER;
126
127 FUNCTION AMT_RECEIVEDFORMULA(QTY_RECEIVED IN NUMBER
128 ,SELLING_PRICE IN NUMBER
129 ,CURRENCY_CODE IN VARCHAR2) RETURN NUMBER;
130
131 FUNCTION AMT_ACCEPTEDFORMULA(QTY_ACCEPTED IN NUMBER
132 ,SELLING_PRICE IN NUMBER
133 ,CURRENCY_CODE IN VARCHAR2) RETURN NUMBER;
134
135 FUNCTION P_CREDIT_ONLYVALIDTRIGGER RETURN BOOLEAN;
136
137 FUNCTION REF_NUMFORMULA(REF_ID IN VARCHAR2
138 ,REF_TYPE_CODE IN VARCHAR2
139 ,LINE_ID IN NUMBER) RETURN VARCHAR2;
140
141 FUNCTION C_TOTAL_RMAFORMULA(TOTAL_RMA IN NUMBER) RETURN NUMBER;
142
143 FUNCTION C_TOTAL_LINESFORMULA(TOTAL_LINES IN NUMBER) RETURN NUMBER;
144
145 FUNCTION C_MASTER_ORGFORMULA RETURN NUMBER;
146
147 FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
148
149 FUNCTION RP_SUB_TITLE_P RETURN VARCHAR2;
150
151 FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
152
153 FUNCTION RP_FUNCTIONAL_CURRENCY_P RETURN VARCHAR2;
154
155 FUNCTION RP_DATA_FOUND_P RETURN VARCHAR2;
156
157 FUNCTION RP_ITEM_FLEX_ALL_SEG_P RETURN VARCHAR2;
158
159 FUNCTION RP_PRINT_DESCRIPTION_P RETURN VARCHAR2;
160
161 FUNCTION RP_OPEN_RETURNS_ONLY_P RETURN VARCHAR2;
162
163 FUNCTION RP_CURR_PROFILE_P RETURN VARCHAR2;
164
165 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;
166
167 END ONT_OEXOEORD_XMLP_PKG;
168