eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JE_BE_CSSR_PKG dependencies on JG_ZZ_VAT_REP_ENTITIES

Line 7: p_vat_reporting_entity_id jg_zz_vat_rep_entities.vat_reporting_entity_id%TYPE,

3:
4: procedure main(
5: p_errbuf OUT NOCOPY VARCHAR2,
6: p_retcode OUT NOCOPY VARCHAR2,
7: p_vat_reporting_entity_id jg_zz_vat_rep_entities.vat_reporting_entity_id%TYPE,
8: p_rep_period gl_periods.period_name%TYPE,
9: p_fax_number varchar2,
10: p_email varchar2,
11: p_resp_email varchar2,

Line 17: cursor c_get_reg_det(p_vat_reporting_entity_id jg_zz_vat_rep_entities.vat_reporting_entity_id%TYPE) is

13: p_trans_ackn varchar2,
14: p_sec_resp varchar2,
15: p_sec_ackn varchar2)is
16:
17: cursor c_get_reg_det(p_vat_reporting_entity_id jg_zz_vat_rep_entities.vat_reporting_entity_id%TYPE) is
18: SELECT substr(legal.tax_registration_number,3),
19: legal.legal_entity_id
20: FROM jg_zz_vat_rep_entities legal,
21: jg_zz_vat_rep_entities acc

Line 20: FROM jg_zz_vat_rep_entities legal,

16:
17: cursor c_get_reg_det(p_vat_reporting_entity_id jg_zz_vat_rep_entities.vat_reporting_entity_id%TYPE) is
18: SELECT substr(legal.tax_registration_number,3),
19: legal.legal_entity_id
20: FROM jg_zz_vat_rep_entities legal,
21: jg_zz_vat_rep_entities acc
22: WHERE acc.vat_reporting_entity_id = p_vat_reporting_entity_id
23: AND ((acc.entity_type_code = 'ACCOUNTING'
24: AND acc.mapping_vat_rep_entity_id = legal.vat_reporting_entity_id)

Line 21: jg_zz_vat_rep_entities acc

17: cursor c_get_reg_det(p_vat_reporting_entity_id jg_zz_vat_rep_entities.vat_reporting_entity_id%TYPE) is
18: SELECT substr(legal.tax_registration_number,3),
19: legal.legal_entity_id
20: FROM jg_zz_vat_rep_entities legal,
21: jg_zz_vat_rep_entities acc
22: WHERE acc.vat_reporting_entity_id = p_vat_reporting_entity_id
23: AND ((acc.entity_type_code = 'ACCOUNTING'
24: AND acc.mapping_vat_rep_entity_id = legal.vat_reporting_entity_id)
25: OR

Line 36: l_be_reg_number jg_zz_vat_rep_entities.tax_registration_number%type;

32: select lower(ISO_LANGUAGE) from fnd_languages
33: where language_code = userenv('LANG');
34:
35: l_iso_lang varchar2(4);
36: l_be_reg_number jg_zz_vat_rep_entities.tax_registration_number%type;
37:
38: l_survey_code varchar2(50);
39: l_proc_status varchar2(200);
40: l_legal_entity_name xle_registrations.registered_name%TYPE;

Line 42: l_legal_entity_id jg_zz_vat_rep_entities.legal_entity_id%TYPE;

38: l_survey_code varchar2(50);
39: l_proc_status varchar2(200);
40: l_legal_entity_name xle_registrations.registered_name%TYPE;
41: l_tel_num hz_parties.primary_phone_number%TYPE;
42: l_legal_entity_id jg_zz_vat_rep_entities.legal_entity_id%TYPE;
43: l_dummy varchar2(100);
44: l_exc_survey_code_null exception;
45: l_exc_lang_limit exception;
46:

Line 313: p_vat_reporting_entity_id jg_zz_vat_rep_entities.vat_reporting_entity_id%TYPE

309:
310: procedure get_content_data
311: (p_survey_code varchar2,
312: p_period varchar2,
313: p_vat_reporting_entity_id jg_zz_vat_rep_entities.vat_reporting_entity_id%TYPE
314: )
315: is
316: l_level number(15);
317: l_var varchar2(50);

Line 319: l_legal_entity_id jg_zz_vat_rep_entities.legal_entity_id%TYPE;

315: is
316: l_level number(15);
317: l_var varchar2(50);
318: l_reporting_level varchar2(30);
319: l_legal_entity_id jg_zz_vat_rep_entities.legal_entity_id%TYPE;
320: l_ledger_id gl_ledgers.ledger_id%type;
321: l_bsv varchar2(30);
322:
323: -- ccid and sob

Line 340: ,jg_zz_vat_rep_entities legal

336: ,acc.BALANCING_SEGMENT_VALUE
337: ,acc.entity_level_code
338: ,legal.legal_entity_id
339: FROM gl_periods glp
340: ,jg_zz_vat_rep_entities legal
341: ,jg_zz_vat_rep_entities acc
342: WHERE glp.period_set_name = legal.tax_calendar_name
343: AND acc.vat_reporting_entity_id = p_vat_reporting_entity_id
344: AND ((acc.entity_type_code = 'ACCOUNTING'

Line 341: ,jg_zz_vat_rep_entities acc

337: ,acc.entity_level_code
338: ,legal.legal_entity_id
339: FROM gl_periods glp
340: ,jg_zz_vat_rep_entities legal
341: ,jg_zz_vat_rep_entities acc
342: WHERE glp.period_set_name = legal.tax_calendar_name
343: AND acc.vat_reporting_entity_id = p_vat_reporting_entity_id
344: AND ((acc.entity_type_code = 'ACCOUNTING'
345: AND acc.mapping_vat_rep_entity_id = legal.vat_reporting_entity_id)