[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT B.BATCH_NUMBER, B.BATCH_NAME, A.AGREEMENT_NAME, B.BATCH_CURRENCY, B.BATCH_STATUS_CODE
FROM FUN_NET_BATCHES_ALL B, FUN_NET_AGREEMENTS_ALL A
WHERE B.AGREEMENT_ID = A.AGREEMENT_ID
AND B.BATCH_NAME = nvl(p_batch_name, p_batch_id||'')
AND B.BATCH_ID >= p_batch_id;
select hr.name
into l_org_name
from hr_operating_units hr
where hr.organization_id = p_org_id;
SELECT agreement_name, ALLOW_DISC_FLAG
INTO l_agreement_name, l_allow_disc_flag
FROM FUN_NET_AGREEMENTS_ALL
WHERE AGREEMENT_ID = p_agreement_id;
fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'INSERT INTO FUN_NET_BATCHES_ALL');
INSERT INTO FUN_NET_BATCHES_ALL
(batch_id,
object_version_number,
agreement_id,
batch_name,
batch_number,
review_netting_batch_flag,
batch_status_code,
transaction_due_date,
settlement_date,
response_date,
exchange_rate_type,
exchange_rate,
gl_date,
org_id,
creation_date,
created_by,
last_update_date,
last_updated_by,
last_update_login,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20)
VALUES
(l_batch_id,
1,
p_agreement_id,
nvl(p_batch_name, l_batch_id),
l_batch_id,
p_review_netting_batch_flag,
'CREATED',
l_transaction_due_date,
fnd_date.canonical_to_date(p_settlement_date),
fnd_date.canonical_to_date(p_response_date),
p_exchange_rate_type,
p_exchange_rate,
fnd_date.canonical_to_date(p_gl_date),
p_org_id,
sysdate,
fnd_global.user_id,
sysdate,
fnd_global.user_id,
fnd_global.login_id,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL);