[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
1634: gtxn.award_number award_number,
1635: txn.transaction_source transaction_source,
1636: txn.batch_name batch_name,
1637: GTXN.txn_interface_id txn_interface_id
1638: FROM gms_transaction_interface_all Gtxn,
1639: pa_transaction_interface_all txn
1640: WHERE txn.txn_interface_id = X_txn_interface_id
1641: AND txn.txn_interface_id = Gtxn.txn_interface_id (+) ;
1642:
1806: x_inv_dist_id := txn_rec.invoice_distribution_id;
1807:
1808: -- ---------------------------------------------------------------
1809: -- Supplier invoice interface transactions do not have records in
1810: -- gms_transaction_interface_all table. So we need to have award
1811: -- from the ap distribution table.
1812: -- ----------------------------------------------------------------
1813: --
1814: -- BUG:4164822 PJ.M:B11:P11:QA:GMS IMPORTED TRANSACTIONS REJECTED DUE TO INVALID REASON
1941: END IF ;
1942:
1943: -- ================================================================
1944: -- Transaction Import should fail if there are missing record in
1945: -- gms_transaction_interface_all table.
1946: -- ================================================================
1947: -- Bug 3221039 :Commented the following code as the validation is shifted to
1948: -- newly introduced function set_award_info
1949:
2294: and rownum = 1;
2295: END IF ;
2296: --
2297: -- USER defined transaction source having gms supported transaction source
2298: -- get award id from gms_transaction_interface_all table record.
2299: --
2300: IF l_predefined_flag = 'N' and
2301: ( SUBSTR(l_transaction_source, 1,4) in ('GMSA', 'GMSE' ) )
2302: THEN
2301: ( SUBSTR(l_transaction_source, 1,4) in ('GMSA', 'GMSE' ) )
2302: THEN
2303: select awd.award_id
2304: into l_award_id
2305: from gms_transaction_interface_all gti,
2306: gms_awards_all awd
2307: where gti.txn_interface_id = p_tran_item_id
2308: and NVL(gti.award_id, awd.award_id) = awd.award_id
2309: and NVL(gti.award_number, awd.award_number ) = awd.award_number