[Home] [Help]
PACKAGE: APPS.ONT_OEXOEORR_XMLP_PKG
Source
1 PACKAGE ONT_OEXOEORR_XMLP_PKG AUTHID CURRENT_USER 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