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_PROJECTS_MAINT_PUB dependencies on PA_PROJECT_CUSTOMERS

Line 3107: FROM PA_PROJECT_CUSTOMERS ppc,

3103:
3104: CURSOR l_check_existing_customers_csr(c_party_id NUMBER)
3105: IS
3106: SELECT ppc.customer_id, ppp.record_version_number, ppc.project_party_id
3107: FROM PA_PROJECT_CUSTOMERS ppc,
3108: PA_PROJECT_PARTIES ppp
3109: WHERE ppc.project_id = p_project_id
3110: AND ppc.project_party_id = ppp.project_party_id
3111: AND ppp.resource_source_id = c_party_id

Line 3210: -- Update the project_party_id col in pa_project_customers to null

3206:
3207: if l_customer_id is not null then
3208:
3209: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
3210: -- Update the project_party_id col in pa_project_customers to null
3211: UPDATE pa_project_customers
3212: SET project_party_id = null
3213: WHERE project_id = p_project_id
3214: AND customer_id = l_customer_id;

Line 3211: UPDATE pa_project_customers

3207: if l_customer_id is not null then
3208:
3209: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
3210: -- Update the project_party_id col in pa_project_customers to null
3211: UPDATE pa_project_customers
3212: SET project_party_id = null
3213: WHERE project_id = p_project_id
3214: AND customer_id = l_customer_id;
3215: end if;

Line 3297: -- Update the project_party_id col in pa_project_customers to null

3293: -- Now update the customer record with the new project_party_id
3294: if l_role_class = 'CUSTOMER' then
3295: if l_customer_id is not null then
3296: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
3297: -- Update the project_party_id col in pa_project_customers to null
3298: UPDATE pa_project_customers
3299: SET project_party_id = l_new_project_party_id
3300: WHERE project_id = p_project_id
3301: AND customer_id = l_customer_id;

Line 3298: UPDATE pa_project_customers

3294: if l_role_class = 'CUSTOMER' then
3295: if l_customer_id is not null then
3296: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
3297: -- Update the project_party_id col in pa_project_customers to null
3298: UPDATE pa_project_customers
3299: SET project_party_id = l_new_project_party_id
3300: WHERE project_id = p_project_id
3301: AND customer_id = l_customer_id;
3302: end if;