[Home] [Help]
409:
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
590: | re-selection is not allowed. |
591: | (3) Before re-selection, purge allocation data and errors table by|
592: | calling allocation purge api. |
593: | (4) Before re-selection, purge the tax data pertaining to the |
594: | previous run from jg_zz_vat_trx_details table by calling |
595: | jg_zz_vat_selection_pkg.purge_tax_data. |
596: | (5) Before re-selection, update the status information (nullify) |
597: | of the selection process for the given combination by calling |
598: | JG_ZZ_VAT_REP_UTILITY.pre_process_update procedure. |
755:
756: IF l_global_variables_rec.retcode <> 2 THEN
757:
758: -- Bulk fetch data from TRL interface table.
759: -- And bulk insert into JG_ZZ_VAT_TRX_DETAILS.
760: fetch_tax_data(l_global_variables_rec,
761: g_conc_request_id);
762: ELSE
763: l_selection_status_flag := fnd_api.g_ret_sts_error;
860: | PROCEDURE |
861: | purge_tax_data |
862: | |
863: | DESCRIPTION |
864: | This procedure deletes the records from JG_ZZ_VAT_TRX_DETAILS |
865: | for a given reporting_status_id |
866: | |
867: | SCOPE - Public |
868: | |
891:
892: /*Set the return status to Success */
893: x_return_status := FND_API.G_RET_STS_SUCCESS;
894:
895: delete from JG_ZZ_VAT_TRX_DETAILS
896: where reporting_Status_id = p_reporting_status_id;
897:
898: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
899: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
929: | FUNCTION |
930: | PURGE_TAX_DATA |
931: | |
932: | DESCRIPTION |
933: | This function deletes the records from JG_ZZ_VAT_TRX_DETAILS, |
934: | for a given reporting_status_id |
935: | |
936: | SCOPE - Public |
937: | |
950: BEGIN
951:
952:
953: select count(*) into num_rows_deleted
954: from jg_zz_vat_trx_details
955: where reporting_status_id = p_reporting_status_id;
956:
957: PURGE_TAX_DATA(p_reporting_status_id, l_return_status);
958:
1674: | fetch_tax_data |
1675: | DESCRIPTION |
1676: | This procedure fetches tax data from TRL interface tables using bulk |
1677: | collect and calls insert_tax_data to perform a bulk insert into |
1678: | jg_zz_vat_trx_details_table. |
1679: | SCOPE - Private |
1680: | |
1681: | NOTES |
1682: | |
1955: AND DET.REP_CONTEXT_ID = CON.REP_CONTEXT_ID
1956: AND EXT.DETAIL_TAX_LINE_ID(+) = DET.DETAIL_TAX_LINE_ID
1957: AND ACT.DETAIL_TAX_LINE_ID(+) = DET.DETAIL_TAX_LINE_ID
1958: AND NOT EXISTS (SELECT 1
1959: FROM JG_ZZ_VAT_TRX_DETAILS JZVTD
1960: WHERE JZVTD.TRX_ID = DET.TRX_ID
1961: AND JZVTD.APPLICATION_ID = DET.APPLICATION_ID
1962: AND JZVTD.ENTITY_CODE = DET.ENTITY_CODE
1963: AND JZVTD.EVENT_CLASS_CODE = DET.EVENT_CLASS_CODE
2231: /*===========================================================================+
2232: | PROCEDURE |
2233: | insert_tax_data |
2234: | DESCRIPTION |
2235: | This procedure bulk inserts tax data into JG_ZZ_VAT_TRX_DETAILS table |
2236: | |
2237: | SCOPE - Private |
2238: | |
2239: | NOTES |
2282:
2283:
2284: FORALL i IN 1 .. l_count
2285:
2286: INSERT INTO JG_ZZ_VAT_TRX_DETAILS(
2287: VAT_TRANSACTION_ID ,
2288: REPORTING_STATUS_ID ,
2289: SELECTION_PROCESS_ID ,
2290: FINAL_REPORTING_ID ,
2518:
2519: -- BUG 9765740 Spanish Modelo 349 ESL EPL Changes
2520: INTRA_EU_TRX_TYPE_CODE)
2521: VALUES (
2522: JG_ZZ_VAT_TRX_DETAILS_S.NEXTVAL,
2523: DECODE( gt_extract_source_ledger(i), 'AR', g_rep_status_id_ar,
2524: 'AP', g_rep_status_id_ap,
2525: 'GL', g_rep_status_id_gl),
2526: g_selection_process_id,
3233: jgvt.reporting_status_id ,
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
3291: jgvt.reporting_status_id ,
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
3617: delete from jg_zz_vat_box_errors
3618: where vat_transaction_id = IdList(i) ;
3619:
3620: FORALL i in 1..l_trx_count
3621: delete from jg_zz_vat_trx_details
3622: where vat_transaction_id = IdList(i) ;
3623:
3624: END IF ; --IF l_trx_count > 0 THEN
3625:
3795: AND trunc(checks.cleared_date) < trunc(p_end_date)
3796: AND checks.status_lookup_code IN ('CLEARED', 'RECONCILED',
3797: 'CLEARED BUT UNACCOUNTED', 'RECONCILED UNACCOUNTED')
3798: AND NOT EXISTS ( SELECT 1
3799: FROM jg_zz_vat_trx_details vtd
3800: WHERE vtd.application_id = 200
3801: AND vtd.trx_id = inv.invoice_id
3802: AND vtd.entity_code = zdf.entity_code
3803: AND vtd.event_class_code = zdf.event_class_code
3840: AND amount_applied >= 0
3841: AND trunc(rpt.apply_date) <= trunc(p_end_date)
3842: AND rpt.apply_date < zdf.tax_invoice_date
3843: AND NOT EXISTS (SELECT 1
3844: FROM jg_zz_vat_trx_details
3845: WHERE application_id = 222
3846: AND trx_id = trx.customer_trx_id
3847: AND entity_code = zdf.entity_code
3848: AND event_class_code = zdf.event_class_code