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.JG_ZZ_VAT_SELECTION_PKG dependencies on JG_ZZ_VAT_REP_ENTITIES

Line 273: P_REPORTING_LEVEL IN JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE,

269: ----------------------------------------
270: --
271: PROCEDURE initialize(
272: P_GLOBAL_VARIABLES_REC OUT NOCOPY JG_ZZ_VAT_SELECTION_PKG.GLOBAL_VARIABLES_REC_TYPE,
273: P_REPORTING_LEVEL IN JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE,
274: P_LEDGER IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,
275: P_BSV IN JG_ZZ_VAT_REP_ENTITIES.balancing_segment_value%TYPE,
276: P_VAT_REPORTING_ENTITY_ID IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,
277: P_TAX_PERIOD IN JG_ZZ_VAT_REP_STATUS.tax_calendar_period%TYPE,

Line 274: P_LEDGER IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,

270: --
271: PROCEDURE initialize(
272: P_GLOBAL_VARIABLES_REC OUT NOCOPY JG_ZZ_VAT_SELECTION_PKG.GLOBAL_VARIABLES_REC_TYPE,
273: P_REPORTING_LEVEL IN JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE,
274: P_LEDGER IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,
275: P_BSV IN JG_ZZ_VAT_REP_ENTITIES.balancing_segment_value%TYPE,
276: P_VAT_REPORTING_ENTITY_ID IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,
277: P_TAX_PERIOD IN JG_ZZ_VAT_REP_STATUS.tax_calendar_period%TYPE,
278: P_SOURCE IN JG_ZZ_VAT_REP_STATUS.source%TYPE,

Line 275: P_BSV IN JG_ZZ_VAT_REP_ENTITIES.balancing_segment_value%TYPE,

271: PROCEDURE initialize(
272: P_GLOBAL_VARIABLES_REC OUT NOCOPY JG_ZZ_VAT_SELECTION_PKG.GLOBAL_VARIABLES_REC_TYPE,
273: P_REPORTING_LEVEL IN JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE,
274: P_LEDGER IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,
275: P_BSV IN JG_ZZ_VAT_REP_ENTITIES.balancing_segment_value%TYPE,
276: P_VAT_REPORTING_ENTITY_ID IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,
277: P_TAX_PERIOD IN JG_ZZ_VAT_REP_STATUS.tax_calendar_period%TYPE,
278: P_SOURCE IN JG_ZZ_VAT_REP_STATUS.source%TYPE,
279: P_ACCTD_UNACCTD IN VARCHAR2,

Line 276: P_VAT_REPORTING_ENTITY_ID IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,

272: P_GLOBAL_VARIABLES_REC OUT NOCOPY JG_ZZ_VAT_SELECTION_PKG.GLOBAL_VARIABLES_REC_TYPE,
273: P_REPORTING_LEVEL IN JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE,
274: P_LEDGER IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,
275: P_BSV IN JG_ZZ_VAT_REP_ENTITIES.balancing_segment_value%TYPE,
276: P_VAT_REPORTING_ENTITY_ID IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,
277: P_TAX_PERIOD IN JG_ZZ_VAT_REP_STATUS.tax_calendar_period%TYPE,
278: P_SOURCE IN JG_ZZ_VAT_REP_STATUS.source%TYPE,
279: P_ACCTD_UNACCTD IN VARCHAR2,
280: P_DEBUG_FLAG IN VARCHAR2,

Line 291: p_vat_reporting_entity_id IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,

287: p_global_variables_rec IN OUT NOCOPY JG_ZZ_VAT_SELECTION_PKG.GLOBAL_VARIABLES_REC_TYPE,
288: x_return_status OUT NOCOPY VARCHAR2);
289:
290: PROCEDURE get_VAT_reporting_details (
291: p_vat_reporting_entity_id IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,
292: p_global_variables_rec IN OUT NOCOPY JG_ZZ_VAT_SELECTION_PKG.GLOBAL_VARIABLES_REC_TYPE,
293: x_return_status OUT NOCOPY VARCHAR2);
294:
295: PROCEDURE call_TRL (

Line 321: p_legal_entity_id IN JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE,

317: filename IN VARCHAR2,
318: text_to_write IN VARCHAR2 );
319:
320: PROCEDURE tax_date_maintenance_program (
321: p_legal_entity_id IN JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE,
322: p_ledger_id IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,
323: p_end_date IN GL_PERIODS.END_DATE%TYPE,
324: p_source IN JG_ZZ_VAT_REP_STATUS.source%TYPE,
325: p_debug_flag IN VARCHAR2,

Line 322: p_ledger_id IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,

318: text_to_write IN VARCHAR2 );
319:
320: PROCEDURE tax_date_maintenance_program (
321: p_legal_entity_id IN JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE,
322: p_ledger_id IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,
323: p_end_date IN GL_PERIODS.END_DATE%TYPE,
324: p_source IN JG_ZZ_VAT_REP_STATUS.source%TYPE,
325: p_debug_flag IN VARCHAR2,
326: x_return_status OUT NOCOPY VARCHAR2,

Line 374: p_reporting_level IN JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE,

370: +===========================================================================*/
371:
372: PROCEDURE main( errbuf OUT NOCOPY VARCHAR2,
373: retcode OUT NOCOPY NUMBER,
374: p_reporting_level IN JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE,
375: p_ledger IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE ,
376: p_chart_of_account IN NUMBER,
377: p_bsv IN JG_ZZ_VAT_REP_ENTITIES.balancing_segment_value%TYPE,
378: p_vat_reporting_entity_id IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,

Line 375: p_ledger IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE ,

371:
372: PROCEDURE main( errbuf OUT NOCOPY VARCHAR2,
373: retcode OUT NOCOPY NUMBER,
374: p_reporting_level IN JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE,
375: p_ledger IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE ,
376: p_chart_of_account IN NUMBER,
377: p_bsv IN JG_ZZ_VAT_REP_ENTITIES.balancing_segment_value%TYPE,
378: p_vat_reporting_entity_id IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,
379: p_period IN JG_ZZ_VAT_REP_STATUS.tax_calendar_period%TYPE,

Line 377: p_bsv IN JG_ZZ_VAT_REP_ENTITIES.balancing_segment_value%TYPE,

373: retcode OUT NOCOPY NUMBER,
374: p_reporting_level IN JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE,
375: p_ledger IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE ,
376: p_chart_of_account IN NUMBER,
377: p_bsv IN JG_ZZ_VAT_REP_ENTITIES.balancing_segment_value%TYPE,
378: p_vat_reporting_entity_id IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,
379: p_period IN JG_ZZ_VAT_REP_STATUS.tax_calendar_period%TYPE,
380: p_source IN JG_ZZ_VAT_REP_STATUS.source%TYPE,
381: p_acct_unacctd IN VARCHAR2,

Line 378: p_vat_reporting_entity_id IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,

374: p_reporting_level IN JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE,
375: p_ledger IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE ,
376: p_chart_of_account IN NUMBER,
377: p_bsv IN JG_ZZ_VAT_REP_ENTITIES.balancing_segment_value%TYPE,
378: p_vat_reporting_entity_id IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,
379: p_period IN JG_ZZ_VAT_REP_STATUS.tax_calendar_period%TYPE,
380: p_source IN JG_ZZ_VAT_REP_STATUS.source%TYPE,
381: p_acct_unacctd IN VARCHAR2,
382: p_dummy IN VARCHAR2,

Line 396: l_legal_entity_id JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE;

392: l_selection_process_id JG_ZZ_VAT_REP_STATUS.selection_process_id%TYPE;
393: l_selection_status_flag JG_ZZ_VAT_REP_STATUS.selection_status_flag%TYPE;
394: l_mapping_rep_entity_id JG_ZZ_VAT_REP_STATUS.mapping_vat_rep_entity_id%TYPE;
395: l_country xle_firstparty_information_v.country%TYPE;
396: l_legal_entity_id JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE;
397: l_ledger JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE;
398:
399: -- Bug 6835573
400: l_last_reported_period JG_ZZ_VAT_REP_ENTITIES.last_reported_period%TYPE;

Line 397: l_ledger JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE;

393: l_selection_status_flag JG_ZZ_VAT_REP_STATUS.selection_status_flag%TYPE;
394: l_mapping_rep_entity_id JG_ZZ_VAT_REP_STATUS.mapping_vat_rep_entity_id%TYPE;
395: l_country xle_firstparty_information_v.country%TYPE;
396: l_legal_entity_id JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE;
397: l_ledger JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE;
398:
399: -- Bug 6835573
400: l_last_reported_period JG_ZZ_VAT_REP_ENTITIES.last_reported_period%TYPE;
401: l_is_mgr_trx_exist NUMBER(15);

Line 400: l_last_reported_period JG_ZZ_VAT_REP_ENTITIES.last_reported_period%TYPE;

396: l_legal_entity_id JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE;
397: l_ledger JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE;
398:
399: -- Bug 6835573
400: l_last_reported_period JG_ZZ_VAT_REP_ENTITIES.last_reported_period%TYPE;
401: l_is_mgr_trx_exist NUMBER(15);
402:
403: CURSOR c_last_report_period(pn_vat_rep_entity_id number) IS
404: SELECT last_reported_period

Line 405: FROM jg_zz_vat_rep_entities

401: l_is_mgr_trx_exist NUMBER(15);
402:
403: CURSOR c_last_report_period(pn_vat_rep_entity_id number) IS
404: SELECT last_reported_period
405: FROM jg_zz_vat_rep_entities
406: WHERE vat_reporting_entity_id = pn_vat_rep_entity_id;
407:
408: CURSOR c_is_mgr_trx_exist(pn_vat_rep_entity_id number) IS
409: SELECT JGTRD.trx_id

Line 462: | entity exists in jg_zz_vat_rep_entities table. |

458: | ACCOUNTING reporting entities or not. This procedure calls: |
459: | (1) validate_entity_attributes - Validates the parameters passed |
460: | based on the Reporting Level. |
461: | (2) get_accounting_entity - Checks if the passed accounting |
462: | entity exists in jg_zz_vat_rep_entities table. |
463: | (3) create_accounting_entity - create a record for the accounting|
464: | entity in the table if it does not exists and returns the vat |
465: | reporting entity identifier. |
466: +--------------------------------------------------------------------*/

Line 936: P_REPORTING_LEVEL IN JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE,

932: +===========================================================================*/
933:
934: PROCEDURE initialize(
935: P_GLOBAL_VARIABLES_REC OUT NOCOPY JG_ZZ_VAT_SELECTION_PKG.GLOBAL_VARIABLES_REC_TYPE,
936: P_REPORTING_LEVEL IN JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE,
937: P_LEDGER IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,
938: P_BSV IN JG_ZZ_VAT_REP_ENTITIES.balancing_segment_value%TYPE,
939: P_VAT_REPORTING_ENTITY_ID IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,
940: P_TAX_PERIOD IN JG_ZZ_VAT_REP_STATUS.tax_calendar_period%TYPE,

Line 937: P_LEDGER IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,

933:
934: PROCEDURE initialize(
935: P_GLOBAL_VARIABLES_REC OUT NOCOPY JG_ZZ_VAT_SELECTION_PKG.GLOBAL_VARIABLES_REC_TYPE,
936: P_REPORTING_LEVEL IN JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE,
937: P_LEDGER IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,
938: P_BSV IN JG_ZZ_VAT_REP_ENTITIES.balancing_segment_value%TYPE,
939: P_VAT_REPORTING_ENTITY_ID IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,
940: P_TAX_PERIOD IN JG_ZZ_VAT_REP_STATUS.tax_calendar_period%TYPE,
941: P_SOURCE IN JG_ZZ_VAT_REP_STATUS.source%TYPE,

Line 938: P_BSV IN JG_ZZ_VAT_REP_ENTITIES.balancing_segment_value%TYPE,

934: PROCEDURE initialize(
935: P_GLOBAL_VARIABLES_REC OUT NOCOPY JG_ZZ_VAT_SELECTION_PKG.GLOBAL_VARIABLES_REC_TYPE,
936: P_REPORTING_LEVEL IN JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE,
937: P_LEDGER IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,
938: P_BSV IN JG_ZZ_VAT_REP_ENTITIES.balancing_segment_value%TYPE,
939: P_VAT_REPORTING_ENTITY_ID IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,
940: P_TAX_PERIOD IN JG_ZZ_VAT_REP_STATUS.tax_calendar_period%TYPE,
941: P_SOURCE IN JG_ZZ_VAT_REP_STATUS.source%TYPE,
942: P_ACCTD_UNACCTD IN VARCHAR2,

Line 939: P_VAT_REPORTING_ENTITY_ID IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,

935: P_GLOBAL_VARIABLES_REC OUT NOCOPY JG_ZZ_VAT_SELECTION_PKG.GLOBAL_VARIABLES_REC_TYPE,
936: P_REPORTING_LEVEL IN JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE,
937: P_LEDGER IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,
938: P_BSV IN JG_ZZ_VAT_REP_ENTITIES.balancing_segment_value%TYPE,
939: P_VAT_REPORTING_ENTITY_ID IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,
940: P_TAX_PERIOD IN JG_ZZ_VAT_REP_STATUS.tax_calendar_period%TYPE,
941: P_SOURCE IN JG_ZZ_VAT_REP_STATUS.source%TYPE,
942: P_ACCTD_UNACCTD IN VARCHAR2,
943: P_DEBUG_FLAG IN VARCHAR2,

Line 1144: p_vat_reporting_entity_id IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,

1140: | |
1141: +===========================================================================*/
1142:
1143: PROCEDURE get_VAT_reporting_details (
1144: p_vat_reporting_entity_id IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,
1145: p_global_variables_rec IN OUT NOCOPY JG_ZZ_VAT_SELECTION_PKG.GLOBAL_VARIABLES_REC_TYPE,
1146: x_return_status OUT NOCOPY VARCHAR2
1147: ) IS
1148: l_api_name CONSTANT VARCHAR2(30) := 'GET_VAT_REPORTING_DETAILS';

Line 1172: FROM JG_ZZ_VAT_REP_ENTITIES

1168: p_global_variables_rec.tax_regime_code,
1169: p_global_variables_rec.tax_registration_number,
1170: p_global_variables_rec.tax_calendar_name,
1171: p_global_variables_rec.driving_date_code
1172: FROM JG_ZZ_VAT_REP_ENTITIES
1173: WHERE nvl(mapping_vat_rep_entity_id,
1174: vat_reporting_entity_id) = p_vat_reporting_entity_id
1175: AND entity_type_code = 'LEGAL';
1176:

Line 2758: from jg_zz_vat_rep_entities legal

2754:
2755: cursor last_report_date (pn_vat_rep_entity_id number) IS
2756: select glp.start_date
2757: ,glp.end_date
2758: from jg_zz_vat_rep_entities legal
2759: ,jg_zz_vat_rep_entities acct
2760: ,gl_periods glp
2761: where acct.entity_type_code='ACCOUNTING'
2762: and acct.vat_reporting_entity_id = pn_vat_rep_entity_id

Line 2759: ,jg_zz_vat_rep_entities acct

2755: cursor last_report_date (pn_vat_rep_entity_id number) IS
2756: select glp.start_date
2757: ,glp.end_date
2758: from jg_zz_vat_rep_entities legal
2759: ,jg_zz_vat_rep_entities acct
2760: ,gl_periods glp
2761: where acct.entity_type_code='ACCOUNTING'
2762: and acct.vat_reporting_entity_id = pn_vat_rep_entity_id
2763: and acct.mapping_vat_rep_entity_id= legal.vat_reporting_entity_id

Line 3118: JG_ZZ_VAT_REP_ENTITIES JGRE

3114: jgrs.vat_reporting_entity_id,
3115: jgre.entity_identifier
3116: FROM JG_ZZ_VAT_TRX_DETAILS JGVT,
3117: JG_ZZ_VAT_REP_STATUS JGRS,
3118: JG_ZZ_VAT_REP_ENTITIES JGRE
3119: WHERE JGVT.reporting_status_id = JGRS.reporting_status_id
3120: AND JGRS.vat_reporting_entity_id = JGRE.vat_reporting_entity_id
3121: AND (nvl(JGVT.internal_organization_id,-99),
3122: JGVT.application_id ,

Line 3572: ( p_legal_entity_id IN JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE,

3568: | to support unaccounted status |
3569: | |
3570: +===========================================================================*/
3571: PROCEDURE tax_date_maintenance_program
3572: ( p_legal_entity_id IN JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE,
3573: p_ledger_id IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,
3574: p_end_date IN GL_PERIODS.end_date%TYPE,
3575: p_source IN JG_ZZ_VAT_REP_STATUS.source%TYPE,
3576: p_debug_flag IN VARCHAR2,

Line 3573: p_ledger_id IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,

3569: | |
3570: +===========================================================================*/
3571: PROCEDURE tax_date_maintenance_program
3572: ( p_legal_entity_id IN JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE,
3573: p_ledger_id IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,
3574: p_end_date IN GL_PERIODS.end_date%TYPE,
3575: p_source IN JG_ZZ_VAT_REP_STATUS.source%TYPE,
3576: p_debug_flag IN VARCHAR2,
3577: x_return_status OUT NOCOPY VARCHAR2,