PACKAGE: APPS.JE_BE_CSSR_PKG

Source

1 PACKAGE JE_BE_CSSR_PKG AS
2 /* $Header: jebecsrs.pls 120.1 2008/01/10 12:24:56 spasupun noship $ */
3 
4 g_xml clob;
5 g_vc_spacing number(20);
6 
7 procedure main(
8  p_errbuf     OUT NOCOPY VARCHAR2,
9  p_retcode    OUT NOCOPY VARCHAR2,
10  p_vat_reporting_entity_id  jg_zz_vat_rep_entities.vat_reporting_entity_id%TYPE,
11  p_rep_period        gl_periods.period_name%TYPE,
12  p_fax_number        varchar2,
13  p_email             varchar2,
14  p_resp_email        varchar2,
15  p_trans_resp        varchar2,
16  p_trans_ackn        varchar2,
17  p_sec_resp          varchar2,
18  p_sec_ackn          varchar2);
19 
20 procedure get_admin_data
21 (
22  p_vat_reg_num       varchar2,
23  p_email_address     varchar2,
24  p_tel_num           varchar2,
25  p_fax_num           varchar2,
26  p_name              varchar2,
27  p_email_resp        varchar2,
28  p_trans_resp        varchar2,
29  p_trans_ackn        varchar2,
30  p_sec_resp          varchar2,
31  p_sec_ackn          varchar2,
32  p_survey_code       varchar2,
33  p_period            varchar2
34 );
35 
36 procedure get_content_data
37 (p_survey_code varchar2,
38  p_period      varchar2,
39  p_vat_reporting_entity_id jg_zz_vat_rep_entities.vat_reporting_entity_id%TYPE
40 );
41 
42 FUNCTION get_bsv(p_ledger_id number,p_choac_id number,p_cc_id number)RETURN VARCHAR2;
43 FUNCTION get_accounting_segment(p_coa_id  number,p_cc_id number default null) RETURN VARCHAR2;
44 
45 function level_up return varchar2;
46 function level_down return varchar2;
47 
48 end JE_BE_CSSR_PKG;
49