APPS.GHR_PAH_RKU SQL Statements

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

Line: 5

procedure AFTER_UPDATE
(P_PA_HISTORY_ID in NUMBER
,P_PA_REQUEST_ID in NUMBER
,P_PROCESS_DATE in DATE
,P_NATURE_OF_ACTION_ID in NUMBER
,P_EFFECTIVE_DATE in DATE
,P_ALTERED_PA_REQUEST_ID in NUMBER
,P_PERSON_ID in NUMBER
,P_ASSIGNMENT_ID in NUMBER
,P_DML_OPERATION in VARCHAR2
,P_TABLE_NAME in VARCHAR2
,P_PRE_VALUES_FLAG in VARCHAR2
,P_INFORMATION1 in VARCHAR2
,P_INFORMATION2 in VARCHAR2
,P_INFORMATION3 in VARCHAR2
,P_INFORMATION4 in VARCHAR2
,P_INFORMATION5 in VARCHAR2
,P_INFORMATION6 in VARCHAR2
,P_INFORMATION7 in VARCHAR2
,P_INFORMATION8 in VARCHAR2
,P_INFORMATION9 in VARCHAR2
,P_INFORMATION10 in VARCHAR2
,P_INFORMATION11 in VARCHAR2
,P_INFORMATION12 in VARCHAR2
,P_INFORMATION13 in VARCHAR2
,P_INFORMATION14 in VARCHAR2
,P_INFORMATION15 in VARCHAR2
,P_INFORMATION16 in VARCHAR2
,P_INFORMATION17 in VARCHAR2
,P_INFORMATION18 in VARCHAR2
,P_INFORMATION19 in VARCHAR2
,P_INFORMATION20 in VARCHAR2
,P_INFORMATION21 in VARCHAR2
,P_INFORMATION22 in VARCHAR2
,P_INFORMATION23 in VARCHAR2
,P_INFORMATION24 in VARCHAR2
,P_INFORMATION25 in VARCHAR2
,P_INFORMATION26 in VARCHAR2
,P_INFORMATION27 in VARCHAR2
,P_INFORMATION28 in VARCHAR2
,P_INFORMATION29 in VARCHAR2
,P_INFORMATION30 in VARCHAR2
,P_INFORMATION31 in VARCHAR2
,P_INFORMATION32 in VARCHAR2
,P_INFORMATION33 in VARCHAR2
,P_INFORMATION34 in VARCHAR2
,P_INFORMATION35 in VARCHAR2
,P_INFORMATION36 in VARCHAR2
,P_INFORMATION37 in VARCHAR2
,P_INFORMATION38 in VARCHAR2
,P_INFORMATION39 in VARCHAR2
,P_INFORMATION47 in VARCHAR2
,P_INFORMATION48 in VARCHAR2
,P_INFORMATION49 in VARCHAR2
,P_INFORMATION40 in VARCHAR2
,P_INFORMATION41 in VARCHAR2
,P_INFORMATION42 in VARCHAR2
,P_INFORMATION43 in VARCHAR2
,P_INFORMATION44 in VARCHAR2
,P_INFORMATION45 in VARCHAR2
,P_INFORMATION46 in VARCHAR2
,P_INFORMATION50 in VARCHAR2
,P_INFORMATION51 in VARCHAR2
,P_INFORMATION52 in VARCHAR2
,P_INFORMATION53 in VARCHAR2
,P_INFORMATION54 in VARCHAR2
,P_INFORMATION55 in VARCHAR2
,P_INFORMATION56 in VARCHAR2
,P_INFORMATION57 in VARCHAR2
,P_INFORMATION58 in VARCHAR2
,P_INFORMATION59 in VARCHAR2
,P_INFORMATION60 in VARCHAR2
,P_INFORMATION61 in VARCHAR2
,P_INFORMATION62 in VARCHAR2
,P_INFORMATION63 in VARCHAR2
,P_INFORMATION64 in VARCHAR2
,P_INFORMATION65 in VARCHAR2
,P_INFORMATION66 in VARCHAR2
,P_INFORMATION67 in VARCHAR2
,P_INFORMATION68 in VARCHAR2
,P_INFORMATION69 in VARCHAR2
,P_INFORMATION70 in VARCHAR2
,P_INFORMATION71 in VARCHAR2
,P_INFORMATION72 in VARCHAR2
,P_INFORMATION73 in VARCHAR2
,P_INFORMATION74 in VARCHAR2
,P_INFORMATION75 in VARCHAR2
,P_INFORMATION76 in VARCHAR2
,P_INFORMATION77 in VARCHAR2
,P_INFORMATION78 in VARCHAR2
,P_INFORMATION79 in VARCHAR2
,P_INFORMATION80 in VARCHAR2
,P_INFORMATION81 in VARCHAR2
,P_INFORMATION82 in VARCHAR2
,P_INFORMATION83 in VARCHAR2
,P_INFORMATION84 in VARCHAR2
,P_INFORMATION85 in VARCHAR2
,P_INFORMATION86 in VARCHAR2
,P_INFORMATION87 in VARCHAR2
,P_INFORMATION88 in VARCHAR2
,P_INFORMATION89 in VARCHAR2
,P_INFORMATION90 in VARCHAR2
,P_INFORMATION91 in VARCHAR2
,P_INFORMATION92 in VARCHAR2
,P_INFORMATION93 in VARCHAR2
,P_INFORMATION94 in VARCHAR2
,P_INFORMATION95 in VARCHAR2
,P_INFORMATION96 in VARCHAR2
,P_INFORMATION97 in VARCHAR2
,P_INFORMATION98 in VARCHAR2
,P_INFORMATION99 in VARCHAR2
,P_INFORMATION100 in VARCHAR2
,P_INFORMATION101 in VARCHAR2
,P_INFORMATION102 in VARCHAR2
,P_INFORMATION103 in VARCHAR2
,P_INFORMATION104 in VARCHAR2
,P_INFORMATION105 in VARCHAR2
,P_INFORMATION106 in VARCHAR2
,P_INFORMATION107 in VARCHAR2
,P_INFORMATION108 in VARCHAR2
,P_INFORMATION109 in VARCHAR2
,P_INFORMATION110 in VARCHAR2
,P_INFORMATION111 in VARCHAR2
,P_INFORMATION112 in VARCHAR2
,P_INFORMATION113 in VARCHAR2
,P_INFORMATION114 in VARCHAR2
,P_INFORMATION115 in VARCHAR2
,P_INFORMATION116 in VARCHAR2
,P_INFORMATION117 in VARCHAR2
,P_INFORMATION118 in VARCHAR2
,P_INFORMATION119 in VARCHAR2
,P_INFORMATION120 in VARCHAR2
,P_INFORMATION121 in VARCHAR2
,P_INFORMATION122 in VARCHAR2
,P_INFORMATION123 in VARCHAR2
,P_INFORMATION124 in VARCHAR2
,P_INFORMATION125 in VARCHAR2
,P_INFORMATION126 in VARCHAR2
,P_INFORMATION127 in VARCHAR2
,P_INFORMATION128 in VARCHAR2
,P_INFORMATION129 in VARCHAR2
,P_INFORMATION130 in VARCHAR2
,P_INFORMATION131 in VARCHAR2
,P_INFORMATION132 in VARCHAR2
,P_INFORMATION133 in VARCHAR2
,P_INFORMATION134 in VARCHAR2
,P_INFORMATION135 in VARCHAR2
,P_INFORMATION136 in VARCHAR2
,P_INFORMATION137 in VARCHAR2
,P_INFORMATION138 in VARCHAR2
,P_INFORMATION139 in VARCHAR2
,P_INFORMATION140 in VARCHAR2
,P_INFORMATION141 in VARCHAR2
,P_INFORMATION142 in VARCHAR2
,P_INFORMATION143 in VARCHAR2
,P_INFORMATION144 in VARCHAR2
,P_INFORMATION145 in VARCHAR2
,P_INFORMATION146 in VARCHAR2
,P_INFORMATION147 in VARCHAR2
,P_INFORMATION148 in VARCHAR2
,P_INFORMATION149 in VARCHAR2
,P_INFORMATION150 in VARCHAR2
,P_INFORMATION151 in VARCHAR2
,P_INFORMATION152 in VARCHAR2
,P_INFORMATION153 in VARCHAR2
,P_INFORMATION154 in VARCHAR2
,P_INFORMATION155 in VARCHAR2
,P_INFORMATION156 in VARCHAR2
,P_INFORMATION157 in VARCHAR2
,P_INFORMATION158 in VARCHAR2
,P_INFORMATION159 in VARCHAR2
,P_INFORMATION160 in VARCHAR2
,P_INFORMATION161 in VARCHAR2
,P_INFORMATION162 in VARCHAR2
,P_INFORMATION163 in VARCHAR2
,P_INFORMATION164 in VARCHAR2
,P_INFORMATION165 in VARCHAR2
,P_INFORMATION166 in VARCHAR2
,P_INFORMATION167 in VARCHAR2
,P_INFORMATION168 in VARCHAR2
,P_INFORMATION169 in VARCHAR2
,P_INFORMATION170 in VARCHAR2
,P_INFORMATION171 in VARCHAR2
,P_INFORMATION172 in VARCHAR2
,P_INFORMATION173 in VARCHAR2
,P_INFORMATION174 in VARCHAR2
,P_INFORMATION175 in VARCHAR2
,P_INFORMATION176 in VARCHAR2
,P_INFORMATION177 in VARCHAR2
,P_INFORMATION178 in VARCHAR2
,P_INFORMATION179 in VARCHAR2
,P_INFORMATION180 in VARCHAR2
,P_INFORMATION181 in VARCHAR2
,P_INFORMATION182 in VARCHAR2
,P_INFORMATION183 in VARCHAR2
,P_INFORMATION184 in VARCHAR2
,P_INFORMATION185 in VARCHAR2
,P_INFORMATION186 in VARCHAR2
,P_INFORMATION187 in VARCHAR2
,P_INFORMATION188 in VARCHAR2
,P_INFORMATION189 in VARCHAR2
,P_INFORMATION190 in VARCHAR2
,P_INFORMATION191 in VARCHAR2
,P_INFORMATION192 in VARCHAR2
,P_INFORMATION193 in VARCHAR2
,P_INFORMATION194 in VARCHAR2
,P_INFORMATION195 in VARCHAR2
,P_INFORMATION196 in VARCHAR2
,P_INFORMATION197 in VARCHAR2
,P_INFORMATION198 in VARCHAR2
,P_INFORMATION199 in VARCHAR2
,P_INFORMATION200 in VARCHAR2
,P_PA_REQUEST_ID_O in NUMBER
,P_PROCESS_DATE_O in DATE
,P_NATURE_OF_ACTION_ID_O in NUMBER
,P_EFFECTIVE_DATE_O in DATE
,P_ALTERED_PA_REQUEST_ID_O in NUMBER
,P_PERSON_ID_O in NUMBER
,P_ASSIGNMENT_ID_O in NUMBER
,P_DML_OPERATION_O in VARCHAR2
,P_TABLE_NAME_O in VARCHAR2
,P_PRE_VALUES_FLAG_O in VARCHAR2
,P_INFORMATION1_O in VARCHAR2
,P_INFORMATION2_O in VARCHAR2
,P_INFORMATION3_O in VARCHAR2
,P_INFORMATION4_O in VARCHAR2
,P_INFORMATION5_O in VARCHAR2
,P_INFORMATION6_O in VARCHAR2
,P_INFORMATION7_O in VARCHAR2
,P_INFORMATION8_O in VARCHAR2
,P_INFORMATION9_O in VARCHAR2
,P_INFORMATION10_O in VARCHAR2
,P_INFORMATION11_O in VARCHAR2
,P_INFORMATION12_O in VARCHAR2
,P_INFORMATION13_O in VARCHAR2
,P_INFORMATION14_O in VARCHAR2
,P_INFORMATION15_O in VARCHAR2
,P_INFORMATION16_O in VARCHAR2
,P_INFORMATION17_O in VARCHAR2
,P_INFORMATION18_O in VARCHAR2
,P_INFORMATION19_O in VARCHAR2
,P_INFORMATION20_O in VARCHAR2
,P_INFORMATION21_O in VARCHAR2
,P_INFORMATION22_O in VARCHAR2
,P_INFORMATION23_O in VARCHAR2
,P_INFORMATION24_O in VARCHAR2
,P_INFORMATION25_O in VARCHAR2
,P_INFORMATION26_O in VARCHAR2
,P_INFORMATION27_O in VARCHAR2
,P_INFORMATION28_O in VARCHAR2
,P_INFORMATION29_O in VARCHAR2
,P_INFORMATION30_O in VARCHAR2
,P_INFORMATION31_O in VARCHAR2
,P_INFORMATION32_O in VARCHAR2
,P_INFORMATION33_O in VARCHAR2
,P_INFORMATION34_O in VARCHAR2
,P_INFORMATION35_O in VARCHAR2
,P_INFORMATION36_O in VARCHAR2
,P_INFORMATION37_O in VARCHAR2
,P_INFORMATION38_O in VARCHAR2
,P_INFORMATION39_O in VARCHAR2
,P_INFORMATION47_O in VARCHAR2
,P_INFORMATION48_O in VARCHAR2
,P_INFORMATION49_O in VARCHAR2
,P_INFORMATION40_O in VARCHAR2
,P_INFORMATION41_O in VARCHAR2
,P_INFORMATION42_O in VARCHAR2
,P_INFORMATION43_O in VARCHAR2
,P_INFORMATION44_O in VARCHAR2
,P_INFORMATION45_O in VARCHAR2
,P_INFORMATION46_O in VARCHAR2
,P_INFORMATION50_O in VARCHAR2
,P_INFORMATION51_O in VARCHAR2
,P_INFORMATION52_O in VARCHAR2
,P_INFORMATION53_O in VARCHAR2
,P_INFORMATION54_O in VARCHAR2
,P_INFORMATION55_O in VARCHAR2
,P_INFORMATION56_O in VARCHAR2
,P_INFORMATION57_O in VARCHAR2
,P_INFORMATION58_O in VARCHAR2
,P_INFORMATION59_O in VARCHAR2
,P_INFORMATION60_O in VARCHAR2
,P_INFORMATION61_O in VARCHAR2
,P_INFORMATION62_O in VARCHAR2
,P_INFORMATION63_O in VARCHAR2
,P_INFORMATION64_O in VARCHAR2
,P_INFORMATION65_O in VARCHAR2
,P_INFORMATION66_O in VARCHAR2
,P_INFORMATION67_O in VARCHAR2
,P_INFORMATION68_O in VARCHAR2
,P_INFORMATION69_O in VARCHAR2
,P_INFORMATION70_O in VARCHAR2
,P_INFORMATION71_O in VARCHAR2
,P_INFORMATION72_O in VARCHAR2
,P_INFORMATION73_O in VARCHAR2
,P_INFORMATION74_O in VARCHAR2
,P_INFORMATION75_O in VARCHAR2
,P_INFORMATION76_O in VARCHAR2
,P_INFORMATION77_O in VARCHAR2
,P_INFORMATION78_O in VARCHAR2
,P_INFORMATION79_O in VARCHAR2
,P_INFORMATION80_O in VARCHAR2
,P_INFORMATION81_O in VARCHAR2
,P_INFORMATION82_O in VARCHAR2
,P_INFORMATION83_O in VARCHAR2
,P_INFORMATION84_O in VARCHAR2
,P_INFORMATION85_O in VARCHAR2
,P_INFORMATION86_O in VARCHAR2
,P_INFORMATION87_O in VARCHAR2
,P_INFORMATION88_O in VARCHAR2
,P_INFORMATION89_O in VARCHAR2
,P_INFORMATION90_O in VARCHAR2
,P_INFORMATION91_O in VARCHAR2
,P_INFORMATION92_O in VARCHAR2
,P_INFORMATION93_O in VARCHAR2
,P_INFORMATION94_O in VARCHAR2
,P_INFORMATION95_O in VARCHAR2
,P_INFORMATION96_O in VARCHAR2
,P_INFORMATION97_O in VARCHAR2
,P_INFORMATION98_O in VARCHAR2
,P_INFORMATION99_O in VARCHAR2
,P_INFORMATION100_O in VARCHAR2
,P_INFORMATION101_O in VARCHAR2
,P_INFORMATION102_O in VARCHAR2
,P_INFORMATION103_O in VARCHAR2
,P_INFORMATION104_O in VARCHAR2
,P_INFORMATION105_O in VARCHAR2
,P_INFORMATION106_O in VARCHAR2
,P_INFORMATION107_O in VARCHAR2
,P_INFORMATION108_O in VARCHAR2
,P_INFORMATION109_O in VARCHAR2
,P_INFORMATION110_O in VARCHAR2
,P_INFORMATION111_O in VARCHAR2
,P_INFORMATION112_O in VARCHAR2
,P_INFORMATION113_O in VARCHAR2
,P_INFORMATION114_O in VARCHAR2
,P_INFORMATION115_O in VARCHAR2
,P_INFORMATION116_O in VARCHAR2
,P_INFORMATION117_O in VARCHAR2
,P_INFORMATION118_O in VARCHAR2
,P_INFORMATION119_O in VARCHAR2
,P_INFORMATION120_O in VARCHAR2
,P_INFORMATION121_O in VARCHAR2
,P_INFORMATION122_O in VARCHAR2
,P_INFORMATION123_O in VARCHAR2
,P_INFORMATION124_O in VARCHAR2
,P_INFORMATION125_O in VARCHAR2
,P_INFORMATION126_O in VARCHAR2
,P_INFORMATION127_O in VARCHAR2
,P_INFORMATION128_O in VARCHAR2
,P_INFORMATION129_O in VARCHAR2
,P_INFORMATION130_O in VARCHAR2
,P_INFORMATION131_O in VARCHAR2
,P_INFORMATION132_O in VARCHAR2
,P_INFORMATION133_O in VARCHAR2
,P_INFORMATION134_O in VARCHAR2
,P_INFORMATION135_O in VARCHAR2
,P_INFORMATION136_O in VARCHAR2
,P_INFORMATION137_O in VARCHAR2
,P_INFORMATION138_O in VARCHAR2
,P_INFORMATION139_O in VARCHAR2
,P_INFORMATION140_O in VARCHAR2
,P_INFORMATION141_O in VARCHAR2
,P_INFORMATION142_O in VARCHAR2
,P_INFORMATION143_O in VARCHAR2
,P_INFORMATION144_O in VARCHAR2
,P_INFORMATION145_O in VARCHAR2
,P_INFORMATION146_O in VARCHAR2
,P_INFORMATION147_O in VARCHAR2
,P_INFORMATION148_O in VARCHAR2
,P_INFORMATION149_O in VARCHAR2
,P_INFORMATION150_O in VARCHAR2
,P_INFORMATION151_O in VARCHAR2
,P_INFORMATION152_O in VARCHAR2
,P_INFORMATION153_O in VARCHAR2
,P_INFORMATION154_O in VARCHAR2
,P_INFORMATION155_O in VARCHAR2
,P_INFORMATION156_O in VARCHAR2
,P_INFORMATION157_O in VARCHAR2
,P_INFORMATION158_O in VARCHAR2
,P_INFORMATION159_O in VARCHAR2
,P_INFORMATION160_O in VARCHAR2
,P_INFORMATION161_O in VARCHAR2
,P_INFORMATION162_O in VARCHAR2
,P_INFORMATION163_O in VARCHAR2
,P_INFORMATION164_O in VARCHAR2
,P_INFORMATION165_O in VARCHAR2
,P_INFORMATION166_O in VARCHAR2
,P_INFORMATION167_O in VARCHAR2
,P_INFORMATION168_O in VARCHAR2
,P_INFORMATION169_O in VARCHAR2
,P_INFORMATION170_O in VARCHAR2
,P_INFORMATION171_O in VARCHAR2
,P_INFORMATION172_O in VARCHAR2
,P_INFORMATION173_O in VARCHAR2
,P_INFORMATION174_O in VARCHAR2
,P_INFORMATION175_O in VARCHAR2
,P_INFORMATION176_O in VARCHAR2
,P_INFORMATION177_O in VARCHAR2
,P_INFORMATION178_O in VARCHAR2
,P_INFORMATION179_O in VARCHAR2
,P_INFORMATION180_O in VARCHAR2
,P_INFORMATION181_O in VARCHAR2
,P_INFORMATION182_O in VARCHAR2
,P_INFORMATION183_O in VARCHAR2
,P_INFORMATION184_O in VARCHAR2
,P_INFORMATION185_O in VARCHAR2
,P_INFORMATION186_O in VARCHAR2
,P_INFORMATION187_O in VARCHAR2
,P_INFORMATION188_O in VARCHAR2
,P_INFORMATION189_O in VARCHAR2
,P_INFORMATION190_O in VARCHAR2
,P_INFORMATION191_O in VARCHAR2
,P_INFORMATION192_O in VARCHAR2
,P_INFORMATION193_O in VARCHAR2
,P_INFORMATION194_O in VARCHAR2
,P_INFORMATION195_O in VARCHAR2
,P_INFORMATION196_O in VARCHAR2
,P_INFORMATION197_O in VARCHAR2
,P_INFORMATION198_O in VARCHAR2
,P_INFORMATION199_O in VARCHAR2
,P_INFORMATION200_O in VARCHAR2
)is
begin
hr_utility.set_location('Entering: GHR_PAH_RKU.AFTER_UPDATE', 10);

Line: 430

hr_utility.set_location(' Leaving: GHR_PAH_RKU.AFTER_UPDATE', 20);

Line: 431

end AFTER_UPDATE;