[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure update_dml(p_rec in out nocopy ghr_pah_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'update_dml';
update ghr_pa_history
set
pa_history_id = p_rec.pa_history_id,
pa_request_id = p_rec.pa_request_id,
process_date = p_rec.process_date,
nature_of_action_id = p_rec.nature_of_action_id,
effective_date = p_rec.effective_date,
altered_pa_request_id = p_rec.altered_pa_request_id,
person_id = p_rec.person_id,
assignment_id = p_rec.assignment_id,
dml_operation = p_rec.dml_operation,
table_name = p_rec.table_name,
pre_values_flag = p_rec.pre_values_flag,
information1 = p_rec.information1,
information2 = p_rec.information2,
information3 = p_rec.information3,
information4 = p_rec.information4,
information5 = p_rec.information5,
information6 = p_rec.information6,
information7 = p_rec.information7,
information8 = p_rec.information8,
information9 = p_rec.information9,
information10 = p_rec.information10,
information11 = p_rec.information11,
information12 = p_rec.information12,
information13 = p_rec.information13,
information14 = p_rec.information14,
information15 = p_rec.information15,
information16 = p_rec.information16,
information17 = p_rec.information17,
information18 = p_rec.information18,
information19 = p_rec.information19,
information20 = p_rec.information20,
information21 = p_rec.information21,
information22 = p_rec.information22,
information23 = p_rec.information23,
information24 = p_rec.information24,
information25 = p_rec.information25,
information26 = p_rec.information26,
information27 = p_rec.information27,
information28 = p_rec.information28,
information29 = p_rec.information29,
information30 = p_rec.information30,
information31 = p_rec.information31,
information32 = p_rec.information32,
information33 = p_rec.information33,
information34 = p_rec.information34,
information35 = p_rec.information35,
information36 = p_rec.information36,
information37 = p_rec.information37,
information38 = p_rec.information38,
information39 = p_rec.information39,
information47 = p_rec.information47,
information48 = p_rec.information48,
information49 = p_rec.information49,
information40 = p_rec.information40,
information41 = p_rec.information41,
information42 = p_rec.information42,
information43 = p_rec.information43,
information44 = p_rec.information44,
information45 = p_rec.information45,
information46 = p_rec.information46,
information50 = p_rec.information50,
information51 = p_rec.information51,
information52 = p_rec.information52,
information53 = p_rec.information53,
information54 = p_rec.information54,
information55 = p_rec.information55,
information56 = p_rec.information56,
information57 = p_rec.information57,
information58 = p_rec.information58,
information59 = p_rec.information59,
information60 = p_rec.information60,
information61 = p_rec.information61,
information62 = p_rec.information62,
information63 = p_rec.information63,
information64 = p_rec.information64,
information65 = p_rec.information65,
information66 = p_rec.information66,
information67 = p_rec.information67,
information68 = p_rec.information68,
information69 = p_rec.information69,
information70 = p_rec.information70,
information71 = p_rec.information71,
information72 = p_rec.information72,
information73 = p_rec.information73,
information74 = p_rec.information74,
information75 = p_rec.information75,
information76 = p_rec.information76,
information77 = p_rec.information77,
information78 = p_rec.information78,
information79 = p_rec.information79,
information80 = p_rec.information80,
information81 = p_rec.information81,
information82 = p_rec.information82,
information83 = p_rec.information83,
information84 = p_rec.information84,
information85 = p_rec.information85,
information86 = p_rec.information86,
information87 = p_rec.information87,
information88 = p_rec.information88,
information89 = p_rec.information89,
information90 = p_rec.information90,
information91 = p_rec.information91,
information92 = p_rec.information92,
information93 = p_rec.information93,
information94 = p_rec.information94,
information95 = p_rec.information95,
information96 = p_rec.information96,
information97 = p_rec.information97,
information98 = p_rec.information98,
information99 = p_rec.information99,
information100 = p_rec.information100,
information101 = p_rec.information101,
information102 = p_rec.information102,
information103 = p_rec.information103,
information104 = p_rec.information104,
information105 = p_rec.information105,
information106 = p_rec.information106,
information107 = p_rec.information107,
information108 = p_rec.information108,
information109 = p_rec.information109,
information110 = p_rec.information110,
information111 = p_rec.information111,
information112 = p_rec.information112,
information113 = p_rec.information113,
information114 = p_rec.information114,
information115 = p_rec.information115,
information116 = p_rec.information116,
information117 = p_rec.information117,
information118 = p_rec.information118,
information119 = p_rec.information119,
information120 = p_rec.information120,
information121 = p_rec.information121,
information122 = p_rec.information122,
information123 = p_rec.information123,
information124 = p_rec.information124,
information125 = p_rec.information125,
information126 = p_rec.information126,
information127 = p_rec.information127,
information128 = p_rec.information128,
information129 = p_rec.information129,
information130 = p_rec.information130,
information131 = p_rec.information131,
information132 = p_rec.information132,
information133 = p_rec.information133,
information134 = p_rec.information134,
information135 = p_rec.information135,
information136 = p_rec.information136,
information137 = p_rec.information137,
information138 = p_rec.information138,
information139 = p_rec.information139,
information140 = p_rec.information140,
information141 = p_rec.information141,
information142 = p_rec.information142,
information143 = p_rec.information143,
information144 = p_rec.information144,
information145 = p_rec.information145,
information146 = p_rec.information146,
information147 = p_rec.information147,
information148 = p_rec.information148,
information149 = p_rec.information149,
information150 = p_rec.information150,
information151 = p_rec.information151,
information152 = p_rec.information152,
information153 = p_rec.information153,
information154 = p_rec.information154,
information155 = p_rec.information155,
information156 = p_rec.information156,
information157 = p_rec.information157,
information158 = p_rec.information158,
information159 = p_rec.information159,
information160 = p_rec.information160,
information161 = p_rec.information161,
information162 = p_rec.information162,
information163 = p_rec.information163,
information164 = p_rec.information164,
information165 = p_rec.information165,
information166 = p_rec.information166,
information167 = p_rec.information167,
information168 = p_rec.information168,
information169 = p_rec.information169,
information170 = p_rec.information170,
information171 = p_rec.information171,
information172 = p_rec.information172,
information173 = p_rec.information173,
information174 = p_rec.information174,
information175 = p_rec.information175,
information176 = p_rec.information176,
information177 = p_rec.information177,
information178 = p_rec.information178,
information179 = p_rec.information179,
information180 = p_rec.information180,
information181 = p_rec.information181,
information182 = p_rec.information182,
information183 = p_rec.information183,
information184 = p_rec.information184,
information185 = p_rec.information185,
information186 = p_rec.information186,
information187 = p_rec.information187,
information188 = p_rec.information188,
information189 = p_rec.information189,
information190 = p_rec.information190,
information191 = p_rec.information191,
information192 = p_rec.information192,
information193 = p_rec.information193,
information194 = p_rec.information194,
information195 = p_rec.information195,
information196 = p_rec.information196,
information197 = p_rec.information197,
information198 = p_rec.information198,
information199 = p_rec.information199,
information200 = p_rec.information200
where pa_history_id = p_rec.pa_history_id;
End update_dml;
Procedure pre_update(p_rec in ghr_pah_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'pre_update';
End pre_update;
Procedure post_update(p_rec in ghr_pah_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'post_update';
ghr_pah_rku.after_update (
p_PA_HISTORY_ID => p_rec.PA_HISTORY_ID ,
p_PA_REQUEST_ID => p_rec.PA_REQUEST_ID ,
p_PROCESS_DATE => p_rec.PROCESS_DATE ,
p_NATURE_OF_ACTION_ID => p_rec.NATURE_OF_ACTION_ID ,
p_EFFECTIVE_DATE => p_rec.EFFECTIVE_DATE ,
p_ALTERED_PA_REQUEST_ID => p_rec.ALTERED_PA_REQUEST_ID ,
p_PERSON_ID => p_rec.PERSON_ID ,
p_ASSIGNMENT_ID => p_rec.ASSIGNMENT_ID ,
p_DML_OPERATION => p_rec.DML_OPERATION ,
p_TABLE_NAME => p_rec.TABLE_NAME ,
p_PRE_VALUES_FLAG => p_rec.PRE_VALUES_FLAG ,
p_INFORMATION1 => p_rec.INFORMATION1 ,
p_INFORMATION2 => p_rec.INFORMATION2 ,
p_INFORMATION3 => p_rec.INFORMATION3 ,
p_INFORMATION4 => p_rec.INFORMATION4 ,
p_INFORMATION5 => p_rec.INFORMATION5 ,
p_INFORMATION6 => p_rec.INFORMATION6 ,
p_INFORMATION7 => p_rec.INFORMATION7 ,
p_INFORMATION8 => p_rec.INFORMATION8 ,
p_INFORMATION9 => p_rec.INFORMATION9 ,
p_INFORMATION10 => p_rec.INFORMATION10 ,
p_INFORMATION11 => p_rec.INFORMATION11 ,
p_INFORMATION12 => p_rec.INFORMATION12 ,
p_INFORMATION13 => p_rec.INFORMATION13 ,
p_INFORMATION14 => p_rec.INFORMATION14 ,
p_INFORMATION15 => p_rec.INFORMATION15 ,
p_INFORMATION16 => p_rec.INFORMATION16 ,
p_INFORMATION17 => p_rec.INFORMATION17 ,
p_INFORMATION18 => p_rec.INFORMATION18 ,
p_INFORMATION19 => p_rec.INFORMATION19 ,
p_INFORMATION20 => p_rec.INFORMATION20 ,
p_INFORMATION21 => p_rec.INFORMATION21 ,
p_INFORMATION22 => p_rec.INFORMATION22 ,
p_INFORMATION23 => p_rec.INFORMATION23 ,
p_INFORMATION24 => p_rec.INFORMATION24 ,
p_INFORMATION25 => p_rec.INFORMATION25 ,
p_INFORMATION26 => p_rec.INFORMATION26 ,
p_INFORMATION27 => p_rec.INFORMATION27 ,
p_INFORMATION28 => p_rec.INFORMATION28 ,
p_INFORMATION29 => p_rec.INFORMATION29 ,
p_INFORMATION30 => p_rec.INFORMATION30 ,
p_INFORMATION31 => p_rec.INFORMATION31 ,
p_INFORMATION32 => p_rec.INFORMATION32 ,
p_INFORMATION33 => p_rec.INFORMATION33 ,
p_INFORMATION34 => p_rec.INFORMATION34 ,
p_INFORMATION35 => p_rec.INFORMATION35 ,
p_INFORMATION36 => p_rec.INFORMATION36 ,
p_INFORMATION37 => p_rec.INFORMATION37 ,
p_INFORMATION38 => p_rec.INFORMATION38 ,
p_INFORMATION39 => p_rec.INFORMATION39 ,
p_INFORMATION47 => p_rec.INFORMATION47 ,
p_INFORMATION48 => p_rec.INFORMATION48 ,
p_INFORMATION49 => p_rec.INFORMATION49 ,
p_INFORMATION40 => p_rec.INFORMATION40 ,
p_INFORMATION41 => p_rec.INFORMATION41 ,
p_INFORMATION42 => p_rec.INFORMATION42 ,
p_INFORMATION43 => p_rec.INFORMATION43 ,
p_INFORMATION44 => p_rec.INFORMATION44 ,
p_INFORMATION45 => p_rec.INFORMATION45 ,
p_INFORMATION46 => p_rec.INFORMATION46 ,
p_INFORMATION50 => p_rec.INFORMATION50 ,
p_INFORMATION51 => p_rec.INFORMATION51 ,
p_INFORMATION52 => p_rec.INFORMATION52 ,
p_INFORMATION53 => p_rec.INFORMATION53 ,
p_INFORMATION54 => p_rec.INFORMATION54 ,
p_INFORMATION55 => p_rec.INFORMATION55 ,
p_INFORMATION56 => p_rec.INFORMATION56 ,
p_INFORMATION57 => p_rec.INFORMATION57 ,
p_INFORMATION58 => p_rec.INFORMATION58 ,
p_INFORMATION59 => p_rec.INFORMATION59 ,
p_INFORMATION60 => p_rec.INFORMATION60 ,
p_INFORMATION61 => p_rec.INFORMATION61 ,
p_INFORMATION62 => p_rec.INFORMATION62 ,
p_INFORMATION63 => p_rec.INFORMATION63 ,
p_INFORMATION64 => p_rec.INFORMATION64 ,
p_INFORMATION65 => p_rec.INFORMATION65 ,
p_INFORMATION66 => p_rec.INFORMATION66 ,
p_INFORMATION67 => p_rec.INFORMATION67 ,
p_INFORMATION68 => p_rec.INFORMATION68 ,
p_INFORMATION69 => p_rec.INFORMATION69 ,
p_INFORMATION70 => p_rec.INFORMATION70 ,
p_INFORMATION71 => p_rec.INFORMATION71 ,
p_INFORMATION72 => p_rec.INFORMATION72 ,
p_INFORMATION73 => p_rec.INFORMATION73 ,
p_INFORMATION74 => p_rec.INFORMATION74 ,
p_INFORMATION75 => p_rec.INFORMATION75 ,
p_INFORMATION76 => p_rec.INFORMATION76 ,
p_INFORMATION77 => p_rec.INFORMATION77 ,
p_INFORMATION78 => p_rec.INFORMATION78 ,
p_INFORMATION79 => p_rec.INFORMATION79 ,
p_INFORMATION80 => p_rec.INFORMATION80 ,
p_INFORMATION81 => p_rec.INFORMATION81 ,
p_INFORMATION82 => p_rec.INFORMATION82 ,
p_INFORMATION83 => p_rec.INFORMATION83 ,
p_INFORMATION84 => p_rec.INFORMATION84 ,
p_INFORMATION85 => p_rec.INFORMATION85 ,
p_INFORMATION86 => p_rec.INFORMATION86 ,
p_INFORMATION87 => p_rec.INFORMATION87 ,
p_INFORMATION88 => p_rec.INFORMATION88 ,
p_INFORMATION89 => p_rec.INFORMATION89 ,
p_INFORMATION90 => p_rec.INFORMATION90 ,
p_INFORMATION91 => p_rec.INFORMATION91 ,
p_INFORMATION92 => p_rec.INFORMATION92 ,
p_INFORMATION93 => p_rec.INFORMATION93 ,
p_INFORMATION94 => p_rec.INFORMATION94 ,
p_INFORMATION95 => p_rec.INFORMATION95 ,
p_INFORMATION96 => p_rec.INFORMATION96 ,
p_INFORMATION97 => p_rec.INFORMATION97 ,
p_INFORMATION98 => p_rec.INFORMATION98 ,
p_INFORMATION99 => p_rec.INFORMATION99 ,
p_INFORMATION100 => p_rec.INFORMATION100 ,
p_INFORMATION101 => p_rec.INFORMATION101 ,
p_INFORMATION102 => p_rec.INFORMATION102 ,
p_INFORMATION103 => p_rec.INFORMATION103 ,
p_INFORMATION104 => p_rec.INFORMATION104 ,
p_INFORMATION105 => p_rec.INFORMATION105 ,
p_INFORMATION106 => p_rec.INFORMATION106 ,
p_INFORMATION107 => p_rec.INFORMATION107 ,
p_INFORMATION108 => p_rec.INFORMATION108 ,
p_INFORMATION109 => p_rec.INFORMATION109 ,
p_INFORMATION110 => p_rec.INFORMATION110 ,
p_INFORMATION111 => p_rec.INFORMATION111 ,
p_INFORMATION112 => p_rec.INFORMATION112 ,
p_INFORMATION113 => p_rec.INFORMATION113 ,
p_INFORMATION114 => p_rec.INFORMATION114 ,
p_INFORMATION115 => p_rec.INFORMATION115 ,
p_INFORMATION116 => p_rec.INFORMATION116 ,
p_INFORMATION117 => p_rec.INFORMATION117 ,
p_INFORMATION118 => p_rec.INFORMATION118 ,
p_INFORMATION119 => p_rec.INFORMATION119 ,
p_INFORMATION120 => p_rec.INFORMATION120 ,
p_INFORMATION121 => p_rec.INFORMATION121 ,
p_INFORMATION122 => p_rec.INFORMATION122 ,
p_INFORMATION123 => p_rec.INFORMATION123 ,
p_INFORMATION124 => p_rec.INFORMATION124 ,
p_INFORMATION125 => p_rec.INFORMATION125 ,
p_INFORMATION126 => p_rec.INFORMATION126 ,
p_INFORMATION127 => p_rec.INFORMATION127 ,
p_INFORMATION128 => p_rec.INFORMATION128 ,
p_INFORMATION129 => p_rec.INFORMATION129 ,
p_INFORMATION130 => p_rec.INFORMATION130 ,
p_INFORMATION131 => p_rec.INFORMATION131 ,
p_INFORMATION132 => p_rec.INFORMATION132 ,
p_INFORMATION133 => p_rec.INFORMATION133 ,
p_INFORMATION134 => p_rec.INFORMATION134 ,
p_INFORMATION135 => p_rec.INFORMATION135 ,
p_INFORMATION136 => p_rec.INFORMATION136 ,
p_INFORMATION137 => p_rec.INFORMATION137 ,
p_INFORMATION138 => p_rec.INFORMATION138 ,
p_INFORMATION139 => p_rec.INFORMATION139 ,
p_INFORMATION140 => p_rec.INFORMATION140 ,
p_INFORMATION141 => p_rec.INFORMATION141 ,
p_INFORMATION142 => p_rec.INFORMATION142 ,
p_INFORMATION143 => p_rec.INFORMATION143 ,
p_INFORMATION144 => p_rec.INFORMATION144 ,
p_INFORMATION145 => p_rec.INFORMATION145 ,
p_INFORMATION146 => p_rec.INFORMATION146 ,
p_INFORMATION147 => p_rec.INFORMATION147 ,
p_INFORMATION148 => p_rec.INFORMATION148 ,
p_INFORMATION149 => p_rec.INFORMATION149 ,
p_INFORMATION150 => p_rec.INFORMATION150 ,
p_INFORMATION151 => p_rec.INFORMATION151 ,
p_INFORMATION152 => p_rec.INFORMATION152 ,
p_INFORMATION153 => p_rec.INFORMATION153 ,
p_INFORMATION154 => p_rec.INFORMATION154 ,
p_INFORMATION155 => p_rec.INFORMATION155 ,
p_INFORMATION156 => p_rec.INFORMATION156 ,
p_INFORMATION157 => p_rec.INFORMATION157 ,
p_INFORMATION158 => p_rec.INFORMATION158 ,
p_INFORMATION159 => p_rec.INFORMATION159 ,
p_INFORMATION160 => p_rec.INFORMATION160 ,
p_INFORMATION161 => p_rec.INFORMATION161 ,
p_INFORMATION162 => p_rec.INFORMATION162 ,
p_INFORMATION163 => p_rec.INFORMATION163 ,
p_INFORMATION164 => p_rec.INFORMATION164 ,
p_INFORMATION165 => p_rec.INFORMATION165 ,
p_INFORMATION166 => p_rec.INFORMATION166 ,
p_INFORMATION167 => p_rec.INFORMATION167 ,
p_INFORMATION168 => p_rec.INFORMATION168 ,
p_INFORMATION169 => p_rec.INFORMATION169 ,
p_INFORMATION170 => p_rec.INFORMATION170 ,
p_INFORMATION171 => p_rec.INFORMATION171 ,
p_INFORMATION172 => p_rec.INFORMATION172 ,
p_INFORMATION173 => p_rec.INFORMATION173 ,
p_INFORMATION174 => p_rec.INFORMATION174 ,
p_INFORMATION175 => p_rec.INFORMATION175 ,
p_INFORMATION176 => p_rec.INFORMATION176 ,
p_INFORMATION177 => p_rec.INFORMATION177 ,
p_INFORMATION178 => p_rec.INFORMATION178 ,
p_INFORMATION179 => p_rec.INFORMATION179 ,
p_INFORMATION180 => p_rec.INFORMATION180 ,
p_INFORMATION181 => p_rec.INFORMATION181 ,
p_INFORMATION182 => p_rec.INFORMATION182 ,
p_INFORMATION183 => p_rec.INFORMATION183 ,
p_INFORMATION184 => p_rec.INFORMATION184 ,
p_INFORMATION185 => p_rec.INFORMATION185 ,
p_INFORMATION186 => p_rec.INFORMATION186 ,
p_INFORMATION187 => p_rec.INFORMATION187 ,
p_INFORMATION188 => p_rec.INFORMATION188 ,
p_INFORMATION189 => p_rec.INFORMATION189 ,
p_INFORMATION190 => p_rec.INFORMATION190 ,
p_INFORMATION191 => p_rec.INFORMATION191 ,
p_INFORMATION192 => p_rec.INFORMATION192 ,
p_INFORMATION193 => p_rec.INFORMATION193 ,
p_INFORMATION194 => p_rec.INFORMATION194 ,
p_INFORMATION195 => p_rec.INFORMATION195 ,
p_INFORMATION196 => p_rec.INFORMATION196 ,
p_INFORMATION197 => p_rec.INFORMATION197 ,
p_INFORMATION198 => p_rec.INFORMATION198 ,
p_INFORMATION199 => p_rec.INFORMATION199 ,
p_INFORMATION200 => p_rec.INFORMATION200 ,
p_PA_REQUEST_ID_o => ghr_pah_shd.g_old_rec.PA_REQUEST_ID ,
p_PROCESS_DATE_o => ghr_pah_shd.g_old_rec.PROCESS_DATE ,
p_NATURE_OF_ACTION_ID_o => ghr_pah_shd.g_old_rec.NATURE_OF_ACTION_ID ,
p_EFFECTIVE_DATE_o => ghr_pah_shd.g_old_rec.EFFECTIVE_DATE ,
p_ALTERED_PA_REQUEST_ID_o => ghr_pah_shd.g_old_rec.ALTERED_PA_REQUEST_ID ,
p_PERSON_ID_o => ghr_pah_shd.g_old_rec.PERSON_ID ,
p_ASSIGNMENT_ID_o => ghr_pah_shd.g_old_rec.ASSIGNMENT_ID ,
p_DML_OPERATION_o => ghr_pah_shd.g_old_rec.DML_OPERATION ,
p_TABLE_NAME_o => ghr_pah_shd.g_old_rec.TABLE_NAME ,
p_PRE_VALUES_FLAG_o => ghr_pah_shd.g_old_rec.PRE_VALUES_FLAG ,
p_INFORMATION1_o => ghr_pah_shd.g_old_rec.INFORMATION1 ,
p_INFORMATION2_o => ghr_pah_shd.g_old_rec.INFORMATION2 ,
p_INFORMATION3_o => ghr_pah_shd.g_old_rec.INFORMATION3 ,
p_INFORMATION4_o => ghr_pah_shd.g_old_rec.INFORMATION4 ,
p_INFORMATION5_o => ghr_pah_shd.g_old_rec.INFORMATION5 ,
p_INFORMATION6_o => ghr_pah_shd.g_old_rec.INFORMATION6 ,
p_INFORMATION7_o => ghr_pah_shd.g_old_rec.INFORMATION7 ,
p_INFORMATION8_o => ghr_pah_shd.g_old_rec.INFORMATION8 ,
p_INFORMATION9_o => ghr_pah_shd.g_old_rec.INFORMATION9 ,
p_INFORMATION10_o => ghr_pah_shd.g_old_rec.INFORMATION10 ,
p_INFORMATION11_o => ghr_pah_shd.g_old_rec.INFORMATION11 ,
p_INFORMATION12_o => ghr_pah_shd.g_old_rec.INFORMATION12 ,
p_INFORMATION13_o => ghr_pah_shd.g_old_rec.INFORMATION13 ,
p_INFORMATION14_o => ghr_pah_shd.g_old_rec.INFORMATION14 ,
p_INFORMATION15_o => ghr_pah_shd.g_old_rec.INFORMATION15 ,
p_INFORMATION16_o => ghr_pah_shd.g_old_rec.INFORMATION16 ,
p_INFORMATION17_o => ghr_pah_shd.g_old_rec.INFORMATION17 ,
p_INFORMATION18_o => ghr_pah_shd.g_old_rec.INFORMATION18 ,
p_INFORMATION19_o => ghr_pah_shd.g_old_rec.INFORMATION19 ,
p_INFORMATION20_o => ghr_pah_shd.g_old_rec.INFORMATION20 ,
p_INFORMATION21_o => ghr_pah_shd.g_old_rec.INFORMATION21 ,
p_INFORMATION22_o => ghr_pah_shd.g_old_rec.INFORMATION22 ,
p_INFORMATION23_o => ghr_pah_shd.g_old_rec.INFORMATION23 ,
p_INFORMATION24_o => ghr_pah_shd.g_old_rec.INFORMATION24 ,
p_INFORMATION25_o => ghr_pah_shd.g_old_rec.INFORMATION25 ,
p_INFORMATION26_o => ghr_pah_shd.g_old_rec.INFORMATION26 ,
p_INFORMATION27_o => ghr_pah_shd.g_old_rec.INFORMATION27 ,
p_INFORMATION28_o => ghr_pah_shd.g_old_rec.INFORMATION28 ,
p_INFORMATION29_o => ghr_pah_shd.g_old_rec.INFORMATION29 ,
p_INFORMATION30_o => ghr_pah_shd.g_old_rec.INFORMATION30 ,
p_INFORMATION31_o => ghr_pah_shd.g_old_rec.INFORMATION31 ,
p_INFORMATION32_o => ghr_pah_shd.g_old_rec.INFORMATION32 ,
p_INFORMATION33_o => ghr_pah_shd.g_old_rec.INFORMATION33 ,
p_INFORMATION34_o => ghr_pah_shd.g_old_rec.INFORMATION34 ,
p_INFORMATION35_o => ghr_pah_shd.g_old_rec.INFORMATION35 ,
p_INFORMATION36_o => ghr_pah_shd.g_old_rec.INFORMATION36 ,
p_INFORMATION37_o => ghr_pah_shd.g_old_rec.INFORMATION37 ,
p_INFORMATION38_o => ghr_pah_shd.g_old_rec.INFORMATION38 ,
p_INFORMATION39_o => ghr_pah_shd.g_old_rec.INFORMATION39 ,
p_INFORMATION47_o => ghr_pah_shd.g_old_rec.INFORMATION47 ,
p_INFORMATION48_o => ghr_pah_shd.g_old_rec.INFORMATION48 ,
p_INFORMATION49_o => ghr_pah_shd.g_old_rec.INFORMATION49 ,
p_INFORMATION40_o => ghr_pah_shd.g_old_rec.INFORMATION40 ,
p_INFORMATION41_o => ghr_pah_shd.g_old_rec.INFORMATION41 ,
p_INFORMATION42_o => ghr_pah_shd.g_old_rec.INFORMATION42 ,
p_INFORMATION43_o => ghr_pah_shd.g_old_rec.INFORMATION43 ,
p_INFORMATION44_o => ghr_pah_shd.g_old_rec.INFORMATION44 ,
p_INFORMATION45_o => ghr_pah_shd.g_old_rec.INFORMATION45 ,
p_INFORMATION46_o => ghr_pah_shd.g_old_rec.INFORMATION46 ,
p_INFORMATION50_o => ghr_pah_shd.g_old_rec.INFORMATION50 ,
p_INFORMATION51_o => ghr_pah_shd.g_old_rec.INFORMATION51 ,
p_INFORMATION52_o => ghr_pah_shd.g_old_rec.INFORMATION52 ,
p_INFORMATION53_o => ghr_pah_shd.g_old_rec.INFORMATION53 ,
p_INFORMATION54_o => ghr_pah_shd.g_old_rec.INFORMATION54 ,
p_INFORMATION55_o => ghr_pah_shd.g_old_rec.INFORMATION55 ,
p_INFORMATION56_o => ghr_pah_shd.g_old_rec.INFORMATION56 ,
p_INFORMATION57_o => ghr_pah_shd.g_old_rec.INFORMATION57 ,
p_INFORMATION58_o => ghr_pah_shd.g_old_rec.INFORMATION58 ,
p_INFORMATION59_o => ghr_pah_shd.g_old_rec.INFORMATION59 ,
p_INFORMATION60_o => ghr_pah_shd.g_old_rec.INFORMATION60 ,
p_INFORMATION61_o => ghr_pah_shd.g_old_rec.INFORMATION61 ,
p_INFORMATION62_o => ghr_pah_shd.g_old_rec.INFORMATION62 ,
p_INFORMATION63_o => ghr_pah_shd.g_old_rec.INFORMATION63 ,
p_INFORMATION64_o => ghr_pah_shd.g_old_rec.INFORMATION64 ,
p_INFORMATION65_o => ghr_pah_shd.g_old_rec.INFORMATION65 ,
p_INFORMATION66_o => ghr_pah_shd.g_old_rec.INFORMATION66 ,
p_INFORMATION67_o => ghr_pah_shd.g_old_rec.INFORMATION67 ,
p_INFORMATION68_o => ghr_pah_shd.g_old_rec.INFORMATION68 ,
p_INFORMATION69_o => ghr_pah_shd.g_old_rec.INFORMATION69 ,
p_INFORMATION70_o => ghr_pah_shd.g_old_rec.INFORMATION70 ,
p_INFORMATION71_o => ghr_pah_shd.g_old_rec.INFORMATION71 ,
p_INFORMATION72_o => ghr_pah_shd.g_old_rec.INFORMATION72 ,
p_INFORMATION73_o => ghr_pah_shd.g_old_rec.INFORMATION73 ,
p_INFORMATION74_o => ghr_pah_shd.g_old_rec.INFORMATION74 ,
p_INFORMATION75_o => ghr_pah_shd.g_old_rec.INFORMATION75 ,
p_INFORMATION76_o => ghr_pah_shd.g_old_rec.INFORMATION76 ,
p_INFORMATION77_o => ghr_pah_shd.g_old_rec.INFORMATION77 ,
p_INFORMATION78_o => ghr_pah_shd.g_old_rec.INFORMATION78 ,
p_INFORMATION79_o => ghr_pah_shd.g_old_rec.INFORMATION79 ,
p_INFORMATION80_o => ghr_pah_shd.g_old_rec.INFORMATION80 ,
p_INFORMATION81_o => ghr_pah_shd.g_old_rec.INFORMATION81 ,
p_INFORMATION82_o => ghr_pah_shd.g_old_rec.INFORMATION82 ,
p_INFORMATION83_o => ghr_pah_shd.g_old_rec.INFORMATION83 ,
p_INFORMATION84_o => ghr_pah_shd.g_old_rec.INFORMATION84 ,
p_INFORMATION85_o => ghr_pah_shd.g_old_rec.INFORMATION85 ,
p_INFORMATION86_o => ghr_pah_shd.g_old_rec.INFORMATION86 ,
p_INFORMATION87_o => ghr_pah_shd.g_old_rec.INFORMATION87 ,
p_INFORMATION88_o => ghr_pah_shd.g_old_rec.INFORMATION88 ,
p_INFORMATION89_o => ghr_pah_shd.g_old_rec.INFORMATION89 ,
p_INFORMATION90_o => ghr_pah_shd.g_old_rec.INFORMATION90 ,
p_INFORMATION91_o => ghr_pah_shd.g_old_rec.INFORMATION91 ,
p_INFORMATION92_o => ghr_pah_shd.g_old_rec.INFORMATION92 ,
p_INFORMATION93_o => ghr_pah_shd.g_old_rec.INFORMATION93 ,
p_INFORMATION94_o => ghr_pah_shd.g_old_rec.INFORMATION94 ,
p_INFORMATION95_o => ghr_pah_shd.g_old_rec.INFORMATION95 ,
p_INFORMATION96_o => ghr_pah_shd.g_old_rec.INFORMATION96 ,
p_INFORMATION97_o => ghr_pah_shd.g_old_rec.INFORMATION97 ,
p_INFORMATION98_o => ghr_pah_shd.g_old_rec.INFORMATION98 ,
p_INFORMATION99_o => ghr_pah_shd.g_old_rec.INFORMATION99 ,
p_INFORMATION100_o => ghr_pah_shd.g_old_rec.INFORMATION100 ,
p_INFORMATION101_o => ghr_pah_shd.g_old_rec.INFORMATION101 ,
p_INFORMATION102_o => ghr_pah_shd.g_old_rec.INFORMATION102 ,
p_INFORMATION103_o => ghr_pah_shd.g_old_rec.INFORMATION103 ,
p_INFORMATION104_o => ghr_pah_shd.g_old_rec.INFORMATION104 ,
p_INFORMATION105_o => ghr_pah_shd.g_old_rec.INFORMATION105 ,
p_INFORMATION106_o => ghr_pah_shd.g_old_rec.INFORMATION106 ,
p_INFORMATION107_o => ghr_pah_shd.g_old_rec.INFORMATION107 ,
p_INFORMATION108_o => ghr_pah_shd.g_old_rec.INFORMATION108 ,
p_INFORMATION109_o => ghr_pah_shd.g_old_rec.INFORMATION109 ,
p_INFORMATION110_o => ghr_pah_shd.g_old_rec.INFORMATION110 ,
p_INFORMATION111_o => ghr_pah_shd.g_old_rec.INFORMATION111 ,
p_INFORMATION112_o => ghr_pah_shd.g_old_rec.INFORMATION112 ,
p_INFORMATION113_o => ghr_pah_shd.g_old_rec.INFORMATION113 ,
p_INFORMATION114_o => ghr_pah_shd.g_old_rec.INFORMATION114 ,
p_INFORMATION115_o => ghr_pah_shd.g_old_rec.INFORMATION115 ,
p_INFORMATION116_o => ghr_pah_shd.g_old_rec.INFORMATION116 ,
p_INFORMATION117_o => ghr_pah_shd.g_old_rec.INFORMATION117 ,
p_INFORMATION118_o => ghr_pah_shd.g_old_rec.INFORMATION118 ,
p_INFORMATION119_o => ghr_pah_shd.g_old_rec.INFORMATION119 ,
p_INFORMATION120_o => ghr_pah_shd.g_old_rec.INFORMATION120 ,
p_INFORMATION121_o => ghr_pah_shd.g_old_rec.INFORMATION121 ,
p_INFORMATION122_o => ghr_pah_shd.g_old_rec.INFORMATION122 ,
p_INFORMATION123_o => ghr_pah_shd.g_old_rec.INFORMATION123 ,
p_INFORMATION124_o => ghr_pah_shd.g_old_rec.INFORMATION124 ,
p_INFORMATION125_o => ghr_pah_shd.g_old_rec.INFORMATION125 ,
p_INFORMATION126_o => ghr_pah_shd.g_old_rec.INFORMATION126 ,
p_INFORMATION127_o => ghr_pah_shd.g_old_rec.INFORMATION127 ,
p_INFORMATION128_o => ghr_pah_shd.g_old_rec.INFORMATION128 ,
p_INFORMATION129_o => ghr_pah_shd.g_old_rec.INFORMATION129 ,
p_INFORMATION130_o => ghr_pah_shd.g_old_rec.INFORMATION130 ,
p_INFORMATION131_o => ghr_pah_shd.g_old_rec.INFORMATION131 ,
p_INFORMATION132_o => ghr_pah_shd.g_old_rec.INFORMATION132 ,
p_INFORMATION133_o => ghr_pah_shd.g_old_rec.INFORMATION133 ,
p_INFORMATION134_o => ghr_pah_shd.g_old_rec.INFORMATION134 ,
p_INFORMATION135_o => ghr_pah_shd.g_old_rec.INFORMATION135 ,
p_INFORMATION136_o => ghr_pah_shd.g_old_rec.INFORMATION136 ,
p_INFORMATION137_o => ghr_pah_shd.g_old_rec.INFORMATION137 ,
p_INFORMATION138_o => ghr_pah_shd.g_old_rec.INFORMATION138 ,
p_INFORMATION139_o => ghr_pah_shd.g_old_rec.INFORMATION139 ,
p_INFORMATION140_o => ghr_pah_shd.g_old_rec.INFORMATION140 ,
p_INFORMATION141_o => ghr_pah_shd.g_old_rec.INFORMATION141 ,
p_INFORMATION142_o => ghr_pah_shd.g_old_rec.INFORMATION142 ,
p_INFORMATION143_o => ghr_pah_shd.g_old_rec.INFORMATION143 ,
p_INFORMATION144_o => ghr_pah_shd.g_old_rec.INFORMATION144 ,
p_INFORMATION145_o => ghr_pah_shd.g_old_rec.INFORMATION145 ,
p_INFORMATION146_o => ghr_pah_shd.g_old_rec.INFORMATION146 ,
p_INFORMATION147_o => ghr_pah_shd.g_old_rec.INFORMATION147 ,
p_INFORMATION148_o => ghr_pah_shd.g_old_rec.INFORMATION148 ,
p_INFORMATION149_o => ghr_pah_shd.g_old_rec.INFORMATION149 ,
p_INFORMATION150_o => ghr_pah_shd.g_old_rec.INFORMATION150 ,
p_INFORMATION151_o => ghr_pah_shd.g_old_rec.INFORMATION151 ,
p_INFORMATION152_o => ghr_pah_shd.g_old_rec.INFORMATION152 ,
p_INFORMATION153_o => ghr_pah_shd.g_old_rec.INFORMATION153 ,
p_INFORMATION154_o => ghr_pah_shd.g_old_rec.INFORMATION154 ,
p_INFORMATION155_o => ghr_pah_shd.g_old_rec.INFORMATION155 ,
p_INFORMATION156_o => ghr_pah_shd.g_old_rec.INFORMATION156 ,
p_INFORMATION157_o => ghr_pah_shd.g_old_rec.INFORMATION157 ,
p_INFORMATION158_o => ghr_pah_shd.g_old_rec.INFORMATION158 ,
p_INFORMATION159_o => ghr_pah_shd.g_old_rec.INFORMATION159 ,
p_INFORMATION160_o => ghr_pah_shd.g_old_rec.INFORMATION160 ,
p_INFORMATION161_o => ghr_pah_shd.g_old_rec.INFORMATION161 ,
p_INFORMATION162_o => ghr_pah_shd.g_old_rec.INFORMATION162 ,
p_INFORMATION163_o => ghr_pah_shd.g_old_rec.INFORMATION163 ,
p_INFORMATION164_o => ghr_pah_shd.g_old_rec.INFORMATION164 ,
p_INFORMATION165_o => ghr_pah_shd.g_old_rec.INFORMATION165 ,
p_INFORMATION166_o => ghr_pah_shd.g_old_rec.INFORMATION166 ,
p_INFORMATION167_o => ghr_pah_shd.g_old_rec.INFORMATION167 ,
p_INFORMATION168_o => ghr_pah_shd.g_old_rec.INFORMATION168 ,
p_INFORMATION169_o => ghr_pah_shd.g_old_rec.INFORMATION169 ,
p_INFORMATION170_o => ghr_pah_shd.g_old_rec.INFORMATION170 ,
p_INFORMATION171_o => ghr_pah_shd.g_old_rec.INFORMATION171 ,
p_INFORMATION172_o => ghr_pah_shd.g_old_rec.INFORMATION172 ,
p_INFORMATION173_o => ghr_pah_shd.g_old_rec.INFORMATION173 ,
p_INFORMATION174_o => ghr_pah_shd.g_old_rec.INFORMATION174 ,
p_INFORMATION175_o => ghr_pah_shd.g_old_rec.INFORMATION175 ,
p_INFORMATION176_o => ghr_pah_shd.g_old_rec.INFORMATION176 ,
p_INFORMATION177_o => ghr_pah_shd.g_old_rec.INFORMATION177 ,
p_INFORMATION178_o => ghr_pah_shd.g_old_rec.INFORMATION178 ,
p_INFORMATION179_o => ghr_pah_shd.g_old_rec.INFORMATION179 ,
p_INFORMATION180_o => ghr_pah_shd.g_old_rec.INFORMATION180 ,
p_INFORMATION181_o => ghr_pah_shd.g_old_rec.INFORMATION181 ,
p_INFORMATION182_o => ghr_pah_shd.g_old_rec.INFORMATION182 ,
p_INFORMATION183_o => ghr_pah_shd.g_old_rec.INFORMATION183 ,
p_INFORMATION184_o => ghr_pah_shd.g_old_rec.INFORMATION184 ,
p_INFORMATION185_o => ghr_pah_shd.g_old_rec.INFORMATION185 ,
p_INFORMATION186_o => ghr_pah_shd.g_old_rec.INFORMATION186 ,
p_INFORMATION187_o => ghr_pah_shd.g_old_rec.INFORMATION187 ,
p_INFORMATION188_o => ghr_pah_shd.g_old_rec.INFORMATION188 ,
p_INFORMATION189_o => ghr_pah_shd.g_old_rec.INFORMATION189 ,
p_INFORMATION190_o => ghr_pah_shd.g_old_rec.INFORMATION190 ,
p_INFORMATION191_o => ghr_pah_shd.g_old_rec.INFORMATION191 ,
p_INFORMATION192_o => ghr_pah_shd.g_old_rec.INFORMATION192 ,
p_INFORMATION193_o => ghr_pah_shd.g_old_rec.INFORMATION193 ,
p_INFORMATION194_o => ghr_pah_shd.g_old_rec.INFORMATION194 ,
p_INFORMATION195_o => ghr_pah_shd.g_old_rec.INFORMATION195 ,
p_INFORMATION196_o => ghr_pah_shd.g_old_rec.INFORMATION196 ,
p_INFORMATION197_o => ghr_pah_shd.g_old_rec.INFORMATION197 ,
p_INFORMATION198_o => ghr_pah_shd.g_old_rec.INFORMATION198 ,
p_INFORMATION199_o => ghr_pah_shd.g_old_rec.INFORMATION199 ,
p_INFORMATION200_o => ghr_pah_shd.g_old_rec.INFORMATION200
);
End post_update;
ghr_pah_bus.update_validate(p_rec);
pre_update(p_rec);
update_dml(p_rec);
post_update(p_rec);