[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