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_STATUS

Line 34: g_rep_status_id_ap jg_zz_vat_rep_status.reporting_status_id%type;

30: g_prog_appl_id number(15);
31: g_conc_program_id number(15);
32: g_conc_login_id number(15);
33:
34: g_rep_status_id_ap jg_zz_vat_rep_status.reporting_status_id%type;
35: g_rep_status_id_ar jg_zz_vat_rep_status.reporting_status_id%type;
36: g_rep_status_id_gl jg_zz_vat_rep_status.reporting_status_id%type;
37: g_selection_process_id jg_zz_vat_rep_status.selection_process_id%type;
38:

Line 35: g_rep_status_id_ar jg_zz_vat_rep_status.reporting_status_id%type;

31: g_conc_program_id number(15);
32: g_conc_login_id number(15);
33:
34: g_rep_status_id_ap jg_zz_vat_rep_status.reporting_status_id%type;
35: g_rep_status_id_ar jg_zz_vat_rep_status.reporting_status_id%type;
36: g_rep_status_id_gl jg_zz_vat_rep_status.reporting_status_id%type;
37: g_selection_process_id jg_zz_vat_rep_status.selection_process_id%type;
38:
39: -- Declare table type global variables

Line 36: g_rep_status_id_gl jg_zz_vat_rep_status.reporting_status_id%type;

32: g_conc_login_id number(15);
33:
34: g_rep_status_id_ap jg_zz_vat_rep_status.reporting_status_id%type;
35: g_rep_status_id_ar jg_zz_vat_rep_status.reporting_status_id%type;
36: g_rep_status_id_gl jg_zz_vat_rep_status.reporting_status_id%type;
37: g_selection_process_id jg_zz_vat_rep_status.selection_process_id%type;
38:
39: -- Declare table type global variables
40: gt_vat_transaction_id JG_ZZ_VAT_SELECTION_PKG.vat_transaction_id_tbl;

Line 37: g_selection_process_id jg_zz_vat_rep_status.selection_process_id%type;

33:
34: g_rep_status_id_ap jg_zz_vat_rep_status.reporting_status_id%type;
35: g_rep_status_id_ar jg_zz_vat_rep_status.reporting_status_id%type;
36: g_rep_status_id_gl jg_zz_vat_rep_status.reporting_status_id%type;
37: g_selection_process_id jg_zz_vat_rep_status.selection_process_id%type;
38:
39: -- Declare table type global variables
40: gt_vat_transaction_id JG_ZZ_VAT_SELECTION_PKG.vat_transaction_id_tbl;
41: gt_reporting_status_id JG_ZZ_VAT_SELECTION_PKG.reporting_status_id_tbl;

Line 283: P_TAX_PERIOD IN JG_ZZ_VAT_REP_STATUS.tax_calendar_period%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,
287: P_ERRBUF IN OUT NOCOPY VARCHAR2,

Line 284: P_SOURCE IN JG_ZZ_VAT_REP_STATUS.source%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,
287: P_ERRBUF IN OUT NOCOPY VARCHAR2,
288: P_RETCODE IN OUT NOCOPY VARCHAR2);

Line 330: p_source IN JG_ZZ_VAT_REP_STATUS.source%TYPE,

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,
333: x_errbuf OUT NOCOPY VARCHAR2 );
334:

Line 354: | (2) Insert status information into jg_zz_vat_rep_status table. |

350: | (1) JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities to validate and |
351: | determine whether to create ACCOUNTING reporting entities or not. |
352: | (2) JG_ZZ_VAT_REP_UTILITY.validate_process_initiation to validate and |
353: | determine whether to proceed with selection or not. |
354: | (2) Insert status information into jg_zz_vat_rep_status table. |
355: | (3) Call TRL engine to fetch AR, AP, GL tax information. |
356: | (4) Controls intersecting domains (transactions selected in current |
357: | run intersects with a previous selection run(s). |
358: | (5) Insert TRL info into JG Tax Trx table |

Line 385: p_period IN JG_ZZ_VAT_REP_STATUS.tax_calendar_period%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,
389: p_entity_identifier IN VARCHAR2,

Line 386: p_source IN JG_ZZ_VAT_REP_STATUS.source%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,
389: p_entity_identifier IN VARCHAR2,
390: p_debug_flag IN VARCHAR2)

Line 398: l_selection_process_id JG_ZZ_VAT_REP_STATUS.selection_process_id%TYPE;

394: l_return_status VARCHAR2(1);
395: l_return_message VARCHAR2(1000);
396: l_intersect_domain_err VARCHAR2(1000);
397:
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;

Line 399: l_selection_status_flag JG_ZZ_VAT_REP_STATUS.selection_status_flag%TYPE;

395: l_return_message VARCHAR2(1000);
396: l_intersect_domain_err VARCHAR2(1000);
397:
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;

Line 400: l_mapping_rep_entity_id JG_ZZ_VAT_REP_STATUS.mapping_vat_rep_entity_id%TYPE;

396: l_intersect_domain_err VARCHAR2(1000);
397:
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:

Line 414: jg_zz_vat_rep_status JGREPS,

410:
411: CURSOR c_is_mgr_trx_exist(pn_vat_rep_entity_id number) IS
412: SELECT JGTRD.trx_id
413: FROM jg_zz_vat_trx_details JGTRD,
414: jg_zz_vat_rep_status JGREPS,
415: zx_lines ZX
416: WHERE JGREPS.vat_reporting_entity_id = pn_vat_rep_entity_id
417: AND JGREPS.reporting_status_id = JGTRD.reporting_status_id
418: AND JGREPS.source = JGTRD.extract_source_ledger

Line 602: | jg_zz_vat_rep_status table. |

598: | JG_ZZ_VAT_REP_UTILITY.pre_process_update procedure. |
599: | (6) If Selection is not yet initiated for the given combination |
600: | Validate if there is any gap in selection as per calendar |
601: | (7) Inserts status information of the Selection process into the |
602: | jg_zz_vat_rep_status table. |
603: +--------------------------------------------------------------------*/
604: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
605: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
606: 'JG_ZZ_VAT_REP_UTILITY.validate_process_initiation'||'.BEGIN',

Line 781: -- jg_zz_vat_rep_status table by passing proper values.

777: END IF;
778:
779: -- post_process_update
780: -- Call the utility API to update selection_process columns of
781: -- jg_zz_vat_rep_status table by passing proper values.
782: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
783: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
784: 'JG_ZZ_VAT_REP_UTILITY.post_process_update'||'.BEGIN',
785: G_PKG_NAME||': '||

Line 995: P_TAX_PERIOD IN JG_ZZ_VAT_REP_STATUS.tax_calendar_period%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,
999: P_ERRBUF IN OUT NOCOPY VARCHAR2,

Line 996: P_SOURCE IN JG_ZZ_VAT_REP_STATUS.source%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,
999: P_ERRBUF IN OUT NOCOPY VARCHAR2,
1000: P_RETCODE IN OUT NOCOPY VARCHAR2)

Line 1321: from jg_zz_vat_rep_status

1317:
1318: -- BEGIN Code to check if this is a very first reporting period.
1319:
1320: select count(*) INTO l_count
1321: from jg_zz_vat_rep_status
1322: where vat_reporting_entity_id = p_global_variables_rec.vat_reporting_entity_id
1323: and period_start_date < p_global_variables_rec.tax_invoice_date_low
1324: and ( period_start_date > p_global_variables_rec.last_rep_period_start_date
1325: or p_global_variables_rec.last_rep_period_start_date is null) --9381398

Line 2279: select JG_ZZ_VAT_REP_STATUS_S1.NEXTVAL

2275: ' Record Count = ' ||to_char(l_count));
2276: END IF;
2277:
2278: if g_selection_process_id is null then
2279: select JG_ZZ_VAT_REP_STATUS_S1.NEXTVAL
2280: into g_selection_process_id from dual;
2281: end if;
2282:
2283:

Line 3238: JG_ZZ_VAT_REP_STATUS JGRS,

3234: jgvt.final_reporting_id,
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

Line 3296: JG_ZZ_VAT_REP_STATUS JGRS,

3292: jgvt.final_reporting_id,
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),

Line 3756: p_source IN JG_ZZ_VAT_REP_STATUS.source%TYPE,

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,
3759: x_errbuf OUT NOCOPY VARCHAR2
3760: )