168:
169: IF l_result is NOT NULL THEN
170: return l_result;
171: END IF;
172: l_country_code := fnd_profile.value('JGZZ_COUNTRY_CODE');
173:
174: JG_ZZ_SHARED_PKG.PUT_CACHE( p_org_id => NULL,
175: p_ledger_id => NULL,
176: p_inv_org_id => NULL,
350: l_result := CHECK_CACHE(NULL,NULL,NULL,FND_GLOBAL.RESP_ID,'PRODUCT') ;
351: IF l_result is NOT NULL THEN
352: return l_result;
353: END IF;
354: l_product_code := fnd_profile.value('JGZZ_PRODUCT_CODE');
355: JG_ZZ_SHARED_PKG.PUT_CACHE( p_org_id => NULL,
356: p_ledger_id => NULL,
357: p_inv_org_id => NULL,
358: p_resp_id => FND_GLOBAL.RESP_ID,
410:
411: FUNCTION GET_APPLICATION
412: RETURN VARCHAR2 IS
413:
414: l_application fnd_profile_option_values.profile_option_value%type;
415: l_result VARCHAR2(100);
416: BEGIN
417:
418: l_result := CHECK_CACHE(NULL,NULL,NULL,FND_GLOBAL.RESP_ID,'APPL') ;
418: l_result := CHECK_CACHE(NULL,NULL,NULL,FND_GLOBAL.RESP_ID,'APPL') ;
419: IF l_result is NOT NULL THEN
420: return l_result;
421: END IF;
422: l_application := fnd_profile.value('JGZZ_APPL_SHORT_NAME');
423: JG_ZZ_SHARED_PKG.PUT_CACHE( p_org_id => NULL,
424: p_ledger_id => NULL,
425: p_inv_org_id => NULL,
426: p_resp_id => FND_GLOBAL.RESP_ID,
478: IF l_result is NOT NULL THEN
479: return l_result;
480: END IF;
481:
482: l_application := fnd_profile.value('JGZZ_APPL_SHORT_NAME');
483: JG_ZZ_SHARED_PKG.PUT_CACHE( p_org_id => NULL,
484: p_ledger_id => NULL,
485: p_inv_org_id => NULL,
486: p_resp_id => FND_GLOBAL.RESP_ID,