PACKAGE: APPS.PO_POXRVXRV_XMLP_PKG

Source

1 PACKAGE PO_POXRVXRV_XMLP_PKG AS
2 /* $Header: POXRVXRVS.pls 120.1 2007/12/25 12:24:06 krreddy noship $ */
3 	P_title	varchar2(50);
4 	P_CONC_REQUEST_ID	number;
5 	P_FLEX_ITEM	varchar2(800);
6 	P_PO_NUM_FROM	varchar2(40);
7 	P_VENDOR	varchar2(240);
8 	LP_VENDOR       varchar2(240);
9 	P_LOCATION	varchar2(40);
10 	P_PROMISE_DATE_FROM	varchar2(40);
11 	P_PROMISE_DATE_TO	varchar2(40);
12 	P_WHERE_CAT	varchar2(2000):='1 = 1';
13 	P_STRUCT_NUM	varchar2(15);
14 	LP_STRUCT_NUM   varchar2(15);
15 	P_category_from	varchar2(900);
16 	P_category_to	varchar2(900);
17 	P_FLEX_CAT	varchar2(800);
18 	P_orderby	varchar2(40);
19 	P_QTY_PRECISION	number;
20 	QTY_PRECISION  varchar2(100);
21 	P_blind_rcv_flag	varchar2(40);
22 	P_item_from	varchar2(900);
23 	P_Item_To	varchar2(900);
24 	P_WHERE_ITEM	varchar2(2000):='1 = 1';
25 	P_ITEM_STRUCT_NUM	varchar2(15);
26 	P_REQ_NUM_FROM	varchar2(40);
27 	P_REQ_NUM_TO	varchar2(40);
28 	P_PO_NUM_TO	varchar2(40);
29 	P_org_id	number;
30 	P_org_displayed	varchar2(60);
31 	P_where_po_num_to	varchar2(240):='1=1';
32 	P_where_po_num_from	varchar2(240):='1=1';
33 	P_where_req_num_to	varchar2(240):='1=1';
34 	P_where_req_num_from	varchar2(240):='1=1';
35 	P_where_vendor	varchar2(240):='1=1';
36 	P_where_no_po_num	varchar2(240):='1=1';
37 	P_where_no_req_num	varchar2(240):='1=1';
38 	P_RMA_NUM_FROM	number;
39 	P_RMA_NUM_TO	number;
40 	P_where_rma_num_from	varchar2(240):='1=1';
41 	P_where_rma_num_to	varchar2(240):='1=1';
42 	P_where_no_rma_num	varchar2(240):='1=1';
43 	P_CUSTOMER	varchar2(240);
44         LP_CUSTOMER	varchar2(240);
45 	P_where_customer	varchar2(240):='1=1';
46 	P_PO_ORG	varchar2(500):='AND 1=1';
47 	P_REQ_ORG	varchar2(500):='AND 1=1';
48 	P_RMA_ORG	varchar2(500):='AND 1=1';
49 	P_LOCATION_ID	number;
50 	function BeforeReport return boolean  ;
51 	function AfterReport return boolean  ;
52 	function orderby_clauseFormula return VARCHAR2  ;
53 	procedure get_precision  ;
54 	function get_p_struct_num return boolean  ;
55 	function AfterPForm return boolean  ;
56 	function P_STRUCT_NUMValidTrigger return boolean  ;
57 	function BeforePForm return boolean  ;
58 	function BetweenPage return boolean  ;
59 	function P_org_displayedValidTrigger return boolean  ;
60 	function location_code1formula(location in varchar2, Shipment_type in varchar2, location_id1 in number) return char  ;
61 	function P_LOCATIONValidTrigger return boolean  ;
62 END PO_POXRVXRV_XMLP_PKG;
63