[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure update_dml(p_rec in out nocopy pqh_cer_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'update_dml';
update pqh_copy_entity_results
set
copy_entity_txn_id = p_rec.copy_entity_txn_id,
result_type_cd = p_rec.result_type_cd,
number_of_copies = p_rec.number_of_copies,
status = p_rec.status,
src_copy_entity_result_id = p_rec.src_copy_entity_result_id,
information_category = p_rec.information_category,
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,
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,
information47 = p_rec.information47,
information48 = p_rec.information48,
information49 = p_rec.information49,
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,
mirror_entity_result_id = p_rec.mirror_entity_result_id,
mirror_src_entity_result_id = p_rec.mirror_src_entity_result_id,
parent_entity_result_id = p_rec.parent_entity_result_id,
table_route_id = p_rec.table_route_id,
long_attribute1 = p_rec.long_attribute1,
object_version_number = p_rec.object_version_number
where copy_entity_result_id = p_rec.copy_entity_result_id;
End update_dml;
Procedure pre_update(p_rec in pqh_cer_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'pre_update';
End pre_update;
Procedure post_update(
p_effective_date in date,p_rec in pqh_cer_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'post_update';
pqh_cer_rku.after_update
(
p_copy_entity_result_id =>p_rec.copy_entity_result_id
,p_copy_entity_txn_id =>p_rec.copy_entity_txn_id
,p_result_type_cd =>p_rec.result_type_cd
,p_number_of_copies =>p_rec.number_of_copies
,p_status =>p_rec.status
,p_src_copy_entity_result_id =>p_rec.src_copy_entity_result_id
,p_information_category =>p_rec.information_category
,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_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_information47 =>p_rec.information47
,p_information48 =>p_rec.information48
,p_information49 =>p_rec.information49
,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_mirror_entity_result_id =>p_rec.mirror_entity_result_id
,p_mirror_src_entity_result_id =>p_rec.mirror_src_entity_result_id
,p_parent_entity_result_id =>p_rec.parent_entity_result_id
,p_table_route_id =>p_rec.table_route_id
,p_long_attribute1 =>p_rec.long_attribute1
,p_object_version_number =>p_rec.object_version_number
,p_effective_date =>p_effective_date
,p_copy_entity_txn_id_o =>pqh_cer_shd.g_old_rec.copy_entity_txn_id
,p_result_type_cd_o =>pqh_cer_shd.g_old_rec.result_type_cd
,p_number_of_copies_o =>pqh_cer_shd.g_old_rec.number_of_copies
,p_status_o =>pqh_cer_shd.g_old_rec.status
,p_src_copy_entity_result_id_o =>pqh_cer_shd.g_old_rec.src_copy_entity_result_id
,p_information_category_o =>pqh_cer_shd.g_old_rec.information_category
,p_information1_o =>pqh_cer_shd.g_old_rec.information1
,p_information2_o =>pqh_cer_shd.g_old_rec.information2
,p_information3_o =>pqh_cer_shd.g_old_rec.information3
,p_information4_o =>pqh_cer_shd.g_old_rec.information4
,p_information5_o =>pqh_cer_shd.g_old_rec.information5
,p_information6_o =>pqh_cer_shd.g_old_rec.information6
,p_information7_o =>pqh_cer_shd.g_old_rec.information7
,p_information8_o =>pqh_cer_shd.g_old_rec.information8
,p_information9_o =>pqh_cer_shd.g_old_rec.information9
,p_information10_o =>pqh_cer_shd.g_old_rec.information10
,p_information11_o =>pqh_cer_shd.g_old_rec.information11
,p_information12_o =>pqh_cer_shd.g_old_rec.information12
,p_information13_o =>pqh_cer_shd.g_old_rec.information13
,p_information14_o =>pqh_cer_shd.g_old_rec.information14
,p_information15_o =>pqh_cer_shd.g_old_rec.information15
,p_information16_o =>pqh_cer_shd.g_old_rec.information16
,p_information17_o =>pqh_cer_shd.g_old_rec.information17
,p_information18_o =>pqh_cer_shd.g_old_rec.information18
,p_information19_o =>pqh_cer_shd.g_old_rec.information19
,p_information20_o =>pqh_cer_shd.g_old_rec.information20
,p_information21_o =>pqh_cer_shd.g_old_rec.information21
,p_information22_o =>pqh_cer_shd.g_old_rec.information22
,p_information23_o =>pqh_cer_shd.g_old_rec.information23
,p_information24_o =>pqh_cer_shd.g_old_rec.information24
,p_information25_o =>pqh_cer_shd.g_old_rec.information25
,p_information26_o =>pqh_cer_shd.g_old_rec.information26
,p_information27_o =>pqh_cer_shd.g_old_rec.information27
,p_information28_o =>pqh_cer_shd.g_old_rec.information28
,p_information29_o =>pqh_cer_shd.g_old_rec.information29
,p_information30_o =>pqh_cer_shd.g_old_rec.information30
,p_information31_o =>pqh_cer_shd.g_old_rec.information31
,p_information32_o =>pqh_cer_shd.g_old_rec.information32
,p_information33_o =>pqh_cer_shd.g_old_rec.information33
,p_information34_o =>pqh_cer_shd.g_old_rec.information34
,p_information35_o =>pqh_cer_shd.g_old_rec.information35
,p_information36_o =>pqh_cer_shd.g_old_rec.information36
,p_information37_o =>pqh_cer_shd.g_old_rec.information37
,p_information38_o =>pqh_cer_shd.g_old_rec.information38
,p_information39_o =>pqh_cer_shd.g_old_rec.information39
,p_information40_o =>pqh_cer_shd.g_old_rec.information40
,p_information41_o =>pqh_cer_shd.g_old_rec.information41
,p_information42_o =>pqh_cer_shd.g_old_rec.information42
,p_information43_o =>pqh_cer_shd.g_old_rec.information43
,p_information44_o =>pqh_cer_shd.g_old_rec.information44
,p_information45_o =>pqh_cer_shd.g_old_rec.information45
,p_information46_o =>pqh_cer_shd.g_old_rec.information46
,p_information47_o =>pqh_cer_shd.g_old_rec.information47
,p_information48_o =>pqh_cer_shd.g_old_rec.information48
,p_information49_o =>pqh_cer_shd.g_old_rec.information49
,p_information50_o =>pqh_cer_shd.g_old_rec.information50
,p_information51_o =>pqh_cer_shd.g_old_rec.information51
,p_information52_o =>pqh_cer_shd.g_old_rec.information52
,p_information53_o =>pqh_cer_shd.g_old_rec.information53
,p_information54_o =>pqh_cer_shd.g_old_rec.information54
,p_information55_o =>pqh_cer_shd.g_old_rec.information55
,p_information56_o =>pqh_cer_shd.g_old_rec.information56
,p_information57_o =>pqh_cer_shd.g_old_rec.information57
,p_information58_o =>pqh_cer_shd.g_old_rec.information58
,p_information59_o =>pqh_cer_shd.g_old_rec.information59
,p_information60_o =>pqh_cer_shd.g_old_rec.information60
,p_information61_o =>pqh_cer_shd.g_old_rec.information61
,p_information62_o =>pqh_cer_shd.g_old_rec.information62
,p_information63_o =>pqh_cer_shd.g_old_rec.information63
,p_information64_o =>pqh_cer_shd.g_old_rec.information64
,p_information65_o =>pqh_cer_shd.g_old_rec.information65
,p_information66_o =>pqh_cer_shd.g_old_rec.information66
,p_information67_o =>pqh_cer_shd.g_old_rec.information67
,p_information68_o =>pqh_cer_shd.g_old_rec.information68
,p_information69_o =>pqh_cer_shd.g_old_rec.information69
,p_information70_o =>pqh_cer_shd.g_old_rec.information70
,p_information71_o =>pqh_cer_shd.g_old_rec.information71
,p_information72_o =>pqh_cer_shd.g_old_rec.information72
,p_information73_o =>pqh_cer_shd.g_old_rec.information73
,p_information74_o =>pqh_cer_shd.g_old_rec.information74
,p_information75_o =>pqh_cer_shd.g_old_rec.information75
,p_information76_o =>pqh_cer_shd.g_old_rec.information76
,p_information77_o =>pqh_cer_shd.g_old_rec.information77
,p_information78_o =>pqh_cer_shd.g_old_rec.information78
,p_information79_o =>pqh_cer_shd.g_old_rec.information79
,p_information80_o =>pqh_cer_shd.g_old_rec.information80
,p_information81_o =>pqh_cer_shd.g_old_rec.information81
,p_information82_o =>pqh_cer_shd.g_old_rec.information82
,p_information83_o =>pqh_cer_shd.g_old_rec.information83
,p_information84_o =>pqh_cer_shd.g_old_rec.information84
,p_information85_o =>pqh_cer_shd.g_old_rec.information85
,p_information86_o =>pqh_cer_shd.g_old_rec.information86
,p_information87_o =>pqh_cer_shd.g_old_rec.information87
,p_information88_o =>pqh_cer_shd.g_old_rec.information88
,p_information89_o =>pqh_cer_shd.g_old_rec.information89
,p_information90_o =>pqh_cer_shd.g_old_rec.information90
,p_information91_o =>pqh_cer_shd.g_old_rec.information91
,p_information92_o =>pqh_cer_shd.g_old_rec.information92
,p_information93_o =>pqh_cer_shd.g_old_rec.information93
,p_information94_o =>pqh_cer_shd.g_old_rec.information94
,p_information95_o =>pqh_cer_shd.g_old_rec.information95
,p_information96_o =>pqh_cer_shd.g_old_rec.information96
,p_information97_o =>pqh_cer_shd.g_old_rec.information97
,p_information98_o =>pqh_cer_shd.g_old_rec.information98
,p_information99_o =>pqh_cer_shd.g_old_rec.information99
,p_information100_o =>pqh_cer_shd.g_old_rec.information100
,p_information101_o =>pqh_cer_shd.g_old_rec.information101
,p_information102_o =>pqh_cer_shd.g_old_rec.information102
,p_information103_o =>pqh_cer_shd.g_old_rec.information103
,p_information104_o =>pqh_cer_shd.g_old_rec.information104
,p_information105_o =>pqh_cer_shd.g_old_rec.information105
,p_information106_o =>pqh_cer_shd.g_old_rec.information106
,p_information107_o =>pqh_cer_shd.g_old_rec.information107
,p_information108_o =>pqh_cer_shd.g_old_rec.information108
,p_information109_o =>pqh_cer_shd.g_old_rec.information109
,p_information110_o =>pqh_cer_shd.g_old_rec.information110
,p_information111_o =>pqh_cer_shd.g_old_rec.information111
,p_information112_o =>pqh_cer_shd.g_old_rec.information112
,p_information113_o =>pqh_cer_shd.g_old_rec.information113
,p_information114_o =>pqh_cer_shd.g_old_rec.information114
,p_information115_o =>pqh_cer_shd.g_old_rec.information115
,p_information116_o =>pqh_cer_shd.g_old_rec.information116
,p_information117_o =>pqh_cer_shd.g_old_rec.information117
,p_information118_o =>pqh_cer_shd.g_old_rec.information118
,p_information119_o =>pqh_cer_shd.g_old_rec.information119
,p_information120_o =>pqh_cer_shd.g_old_rec.information120
,p_information121_o =>pqh_cer_shd.g_old_rec.information121
,p_information122_o =>pqh_cer_shd.g_old_rec.information122
,p_information123_o =>pqh_cer_shd.g_old_rec.information123
,p_information124_o =>pqh_cer_shd.g_old_rec.information124
,p_information125_o =>pqh_cer_shd.g_old_rec.information125
,p_information126_o =>pqh_cer_shd.g_old_rec.information126
,p_information127_o =>pqh_cer_shd.g_old_rec.information127
,p_information128_o =>pqh_cer_shd.g_old_rec.information128
,p_information129_o =>pqh_cer_shd.g_old_rec.information129
,p_information130_o =>pqh_cer_shd.g_old_rec.information130
,p_information131_o =>pqh_cer_shd.g_old_rec.information131
,p_information132_o =>pqh_cer_shd.g_old_rec.information132
,p_information133_o =>pqh_cer_shd.g_old_rec.information133
,p_information134_o =>pqh_cer_shd.g_old_rec.information134
,p_information135_o =>pqh_cer_shd.g_old_rec.information135
,p_information136_o =>pqh_cer_shd.g_old_rec.information136
,p_information137_o =>pqh_cer_shd.g_old_rec.information137
,p_information138_o =>pqh_cer_shd.g_old_rec.information138
,p_information139_o =>pqh_cer_shd.g_old_rec.information139
,p_information140_o =>pqh_cer_shd.g_old_rec.information140
,p_information141_o =>pqh_cer_shd.g_old_rec.information141
,p_information142_o =>pqh_cer_shd.g_old_rec.information142
,p_information143_o =>pqh_cer_shd.g_old_rec.information143
,p_information144_o =>pqh_cer_shd.g_old_rec.information144
,p_information145_o =>pqh_cer_shd.g_old_rec.information145
,p_information146_o =>pqh_cer_shd.g_old_rec.information146
,p_information147_o =>pqh_cer_shd.g_old_rec.information147
,p_information148_o =>pqh_cer_shd.g_old_rec.information148
,p_information149_o =>pqh_cer_shd.g_old_rec.information149
,p_information150_o =>pqh_cer_shd.g_old_rec.information150
,p_information151_o =>pqh_cer_shd.g_old_rec.information151
,p_information152_o =>pqh_cer_shd.g_old_rec.information152
,p_information153_o =>pqh_cer_shd.g_old_rec.information153
,p_information154_o =>pqh_cer_shd.g_old_rec.information154
,p_information155_o =>pqh_cer_shd.g_old_rec.information155
,p_information156_o =>pqh_cer_shd.g_old_rec.information156
,p_information157_o =>pqh_cer_shd.g_old_rec.information157
,p_information158_o =>pqh_cer_shd.g_old_rec.information158
,p_information159_o =>pqh_cer_shd.g_old_rec.information159
,p_information160_o =>pqh_cer_shd.g_old_rec.information160
,p_information161_o =>pqh_cer_shd.g_old_rec.information161
,p_information162_o =>pqh_cer_shd.g_old_rec.information162
,p_information163_o =>pqh_cer_shd.g_old_rec.information163
,p_information164_o =>pqh_cer_shd.g_old_rec.information164
,p_information165_o =>pqh_cer_shd.g_old_rec.information165
,p_information166_o =>pqh_cer_shd.g_old_rec.information166
,p_information167_o =>pqh_cer_shd.g_old_rec.information167
,p_information168_o =>pqh_cer_shd.g_old_rec.information168
,p_information169_o =>pqh_cer_shd.g_old_rec.information169
,p_information170_o =>pqh_cer_shd.g_old_rec.information170
,p_information171_o =>pqh_cer_shd.g_old_rec.information171
,p_information172_o =>pqh_cer_shd.g_old_rec.information172
,p_information173_o =>pqh_cer_shd.g_old_rec.information173
,p_information174_o =>pqh_cer_shd.g_old_rec.information174
,p_information175_o =>pqh_cer_shd.g_old_rec.information175
,p_information176_o =>pqh_cer_shd.g_old_rec.information176
,p_information177_o =>pqh_cer_shd.g_old_rec.information177
,p_information178_o =>pqh_cer_shd.g_old_rec.information178
,p_information179_o =>pqh_cer_shd.g_old_rec.information179
,p_information180_o =>pqh_cer_shd.g_old_rec.information180
,p_information181_o =>pqh_cer_shd.g_old_rec.information181
,p_information182_o =>pqh_cer_shd.g_old_rec.information182
,p_information183_o =>pqh_cer_shd.g_old_rec.information183
,p_information184_o =>pqh_cer_shd.g_old_rec.information184
,p_information185_o =>pqh_cer_shd.g_old_rec.information185
,p_information186_o =>pqh_cer_shd.g_old_rec.information186
,p_information187_o =>pqh_cer_shd.g_old_rec.information187
,p_information188_o =>pqh_cer_shd.g_old_rec.information188
,p_information189_o =>pqh_cer_shd.g_old_rec.information189
,p_information190_o =>pqh_cer_shd.g_old_rec.information190
,p_mirror_entity_result_id_o =>pqh_cer_shd.g_old_rec.mirror_entity_result_id
,p_mirror_src_entity_result_ido =>pqh_cer_shd.g_old_rec.mirror_src_entity_result_id
,p_parent_entity_result_id_o =>pqh_cer_shd.g_old_rec.parent_entity_result_id
,p_table_route_id_o =>pqh_cer_shd.g_old_rec.table_route_id
,p_long_attribute1_o =>pqh_cer_shd.g_old_rec.long_attribute1
,p_object_version_number_o =>pqh_cer_shd.g_old_rec.object_version_number
);
End post_update;
pqh_cer_bus.update_validate(p_rec
,p_effective_date);
pre_update(p_rec);
update_dml(p_rec);
post_update(
p_effective_date,p_rec);