eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_CMN_RGM_RECORDING_PKG dependencies on JAI_RGM_TRX_RECORDS

Line 59: A new column has been added into the table jai_Rgm_trx_Records called regime_primary_regno and it has been

55:
56:
57: 3. Bug# 4204880 - ssumaith - 20-feb-2005 - File version 115.2
58:
59: A new column has been added into the table jai_Rgm_trx_Records called regime_primary_regno and it has been
60: included in the insert column list in the table jai_Rgm_trx_Records
61: A cursor has been added to fetch the primary registration number.
62:
63: Dependency :-

Line 60: included in the insert column list in the table jai_Rgm_trx_Records

56:
57: 3. Bug# 4204880 - ssumaith - 20-feb-2005 - File version 115.2
58:
59: A new column has been added into the table jai_Rgm_trx_Records called regime_primary_regno and it has been
60: included in the insert column list in the table jai_Rgm_trx_Records
61: A cursor has been added to fetch the primary registration number.
62:
63: Dependency :-
64: High . A new column has been added into the jai_rgm_trx_records table which also needs data to be populated

Line 64: High . A new column has been added into the jai_rgm_trx_records table which also needs data to be populated

60: included in the insert column list in the table jai_Rgm_trx_Records
61: A cursor has been added to fetch the primary registration number.
62:
63: Dependency :-
64: High . A new column has been added into the jai_rgm_trx_records table which also needs data to be populated
65: If this file is sent alone , it will cause a dependency issue.
66: Need to ensure that the new column needs to be part of the table.
67:
68:

Line 132: jai_rgm_trx_records.

128: 13. 05-Feb-2009 CSahoo for bug#9350172
129: ISSUE: FPBUG:CAN NOT ADD TAXES SUCCESSFULLY IN ENTER TXN INDIA LOCALIZATION FORM
130: FIX: Added an input parameter pn_settlement_id to the procedure insert_vat_repository_entry
131: This parameter pn_settlement_id is used to populate the settlement_id in the table
132: jai_rgm_trx_records.
133:
134: 14. 4-Apr-2010 Bo Li for Bug9305067
135: Modify the procedure insert_repository_entry and insert_vat_repository_entry.
136: Replace the attribute parameters with new meaningful parameters

Line 179: This is used to insert into jai_rgm_trx_records.

175: 12 25-April-2007 ssawant for bug 5879769 ,File version 120.6
176: Forward porting of
177: ENH : SERVICE TAX BY INVENTORY ORGANIZATION AND SERVICE TYPE SOLUTION from 11.5( bug no 5694855) to R12 (bug no 5879769).
178: Fix : A new parameter p_service_type_code is added to insert_repository procedure.
179: This is used to insert into jai_rgm_trx_records.
180: A new column repository_id is added to jai_sla_entries and so the insert statement
181: is modified to insert the repository id
182: The procedure get_account is modified to return the account if the regime is SERVICE, Org Type is IO and the
183: tax is not of EXCISE or EXCISE CESS types

Line 296: jai_rgm_trx_records.trx_credit_amount has to hit with the -ve distribution

292: Issue:
293: Service tax distribution out is updating the repost
294: Fix :
295: For Distribute_out transaction type
296: jai_rgm_trx_records.trx_credit_amount has to hit with the -ve distribution
297:
298: changes are done in insert_repository_entry procedure for "SERVICE_dISTRIBUTE_OUT" transaction.
299:
300: ----------------------------------------------------------------------------------------------------------------------------*/

Line 367: lv_account_name JAI_RGM_TRX_RECORDS.account_name%TYPE;

363: ln_trx_credit NUMBER;
364: ln_trx_debit NUMBER;
365:
366: lv_register_entry_type VARCHAR2(2);
367: lv_account_name JAI_RGM_TRX_RECORDS.account_name%TYPE;
368: ln_charge_account_id JAI_RGM_TRX_RECORDS.charge_account_id%TYPE;
369: lv_charge_entry_type VARCHAR2(2);
370: lv_period_name GL_PERIODS.period_name%TYPE;
371:

Line 368: ln_charge_account_id JAI_RGM_TRX_RECORDS.charge_account_id%TYPE;

364: ln_trx_debit NUMBER;
365:
366: lv_register_entry_type VARCHAR2(2);
367: lv_account_name JAI_RGM_TRX_RECORDS.account_name%TYPE;
368: ln_charge_account_id JAI_RGM_TRX_RECORDS.charge_account_id%TYPE;
369: lv_charge_entry_type VARCHAR2(2);
370: lv_period_name GL_PERIODS.period_name%TYPE;
371:
372: lv_balancing_tax_type JAI_RGM_TRX_RECORDS.tax_type%TYPE;

Line 372: lv_balancing_tax_type JAI_RGM_TRX_RECORDS.tax_type%TYPE;

368: ln_charge_account_id JAI_RGM_TRX_RECORDS.charge_account_id%TYPE;
369: lv_charge_entry_type VARCHAR2(2);
370: lv_period_name GL_PERIODS.period_name%TYPE;
371:
372: lv_balancing_tax_type JAI_RGM_TRX_RECORDS.tax_type%TYPE;
373: lv_balancing_orgn_type JAI_RGM_TRX_RECORDS.organization_type%TYPE;
374: ln_balancing_orgn_id JAI_RGM_TRX_RECORDS.organization_id%TYPE;
375: ln_balancing_location_id JAI_RGM_TRX_RECORDS.location_id%TYPE;
376: lv_balancing_accnt_name JAI_RGM_TRX_RECORDS.account_name%TYPE;

Line 373: lv_balancing_orgn_type JAI_RGM_TRX_RECORDS.organization_type%TYPE;

369: lv_charge_entry_type VARCHAR2(2);
370: lv_period_name GL_PERIODS.period_name%TYPE;
371:
372: lv_balancing_tax_type JAI_RGM_TRX_RECORDS.tax_type%TYPE;
373: lv_balancing_orgn_type JAI_RGM_TRX_RECORDS.organization_type%TYPE;
374: ln_balancing_orgn_id JAI_RGM_TRX_RECORDS.organization_id%TYPE;
375: ln_balancing_location_id JAI_RGM_TRX_RECORDS.location_id%TYPE;
376: lv_balancing_accnt_name JAI_RGM_TRX_RECORDS.account_name%TYPE;
377: ln_balancing_account_id JAI_RGM_TRX_RECORDS.charge_account_id%TYPE;

Line 374: ln_balancing_orgn_id JAI_RGM_TRX_RECORDS.organization_id%TYPE;

370: lv_period_name GL_PERIODS.period_name%TYPE;
371:
372: lv_balancing_tax_type JAI_RGM_TRX_RECORDS.tax_type%TYPE;
373: lv_balancing_orgn_type JAI_RGM_TRX_RECORDS.organization_type%TYPE;
374: ln_balancing_orgn_id JAI_RGM_TRX_RECORDS.organization_id%TYPE;
375: ln_balancing_location_id JAI_RGM_TRX_RECORDS.location_id%TYPE;
376: lv_balancing_accnt_name JAI_RGM_TRX_RECORDS.account_name%TYPE;
377: ln_balancing_account_id JAI_RGM_TRX_RECORDS.charge_account_id%TYPE;
378: lv_balancing_entry_type VARCHAR2(2);

Line 375: ln_balancing_location_id JAI_RGM_TRX_RECORDS.location_id%TYPE;

371:
372: lv_balancing_tax_type JAI_RGM_TRX_RECORDS.tax_type%TYPE;
373: lv_balancing_orgn_type JAI_RGM_TRX_RECORDS.organization_type%TYPE;
374: ln_balancing_orgn_id JAI_RGM_TRX_RECORDS.organization_id%TYPE;
375: ln_balancing_location_id JAI_RGM_TRX_RECORDS.location_id%TYPE;
376: lv_balancing_accnt_name JAI_RGM_TRX_RECORDS.account_name%TYPE;
377: ln_balancing_account_id JAI_RGM_TRX_RECORDS.charge_account_id%TYPE;
378: lv_balancing_entry_type VARCHAR2(2);
379: lv_bal_entry_period_name GL_PERIODS.period_name%TYPE;

Line 376: lv_balancing_accnt_name JAI_RGM_TRX_RECORDS.account_name%TYPE;

372: lv_balancing_tax_type JAI_RGM_TRX_RECORDS.tax_type%TYPE;
373: lv_balancing_orgn_type JAI_RGM_TRX_RECORDS.organization_type%TYPE;
374: ln_balancing_orgn_id JAI_RGM_TRX_RECORDS.organization_id%TYPE;
375: ln_balancing_location_id JAI_RGM_TRX_RECORDS.location_id%TYPE;
376: lv_balancing_accnt_name JAI_RGM_TRX_RECORDS.account_name%TYPE;
377: ln_balancing_account_id JAI_RGM_TRX_RECORDS.charge_account_id%TYPE;
378: lv_balancing_entry_type VARCHAR2(2);
379: lv_bal_entry_period_name GL_PERIODS.period_name%TYPE;
380:

Line 377: ln_balancing_account_id JAI_RGM_TRX_RECORDS.charge_account_id%TYPE;

373: lv_balancing_orgn_type JAI_RGM_TRX_RECORDS.organization_type%TYPE;
374: ln_balancing_orgn_id JAI_RGM_TRX_RECORDS.organization_id%TYPE;
375: ln_balancing_location_id JAI_RGM_TRX_RECORDS.location_id%TYPE;
376: lv_balancing_accnt_name JAI_RGM_TRX_RECORDS.account_name%TYPE;
377: ln_balancing_account_id JAI_RGM_TRX_RECORDS.charge_account_id%TYPE;
378: lv_balancing_entry_type VARCHAR2(2);
379: lv_bal_entry_period_name GL_PERIODS.period_name%TYPE;
380:
381: ln_trx_tax_amount NUMBER;

Line 402: It will be inserted into jai_Rgm_trx_records table.

398: ln_unearned_disc_accnt NUMBER;
399:
400: /*
401: Following cursor added by ssumaith for fetching the primary registration number of the regime
402: It will be inserted into jai_Rgm_trx_records table.
403: Bug# 4204880
404: */
405:
406: CURSOR c_primary_regno( p_att_type_code jai_rgm_registrations.attribute_Type_code%TYPE ) IS --rchandan for bug#4428980

Line 813: Added the column regime_primary_regno in the insert column list of the table jai_rgm_trx_records table.

809: lv_statement := '10';
810:
811: /*
812: Following cursor added by ssumaith to get the primary registration number - bug# 4204880
813: Added the column regime_primary_regno in the insert column list of the table jai_rgm_trx_records table.
814: */
815: OPEN c_primary_regno('PRIMARY'); --rchandan for bug#4428980
816: FETCH c_primary_regno into lv_primary_regime_regno;
817: CLOSE c_primary_regno;

Line 820: INSERT INTO jai_rgm_trx_records(

816: FETCH c_primary_regno into lv_primary_regime_regno;
817: CLOSE c_primary_regno;
818:
819: lv_codepath := jai_general_pkg.plot_codepath(15, lv_codepath);
820: INSERT INTO jai_rgm_trx_records(
821: repository_id, regime_code, tax_type, source,
822: source_document_id, source_table_name, transaction_date, debit_amount, credit_amount,
823: settled_amount, settled_flag, settlement_id, organization_type,
824: organization_id, location_id, account_name, charge_account_id, balancing_account_id,

Line 832: jai_rgm_trx_records_s.nextval, lv_regime_code, p_tax_type, p_source,

828: trx_reference_context, trx_reference1, trx_reference2, trx_reference3, trx_reference4, trx_reference5
829: , inv_organization_id, regime_primary_regno ,service_type_code /* added by ssawant for bug 5879769 */
830: , invoice_no --Add by Qiong for Advanced Receipts
831: ) VALUES (
832: jai_rgm_trx_records_s.nextval, lv_regime_code, p_tax_type, p_source,
833: p_source_document_id, p_source_table_name, ld_transaction_date, ln_debit, ln_credit,
834: null, null, p_settlement_id, p_organization_type,
835: p_organization_id, p_location_id, lv_account_name,--Modified by Xiao from p_account_name for POT change, reg bug#12533434
836: ln_charge_account_id, ln_balancing_account_id,

Line 1272: from jai_rgm_trx_records

1268:
1269: Cursor c_get_source(cp_repository_id NUMBER)
1270: IS
1271: select source
1272: from jai_rgm_trx_records
1273: where repository_id = cp_repository_id ;
1274:
1275: --Add by Xiao for bug#12598609, begin
1276:

Line 1310: lv_source jai_rgm_trx_records.source%TYPE ;

1306: ln_cash_receipt_id NUMBER;
1307: ln_customer_trx_id NUMBER;
1308: --Added by Wenqiong end
1309:
1310: lv_source jai_rgm_trx_records.source%TYPE ;
1311: lv_src_party_id jai_rgm_dis_src_hdrs.party_id%TYPE ;
1312: lv_reference1 gl_interface.reference1%TYPE ;
1313: ln_loop_cnt NUMBER;
1314:

Line 2147: lv_primary_regime_regno jai_rgm_trx_records.regime_primary_regno%TYPE;

2143: AND attribute_type_code = p_att_type_code;
2144:
2145: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%TYPE;
2146: ld_transaction_date DATE;
2147: lv_primary_regime_regno jai_rgm_trx_records.regime_primary_regno%TYPE;
2148:
2149: lv_statement_id VARCHAR2(3);
2150: BEGIN
2151:

Line 2175: INSERT INTO jai_rgm_trx_records(

2171: pn_credit_amount := round( pn_credit_amount, jai_constants.vat_rgm_rnd_factor);
2172: pn_debit_amount := round( pn_debit_amount, jai_constants.vat_rgm_rnd_factor);
2173:
2174: lv_statement_id := '5';
2175: INSERT INTO jai_rgm_trx_records(
2176: repository_id, regime_code, tax_type, source,
2177: source_document_id, source_table_name, transaction_date, debit_amount, credit_amount,
2178: settled_amount, settled_flag, settlement_id, organization_type,
2179: organization_id, location_id, account_name, charge_account_id, balancing_account_id,

Line 2186: jai_rgm_trx_records_s.nextval, lv_regime_code, pv_tax_type, pv_source,

2182: creation_date, created_by, last_update_date, last_updated_by, last_update_login,
2183: trx_reference_context, trx_reference1, trx_reference2, trx_reference3, trx_reference4, trx_reference5
2184: , inv_organization_id, regime_primary_regno, invoice_no, invoice_date
2185: ) VALUES (
2186: jai_rgm_trx_records_s.nextval, lv_regime_code, pv_tax_type, pv_source,
2187: pn_source_id, pv_source_table_name, ld_transaction_date, pn_debit_amount, pn_credit_amount,
2188: null, null, pn_settlement_id, pv_organization_type, --added pn_settlement_id for bug#9350172
2189: pn_organization_id, pn_location_id, pv_account_name, pn_charge_account_id, pn_balancing_account_id,
2190: pn_reference_id, pv_source_trx_type, pn_tax_rate, pn_assessable_value, pn_batch_id,

Line 2248: lv_source JAI_RGM_TRX_RECORDS.source%TYPE;

2244: ln_accounted_debit NUMBER;
2245: ld_accounting_date DATE;
2246: ld_transaction_date DATE;
2247:
2248: lv_source JAI_RGM_TRX_RECORDS.source%TYPE;
2249: lv_source_trx_type JAI_RGM_TRX_RECORDS.source_trx_type%TYPE;
2250: lv_source_table_name JAI_RGM_TRX_RECORDS.source_table_name%TYPE;
2251: ln_source_id JAI_RGM_TRX_RECORDS.source_document_id%TYPE;
2252: ln_repository_id JAI_RGM_TRX_RECORDS.repository_id%TYPE;

Line 2249: lv_source_trx_type JAI_RGM_TRX_RECORDS.source_trx_type%TYPE;

2245: ld_accounting_date DATE;
2246: ld_transaction_date DATE;
2247:
2248: lv_source JAI_RGM_TRX_RECORDS.source%TYPE;
2249: lv_source_trx_type JAI_RGM_TRX_RECORDS.source_trx_type%TYPE;
2250: lv_source_table_name JAI_RGM_TRX_RECORDS.source_table_name%TYPE;
2251: ln_source_id JAI_RGM_TRX_RECORDS.source_document_id%TYPE;
2252: ln_repository_id JAI_RGM_TRX_RECORDS.repository_id%TYPE;
2253: lv_repository_name VARCHAR2(30);

Line 2250: lv_source_table_name JAI_RGM_TRX_RECORDS.source_table_name%TYPE;

2246: ld_transaction_date DATE;
2247:
2248: lv_source JAI_RGM_TRX_RECORDS.source%TYPE;
2249: lv_source_trx_type JAI_RGM_TRX_RECORDS.source_trx_type%TYPE;
2250: lv_source_table_name JAI_RGM_TRX_RECORDS.source_table_name%TYPE;
2251: ln_source_id JAI_RGM_TRX_RECORDS.source_document_id%TYPE;
2252: ln_repository_id JAI_RGM_TRX_RECORDS.repository_id%TYPE;
2253: lv_repository_name VARCHAR2(30);
2254:

Line 2251: ln_source_id JAI_RGM_TRX_RECORDS.source_document_id%TYPE;

2247:
2248: lv_source JAI_RGM_TRX_RECORDS.source%TYPE;
2249: lv_source_trx_type JAI_RGM_TRX_RECORDS.source_trx_type%TYPE;
2250: lv_source_table_name JAI_RGM_TRX_RECORDS.source_table_name%TYPE;
2251: ln_source_id JAI_RGM_TRX_RECORDS.source_document_id%TYPE;
2252: ln_repository_id JAI_RGM_TRX_RECORDS.repository_id%TYPE;
2253: lv_repository_name VARCHAR2(30);
2254:
2255: lv_statement_id VARCHAR2(3);

Line 2252: ln_repository_id JAI_RGM_TRX_RECORDS.repository_id%TYPE;

2248: lv_source JAI_RGM_TRX_RECORDS.source%TYPE;
2249: lv_source_trx_type JAI_RGM_TRX_RECORDS.source_trx_type%TYPE;
2250: lv_source_table_name JAI_RGM_TRX_RECORDS.source_table_name%TYPE;
2251: ln_source_id JAI_RGM_TRX_RECORDS.source_document_id%TYPE;
2252: ln_repository_id JAI_RGM_TRX_RECORDS.repository_id%TYPE;
2253: lv_repository_name VARCHAR2(30);
2254:
2255: lv_statement_id VARCHAR2(3);
2256:

Line 2532: lv_balancing_accnt_name JAI_RGM_TRX_RECORDS.account_name%TYPE;

2528: lv_regime_code VARCHAR2(10);
2529: ln_org_id NUMBER;
2530: ln_bal_org_id NUMBER;
2531: lv_codepath VARCHAR2(500) := '';
2532: lv_balancing_accnt_name JAI_RGM_TRX_RECORDS.account_name%TYPE;
2533: lv_charge_entry_type VARCHAR2(2);
2534: lv_balancing_entry_type VARCHAR2(2);
2535: ln_charge_account_id NUMBER;
2536: