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 1060: FROM jg_zz_vat_trx_gt

1056:
1057: CURSOR lcu_euar_data_count ( p_ex_vat_trx_type IN VARCHAR2)
1058: IS
1059: SELECT COUNT(1) C_NO_DATA_COUNT
1060: FROM jg_zz_vat_trx_gt
1061: WHERE jg_info_v14 <> P_EX_VAT_TRX_TYPE
1062: OR P_EX_VAT_TRX_TYPE IS NULL
1063: ;
1064:

Line 1517: UPDATE jg_zz_vat_trx_gt

1513:
1514: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'JGZZARVR - 3'); end if;
1515: FOR r_euar_data_count IN lcu_euar_data_count ( p_ex_vat_trx_type)
1516: LOOP
1517: UPDATE jg_zz_vat_trx_gt
1518: SET jg_info_n20 = r_euar_data_count.c_no_data_count;
1519: END LOOP;
1520: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'JGZZARVR - 4'); end if;
1521:

Line 1533: SELECT distinct JG_INFO_V40 INTO v_is_seq_updated FROM JG_ZZ_VAT_TRX_GT T1

1529: IF r_seq_impl.VAT_TRX_TYPE_CODE <> v_prev_vat_code or r_seq_impl.VAT_TRX_TYPE_CODE IS NULL THEN
1530: v_count := 0;
1531: END IF;
1532:
1533: SELECT distinct JG_INFO_V40 INTO v_is_seq_updated FROM JG_ZZ_VAT_TRX_GT T1
1534: WHERE T1.jg_info_n25 = r_seq_impl.trx_id
1535: AND T1.jg_info_v6 = r_seq_impl.VAT_TRX_TYPE_CODE;
1536:
1537:

Line 1542: UPDATE JG_ZZ_VAT_TRX_GT SET jg_info_n1 = v_count ,

1538: IF nvl(v_is_seq_updated,'N') <> 'Y' THEN
1539:
1540: v_count := v_count+1;
1541:
1542: UPDATE JG_ZZ_VAT_TRX_GT SET jg_info_n1 = v_count ,
1543: jg_info_v40 = 'Y'
1544: WHERE jg_info_n25 = r_seq_impl.trx_id
1545: AND jg_info_v6 = r_seq_impl.VAT_TRX_TYPE_CODE;
1546: