APPS.PA_COMP_PROFILE_PVT dependencies on PA_COMPETENCE_PROFILES

Line 138: SELECT pa_competence_profiles_s.nextval

134: FETCH l_bg_csr INTO l_bg_id;
135: CLOSE l_bg_csr;
136:
137: IF g_profile_id = 0 THEN
138: SELECT pa_competence_profiles_s.nextval
139: INTO g_profile_id
140: FROM dual;
141: END IF;
142:

Line 253: SELECT pa_competence_profiles_s.nextval

249: RETURN;
250: END IF;
251:
252: IF g_profile_id = 0 THEN
253: SELECT pa_competence_profiles_s.nextval
254: INTO g_profile_id
255: FROM dual;
256: END IF;
257:

Line 485: INSERT INTO PA_COMPETENCE_PROFILES

481: l_rating_level_value := null;
482: END;
483: END IF;
484:
485: INSERT INTO PA_COMPETENCE_PROFILES
486: (PROFILE_ID,
487: PERSON_ID,
488: OBJECT_VERSION_NUMBER,
489: BUSINESS_GROUP_ID,

Line 597: INSERT INTO PA_COMPETENCE_PROFILES

593: l_rating_level_value := null;
594: END;
595: END IF;
596:
597: INSERT INTO PA_COMPETENCE_PROFILES
598: (PROFILE_ID,
599: PERSON_ID,
600: OBJECT_VERSION_NUMBER,
601: BUSINESS_GROUP_ID,

Line 789: DELETE from pa_competence_profiles

785: x_msg_data := l_data;
786: x_msg_count := 1;
787: IF g_profile_id > 0 THEN
788: BEGIN
789: DELETE from pa_competence_profiles
790: where profile_id=g_profile_id;
791: EXCEPTION
792: WHEN OTHERS THEN NULL;
793: END;

Line 812: DELETE from pa_competence_profiles

808: x_msg_data:=SUBSTRB( SQLERRM,1,1900); -- 4537865 Replaced substr with substrb
809:
810: IF g_profile_id > 0 THEN
811: BEGIN
812: DELETE from pa_competence_profiles
813: where profile_id=g_profile_id;
814: EXCEPTION
815: WHEN OTHERS THEN NULL;
816: END;

Line 849: FROM PA_COMPETENCE_PROFILES

845: EFFECTIVE_DATE_FROM,
846: RATING_LEVEL_ID,
847: CREATED_BY,
848: CREATION_DATE
849: FROM PA_COMPETENCE_PROFILES
850: WHERE profile_id = p_profile_id
851: AND operation = 'INSERT';
852:
853: cursor update_profile IS

Line 860: FROM PA_COMPETENCE_PROFILES

856: EFFECTIVE_DATE_FROM,
857: RATING_LEVEL_ID,
858: LAST_UPDATED_BY,
859: LAST_UPDATE_DATE
860: FROM PA_COMPETENCE_PROFILES
861: WHERE profile_id = p_profile_id
862: AND operation = 'UPDATE';
863:
864: cursor delete_profile IS

Line 867: FROM PA_COMPETENCE_PROFILES

863:
864: cursor delete_profile IS
865: SELECT COMPETENCE_ELEMENT_ID,
866: OBJECT_VERSION_NUMBER
867: FROM PA_COMPETENCE_PROFILES
868: WHERE profile_id = p_profile_id
869: AND operation = 'DELETE';
870:
871: l_object_version_number NUMBER := 0;

Line 1006: DELETE from pa_competence_profiles

1002: -- We should delete the rows from pa_competence_profile table since
1003: -- the HR tables have been updated with this information.
1004:
1005: BEGIN
1006: DELETE from pa_competence_profiles
1007: where profile_id=p_profile_id;
1008: EXCEPTION
1009: WHEN OTHERS THEN
1010: RAISE;

Line 1089: FROM pa_competence_profiles

1085: l_dummy VARCHAR2(1);
1086: BEGIN
1087:
1088: SELECT 'x' INTO l_dummy
1089: FROM pa_competence_profiles
1090: WHERE person_id = p_person_id
1091: AND competence_id = p_competence_id ;
1092:
1093: RETURN 'Y';

Line 1119: FROM pa_competence_profiles

1115: l_dummy VARCHAR2(1);
1116: BEGIN
1117:
1118: SELECT 'x' INTO l_dummy
1119: FROM pa_competence_profiles
1120: WHERE competence_element_id = p_element_id;
1121:
1122: RETURN 'Y';
1123:

Line 1183: FROM PA_COMPETENCE_PROFILES

1179: COMPETENCE_NAME,
1180: EFFECTIVE_DATE_FROM,
1181: RATING_LEVEL_ID,
1182: RATING_LEVEL_VALUE
1183: FROM PA_COMPETENCE_PROFILES
1184: WHERE profile_id = l_profile_id
1185: AND operation = 'INSERT';
1186:
1187: cursor update_profile

Line 1196: FROM PA_COMPETENCE_PROFILES

1192: COMPETENCE_NAME,
1193: EFFECTIVE_DATE_FROM,
1194: RATING_LEVEL_ID,
1195: RATING_LEVEL_VALUE
1196: FROM PA_COMPETENCE_PROFILES
1197: WHERE profile_id = l_profile_id
1198: AND operation = 'UPDATE';
1199:
1200: cursor delete_profile

Line 1209: FROM PA_COMPETENCE_PROFILES

1205: COMPETENCE_NAME,
1206: EFFECTIVE_DATE_FROM,
1207: RATING_LEVEL_ID,
1208: RATING_LEVEL_VALUE
1209: FROM PA_COMPETENCE_PROFILES
1210: WHERE profile_id = l_profile_id
1211: AND operation = 'DELETE';
1212:
1213: BEGIN

Line 1305: DELETE FROM pa_competence_profiles

1301: x_msg_count OUT NOCOPY NUMBER, -- 4537865 Added the nocopy hint
1302: x_msg_data OUT NOCOPY VARCHAR2) -- 4537865 Added the nocopy hint
1303: IS
1304: BEGIN
1305: DELETE FROM pa_competence_profiles
1306: WHERE profile_id=p_profile_id;
1307:
1308: x_return_status := FND_API.G_RET_STS_SUCCESS;
1309: x_msg_count := 0;