1 PACKAGE per_get_elig AS
2 -- $Header: perellst.pkh 120.0 2005/05/31 17:36:24 appldev noship $
3
4 ----------------------------------------------------------------------------
5 --
6 -- Purpose:-
7 --
8 -- List the Eligibility Objects that the given Person Assignment
9 -- is eligible for.
10 --
11 -- Parameters:-
12 --
13 -- P_PERSON_ID = Identifier of person for whom eligible objects
14 -- are required to be listed.
15 -- P_ASSIGNMENT_ID = Identifier of assignment for which eligible objects
16 -- are required to be listed. If null, objects are
17 -- listed for all the assignments.
18 -- P_EFFECTIVE_DATE = Effective date for testing eligibility.
19 -- P_TABLE_NAME = Eligibility object type.
20 -- P_DATA_MODE = 'L' for Live date (default)
21 -- 'C' for Cached data.
22 -- X_ELIGIBLE_OBJECT = VARRAY listing eligible object details.
23 -- X_RETURN_STATUS = '0' = success, '1' = warning, '2' = error.
24 -- X_RETURN_MESSAGE = Message in case of return status '1' or '2'.
25 --
26 ----------------------------------------------------------------------------
27 PROCEDURE get_elig_obj_for_per_asg( p_person_id IN NUMBER
28 , p_assignment_id IN NUMBER DEFAULT NULL
29 , p_effective_date IN DATE
30 , p_table_name IN VARCHAR2
31 , p_data_mode IN VARCHAR2 DEFAULT NULL
32 , x_eligible_object OUT NOCOPY per_elig_obj_varray
33 , x_return_status OUT NOCOPY NUMBER
34 , x_return_message OUT NOCOPY VARCHAR2
35 );
36
37 ----------------------------------------------------------------------------
38 --
39 -- Purpose:-
40 --
41 -- List the Person Assignment that are eligible for the given
42 -- Eligibility Object.
43 --
44 -- Parameters:-
45 --
46 -- P_TABLE_NAME = Eligibility object type.
47 -- P_COLUMN_NAME = Key column for eligibility object type.
48 -- P_COLUMN_VALUE = Eligibility object instance.
49 -- P_EFFECTIVE_DATE = Effective date for testing eligibility.
50 -- P_BUSINESS_GROUP_ID = Business group identifier to which the listed
51 -- person assignments should belong.
52 -- P_DATA_MODE = 'L' for Live date (default)
53 -- 'C' for Cached data.
54 -- P_PERSON_ASSIGNMENT = VARRAY listing person assignment details.
55 -- X_RETURN_STATUS = '0' = success, '1' = warning, '2' = error.
56 -- X_RETURN_MESSAGE = Message in case of return status '1' or '2'.
57 --
58 ----------------------------------------------------------------------------
59 PROCEDURE get_per_asg_for_elig_obj( p_table_name IN VARCHAR2
60 , p_column_name IN VARCHAR2
61 , p_column_value IN VARCHAR2
62 , p_effective_date IN DATE
63 , p_business_group_id IN NUMBER
64 , p_data_mode IN VARCHAR2 DEFAULT NULL
65 , x_person_assignment OUT NOCOPY per_asg_varray
66 , x_return_status OUT NOCOPY NUMBER
67 , x_return_message OUT NOCOPY VARCHAR2
68 );
69
70 ----------------------------------------------------------------------------
71 --
72 -- Purpose:-
73 --
74 -- List the Work Schedules that the given Person Assignment
75 -- is eligible for.
76 --
77 -- Parameters:-
78 --
79 -- P_PERSON_ID = Identifier of person for whom work schedules are
80 -- required to be listed.
81 -- P_ASSIGNMENT_ID = Identifier of assignment for which work schedules
82 -- are required to be listed. If null, schedules are
83 -- listed for all the assignments.
84 -- P_EFFECTIVE_DATE = Effective date for testing eligibility.
85 -- P_DATA_MODE = 'L' for Live date (default)
86 -- 'C' for Cached data.
87 -- X_SCHEDULE = VARRAY listing eligible work schedule details.
88 -- X_RETURN_STATUS = '0' = success, '1' = warning, '2' = error.
89 -- X_RETURN_MESSAGE = Message in case of return status '1' or '2'.
90 --
91 ----------------------------------------------------------------------------
92 PROCEDURE get_sch_for_per_asg( p_person_id IN NUMBER
93 , p_assignment_id IN NUMBER DEFAULT NULL
94 , p_effective_date IN DATE
95 , p_data_mode IN VARCHAR2 DEFAULT NULL
96 , x_schedule OUT NOCOPY per_work_sch_varray
97 , x_return_status OUT NOCOPY NUMBER
98 , x_return_message OUT NOCOPY VARCHAR2
99 );
100
101 ----------------------------------------------------------------------------
102 --
103 -- Purpose:-
104 --
105 -- List the Person Assignment that are eligible for the given
106 -- Schedule.
107 --
108 -- Parameters:-
109 --
110 -- P_SCHEDULE_CATEGORY = Work schedule category.
111 -- P_SCHEDULE_NAME = Work schedule name.
112 -- P_EFFECTIVE_DATE = Effective date for testing eligibility.
113 -- P_BUSINESS_GROUP_ID = Business group identifier to which the listed
114 -- person assignments should belong.
115 -- P_DATA_MODE = 'L' for Live date (default)
116 -- 'C' for Cached data.
117 -- P_PERSON_ASSIGNMENT = VARRAY listing person assignment details.
118 -- X_RETURN_STATUS = '0' = success, '1' = warning, '2' = error.
119 -- X_RETURN_MESSAGE = Message in case of return status '1' or '2'.
120 --
121 ----------------------------------------------------------------------------
122 PROCEDURE get_per_asg_for_sch( p_schedule_category IN VARCHAR2
123 , p_schedule_name IN VARCHAR2
124 , p_effective_date IN DATE
125 , p_business_group_id IN NUMBER
126 , p_data_mode IN VARCHAR2 DEFAULT NULL
127 , x_person_assignment OUT NOCOPY per_asg_varray
128 , x_return_status OUT NOCOPY NUMBER
129 , x_return_message OUT NOCOPY VARCHAR2
130 );
131
132 END per_get_elig;