1 PACKAGE PO_POXQUAPR_XMLP_PKG AS
2 /* $Header: POXQUAPRS.pls 120.1 2007/12/25 11:37:30 krreddy noship $ */
3 P_VENDOR_FROM varchar2(240);
4 P_VENDOR_TO varchar2(240);
5 P_BUYER varchar2(240);
6 P_CREATION_DATE_FROM varchar2(40);
7 P_CREATION_DATE_TO varchar2(40);
8 P_CONC_REQUEST_ID number;
9 P_FLEX_ITEM varchar2(800);
10 P_QTY_PRECISION number;
11 P_GET_PRECISION varchar2(40);
12 P_title varchar2(50);
13 P_WHERE_ITEM varchar2(2000);
14 P_WHERE_CAT varchar2(2000);
15 P_item_from varchar2(900);
16 P_item_to varchar2(900);
17 P_category_from varchar2(900);
18 P_category_to varchar2(900);
19 P_STRUCT_NUM varchar2(15);
20 P_ITEM_STRUCT_NUM varchar2(15);
21 P_report_type number;
22 P_detail_summary varchar2(1);
23 FORMAT_MASK varchar2(100);
24 function BeforeReport return boolean ;
25 function AfterReport return boolean ;
26 procedure get_precision ;
27 function get_p_struct_num return boolean ;
28 function per_acceptedformula(Received in number, Accepted in number) return number ;
29 function per_rejectedformula(Received in number, Rejected in number) return number ;
30 function per_returnedformula(Received in number, Returned in number) return number ;
31 function c_item_per_acceptedformula(C_item_sum_rec in number, C_item_sum_acc in number) return number ;
32 function c_item_per_rejectedformula(C_item_sum_rec in number, C_item_sum_rej in number) return number ;
33 function c_item_per_returnedformula(C_item_sum_rec in number, C_item_sum_ret in number) return number ;
34 function uninspectedformula(Received in number, Accepted in number, Rejected in number) return number ;
35 function per_uninspectedformula(Received in number, Uninspected in number) return number ;
36 function per_rtv_wout_inspectformula(Received in number, Rtv_wout_inspect in number) return number ;
37 function c_item_per_uninsformula(C_item_sum_rec in number, C_item_sum_unins in number) return number ;
38 function c_item_per_rtv_wout_insformula(C_item_sum_rec in number, C_item_sum_rtv_wout_ins in number) return number ;
39 function quantity_acceptedformula(pll_quantity_accepted in number, conversion_rate in varchar2) return number ;
40 function quantity_rejectedformula(conversion_rate in varchar2, pll_quantity_rejected in number) return number ;
41 function quantity_orderedformula(conversion_rate in varchar2, pll_quantity_ordered in number) return number ;
42 function c_tot_returnedformula(parent_line_location_id in number, Item_id in number) return number ;
43 function c_tot_inspectedformula(parent_line_location_id in number, Item_id in number) return number ;
44 function c_tot_receivedformula(parent_line_location_id in number, Item_id in number) return number ;
45 END PO_POXQUAPR_XMLP_PKG;
46
[Home] [Help]