241: l_context_segment_included BOOLEAN;
242:
243: BEGIN
244: IF (fnd_flex_server1.g_debug_level > 0) THEN
245: FND_FLEX_SERVER1.add_debug(fnd_global.newline ||
246: 'BEGIN SV4.descval_engine() ');
247: END IF;
248:
249: -- Initialize all output variables so that returning from any point
494: effective_table VARCHAR2(30);
495:
496: BEGIN
497: IF (fnd_flex_server1.g_debug_level > 0) THEN
498: FND_FLEX_SERVER1.add_debug(fnd_global.newline ||
499: 'BEGIN SV4.find_descsegs() ');
500: END IF;
501:
502: nsegs_out := 0;
542: rstat NUMBER;
543:
544: BEGIN
545: IF (fnd_flex_server1.g_debug_level > 0) THEN
546: FND_FLEX_SERVER1.add_debug(fnd_global.newline ||
547: 'BEGIN SV4.read_datafield() ');
548: END IF;
549:
550: fnd_dsql.init;
609: context_number NUMBER;
610:
611: BEGIN
612: IF (fnd_flex_server1.g_debug_level > 0) THEN
613: FND_FLEX_SERVER1.add_debug(fnd_global.newline ||
614: 'BEGIN SV4.read_segment_cols() ');
615: END IF;
616:
617: nsegs := 0;
754: vc_return NUMBER;
755:
756: BEGIN
757: IF (fnd_flex_server1.g_debug_level > 0) THEN
758: FND_FLEX_SERVER1.add_debug(fnd_global.newline ||
759: 'BEGIN SV4.get_desc_cols() ');
760: END IF;
761:
762: -- Initialize outputs to return nothing in case of error.
906: context_seg NUMBER;
907:
908: BEGIN
909: IF (fnd_flex_server1.g_debug_level > 0) THEN
910: FND_FLEX_SERVER1.add_debug(fnd_global.newline ||
911: 'BEGIN SV4.get_descsegs() ');
912: END IF;
913:
914: -- Initialize outputs in case of error.
997: niceval VARCHAR2(1000);
998:
999: BEGIN
1000: IF (fnd_flex_server1.g_debug_level > 0) THEN
1001: FND_FLEX_SERVER1.add_debug(fnd_global.newline ||
1002: 'BEGIN SV4.get_column_value() ');
1003: END IF;
1004:
1005: -- Find index to value in column value table.
1120: return_code NUMBER;
1121:
1122: BEGIN
1123: IF (fnd_flex_server1.g_debug_level > 0) THEN
1124: FND_FLEX_SERVER1.add_debug(fnd_global.newline ||
1125: 'BEGIN SV4.validate_descsegs() ');
1126: END IF;
1127:
1128: -- Initialize all returned values and all derived values with defaults
1390: l_errsegn NUMBER;
1391: l_ret_code NUMBER;
1392: BEGIN
1393: IF (fnd_flex_server1.g_debug_level > 0) THEN
1394: FND_FLEX_SERVER1.add_debug(fnd_global.newline ||
1395: 'BEGIN SV4.validate_context_segs() ');
1396: END IF;
1397:
1398:
1487: c_value FND_VSET.value_dr;
1488:
1489: BEGIN
1490: IF (fnd_flex_server1.g_debug_level > 0) THEN
1491: FND_FLEX_SERVER1.add_debug(fnd_global.newline ||
1492: 'BEGIN SV4.validate_context() ');
1493: END IF;
1494:
1495:
1647: n NUMBER;
1648:
1649: BEGIN
1650: IF (fnd_flex_server1.g_debug_level > 0) THEN
1651: FND_FLEX_SERVER1.add_debug(fnd_global.newline ||
1652: 'BEGIN SV4.append_vsegarray() ');
1653: END IF;
1654:
1655: n := destvsa.nvalidated;
1740: vcode VARCHAR2(1);
1741:
1742: BEGIN
1743: IF (fnd_flex_server1.g_debug_level > 0) THEN
1744: FND_FLEX_SERVER1.add_debug(fnd_global.newline ||
1745: 'BEGIN SV4.find_context_value(' ||
1746: p_id_or_value || ',' || seg_in ||') ');
1747: END IF;
1748:
1821: dflex_name IN VARCHAR2,
1822: glob_context OUT nocopy VARCHAR2) RETURN BOOLEAN IS
1823: BEGIN
1824: IF (fnd_flex_server1.g_debug_level > 0) THEN
1825: FND_FLEX_SERVER1.add_debug(fnd_global.newline ||
1826: 'BEGIN SV4.get_global_context() ');
1827: END IF;
1828:
1829: g_cache_key := appl_id || '.' || dflex_name;