[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure delete_PLAN_DESIGN_TXN
(p_validate in number default 0 -- default false
,p_copy_entity_txn_id in number
,p_cet_object_version_number in number
,p_effective_date in date
) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := 'delete_PLAN_DESIGN_TXN';
select object_version_number
from pqh_copy_entity_txns
where copy_entity_txn_id = p_copy_entity_txn_id;
select copy_entity_attrib_id,cea_object_version_number
from ben_copy_entity_txns_vw
where copy_entity_txn_id = p_copy_entity_txn_id;
select cer.*
from ben_copy_entity_results cer
where COPY_ENTITY_TXN_ID = p_COPY_ENTITY_TXN_ID;
savepoint delete_PLAN_DESIGN_TXN;
BEN_PLAN_DESIGN_TXNS_API.delete_plan_design_result
( p_validate => p_validate
,p_copy_entity_txn_id => p_copy_entity_txn_id
,p_effective_date => p_effective_date
);
DELETE FROM PQH_COPY_ENTITY_RESULTS
WHERE COPY_ENTITY_TXN_ID = p_copy_entity_txn_id;
DELETE FROM BEN_COPY_ENTITY_RESULTS
WHERE COPY_ENTITY_TXN_ID = p_copy_entity_txn_id;
DELETE FROM PQH_COPY_ENTITY_ATTRIBS
WHERE COPY_ENTITY_TXN_ID = p_copy_entity_txn_id;
DELETE FROM PQH_COPY_ENTITY_TXNS
WHERE COPY_ENTITY_TXN_ID = p_copy_entity_txn_id;
PQH_COPY_ENTITY_ATTRIBS_api.delete_COPY_ENTITY_ATTRIB
(p_validate => false
,p_copy_entity_attrib_id => l_copy_entity_attrib_id
,p_object_version_number => l_cea_object_version_number
,p_effective_date => p_effective_date
);
delete from pqh_process_log
where txn_id = p_copy_entity_txn_id
and module_cd = 'PDC_CP';
PQH_COPY_ENTITY_TXNS_api.delete_COPY_ENTITY_TXN
(p_validate => false
,p_copy_entity_txn_id => p_copy_entity_txn_id
,p_object_version_number => l_object_version_number
,p_effective_date => p_effective_date
);
ROLLBACK TO delete_PLAN_DESIGN_TXN;
ROLLBACK TO delete_PLAN_DESIGN_TXN;
end delete_PLAN_DESIGN_TXN;
l_last_update_date date;
l_last_updated_by number(15);
l_last_update_login number(15);
select copy_entity_txn_id ,object_version_number
from pqh_copy_entity_txns cet
where cet.display_name = p_display_name
and cet.context_business_group_id = v_context_business_group_id
and cet.transaction_category_id = v_transaction_category_id ;
select transaction_category_id
from pqh_transaction_categories tc
where tc.short_name = p_TRANS_CATEGORY_NAME ;
select business_group_id
from per_business_groups bg
where bg.short_name = p_CONTEXT_BUSINESS_GROUP ;
select null
from all_triggers
where table_name = 'PQH_COPY_ENTITY_TXNS'
and trigger_name = 'PQH_COPY_ENTITY_TXNS_WHO'
and table_owner = l_schema
and status = 'ENABLED';
update pqh_copy_entity_txns
set display_name = display_name||l_datestamp
where copy_entity_txn_id = l_old_copy_entity_txn_id ;
l_last_update_date := sysdate;
l_last_updated_by := fnd_global.user_id;
l_last_update_login := fnd_global.login_id;
l_last_update_date := null;
l_last_updated_by := null;
l_last_update_login := null;
select pqh_copy_entity_txns_s.nextval into l_copy_entity_txn_id
from dual ;
insert into pqh_copy_entity_txns
( copy_entity_txn_id,
transaction_category_id,
txn_category_attribute_id,
context_business_group_id,
datetrack_mode,
context ,
action_date ,
src_effective_date,
number_of_copies ,
display_name,
replacement_type_cd,
start_with,
increment_by,
status,
object_version_number,
last_update_date, --Bug : 4354708
last_updated_by,
last_update_login,
created_by,
creation_date --Bug : 4354708
)
Values
( l_copy_entity_txn_id,
l_transaction_category_id,
null,
nvl(l_business_group_id,0),
null,
p_context ,
to_date(p_action_date ,'DD/MM/YYYY'),
to_date(p_src_effective_date,'DD/MM/YYYY'),
to_number(p_number_of_copies) ,
p_display_name,
p_replacement_type_cd,
l_start_with,
to_number(p_increment_by) ,
l_status,
l_object_version_number,
l_last_update_date, --Bug : 4354708
l_last_updated_by,
l_last_update_login,
l_created_by,
l_creation_date --Bug : 4354708
);
delete_PLAN_DESIGN_TXN
(p_copy_entity_txn_id =>l_old_copy_entity_txn_id
,p_cet_object_version_number =>l_ovn
,p_effective_date =>to_date(p_src_effective_date,'DD/MM/YYYY')
);
l_last_update_date date;
l_last_updated_by number(15);
l_last_update_login number(15);
select transaction_category_id
from pqh_transaction_categories tc
where tc.short_name = p_TRANS_CATEGORY_NAME ;
select null
from pqh_copy_entity_txns cet,
pqh_copy_entity_attribs cea
where cet.display_name = p_display_name
and cet.context_business_group_id = v_context_business_group_id
and cet.transaction_category_id = v_transaction_category_id
-- and to_char(cet.src_effective_date,'DD/MM/YYYY') = p_src_effective_date
and cet.copy_entity_txn_id = cea.copy_entity_txn_id ;
select copy_entity_txn_id
from pqh_copy_entity_txns cet
where cet.display_name = p_display_name
and cet.context_business_group_id = v_context_business_group_id
and cet.transaction_category_id = v_transaction_category_id ;
select null
from all_triggers
where table_name = 'PQH_COPY_ENTITY_ATTRIBS'
and trigger_name = 'PQH_COPY_ENTITY_ATTRIBS_WHO'
and table_owner = l_schema
and status = 'ENABLED';
l_last_update_date := sysdate;
l_last_updated_by := fnd_global.user_id;
l_last_update_login := fnd_global.login_id;
l_last_update_date := null;
l_last_updated_by := null;
l_last_update_login := null;
select pqh_copy_entity_attribs_s.nextval into l_copy_entity_attrib_id
from dual ;
insert into pqh_copy_entity_attribs
( copy_entity_attrib_id,
copy_entity_txn_id,
row_type_cd,
information_category,
information1,
information2,
information3,
information4,
information5,
information6,
information7,
information8,
information9,
information10,
information11,
information12,
information13,
information14,
information15,
information16,
information17,
information18,
information19,
information20,
information21,
information22,
information23,
information24,
information25,
information26,
information27,
information28,
information29,
information30,
object_version_number,
last_update_date, --Bug : 4354708
last_updated_by,
last_update_login,
created_by,
creation_date --Bug : 4354708
)
Values
( l_copy_entity_attrib_id,
l_copy_entity_txn_id,
p_row_type_cd,
p_information_category,
p_information1,
p_information2,
l_target_typ_cd,
p_information4,
p_information5,
p_information6,
p_information7,
p_information8,
p_information9,
p_information10,
p_information11,
p_information12,
p_information13,
p_information14,
p_information15,
p_information16,
p_information17,
p_information18,
p_information19,
p_information20,
p_information21,
p_information22,
p_information23,
p_information24,
p_information25,
p_information26,
p_information27,
p_information28,
p_information29,
p_information30,
l_object_version_number,
l_last_update_date, --Bug : 4354708
l_last_updated_by,
l_last_update_login,
l_created_by,
l_creation_date --Bug : 4354708
);
l_last_update_date date;
l_last_updated_by number(15);
l_last_update_login number(15);
select transaction_category_id
from pqh_transaction_categories tc
where tc.short_name = p_TRANS_CATEGORY_NAME ;
select null
from pqh_copy_entity_txns cet,
pqh_copy_entity_results cer
where cet.display_name = p_display_name
and cet.context_business_group_id = v_context_business_group_id
and cet.transaction_category_id = v_transaction_category_id
-- and to_char(cet.src_effective_date,'DD/MM/YYYY') = p_src_effective_date
and cet.copy_entity_txn_id = cer.copy_entity_txn_id
and ( p_mirror_entity_result_id is null or
cer.mirror_entity_result_id = to_number(p_mirror_entity_result_id) )
and ( p_mirror_src_entity_result_id is null or
cer.mirror_src_entity_result_id = to_number(p_mirror_src_entity_result_id)) ;
select copy_entity_txn_id
from pqh_copy_entity_txns cet
where cet.display_name = p_display_name
and cet.context_business_group_id = v_context_business_group_id
and cet.transaction_category_id = v_transaction_category_id ;
select table_route_id
from pqh_table_route tr
where table_alias = p_table_alias
and tr.from_clause = 'OAB' ;
select null
from all_triggers
where table_name = 'PQH_COPY_ENTITY_RESULTS'
and trigger_name = 'PQH_COPY_ENTITY_RESULTS_WHO'
and table_owner = l_schema
and status = 'ENABLED';
l_last_update_date := sysdate;
l_last_updated_by := fnd_global.user_id;
l_last_update_login := fnd_global.login_id;
l_last_update_date := null;
l_last_updated_by := null;
l_last_update_login := null;
select pqh_copy_entity_results_s.nextval into l_copy_entity_result_id
from dual ;
insert into pqh_copy_entity_results
( copy_entity_result_id,
copy_entity_txn_id,
result_type_cd,
number_of_copies,
status,
src_copy_entity_result_id,
information_category,
information1,
information2,
information3,
information4,
information5,
information6,
information7,
information8,
information9,
information10,
information11,
information12,
information13,
information14,
information15,
information16,
information17,
information18,
information19,
information20,
information21,
information22,
information23,
information24,
information25,
information26,
information27,
information28,
information29,
information30,
information31,
information32,
information33,
information34,
information35,
information36,
information37,
information38,
information39,
information40,
information41,
information42,
information43,
information44,
information45,
information46,
information47,
information48,
information49,
information50,
information51,
information52,
information53,
information54,
information55,
information56,
information57,
information58,
information59,
information60,
information61,
information62,
information63,
information64,
information65,
information66,
information67,
information68,
information69,
information70,
information71,
information72,
information73,
information74,
information75,
information76,
information77,
information78,
information79,
information80,
information81,
information82,
information83,
information84,
information85,
information86,
information87,
information88,
information89,
information90,
information91 ,
information92 ,
information93 ,
information94 ,
information95 ,
information96 ,
information97 ,
information98 ,
information99 ,
information100 ,
information101 ,
information102 ,
information103 ,
information104 ,
information105 ,
information106 ,
information107 ,
information108 ,
information109 ,
information110 ,
information111 ,
information112 ,
information113 ,
information114 ,
information115 ,
information116 ,
information117 ,
information118 ,
information119 ,
information120 ,
information121 ,
information122 ,
information123 ,
information124 ,
information125 ,
information126 ,
information127 ,
information128 ,
information129 ,
information130 ,
information131 ,
information132 ,
information133 ,
information134 ,
information135 ,
information136 ,
information137 ,
information138 ,
information139 ,
information140 ,
information141 ,
information142 ,
information143 ,
information144 ,
information145 ,
information146 ,
information147 ,
information148 ,
information149 ,
information150 ,
information151 ,
information152 ,
information153 ,
information154 ,
information155 ,
information156 ,
information157 ,
information158 ,
information159 ,
information160 ,
information161 ,
information162 ,
information163 ,
information164 ,
information165 ,
information166 ,
information167 ,
information168 ,
information169 ,
information170 ,
information171 ,
information172 ,
information173 ,
information174 ,
information175 ,
information176 ,
information177 ,
information178 ,
information179 ,
information180 ,
information181 ,
information182 ,
information183 ,
information184 ,
information185 ,
information186 ,
information187 ,
information188 ,
information189 ,
information190 ,
object_version_number ,
table_route_id ,
mirror_entity_result_id,
mirror_src_entity_result_id,
parent_entity_result_id,
long_attribute1,
last_update_date, --Bug : 4354708
last_updated_by,
last_update_login,
created_by,
creation_date --Bug : 4354708
)
Values
( pqh_copy_entity_results_s.nextval, -- l_copy_entity_result_id,
l_copy_entity_txn_id,
p_result_type_cd,
to_number(p_number_of_copies),
p_status,
null, -- p_src_copy_entity_result_id,
p_information_category,
p_information1,
p_information2,
p_information3,
p_information4,
p_information5,
p_information6,
p_information7,
p_information8,
p_information9,
p_information10,
p_information11,
p_information12,
p_information13,
p_information14,
p_information15,
p_information16,
p_information17,
p_information18,
p_information19,
p_information20,
p_information21,
p_information22,
p_information23,
p_information24,
p_information25,
p_information26,
p_information27,
p_information28,
p_information29,
p_information30,
p_information31,
p_information32,
p_information33,
p_information34,
p_information35,
p_information36,
p_information37,
p_information38,
p_information39,
p_information40,
p_information41,
p_information42,
p_information43,
p_information44,
p_information45,
p_information46,
p_information47,
p_information48,
p_information49,
p_information50,
p_information51,
p_information52,
p_information53,
p_information54,
p_information55,
p_information56,
p_information57,
p_information58,
p_information59,
p_information60,
p_information61,
p_information62,
p_information63,
p_information64,
p_information65,
p_information66,
p_information67,
p_information68,
p_information69,
p_information70,
p_information71,
p_information72,
p_information73,
p_information74,
p_information75,
p_information76,
p_information77,
p_information78,
p_information79,
p_information80,
p_information81,
p_information82,
p_information83,
p_information84,
p_information85,
p_information86,
p_information87,
p_information88,
p_information89,
p_information90,
p_information91 ,
p_information92 ,
p_information93 ,
p_information94 ,
p_information95 ,
p_information96 ,
p_information97 ,
p_information98 ,
p_information99 ,
p_information100 ,
p_information101 ,
p_information102 ,
p_information103 ,
p_information104 ,
p_information105 ,
p_information106 ,
p_information107 ,
p_information108 ,
p_information109 ,
p_information110 ,
p_information111 ,
p_information112 ,
p_information113 ,
p_information114 ,
p_information115 ,
p_information116 ,
p_information117 ,
p_information118 ,
p_information119 ,
p_information120 ,
p_information121 ,
p_information122 ,
p_information123 ,
p_information124 ,
p_information125 ,
p_information126 ,
p_information127 ,
p_information128 ,
p_information129 ,
p_information130 ,
p_information131 ,
p_information132 ,
p_information133 ,
p_information134 ,
p_information135 ,
p_information136 ,
p_information137 ,
p_information138 ,
p_information139 ,
p_information140 ,
p_information141 ,
p_information142 ,
p_information143 ,
p_information144 ,
p_information145 ,
p_information146 ,
p_information147 ,
p_information148 ,
p_information149 ,
p_information150 ,
p_information151 ,
p_information152 ,
p_information153 ,
p_information154 ,
p_information155 ,
p_information156 ,
p_information157 ,
p_information158 ,
p_information159 ,
p_information160 ,
p_information161 ,
p_information162 ,
p_information163 ,
p_information164 ,
p_information165 ,
p_information166 ,
p_information167 ,
p_information168 ,
p_information169 ,
p_information170 ,
p_information171 ,
p_information172 ,
p_information173 ,
p_information174 ,
p_information175 ,
p_information176 ,
p_information177 ,
p_information178 ,
p_information179 ,
p_information180 ,
p_information181 ,
p_information182 ,
p_information183 ,
p_information184 ,
p_information185 ,
p_information186 ,
p_information187 ,
p_information188 ,
p_information189 ,
p_information190 ,
l_object_version_number ,
l_table_route_id ,
to_number(p_mirror_entity_result_id) ,
to_number(p_mirror_src_entity_result_id),
to_number(p_parent_entity_result_id),
p_long_attribute1 ,
l_last_update_date, --Bug : 4354708
l_last_updated_by,
l_last_update_login,
l_created_by,
l_creation_date --Bug : 4354708
);
l_last_update_date date;
l_last_updated_by number(15);
l_last_update_login number(15);
select transaction_category_id
from pqh_transaction_categories tc
where tc.short_name = g_TRANS_CATEGORY_NAME ;
select copy_entity_txn_id
from pqh_copy_entity_txns cet
where cet.display_name = p_display_name
and cet.context_business_group_id = v_context_business_group_id
and cet.transaction_category_id = v_transaction_category_id;
select table_route_id
from pqh_table_route tr
where table_alias = p_table_alias
and tr.from_clause = 'OAB' ;
select null
from all_triggers
where table_name = 'BEN_COPY_ENTITY_RESULTS'
and trigger_name = 'BEN_COPY_ENTITY_RESULTS_WHO'
and table_owner = l_schema
and status = 'ENABLED';
l_last_update_date := sysdate;
l_last_updated_by := fnd_global.user_id;
l_last_update_login := fnd_global.login_id;
l_last_update_date := null;
l_last_updated_by := null;
l_last_update_login := null;
insert into ben_copy_entity_results
( copy_entity_result_id
,copy_entity_txn_id
,src_copy_entity_result_id
,result_type_cd
,number_of_copies
,mirror_entity_result_id
,mirror_src_entity_result_id
,parent_entity_result_id
,pd_mirror_src_entity_result_id
,pd_parent_entity_result_id
,gs_mirror_src_entity_result_id
,gs_parent_entity_result_id
,table_name
,table_route_id
,status
,dml_operation
,information_category
,information1
,information2
,information3
,information4
,information5
,information6
,information7
,information8
,information9
,information10
,information11
,information12
,information13
,information14
,information15
,information16
,information17
,information18
,information19
,information20
,information21
,information22
,information23
,information24
,information25
,information26
,information27
,information28
,information29
,information30
,information31
,information32
,information33
,information34
,information35
,information36
,information37
,information38
,information39
,information40
,information41
,information42
,information43
,information44
,information45
,information46
,information47
,information48
,information49
,information50
,information51
,information52
,information53
,information54
,information55
,information56
,information57
,information58
,information59
,information60
,information61
,information62
,information63
,information64
,information65
,information66
,information67
,information68
,information69
,information70
,information71
,information72
,information73
,information74
,information75
,information76
,information77
,information78
,information79
,information80
,information81
,information82
,information83
,information84
,information85
,information86
,information87
,information88
,information89
,information90
,information91
,information92
,information93
,information94
,information95
,information96
,information97
,information98
,information99
,information100
,information101
,information102
,information103
,information104
,information105
,information106
,information107
,information108
,information109
,information110
,information111
,information112
,information113
,information114
,information115
,information116
,information117
,information118
,information119
,information120
,information121
,information122
,information123
,information124
,information125
,information126
,information127
,information128
,information129
,information130
,information131
,information132
,information133
,information134
,information135
,information136
,information137
,information138
,information139
,information140
,information141
,information142
/* Extra Reserved Columns
,information143
,information144
,information145
,information146
,information147
,information148
,information149
,information150
*/
,information151
,information152
,information153
/* Extra Reserved Columns
,information154
,information155
,information156
,information157
,information158
,information159
*/
,information160
,information161
,information162
/* Extra Reserved Columns
,information163
,information164
,information165
*/
,information166
,information167
,information168
,information169
,information170
/* Extra Reserved Columns
,information171
,information172
*/
,information173
,information174
,information175
,information176
,information177
,information178
,information179
,information180
,information181
,information182
/* Extra Reserved Columns
,information183
,information184
*/
,information185
,information186
,information187
,information188
/* Extra Reserved Columns
,information189
*/
,information190
,information191
,information192
,information193
,information194
,information195
,information196
,information197
,information198
,information199
/* Extra Reserved Columns
,information200
,information201
,information202
,information203
,information204
,information205
,information206
,information207
,information208
,information209
,information210
,information211
,information212
,information213
,information214
,information215
*/
,information216
,information217
,information218
,information219
,information220
,information221
,information222
,information223
,information224
,information225
,information226
,information227
,information228
,information229
,information230
,information231
,information232
,information233
,information234
,information235
,information236
,information237
,information238
,information239
,information240
,information241
,information242
,information243
,information244
,information245
,information246
,information247
,information248
,information249
,information250
,information251
,information252
,information253
,information254
,information255
,information256
,information257
,information258
,information259
,information260
,information261
,information262
,information263
,information264
,information265
,information266
,information267
,information268
,information269
,information270
,information271
,information272
,information273
,information274
,information275
,information276
,information277
,information278
,information279
,information280
,information281
,information282
,information283
,information284
,information285
,information286
,information287
,information288
,information289
,information290
,information291
,information292
,information293
,information294
,information295
,information296
,information297
,information298
,information299
,information300
,information301
,information302
,information303
,information304
/* Extra Reserved Columns
,information305
*/
,information306
,information307
,information308
,information309
,information310
,information311
,information312
,information313
,information314
,information315
,information316
,information317
,information318
,information319
,information320
/* Extra Reserved Columns
,information321
,information322
*/
,information323
,datetrack_mode
,table_alias
,object_version_number
,last_update_date --Bug : 4354708
,last_updated_by
,last_update_login
,created_by
,creation_date --Bug : 4354708
)
Values
( ben_copy_entity_results_s.nextval
,l_copy_entity_txn_id
,NULL -- g_src_copy_entity_result_id -- Start global variables
,g_result_type_cd
,to_number(g_number_of_copies)
,to_number(g_mirror_entity_result_id)
,to_number(g_mirror_src_entity_result_id)
,to_number(g_parent_entity_result_id)
,to_number(g_pd_mr_src_entity_result_id)
,to_number(g_pd_parent_entity_result_id)
,to_number(g_gs_mr_src_entity_result_id)
,to_number(g_gs_parent_entity_result_id)
,g_table_name
,l_table_route_id
,g_status
,g_dml_operation
,g_information_category
,to_number(g_information1)
,to_date(g_information2,'DD/MM/YYYY')
,to_date(g_information3,'DD/MM/YYYY')
,to_number(g_information4)
,g_information5
,g_information6
,g_information7
,g_information8
,g_information9
,to_date(g_information10,'DD/MM/YYYY')
,g_information11
,g_information12
,g_information13
,g_information14
,g_information15
,g_information16
,g_information17
,g_information18
,g_information19
,g_information20
,g_information21
,g_information22
,g_information23
,g_information24
,g_information25
,g_information26
,g_information27
,g_information28
,g_information29
,g_information30
,g_information31
,g_information32
,g_information33
,g_information34
,g_information35
,g_information36
,g_information37
,g_information38
,g_information39
,g_information40
,g_information41
,g_information42
,g_information43
,g_information44
,g_information45
,g_information46
,g_information47
,g_information48
,g_information49
,g_information50
,g_information51
,g_information52
,g_information53
,g_information54
,g_information55
,g_information56
,g_information57
,g_information58
,g_information59
,g_information60
,g_information61
,g_information62
,g_information63
,g_information64
,g_information65
,g_information66
,g_information67
,g_information68
,g_information69
,g_information70
,g_information71
,g_information72
,g_information73
,g_information74
,g_information75
,g_information76
,g_information77
,g_information78
,g_information79
,g_information80
,g_information81
,g_information82
,g_information83
,g_information84
,g_information85
,g_information86
,g_information87
,g_information88
,g_information89
,g_information90 -- End global variables
,p_information91
,p_information92
,p_information93
,p_information94
,p_information95
,p_information96
,p_information97
,p_information98
,p_information99
,p_information100
,p_information101
,p_information102
,p_information103
,p_information104
,p_information105
,p_information106
,p_information107
,p_information108
,p_information109
,p_information110
,p_information111
,p_information112
,p_information113
,p_information114
,p_information115
,p_information116
,p_information117
,p_information118
,p_information119
,p_information120
,p_information121
,p_information122
,p_information123
,p_information124
,p_information125
,p_information126
,p_information127
,p_information128
,p_information129
,p_information130
,p_information131
,p_information132
,p_information133
,p_information134
,p_information135
,p_information136
,p_information137
,p_information138
,p_information139
,p_information140
,p_information141
,p_information142
/* Extra Reserved Columns
,p_information143
,p_information144
,p_information145
,p_information146
,p_information147
,p_information148
,p_information149
,p_information150
*/
,p_information151
,p_information152
,p_information153
/* Extra Reserved Columns
,p_information154
,p_information155
,p_information156
,p_information157
,p_information158
,p_information159
*/
,to_number(p_information160)
,to_number(p_information161)
,to_number(p_information162)
/* Extra Reserved Columns
,to_number(p_information163)
,to_number(p_information164)
,to_number(p_information165)
*/
,to_date(p_information166,'DD/MM/YYYY')
,to_date(p_information167,'DD/MM/YYYY')
,to_date(p_information168,'DD/MM/YYYY')
,to_number(p_information169)
,p_information170
/* Extra Reserved Columns
,p_information171
,p_information172
*/
,p_information173
,to_number(p_information174)
,p_information175
,to_number(p_information176)
,p_information177
,to_number(p_information178)
,p_information179
,to_number(p_information180)
,p_information181
,p_information182
/* Extra Reserved Columns
,p_information183
,p_information184
*/
,p_information185
,p_information186
,p_information187
,p_information188
/* Extra Reserved Columns
,p_information189
*/
,p_information190
,p_information191
,p_information192
,p_information193
,p_information194
,p_information195
,p_information196
,p_information197
,p_information198
,p_information199
/* Extra Reserved Columns
,p_information200
,p_information201
,p_information202
,p_information203
,p_information204
,p_information205
,p_information206
,p_information207
,p_information208
,p_information209
,p_information210
,p_information211
,p_information212
,p_information213
,p_information214
,p_information215
*/
,p_information216
,p_information217
,p_information218
,p_information219
,p_information220
,to_number(p_information221)
,to_number(p_information222)
,to_number(p_information223)
,to_number(p_information224)
,to_number(p_information225)
,to_number(p_information226)
,to_number(p_information227)
,to_number(p_information228)
,to_number(p_information229)
,to_number(p_information230)
,to_number(p_information231)
,to_number(p_information232)
,to_number(p_information233)
,to_number(p_information234)
,to_number(p_information235)
,to_number(p_information236)
,to_number(p_information237)
,to_number(p_information238)
,to_number(p_information239)
,to_number(p_information240)
,to_number(p_information241)
,to_number(p_information242)
,to_number(p_information243)
,to_number(p_information244)
,to_number(p_information245)
,to_number(p_information246)
,to_number(p_information247)
,to_number(p_information248)
,to_number(p_information249)
,to_number(p_information250)
,to_number(p_information251)
,to_number(p_information252)
,to_number(p_information253)
,to_number(p_information254)
,to_number(p_information255)
,to_number(p_information256)
,to_number(p_information257)
,to_number(p_information258)
,to_number(p_information259)
,to_number(p_information260)
,to_number(p_information261)
,to_number(p_information262)
,to_number(p_information263)
,to_number(p_information264)
,to_number(p_information265)
,to_number(p_information266)
,to_number(p_information267)
,to_number(p_information268)
,to_number(p_information269)
,to_number(p_information270)
,to_number(p_information271)
,to_number(p_information272)
,to_number(p_information273)
,to_number(p_information274)
,to_number(p_information275)
,to_number(p_information276)
,to_number(p_information277)
,to_number(p_information278)
,to_number(p_information279)
,to_number(p_information280)
,to_number(p_information281)
,to_number(p_information282)
,to_number(p_information283)
,to_number(p_information284)
,to_number(p_information285)
,to_number(p_information286)
,to_number(p_information287)
,to_number(p_information288)
,to_number(p_information289)
,to_number(p_information290)
,to_number(p_information291)
,to_number(p_information292)
,to_number(p_information293)
,to_number(p_information294)
,to_number(p_information295)
,to_number(p_information296)
,to_number(p_information297)
,to_number(p_information298)
,to_number(p_information299)
,to_number(p_information300)
,to_number(p_information301)
,to_number(p_information302)
,to_number(p_information303)
,to_number(p_information304)
/* Extra Reserved Columns
,to_number(p_information305)
*/
,to_date(p_information306,'DD/MM/YYYY')
,to_date(p_information307,'DD/MM/YYYY')
,to_date(p_information308,'DD/MM/YYYY')
,to_date(p_information309,'DD/MM/YYYY')
,to_date(p_information310,'DD/MM/YYYY')
,to_date(p_information311,'DD/MM/YYYY')
,to_date(p_information312,'DD/MM/YYYY')
,to_date(p_information313,'DD/MM/YYYY')
,to_date(p_information314,'DD/MM/YYYY')
,to_date(p_information315,'DD/MM/YYYY')
,to_date(p_information316,'DD/MM/YYYY')
,to_date(p_information317,'DD/MM/YYYY')
,to_date(p_information318,'DD/MM/YYYY')
,to_date(p_information319,'DD/MM/YYYY')
,to_date(p_information320,'DD/MM/YYYY')
/* Extra Reserved Columns
,to_date(p_information321,'DD/MM/YYYY')
,to_date(p_information322,'DD/MM/YYYY')
*/
,p_information323
,p_datetrack_mode
,p_table_alias
,l_object_version_number
,l_last_update_date --Bug : 4354708
,l_last_updated_by
,l_last_update_login
,l_created_by
,l_creation_date --Bug : 4354708
);