DBA Data[Home] [Help]

APPS.PA_PROGRESS_UTILS dependencies on PA_TASK_ASSIGNMENT_UTILS

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

2766: l_return_value VARCHAR2(1) := 'Y';
2767:
2768: BEGIN
2769:
2770: l_return_value := pa_task_assignment_utils.check_asgmt_exists_in_task(p_object_version_id);
2771:
2772: RETURN (l_return_value);
2773: END check_assignment_exists;
2774:

Line 10187: p_task_assignment_tbl IN PA_TASK_ASSIGNMENT_UTILS.l_resource_rec_tbl_type,

10183:
10184: -- Procedure to be called when updating task assignments for progress related business rules check.
10185: PROCEDURE check_prog_for_update_asgmts
10186: (
10187: p_task_assignment_tbl IN PA_TASK_ASSIGNMENT_UTILS.l_resource_rec_tbl_type,
10188: x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10189: )
10190:
10191: IS

Line 10287: PA_TASK_ASSIGNMENT_UTILS.set_table_stats('PA','PA_RES_ASGMTS_TEMP', l_num_of_asgmts, l_num_blocks, 75);

10283: END LOOP;
10284:
10285: -- Manually seed the statistics for the temporary table.
10286: -- Need to do it before populating the table otherwise the table will be emptied.
10287: PA_TASK_ASSIGNMENT_UTILS.set_table_stats('PA','PA_RES_ASGMTS_TEMP', l_num_of_asgmts, l_num_blocks, 75);
10288:
10289: -- Populate the temporary table with the parameters passed in.
10290: DELETE pa_res_asgmts_temp;
10291: FORALL j IN 1..p_task_assignment_tbl.COUNT