DBA Data[Home] [Help]

APPS.CN_ACC_PERIODS_PVT dependencies on GL_LOOKUPS

Line 6: TYPE str_tbl_type IS TABLE OF gl_lookups.meaning%TYPE INDEX BY BINARY_INTEGER;

2: /*$Header: cnvsyprb.pls 120.7 2006/02/28 04:42:05 vensrini noship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_ACC_PERIODS_PVT';
5:
6: TYPE str_tbl_type IS TABLE OF gl_lookups.meaning%TYPE INDEX BY BINARY_INTEGER;
7:
8: g_code_tbl str_tbl_type;
9: g_meaning_tbl str_tbl_type;
10:

Line 17: FUNCTION get_closing_status(p_closing_status_meaning gl_lookups.meaning%TYPE) RETURN gl_lookups.lookup_code%TYPE IS

13: SELECT lookup_code, meaning
14: FROM CN_lookups
15: WHERE lookup_type = 'PERIOD_CLOSING_STATUS';
16:
17: FUNCTION get_closing_status(p_closing_status_meaning gl_lookups.meaning%TYPE) RETURN gl_lookups.lookup_code%TYPE IS
18: BEGIN
19: -- FOR i IN 1..g_meaning_tbl.COUNT LOOP
20: -- IF (p_closing_status_meaning = g_meaning_tbl(i)) THEN
21: -- RETURN g_code_tbl(i);