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 279: P_REPORTING_LEVEL IN JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE,

275: ----------------------------------------
276: --
277: PROCEDURE initialize(
278: P_GLOBAL_VARIABLES_REC OUT NOCOPY JG_ZZ_VAT_SELECTION_PKG.GLOBAL_VARIABLES_REC_TYPE,
279: P_REPORTING_LEVEL IN JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE,
280: P_LEDGER IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,
281: P_BSV IN JG_ZZ_VAT_REP_ENTITIES.balancing_segment_value%TYPE,
282: P_VAT_REPORTING_ENTITY_ID IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,
283: P_TAX_PERIOD IN JG_ZZ_VAT_REP_STATUS.tax_calendar_period%TYPE,

Line 280: P_LEDGER IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,

276: --
277: PROCEDURE initialize(
278: P_GLOBAL_VARIABLES_REC OUT NOCOPY JG_ZZ_VAT_SELECTION_PKG.GLOBAL_VARIABLES_REC_TYPE,
279: P_REPORTING_LEVEL IN JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE,
280: P_LEDGER IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,
281: P_BSV IN JG_ZZ_VAT_REP_ENTITIES.balancing_segment_value%TYPE,
282: P_VAT_REPORTING_ENTITY_ID IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,
283: P_TAX_PERIOD IN JG_ZZ_VAT_REP_STATUS.tax_calendar_period%TYPE,
284: P_SOURCE IN JG_ZZ_VAT_REP_STATUS.source%TYPE,

Line 281: P_BSV IN JG_ZZ_VAT_REP_ENTITIES.balancing_segment_value%TYPE,

277: PROCEDURE initialize(
278: P_GLOBAL_VARIABLES_REC OUT NOCOPY JG_ZZ_VAT_SELECTION_PKG.GLOBAL_VARIABLES_REC_TYPE,
279: P_REPORTING_LEVEL IN JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE,
280: P_LEDGER IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,
281: P_BSV IN JG_ZZ_VAT_REP_ENTITIES.balancing_segment_value%TYPE,
282: P_VAT_REPORTING_ENTITY_ID IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,
283: P_TAX_PERIOD IN JG_ZZ_VAT_REP_STATUS.tax_calendar_period%TYPE,
284: P_SOURCE IN JG_ZZ_VAT_REP_STATUS.source%TYPE,
285: P_ACCTD_UNACCTD IN VARCHAR2,

Line 282: P_VAT_REPORTING_ENTITY_ID IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,

278: P_GLOBAL_VARIABLES_REC OUT NOCOPY JG_ZZ_VAT_SELECTION_PKG.GLOBAL_VARIABLES_REC_TYPE,
279: P_REPORTING_LEVEL IN JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE,
280: P_LEDGER IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,
281: P_BSV IN JG_ZZ_VAT_REP_ENTITIES.balancing_segment_value%TYPE,
282: P_VAT_REPORTING_ENTITY_ID IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,
283: P_TAX_PERIOD IN JG_ZZ_VAT_REP_STATUS.tax_calendar_period%TYPE,
284: P_SOURCE IN JG_ZZ_VAT_REP_STATUS.source%TYPE,
285: P_ACCTD_UNACCTD IN VARCHAR2,
286: P_DEBUG_FLAG IN VARCHAR2,

Line 297: p_vat_reporting_entity_id IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,

293: p_global_variables_rec IN OUT NOCOPY JG_ZZ_VAT_SELECTION_PKG.GLOBAL_VARIABLES_REC_TYPE,
294: x_return_status OUT NOCOPY VARCHAR2);
295:
296: PROCEDURE get_VAT_reporting_details (
297: p_vat_reporting_entity_id IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,
298: p_global_variables_rec IN OUT NOCOPY JG_ZZ_VAT_SELECTION_PKG.GLOBAL_VARIABLES_REC_TYPE,
299: x_return_status OUT NOCOPY VARCHAR2);
300:
301: PROCEDURE call_TRL (

Line 327: p_legal_entity_id IN JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE,

323: filename IN VARCHAR2,
324: text_to_write IN VARCHAR2 );
325:
326: PROCEDURE tax_date_maintenance_program (
327: p_legal_entity_id IN JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE,
328: p_ledger_id IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,
329: p_end_date IN GL_PERIODS.END_DATE%TYPE,
330: p_source IN JG_ZZ_VAT_REP_STATUS.source%TYPE,
331: p_debug_flag IN VARCHAR2,

Line 328: p_ledger_id IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,

324: text_to_write IN VARCHAR2 );
325:
326: PROCEDURE tax_date_maintenance_program (
327: p_legal_entity_id IN JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE,
328: p_ledger_id IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,
329: p_end_date IN GL_PERIODS.END_DATE%TYPE,
330: p_source IN JG_ZZ_VAT_REP_STATUS.source%TYPE,
331: p_debug_flag IN VARCHAR2,
332: x_return_status OUT NOCOPY VARCHAR2,

Line 380: p_reporting_level IN JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE,

376: +===========================================================================*/
377:
378: PROCEDURE main( errbuf OUT NOCOPY VARCHAR2,
379: retcode OUT NOCOPY NUMBER,
380: p_reporting_level IN JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE,
381: p_ledger IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE ,
382: p_chart_of_account IN NUMBER,
383: p_bsv IN JG_ZZ_VAT_REP_ENTITIES.balancing_segment_value%TYPE,
384: p_vat_reporting_entity_id IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,

Line 381: p_ledger IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE ,

377:
378: PROCEDURE main( errbuf OUT NOCOPY VARCHAR2,
379: retcode OUT NOCOPY NUMBER,
380: p_reporting_level IN JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE,
381: p_ledger IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE ,
382: p_chart_of_account IN NUMBER,
383: p_bsv IN JG_ZZ_VAT_REP_ENTITIES.balancing_segment_value%TYPE,
384: p_vat_reporting_entity_id IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,
385: p_period IN JG_ZZ_VAT_REP_STATUS.tax_calendar_period%TYPE,

Line 383: p_bsv IN JG_ZZ_VAT_REP_ENTITIES.balancing_segment_value%TYPE,

379: retcode OUT NOCOPY NUMBER,
380: p_reporting_level IN JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE,
381: p_ledger IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE ,
382: p_chart_of_account IN NUMBER,
383: p_bsv IN JG_ZZ_VAT_REP_ENTITIES.balancing_segment_value%TYPE,
384: p_vat_reporting_entity_id IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,
385: p_period IN JG_ZZ_VAT_REP_STATUS.tax_calendar_period%TYPE,
386: p_source IN JG_ZZ_VAT_REP_STATUS.source%TYPE,
387: p_acct_unacctd IN VARCHAR2,

Line 384: p_vat_reporting_entity_id IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,

380: p_reporting_level IN JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE,
381: p_ledger IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE ,
382: p_chart_of_account IN NUMBER,
383: p_bsv IN JG_ZZ_VAT_REP_ENTITIES.balancing_segment_value%TYPE,
384: p_vat_reporting_entity_id IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,
385: p_period IN JG_ZZ_VAT_REP_STATUS.tax_calendar_period%TYPE,
386: p_source IN JG_ZZ_VAT_REP_STATUS.source%TYPE,
387: p_acct_unacctd IN VARCHAR2,
388: p_dummy IN VARCHAR2,

Line 402: l_legal_entity_id JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE;

398: l_selection_process_id JG_ZZ_VAT_REP_STATUS.selection_process_id%TYPE;
399: l_selection_status_flag JG_ZZ_VAT_REP_STATUS.selection_status_flag%TYPE;
400: l_mapping_rep_entity_id JG_ZZ_VAT_REP_STATUS.mapping_vat_rep_entity_id%TYPE;
401: l_country xle_firstparty_information_v.country%TYPE;
402: l_legal_entity_id JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE;
403: l_ledger JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE;
404:
405: -- Bug 6835573
406: l_last_reported_period JG_ZZ_VAT_REP_ENTITIES.last_reported_period%TYPE;

Line 403: l_ledger JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE;

399: l_selection_status_flag JG_ZZ_VAT_REP_STATUS.selection_status_flag%TYPE;
400: l_mapping_rep_entity_id JG_ZZ_VAT_REP_STATUS.mapping_vat_rep_entity_id%TYPE;
401: l_country xle_firstparty_information_v.country%TYPE;
402: l_legal_entity_id JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE;
403: l_ledger JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE;
404:
405: -- Bug 6835573
406: l_last_reported_period JG_ZZ_VAT_REP_ENTITIES.last_reported_period%TYPE;
407: l_is_mgr_trx_exist NUMBER(15);

Line 406: l_last_reported_period JG_ZZ_VAT_REP_ENTITIES.last_reported_period%TYPE;

402: l_legal_entity_id JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE;
403: l_ledger JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE;
404:
405: -- Bug 6835573
406: l_last_reported_period JG_ZZ_VAT_REP_ENTITIES.last_reported_period%TYPE;
407: l_is_mgr_trx_exist NUMBER(15);
408:
409:
410:

Line 440: from jg_zz_vat_rep_entities legal

436: l_last_rep_period_end_date DATE;
437:
438: cursor last_reported_date_from_11i (pn_vat_rep_entity_id number) IS
439: select glp.start_date,glp.end_date,acct.last_reported_period
440: from jg_zz_vat_rep_entities legal
441: ,jg_zz_vat_rep_entities acct
442: ,gl_periods glp
443: where acct.entity_type_code = 'ACCOUNTING'
444: and acct.vat_reporting_entity_id = pn_vat_rep_entity_id

Line 441: ,jg_zz_vat_rep_entities acct

437:
438: cursor last_reported_date_from_11i (pn_vat_rep_entity_id number) IS
439: select glp.start_date,glp.end_date,acct.last_reported_period
440: from jg_zz_vat_rep_entities legal
441: ,jg_zz_vat_rep_entities acct
442: ,gl_periods glp
443: where acct.entity_type_code = 'ACCOUNTING'
444: and acct.vat_reporting_entity_id = pn_vat_rep_entity_id
445: and acct.mapping_vat_rep_entity_id= legal.vat_reporting_entity_id

Line 487: | entity exists in jg_zz_vat_rep_entities table. |

483: | ACCOUNTING reporting entities or not. This procedure calls: |
484: | (1) validate_entity_attributes - Validates the parameters passed |
485: | based on the Reporting Level. |
486: | (2) get_accounting_entity - Checks if the passed accounting |
487: | entity exists in jg_zz_vat_rep_entities table. |
488: | (3) create_accounting_entity - create a record for the accounting|
489: | entity in the table if it does not exists and returns the vat |
490: | reporting entity identifier. |
491: +--------------------------------------------------------------------*/

Line 991: P_REPORTING_LEVEL IN JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE,

987: +===========================================================================*/
988:
989: PROCEDURE initialize(
990: P_GLOBAL_VARIABLES_REC OUT NOCOPY JG_ZZ_VAT_SELECTION_PKG.GLOBAL_VARIABLES_REC_TYPE,
991: P_REPORTING_LEVEL IN JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE,
992: P_LEDGER IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,
993: P_BSV IN JG_ZZ_VAT_REP_ENTITIES.balancing_segment_value%TYPE,
994: P_VAT_REPORTING_ENTITY_ID IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,
995: P_TAX_PERIOD IN JG_ZZ_VAT_REP_STATUS.tax_calendar_period%TYPE,

Line 992: P_LEDGER IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,

988:
989: PROCEDURE initialize(
990: P_GLOBAL_VARIABLES_REC OUT NOCOPY JG_ZZ_VAT_SELECTION_PKG.GLOBAL_VARIABLES_REC_TYPE,
991: P_REPORTING_LEVEL IN JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE,
992: P_LEDGER IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,
993: P_BSV IN JG_ZZ_VAT_REP_ENTITIES.balancing_segment_value%TYPE,
994: P_VAT_REPORTING_ENTITY_ID IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,
995: P_TAX_PERIOD IN JG_ZZ_VAT_REP_STATUS.tax_calendar_period%TYPE,
996: P_SOURCE IN JG_ZZ_VAT_REP_STATUS.source%TYPE,

Line 993: P_BSV IN JG_ZZ_VAT_REP_ENTITIES.balancing_segment_value%TYPE,

989: PROCEDURE initialize(
990: P_GLOBAL_VARIABLES_REC OUT NOCOPY JG_ZZ_VAT_SELECTION_PKG.GLOBAL_VARIABLES_REC_TYPE,
991: P_REPORTING_LEVEL IN JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE,
992: P_LEDGER IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,
993: P_BSV IN JG_ZZ_VAT_REP_ENTITIES.balancing_segment_value%TYPE,
994: P_VAT_REPORTING_ENTITY_ID IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,
995: P_TAX_PERIOD IN JG_ZZ_VAT_REP_STATUS.tax_calendar_period%TYPE,
996: P_SOURCE IN JG_ZZ_VAT_REP_STATUS.source%TYPE,
997: P_ACCTD_UNACCTD IN VARCHAR2,

Line 994: P_VAT_REPORTING_ENTITY_ID IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,

990: P_GLOBAL_VARIABLES_REC OUT NOCOPY JG_ZZ_VAT_SELECTION_PKG.GLOBAL_VARIABLES_REC_TYPE,
991: P_REPORTING_LEVEL IN JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE,
992: P_LEDGER IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,
993: P_BSV IN JG_ZZ_VAT_REP_ENTITIES.balancing_segment_value%TYPE,
994: P_VAT_REPORTING_ENTITY_ID IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,
995: P_TAX_PERIOD IN JG_ZZ_VAT_REP_STATUS.tax_calendar_period%TYPE,
996: P_SOURCE IN JG_ZZ_VAT_REP_STATUS.source%TYPE,
997: P_ACCTD_UNACCTD IN VARCHAR2,
998: P_DEBUG_FLAG IN VARCHAR2,

Line 1199: p_vat_reporting_entity_id IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,

1195: | |
1196: +===========================================================================*/
1197:
1198: PROCEDURE get_VAT_reporting_details (
1199: p_vat_reporting_entity_id IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,
1200: p_global_variables_rec IN OUT NOCOPY JG_ZZ_VAT_SELECTION_PKG.GLOBAL_VARIABLES_REC_TYPE,
1201: x_return_status OUT NOCOPY VARCHAR2
1202: ) IS
1203: l_api_name CONSTANT VARCHAR2(30) := 'GET_VAT_REPORTING_DETAILS';

Line 1227: FROM JG_ZZ_VAT_REP_ENTITIES

1223: p_global_variables_rec.tax_regime_code,
1224: p_global_variables_rec.tax_registration_number,
1225: p_global_variables_rec.tax_calendar_name,
1226: p_global_variables_rec.driving_date_code
1227: FROM JG_ZZ_VAT_REP_ENTITIES
1228: WHERE nvl(mapping_vat_rep_entity_id,
1229: vat_reporting_entity_id) = p_vat_reporting_entity_id
1230: AND entity_type_code = 'LEGAL';
1231:

Line 2874: from jg_zz_vat_rep_entities legal

2870:
2871: cursor last_report_date (pn_vat_rep_entity_id number) IS
2872: select glp.start_date
2873: ,glp.end_date
2874: from jg_zz_vat_rep_entities legal
2875: ,jg_zz_vat_rep_entities acct
2876: ,gl_periods glp
2877: where acct.entity_type_code='ACCOUNTING'
2878: and acct.vat_reporting_entity_id = pn_vat_rep_entity_id

Line 2875: ,jg_zz_vat_rep_entities acct

2871: cursor last_report_date (pn_vat_rep_entity_id number) IS
2872: select glp.start_date
2873: ,glp.end_date
2874: from jg_zz_vat_rep_entities legal
2875: ,jg_zz_vat_rep_entities acct
2876: ,gl_periods glp
2877: where acct.entity_type_code='ACCOUNTING'
2878: and acct.vat_reporting_entity_id = pn_vat_rep_entity_id
2879: and acct.mapping_vat_rep_entity_id= legal.vat_reporting_entity_id

Line 3239: JG_ZZ_VAT_REP_ENTITIES JGRE

3235: jgrs.vat_reporting_entity_id,
3236: jgre.entity_identifier
3237: FROM JG_ZZ_VAT_TRX_DETAILS JGVT,
3238: JG_ZZ_VAT_REP_STATUS JGRS,
3239: JG_ZZ_VAT_REP_ENTITIES JGRE
3240: WHERE JGVT.reporting_status_id = JGRS.reporting_status_id
3241: AND JGRS.vat_reporting_entity_id = JGRE.vat_reporting_entity_id
3242: AND (JGRS.period_end_date > p_global_variables_rec.LAST_REP_PERIOD_END_DATE
3243: OR p_global_variables_rec.LAST_REP_PERIOD_END_DATE IS NULL)

Line 3297: JG_ZZ_VAT_REP_ENTITIES JGRE

3293: jgrs.vat_reporting_entity_id,
3294: jgre.entity_identifier
3295: FROM JG_ZZ_VAT_TRX_DETAILS JGVT,
3296: JG_ZZ_VAT_REP_STATUS JGRS,
3297: JG_ZZ_VAT_REP_ENTITIES JGRE
3298: WHERE JGVT.reporting_status_id = JGRS.reporting_status_id
3299: AND JGRS.vat_reporting_entity_id = JGRE.vat_reporting_entity_id
3300: AND (nvl(JGVT.internal_organization_id,-99),
3301: JGVT.application_id ,

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

3749: | to support unaccounted status |
3750: | |
3751: +===========================================================================*/
3752: PROCEDURE tax_date_maintenance_program
3753: ( p_legal_entity_id IN JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE,
3754: p_ledger_id IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,
3755: p_end_date IN GL_PERIODS.end_date%TYPE,
3756: p_source IN JG_ZZ_VAT_REP_STATUS.source%TYPE,
3757: p_debug_flag IN VARCHAR2,

Line 3754: p_ledger_id IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,

3750: | |
3751: +===========================================================================*/
3752: PROCEDURE tax_date_maintenance_program
3753: ( p_legal_entity_id IN JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE,
3754: p_ledger_id IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,
3755: p_end_date IN GL_PERIODS.end_date%TYPE,
3756: p_source IN JG_ZZ_VAT_REP_STATUS.source%TYPE,
3757: p_debug_flag IN VARCHAR2,
3758: x_return_status OUT NOCOPY VARCHAR2,