1 Package OKL_UTIL AUTHID CURRENT_USER AS
2 /* $Header: OKLRUTLS.pls 120.2.12010000.2 2008/11/13 13:36:19 kkorrapo ship $ */
3
4 -------------------------
5 -- trace global variables
6 -------------------------
7 l_trace_path VARCHAR2(255);
8 l_trace_file UTL_FILE.FILE_TYPE;
9 l_trace_file_name VARCHAR2(255);
10 l_output_file UTL_FILE.FILE_TYPE;
11 l_output_file_name VARCHAR2(255);
12 l_trace_flag BOOLEAN:=FALSE;
13 l_log_flag BOOLEAN:=FALSE;
14 l_output_flag BOOLEAN:=FALSE;
15 l_request_id NUMBER;
16 l_program VARCHAR2(80);
17 l_module VARCHAR2(80);
18 l_complete_trace_file_name VARCHAR2(255);
19 l_complete_trace_file_name2 VARCHAR2(255);
20 -------------------------
21 -- standard trace constants
22 -------------------------
23 g_trc_trace_file_prefix CONSTANT VARCHAR2(30) := 'okl_';
24 g_trc_trace_file_suffix CONSTANT VARCHAR2(30) := '.trc';
25 ---------------------------------------------------------------------------
26 -- GLOBAL DATASTRUCTURES
27 ---------------------------------------------------------------------------
28 TYPE unq_rec_type IS RECORD (
29 p_col_name VARCHAR2(40),
30 p_col_val VARCHAR2(2000));
31 TYPE unq_tbl_type IS TABLE OF unq_rec_type
32 INDEX BY BINARY_INTEGER;
33 TYPE lenchk_rec_type IS RECORD (
34 VName VARCHAR2(30),
35 CName VARCHAR2(30),
36 CDType VARCHAR2(20),
37 CLength NUMBER,
38 CScale NUMBER);
39 TYPE lenchk_tbl_type IS TABLE OF lenchk_rec_type
40 INDEX BY BINARY_INTEGER;
41 -- Stores the languages that are currently defined in FND_LANGUAGES.
42 -- This table is populated by the anonymous block in the package body.
43 -- g_language_code OKL_Datatypes.Var12TabTyp;
44 -- g_lenchk_tbl lenchk_tbl_type;
45 ---------------------------------------------------------------------------
46 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_Api.G_APP_NAME;
47 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
48 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
49 G_EXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_VALUE_ERROR';
50 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_Api.G_COL_NAME_TOKEN;
51 G_VIEW_TOKEN CONSTANT VARCHAR2(200) := 'G_VIEW_TOKEN';
52 ---------------------------------------------------------------------------
53 --GLOBAL CONSTANT
54 ---------------------------------------------------------------------------
55
56
57
58 ----------------------------------------------------------------------------
59 --Get country FOR before active line
60 ----------------------------------------------------------------------------
61 FUNCTION get_preactive_line_inst(p_financial_line IN NUMBER)
62 RETURN VARCHAR2;
63 pragma restrict_references(get_preactive_line_inst, WNDS,WNPS,RNPS);
64
65 ----------------------------------------------------------------------------
66 -- --Get country FOR after active line
67 ----------------------------------------------------------------------------
68 FUNCTION get_active_line_inst_country(p_financial_line IN NUMBER)
69 RETURN VARCHAR2;
70 pragma restrict_references(get_active_line_inst_country, WNDS,WNPS,RNPS);
71
72 ----------------------------------------------------------------------------
73 --Check if valid code for a type in fnd lookup
74 ----------------------------------------------------------------------------
75 FUNCTION check_lookup_code(p_lookup_type IN VARCHAR2, p_lookup_code IN VARCHAR2)
76 RETURN VARCHAR2;
77 ----------------------------------------------------------------------------
78 --Check if valid value for a domain(Y/N)
79 ----------------------------------------------------------------------------
80 FUNCTION check_domain_yn(p_col_value IN VARCHAR2)
81 RETURN VARCHAR2;
82 ----------------------------------------------------------------------------
83 --Check if valid value for a domain(amount)
84 ----------------------------------------------------------------------------
85 FUNCTION check_domain_amount(p_col_value IN NUMBER)
86 RETURN VARCHAR2;
87 ----------------------------------------------------------------------------
88 --Check if valid value for date range
89 ----------------------------------------------------------------------------
90 FUNCTION check_from_to_date_range(p_from_date IN DATE,p_to_date IN DATE )
91 RETURN VARCHAR2;
92 ----------------------------------------------------------------------------
93 --Check if valid value for Number range
94 ----------------------------------------------------------------------------
95 FUNCTION check_from_to_number_range(p_from_number IN NUMBER ,p_to_number IN NUMBER )
96 RETURN VARCHAR2;
97 -------------------------------------------------------------------
98 FUNCTION check_org_id(p_org_id IN VARCHAR2,
99 p_null_allowed IN VARCHAR2 DEFAULT 'Y')
100 RETURN VARCHAR2;
101 -------------------------------------------------------------------
102 FUNCTION get_rec_status (p_start_date IN DATE, p_end_date IN DATE)
103 RETURN VARCHAR2;
104 pragma restrict_references(get_rec_status, WNDS,WNPS,RNPS);
105 ------------------------------------------------------------------------
106
107 --Bug 7022258-Added by kkorrapo
108 FUNCTION get_next_seq_num(
109 p_seq_name IN VARCHAR2,
110 p_table_name IN VARCHAR2,
111 p_col_name IN VARCHAR2)
112 RETURN VARCHAR2;
113
114 FUNCTION validate_seq_num(
115 p_seq_name IN VARCHAR2,
116 p_table_name IN VARCHAR2,
117 p_col_name IN VARCHAR2,
118 p_value IN VARCHAR2)
119 RETURN varchar2;
120 --Bug 7022258--Addition end
121 END OKL_UTIL;