APPS.BEN_WARNINGS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 109

  g_oab_warnings.delete(l_trim_begin,l_trim_end);

Line: 124

  g_oab_warnings.delete;

Line: 202

        Insert into ben_online_warnings(session_id, message_text)
             values (p_session_id, fnd_message.get);

Line: 214

This procedure is used to delete the warnings. warnings are deleted
based on the paramters passed.
*/
----------------------------------------------------------------------------

PROCEDURE delete_warnings (
   p_application_short_name   IN   VARCHAR2,
   p_message_name             IN   VARCHAR2,
   p_parm1                    IN   NUMBER DEFAULT NULL,
   p_parm2                    IN   NUMBER DEFAULT NULL,
   p_parma                    IN   VARCHAR2 DEFAULT NULL,
   p_parmb                    IN   VARCHAR2 DEFAULT NULL,
   p_parmc                    IN   VARCHAR2 DEFAULT NULL,
   p_person_id                IN   NUMBER DEFAULT NULL
)
IS
   curr_index      NUMBER;

Line: 232

   l_package       VARCHAR2 (80)         := g_package || '.delete_warnings';

Line: 263

            g_oab_warnings.DELETE (curr_index);

Line: 274

END delete_warnings;