1 PACKAGE PO_POXKIAGN_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: POXKIAGNS.pls 120.2 2007/12/25 11:00:48 krreddy noship $ */
3 P_title varchar2(52);
4 P_CONC_REQUEST_ID number;
5 P_START_DATE_FROM varchar2(40);
6 P_START_DATE_TO varchar2(40);
7 P_BUYER varchar2(40);
8 P_FLEX_CAT varchar2(31000);
9 P_qty_precision number;
10 P_ORDERBY varchar2(40);
11 P_ORDERBY_CAT varchar2(298);
12 P_STRUCT_NUM number;
13 LP_STRUCT_NUM number;
14 P_CATEGORY_FROM varchar2(900);
15 P_CATEGORY_TO varchar2(900);
16 P_WHERE_CAT varchar2(2000) := '1 = 1';
17 P_BASE_CURRENCY varchar2(40);
18 P_ORDERBY_DISP varchar2(80);
19 function BeforeReport return boolean ;
20 procedure get_precision ;
21 function get_p_struct_num return boolean ;
22 function orderby_clauseFormula return VARCHAR2 ;
23 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 ;
24 function return_amt_saved(C_AMOUNT_LIST in number, C_AMOUNT_ACTUAL in number) return number ;
25 function return_discount(C_AMOUNT_LIST in number, C_AMOUNT_ACTUAL in number) return number ;
26 function return_list(Order_type in varchar2, C_min_quote in number, Market_price in number, List in number, Rate in number) return number ;
27 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 ;
28 function return_amt_act(C_quantity in number, Line_price in number, Rate in number) return number ;
29 function get_quantity(Shipment_quantity in number, Line_quantity in number) return number ;
30 function AfterReport return boolean ;
31 END PO_POXKIAGN_XMLP_PKG;
32