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 205: -- only the first 2 columns in pa_resources_denorm_n1 to be used

201:
202: -- CASE 1: country is not null
203: -- added the nvl around the country code join below due to the
204: -- functionality change in bug 1925620. This will cause
205: -- only the first 2 columns in pa_resources_denorm_n1 to be used
206: -- (country_code column in the index cannot be used b/c of the nvl)
207: --RD.resource_job_level BETWEEN p_search_criteria.min_job_level
208: --AND p_search_criteria.max_job_level
209:

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

211: -- AND p_search_criteria.territory_code IS NOT NULL THEN
212:
213: -- Start of addition for bug 4624826
214: l_res_sql :=
215: -- 'SELECT /*+ INDEX (RD, PA_RESOURCES_DENORM_N6) */ RD.person_id, RD.resource_id, RD.resource_name, RD.resource_type ' || -- adding hint for 6911907
216: 'SELECT /*+ LEADING(RD) INDEX(RD PA_RESOURCES_DENORM_N6) USE_NL(RD PDF OHD PPF) */ RD.person_id, RD.resource_id, RD.resource_name, RD.resource_type ' || -- adding another hint for 6911907
217: -- 'SELECT RD.person_id, RD.resource_id, RD.resource_name, RD.resource_type ' ||
218: ', RD.resource_organization_id, RD.resource_country_code,RD.resource_country, RD.resource_region '||
219: ', RD.resource_city, RD.resource_job_level, RD.manager_name,PPF.email_address ';

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

212:
213: -- Start of addition for bug 4624826
214: l_res_sql :=
215: -- 'SELECT /*+ INDEX (RD, PA_RESOURCES_DENORM_N6) */ RD.person_id, RD.resource_id, RD.resource_name, RD.resource_type ' || -- adding hint for 6911907
216: 'SELECT /*+ LEADING(RD) INDEX(RD PA_RESOURCES_DENORM_N6) USE_NL(RD PDF OHD PPF) */ RD.person_id, RD.resource_id, RD.resource_name, RD.resource_type ' || -- adding another hint for 6911907
217: -- 'SELECT RD.person_id, RD.resource_id, RD.resource_name, RD.resource_type ' ||
218: ', RD.resource_organization_id, RD.resource_country_code,RD.resource_country, RD.resource_region '||
219: ', RD.resource_city, RD.resource_job_level, RD.manager_name,PPF.email_address ';
220:

Line 221: 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 ';

217: -- 'SELECT RD.person_id, RD.resource_id, RD.resource_name, RD.resource_type ' ||
218: ', RD.resource_organization_id, RD.resource_country_code,RD.resource_country, RD.resource_region '||
219: ', RD.resource_city, RD.resource_job_level, RD.manager_name,PPF.email_address ';
220:
221: 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 ';
222:
223: if p_search_criteria.min_job_level IS NOT NULL then
224: l_res_sql := l_res_sql || ' WHERE RD.resource_job_level >= :1 ';
225: else

Line 356: FROM PA_RESOURCES_DENORM RD

352: , RD.resource_city
353: , RD.resource_job_level
354: , RD.manager_name
355: , PPF.email_address
356: FROM PA_RESOURCES_DENORM RD
357: , PA_ORG_HIERARCHY_DENORM ohd
358: , PER_ALL_PEOPLE_F ppf
359: , PER_DEPLOYMENT_FACTORS pdf
360: WHERE ((p_search_criteria.min_job_level IS NOT NULL AND

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

1481: AND (ps.project_system_status_code= 'OPEN_ASGMT' or ps.project_system_status_code is NULL)
1482: AND p_auto_search_mode = 'MULTI_PROJECT'
1483: ;
1484:
1485: TYPE resource_id_tbl IS TABLE OF pa_resources_denorm.resource_id%TYPE
1486: INDEX BY BINARY_INTEGER;
1487: l_resource_id_tbl resource_id_tbl;
1488:
1489: TYPE candidate_id_tbl IS TABLE OF pa_candidates.candidate_id%TYPE