DBA Data[Home] [Help]

APPS.PA_PROJECTS_MAINT_PUB dependencies on PA_PROJECT_PARTIES

Line 3104: PA_PROJECT_PARTIES ppp

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
3108: AND ppp.resource_type_id = 112;

Line 3142: l_project_role_id := pa_project_parties_utils.get_project_role_id(p_project_role_type,p_calling_module);

3138:
3139: l_role_class := NULL;
3140:
3141: if p_project_role_id is null or p_project_role_id = FND_API.G_MISS_NUM then
3142: l_project_role_id := pa_project_parties_utils.get_project_role_id(p_project_role_type,p_calling_module);
3143: else
3144: l_project_role_id := p_project_role_id;
3145: end if;
3146:

Line 3214: PA_PROJECT_PARTIES_PUB.DELETE_PROJECT_PARTY

3210: AND customer_id = l_customer_id;
3211: end if;
3212:
3213: -- Delete the existing role
3214: PA_PROJECT_PARTIES_PUB.DELETE_PROJECT_PARTY
3215: ( p_init_msg_list => p_init_msg_list
3216: ,p_validate_only => p_validate_only
3217: ,p_validation_level => p_validation_level
3218: ,p_debug_mode => p_debug_mode

Line 3246: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY

3242: end if;
3243: end if;
3244:
3245: -- Now create the org role
3246: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY
3247: ( p_validate_only => p_validate_only
3248: ,p_init_msg_list => p_init_msg_list
3249: ,p_validation_level => p_validation_level
3250: ,p_debug_mode => p_debug_mode