[Home] [Help]
16: -- p_rec plsql record structure
17: -- to see if a system default is being used. If a system default
18: -- is being used then we must set to the 'current' argument value.
19: --
20: If (p_rec.assignment_id = hr_api.g_number) then
21: p_rec.assignment_id :=
22: pqp_val_shd.g_old_rec.assignment_id;
23: End If;
24: If (p_rec.business_group_id = hr_api.g_number) then
20: If (p_rec.assignment_id = hr_api.g_number) then
21: p_rec.assignment_id :=
22: pqp_val_shd.g_old_rec.assignment_id;
23: End If;
24: If (p_rec.business_group_id = hr_api.g_number) then
25: p_rec.business_group_id :=
26: pqp_val_shd.g_old_rec.business_group_id;
27: End If;
28: If (p_rec.across_assignments = hr_api.g_varchar2) then
24: If (p_rec.business_group_id = hr_api.g_number) then
25: p_rec.business_group_id :=
26: pqp_val_shd.g_old_rec.business_group_id;
27: End If;
28: If (p_rec.across_assignments = hr_api.g_varchar2) then
29: p_rec.across_assignments :=
30: pqp_val_shd.g_old_rec.across_assignments;
31: End If;
32: If (p_rec.vehicle_repository_id = hr_api.g_number) then
28: If (p_rec.across_assignments = hr_api.g_varchar2) then
29: p_rec.across_assignments :=
30: pqp_val_shd.g_old_rec.across_assignments;
31: End If;
32: If (p_rec.vehicle_repository_id = hr_api.g_number) then
33: p_rec.vehicle_repository_id :=
34: pqp_val_shd.g_old_rec.vehicle_repository_id;
35: End If;
36: If (p_rec.usage_type = hr_api.g_varchar2) then
32: If (p_rec.vehicle_repository_id = hr_api.g_number) then
33: p_rec.vehicle_repository_id :=
34: pqp_val_shd.g_old_rec.vehicle_repository_id;
35: End If;
36: If (p_rec.usage_type = hr_api.g_varchar2) then
37: p_rec.usage_type :=
38: pqp_val_shd.g_old_rec.usage_type;
39: End If;
40: If (p_rec.capital_contribution = hr_api.g_number) then
36: If (p_rec.usage_type = hr_api.g_varchar2) then
37: p_rec.usage_type :=
38: pqp_val_shd.g_old_rec.usage_type;
39: End If;
40: If (p_rec.capital_contribution = hr_api.g_number) then
41: p_rec.capital_contribution :=
42: pqp_val_shd.g_old_rec.capital_contribution;
43: End If;
44: If (p_rec.private_contribution = hr_api.g_number) then
40: If (p_rec.capital_contribution = hr_api.g_number) then
41: p_rec.capital_contribution :=
42: pqp_val_shd.g_old_rec.capital_contribution;
43: End If;
44: If (p_rec.private_contribution = hr_api.g_number) then
45: p_rec.private_contribution :=
46: pqp_val_shd.g_old_rec.private_contribution;
47: End If;
48: If (p_rec.default_vehicle = hr_api.g_varchar2) then
44: If (p_rec.private_contribution = hr_api.g_number) then
45: p_rec.private_contribution :=
46: pqp_val_shd.g_old_rec.private_contribution;
47: End If;
48: If (p_rec.default_vehicle = hr_api.g_varchar2) then
49: p_rec.default_vehicle :=
50: pqp_val_shd.g_old_rec.default_vehicle;
51: End If;
52: If (p_rec.fuel_card = hr_api.g_varchar2) then
48: If (p_rec.default_vehicle = hr_api.g_varchar2) then
49: p_rec.default_vehicle :=
50: pqp_val_shd.g_old_rec.default_vehicle;
51: End If;
52: If (p_rec.fuel_card = hr_api.g_varchar2) then
53: p_rec.fuel_card :=
54: pqp_val_shd.g_old_rec.fuel_card;
55: End If;
56: If (p_rec.fuel_card_number = hr_api.g_varchar2) then
52: If (p_rec.fuel_card = hr_api.g_varchar2) then
53: p_rec.fuel_card :=
54: pqp_val_shd.g_old_rec.fuel_card;
55: End If;
56: If (p_rec.fuel_card_number = hr_api.g_varchar2) then
57: p_rec.fuel_card_number :=
58: pqp_val_shd.g_old_rec.fuel_card_number;
59: End If;
60: If (p_rec.calculation_method = hr_api.g_varchar2) then
56: If (p_rec.fuel_card_number = hr_api.g_varchar2) then
57: p_rec.fuel_card_number :=
58: pqp_val_shd.g_old_rec.fuel_card_number;
59: End If;
60: If (p_rec.calculation_method = hr_api.g_varchar2) then
61: p_rec.calculation_method :=
62: pqp_val_shd.g_old_rec.calculation_method;
63: End If;
64: If (p_rec.rates_table_id = hr_api.g_number) then
60: If (p_rec.calculation_method = hr_api.g_varchar2) then
61: p_rec.calculation_method :=
62: pqp_val_shd.g_old_rec.calculation_method;
63: End If;
64: If (p_rec.rates_table_id = hr_api.g_number) then
65: p_rec.rates_table_id :=
66: pqp_val_shd.g_old_rec.rates_table_id;
67: End If;
68: If (p_rec.element_type_id = hr_api.g_number) then
64: If (p_rec.rates_table_id = hr_api.g_number) then
65: p_rec.rates_table_id :=
66: pqp_val_shd.g_old_rec.rates_table_id;
67: End If;
68: If (p_rec.element_type_id = hr_api.g_number) then
69: p_rec.element_type_id :=
70: pqp_val_shd.g_old_rec.element_type_id;
71: End If;
72: If (p_rec.private_use_flag = hr_api.g_varchar2) then
68: If (p_rec.element_type_id = hr_api.g_number) then
69: p_rec.element_type_id :=
70: pqp_val_shd.g_old_rec.element_type_id;
71: End If;
72: If (p_rec.private_use_flag = hr_api.g_varchar2) then
73: p_rec.private_use_flag :=
74: pqp_val_shd.g_old_rec.private_use_flag;
75: End If;
76: If (p_rec.insurance_number = hr_api.g_varchar2) then
72: If (p_rec.private_use_flag = hr_api.g_varchar2) then
73: p_rec.private_use_flag :=
74: pqp_val_shd.g_old_rec.private_use_flag;
75: End If;
76: If (p_rec.insurance_number = hr_api.g_varchar2) then
77: p_rec.insurance_number :=
78: pqp_val_shd.g_old_rec.insurance_number;
79: End If;
80: If (p_rec.insurance_expiry_date = hr_api.g_date) then
76: If (p_rec.insurance_number = hr_api.g_varchar2) then
77: p_rec.insurance_number :=
78: pqp_val_shd.g_old_rec.insurance_number;
79: End If;
80: If (p_rec.insurance_expiry_date = hr_api.g_date) then
81: p_rec.insurance_expiry_date :=
82: pqp_val_shd.g_old_rec.insurance_expiry_date;
83: End If;
84:
81: p_rec.insurance_expiry_date :=
82: pqp_val_shd.g_old_rec.insurance_expiry_date;
83: End If;
84:
85: If (p_rec.val_attribute_category = hr_api.g_varchar2) then
86: p_rec.val_attribute_category :=
87: pqp_val_shd.g_old_rec.val_attribute_category;
88: End If;
89: If (p_rec.val_attribute1 = hr_api.g_varchar2) then
85: If (p_rec.val_attribute_category = hr_api.g_varchar2) then
86: p_rec.val_attribute_category :=
87: pqp_val_shd.g_old_rec.val_attribute_category;
88: End If;
89: If (p_rec.val_attribute1 = hr_api.g_varchar2) then
90: p_rec.val_attribute1 :=
91: pqp_val_shd.g_old_rec.val_attribute1;
92: End If;
93: If (p_rec.val_attribute2 = hr_api.g_varchar2) then
89: If (p_rec.val_attribute1 = hr_api.g_varchar2) then
90: p_rec.val_attribute1 :=
91: pqp_val_shd.g_old_rec.val_attribute1;
92: End If;
93: If (p_rec.val_attribute2 = hr_api.g_varchar2) then
94: p_rec.val_attribute2 :=
95: pqp_val_shd.g_old_rec.val_attribute2;
96: End If;
97: If (p_rec.val_attribute3 = hr_api.g_varchar2) then
93: If (p_rec.val_attribute2 = hr_api.g_varchar2) then
94: p_rec.val_attribute2 :=
95: pqp_val_shd.g_old_rec.val_attribute2;
96: End If;
97: If (p_rec.val_attribute3 = hr_api.g_varchar2) then
98: p_rec.val_attribute3 :=
99: pqp_val_shd.g_old_rec.val_attribute3;
100: End If;
101: If (p_rec.val_attribute4 = hr_api.g_varchar2) then
97: If (p_rec.val_attribute3 = hr_api.g_varchar2) then
98: p_rec.val_attribute3 :=
99: pqp_val_shd.g_old_rec.val_attribute3;
100: End If;
101: If (p_rec.val_attribute4 = hr_api.g_varchar2) then
102: p_rec.val_attribute4 :=
103: pqp_val_shd.g_old_rec.val_attribute4;
104: End If;
105: If (p_rec.val_attribute5 = hr_api.g_varchar2) then
101: If (p_rec.val_attribute4 = hr_api.g_varchar2) then
102: p_rec.val_attribute4 :=
103: pqp_val_shd.g_old_rec.val_attribute4;
104: End If;
105: If (p_rec.val_attribute5 = hr_api.g_varchar2) then
106: p_rec.val_attribute5 :=
107: pqp_val_shd.g_old_rec.val_attribute5;
108: End If;
109: If (p_rec.val_attribute6 = hr_api.g_varchar2) then
105: If (p_rec.val_attribute5 = hr_api.g_varchar2) then
106: p_rec.val_attribute5 :=
107: pqp_val_shd.g_old_rec.val_attribute5;
108: End If;
109: If (p_rec.val_attribute6 = hr_api.g_varchar2) then
110: p_rec.val_attribute6 :=
111: pqp_val_shd.g_old_rec.val_attribute6;
112: End If;
113: If (p_rec.val_attribute7 = hr_api.g_varchar2) then
109: If (p_rec.val_attribute6 = hr_api.g_varchar2) then
110: p_rec.val_attribute6 :=
111: pqp_val_shd.g_old_rec.val_attribute6;
112: End If;
113: If (p_rec.val_attribute7 = hr_api.g_varchar2) then
114: p_rec.val_attribute7 :=
115: pqp_val_shd.g_old_rec.val_attribute7;
116: End If;
117: If (p_rec.val_attribute8 = hr_api.g_varchar2) then
113: If (p_rec.val_attribute7 = hr_api.g_varchar2) then
114: p_rec.val_attribute7 :=
115: pqp_val_shd.g_old_rec.val_attribute7;
116: End If;
117: If (p_rec.val_attribute8 = hr_api.g_varchar2) then
118: p_rec.val_attribute8 :=
119: pqp_val_shd.g_old_rec.val_attribute8;
120: End If;
121: If (p_rec.val_attribute9 = hr_api.g_varchar2) then
117: If (p_rec.val_attribute8 = hr_api.g_varchar2) then
118: p_rec.val_attribute8 :=
119: pqp_val_shd.g_old_rec.val_attribute8;
120: End If;
121: If (p_rec.val_attribute9 = hr_api.g_varchar2) then
122: p_rec.val_attribute9 :=
123: pqp_val_shd.g_old_rec.val_attribute9;
124: End If;
125: If (p_rec.val_attribute10 = hr_api.g_varchar2) then
121: If (p_rec.val_attribute9 = hr_api.g_varchar2) then
122: p_rec.val_attribute9 :=
123: pqp_val_shd.g_old_rec.val_attribute9;
124: End If;
125: If (p_rec.val_attribute10 = hr_api.g_varchar2) then
126: p_rec.val_attribute10 :=
127: pqp_val_shd.g_old_rec.val_attribute10;
128: End If;
129: If (p_rec.val_attribute11 = hr_api.g_varchar2) then
125: If (p_rec.val_attribute10 = hr_api.g_varchar2) then
126: p_rec.val_attribute10 :=
127: pqp_val_shd.g_old_rec.val_attribute10;
128: End If;
129: If (p_rec.val_attribute11 = hr_api.g_varchar2) then
130: p_rec.val_attribute11 :=
131: pqp_val_shd.g_old_rec.val_attribute11;
132: End If;
133: If (p_rec.val_attribute12 = hr_api.g_varchar2) then
129: If (p_rec.val_attribute11 = hr_api.g_varchar2) then
130: p_rec.val_attribute11 :=
131: pqp_val_shd.g_old_rec.val_attribute11;
132: End If;
133: If (p_rec.val_attribute12 = hr_api.g_varchar2) then
134: p_rec.val_attribute12 :=
135: pqp_val_shd.g_old_rec.val_attribute12;
136: End If;
137: If (p_rec.val_attribute13 = hr_api.g_varchar2) then
133: If (p_rec.val_attribute12 = hr_api.g_varchar2) then
134: p_rec.val_attribute12 :=
135: pqp_val_shd.g_old_rec.val_attribute12;
136: End If;
137: If (p_rec.val_attribute13 = hr_api.g_varchar2) then
138: p_rec.val_attribute13 :=
139: pqp_val_shd.g_old_rec.val_attribute13;
140: End If;
141: If (p_rec.val_attribute14 = hr_api.g_varchar2) then
137: If (p_rec.val_attribute13 = hr_api.g_varchar2) then
138: p_rec.val_attribute13 :=
139: pqp_val_shd.g_old_rec.val_attribute13;
140: End If;
141: If (p_rec.val_attribute14 = hr_api.g_varchar2) then
142: p_rec.val_attribute14 :=
143: pqp_val_shd.g_old_rec.val_attribute14;
144: End If;
145: If (p_rec.val_attribute15 = hr_api.g_varchar2) then
141: If (p_rec.val_attribute14 = hr_api.g_varchar2) then
142: p_rec.val_attribute14 :=
143: pqp_val_shd.g_old_rec.val_attribute14;
144: End If;
145: If (p_rec.val_attribute15 = hr_api.g_varchar2) then
146: p_rec.val_attribute15 :=
147: pqp_val_shd.g_old_rec.val_attribute15;
148: End If;
149: If (p_rec.val_attribute16 = hr_api.g_varchar2) then
145: If (p_rec.val_attribute15 = hr_api.g_varchar2) then
146: p_rec.val_attribute15 :=
147: pqp_val_shd.g_old_rec.val_attribute15;
148: End If;
149: If (p_rec.val_attribute16 = hr_api.g_varchar2) then
150: p_rec.val_attribute16 :=
151: pqp_val_shd.g_old_rec.val_attribute16;
152: End If;
153: If (p_rec.val_attribute17 = hr_api.g_varchar2) then
149: If (p_rec.val_attribute16 = hr_api.g_varchar2) then
150: p_rec.val_attribute16 :=
151: pqp_val_shd.g_old_rec.val_attribute16;
152: End If;
153: If (p_rec.val_attribute17 = hr_api.g_varchar2) then
154: p_rec.val_attribute17 :=
155: pqp_val_shd.g_old_rec.val_attribute17;
156: End If;
157: If (p_rec.val_attribute18 = hr_api.g_varchar2) then
153: If (p_rec.val_attribute17 = hr_api.g_varchar2) then
154: p_rec.val_attribute17 :=
155: pqp_val_shd.g_old_rec.val_attribute17;
156: End If;
157: If (p_rec.val_attribute18 = hr_api.g_varchar2) then
158: p_rec.val_attribute18 :=
159: pqp_val_shd.g_old_rec.val_attribute18;
160: End If;
161: If (p_rec.val_attribute19 = hr_api.g_varchar2) then
157: If (p_rec.val_attribute18 = hr_api.g_varchar2) then
158: p_rec.val_attribute18 :=
159: pqp_val_shd.g_old_rec.val_attribute18;
160: End If;
161: If (p_rec.val_attribute19 = hr_api.g_varchar2) then
162: p_rec.val_attribute19 :=
163: pqp_val_shd.g_old_rec.val_attribute19;
164: End If;
165: If (p_rec.val_attribute20 = hr_api.g_varchar2) then
161: If (p_rec.val_attribute19 = hr_api.g_varchar2) then
162: p_rec.val_attribute19 :=
163: pqp_val_shd.g_old_rec.val_attribute19;
164: End If;
165: If (p_rec.val_attribute20 = hr_api.g_varchar2) then
166: p_rec.val_attribute20 :=
167: pqp_val_shd.g_old_rec.val_attribute20;
168: End If;
169: If (p_rec.val_information_category = hr_api.g_varchar2) then
165: If (p_rec.val_attribute20 = hr_api.g_varchar2) then
166: p_rec.val_attribute20 :=
167: pqp_val_shd.g_old_rec.val_attribute20;
168: End If;
169: If (p_rec.val_information_category = hr_api.g_varchar2) then
170: p_rec.val_information_category :=
171: pqp_val_shd.g_old_rec.val_information_category;
172: End If;
173: If (p_rec.val_information1 = hr_api.g_varchar2) then
169: If (p_rec.val_information_category = hr_api.g_varchar2) then
170: p_rec.val_information_category :=
171: pqp_val_shd.g_old_rec.val_information_category;
172: End If;
173: If (p_rec.val_information1 = hr_api.g_varchar2) then
174: p_rec.val_information1 :=
175: pqp_val_shd.g_old_rec.val_information1;
176: End If;
177: If (p_rec.val_information2 = hr_api.g_varchar2) then
173: If (p_rec.val_information1 = hr_api.g_varchar2) then
174: p_rec.val_information1 :=
175: pqp_val_shd.g_old_rec.val_information1;
176: End If;
177: If (p_rec.val_information2 = hr_api.g_varchar2) then
178: p_rec.val_information2 :=
179: pqp_val_shd.g_old_rec.val_information2;
180: End If;
181: If (p_rec.val_information3 = hr_api.g_varchar2) then
177: If (p_rec.val_information2 = hr_api.g_varchar2) then
178: p_rec.val_information2 :=
179: pqp_val_shd.g_old_rec.val_information2;
180: End If;
181: If (p_rec.val_information3 = hr_api.g_varchar2) then
182: p_rec.val_information3 :=
183: pqp_val_shd.g_old_rec.val_information3;
184: End If;
185: If (p_rec.val_information4 = hr_api.g_varchar2) then
181: If (p_rec.val_information3 = hr_api.g_varchar2) then
182: p_rec.val_information3 :=
183: pqp_val_shd.g_old_rec.val_information3;
184: End If;
185: If (p_rec.val_information4 = hr_api.g_varchar2) then
186: p_rec.val_information4 :=
187: pqp_val_shd.g_old_rec.val_information4;
188: End If;
189: If (p_rec.val_information5 = hr_api.g_varchar2) then
185: If (p_rec.val_information4 = hr_api.g_varchar2) then
186: p_rec.val_information4 :=
187: pqp_val_shd.g_old_rec.val_information4;
188: End If;
189: If (p_rec.val_information5 = hr_api.g_varchar2) then
190: p_rec.val_information5 :=
191: pqp_val_shd.g_old_rec.val_information5;
192: End If;
193: If (p_rec.val_information6 = hr_api.g_varchar2) then
189: If (p_rec.val_information5 = hr_api.g_varchar2) then
190: p_rec.val_information5 :=
191: pqp_val_shd.g_old_rec.val_information5;
192: End If;
193: If (p_rec.val_information6 = hr_api.g_varchar2) then
194: p_rec.val_information6 :=
195: pqp_val_shd.g_old_rec.val_information6;
196: End If;
197: If (p_rec.val_information7 = hr_api.g_varchar2) then
193: If (p_rec.val_information6 = hr_api.g_varchar2) then
194: p_rec.val_information6 :=
195: pqp_val_shd.g_old_rec.val_information6;
196: End If;
197: If (p_rec.val_information7 = hr_api.g_varchar2) then
198: p_rec.val_information7 :=
199: pqp_val_shd.g_old_rec.val_information7;
200: End If;
201: If (p_rec.val_information8 = hr_api.g_varchar2) then
197: If (p_rec.val_information7 = hr_api.g_varchar2) then
198: p_rec.val_information7 :=
199: pqp_val_shd.g_old_rec.val_information7;
200: End If;
201: If (p_rec.val_information8 = hr_api.g_varchar2) then
202: p_rec.val_information8 :=
203: pqp_val_shd.g_old_rec.val_information8;
204: End If;
205: If (p_rec.val_information9 = hr_api.g_varchar2) then
201: If (p_rec.val_information8 = hr_api.g_varchar2) then
202: p_rec.val_information8 :=
203: pqp_val_shd.g_old_rec.val_information8;
204: End If;
205: If (p_rec.val_information9 = hr_api.g_varchar2) then
206: p_rec.val_information9 :=
207: pqp_val_shd.g_old_rec.val_information9;
208: End If;
209: If (p_rec.val_information10 = hr_api.g_varchar2) then
205: If (p_rec.val_information9 = hr_api.g_varchar2) then
206: p_rec.val_information9 :=
207: pqp_val_shd.g_old_rec.val_information9;
208: End If;
209: If (p_rec.val_information10 = hr_api.g_varchar2) then
210: p_rec.val_information10 :=
211: pqp_val_shd.g_old_rec.val_information10;
212: End If;
213: If (p_rec.val_information11 = hr_api.g_varchar2) then
209: If (p_rec.val_information10 = hr_api.g_varchar2) then
210: p_rec.val_information10 :=
211: pqp_val_shd.g_old_rec.val_information10;
212: End If;
213: If (p_rec.val_information11 = hr_api.g_varchar2) then
214: p_rec.val_information11 :=
215: pqp_val_shd.g_old_rec.val_information11;
216: End If;
217: If (p_rec.val_information12 = hr_api.g_varchar2) then
213: If (p_rec.val_information11 = hr_api.g_varchar2) then
214: p_rec.val_information11 :=
215: pqp_val_shd.g_old_rec.val_information11;
216: End If;
217: If (p_rec.val_information12 = hr_api.g_varchar2) then
218: p_rec.val_information12 :=
219: pqp_val_shd.g_old_rec.val_information12;
220: End If;
221: If (p_rec.val_information13 = hr_api.g_varchar2) then
217: If (p_rec.val_information12 = hr_api.g_varchar2) then
218: p_rec.val_information12 :=
219: pqp_val_shd.g_old_rec.val_information12;
220: End If;
221: If (p_rec.val_information13 = hr_api.g_varchar2) then
222: p_rec.val_information13 :=
223: pqp_val_shd.g_old_rec.val_information13;
224: End If;
225: If (p_rec.val_information14 = hr_api.g_varchar2) then
221: If (p_rec.val_information13 = hr_api.g_varchar2) then
222: p_rec.val_information13 :=
223: pqp_val_shd.g_old_rec.val_information13;
224: End If;
225: If (p_rec.val_information14 = hr_api.g_varchar2) then
226: p_rec.val_information14 :=
227: pqp_val_shd.g_old_rec.val_information14;
228: End If;
229: If (p_rec.val_information15 = hr_api.g_varchar2) then
225: If (p_rec.val_information14 = hr_api.g_varchar2) then
226: p_rec.val_information14 :=
227: pqp_val_shd.g_old_rec.val_information14;
228: End If;
229: If (p_rec.val_information15 = hr_api.g_varchar2) then
230: p_rec.val_information15 :=
231: pqp_val_shd.g_old_rec.val_information15;
232: End If;
233: If (p_rec.val_information16 = hr_api.g_varchar2) then
229: If (p_rec.val_information15 = hr_api.g_varchar2) then
230: p_rec.val_information15 :=
231: pqp_val_shd.g_old_rec.val_information15;
232: End If;
233: If (p_rec.val_information16 = hr_api.g_varchar2) then
234: p_rec.val_information16 :=
235: pqp_val_shd.g_old_rec.val_information16;
236: End If;
237: If (p_rec.val_information17 = hr_api.g_varchar2) then
233: If (p_rec.val_information16 = hr_api.g_varchar2) then
234: p_rec.val_information16 :=
235: pqp_val_shd.g_old_rec.val_information16;
236: End If;
237: If (p_rec.val_information17 = hr_api.g_varchar2) then
238: p_rec.val_information17 :=
239: pqp_val_shd.g_old_rec.val_information17;
240: End If;
241: If (p_rec.val_information18 = hr_api.g_varchar2) then
237: If (p_rec.val_information17 = hr_api.g_varchar2) then
238: p_rec.val_information17 :=
239: pqp_val_shd.g_old_rec.val_information17;
240: End If;
241: If (p_rec.val_information18 = hr_api.g_varchar2) then
242: p_rec.val_information18 :=
243: pqp_val_shd.g_old_rec.val_information18;
244: End If;
245: If (p_rec.val_information19 = hr_api.g_varchar2) then
241: If (p_rec.val_information18 = hr_api.g_varchar2) then
242: p_rec.val_information18 :=
243: pqp_val_shd.g_old_rec.val_information18;
244: End If;
245: If (p_rec.val_information19 = hr_api.g_varchar2) then
246: p_rec.val_information19 :=
247: pqp_val_shd.g_old_rec.val_information19;
248: End If;
249: If (p_rec.val_information20 = hr_api.g_varchar2) then
245: If (p_rec.val_information19 = hr_api.g_varchar2) then
246: p_rec.val_information19 :=
247: pqp_val_shd.g_old_rec.val_information19;
248: End If;
249: If (p_rec.val_information20 = hr_api.g_varchar2) then
250: p_rec.val_information20 :=
251: pqp_val_shd.g_old_rec.val_information20;
252: End If;
253: If (p_rec.fuel_benefit = hr_api.g_varchar2) then
249: If (p_rec.val_information20 = hr_api.g_varchar2) then
250: p_rec.val_information20 :=
251: pqp_val_shd.g_old_rec.val_information20;
252: End If;
253: If (p_rec.fuel_benefit = hr_api.g_varchar2) then
254: p_rec.fuel_benefit :=
255: pqp_val_shd.g_old_rec.fuel_benefit;
256: End If;
257: If (p_rec.sliding_rates_info = hr_api.g_varchar2) then
253: If (p_rec.fuel_benefit = hr_api.g_varchar2) then
254: p_rec.fuel_benefit :=
255: pqp_val_shd.g_old_rec.fuel_benefit;
256: End If;
257: If (p_rec.sliding_rates_info = hr_api.g_varchar2) then
258: p_rec.sliding_rates_info :=
259: pqp_val_shd.g_old_rec.sliding_rates_info;
260: End If;
261: