[Home] [Help]
PACKAGE: APPS.WSH_WSHRDBSR_XMLP_PKG
Source
1 PACKAGE WSH_WSHRDBSR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: WSHRDBSRS.pls 120.3 2008/02/12 13:01:27 dwkrishn noship $ */
3 P_CONC_REQUEST_ID NUMBER := 0;
4
5 P_TRANSACTION_TYPE_ID NUMBER;
6
7 P_HEADER_ID_LOW NUMBER;
8
9 P_HEADER_ID_HIGH NUMBER;
10
11 P_ITEM_FLEX_CODE VARCHAR2(32767);
12
13 P_ORGANIZATION_ID NUMBER;
14
15 P_USER_ID VARCHAR2(100);
16
17 LP_ITEM_FLEX_ALL_SEG_LOW VARCHAR2(600);
18
19 LP_ITEM_FLEX_ALL_SEG_HIGH VARCHAR2(600);
20
21 --LP_ORDER_TYPE VARCHAR2(500);
22 LP_ORDER_TYPE VARCHAR2(500):=' ';
23
24 --LP_HEADER_NUMBER VARCHAR2(500);
25 LP_HEADER_NUMBER VARCHAR2(500):=' ';
26
27 RP_USER_ID VARCHAR2(200);
28
29 RP_ORDER_TYPE_NAME VARCHAR2(30);
30
31 LP_ITEM_DISPLAY_VALUE VARCHAR2(200) := 'wdd.item_description';
32
33 P_ITEM_DISPLAY VARCHAR2(2);
34
35 LP_STRUCTURE_NUM NUMBER := 101;
36
37 LP_MOVE_ORDER VARCHAR2(200);
38
39 P_ORDER_NUM_HIGH NUMBER;
40
41 P_ORDER_NUM_LOW NUMBER;
42
43 LP_ORGANIZATION_ID VARCHAR2(100):= ' ';
44
45 RP_REPORT_NAME VARCHAR2(240);
46
47 RP_SUB_TITLE VARCHAR2(80);
48
49 RP_COMPANY_NAME VARCHAR2(240);
50
51 RP_DATA_FOUND VARCHAR2(300);
52
53 RP_ITEM_FLEX_ALL_SEG VARCHAR2(500) := 'SI.SEGMENT1';
54
55 RP_ORDER_RANGE VARCHAR2(40);
56
57 RP_ORDER_BY VARCHAR2(80);
58
59 RP_FLEX_OR_DESC VARCHAR2(80);
60
61 RP_WAREHOUSE VARCHAR2(240);
62
63 RP_ORDER_NUM_LOW NUMBER;
64
65 RP_ORDER_NUM_HIGH NUMBER;
66
67 FUNCTION BEFOREREPORT RETURN BOOLEAN;
68
69 FUNCTION AFTERREPORT RETURN BOOLEAN;
70
71 FUNCTION P_ORGANIZATION_IDVALIDTRIGGER RETURN BOOLEAN;
72
73 FUNCTION P_ITEM_FLEX_CODEVALIDTRIGGER RETURN BOOLEAN;
74
75 FUNCTION AFTERPFORM RETURN BOOLEAN;
76
77 FUNCTION C_SET_LBLFORMULA RETURN VARCHAR2;
78
79 FUNCTION CF_ITEM_DESCRIPTIONFORMULA(INVENTORY_ITEM_ID1 IN NUMBER
80 ,ORGANIZATION_ID IN NUMBER
81 ,ITEM_DESCRIPTION IN VARCHAR2) RETURN VARCHAR2;
82
83 FUNCTION CF_BO_AMTFORMULA(BACKORDERED_QUANTITY IN NUMBER
84 ,UNIT_PRICE IN NUMBER) RETURN NUMBER;
85
86 FUNCTION CF_SHIPPED_AMTFORMULA(CF_SHIPPED_QTY IN NUMBER
87 ,UNIT_PRICE IN NUMBER) RETURN NUMBER;
88
89 FUNCTION CF_WAREHOUSEFORMULA(ORGANIZATION_ID_V IN NUMBER) RETURN CHAR;
90
91 FUNCTION CF_SHIPPED_QTYFORMULA(CURRENCY_CODE_V IN VARCHAR2
92 ,ORGANIZATION_ID_V IN NUMBER
93 ,INVENTORY_ITEM_ID1 IN NUMBER
94 ,SOURCE_HEADER_NUMBER_V IN VARCHAR2
95 ,ORDER_TYPE IN VARCHAR2
96 ,REQUESTED_QUANTITY_UOM_V IN VARCHAR2
97 ,UNIT_PRICE_V IN NUMBER) RETURN NUMBER;
98
99 FUNCTION CF_LAST_SHIPPED_DATEFORMULA(ORGANIZATION_ID IN NUMBER
100 ,SOURCE_HEADER_NUMBER IN VARCHAR2) RETURN DATE;
101
102 FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
103
104 FUNCTION RP_SUB_TITLE_P RETURN VARCHAR2;
105
106 FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
107
108 FUNCTION RP_DATA_FOUND_P RETURN VARCHAR2;
109
110 FUNCTION RP_ITEM_FLEX_ALL_SEG_P RETURN VARCHAR2;
111
112 FUNCTION RP_ORDER_RANGE_P RETURN VARCHAR2;
113
114 FUNCTION RP_ORDER_BY_P RETURN VARCHAR2;
115
116 FUNCTION RP_FLEX_OR_DESC_P RETURN VARCHAR2;
117
118 FUNCTION RP_WAREHOUSE_P RETURN VARCHAR2;
119
120 FUNCTION RP_ORDER_NUM_LOW_P RETURN NUMBER;
121
122 FUNCTION RP_ORDER_NUM_HIGH_P RETURN NUMBER;
123
124 PROCEDURE SET_NAME(APPLICATION IN VARCHAR2
125 ,NAME IN VARCHAR2);
126
127 PROCEDURE SET_TOKEN(TOKEN IN VARCHAR2
128 ,VALUE IN VARCHAR2
129 ,TRANSLATE IN BOOLEAN);
130
131 PROCEDURE RETRIEVE(MSGOUT OUT NOCOPY VARCHAR2);
132
133 PROCEDURE CLEAR;
134
135 FUNCTION GET_STRING(APPIN IN VARCHAR2
136 ,NAMEIN IN VARCHAR2) RETURN VARCHAR2;
137
138 FUNCTION GET_NUMBER(APPIN IN VARCHAR2
139 ,NAMEIN IN VARCHAR2) RETURN NUMBER;
140
141 FUNCTION GET RETURN VARCHAR2;
142
143 FUNCTION GET_ENCODED RETURN VARCHAR2;
144
145 PROCEDURE PARSE_ENCODED(ENCODED_MESSAGE IN VARCHAR2
146 ,APP_SHORT_NAME OUT NOCOPY VARCHAR2
147 ,MESSAGE_NAME OUT NOCOPY VARCHAR2);
148
149 PROCEDURE SET_ENCODED(ENCODED_MESSAGE IN VARCHAR2);
150
151 PROCEDURE RAISE_ERROR;
152
153 END WSH_WSHRDBSR_XMLP_PKG;
154