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_AP_UTILS_PKG dependencies on JAI_CONSTANTS

Line 35: jai_constants.pls (120.3)

31: ----------------------
32: jai_ap_utils.pls (120.2)
33: jai_ap_tds_old.plb (120.3)
34: jai_ap_tds_gen.plb (120.8)
35: jai_constants.pls (120.3)
36: jaiorgdffsetup.sql (120.2)
37: jaivmlu.ldt
38:
39: 3 07/12/2005 Hjujjuru for Bug 4870243, File version 120.5

Line 2345: WHERE regime_code = jai_constants.tds_regime;

2341:
2342: CURSOR c_regime_cur IS
2343: SELECT regime_id
2344: FROM JAI_RGM_DEFINITIONS
2345: WHERE regime_code = jai_constants.tds_regime;
2346:
2347: CURSOR c_attribute_value_cur(P_regime_id IN NUMBER, p_org_id number) is --added org_id parameter for bug#9149941
2348: SELECT attribute_Value
2349: FROM JAI_RGM_ORG_REGNS_V

Line 2351: AND attribute_type_code = jai_constants.regn_type_others

2347: CURSOR c_attribute_value_cur(P_regime_id IN NUMBER, p_org_id number) is --added org_id parameter for bug#9149941
2348: SELECT attribute_Value
2349: FROM JAI_RGM_ORG_REGNS_V
2350: WHERE regime_id = P_regime_id
2351: AND attribute_type_code = jai_constants.regn_type_others
2352: AND attribute_code = jai_constants.regn_type_tds_batch
2353: and organization_id = nvl(p_org_id, organization_id); --added for Bug#9149941
2354:
2355: CURSOR c_batch_name(cp_invoice_id NUMBER)

Line 2352: AND attribute_code = jai_constants.regn_type_tds_batch

2348: SELECT attribute_Value
2349: FROM JAI_RGM_ORG_REGNS_V
2350: WHERE regime_id = P_regime_id
2351: AND attribute_type_code = jai_constants.regn_type_others
2352: AND attribute_code = jai_constants.regn_type_tds_batch
2353: and organization_id = nvl(p_org_id, organization_id); --added for Bug#9149941
2354:
2355: CURSOR c_batch_name(cp_invoice_id NUMBER)
2356: IS

Line 2804: WHERE regime_code IN (jai_constants.service_regime,jai_constants.vat_regime)

2800: FROM
2801: jai_rgm_definitions rgm_def
2802: , jai_rgm_registrations tax_rgm
2803: , jai_rgm_registrations acc_rgm
2804: WHERE regime_code IN (jai_constants.service_regime,jai_constants.vat_regime)
2805: AND tax_rgm.regime_id = rgm_def.regime_id
2806: AND tax_rgm.registration_type = jai_constants.regn_type_tax_types
2807: AND tax_rgm.attribute_code = pv_tax_type
2808: AND tax_rgm.regime_id = acc_rgm.regime_id

Line 2806: AND tax_rgm.registration_type = jai_constants.regn_type_tax_types

2802: , jai_rgm_registrations tax_rgm
2803: , jai_rgm_registrations acc_rgm
2804: WHERE regime_code IN (jai_constants.service_regime,jai_constants.vat_regime)
2805: AND tax_rgm.regime_id = rgm_def.regime_id
2806: AND tax_rgm.registration_type = jai_constants.regn_type_tax_types
2807: AND tax_rgm.attribute_code = pv_tax_type
2808: AND tax_rgm.regime_id = acc_rgm.regime_id
2809: AND acc_rgm.registration_type = jai_constants.regn_type_accounts
2810: AND acc_rgm.attribute_code = jai_constants.recovery_interim

Line 2809: AND acc_rgm.registration_type = jai_constants.regn_type_accounts

2805: AND tax_rgm.regime_id = rgm_def.regime_id
2806: AND tax_rgm.registration_type = jai_constants.regn_type_tax_types
2807: AND tax_rgm.attribute_code = pv_tax_type
2808: AND tax_rgm.regime_id = acc_rgm.regime_id
2809: AND acc_rgm.registration_type = jai_constants.regn_type_accounts
2810: AND acc_rgm.attribute_code = jai_constants.recovery_interim
2811: AND acc_rgm.parent_registration_id = tax_rgm.registration_id;
2812:
2813: ln_tax_acc_id := ln_tax_rgm_acc_id;

Line 2810: AND acc_rgm.attribute_code = jai_constants.recovery_interim

2806: AND tax_rgm.registration_type = jai_constants.regn_type_tax_types
2807: AND tax_rgm.attribute_code = pv_tax_type
2808: AND tax_rgm.regime_id = acc_rgm.regime_id
2809: AND acc_rgm.registration_type = jai_constants.regn_type_accounts
2810: AND acc_rgm.attribute_code = jai_constants.recovery_interim
2811: AND acc_rgm.parent_registration_id = tax_rgm.registration_id;
2812:
2813: ln_tax_acc_id := ln_tax_rgm_acc_id;
2814: EXCEPTION

Line 3041: AND tax_line.source_doc_type = jai_constants.G_AP_STANDALONE_INVOICE

3037: FROM
3038: jai_cmn_document_taxes tax_line
3039: , jai_cmn_taxes_all tax
3040: WHERE NVL(tax.inclusive_tax_flag,'N') = 'Y'
3041: AND tax_line.source_doc_type = jai_constants.G_AP_STANDALONE_INVOICE
3042: AND tax_line.source_doc_id = pn_invoice_id
3043: AND tax_line.source_doc_parent_line_no = pn_invoice_line_num
3044: AND tax_line.tax_id = tax.tax_id
3045: GROUP BY

Line 3162: lv_match_type := jai_constants.G_AP_STANDALONE_INVOICE;

3158:
3159: -- Get inv_organization_id and inv_organization_code
3160: IF ln_po_dist_id IS NULL
3161: THEN
3162: lv_match_type := jai_constants.G_AP_STANDALONE_INVOICE;
3163: ln_inv_org_id := NULL;
3164: lv_inv_org_code := '';
3165: ELSE
3166: SELECT

Line 3193: IF lv_match_type = jai_constants.G_AP_STANDALONE_INVOICE

3189:
3190: -- if only one distribution line has been transfer to GL, then insert inclusive data into GL interface
3191: IF ln_invoice_post_num = 1
3192: THEN
3193: IF lv_match_type = jai_constants.G_AP_STANDALONE_INVOICE
3194: THEN
3195: -- Get inclusive tax info from jai_cmn_document_taxes
3196: -- and insert debit inclusive taxes into GL interface table.
3197: FOR standalone_inclu_tax_csr IN standalone_inclu_tax_cur(ln_invoice_line_num)