DBA Data[Home] [Help]

APPS.BIS_DIM_LEVEL_VALUE_PVT dependencies on BIS_LEVELS_TL

Line 73: l_name bis_levels_tl.name%TYPE;

69: IS
70: --
71: l_view_name VARCHAR2(80);
72: l_short_name VARCHAR2(30);
73: l_name bis_levels_tl.name%TYPE;
74: l_cursor INTEGER;
75: l_ind NUMBER := 0;
76: l_id VARCHAR2(250);
77: l_value VARCHAR2(250);

Line 252: l_name bis_levels_tl.name%TYPE;

248: IS
249: --
250: l_view_name VARCHAR2(80);
251: l_short_name VARCHAR2(30);
252: l_name bis_levels_tl.name%TYPE;
253: l_cursor INTEGER;
254: l_ind NUMBER := 0;
255: l_id VARCHAR2(250);
256: l_value VARCHAR2(250);

Line 408: l_name bis_levels_tl.name%TYPE;

404: IS
405: --
406: l_view_name VARCHAR2(80);
407: l_short_name VARCHAR2(30);
408: l_name bis_levels_tl.name%TYPE;
409: l_cursor INTEGER;
410: l_ind NUMBER := 0;
411: l_id VARCHAR2(250);
412: l_value VARCHAR2(250);

Line 548: l_name bis_levels_tl.name%TYPE;

544: IS
545: --
546: l_view_name VARCHAR2(80);
547: l_short_name VARCHAR2(30);
548: l_name bis_levels_tl.name%TYPE;
549: l_cursor INTEGER;
550: l_ind NUMBER := 0;
551: l_id VARCHAR2(250);
552: l_value VARCHAR2(250);

Line 692: l_name bis_levels_tl.name%TYPE;

688: IS
689: --
690: l_view_name VARCHAR2(80);
691: l_short_name VARCHAR2(30);
692: l_name bis_levels_tl.name%TYPE;
693: l_cursor INTEGER := NULL;
694: l_ind NUMBER := 0;
695: l_period_set VARCHAR2(250);
696: l_id VARCHAR2(250) := NULL;

Line 1126: l_name bis_levels_tl.name%TYPE;

1122: IS
1123: --
1124: l_view_name VARCHAR2(80);
1125: l_short_name VARCHAR2(30);
1126: l_name bis_levels_tl.name%TYPE;
1127: l_id VARCHAR2(250);
1128: l_value VARCHAR2(250);
1129: l_select_stmt VARCHAR2(2000);
1130: --

Line 1227: l_name bis_levels_tl.name%TYPE;

1223: IS
1224: --
1225: l_view_name VARCHAR2(80);
1226: l_short_name VARCHAR2(30);
1227: l_name bis_levels_tl.name%TYPE;
1228: l_id VARCHAR2(80);
1229: l_value VARCHAR2(250);
1230: l_select_stmt VARCHAR2(2000);
1231: --

Line 1331: l_name bis_levels_tl.name%TYPE;

1327: IS
1328: --
1329: l_view_name VARCHAR2(80);
1330: l_short_name VARCHAR2(30);
1331: l_name bis_levels_tl.name%TYPE;
1332: l_period_set VARCHAR2(250);
1333: l_value VARCHAR2(250);
1334: l_select_stmt VARCHAR2(2000);
1335: --

Line 1454: l_name bis_levels_tl.name%TYPE;

1450: IS
1451: --
1452: l_view_name VARCHAR2(80);
1453: l_short_name VARCHAR2(30);
1454: l_name bis_levels_tl.name%TYPE;
1455: l_id VARCHAR2(80);
1456: l_value VARCHAR2(250);
1457: l_select_stmt VARCHAR2(2000);
1458: --

Line 1581: l_name bis_levels_tl.name%TYPE;

1577: IS
1578: --
1579: l_view_name VARCHAR2(80);
1580: l_short_name VARCHAR2(30);
1581: l_name bis_levels_tl.name%TYPE;
1582: l_cursor INTEGER;
1583: l_id VARCHAR2(250);
1584: l_value VARCHAR2(2000);
1585: l_select_stmt VARCHAR2(2000);

Line 1587: l_description bis_levels_tl.description%TYPE;

1583: l_id VARCHAR2(250);
1584: l_value VARCHAR2(2000);
1585: l_select_stmt VARCHAR2(2000);
1586: l_sql_result INTEGER := 0;
1587: l_description bis_levels_tl.description%TYPE;
1588: l_id_name VARCHAR(2000);
1589: l_value_name VARCHAR(2000);
1590: l_msg_count NUMBER;
1591: l_msg_data VARCHAR(32000);

Line 1734: l_name bis_levels_tl.name%TYPE;

1730: IS
1731: --
1732: l_view_name VARCHAR2(80);
1733: l_short_name VARCHAR2(30);
1734: l_name bis_levels_tl.name%TYPE;
1735: l_cursor INTEGER;
1736: l_id VARCHAR2(80);
1737: l_value VARCHAR2(250);
1738: l_select_stmt VARCHAR2(2000);

Line 1840: l_name bis_levels_tl.name%TYPE;

1836: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1837:
1838: l_view_name VARCHAR2(80);
1839: l_short_name VARCHAR2(30);
1840: l_name bis_levels_tl.name%TYPE;
1841: l_cursor INTEGER;
1842: l_id VARCHAR2(250);
1843: l_value VARCHAR2(250);
1844: l_select_stmt VARCHAR2(2000);

Line 1846: l_description bis_levels_tl.description%TYPE;

1842: l_id VARCHAR2(250);
1843: l_value VARCHAR2(250);
1844: l_select_stmt VARCHAR2(2000);
1845: l_sql_result INTEGER := 0;
1846: l_description bis_levels_tl.description%TYPE;
1847: l_return_status VARCHAR2(240);
1848: l_id_name VARCHAR(2000);
1849: l_value_name VARCHAR(2000);
1850: l_msg_count NUMBER;

Line 1977: l_name bis_levels_tl.name%TYPE;

1973: --l_period_set_name VARCHAR2(32000);
1974:
1975: l_view_name VARCHAR2(80);
1976: l_short_name VARCHAR2(30);
1977: l_name bis_levels_tl.name%TYPE;
1978: l_cursor INTEGER;
1979: l_id VARCHAR2(250);
1980: l_value VARCHAR2(250);
1981: l_select_stmt VARCHAR2(2000);

Line 1983: l_description bis_levels_tl.description%TYPE;

1979: l_id VARCHAR2(250);
1980: l_value VARCHAR2(250);
1981: l_select_stmt VARCHAR2(2000);
1982: l_sql_result INTEGER := 0;
1983: l_description bis_levels_tl.description%TYPE;
1984: l_return_status VARCHAR2(240);
1985: l_id_name VARCHAR(2000);
1986: l_value_name VARCHAR(2000);
1987: l_msg_count NUMBER;