1 PACKAGE PO_POXKISUM_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: POXKISUMS.pls 120.3 2007/12/25 11:02:44 krreddy noship $ */
3 P_title varchar2(52);
4 P_CREATION_DATE_FROM date;
5 P_CREATION_DATE_TO date;
6 CP_CREATION_DATE_FROM varchar2(25);
7 CP_CREATION_DATE_TO varchar2(25);
8 P_BUYER varchar2(240);
9 P_CONC_REQUEST_ID number;
10 P_qty_precision number;
11 P_ORDERBY varchar2(100);
12 P_BASE_CURRENCY varchar2(40);
13 P_orderby_displayed varchar2(80);
14 P_SORT varchar2(100);
15 function BeforeReport return boolean ;
16 function AfterReport return boolean ;
17 function return_amt_saved(C_AMOUNT_LIST1 in number, C_AMOUNT_ACTUAL1 in number) return number ;
18 function orderby_clauseFormula return VARCHAR2 ;
19 function return_amt_act(C_quantity in number, Line_price in number, Rate in number) return number ;
20 function return_amt_list(C_min_quote in number, Market_price in number, List in number, C_quantity in number, Rate in number) return number ;
21 function return_type(C_min_quote in number, Quote_code in varchar2, Market_price in number, Market_code in varchar2, List in number, List_code in varchar2) return varchar2 ;
22 function return_list(C_min_quote in number, Market_price in number, List in number, Rate in number) return number ;
23 function return_discount(C_AMOUNT_LIST1 in number, C_AMOUNT_ACTUAL1 in number) return number ;
24 function get_quantity(Shipment_quantity in number, Shipment_quantity_cancelled in number, Line_quantity in number) return number ;
25 function round_amount_actual_rep(c_amount_actual_rep in number, c_curr_precision in number) return number ;
26 function round_amount_saved_rep(c_amount_saved_rep in number, c_curr_precision in number) return number ;
27 function round_amount_list_rep(c_amount_list_rep in number, c_curr_precision in number) return number ;
28 function round_amount_list_subtotal_rep(c_amount_list_subtotal in number, c_curr_precision in number) return number ;
29 function round_amount_actual_subtotal(c_amount_actual_subtotal in number, c_curr_precision in number) return number ;
30 function round_amount_saved_subtotal(c_amount_saved_subtotal in number, c_curr_precision in number) return number ;
31 function round_amount_list1(c_amount_list1 in number, c_curr_precision in number) return number ;
32 function round_amount_actual1(c_amount_actual1 in number, c_curr_precision in number) return number ;
33 function round_amount_saved(c_amount_saved in number, c_curr_precision in number) return number ;
34 END PO_POXKISUM_XMLP_PKG;
35
[Home] [Help]