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

Line 238: PER_RIC_PKG.chk_integrity (

234: -- Code Starts Here.
235: --
236:
237: BEGIN
238: PER_RIC_PKG.chk_integrity (
239: p_entity_name => 'PER_ASS_STATUS_TYPE_AMENDS',
240: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
241: PER_RIC_PKG.ref_info_rec('PER_ASSIGNMENT_STATUS_TYPES', PER_RIC_PKG.column_info_tbl(
242: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,P_ASSIGNMENT_STATUS_TYPE_ID,NULL))),

Line 240: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(

236:
237: BEGIN
238: PER_RIC_PKG.chk_integrity (
239: p_entity_name => 'PER_ASS_STATUS_TYPE_AMENDS',
240: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
241: PER_RIC_PKG.ref_info_rec('PER_ASSIGNMENT_STATUS_TYPES', PER_RIC_PKG.column_info_tbl(
242: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,P_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
243: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS', PER_RIC_PKG.column_info_tbl(
244: PER_RIC_PKG.col_info_rec('ORGANIZATION_ID',NULL,P_BUSINESS_GROUP_ID,NULL)))

Line 241: PER_RIC_PKG.ref_info_rec('PER_ASSIGNMENT_STATUS_TYPES', PER_RIC_PKG.column_info_tbl(

237: BEGIN
238: PER_RIC_PKG.chk_integrity (
239: p_entity_name => 'PER_ASS_STATUS_TYPE_AMENDS',
240: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
241: PER_RIC_PKG.ref_info_rec('PER_ASSIGNMENT_STATUS_TYPES', PER_RIC_PKG.column_info_tbl(
242: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,P_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
243: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS', PER_RIC_PKG.column_info_tbl(
244: PER_RIC_PKG.col_info_rec('ORGANIZATION_ID',NULL,P_BUSINESS_GROUP_ID,NULL)))
245: ),

Line 242: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,P_ASSIGNMENT_STATUS_TYPE_ID,NULL))),

238: PER_RIC_PKG.chk_integrity (
239: p_entity_name => 'PER_ASS_STATUS_TYPE_AMENDS',
240: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
241: PER_RIC_PKG.ref_info_rec('PER_ASSIGNMENT_STATUS_TYPES', PER_RIC_PKG.column_info_tbl(
242: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,P_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
243: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS', PER_RIC_PKG.column_info_tbl(
244: PER_RIC_PKG.col_info_rec('ORGANIZATION_ID',NULL,P_BUSINESS_GROUP_ID,NULL)))
245: ),
246: p_ref_type => 'INS');

Line 243: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS', PER_RIC_PKG.column_info_tbl(

239: p_entity_name => 'PER_ASS_STATUS_TYPE_AMENDS',
240: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
241: PER_RIC_PKG.ref_info_rec('PER_ASSIGNMENT_STATUS_TYPES', PER_RIC_PKG.column_info_tbl(
242: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,P_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
243: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS', PER_RIC_PKG.column_info_tbl(
244: PER_RIC_PKG.col_info_rec('ORGANIZATION_ID',NULL,P_BUSINESS_GROUP_ID,NULL)))
245: ),
246: p_ref_type => 'INS');
247:

Line 244: PER_RIC_PKG.col_info_rec('ORGANIZATION_ID',NULL,P_BUSINESS_GROUP_ID,NULL)))

240: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
241: PER_RIC_PKG.ref_info_rec('PER_ASSIGNMENT_STATUS_TYPES', PER_RIC_PKG.column_info_tbl(
242: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,P_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
243: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS', PER_RIC_PKG.column_info_tbl(
244: PER_RIC_PKG.col_info_rec('ORGANIZATION_ID',NULL,P_BUSINESS_GROUP_ID,NULL)))
245: ),
246: p_ref_type => 'INS');
247:
248: END;

Line 289: PER_RIC_PKG.chk_integrity (

285: -- Code Starts Here.
286: --
287:
288: BEGIN
289: PER_RIC_PKG.chk_integrity (
290: p_entity_name => 'PER_ASS_STATUS_TYPE_AMENDS_TL',
291: p_ref_entity => 'PER_ASS_STATUS_TYPE_AMENDS',
292: p_ref_column_name => 'ASS_STATUS_TYPE_AMEND_ID',
293: p_ref_col_value_number => P_ASS_STATUS_TYPE_AMEND_ID,

Line 480: PER_RIC_PKG.chk_integrity (

476: -- Code Starts Here.
477: --
478:
479: BEGIN
480: PER_RIC_PKG.chk_integrity (
481: p_entity_name => 'PER_ASSIGNMENT_STATUS_TYPES_TL',
482: p_ref_entity => 'PER_ASSIGNMENT_STATUS_TYPES',
483: p_ref_column_name => 'ASSIGNMENT_STATUS_TYPE_ID',
484: p_ref_col_value_number => X_ASSIGNMENT_STATUS_TYPE_ID,

Line 696: PER_RIC_PKG.chk_integrity (

692: -- Code Starts Here.
693: --
694:
695: BEGIN
696: PER_RIC_PKG.chk_integrity (
697: p_entity_name => 'PER_ASSIGNMENT_STATUS_TYPES',
698: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
699: PER_RIC_PKG.ref_info_rec('PAY_STATUS_PROCESSING_RULES_F', PER_RIC_PKG.column_info_tbl(
700: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),

Line 698: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(

694:
695: BEGIN
696: PER_RIC_PKG.chk_integrity (
697: p_entity_name => 'PER_ASSIGNMENT_STATUS_TYPES',
698: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
699: PER_RIC_PKG.ref_info_rec('PAY_STATUS_PROCESSING_RULES_F', PER_RIC_PKG.column_info_tbl(
700: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
701: PER_RIC_PKG.ref_info_rec('PER_ALL_ASSIGNMENTS_F', PER_RIC_PKG.column_info_tbl(
702: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),

Line 699: PER_RIC_PKG.ref_info_rec('PAY_STATUS_PROCESSING_RULES_F', PER_RIC_PKG.column_info_tbl(

695: BEGIN
696: PER_RIC_PKG.chk_integrity (
697: p_entity_name => 'PER_ASSIGNMENT_STATUS_TYPES',
698: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
699: PER_RIC_PKG.ref_info_rec('PAY_STATUS_PROCESSING_RULES_F', PER_RIC_PKG.column_info_tbl(
700: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
701: PER_RIC_PKG.ref_info_rec('PER_ALL_ASSIGNMENTS_F', PER_RIC_PKG.column_info_tbl(
702: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
703: PER_RIC_PKG.ref_info_rec('PER_ASS_STATUS_TYPE_AMENDS', PER_RIC_PKG.column_info_tbl(

Line 700: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),

696: PER_RIC_PKG.chk_integrity (
697: p_entity_name => 'PER_ASSIGNMENT_STATUS_TYPES',
698: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
699: PER_RIC_PKG.ref_info_rec('PAY_STATUS_PROCESSING_RULES_F', PER_RIC_PKG.column_info_tbl(
700: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
701: PER_RIC_PKG.ref_info_rec('PER_ALL_ASSIGNMENTS_F', PER_RIC_PKG.column_info_tbl(
702: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
703: PER_RIC_PKG.ref_info_rec('PER_ASS_STATUS_TYPE_AMENDS', PER_RIC_PKG.column_info_tbl(
704: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),

Line 701: PER_RIC_PKG.ref_info_rec('PER_ALL_ASSIGNMENTS_F', PER_RIC_PKG.column_info_tbl(

697: p_entity_name => 'PER_ASSIGNMENT_STATUS_TYPES',
698: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
699: PER_RIC_PKG.ref_info_rec('PAY_STATUS_PROCESSING_RULES_F', PER_RIC_PKG.column_info_tbl(
700: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
701: PER_RIC_PKG.ref_info_rec('PER_ALL_ASSIGNMENTS_F', PER_RIC_PKG.column_info_tbl(
702: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
703: PER_RIC_PKG.ref_info_rec('PER_ASS_STATUS_TYPE_AMENDS', PER_RIC_PKG.column_info_tbl(
704: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
705: PER_RIC_PKG.ref_info_rec('PER_LETTER_REQUEST_LINES', PER_RIC_PKG.column_info_tbl(

Line 702: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),

698: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
699: PER_RIC_PKG.ref_info_rec('PAY_STATUS_PROCESSING_RULES_F', PER_RIC_PKG.column_info_tbl(
700: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
701: PER_RIC_PKG.ref_info_rec('PER_ALL_ASSIGNMENTS_F', PER_RIC_PKG.column_info_tbl(
702: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
703: PER_RIC_PKG.ref_info_rec('PER_ASS_STATUS_TYPE_AMENDS', PER_RIC_PKG.column_info_tbl(
704: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
705: PER_RIC_PKG.ref_info_rec('PER_LETTER_REQUEST_LINES', PER_RIC_PKG.column_info_tbl(
706: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),

Line 703: PER_RIC_PKG.ref_info_rec('PER_ASS_STATUS_TYPE_AMENDS', PER_RIC_PKG.column_info_tbl(

699: PER_RIC_PKG.ref_info_rec('PAY_STATUS_PROCESSING_RULES_F', PER_RIC_PKG.column_info_tbl(
700: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
701: PER_RIC_PKG.ref_info_rec('PER_ALL_ASSIGNMENTS_F', PER_RIC_PKG.column_info_tbl(
702: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
703: PER_RIC_PKG.ref_info_rec('PER_ASS_STATUS_TYPE_AMENDS', PER_RIC_PKG.column_info_tbl(
704: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
705: PER_RIC_PKG.ref_info_rec('PER_LETTER_REQUEST_LINES', PER_RIC_PKG.column_info_tbl(
706: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
707: PER_RIC_PKG.ref_info_rec('PER_SECONDARY_ASS_STATUSES', PER_RIC_PKG.column_info_tbl(

Line 704: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),

700: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
701: PER_RIC_PKG.ref_info_rec('PER_ALL_ASSIGNMENTS_F', PER_RIC_PKG.column_info_tbl(
702: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
703: PER_RIC_PKG.ref_info_rec('PER_ASS_STATUS_TYPE_AMENDS', PER_RIC_PKG.column_info_tbl(
704: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
705: PER_RIC_PKG.ref_info_rec('PER_LETTER_REQUEST_LINES', PER_RIC_PKG.column_info_tbl(
706: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
707: PER_RIC_PKG.ref_info_rec('PER_SECONDARY_ASS_STATUSES', PER_RIC_PKG.column_info_tbl(
708: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL)))

Line 705: PER_RIC_PKG.ref_info_rec('PER_LETTER_REQUEST_LINES', PER_RIC_PKG.column_info_tbl(

701: PER_RIC_PKG.ref_info_rec('PER_ALL_ASSIGNMENTS_F', PER_RIC_PKG.column_info_tbl(
702: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
703: PER_RIC_PKG.ref_info_rec('PER_ASS_STATUS_TYPE_AMENDS', PER_RIC_PKG.column_info_tbl(
704: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
705: PER_RIC_PKG.ref_info_rec('PER_LETTER_REQUEST_LINES', PER_RIC_PKG.column_info_tbl(
706: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
707: PER_RIC_PKG.ref_info_rec('PER_SECONDARY_ASS_STATUSES', PER_RIC_PKG.column_info_tbl(
708: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL)))
709: ),

Line 706: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),

702: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
703: PER_RIC_PKG.ref_info_rec('PER_ASS_STATUS_TYPE_AMENDS', PER_RIC_PKG.column_info_tbl(
704: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
705: PER_RIC_PKG.ref_info_rec('PER_LETTER_REQUEST_LINES', PER_RIC_PKG.column_info_tbl(
706: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
707: PER_RIC_PKG.ref_info_rec('PER_SECONDARY_ASS_STATUSES', PER_RIC_PKG.column_info_tbl(
708: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL)))
709: ),
710: p_ref_type => 'DEL');

Line 707: PER_RIC_PKG.ref_info_rec('PER_SECONDARY_ASS_STATUSES', PER_RIC_PKG.column_info_tbl(

703: PER_RIC_PKG.ref_info_rec('PER_ASS_STATUS_TYPE_AMENDS', PER_RIC_PKG.column_info_tbl(
704: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
705: PER_RIC_PKG.ref_info_rec('PER_LETTER_REQUEST_LINES', PER_RIC_PKG.column_info_tbl(
706: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
707: PER_RIC_PKG.ref_info_rec('PER_SECONDARY_ASS_STATUSES', PER_RIC_PKG.column_info_tbl(
708: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL)))
709: ),
710: p_ref_type => 'DEL');
711:

Line 708: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL)))

704: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
705: PER_RIC_PKG.ref_info_rec('PER_LETTER_REQUEST_LINES', PER_RIC_PKG.column_info_tbl(
706: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
707: PER_RIC_PKG.ref_info_rec('PER_SECONDARY_ASS_STATUSES', PER_RIC_PKG.column_info_tbl(
708: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL)))
709: ),
710: p_ref_type => 'DEL');
711:
712: END;