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_ASSIGNMENTS_V7_PKG dependencies on PER_ASSIGNMENTS_V7_PKG

Line 1: PACKAGE BODY PER_ASSIGNMENTS_V7_PKG as

1: PACKAGE BODY PER_ASSIGNMENTS_V7_PKG as
2: /* $Header: peasg07t.pkb 120.2 2005/12/05 14:01:08 rthiagar noship $ */
3: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
4: X_Assignment_Id IN OUT NOCOPY NUMBER,
5: X_Effective_Start_Date DATE,

Line 108: hr_utility.set_location('per_assignments_v7_pkg.insert_row',10);

104: and nvl(pasa.default_flag,past.default_flag) = 'Y'
105: and nvl(pasa.per_system_status,past.per_system_status) = 'ACTIVE_ASSIGN';
106: --
107: BEGIN
108: hr_utility.set_location('per_assignments_v7_pkg.insert_row',10);
109: if (X_Assignment_Id is NULL) then
110: OPEN C2;
111: FETCH C2 INTO X_Assignment_Id;
112: CLOSE C2;

Line 114: hr_utility.set_location('per_assignments_v7_pkg.insert_row',20);

110: OPEN C2;
111: FETCH C2 INTO X_Assignment_Id;
112: CLOSE C2;
113: end if;
114: hr_utility.set_location('per_assignments_v7_pkg.insert_row',20);
115: open c3;
116: fetch c3 into X_assignment_status_type_id;
117: close c3;
118: --

Line 119: hr_utility.set_location('per_assignments_v7_pkg.insert_row',30);

115: open c3;
116: fetch c3 into X_assignment_status_type_id;
117: close c3;
118: --
119: hr_utility.set_location('per_assignments_v7_pkg.insert_row',30);
120: hr_assignment.gen_new_ass_sequence(X_person_id
121: ,X_Assignment_type
122: ,X_assignment_sequence);
123: --

Line 124: hr_utility.set_location('per_assignments_v7_pkg.insert_row',40);

120: hr_assignment.gen_new_ass_sequence(X_person_id
121: ,X_Assignment_type
122: ,X_assignment_sequence);
123: --
124: hr_utility.set_location('per_assignments_v7_pkg.insert_row',40);
125: hr_assignment.gen_new_ass_number(X_Assignment_Id
126: ,X_business_group_id
127: ,X_employee_number
128: ,X_assignment_sequence

Line 133: hr_utility.set_location('per_assignments_v7_pkg.insert_row',50);

129: ,X_assignment_number);
130: --
131: -- Check for current primary
132: --
133: hr_utility.set_location('per_assignments_v7_pkg.insert_row',50);
134: per_assignments_v7_pkg.check_primary(X_person_id => X_person_id
135: ,X_primary_flag => X_primary_flag);
136: --
137: hr_utility.set_location('per_assignments_v7_pkg.insert_row',60);

Line 134: per_assignments_v7_pkg.check_primary(X_person_id => X_person_id

130: --
131: -- Check for current primary
132: --
133: hr_utility.set_location('per_assignments_v7_pkg.insert_row',50);
134: per_assignments_v7_pkg.check_primary(X_person_id => X_person_id
135: ,X_primary_flag => X_primary_flag);
136: --
137: hr_utility.set_location('per_assignments_v7_pkg.insert_row',60);
138: INSERT INTO PER_ASSIGNMENTS_F(

Line 137: hr_utility.set_location('per_assignments_v7_pkg.insert_row',60);

133: hr_utility.set_location('per_assignments_v7_pkg.insert_row',50);
134: per_assignments_v7_pkg.check_primary(X_person_id => X_person_id
135: ,X_primary_flag => X_primary_flag);
136: --
137: hr_utility.set_location('per_assignments_v7_pkg.insert_row',60);
138: INSERT INTO PER_ASSIGNMENTS_F(
139: assignment_id,
140: effective_start_date,
141: effective_end_date,

Line 319: hr_utility.set_location('per_assignments_v7_pkg.insert_row',70);

315: CLOSE C;
316: --
317: -- add the person to the appropriate security lists
318: --
319: hr_utility.set_location('per_assignments_v7_pkg.insert_row',70);
320: hr_security_internal.add_to_person_list
321: (p_effective_date => sysdate
322: ,p_assignment_id => X_Assignment_Id);
323: --

Line 324: hr_utility.set_location('per_assignments_v7_pkg.insert_row',80);

320: hr_security_internal.add_to_person_list
321: (p_effective_date => sysdate
322: ,p_assignment_id => X_Assignment_Id);
323: --
324: hr_utility.set_location('per_assignments_v7_pkg.insert_row',80);
325: END Insert_Row;
326: --
327: PROCEDURE Lock_Row(X_Rowid VARCHAR2,
328: X_Assignment_Id NUMBER,

Line 415: hr_utility.set_location('per_assignments_v7_pkg.lock_row',10);

411: WHERE rowid = X_Rowid
412: FOR UPDATE of Assignment_Id NOWAIT;
413: Recinfo C%ROWTYPE;
414: BEGIN
415: hr_utility.set_location('per_assignments_v7_pkg.lock_row',10);
416: OPEN C;
417: FETCH C INTO Recinfo;
418: if (C%NOTFOUND) then
419: CLOSE C;

Line 423: hr_utility.set_location('per_assignments_v7_pkg.lock_row',20);

419: CLOSE C;
420: RAISE NO_DATA_FOUND;
421: end if;
422: CLOSE C;
423: hr_utility.set_location('per_assignments_v7_pkg.lock_row',20);
424: if (
425: ( (Recinfo.assignment_id = X_Assignment_Id)
426: OR ( (Recinfo.assignment_id IS NULL)
427: AND (X_Assignment_Id IS NULL)))

Line 674: hr_utility.set_location('per_assignments_v7_pkg.lock_row',30);

670: else
671: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
672: APP_EXCEPTION.RAISE_EXCEPTION;
673: end if;
674: hr_utility.set_location('per_assignments_v7_pkg.lock_row',30);
675: END Lock_Row;
676: PROCEDURE Update_Row(X_Rowid VARCHAR2,
677: X_Assignment_Id NUMBER,
678: X_Effective_Start_Date DATE,

Line 772: hr_utility.set_location('per_assignments_v7_pkg.update_row',10);

768: --
769: l_old_org_id per_all_assignments_f.organization_id%TYPE;
770: --
771: BEGIN
772: hr_utility.set_location('per_assignments_v7_pkg.update_row',10);
773: if X_Current_application_id = 810
774: then
775: hr_utility.set_location('per_assignments_v7_pkg.update_row',20);
776: per_assignments_v7_pkg.get_future_changes(X_assignment_id

Line 775: hr_utility.set_location('per_assignments_v7_pkg.update_row',20);

771: BEGIN
772: hr_utility.set_location('per_assignments_v7_pkg.update_row',10);
773: if X_Current_application_id = 810
774: then
775: hr_utility.set_location('per_assignments_v7_pkg.update_row',20);
776: per_assignments_v7_pkg.get_future_changes(X_assignment_id
777: ,X_effective_start_date
778: ,X_Current_application_id);
779: hr_utility.set_location('per_assignments_v7_pkg.update_row',30);

Line 776: per_assignments_v7_pkg.get_future_changes(X_assignment_id

772: hr_utility.set_location('per_assignments_v7_pkg.update_row',10);
773: if X_Current_application_id = 810
774: then
775: hr_utility.set_location('per_assignments_v7_pkg.update_row',20);
776: per_assignments_v7_pkg.get_future_changes(X_assignment_id
777: ,X_effective_start_date
778: ,X_Current_application_id);
779: hr_utility.set_location('per_assignments_v7_pkg.update_row',30);
780: end if;

Line 779: hr_utility.set_location('per_assignments_v7_pkg.update_row',30);

775: hr_utility.set_location('per_assignments_v7_pkg.update_row',20);
776: per_assignments_v7_pkg.get_future_changes(X_assignment_id
777: ,X_effective_start_date
778: ,X_Current_application_id);
779: hr_utility.set_location('per_assignments_v7_pkg.update_row',30);
780: end if;
781: --
782: -- get the current organization
783: --

Line 789: hr_utility.set_location('per_assignments_v7_pkg.update_row',40);

785: fetch org into l_old_org_id;
786: if org%NOTFOUND then
787: close org;
788: else
789: hr_utility.set_location('per_assignments_v7_pkg.update_row',40);
790: close org;
791: end if;
792: --
793: hr_utility.set_location('per_assignments_v7_pkg.update_row',50);

Line 793: hr_utility.set_location('per_assignments_v7_pkg.update_row',50);

789: hr_utility.set_location('per_assignments_v7_pkg.update_row',40);
790: close org;
791: end if;
792: --
793: hr_utility.set_location('per_assignments_v7_pkg.update_row',50);
794: UPDATE PER_ASSIGNMENTS_F
795: SET
796: assignment_id = X_Assignment_Id,
797: effective_start_date = X_Effective_Start_Date,

Line 883: hr_utility.set_location('per_assignments_v7_pkg.update_row',60);

879: WHERE rowid = X_rowid;
880: if (SQL%NOTFOUND) then
881: RAISE NO_DATA_FOUND;
882: end if;
883: hr_utility.set_location('per_assignments_v7_pkg.update_row',60);
884: --
885: -- update the security lists
886: --
887: if (l_old_org_id = X_Business_Group_Id

Line 889: hr_utility.set_location('per_assignments_v7_pkg.update_row',70);

885: -- update the security lists
886: --
887: if (l_old_org_id = X_Business_Group_Id
888: and X_Organization_Id <> X_Business_Group_Id) then
889: hr_utility.set_location('per_assignments_v7_pkg.update_row',70);
890: hr_security_internal.clear_from_person_list(X_Person_Id);
891: end if;
892: hr_utility.set_location('per_assignments_v7_pkg.update_row',80);
893: --2468956: change the date from sysdate to x_effective_start_date in following

Line 892: hr_utility.set_location('per_assignments_v7_pkg.update_row',80);

888: and X_Organization_Id <> X_Business_Group_Id) then
889: hr_utility.set_location('per_assignments_v7_pkg.update_row',70);
890: hr_security_internal.clear_from_person_list(X_Person_Id);
891: end if;
892: hr_utility.set_location('per_assignments_v7_pkg.update_row',80);
893: --2468956: change the date from sysdate to x_effective_start_date in following
894: hr_security_internal.add_to_person_list(X_Effective_Start_Date,X_Assignment_Id);
895: hr_utility.set_location('per_assignments_v7_pkg.update_row',90);
896: --

Line 895: hr_utility.set_location('per_assignments_v7_pkg.update_row',90);

891: end if;
892: hr_utility.set_location('per_assignments_v7_pkg.update_row',80);
893: --2468956: change the date from sysdate to x_effective_start_date in following
894: hr_security_internal.add_to_person_list(X_Effective_Start_Date,X_Assignment_Id);
895: hr_utility.set_location('per_assignments_v7_pkg.update_row',90);
896: --
897: END Update_Row;
898: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
899: BEGIN

Line 900: hr_utility.set_location('per_assignments_v7_pkg.delete_row',10);

896: --
897: END Update_Row;
898: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
899: BEGIN
900: hr_utility.set_location('per_assignments_v7_pkg.delete_row',10);
901: DELETE FROM PER_ASSIGNMENTS_F
902: WHERE rowid = X_Rowid;
903: if (SQL%NOTFOUND) then
904: RAISE NO_DATA_FOUND;

Line 906: hr_utility.set_location('per_assignments_v7_pkg.delete_row',20);

902: WHERE rowid = X_Rowid;
903: if (SQL%NOTFOUND) then
904: RAISE NO_DATA_FOUND;
905: end if;
906: hr_utility.set_location('per_assignments_v7_pkg.delete_row',20);
907: END Delete_Row;
908: --
909: PROCEDURE get_location_address (X_location_id NUMBER
910: ,X_Address_Line_1 IN OUT NOCOPY VARCHAR2

Line 1138: END PER_ASSIGNMENTS_V7_PKG;

1134: --
1135: end if;
1136: close get_future_changes;
1137: end;
1138: END PER_ASSIGNMENTS_V7_PKG;