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(
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))),
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(
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))),
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(
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))),
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(
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))),
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(
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))),
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(
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))),
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(
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))),
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(
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))),
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(
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))),
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(
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))),
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(
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))),
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(
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))),
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(
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))),
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(
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)))),
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');
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: --
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
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: --