eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ABT_PKG dependencies on PER_ABT_PKG

Line 1: PACKAGE BODY PER_ABT_PKG as

1: PACKAGE BODY PER_ABT_PKG as
2: /* $Header: peabt01t.pkb 115.1 99/07/17 18:23:36 porting ship $ */
3: /*===========================================================================+
4: | Copyright (c) 1993 Oracle Corporation |
5: | Redwood Shores, California, USA |

Line 72: per_abt_pkg.check_unique_name(X_Rowid

68: FROM sys.dual;
69: BEGIN
70: -- check the uniqueness of the name
71: --
72: per_abt_pkg.check_unique_name(X_Rowid
73: ,X_Business_Group_Id
74: ,X_Name);
75: --
76: --

Line 77: per_abt_pkg.ensure_fields_populated(X_inc_or_dec_flag

73: ,X_Business_Group_Id
74: ,X_Name);
75: --
76: --
77: per_abt_pkg.ensure_fields_populated(X_inc_or_dec_flag
78: ,X_hours_or_days
79: ,X_input_value_id
80: ,X_element_type_id);
81: --

Line 83: per_abt_pkg.check_inputs_required(X_element_type_id

79: ,X_input_value_id
80: ,X_element_type_id);
81: --
82: --
83: per_abt_pkg.check_inputs_required(X_element_type_id
84: ,X_Input_Value_Id );
85: --
86: --
87: per_abt_pkg.val_date_end(X_date_end

Line 87: per_abt_pkg.val_date_end(X_date_end

83: per_abt_pkg.check_inputs_required(X_element_type_id
84: ,X_Input_Value_Id );
85: --
86: --
87: per_abt_pkg.val_date_end(X_date_end
88: ,X_element_end_date
89: ,X_end_of_time );
90: --
91: if (X_Absence_Attendance_Type_Id is NULL) then

Line 167: hr_utility.set_message_token('PROCEDURE','PER_ABT_PKG.Insert_Row');

163: FETCH C INTO X_Rowid;
164: if (C%NOTFOUND) then
165: CLOSE C;
166: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
167: hr_utility.set_message_token('PROCEDURE','PER_ABT_PKG.Insert_Row');
168: hr_utility.set_message_token('STEP','1');
169: hr_utility.raise_error;
170: end if;
171: CLOSE C;

Line 224: hr_utility.set_message_token('PROCEDURE','PER_ABT_PKG.Lock_Row');

220: FETCH C INTO Recinfo;
221: if (C%NOTFOUND) then
222: CLOSE C;
223: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
224: hr_utility.set_message_token('PROCEDURE','PER_ABT_PKG.Lock_Row');
225: hr_utility.set_message_token('STEP','1');
226: hr_utility.raise_error;
227: end if;
228: CLOSE C;

Line 402: per_abt_pkg.check_unique_name(X_Rowid

398: ) IS
399: BEGIN
400: -- check the uniqueness of the name
401: --
402: per_abt_pkg.check_unique_name(X_Rowid
403: ,X_Business_Group_Id
404: ,X_Name);
405: --
406: --

Line 407: per_abt_pkg.ensure_fields_populated(X_inc_or_dec_flag

403: ,X_Business_Group_Id
404: ,X_Name);
405: --
406: --
407: per_abt_pkg.ensure_fields_populated(X_inc_or_dec_flag
408: ,X_hours_or_days
409: ,X_input_value_id
410: ,X_element_type_id);
411: --

Line 413: per_abt_pkg.check_inputs_required(X_element_type_id

409: ,X_input_value_id
410: ,X_element_type_id);
411: --
412: --
413: per_abt_pkg.check_inputs_required(X_element_type_id
414: ,X_Input_Value_Id );
415: --
416: --
417: per_abt_pkg.check_category(X_old_absence_category

Line 417: per_abt_pkg.check_category(X_old_absence_category

413: per_abt_pkg.check_inputs_required(X_element_type_id
414: ,X_Input_Value_Id );
415: --
416: --
417: per_abt_pkg.check_category(X_old_absence_category
418: ,X_absence_category
419: ,X_absence_attendance_type_id );
420: --
421: --

Line 422: per_abt_pkg.val_date_end(X_date_end

418: ,X_absence_category
419: ,X_absence_attendance_type_id );
420: --
421: --
422: per_abt_pkg.val_date_end(X_date_end
423: ,X_element_end_date
424: ,X_end_of_time );
425: --
426: --

Line 468: hr_utility.set_message_token('PROCEDURE','PER_ABT_PKG.Update_Row');

464: WHERE rowid = X_rowid;
465: --
466: if (SQL%NOTFOUND) then
467: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
468: hr_utility.set_message_token('PROCEDURE','PER_ABT_PKG.Update_Row');
469: hr_utility.set_message_token('STEP','1');
470: hr_utility.raise_error;
471: end if;
472: --

Line 483: hr_utility.set_location('per_abt_pkg.delete_row',1);

479: PROCEDURE Delete_Row(X_Rowid VARCHAR2
480: ,X_Absence_attendance_type_id NUMBER) IS
481: BEGIN
482: --
483: hr_utility.set_location('per_abt_pkg.delete_row',1);
484: per_abt_pkg.abt_del_validation(X_Absence_attendance_type_id);
485: --
486: hr_utility.set_location('per_abt_pkg.delete_row',2);
487: hrdyndbi.delete_absence_dict(X_Absence_attendance_type_id);

Line 484: per_abt_pkg.abt_del_validation(X_Absence_attendance_type_id);

480: ,X_Absence_attendance_type_id NUMBER) IS
481: BEGIN
482: --
483: hr_utility.set_location('per_abt_pkg.delete_row',1);
484: per_abt_pkg.abt_del_validation(X_Absence_attendance_type_id);
485: --
486: hr_utility.set_location('per_abt_pkg.delete_row',2);
487: hrdyndbi.delete_absence_dict(X_Absence_attendance_type_id);
488: --

Line 486: hr_utility.set_location('per_abt_pkg.delete_row',2);

482: --
483: hr_utility.set_location('per_abt_pkg.delete_row',1);
484: per_abt_pkg.abt_del_validation(X_Absence_attendance_type_id);
485: --
486: hr_utility.set_location('per_abt_pkg.delete_row',2);
487: hrdyndbi.delete_absence_dict(X_Absence_attendance_type_id);
488: --
489: hr_utility.set_location('per_abt_pkg.delete_row',3);
490: DELETE FROM PER_ABSENCE_ATTENDANCE_TYPES

Line 489: hr_utility.set_location('per_abt_pkg.delete_row',3);

485: --
486: hr_utility.set_location('per_abt_pkg.delete_row',2);
487: hrdyndbi.delete_absence_dict(X_Absence_attendance_type_id);
488: --
489: hr_utility.set_location('per_abt_pkg.delete_row',3);
490: DELETE FROM PER_ABSENCE_ATTENDANCE_TYPES
491: WHERE rowid = X_Rowid;
492: --
493: if (SQL%NOTFOUND) then

Line 495: hr_utility.set_message_token('PROCEDURE','PER_ABT_PKG.Delete_Row');

491: WHERE rowid = X_Rowid;
492: --
493: if (SQL%NOTFOUND) then
494: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
495: hr_utility.set_message_token('PROCEDURE','PER_ABT_PKG.Delete_Row');
496: hr_utility.set_message_token('STEP','1');
497: hr_utility.raise_error;
498: end if;
499: END Delete_Row;

Line 516: hr_utility.set_location('per_abt_pkg.check_unique_name',1);

512: abt_rec c%rowtype;
513: --
514: begin
515: --
516: hr_utility.set_location('per_abt_pkg.check_unique_name',1);
517: OPEN C;
518: FETCH C INTO ABT_REC;
519: if (C%FOUND) then
520: CLOSE C;

Line 550: hr_utility.set_location('per_abt_pkg.validate_date_effective',1);

546: abs_rec c2%rowtype;
547: --
548: begin
549: --
550: hr_utility.set_location('per_abt_pkg.validate_date_effective',1);
551: if p_element_type_id is not null then
552: OPEN C1;
553: FETCH C1 INTO ELT_REC;
554: if (C1%NOTFOUND) then

Line 562: hr_utility.set_location('per_abt_pkg.validate_date_effective',2);

558: end if;
559: CLOSE C1;
560: end if;
561: --
562: hr_utility.set_location('per_abt_pkg.validate_date_effective',2);
563: if p_absence_attendance_type_id is not null then
564: OPEN C2;
565: FETCH C2 INTO ABS_REC;
566: if (C2%FOUND) then

Line 623: hr_utility.set_location('per_abt_pkg.validate_element_name',1);

619: --
620: /* If there is only one row returned by this statement then default the
621: values otherwise nullify the values */
622: --
623: hr_utility.set_location('per_abt_pkg.validate_element_name',1);
624: p_default_value := 'N';
625: OPEN C;
626: FETCH C INTO IPV_REC2;
627: if (C%FOUND) then

Line 672: hr_utility.set_location('per_abt_pkg.get_uom',1);

668: LKP_REC c%rowtype;
669: --
670: begin
671: --
672: hr_utility.set_location('per_abt_pkg.get_uom',1);
673: OPEN C;
674: FETCH C INTO LKP_REC;
675: if (C%FOUND) then
676: p_hours_or_days := LKP_REC.lookup_code;

Line 689: hr_utility.set_location('per_abt_pkg.ensure_fields_populated',1);

685: ,p_input_value_id NUMBER
686: ,p_element_type_id NUMBER) is
687: begin
688: --
689: hr_utility.set_location('per_abt_pkg.ensure_fields_populated',1);
690: if p_element_type_id is not null then
691: --
692: if p_input_value_id is null then
693: hr_utility.set_message(801,'HR_7572_ALL_MAN_VAL_FIELD');

Line 725: hr_utility.set_location('per_abt_pkg.check_inputs_required',1);

721: ipv_rec c%rowtype;
722: --
723: begin
724: --
725: hr_utility.set_location('per_abt_pkg.check_inputs_required',1);
726: OPEN C;
727: FETCH C INTO IPV_REC;
728: if (C%FOUND) then
729: CLOSE C;

Line 749: hr_utility.set_location('per_abt_pkg.check_category',1);

745: where absence_attendance_type_id = p_absence_attendance_type_id;
746: abs_rec c%rowtype;
747: --
748: begin
749: hr_utility.set_location('per_abt_pkg.check_category',1);
750: if p_old_absence_category is null or
751: p_old_absence_category = p_new_absence_category then
752: null;
753: else

Line 770: hr_utility.set_location('per_abt_pkg.val_date_end',1);

766: procedure val_date_end(p_date_end IN OUT DATE
767: ,p_element_end_date DATE
768: ,p_end_of_time DATE) is
769: begin
770: hr_utility.set_location('per_abt_pkg.val_date_end',1);
771: if p_date_end is null then
772: if p_element_end_date is null or
773: p_element_end_date = p_end_of_time then
774: null;

Line 804: hr_utility.set_location('per_abt_pkg.abt_del_validation',1);

800: where absence_attendance_type_id = p_absence_attendance_type_id;
801: --
802: begin
803: --
804: hr_utility.set_location('per_abt_pkg.abt_del_validation',1);
805: OPEN C1;
806: FETCH C1 INTO l_exists;
807: if (C1%FOUND) then
808: CLOSE C1;

Line 814: hr_utility.set_location('per_abt_pkg.abt_del_validation',2);

810: hr_utility.raise_error;
811: end if;
812: CLOSE C1;
813: --
814: hr_utility.set_location('per_abt_pkg.abt_del_validation',2);
815: OPEN C2;
816: FETCH C2 INTO l_exists;
817: if (C2%FOUND) then
818: CLOSE C2;

Line 826: END PER_ABT_PKG;

822: CLOSE C2;
823: --
824: end abt_del_validation;
825: --
826: END PER_ABT_PKG;