DBA Data[Home] [Help]

APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_TASK_ASSIGNMENT_UTILS

Line 2528: PA_TASK_ASSIGNMENT_UTILS.set_table_stats(PJI_UTILS.GET_PA_SCHEMA_NAME,'PA_RES_MEMBERS_TEMP',100,10,100);

2524:
2525: -- Proper Fix for 4887312 *** RAMURTHY 03/01/06 02:33 pm ***
2526: -- It solves the issue above wrt commit by the FND_STATS.SET_TABLE_STATS call
2527: -- Bug 12533202: Replaced 'PA' by PJI_UTILS.GET_PA_SCHEMA_NAME
2528: PA_TASK_ASSIGNMENT_UTILS.set_table_stats(PJI_UTILS.GET_PA_SCHEMA_NAME,'PA_RES_MEMBERS_TEMP',100,10,100);
2529: PA_TASK_ASSIGNMENT_UTILS.set_table_stats(PJI_UTILS.GET_PA_SCHEMA_NAME,'PA_RES_MEMBER_ID_TEMP',100,10,100);
2530:
2531: -- End Bug fix 4887312
2532:

Line 2529: PA_TASK_ASSIGNMENT_UTILS.set_table_stats(PJI_UTILS.GET_PA_SCHEMA_NAME,'PA_RES_MEMBER_ID_TEMP',100,10,100);

2525: -- Proper Fix for 4887312 *** RAMURTHY 03/01/06 02:33 pm ***
2526: -- It solves the issue above wrt commit by the FND_STATS.SET_TABLE_STATS call
2527: -- Bug 12533202: Replaced 'PA' by PJI_UTILS.GET_PA_SCHEMA_NAME
2528: PA_TASK_ASSIGNMENT_UTILS.set_table_stats(PJI_UTILS.GET_PA_SCHEMA_NAME,'PA_RES_MEMBERS_TEMP',100,10,100);
2529: PA_TASK_ASSIGNMENT_UTILS.set_table_stats(PJI_UTILS.GET_PA_SCHEMA_NAME,'PA_RES_MEMBER_ID_TEMP',100,10,100);
2530:
2531: -- End Bug fix 4887312
2532:
2533: /***********************************************

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

6516: * resource list member, given a project ID
6517: * resource_format Id and a few attributes.
6518: * (1) It first Checks if the Mandatory values
6519: * are passed.
6520: * (2) It then calls the API PA_TASK_ASSIGNMENT_UTILS
6521: * Get_WP_Resource_List_Id --> which will return the
6522: * resource list ID.
6523: * (3) Then Based on the values passed Constructs a
6524: * Dynamic SQL and retrieves the values from

Line 6612: Pa_Task_Assignment_Utils.Get_WP_Resource_List_Id(p_project_id);

6608: * It would get the resource_list_ID associated to the
6609: * project and for which Workplan is enabled.
6610: ****************************************************/
6611: l_resource_list_id :=
6612: Pa_Task_Assignment_Utils.Get_WP_Resource_List_Id(p_project_id);
6613:
6614: IF l_resource_list_id IS NULL THEN
6615: l_resource_list_member_id := NULL;
6616: Return l_resource_list_member_id;

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

7224: --for now. Later when Vijay passes the API remove this.
7225: /************************************************
7226: * For Assignments do the following
7227: * ***********************************************/
7228: IF pa_task_assignment_utils.is_uncategorized_res_list(p_resource_list_id => p_resource_list_id) = 'Y'
7229: THEN --Added IF-ELSE for bug 5962655
7230: x_asgmt_res_format_id := Null;
7231: x_req_res_format_id := Null;
7232: ELSE