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.HR_ITEM_PROPERTIES_PKG dependencies on PER_RIC_PKG

Line 332: PER_RIC_PKG.chk_integrity (

328: -- Code Starts Here.
329: --
330:
331: BEGIN
332: PER_RIC_PKG.chk_integrity (
333: p_entity_name => 'HR_ITEM_PROPERTIES_B',
334: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
335: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
336: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_FORM_ITEM_ID,NULL))),

Line 334: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(

330:
331: BEGIN
332: PER_RIC_PKG.chk_integrity (
333: p_entity_name => 'HR_ITEM_PROPERTIES_B',
334: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
335: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
336: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_FORM_ITEM_ID,NULL))),
337: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
338: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID1,NULL))),

Line 335: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

331: BEGIN
332: PER_RIC_PKG.chk_integrity (
333: p_entity_name => 'HR_ITEM_PROPERTIES_B',
334: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
335: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
336: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_FORM_ITEM_ID,NULL))),
337: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
338: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID1,NULL))),
339: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

Line 336: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_FORM_ITEM_ID,NULL))),

332: PER_RIC_PKG.chk_integrity (
333: p_entity_name => 'HR_ITEM_PROPERTIES_B',
334: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
335: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
336: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_FORM_ITEM_ID,NULL))),
337: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
338: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID1,NULL))),
339: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
340: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID2,NULL))),

Line 337: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

333: p_entity_name => 'HR_ITEM_PROPERTIES_B',
334: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
335: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
336: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_FORM_ITEM_ID,NULL))),
337: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
338: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID1,NULL))),
339: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
340: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID2,NULL))),
341: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

Line 338: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID1,NULL))),

334: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
335: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
336: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_FORM_ITEM_ID,NULL))),
337: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
338: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID1,NULL))),
339: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
340: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID2,NULL))),
341: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
342: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID3,NULL))),

Line 339: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

335: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
336: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_FORM_ITEM_ID,NULL))),
337: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
338: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID1,NULL))),
339: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
340: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID2,NULL))),
341: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
342: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID3,NULL))),
343: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

Line 340: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID2,NULL))),

336: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_FORM_ITEM_ID,NULL))),
337: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
338: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID1,NULL))),
339: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
340: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID2,NULL))),
341: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
342: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID3,NULL))),
343: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
344: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID4,NULL))),

Line 341: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

337: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
338: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID1,NULL))),
339: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
340: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID2,NULL))),
341: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
342: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID3,NULL))),
343: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
344: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID4,NULL))),
345: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

Line 342: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID3,NULL))),

338: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID1,NULL))),
339: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
340: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID2,NULL))),
341: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
342: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID3,NULL))),
343: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
344: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID4,NULL))),
345: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
346: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID5,NULL))),

Line 343: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

339: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
340: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID2,NULL))),
341: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
342: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID3,NULL))),
343: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
344: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID4,NULL))),
345: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
346: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID5,NULL))),
347: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

Line 344: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID4,NULL))),

340: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID2,NULL))),
341: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
342: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID3,NULL))),
343: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
344: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID4,NULL))),
345: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
346: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID5,NULL))),
347: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
348: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_NEXT_NAVIGATION_ITEM_ID,NULL))),

Line 345: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

341: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
342: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID3,NULL))),
343: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
344: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID4,NULL))),
345: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
346: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID5,NULL))),
347: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
348: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_NEXT_NAVIGATION_ITEM_ID,NULL))),
349: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

Line 346: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID5,NULL))),

342: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID3,NULL))),
343: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
344: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID4,NULL))),
345: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
346: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID5,NULL))),
347: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
348: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_NEXT_NAVIGATION_ITEM_ID,NULL))),
349: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
350: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_PREVIOUS_NAVIGATION_ITEM_ID,NULL))),

Line 347: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

343: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
344: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID4,NULL))),
345: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
346: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID5,NULL))),
347: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
348: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_NEXT_NAVIGATION_ITEM_ID,NULL))),
349: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
350: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_PREVIOUS_NAVIGATION_ITEM_ID,NULL))),
351: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

Line 348: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_NEXT_NAVIGATION_ITEM_ID,NULL))),

344: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID4,NULL))),
345: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
346: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID5,NULL))),
347: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
348: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_NEXT_NAVIGATION_ITEM_ID,NULL))),
349: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
350: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_PREVIOUS_NAVIGATION_ITEM_ID,NULL))),
351: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
352: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID1,NULL))),

Line 349: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

345: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
346: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID5,NULL))),
347: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
348: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_NEXT_NAVIGATION_ITEM_ID,NULL))),
349: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
350: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_PREVIOUS_NAVIGATION_ITEM_ID,NULL))),
351: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
352: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID1,NULL))),
353: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

Line 350: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_PREVIOUS_NAVIGATION_ITEM_ID,NULL))),

346: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID5,NULL))),
347: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
348: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_NEXT_NAVIGATION_ITEM_ID,NULL))),
349: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
350: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_PREVIOUS_NAVIGATION_ITEM_ID,NULL))),
351: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
352: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID1,NULL))),
353: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
354: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID2,NULL))),

Line 351: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

347: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
348: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_NEXT_NAVIGATION_ITEM_ID,NULL))),
349: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
350: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_PREVIOUS_NAVIGATION_ITEM_ID,NULL))),
351: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
352: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID1,NULL))),
353: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
354: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID2,NULL))),
355: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

Line 352: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID1,NULL))),

348: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_NEXT_NAVIGATION_ITEM_ID,NULL))),
349: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
350: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_PREVIOUS_NAVIGATION_ITEM_ID,NULL))),
351: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
352: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID1,NULL))),
353: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
354: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID2,NULL))),
355: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
356: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID3,NULL))),

Line 353: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

349: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
350: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_PREVIOUS_NAVIGATION_ITEM_ID,NULL))),
351: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
352: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID1,NULL))),
353: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
354: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID2,NULL))),
355: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
356: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID3,NULL))),
357: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

Line 354: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID2,NULL))),

350: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_PREVIOUS_NAVIGATION_ITEM_ID,NULL))),
351: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
352: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID1,NULL))),
353: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
354: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID2,NULL))),
355: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
356: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID3,NULL))),
357: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
358: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID4,NULL))),

Line 355: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

351: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
352: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID1,NULL))),
353: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
354: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID2,NULL))),
355: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
356: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID3,NULL))),
357: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
358: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID4,NULL))),
359: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

Line 356: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID3,NULL))),

352: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID1,NULL))),
353: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
354: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID2,NULL))),
355: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
356: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID3,NULL))),
357: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
358: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID4,NULL))),
359: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
360: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID5,NULL))),

Line 357: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

353: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
354: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID2,NULL))),
355: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
356: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID3,NULL))),
357: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
358: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID4,NULL))),
359: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
360: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID5,NULL))),
361: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(

Line 358: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID4,NULL))),

354: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID2,NULL))),
355: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
356: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID3,NULL))),
357: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
358: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID4,NULL))),
359: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
360: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID5,NULL))),
361: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
362: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),

Line 359: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

355: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
356: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID3,NULL))),
357: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
358: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID4,NULL))),
359: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
360: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID5,NULL))),
361: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
362: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
363: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(

Line 360: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID5,NULL))),

356: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID3,NULL))),
357: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
358: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID4,NULL))),
359: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
360: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID5,NULL))),
361: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
362: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
363: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
364: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,X_TEMPLATE_ITEM_CONTEXT_ID,NULL)))

Line 361: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(

357: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
358: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID4,NULL))),
359: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
360: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID5,NULL))),
361: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
362: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
363: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
364: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,X_TEMPLATE_ITEM_CONTEXT_ID,NULL)))
365: ),

Line 362: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),

358: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID4,NULL))),
359: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
360: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID5,NULL))),
361: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
362: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
363: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
364: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,X_TEMPLATE_ITEM_CONTEXT_ID,NULL)))
365: ),
366: p_ref_type => 'INS');

Line 363: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(

359: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
360: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID5,NULL))),
361: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
362: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
363: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
364: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,X_TEMPLATE_ITEM_CONTEXT_ID,NULL)))
365: ),
366: p_ref_type => 'INS');
367:

Line 364: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,X_TEMPLATE_ITEM_CONTEXT_ID,NULL)))

360: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID5,NULL))),
361: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
362: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
363: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
364: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,X_TEMPLATE_ITEM_CONTEXT_ID,NULL)))
365: ),
366: p_ref_type => 'INS');
367:
368: END;

Line 531: PER_RIC_PKG.chk_integrity (

527: -- Code Starts Here.
528: --
529:
530: BEGIN
531: PER_RIC_PKG.chk_integrity (
532: p_entity_name => 'HR_ITEM_PROPERTIES_TL',
533: p_ref_entity => 'HR_ITEM_PROPERTIES_B',
534: p_ref_column_name => 'ITEM_PROPERTY_ID',
535: p_ref_col_value_number => X_ITEM_PROPERTY_ID,

Line 1119: PER_RIC_PKG.chk_integrity (

1115: -- Code Starts Here.
1116: --
1117:
1118: BEGIN
1119: PER_RIC_PKG.chk_integrity (
1120: p_entity_name => 'HR_ITEM_PROPERTIES_B',
1121: p_ref_entity => 'HR_ITEM_PROPERTIES_TL',
1122: p_ref_column_name => 'ITEM_PROPERTY_ID',
1123: p_ref_col_value_number => X_ITEM_PROPERTY_ID,