[Home] [Help]
779: ei.revenue_distributed_flag revenue_distributed_flag,
780: pt.txn_interface_id TXN_INTERFACE_ID,
781: pt.accrual_flag period_end_accrual_flag,
782: pt.system_linkage system_linkage
783: FROM gms_transaction_interface_all gt,
784: pa_transaction_interface_all pt,
785: pa_expenditure_items_all ei
786: WHERE ei.expenditure_item_id = x_ei_id
787: AND ei.expenditure_id = x_exp_id
937: END IF ;
938: -- end of bug : 3684711 Fix.
939:
940: IF NVL(x_purgeable,'N') = 'Y' THEN
941: DELETE from gms_transaction_interface_all
942: WHERE txn_interface_id = x_txn_xface_id ;
943: END IF ;
944:
945:
1541: -- -----------------------------------------------------------------
1542: -- BUG: 1361739 - Supplier Invoice Interface cause validation
1543: -- failed. ERROR - GMS_VALIDATION_FAILED.
1544: -- Supplier Invoice Interface doesn't put records into
1545: -- gms_transaction_interface_all, So award_id wasn't found and result
1546: -- in GMS_VALIDATION_FAILED.
1547: -- We should be doing this validations only if we have records in
1548: -- gms_transaction_interface_all table .
1549: -- ------------------------------------------------------------------
1544: -- Supplier Invoice Interface doesn't put records into
1545: -- gms_transaction_interface_all, So award_id wasn't found and result
1546: -- in GMS_VALIDATION_FAILED.
1547: -- We should be doing this validations only if we have records in
1548: -- gms_transaction_interface_all table .
1549: -- ------------------------------------------------------------------
1550: CURSOR C_BUDGET_CHECK ( x_project_id NUMBER, x_award_id NUMBER ) is
1551: SELECT budget_version_id
1552: from gms_budget_versions
1647: gtxn.award_number award_number,
1648: txn.transaction_source transaction_source,
1649: txn.batch_name batch_name,
1650: GTXN.txn_interface_id txn_interface_id
1651: FROM gms_transaction_interface_all Gtxn,
1652: pa_transaction_interface_all txn
1653: WHERE txn.txn_interface_id = X_txn_interface_id
1654: AND txn.txn_interface_id = Gtxn.txn_interface_id (+) ;
1655:
1819: x_inv_dist_id := txn_rec.invoice_distribution_id;
1820:
1821: -- ---------------------------------------------------------------
1822: -- Supplier invoice interface transactions do not have records in
1823: -- gms_transaction_interface_all table. So we need to have award
1824: -- from the ap distribution table.
1825: -- ----------------------------------------------------------------
1826: --
1827: -- BUG:4164822 PJ.M:B11:P11:QA:GMS IMPORTED TRANSACTIONS REJECTED DUE TO INVALID REASON
1954: END IF ;
1955:
1956: -- ================================================================
1957: -- Transaction Import should fail if there are missing record in
1958: -- gms_transaction_interface_all table.
1959: -- ================================================================
1960: -- Bug 3221039 :Commented the following code as the validation is shifted to
1961: -- newly introduced function set_award_info
1962:
2345:
2346: END IF ;
2347: --
2348: -- USER defined transaction source having gms supported transaction source
2349: -- get award id from gms_transaction_interface_all table record.
2350: --
2351: IF l_predefined_flag = 'N' and
2352: ( SUBSTR(l_transaction_source, 1,4) in ('GMSA', 'GMSE' ) )
2353: THEN
2352: ( SUBSTR(l_transaction_source, 1,4) in ('GMSA', 'GMSE' ) )
2353: THEN
2354: select awd.award_id
2355: into l_award_id
2356: from gms_transaction_interface_all gti,
2357: gms_awards_all awd
2358: where gti.txn_interface_id = p_tran_item_id
2359: and NVL(gti.award_id, awd.award_id) = awd.award_id
2360: and NVL(gti.award_number, awd.award_number ) = awd.award_number