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.FND_DSQL dependencies on FND_DSQL

Line 1: PACKAGE BODY fnd_dsql AS

1: PACKAGE BODY fnd_dsql AS
2: /* $Header: AFUTSQLB.pls 120.1.12010000.1 2008/07/25 14:23:37 appldev ship $ */
3:
4:
5: TYPE VARCHAR2_TBL_TYPE IS VARRAY(100) OF VARCHAR2(2000);

Line 23: g_package_name VARCHAR2(30) := 'fnd_dsql';

19: g_bind_dtbl DATE_TBL_TYPE; -- date type bind values
20: g_bind_ntbl NUMBER_TBL_TYPE; -- number type bind values
21:
22: chr_newline VARCHAR2(8);
23: g_package_name VARCHAR2(30) := 'fnd_dsql';
24:
25: -- ======================================================================
26: -- Utility Functions
27: -- ======================================================================

Line 43: fnd_dsql.g_dsql_text := NULL;

39: -- ======================================================================
40: PROCEDURE init
41: IS
42: BEGIN
43: fnd_dsql.g_dsql_text := NULL;
44: fnd_dsql.g_cursor_id := NULL;
45: fnd_dsql.g_nbinds := 0;
46: EXCEPTION
47: WHEN OTHERS THEN

Line 44: fnd_dsql.g_cursor_id := NULL;

40: PROCEDURE init
41: IS
42: BEGIN
43: fnd_dsql.g_dsql_text := NULL;
44: fnd_dsql.g_cursor_id := NULL;
45: fnd_dsql.g_nbinds := 0;
46: EXCEPTION
47: WHEN OTHERS THEN
48: report_error(g_package_name || '.init' , Sqlerrm);

Line 45: fnd_dsql.g_nbinds := 0;

41: IS
42: BEGIN
43: fnd_dsql.g_dsql_text := NULL;
44: fnd_dsql.g_cursor_id := NULL;
45: fnd_dsql.g_nbinds := 0;
46: EXCEPTION
47: WHEN OTHERS THEN
48: report_error(g_package_name || '.init' , Sqlerrm);
49: RAISE;

Line 55: fnd_dsql.g_dsql_text := fnd_dsql.g_dsql_text || p_text;

51:
52:
53: PROCEDURE add_text(p_text IN VARCHAR2) IS
54: BEGIN
55: fnd_dsql.g_dsql_text := fnd_dsql.g_dsql_text || p_text;
56: EXCEPTION
57: WHEN OTHERS THEN
58: report_error(g_package_name || '.add_text()', Sqlerrm);
59: RAISE;

Line 66: fnd_dsql.g_nbinds := fnd_dsql.g_nbinds + 1;

62:
63: PROCEDURE add_bind(p_value IN VARCHAR2)
64: IS
65: BEGIN
66: fnd_dsql.g_nbinds := fnd_dsql.g_nbinds + 1;
67:
68: fnd_dsql.g_bind_ttbl(fnd_dsql.g_nbinds) := 'C';
69: fnd_dsql.g_bind_vtbl(fnd_dsql.g_nbinds) := p_value;
70:

Line 68: fnd_dsql.g_bind_ttbl(fnd_dsql.g_nbinds) := 'C';

64: IS
65: BEGIN
66: fnd_dsql.g_nbinds := fnd_dsql.g_nbinds + 1;
67:
68: fnd_dsql.g_bind_ttbl(fnd_dsql.g_nbinds) := 'C';
69: fnd_dsql.g_bind_vtbl(fnd_dsql.g_nbinds) := p_value;
70:
71: fnd_dsql.g_dsql_text := (fnd_dsql.g_dsql_text ||
72: ':FND_BIND' || To_char(fnd_dsql.g_nbinds));

Line 69: fnd_dsql.g_bind_vtbl(fnd_dsql.g_nbinds) := p_value;

65: BEGIN
66: fnd_dsql.g_nbinds := fnd_dsql.g_nbinds + 1;
67:
68: fnd_dsql.g_bind_ttbl(fnd_dsql.g_nbinds) := 'C';
69: fnd_dsql.g_bind_vtbl(fnd_dsql.g_nbinds) := p_value;
70:
71: fnd_dsql.g_dsql_text := (fnd_dsql.g_dsql_text ||
72: ':FND_BIND' || To_char(fnd_dsql.g_nbinds));
73: EXCEPTION

Line 71: fnd_dsql.g_dsql_text := (fnd_dsql.g_dsql_text ||

67:
68: fnd_dsql.g_bind_ttbl(fnd_dsql.g_nbinds) := 'C';
69: fnd_dsql.g_bind_vtbl(fnd_dsql.g_nbinds) := p_value;
70:
71: fnd_dsql.g_dsql_text := (fnd_dsql.g_dsql_text ||
72: ':FND_BIND' || To_char(fnd_dsql.g_nbinds));
73: EXCEPTION
74: WHEN OTHERS THEN
75: report_error(g_package_name || '.add_bind(VARCHAR2)', Sqlerrm);

Line 72: ':FND_BIND' || To_char(fnd_dsql.g_nbinds));

68: fnd_dsql.g_bind_ttbl(fnd_dsql.g_nbinds) := 'C';
69: fnd_dsql.g_bind_vtbl(fnd_dsql.g_nbinds) := p_value;
70:
71: fnd_dsql.g_dsql_text := (fnd_dsql.g_dsql_text ||
72: ':FND_BIND' || To_char(fnd_dsql.g_nbinds));
73: EXCEPTION
74: WHEN OTHERS THEN
75: report_error(g_package_name || '.add_bind(VARCHAR2)', Sqlerrm);
76: RAISE;

Line 83: fnd_dsql.g_nbinds := fnd_dsql.g_nbinds + 1;

79:
80: PROCEDURE add_bind(p_value IN DATE)
81: IS
82: BEGIN
83: fnd_dsql.g_nbinds := fnd_dsql.g_nbinds + 1;
84:
85: fnd_dsql.g_bind_ttbl(fnd_dsql.g_nbinds) := 'D';
86: fnd_dsql.g_bind_dtbl(fnd_dsql.g_nbinds) := p_value;
87:

Line 85: fnd_dsql.g_bind_ttbl(fnd_dsql.g_nbinds) := 'D';

81: IS
82: BEGIN
83: fnd_dsql.g_nbinds := fnd_dsql.g_nbinds + 1;
84:
85: fnd_dsql.g_bind_ttbl(fnd_dsql.g_nbinds) := 'D';
86: fnd_dsql.g_bind_dtbl(fnd_dsql.g_nbinds) := p_value;
87:
88: fnd_dsql.g_dsql_text := (fnd_dsql.g_dsql_text ||
89: ':FND_BIND' || To_char(fnd_dsql.g_nbinds));

Line 86: fnd_dsql.g_bind_dtbl(fnd_dsql.g_nbinds) := p_value;

82: BEGIN
83: fnd_dsql.g_nbinds := fnd_dsql.g_nbinds + 1;
84:
85: fnd_dsql.g_bind_ttbl(fnd_dsql.g_nbinds) := 'D';
86: fnd_dsql.g_bind_dtbl(fnd_dsql.g_nbinds) := p_value;
87:
88: fnd_dsql.g_dsql_text := (fnd_dsql.g_dsql_text ||
89: ':FND_BIND' || To_char(fnd_dsql.g_nbinds));
90: EXCEPTION

Line 88: fnd_dsql.g_dsql_text := (fnd_dsql.g_dsql_text ||

84:
85: fnd_dsql.g_bind_ttbl(fnd_dsql.g_nbinds) := 'D';
86: fnd_dsql.g_bind_dtbl(fnd_dsql.g_nbinds) := p_value;
87:
88: fnd_dsql.g_dsql_text := (fnd_dsql.g_dsql_text ||
89: ':FND_BIND' || To_char(fnd_dsql.g_nbinds));
90: EXCEPTION
91: WHEN OTHERS THEN
92: report_error(g_package_name || '.add_bind(DATE)', Sqlerrm);

Line 89: ':FND_BIND' || To_char(fnd_dsql.g_nbinds));

85: fnd_dsql.g_bind_ttbl(fnd_dsql.g_nbinds) := 'D';
86: fnd_dsql.g_bind_dtbl(fnd_dsql.g_nbinds) := p_value;
87:
88: fnd_dsql.g_dsql_text := (fnd_dsql.g_dsql_text ||
89: ':FND_BIND' || To_char(fnd_dsql.g_nbinds));
90: EXCEPTION
91: WHEN OTHERS THEN
92: report_error(g_package_name || '.add_bind(DATE)', Sqlerrm);
93: RAISE;

Line 99: fnd_dsql.g_nbinds := fnd_dsql.g_nbinds + 1;

95:
96: PROCEDURE add_bind(p_value IN NUMBER)
97: IS
98: BEGIN
99: fnd_dsql.g_nbinds := fnd_dsql.g_nbinds + 1;
100:
101: fnd_dsql.g_bind_ttbl(fnd_dsql.g_nbinds) := 'N';
102: fnd_dsql.g_bind_ntbl(fnd_dsql.g_nbinds) := p_value;
103:

Line 101: fnd_dsql.g_bind_ttbl(fnd_dsql.g_nbinds) := 'N';

97: IS
98: BEGIN
99: fnd_dsql.g_nbinds := fnd_dsql.g_nbinds + 1;
100:
101: fnd_dsql.g_bind_ttbl(fnd_dsql.g_nbinds) := 'N';
102: fnd_dsql.g_bind_ntbl(fnd_dsql.g_nbinds) := p_value;
103:
104: fnd_dsql.g_dsql_text := (fnd_dsql.g_dsql_text ||
105: ':FND_BIND' || To_char(fnd_dsql.g_nbinds));

Line 102: fnd_dsql.g_bind_ntbl(fnd_dsql.g_nbinds) := p_value;

98: BEGIN
99: fnd_dsql.g_nbinds := fnd_dsql.g_nbinds + 1;
100:
101: fnd_dsql.g_bind_ttbl(fnd_dsql.g_nbinds) := 'N';
102: fnd_dsql.g_bind_ntbl(fnd_dsql.g_nbinds) := p_value;
103:
104: fnd_dsql.g_dsql_text := (fnd_dsql.g_dsql_text ||
105: ':FND_BIND' || To_char(fnd_dsql.g_nbinds));
106: EXCEPTION

Line 104: fnd_dsql.g_dsql_text := (fnd_dsql.g_dsql_text ||

100:
101: fnd_dsql.g_bind_ttbl(fnd_dsql.g_nbinds) := 'N';
102: fnd_dsql.g_bind_ntbl(fnd_dsql.g_nbinds) := p_value;
103:
104: fnd_dsql.g_dsql_text := (fnd_dsql.g_dsql_text ||
105: ':FND_BIND' || To_char(fnd_dsql.g_nbinds));
106: EXCEPTION
107: WHEN OTHERS THEN
108: report_error(g_package_name || '.add_bind(NUMBER)', Sqlerrm);

Line 105: ':FND_BIND' || To_char(fnd_dsql.g_nbinds));

101: fnd_dsql.g_bind_ttbl(fnd_dsql.g_nbinds) := 'N';
102: fnd_dsql.g_bind_ntbl(fnd_dsql.g_nbinds) := p_value;
103:
104: fnd_dsql.g_dsql_text := (fnd_dsql.g_dsql_text ||
105: ':FND_BIND' || To_char(fnd_dsql.g_nbinds));
106: EXCEPTION
107: WHEN OTHERS THEN
108: report_error(g_package_name || '.add_bind(NUMBER)', Sqlerrm);
109: RAISE;

Line 116: fnd_dsql.g_cursor_id := p_cursor_id;

112:
113: PROCEDURE set_cursor(p_cursor_id IN INTEGER)
114: IS
115: BEGIN
116: fnd_dsql.g_cursor_id := p_cursor_id;
117: EXCEPTION
118: WHEN OTHERS THEN
119: report_error(g_package_name || '.set_cursor_id()', Sqlerrm);
120: RAISE;

Line 126: FOR i IN 1..fnd_dsql.g_nbinds LOOP

122:
123: PROCEDURE do_binds
124: IS
125: BEGIN
126: FOR i IN 1..fnd_dsql.g_nbinds LOOP
127: IF (fnd_dsql.g_bind_ttbl(i) = 'D') THEN
128: dbms_sql.bind_variable(fnd_dsql.g_cursor_id,
129: ':FND_BIND' || To_char(i),
130: fnd_dsql.g_bind_dtbl(i));

Line 127: IF (fnd_dsql.g_bind_ttbl(i) = 'D') THEN

123: PROCEDURE do_binds
124: IS
125: BEGIN
126: FOR i IN 1..fnd_dsql.g_nbinds LOOP
127: IF (fnd_dsql.g_bind_ttbl(i) = 'D') THEN
128: dbms_sql.bind_variable(fnd_dsql.g_cursor_id,
129: ':FND_BIND' || To_char(i),
130: fnd_dsql.g_bind_dtbl(i));
131: ELSIF (fnd_dsql.g_bind_ttbl(i) = 'N') THEN

Line 128: dbms_sql.bind_variable(fnd_dsql.g_cursor_id,

124: IS
125: BEGIN
126: FOR i IN 1..fnd_dsql.g_nbinds LOOP
127: IF (fnd_dsql.g_bind_ttbl(i) = 'D') THEN
128: dbms_sql.bind_variable(fnd_dsql.g_cursor_id,
129: ':FND_BIND' || To_char(i),
130: fnd_dsql.g_bind_dtbl(i));
131: ELSIF (fnd_dsql.g_bind_ttbl(i) = 'N') THEN
132: dbms_sql.bind_variable(fnd_dsql.g_cursor_id,

Line 130: fnd_dsql.g_bind_dtbl(i));

126: FOR i IN 1..fnd_dsql.g_nbinds LOOP
127: IF (fnd_dsql.g_bind_ttbl(i) = 'D') THEN
128: dbms_sql.bind_variable(fnd_dsql.g_cursor_id,
129: ':FND_BIND' || To_char(i),
130: fnd_dsql.g_bind_dtbl(i));
131: ELSIF (fnd_dsql.g_bind_ttbl(i) = 'N') THEN
132: dbms_sql.bind_variable(fnd_dsql.g_cursor_id,
133: ':FND_BIND' || To_char(i),
134: fnd_dsql.g_bind_ntbl(i));

Line 131: ELSIF (fnd_dsql.g_bind_ttbl(i) = 'N') THEN

127: IF (fnd_dsql.g_bind_ttbl(i) = 'D') THEN
128: dbms_sql.bind_variable(fnd_dsql.g_cursor_id,
129: ':FND_BIND' || To_char(i),
130: fnd_dsql.g_bind_dtbl(i));
131: ELSIF (fnd_dsql.g_bind_ttbl(i) = 'N') THEN
132: dbms_sql.bind_variable(fnd_dsql.g_cursor_id,
133: ':FND_BIND' || To_char(i),
134: fnd_dsql.g_bind_ntbl(i));
135: ELSE

Line 132: dbms_sql.bind_variable(fnd_dsql.g_cursor_id,

128: dbms_sql.bind_variable(fnd_dsql.g_cursor_id,
129: ':FND_BIND' || To_char(i),
130: fnd_dsql.g_bind_dtbl(i));
131: ELSIF (fnd_dsql.g_bind_ttbl(i) = 'N') THEN
132: dbms_sql.bind_variable(fnd_dsql.g_cursor_id,
133: ':FND_BIND' || To_char(i),
134: fnd_dsql.g_bind_ntbl(i));
135: ELSE
136: dbms_sql.bind_variable(fnd_dsql.g_cursor_id,

Line 134: fnd_dsql.g_bind_ntbl(i));

130: fnd_dsql.g_bind_dtbl(i));
131: ELSIF (fnd_dsql.g_bind_ttbl(i) = 'N') THEN
132: dbms_sql.bind_variable(fnd_dsql.g_cursor_id,
133: ':FND_BIND' || To_char(i),
134: fnd_dsql.g_bind_ntbl(i));
135: ELSE
136: dbms_sql.bind_variable(fnd_dsql.g_cursor_id,
137: ':FND_BIND' || To_char(i),
138: fnd_dsql.g_bind_vtbl(i));

Line 136: dbms_sql.bind_variable(fnd_dsql.g_cursor_id,

132: dbms_sql.bind_variable(fnd_dsql.g_cursor_id,
133: ':FND_BIND' || To_char(i),
134: fnd_dsql.g_bind_ntbl(i));
135: ELSE
136: dbms_sql.bind_variable(fnd_dsql.g_cursor_id,
137: ':FND_BIND' || To_char(i),
138: fnd_dsql.g_bind_vtbl(i));
139: END IF;
140: END LOOP;

Line 138: fnd_dsql.g_bind_vtbl(i));

134: fnd_dsql.g_bind_ntbl(i));
135: ELSE
136: dbms_sql.bind_variable(fnd_dsql.g_cursor_id,
137: ':FND_BIND' || To_char(i),
138: fnd_dsql.g_bind_vtbl(i));
139: END IF;
140: END LOOP;
141: EXCEPTION
142: WHEN OTHERS THEN

Line 153: l_return := Rtrim(Ltrim(fnd_dsql.g_dsql_text));

149: RETURN VARCHAR2
150: IS
151: l_return VARCHAR2(32000);
152: BEGIN
153: l_return := Rtrim(Ltrim(fnd_dsql.g_dsql_text));
154: IF (p_with_debug) THEN
155: l_return := l_return || chr_newline;
156: FOR i IN 1..fnd_dsql.g_nbinds LOOP
157: l_return := (l_return || fnd_dsql.g_bind_ttbl(i) ||

Line 156: FOR i IN 1..fnd_dsql.g_nbinds LOOP

152: BEGIN
153: l_return := Rtrim(Ltrim(fnd_dsql.g_dsql_text));
154: IF (p_with_debug) THEN
155: l_return := l_return || chr_newline;
156: FOR i IN 1..fnd_dsql.g_nbinds LOOP
157: l_return := (l_return || fnd_dsql.g_bind_ttbl(i) ||
158: ':FND_BIND' || To_char(i) || '=' );
159: IF (fnd_dsql.g_bind_ttbl(i) = 'D') THEN
160: l_return := l_return || To_char(fnd_dsql.g_bind_dtbl(i),

Line 157: l_return := (l_return || fnd_dsql.g_bind_ttbl(i) ||

153: l_return := Rtrim(Ltrim(fnd_dsql.g_dsql_text));
154: IF (p_with_debug) THEN
155: l_return := l_return || chr_newline;
156: FOR i IN 1..fnd_dsql.g_nbinds LOOP
157: l_return := (l_return || fnd_dsql.g_bind_ttbl(i) ||
158: ':FND_BIND' || To_char(i) || '=' );
159: IF (fnd_dsql.g_bind_ttbl(i) = 'D') THEN
160: l_return := l_return || To_char(fnd_dsql.g_bind_dtbl(i),
161: 'YYYY/MM/DD HH24:MI:SS');

Line 159: IF (fnd_dsql.g_bind_ttbl(i) = 'D') THEN

155: l_return := l_return || chr_newline;
156: FOR i IN 1..fnd_dsql.g_nbinds LOOP
157: l_return := (l_return || fnd_dsql.g_bind_ttbl(i) ||
158: ':FND_BIND' || To_char(i) || '=' );
159: IF (fnd_dsql.g_bind_ttbl(i) = 'D') THEN
160: l_return := l_return || To_char(fnd_dsql.g_bind_dtbl(i),
161: 'YYYY/MM/DD HH24:MI:SS');
162: ELSIF (fnd_dsql.g_bind_ttbl(i) = 'N') THEN
163: l_return := l_return || fnd_dsql.g_bind_ntbl(i);

Line 160: l_return := l_return || To_char(fnd_dsql.g_bind_dtbl(i),

156: FOR i IN 1..fnd_dsql.g_nbinds LOOP
157: l_return := (l_return || fnd_dsql.g_bind_ttbl(i) ||
158: ':FND_BIND' || To_char(i) || '=' );
159: IF (fnd_dsql.g_bind_ttbl(i) = 'D') THEN
160: l_return := l_return || To_char(fnd_dsql.g_bind_dtbl(i),
161: 'YYYY/MM/DD HH24:MI:SS');
162: ELSIF (fnd_dsql.g_bind_ttbl(i) = 'N') THEN
163: l_return := l_return || fnd_dsql.g_bind_ntbl(i);
164: ELSE

Line 162: ELSIF (fnd_dsql.g_bind_ttbl(i) = 'N') THEN

158: ':FND_BIND' || To_char(i) || '=' );
159: IF (fnd_dsql.g_bind_ttbl(i) = 'D') THEN
160: l_return := l_return || To_char(fnd_dsql.g_bind_dtbl(i),
161: 'YYYY/MM/DD HH24:MI:SS');
162: ELSIF (fnd_dsql.g_bind_ttbl(i) = 'N') THEN
163: l_return := l_return || fnd_dsql.g_bind_ntbl(i);
164: ELSE
165: l_return := l_return || fnd_dsql.g_bind_vtbl(i);
166: END IF;

Line 163: l_return := l_return || fnd_dsql.g_bind_ntbl(i);

159: IF (fnd_dsql.g_bind_ttbl(i) = 'D') THEN
160: l_return := l_return || To_char(fnd_dsql.g_bind_dtbl(i),
161: 'YYYY/MM/DD HH24:MI:SS');
162: ELSIF (fnd_dsql.g_bind_ttbl(i) = 'N') THEN
163: l_return := l_return || fnd_dsql.g_bind_ntbl(i);
164: ELSE
165: l_return := l_return || fnd_dsql.g_bind_vtbl(i);
166: END IF;
167: l_return := l_return || chr_newline;

Line 165: l_return := l_return || fnd_dsql.g_bind_vtbl(i);

161: 'YYYY/MM/DD HH24:MI:SS');
162: ELSIF (fnd_dsql.g_bind_ttbl(i) = 'N') THEN
163: l_return := l_return || fnd_dsql.g_bind_ntbl(i);
164: ELSE
165: l_return := l_return || fnd_dsql.g_bind_vtbl(i);
166: END IF;
167: l_return := l_return || chr_newline;
168: END LOOP;
169: END IF;

Line 199: PROCEDURE fnd_dsql_test

195: WHEN OTHERS THEN
196: NULL;
197: END dbms_debug;
198:
199: PROCEDURE fnd_dsql_test
200: IS
201: i INTEGER;
202: m INTEGER;
203: l_dsql VARCHAR2(32000);

Line 206: fnd_dsql.init;

202: m INTEGER;
203: l_dsql VARCHAR2(32000);
204: l_debug VARCHAR2(32000);
205: BEGIN
206: fnd_dsql.init;
207: fnd_dsql.add_text('Start:' || chr_newline);
208: i := 0;
209: LOOP
210: i := i + 1;

Line 207: fnd_dsql.add_text('Start:' || chr_newline);

203: l_dsql VARCHAR2(32000);
204: l_debug VARCHAR2(32000);
205: BEGIN
206: fnd_dsql.init;
207: fnd_dsql.add_text('Start:' || chr_newline);
208: i := 0;
209: LOOP
210: i := i + 1;
211: IF i > g_maximum_varray_size THEN

Line 215: fnd_dsql.add_text(' i:' || To_char(i));

211: IF i > g_maximum_varray_size THEN
212: EXIT;
213: END IF;
214: m := MOD(i,3);
215: fnd_dsql.add_text(' i:' || To_char(i));
216: IF m = 0 THEN
217: fnd_dsql.add_text('varchar2=');
218: fnd_dsql.add_bind('test' || To_char(i));
219: ELSIF m = 1 THEN

Line 217: fnd_dsql.add_text('varchar2=');

213: END IF;
214: m := MOD(i,3);
215: fnd_dsql.add_text(' i:' || To_char(i));
216: IF m = 0 THEN
217: fnd_dsql.add_text('varchar2=');
218: fnd_dsql.add_bind('test' || To_char(i));
219: ELSIF m = 1 THEN
220: fnd_dsql.add_text('date=');
221: fnd_dsql.add_bind(Sysdate);

Line 218: fnd_dsql.add_bind('test' || To_char(i));

214: m := MOD(i,3);
215: fnd_dsql.add_text(' i:' || To_char(i));
216: IF m = 0 THEN
217: fnd_dsql.add_text('varchar2=');
218: fnd_dsql.add_bind('test' || To_char(i));
219: ELSIF m = 1 THEN
220: fnd_dsql.add_text('date=');
221: fnd_dsql.add_bind(Sysdate);
222: ELSE

Line 220: fnd_dsql.add_text('date=');

216: IF m = 0 THEN
217: fnd_dsql.add_text('varchar2=');
218: fnd_dsql.add_bind('test' || To_char(i));
219: ELSIF m = 1 THEN
220: fnd_dsql.add_text('date=');
221: fnd_dsql.add_bind(Sysdate);
222: ELSE
223: fnd_dsql.add_text('number=');
224: fnd_dsql.add_bind(i);

Line 221: fnd_dsql.add_bind(Sysdate);

217: fnd_dsql.add_text('varchar2=');
218: fnd_dsql.add_bind('test' || To_char(i));
219: ELSIF m = 1 THEN
220: fnd_dsql.add_text('date=');
221: fnd_dsql.add_bind(Sysdate);
222: ELSE
223: fnd_dsql.add_text('number=');
224: fnd_dsql.add_bind(i);
225: END IF;

Line 223: fnd_dsql.add_text('number=');

219: ELSIF m = 1 THEN
220: fnd_dsql.add_text('date=');
221: fnd_dsql.add_bind(Sysdate);
222: ELSE
223: fnd_dsql.add_text('number=');
224: fnd_dsql.add_bind(i);
225: END IF;
226: END LOOP;
227: l_dsql := fnd_dsql.get_text;

Line 224: fnd_dsql.add_bind(i);

220: fnd_dsql.add_text('date=');
221: fnd_dsql.add_bind(Sysdate);
222: ELSE
223: fnd_dsql.add_text('number=');
224: fnd_dsql.add_bind(i);
225: END IF;
226: END LOOP;
227: l_dsql := fnd_dsql.get_text;
228: l_debug := fnd_dsql.get_text(TRUE);

Line 227: l_dsql := fnd_dsql.get_text;

223: fnd_dsql.add_text('number=');
224: fnd_dsql.add_bind(i);
225: END IF;
226: END LOOP;
227: l_dsql := fnd_dsql.get_text;
228: l_debug := fnd_dsql.get_text(TRUE);
229: dbms_debug(l_dsql);
230: dbms_debug(l_debug);
231: EXCEPTION

Line 228: l_debug := fnd_dsql.get_text(TRUE);

224: fnd_dsql.add_bind(i);
225: END IF;
226: END LOOP;
227: l_dsql := fnd_dsql.get_text;
228: l_debug := fnd_dsql.get_text(TRUE);
229: dbms_debug(l_dsql);
230: dbms_debug(l_debug);
231: EXCEPTION
232: WHEN OTHERS THEN

Line 237: END fnd_dsql_test;

233: l_dsql := 'SQLERRM:' || Sqlerrm;
234: l_debug := 'i:' || To_char(i) || ' ' || fnd_message.get;
235: dbms_debug(l_dsql);
236: dbms_debug(l_debug);
237: END fnd_dsql_test;
238:
239:
240: --
241: -- Package Initialization.

Line 244: fnd_dsql.chr_newline := fnd_global.newline;

240: --
241: -- Package Initialization.
242: --
243: BEGIN
244: fnd_dsql.chr_newline := fnd_global.newline;
245: fnd_dsql.g_dsql_text := NULL;
246: fnd_dsql.g_cursor_id := NULL;
247: fnd_dsql.g_nbinds := 0;
248:

Line 245: fnd_dsql.g_dsql_text := NULL;

241: -- Package Initialization.
242: --
243: BEGIN
244: fnd_dsql.chr_newline := fnd_global.newline;
245: fnd_dsql.g_dsql_text := NULL;
246: fnd_dsql.g_cursor_id := NULL;
247: fnd_dsql.g_nbinds := 0;
248:
249: --

Line 246: fnd_dsql.g_cursor_id := NULL;

242: --
243: BEGIN
244: fnd_dsql.chr_newline := fnd_global.newline;
245: fnd_dsql.g_dsql_text := NULL;
246: fnd_dsql.g_cursor_id := NULL;
247: fnd_dsql.g_nbinds := 0;
248:
249: --
250: -- Call varray constructors. Otherwise it gives

Line 247: fnd_dsql.g_nbinds := 0;

243: BEGIN
244: fnd_dsql.chr_newline := fnd_global.newline;
245: fnd_dsql.g_dsql_text := NULL;
246: fnd_dsql.g_cursor_id := NULL;
247: fnd_dsql.g_nbinds := 0;
248:
249: --
250: -- Call varray constructors. Otherwise it gives
251: -- ORA-06531: Reference to uninitialized collection

Line 253: fnd_dsql.g_bind_ttbl := varchar2_tbl_type();

249: --
250: -- Call varray constructors. Otherwise it gives
251: -- ORA-06531: Reference to uninitialized collection
252: --
253: fnd_dsql.g_bind_ttbl := varchar2_tbl_type();
254: fnd_dsql.g_bind_vtbl := varchar2_tbl_type();
255: fnd_dsql.g_bind_dtbl := date_tbl_type();
256: fnd_dsql.g_bind_ntbl := number_tbl_type();
257:

Line 254: fnd_dsql.g_bind_vtbl := varchar2_tbl_type();

250: -- Call varray constructors. Otherwise it gives
251: -- ORA-06531: Reference to uninitialized collection
252: --
253: fnd_dsql.g_bind_ttbl := varchar2_tbl_type();
254: fnd_dsql.g_bind_vtbl := varchar2_tbl_type();
255: fnd_dsql.g_bind_dtbl := date_tbl_type();
256: fnd_dsql.g_bind_ntbl := number_tbl_type();
257:
258: --

Line 255: fnd_dsql.g_bind_dtbl := date_tbl_type();

251: -- ORA-06531: Reference to uninitialized collection
252: --
253: fnd_dsql.g_bind_ttbl := varchar2_tbl_type();
254: fnd_dsql.g_bind_vtbl := varchar2_tbl_type();
255: fnd_dsql.g_bind_dtbl := date_tbl_type();
256: fnd_dsql.g_bind_ntbl := number_tbl_type();
257:
258: --
259: -- Extend the varrays. Otherwise it gives

Line 256: fnd_dsql.g_bind_ntbl := number_tbl_type();

252: --
253: fnd_dsql.g_bind_ttbl := varchar2_tbl_type();
254: fnd_dsql.g_bind_vtbl := varchar2_tbl_type();
255: fnd_dsql.g_bind_dtbl := date_tbl_type();
256: fnd_dsql.g_bind_ntbl := number_tbl_type();
257:
258: --
259: -- Extend the varrays. Otherwise it gives
260: -- ORA-06533: Subscript beyond count

Line 262: fnd_dsql.g_bind_ttbl.EXTEND(g_maximum_varray_size);

258: --
259: -- Extend the varrays. Otherwise it gives
260: -- ORA-06533: Subscript beyond count
261: --
262: fnd_dsql.g_bind_ttbl.EXTEND(g_maximum_varray_size);
263: fnd_dsql.g_bind_vtbl.EXTEND(g_maximum_varray_size);
264: fnd_dsql.g_bind_dtbl.EXTEND(g_maximum_varray_size);
265: fnd_dsql.g_bind_ntbl.EXTEND(g_maximum_varray_size);
266: EXCEPTION

Line 263: fnd_dsql.g_bind_vtbl.EXTEND(g_maximum_varray_size);

259: -- Extend the varrays. Otherwise it gives
260: -- ORA-06533: Subscript beyond count
261: --
262: fnd_dsql.g_bind_ttbl.EXTEND(g_maximum_varray_size);
263: fnd_dsql.g_bind_vtbl.EXTEND(g_maximum_varray_size);
264: fnd_dsql.g_bind_dtbl.EXTEND(g_maximum_varray_size);
265: fnd_dsql.g_bind_ntbl.EXTEND(g_maximum_varray_size);
266: EXCEPTION
267: WHEN OTHERS THEN

Line 264: fnd_dsql.g_bind_dtbl.EXTEND(g_maximum_varray_size);

260: -- ORA-06533: Subscript beyond count
261: --
262: fnd_dsql.g_bind_ttbl.EXTEND(g_maximum_varray_size);
263: fnd_dsql.g_bind_vtbl.EXTEND(g_maximum_varray_size);
264: fnd_dsql.g_bind_dtbl.EXTEND(g_maximum_varray_size);
265: fnd_dsql.g_bind_ntbl.EXTEND(g_maximum_varray_size);
266: EXCEPTION
267: WHEN OTHERS THEN
268: report_error(g_package_name || '.Package Initialization', Sqlerrm);

Line 265: fnd_dsql.g_bind_ntbl.EXTEND(g_maximum_varray_size);

261: --
262: fnd_dsql.g_bind_ttbl.EXTEND(g_maximum_varray_size);
263: fnd_dsql.g_bind_vtbl.EXTEND(g_maximum_varray_size);
264: fnd_dsql.g_bind_dtbl.EXTEND(g_maximum_varray_size);
265: fnd_dsql.g_bind_ntbl.EXTEND(g_maximum_varray_size);
266: EXCEPTION
267: WHEN OTHERS THEN
268: report_error(g_package_name || '.Package Initialization', Sqlerrm);
269: RAISE;

Line 270: END fnd_dsql;

266: EXCEPTION
267: WHEN OTHERS THEN
268: report_error(g_package_name || '.Package Initialization', Sqlerrm);
269: RAISE;
270: END fnd_dsql;