[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT USER_CONVERSION_TYPE
INTO l_user_conversion_type
from GL_DAILY_CONVERSION_TYPES
where conversion_type = p_conversion_type;
SELECT status, description, batch_id
INTO l_status, l_desc, l_batch_id
FROM fun_trx_headers
WHERE trx_id = p_trx_id;
select batch_number
INTO l_batch_number
from fun_trx_batches
Where batch_id = l_batch_id;
l_status := update_status(p_trx_id, l_status, p_party_type);
SELECT status INTO l_status
FROM fun_trx_headers
WHERE trx_id = p_trx_id
FOR UPDATE;
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;
/*SELECT ps.closing_status
INTO l_status
FROM gl_periods p,
gl_ledgers l,
gl_period_statuses ps
WHERE l.ledger_id = p_ledger_id AND
p.period_set_name = l.period_set_name AND
p_date BETWEEN p.start_date AND p.end_date AND
ps.period_name = p.period_name AND
ps.application_id = p_app_id AND
ps.set_of_books_id = l.ledger_id;*/
SELECT ps.closing_status
INTO l_status
FROM gl_period_statuses ps
WHERE ps.ledger_id = p_ledger_id AND
p_date BETWEEN ps.start_date AND ps.end_date AND
ps.application_id = p_app_id AND
ps.adjustment_period_flag = 'N';
* FUNCTION update_status
* ----------------------------------------------------
* Returns the new status.
* ---------------------------------------------------*/
FUNCTION update_status (
p_trx_id IN number,
p_status IN varchar2,
p_party_type IN varchar2) RETURN varchar2
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 => 'XFER_RECI_GL');
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 => 'XFER_INI_GL');
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');
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 d.amount_cr, d.amount_dr, d.ccid,
d.created_by, d.line_id, d.description,
h.batch_id,
h.trx_id,
d.dist_id
FROM fun_dist_lines d,
fun_trx_lines t,
fun_trx_headers h
WHERE t.trx_id = p_trx_id AND
d.line_id = t.line_id AND
h.trx_id = t.trx_id AND
d.party_type_flag = p_party_type;
select sysdate into l_initdate from dual;
select user_je_source_name into l_trans_source from gl_je_sources_tl where
je_source_name = p_source and language = USERENV('LANG');
select user_je_category_name into l_trans_category from gl_je_categories_tl where
je_category_name = p_category and language = USERENV('LANG');
INSERT INTO gl_interface
(status, set_of_books_id, accounting_date,
currency_code, date_created, created_by,
actual_flag, user_je_category_name, user_je_source_name,
currency_conversion_date, user_currency_conversion_type, entered_dr,
entered_cr, reference10,reference4,
code_combination_id, group_id,ledger_id,
reference21, reference22, reference23, reference24, reference25)
VALUES
('NEW', p_ledger_id, p_gl_date,
p_currency, SYSDATE, l_created_by,
'A', l_trans_category, l_trans_source,
p_conv_date, FUN_GL_TRANSFER.GET_CONVERSION_TYPE(p_conv_type), l_amount_dr,
l_amount_cr, nvl(l_desc,p_desc),p_batch_number,
l_ccid, p_ledger_id ,p_ledger_id,
'Intercompany Transaction',
l_batch_id,
l_trx_id,
l_line_id,
l_dist_id
);
l_parameter_list.delete();