[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT rci.country country,
rci.city city,
rci.state state,
rci.county county,
rci.province province,
rci.postal_code postal_code,
rci.address_attribute1 attribute1,
rci.address_attribute2 attribute2,
rci.address_attribute3 attribute3,
rci.address_attribute4 attribute4,
rci.address_attribute5 attribute5,
rci.address_attribute6 attribute6,
rci.address_attribute7 attribute7,
rci.address_attribute8 attribute8,
rci.address_attribute9 attribute9,
rci.address_attribute10 attribute10,
rci.rowid row_id
FROM ra_customers_interface rci ,
ar_system_parameters sp
WHERE rci.interface_status is null
AND rci.orig_system_address_ref is not null
AND rci.request_id = request_id
AND rci.country = sp.default_country
AND rci.rowid in (SELECT min(rci2.rowid)
FROM ra_customers_interface rci2
WHERE rci2.interface_status is null
AND rci2.orig_system_address_ref =
rci.orig_system_address_ref
/* Added the site_use_code clause for Bug 235747 which causes all of the *
* relevant rows to be considered for error checking. Leaving this where *
* clause causes only 1 of the row from ra_customers_interface to be *
* selected. In order to do proper error checking we would like to have *
* all those rows which have a distinct combination of address ref and *
* site use code. */
AND NVL(rci2.site_use_code,'X') = NVL(rci.site_use_code,'X')
AND rci2.request_id = request_id
);
UPDATE ra_customers_interface
SET warning_text = warning_text_in,
location_ccid = location_ccid_in,
message_text = message_text_in,
interface_status = interface_status_in
WHERE rowid = rowid_in;
h_last_update_login in number,
h_application_id in number,
h_language_id in number ) IS
BEGIN
arp_standard.set_who_information( h_user_id,
h_request_id,
h_prog_appl_id,
h_program_id,
h_last_update_login ) ;
( arp_adds.location_segment_inserted = TRUE )
THEN
arp_cint.up_cust_int( 'Q1,', loc_ccid, null,
null, add_rec.row_id );