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.

[Home] [Help]

APPS.PER_SHT_DEL dependencies on PER_RIC_PKG

Line 56: PER_RIC_PKG.chk_integrity (

52: --
53: -- Added the following code as a part of Zero Downtime Patching Project.
54: -- Code Starts Here.
55: --
56: PER_RIC_PKG.chk_integrity (
57: p_entity_name=>'PER_SHARED_TYPES',
58: p_ref_entity_info=>
59: PER_RIC_PKG.ref_entity_tbl(
60: PER_RIC_PKG.ref_info_rec('HR_ALL_POSITIONS_F',PER_RIC_PKG.column_info_tbl(

Line 59: PER_RIC_PKG.ref_entity_tbl(

55: --
56: PER_RIC_PKG.chk_integrity (
57: p_entity_name=>'PER_SHARED_TYPES',
58: p_ref_entity_info=>
59: PER_RIC_PKG.ref_entity_tbl(
60: PER_RIC_PKG.ref_info_rec('HR_ALL_POSITIONS_F',PER_RIC_PKG.column_info_tbl(
61: PER_RIC_PKG.col_info_rec('AVAILABILITY_STATUS_ID', NULL, p_rec.shared_type_id,NULL))),
62: PER_RIC_PKG.ref_info_rec('PQH_BUDGETS',PER_RIC_PKG.column_info_tbl(
63: PER_RIC_PKG.col_info_rec('BUDGET_UNIT1_ID', NULL,p_rec.shared_type_id,NULL))),

Line 60: PER_RIC_PKG.ref_info_rec('HR_ALL_POSITIONS_F',PER_RIC_PKG.column_info_tbl(

56: PER_RIC_PKG.chk_integrity (
57: p_entity_name=>'PER_SHARED_TYPES',
58: p_ref_entity_info=>
59: PER_RIC_PKG.ref_entity_tbl(
60: PER_RIC_PKG.ref_info_rec('HR_ALL_POSITIONS_F',PER_RIC_PKG.column_info_tbl(
61: PER_RIC_PKG.col_info_rec('AVAILABILITY_STATUS_ID', NULL, p_rec.shared_type_id,NULL))),
62: PER_RIC_PKG.ref_info_rec('PQH_BUDGETS',PER_RIC_PKG.column_info_tbl(
63: PER_RIC_PKG.col_info_rec('BUDGET_UNIT1_ID', NULL,p_rec.shared_type_id,NULL))),
64: PER_RIC_PKG.ref_info_rec('PQH_BUDGETS',PER_RIC_PKG.column_info_tbl(

Line 61: PER_RIC_PKG.col_info_rec('AVAILABILITY_STATUS_ID', NULL, p_rec.shared_type_id,NULL))),

57: p_entity_name=>'PER_SHARED_TYPES',
58: p_ref_entity_info=>
59: PER_RIC_PKG.ref_entity_tbl(
60: PER_RIC_PKG.ref_info_rec('HR_ALL_POSITIONS_F',PER_RIC_PKG.column_info_tbl(
61: PER_RIC_PKG.col_info_rec('AVAILABILITY_STATUS_ID', NULL, p_rec.shared_type_id,NULL))),
62: PER_RIC_PKG.ref_info_rec('PQH_BUDGETS',PER_RIC_PKG.column_info_tbl(
63: PER_RIC_PKG.col_info_rec('BUDGET_UNIT1_ID', NULL,p_rec.shared_type_id,NULL))),
64: PER_RIC_PKG.ref_info_rec('PQH_BUDGETS',PER_RIC_PKG.column_info_tbl(
65: PER_RIC_PKG.col_info_rec('BUDGET_UNIT2_ID', NULL, p_rec.shared_type_id,NULL))),

Line 62: PER_RIC_PKG.ref_info_rec('PQH_BUDGETS',PER_RIC_PKG.column_info_tbl(

58: p_ref_entity_info=>
59: PER_RIC_PKG.ref_entity_tbl(
60: PER_RIC_PKG.ref_info_rec('HR_ALL_POSITIONS_F',PER_RIC_PKG.column_info_tbl(
61: PER_RIC_PKG.col_info_rec('AVAILABILITY_STATUS_ID', NULL, p_rec.shared_type_id,NULL))),
62: PER_RIC_PKG.ref_info_rec('PQH_BUDGETS',PER_RIC_PKG.column_info_tbl(
63: PER_RIC_PKG.col_info_rec('BUDGET_UNIT1_ID', NULL,p_rec.shared_type_id,NULL))),
64: PER_RIC_PKG.ref_info_rec('PQH_BUDGETS',PER_RIC_PKG.column_info_tbl(
65: PER_RIC_PKG.col_info_rec('BUDGET_UNIT2_ID', NULL, p_rec.shared_type_id,NULL))),
66: PER_RIC_PKG.ref_info_rec('PQH_BUDGETS',PER_RIC_PKG.column_info_tbl(

Line 63: PER_RIC_PKG.col_info_rec('BUDGET_UNIT1_ID', NULL,p_rec.shared_type_id,NULL))),

59: PER_RIC_PKG.ref_entity_tbl(
60: PER_RIC_PKG.ref_info_rec('HR_ALL_POSITIONS_F',PER_RIC_PKG.column_info_tbl(
61: PER_RIC_PKG.col_info_rec('AVAILABILITY_STATUS_ID', NULL, p_rec.shared_type_id,NULL))),
62: PER_RIC_PKG.ref_info_rec('PQH_BUDGETS',PER_RIC_PKG.column_info_tbl(
63: PER_RIC_PKG.col_info_rec('BUDGET_UNIT1_ID', NULL,p_rec.shared_type_id,NULL))),
64: PER_RIC_PKG.ref_info_rec('PQH_BUDGETS',PER_RIC_PKG.column_info_tbl(
65: PER_RIC_PKG.col_info_rec('BUDGET_UNIT2_ID', NULL, p_rec.shared_type_id,NULL))),
66: PER_RIC_PKG.ref_info_rec('PQH_BUDGETS',PER_RIC_PKG.column_info_tbl(
67: PER_RIC_PKG.col_info_rec('BUDGET_UNIT3_ID', NULL,p_rec.shared_type_id,NULL))),

Line 64: PER_RIC_PKG.ref_info_rec('PQH_BUDGETS',PER_RIC_PKG.column_info_tbl(

60: PER_RIC_PKG.ref_info_rec('HR_ALL_POSITIONS_F',PER_RIC_PKG.column_info_tbl(
61: PER_RIC_PKG.col_info_rec('AVAILABILITY_STATUS_ID', NULL, p_rec.shared_type_id,NULL))),
62: PER_RIC_PKG.ref_info_rec('PQH_BUDGETS',PER_RIC_PKG.column_info_tbl(
63: PER_RIC_PKG.col_info_rec('BUDGET_UNIT1_ID', NULL,p_rec.shared_type_id,NULL))),
64: PER_RIC_PKG.ref_info_rec('PQH_BUDGETS',PER_RIC_PKG.column_info_tbl(
65: PER_RIC_PKG.col_info_rec('BUDGET_UNIT2_ID', NULL, p_rec.shared_type_id,NULL))),
66: PER_RIC_PKG.ref_info_rec('PQH_BUDGETS',PER_RIC_PKG.column_info_tbl(
67: PER_RIC_PKG.col_info_rec('BUDGET_UNIT3_ID', NULL,p_rec.shared_type_id,NULL))),
68: PER_RIC_PKG.ref_info_rec('PQH_BUDGET_POOLS',PER_RIC_PKG.column_info_tbl(

Line 65: PER_RIC_PKG.col_info_rec('BUDGET_UNIT2_ID', NULL, p_rec.shared_type_id,NULL))),

61: PER_RIC_PKG.col_info_rec('AVAILABILITY_STATUS_ID', NULL, p_rec.shared_type_id,NULL))),
62: PER_RIC_PKG.ref_info_rec('PQH_BUDGETS',PER_RIC_PKG.column_info_tbl(
63: PER_RIC_PKG.col_info_rec('BUDGET_UNIT1_ID', NULL,p_rec.shared_type_id,NULL))),
64: PER_RIC_PKG.ref_info_rec('PQH_BUDGETS',PER_RIC_PKG.column_info_tbl(
65: PER_RIC_PKG.col_info_rec('BUDGET_UNIT2_ID', NULL, p_rec.shared_type_id,NULL))),
66: PER_RIC_PKG.ref_info_rec('PQH_BUDGETS',PER_RIC_PKG.column_info_tbl(
67: PER_RIC_PKG.col_info_rec('BUDGET_UNIT3_ID', NULL,p_rec.shared_type_id,NULL))),
68: PER_RIC_PKG.ref_info_rec('PQH_BUDGET_POOLS',PER_RIC_PKG.column_info_tbl(
69: PER_RIC_PKG.col_info_rec('BUDGET_UNIT_ID', NULL, p_rec.shared_type_id,NULL))),

Line 66: PER_RIC_PKG.ref_info_rec('PQH_BUDGETS',PER_RIC_PKG.column_info_tbl(

62: PER_RIC_PKG.ref_info_rec('PQH_BUDGETS',PER_RIC_PKG.column_info_tbl(
63: PER_RIC_PKG.col_info_rec('BUDGET_UNIT1_ID', NULL,p_rec.shared_type_id,NULL))),
64: PER_RIC_PKG.ref_info_rec('PQH_BUDGETS',PER_RIC_PKG.column_info_tbl(
65: PER_RIC_PKG.col_info_rec('BUDGET_UNIT2_ID', NULL, p_rec.shared_type_id,NULL))),
66: PER_RIC_PKG.ref_info_rec('PQH_BUDGETS',PER_RIC_PKG.column_info_tbl(
67: PER_RIC_PKG.col_info_rec('BUDGET_UNIT3_ID', NULL,p_rec.shared_type_id,NULL))),
68: PER_RIC_PKG.ref_info_rec('PQH_BUDGET_POOLS',PER_RIC_PKG.column_info_tbl(
69: PER_RIC_PKG.col_info_rec('BUDGET_UNIT_ID', NULL, p_rec.shared_type_id,NULL))),
70: PER_RIC_PKG.ref_info_rec('PQH_POSITION_TRANSACTIONS',PER_RIC_PKG.column_info_tbl(

Line 67: PER_RIC_PKG.col_info_rec('BUDGET_UNIT3_ID', NULL,p_rec.shared_type_id,NULL))),

63: PER_RIC_PKG.col_info_rec('BUDGET_UNIT1_ID', NULL,p_rec.shared_type_id,NULL))),
64: PER_RIC_PKG.ref_info_rec('PQH_BUDGETS',PER_RIC_PKG.column_info_tbl(
65: PER_RIC_PKG.col_info_rec('BUDGET_UNIT2_ID', NULL, p_rec.shared_type_id,NULL))),
66: PER_RIC_PKG.ref_info_rec('PQH_BUDGETS',PER_RIC_PKG.column_info_tbl(
67: PER_RIC_PKG.col_info_rec('BUDGET_UNIT3_ID', NULL,p_rec.shared_type_id,NULL))),
68: PER_RIC_PKG.ref_info_rec('PQH_BUDGET_POOLS',PER_RIC_PKG.column_info_tbl(
69: PER_RIC_PKG.col_info_rec('BUDGET_UNIT_ID', NULL, p_rec.shared_type_id,NULL))),
70: PER_RIC_PKG.ref_info_rec('PQH_POSITION_TRANSACTIONS',PER_RIC_PKG.column_info_tbl(
71: PER_RIC_PKG.col_info_rec('AVAILABILITY_STATUS_ID', NULL,p_rec.shared_type_id,NULL))),

Line 68: PER_RIC_PKG.ref_info_rec('PQH_BUDGET_POOLS',PER_RIC_PKG.column_info_tbl(

64: PER_RIC_PKG.ref_info_rec('PQH_BUDGETS',PER_RIC_PKG.column_info_tbl(
65: PER_RIC_PKG.col_info_rec('BUDGET_UNIT2_ID', NULL, p_rec.shared_type_id,NULL))),
66: PER_RIC_PKG.ref_info_rec('PQH_BUDGETS',PER_RIC_PKG.column_info_tbl(
67: PER_RIC_PKG.col_info_rec('BUDGET_UNIT3_ID', NULL,p_rec.shared_type_id,NULL))),
68: PER_RIC_PKG.ref_info_rec('PQH_BUDGET_POOLS',PER_RIC_PKG.column_info_tbl(
69: PER_RIC_PKG.col_info_rec('BUDGET_UNIT_ID', NULL, p_rec.shared_type_id,NULL))),
70: PER_RIC_PKG.ref_info_rec('PQH_POSITION_TRANSACTIONS',PER_RIC_PKG.column_info_tbl(
71: PER_RIC_PKG.col_info_rec('AVAILABILITY_STATUS_ID', NULL,p_rec.shared_type_id,NULL))),
72: PER_RIC_PKG.ref_info_rec('PER_SHARED_TYPES_TL',PER_RIC_PKG.column_info_tbl(

Line 69: PER_RIC_PKG.col_info_rec('BUDGET_UNIT_ID', NULL, p_rec.shared_type_id,NULL))),

65: PER_RIC_PKG.col_info_rec('BUDGET_UNIT2_ID', NULL, p_rec.shared_type_id,NULL))),
66: PER_RIC_PKG.ref_info_rec('PQH_BUDGETS',PER_RIC_PKG.column_info_tbl(
67: PER_RIC_PKG.col_info_rec('BUDGET_UNIT3_ID', NULL,p_rec.shared_type_id,NULL))),
68: PER_RIC_PKG.ref_info_rec('PQH_BUDGET_POOLS',PER_RIC_PKG.column_info_tbl(
69: PER_RIC_PKG.col_info_rec('BUDGET_UNIT_ID', NULL, p_rec.shared_type_id,NULL))),
70: PER_RIC_PKG.ref_info_rec('PQH_POSITION_TRANSACTIONS',PER_RIC_PKG.column_info_tbl(
71: PER_RIC_PKG.col_info_rec('AVAILABILITY_STATUS_ID', NULL,p_rec.shared_type_id,NULL))),
72: PER_RIC_PKG.ref_info_rec('PER_SHARED_TYPES_TL',PER_RIC_PKG.column_info_tbl(
73: PER_RIC_PKG.col_info_rec('SHARED_TYPE_ID', NULL, p_rec.shared_type_id,NULL)))),

Line 70: PER_RIC_PKG.ref_info_rec('PQH_POSITION_TRANSACTIONS',PER_RIC_PKG.column_info_tbl(

66: PER_RIC_PKG.ref_info_rec('PQH_BUDGETS',PER_RIC_PKG.column_info_tbl(
67: PER_RIC_PKG.col_info_rec('BUDGET_UNIT3_ID', NULL,p_rec.shared_type_id,NULL))),
68: PER_RIC_PKG.ref_info_rec('PQH_BUDGET_POOLS',PER_RIC_PKG.column_info_tbl(
69: PER_RIC_PKG.col_info_rec('BUDGET_UNIT_ID', NULL, p_rec.shared_type_id,NULL))),
70: PER_RIC_PKG.ref_info_rec('PQH_POSITION_TRANSACTIONS',PER_RIC_PKG.column_info_tbl(
71: PER_RIC_PKG.col_info_rec('AVAILABILITY_STATUS_ID', NULL,p_rec.shared_type_id,NULL))),
72: PER_RIC_PKG.ref_info_rec('PER_SHARED_TYPES_TL',PER_RIC_PKG.column_info_tbl(
73: PER_RIC_PKG.col_info_rec('SHARED_TYPE_ID', NULL, p_rec.shared_type_id,NULL)))),
74: p_ref_type=>'DEL');

Line 71: PER_RIC_PKG.col_info_rec('AVAILABILITY_STATUS_ID', NULL,p_rec.shared_type_id,NULL))),

67: PER_RIC_PKG.col_info_rec('BUDGET_UNIT3_ID', NULL,p_rec.shared_type_id,NULL))),
68: PER_RIC_PKG.ref_info_rec('PQH_BUDGET_POOLS',PER_RIC_PKG.column_info_tbl(
69: PER_RIC_PKG.col_info_rec('BUDGET_UNIT_ID', NULL, p_rec.shared_type_id,NULL))),
70: PER_RIC_PKG.ref_info_rec('PQH_POSITION_TRANSACTIONS',PER_RIC_PKG.column_info_tbl(
71: PER_RIC_PKG.col_info_rec('AVAILABILITY_STATUS_ID', NULL,p_rec.shared_type_id,NULL))),
72: PER_RIC_PKG.ref_info_rec('PER_SHARED_TYPES_TL',PER_RIC_PKG.column_info_tbl(
73: PER_RIC_PKG.col_info_rec('SHARED_TYPE_ID', NULL, p_rec.shared_type_id,NULL)))),
74: p_ref_type=>'DEL');
75: --

Line 72: PER_RIC_PKG.ref_info_rec('PER_SHARED_TYPES_TL',PER_RIC_PKG.column_info_tbl(

68: PER_RIC_PKG.ref_info_rec('PQH_BUDGET_POOLS',PER_RIC_PKG.column_info_tbl(
69: PER_RIC_PKG.col_info_rec('BUDGET_UNIT_ID', NULL, p_rec.shared_type_id,NULL))),
70: PER_RIC_PKG.ref_info_rec('PQH_POSITION_TRANSACTIONS',PER_RIC_PKG.column_info_tbl(
71: PER_RIC_PKG.col_info_rec('AVAILABILITY_STATUS_ID', NULL,p_rec.shared_type_id,NULL))),
72: PER_RIC_PKG.ref_info_rec('PER_SHARED_TYPES_TL',PER_RIC_PKG.column_info_tbl(
73: PER_RIC_PKG.col_info_rec('SHARED_TYPE_ID', NULL, p_rec.shared_type_id,NULL)))),
74: p_ref_type=>'DEL');
75: --
76: -- Code Ends Here

Line 73: PER_RIC_PKG.col_info_rec('SHARED_TYPE_ID', NULL, p_rec.shared_type_id,NULL)))),

69: PER_RIC_PKG.col_info_rec('BUDGET_UNIT_ID', NULL, p_rec.shared_type_id,NULL))),
70: PER_RIC_PKG.ref_info_rec('PQH_POSITION_TRANSACTIONS',PER_RIC_PKG.column_info_tbl(
71: PER_RIC_PKG.col_info_rec('AVAILABILITY_STATUS_ID', NULL,p_rec.shared_type_id,NULL))),
72: PER_RIC_PKG.ref_info_rec('PER_SHARED_TYPES_TL',PER_RIC_PKG.column_info_tbl(
73: PER_RIC_PKG.col_info_rec('SHARED_TYPE_ID', NULL, p_rec.shared_type_id,NULL)))),
74: p_ref_type=>'DEL');
75: --
76: -- Code Ends Here
77: --