eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_STS_BUS dependencies on PQH_STS_SHD

Line 220: ,p_rec in pqh_sts_shd.g_rec_type

216: -- {End Of Comments}
217: -- ----------------------------------------------------------------------------
218: Procedure chk_non_updateable_args
219: (p_effective_date in date
220: ,p_rec in pqh_sts_shd.g_rec_type
221: ) IS
222: --
223: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
224: l_status varchar2(10) := null;

Line 231: IF NOT pqh_sts_shd.api_updating

227: --
228: -- Only proceed with the validation if a row exists for the current
229: -- record in the HR Schema.
230: --
231: IF NOT pqh_sts_shd.api_updating
232: (p_statutory_situation_id => p_rec.statutory_situation_id
233: ,p_object_version_number => p_rec.object_version_number
234: ) THEN
235: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 242: nvl(pqh_sts_shd.g_old_rec.business_group_id

238: fnd_message.raise_error;
239: END IF;
240:
241: if nvl(p_rec.business_group_id, hr_api.g_number) <>
242: nvl(pqh_sts_shd.g_old_rec.business_group_id
243: ,hr_api.g_number
244: ) then
245: hr_api.argument_changed_error
246: (p_api_name => l_proc

Line 248: ,p_base_table => pqh_sts_shd.g_tab_nam

244: ) then
245: hr_api.argument_changed_error
246: (p_api_name => l_proc
247: ,p_argument => 'BUSINESS_GROUP_ID'
248: ,p_base_table => pqh_sts_shd.g_tab_nam
249: );
250: end if;
251:
252: -- Type_Of_PS

Line 255: nvl(pqh_sts_shd.g_old_rec.type_of_ps

251:
252: -- Type_Of_PS
253:
254: if nvl(p_rec.type_of_ps, hr_api.g_varchar2) <>
255: nvl(pqh_sts_shd.g_old_rec.type_of_ps
256: ,hr_api.g_varchar2
257: ) then
258: hr_api.argument_changed_error
259: (p_api_name => l_proc

Line 261: ,p_base_table => pqh_sts_shd.g_tab_nam

257: ) then
258: hr_api.argument_changed_error
259: (p_api_name => l_proc
260: ,p_argument => 'TYPE_OF_PS'
261: ,p_base_table => pqh_sts_shd.g_tab_nam
262: );
263: end if;
264:
265: -- Situation Type

Line 268: nvl(pqh_sts_shd.g_old_rec.situation_type

264:
265: -- Situation Type
266:
267: if nvl(p_rec.situation_type, hr_api.g_varchar2) <>
268: nvl(pqh_sts_shd.g_old_rec.situation_type
269: ,hr_api.g_varchar2
270: ) then
271: hr_api.argument_changed_error
272: (p_api_name => l_proc

Line 274: ,p_base_table => pqh_sts_shd.g_tab_nam

270: ) then
271: hr_api.argument_changed_error
272: (p_api_name => l_proc
273: ,p_argument => 'SITUATION_TYPE'
274: ,p_base_table => pqh_sts_shd.g_tab_nam
275: );
276: end if;
277:
278: -- Sub Type

Line 280: nvl(pqh_sts_shd.g_old_rec.sub_type

276: end if;
277:
278: -- Sub Type
279: if nvl(p_rec.sub_type, hr_api.g_varchar2) <>
280: nvl(pqh_sts_shd.g_old_rec.sub_type
281: ,hr_api.g_varchar2
282: ) then
283: hr_api.argument_changed_error
284: (p_api_name => l_proc

Line 286: ,p_base_table => pqh_sts_shd.g_tab_nam

282: ) then
283: hr_api.argument_changed_error
284: (p_api_name => l_proc
285: ,p_argument => 'SUB_TYPE'
286: ,p_base_table => pqh_sts_shd.g_tab_nam
287: );
288: end if;
289:
290: -- Source

Line 292: nvl(pqh_sts_shd.g_old_rec.source

288: end if;
289:
290: -- Source
291: if nvl(p_rec.source, hr_api.g_varchar2) <>
292: nvl(pqh_sts_shd.g_old_rec.source
293: ,hr_api.g_varchar2
294: ) then
295: hr_api.argument_changed_error
296: (p_api_name => l_proc

Line 298: ,p_base_table => pqh_sts_shd.g_tab_nam

294: ) then
295: hr_api.argument_changed_error
296: (p_api_name => l_proc
297: ,p_argument => 'SOURCE'
298: ,p_base_table => pqh_sts_shd.g_tab_nam
299: );
300: end if;
301:
302: -- Location

Line 304: nvl(pqh_sts_shd.g_old_rec.location

300: end if;
301:
302: -- Location
303: if nvl(p_rec.location, hr_api.g_varchar2) <>
304: nvl(pqh_sts_shd.g_old_rec.location
305: ,hr_api.g_varchar2
306: ) then
307: hr_api.argument_changed_error
308: (p_api_name => l_proc

Line 310: ,p_base_table => pqh_sts_shd.g_tab_nam

306: ) then
307: hr_api.argument_changed_error
308: (p_api_name => l_proc
309: ,p_argument => 'LOCATION'
310: ,p_base_table => pqh_sts_shd.g_tab_nam
311: );
312: end if;
313:
314: -- Reason

Line 316: nvl(pqh_sts_shd.g_old_rec.reason

312: end if;
313:
314: -- Reason
315: if nvl(p_rec.reason, hr_api.g_varchar2) <>
316: nvl(pqh_sts_shd.g_old_rec.reason
317: ,hr_api.g_varchar2
318: ) then
319: hr_api.argument_changed_error
320: (p_api_name => l_proc

Line 322: ,p_base_table => pqh_sts_shd.g_tab_nam

318: ) then
319: hr_api.argument_changed_error
320: (p_api_name => l_proc
321: ,p_argument => 'REASON'
322: ,p_base_table => pqh_sts_shd.g_tab_nam
323: );
324: end if;
325:
326: --

Line 356: procedure chk_duration_limits(p_rec in pqh_sts_shd.g_rec_type)

352: end if;
353:
354: end chk_renewable;
355: --
356: procedure chk_duration_limits(p_rec in pqh_sts_shd.g_rec_type)
357: is
358: --
359: l_proc varchar2(72) := g_package||'chk_duration_limits';
360: l_value varchar2(100);

Line 866: procedure chk_default(p_rec in pqh_sts_shd.g_rec_type)

862:
863: ---
864: -- Default check
865: ---
866: procedure chk_default(p_rec in pqh_sts_shd.g_rec_type)
867: is
868: --
869: l_proc varchar2(72) := g_package||'chk_default';
870: l_value varchar2(1000);

Line 986: procedure chk_unique_sitaution_name (p_rec in pqh_sts_shd.g_rec_type)

982: --
983: End chk_situation_type;
984:
985: --
986: procedure chk_unique_sitaution_name (p_rec in pqh_sts_shd.g_rec_type)
987: is
988: --
989: l_proc varchar2(72) := g_package||'chk_unique_sitaution_name';
990: l_value varchar2(1000);

Line 1028: procedure chk_unique_sitaution (p_rec in pqh_sts_shd.g_rec_type)

1024:
1025: --
1026: --
1027: --
1028: procedure chk_unique_sitaution (p_rec in pqh_sts_shd.g_rec_type)
1029: is
1030: --
1031: l_proc varchar2(72) := g_package||'chk_unique_sitaution';
1032: l_value varchar2(1000);

Line 1125: ,p_rec in pqh_sts_shd.g_rec_type

1121: -- |---------------------------< insert_validate >----------------------------|
1122: -- ----------------------------------------------------------------------------
1123: Procedure insert_validate
1124: (p_effective_date in date
1125: ,p_rec in pqh_sts_shd.g_rec_type
1126: ) is
1127: --
1128: l_proc varchar2(72) := g_package||'insert_validate';
1129: --

Line 1142: ,p_associated_column1 => pqh_sts_shd.g_tab_nam

1138: -- Call all supporting business operations
1139: --
1140: hr_api.validate_bus_grp_id
1141: (p_business_group_id => p_rec.business_group_id
1142: ,p_associated_column1 => pqh_sts_shd.g_tab_nam
1143: || '.BUSINESS_GROUP_ID');
1144: --
1145: --
1146: hr_multi_message.end_validation_set;

Line 1223: ,p_rec in pqh_sts_shd.g_rec_type

1219: -- |---------------------------< update_validate >----------------------------|
1220: -- ----------------------------------------------------------------------------
1221: Procedure update_validate
1222: (p_effective_date in date
1223: ,p_rec in pqh_sts_shd.g_rec_type
1224: ) is
1225: --
1226: l_proc varchar2(72) := g_package||'update_validate';
1227: --

Line 1239: ,p_associated_column1 => pqh_sts_shd.g_tab_nam

1235: -- Call all supporting business operations
1236: --
1237: hr_api.validate_bus_grp_id
1238: (p_business_group_id => p_rec.business_group_id
1239: ,p_associated_column1 => pqh_sts_shd.g_tab_nam
1240: || '.BUSINESS_GROUP_ID');
1241: hr_multi_message.end_validation_set;
1242:
1243: chk_unique_sitaution_name(p_rec);

Line 1299: (p_rec in pqh_sts_shd.g_rec_type

1295: -- ----------------------------------------------------------------------------
1296: -- |---------------------------< delete_validate >----------------------------|
1297: -- ----------------------------------------------------------------------------
1298: Procedure delete_validate
1299: (p_rec in pqh_sts_shd.g_rec_type
1300: ) is
1301: --
1302: l_proc varchar2(72) := g_package||'delete_validate';
1303: --