eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_RESOURCE_LIST_MEMBERS

Line 20: from pa_resource_list_members

16: CURSOR chk_if_exists IS
17: select 'Y'
18: from dual
19: where ((exists (select 'Y'
20: from pa_resource_list_members
21: where spread_curve_id = p_spread_curve_id))
22: OR (exists (select 'Y'
23: from pa_plan_res_defaults
24: where spread_curve_id = p_spread_curve_id)));

Line 50: from pa_resource_list_members

46: BOOLEAN
47: IS
48: CURSOR chk_nlr_resource IS
49: select 'Y'
50: from pa_resource_list_members
51: where non_labor_resource = p_non_labor_resource
52: and migration_code = 'N';
53:
54: l_exists VARCHAR2(1) := 'N';

Line 92: pa_resource_list_members rlm,

88: BEGIN
89: SELECT typ.res_type_code
90: INTO l_res_type_code
91: FROM pa_res_types_b typ,
92: pa_resource_list_members rlm,
93: pa_res_formats_b fmt
94: WHERE rlm.resource_list_member_id = p_resource_list_member_id
95: AND rlm.res_format_id = fmt.res_format_id
96: AND fmt.res_type_enabled_flag = 'Y'

Line 117: FROM pa_resource_list_members

113: 'BOM_EQUIPMENT',to_char(bom_resource_id),
114: 'INVENTORY_ITEM',to_char(inventory_item_id),
115: 'ITEM_CATEGORY',to_char(item_category_id)))
116: INTO l_resource_code
117: FROM pa_resource_list_members
118: WHERE resource_list_member_id = p_resource_list_member_id;
119:
120: Return l_resource_code;
121: ELSE

Line 144: l_fin_category_code pa_resource_list_members.FC_RES_TYPE_CODE%TYPE := NULL;

140: *******************************************************************/
141: FUNCTION Get_member_Fin_Cat_Code(p_resource_list_member_id IN NUMBER) return
142: VARCHAR2
143: IS
144: l_fin_category_code pa_resource_list_members.FC_RES_TYPE_CODE%TYPE := NULL;
145: BEGIN
146: IF p_resource_list_member_id IS NOT NULL THEN
147: SELECT DECODE(fc_res_type_code,
148: 'EXPENDITURE_TYPE',expenditure_type,

Line 153: FROM pa_resource_list_members

149: 'EXPENDITURE_CATEGORY',expenditure_category,
150: 'EVENT_TYPE',event_type,
151: 'REVENUE_CATEGORY',revenue_category)
152: INTO l_fin_category_code
153: FROM pa_resource_list_members
154: WHERE RESOURCE_LIST_MEMBER_ID = p_resource_list_member_id;
155:
156: Return l_fin_category_code;
157: ELSE

Line 187: FROM pa_resource_list_members

183: nvl(person_type_code,
184: nvl(to_char(incur_by_role_id),
185: nvl(incur_by_res_class_code, 'ERROR'))))))
186: INTO l_incur_by_res_code
187: FROM pa_resource_list_members
188: WHERE resource_list_member_id = p_resource_list_member_id;
189:
190: Return l_incur_by_res_code;
191: ELSE

Line 1942: PA_RESOURCE_LIST_MEMBERS prlm,

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
1946: rownum = 1;

Line 1954: from PA_RESOURCE_LIST_MEMBERS where

1950: end;
1951: if l_resource_class_flag = 'N' then
1952: UPDATE pa_res_members_temp res_temp
1953: SET res_temp.rate_expenditure_type = (select expenditure_type_2
1954: from PA_RESOURCE_LIST_MEMBERS where
1955: resource_list_member_id = res_temp.resource_list_member_id)
1956: WHERE (res_temp.rate_expenditure_type IS NULL OR
1957: (res_temp.rate_expenditure_type = 'NO Val'));
1958: else

Line 2644: pa_resource_list_members a,

2640: NULL ,
2641: NULL ,
2642: NULL
2643: FROM pa_res_member_id_temp b,
2644: pa_resource_list_members a,
2645: pa_res_formats_b fmt,
2646: pa_res_types_b typ
2647: WHERE a.resource_list_member_id = b.resource_list_member_id
2648: AND a.res_format_id = fmt.res_format_id

Line 4634: Pa_Resource_List_Members

4630: Incurred_By_Res_Flag,
4631: Incur_By_Res_Class_Code,
4632: Incur_By_Role_Id
4633: From
4634: Pa_Resource_List_Members
4635: Where
4636: Resource_List_Member_Id = P_Res_List_Member_Id;
4637:
4638: Res_List_Member_Rec c_Res_List%RowType;

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 5679: Pa_Resource_List_Members

5675: Select
5676: Resource_List_Member_Id,
5677: Res_Format_Id
5678: From
5679: Pa_Resource_List_Members
5680: Where (P_Plan_Res_List_Mem_Id is Not Null and
5681: Resource_List_Member_Id = P_Plan_Res_List_Mem_Id) ;
5682:
5683: Cursor c_get_migration_code (P_Res_List_Mem_Id In Number) Is

Line 5685: From Pa_Resource_List_Members

5681: Resource_List_Member_Id = P_Plan_Res_List_Mem_Id) ;
5682:
5683: Cursor c_get_migration_code (P_Res_List_Mem_Id In Number) Is
5684: Select migration_code
5685: From Pa_Resource_List_Members
5686: Where Resource_List_Member_Id = P_Res_List_Mem_Id;
5687:
5688: Cursor c_Get_Fmt_Details (P_Res_Format_Id IN Number ) is
5689: Select

Line 5717: from pa_resource_list_members

5713: and Job_ID = p_Job_ID;
5714:
5715: CURSOR get_res_list_id(p_res_member_id in NUMBER) is
5716: select resource_list_id
5717: from pa_resource_list_members
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

Line 6525: * pa_resource_list_members table.

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
6525: * pa_resource_list_members table.
6526: * (4) If no rows are returned then does step 5,6
6527: * (5) Checks if the resource list is project specific
6528: * If it is then creates a new resource_list_member
6529: * Call to pa_planning_resource_pvt.create_planning_resource

Line 6643: ' FROM pa_resource_list_members ' ||

6639: * Constructing the Select Statement based on the values passed
6640: * as parameters to this procedure.
6641: ***********************************************************/
6642: l_stmt := 'SELECT resource_list_member_id '||
6643: ' FROM pa_resource_list_members ' ||
6644: ' WHERE resource_list_id = :resource_list_id' ||
6645: ' AND enabled_flag = ''Y'' ' ||
6646: ' AND res_format_id = :res_format_id';
6647:

Line 7397: DELETE FROM pa_resource_list_members

7393: LOOP
7394: FETCH get_resource_lists INTO l_res_list_id;
7395: EXIT WHEN get_resource_lists%NOTFOUND;
7396:
7397: DELETE FROM pa_resource_list_members
7398: WHERE resource_list_id = l_res_list_id
7399: AND object_type = 'PROJECT'
7400: AND object_id = p_project_id;
7401: END LOOP;

Line 7431: FROM pa_resource_list_members

7427:
7428: IF l_central_control = 'Y' THEN
7429: SELECT resource_list_member_id
7430: INTO l_resource_list_member_id
7431: FROM pa_resource_list_members
7432: WHERE resource_list_id = p_resource_list_id
7433: AND resource_class_flag = 'Y'
7434: AND resource_class_code = p_resource_class_code;
7435: ELSE

Line 7438: FROM pa_resource_list_members

7434: AND resource_class_code = p_resource_class_code;
7435: ELSE
7436: SELECT resource_list_member_id
7437: INTO l_resource_list_member_id
7438: FROM pa_resource_list_members
7439: WHERE resource_list_id = p_resource_list_id
7440: AND resource_class_flag = 'Y'
7441: AND resource_class_code = p_resource_class_code
7442: AND object_type = 'PROJECT'

Line 7464: FROM pa_resource_list_members

7460: return VARCHAR2 IS
7461:
7462: CURSOR get_res_details(p_resource_list_member_id IN NUMBER) IS
7463: SELECT resource_class_code, inventory_item_id, expenditure_type
7464: FROM pa_resource_list_members
7465: WHERE resource_list_member_id = p_resource_list_member_id;
7466:
7467: l_rate_based_flag VARCHAR2(1) := 'N';
7468: l_res_details get_res_details%ROWTYPE;

Line 7547: FROM pa_resource_list_members

7543: object_id, enabled_flag
7544: INTO l_res_format_id, l_res_list_id, l_expenditure_type,
7545: l_expenditure_category, l_revenue_category, l_event_type, l_object_type,
7546: l_object_id, l_enabled_flag
7547: FROM pa_resource_list_members
7548: WHERE resource_list_member_id = p_resource_list_member_id;
7549:
7550: l_allowed := 'Y';
7551: IF l_res_format_id in (29, 73) AND (l_enabled_flag = 'N') THEN

Line 7556: FROM pa_resource_list_members

7552:
7553: BEGIN
7554: SELECT 'N'
7555: INTO l_allowed
7556: FROM pa_resource_list_members
7557: WHERE resource_list_id = l_res_list_id
7558: AND res_format_id = l_res_format_id
7559: AND enabled_flag = 'Y'
7560: AND resource_list_member_id <> p_resource_list_member_id

Line 7634: FROM pa_resource_list_members

7630: BEGIN
7631: IF p_alias IS NOT NULL and p_resource_list_member_id IS NULL THEN
7632: SELECT resource_list_member_id
7633: INTO x_resource_list_member_id
7634: FROM pa_resource_list_members
7635: WHERE alias = p_alias
7636: AND resource_list_id = p_resource_list_id
7637: AND object_type = l_object_type
7638: AND object_id = l_object_id;

Line 7661: FROM pa_resource_list_members

7657: END IF;
7658:
7659: SELECT 'Y'
7660: INTO x_valid_member_flag
7661: FROM pa_resource_list_members
7662: WHERE resource_list_member_id = x_resource_list_member_id
7663: AND resource_list_id = p_resource_list_id
7664: AND object_type = l_object_type
7665: AND object_id = l_object_id;

Line 7687: FROM pa_resource_list_members

7683: IF p_chk_enabled = 'Y' THEN
7684: BEGIN
7685: SELECT 'Y'
7686: INTO x_valid_member_flag
7687: FROM pa_resource_list_members
7688: WHERE resource_list_member_id = x_resource_list_member_id
7689: AND enabled_flag = 'Y';
7690:
7691: EXCEPTION WHEN NO_DATA_FOUND THEN