eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_OPEN_API_PKG dependencies on JAI_AR_TRX_PKG

Line 5769: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);

5765: FETCH ORG_CUR
5766: INTO V_ORG_ID;
5767: CLOSE ORG_CUR;
5768:
5769: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
5770: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur
5771: INTO lv_tax_regime_code;
5772: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur;
5773:

Line 5770: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur

5766: INTO V_ORG_ID;
5767: CLOSE ORG_CUR;
5768:
5769: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
5770: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur
5771: INTO lv_tax_regime_code;
5772: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur;
5773:
5774: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);

Line 5772: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur;

5768:
5769: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
5770: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur
5771: INTO lv_tax_regime_code;
5772: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur;
5773:
5774: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
5775: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur
5776: INTO ln_tax_rate_id;

Line 5774: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);

5770: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur
5771: INTO lv_tax_regime_code;
5772: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur;
5773:
5774: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
5775: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur
5776: INTO ln_tax_rate_id;
5777: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur;
5778:

Line 5775: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur

5771: INTO lv_tax_regime_code;
5772: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur;
5773:
5774: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
5775: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur
5776: INTO ln_tax_rate_id;
5777: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur;
5778:
5779: OPEN SO_AR_HDR_INFO;

Line 5777: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur;

5773:
5774: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
5775: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur
5776: INTO ln_tax_rate_id;
5777: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur;
5778:
5779: OPEN SO_AR_HDR_INFO;
5780: FETCH SO_AR_HDR_INFO
5781: INTO v_organization_id, v_location_id, v_batch_source_id;

Line 6638: jai_ar_trx_pkg.update_reference(

6634: AND lines.customer_trx_id = pn_customer_trx_id
6635: AND lines.interface_flag = 'Y'
6636: AND intfs.taxable_event = 'EXTERNAL';
6637:
6638: jai_ar_trx_pkg.update_reference(
6639: retcode => lv_return_code,
6640: errbuf => lv_return_message,
6641: pn_customer_trx_id => pn_customer_trx_id);
6642:

Line 7277: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);

7273: FETCH GL_DATE_CUR INTO v_gl_date;
7274: CLOSE GL_DATE_CUR;
7275: v_sql_num := 19;
7276:
7277: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
7278: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
7279: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur;
7280:
7281: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);

Line 7278: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;

7274: CLOSE GL_DATE_CUR;
7275: v_sql_num := 19;
7276:
7277: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
7278: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
7279: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur;
7280:
7281: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);
7282: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;

Line 7279: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur;

7275: v_sql_num := 19;
7276:
7277: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
7278: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
7279: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur;
7280:
7281: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);
7282: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;
7283: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur;

Line 7281: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);

7277: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
7278: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
7279: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur;
7280:
7281: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);
7282: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;
7283: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur;
7284:
7285: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code,

Line 7282: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;

7278: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur INTO lv_tax_regime_code;
7279: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur;
7280:
7281: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);
7282: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;
7283: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur;
7284:
7285: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code,
7286: ln_party_tax_profile_id);

Line 7283: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur;

7279: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur;
7280:
7281: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);
7282: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;
7283: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur;
7284:
7285: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code,
7286: ln_party_tax_profile_id);
7287: FETCH jai_ar_trx_pkg.c_tax_rate_id_cur INTO ln_tax_rate_id;

Line 7285: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code,

7281: OPEN jai_ar_trx_pkg.c_party_tax_profile_id_cur(V_ORG_ID);
7282: FETCH jai_ar_trx_pkg.c_party_tax_profile_id_cur INTO ln_party_tax_profile_id;
7283: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur;
7284:
7285: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code,
7286: ln_party_tax_profile_id);
7287: FETCH jai_ar_trx_pkg.c_tax_rate_id_cur INTO ln_tax_rate_id;
7288: CLOSE jai_ar_trx_pkg.c_tax_rate_id_cur;
7289:

Line 7287: FETCH jai_ar_trx_pkg.c_tax_rate_id_cur INTO ln_tax_rate_id;

7283: CLOSE jai_ar_trx_pkg.c_party_tax_profile_id_cur;
7284:
7285: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code,
7286: ln_party_tax_profile_id);
7287: FETCH jai_ar_trx_pkg.c_tax_rate_id_cur INTO ln_tax_rate_id;
7288: CLOSE jai_ar_trx_pkg.c_tax_rate_id_cur;
7289:
7290: if ln_tax_rate_id is null then
7291: raise Localization_tax_not_defined;

Line 7288: CLOSE jai_ar_trx_pkg.c_tax_rate_id_cur;

7284:
7285: OPEN jai_ar_trx_pkg.c_tax_rate_id_cur(lv_tax_regime_code,
7286: ln_party_tax_profile_id);
7287: FETCH jai_ar_trx_pkg.c_tax_rate_id_cur INTO ln_tax_rate_id;
7288: CLOSE jai_ar_trx_pkg.c_tax_rate_id_cur;
7289:
7290: if ln_tax_rate_id is null then
7291: raise Localization_tax_not_defined;
7292: end if;