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

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

Line 324: p_source IN JG_ZZ_VAT_REP_STATUS.source%TYPE,

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

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

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

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

Line 380: p_source IN JG_ZZ_VAT_REP_STATUS.source%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,
383: p_entity_identifier IN VARCHAR2,
384: p_debug_flag IN VARCHAR2)

Line 392: l_selection_process_id JG_ZZ_VAT_REP_STATUS.selection_process_id%TYPE;

388: l_return_status VARCHAR2(1);
389: l_return_message VARCHAR2(1000);
390: l_intersect_domain_err VARCHAR2(1000);
391:
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;

Line 393: l_selection_status_flag JG_ZZ_VAT_REP_STATUS.selection_status_flag%TYPE;

389: l_return_message VARCHAR2(1000);
390: l_intersect_domain_err VARCHAR2(1000);
391:
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;

Line 394: l_mapping_rep_entity_id JG_ZZ_VAT_REP_STATUS.mapping_vat_rep_entity_id%TYPE;

390: l_intersect_domain_err VARCHAR2(1000);
391:
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:

Line 411: jg_zz_vat_rep_status JGREPS,

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

Line 547: | jg_zz_vat_rep_status table. |

543: | JG_ZZ_VAT_REP_UTILITY.pre_process_update procedure. |
544: | (6) If Selection is not yet initiated for the given combination |
545: | Validate if there is any gap in selection as per calendar |
546: | (7) Inserts status information of the Selection process into the |
547: | jg_zz_vat_rep_status table. |
548: +--------------------------------------------------------------------*/
549: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
550: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
551: 'JG_ZZ_VAT_REP_UTILITY.validate_process_initiation'||'.BEGIN',

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

722: END IF;
723:
724: -- post_process_update
725: -- Call the utility API to update selection_process columns of
726: -- jg_zz_vat_rep_status table by passing proper values.
727: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
728: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
729: 'JG_ZZ_VAT_REP_UTILITY.post_process_update'||'.BEGIN',
730: G_PKG_NAME||': '||

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

Line 941: P_SOURCE IN JG_ZZ_VAT_REP_STATUS.source%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,
944: P_ERRBUF IN OUT NOCOPY VARCHAR2,
945: P_RETCODE IN OUT NOCOPY VARCHAR2)

Line 2175: select JG_ZZ_VAT_REP_STATUS_S1.NEXTVAL

2171: ' Record Count = ' ||to_char(l_count));
2172: END IF;
2173:
2174: if g_selection_process_id is null then
2175: select JG_ZZ_VAT_REP_STATUS_S1.NEXTVAL
2176: into g_selection_process_id from dual;
2177: end if;
2178:
2179:

Line 3117: JG_ZZ_VAT_REP_STATUS JGRS,

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

Line 3575: p_source IN JG_ZZ_VAT_REP_STATUS.source%TYPE,

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,
3578: x_errbuf OUT NOCOPY VARCHAR2
3579: )