[Home] [Help]
PACKAGE: APPS.JE_BE_CSSR_PKG
Source
1 PACKAGE JE_BE_CSSR_PKG AUTHID CURRENT_USER 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