eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_FLEX_SERVER1 dependencies on FND_PLSQL_CACHE

Line 380: g_cache_value fnd_plsql_cache.generic_cache_value_type;

376: -- Caching.
377: -- ======================================================================
378: g_cache_return_code VARCHAR2(30);
379: g_cache_key VARCHAR2(2000);
380: g_cache_value fnd_plsql_cache.generic_cache_value_type;
381: g_cache_values fnd_plsql_cache.generic_cache_values_type;
382: g_cache_indexes fnd_plsql_cache.custom_cache_indexes_type;
383: g_cache_numof_indexes NUMBER;
384: g_cache_numof_values NUMBER;

Line 381: g_cache_values fnd_plsql_cache.generic_cache_values_type;

377: -- ======================================================================
378: g_cache_return_code VARCHAR2(30);
379: g_cache_key VARCHAR2(2000);
380: g_cache_value fnd_plsql_cache.generic_cache_value_type;
381: g_cache_values fnd_plsql_cache.generic_cache_values_type;
382: g_cache_indexes fnd_plsql_cache.custom_cache_indexes_type;
383: g_cache_numof_indexes NUMBER;
384: g_cache_numof_values NUMBER;
385:

Line 382: g_cache_indexes fnd_plsql_cache.custom_cache_indexes_type;

378: g_cache_return_code VARCHAR2(30);
379: g_cache_key VARCHAR2(2000);
380: g_cache_value fnd_plsql_cache.generic_cache_value_type;
381: g_cache_values fnd_plsql_cache.generic_cache_values_type;
382: g_cache_indexes fnd_plsql_cache.custom_cache_indexes_type;
383: g_cache_numof_indexes NUMBER;
384: g_cache_numof_values NUMBER;
385:
386: -- ======================================================================

Line 392: vst_cache_controller fnd_plsql_cache.cache_1to1_controller_type;

388: --
389: -- PK:
390: --
391: -- ======================================================================
392: vst_cache_controller fnd_plsql_cache.cache_1to1_controller_type;
393: vst_cache_storage fnd_plsql_cache.generic_cache_values_type;
394:
395: -- ======================================================================
396: -- Value Security Cache : VSC

Line 393: vst_cache_storage fnd_plsql_cache.generic_cache_values_type;

389: -- PK:
390: --
391: -- ======================================================================
392: vst_cache_controller fnd_plsql_cache.cache_1to1_controller_type;
393: vst_cache_storage fnd_plsql_cache.generic_cache_values_type;
394:
395: -- ======================================================================
396: -- Value Security Cache : VSC
397: --

Line 403: vsc_cache_controller fnd_plsql_cache.cache_1to1_controller_type;

399: -- || NEWLINE || || NEWLINE ||
400: --
401: --
402: -- ======================================================================
403: vsc_cache_controller fnd_plsql_cache.cache_1to1_controller_type;
404: vsc_cache_storage fnd_plsql_cache.generic_cache_values_type;
405:
406: -- ======================================================================
407: -- Flex Value Cache : FVC

Line 404: vsc_cache_storage fnd_plsql_cache.generic_cache_values_type;

400: --
401: --
402: -- ======================================================================
403: vsc_cache_controller fnd_plsql_cache.cache_1to1_controller_type;
404: vsc_cache_storage fnd_plsql_cache.generic_cache_values_type;
405:
406: -- ======================================================================
407: -- Flex Value Cache : FVC
408: --

Line 412: fvc_cache_controller fnd_plsql_cache.cache_1to1_controller_type;

408: --
409: -- PK: || NEWLINE || || NEWLINE ||
410: --
411: -- ======================================================================
412: fvc_cache_controller fnd_plsql_cache.cache_1to1_controller_type;
413: fvc_cache_storage fnd_plsql_cache.generic_cache_values_type;
414:
415: -- ======================================================================
416: -- Flex Segment Qualifiers Cache : FSQ

Line 413: fvc_cache_storage fnd_plsql_cache.generic_cache_values_type;

409: -- PK: || NEWLINE || || NEWLINE ||
410: --
411: -- ======================================================================
412: fvc_cache_controller fnd_plsql_cache.cache_1to1_controller_type;
413: fvc_cache_storage fnd_plsql_cache.generic_cache_values_type;
414:
415: -- ======================================================================
416: -- Flex Segment Qualifiers Cache : FSQ
417: --

Line 422: fsq_cache_controller fnd_plsql_cache.cache_1tom_controller_type;

418: -- PK: || NEWLINE || || NEWLINE ||
419: -- || NEWLINE ||
420: --
421: -- ======================================================================
422: fsq_cache_controller fnd_plsql_cache.cache_1tom_controller_type;
423: fsq_cache_storage fnd_plsql_cache.generic_cache_values_type;
424:
425: -- ======================================================================
426: -- Value Set Qualifiers Cache : VSQ

Line 423: fsq_cache_storage fnd_plsql_cache.generic_cache_values_type;

419: -- || NEWLINE ||
420: --
421: -- ======================================================================
422: fsq_cache_controller fnd_plsql_cache.cache_1tom_controller_type;
423: fsq_cache_storage fnd_plsql_cache.generic_cache_values_type;
424:
425: -- ======================================================================
426: -- Value Set Qualifiers Cache : VSQ
427: --

Line 431: vsq_cache_controller fnd_plsql_cache.cache_1tom_controller_type;

427: --
428: -- PK:
429: --
430: -- ======================================================================
431: vsq_cache_controller fnd_plsql_cache.cache_1tom_controller_type;
432: vsq_cache_storage fnd_plsql_cache.generic_cache_values_type;
433:
434: -- ======================================================================
435: -- Validate Structue Segments Cache : str

Line 432: vsq_cache_storage fnd_plsql_cache.generic_cache_values_type;

428: -- PK:
429: --
430: -- ======================================================================
431: vsq_cache_controller fnd_plsql_cache.cache_1tom_controller_type;
432: vsq_cache_storage fnd_plsql_cache.generic_cache_values_type;
433:
434: -- ======================================================================
435: -- Validate Structue Segments Cache : str
436: -- ======================================================================

Line 440: str_cache_controller fnd_plsql_cache.cache_1tom_controller_type;

436: -- ======================================================================
437: TYPE str_cache_storage_type IS TABLE OF segmentinfo
438: INDEX BY BINARY_INTEGER;
439:
440: str_cache_controller fnd_plsql_cache.cache_1tom_controller_type;
441: str_cache_storage str_cache_storage_type;
442:
443: -- ======================================================================
444: -- Local Cache Functions

Line 464: fnd_plsql_cache.generic_1to1_get_value(vsc_cache_controller,

460: p_responsibility_id || '.' ||
461: p_value_set_id || '.' ||
462: p_value);
463:
464: fnd_plsql_cache.generic_1to1_get_value(vsc_cache_controller,
465: vsc_cache_storage,
466: g_cache_key,
467: g_cache_value,
468: g_cache_return_code);

Line 470: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN

466: g_cache_key,
467: g_cache_value,
468: g_cache_return_code);
469:
470: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
471: px_error_code := g_cache_value.varchar2_1;
472: IF (px_error_code = FF_VVALID) THEN
473: RETURN(fnd_plsql_cache.CACHE_VALID);
474: ELSE

Line 473: RETURN(fnd_plsql_cache.CACHE_VALID);

469:
470: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
471: px_error_code := g_cache_value.varchar2_1;
472: IF (px_error_code = FF_VVALID) THEN
473: RETURN(fnd_plsql_cache.CACHE_VALID);
474: ELSE
475: fnd_message.set_encoded(g_cache_value.varchar2_2);
476: RETURN(fnd_plsql_cache.CACHE_INVALID);
477: END IF;

Line 476: RETURN(fnd_plsql_cache.CACHE_INVALID);

472: IF (px_error_code = FF_VVALID) THEN
473: RETURN(fnd_plsql_cache.CACHE_VALID);
474: ELSE
475: fnd_message.set_encoded(g_cache_value.varchar2_2);
476: RETURN(fnd_plsql_cache.CACHE_INVALID);
477: END IF;
478: ELSE
479: RETURN(g_cache_return_code);
480: END IF;

Line 483: RETURN(fnd_plsql_cache.CACHE_NOTFOUND);

479: RETURN(g_cache_return_code);
480: END IF;
481: EXCEPTION
482: WHEN OTHERS THEN
483: RETURN(fnd_plsql_cache.CACHE_NOTFOUND);
484: END check_vsc;
485:
486: PROCEDURE update_vsc(p_application_id IN NUMBER,
487: p_responsibility_id IN NUMBER,

Line 509: fnd_plsql_cache.generic_cache_new_value

505: l_enc_err_msg := fnd_message.get_encoded;
506: fnd_message.set_encoded(l_enc_err_msg);
507: END IF;
508:
509: fnd_plsql_cache.generic_cache_new_value
510: (x_value => g_cache_value,
511: p_varchar2_1 => p_error_code,
512: p_varchar2_2 => l_enc_err_msg);
513:

Line 514: fnd_plsql_cache.generic_1to1_put_value(vsc_cache_controller,

510: (x_value => g_cache_value,
511: p_varchar2_1 => p_error_code,
512: p_varchar2_2 => l_enc_err_msg);
513:
514: fnd_plsql_cache.generic_1to1_put_value(vsc_cache_controller,
515: vsc_cache_storage,
516: g_cache_key,
517: g_cache_value);
518: EXCEPTION

Line 539: fnd_plsql_cache.generic_1to1_get_value(fvc_cache_controller,

535: g_cache_key := (p_parent_value || '.' ||
536: p_value_set_id || '.' ||
537: p_value);
538:
539: fnd_plsql_cache.generic_1to1_get_value(fvc_cache_controller,
540: fvc_cache_storage,
541: g_cache_key,
542: g_cache_value,
543: g_cache_return_code);

Line 545: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN

541: g_cache_key,
542: g_cache_value,
543: g_cache_return_code);
544:
545: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
546: px_flexvalue.displayed_value := g_cache_value.varchar2_1;
547: px_flexvalue.stored_value := g_cache_value.varchar2_2;
548: px_flexvalue.hidden_id := g_cache_value.varchar2_3;
549: px_flexvalue.description := g_cache_value.varchar2_4;

Line 560: RETURN(fnd_plsql_cache.CACHE_NOTFOUND);

556: END IF;
557: RETURN(g_cache_return_code);
558: EXCEPTION
559: WHEN OTHERS THEN
560: RETURN(fnd_plsql_cache.CACHE_NOTFOUND);
561: END check_fvc;
562:
563: PROCEDURE update_fvc(p_value_set_id IN NUMBER,
564: p_parent_value IN VARCHAR2,

Line 576: fnd_plsql_cache.generic_cache_new_value

572: g_cache_key := (p_parent_value || '.' ||
573: p_value_set_id || '.' ||
574: p_value);
575:
576: fnd_plsql_cache.generic_cache_new_value
577: (x_value => g_cache_value,
578: p_varchar2_1 => p_flexvalue.displayed_value,
579: p_varchar2_2 => p_flexvalue.stored_value,
580: p_varchar2_3 => p_flexvalue.hidden_id,

Line 589: fnd_plsql_cache.generic_1to1_put_value(fvc_cache_controller,

585: p_varchar2_8 => p_flexvalue.enabled_flag,
586: p_date_1 => p_flexvalue.start_valid,
587: p_date_2 => p_flexvalue.end_valid);
588:
589: fnd_plsql_cache.generic_1to1_put_value(fvc_cache_controller,
590: fvc_cache_storage,
591: g_cache_key,
592: g_cache_value);
593: EXCEPTION

Line 1002: fnd_plsql_cache.custom_1tom_get_get_indexes(str_cache_controller,

998: tbl_apid || '.' ||
999: tbl_id);
1000: END IF;
1001:
1002: fnd_plsql_cache.custom_1tom_get_get_indexes(str_cache_controller,
1003: g_cache_key,
1004: g_cache_numof_indexes,
1005: g_cache_indexes,
1006: g_cache_return_code);

Line 1008: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN

1004: g_cache_numof_indexes,
1005: g_cache_indexes,
1006: g_cache_return_code);
1007:
1008: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
1009: --
1010: -- Copy cached values to local array.
1011: --
1012: FOR ii IN 1..g_cache_numof_indexes LOOP

Line 1043: fnd_plsql_cache.custom_1tom_get_put_indexes(str_cache_controller,

1039: else
1040: close descc;
1041: end if;
1042:
1043: fnd_plsql_cache.custom_1tom_get_put_indexes(str_cache_controller,
1044: g_cache_key,
1045: g_cache_numof_indexes,
1046: g_cache_indexes,
1047: g_cache_return_code);

Line 1048: IF (g_cache_return_code = fnd_plsql_cache.CACHE_PUT_IS_SUCCESSFUL) THEN

1044: g_cache_key,
1045: g_cache_numof_indexes,
1046: g_cache_indexes,
1047: g_cache_return_code);
1048: IF (g_cache_return_code = fnd_plsql_cache.CACHE_PUT_IS_SUCCESSFUL) THEN
1049: FOR ii IN 1..g_cache_numof_indexes LOOP
1050: str_cache_storage(g_cache_indexes(ii)) := l_str_cache_segs(ii);
1051: END LOOP;
1052: END IF;

Line 1572: l_fvc_code := fnd_plsql_cache.CACHE_NOTFOUND;

1568: --
1569: -- Find parent value: took out from find_value.
1570: --
1571: -- ==
1572: l_fvc_code := fnd_plsql_cache.CACHE_NOTFOUND;
1573: IF (vsinf.valtype IN ('I','D','X','Y')) THEN
1574: IF (isvalu) then
1575: l_flexvalue.displayed_value := thisseg;
1576: l_flexvalue.stored_value := thisseg;

Line 1673: IF (l_fvc_code IN (fnd_plsql_cache.CACHE_FOUND)) THEN

1669: END IF;
1670: END IF;
1671: END IF;
1672:
1673: IF (l_fvc_code IN (fnd_plsql_cache.CACHE_FOUND)) THEN
1674: vcode := FF_VVALID;
1675: ELSE
1676: vcode := find_value(fstruct, kseg, vsinf, v_date,
1677: thisseg,

Line 3439: IF (l_vsc_code IN (fnd_plsql_cache.CACHE_VALID,

3435: -- First check the VSC
3436: --
3437: l_vsc_code := check_vsc(user_apid, user_respid, vsinfo.vsid,
3438: parentval, val, l_return_code);
3439: IF (l_vsc_code IN (fnd_plsql_cache.CACHE_VALID,
3440: fnd_plsql_cache.CACHE_INVALID)) THEN
3441: IF (fnd_flex_server1.g_debug_level > 0) THEN
3442: add_debug('Found in vsc.');
3443: END IF;

Line 3440: fnd_plsql_cache.CACHE_INVALID)) THEN

3436: --
3437: l_vsc_code := check_vsc(user_apid, user_respid, vsinfo.vsid,
3438: parentval, val, l_return_code);
3439: IF (l_vsc_code IN (fnd_plsql_cache.CACHE_VALID,
3440: fnd_plsql_cache.CACHE_INVALID)) THEN
3441: IF (fnd_flex_server1.g_debug_level > 0) THEN
3442: add_debug('Found in vsc.');
3443: END IF;
3444: GOTO label_return;

Line 3479: IF (l_vsc_code IN (fnd_plsql_cache.CACHE_NOTFOUND)) THEN

3475: GOTO label_return;
3476:
3477:
3478: <>
3479: IF (l_vsc_code IN (fnd_plsql_cache.CACHE_NOTFOUND)) THEN
3480: update_vsc(user_apid, user_respid, vsinfo.vsid,
3481: parentval, val, l_return_code);
3482: END IF;
3483: IF (fnd_flex_server1.g_debug_level > 0) THEN

Line 3591: fnd_plsql_cache.generic_1tom_get_values(vsq_cache_controller,

3587: --
3588:
3589: g_cache_key := valset_id;
3590:
3591: fnd_plsql_cache.generic_1tom_get_values(vsq_cache_controller,
3592: vsq_cache_storage,
3593: g_cache_key,
3594: g_cache_numof_values,
3595: g_cache_values,

Line 3598: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN

3594: g_cache_numof_values,
3595: g_cache_values,
3596: g_cache_return_code);
3597:
3598: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
3599: NULL;
3600: ELSE
3601: i := 0;
3602: FOR vq IN cva_cursor(valset_id) LOOP

Line 3604: fnd_plsql_cache.generic_cache_new_value

3600: ELSE
3601: i := 0;
3602: FOR vq IN cva_cursor(valset_id) LOOP
3603: i := i + 1;
3604: fnd_plsql_cache.generic_cache_new_value
3605: (x_value => g_cache_value,
3606: p_number_1 => vq.fapid,
3607: p_varchar2_1 => vq.fcode,
3608: p_varchar2_2 => vq.fqname,

Line 3614: fnd_plsql_cache.generic_1tom_put_values(vsq_cache_controller,

3610: g_cache_values(i) := g_cache_value;
3611: END LOOP;
3612: g_cache_numof_values := i;
3613:
3614: fnd_plsql_cache.generic_1tom_put_values(vsq_cache_controller,
3615: vsq_cache_storage,
3616: g_cache_key,
3617: g_cache_numof_values,
3618: g_cache_values);

Line 3701: fnd_plsql_cache.generic_1tom_get_values(fsq_cache_controller,

3697: ffstruct.id_flex_code || '.' ||
3698: ffstruct.id_flex_num || '.' ||
3699: seg_colname);
3700:
3701: fnd_plsql_cache.generic_1tom_get_values(fsq_cache_controller,
3702: fsq_cache_storage,
3703: g_cache_key,
3704: g_cache_numof_values,
3705: g_cache_values,

Line 3708: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN

3704: g_cache_numof_values,
3705: g_cache_values,
3706: g_cache_return_code);
3707:
3708: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
3709: sqcount := g_cache_numof_values;
3710: ELSE
3711: FOR squal IN qual_cursor(ffstruct, seg_colname) LOOP
3712: sqcount := sqcount + 1;

Line 3714: fnd_plsql_cache.generic_cache_new_value

3710: ELSE
3711: FOR squal IN qual_cursor(ffstruct, seg_colname) LOOP
3712: sqcount := sqcount + 1;
3713:
3714: fnd_plsql_cache.generic_cache_new_value
3715: (x_value => g_cache_value,
3716: p_varchar2_1 => squal.fq_name,
3717: p_varchar2_2 => squal.sq_name,
3718: p_varchar2_3 => squal.dflt_val,

Line 3724: fnd_plsql_cache.generic_1tom_put_values(fsq_cache_controller,

3720: g_cache_values(sqcount) := g_cache_value;
3721: END LOOP;
3722: g_cache_numof_values := sqcount;
3723:
3724: fnd_plsql_cache.generic_1tom_put_values(fsq_cache_controller,
3725: fsq_cache_storage,
3726: g_cache_key,
3727: g_cache_numof_values,
3728: g_cache_values);

Line 3775: fnd_plsql_cache.generic_1to1_get_value(vst_cache_controller,

3771: 'vsid:' || value_set_id || ')');
3772: END IF;
3773:
3774: g_cache_key := value_set_id;
3775: fnd_plsql_cache.generic_1to1_get_value(vst_cache_controller,
3776: vst_cache_storage,
3777: g_cache_key,
3778: g_cache_value,
3779: g_cache_return_code);

Line 3781: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN

3777: g_cache_key,
3778: g_cache_value,
3779: g_cache_return_code);
3780:
3781: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
3782: vs_info.vsid := value_set_id;
3783: vs_info.parent_vsid := g_cache_value.number_1;
3784: vs_info.valsecure := g_cache_value.varchar2_1;
3785: vs_info.valtype := g_cache_value.varchar2_2;

Line 3806: fnd_plsql_cache.generic_cache_new_value

3802: INTO l_vsi
3803: FROM fnd_flex_value_sets
3804: WHERE flex_value_set_id = value_set_id;
3805:
3806: fnd_plsql_cache.generic_cache_new_value
3807: (x_value => g_cache_value,
3808: p_number_1 => l_vsi.parent_vsid,
3809: p_varchar2_1 => l_vsi.valsecure,
3810: p_varchar2_2 => l_vsi.valtype,

Line 3821: fnd_plsql_cache.generic_1to1_put_value(vst_cache_controller,

3817: p_varchar2_7 => l_vsi.minval,
3818: p_varchar2_8 => l_vsi.maxval,
3819: p_varchar2_9 => l_vsi.vsname);
3820:
3821: fnd_plsql_cache.generic_1to1_put_value(vst_cache_controller,
3822: vst_cache_storage,
3823: g_cache_key,
3824: g_cache_value);
3825: vs_info := l_vsi;

Line 5285: fnd_plsql_cache.generic_1to1_init('SV1.VST',

5281: NEWLINE := fnd_global.newline;
5282: TAB := fnd_global.tab;
5283: WHITESPACE := ' ' || TAB || NEWLINE;
5284:
5285: fnd_plsql_cache.generic_1to1_init('SV1.VST',
5286: vst_cache_controller,
5287: vst_cache_storage);
5288:
5289: fnd_plsql_cache.generic_1to1_init('SV1.VSC',

Line 5289: fnd_plsql_cache.generic_1to1_init('SV1.VSC',

5285: fnd_plsql_cache.generic_1to1_init('SV1.VST',
5286: vst_cache_controller,
5287: vst_cache_storage);
5288:
5289: fnd_plsql_cache.generic_1to1_init('SV1.VSC',
5290: vsc_cache_controller,
5291: vsc_cache_storage);
5292:
5293: fnd_plsql_cache.generic_1to1_init('SV1.FVC',

Line 5293: fnd_plsql_cache.generic_1to1_init('SV1.FVC',

5289: fnd_plsql_cache.generic_1to1_init('SV1.VSC',
5290: vsc_cache_controller,
5291: vsc_cache_storage);
5292:
5293: fnd_plsql_cache.generic_1to1_init('SV1.FVC',
5294: fvc_cache_controller,
5295: fvc_cache_storage);
5296:
5297: fnd_plsql_cache.generic_1tom_init('SV1.FSQ',

Line 5297: fnd_plsql_cache.generic_1tom_init('SV1.FSQ',

5293: fnd_plsql_cache.generic_1to1_init('SV1.FVC',
5294: fvc_cache_controller,
5295: fvc_cache_storage);
5296:
5297: fnd_plsql_cache.generic_1tom_init('SV1.FSQ',
5298: fsq_cache_controller,
5299: fsq_cache_storage);
5300:
5301: fnd_plsql_cache.generic_1tom_init('SV1.VSQ',

Line 5301: fnd_plsql_cache.generic_1tom_init('SV1.VSQ',

5297: fnd_plsql_cache.generic_1tom_init('SV1.FSQ',
5298: fsq_cache_controller,
5299: fsq_cache_storage);
5300:
5301: fnd_plsql_cache.generic_1tom_init('SV1.VSQ',
5302: vsq_cache_controller,
5303: vsq_cache_storage);
5304:
5305: fnd_plsql_cache.custom_1tom_init('SV1.STR',

Line 5305: fnd_plsql_cache.custom_1tom_init('SV1.STR',

5301: fnd_plsql_cache.generic_1tom_init('SV1.VSQ',
5302: vsq_cache_controller,
5303: vsq_cache_storage);
5304:
5305: fnd_plsql_cache.custom_1tom_init('SV1.STR',
5306: str_cache_controller);
5307: str_cache_storage.DELETE;
5308:
5309: --