APPS.JAI_OPEN_API_PKG dependencies on JAI_CMN_VENDOR_SITES

Line 3671: jai_cmn_vendor_sites

3667: CURSOR get_tax_service_cur IS
3668: SELECT
3669: tax_category_id, service_type_code
3670: FROM
3671: jai_cmn_vendor_sites
3672: WHERE NVL (vendor_site_id, 0) = pn_vendor_site_id
3673: AND vendor_id = pn_vendor_id;
3674:
3675: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

Line 4183: FROM jai_cmn_vendor_sites

4179: AND jcca.customer_id = cn_party_id;
4180:
4181: CURSOR get_ap_party_cur IS
4182: SELECT count(vendor_id)
4183: FROM jai_cmn_vendor_sites
4184: WHERE vendor_id = pn_party_id;
4185:
4186: CURSOR get_ap_party_site_cur IS
4187: SELECT count(vendor_site_id)

Line 4188: FROM jai_cmn_vendor_sites

4184: WHERE vendor_id = pn_party_id;
4185:
4186: CURSOR get_ap_party_site_cur IS
4187: SELECT count(vendor_site_id)
4188: FROM jai_cmn_vendor_sites
4189: WHERE vendor_site_id = pn_party_site_id;
4190:
4191: CURSOR chk_ap_party_combination_cur(
4192: cn_party_id IN JAI_INTERFACE_LINES_ALL.PARTY_ID%TYPE,

Line 4195: FROM jai_cmn_vendor_sites

4191: CURSOR chk_ap_party_combination_cur(
4192: cn_party_id IN JAI_INTERFACE_LINES_ALL.PARTY_ID%TYPE,
4193: cn_party_site_id IN JAI_INTERFACE_LINES_ALL.PARTY_SITE_ID%TYPE) IS
4194: SELECT COUNT(vendor_id)
4195: FROM jai_cmn_vendor_sites
4196: WHERE vendor_id = cn_party_id
4197: AND vendor_site_id = cn_party_site_id;
4198:
4199: --Variable define here

Line 4449: FROM JAI_CMN_VENDOR_SITES

4445: )
4446: IS
4447: SELECT
4448: service_type_code
4449: FROM JAI_CMN_VENDOR_SITES
4450: WHERE VENDOR_ID = cn_vendor_id
4451: AND VENDOR_SITE_ID = cn_vendor_site_id;
4452:
4453: CURSOR chk_service_type_code

Line 4542: lv_serv_type_code JAI_CMN_VENDOR_SITES.SERVICE_TYPE_CODE%TYPE;

4538: ln_vendor_id NUMBER;
4539: ln_vendor_site_id NUMBER;
4540:
4541: ln_result_count NUMBER;
4542: lv_serv_type_code JAI_CMN_VENDOR_SITES.SERVICE_TYPE_CODE%TYPE;
4543:
4544: lv_return_mess VARCHAR2(1000);
4545: lv_error_mess VARCHAR2(1000);
4546: --Main block