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.PA_PROJECT_PUB dependencies on PA_PROJECT_CONTACTS

Line 19749: Delete pa_project_contacts

19745: where project_id=l_project_id
19746: and customer_id=p_project_in.customer_id;
19747:
19748: 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
19749: Delete pa_project_contacts
19750: where Project_Id=l_project_id
19751: and customer_id=p_project_in.customer_id
19752: and Project_Contact_Type_Code='BILLING';
19753:

Line 19757: Delete pa_project_contacts

19753:
19754: end if;
19755:
19756: 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
19757: Delete pa_project_contacts
19758: where Project_Id=l_project_id
19759: and customer_id=p_project_in.customer_id
19760: and Project_Contact_Type_Code='SHIPPING';
19761:

Line 20401: Delete pa_project_contacts

20397: where project_id=l_project_id
20398: and customer_id=p_project_in.customer_id;
20399:
20400: 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
20401: Delete pa_project_contacts
20402: where Project_Id=l_project_id
20403: and customer_id=p_project_in.customer_id
20404: and Project_Contact_Type_Code='BILLING';
20405:

Line 20409: Delete pa_project_contacts

20405:
20406: end if;
20407:
20408: 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
20409: Delete pa_project_contacts
20410: where Project_Id=l_project_id
20411: and customer_id=p_project_in.customer_id
20412: and Project_Contact_Type_Code='SHIPPING';
20413:

Line 20991: Delete pa_project_contacts

20987: where project_id=l_project_id
20988: and customer_id=p_customers_in(i).customer_id;
20989:
20990: 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
20991: Delete pa_project_contacts
20992: where Project_Id=l_project_id
20993: and customer_id=p_customers_in(i).customer_id
20994: and Project_Contact_Type_Code='BILLING';
20995:

Line 20999: Delete pa_project_contacts

20995:
20996: end if;
20997:
20998: 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
20999: Delete pa_project_contacts
21000: where Project_Id=l_project_id
21001: and customer_id=p_customers_in(i).customer_id
21002: and Project_Contact_Type_Code='SHIPPING';
21003:

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

21172:
21173: /* Added Call to pa_customer_info.Create_Customer_Contacts. We only will be adding new contacts.
21174: There are no attrbutes that can be updated in a contact. Hence, the call below will suffice.
21175: It will check if the customer already exists, then Insert into pa_project_customers will
21176: be skipped and data will only be inserted into pa_project_contacts */
21177:
21178: pa_customer_info.Create_Customer_Contacts
21179: ( X_Project_Id => l_project_id,
21180: X_Customer_Id => p_customers_in(i).customer_id,