[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT attribute_value
FROM jai_rgm_org_regns_v
WHERE regime_id = pn_regime_id
AND organization_id = pn_organization_id
AND organization_type = pv_organization_type
AND registration_type = jai_constants.regn_type_others
AND attribute_Type_code = 'PRIMARY';
SELECT org_information3
FROM hr_organization_information
WHERE upper(ORG_INFORMATION_CONTEXT) = 'ACCOUNTING INFORMATION'
AND organization_id = cpn_organization_id;
SELECT interorg_payables_account,
interorg_receivables_account
FROM mtl_parameters_view
WHERE organization_id = cpn_organization_id;
lv_codepath := jai_general_pkg.plot_codepath(1, lv_codepath, 'Insert_Repository_Entry', 'START');
INSERT INTO jai_rgm_trx_records (
repository_id,
regime_code,
tax_type,
source,
source_document_id,
source_table_name,
transaction_date,
debit_amount,
credit_amount,
settled_amount,
settled_flag,
settlement_id,
organization_type,
organization_id,
location_id,
account_name,
charge_account_id,
balancing_account_id,
reference_id,
source_trx_type,
tax_rate,
assessable_value,
batch_id,
trx_currency,
curr_conv_date,
curr_conv_rate,
trx_credit_amount,
trx_debit_amount,
creation_date,
created_by,
last_update_date,
last_updated_by,
last_update_login,
attribute_context,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
inv_organization_id,
regime_primary_regno,
service_type_code
)
VALUES
(
jai_rgm_trx_records_s.nextval, /* repository_id, */
lv_regime_code, /* regime_code, */
pv_tax_type, /* tax_type, */
pv_source, /* source, */
pn_source_document_id, /* source_document_id, */
pv_source_table_name, /* source_table_name, */
pd_transaction_date, /* transaction_date, */
ln_debit, /* debit_amount, */
ln_credit, /* credit_amount, */
null, /* settled_amount, */
null, /* settled_flag, */
pn_settlement_id, /* settlement_id, */
pv_organization_type, /* organization_type, */
pn_organization_id, /* organization_id, */
pn_location_id, /* location_id, */
pv_account_name, /* account_name, */
ln_charge_account_id, /* charge_account_id, */
ln_balancing_account_id, /* balancing_account_id, */
pn_reference_id, /* reference_id, */
pv_source_trx_type, /* source_trx_type, */
pn_tax_rate, /* tax_rate, */
pn_assessable_value, /* assessable_value, */
pn_batch_id, /* batch_id, */
pv_currency_code, /* trx_currency, */
pd_curr_conv_date, /* curr_conv_date, */
pn_curr_conv_rate, /* curr_conv_rate, */
ln_trx_credit, /* trx_credit_amount, */
ln_trx_debit, /* trx_debit_amount, */
sysdate, /* creation_date, */
FND_GLOBAL.user_id, /* created_by, */
sysdate, /* last_update_date, */
FND_GLOBAL.user_id, /* last_updated_by, */
FND_GLOBAL.login_id, /* last_update_login, */
pv_trx_reference_context,
pv_trx_reference1,
pv_trx_reference2,
pv_trx_reference3,
pv_trx_reference4,
pv_trx_reference5,
pn_inv_organization_id, /* inv_organization_id, */
lv_primary_regime_regno, /* regime_primary_regno, */
pv_service_type_code /* service_type_code */
) RETURNING repository_id INTO pn_repository_id;
select currency_Code
from gl_Sets_of_books
where set_of_books_id = cpn_Set_of_books_id;
For set_rec IN (SELECT set_of_books_id, organization_code
FROM org_organization_definitions
WHERE organization_id = pn_organization_id)
LOOP
ln_set_of_books_id := set_rec.set_of_books_id;
INSERT into gl_interface
(status,
set_of_books_id,
user_je_source_name,
user_je_category_name,
accounting_date,
currency_code,
date_created,
created_by,
actual_flag,
entered_cr,
entered_dr,
transaction_date,
code_combination_id,
currency_conversion_date,
user_currency_conversion_type,
currency_conversion_rate,
reference1,
reference10,
reference22,
reference23,
reference24,
reference25,
reference26,
reference27
)
VALUES ('NEW',
ln_set_of_books_id,
pv_je_source_name,
pv_je_category_name,
ld_accounting_date,
lv_currency_code ,
ld_creation_date,
ln_created_by,
'A',
pn_credit_amount,
pn_debit_amount,
sysdate,
pn_cc_id,
pd_currency_conversion_date,
pv_currency_conversion_type,
pn_currency_conversion_rate,
lv_organization_code, /* p_reference_1 */
lv_reference_10,
lv_reference_entry, /* p_reference_22 */
lv_reference_23,
lv_reference_24,
lv_reference_25,
lv_reference_26,
to_char(pn_organization_id) /* p_reference_27 */
);