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_ADVERTISEMENTS_PVT dependencies on PA_RESOURCE_UTILS

Line 403: SELECT child_organization_id, pa_resource_utils.get_organization_name(child_organization_id) -- Added for Bug 4866284

399: -- cursor to get all organizations under the specified starting
400: -- organization in the organization hierarchy
401: CURSOR get_all_child_orgs_in_hier IS
402: -- SELECT child_organization_id, pa_expenditures_utils.GetOrgTlName(child_organization_id) -- Commented for Bug 4866284
403: SELECT child_organization_id, pa_resource_utils.get_organization_name(child_organization_id) -- Added for Bug 4866284
404: FROM pa_org_hierarchy_denorm
405: WHERE org_hierarchy_version_id = p_org_hierarchy_version_id
406: AND parent_organization_id = p_starting_organization_id
407: AND pa_org_use_type = 'EXPENDITURES';

Line 549: SELECT ohd.child_organization_id, pa_resource_utils.get_organization_name(ohd.child_organization_id) -- Added for Bug 4866284

545: -- cursor to get all organizations under the specified starting
546: -- organization in the organization hierarchy that have not been published to
547: CURSOR get_child_orgs_in_hier(c_org_hierarchy_version_id NUMBER, c_start_org_id NUMBER) IS
548: -- SELECT ohd.child_organization_id, pa_expenditures_utils.GetOrgTlName(ohd.child_organization_id) -- Commented for Bug 4866284
549: SELECT ohd.child_organization_id, pa_resource_utils.get_organization_name(ohd.child_organization_id) -- Added for Bug 4866284
550: FROM pa_org_hierarchy_denorm ohd
551: WHERE ohd.org_hierarchy_version_id = c_org_hierarchy_version_id
552: AND ohd.parent_organization_id = c_start_org_id
553: AND ohd.pa_org_use_type = 'EXPENDITURES'

Line 556: SELECT ohd.child_organization_id, pa_resource_utils.get_organization_name(ohd.child_organization_id) -- Added for Bug 4866284

552: AND ohd.parent_organization_id = c_start_org_id
553: AND ohd.pa_org_use_type = 'EXPENDITURES'
554: MINUS
555: -- SELECT ohd.child_organization_id, pa_expenditures_utils.GetOrgTlName(ohd.child_organization_id) -- Commented for Bug 4866284
556: SELECT ohd.child_organization_id, pa_resource_utils.get_organization_name(ohd.child_organization_id) -- Added for Bug 4866284
557: FROM pa_org_hierarchy_denorm ohd,
558: pa_action_set_line_aud asla
559: WHERE ohd.org_hierarchy_version_id = c_org_hierarchy_version_id
560: AND ohd.parent_organization_id = c_start_org_id

Line 1273: pa_resource_utils.get_organization_name(proj.carrying_out_organization_id), -- Added for Bug 4866284

1269: SELECT asgn.assignment_name,
1270: asgn.start_date,
1271: asgn.end_date,
1272: -- pa_expenditures_utils.GetOrgTlName(proj.carrying_out_organization_id), -- Commented for Bug 4866284
1273: pa_resource_utils.get_organization_name(proj.carrying_out_organization_id), -- Added for Bug 4866284
1274: prt.meaning,
1275: asgn.min_resource_job_level,
1276: asgn.max_resource_job_level,
1277: sp.meaning staffing_priority_name,