APPS.JG_GLOBE_FLEX_VAL dependencies on RA_CUSTOMERS_INTERFACE

Line 1668: -- global flexfield segments in RA_CUSTOMERS_INTERFACE

1664: END check_ap_business_rules;
1665:
1666:
1667: -- Call global flexfield validations procedure for validating the Tax ID and
1668: -- global flexfield segments in RA_CUSTOMERS_INTERFACE
1669:
1670: PROCEDURE ar_cust_interface(p_request_id IN NUMBER,
1671: p_org_id IN NUMBER,
1672: -- This org_id is not used for data partitioning

Line 1689: -- This is for new RA_CUSTOMERS_INTERFACE model.

1685:
1686: --
1687: -- Modified to implement new TCA model
1688: --
1689: -- This is for new RA_CUSTOMERS_INTERFACE model.
1690: -- You can delete old model once you completed.
1691: --
1692: -- This revision includes following columns:
1693: --

Line 1707: CURSOR ra_customers_interface IS

1703: -- gdf_site_use_attr_cat
1704: -- gdf_site_use_attr1..20
1705: --
1706:
1707: CURSOR ra_customers_interface IS
1708: SELECT i.customer_name, i.customer_number, i.jgzz_fiscal_code,
1709: i.orig_system_customer_ref,i.insert_update_flag,
1710: i.cust_tax_reference,
1711: i.global_attribute_category,i.global_attribute1,

Line 1736: FROM ra_customers_interface i

1732: i.gdf_site_use_attribute14,i.gdf_site_use_attribute15,i.gdf_site_use_attribute16,
1733: i.gdf_site_use_attribute17,i.gdf_site_use_attribute18,i.gdf_site_use_attribute19,
1734: i.gdf_site_use_attribute20,
1735: i.rowid
1736: FROM ra_customers_interface i
1737: WHERE i.request_id = p_request_id
1738: AND nvl(i.validated_flag,'N') <> 'Y';
1739:
1740: --

Line 1816: FOR idx_cur IN ra_customers_interface LOOP

1812: OPEN generate_number;
1813: FETCH generate_number INTO l_cust_man_numbering;
1814: CLOSE generate_number;
1815:
1816: FOR idx_cur IN ra_customers_interface LOOP
1817: --
1818: -- Modified to implement new TCA model
1819: --
1820: gdf_rec1.global_attribute_category := idx_cur.global_attribute_category;

Line 2200: JG_GLOBE_FLEX_VAL_SHARED.UPDATE_RA_CUSTOMERS_INTERFACE(

2196: IF l_errcode IS NOT NULL THEN
2197: --
2198: -- Update STATUS column of the customer interface table
2199: --
2200: JG_GLOBE_FLEX_VAL_SHARED.UPDATE_RA_CUSTOMERS_INTERFACE(
2201: l_errcode,
2202: p_glob_attr_general.core_prod_arg2,
2203: 'E');
2204: END IF;