1 package iex_promise_recon_rpt_pkg AUTHID CURRENT_USER as
2 /* $Header: iexprcrs.pls 120.5 2011/05/06 09:44:18 pnaveenk noship $ */
3
4 PROCEDURE PRINT_CLOB (lob_loc in clob);
5
6
7
8 Procedure gen_xml_data(ERRBUF OUT NOCOPY VARCHAR2,
9 RETCODE OUT NOCOPY VARCHAR2,
10 p_org_id in number,
11 p_date_from in varchar2,
12 p_date_to in varchar2,
13 p_currency in varchar2,
14 p_pro_state in varchar2,
15 p_pro_status in varchar2,
16 p_summ_det in varchar2,
17 p_group_by in varchar2,
18 p_group_by_mode in varchar2,
19 p_group_by_coll_dumm in varchar2 default null,
20 p_group_by_value_coll in varchar2 default null,
21 p_group_by_sch_dumm in varchar2 default null,
22 p_group_by_value_sch in varchar2 default null
23 );
24
25 type l_res_hash_type is table of JTF_RS_RESOURCE_EXTNS.resource_id%type;
26 type l_pmt_cnt_type is table of number index by binary_integer;
27 type l_pmt_amt_type is table of number index by binary_integer;
28
29 procedure calc_pmt_amt_cnt(p_org_id in number,
30 p_date_from in date,
31 p_date_to in date,
32 p_currency in varchar2,
33 p_pro_state in varchar2,
34 p_pro_status in varchar2,
35 p_group_by in varchar2,
36 p_group_by_mode in varchar2,
37 p_group_by_value_coll in varchar2 default null,
38 p_group_by_value_sch in varchar2 default null
39 );
40
41 function get_pmt_count(p_resource_id number,p_source_code_id in number) return number;
42 function get_pmt_amount(p_resource_id number,p_source_code_id in number) return number;
43
44
45
46 end iex_promise_recon_rpt_pkg;