DBA Data[Home] [Help]

APPS.PER_ASSIGNMENTS_V8_PKG dependencies on PER_ASSIGNMENTS_V8_PKG

Line 1: PACKAGE BODY PER_ASSIGNMENTS_V8_PKG as

1: PACKAGE BODY PER_ASSIGNMENTS_V8_PKG as
2: /* $Header: peasg08t.pkb 120.1 2006/01/23 06:35:44 eumenyio 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 120: per_assignments_v8_pkg.delete_record(X_ROWID);

116: open C;
117: fetch C into X_Rowid;
118: if C%FOUND
119: then
120: per_assignments_v8_pkg.delete_record(X_ROWID);
121: end if;
122: --
123:
124: hr_utility.set_location('Enterring:per_assignments_v8_pkg.insert_row',10);

Line 124: hr_utility.set_location('Enterring:per_assignments_v8_pkg.insert_row',10);

120: per_assignments_v8_pkg.delete_record(X_ROWID);
121: end if;
122: --
123:
124: hr_utility.set_location('Enterring:per_assignments_v8_pkg.insert_row',10);
125:
126: INSERT INTO PER_ASSIGNMENTS_F(
127: assignment_id,
128: effective_start_date,

Line 716: per_assignments_v8_pkg.validate_effective_start(p_effective_start_date

712: begin
713: --
714: -- check the date is valid.
715: --
716: per_assignments_v8_pkg.validate_effective_start(p_effective_start_date
717: ,p_person_id
718: ,p_period_of_service_id);
719: open get_asg_of_start_date;
720: fetch get_asg_of_start_date into ass_rec;

Line 984: END PER_ASSIGNMENTS_V8_PKG;

980: to_char(p_termination_date,'DD-MON-YYYY'));
981: HR_UTILITY.RAISE_ERROR;
982: end if;
983: end;
984: END PER_ASSIGNMENTS_V8_PKG;