APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_RESOURCE_LISTS_ALL_BG

Line 1890: l_resource_class_flag PA_RESOURCE_LISTS_ALL_BG.resource_class_flag%TYPE := 'Y'; --CBS

1886: * res_temp.rate_expenditure_type IS NULL
1887: **********************************************************/
1888: PROCEDURE Default_Rate_Expenditure_Type
1889: IS
1890: l_resource_class_flag PA_RESOURCE_LISTS_ALL_BG.resource_class_flag%TYPE := 'Y'; --CBS
1891: BEGIN
1892: /*************************************************
1893: * Update to use when the rate_expenditure_type is null
1894: * and bom_resource_id is not null. We use the below

Line 1941: from PA_RESOURCE_LISTS_ALL_BG prlab,

1937: * **************************************************/
1938: --CBS Changes Start here
1939: begin
1940: select nvl(prlab.resource_class_flag,'Y') into l_resource_class_flag
1941: from PA_RESOURCE_LISTS_ALL_BG prlab,
1942: PA_RESOURCE_LIST_MEMBERS prlm,
1943: pa_res_members_temp prmt
1944: where prlab.resource_list_id = prlm.resource_list_id and
1945: prlm.resource_list_member_id = prmt.resource_list_member_id and

Line 4986: l_resource_class_flag PA_RESOURCE_LISTS_ALL_BG.resource_class_flag%TYPE := 'Y';

4982: l_Return_Status Varchar2(1);
4983: l_Res_List_Member_Alias Varchar2(2000);
4984: l_Error_Msg_Data Varchar2(30);
4985: l_Error_Count Number;
4986: l_resource_class_flag PA_RESOURCE_LISTS_ALL_BG.resource_class_flag%TYPE := 'Y';
4987: BEGIN
4988:
4989: Pa_Planning_Resource_Utils.Get_Plan_Res_Combination(
4990: P_Resource_List_Member_Id => P_Resource_List_Member_Id,

Line 5009: PA_RESOURCE_LIST_MEMBERS prlm, PA_RESOURCE_LISTS_ALL_BG prlab

5005: Else
5006: /*CBS Changes Start*/
5007: begin
5008: select nvl(prlab.resource_class_flag,'Y') INTO l_resource_class_flag from
5009: PA_RESOURCE_LIST_MEMBERS prlm, PA_RESOURCE_LISTS_ALL_BG prlab
5010: where prlm.resource_list_member_id = P_Resource_List_Member_Id and
5011: prlm.resource_list_id = prlab.resource_list_id;
5012: EXCEPTION WHEN OTHERS then
5013: l_resource_class_flag := 'Y';

Line 5705: from pa_resource_lists_all_bg

5701: Res_Format_Id = P_Res_Format_Id;
5702:
5703: CURSOR get_job_group_id(p_res_list_id in NUMBER) is
5704: select job_group_id
5705: from pa_resource_lists_all_bg
5706: where resource_list_id = p_res_list_id;
5707:
5708: CURSOR chk_job_in_job_group(p_job_group_id IN NUMBER,
5709: p_Job_ID in NUMBER) IS

Line 5722: from pa_resource_lists_all_bg

5718: where resource_list_member_id = p_res_member_id;
5719: --Added for CBS::13535688
5720: CURSOR get_resource_class_flag(x_p_resource_list_id in NUMBER) is
5721: select NVL(resource_class_flag,'Y') resource_class_flag
5722: from pa_resource_lists_all_bg
5723: where resource_list_id = x_p_resource_list_id;
5724: --Added for CBS::13535688
5725:
5726:

Line 6627: FROM pa_resource_lists_all_bg

6623: *******************************************************/
6624: BEGIN
6625: SELECT control_flag
6626: INTO l_central_control
6627: FROM pa_resource_lists_all_bg
6628: WHERE resource_list_id = l_resource_list_id;
6629: EXCEPTION
6630: WHEN OTHERS THEN
6631: l_resource_list_member_id := NULL;

Line 7104: FROM pa_resource_lists_all_bg

7100: -- Added for bug 4025261
7101: BEGIN
7102: SELECT job_group_id
7103: INTO l_job_group_id
7104: FROM pa_resource_lists_all_bg
7105: WHERE resource_list_id = l_resource_list_id;
7106:
7107: SELECT 'Y'
7108: INTO l_valid_job

Line 7355: from pa_resource_lists_all_bg lst,

7351: lst.name,
7352: lst.description,
7353: l.language_code,
7354: userenv('LANG')
7355: from pa_resource_lists_all_bg lst,
7356: fnd_languages l
7357: where l.Installed_Flag in ('I', 'B')
7358: and lst.resource_list_id = p_resource_list_id
7359: and not exists (select 'Y'

Line 7380: l_res_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;

7376: p_project_id IN NUMBER,
7377: x_return_status OUT NOCOPY VARCHAR2,
7378: x_msg_count OUT NOCOPY NUMBER)
7379: IS
7380: l_res_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
7381:
7382: --For bug 4039707
7383: CURSOR get_resource_lists IS
7384: SELECT resource_list_id FROM pa_resource_lists_all_bg

Line 7384: SELECT resource_list_id FROM pa_resource_lists_all_bg

7380: l_res_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
7381:
7382: --For bug 4039707
7383: CURSOR get_resource_lists IS
7384: SELECT resource_list_id FROM pa_resource_lists_all_bg
7385: WHERE migration_code is not null;
7386:
7387: BEGIN
7388: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7425: FROM pa_resource_lists_all_bg

7421:
7422: BEGIN
7423: SELECT nvl(control_flag, 'N')
7424: INTO l_central_control
7425: FROM pa_resource_lists_all_bg
7426: WHERE resource_list_id = p_resource_list_id;
7427:
7428: IF l_central_control = 'Y' THEN
7429: SELECT resource_list_member_id

Line 7619: FROM pa_resource_lists_all_bg

7615: x_msg_count := 0;
7616:
7617: SELECT control_flag
7618: INTO l_central_control
7619: FROM pa_resource_lists_all_bg
7620: WHERE resource_list_id = p_resource_list_id;
7621:
7622: IF l_central_control = 'N' THEN
7623: l_object_type := 'PROJECT';