APPS.HR_EXTERNAL_APPLICATION dependencies on HR_KI_EXT_APPLICATIONS

Line 291: FROM hr_ki_ext_applications

287: l_procedure VARCHAR2(31) := 'get_app_id';
288:
289: cursor csr_get_app_id is
290: SELECT external_application_id
291: FROM hr_ki_ext_applications
292: WHERE external_application_name = p_app_code;
293:
294: BEGIN
295:

Line 824: FROM hr_ki_ext_applications

820: l_tst_fval9 VARCHAR2(1000);
821:
822: CURSOR csr_app_id IS
823: SELECT external_application_id
824: FROM hr_ki_ext_applications
825: WHERE external_application_name = p_app_code;
826:
827: BEGIN
828:

Line 829: -- see if the hr_ki_ext_applications

825: WHERE external_application_name = p_app_code;
826:
827: BEGIN
828:
829: -- see if the hr_ki_ext_applications
830: -- if no app_id, then this is a new external application
831: -- otherwise we are doing an update
832:
833: hr_utility.trace('csr_app_id');

Line 920: -- insert record into hr_ki_ext_applications

916: p_fname9 => p_fname9,
917: p_fval9 => p_fval9,
918: p_appid => l_app_id);
919:
920: -- insert record into hr_ki_ext_applications
921: -- after deleting any existing entry
922: DELETE FROM hr_ki_ext_applications
923: WHERE external_application_name = p_app_code;
924:

Line 922: DELETE FROM hr_ki_ext_applications

918: p_appid => l_app_id);
919:
920: -- insert record into hr_ki_ext_applications
921: -- after deleting any existing entry
922: DELETE FROM hr_ki_ext_applications
923: WHERE external_application_name = p_app_code;
924:
925: INSERT INTO hr_ki_ext_applications
926: (

Line 925: INSERT INTO hr_ki_ext_applications

921: -- after deleting any existing entry
922: DELETE FROM hr_ki_ext_applications
923: WHERE external_application_name = p_app_code;
924:
925: INSERT INTO hr_ki_ext_applications
926: (
927: ext_application_id,
928: external_application_name,
929: external_application_id

Line 932: hr_ki_ext_applications_s.nextval,

928: external_application_name,
929: external_application_id
930: )
931: SELECT
932: hr_ki_ext_applications_s.nextval,
933: p_app_code,
934: l_app_id
935: FROM dual;
936:

Line 968: -- update external_application_id in hr_ki_ext_applications

964: p_fval8 => p_fval8,
965: p_fname9 => p_fname9,
966: p_fval9 => p_fval9);
967:
968: -- update external_application_id in hr_ki_ext_applications
969: -- with app_id
970: UPDATE hr_ki_ext_applications
971: SET external_application_id = l_app_id
972: WHERE external_application_name = p_app_code;

Line 970: UPDATE hr_ki_ext_applications

966: p_fval9 => p_fval9);
967:
968: -- update external_application_id in hr_ki_ext_applications
969: -- with app_id
970: UPDATE hr_ki_ext_applications
971: SET external_application_id = l_app_id
972: WHERE external_application_name = p_app_code;
973:
974: