DBA Data[Home] [Help]

APPS.JAI_RGM_GST_ACCOUNTING_PKG dependencies on JAI_RGM_TRX_RECORDS

Line 89: lv_account_name JAI_RGM_TRX_RECORDS.account_name%TYPE;

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;

Line 91: ln_charge_account_id JAI_RGM_TRX_RECORDS.charge_account_id%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;

Line 92: ln_balancing_account_id JAI_RGM_TRX_RECORDS.charge_account_id%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;

Line 95: lv_balancing_tax_type JAI_RGM_TRX_RECORDS.tax_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;

Line 96: lv_balancing_orgn_type JAI_RGM_TRX_RECORDS.organization_type%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:

Line 97: ln_balancing_orgn_id JAI_RGM_TRX_RECORDS.organization_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:
101:

Line 98: ln_balancing_location_id JAI_RGM_TRX_RECORDS.location_id%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:
102: /*

Line 99: lv_balancing_accnt_name JAI_RGM_TRX_RECORDS.account_name%TYPE;

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

Line 329: INSERT INTO jai_rgm_trx_records (

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,

Line 375: jai_rgm_trx_records_s.nextval, /* repository_id, */

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, */