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 3006: (p_resource_id IN pa_resources.resource_id%TYPE,

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

Line 3007: p_resource_name IN pa_resources.name%TYPE,

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

Line 3037: from pa_resources r,

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

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

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

Line 3096: p_resource_name IN pa_resources.name%TYPE,

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

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

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

Line 3113: from pa_resources

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

Line 3124: from pa_resources

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

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

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

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

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

Line 3969: ,pa_resources pr

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