35:
36: -- Initialization block
37: l_stmt := 0;
38:
39: bis_collection_utilities.put_line('Enter pre_r12_opm_cogs() ' ||
40: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
41: INSERT /*+ append parallel(opi_dbi_cogs_fstg) */ into opi_dbi_cogs_fstg (
42: inventory_item_id,
43: organization_id,
137: l_stmt := 1;
138:
139: COMMIT;
140:
141: bis_collection_utilities.put_line('Exit pre_r12_opm_cogs() ' ||
142: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
143:
144: EXCEPTION WHEN OTHERS THEN
145: --{
144: EXCEPTION WHEN OTHERS THEN
145: --{
146: ROLLBACK;
147:
148: bis_collection_utilities.put_line(' Error in pre_r12_opm_cogs() at statement');
149: bis_collection_utilities.put_line( Sqlerrm );
150: --}
151: END pre_r12_opm_cogs;
152:
145: --{
146: ROLLBACK;
147:
148: bis_collection_utilities.put_line(' Error in pre_r12_opm_cogs() at statement');
149: bis_collection_utilities.put_line( Sqlerrm );
150: --}
151: END pre_r12_opm_cogs;
152:
153: END opi_dbi_pre_r12_cogs_pkg;