[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
23/6/2006 BRATHOD 120.2 5166688 Modified the signature of INSERT_ROW procedure in
to return rowid to caller of API by adding out
parameter in the call. Refer bug# 5166688 for details
04/07/2006 KASBALAS 120.3 5398572 Modified the insert_row to insert the Driving
Date code as well.Refer Bug # 5398572 for details.
-----------------------------------------------------------------------------------------------------------*/
procedure insert_row
( x_record in jg_zz_vat_rep_entities%rowtype
, x_vat_reporting_entity_id out nocopy jg_zz_vat_rep_entities.vat_reporting_entity_id%type
, x_row_id out nocopy rowid
)
is
cursor c_gen_vat_reporting_entity_id
is
select jg_zz_vat_rep_entities_s.nextval
from dual;
insert into jg_zz_vat_rep_entities
( vat_reporting_entity_id
, legal_entity_id
, party_id
, tax_regime_code
, tax_registration_number
, tax_calendar_name
, enable_allocations_flag
, enable_annual_allocation_flag
, enable_registers_flag
, enable_report_sequence_flag
, threshold_amount
, created_by
, creation_date
, last_updated_by
, last_update_date
, last_update_login
, entity_type_code
, entity_level_code
, ledger_id
, balancing_segment_value
, mapping_vat_rep_entity_id
, entity_identifier
, driving_date_code
)
values ( x_vat_reporting_entity_id
, x_record.legal_entity_id
, x_record.party_id
, x_record.tax_regime_code
, x_record.tax_registration_number
, x_record.tax_calendar_name
, x_record.enable_allocations_flag
, x_record.enable_annual_allocation_flag
, x_record.enable_registers_flag
, x_record.enable_report_sequence_flag
, x_record.threshold_amount
, x_record.created_by
, x_record.creation_date
, x_record.last_updated_by
, x_record.last_update_date
, x_record.last_update_login
, lv_entity_type_code
, x_record.entity_level_code
, x_record.ledger_id
, x_record.balancing_segment_value
, x_record.mapping_vat_rep_entity_id
, x_record.entity_identifier
, x_record.driving_date_code
) returning rowid into x_row_id ;
jg_zz_vat_rep_entities_pkg.update_entity_identifier
( pn_vat_reporting_entity_id => x_vat_reporting_entity_id
, pv_entity_level_code => null
, pn_ledger_id => null
, pv_balancing_segment_value => null
, pv_called_from => 'TABLE_HANDLER'
);
end insert_row;
select jzvrc.*
from jg_zz_vat_rep_entities jzvrc
where rowid = x_row_id
for update nowait;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
procedure update_row( x_record in jg_zz_vat_rep_entities%rowtype
)
is
le_no_rows_updated exception;
update jg_zz_vat_rep_entities
set legal_entity_id = x_record.legal_entity_id
, party_id = x_record.party_id
, tax_regime_code = x_record.tax_regime_code
, tax_registration_number = x_record.tax_registration_number
, tax_calendar_name = x_record.tax_calendar_name
, enable_allocations_flag = x_record.enable_allocations_flag
, enable_annual_allocation_flag = x_record.enable_annual_allocation_flag
, enable_registers_flag = x_record.enable_registers_flag
, enable_report_sequence_flag = x_record.enable_report_sequence_flag
, threshold_amount = x_record.threshold_amount
, created_by = x_record.created_by
, creation_date = x_record.creation_date
, last_updated_by = x_record.last_updated_by
, last_update_date = x_record.last_update_date
, last_update_login = x_record.last_update_login
, entity_type_code = x_record.entity_type_code
, entity_level_code = x_record.entity_level_code
, ledger_id = x_record.ledger_id
, balancing_segment_value = x_record.balancing_segment_value
, mapping_vat_rep_entity_id = x_record.mapping_vat_rep_entity_id
, entity_identifier = x_record.entity_identifier
, driving_date_code =
x_record.driving_date_code
where vat_reporting_entity_id = x_record.vat_reporting_entity_id;
end update_row;
procedure delete_row(x_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type)
is
le_no_rows_deleted exception;
delete from jg_zz_vat_rep_entities
where vat_reporting_entity_id = x_vat_reporting_entity_id;
end delete_row;
procedure update_entity_identifier
( pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type
, pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type default null
, pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null
, pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null
, pv_called_from in varchar2
)
is
lv_entity_identifier jg_zz_vat_rep_entities.entity_identifier%type;
update jg_zz_vat_rep_entities
set entity_identifier = lv_entity_identifier
where vat_reporting_entity_id = pn_vat_reporting_entity_id;
end update_entity_identifier;