APPS.JAI_AP_UTILS_PKG dependencies on JAI_CONSTANTS

Line 33: jai_constants.pls (120.3)

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

Line 2122: WHERE regime_code = jai_constants.tds_regime;

2118:
2119: CURSOR c_regime_cur IS
2120: SELECT regime_id
2121: FROM JAI_RGM_DEFINITIONS
2122: WHERE regime_code = jai_constants.tds_regime;
2123:
2124: CURSOR c_attribute_value_cur(P_regime_id IN NUMBER) is
2125: SELECT attribute_Value
2126: FROM JAI_RGM_ORG_REGNS_V

Line 2128: AND attribute_type_code = jai_constants.regn_type_others

2124: CURSOR c_attribute_value_cur(P_regime_id IN NUMBER) is
2125: SELECT attribute_Value
2126: FROM JAI_RGM_ORG_REGNS_V
2127: WHERE regime_id = P_regime_id
2128: AND attribute_type_code = jai_constants.regn_type_others
2129: AND attribute_code = jai_constants.regn_type_tds_batch;
2130:
2131: CURSOR c_batch_name(cp_invoice_id NUMBER)
2132: IS

Line 2129: AND attribute_code = jai_constants.regn_type_tds_batch;

2125: SELECT attribute_Value
2126: FROM JAI_RGM_ORG_REGNS_V
2127: WHERE regime_id = P_regime_id
2128: AND attribute_type_code = jai_constants.regn_type_others
2129: AND attribute_code = jai_constants.regn_type_tds_batch;
2130:
2131: CURSOR c_batch_name(cp_invoice_id NUMBER)
2132: IS
2133: SELECT b.batch_name

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

2575: FROM
2576: jai_rgm_definitions rgm_def
2577: , jai_rgm_registrations tax_rgm
2578: , jai_rgm_registrations acc_rgm
2579: WHERE regime_code IN (jai_constants.service_regime,jai_constants.vat_regime)
2580: AND tax_rgm.regime_id = rgm_def.regime_id
2581: AND tax_rgm.registration_type = jai_constants.regn_type_tax_types
2582: AND tax_rgm.attribute_code = pv_tax_type
2583: AND tax_rgm.regime_id = acc_rgm.regime_id

Line 2581: AND tax_rgm.registration_type = jai_constants.regn_type_tax_types

2577: , jai_rgm_registrations tax_rgm
2578: , jai_rgm_registrations acc_rgm
2579: WHERE regime_code IN (jai_constants.service_regime,jai_constants.vat_regime)
2580: AND tax_rgm.regime_id = rgm_def.regime_id
2581: AND tax_rgm.registration_type = jai_constants.regn_type_tax_types
2582: AND tax_rgm.attribute_code = pv_tax_type
2583: AND tax_rgm.regime_id = acc_rgm.regime_id
2584: AND acc_rgm.registration_type = jai_constants.regn_type_accounts
2585: AND acc_rgm.attribute_code = jai_constants.recovery_interim

Line 2584: AND acc_rgm.registration_type = jai_constants.regn_type_accounts

2580: AND tax_rgm.regime_id = rgm_def.regime_id
2581: AND tax_rgm.registration_type = jai_constants.regn_type_tax_types
2582: AND tax_rgm.attribute_code = pv_tax_type
2583: AND tax_rgm.regime_id = acc_rgm.regime_id
2584: AND acc_rgm.registration_type = jai_constants.regn_type_accounts
2585: AND acc_rgm.attribute_code = jai_constants.recovery_interim
2586: AND acc_rgm.parent_registration_id = tax_rgm.registration_id;
2587:
2588: ln_tax_acc_id := ln_tax_rgm_acc_id;

Line 2585: AND acc_rgm.attribute_code = jai_constants.recovery_interim

2581: AND tax_rgm.registration_type = jai_constants.regn_type_tax_types
2582: AND tax_rgm.attribute_code = pv_tax_type
2583: AND tax_rgm.regime_id = acc_rgm.regime_id
2584: AND acc_rgm.registration_type = jai_constants.regn_type_accounts
2585: AND acc_rgm.attribute_code = jai_constants.recovery_interim
2586: AND acc_rgm.parent_registration_id = tax_rgm.registration_id;
2587:
2588: ln_tax_acc_id := ln_tax_rgm_acc_id;
2589: EXCEPTION

Line 2816: AND tax_line.source_doc_type = jai_constants.G_AP_STANDALONE_INVOICE

2812: FROM
2813: jai_cmn_document_taxes tax_line
2814: , jai_cmn_taxes_all tax
2815: WHERE NVL(tax.inclusive_tax_flag,'N') = 'Y'
2816: AND tax_line.source_doc_type = jai_constants.G_AP_STANDALONE_INVOICE
2817: AND tax_line.source_doc_id = pn_invoice_id
2818: AND tax_line.source_doc_parent_line_no = pn_invoice_line_num
2819: AND tax_line.tax_id = tax.tax_id
2820: GROUP BY

Line 2937: lv_match_type := jai_constants.G_AP_STANDALONE_INVOICE;

2933:
2934: -- Get inv_organization_id and inv_organization_code
2935: IF ln_po_dist_id IS NULL
2936: THEN
2937: lv_match_type := jai_constants.G_AP_STANDALONE_INVOICE;
2938: ln_inv_org_id := NULL;
2939: lv_inv_org_code := '';
2940: ELSE
2941: SELECT

Line 2968: IF lv_match_type = jai_constants.G_AP_STANDALONE_INVOICE

2964:
2965: -- if only one distribution line has been transfer to GL, then insert inclusive data into GL interface
2966: IF ln_invoice_post_num = 1
2967: THEN
2968: IF lv_match_type = jai_constants.G_AP_STANDALONE_INVOICE
2969: THEN
2970: -- Get inclusive tax info from jai_cmn_document_taxes
2971: -- and insert debit inclusive taxes into GL interface table.
2972: FOR standalone_inclu_tax_csr IN standalone_inclu_tax_cur(ln_invoice_line_num)