DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_UTILS dependencies on PA_RESOURCES

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

318: a exception unconditionally for tracking/debuging purposes at the moment.
319: Basically to note any calls made to this procedure. Eventually we shall be
320: commenting out this procedure because of its nonusage. */
321: PROCEDURE check_resource_gp_name_or_id
322: (p_resource_id IN pa_resources.resource_id%TYPE,
323: p_resource_name IN pa_resources.name%TYPE,
324: p_check_id_flag IN VARCHAR2,
325: x_resource_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE, --File.Sql.39 bug 4440895
326: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 323: p_resource_name IN pa_resources.name%TYPE,

319: Basically to note any calls made to this procedure. Eventually we shall be
320: commenting out this procedure because of its nonusage. */
321: PROCEDURE check_resource_gp_name_or_id
322: (p_resource_id IN pa_resources.resource_id%TYPE,
323: p_resource_name IN pa_resources.name%TYPE,
324: p_check_id_flag IN VARCHAR2,
325: x_resource_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE, --File.Sql.39 bug 4440895
326: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
327: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

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

327: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
328: x_error_msg OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
329:
330: PROCEDURE check_resource_name_or_id
331: (p_resource_id IN pa_resources.resource_id%TYPE,
332: p_resource_name IN pa_resources.name%TYPE,
333: p_check_id_flag IN VARCHAR2,
334: x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE, --File.Sql.39 bug 4440895
335: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 332: p_resource_name IN pa_resources.name%TYPE,

328: x_error_msg OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
329:
330: PROCEDURE check_resource_name_or_id
331: (p_resource_id IN pa_resources.resource_id%TYPE,
332: p_resource_name IN pa_resources.name%TYPE,
333: p_check_id_flag IN VARCHAR2,
334: x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE, --File.Sql.39 bug 4440895
335: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
336: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

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

330: PROCEDURE check_resource_name_or_id
331: (p_resource_id IN pa_resources.resource_id%TYPE,
332: p_resource_name IN pa_resources.name%TYPE,
333: p_check_id_flag IN VARCHAR2,
334: x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE, --File.Sql.39 bug 4440895
335: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
336: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
337: x_error_msg OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
338:

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

401: PROCEDURE Get_Uncat_Resource_List_Info
402: (x_resource_list_id OUT NOCOPY pa_resource_lists.RESOURCE_LIST_ID%TYPE --File.Sql.39 bug 4440895
403: ,x_resource_list_member_id OUT NOCOPY pa_resource_list_members.RESOURCE_LIST_MEMBER_ID%TYPE --File.Sql.39 bug 4440895
404: ,x_track_as_labor_flag OUT NOCOPY pa_resource_list_members.TRACK_AS_LABOR_FLAG%TYPE --File.Sql.39 bug 4440895
405: ,x_unit_of_measure OUT NOCOPY pa_resources.UNIT_OF_MEASURE%TYPE --File.Sql.39 bug 4440895
406: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
407: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
408: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
409: