[Home] [Help]
PACKAGE: APPS.HXT_GEN_AAI
Source
1 PACKAGE HXT_GEN_AAI AUTHID CURRENT_USER AS
2 /* $Header: hxtgenai.pkh 115.3 2003/09/09 09:55:53 mhanda ship $ */
3
4 ------------------------------------------------------------------------------
5
6 PROCEDURE AAI_VALIDATIONS
7 (p_assignment_id NUMBER
8 ,p_earning_policy NUMBER
9 ,p_rotation_plan NUMBER
10 ,p_shift_differential_policy NUMBER
11 ,p_hour_deduction_policy NUMBER
12 ,p_autogen_hours_yn VARCHAR2
13 ,p_effective_start_date DATE
14 );
15
16 ------------------------------------------------------------------------------
17
18 --The purpose of this procedure is to INSERT a row for the additional
19 --assignment information
20
21 --Arguments
22 -- Arguments
23 -- p_id -ID of the record.
24 -- p_effective_start_date -effective_start_date for the record to be
25 -- -inserted.
26 -- p_assignment_id -id of the assignment for which the information
27 -- -has to be added.
28 -- p_autogen_hours_yn -The value for this argument can be either
29 -- -'Y' or 'N',to specify whether to autogen
30 -- -the hours for this assignment
31 --p_rotation_plan -rotation_plan_id for this assignment
32 --p_earning_policy -earning_policy_id for this assignment
33 --p_shift_differential_policy -shift_differential_policy_id for this
34 -- -assignment
35 --p_hour_deduction_policy -hour_deduction_policy_id for this assignment
36 --p_attribute1 .. p_attribute30 -attribute values
37
38 PROCEDURE Create_Otlr_Add_Assign_Info
39 (p_id NUMBER
40 ,p_effective_start_date DATE
41 -- ,p_effective_end_date DATE
42 ,p_assignment_id NUMBER
43 ,p_autogen_hours_yn VARCHAR2
44 ,p_rotation_plan NUMBER DEFAULT NULL
45 ,p_earning_policy NUMBER
46 ,p_shift_differential_policy NUMBER DEFAULT NULL
47 ,p_hour_deduction_policy NUMBER DEFAULT NULL
48 ,p_created_by NUMBER
49 ,p_creation_date DATE
50 ,p_last_updated_by NUMBER
51 ,p_last_update_date DATE
52 ,p_last_update_login NUMBER
53 ,p_attribute_category VARCHAR2 DEFAULT NULL
54 ,p_attribute1 VARCHAR2 DEFAULT NULL
55 ,p_attribute2 VARCHAR2 DEFAULT NULL
56 ,p_attribute3 VARCHAR2 DEFAULT NULL
57 ,p_attribute4 VARCHAR2 DEFAULT NULL
58 ,p_attribute5 VARCHAR2 DEFAULT NULL
59 ,p_attribute6 VARCHAR2 DEFAULT NULL
60 ,p_attribute7 VARCHAR2 DEFAULT NULL
61 ,p_attribute8 VARCHAR2 DEFAULT NULL
62 ,p_attribute9 VARCHAR2 DEFAULT NULL
63 ,p_attribute10 VARCHAR2 DEFAULT NULL
64 ,p_attribute11 VARCHAR2 DEFAULT NULL
65 ,p_attribute12 VARCHAR2 DEFAULT NULL
66 ,p_attribute13 VARCHAR2 DEFAULT NULL
67 ,p_attribute14 VARCHAR2 DEFAULT NULL
68 ,p_attribute15 VARCHAR2 DEFAULT NULL
69 ,p_attribute16 VARCHAR2 DEFAULT NULL
70 ,p_attribute17 VARCHAR2 DEFAULT NULL
71 ,p_attribute18 VARCHAR2 DEFAULT NULL
72 ,p_attribute19 VARCHAR2 DEFAULT NULL
73 ,p_attribute20 VARCHAR2 DEFAULT NULL
74 ,p_attribute21 VARCHAR2 DEFAULT NULL
75 ,p_attribute22 VARCHAR2 DEFAULT NULL
76 ,p_attribute23 VARCHAR2 DEFAULT NULL
77 ,p_attribute24 VARCHAR2 DEFAULT NULL
78 ,p_attribute25 VARCHAR2 DEFAULT NULL
79 ,p_attribute26 VARCHAR2 DEFAULT NULL
80 ,p_attribute27 VARCHAR2 DEFAULT NULL
81 ,p_attribute28 VARCHAR2 DEFAULT NULL
82 ,p_attribute29 VARCHAR2 DEFAULT NULL
83 ,p_attribute30 VARCHAR2 DEFAULT NULL
84 );
85
86 ------------------------------------------------------------------------------
87
88 -- The purpose of this procedure is to perform 'CORRECTION' and
89 -- 'UPDATE_OVERRIDE' for the additional assignment information.This procedure
90 -- when run in an 'UPDATE_OVERRIDE' mode would override the future changes
91
92 -- Arguments
93 -- p_id - ID of the record.
94 -- p_datetrack_mode -The mode in which the api has to be run.
95 -- -It can be run in 'CORRECTION' or
96 -- -'UPDATE_OVERRIDE' mode.
97 -- p_effective_date -The record will be updated as of this date.
98 -- p_effective_start_date -effective_start_date of the record for this
99 -- -assignment that has effective_end_date as
100 -- -end_of_time.
101 -- p_assignment_id -assignment_id for which the update has to be
102 -- -done.
103 -- p_autogen_hours_yn -The value for this argument can be either
104 -- -'Y' or 'N',to specify whether to autogen
105 -- -the hours for this assignment.
106 --p_rotation_plan -rotation_plan_id for this assignment.
107 --p_earning_policy -earning_policy_id for this assignment.
108 --p_shift_differential_policy -shift_differential_policy_id for this
109 -- -assignment.
110 --p_hour_deduction_policy -hour_deduction_policy_id for this assignment.
111 --p_attribute1 .. p_attribute30 -attribute values.
112
113 PROCEDURE Update_Otlr_Add_Assign_Info
114 (p_id NUMBER
115 ,p_datetrack_mode VARCHAR2
116 ,p_effective_date DATE
117 ,p_effective_start_date DATE
118 --,p_effective_end_date DATE
119 ,p_assignment_id NUMBER
120 ,p_autogen_hours_yn VARCHAR2
121 ,p_rotation_plan NUMBER DEFAULT NULL
122 ,p_earning_policy NUMBER
123 ,p_shift_differential_policy NUMBER DEFAULT NULL
124 ,p_hour_deduction_policy NUMBER DEFAULT NULL
125 ,p_created_by NUMBER
126 ,p_creation_date DATE
127 ,p_last_updated_by NUMBER
128 ,p_last_update_date DATE
129 ,p_last_update_login NUMBER
130 ,p_attribute_category VARCHAR2 DEFAULT NULL
131 ,p_attribute1 VARCHAR2 DEFAULT NULL
132 ,p_attribute2 VARCHAR2 DEFAULT NULL
133 ,p_attribute3 VARCHAR2 DEFAULT NULL
134 ,p_attribute4 VARCHAR2 DEFAULT NULL
135 ,p_attribute5 VARCHAR2 DEFAULT NULL
136 ,p_attribute6 VARCHAR2 DEFAULT NULL
137 ,p_attribute7 VARCHAR2 DEFAULT NULL
138 ,p_attribute8 VARCHAR2 DEFAULT NULL
139 ,p_attribute9 VARCHAR2 DEFAULT NULL
140 ,p_attribute10 VARCHAR2 DEFAULT NULL
141 ,p_attribute11 VARCHAR2 DEFAULT NULL
142 ,p_attribute12 VARCHAR2 DEFAULT NULL
143 ,p_attribute13 VARCHAR2 DEFAULT NULL
144 ,p_attribute14 VARCHAR2 DEFAULT NULL
145 ,p_attribute15 VARCHAR2 DEFAULT NULL
146 ,p_attribute16 VARCHAR2 DEFAULT NULL
147 ,p_attribute17 VARCHAR2 DEFAULT NULL
148 ,p_attribute18 VARCHAR2 DEFAULT NULL
149 ,p_attribute19 VARCHAR2 DEFAULT NULL
150 ,p_attribute20 VARCHAR2 DEFAULT NULL
151 ,p_attribute21 VARCHAR2 DEFAULT NULL
152 ,p_attribute22 VARCHAR2 DEFAULT NULL
153 ,p_attribute23 VARCHAR2 DEFAULT NULL
154 ,p_attribute24 VARCHAR2 DEFAULT NULL
155 ,p_attribute25 VARCHAR2 DEFAULT NULL
156 ,p_attribute26 VARCHAR2 DEFAULT NULL
157 ,p_attribute27 VARCHAR2 DEFAULT NULL
158 ,p_attribute28 VARCHAR2 DEFAULT NULL
159 ,p_attribute29 VARCHAR2 DEFAULT NULL
160 ,p_attribute30 VARCHAR2 DEFAULT NULL
161 );
162
163 ------------------------------------------------------------------------------
164
165 END HXT_GEN_AAI;