APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_TASK_ASSIGNMENT_UTILS

Line 2487: PA_TASK_ASSIGNMENT_UTILS.set_table_stats('PA','PA_RES_MEMBERS_TEMP',100,10,100);

2483:
2484: -- Proper Fix for 4887312 *** RAMURTHY 03/01/06 02:33 pm ***
2485: -- It solves the issue above wrt commit by the FND_STATS.SET_TABLE_STATS call
2486:
2487: PA_TASK_ASSIGNMENT_UTILS.set_table_stats('PA','PA_RES_MEMBERS_TEMP',100,10,100);
2488: PA_TASK_ASSIGNMENT_UTILS.set_table_stats('PA','PA_RES_MEMBER_ID_TEMP',100,10,100);
2489:
2490: -- End Bug fix 4887312
2491:

Line 2488: PA_TASK_ASSIGNMENT_UTILS.set_table_stats('PA','PA_RES_MEMBER_ID_TEMP',100,10,100);

2484: -- Proper Fix for 4887312 *** RAMURTHY 03/01/06 02:33 pm ***
2485: -- It solves the issue above wrt commit by the FND_STATS.SET_TABLE_STATS call
2486:
2487: PA_TASK_ASSIGNMENT_UTILS.set_table_stats('PA','PA_RES_MEMBERS_TEMP',100,10,100);
2488: PA_TASK_ASSIGNMENT_UTILS.set_table_stats('PA','PA_RES_MEMBER_ID_TEMP',100,10,100);
2489:
2490: -- End Bug fix 4887312
2491:
2492: /***********************************************

Line 6362: * (2) It then calls the API PA_TASK_ASSIGNMENT_UTILS

6358: * resource list member, given a project ID
6359: * resource_format Id and a few attributes.
6360: * (1) It first Checks if the Mandatory values
6361: * are passed.
6362: * (2) It then calls the API PA_TASK_ASSIGNMENT_UTILS
6363: * Get_WP_Resource_List_Id --> which will return the
6364: * resource list ID.
6365: * (3) Then Based on the values passed Constructs a
6366: * Dynamic SQL and retrieves the values from

Line 6454: Pa_Task_Assignment_Utils.Get_WP_Resource_List_Id(p_project_id);

6450: * It would get the resource_list_ID associated to the
6451: * project and for which Workplan is enabled.
6452: ****************************************************/
6453: l_resource_list_id :=
6454: Pa_Task_Assignment_Utils.Get_WP_Resource_List_Id(p_project_id);
6455:
6456: IF l_resource_list_id IS NULL THEN
6457: l_resource_list_member_id := NULL;
6458: Return l_resource_list_member_id;

Line 7070: IF pa_task_assignment_utils.is_uncategorized_res_list(p_resource_list_id => p_resource_list_id) = 'Y'

7066: --for now. Later when Vijay passes the API remove this.
7067: /************************************************
7068: * For Assignments do the following
7069: * ***********************************************/
7070: IF pa_task_assignment_utils.is_uncategorized_res_list(p_resource_list_id => p_resource_list_id) = 'Y'
7071: THEN --Added IF-ELSE for bug 5962655
7072: x_asgmt_res_format_id := Null;
7073: x_req_res_format_id := Null;
7074: ELSE