DBA Data[Home] [Help]

APPS.PA_PROGRESS_UTILS dependencies on PA_TASK_ASSIGNMENT_UTILS

Line 2795: l_return_value := pa_task_assignment_utils.check_asgmt_exists_in_task(p_object_version_id);

2791: l_return_value VARCHAR2(1) := 'Y';
2792:
2793: BEGIN
2794:
2795: l_return_value := pa_task_assignment_utils.check_asgmt_exists_in_task(p_object_version_id);
2796:
2797: RETURN (l_return_value);
2798: END check_assignment_exists;
2799:

Line 10261: p_task_assignment_tbl IN PA_TASK_ASSIGNMENT_UTILS.l_resource_rec_tbl_type,

10257:
10258: -- Procedure to be called when updating task assignments for progress related business rules check.
10259: PROCEDURE check_prog_for_update_asgmts
10260: (
10261: p_task_assignment_tbl IN PA_TASK_ASSIGNMENT_UTILS.l_resource_rec_tbl_type,
10262: x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10263: )
10264:
10265: IS

Line 10362: PA_TASK_ASSIGNMENT_UTILS.set_table_stats(PJI_UTILS.GET_PA_SCHEMA_NAME,'PA_RES_ASGMTS_TEMP', l_num_of_asgmts, l_num_blocks, 75);

10358:
10359: -- Manually seed the statistics for the temporary table.
10360: -- Need to do it before populating the table otherwise the table will be emptied.
10361: -- Bug 8261905 : Replaced 'PA' by PJI_UTILS.GET_PA_SCHEMA_NAME
10362: PA_TASK_ASSIGNMENT_UTILS.set_table_stats(PJI_UTILS.GET_PA_SCHEMA_NAME,'PA_RES_ASGMTS_TEMP', l_num_of_asgmts, l_num_blocks, 75);
10363:
10364: -- Populate the temporary table with the parameters passed in.
10365: DELETE pa_res_asgmts_temp;
10366: FORALL j IN 1..p_task_assignment_tbl.COUNT