DBA Data[Home] [Help]

APPS.HR_ITP_INS dependencies on PER_RIC_PKG

Line 71: PER_RIC_PKG.chk_integrity (

67: -- Added the following code as a part of Zero Downtime Patching Project.
68: -- Code Starts Here.
69: --
70: --
71: PER_RIC_PKG.chk_integrity (
72: p_entity_name=>'HR_ITEM_PROPERTIES_B',
73: p_ref_entity_info=>
74: PER_RIC_PKG.ref_entity_tbl(
75: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(

Line 74: PER_RIC_PKG.ref_entity_tbl(

70: --
71: PER_RIC_PKG.chk_integrity (
72: p_entity_name=>'HR_ITEM_PROPERTIES_B',
73: p_ref_entity_info=>
74: PER_RIC_PKG.ref_entity_tbl(
75: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
76: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.form_item_id,NULL))),
77: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
78: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id1,NULL))),

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

71: PER_RIC_PKG.chk_integrity (
72: p_entity_name=>'HR_ITEM_PROPERTIES_B',
73: p_ref_entity_info=>
74: PER_RIC_PKG.ref_entity_tbl(
75: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
76: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.form_item_id,NULL))),
77: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
78: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id1,NULL))),
79: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(

Line 76: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.form_item_id,NULL))),

72: p_entity_name=>'HR_ITEM_PROPERTIES_B',
73: p_ref_entity_info=>
74: PER_RIC_PKG.ref_entity_tbl(
75: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
76: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.form_item_id,NULL))),
77: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
78: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id1,NULL))),
79: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
80: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id2,NULL))),

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

73: p_ref_entity_info=>
74: PER_RIC_PKG.ref_entity_tbl(
75: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
76: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.form_item_id,NULL))),
77: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
78: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id1,NULL))),
79: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
80: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id2,NULL))),
81: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(

Line 78: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id1,NULL))),

74: PER_RIC_PKG.ref_entity_tbl(
75: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
76: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.form_item_id,NULL))),
77: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
78: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id1,NULL))),
79: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
80: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id2,NULL))),
81: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
82: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id3,NULL))),

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

75: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
76: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.form_item_id,NULL))),
77: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
78: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id1,NULL))),
79: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
80: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id2,NULL))),
81: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
82: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id3,NULL))),
83: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(

Line 80: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id2,NULL))),

76: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.form_item_id,NULL))),
77: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
78: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id1,NULL))),
79: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
80: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id2,NULL))),
81: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
82: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id3,NULL))),
83: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
84: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id4,NULL))),

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

77: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
78: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id1,NULL))),
79: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
80: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id2,NULL))),
81: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
82: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id3,NULL))),
83: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
84: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id4,NULL))),
85: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(

Line 82: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id3,NULL))),

78: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id1,NULL))),
79: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
80: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id2,NULL))),
81: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
82: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id3,NULL))),
83: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
84: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id4,NULL))),
85: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
86: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id5,NULL))),

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

79: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
80: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id2,NULL))),
81: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
82: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id3,NULL))),
83: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
84: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id4,NULL))),
85: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
86: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id5,NULL))),
87: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(

Line 84: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id4,NULL))),

80: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id2,NULL))),
81: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
82: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id3,NULL))),
83: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
84: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id4,NULL))),
85: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
86: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id5,NULL))),
87: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
88: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id1,NULL))),

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

81: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
82: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id3,NULL))),
83: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
84: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id4,NULL))),
85: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
86: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id5,NULL))),
87: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
88: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id1,NULL))),
89: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(

Line 86: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id5,NULL))),

82: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id3,NULL))),
83: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
84: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id4,NULL))),
85: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
86: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id5,NULL))),
87: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
88: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id1,NULL))),
89: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
90: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id2,NULL))),

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

83: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
84: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id4,NULL))),
85: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
86: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id5,NULL))),
87: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
88: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id1,NULL))),
89: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
90: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id2,NULL))),
91: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(

Line 88: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id1,NULL))),

84: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id4,NULL))),
85: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
86: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id5,NULL))),
87: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
88: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id1,NULL))),
89: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
90: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id2,NULL))),
91: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
92: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id3,NULL))),

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

85: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
86: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id5,NULL))),
87: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
88: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id1,NULL))),
89: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
90: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id2,NULL))),
91: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
92: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id3,NULL))),
93: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(

Line 90: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id2,NULL))),

86: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id5,NULL))),
87: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
88: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id1,NULL))),
89: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
90: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id2,NULL))),
91: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
92: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id3,NULL))),
93: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
94: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id4,NULL))),

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

87: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
88: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id1,NULL))),
89: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
90: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id2,NULL))),
91: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
92: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id3,NULL))),
93: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
94: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id4,NULL))),
95: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(

Line 92: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id3,NULL))),

88: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id1,NULL))),
89: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
90: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id2,NULL))),
91: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
92: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id3,NULL))),
93: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
94: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id4,NULL))),
95: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
96: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id5,NULL))),

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

89: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
90: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id2,NULL))),
91: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
92: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id3,NULL))),
93: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
94: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id4,NULL))),
95: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
96: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id5,NULL))),
97: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(

Line 94: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id4,NULL))),

90: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id2,NULL))),
91: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
92: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id3,NULL))),
93: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
94: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id4,NULL))),
95: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
96: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id5,NULL))),
97: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
98: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.next_navigation_item_id ,NULL))),

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

91: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
92: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id3,NULL))),
93: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
94: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id4,NULL))),
95: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
96: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id5,NULL))),
97: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
98: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.next_navigation_item_id ,NULL))),
99: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(

Line 96: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id5,NULL))),

92: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id3,NULL))),
93: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
94: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id4,NULL))),
95: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
96: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id5,NULL))),
97: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
98: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.next_navigation_item_id ,NULL))),
99: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
100: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.previous_navigation_item_id,NULL))),

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

93: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
94: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id4,NULL))),
95: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
96: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id5,NULL))),
97: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
98: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.next_navigation_item_id ,NULL))),
99: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
100: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.previous_navigation_item_id,NULL))),
101: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(

Line 98: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.next_navigation_item_id ,NULL))),

94: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id4,NULL))),
95: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
96: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id5,NULL))),
97: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
98: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.next_navigation_item_id ,NULL))),
99: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
100: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.previous_navigation_item_id,NULL))),
101: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
102: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,p_rec.template_item_id,NULL))),

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

95: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
96: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id5,NULL))),
97: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
98: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.next_navigation_item_id ,NULL))),
99: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
100: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.previous_navigation_item_id,NULL))),
101: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
102: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,p_rec.template_item_id,NULL))),
103: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B',PER_RIC_PKG.column_info_tbl(

Line 100: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.previous_navigation_item_id,NULL))),

96: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id5,NULL))),
97: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
98: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.next_navigation_item_id ,NULL))),
99: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
100: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.previous_navigation_item_id,NULL))),
101: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
102: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,p_rec.template_item_id,NULL))),
103: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B',PER_RIC_PKG.column_info_tbl(
104: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,p_rec.template_item_context_id ,NULL)))),

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

97: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
98: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.next_navigation_item_id ,NULL))),
99: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
100: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.previous_navigation_item_id,NULL))),
101: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
102: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,p_rec.template_item_id,NULL))),
103: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B',PER_RIC_PKG.column_info_tbl(
104: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,p_rec.template_item_context_id ,NULL)))),
105: p_ref_type=>'INS');

Line 102: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,p_rec.template_item_id,NULL))),

98: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.next_navigation_item_id ,NULL))),
99: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
100: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.previous_navigation_item_id,NULL))),
101: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
102: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,p_rec.template_item_id,NULL))),
103: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B',PER_RIC_PKG.column_info_tbl(
104: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,p_rec.template_item_context_id ,NULL)))),
105: p_ref_type=>'INS');
106: --

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

99: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
100: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.previous_navigation_item_id,NULL))),
101: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
102: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,p_rec.template_item_id,NULL))),
103: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B',PER_RIC_PKG.column_info_tbl(
104: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,p_rec.template_item_context_id ,NULL)))),
105: p_ref_type=>'INS');
106: --
107: -- Code Ends Here

Line 104: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,p_rec.template_item_context_id ,NULL)))),

100: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.previous_navigation_item_id,NULL))),
101: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
102: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,p_rec.template_item_id,NULL))),
103: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B',PER_RIC_PKG.column_info_tbl(
104: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,p_rec.template_item_context_id ,NULL)))),
105: p_ref_type=>'INS');
106: --
107: -- Code Ends Here
108: --