[Home] [Help]
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
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
535: | re-selection is not allowed. |
536: | (3) Before re-selection, purge allocation data and errors table by|
537: | calling allocation purge api. |
538: | (4) Before re-selection, purge the tax data pertaining to the |
539: | previous run from jg_zz_vat_trx_details table by calling |
540: | jg_zz_vat_selection_pkg.purge_tax_data. |
541: | (5) Before re-selection, update the status information (nullify) |
542: | of the selection process for the given combination by calling |
543: | JG_ZZ_VAT_REP_UTILITY.pre_process_update procedure. |
700:
701: IF l_global_variables_rec.retcode <> 2 THEN
702:
703: -- Bulk fetch data from TRL interface table.
704: -- And bulk insert into JG_ZZ_VAT_TRX_DETAILS.
705: fetch_tax_data(l_global_variables_rec,
706: g_conc_request_id);
707: ELSE
708: l_selection_status_flag := fnd_api.g_ret_sts_error;
805: | PROCEDURE |
806: | purge_tax_data |
807: | |
808: | DESCRIPTION |
809: | This procedure deletes the records from JG_ZZ_VAT_TRX_DETAILS |
810: | for a given reporting_status_id |
811: | |
812: | SCOPE - Public |
813: | |
836:
837: /*Set the return status to Success */
838: x_return_status := FND_API.G_RET_STS_SUCCESS;
839:
840: delete from JG_ZZ_VAT_TRX_DETAILS
841: where reporting_Status_id = p_reporting_status_id;
842:
843: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
844: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
874: | FUNCTION |
875: | PURGE_TAX_DATA |
876: | |
877: | DESCRIPTION |
878: | This function deletes the records from JG_ZZ_VAT_TRX_DETAILS, |
879: | for a given reporting_status_id |
880: | |
881: | SCOPE - Public |
882: | |
895: BEGIN
896:
897:
898: select count(*) into num_rows_deleted
899: from jg_zz_vat_trx_details
900: where reporting_status_id = p_reporting_status_id;
901:
902: PURGE_TAX_DATA(p_reporting_status_id, l_return_status);
903:
1584: | fetch_tax_data |
1585: | DESCRIPTION |
1586: | This procedure fetches tax data from TRL interface tables using bulk |
1587: | collect and calls insert_tax_data to perform a bulk insert into |
1588: | jg_zz_vat_trx_details_table. |
1589: | SCOPE - Private |
1590: | |
1591: | NOTES |
1592: | |
1858: AND DET.REP_CONTEXT_ID = CON.REP_CONTEXT_ID
1859: AND EXT.DETAIL_TAX_LINE_ID(+) = DET.DETAIL_TAX_LINE_ID
1860: AND ACT.DETAIL_TAX_LINE_ID(+) = DET.DETAIL_TAX_LINE_ID
1861: AND NOT EXISTS (SELECT 1
1862: FROM JG_ZZ_VAT_TRX_DETAILS JG
1863: WHERE JG.TRX_ID = DET.TRX_ID
1864: AND JG.APPLICATION_ID = DET.APPLICATION_ID
1865: AND JG.ENTITY_CODE = DET.ENTITY_CODE
1866: AND JG.EVENT_CLASS_CODE = DET.EVENT_CLASS_CODE
2127: /*===========================================================================+
2128: | PROCEDURE |
2129: | insert_tax_data |
2130: | DESCRIPTION |
2131: | This procedure bulk inserts tax data into JG_ZZ_VAT_TRX_DETAILS table |
2132: | |
2133: | SCOPE - Private |
2134: | |
2135: | NOTES |
2178:
2179:
2180: FORALL i IN 1 .. l_count
2181:
2182: INSERT INTO JG_ZZ_VAT_TRX_DETAILS(
2183: VAT_TRANSACTION_ID ,
2184: REPORTING_STATUS_ID ,
2185: SELECTION_PROCESS_ID ,
2186: FINAL_REPORTING_ID ,
2408: TAX_ORIGIN ,
2409: REPORTING_CODE ,
2410: DEF_REC_SETTLEMENT_OPTION_CODE)
2411: VALUES (
2412: JG_ZZ_VAT_TRX_DETAILS_S.NEXTVAL,
2413: DECODE( gt_extract_source_ledger(i), 'AR', g_rep_status_id_ar,
2414: 'AP', g_rep_status_id_ap,
2415: 'GL', g_rep_status_id_gl),
2416: g_selection_process_id,
3112: jgvt.reporting_status_id ,
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
3436: delete from jg_zz_vat_box_errors
3437: where vat_transaction_id = IdList(i) ;
3438:
3439: FORALL i in 1..l_trx_count
3440: delete from jg_zz_vat_trx_details
3441: where vat_transaction_id = IdList(i) ;
3442:
3443: END IF ; --IF l_trx_count > 0 THEN
3444:
3614: AND trunc(checks.cleared_date) < trunc(p_end_date)
3615: AND checks.status_lookup_code IN ('CLEARED', 'RECONCILED',
3616: 'CLEARED BUT UNACCOUNTED', 'RECONCILED UNACCOUNTED')
3617: AND NOT EXISTS ( SELECT 1
3618: FROM jg_zz_vat_trx_details vtd
3619: WHERE vtd.application_id = 200
3620: AND vtd.trx_id = inv.invoice_id
3621: AND vtd.entity_code = zdf.entity_code
3622: AND vtd.event_class_code = zdf.event_class_code
3653: AND amount_applied >= 0
3654: AND trunc(rpt.apply_date) <= trunc(p_end_date)
3655: AND rpt.apply_date < zdf.tax_invoice_date
3656: AND NOT EXISTS (SELECT 1
3657: FROM jg_zz_vat_trx_details
3658: WHERE application_id = 222
3659: AND trx_id = trx.customer_trx_id
3660: AND entity_code = zdf.entity_code
3661: AND event_class_code = zdf.event_class_code