1 PACKAGE PO_POXSERPR_XMLP_PKG AS
2 /* $Header: POXSERPRS.pls 120.1 2007/12/25 12:26:22 krreddy noship $ */
3 P_VENDOR_FROM varchar2(240);
4 P_VENDOR_TO varchar2(240);
5 P_BUYER varchar2(40);
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 QTY_PRECISION varchar2(30);
12 P_GET_PRECISION varchar2(40);
13 P_title varchar2(52);
14 P_WHERE_ITEM varchar2(2000);
15 P_WHERE_CAT varchar2(2000);
16 P_item_from varchar2(900);
17 P_item_to varchar2(900);
18 P_category_from varchar2(900);
19 P_category_to varchar2(900);
20 P_STRUCT_NUM varchar2(15);
21 P_ITEM_STRUCT_NUM varchar2(15);
22 P_detail_summary varchar2(1);
23 P_DRIVE_OFF_HEADERS varchar2(40);
24 P_DRIVE_OFF_VENDORS varchar2(40);
25 P_VENDOR_QUERY varchar2(4000);
26 function BeforeReport return boolean ;
27 function AfterReport return boolean ;
28 procedure get_precision ;
29 function get_p_struct_num return boolean ;
30 function locationformula(PO_RECEIVED in number, PO_WRONG_LOCATION in number) return number ;
31 function on_timeformula(PO_ORDERED in number, PO_RECEIVED in number, PO_ON_TIME in number) return number ;
32 function lateformula(PO_ORDERED in number, PO_RECEIVED in number, PO_LATE in number) return number ;
33 function earlyformula(PO_ORDERED in number, PO_RECEIVED in number, PO_EARLY in number) return number ;
34 function varianceformula(PO_RECEIVED in number, PO_DAYS_QTY in number) return number ;
35 function c_per_item_earlyformula(C_item_sum_ord in number, C_item_sum_rec in number, C_item_sum_early in number) return number ;
36 function c_per_item_lateformula(C_item_sum_ord in number, C_item_sum_rec in number, C_item_sum_late in number) return number ;
37 function c_per_item_on_timeformula(C_item_sum_ord in number, C_item_sum_rec in number, C_item_sum_on_time in number) return number ;
38 function c_per_item_locformula(C_item_sum_rec in number, C_item_sum_w_loc in number) return number ;
39 function c_per_item_rejformula(C_item_sum_rec in number, C_item_sum_rej in number) return number ;
40 function c_per_item_varformula(C_item_sum_rec in number, C_item_sum_days_qty in number) return number ;
41 function orderedformula(shipment_conversion_rate in varchar2, pll_quantity_ordered in number) return number ;
42 function rejectedformula(shipment_conversion_rate in varchar2, pll_quantity_rejected in number) return number ;
43 function per_rejectedformula(PO_received in number, PO_rejected in number) return number ;
44 function openformula(Received in number, Ordered in number, cutoff_date in date) return number ;
45 function past_dueformula(Received in number, Ordered in number, cutoff_date in date) return number ;
46 function p_openformula(PO_ORDERED in number, PO_RECEIVED in number, PO_OPEN in number) return number ;
47 function p_past_dueformula(PO_ORDERED in number, PO_RECEIVED in number, PO_PAST_DUE in number) return number ;
48 function c_per_item_openformula(C_item_sum_ord in number, C_item_sum_rec in number, C_item_sum_open in number) return number ;
49 function c_per_item_past_dueformula(C_item_sum_ord in number, C_item_sum_rec in number, C_item_sum_past_due in number) return number ;
50 function quantity_received_on_timeformu(quantity_received_total in number, quantity_received_early in number, quantity_received_late in number) return number ;
51 function receivedformula(quantity_received_total in number) return number ;
52 function days_total_late_or_earlyformul(days_received_early in number, days_received_late in number) return number ;
53 END PO_POXSERPR_XMLP_PKG;
54