1 PACKAGE PO_POXPOCOM_XMLP_PKG AS
2 /* $Header: POXPOCOMS.pls 120.0 2008/01/02 07:47:45 dwkrishn noship $ */
3 P_title varchar2(50);
4 P_CONC_REQUEST_ID number;
5 P_PERIOD varchar2(40);
6 P_PO_NUMBER_FROM varchar2(40);
7 P_PO_NUMBER_TO varchar2(40);
8 P_VENDOR_FROM varchar2(240);
9 P_VENDOR_TO varchar2(240);
10 P_BUYER varchar2(40);
11 P_CATEGORY_FROM varchar2(900);
12 P_CATEGORY_TO varchar2(900);
13 P_SORT varchar2(40);
14 P_SORT_1 varchar2(40);
15 P_WHERE_CAT varchar2(2000);
16 P_STRUCT_NUM number;
17 P_PERIOD_NUM number;
18 P_orderby_displayed varchar2(80);
19 P_period_year number;
20 P_ALT_ORDERBY_DISPLAYED varchar2(80);
21 function BeforeReport return boolean ;
22 function get_p_struct_num return boolean ;
23 function get_period_num return boolean ;
24 function C_break_headerFormula return VARCHAR2 ;
25 function C_other_headerFormula return VARCHAR2 ;
26 function c_sum_allformula(C_break_per1 in number, C_break_per2 in number, C_break_per3 in number, C_break_per4 in number, c_precision in number) return number ;
27 function G_periodsGroupFilter return boolean ;
28 function c_break_per1_round(c_break_per1 in number, c_precision in number) return number ;
29 function c_break_per2_round(c_break_per2 in number, c_precision in number) return number ;
30 function c_break_per3_round(c_break_per3 in number, c_precision in number) return number ;
31 function c_break_per4_round(c_break_per4 in number, c_precision in number) return number ;
32 function c_amt_per1_round(c_amount_per1 in number, c_precision in number) return number ;
33 function c_amt_per2_round(c_amount_per2 in number, c_precision in number) return number ;
34 function c_amt_per3_round(c_amount_per3 in number, c_precision in number) return number ;
35 function c_amt_per4_round(c_amount_per4 in number, c_precision in number) return number ;
36 function AfterReport return boolean ;
37 END PO_POXPOCOM_XMLP_PKG;
38