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_SEARCH_RESULTS_TEMP

Line 139: FROM PA_SEARCH_RESULTS_TEMP

135: --Bug Ref #6144255
136: CURSOR cur_res_temp_search
137: IS
138: SELECT RESOURCE_ID
139: FROM PA_SEARCH_RESULTS_TEMP
140: WHERE MANDATORY_COMPETENCE_COUNT = MANDATORY_COMPETENCE_MATCH;
141:
142: TYPE id_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
143:

Line 715: INSERT INTO PA_SEARCH_RESULTS_TEMP ( person_id

711:
712: END IF; --p_competence_criteria.COUNT >0
713:
714: FORALL k IN l_person_id_tbl.FIRST .. l_person_id_tbl.LAST
715: INSERT INTO PA_SEARCH_RESULTS_TEMP ( person_id
716: , resource_id
717: , resource_organization_id
718: , resource_name
719: , resource_type

Line 777: -- UPDATE pa_search_results_temp

773: -- update the search results table with the match.
774: --
775: -- IF p_search_mode = 'RESOURCE' THEN
776: -- FORALL i IN l_person_id_tbl.FIRST .. l_person_id_tbl.LAST
777: -- UPDATE pa_search_results_temp
778: -- SET (mandatory_competence_match,optional_competence_match)=
779: -- (SELECT /*+ ORDERED */nvl(sum(decode(pct.mandatory_flag,'Y',1,0)),0), nvl(sum(decode(pct.mandatory_flag,'N',1,0)),0)
780: -- FROM pa_competence_criteria_temp pct,
781: -- per_competence_elements pce,

Line 805: UPDATE pa_search_results_temp

801: -- as the above, with a check for competence id to be
802: -- not null.
803: --
804: FORALL i IN l_person_id_tbl.FIRST .. l_person_id_tbl.LAST
805: UPDATE pa_search_results_temp
806: SET (mandatory_competence_match,optional_competence_match)=
807: (SELECT /*+ ORDERED */nvl(sum(decode(pct.mandatory_flag,'Y',1,0)),0), nvl(sum(decode(pct.mandatory_flag,'N',1,0)),0)
808: FROM pa_competence_criteria_temp pct,
809: per_competence_elements pce,

Line 851: UPDATE pa_search_results_temp

847: END IF;
848: */
849:
850: FOR i IN l_person_id_tbl.FIRST .. l_person_id_tbl.LAST LOOP
851: UPDATE pa_search_results_temp
852: SET (mandatory_competence_match,optional_competence_match)=
853: (SELECT /*+ ORDERED */
854: (nvl(sum(decode(pct.mandatory_flag,'Y',1,0)),0) + nvl(mandatory_competence_match, 0)),
855: (nvl(sum(decode(pct.mandatory_flag,'N',1,0)),0) + nvl(optional_competence_match, 0))

Line 920: -- in the pa_search_results_temp table. The availability is

916: -- hr_utility.trace('l_assignment_days is : ' || to_char(l_assignment_days));
917: IF l_assignment_days > 0 THEN
918:
919: -- this sql statement calculates availability for each resource
920: -- in the pa_search_results_temp table. The availability is
921: -- calculated on a daily basis. The resource avail hours is
922: -- divided by the assignment hours for each day, summed up and
923: -- then divided by the total number of assignment days
924: -- with non-zero hours. We need to divide by l_assignment_days

Line 1034: FROM PA_SEARCH_RESULTS_TEMP srt,

1030: -- Caculation from forecast items until new table solution
1031: --
1032: SELECT /*+ ORDERED USE_NL(srt res) INDEX (res, PA_FORECAST_ITEMS_N3)*/srt.person_id, count(res.resource_id)
1033: BULK COLLECT INTO l_person_id_tbl, l_days_in_period_tbl
1034: FROM PA_SEARCH_RESULTS_TEMP srt,
1035: PA_FORECAST_ITEMS res
1036: WHERE srt.resource_id = res.resource_id
1037: AND res.forecast_item_type = 'U'
1038: AND res.delete_flag = 'N'

Line 1064: FROM PA_SEARCH_RESULTS_TEMP srt,

1060: nvl(res.confirmed_qty, 0)), 0) / res.capacity_quantity) /
1061: l_days_in_period_tbl(i) * 100)
1062: INTO l_pot_availability_tbl(i),
1063: l_availability_tbl(i)
1064: FROM PA_SEARCH_RESULTS_TEMP srt,
1065: PA_FORECAST_ITEMS res
1066: WHERE srt.person_id = l_person_id_tbl(i)
1067: AND srt.resource_id = res.resource_id
1068: AND res.forecast_item_type = 'U'

Line 1112: FROM PA_SEARCH_RESULTS_TEMP srt,

1108: potential.percent
1109: BULK COLLECT INTO l_person_id_tbl,
1110: l_availability_tbl,
1111: l_pot_availability_tbl
1112: FROM PA_SEARCH_RESULTS_TEMP srt,
1113: PA_RES_AVAILABILITY confirmed,
1114: PA_RES_AVAILABILITY potential
1115: WHERE srt.resource_id = confirmed.resource_id
1116: AND confirmed.record_type = 'C'

Line 1143: UPDATE pa_search_results_temp

1139: IF l_person_id_tbl.COUNT > 0 THEN
1140:
1141: -- hr_utility.trace('l_person_id is ' || to_char(l_person_id_tbl(1)));
1142: FORALL k IN l_person_id_tbl.FIRST .. l_person_id_tbl.LAST
1143: UPDATE pa_search_results_temp
1144: SET availability = l_availability_tbl(k),
1145: potential_availability = l_pot_availability_tbl(k),
1146: --resource_organization_name = pa_expenditures_utils.GetOrgTlName(resource_organization_id), 4778073
1147: resource_organization_name = pa_resource_utils.get_organization_name(resource_organization_id),

Line 1191: UPDATE pa_search_results_temp

1187: -- which means they were not updated in the above update statement.
1188:
1189: IF p_search_criteria.min_availability = 0 THEN
1190:
1191: UPDATE pa_search_results_temp
1192: SET availability = 0,
1193: potential_availability = 0,
1194: --resource_organization_name = pa_expenditures_utils.GetOrgTlName(resource_organization_id), 4778073
1195: resource_organization_name = pa_resource_utils.get_organization_name(resource_organization_id),

Line 1245: INSERT INTO PA_SEARCH_RESULTS_TEMP ( assignment_id

1241:
1242: IF l_assignment_id_tbl.COUNT > 0 THEN
1243:
1244: FORALL k IN l_assignment_id_tbl.FIRST .. l_assignment_id_tbl.LAST
1245: INSERT INTO PA_SEARCH_RESULTS_TEMP ( assignment_id
1246: , assignment_name
1247: , assignment_number
1248: , assignment_start_date
1249: , assignment_end_date

Line 1288: DELETE FROM pa_search_results_temp

1284: --to be shown due to the status controls.
1285: --**Calling this bulk delete is slightly faster than calling the
1286: --**function directly in the insert statement above.
1287: FORALL i IN l_assignment_id_tbl.FIRST .. l_assignment_id_tbl.LAST
1288: DELETE FROM pa_search_results_temp
1289: WHERE show_req_in_search(l_assignment_id_tbl(i), l_status_code_tbl(i)) = 'N'
1290: AND assignment_id = l_assignment_id_tbl(i);
1291:
1292: --if resource source id is not null then do the competence count/match

Line 1299: UPDATE pa_search_results_temp

1295:
1296: --update the search results table with the mandatory/optional competence count
1297: --for all requirements.
1298: FORALL i IN l_assignment_id_tbl.FIRST .. l_assignment_id_tbl.LAST
1299: UPDATE pa_search_results_temp
1300: SET (mandatory_competence_count, optional_competence_count) =
1301: (SELECT nvl(sum(decode(mandatory,'Y',1,0)),0), nvl(sum(decode(mandatory,'N',1,0)),0)
1302: FROM per_competence_elements pce
1303: WHERE pce.object_name = 'OPEN_ASSIGNMENT'

Line 1310: UPDATE pa_search_results_temp

1306:
1307: --update the search results table with the mandatory/optional competence match
1308: --for all requirments based on the resource competencies.
1309: FORALL i IN l_assignment_id_tbl.FIRST .. l_assignment_id_tbl.LAST
1310: UPDATE pa_search_results_temp
1311: SET (mandatory_competence_match,optional_competence_match)=
1312: (SELECT nvl(sum(decode(pce.mandatory,'Y',1,0)),0), nvl(sum(decode(pce.mandatory,'N',1,0)),0)
1313: FROM per_competence_elements pce,
1314: per_competence_elements pce2,

Line 1333: UPDATE pa_search_results_temp

1329: --and the candidate in req flag (if resource source id is not null)
1330: --for only requirements that passed the mandatory competence match if restrict to
1331: --resource's competencies is true, or for all requirements if restrict to resource's
1332: --competencies is false.
1333: UPDATE pa_search_results_temp
1334: SET candidate_in_req_flag = decode(p_search_criteria.resource_source_id, NULL, NULL,PA_CANDIDATE_UTILS.Check_Resource_Is_Candidate(PA_RESOURCE_UTILS.Get_Resource_Id(p_search_criteria.resource_source_id), assignment_id))
1335: WHERE ((mandatory_competence_count=mandatory_competence_match AND p_search_criteria.restrict_res_comp = FND_API.G_TRUE)
1336: OR p_search_criteria.restrict_res_comp = FND_API.G_FALSE);
1337:

Line 1661: DELETE FROM pa_search_results_temp;

1657: IF p_debug_mode = 'Y' THEN
1658: fnd_file.put_line(FND_FILE.LOG,'about to clear the global temp tables');
1659: END IF;
1660:
1661: DELETE FROM pa_search_results_temp;
1662: DELETE FROM pa_competence_criteria_temp;
1663:
1664: IF p_debug_mode = 'Y' THEN
1665: fnd_file.put_line(FND_FILE.LOG,'done clearing the global temp tables');

Line 1683: FROM pa_search_results_temp

1679: END IF;
1680:
1681: --bulk collect the resources to be nominated
1682: SELECT resource_id BULK COLLECT INTO l_resource_id_tbl
1683: FROM pa_search_results_temp
1684: WHERE candidate_score >= l_min_candidate_score;
1685:
1686: IF p_debug_mode = 'Y' THEN
1687: fnd_file.put_line(FND_FILE.LOG,'done with bulk collect');

Line 1738: FROM pa_search_results_temp

1734: AND ps.status_type = 'CANDIDATE'
1735: AND ps.project_system_status_code = l_cand_system_status_code
1736: AND resource_id NOT IN
1737: (SELECT resource_id
1738: FROM pa_search_results_temp
1739: WHERE candidate_score >= l_min_candidate_score)
1740: ;
1741:
1742: IF p_debug_mode = 'Y' THEN