90:
91: --
92: -- Declare out parameters
93: --
94: l_object_version_number per_qualification_types.object_version_number%TYPE;
95: l_qualification_type_id per_qualification_types.qualification_type_id%TYPE;
96: l_language_code per_qualification_types_tl.language%TYPE;
97: --
98: begin
91: --
92: -- Declare out parameters
93: --
94: l_object_version_number per_qualification_types.object_version_number%TYPE;
95: l_qualification_type_id per_qualification_types.qualification_type_id%TYPE;
96: l_language_code per_qualification_types_tl.language%TYPE;
97: --
98: begin
99: --
92: -- Declare out parameters
93: --
94: l_object_version_number per_qualification_types.object_version_number%TYPE;
95: l_qualification_type_id per_qualification_types.qualification_type_id%TYPE;
96: l_language_code per_qualification_types_tl.language%TYPE;
97: --
98: begin
99: --
100:
293:
294: hr_utility.set_location(l_proc, 50);
295:
296: --
297: -- Insert translatable rows in per_qualification_types_tl table
298: --
299: per_qtt_ins.ins_tl
300: (p_qualification_type_id => l_qualification_type_id
301: ,p_language_code => l_language_code
522: -- Declare cursors and local variables
523: --
524: l_proc varchar2(72) := g_package||'update_qualification_type';
525: l_effective_date date;
526: lv_object_version_number per_qualification_types.object_version_number%TYPE;
527:
528: --
529: -- Declare out parameters
530: --
527:
528: --
529: -- Declare out parameters
530: --
531: l_object_version_number per_qualification_types.object_version_number%TYPE;
532: l_language_code per_qualification_types_tl.language%TYPE;
533:
534: --
535: begin
528: --
529: -- Declare out parameters
530: --
531: l_object_version_number per_qualification_types.object_version_number%TYPE;
532: l_language_code per_qualification_types_tl.language%TYPE;
533:
534: --
535: begin
536: --
737:
738: hr_utility.set_location(l_proc, 50);
739:
740: --
741: -- Update per_qualification_types_tl table
742: --
743: per_qtt_upd.upd_tl
744: (p_qualification_type_id => p_qualification_type_id
745: ,p_language_code => p_language_code
901: --
902: -- Declare cursors and local variables
903: --
904: l_proc VARCHAR2(72) := g_package||'delete_qualification_type';
905: lv_object_version_number per_qualification_types.object_version_number%type;
906:
907: --
908: -- Declare out parameter
909: --
906:
907: --
908: -- Declare out parameter
909: --
910: l_object_version_number per_qualification_types.object_version_number%type;
911:
912: --
913: begin
914: --
943:
944: hr_utility.set_location(l_proc, 30);
945:
946: --
947: -- Remove all matching translation rows in per_qualification_types_tl
948: --
949: per_qtt_del.del_tl
950: (p_qualification_type_id => p_qualification_type_id
951: );