DBA Data[Home] [Help]

APPS.PA_PROJECT_PARTIES_PVT dependencies on PA_RESOURCE_UTILS

Line 118: pa_resource_utils.check_res_exists(

114: --MT: OrgRole changes
115: IF p_resource_type_id=101 THEN
116:
117: /* Added for bug 3234293 - We check if resource exists, call resource pull only if resource does not exist */
118: pa_resource_utils.check_res_exists(
119: P_PERSON_ID => p_resource_source_id,
120: X_VALID => l_is_valid,
121: X_RETURN_STATUS => l_return_status);
122:

Line 180: pa_resource_utils.check_res_exists(

176: l_source_type := 'HZ_PARTY';
177:
178: /* Added for bug 3234293 - We check if resource exists, call resource pull only if resource does not exist */
179:
180: pa_resource_utils.check_res_exists(
181: P_PARTY_ID => p_resource_source_id,
182: X_VALID => l_is_valid,
183: X_RETURN_STATUS => l_return_status);
184:

Line 223: l_past_resource := pa_resource_utils.is_past_resource(l_resource_id);

219: END IF;
220: --MT: End OrgRole changes
221:
222: if (x_return_status = FND_API.G_RET_STS_SUCCESS and p_scheduled_flag = 'Y') then
223: l_past_resource := pa_resource_utils.is_past_resource(l_resource_id);
224: IF(NVL(l_past_resource,'XXX') = 'Y') THEN
225: pa_resource_utils.CHECK_RES_BELONGS_EXPORG(p_resource_id => l_resource_id,
226: p_start_date_active => p_start_date_active,
227: p_end_date_active => p_end_date_active,

Line 225: pa_resource_utils.CHECK_RES_BELONGS_EXPORG(p_resource_id => l_resource_id,

221:
222: if (x_return_status = FND_API.G_RET_STS_SUCCESS and p_scheduled_flag = 'Y') then
223: l_past_resource := pa_resource_utils.is_past_resource(l_resource_id);
224: IF(NVL(l_past_resource,'XXX') = 'Y') THEN
225: pa_resource_utils.CHECK_RES_BELONGS_EXPORG(p_resource_id => l_resource_id,
226: p_start_date_active => p_start_date_active,
227: p_end_date_active => p_end_date_active,
228: x_valid => l_valid,
229: x_return_status => x_return_status,

Line 232: pa_resource_utils.CHECK_RES_BELONGS_EXPORG(p_resource_id => l_resource_id,

228: x_valid => l_valid,
229: x_return_status => x_return_status,
230: x_error_message_code => l_error_msg_code);
231: ELSE
232: pa_resource_utils.CHECK_RES_BELONGS_EXPORG(p_resource_id => l_resource_id,
233: x_valid => l_valid,
234: x_return_status => x_return_status,
235: x_error_message_code => l_error_msg_code);
236: END IF;

Line 254: l_date :=pa_resource_utils.Get_Resource_Effective_Date(p_resource_id => l_resource_id);

250: INTO l_date
251: FROM pa_resources_denorm
252: WHERE resource_id = l_resource_id ;
253: else
254: l_date :=pa_resource_utils.Get_Resource_Effective_Date(p_resource_id => l_resource_id);
255: end if;
256: l_job_schedulable := PA_HR_UPDATE_API.check_job_schedulable
257: ( p_person_id => p_resource_source_id
258: ,p_date => l_date );

Line 606: l_past_resource := pa_resource_utils.is_past_resource(l_resource_id);

602: if x_assignment_action = 'CREATE' then
603: -- call assignments api
604:
605: IF (p_scheduled_flag = 'Y') THEN
606: l_past_resource := pa_resource_utils.is_past_resource(l_resource_id);
607: IF(NVL(l_past_resource,'XXX') = 'Y') THEN
608: pa_resource_utils.CHECK_RES_BELONGS_EXPORG(p_resource_id => l_resource_id,
609: p_start_date_active => p_start_date_active,
610: p_end_date_active => p_end_date_active,

Line 608: pa_resource_utils.CHECK_RES_BELONGS_EXPORG(p_resource_id => l_resource_id,

604:
605: IF (p_scheduled_flag = 'Y') THEN
606: l_past_resource := pa_resource_utils.is_past_resource(l_resource_id);
607: IF(NVL(l_past_resource,'XXX') = 'Y') THEN
608: pa_resource_utils.CHECK_RES_BELONGS_EXPORG(p_resource_id => l_resource_id,
609: p_start_date_active => p_start_date_active,
610: p_end_date_active => p_end_date_active,
611: x_valid => l_valid,
612: x_return_status => x_return_status,

Line 615: pa_resource_utils.CHECK_RES_BELONGS_EXPORG(p_resource_id => p_resource_id,

611: x_valid => l_valid,
612: x_return_status => x_return_status,
613: x_error_message_code => l_error_msg_code);
614: ELSE
615: pa_resource_utils.CHECK_RES_BELONGS_EXPORG(p_resource_id => p_resource_id,
616: x_valid => l_valid,
617: x_return_status => x_return_status,
618: x_error_message_code => l_error_msg_code);
619: END IF;

Line 639: l_date :=pa_resource_utils.Get_Resource_Effective_Date(p_resource_id => p_resource_id);

635: INTO l_date
636: FROM pa_resources_denorm
637: WHERE resource_id = l_resource_id ;
638: else
639: l_date :=pa_resource_utils.Get_Resource_Effective_Date(p_resource_id => p_resource_id);
640: end if;
641: l_job_schedulable := PA_HR_UPDATE_API.check_job_schedulable
642: ( p_person_id => p_resource_source_id
643: ,p_date => l_date );