APPS.PA_SEARCH_PVT dependencies on PA_COMPETENCE_CRITERIA_TEMP

Line 23: TYPE mandatory_flag IS TABLE OF pa_competence_criteria_temp.mandatory_flag%TYPE

19:
20: l_competence_id_tbl number_tbl;
21: l_rating_level_tbl number_tbl;
22:
23: TYPE mandatory_flag IS TABLE OF pa_competence_criteria_temp.mandatory_flag%TYPE
24: INDEX BY BINARY_INTEGER;
25: l_mandatory_flag_tbl mandatory_flag;
26:
27: TYPE competence_name IS TABLE OF per_competences.name%TYPE

Line 761: INSERT INTO pa_competence_criteria_temp(competence_id,

757: -- insert competence critieria into a global temporary table.
758: -- that way I can join to the temp table to do the competence match
759: -- instead of doing the match once per competence.
760: FORALL i IN l_competence_id_tbl.FIRST .. l_competence_id_tbl.LAST
761: INSERT INTO pa_competence_criteria_temp(competence_id,
762: competence_name,
763: rating_level,
764: mandatory_flag)
765: VALUES(l_competence_id_tbl(i),

Line 780: -- FROM pa_competence_criteria_temp pct,

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,
782: -- per_rating_levels prl
783: -- WHERE pce.competence_id = pct.competence_id
784: -- AND pce.person_id = l_person_id_tbl(i)

Line 808: FROM pa_competence_criteria_temp pct,

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,
810: per_rating_levels prl
811: WHERE (pct.competence_id <> -1 AND
812: pce.competence_id = pct.competence_id)

Line 856: FROM pa_competence_criteria_temp pct

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))
856: FROM pa_competence_criteria_temp pct
857: WHERE pct.competence_id = -1
858: AND EXISTS ( SELECT 'Y'
859: FROM per_competence_elements pce,
860: per_competences pc,

Line 1662: DELETE FROM pa_competence_criteria_temp;

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');
1666: fnd_file.put_line(FND_FILE.LOG,'about to call run search API');