332: SELECT org_id into l_ou_id FROM fnd_concurrent_requests
333: WHERE request_id = fnd_global.conc_request_id ;
334:
335: fnd_request.set_org_id(l_ou_id);
336: l_country_code := jg_zz_shared_pkg.get_country(l_ou_id, NULL,null);
337:
338: -------------------------------------------------------
339: -- Execute the Colombia Balancing Segament Validation
340: -------------------------------------------------------
1391: WHERE request_id = fnd_global.conc_request_id ;
1392:
1393: fnd_request.set_org_id(l_ou_id);
1394:
1395: IF jg_zz_shared_pkg.get_country(l_ou_id, NULL,null) IN ('AR','BR','CO','CL') THEN --Bug 2354736
1396:
1397: IF p_glob_attr_set1.global_attribute_category IN
1398: ('JL.AR.ARXCUDCI.CUSTOMERS' ,
1399: 'JL.CL.ARXCUDCI.CUSTOMERS' ,
1417: END IF;
1418:
1419: END IF;
1420:
1421: IF jg_zz_shared_pkg.get_country(l_ou_id, NULL) = 'BR' THEN --Bug 2354736
1422:
1423: IF p_glob_attr_set2.global_attribute_category =
1424: 'JL.BR.ARXCUDCI.Additional' THEN
1425: jl_br_arxcudci_additional (p_glob_attr_set1,
1442: WHERE request_id = fnd_global.conc_request_id ;
1443:
1444: fnd_request.set_org_id(l_ou_id);
1445:
1446: IF jg_zz_shared_pkg.get_country(l_ou_id, NULL) = 'BR' THEN
1447:
1448: IF p_glob_attr_set2.global_attribute_category =
1449: 'JL.BR.ARXCUDCI.Additional Info' THEN
1450: jl_br_customer_profiles (p_glob_attr_set1,