eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.PO_POXDLPDT_XMLP_PKG

Source


1 PACKAGE PO_POXDLPDT_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: POXDLPDTS.pls 120.1 2007/12/25 10:57:20 krreddy noship $ */
3   P_TITLE VARCHAR2(50);
4 
5   P_CONC_REQUEST_ID NUMBER := 0;
6 
7   P_QTY_PRECISION NUMBER;
8 
9   QTY_PRECISION varchar2(100);
10 
11   P_FLEX_ITEM VARCHAR2(800);
12 
13   from_lexical varchar2(500);
14 
15   from_lexical_1 varchar2(500);
16 
17   and_lexical varchar2(500);
18 
19   P_FLEX_CAT VARCHAR2(31000);
20 
21   P_DELIVERY_LOCATION VARCHAR2(240);
22 
23   P_RECEIPT_NUM_FROM VARCHAR2(40);
24 
25   P_RECEIPT_NUM_TO VARCHAR2(40);
26 
27   P_CATEGORY_FROM VARCHAR2(900);
28 
29   P_CATEGORY_TO VARCHAR2(900);
30 
31   P_ITEM_FROM VARCHAR2(900);
32 
33   P_ITEM_TO VARCHAR2(900);
34 
35   P_SHIP_TO_LOCATION VARCHAR2(40);
36 
37   P_STRUCT_NUM NUMBER;
38 
39   P_ITEM_STRUCT_NUM NUMBER;
40 
41   P_WHERE_ITEM VARCHAR2(2400);
42 
43   P_WHERE_CAT VARCHAR2(2400);
44 
45   P_GROUP_ID NUMBER;
46 
47   P_SUPPLY_DAYS VARCHAR2(40);
48 
49   P_FLEX_LOCATOR VARCHAR2(800) := '(MSL.SEGMENT1||''\n''||MSL.SEGMENT2||''\n''||MSL.SEGMENT3||''\n''||MSL.SEGMENT4||''\n''||MSL.SEGMENT5||''\n''||MSL.SEGMENT6||''\n''||MSL.SEGMENT7||''\n''||MSL.SEGMENT8||''\n''||MSL.SEGMENT9||''\n''
50   ||MSL.SEGMENT10||''\n''||MSL.SEGMENT11||''\n''||MSL.SEGMENT12||''\n''||MSL.SEGMENT13||''\n''||MSL.SEGMENT14||''\n''||MSL.SEGMENT15||''\n''||MSL.SEGMENT16||''\n''||MSL.SEGMENT17||''\n''||MSL.SEGMENT18||''\n''||MSL.SEGMENT19||''\n''||MSL.SEGMENT20)';
51 
52   P_WIP_STATUS VARCHAR2(1);
53 
54   P_ORG_ID NUMBER;
55 
56   P_ORG_DISPLAYED VARCHAR2(60);
57 
58   SERIAL_CONTROL_CODE VARCHAR2(40);
59 
60   P_INV_STATUS VARCHAR2(1);
61 
62   P_WHERE_ORG_ID VARCHAR2(100) := '1=1';
63 
64   P_WHERE_GROUP_ID VARCHAR2(200) := '1=1';
65 
66   P_WHERE_SHIP_TO_LOCATION VARCHAR2(200) := '1=1';
67 
68   P_WHERE_DELIVER_TO_LOCATION VARCHAR2(200) := '1=1';
69 
70   P_WHERE_RECEIPT_NUM_FROM VARCHAR2(200) := '1=1';
71 
72   P_WHERE_RECEIPT_NUM_TO VARCHAR2(200) := '1=1';
73 
74   P_ORDERBY VARCHAR2(200);
75 
76   P_SELECT_RECEIPTS VARCHAR2(6200) := 'SELECT rrp.org_id, rrp.item_id,rrp.organization_id rrp_organization_id,MSI.SEGMENT1||''''||MSI.SEGMENT2||''''||MSI.SEGMENT3||''''||MSI.SEGMENT19||''''||MSI.SEGMENT20 C_FLEX_ITEM,MCA.SEGMENT1||''''||MCA.SEGMENT2
77   ||''''||MCA.SEGMENT3||''''||MCA.SEGMENT19||''''||MCA.SEGMENT20 C_FLEX_CAT,rrp.revision_num,rrp.category_id,rrp.item_description,rrp.un_num,rrp.un_description,rrp.hazard_class,rrp.routing_name,rrp.document_type_code,rrp.document_number,
78   rrp.release_num,rrp.line_num,rrp.buyer_preparer_name,rrp.source_type,rrp.source,rrp.source_unit_of_measure,rrp.vendor_product_num,fnd_date.date_to_canonical(rrp.due_date) due_date,round(rrp.quantity_ordered,:P_qty_precision) quantity_ordered,
79   rrp.note_to_receiver,rrp.pll_note_to_receiver,rrp.receipt_num RECEIPT_NUM,rrp.receipt_unit_of_measure,fnd_date.date_to_canonical(rrp.receipt_date) receipt_date,rrp.receipt_location,rrp.receiver_first_name,rrp.receiver_last_name,
80   rrp.freight_carrier,round(rrp.quantity_received,:P_qty_precision) quantity_received,rrp.primary_quantity parent_primary_quantity,round(rrp.quantity_remaining,:P_qty_precision) quantity_remaining,rrp.shipment_num,rrp.bill_of_lading,
81   rrp.vendor_lot_num,rrp.packing_slip_num,rrp.containers,rrp.receiver_comment,rrp.transaction_type rrp_transaction_type,rrp.transaction_id rrp_transaction_id,rrp.shipment_line_id rrp_shipment_line_id,rrp.shipment_header_id rrp_shipment_header_id,
82   rrp.distribution_id rrp_distribution_id,rrp.po_header_id,rrp.po_line_id,rrp.po_line_location_id,rrp.requisition_header_id,rrp.requisition_line_id,rrp.from_interface rrp_from_interface,rrp.deliver_to_location,rrp.license_plate_number,
83   rrp.locator_id, rrp.receiving_subinventory  from rcv_receipts_print rrp, mtl_system_items msi, mtl_categories mca';
84 
85   P_SELECT_DISTRIBUTIONS VARCHAR2(6200) := 'SELECT rdp.destination_type, rdp.destination, rdp.document_num, rdp.deliver_unit_of_measure, rdp.outstanding_quantity, rdp.note_to_deliver, rdp.pll_note_to_deliver, rdp.deliver_transaction_type,
86   rdp.transaction_id, rdp.distribution_id, round( rdp.quantity_delivered, :P_qty_precision) quantity_delivered, fnd_date.date_to_canonical(rdp.delivery_date) delivery_date, rdp.delivered_by, rdp.from_interface, rdp.deliver_to_person,
87   rdp.deliver_to_location, rdp.deliver_to_org, rdp.destination_subinventory, rdp.locator_id, MSL.SEGMENT1||'' ''||MSL.SEGMENT2||'' ''||MSL.SEGMENT3||'' ''||MSL.SEGMENT4||'' ''||MSL.SEGMENT5||'' ''||MSL.SEGMENT6||'' ''||MSL.SEGMENT7
88   ||'' ''||MSL.SEGMENT8||'' ''||MSL.SEGMENT9||'' ''||MSL.SEGMENT10||'' ''||MSL.SEGMENT11||'' ''||MSL.SEGMENT12||'' ''||MSL.SEGMENT13||'' ''||MSL.SEGMENT14||'' ''||MSL.SEGMENT15||'' ''||MSL.SEGMENT16||'' ''||MSL.SEGMENT17||'' ''||
89   MSL.SEGMENT18||'' ''||MSL.SEGMENT19||'' ''||MSL.SEGMENT20 C_FLEX_LOCATOR, we.wip_entity_name job_or_schedule, wl.line_code line , wn.operation_seq_num op_seq, bd.department_code department, rdp.license_plate_number FROM
90   rcv_distributions_print rdp, wip_lines wl, wip_entities we, bom_departments bd, wip_operation_resources wr, wip_operations wn, wip_operations wo, mtl_item_locations msl';
91 
92   P_RECEIPT_SOURCE_TYPE VARCHAR2(30);
93 
94   P_WIP_FROM_DIST VARCHAR2(500);
95 
96   P_WIP_SELECT_DIST VARCHAR2(500) := ', rdp.DELIVER_TO_PERSON job_or_schedule, rdp.DESTINATION_SUBINVENTORY line, to_number(null) op_seq, rdp.DESTINATION_SUBINVENTORY department';
97 
98   P_WIP_WHERE_DIST VARCHAR2(32000);
99 
100   P_UNION_UPPER_UPPER VARCHAR2(32000) := 'SELECT WE.WIP_ENTITY_NAME  Work_Order,WL.LINE_CODE   Line,WRO.DATE_REQUIRED  Date_Required, WRO.QUANTITY_ISSUED  Quantity_Issued,WRO.REQUIRED_QUANTITY  Quantity_Required,''XXX''  Processing_Mode';
101 
102   P_UNION_LOWER_UPPER VARCHAR2(32000) := 'SELECT WE.WIP_ENTITY_NAME  Work_Order,WL.LINE_CODE   Line,WRO.DATE_REQUIRED  Date_Required, WRO.QUANTITY_ISSUED  Quantity_Issued,WRO.REQUIRED_QUANTITY  Quantity_Required,''XXX''  Processing_Mode';
103 
104   P_UNION_LOWER_LOWER VARCHAR2(32000) := 'FROM MTL_ITEM_QUANTITIES_VIEW MOQ2,WIP_ENTITIES WE,WIP_REQUIREMENT_OPERATIONS WRO,WIP_DISCRETE_JOBS WDJ,WIP_LINES WL, WIP_REPETITIVE_SCHEDULES  WRS where 1=2';
105 
106   P_UNION_UPPER_LOWER VARCHAR2(32000) := 'FROM MTL_ITEM_QUANTITIES_VIEW MOQ2,WIP_ENTITIES WE,WIP_REQUIREMENT_OPERATIONS WRO,WIP_DISCRETE_JOBS WDJ,WIP_LINES WL, WIP_REPETITIVE_SCHEDULES  WRS where 1=2';
107 
108   P_RECEIPT_LOCATION VARCHAR2(100);
109 
110   P_OPERATING_UNIT_ID NUMBER;
111 
112   P_OPERATING_UNIT_DISPLAYED VARCHAR2(240);
113 
114   C_NUM_RTS_PRINTED NUMBER := 0;
115 
116   CP_DELIVERY_LOCATION VARCHAR2(40);
117 
118   CP_RECEIPT_NUM_FROM VARCHAR2(40);
119 
120   CP_RECEIPT_NUM_TO VARCHAR2(40);
121 
122   CP_ITEM_FROM VARCHAR2(900);
123 
124   CP_ITEM_TO VARCHAR2(900);
125 
126   CP_CATEGORY_FROM VARCHAR2(900);
127 
128   CP_CATEGORY_TO VARCHAR2(900);
129 
130   CP_SHIP_TO_LOCATION VARCHAR2(40);
131 
132   CP_ORG_DISPLAYED VARCHAR2(60);
133 
134   CP_TITLE VARCHAR2(50);
135 
136   CP_WIP_STATUS VARCHAR2(1);
137 
138   CP_OPERATING_UNIT_DISPLAYED VARCHAR2(240);
139 
140   FUNCTION GET_P_STRUCT_NUM RETURN BOOLEAN;
141 
142   FUNCTION BUYER_PREPARERFORMULA(RRP_TRANSACTION_TYPE IN VARCHAR2) RETURN VARCHAR2;
143 
144   FUNCTION DIRECT_RECEIVING_CHECK(RRP_FROM_INTERFACE IN VARCHAR2
145                                  ,RRP_TRANSACTION_ID IN NUMBER) RETURN BOOLEAN;
146 
147   FUNCTION BLIND_RECEIVING_CHECK(RRP_ORGANIZATION_ID IN NUMBER) RETURN BOOLEAN;
148 
149   FUNCTION BOILER_PLATE_DOC_TYPE(RRP_TRANSACTION_TYPE IN VARCHAR2) RETURN CHARACTER;
150 
151   FUNCTION BOILER_PLATE_DOC_NUM(RRP_TRANSACTION_TYPE IN VARCHAR2) RETURN CHARACTER;
152 
153   FUNCTION BOILER_PLATE_BUYER(RRP_TRANSACTION_TYPE IN VARCHAR2) RETURN CHARACTER;
154 
155   FUNCTION DOC_TYPE_BOILERPLATEFORMULA(RRP_TRANSACTION_TYPE IN VARCHAR2) RETURN VARCHAR2;
156 
157   FUNCTION DOC_NUM_BOILER_PLATEFORMULA(RRP_TRANSACTION_TYPE IN VARCHAR2) RETURN VARCHAR2;
158 
159   FUNCTION DELIVERY_CHECK(RRP_FROM_INTERFACE IN VARCHAR2
160                          ,RRP_TRANSACTION_ID IN NUMBER) RETURN BOOLEAN;
161 
162   FUNCTION CHILD_DIRECT_RECEIVING_CHECK(RRP_FROM_INTERFACE IN VARCHAR2
163                                        ,RRP_TRANSACTION_ID IN NUMBER) RETURN BOOLEAN;
164 
165   FUNCTION G_RECEIPTSGROUPFILTER(RRP_TRANSACTION_ID IN NUMBER
166                                 ,RRP_FROM_INTERFACE IN VARCHAR2) RETURN BOOLEAN;
167 
168   FUNCTION C_UNION_UPPER_UPPERFORMULA RETURN VARCHAR2;
169 
170   FUNCTION C_UNION_LOWER_UPPERFORMULA RETURN VARCHAR2;
171 
172   FUNCTION C_UNION_LOWER_LOWERFORMULA RETURN VARCHAR2;
173 
174   FUNCTION C_UNION_UPPER_LOWERFORMULA RETURN VARCHAR2;
175 
176   FUNCTION WIP_SELECT_DISTFORMULA RETURN VARCHAR2;
177 
178   FUNCTION WIP_FROM_DISTFORMULA RETURN VARCHAR2;
179 
180   FUNCTION WIP_WHERE_DISTFORMULA RETURN VARCHAR2;
181 
182   FUNCTION WIP_WHERE_DIST_INTERFACEFORMUL RETURN VARCHAR2;
183 
184   FUNCTION C_SET_RT_NUMFORMULA(COUNT_DISTRIBUTIONS IN NUMBER
185                               ,RRP_TRANSACTION_ID IN NUMBER
186                               ,RRP_FROM_INTERFACE IN VARCHAR2) RETURN NUMBER;
187 
188   FUNCTION QUANTITY_RECEIVED_fn(RRP_FROM_INTERFACE IN VARCHAR2
189                             ,RRP_TRANSACTION_ID IN NUMBER
190                             ,PARENT_PRIMARY_QUANTITY IN NUMBER
191                             ,C_SUM_CORRECTED_QTY IN NUMBER
192                             ,QUANTITY_RECEIVED IN NUMBER
193                             ,RRP_SHIPMENT_LINE_ID IN NUMBER
194                             ,RECEIPT_UNIT_OF_MEASURE IN VARCHAR2
195                             ,ITEM_ID IN NUMBER) RETURN NUMBER;
196 
197   FUNCTION SUM_CORRECT_RTV(C_QTY_CORRECTED IN NUMBER
198                           ,C_SUM_CORRECT_RTV_QTY IN NUMBER) RETURN NUMBER;
199 
200   PROCEDURE GET_PRECISION(ID IN NUMBER);
201 
202   FUNCTION C_QUANTITY_REMAINING_PRINTFORM(QUANTITY_REMAINING IN NUMBER
203                                          ,SOURCE_UNIT_OF_MEASURE IN VARCHAR2
204                                          ,RECEIPT_UNIT_OF_MEASURE IN VARCHAR2
205                                          ,ITEM_ID IN NUMBER
206                                          ,RRP_ORGANIZATION_ID IN NUMBER) RETURN NUMBER;
207 
208   FUNCTION QUANTITY_DELIVERED(PARENT_PRIMARY_QUANTITY IN NUMBER
209                              ,C_SUM_CORRECTED_QTY IN NUMBER) RETURN NUMBER;
210 
211   FUNCTION AFTERREPORT RETURN BOOLEAN;
212 
213   FUNCTION ITEM_NOTEFORMULA(ITEM_NOTE_DATATYPE_ID IN NUMBER
214                            ,ITEM_NOTE_MEDIA_ID IN NUMBER) RETURN CHAR;
215 
216   FUNCTION LONG_NOTE1FORMULA(LONG_NOTE_DATATYPE_ID IN NUMBER
217                             ,LONG_NOTE_MEDIA_ID IN NUMBER) RETURN CHAR;
218 
219   FUNCTION LONG_NOTE2FORMULA(TRX_NOTE_DATATYPE_ID IN NUMBER
220                             ,TRX_NOTE_MEDIA_ID IN NUMBER) RETURN CHAR;
221 
222   FUNCTION PO_HEADER_LONG_NOTEFORMULA(PO_HEADER_NOTE_DATATYPE_ID IN NUMBER
223                                      ,PO_HEADER_NOTE_MEDIA_ID IN NUMBER) RETURN CHAR;
224 
225   FUNCTION PO_LINE_LONG_NOTEFORMULA(PO_LINE_NOTE_DATATYPE_ID IN NUMBER
226                                    ,PO_LINE_NOTE_MEDIA_ID IN NUMBER) RETURN CHAR;
227 
228   FUNCTION REQ_HEADER_LONG_NOTEFORMULA(REQ_HEADER_NOTE_DATATYPE_ID IN NUMBER
229                                       ,REQ_HEADER_NOTE_MEDIA_ID IN NUMBER) RETURN CHAR;
230 
231   FUNCTION REQ_LINE_LONG_NOTEFORMULA(REQ_LINE_NOTE_DATATYPE_ID IN NUMBER
232                                     ,REQ_LINE_NOTE_MEDIA_ID IN NUMBER) RETURN CHAR;
233 
234   FUNCTION PO_LINE_LOCATION_LONG_NOTEFORM(SHIPMENT_NOTE_DATATYPE_ID IN NUMBER
235                                          ,SHIPMENT_NOTE_MEDIA_ID IN NUMBER) RETURN CHAR;
236 
237   FUNCTION AFTERPFORM RETURN BOOLEAN;
238 
239   PROCEDURE BUILD_QRECEIPTS;
240 
241   PROCEDURE BUILD_QDISTRIBUTIONS;
242 
243   FUNCTION ROUNDED_QTY_ISSUEDFORMULA(QUANTITY_ISSUED IN NUMBER) RETURN NUMBER;
244 
245   FUNCTION ROUNDED_QTY_ON_HANDFORMULA(JOIN_ITEM_ID IN NUMBER
246                                      ,JOIN_ORGANIZATION_ID IN NUMBER) RETURN NUMBER;
247 
248   FUNCTION ROUNDED_QTY_REQUIREDFORMULA(QUANTITY_REQUIRED IN NUMBER) RETURN NUMBER;
249 
250   FUNCTION QUANTITY_SHORTFORMULA(ROUNDED_QTY_REQUIRED IN NUMBER
251                                 ,ROUNDED_QTY_ISSUED IN NUMBER
252                                 ,ROUNDED_QTY_ON_HAND IN NUMBER) RETURN NUMBER;
253 
254   FUNCTION G_WORK_ORDER_SHORTAGEGROUPFILT(QUANTITY_SHORT IN NUMBER) RETURN BOOLEAN;
255 
256   FUNCTION BEFOREREPORT RETURN BOOLEAN;
257 
258   FUNCTION CF_DO_PRINTFORMULA(COUNT_DISTRIBUTIONS IN NUMBER
259                              ,RRP_TRANSACTION_ID IN NUMBER
260                              ,RRP_FROM_INTERFACE IN VARCHAR2) RETURN CHAR;
261 
262   FUNCTION CF_BLIND_RCVFORMULA(RRP_ORGANIZATION_ID IN NUMBER) RETURN CHAR;
263 
264   FUNCTION CF_DIRECT_RCV_DLVFORMULA(RRP_TRANSACTION_ID IN NUMBER
265                                    ,RRP_FROM_INTERFACE IN VARCHAR2) RETURN CHAR;
266 
267   FUNCTION CF_SERIAL_NUM_CCFORMULA(SERIAL_NUMBER_CONTROL_COD IN NUMBER) RETURN CHAR;
268 
269   FUNCTION BEFOREPFORM RETURN BOOLEAN;
270 
271   FUNCTION CF_OPERATING_UNITFORMULA(ORG_ID IN NUMBER) RETURN VARCHAR2;
272 
273   FUNCTION CF_RECEIPT_LOCATIONFORMULA(LOCATOR_ID1 IN NUMBER
274                                      ,RECEIPT_LOCATION IN VARCHAR2
275                                      ,RECEIVING_SUBINVENTORY IN VARCHAR2) RETURN CHAR;
276 
277   FUNCTION C_NUM_RTS_PRINTED_P RETURN NUMBER;
278 
279   FUNCTION CP_DELIVERY_LOCATION_P RETURN VARCHAR2;
280 
281   FUNCTION CP_RECEIPT_NUM_FROM_P RETURN VARCHAR2;
282 
283   FUNCTION CP_RECEIPT_NUM_TO_P RETURN VARCHAR2;
284 
285   FUNCTION CP_ITEM_FROM_P RETURN VARCHAR2;
286 
287   FUNCTION CP_ITEM_TO_P RETURN VARCHAR2;
288 
289   FUNCTION CP_CATEGORY_FROM_P RETURN VARCHAR2;
290 
291   FUNCTION CP_CATEGORY_TO_P RETURN VARCHAR2;
292 
293   FUNCTION CP_SHIP_TO_LOCATION_P RETURN VARCHAR2;
294 
295   FUNCTION CP_ORG_DISPLAYED_P RETURN VARCHAR2;
296 
297   FUNCTION CP_TITLE_P RETURN VARCHAR2;
298 
299   FUNCTION CP_WIP_STATUS_P RETURN VARCHAR2;
300 
301   FUNCTION CP_OPERATING_UNIT_DISPLAYED_P RETURN VARCHAR2;
302 
303 END PO_POXDLPDT_XMLP_PKG;
304