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 3009: x_resource_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE, --File.Sql.39 bug 4440895

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

Line 3026: from pa_resource_list_members

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

Line 3038: pa_resource_list_members rlm

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

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

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

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

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

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

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

Line 3950: pa_resource_list_members prlm

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

Line 3968: ,pa_resource_list_members prlm

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