APPS.PQH_CER_DEL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 45

Procedure delete_dml(p_rec in pqh_cer_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'delete_dml';

Line: 54

  delete from pqh_copy_entity_results
  where copy_entity_result_id = p_rec.copy_entity_result_id;

Line: 66

End delete_dml;

Line: 100

Procedure pre_delete(p_rec in pqh_cer_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'pre_delete';

Line: 108

End pre_delete;

Line: 142

Procedure post_delete(
p_effective_date in date,p_rec in pqh_cer_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'post_delete';

Line: 155

    pqh_cer_rkd.after_delete
      (
  p_copy_entity_result_id         =>p_rec.copy_entity_result_id
 ,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
      );

Line: 376

End post_delete;

Line: 402

  pqh_cer_bus.delete_validate(p_rec
  ,p_effective_date);

Line: 407

  pre_delete(p_rec);

Line: 411

  delete_dml(p_rec);

Line: 415

  post_delete(
p_effective_date,p_rec);