PACKAGE: APPS.PO_POXPODDR_XMLP_PKG

Source

1 PACKAGE PO_POXPODDR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: POXPODDRS.pls 120.2 2007/12/25 11:13:48 krreddy noship $ */
3 	P_title	varchar2(50);
4 	P_BUYER	varchar2(40);
5 	P_VENDOR_FROM	varchar2(240);
6 	P_VENDOR_TO	varchar2(240);
7 	P_CREATION_DATE_FROM	date;
8 	P_CREATION_DATE_TO	date;
9 	P_CREATION_DATE_FROM1	varchar2(25);
10 	P_CREATION_DATE_TO1	varchar2(25);
11 	P_PO_NUM_FROM	varchar2(40);
12 	P_PO_NUM_TO	varchar2(40);
13 	P_CONC_REQUEST_ID	number;
14 	P_FLEX_ITEM	varchar2(800);
15 	P_FLEX_ACC	varchar2(31000);
16 	P_FAILED_FUNDS	varchar2(1);
17 	P_ORDERBY	varchar2(40);
18 	p_qty_precision	number;
19 	TYPE_LOOKUP_CODE	varchar2(40);
20 	P_ORDERBY_DISP	varchar2(80);
21 	P_FAILED_FUNDS_DISP	varchar2(80);
22 	p_ca_set_of_books_id	number;
23 	P_mrcsobtype	varchar2(10);
24 	lp_fin_system_parameters_all	varchar2(50);
25 	lp_fin_system_parameters	varchar2(50);
26 	LP_PO_HEADERS	varchar2(50);
27 	LP_PO_HEADERS_ALL	varchar2(50);
28 	lp_rcv_transactions	varchar2(50);
29 	lp_po_distributions	varchar2(50);
30 	lp_po_distributions_all	varchar2(50);
31 	lp_rcv_shipment_headers	varchar2(50);
32 	lp_rcv_receiving_sub_ledger	varchar2(50);
33 	lp_rcv_sub_ledger_details	varchar2(50);
34 	where_performance	varchar2(2000);
35 	C_amount_func_sub_round	number;
36 	C_amount_cur_round	number;
37 	C_amount_fun_round	number;
38 	C_amount_func_tot_round	number;
39 	function AfterReport return boolean  ;
40 	function BeforeReport return boolean  ;
41 	function select_failed_f return character  ;
42 	function where_failed_f return character  ;
43 	function from_failed_f return character  ;
44 	function orderby_clauseFormula return VARCHAR2  ;
45 	procedure get_precision  ;
46 	function get_dist_func_amount(shipment_type in varchar2, dist_quantity_ordered in number, c_dist_rls_qty in number, unit_price in number, rate in number, order_type_lookup_code in varchar2, dist_amount_ordered in number) return number  ;
47 	function get_dist_cur_amount(shipment_type in varchar2, dist_quantity_ordered in number, c_dist_rls_qty in number, unit_price in number, order_type_lookup_code in varchar2, dist_amount_ordered in number) return number  ;
48 	function get_ship_quantity(shipment_type in varchar2, ship_qty_ordered in number, c_ship_rls_qty in number) return number  ;
49 	function AfterPForm return boolean  ;
50 	Function C_amount_func_sub_round_p return number;
51 	Function C_amount_cur_round_p(C_DIST_AMT_CUR in number,PO_CURRENCY_PRECISION in  number) return number;
52 	Function C_amount_fun_round_p(C_DIST_AMT_FUNC in number,PO_CURRENCY_PRECISION in  number) return number;
53 	Function C_amount_func_tot_round_p return number;
54 END PO_POXPODDR_XMLP_PKG;
55