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 3103: FROM PA_PROJECT_CUSTOMERS ppc,

3099:
3100: CURSOR l_check_existing_customers_csr(c_party_id NUMBER)
3101: IS
3102: SELECT ppc.customer_id, ppp.record_version_number, ppc.project_party_id
3103: FROM PA_PROJECT_CUSTOMERS ppc,
3104: PA_PROJECT_PARTIES ppp
3105: WHERE ppc.project_id = p_project_id
3106: AND ppc.project_party_id = ppp.project_party_id
3107: AND ppp.resource_source_id = c_party_id

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

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

Line 3207: UPDATE pa_project_customers

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

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

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

Line 3294: UPDATE pa_project_customers

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