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_FIN_PLAN_UTILS dependencies on PA_RESOURCE_LIST_MEMBERS

Line 243: p_resource_list_member_id IN pa_resource_list_members.RESOURCE_LIST_MEMBER_ID%TYPE Default Null

239:
240: FUNCTION Plan_Amount_Exists_Task_Res
241: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE ,
242: p_task_id IN pa_tasks.task_id%TYPE Default Null,
243: p_resource_list_member_id IN pa_resource_list_members.RESOURCE_LIST_MEMBER_ID%TYPE Default Null
244: ) RETURN VARCHAR2
245: IS
246: l_exists varchar2(1) := 'N';
247: begin

Line 3011: x_resource_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE, --File.Sql.39 bug 4440895

3007: PROCEDURE check_resource_gp_name_or_id
3008: (p_resource_id IN pa_resources.resource_id%TYPE,
3009: p_resource_name IN pa_resources.name%TYPE,
3010: p_check_id_flag IN VARCHAR2,
3011: x_resource_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE, --File.Sql.39 bug 4440895
3012: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3013: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3014: x_error_msg OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
3015: is

Line 3028: from pa_resource_list_members

3024: if p_check_id_flag = 'Y' then
3025: -- validate the id that was passed in
3026: select resource_list_member_id
3027: into x_resource_id
3028: from pa_resource_list_members
3029: where resource_list_member_id = p_resource_id;
3030: elsif p_check_id_flag = 'N' then
3031: -- just return the p_resource_id, since we're not validating
3032: x_resource_id := p_resource_id;

Line 3040: pa_resource_list_members rlm

3036: -- p_resource_id = null, so we need to find the id
3037: select rlm.resource_list_member_id
3038: into x_resource_id
3039: from pa_resources r,
3040: pa_resource_list_members rlm
3041: where r.name = p_resource_name and
3042: r.resource_id = rlm.resource_id and
3043: rlm.parent_member_id is null;
3044: else

Line 3895: ,x_resource_list_member_id OUT NOCOPY pa_resource_list_members.RESOURCE_LIST_MEMBER_ID%TYPE --File.Sql.39 bug 4440895

3891:
3892: /* This api should be used only for budgets created using self-service. */
3893: PROCEDURE Get_Uncat_Resource_List_Info
3894: (x_resource_list_id OUT NOCOPY pa_resource_lists.RESOURCE_LIST_ID%TYPE --File.Sql.39 bug 4440895
3895: ,x_resource_list_member_id OUT NOCOPY pa_resource_list_members.RESOURCE_LIST_MEMBER_ID%TYPE --File.Sql.39 bug 4440895
3896: ,x_track_as_labor_flag OUT NOCOPY pa_resource_list_members.TRACK_AS_LABOR_FLAG%TYPE --File.Sql.39 bug 4440895
3897: ,x_unit_of_measure OUT NOCOPY pa_resources.UNIT_OF_MEASURE%TYPE --File.Sql.39 bug 4440895
3898: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3899: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 3896: ,x_track_as_labor_flag OUT NOCOPY pa_resource_list_members.TRACK_AS_LABOR_FLAG%TYPE --File.Sql.39 bug 4440895

3892: /* This api should be used only for budgets created using self-service. */
3893: PROCEDURE Get_Uncat_Resource_List_Info
3894: (x_resource_list_id OUT NOCOPY pa_resource_lists.RESOURCE_LIST_ID%TYPE --File.Sql.39 bug 4440895
3895: ,x_resource_list_member_id OUT NOCOPY pa_resource_list_members.RESOURCE_LIST_MEMBER_ID%TYPE --File.Sql.39 bug 4440895
3896: ,x_track_as_labor_flag OUT NOCOPY pa_resource_list_members.TRACK_AS_LABOR_FLAG%TYPE --File.Sql.39 bug 4440895
3897: ,x_unit_of_measure OUT NOCOPY pa_resources.UNIT_OF_MEASURE%TYPE --File.Sql.39 bug 4440895
3898: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3899: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3900: ,x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895

Line 3942: -- select /+ Use_NL(prlm,pr) index(prlm, PA_RESOURCE_LIST_MEMBERS_N1) /

3938: * in rlm table itself. Track_as_labor_flag is obsolete for FP M.
3939: * This change would also improve the performance and RLM's N5 index would be
3940: * used.
3941: */
3942: -- select /*+ Use_NL(prlm,pr) index(prlm, PA_RESOURCE_LIST_MEMBERS_N1) */
3943: select pbg.resource_list_id,
3944: prlm.track_as_labor_flag,
3945: prlm.resource_list_member_id,
3946: prlm.unit_of_measure

Line 3952: pa_resource_list_members prlm

3948: x_track_as_labor_flag,
3949: x_resource_list_member_id,
3950: x_unit_of_measure
3951: from pa_resource_lists_all_bg pbg,
3952: pa_resource_list_members prlm
3953: where pbg.business_group_id = l_business_group_id and -- bug 2760675 pa_utils.business_group_id and
3954: pbg.uncategorized_flag = 'Y' and
3955: prlm.resource_list_id = pbg.resource_list_id and
3956: prlm.object_id = pbg.resource_list_id and

Line 3970: ,pa_resource_list_members prlm

3966: ,x_track_as_labor_flag
3967: ,x_resource_list_member_id
3968: ,x_unit_of_measure
3969: FROM pa_resource_lists_all_bg pbg
3970: ,pa_resource_list_members prlm
3971: ,pa_resources pr
3972: WHERE prlm.resource_list_id = pbg.resource_list_id
3973: AND pbg.resource_list_id = prlm.resource_list_id
3974: AND prlm.resource_id = pr.resource_id