The following lines contain the word 'select', 'insert', 'update' or 'delete':
DELETE FROM fv_third_party_temp;
g_message := ' Inserting a record in Fv_Third_Party_Temp ...';
INSERT INTO fv_third_party_temp
(original_supplier_name,
original_supplier_site,
third_party_agent,
third_party_site,
check_number,
check_date,
check_amount,
invoice_number,
invoice_amount,
discount_amount,
org_id,
set_of_books_id)
VALUES
(p_from_supp_name,
p_from_supp_site,
p_to_supp_name,
p_to_supp_site,
p_check_number,
p_check_date,
p_check_amount,
p_invoice_number,
p_invoice_amount,
p_discount_amount,
g_org_id,
g_sob_id);
' -- Error in Populate_Third_Party_Temp Procedure when inserting record into fv_third_party_temp table';
SELECT vendor_name
INTO l_vendor_name
FROM po_vendors
WHERE vendor_id = p_vendor_id;
SELECT vendor_site_code
INTO l_vendor_site_code
FROM po_vendor_sites
WHERE vendor_site_id = p_vendor_site_id;
l_row_select VARCHAR2(3000);
l_bank_account_id Ap_Invoice_Selection_Criteria.bank_account_id%TYPE;
SELECT apc.check_number, apc.check_date, apc.amount,
invoice_num, invoice_amount, discount_amount_taken
FROM ap_checks apc, ap_invoice_payments apip, ap_invoices api
WHERE apc.bank_account_id = l_bank_account_id
AND apc.checkrun_name = l_checkrun_name
AND apc.check_number = l_check_num_fvtpp
AND apc.vendor_id = l_third_party_agent_id
AND apc.vendor_site_id = l_third_party_site_id
AND apc.check_id = apip.check_id
AND apip.set_of_books_id = g_sob_id
AND apip.invoice_id = api.invoice_id
AND api.vendor_id = l_original_supplier_id
AND api.vendor_site_id = l_original_site_id
AND api.set_of_books_id = g_sob_id
AND status_lookup_code IN ('CLEARED', 'CLEARED BUT UNACCOUNTED', 'ISSUED',
'NEGOTIABLE', 'RECONCILED', 'RECONCILED UNACCOUNTED');
l_row_select := '
SELECT fvcd.assignment_id, tpp.original_supplier_id, tpp.original_supplier_site_id,
tpp.third_party_agent_id, tpp.third_party_site_id, fvcd.checkrun_name, fvcd.check_number
FROM fv_tpp_check_details fvcd, fv_tpp_assignments_all tpp, ap_invoice_selection_criteria apisc
WHERE '|| l_where_clause ||'
fvcd.checkrun_name = apisc.checkrun_name
AND apisc.status = '||''''|| 'CONFIRMED' ||''''||'
AND fvcd.set_of_books_id = '|| g_sob_id ||'
AND tpp.set_of_books_id = '|| g_sob_id ||'
AND tpp.org_id = '|| g_org_id ||'
AND fvcd.assignment_id = tpp.assignment_id';
g_message := l_row_select;
DBMS_SQL.PARSE(l_row_cursor, l_row_select, DBMS_SQL.V7);
SELECT bank_account_id
INTO l_bank_account_id
FROM ap_invoice_selection_criteria
WHERE checkrun_name = l_checkrun_name;
-- Select the Original and Third Party info
-- if not specified as SRS parameters
IF (l <> 0) AND (j <> 0)
THEN
FOR i IN l .. j
LOOP
BEGIN
SELECT pv.vendor_name, ps.vendor_site_code
INTO l_vendor_name, l_site_code
FROM po_vendors pv, po_vendor_sites ps,
fv_tpp_assignments_all fv
WHERE fv.assignment_id = l_assignment_id
AND fv.set_of_books_id = g_sob_id
AND fv.org_id = g_org_id
AND pv.vendor_id = DECODE(i, 1, fv.original_supplier_id,
2, fv.third_party_agent_id)
AND ps.vendor_site_id = DECODE(i, 1, fv.original_supplier_site_id,
2, fv.third_party_site_id);