85: ln_trx_credit NUMBER;
86: ln_trx_debit NUMBER;
87:
88: lv_register_entry_type VARCHAR2(2);
89: lv_account_name JAI_RGM_TRX_RECORDS.account_name%TYPE;
90:
91: ln_charge_account_id JAI_RGM_TRX_RECORDS.charge_account_id%TYPE;
92: ln_balancing_account_id JAI_RGM_TRX_RECORDS.charge_account_id%TYPE;
93: lv_primary_regime_regno JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
87:
88: lv_register_entry_type VARCHAR2(2);
89: lv_account_name JAI_RGM_TRX_RECORDS.account_name%TYPE;
90:
91: ln_charge_account_id JAI_RGM_TRX_RECORDS.charge_account_id%TYPE;
92: ln_balancing_account_id JAI_RGM_TRX_RECORDS.charge_account_id%TYPE;
93: lv_primary_regime_regno JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
94:
95: lv_balancing_tax_type JAI_RGM_TRX_RECORDS.tax_type%TYPE;
88: lv_register_entry_type VARCHAR2(2);
89: lv_account_name JAI_RGM_TRX_RECORDS.account_name%TYPE;
90:
91: ln_charge_account_id JAI_RGM_TRX_RECORDS.charge_account_id%TYPE;
92: ln_balancing_account_id JAI_RGM_TRX_RECORDS.charge_account_id%TYPE;
93: lv_primary_regime_regno JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
94:
95: lv_balancing_tax_type JAI_RGM_TRX_RECORDS.tax_type%TYPE;
96: lv_balancing_orgn_type JAI_RGM_TRX_RECORDS.organization_type%TYPE;
91: ln_charge_account_id JAI_RGM_TRX_RECORDS.charge_account_id%TYPE;
92: ln_balancing_account_id JAI_RGM_TRX_RECORDS.charge_account_id%TYPE;
93: lv_primary_regime_regno JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
94:
95: lv_balancing_tax_type JAI_RGM_TRX_RECORDS.tax_type%TYPE;
96: lv_balancing_orgn_type JAI_RGM_TRX_RECORDS.organization_type%TYPE;
97: ln_balancing_orgn_id JAI_RGM_TRX_RECORDS.organization_id%TYPE;
98: ln_balancing_location_id JAI_RGM_TRX_RECORDS.location_id%TYPE;
99: lv_balancing_accnt_name JAI_RGM_TRX_RECORDS.account_name%TYPE;
92: ln_balancing_account_id JAI_RGM_TRX_RECORDS.charge_account_id%TYPE;
93: lv_primary_regime_regno JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
94:
95: lv_balancing_tax_type JAI_RGM_TRX_RECORDS.tax_type%TYPE;
96: lv_balancing_orgn_type JAI_RGM_TRX_RECORDS.organization_type%TYPE;
97: ln_balancing_orgn_id JAI_RGM_TRX_RECORDS.organization_id%TYPE;
98: ln_balancing_location_id JAI_RGM_TRX_RECORDS.location_id%TYPE;
99: lv_balancing_accnt_name JAI_RGM_TRX_RECORDS.account_name%TYPE;
100:
93: lv_primary_regime_regno JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
94:
95: lv_balancing_tax_type JAI_RGM_TRX_RECORDS.tax_type%TYPE;
96: lv_balancing_orgn_type JAI_RGM_TRX_RECORDS.organization_type%TYPE;
97: ln_balancing_orgn_id JAI_RGM_TRX_RECORDS.organization_id%TYPE;
98: ln_balancing_location_id JAI_RGM_TRX_RECORDS.location_id%TYPE;
99: lv_balancing_accnt_name JAI_RGM_TRX_RECORDS.account_name%TYPE;
100:
101:
94:
95: lv_balancing_tax_type JAI_RGM_TRX_RECORDS.tax_type%TYPE;
96: lv_balancing_orgn_type JAI_RGM_TRX_RECORDS.organization_type%TYPE;
97: ln_balancing_orgn_id JAI_RGM_TRX_RECORDS.organization_id%TYPE;
98: ln_balancing_location_id JAI_RGM_TRX_RECORDS.location_id%TYPE;
99: lv_balancing_accnt_name JAI_RGM_TRX_RECORDS.account_name%TYPE;
100:
101:
102: /*
95: lv_balancing_tax_type JAI_RGM_TRX_RECORDS.tax_type%TYPE;
96: lv_balancing_orgn_type JAI_RGM_TRX_RECORDS.organization_type%TYPE;
97: ln_balancing_orgn_id JAI_RGM_TRX_RECORDS.organization_id%TYPE;
98: ln_balancing_location_id JAI_RGM_TRX_RECORDS.location_id%TYPE;
99: lv_balancing_accnt_name JAI_RGM_TRX_RECORDS.account_name%TYPE;
100:
101:
102: /*
103: Cursor to fetch the primary registration number
325: FETCH cur_primary_regno into lv_primary_regime_regno;
326: CLOSE cur_primary_regno;
327:
328: lv_codepath := jai_general_pkg.plot_codepath(15, lv_codepath);
329: INSERT INTO jai_rgm_trx_records (
330: repository_id,
331: regime_code,
332: tax_type,
333: source,
371: service_type_code
372: )
373: VALUES
374: (
375: jai_rgm_trx_records_s.nextval, /* repository_id, */
376: lv_regime_code, /* regime_code, */
377: pv_tax_type, /* tax_type, */
378: pv_source, /* source, */
379: pn_source_document_id, /* source_document_id, */