659: -----------------------------------------------------------------------------
660: -- Name
661: -- Insert_Lookups
662: -- Purpose
663: -- Inserts lookups into the hr_lookups table. It firstly checks if the lookup
664: -- exists before inserting it thus avoiding duplication.
665: -- Arguments
666: -- p_lookup_code - lookup code to add
667: -- p_lookup_type - lookup type to add
683: l_dummy VARCHAR2(1);
684: --
685: CURSOR c1 IS
686: SELECT NULL
687: FROM HR_LOOKUPS HR
688: WHERE HR.lookup_type = p_lookup_type
689: AND HR.lookup_code = p_lookup_code;
690: --
691: BEGIN
696: IF c1%notfound THEN
697: --
698: -- insert the lookup
699: --
700: INSERT INTO hr_lookups
701: (lookup_code,
702: lookup_type,
703: application_id,
704: created_by,