APPS.JG_ZZ_VAT_SELECTION_PKG dependencies on JG_ZZ_VAT_TRX_GT

Line 3045: | intersecting data is populated into the jg_zz_vat_trx_gt table. |

3041: | control_intersecting_domains |
3042: | DESCRIPTION |
3043: | This procedure checks whether the current selection run results in |
3044: | intersecting data with a previous selection run(s). If exists, the |
3045: | intersecting data is populated into the jg_zz_vat_trx_gt table. |
3046: | If the intersecting data is a transaction that has been final reported |
3047: | we error the Selection process. |
3048: | For records that have not been final reported - we allow the subsequent|
3049: | run to replace the data. |

Line 3087: INSERT INTO JG_ZZ_VAT_TRX_GT

3083: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');
3084: END IF;
3085:
3086: -- populate temp table with the intersecting data.
3087: INSERT INTO JG_ZZ_VAT_TRX_GT
3088: (JG_INFO_N2,
3089: JG_INFO_N3,
3090: JG_INFO_V2,
3091: JG_INFO_V3,

Line 3142: SELECT count(*) INTO l_count FROM JG_ZZ_VAT_TRX_GT;

3138: AND DET.request_id = CON.request_id
3139: AND DET.rep_context_id = CON.rep_context_id
3140: );
3141:
3142: SELECT count(*) INTO l_count FROM JG_ZZ_VAT_TRX_GT;
3143:
3144: -- purge_report_finalrep
3145: IF l_count > 0 THEN
3146: purge_report_finalrep(

Line 3232: FROM jg_zz_vat_trx_gt

3228: || Fetches the number of records which are finally reported from GTT
3229: */
3230: CURSOR c_finalrep_exist IS
3231: SELECT count(1)
3232: FROM jg_zz_vat_trx_gt
3233: WHERE jg_info_n9 is not null ; /* final_reporting_id */
3234:
3235: /*
3236: || Fetches the invoice details which are finally reported

Line 3253: FROM jg_zz_vat_trx_gt

3249: jg_info_d1 , /* tax_invoice_date */
3250: jg_info_n7 , /* reporting_status_id */
3251: jg_info_n8 , /* vat_reporting_entity_id */
3252: jg_info_n9 /* final_reporting_id */
3253: FROM jg_zz_vat_trx_gt
3254: WHERE jg_info_n9 is not null; /* final_reporting_id */
3255:
3256:
3257: CURSOR c_get_finalrep_trx_for_upd IS

Line 3266: FROM jg_zz_vat_trx_gt p

3262: p.jg_info_n4 , /* trx_id */
3263: p.jg_info_n5 , /* trx_line_id */
3264: p.jg_info_n2 , /* internal_organization_id */
3265: p.jg_info_n6 /* tax_line_id */
3266: FROM jg_zz_vat_trx_gt p
3267: WHERE p.jg_info_n9 is not null /* final_reporting_id */
3268: AND p.jg_info_n6 not in ( select tax_line_id
3269: from zx_lines
3270: where cancel_flag = 'Y'

Line 3276: FROM jg_zz_vat_trx_gt

3272: and tax_line_id = p.jg_info_n6 );
3273:
3274: CURSOR c_vat_transaction_id IS
3275: SELECT jg_info_n1 /* vat_transaction_id */
3276: FROM jg_zz_vat_trx_gt
3277: WHERE jg_info_n9 is null; /* final_reporting_id */
3278:
3279: CURSOR c_get_outfile IS
3280: select 'jg_zz_vat' || to_char(sysdate,'ddmmyyyy_hhmiss') from dual ;

Line 3282: TYPE IdTab IS TABLE OF jg_zz_vat_trx_gt.jg_info_n1%TYPE;

3278:
3279: CURSOR c_get_outfile IS
3280: select 'jg_zz_vat' || to_char(sysdate,'ddmmyyyy_hhmiss') from dual ;
3281:
3282: TYPE IdTab IS TABLE OF jg_zz_vat_trx_gt.jg_info_n1%TYPE;
3283: IdList IdTab ;
3284:
3285: l_count NUMBER DEFAULT 0 ;
3286: lv_filename VARCHAR2(30);