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.

[Home] [Help]

APPS.PA_PROJECT_PUB dependencies on PA_PROJECT_CONTACTS

Line 19351: Delete pa_project_contacts

19347: where project_id=l_project_id
19348: and customer_id=p_project_in.customer_id;
19349:
19350: If p_project_in.bill_to_customer_id is not null and p_project_in.bill_to_customer_id <> cur_customer_rec.bill_to_customer_id THEN
19351: Delete pa_project_contacts
19352: where Project_Id=l_project_id
19353: and customer_id=p_project_in.customer_id
19354: and Project_Contact_Type_Code='BILLING';
19355:

Line 19359: Delete pa_project_contacts

19355:
19356: end if;
19357:
19358: If p_project_in.ship_to_customer_id is not null and p_project_in.ship_to_customer_id <> cur_customer_rec.bill_to_customer_id THEN
19359: Delete pa_project_contacts
19360: where Project_Id=l_project_id
19361: and customer_id=p_project_in.customer_id
19362: and Project_Contact_Type_Code='SHIPPING';
19363:

Line 20000: Delete pa_project_contacts

19996: where project_id=l_project_id
19997: and customer_id=p_project_in.customer_id;
19998:
19999: If p_project_in.bill_to_customer_id is not null and p_project_in.bill_to_customer_id <> cur_customer_rec.bill_to_customer_id THEN
20000: Delete pa_project_contacts
20001: where Project_Id=l_project_id
20002: and customer_id=p_project_in.customer_id
20003: and Project_Contact_Type_Code='BILLING';
20004:

Line 20008: Delete pa_project_contacts

20004:
20005: end if;
20006:
20007: If p_project_in.ship_to_customer_id is not null and p_project_in.ship_to_customer_id <> cur_customer_rec.bill_to_customer_id THEN
20008: Delete pa_project_contacts
20009: where Project_Id=l_project_id
20010: and customer_id=p_project_in.customer_id
20011: and Project_Contact_Type_Code='SHIPPING';
20012:

Line 20590: Delete pa_project_contacts

20586: where project_id=l_project_id
20587: and customer_id=p_customers_in(i).customer_id;
20588:
20589: If p_customers_in(i).bill_to_customer_id is not null and p_customers_in(i).bill_to_customer_id <> cur_customer_rec.bill_to_customer_id THEN
20590: Delete pa_project_contacts
20591: where Project_Id=l_project_id
20592: and customer_id=p_customers_in(i).customer_id
20593: and Project_Contact_Type_Code='BILLING';
20594:

Line 20598: Delete pa_project_contacts

20594:
20595: end if;
20596:
20597: If p_customers_in(i).ship_to_customer_id is not null and p_customers_in(i).ship_to_customer_id <> cur_customer_rec.bill_to_customer_id THEN
20598: Delete pa_project_contacts
20599: where Project_Id=l_project_id
20600: and customer_id=p_customers_in(i).customer_id
20601: and Project_Contact_Type_Code='SHIPPING';
20602:

Line 20775: be skipped and data will only be inserted into pa_project_contacts */

20771:
20772: /* Added Call to pa_customer_info.Create_Customer_Contacts. We only will be adding new contacts.
20773: There are no attrbutes that can be updated in a contact. Hence, the call below will suffice.
20774: It will check if the customer already exists, then Insert into pa_project_customers will
20775: be skipped and data will only be inserted into pa_project_contacts */
20776:
20777: pa_customer_info.Create_Customer_Contacts
20778: ( X_Project_Id => l_project_id,
20779: X_Customer_Id => p_customers_in(i).customer_id,