APPS.JG_GLOBE_FLEX_VAL dependencies on RA_CUSTOMERS_INTERFACE

Line 1561: -- global flexfield segments in RA_CUSTOMERS_INTERFACE

1557: END check_ap_business_rules;
1558:
1559:
1560: -- Call global flexfield validations procedure for validating the Tax ID and
1561: -- global flexfield segments in RA_CUSTOMERS_INTERFACE
1562:
1563: PROCEDURE ar_cust_interface(p_request_id IN NUMBER,
1564: p_org_id IN NUMBER,
1565: -- This org_id is not used for data partitioning

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

1578:
1579: --
1580: -- Modified to implement new TCA model
1581: --
1582: -- This is for new RA_CUSTOMERS_INTERFACE model.
1583: -- You can delete old model once you completed.
1584: --
1585: -- This revision includes following columns:
1586: --

Line 1600: CURSOR ra_customers_interface IS

1596: -- gdf_site_use_attr_cat
1597: -- gdf_site_use_attr1..20
1598: --
1599:
1600: CURSOR ra_customers_interface IS
1601: SELECT i.customer_name, i.customer_number, i.jgzz_fiscal_code,
1602: i.orig_system_customer_ref,i.insert_update_flag,
1603: i.cust_tax_reference,
1604: i.global_attribute_category,i.global_attribute1,

Line 1629: FROM ra_customers_interface i

1625: i.gdf_site_use_attribute14,i.gdf_site_use_attribute15,i.gdf_site_use_attribute16,
1626: i.gdf_site_use_attribute17,i.gdf_site_use_attribute18,i.gdf_site_use_attribute19,
1627: i.gdf_site_use_attribute20,
1628: i.rowid
1629: FROM ra_customers_interface i
1630: WHERE i.request_id = p_request_id
1631: AND nvl(i.validated_flag,'N') <> 'Y';
1632:
1633: --

Line 1709: FOR idx_cur IN ra_customers_interface LOOP

1705: OPEN generate_number;
1706: FETCH generate_number INTO l_cust_man_numbering;
1707: CLOSE generate_number;
1708:
1709: FOR idx_cur IN ra_customers_interface LOOP
1710: --
1711: -- Modified to implement new TCA model
1712: --
1713: gdf_rec1.global_attribute_category := idx_cur.global_attribute_category;

Line 2093: JG_GLOBE_FLEX_VAL_SHARED.UPDATE_RA_CUSTOMERS_INTERFACE(

2089: IF l_errcode IS NOT NULL THEN
2090: --
2091: -- Update STATUS column of the customer interface table
2092: --
2093: JG_GLOBE_FLEX_VAL_SHARED.UPDATE_RA_CUSTOMERS_INTERFACE(
2094: l_errcode,
2095: p_glob_attr_general.core_prod_arg2,
2096: 'E');
2097: END IF;