APPS.JAI_AR_IMPORT_POPU_PKG dependencies on JAI_RGM_DEFINITIONS

Line 513: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;

509:
510: ln_legal_entity_id NUMBER ;
511:
512: ln_tcs_exists number;
513: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;
514: ln_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%type;
515: ln_last_line_no number;
516: ln_base_line_no number;
517: lv_process_flag VARCHAR2(2);

Line 521: cursor c_chk_rgm_tax_exists ( cp_regime_code JAI_RGM_DEFINITIONS.regime_code%type

517: lv_process_flag VARCHAR2(2);
518: lv_process_message VARCHAR2(1996);
519: ln_reg_id number;
520:
521: cursor c_chk_rgm_tax_exists ( cp_regime_code JAI_RGM_DEFINITIONS.regime_code%type
522: , cp_cust_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type
523: )
524: is
525: select count(1)

Line 534: cursor c_get_regime_id (cp_regime_code JAI_RGM_DEFINITIONS.regime_code%type)

530: and jtc.tax_type = jrttv.tax_type
531: and regime_code = cp_regime_code
532: and jrctt.link_to_cust_trx_line_id = cp_cust_trx_line_id;
533:
534: cursor c_get_regime_id (cp_regime_code JAI_RGM_DEFINITIONS.regime_code%type)
535: is
536: select regime_id
537: from JAI_RGM_DEFINITIONS
538: where regime_code = cp_regime_code;

Line 537: from JAI_RGM_DEFINITIONS

533:
534: cursor c_get_regime_id (cp_regime_code JAI_RGM_DEFINITIONS.regime_code%type)
535: is
536: select regime_id
537: from JAI_RGM_DEFINITIONS
538: where regime_code = cp_regime_code;
539:
540: Cursor get_ar_tax_amount
541: is

Line 5089: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;

5085: lv_addl_msg JAI_CMN_ERRORS_T.ADDITIONAL_ERROR_MESG%type;*/
5086:
5087: ln_legal_entity_id NUMBER;
5088: ln_tcs_exists number;
5089: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;
5090: ln_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%type;
5091: ln_last_line_no number;
5092: ln_base_line_no number;
5093: lv_process_flag VARCHAR2(2);

Line 5097: cursor c_chk_rgm_tax_exists ( cp_regime_code JAI_RGM_DEFINITIONS.regime_code%type

5093: lv_process_flag VARCHAR2(2);
5094: lv_process_message VARCHAR2(1996);
5095: ln_reg_id number;
5096: ln_threshold_tax_cat_id jai_ap_tds_thhold_taxes.tax_category_id%type;
5097: cursor c_chk_rgm_tax_exists ( cp_regime_code JAI_RGM_DEFINITIONS.regime_code%type
5098: , cp_cust_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type
5099: )
5100: is
5101: select count(1)

Line 5109: cursor c_get_regime_id (cp_regime_code JAI_RGM_DEFINITIONS.regime_code%type)

5105: where jtc.tax_id = jrctt.tax_id
5106: and jtc.tax_type = jrttv.tax_type
5107: and regime_code = cp_regime_code
5108: and jrctt.link_to_cust_trx_line_id = cp_cust_trx_line_id;
5109: cursor c_get_regime_id (cp_regime_code JAI_RGM_DEFINITIONS.regime_code%type)
5110: is
5111: select regime_id
5112: from JAI_RGM_DEFINITIONS
5113: where regime_code = cp_regime_code;

Line 5112: from JAI_RGM_DEFINITIONS

5108: and jrctt.link_to_cust_trx_line_id = cp_cust_trx_line_id;
5109: cursor c_get_regime_id (cp_regime_code JAI_RGM_DEFINITIONS.regime_code%type)
5110: is
5111: select regime_id
5112: from JAI_RGM_DEFINITIONS
5113: where regime_code = cp_regime_code;
5114:
5115: Cursor get_ar_tax_amount
5116: is