DBA Data[Home] [Help]

APPS.PA_PROJECTS_MAINT_PUB dependencies on PA_PROJECT_PARTIES

Line 3108: PA_PROJECT_PARTIES ppp

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

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

3142:
3143: l_role_class := NULL;
3144:
3145: if p_project_role_id is null or p_project_role_id = FND_API.G_MISS_NUM then
3146: l_project_role_id := pa_project_parties_utils.get_project_role_id(p_project_role_type,p_calling_module);
3147: else
3148: l_project_role_id := p_project_role_id;
3149: end if;
3150:

Line 3218: PA_PROJECT_PARTIES_PUB.DELETE_PROJECT_PARTY

3214: AND customer_id = l_customer_id;
3215: end if;
3216:
3217: -- Delete the existing role
3218: PA_PROJECT_PARTIES_PUB.DELETE_PROJECT_PARTY
3219: ( p_init_msg_list => p_init_msg_list
3220: ,p_validate_only => p_validate_only
3221: ,p_validation_level => p_validation_level
3222: ,p_debug_mode => p_debug_mode

Line 3250: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY

3246: end if;
3247: end if;
3248:
3249: -- Now create the org role
3250: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY
3251: ( p_validate_only => p_validate_only
3252: ,p_init_msg_list => p_init_msg_list
3253: ,p_validation_level => p_validation_level
3254: ,p_debug_mode => p_debug_mode