DBA Data[Home] [Help]

APPS.JL_INTERFACE_VAL dependencies on FND_GLOBAL

Line 333: WHERE request_id = fnd_global.conc_request_id ;

329: --fnd_profile.get('ORG_ID',l_ou_id);
330: --Bug 4499004
331: --commented out above line and getting org id from fnd concurrents
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:

Line 1391: WHERE request_id = fnd_global.conc_request_id ;

1387:
1388: --Bug 4499004
1389: --commented out above line and getting org id from fnd concurrents
1390: SELECT org_id into l_ou_id FROM fnd_concurrent_requests
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

Line 1442: WHERE request_id = fnd_global.conc_request_id ;

1438: --fnd_profile.get('ORG_ID',l_ou_id);
1439: --Bug 4499004
1440: --commented out above line and getting org id from fnd concurrents
1441: SELECT org_id into l_ou_id FROM fnd_concurrent_requests
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