[Home] [Help]
PACKAGE: APPS.PO_RCVTXRTR_NEW_XMLP_PKG
Source
1 PACKAGE PO_RCVTXRTR_NEW_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: RCVTXRTRS.pls 120.3 2007/12/25 13:51:02 krreddy noship $ */
3 P_title varchar2(50);
4 P_CONC_REQUEST_ID number;
5 ITEM_ID varchar2(40);
6 RRP_ORGANIZATION_ID varchar2(40);
7 RRP_TRANSACTION_ID varchar2(40);
8 RRP_SHIPMENT_LINE_ID varchar2(40);
9 RRP_FROM_INTERFACE varchar2(40);
10 P_FLEX_CAT varchar2(31000);
11 P_FLEX_ITEM varchar2(800);
12 P_org_displayed varchar2(60);
13 P_org_id number;
14 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''||MSL.SEGMENT10||
15 ''\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)' ;
16 P_STRUCT_NUM number;
17 P_STRUCT_NUM1 number;
18 P_ITEM_STRUCT_NUM number;
19 P_item_from varchar2(900);
20 P_Item_to varchar2(900);
21 P_category_to varchar2(900);
22 P_category_from varchar2(900);
23 P_vendor_from varchar2(240);
24 P_vendor_to varchar2(240);
25 P_po_num_from varchar2(40);
26 P_po_num_to varchar2(40);
27 P_receipt_num_from varchar2(40);
28 P_receipt_num_to varchar2(40);
29 P_req_num_from varchar2(40);
30 P_ship_num_to varchar2(40);
31 P_req_num_to varchar2(40);
32 P_ship_num_from varchar2(40);
33 P_trx_date_from date;
34 P_trx_date_to date;
35 P_receiver varchar2(240);
36 P_trx_type varchar2(40);
37 P_buyer varchar2(240);
38 P_inc_lot_and_serial varchar2(1);
39 P_exception varchar2(1);
40 P_detail_summary varchar2(1);
41 P_sort_by varchar2(40);
42 P_QTY_PRECISION number;
43 P_WHERE_CAT varchar2(2400);
44 P_WHERE_ITEM varchar2(2400);
45 P_INV_STATUS varchar2(1);
46 P_where_org_id varchar2(240) := '1=1';
47 P_where_receipt_num_from varchar2(240) := '1=1';
48 P_where_receipt_num_to varchar2(240) := '1=1';
49 P_where_receiver varchar2(240);
50 P_where_po_num_to varchar2(240) := '1=1';
51 P_where_vendor_to varchar2(240) := '1=1';
52 P_where_vendor_from varchar2(240) := '1=1';
53 P_where_buyer varchar2(240) := '1=1';
54 P_where_po_num_from varchar2(240) := '1=1';
55 P_where_trx_type varchar2(240) := '1=1';
56 P_where_trx_date_from varchar2(240) := '1=1';
57 P_where_trx_date_to varchar2(240) := '1=1';
58 P_where_ship_num_from varchar2(240) := '1=1';
59 P_where_ship_num_to varchar2(240) := '1=1';
60 P_where_req_num_from varchar2(240) := '1=1';
61 P_where_req_num_to varchar2(240) := '1=1';
62 P_CUSTOMER_FROM varchar2(240);
63 P_CUSTOMER_TO varchar2(240);
64 P_RMA_NUM_FROM varchar2(40);
65 P_RMA_NUM_TO varchar2(40);
66 P_where_customer_from varchar2(240) := '1=1';
67 P_where_customer_to varchar2(240) :='1=1';
68 P_where_rma_num_from varchar2(240) := '1=1';
69 P_where_rma_num_to varchar2(240) := '1=1';
70 function BeforeReport return boolean ;
71 function get_p_struct_num return boolean ;
72 procedure get_precision ;
73 function G_src_and_typeGroupFilter return boolean ;
74 function AfterPForm return boolean ;
75 function AfterReport return boolean ;
76 function rcv_uom_convertformula(PO_UOM in varchar2, UOM in varchar2, ls_item_id in number, PRICE in number) return number ;
77 END PO_RCVTXRTR_new_XMLP_PKG;
78