[Home] [Help]
356: p_accrual_basis IN VARCHAR2 DEFAULT NULL, --Add by Xiao for POT change, reg bug#12533434 on 16-May-2011
357: p_invoice_no IN VARCHAR2 DEFAULT NULL --Added by Qiong for advanced receipts bug#13361952
358: ) IS
359:
360: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%TYPE;
361: ln_credit NUMBER;
362: ln_debit NUMBER;
363: ln_trx_credit NUMBER;
364: ln_trx_debit NUMBER;
1233: ln_entered_cr NUMBER;
1234: ln_accounted_dr NUMBER;
1235: ln_accounted_cr NUMBER;
1236:
1237: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%TYPE;
1238: lv_reference_name VARCHAR2(30);
1239: ln_reference_id NUMBER(15);
1240: lv_gl_je_category varchar2(30); --File.Sql.35 Cbabu jai_constants.je_category_rg_entry%type;
1241: lv_status gl_interface.status%TYPE ; --rchandan for bug#4428980
1745:
1746: lv_organization_type VARCHAR2(2);
1747: ln_organization_id NUMBER;
1748:
1749: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%TYPE;
1750: lv_excise_cess JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE; /* Added by Ramananda - bug# 4546114*/
1751:
1752: BEGIN
1753:
2141: and (cp_location_id is null or location_id = cp_location_id)
2142: AND registration_type = jai_constants.regn_type_others
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);
2235: ) IS
2236:
2237: r_repo_dtl c_repository_dtl%ROWTYPE;
2238:
2239: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%TYPE;
2240: lv_tax_type JAI_CMN_TAXES_ALL.tax_type%TYPE;
2241: ln_credit NUMBER;
2242: ln_debit NUMBER;
2243: ln_accounted_credit NUMBER;