[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT simulation_id
FROM inl_simulations
WHERE vendor_id = p_from_id
AND vendor_site_id = p_from_site_id;
SELECT ship_line_group_id
FROM inl_ship_line_groups
WHERE party_id = p_from_party_id
AND party_site_id = p_from_party_site_id
AND src_type_code = 'PO';
SELECT ship_line_id
FROM inl_ship_lines_all
WHERE ((poa_party_id = p_from_id AND poa_party_site_id = p_from_site_id)
OR (ship_from_party_id = p_from_id AND ship_from_party_site_id = p_from_site_id)
OR (bill_from_party_id = p_from_id AND bill_from_party_site_id = p_from_site_id))
AND ship_line_src_type_code = 'PO';
SELECT charge_line_id
FROM inl_charge_lines cl
WHERE (cl.party_id = p_from_party_id or cl.party_site_id = p_from_party_site_id)
AND ((cl.ship_from_party_id = p_from_id AND cl.ship_from_party_site_id = p_from_site_id)
OR (cl.bill_from_party_id = p_from_id AND cl.bill_from_party_site_id = p_from_site_id)
OR (cl.poa_party_id = p_from_id AND cl.poa_party_site_id = p_from_site_id));
SELECT match_id
FROM INL_MATCHES
WHERE party_id = p_from_party_id
AND party_site_id = p_from_party_site_id;
UPDATE inl_simulations
SET vendor_id = p_to_id,
vendor_site_id = p_to_site_id,
request_id = fnd_global.conc_request_id,
program_id = fnd_global.conc_program_id,
program_application_id = fnd_global.prog_appl_id,
last_update_date = sysdate,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.login_id
WHERE simulation_id = l_simulation_list(j);
l_debug_info := 'Updated inl_simulations. Number of Rows updated is ' || sql%rowcount;
UPDATE inl_ship_line_groups
SET party_id = p_to_party_id,
party_site_id = p_to_party_site_id,
request_id = fnd_global.conc_request_id,
program_id = fnd_global.conc_program_id,
program_application_id = fnd_global.prog_appl_id,
last_update_date = sysdate,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.login_id
WHERE ship_line_group_id = l_line_group_list(j);
l_debug_info := 'Updated inl_ship_line_groups. Number of Rows updated is ' || sql%rowcount;
UPDATE inl_ship_lines_all
SET poa_party_id = decode(poa_party_id,p_from_id,p_to_id,poa_party_id),
poa_party_site_id = decode(poa_party_site_id,p_from_site_id,p_to_site_id,poa_party_site_id),
ship_from_party_id = decode(ship_from_party_id,p_from_id,p_to_id,ship_from_party_id),
ship_from_party_site_id = decode(ship_from_party_site_id,p_from_site_id,p_to_site_id,ship_from_party_site_id),
bill_from_party_id = decode(bill_from_party_id,p_from_id,p_to_id,bill_from_party_id),
bill_from_party_site_id = decode(bill_from_party_site_id,p_from_site_id,p_to_site_id,bill_from_party_site_id),
request_id = fnd_global.conc_request_id,
program_id = fnd_global.conc_program_id,
program_application_id = fnd_global.prog_appl_id,
last_update_date = sysdate,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.login_id
WHERE ship_line_id = l_line_list(j);
l_debug_info := 'Updated inl_ship_lines_all. Number of Rows updated is ' || sql%rowcount;
UPDATE inl_charge_lines
SET ship_from_party_id = decode(ship_from_party_id,p_from_id,p_to_id,ship_from_party_id),
ship_from_party_site_id = decode(nvl(ship_from_party_site_id,-1),-1,null,p_from_site_id,p_to_site_id,ship_from_party_site_id),
bill_from_party_id = decode(bill_from_party_id,p_from_id,p_to_id,bill_from_party_id),
bill_from_party_site_id = decode(nvl(bill_from_party_site_id,-1),-1,null,p_from_site_id,p_to_site_id,bill_from_party_site_id),
poa_party_id = decode(poa_party_id,p_from_id,p_to_id,poa_party_id),
poa_party_site_id = decode(nvl(poa_party_site_id,-1),-1,null,p_from_site_id,p_to_site_id,poa_party_site_id),
party_id = p_to_party_id,
party_site_id = decode(nvl(party_site_id,-1),-1,null,p_from_party_site_id,p_to_party_site_id,party_site_id),
last_update_date = sysdate,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.login_id
WHERE charge_line_id = l_charge_line_list(j);
l_debug_info := 'Updated inl_charges. Number of Rows updated is ' || sql%rowcount;
UPDATE inl_matches
SET party_id = p_to_party_id,
party_site_id = p_to_party_site_id,
request_id = fnd_global.conc_request_id,
program_id = fnd_global.conc_program_id,
program_application_id = fnd_global.prog_appl_id,
last_update_date = sysdate,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.login_id
WHERE match_id = l_match_list(j);
l_debug_info := 'Updated inl_matches. Number of Rows updated is ' || sql%rowcount;
SELECT party_id
FROM po_vendors
WHERE vendor_id = p_vendorId;
SELECT party_site_id
FROM po_vendor_sites_all
WHERE vendor_site_id = p_vendorSiteId;
SELECT charge_line_id
FROM inl_charge_lines cl
WHERE cl.party_id = p_from_fk_id
AND cl.ship_from_party_id is null
AND cl.bill_from_party_id is null
AND cl.poa_party_id is null;
UPDATE inl_charge_lines
SET party_id = p_to_fk_id,
last_update_date = sysdate,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.login_id
WHERE charge_line_id = l_charge_line_list(j);
l_debug_info := 'Updated inl_charges. Number of Rows updated is ' || sql%rowcount;
SELECT charge_line_id
FROM inl_charge_lines cl
WHERE cl.party_site_id = p_from_fk_id
AND cl.ship_from_party_site_id is null
AND cl.bill_from_party_site_id is null
AND cl.poa_party_site_id is null;
UPDATE inl_charge_lines
SET party_site_id = p_to_fk_id,
last_update_date = sysdate,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.login_id
WHERE charge_line_id = l_charge_line_list(j);
l_debug_info := 'Updated inl_charges. Number of Rows updated is ' || sql%rowcount;