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.GL_CHART_OF_ACCOUNTS_API_PKG dependencies on DUAL

Line 1416: FROM dual

1412: CURSOR c_check_value_attribute(v_character VARCHAR2,
1413: v_required_flag VARCHAR2,
1414: v_lookup_type VARCHAR2) IS
1415: SELECT v_character
1416: FROM dual
1417: WHERE v_character IN (SELECT lookup_code
1418: FROM FND_LOOKUPS
1419: WHERE lookup_type = v_lookup_type)
1420: OR (v_character = ' ' AND v_required_flag = 'N' );

Line 1489: -- 1. Each individual attribute value must be in the lookup table

1485: AND vat.segment_attribute_type = fvq.segment_attribute_type
1486: AND vat.value_attribute_type = fvq.value_attribute_type;
1487:
1488: --
1489: -- 1. Each individual attribute value must be in the lookup table
1490: -- or can be ' ' if it is not a required attribute.
1491: -- Each individual attribute value can also be null (Added on 03/05/01).
1492: --
1493: -- Added by ABHJOSHI on 03/31/05

Line 1491: -- Each individual attribute value can also be null (Added on 03/05/01).

1487:
1488: --
1489: -- 1. Each individual attribute value must be in the lookup table
1490: -- or can be ' ' if it is not a required attribute.
1491: -- Each individual attribute value can also be null (Added on 03/05/01).
1492: --
1493: -- Added by ABHJOSHI on 03/31/05
1494: -- Handling of the multi-character individual attribute value.
1495: --

Line 1494: -- Handling of the multi-character individual attribute value.

1490: -- or can be ' ' if it is not a required attribute.
1491: -- Each individual attribute value can also be null (Added on 03/05/01).
1492: --
1493: -- Added by ABHJOSHI on 03/31/05
1494: -- Handling of the multi-character individual attribute value.
1495: --
1496:
1497: v_compiled_value_attribute_s
1498: := v_compiled_value_attributes||FND_GLOBAL.newline;

Line 1510: -- Retrieve the individual attribute value from the compiled attribute value

1506: v_required_flag := v_cursor_attribute_type.required_flag;
1507: v_lookup_type := v_cursor_attribute_type.lookup_type;
1508: v_value_attribute_type := v_cursor_attribute_type.value_attribute_type;
1509:
1510: -- Retrieve the individual attribute value from the compiled attribute value
1511: -- Each individual attribute value can be null.
1512: -- Consequtive character (ASCII value 10) means a NULL value.
1513: -- Added by ABHJOSHI on 03/31/05
1514: --

Line 1511: -- Each individual attribute value can be null.

1507: v_lookup_type := v_cursor_attribute_type.lookup_type;
1508: v_value_attribute_type := v_cursor_attribute_type.value_attribute_type;
1509:
1510: -- Retrieve the individual attribute value from the compiled attribute value
1511: -- Each individual attribute value can be null.
1512: -- Consequtive character (ASCII value 10) means a NULL value.
1513: -- Added by ABHJOSHI on 03/31/05
1514: --
1515: IF (substrb(v_compiled_value_attribute_s,1,1) = FND_GLOBAL.newline) THEN

Line 1524: -- Each individual attribute value can be null.

1520: ,1
1521: ,instrb(v_compiled_value_attribute_s,FND_GLOBAL.newline,1)-1);
1522: END IF;
1523:
1524: -- Each individual attribute value can be null.
1525: IF (v_compiled_value_attribute_c IS NOT NULL) THEN
1526:
1527: -- Check if the individual attribute value is valid
1528: OPEN c_check_value_attribute(v_compiled_value_attribute_c,

Line 1527: -- Check if the individual attribute value is valid

1523:
1524: -- Each individual attribute value can be null.
1525: IF (v_compiled_value_attribute_c IS NOT NULL) THEN
1526:
1527: -- Check if the individual attribute value is valid
1528: OPEN c_check_value_attribute(v_compiled_value_attribute_c,
1529: v_required_flag,
1530: v_lookup_type);
1531: FETCH c_check_value_attribute

Line 1543: -- Individual attribute value should not contain

1539: END IF;
1540:
1541: END IF;
1542:
1543: -- Individual attribute value should not contain
1544: -- character (ASCII value 10)
1545: -- Otherwise will be treated as separate values
1546: v_compiled_value_attribute_s
1547: := substrb(v_compiled_value_attribute_s

Line 1553: -- 2. Each individual attribute must be separated from other

1549:
1550: END LOOP;
1551:
1552: --
1553: -- 2. Each individual attribute must be separated from other
1554: -- attributes with an character (ASCII value 10).
1555: -- Each individual attribute value can also be null (Added on 03/05/01).
1556: --
1557: -- Added by ABHJOSHI on 03/31/05

Line 1555: -- Each individual attribute value can also be null (Added on 03/05/01).

1551:
1552: --
1553: -- 2. Each individual attribute must be separated from other
1554: -- attributes with an character (ASCII value 10).
1555: -- Each individual attribute value can also be null (Added on 03/05/01).
1556: --
1557: -- Added by ABHJOSHI on 03/31/05
1558: -- This check has been modified alongwith the handling of the
1559: -- multi-character individual attribute value (code section 1),

Line 1559: -- multi-character individual attribute value (code section 1),

1555: -- Each individual attribute value can also be null (Added on 03/05/01).
1556: --
1557: -- Added by ABHJOSHI on 03/31/05
1558: -- This check has been modified alongwith the handling of the
1559: -- multi-character individual attribute value (code section 1),
1560: -- hence this code section has been removed and exception
1561: -- invalid_compiled_value_attr2 is no longer used.
1562:
1563: --