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 16: from pa_resource_list_members

12: CURSOR chk_if_exists IS
13: select 'Y'
14: from dual
15: where ((exists (select 'Y'
16: from pa_resource_list_members
17: where spread_curve_id = p_spread_curve_id))
18: OR (exists (select 'Y'
19: from pa_plan_res_defaults
20: where spread_curve_id = p_spread_curve_id)));

Line 46: from pa_resource_list_members

42: BOOLEAN
43: IS
44: CURSOR chk_nlr_resource IS
45: select 'Y'
46: from pa_resource_list_members
47: where non_labor_resource = p_non_labor_resource
48: and migration_code = 'N';
49:
50: l_exists VARCHAR2(1) := 'N';

Line 88: pa_resource_list_members rlm,

84: BEGIN
85: SELECT typ.res_type_code
86: INTO l_res_type_code
87: FROM pa_res_types_b typ,
88: pa_resource_list_members rlm,
89: pa_res_formats_b fmt
90: WHERE rlm.resource_list_member_id = p_resource_list_member_id
91: AND rlm.res_format_id = fmt.res_format_id
92: AND fmt.res_type_enabled_flag = 'Y'

Line 113: FROM pa_resource_list_members

109: 'BOM_EQUIPMENT',to_char(bom_resource_id),
110: 'INVENTORY_ITEM',to_char(inventory_item_id),
111: 'ITEM_CATEGORY',to_char(item_category_id)))
112: INTO l_resource_code
113: FROM pa_resource_list_members
114: WHERE resource_list_member_id = p_resource_list_member_id;
115:
116: Return l_resource_code;
117: ELSE

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

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

Line 149: FROM pa_resource_list_members

145: 'EXPENDITURE_CATEGORY',expenditure_category,
146: 'EVENT_TYPE',event_type,
147: 'REVENUE_CATEGORY',revenue_category)
148: INTO l_fin_category_code
149: FROM pa_resource_list_members
150: WHERE RESOURCE_LIST_MEMBER_ID = p_resource_list_member_id;
151:
152: Return l_fin_category_code;
153: ELSE

Line 183: FROM pa_resource_list_members

179: nvl(person_type_code,
180: nvl(to_char(incur_by_role_id),
181: nvl(incur_by_res_class_code, 'ERROR'))))))
182: INTO l_incur_by_res_code
183: FROM pa_resource_list_members
184: WHERE resource_list_member_id = p_resource_list_member_id;
185:
186: Return l_incur_by_res_code;
187: ELSE

Line 2603: pa_resource_list_members a,

2599: NULL ,
2600: NULL ,
2601: NULL
2602: FROM pa_res_member_id_temp b,
2603: pa_resource_list_members a,
2604: pa_res_formats_b fmt,
2605: pa_res_types_b typ
2606: WHERE a.resource_list_member_id = b.resource_list_member_id
2607: AND a.res_format_id = fmt.res_format_id

Line 4593: Pa_Resource_List_Members

4589: Incurred_By_Res_Flag,
4590: Incur_By_Res_Class_Code,
4591: Incur_By_Role_Id
4592: From
4593: Pa_Resource_List_Members
4594: Where
4595: Resource_List_Member_Id = P_Res_List_Member_Id;
4596:
4597: Res_List_Member_Rec c_Res_List%RowType;

Line 5594: Pa_Resource_List_Members

5590: Select
5591: Resource_List_Member_Id,
5592: Res_Format_Id
5593: From
5594: Pa_Resource_List_Members
5595: Where (P_Plan_Res_List_Mem_Id is Not Null and
5596: Resource_List_Member_Id = P_Plan_Res_List_Mem_Id) ;
5597:
5598: Cursor c_get_migration_code (P_Res_List_Mem_Id In Number) Is

Line 5600: From Pa_Resource_List_Members

5596: Resource_List_Member_Id = P_Plan_Res_List_Mem_Id) ;
5597:
5598: Cursor c_get_migration_code (P_Res_List_Mem_Id In Number) Is
5599: Select migration_code
5600: From Pa_Resource_List_Members
5601: Where Resource_List_Member_Id = P_Res_List_Mem_Id;
5602:
5603: Cursor c_Get_Fmt_Details (P_Res_Format_Id IN Number ) is
5604: Select

Line 5632: from pa_resource_list_members

5628: and Job_ID = p_Job_ID;
5629:
5630: CURSOR get_res_list_id(p_res_member_id in NUMBER) is
5631: select resource_list_id
5632: from pa_resource_list_members
5633: where resource_list_member_id = p_res_member_id;
5634:
5635: l_Resource_List_Member_Id Number := Null;
5636: l_Res_Format_Id Number := Null;

Line 6367: * pa_resource_list_members table.

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

Line 6485: ' FROM pa_resource_list_members ' ||

6481: * Constructing the Select Statement based on the values passed
6482: * as parameters to this procedure.
6483: ***********************************************************/
6484: l_stmt := 'SELECT resource_list_member_id '||
6485: ' FROM pa_resource_list_members ' ||
6486: ' WHERE resource_list_id = :resource_list_id' ||
6487: ' AND enabled_flag = ''Y'' ' ||
6488: ' AND res_format_id = :res_format_id';
6489:

Line 7239: DELETE FROM pa_resource_list_members

7235: LOOP
7236: FETCH get_resource_lists INTO l_res_list_id;
7237: EXIT WHEN get_resource_lists%NOTFOUND;
7238:
7239: DELETE FROM pa_resource_list_members
7240: WHERE resource_list_id = l_res_list_id
7241: AND object_type = 'PROJECT'
7242: AND object_id = p_project_id;
7243: END LOOP;

Line 7273: FROM pa_resource_list_members

7269:
7270: IF l_central_control = 'Y' THEN
7271: SELECT resource_list_member_id
7272: INTO l_resource_list_member_id
7273: FROM pa_resource_list_members
7274: WHERE resource_list_id = p_resource_list_id
7275: AND resource_class_flag = 'Y'
7276: AND resource_class_code = p_resource_class_code;
7277: ELSE

Line 7280: FROM pa_resource_list_members

7276: AND resource_class_code = p_resource_class_code;
7277: ELSE
7278: SELECT resource_list_member_id
7279: INTO l_resource_list_member_id
7280: FROM pa_resource_list_members
7281: WHERE resource_list_id = p_resource_list_id
7282: AND resource_class_flag = 'Y'
7283: AND resource_class_code = p_resource_class_code
7284: AND object_type = 'PROJECT'

Line 7306: FROM pa_resource_list_members

7302: return VARCHAR2 IS
7303:
7304: CURSOR get_res_details(p_resource_list_member_id IN NUMBER) IS
7305: SELECT resource_class_code, inventory_item_id, expenditure_type
7306: FROM pa_resource_list_members
7307: WHERE resource_list_member_id = p_resource_list_member_id;
7308:
7309: l_rate_based_flag VARCHAR2(1) := 'N';
7310: l_res_details get_res_details%ROWTYPE;

Line 7389: FROM pa_resource_list_members

7385: object_id, enabled_flag
7386: INTO l_res_format_id, l_res_list_id, l_expenditure_type,
7387: l_expenditure_category, l_revenue_category, l_event_type, l_object_type,
7388: l_object_id, l_enabled_flag
7389: FROM pa_resource_list_members
7390: WHERE resource_list_member_id = p_resource_list_member_id;
7391:
7392: l_allowed := 'Y';
7393: IF l_res_format_id in (29, 73) AND (l_enabled_flag = 'N') THEN

Line 7398: FROM pa_resource_list_members

7394:
7395: BEGIN
7396: SELECT 'N'
7397: INTO l_allowed
7398: FROM pa_resource_list_members
7399: WHERE resource_list_id = l_res_list_id
7400: AND res_format_id = l_res_format_id
7401: AND enabled_flag = 'Y'
7402: AND resource_list_member_id <> p_resource_list_member_id

Line 7476: FROM pa_resource_list_members

7472: BEGIN
7473: IF p_alias IS NOT NULL and p_resource_list_member_id IS NULL THEN
7474: SELECT resource_list_member_id
7475: INTO x_resource_list_member_id
7476: FROM pa_resource_list_members
7477: WHERE alias = p_alias
7478: AND resource_list_id = p_resource_list_id
7479: AND object_type = l_object_type
7480: AND object_id = l_object_id;

Line 7503: FROM pa_resource_list_members

7499: END IF;
7500:
7501: SELECT 'Y'
7502: INTO x_valid_member_flag
7503: FROM pa_resource_list_members
7504: WHERE resource_list_member_id = x_resource_list_member_id
7505: AND resource_list_id = p_resource_list_id
7506: AND object_type = l_object_type
7507: AND object_id = l_object_id;

Line 7529: FROM pa_resource_list_members

7525: IF p_chk_enabled = 'Y' THEN
7526: BEGIN
7527: SELECT 'Y'
7528: INTO x_valid_member_flag
7529: FROM pa_resource_list_members
7530: WHERE resource_list_member_id = x_resource_list_member_id
7531: AND enabled_flag = 'Y';
7532:
7533: EXCEPTION WHEN NO_DATA_FOUND THEN