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_SEARCH_PVT dependencies on PA_RESOURCES_DENORM

Line 45: TYPE person_id_tbl IS TABLE OF pa_resources_denorm.person_id%TYPE

41: l_person_type fnd_lookup_values.lookup_code%TYPE; -- Bug 6526674
42: TYPE resource_organization_name_tbl IS TABLE OF hr_organization_units.name%TYPE
43: INDEX BY BINARY_INTEGER;
44:
45: TYPE person_id_tbl IS TABLE OF pa_resources_denorm.person_id%TYPE
46: INDEX BY BINARY_INTEGER;
47: l_person_id_tbl person_id_tbl;
48:
49: TYPE resource_id_tbl IS TABLE OF pa_resources_denorm.resource_id%TYPE

Line 49: TYPE resource_id_tbl IS TABLE OF pa_resources_denorm.resource_id%TYPE

45: TYPE person_id_tbl IS TABLE OF pa_resources_denorm.person_id%TYPE
46: INDEX BY BINARY_INTEGER;
47: l_person_id_tbl person_id_tbl;
48:
49: TYPE resource_id_tbl IS TABLE OF pa_resources_denorm.resource_id%TYPE
50: INDEX BY BINARY_INTEGER;
51: l_resource_id_tbl resource_id_tbl;
52:
53: TYPE resource_name_tbl IS TABLE OF pa_resources_denorm.resource_name%TYPE

Line 53: TYPE resource_name_tbl IS TABLE OF pa_resources_denorm.resource_name%TYPE

49: TYPE resource_id_tbl IS TABLE OF pa_resources_denorm.resource_id%TYPE
50: INDEX BY BINARY_INTEGER;
51: l_resource_id_tbl resource_id_tbl;
52:
53: TYPE resource_name_tbl IS TABLE OF pa_resources_denorm.resource_name%TYPE
54: INDEX BY BINARY_INTEGER;
55: l_resource_name_tbl resource_name_tbl;
56:
57: TYPE resource_type_tbl IS TABLE OF pa_resources_denorm.resource_type%TYPE

Line 57: TYPE resource_type_tbl IS TABLE OF pa_resources_denorm.resource_type%TYPE

53: TYPE resource_name_tbl IS TABLE OF pa_resources_denorm.resource_name%TYPE
54: INDEX BY BINARY_INTEGER;
55: l_resource_name_tbl resource_name_tbl;
56:
57: TYPE resource_type_tbl IS TABLE OF pa_resources_denorm.resource_type%TYPE
58: INDEX BY BINARY_INTEGER;
59: l_resource_type_tbl resource_type_tbl;
60:
61: TYPE resource_organization_id_tbl IS TABLE OF pa_resources_denorm.resource_organization_id%TYPE

Line 61: TYPE resource_organization_id_tbl IS TABLE OF pa_resources_denorm.resource_organization_id%TYPE

57: TYPE resource_type_tbl IS TABLE OF pa_resources_denorm.resource_type%TYPE
58: INDEX BY BINARY_INTEGER;
59: l_resource_type_tbl resource_type_tbl;
60:
61: TYPE resource_organization_id_tbl IS TABLE OF pa_resources_denorm.resource_organization_id%TYPE
62: INDEX BY BINARY_INTEGER;
63: l_resource_organization_id_tbl resource_organization_id_tbl;
64:
65: TYPE country_code_tbl IS TABLE OF fnd_territories_vl.territory_code%TYPE

Line 85: TYPE manager_tbl IS TABLE OF pa_resources_denorm.manager_name%TYPE

81: TYPE email_tbl IS TABLE OF per_all_people_f.email_address%TYPE
82: INDEX BY BINARY_INTEGER;
83: l_email_tbl email_tbl;
84:
85: TYPE manager_tbl IS TABLE OF pa_resources_denorm.manager_name%TYPE
86: INDEX BY BINARY_INTEGER;
87: l_manager_tbl manager_tbl;
88:
89: TYPE resource_job_level_tbl IS TABLE OF pa_resources_denorm.resource_job_level%TYPE

Line 89: TYPE resource_job_level_tbl IS TABLE OF pa_resources_denorm.resource_job_level%TYPE

85: TYPE manager_tbl IS TABLE OF pa_resources_denorm.manager_name%TYPE
86: INDEX BY BINARY_INTEGER;
87: l_manager_tbl manager_tbl;
88:
89: TYPE resource_job_level_tbl IS TABLE OF pa_resources_denorm.resource_job_level%TYPE
90: INDEX BY BINARY_INTEGER;
91: l_resource_job_level_tbl resource_job_level_tbl;
92:
93: TYPE assignment_id_tbl IS TABLE OF pa_project_assignments.assignment_id%TYPE

Line 213: -- only the first 2 columns in pa_resources_denorm_n1 to be used

209:
210: -- CASE 1: country is not null
211: -- added the nvl around the country code join below due to the
212: -- functionality change in bug 1925620. This will cause
213: -- only the first 2 columns in pa_resources_denorm_n1 to be used
214: -- (country_code column in the index cannot be used b/c of the nvl)
215: --RD.resource_job_level BETWEEN p_search_criteria.min_job_level
216: --AND p_search_criteria.max_job_level
217:

Line 222: -- 'SELECT /+ INDEX (RD, PA_RESOURCES_DENORM_N6) / RD.person_id, RD.resource_id, RD.resource_name, RD.resource_type ' || -- adding hint for 6911907

218: IF p_search_mode = 'RESOURCE' or p_search_mode = 'ADHOC' THEN
219: -- AND p_search_criteria.territory_code IS NOT NULL THEN
220: -- Start of addition for bug 4624826
221: l_res_sql :=
222: -- 'SELECT /*+ INDEX (RD, PA_RESOURCES_DENORM_N6) */ RD.person_id, RD.resource_id, RD.resource_name, RD.resource_type ' || -- adding hint for 6911907
223: 'SELECT /*+ LEADING(RD) INDEX(RD PA_RESOURCES_DENORM_N6) USE_NL(RD PDF OHD PPF) */ DISTINCT RD.person_id, RD.resource_id, RD.resource_name, RD.resource_type ' || -- adding another hint for 6911907, --added distinct bug 9206026
224: -- 'SELECT RD.person_id, RD.resource_id, RD.resource_name, RD.resource_type ' ||
225: ', RD.resource_organization_id, RD.resource_country_code,RD.resource_country, RD.resource_region '||
226: ', RD.resource_city, RD.resource_job_level, RD.manager_name,PPF.email_address ';

Line 223: 'SELECT /+ LEADING(RD) INDEX(RD PA_RESOURCES_DENORM_N6) USE_NL(RD PDF OHD PPF) / DISTINCT RD.person_id, RD.resource_id, RD.resource_name, RD.resource_type ' || -- adding another hint for 6911907, --added distinct bug 9206026

219: -- AND p_search_criteria.territory_code IS NOT NULL THEN
220: -- Start of addition for bug 4624826
221: l_res_sql :=
222: -- 'SELECT /*+ INDEX (RD, PA_RESOURCES_DENORM_N6) */ RD.person_id, RD.resource_id, RD.resource_name, RD.resource_type ' || -- adding hint for 6911907
223: 'SELECT /*+ LEADING(RD) INDEX(RD PA_RESOURCES_DENORM_N6) USE_NL(RD PDF OHD PPF) */ DISTINCT RD.person_id, RD.resource_id, RD.resource_name, RD.resource_type ' || -- adding another hint for 6911907, --added distinct bug 9206026
224: -- 'SELECT RD.person_id, RD.resource_id, RD.resource_name, RD.resource_type ' ||
225: ', RD.resource_organization_id, RD.resource_country_code,RD.resource_country, RD.resource_region '||
226: ', RD.resource_city, RD.resource_job_level, RD.manager_name,PPF.email_address ';
227:

Line 228: l_res_sql := l_res_sql || ' FROM PA_RESOURCES_DENORM RD, PER_ALL_PEOPLE_F ppf,PA_ORG_HIERARCHY_DENORM ohd, PER_DEPLOYMENT_FACTORS pdf ';

224: -- 'SELECT RD.person_id, RD.resource_id, RD.resource_name, RD.resource_type ' ||
225: ', RD.resource_organization_id, RD.resource_country_code,RD.resource_country, RD.resource_region '||
226: ', RD.resource_city, RD.resource_job_level, RD.manager_name,PPF.email_address ';
227:
228: l_res_sql := l_res_sql || ' FROM PA_RESOURCES_DENORM RD, PER_ALL_PEOPLE_F ppf,PA_ORG_HIERARCHY_DENORM ohd, PER_DEPLOYMENT_FACTORS pdf ';
229:
230: if p_search_criteria.min_job_level IS NOT NULL then
231: l_res_sql := l_res_sql || ' WHERE RD.resource_job_level >= :1 ';
232: else

Line 364: FROM PA_RESOURCES_DENORM RD

360: , RD.resource_city
361: , RD.resource_job_level
362: , RD.manager_name
363: , PPF.email_address
364: FROM PA_RESOURCES_DENORM RD
365: , PA_ORG_HIERARCHY_DENORM ohd
366: , PER_ALL_PEOPLE_F ppf
367: , PER_DEPLOYMENT_FACTORS pdf
368: WHERE ((p_search_criteria.min_job_level IS NOT NULL AND

Line 1535: TYPE resource_id_tbl IS TABLE OF pa_resources_denorm.resource_id%TYPE

1531: AND (ps.project_system_status_code= 'OPEN_ASGMT' or ps.project_system_status_code is NULL)
1532: AND p_auto_search_mode = 'MULTI_PROJECT'
1533: ;
1534:
1535: TYPE resource_id_tbl IS TABLE OF pa_resources_denorm.resource_id%TYPE
1536: INDEX BY BINARY_INTEGER;
1537: l_resource_id_tbl resource_id_tbl;
1538:
1539: TYPE candidate_id_tbl IS TABLE OF pa_candidates.candidate_id%TYPE