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_RESOURCES

Line 3008: (p_resource_id IN pa_resources.resource_id%TYPE,

3004: Basically to note any calls made to this procedure. Eventually we shall be
3005: commenting out this procedure because of its nonusage. */
3006: -- returns RESOURCE_LIST_MEMBER_ID of resource group
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

Line 3009: p_resource_name IN pa_resources.name%TYPE,

3005: commenting out this procedure because of its nonusage. */
3006: -- returns RESOURCE_LIST_MEMBER_ID of resource group
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

Line 3039: from pa_resources r,

3035: if p_resource_name is not null then
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;

Line 3097: (p_resource_id IN pa_resources.resource_id%TYPE,

3093: RAISE;
3094: END check_resource_gp_name_or_id;
3095:
3096: PROCEDURE check_resource_name_or_id
3097: (p_resource_id IN pa_resources.resource_id%TYPE,
3098: p_resource_name IN pa_resources.name%TYPE,
3099: p_check_id_flag IN VARCHAR2,
3100: x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE, --File.Sql.39 bug 4440895
3101: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 3098: p_resource_name IN pa_resources.name%TYPE,

3094: END check_resource_gp_name_or_id;
3095:
3096: PROCEDURE check_resource_name_or_id
3097: (p_resource_id IN pa_resources.resource_id%TYPE,
3098: p_resource_name IN pa_resources.name%TYPE,
3099: p_check_id_flag IN VARCHAR2,
3100: x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE, --File.Sql.39 bug 4440895
3101: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3102: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 3100: x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE, --File.Sql.39 bug 4440895

3096: PROCEDURE check_resource_name_or_id
3097: (p_resource_id IN pa_resources.resource_id%TYPE,
3098: p_resource_name IN pa_resources.name%TYPE,
3099: p_check_id_flag IN VARCHAR2,
3100: x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE, --File.Sql.39 bug 4440895
3101: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3102: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3103: x_error_msg OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
3104: is

Line 3115: from pa_resources

3111: if p_check_id_flag = 'Y' then
3112: -- validate the id that was passed in
3113: select resource_id
3114: into x_resource_id
3115: from pa_resources
3116: where resource_id = p_resource_id;
3117: elsif p_check_id_flag = 'N' then
3118: -- just return the p_resource_id, since we're not validating
3119: x_resource_id := p_resource_id;

Line 3126: from pa_resources

3122: if p_resource_name is not null then
3123: -- p_resource_id = null, so we need to find the id
3124: select resource_id
3125: into x_resource_id
3126: from pa_resources
3127: where name = p_resource_name;
3128: else
3129: x_resource_id := null;
3130: end if;

Line 3897: ,x_unit_of_measure OUT NOCOPY pa_resources.UNIT_OF_MEASURE%TYPE --File.Sql.39 bug 4440895

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
3901:

Line 3935: /* Bug 4052562 - Pa_resources is obsolete for FP M. Also, there would

3931: * The final fix is pending discussion w/architects. This fix was made
3932: * so Q/A can continue
3933: */
3934:
3935: /* Bug 4052562 - Pa_resources is obsolete for FP M. Also, there would
3936: * be 4 default rlms for every resource list. As such, in FP M, the
3937: * uncat rlm would have unit of measure as DOLLARS and this is available
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

Line 3971: ,pa_resources pr

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
3975: AND pbg.uncategorized_flag = 'Y'