DBA Data[Home] [Help]

PACKAGE: APPS.PO_POXPOSMH_XMLP_PKG

Source


1 PACKAGE PO_POXPOSMH_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: POXPOSMHS.pls 120.1 2007/12/25 11:21:24 krreddy noship $ */
3 	P_title	varchar2(50);
4 	P_FLEX_ITEM	varchar2(800);
5 	P_FLEX_CAT	varchar2(3100);
6 	P_CONC_REQUEST_ID	number;
7 	P_BUYER	varchar2(240);
8 	P_VENDOR_FROM	varchar2(240);
9 	P_VENDOR_TO	varchar2(240);
10 	P_INVOICE_DATE_FROM	varchar2(40);
11 	P_INVOICE_DATE_TO	varchar2(40);
12 	PRICE_HOLD	varchar2(40);
13 	QTY_ORD_HOLD	varchar2(40);
14 	QTY_REC_HOLD	varchar2(40);
15 	QUALITY_HOLD	varchar2(40);
16 	ORG_ID	varchar2(40);
17 	P_PRICE_HOLD	varchar2(40);
18 	P_QTY_ORD_HOLD	varchar2(40);
19 	P_QTY_REC_HOLD	varchar2(40);
20 	P_QUALITY_HOLD	varchar2(40);
21 	P_QTY_PRECISION	number;
22 	P_WHERE_CAT	varchar2(2000);
23 	P_WHERE_ITEM	varchar2(2000);
24 	P_STRUCT_NUM	varchar2(15);
25 	P_category_from	varchar2(900);
26 	P_category_to	varchar2(900);
27 	P_item_from	varchar2(900);
28 	P_item_to	varchar2(900);
29 	P_ITEM_STRUCT_NUM	varchar2(32767);
30         FORMAT_MASK varchar2(100);
31 	function BeforeReport return boolean  ;
32 	function AfterReport return boolean  ;
33 	procedure get_precision  ;
34 	function get_p_struct_num return boolean  ;
35 	function c_report_avg_no_of_daysformula(C_report_tot_days_hold in number, C_report_number_total in number) return number  ;
36 	function c_total_days_holdingformula(average in number, number_amount_tot in number) return number  ;
37 	function c_unit_price_round(unit_price in varchar2, parent_currency_precision in number) return number  ;
38 	function c_invoice_price_round(invoice_price in number, parent_currency_precision in number) return number  ;
39 END PO_POXPOSMH_XMLP_PKG;
40