APPS.JG_ZZ_SUMMARY_AR_PKG dependencies on JG_ZZ_VAT_TRX_GT

Line 578: INSERT INTO JG_ZZ_VAT_TRX_GT(

574: -- | Description : This procedure inserts data into the Global Temp |
575: -- | table |
576: -- +======================================================================+
577: BEGIN
578: INSERT INTO JG_ZZ_VAT_TRX_GT(
579: jg_info_n1
580: , jg_info_n2
581: , jg_info_n3
582: , jg_info_n4

Line 1032: FROM jg_zz_vat_trx_gt

1028:
1029: CURSOR lcu_euar_data_count ( p_ex_vat_trx_type IN VARCHAR2)
1030: IS
1031: SELECT COUNT(1) C_NO_DATA_COUNT
1032: FROM jg_zz_vat_trx_gt
1033: WHERE jg_info_v14 <> P_EX_VAT_TRX_TYPE
1034: OR P_EX_VAT_TRX_TYPE IS NULL
1035: ;
1036:

Line 1460: UPDATE jg_zz_vat_trx_gt

1456:
1457: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'JGZZARVR - 3'); end if;
1458: FOR r_euar_data_count IN lcu_euar_data_count ( p_ex_vat_trx_type)
1459: LOOP
1460: UPDATE jg_zz_vat_trx_gt
1461: SET jg_info_n20 = r_euar_data_count.c_no_data_count;
1462: END LOOP;
1463: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'JGZZARVR - 4'); end if;
1464:

Line 1476: SELECT distinct JG_INFO_V40 INTO v_is_seq_updated FROM JG_ZZ_VAT_TRX_GT T1

1472: IF r_seq_impl.VAT_TRX_TYPE_CODE <> v_prev_vat_code or r_seq_impl.VAT_TRX_TYPE_CODE IS NULL THEN
1473: v_count := 0;
1474: END IF;
1475:
1476: SELECT distinct JG_INFO_V40 INTO v_is_seq_updated FROM JG_ZZ_VAT_TRX_GT T1
1477: WHERE T1.jg_info_n25 = r_seq_impl.trx_id
1478: AND T1.jg_info_v6 = r_seq_impl.VAT_TRX_TYPE_CODE;
1479:
1480:

Line 1485: UPDATE JG_ZZ_VAT_TRX_GT SET jg_info_n1 = v_count ,

1481: IF nvl(v_is_seq_updated,'N') <> 'Y' THEN
1482:
1483: v_count := v_count+1;
1484:
1485: UPDATE JG_ZZ_VAT_TRX_GT SET jg_info_n1 = v_count ,
1486: jg_info_v40 = 'Y'
1487: WHERE jg_info_n25 = r_seq_impl.trx_id
1488: AND jg_info_v6 = r_seq_impl.VAT_TRX_TYPE_CODE;
1489: