APPS.JAI_AR_TRXS_PKG dependencies on JAI_CONSTANTS

Line 209: AND b.tax_type = jai_constants.tax_type_modvat_recovery ;

205: SELECT a.tax_rate, b.rounding_factor
206: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
207: WHERE a.tax_id = b.tax_id
208: AND a.link_to_cust_trx_line_id = p_cust_trx_line_id
209: AND b.tax_type = jai_constants.tax_type_modvat_recovery ;
210:
211: CURSOR get_opt_unit is SELECT Operating_unit
212: FROM org_organization_definitions
213: WHERE organization_id = nvl(v_org_id,0);

Line 244: upper(jtc.tax_type) IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess) AND /* added by ssawant for bug 5989740 */

240: WHERE
241: jrctl.customer_trx_line_id = jrcttl.link_to_cust_trx_line_id AND
242: jrcttl.tax_id = jtc.tax_id AND
243:
244: upper(jtc.tax_type) IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess) AND /* added by ssawant for bug 5989740 */
245: jrctl.customer_trx_line_id = cp_trx_line_id;
246:
247:
248: CURSOR cur_get_trx_sh_cess_amt (cp_trx_line_id in number)

Line 259: upper(jtc.tax_type) IN (jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess) AND

255: jai_cmn_taxes_all jtc
256: WHERE
257: jrctl.customer_trx_line_id = jrcttl.link_to_cust_trx_line_id AND
258: jrcttl.tax_id = jtc.tax_id AND
259: upper(jtc.tax_type) IN (jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess) AND
260: jrctl.customer_trx_line_id = cp_trx_line_id;
261:
262: ln_trx_totcess_amt JAI_CMN_RG_I_TRXS.CESS_AMT%TYPE;
263: ln_trx_totshcess_amt JAI_CMN_RG_I_TRXS.SH_CESS_AMT%TYPE;

Line 269: pv_return_code := jai_constants.successful ;

265:
266:
267: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
268: BEGIN
269: pv_return_code := jai_constants.successful ;
270:
271: --added by Zhiwei for bug#14640257 begin
272: ----------------------------------------------------------
273: open get_created_from;

Line 306: v_category_name := jai_constants.je_category_rg_entry ; -- modified by csahoo for bug#6155839 --'RG Register Data Entry'; --Ramananda for File.Sql.35

302: v_conv_rate := pr_new.Exchange_rate; --Ramananda for File.Sql.35
303: --2001/05/04 Vijay,Subbu.
304: v_trx_number := pr_new.Trx_Number; --Ramananda for File.Sql.35
305: v_source_name := 'Receivables India'; --Ramananda for File.Sql.35
306: v_category_name := jai_constants.je_category_rg_entry ; -- modified by csahoo for bug#6155839 --'RG Register Data Entry'; --Ramananda for File.Sql.35
307: v_ref_10 := 'India Localization Entry for Invoice # '; -- will hold a standard text such as 'India Localization Entry for sales order'
308: v_ref_23 := 'ja_in_ar_hdr_complete_trg'; -- holds the object name -- 'ja_in_ar_hdr_complete_trg'
309: v_ref_24 := 'ra_customer_trx_lines_all'; -- holds the table name -- ' ra_customer_trx_all'
310: v_ref_25 := 'customer_trx_line_id'; -- holds the column name -- 'customer_trx_id'

Line 509: p_source => jai_constants.source_ar

505: p_last_update_login => v_last_update_login ,
506: p_assessable_value => v_assessable_value ,
507: p_cess_amt => ln_trx_totcess_amt ,
508: p_sh_cess_amt => ln_trx_totshcess_amt ,
509: p_source => jai_constants.source_ar
510: );
511:
512:
513: vsqlstmt := '20';

Line 784: Pv_return_code := jai_constants.unexpected_error;

780:
781:
782: EXCEPTION
783: WHEN OTHERS THEN
784: Pv_return_code := jai_constants.unexpected_error;
785: Pv_return_message := 'Encountered an error in JAI_JAR_TRXS_TRIGGER_PKG.ARU_T1 ' || substr(sqlerrm,1,1900);
786:
787: END update_excise_registers ;
788: