[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure insert_dml(p_rec in out nocopy ben_xrd_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'insert_dml';
insert into ben_ext_rslt_dtl
( ext_rslt_dtl_id,
prmy_sort_val,
scnd_sort_val,
thrd_sort_val,
trans_seq_num,
rcrd_seq_num,
ext_rslt_id,
ext_rcd_id,
person_id,
business_group_id,
ext_per_bg_id ,
val_01,
val_02,
val_03,
val_04,
val_05,
val_06,
val_07,
val_08,
val_09,
val_10,
val_11,
val_12,
val_13,
val_14,
val_15,
val_16,
val_17,
val_19,
val_18,
val_20,
val_21,
val_22,
val_23,
val_24,
val_25,
val_26,
val_27,
val_28,
val_29,
val_30,
val_31,
val_32,
val_33,
val_34,
val_35,
val_36,
val_37,
val_38,
val_39,
val_40,
val_41,
val_42,
val_43,
val_44,
val_45,
val_46,
val_47,
val_48,
val_49,
val_50,
val_51,
val_52,
val_53,
val_54,
val_55,
val_56,
val_57,
val_58,
val_59,
val_60,
val_61,
val_62,
val_63,
val_64,
val_65,
val_66,
val_67,
val_68,
val_69,
val_70,
val_71,
val_72,
val_73,
val_74,
val_75,
val_76,
val_77,
val_78,
val_79,
val_80,
val_81,
val_82,
val_83,
val_84,
val_85,
val_86,
val_87,
val_88,
val_89,
val_90,
val_91,
val_92,
val_93,
val_94,
val_95,
val_96,
val_97,
val_98,
val_99,
val_100,
val_101,
val_102,
val_103,
val_104,
val_105,
val_106,
val_107,
val_108,
val_109,
val_110,
val_111,
val_112,
val_113,
val_114,
val_115,
val_116,
val_117,
val_119,
val_118,
val_120,
val_121,
val_122,
val_123,
val_124,
val_125,
val_126,
val_127,
val_128,
val_129,
val_130,
val_131,
val_132,
val_133,
val_134,
val_135,
val_136,
val_137,
val_138,
val_139,
val_140,
val_141,
val_142,
val_143,
val_144,
val_145,
val_146,
val_147,
val_148,
val_149,
val_150,
val_151,
val_152,
val_153,
val_154,
val_155,
val_156,
val_157,
val_158,
val_159,
val_160,
val_161,
val_162,
val_163,
val_164,
val_165,
val_166,
val_167,
val_168,
val_169,
val_170,
val_171,
val_172,
val_173,
val_174,
val_175,
val_176,
val_177,
val_178,
val_179,
val_180,
val_181,
val_182,
val_183,
val_184,
val_185,
val_186,
val_187,
val_188,
val_189,
val_190,
val_191,
val_192,
val_193,
val_194,
val_195,
val_196,
val_197,
val_198,
val_199,
val_200,
val_201,
val_202,
val_203,
val_204,
val_205,
val_206,
val_207,
val_208,
val_209,
val_210,
val_211,
val_212,
val_213,
val_214,
val_215,
val_216,
val_217,
val_219,
val_218,
val_220,
val_221,
val_222,
val_223,
val_224,
val_225,
val_226,
val_227,
val_228,
val_229,
val_230,
val_231,
val_232,
val_233,
val_234,
val_235,
val_236,
val_237,
val_238,
val_239,
val_240,
val_241,
val_242,
val_243,
val_244,
val_245,
val_246,
val_247,
val_248,
val_249,
val_250,
val_251,
val_252,
val_253,
val_254,
val_255,
val_256,
val_257,
val_258,
val_259,
val_260,
val_261,
val_262,
val_263,
val_264,
val_265,
val_266,
val_267,
val_268,
val_269,
val_270,
val_271,
val_272,
val_273,
val_274,
val_275,
val_276,
val_277,
val_278,
val_279,
val_280,
val_281,
val_282,
val_283,
val_284,
val_285,
val_286,
val_287,
val_288,
val_289,
val_290,
val_291,
val_292,
val_293,
val_294,
val_295,
val_296,
val_297,
val_298,
val_299,
val_300,
group_val_01 ,
group_val_02 ,
program_application_id,
program_id,
program_update_date,
request_id,
object_version_number,
ext_rcd_in_file_id
)
Values
( p_rec.ext_rslt_dtl_id,
p_rec.prmy_sort_val,
p_rec.scnd_sort_val,
p_rec.thrd_sort_val,
p_rec.trans_seq_num,
p_rec.rcrd_seq_num,
p_rec.ext_rslt_id,
p_rec.ext_rcd_id,
p_rec.person_id,
p_rec.business_group_id,
p_rec.ext_per_bg_id,
p_rec.val_01,
p_rec.val_02,
p_rec.val_03,
p_rec.val_04,
p_rec.val_05,
p_rec.val_06,
p_rec.val_07,
p_rec.val_08,
p_rec.val_09,
p_rec.val_10,
p_rec.val_11,
p_rec.val_12,
p_rec.val_13,
p_rec.val_14,
p_rec.val_15,
p_rec.val_16,
p_rec.val_17,
p_rec.val_19,
p_rec.val_18,
p_rec.val_20,
p_rec.val_21,
p_rec.val_22,
p_rec.val_23,
p_rec.val_24,
p_rec.val_25,
p_rec.val_26,
p_rec.val_27,
p_rec.val_28,
p_rec.val_29,
p_rec.val_30,
p_rec.val_31,
p_rec.val_32,
p_rec.val_33,
p_rec.val_34,
p_rec.val_35,
p_rec.val_36,
p_rec.val_37,
p_rec.val_38,
p_rec.val_39,
p_rec.val_40,
p_rec.val_41,
p_rec.val_42,
p_rec.val_43,
p_rec.val_44,
p_rec.val_45,
p_rec.val_46,
p_rec.val_47,
p_rec.val_48,
p_rec.val_49,
p_rec.val_50,
p_rec.val_51,
p_rec.val_52,
p_rec.val_53,
p_rec.val_54,
p_rec.val_55,
p_rec.val_56,
p_rec.val_57,
p_rec.val_58,
p_rec.val_59,
p_rec.val_60,
p_rec.val_61,
p_rec.val_62,
p_rec.val_63,
p_rec.val_64,
p_rec.val_65,
p_rec.val_66,
p_rec.val_67,
p_rec.val_68,
p_rec.val_69,
p_rec.val_70,
p_rec.val_71,
p_rec.val_72,
p_rec.val_73,
p_rec.val_74,
p_rec.val_75,
p_rec.val_76,
p_rec.val_77,
p_rec.val_78,
p_rec.val_79,
p_rec.val_80,
p_rec.val_81,
p_rec.val_82,
p_rec.val_83,
p_rec.val_84,
p_rec.val_85,
p_rec.val_86,
p_rec.val_87,
p_rec.val_88,
p_rec.val_89,
p_rec.val_90,
p_rec.val_91,
p_rec.val_92,
p_rec.val_93,
p_rec.val_94,
p_rec.val_95,
p_rec.val_96,
p_rec.val_97,
p_rec.val_98,
p_rec.val_99,
p_rec.val_100,
p_rec.val_101,
p_rec.val_102,
p_rec.val_103,
p_rec.val_104,
p_rec.val_105,
p_rec.val_106,
p_rec.val_107,
p_rec.val_108,
p_rec.val_109,
p_rec.val_110,
p_rec.val_111,
p_rec.val_112,
p_rec.val_113,
p_rec.val_114,
p_rec.val_115,
p_rec.val_116,
p_rec.val_117,
p_rec.val_119,
p_rec.val_118,
p_rec.val_120,
p_rec.val_121,
p_rec.val_122,
p_rec.val_123,
p_rec.val_124,
p_rec.val_125,
p_rec.val_126,
p_rec.val_127,
p_rec.val_128,
p_rec.val_129,
p_rec.val_130,
p_rec.val_131,
p_rec.val_132,
p_rec.val_133,
p_rec.val_134,
p_rec.val_135,
p_rec.val_136,
p_rec.val_137,
p_rec.val_138,
p_rec.val_139,
p_rec.val_140,
p_rec.val_141,
p_rec.val_142,
p_rec.val_143,
p_rec.val_144,
p_rec.val_145,
p_rec.val_146,
p_rec.val_147,
p_rec.val_148,
p_rec.val_149,
p_rec.val_150,
p_rec.val_151,
p_rec.val_152,
p_rec.val_153,
p_rec.val_154,
p_rec.val_155,
p_rec.val_156,
p_rec.val_157,
p_rec.val_158,
p_rec.val_159,
p_rec.val_160,
p_rec.val_161,
p_rec.val_162,
p_rec.val_163,
p_rec.val_164,
p_rec.val_165,
p_rec.val_166,
p_rec.val_167,
p_rec.val_168,
p_rec.val_169,
p_rec.val_170,
p_rec.val_171,
p_rec.val_172,
p_rec.val_173,
p_rec.val_174,
p_rec.val_175,
p_rec.val_176,
p_rec.val_177,
p_rec.val_178,
p_rec.val_179,
p_rec.val_180,
p_rec.val_181,
p_rec.val_182,
p_rec.val_183,
p_rec.val_184,
p_rec.val_185,
p_rec.val_186,
p_rec.val_187,
p_rec.val_188,
p_rec.val_189,
p_rec.val_190,
p_rec.val_191,
p_rec.val_192,
p_rec.val_193,
p_rec.val_194,
p_rec.val_195,
p_rec.val_196,
p_rec.val_197,
p_rec.val_198,
p_rec.val_199,
p_rec.val_200,
p_rec.val_201,
p_rec.val_202,
p_rec.val_203,
p_rec.val_204,
p_rec.val_205,
p_rec.val_206,
p_rec.val_207,
p_rec.val_208,
p_rec.val_209,
p_rec.val_210,
p_rec.val_211,
p_rec.val_212,
p_rec.val_213,
p_rec.val_214,
p_rec.val_215,
p_rec.val_216,
p_rec.val_217,
p_rec.val_219,
p_rec.val_218,
p_rec.val_220,
p_rec.val_221,
p_rec.val_222,
p_rec.val_223,
p_rec.val_224,
p_rec.val_225,
p_rec.val_226,
p_rec.val_227,
p_rec.val_228,
p_rec.val_229,
p_rec.val_230,
p_rec.val_231,
p_rec.val_232,
p_rec.val_233,
p_rec.val_234,
p_rec.val_235,
p_rec.val_236,
p_rec.val_237,
p_rec.val_238,
p_rec.val_239,
p_rec.val_240,
p_rec.val_241,
p_rec.val_242,
p_rec.val_243,
p_rec.val_244,
p_rec.val_245,
p_rec.val_246,
p_rec.val_247,
p_rec.val_248,
p_rec.val_249,
p_rec.val_250,
p_rec.val_251,
p_rec.val_252,
p_rec.val_253,
p_rec.val_254,
p_rec.val_255,
p_rec.val_256,
p_rec.val_257,
p_rec.val_258,
p_rec.val_259,
p_rec.val_260,
p_rec.val_261,
p_rec.val_262,
p_rec.val_263,
p_rec.val_264,
p_rec.val_265,
p_rec.val_266,
p_rec.val_267,
p_rec.val_268,
p_rec.val_269,
p_rec.val_270,
p_rec.val_271,
p_rec.val_272,
p_rec.val_273,
p_rec.val_274,
p_rec.val_275,
p_rec.val_276,
p_rec.val_277,
p_rec.val_278,
p_rec.val_279,
p_rec.val_280,
p_rec.val_281,
p_rec.val_282,
p_rec.val_283,
p_rec.val_284,
p_rec.val_285,
p_rec.val_286,
p_rec.val_287,
p_rec.val_288,
p_rec.val_289,
p_rec.val_290,
p_rec.val_291,
p_rec.val_292,
p_rec.val_293,
p_rec.val_294,
p_rec.val_295,
p_rec.val_296,
p_rec.val_297,
p_rec.val_298,
p_rec.val_299,
p_rec.val_300,
p_rec.group_val_01,
p_rec.group_val_02,
p_rec.program_application_id,
p_rec.program_id,
p_rec.program_update_date,
p_rec.request_id,
p_rec.object_version_number,
p_rec.ext_rcd_in_file_id
);
End insert_dml;
Procedure pre_insert(p_rec in out nocopy ben_xrd_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'pre_insert';
Cursor C_Sel1 is select ben_ext_rslt_dtl_s.nextval from sys.dual;
End pre_insert;
Procedure post_insert(p_rec in ben_xrd_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'post_insert';
ben_xrd_rki.after_insert
(
p_ext_rslt_dtl_id =>p_rec.ext_rslt_dtl_id
,p_prmy_sort_val =>p_rec.prmy_sort_val
,p_scnd_sort_val =>p_rec.scnd_sort_val
,p_thrd_sort_val =>p_rec.thrd_sort_val
,p_trans_seq_num =>p_rec.trans_seq_num
,p_rcrd_seq_num =>p_rec.rcrd_seq_num
,p_ext_rslt_id =>p_rec.ext_rslt_id
,p_ext_rcd_id =>p_rec.ext_rcd_id
,p_person_id =>p_rec.person_id
,p_business_group_id =>p_rec.business_group_id
,p_ext_per_bg_id =>p_rec.ext_per_bg_id
,p_val_01 =>p_rec.val_01
,p_val_02 =>p_rec.val_02
,p_val_03 =>p_rec.val_03
,p_val_04 =>p_rec.val_04
,p_val_05 =>p_rec.val_05
,p_val_06 =>p_rec.val_06
,p_val_07 =>p_rec.val_07
,p_val_08 =>p_rec.val_08
,p_val_09 =>p_rec.val_09
,p_val_10 =>p_rec.val_10
,p_val_11 =>p_rec.val_11
,p_val_12 =>p_rec.val_12
,p_val_13 =>p_rec.val_13
,p_val_14 =>p_rec.val_14
,p_val_15 =>p_rec.val_15
,p_val_16 =>p_rec.val_16
,p_val_17 =>p_rec.val_17
,p_val_19 =>p_rec.val_19
,p_val_18 =>p_rec.val_18
,p_val_20 =>p_rec.val_20
,p_val_21 =>p_rec.val_21
,p_val_22 =>p_rec.val_22
,p_val_23 =>p_rec.val_23
,p_val_24 =>p_rec.val_24
,p_val_25 =>p_rec.val_25
,p_val_26 =>p_rec.val_26
,p_val_27 =>p_rec.val_27
,p_val_28 =>p_rec.val_28
,p_val_29 =>p_rec.val_29
,p_val_30 =>p_rec.val_30
,p_val_31 =>p_rec.val_31
,p_val_32 =>p_rec.val_32
,p_val_33 =>p_rec.val_33
,p_val_34 =>p_rec.val_34
,p_val_35 =>p_rec.val_35
,p_val_36 =>p_rec.val_36
,p_val_37 =>p_rec.val_37
,p_val_38 =>p_rec.val_38
,p_val_39 =>p_rec.val_39
,p_val_40 =>p_rec.val_40
,p_val_41 =>p_rec.val_41
,p_val_42 =>p_rec.val_42
,p_val_43 =>p_rec.val_43
,p_val_44 =>p_rec.val_44
,p_val_45 =>p_rec.val_45
,p_val_46 =>p_rec.val_46
,p_val_47 =>p_rec.val_47
,p_val_48 =>p_rec.val_48
,p_val_49 =>p_rec.val_49
,p_val_50 =>p_rec.val_50
,p_val_51 =>p_rec.val_51
,p_val_52 =>p_rec.val_52
,p_val_53 =>p_rec.val_53
,p_val_54 =>p_rec.val_54
,p_val_55 =>p_rec.val_55
,p_val_56 =>p_rec.val_56
,p_val_57 =>p_rec.val_57
,p_val_58 =>p_rec.val_58
,p_val_59 =>p_rec.val_59
,p_val_60 =>p_rec.val_60
,p_val_61 =>p_rec.val_61
,p_val_62 =>p_rec.val_62
,p_val_63 =>p_rec.val_63
,p_val_64 =>p_rec.val_64
,p_val_65 =>p_rec.val_65
,p_val_66 =>p_rec.val_66
,p_val_67 =>p_rec.val_67
,p_val_68 =>p_rec.val_68
,p_val_69 =>p_rec.val_69
,p_val_70 =>p_rec.val_70
,p_val_71 =>p_rec.val_71
,p_val_72 =>p_rec.val_72
,p_val_73 =>p_rec.val_73
,p_val_74 =>p_rec.val_74
,p_val_75 =>p_rec.val_75
,p_val_76 =>p_rec.val_76
,p_val_77 =>p_rec.val_77
,p_val_78 =>p_rec.val_78
,p_val_79 =>p_rec.val_79
,p_val_80 =>p_rec.val_80
,p_val_81 =>p_rec.val_81
,p_val_82 =>p_rec.val_82
,p_val_83 =>p_rec.val_83
,p_val_84 =>p_rec.val_84
,p_val_85 =>p_rec.val_85
,p_val_86 =>p_rec.val_86
,p_val_87 =>p_rec.val_87
,p_val_88 =>p_rec.val_88
,p_val_89 =>p_rec.val_89
,p_val_90 =>p_rec.val_90
,p_val_91 =>p_rec.val_91
,p_val_92 =>p_rec.val_92
,p_val_93 =>p_rec.val_93
,p_val_94 =>p_rec.val_94
,p_val_95 =>p_rec.val_95
,p_val_96 =>p_rec.val_96
,p_val_97 =>p_rec.val_97
,p_val_98 =>p_rec.val_98
,p_val_99 =>p_rec.val_99
,p_val_100 =>p_rec.val_100
,p_val_101 =>p_rec.val_101
,p_val_102 =>p_rec.val_102
,p_val_103 =>p_rec.val_103
,p_val_104 =>p_rec.val_104
,p_val_105 =>p_rec.val_105
,p_val_106 =>p_rec.val_106
,p_val_107 =>p_rec.val_107
,p_val_108 =>p_rec.val_108
,p_val_109 =>p_rec.val_109
,p_val_110 =>p_rec.val_110
,p_val_111 =>p_rec.val_111
,p_val_112 =>p_rec.val_112
,p_val_113 =>p_rec.val_113
,p_val_114 =>p_rec.val_114
,p_val_115 =>p_rec.val_115
,p_val_116 =>p_rec.val_116
,p_val_117 =>p_rec.val_117
,p_val_119 =>p_rec.val_119
,p_val_118 =>p_rec.val_118
,p_val_120 =>p_rec.val_120
,p_val_121 =>p_rec.val_121
,p_val_122 =>p_rec.val_122
,p_val_123 =>p_rec.val_123
,p_val_124 =>p_rec.val_124
,p_val_125 =>p_rec.val_125
,p_val_126 =>p_rec.val_126
,p_val_127 =>p_rec.val_127
,p_val_128 =>p_rec.val_128
,p_val_129 =>p_rec.val_129
,p_val_130 =>p_rec.val_130
,p_val_131 =>p_rec.val_131
,p_val_132 =>p_rec.val_132
,p_val_133 =>p_rec.val_133
,p_val_134 =>p_rec.val_134
,p_val_135 =>p_rec.val_135
,p_val_136 =>p_rec.val_136
,p_val_137 =>p_rec.val_137
,p_val_138 =>p_rec.val_138
,p_val_139 =>p_rec.val_139
,p_val_140 =>p_rec.val_140
,p_val_141 =>p_rec.val_141
,p_val_142 =>p_rec.val_142
,p_val_143 =>p_rec.val_143
,p_val_144 =>p_rec.val_144
,p_val_145 =>p_rec.val_145
,p_val_146 =>p_rec.val_146
,p_val_147 =>p_rec.val_147
,p_val_148 =>p_rec.val_148
,p_val_149 =>p_rec.val_149
,p_val_150 =>p_rec.val_150
,p_val_151 =>p_rec.val_151
,p_val_152 =>p_rec.val_152
,p_val_153 =>p_rec.val_153
,p_val_154 =>p_rec.val_154
,p_val_155 =>p_rec.val_155
,p_val_156 =>p_rec.val_156
,p_val_157 =>p_rec.val_157
,p_val_158 =>p_rec.val_158
,p_val_159 =>p_rec.val_159
,p_val_160 =>p_rec.val_160
,p_val_161 =>p_rec.val_161
,p_val_162 =>p_rec.val_162
,p_val_163 =>p_rec.val_163
,p_val_164 =>p_rec.val_164
,p_val_165 =>p_rec.val_165
,p_val_166 =>p_rec.val_166
,p_val_167 =>p_rec.val_167
,p_val_168 =>p_rec.val_168
,p_val_169 =>p_rec.val_169
,p_val_170 =>p_rec.val_170
,p_val_171 =>p_rec.val_171
,p_val_172 =>p_rec.val_172
,p_val_173 =>p_rec.val_173
,p_val_174 =>p_rec.val_174
,p_val_175 =>p_rec.val_175
,p_val_176 =>p_rec.val_176
,p_val_177 =>p_rec.val_177
,p_val_178 =>p_rec.val_178
,p_val_179 =>p_rec.val_179
,p_val_180 =>p_rec.val_180
,p_val_181 =>p_rec.val_181
,p_val_182 =>p_rec.val_182
,p_val_183 =>p_rec.val_183
,p_val_184 =>p_rec.val_184
,p_val_185 =>p_rec.val_185
,p_val_186 =>p_rec.val_186
,p_val_187 =>p_rec.val_187
,p_val_188 =>p_rec.val_188
,p_val_189 =>p_rec.val_189
,p_val_190 =>p_rec.val_190
,p_val_191 =>p_rec.val_191
,p_val_192 =>p_rec.val_192
,p_val_193 =>p_rec.val_193
,p_val_194 =>p_rec.val_194
,p_val_195 =>p_rec.val_195
,p_val_196 =>p_rec.val_196
,p_val_197 =>p_rec.val_197
,p_val_198 =>p_rec.val_198
,p_val_199 =>p_rec.val_199
,p_val_200 =>p_rec.val_200
,p_val_201 =>p_rec.val_201
,p_val_202 =>p_rec.val_202
,p_val_203 =>p_rec.val_203
,p_val_204 =>p_rec.val_204
,p_val_205 =>p_rec.val_205
,p_val_206 =>p_rec.val_206
,p_val_207 =>p_rec.val_207
,p_val_208 =>p_rec.val_208
,p_val_209 =>p_rec.val_209
,p_val_210 =>p_rec.val_210
,p_val_211 =>p_rec.val_211
,p_val_212 =>p_rec.val_212
,p_val_213 =>p_rec.val_213
,p_val_214 =>p_rec.val_214
,p_val_215 =>p_rec.val_215
,p_val_216 =>p_rec.val_216
,p_val_217 =>p_rec.val_217
,p_val_219 =>p_rec.val_219
,p_val_218 =>p_rec.val_218
,p_val_220 =>p_rec.val_220
,p_val_221 =>p_rec.val_221
,p_val_222 =>p_rec.val_222
,p_val_223 =>p_rec.val_223
,p_val_224 =>p_rec.val_224
,p_val_225 =>p_rec.val_225
,p_val_226 =>p_rec.val_226
,p_val_227 =>p_rec.val_227
,p_val_228 =>p_rec.val_228
,p_val_229 =>p_rec.val_229
,p_val_230 =>p_rec.val_230
,p_val_231 =>p_rec.val_231
,p_val_232 =>p_rec.val_232
,p_val_233 =>p_rec.val_233
,p_val_234 =>p_rec.val_234
,p_val_235 =>p_rec.val_235
,p_val_236 =>p_rec.val_236
,p_val_237 =>p_rec.val_237
,p_val_238 =>p_rec.val_238
,p_val_239 =>p_rec.val_239
,p_val_240 =>p_rec.val_240
,p_val_241 =>p_rec.val_241
,p_val_242 =>p_rec.val_242
,p_val_243 =>p_rec.val_243
,p_val_244 =>p_rec.val_244
,p_val_245 =>p_rec.val_245
,p_val_246 =>p_rec.val_246
,p_val_247 =>p_rec.val_247
,p_val_248 =>p_rec.val_248
,p_val_249 =>p_rec.val_249
,p_val_250 =>p_rec.val_250
,p_val_251 =>p_rec.val_251
,p_val_252 =>p_rec.val_252
,p_val_253 =>p_rec.val_253
,p_val_254 =>p_rec.val_254
,p_val_255 =>p_rec.val_255
,p_val_256 =>p_rec.val_256
,p_val_257 =>p_rec.val_257
,p_val_258 =>p_rec.val_258
,p_val_259 =>p_rec.val_259
,p_val_260 =>p_rec.val_260
,p_val_261 =>p_rec.val_261
,p_val_262 =>p_rec.val_262
,p_val_263 =>p_rec.val_263
,p_val_264 =>p_rec.val_264
,p_val_265 =>p_rec.val_265
,p_val_266 =>p_rec.val_266
,p_val_267 =>p_rec.val_267
,p_val_268 =>p_rec.val_268
,p_val_269 =>p_rec.val_269
,p_val_270 =>p_rec.val_270
,p_val_271 =>p_rec.val_271
,p_val_272 =>p_rec.val_272
,p_val_273 =>p_rec.val_273
,p_val_274 =>p_rec.val_274
,p_val_275 =>p_rec.val_275
,p_val_276 =>p_rec.val_276
,p_val_277 =>p_rec.val_277
,p_val_278 =>p_rec.val_278
,p_val_279 =>p_rec.val_279
,p_val_280 =>p_rec.val_280
,p_val_281 =>p_rec.val_281
,p_val_282 =>p_rec.val_282
,p_val_283 =>p_rec.val_283
,p_val_284 =>p_rec.val_284
,p_val_285 =>p_rec.val_285
,p_val_286 =>p_rec.val_286
,p_val_287 =>p_rec.val_287
,p_val_288 =>p_rec.val_288
,p_val_289 =>p_rec.val_289
,p_val_290 =>p_rec.val_290
,p_val_291 =>p_rec.val_291
,p_val_292 =>p_rec.val_292
,p_val_293 =>p_rec.val_293
,p_val_294 =>p_rec.val_294
,p_val_295 =>p_rec.val_295
,p_val_296 =>p_rec.val_296
,p_val_297 =>p_rec.val_297
,p_val_298 =>p_rec.val_298
,p_val_299 =>p_rec.val_299
,p_val_300 =>p_rec.val_300
,p_group_val_01 =>p_rec.group_val_01
,p_group_val_02 =>p_rec.group_val_02
,p_program_application_id =>p_rec.program_application_id
,p_program_id =>p_rec.program_id
,p_program_update_date =>p_rec.program_update_date
,p_request_id =>p_rec.request_id
,p_object_version_number =>p_rec.object_version_number
,p_ext_rcd_in_file_id =>p_rec.ext_rcd_in_file_id
);
End post_insert;
ben_xrd_bus.insert_validate(p_rec);
pre_insert(p_rec);
insert_dml(p_rec);
post_insert(p_rec);
p_program_update_date in date default null,
p_request_id in number default null,
p_object_version_number out nocopy number ,
p_ext_rcd_in_file_id in number default null
) is
--
l_rec ben_xrd_shd.g_rec_type;
p_program_update_date,
p_request_id,
null ,
p_ext_rcd_in_file_id
);