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 1580: l_fvc_code := fnd_plsql_cache.CACHE_NOTFOUND;

1576: --
1577: -- Find parent value: took out from find_value.
1578: --
1579: -- ==
1580: l_fvc_code := fnd_plsql_cache.CACHE_NOTFOUND;
1581: IF (vsinf.valtype IN ('I','D','X','Y')) THEN
1582: IF (isvalu) then
1583: l_flexvalue.displayed_value := thisseg;
1584: l_flexvalue.stored_value := thisseg;

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

1682: END IF;
1683: END IF;
1684: END IF;
1685:
1686: IF (l_fvc_code IN (fnd_plsql_cache.CACHE_FOUND)) THEN
1687: vcode := FF_VVALID;
1688: ELSE
1689: vcode := find_value(fstruct, kseg, vsinf, v_date,
1690: thisseg,

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

3455: -- First check the VSC
3456: --
3457: l_vsc_code := check_vsc(user_apid, user_respid, vsinfo.vsid,
3458: parentval, val, l_return_code);
3459: IF (l_vsc_code IN (fnd_plsql_cache.CACHE_VALID,
3460: fnd_plsql_cache.CACHE_INVALID)) THEN
3461: IF (fnd_flex_server1.g_debug_level > 0) THEN
3462: add_debug('Found in vsc.');
3463: END IF;

Line 3460: fnd_plsql_cache.CACHE_INVALID)) THEN

3456: --
3457: l_vsc_code := check_vsc(user_apid, user_respid, vsinfo.vsid,
3458: parentval, val, l_return_code);
3459: IF (l_vsc_code IN (fnd_plsql_cache.CACHE_VALID,
3460: fnd_plsql_cache.CACHE_INVALID)) THEN
3461: IF (fnd_flex_server1.g_debug_level > 0) THEN
3462: add_debug('Found in vsc.');
3463: END IF;
3464: GOTO label_return;

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

3495: GOTO label_return;
3496:
3497:
3498: <>
3499: IF (l_vsc_code IN (fnd_plsql_cache.CACHE_NOTFOUND)) THEN
3500: update_vsc(user_apid, user_respid, vsinfo.vsid,
3501: parentval, val, l_return_code);
3502: END IF;
3503: IF (fnd_flex_server1.g_debug_level > 0) THEN

Line 3611: fnd_plsql_cache.generic_1tom_get_values(vsq_cache_controller,

3607: --
3608:
3609: g_cache_key := valset_id;
3610:
3611: fnd_plsql_cache.generic_1tom_get_values(vsq_cache_controller,
3612: vsq_cache_storage,
3613: g_cache_key,
3614: g_cache_numof_values,
3615: g_cache_values,

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

3614: g_cache_numof_values,
3615: g_cache_values,
3616: g_cache_return_code);
3617:
3618: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
3619: NULL;
3620: ELSE
3621: i := 0;
3622: FOR vq IN cva_cursor(valset_id) LOOP

Line 3624: fnd_plsql_cache.generic_cache_new_value

3620: ELSE
3621: i := 0;
3622: FOR vq IN cva_cursor(valset_id) LOOP
3623: i := i + 1;
3624: fnd_plsql_cache.generic_cache_new_value
3625: (x_value => g_cache_value,
3626: p_number_1 => vq.fapid,
3627: p_varchar2_1 => vq.fcode,
3628: p_varchar2_2 => vq.fqname,

Line 3634: fnd_plsql_cache.generic_1tom_put_values(vsq_cache_controller,

3630: g_cache_values(i) := g_cache_value;
3631: END LOOP;
3632: g_cache_numof_values := i;
3633:
3634: fnd_plsql_cache.generic_1tom_put_values(vsq_cache_controller,
3635: vsq_cache_storage,
3636: g_cache_key,
3637: g_cache_numof_values,
3638: g_cache_values);

Line 3721: fnd_plsql_cache.generic_1tom_get_values(fsq_cache_controller,

3717: ffstruct.id_flex_code || '.' ||
3718: ffstruct.id_flex_num || '.' ||
3719: seg_colname);
3720:
3721: fnd_plsql_cache.generic_1tom_get_values(fsq_cache_controller,
3722: fsq_cache_storage,
3723: g_cache_key,
3724: g_cache_numof_values,
3725: g_cache_values,

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

3724: g_cache_numof_values,
3725: g_cache_values,
3726: g_cache_return_code);
3727:
3728: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
3729: sqcount := g_cache_numof_values;
3730: ELSE
3731: FOR squal IN qual_cursor(ffstruct, seg_colname) LOOP
3732: sqcount := sqcount + 1;

Line 3734: fnd_plsql_cache.generic_cache_new_value

3730: ELSE
3731: FOR squal IN qual_cursor(ffstruct, seg_colname) LOOP
3732: sqcount := sqcount + 1;
3733:
3734: fnd_plsql_cache.generic_cache_new_value
3735: (x_value => g_cache_value,
3736: p_varchar2_1 => squal.fq_name,
3737: p_varchar2_2 => squal.sq_name,
3738: p_varchar2_3 => squal.dflt_val,

Line 3744: fnd_plsql_cache.generic_1tom_put_values(fsq_cache_controller,

3740: g_cache_values(sqcount) := g_cache_value;
3741: END LOOP;
3742: g_cache_numof_values := sqcount;
3743:
3744: fnd_plsql_cache.generic_1tom_put_values(fsq_cache_controller,
3745: fsq_cache_storage,
3746: g_cache_key,
3747: g_cache_numof_values,
3748: g_cache_values);

Line 3795: fnd_plsql_cache.generic_1to1_get_value(vst_cache_controller,

3791: 'vsid:' || value_set_id || ')');
3792: END IF;
3793:
3794: g_cache_key := value_set_id;
3795: fnd_plsql_cache.generic_1to1_get_value(vst_cache_controller,
3796: vst_cache_storage,
3797: g_cache_key,
3798: g_cache_value,
3799: g_cache_return_code);

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

3797: g_cache_key,
3798: g_cache_value,
3799: g_cache_return_code);
3800:
3801: IF (g_cache_return_code = fnd_plsql_cache.CACHE_FOUND) THEN
3802: vs_info.vsid := value_set_id;
3803: vs_info.parent_vsid := g_cache_value.number_1;
3804: vs_info.valsecure := g_cache_value.varchar2_1;
3805: vs_info.valtype := g_cache_value.varchar2_2;

Line 3826: fnd_plsql_cache.generic_cache_new_value

3822: INTO l_vsi
3823: FROM fnd_flex_value_sets
3824: WHERE flex_value_set_id = value_set_id;
3825:
3826: fnd_plsql_cache.generic_cache_new_value
3827: (x_value => g_cache_value,
3828: p_number_1 => l_vsi.parent_vsid,
3829: p_varchar2_1 => l_vsi.valsecure,
3830: p_varchar2_2 => l_vsi.valtype,

Line 3841: fnd_plsql_cache.generic_1to1_put_value(vst_cache_controller,

3837: p_varchar2_7 => l_vsi.minval,
3838: p_varchar2_8 => l_vsi.maxval,
3839: p_varchar2_9 => l_vsi.vsname);
3840:
3841: fnd_plsql_cache.generic_1to1_put_value(vst_cache_controller,
3842: vst_cache_storage,
3843: g_cache_key,
3844: g_cache_value);
3845: vs_info := l_vsi;

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

5301: NEWLINE := fnd_global.newline;
5302: TAB := fnd_global.tab;
5303: WHITESPACE := ' ' || TAB || NEWLINE;
5304:
5305: fnd_plsql_cache.generic_1to1_init('SV1.VST',
5306: vst_cache_controller,
5307: vst_cache_storage);
5308:
5309: fnd_plsql_cache.generic_1to1_init('SV1.VSC',

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

5305: fnd_plsql_cache.generic_1to1_init('SV1.VST',
5306: vst_cache_controller,
5307: vst_cache_storage);
5308:
5309: fnd_plsql_cache.generic_1to1_init('SV1.VSC',
5310: vsc_cache_controller,
5311: vsc_cache_storage);
5312:
5313: fnd_plsql_cache.generic_1to1_init('SV1.FVC',

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

5309: fnd_plsql_cache.generic_1to1_init('SV1.VSC',
5310: vsc_cache_controller,
5311: vsc_cache_storage);
5312:
5313: fnd_plsql_cache.generic_1to1_init('SV1.FVC',
5314: fvc_cache_controller,
5315: fvc_cache_storage);
5316:
5317: fnd_plsql_cache.generic_1tom_init('SV1.FSQ',

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

5313: fnd_plsql_cache.generic_1to1_init('SV1.FVC',
5314: fvc_cache_controller,
5315: fvc_cache_storage);
5316:
5317: fnd_plsql_cache.generic_1tom_init('SV1.FSQ',
5318: fsq_cache_controller,
5319: fsq_cache_storage);
5320:
5321: fnd_plsql_cache.generic_1tom_init('SV1.VSQ',

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

5317: fnd_plsql_cache.generic_1tom_init('SV1.FSQ',
5318: fsq_cache_controller,
5319: fsq_cache_storage);
5320:
5321: fnd_plsql_cache.generic_1tom_init('SV1.VSQ',
5322: vsq_cache_controller,
5323: vsq_cache_storage);
5324:
5325: fnd_plsql_cache.custom_1tom_init('SV1.STR',

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

5321: fnd_plsql_cache.generic_1tom_init('SV1.VSQ',
5322: vsq_cache_controller,
5323: vsq_cache_storage);
5324:
5325: fnd_plsql_cache.custom_1tom_init('SV1.STR',
5326: str_cache_controller);
5327: str_cache_storage.DELETE;
5328:
5329: --