APPS.HR_QUALIFICATION_TYPE_API dependencies on PER_QUALIFICATION_TYPES

Line 94: l_object_version_number per_qualification_types.object_version_number%TYPE;

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

Line 95: l_qualification_type_id per_qualification_types.qualification_type_id%TYPE;

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: --

Line 96: l_language_code per_qualification_types_tl.language%TYPE;

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:

Line 297: -- Insert translatable rows in per_qualification_types_tl table

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

Line 526: lv_object_version_number per_qualification_types.object_version_number%TYPE;

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: --

Line 531: l_object_version_number per_qualification_types.object_version_number%TYPE;

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

Line 532: l_language_code per_qualification_types_tl.language%TYPE;

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: --

Line 741: -- Update per_qualification_types_tl table

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

Line 905: lv_object_version_number per_qualification_types.object_version_number%type;

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: --

Line 910: l_object_version_number per_qualification_types.object_version_number%type;

906:
907: --
908: -- Declare out parameter
909: --
910: l_object_version_number per_qualification_types.object_version_number%type;
911:
912: --
913: begin
914: --

Line 947: -- Remove all matching translation rows in per_qualification_types_tl

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: );