eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMS_AWARD_PVT dependencies on PA_PROJECT_CUSTOMERS

Line 2074: -- column of the pa_project_customers.

2070: --**************************************************************
2071: -- Bug FIx 3076921
2072: -- For the PA.K rollup patch certification we started making use of the customer account relationship feature.
2073: -- From now on we will store the bill_to_customer_id i.e LOC customer id of an award in the bill_to_customer_id
2074: -- column of the pa_project_customers.
2075: -- We will not update teh record with the latest, by overriding the existing customer_id.
2076: -- For this the columns bill_to_customer_id and ship_to_customer_id need to be defined as overridable.
2077: -- This change can be done in the implementaitons form, but that forces us to come up with a data fix
2078: -- for the existing implementations. So adding that check before creating an award. Thus we dont need any

Line 2314: update PA_PROJECT_Customers

2310: --
2311: -- Update project customers.
2312: --
2313:
2314: update PA_PROJECT_Customers
2315: set BILL_TO_ADDRESS_ID = NVL(g_award_rec.bill_To_Address_Id, bill_TO_ADDRESS_ID ),
2316: SHIP_TO_ADDRESS_ID = NVL(g_award_rec.Ship_To_Address_Id, SHIP_TO_ADDRESS_ID )
2317: ,LAST_UPDATE_DATE = SYSDATE
2318: ,LAST_UPDATED_BY = fnd_global.user_id