1 PACKAGE PER_BULK_APP_ASG_CHANGE_PKG AUTHID CURRENT_USER AS
2 /* $Header: peasg03t.pkh 115.3 2003/01/15 19:08:40 asahay ship $ */
3 -- Name
4 -- get_db_defaults
5 -- Purpose
6 -- Retrieve database default values needed at form startup
7 -- Arguments
8 -- p_business_group_id
9 -- p_grade_structure -- bg structure id
10 -- p_people_group_structure -- bg structure id
11 -- p_job_structure -- bg structure id
12 -- p_postion_structure -- bg structure id
13 procedure get_db_defaults ( p_business_group_id in number,
14 p_grade_structure in out nocopy number,
15 p_people_group_structure in out nocopy number,
16 p_job_structure in out nocopy number,
17 p_position_structure in out nocopy number ) ;
18 --
19 -- Name
20 -- validate_asg_change
21 -- Purpose
22 -- Validates a change to an applicant assignment
23 -- The change can be one of the following :
24 -- Assignment Status
25 -- Recruiter
26 -- Will raise an error and set message if the change is disallowed.
27 --
28 -- Parameters
29 -- p_application_id
30 -- p_person_id
31 -- p_assignment_id
32 -- p_status_changed Has the status changed.
33 -- p_new_system_status e.g. TERM_APL
34 -- p_new_asg_status_type_id
35 -- p_recruiter_id
36 -- p_dt_update_mode DateTrack Update mode ie UPDATE
37 -- or correction
38 -- p_business_group_id
39 --
40 -- Notes
41 --
42 procedure validate_asg_change ( p_application_id in number,
43 p_person_id in number,
44 p_assignment_id in number,
45 p_status_changed in boolean,
46 p_new_system_status in varchar2,
47 p_new_asg_status_type_id in number,
48 p_recruiter_id in number,
49 p_dt_update_mode in varchar2,
50 p_business_group_id in number) ;
51 --
52 -- Name
53 -- update_row
54 -- Purpose
55 -- Updates the given applicant assignment row.
56 -- The change can be one of the following :
57 -- Assignment Status
58 -- Recruiter
59 -- Will raise an error and set message if the change is disallowed.
60 --
61 -- Parameters
62 -- p_application_id
63 -- p_person_id
64 -- p_assignment_id
65 -- p_status_changed
66 -- p_new_system_status e.g. TERM_APL
67 -- p_new_asg_status_type_id
68 -- p_recruiter_id
69 -- p_dt_update_mode DateTrack Update mode ie UPDATE
70 -- or correction
71 -- p_effective_date Session Date
75 --
72 -- p_effective_start_date Effective Start of Row to be updated.
73 -- p_validation_start_date DateTrack Validation Start Date
74 -- p_business_group_id
76 -- Notes
77 -- Calls validate_asg_change before performing the update.
78 -- Datetrack handles the creation of the extra row for UPDATE mode.
79 procedure update_row ( p_rowid in varchar2,
80 p_application_id in number,
81 p_person_id in number,
82 p_assignment_id in number,
83 p_status_changed in boolean,
84 p_new_system_status in varchar2,
85 p_new_asg_status_type_id in number,
86 p_recruiter_id in number,
87 p_dt_update_mode in varchar2,
88 p_effective_date in date,
89 p_effective_start_date in date,
90 p_validation_start_date in date,
91 p_business_group_id in number) ;
92 --
93 END PER_BULK_APP_ASG_CHANGE_PKG ;