[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT COUNT(conversion_rate) INTO l_has_rate
FROM gl_daily_rates
WHERE from_currency = p_from_currency AND
to_currency = p_to_currency AND
conversion_type = p_exchange_type AND
conversion_date = p_exchange_date;
update_status(p_trx_id);
SELECT status INTO l_status
FROM fun_trx_headers
WHERE trx_id = p_trx_id
FOR UPDATE;
* PROCEDURE update_status
* ----------------------------------------------------
* Returns the new status.
* ---------------------------------------------------*/
PROCEDURE update_status (
p_trx_id IN number)
IS
l_result varchar2(1);
fun_trx_pvt.update_trx_status
(p_api_version => 1.0,
x_return_status => l_result,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_trx_id => p_trx_id,
p_update_status_to => 'COMPLETE');
END update_status;
SELECT h.trx_id,
h.trx_number,
b.batch_number,
b.batch_date,
b.currency_code,
b.exchange_rate_type,
ledgers.currency_code,
ps.closing_status,
b.gl_date,
h.approval_date,
h.ar_invoice_number,
b.from_le_id,
h.to_le_id ,
fun_tca_pkg.get_ou_id(h.initiator_id) from_org_id,
NVL(p_org_id, fun_tca_pkg.get_ou_id(h.recipient_id)) to_org_id,
b.initiator_id,
h.recipient_id
FROM fun_trx_batches b,
fun_trx_headers h,
gl_period_statuses ps,
gl_ledgers ledgers
WHERE b.batch_id = h.batch_id AND
ps.ledger_id = h.to_ledger_id AND
ps.application_id = 200 AND
ledgers.ledger_id = h.to_ledger_id AND
b.gl_date BETWEEN ps.start_date AND ps.end_date AND
b.gl_date BETWEEN nvl(l_date_low, b.gl_date)
AND nvl(l_date_high, b.gl_date) AND
h.to_le_id = NVL(p_le_id, h.to_le_id) AND
NVL(p_org_id, 1) = NVL2(p_org_id,
fun_tca_pkg.get_ou_id(h.recipient_id),1) AND
h.status = 'XFER_AR' AND
h.ar_invoice_number IS NOT NULL
ORDER BY to_org_id; -- Order By added to be able to set
select sysdate into l_init_sysdate from dual;
select hr.name into l_org_name from hr_operating_units hr
where hr.organization_id = p_org_id;
select xle.name into l_le_name from xle_entity_profiles xle
where xle.legal_entity_id = p_le_id;
SELECT trx_id INTO l_trx_id
FROM fun_trx_headers
WHERE trx_id = l_trx_id
FOR UPDATE;
update_status(l_trx_id);
l_parameter_list.delete();
SELECT NVL(d.amount_cr,0), NVL(d.amount_dr,0), d.ccid,
d.dist_type_flag, NVL(t.reci_amount_cr,0), NVL(t.reci_amount_dr,0),
d.dist_id, t.line_type_flag, d.description -- Bug No : 7122846
FROM fun_dist_lines d,
fun_trx_lines t
WHERE t.trx_id = p_trx_id AND
d.line_id = t.line_id AND
d.party_type_flag = 'R';
SELECT site.payment_method_lookup_code
FROM po_vendor_sites_all site
WHERE site.vendor_id = p_vendor_id
AND site.vendor_site_id = p_vendor_site_id;
SELECT zx.application_id,
zx.entity_code,
zx.event_class_code,
zx.trx_id,
zx.trx_line_id,
zx.trx_level_type
FROM zx_lines_det_factors zx,
ra_customer_trx_all artrx
WHERE zx.trx_id = artrx.customer_trx_id
AND zx.application_id = 222
AND zx.entity_code = 'TRANSACTIONS'
AND artrx.trx_number = p_invoice_num
AND artrx.org_id = p_from_org_id
AND artrx.INTERFACE_HEADER_ATTRIBUTE2 = p_trx_id; -- bug no : 7718598
SELECT ap_invoices_interface_s.nextval INTO l_invoice_id
FROM dual;
select description
INTO l_desc_header_level
from fun_trx_headers
where trx_id=p_trx_id;
INSERT INTO ap_invoices_interface (
invoice_id, invoice_num, invoice_date,
vendor_id, vendor_site_id, invoice_amount,
invoice_currency_code, exchange_rate_type, exchange_date,
description,
source, group_id,
goods_received_date, invoice_received_date,
gl_date, accts_pay_code_combination_id, org_id,
payment_method_lookup_code,
payment_method_code,
calc_tax_during_import_flag ,
add_tax_to_inv_amt_flag)
VALUES (
l_invoice_id, p_invoice_num, p_batch_date,
p_vendor_id, p_vendor_site_id, l_amount,
p_currency, p_conv_type, p_batch_date,
l_desc_header_level, -- Bug No : 7652608
p_source, p_trx_id,
p_batch_date, Nvl(p_approval_date, TRUNC(SYSDATE)),
p_gl_date, l_ccid, p_org_id,
l_payment_method_lookup_code,
l_payment_method_lookup_code,
'Y',
'Y');
SELECT ap_invoice_lines_interface_s.nextval into l_inv_line_id
FROM dual;
INSERT INTO ap_invoice_lines_interface (
invoice_id, invoice_line_id, line_number,
line_type_lookup_code, amount, accounting_date,
description, dist_code_combination_id, org_id,
source_application_id,
source_entity_code,
source_event_class_code,
source_trx_id,
source_trx_level_type,
source_line_id )
VALUES (
l_invoice_id, l_inv_line_id, l_dist_id,
'ITEM', l_amount, p_gl_date,
l_desc, l_ccid, p_org_id,
l_application_id, -- added for etax changes
l_entity_code, -- added for etax changes
'INTERCOMPANY_TRX', -- added for etax changes
l_trx_id, -- added for etax changes
'LINE' , -- added for etax changes
l_trx_line_id);
l_parameter_list.delete();