APPS.JG_ZZ_VAT_SELECTION_PKG dependencies on JG_ZZ_VAT_TRX_GT

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

3157: | control_intersecting_domains |
3158: | DESCRIPTION |
3159: | This procedure checks whether the current selection run results in |
3160: | intersecting data with a previous selection run(s). If exists, the |
3161: | intersecting data is populated into the jg_zz_vat_trx_gt table. |
3162: | If the intersecting data is a transaction that has been final reported |
3163: | we error the Selection process. |
3164: | For records that have not been final reported - we allow the subsequent|
3165: | run to replace the data. |

Line 3208: INSERT INTO JG_ZZ_VAT_TRX_GT

3204: -- populate temp table with the intersecting data.
3205: IF p_global_variables_rec.tax_invoice_date_high > p_global_variables_rec.LAST_REP_PERIOD_END_DATE THEN
3206:
3207: -- Period above than last reported period.
3208: INSERT INTO JG_ZZ_VAT_TRX_GT
3209: (JG_INFO_N2,
3210: JG_INFO_N3,
3211: JG_INFO_V2,
3212: JG_INFO_V3,

Line 3266: INSERT INTO JG_ZZ_VAT_TRX_GT

3262: AND DET.rep_context_id = CON.rep_context_id
3263: );
3264: ELSE
3265: -- Period before or equal to last reported period.
3266: INSERT INTO JG_ZZ_VAT_TRX_GT
3267: (JG_INFO_N2,
3268: JG_INFO_N3,
3269: JG_INFO_V2,
3270: JG_INFO_V3,

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

3319: );
3320:
3321: END IF;
3322:
3323: SELECT count(*) INTO l_count FROM JG_ZZ_VAT_TRX_GT;
3324:
3325: -- purge_report_finalrep
3326: IF l_count > 0 THEN
3327: purge_report_finalrep(

Line 3413: FROM jg_zz_vat_trx_gt

3409: || Fetches the number of records which are finally reported from GTT
3410: */
3411: CURSOR c_finalrep_exist IS
3412: SELECT count(1)
3413: FROM jg_zz_vat_trx_gt
3414: WHERE jg_info_n9 is not null ; /* final_reporting_id */
3415:
3416: /*
3417: || Fetches the invoice details which are finally reported

Line 3434: FROM jg_zz_vat_trx_gt

3430: jg_info_d1 , /* tax_invoice_date */
3431: jg_info_n7 , /* reporting_status_id */
3432: jg_info_n8 , /* vat_reporting_entity_id */
3433: jg_info_n9 /* final_reporting_id */
3434: FROM jg_zz_vat_trx_gt
3435: WHERE jg_info_n9 is not null; /* final_reporting_id */
3436:
3437:
3438: CURSOR c_get_finalrep_trx_for_upd IS

Line 3447: FROM jg_zz_vat_trx_gt p

3443: p.jg_info_n4 , /* trx_id */
3444: p.jg_info_n5 , /* trx_line_id */
3445: p.jg_info_n2 , /* internal_organization_id */
3446: p.jg_info_n6 /* tax_line_id */
3447: FROM jg_zz_vat_trx_gt p
3448: WHERE p.jg_info_n9 is not null /* final_reporting_id */
3449: AND p.jg_info_n6 not in ( select tax_line_id
3450: from zx_lines
3451: where cancel_flag = 'Y'

Line 3457: FROM jg_zz_vat_trx_gt

3453: and tax_line_id = p.jg_info_n6 );
3454:
3455: CURSOR c_vat_transaction_id IS
3456: SELECT jg_info_n1 /* vat_transaction_id */
3457: FROM jg_zz_vat_trx_gt
3458: WHERE jg_info_n9 is null; /* final_reporting_id */
3459:
3460: CURSOR c_get_outfile IS
3461: select 'jg_zz_vat' || to_char(sysdate,'ddmmyyyy_hhmiss') from dual ;

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

3459:
3460: CURSOR c_get_outfile IS
3461: select 'jg_zz_vat' || to_char(sysdate,'ddmmyyyy_hhmiss') from dual ;
3462:
3463: TYPE IdTab IS TABLE OF jg_zz_vat_trx_gt.jg_info_n1%TYPE;
3464: IdList IdTab ;
3465:
3466: l_count NUMBER DEFAULT 0 ;
3467: lv_filename VARCHAR2(30);