DBA Data[Home] [Help]

APPS.NTN dependencies on FND_NOTIFICATIONS_S

Line 136: || '(fnd_notifications_s.nextval, :employee_id, :message_name, :priority, :status, :object_id, :deletable, :from_id, :application_id, ' ||

132: || 'attribute31, attribute32, '
133: || 'last_update_date, last_updated_by, last_update_login, '
134: || 'creation_date, created_by)'
135: || ' values '
136: || '(fnd_notifications_s.nextval, :employee_id, :message_name, :priority, :status, :object_id, :deletable, :from_id, :application_id, ' ||
137: ':doc_type, :doc_number, :amount, :currency, :note, :start_effective_date, :end_effective_date, :doc_creation_date, :date1, :date2, :date3, :off_line, '
138: || ':a1, :a2, :a3, :a4, :a5, :a6, :a7, :a8, :a9, :a10,'
139: || ':a11, :a12, :a13, :a14, :a15, :a16,'
140: || ':a17, :a18, :a19, :a20, :a21, :a22,'

Line 189: select fnd_notifications_s.currval into notification_id from dual;

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:
193: