DBA Data[Home] [Help]

APPS.GMS_AWARD_PVT dependencies on PA_PROJECT_CONTACTS

Line 4527: -- Updating pa_project_contacts for Award Project customer id for primary bill to and ship to

4523: END IF ;
4524:
4525:
4526: -- ===========================================================================================
4527: -- Updating pa_project_contacts for Award Project customer id for primary bill to and ship to
4528: -- ===========================================================================================
4529:
4530: IF (G_contact_rec.primary_flag = 'Y') THEN
4531: IF (G_contact_rec.usage_code = 'BILL_TO') or (G_contact_rec.usage_code = 'SHIP_TO' ) THEN

Line 4534: UPDATE pa_project_contacts

4530: IF (G_contact_rec.primary_flag = 'Y') THEN
4531: IF (G_contact_rec.usage_code = 'BILL_TO') or (G_contact_rec.usage_code = 'SHIP_TO' ) THEN
4532: IF l_award_project_id IS NOT NULL THEN
4533:
4534: UPDATE pa_project_contacts
4535: SET contact_id = DECODE(project_contact_type_code,
4536: 'BILLING', (G_contact_rec.Contact_id),
4537: 'SHIPPING',(G_contact_rec.Contact_id),
4538: contact_id ),