APPS.M4U_DMD_UTILS SQL Statements

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

Line: 176

           p_value IN (c_action_add,c_action_delete,c_action_accepted,
           c_action_rejected,c_action_sync,c_action_review,
           c_action_new,c_action_init_load,c_action_modify,
           c_action_correct)THEN
           RETURN true;

Line: 230

        SELECT  count(*)
        INTO    l_count
        FROM    m4u_dmd_payloads
          WHERE payload_id = p_payload_id;

Line: 256

        SELECT  count(*)
        INTO    l_count
        FROM    m4u_dmd_documents
          WHERE doc_id = p_doc_id;

Line: 282

        SELECT  count(*)
        INTO    l_count
        FROM    m4u_dmd_messages
          WHERE msg_id = p_msg_id;

Line: 308

        SELECT  count(*)
        INTO    l_count
        FROM    m4u_dmd_documents
          WHERE orig_doc_id = p_orig_doc_id;

Line: 334

        SELECT  count(*)
        INTO    l_count
        FROM    m4u_dmd_messages
          WHERE orig_msg_id = p_orig_msg_id;

Line: 381

                SELECT meaning
                INTO   l_user_id
                FROM   fnd_lookup_values
                WHERE  lookup_type = 'M4U_USER_GLNS'
                   AND language    = userenv('lang')
                   AND lookup_code = p_gln;