APPS.NTN dependencies on DBMS_SQL

Line 148: c := sys.dbms_sql.open_cursor;

144:
145: -- stmt:= stmt||' '||new_id||',';
146: -- stmt:= stmt||' '||employee_id||',';
147: -- stmt:= stmt||''''||p_message_name||''',';
148: c := sys.dbms_sql.open_cursor;
149: sys.dbms_sql.parse(c, stmt, dbms_sql.native);
150: sys.dbms_sql.bind_variable(c,'employee_id', p_employee_id);
151: sys.dbms_sql.bind_variable(c,'message_name', p_message_name);
152: sys.dbms_sql.bind_variable(c,'object_id', object_id);

Line 149: sys.dbms_sql.parse(c, stmt, dbms_sql.native);

145: -- stmt:= stmt||' '||new_id||',';
146: -- stmt:= stmt||' '||employee_id||',';
147: -- stmt:= stmt||''''||p_message_name||''',';
148: c := sys.dbms_sql.open_cursor;
149: sys.dbms_sql.parse(c, stmt, dbms_sql.native);
150: sys.dbms_sql.bind_variable(c,'employee_id', p_employee_id);
151: sys.dbms_sql.bind_variable(c,'message_name', p_message_name);
152: sys.dbms_sql.bind_variable(c,'object_id', object_id);
153: sys.dbms_sql.bind_variable(c,'deletable', deletable);

Line 150: sys.dbms_sql.bind_variable(c,'employee_id', p_employee_id);

146: -- stmt:= stmt||' '||employee_id||',';
147: -- stmt:= stmt||''''||p_message_name||''',';
148: c := sys.dbms_sql.open_cursor;
149: sys.dbms_sql.parse(c, stmt, dbms_sql.native);
150: sys.dbms_sql.bind_variable(c,'employee_id', p_employee_id);
151: sys.dbms_sql.bind_variable(c,'message_name', p_message_name);
152: sys.dbms_sql.bind_variable(c,'object_id', object_id);
153: sys.dbms_sql.bind_variable(c,'deletable', deletable);
154: sys.dbms_sql.bind_variable(c,'from_id', from_id);

Line 151: sys.dbms_sql.bind_variable(c,'message_name', p_message_name);

147: -- stmt:= stmt||''''||p_message_name||''',';
148: c := sys.dbms_sql.open_cursor;
149: sys.dbms_sql.parse(c, stmt, dbms_sql.native);
150: sys.dbms_sql.bind_variable(c,'employee_id', p_employee_id);
151: sys.dbms_sql.bind_variable(c,'message_name', p_message_name);
152: sys.dbms_sql.bind_variable(c,'object_id', object_id);
153: sys.dbms_sql.bind_variable(c,'deletable', deletable);
154: sys.dbms_sql.bind_variable(c,'from_id', from_id);
155: sys.dbms_sql.bind_variable(c,'application_id', p_application_id);

Line 152: sys.dbms_sql.bind_variable(c,'object_id', object_id);

148: c := sys.dbms_sql.open_cursor;
149: sys.dbms_sql.parse(c, stmt, dbms_sql.native);
150: sys.dbms_sql.bind_variable(c,'employee_id', p_employee_id);
151: sys.dbms_sql.bind_variable(c,'message_name', p_message_name);
152: sys.dbms_sql.bind_variable(c,'object_id', object_id);
153: sys.dbms_sql.bind_variable(c,'deletable', deletable);
154: sys.dbms_sql.bind_variable(c,'from_id', from_id);
155: sys.dbms_sql.bind_variable(c,'application_id', p_application_id);
156: sys.dbms_sql.bind_variable(c,'doc_type', doc_type);

Line 153: sys.dbms_sql.bind_variable(c,'deletable', deletable);

149: sys.dbms_sql.parse(c, stmt, dbms_sql.native);
150: sys.dbms_sql.bind_variable(c,'employee_id', p_employee_id);
151: sys.dbms_sql.bind_variable(c,'message_name', p_message_name);
152: sys.dbms_sql.bind_variable(c,'object_id', object_id);
153: sys.dbms_sql.bind_variable(c,'deletable', deletable);
154: sys.dbms_sql.bind_variable(c,'from_id', from_id);
155: sys.dbms_sql.bind_variable(c,'application_id', p_application_id);
156: sys.dbms_sql.bind_variable(c,'doc_type', doc_type);
157: sys.dbms_sql.bind_variable(c,'doc_number', doc_number);

Line 154: sys.dbms_sql.bind_variable(c,'from_id', from_id);

150: sys.dbms_sql.bind_variable(c,'employee_id', p_employee_id);
151: sys.dbms_sql.bind_variable(c,'message_name', p_message_name);
152: sys.dbms_sql.bind_variable(c,'object_id', object_id);
153: sys.dbms_sql.bind_variable(c,'deletable', deletable);
154: sys.dbms_sql.bind_variable(c,'from_id', from_id);
155: sys.dbms_sql.bind_variable(c,'application_id', p_application_id);
156: sys.dbms_sql.bind_variable(c,'doc_type', doc_type);
157: sys.dbms_sql.bind_variable(c,'doc_number', doc_number);
158: sys.dbms_sql.bind_variable(c,'amount', amount);

Line 155: sys.dbms_sql.bind_variable(c,'application_id', p_application_id);

151: sys.dbms_sql.bind_variable(c,'message_name', p_message_name);
152: sys.dbms_sql.bind_variable(c,'object_id', object_id);
153: sys.dbms_sql.bind_variable(c,'deletable', deletable);
154: sys.dbms_sql.bind_variable(c,'from_id', from_id);
155: sys.dbms_sql.bind_variable(c,'application_id', p_application_id);
156: sys.dbms_sql.bind_variable(c,'doc_type', doc_type);
157: sys.dbms_sql.bind_variable(c,'doc_number', doc_number);
158: sys.dbms_sql.bind_variable(c,'amount', amount);
159: sys.dbms_sql.bind_variable(c,'currency', currency);

Line 156: sys.dbms_sql.bind_variable(c,'doc_type', doc_type);

152: sys.dbms_sql.bind_variable(c,'object_id', object_id);
153: sys.dbms_sql.bind_variable(c,'deletable', deletable);
154: sys.dbms_sql.bind_variable(c,'from_id', from_id);
155: sys.dbms_sql.bind_variable(c,'application_id', p_application_id);
156: sys.dbms_sql.bind_variable(c,'doc_type', doc_type);
157: sys.dbms_sql.bind_variable(c,'doc_number', doc_number);
158: sys.dbms_sql.bind_variable(c,'amount', amount);
159: sys.dbms_sql.bind_variable(c,'currency', currency);
160: sys.dbms_sql.bind_variable(c,'note', note);

Line 157: sys.dbms_sql.bind_variable(c,'doc_number', doc_number);

153: sys.dbms_sql.bind_variable(c,'deletable', deletable);
154: sys.dbms_sql.bind_variable(c,'from_id', from_id);
155: sys.dbms_sql.bind_variable(c,'application_id', p_application_id);
156: sys.dbms_sql.bind_variable(c,'doc_type', doc_type);
157: sys.dbms_sql.bind_variable(c,'doc_number', doc_number);
158: sys.dbms_sql.bind_variable(c,'amount', amount);
159: sys.dbms_sql.bind_variable(c,'currency', currency);
160: sys.dbms_sql.bind_variable(c,'note', note);
161: sys.dbms_sql.bind_variable(c,'start_effective_date', start_effective_date);

Line 158: sys.dbms_sql.bind_variable(c,'amount', amount);

154: sys.dbms_sql.bind_variable(c,'from_id', from_id);
155: sys.dbms_sql.bind_variable(c,'application_id', p_application_id);
156: sys.dbms_sql.bind_variable(c,'doc_type', doc_type);
157: sys.dbms_sql.bind_variable(c,'doc_number', doc_number);
158: sys.dbms_sql.bind_variable(c,'amount', amount);
159: sys.dbms_sql.bind_variable(c,'currency', currency);
160: sys.dbms_sql.bind_variable(c,'note', note);
161: sys.dbms_sql.bind_variable(c,'start_effective_date', start_effective_date);
162: sys.dbms_sql.bind_variable(c,'end_effective_date', end_effective_date);

Line 159: sys.dbms_sql.bind_variable(c,'currency', currency);

155: sys.dbms_sql.bind_variable(c,'application_id', p_application_id);
156: sys.dbms_sql.bind_variable(c,'doc_type', doc_type);
157: sys.dbms_sql.bind_variable(c,'doc_number', doc_number);
158: sys.dbms_sql.bind_variable(c,'amount', amount);
159: sys.dbms_sql.bind_variable(c,'currency', currency);
160: sys.dbms_sql.bind_variable(c,'note', note);
161: sys.dbms_sql.bind_variable(c,'start_effective_date', start_effective_date);
162: sys.dbms_sql.bind_variable(c,'end_effective_date', end_effective_date);
163: sys.dbms_sql.bind_variable(c,'doc_creation_date', doc_creation_date);

Line 160: sys.dbms_sql.bind_variable(c,'note', note);

156: sys.dbms_sql.bind_variable(c,'doc_type', doc_type);
157: sys.dbms_sql.bind_variable(c,'doc_number', doc_number);
158: sys.dbms_sql.bind_variable(c,'amount', amount);
159: sys.dbms_sql.bind_variable(c,'currency', currency);
160: sys.dbms_sql.bind_variable(c,'note', note);
161: sys.dbms_sql.bind_variable(c,'start_effective_date', start_effective_date);
162: sys.dbms_sql.bind_variable(c,'end_effective_date', end_effective_date);
163: sys.dbms_sql.bind_variable(c,'doc_creation_date', doc_creation_date);
164: sys.dbms_sql.bind_variable(c,'date1', date1);

Line 161: sys.dbms_sql.bind_variable(c,'start_effective_date', start_effective_date);

157: sys.dbms_sql.bind_variable(c,'doc_number', doc_number);
158: sys.dbms_sql.bind_variable(c,'amount', amount);
159: sys.dbms_sql.bind_variable(c,'currency', currency);
160: sys.dbms_sql.bind_variable(c,'note', note);
161: sys.dbms_sql.bind_variable(c,'start_effective_date', start_effective_date);
162: sys.dbms_sql.bind_variable(c,'end_effective_date', end_effective_date);
163: sys.dbms_sql.bind_variable(c,'doc_creation_date', doc_creation_date);
164: sys.dbms_sql.bind_variable(c,'date1', date1);
165: sys.dbms_sql.bind_variable(c,'date2', date2);

Line 162: sys.dbms_sql.bind_variable(c,'end_effective_date', end_effective_date);

158: sys.dbms_sql.bind_variable(c,'amount', amount);
159: sys.dbms_sql.bind_variable(c,'currency', currency);
160: sys.dbms_sql.bind_variable(c,'note', note);
161: sys.dbms_sql.bind_variable(c,'start_effective_date', start_effective_date);
162: sys.dbms_sql.bind_variable(c,'end_effective_date', end_effective_date);
163: sys.dbms_sql.bind_variable(c,'doc_creation_date', doc_creation_date);
164: sys.dbms_sql.bind_variable(c,'date1', date1);
165: sys.dbms_sql.bind_variable(c,'date2', date2);
166: sys.dbms_sql.bind_variable(c,'date3', date3);

Line 163: sys.dbms_sql.bind_variable(c,'doc_creation_date', doc_creation_date);

159: sys.dbms_sql.bind_variable(c,'currency', currency);
160: sys.dbms_sql.bind_variable(c,'note', note);
161: sys.dbms_sql.bind_variable(c,'start_effective_date', start_effective_date);
162: sys.dbms_sql.bind_variable(c,'end_effective_date', end_effective_date);
163: sys.dbms_sql.bind_variable(c,'doc_creation_date', doc_creation_date);
164: sys.dbms_sql.bind_variable(c,'date1', date1);
165: sys.dbms_sql.bind_variable(c,'date2', date2);
166: sys.dbms_sql.bind_variable(c,'date3', date3);
167: sys.dbms_sql.bind_variable(c,'off_line', off_line);

Line 164: sys.dbms_sql.bind_variable(c,'date1', date1);

160: sys.dbms_sql.bind_variable(c,'note', note);
161: sys.dbms_sql.bind_variable(c,'start_effective_date', start_effective_date);
162: sys.dbms_sql.bind_variable(c,'end_effective_date', end_effective_date);
163: sys.dbms_sql.bind_variable(c,'doc_creation_date', doc_creation_date);
164: sys.dbms_sql.bind_variable(c,'date1', date1);
165: sys.dbms_sql.bind_variable(c,'date2', date2);
166: sys.dbms_sql.bind_variable(c,'date3', date3);
167: sys.dbms_sql.bind_variable(c,'off_line', off_line);
168: sys.dbms_sql.bind_variable(c,'priority', priority);

Line 165: sys.dbms_sql.bind_variable(c,'date2', date2);

161: sys.dbms_sql.bind_variable(c,'start_effective_date', start_effective_date);
162: sys.dbms_sql.bind_variable(c,'end_effective_date', end_effective_date);
163: sys.dbms_sql.bind_variable(c,'doc_creation_date', doc_creation_date);
164: sys.dbms_sql.bind_variable(c,'date1', date1);
165: sys.dbms_sql.bind_variable(c,'date2', date2);
166: sys.dbms_sql.bind_variable(c,'date3', date3);
167: sys.dbms_sql.bind_variable(c,'off_line', off_line);
168: sys.dbms_sql.bind_variable(c,'priority', priority);
169: sys.dbms_sql.bind_variable(c,'status', status);

Line 166: sys.dbms_sql.bind_variable(c,'date3', date3);

162: sys.dbms_sql.bind_variable(c,'end_effective_date', end_effective_date);
163: sys.dbms_sql.bind_variable(c,'doc_creation_date', doc_creation_date);
164: sys.dbms_sql.bind_variable(c,'date1', date1);
165: sys.dbms_sql.bind_variable(c,'date2', date2);
166: sys.dbms_sql.bind_variable(c,'date3', date3);
167: sys.dbms_sql.bind_variable(c,'off_line', off_line);
168: sys.dbms_sql.bind_variable(c,'priority', priority);
169: sys.dbms_sql.bind_variable(c,'status', status);
170: sys.dbms_sql.bind_variable(c,'user_id', user_id);

Line 167: sys.dbms_sql.bind_variable(c,'off_line', off_line);

163: sys.dbms_sql.bind_variable(c,'doc_creation_date', doc_creation_date);
164: sys.dbms_sql.bind_variable(c,'date1', date1);
165: sys.dbms_sql.bind_variable(c,'date2', date2);
166: sys.dbms_sql.bind_variable(c,'date3', date3);
167: sys.dbms_sql.bind_variable(c,'off_line', off_line);
168: sys.dbms_sql.bind_variable(c,'priority', priority);
169: sys.dbms_sql.bind_variable(c,'status', status);
170: sys.dbms_sql.bind_variable(c,'user_id', user_id);
171: sys.dbms_sql.bind_variable(c,'login_id', login_id);

Line 168: sys.dbms_sql.bind_variable(c,'priority', priority);

164: sys.dbms_sql.bind_variable(c,'date1', date1);
165: sys.dbms_sql.bind_variable(c,'date2', date2);
166: sys.dbms_sql.bind_variable(c,'date3', date3);
167: sys.dbms_sql.bind_variable(c,'off_line', off_line);
168: sys.dbms_sql.bind_variable(c,'priority', priority);
169: sys.dbms_sql.bind_variable(c,'status', status);
170: sys.dbms_sql.bind_variable(c,'user_id', user_id);
171: sys.dbms_sql.bind_variable(c,'login_id', login_id);
172:

Line 169: sys.dbms_sql.bind_variable(c,'status', status);

165: sys.dbms_sql.bind_variable(c,'date2', date2);
166: sys.dbms_sql.bind_variable(c,'date3', date3);
167: sys.dbms_sql.bind_variable(c,'off_line', off_line);
168: sys.dbms_sql.bind_variable(c,'priority', priority);
169: sys.dbms_sql.bind_variable(c,'status', status);
170: sys.dbms_sql.bind_variable(c,'user_id', user_id);
171: sys.dbms_sql.bind_variable(c,'login_id', login_id);
172:
173: dbms_output.put_line('after message insert');

Line 170: sys.dbms_sql.bind_variable(c,'user_id', user_id);

166: sys.dbms_sql.bind_variable(c,'date3', date3);
167: sys.dbms_sql.bind_variable(c,'off_line', off_line);
168: sys.dbms_sql.bind_variable(c,'priority', priority);
169: sys.dbms_sql.bind_variable(c,'status', status);
170: sys.dbms_sql.bind_variable(c,'user_id', user_id);
171: sys.dbms_sql.bind_variable(c,'login_id', login_id);
172:
173: dbms_output.put_line('after message insert');
174: num_attrs := 32;

Line 171: sys.dbms_sql.bind_variable(c,'login_id', login_id);

167: sys.dbms_sql.bind_variable(c,'off_line', off_line);
168: sys.dbms_sql.bind_variable(c,'priority', priority);
169: sys.dbms_sql.bind_variable(c,'status', status);
170: sys.dbms_sql.bind_variable(c,'user_id', user_id);
171: sys.dbms_sql.bind_variable(c,'login_id', login_id);
172:
173: dbms_output.put_line('after message insert');
174: num_attrs := 32;
175: for ix in 1..num_attrs loop

Line 178: sys.dbms_sql.bind_variable(c,'a' || (ix), attribute_array(array_lb +ix -1));

174: num_attrs := 32;
175: for ix in 1..num_attrs loop
176: num_attrs_passed := array_ub - array_lb +1;
177: if (ix <= num_attrs_passed) then
178: sys.dbms_sql.bind_variable(c,'a' || (ix), attribute_array(array_lb +ix -1));
179: else
180: sys.dbms_sql.bind_variable(c,'a' || (ix), '');
181: end if ;
182:

Line 180: sys.dbms_sql.bind_variable(c,'a' || (ix), '');

176: num_attrs_passed := array_ub - array_lb +1;
177: if (ix <= num_attrs_passed) then
178: sys.dbms_sql.bind_variable(c,'a' || (ix), attribute_array(array_lb +ix -1));
179: else
180: sys.dbms_sql.bind_variable(c,'a' || (ix), '');
181: end if ;
182:
183: end loop;
184: dbms_output.put_line('after attribute array');

Line 187: rows_processed := sys.dbms_sql.execute(c);

183: end loop;
184: dbms_output.put_line('after attribute array');
185: -- sys.dbms_output.put_line(stmt);
186:
187: rows_processed := sys.dbms_sql.execute(c);
188: sys.dbms_sql.close_cursor(c);
189: select fnd_notifications_s.currval into notification_id from dual;
190: return_code:=0;
191: dbms_output.put_line('after send notification');

Line 188: sys.dbms_sql.close_cursor(c);

184: dbms_output.put_line('after attribute array');
185: -- sys.dbms_output.put_line(stmt);
186:
187: rows_processed := sys.dbms_sql.execute(c);
188: sys.dbms_sql.close_cursor(c);
189: select fnd_notifications_s.currval into notification_id from dual;
190: return_code:=0;
191: dbms_output.put_line('after send notification');
192:

Line 302: c := sys.dbms_sql.open_cursor;

298: || ' from jliang_nv '
299: || ' where notification_id = :p_notification_id';
300:
301:
302: c := sys.dbms_sql.open_cursor;
303: sys.dbms_sql.parse(c, stmt, dbms_sql.native);
304: sys.dbms_sql.bind_variable(c,'p_notification_id', p_notification_id);
305: sys.dbms_sql.define_column(c, 1, attrval, 100);
306:

Line 303: sys.dbms_sql.parse(c, stmt, dbms_sql.native);

299: || ' where notification_id = :p_notification_id';
300:
301:
302: c := sys.dbms_sql.open_cursor;
303: sys.dbms_sql.parse(c, stmt, dbms_sql.native);
304: sys.dbms_sql.bind_variable(c,'p_notification_id', p_notification_id);
305: sys.dbms_sql.define_column(c, 1, attrval, 100);
306:
307:

Line 304: sys.dbms_sql.bind_variable(c,'p_notification_id', p_notification_id);

300:
301:
302: c := sys.dbms_sql.open_cursor;
303: sys.dbms_sql.parse(c, stmt, dbms_sql.native);
304: sys.dbms_sql.bind_variable(c,'p_notification_id', p_notification_id);
305: sys.dbms_sql.define_column(c, 1, attrval, 100);
306:
307:
308: rows_processed := sys.dbms_sql.execute(c);

Line 305: sys.dbms_sql.define_column(c, 1, attrval, 100);

301:
302: c := sys.dbms_sql.open_cursor;
303: sys.dbms_sql.parse(c, stmt, dbms_sql.native);
304: sys.dbms_sql.bind_variable(c,'p_notification_id', p_notification_id);
305: sys.dbms_sql.define_column(c, 1, attrval, 100);
306:
307:
308: rows_processed := sys.dbms_sql.execute(c);
309:

Line 308: rows_processed := sys.dbms_sql.execute(c);

304: sys.dbms_sql.bind_variable(c,'p_notification_id', p_notification_id);
305: sys.dbms_sql.define_column(c, 1, attrval, 100);
306:
307:
308: rows_processed := sys.dbms_sql.execute(c);
309:
310: if dbms_sql.fetch_rows(c) > 0 then
311: dbms_sql.column_value(c,1,attrval);
312: end if;

Line 310: if dbms_sql.fetch_rows(c) > 0 then

306:
307:
308: rows_processed := sys.dbms_sql.execute(c);
309:
310: if dbms_sql.fetch_rows(c) > 0 then
311: dbms_sql.column_value(c,1,attrval);
312: end if;
313:
314: sys.dbms_sql.close_cursor(c);

Line 311: dbms_sql.column_value(c,1,attrval);

307:
308: rows_processed := sys.dbms_sql.execute(c);
309:
310: if dbms_sql.fetch_rows(c) > 0 then
311: dbms_sql.column_value(c,1,attrval);
312: end if;
313:
314: sys.dbms_sql.close_cursor(c);
315: attribute_value := attrval;

Line 314: sys.dbms_sql.close_cursor(c);

310: if dbms_sql.fetch_rows(c) > 0 then
311: dbms_sql.column_value(c,1,attrval);
312: end if;
313:
314: sys.dbms_sql.close_cursor(c);
315: attribute_value := attrval;
316: end;
317: */
318: