45: l_value varchar2(1000);
46: l_lov_sql varchar2(32000);
47: l_callback_function varchar2(1000);
48: BEGIN
49: htp.htmlOpen;
50: htp.headOpen;
51: htp.title('Valid Values');
52:
53: if p_callback_function is null then
46: l_lov_sql varchar2(32000);
47: l_callback_function varchar2(1000);
48: BEGIN
49: htp.htmlOpen;
50: htp.headOpen;
51: htp.title('Valid Values');
52:
53: if p_callback_function is null then
54: l_callback_function := '';
47: l_callback_function varchar2(1000);
48: BEGIN
49: htp.htmlOpen;
50: htp.headOpen;
51: htp.title('Valid Values');
52:
53: if p_callback_function is null then
54: l_callback_function := '';
55: else
63: if (fp_id != "")
64: self.opener.document.'||p_form_name||'.'||p_param_id_field||'.value = fp_id; '||
65: l_callback_function||'
66: parent.self.close()}');
67: htp.print('');
68:
69: htp.headClose;
70: htp.bodyOpen;
71:
65: l_callback_function||'
66: parent.self.close()}');
67: htp.print('');
68:
69: htp.headClose;
70: htp.bodyOpen;
71:
72:
73: l_lov_sql := getLOVSQL(p_lov_type, p_filter, p_parameter1, p_parameter2, p_parameter3, p_parameter4, p_parameter5);
66: parent.self.close()}');
67: htp.print('');
68:
69: htp.headClose;
70: htp.bodyOpen;
71:
72:
73: l_lov_sql := getLOVSQL(p_lov_type, p_filter, p_parameter1, p_parameter2, p_parameter3, p_parameter4, p_parameter5);
74:
77: fetch c1 into l_id, l_value;
78: exit when c1%notfound;
79:
80: if (p_param_id_field is null) then
81: htp.print('');
82: else
83: htp.print('');
84: end if;
85: htp.print(l_value);
79:
80: if (p_param_id_field is null) then
81: htp.print('');
82: else
83: htp.print('');
84: end if;
85: htp.print(l_value);
86: htp.print('');
87: htp.br;
81: htp.print('');
82: else
83: htp.print('');
84: end if;
85: htp.print(l_value);
86: htp.print('');
87: htp.br;
88: end loop;
89:
82: else
83: htp.print('');
84: end if;
85: htp.print(l_value);
86: htp.print('');
87: htp.br;
88: end loop;
89:
90: close c1;
83: htp.print('');
84: end if;
85: htp.print(l_value);
86: htp.print('');
87: htp.br;
88: end loop;
89:
90: close c1;
91: htp.bodyClose;
87: htp.br;
88: end loop;
89:
90: close c1;
91: htp.bodyClose;
92: htp.htmlClose;
93:
94: END showLOV;
95:
88: end loop;
89:
90: close c1;
91: htp.bodyClose;
92: htp.htmlClose;
93:
94: END showLOV;
95:
96: FUNCTION getLOVSQL (p_lov_type in varchar2