APPS.DPP_NOTIFICATION_PVT SQL Statements

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

Line: 111

     SELECT u.RESPONSIBILITY_ID,
            u.RESPONSIBILITY_APPLICATION_ID
       INTO l_responsibility_id,
            l_application_id
       FROM fnd_user_resp_groups u,
            fnd_responsibility_vl r
      WHERE user_id = p_user_id
        AND r.RESPONSIBILITY_ID = u.RESPONSIBILITY_ID
        AND u.RESPONSIBILITY_APPLICATION_ID = 9000          -- for dpp
        AND ROWNUM = 1;

Line: 134

INSERT INTO DPP_NOTIFICATION_BLOBS
(
	execution_detail_id,
	creation_date,
	created_by,
	last_update_date,
	last_updated_by,
	last_update_login,
	notification_xml_input,
	Notification_Output_Type
)
VALUES
(
	p_execution_detail_id,
	sysdate,
	p_user_id,
	sysdate,
	p_user_id,
	fnd_global.login_id,
	p_input_xml,
	l_output_type
);

Line: 160

       SELECT tag
         INTO l_notif_territory
         FROM dpp_lookups
        WHERE lookup_code =  UPPER(p_notif_language)
          AND lookup_type = 'DPP_LANG_DFLT_TERRITORY';

Line: 289

PROCEDURE Select_Message_Text
     (x_return_status           OUT NOCOPY VARCHAR2,
      x_msg_count               OUT NOCOPY NUMBER,
      x_msg_data                OUT NOCOPY VARCHAR2,
      p_message_name            IN VARCHAR2,
      p_application_short_name  IN VARCHAR2,
      p_language_code           IN VARCHAR2,
      p_message_token           IN MESSAGE_TOKENS_TBL_TYPE,
      x_message_type            OUT NOCOPY VARCHAR2,
      x_message_category        OUT NOCOPY VARCHAR2,
      x_message_text            OUT NOCOPY VARCHAR2,
      x_message_severity        OUT NOCOPY VARCHAR2)
IS
  l_api_name           CONSTANT VARCHAR2(30) := 'Select_Message_Text';

Line: 307

  l_module             VARCHAR2(100) := 'dpp.plsql.DPP_NOTIFICATION_PVT.SELECT_MESSAGE_TEXT';

Line: 334

       SELECT nls_language
         INTO l_language_code
         FROM fnd_languages
        WHERE upper((iso_language||'-'||iso_territory)) = UPPER(p_language_code);

Line: 341

              SELECT fl.nls_language
                INTO l_language_code
                FROM fnd_languages fl,
                     dpp_lookups dl
               WHERE upper((fl.iso_language||'-'||fl.iso_territory)) = UPPER((p_language_code||'-'||dl.tag))
                 AND dl.lookup_code = UPPER(p_language_code)
                 AND dl.lookup_type = 'DPP_LANG_DFLT_TERRITORY';

Line: 429

      fnd_message.set_token('ROUTINE', 'DPP_NOTIFICATION_PVT.Select_Message_Text');

Line: 433

      DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_EXCEPTION, l_module, substr(('Error in DPP_NOTIFICATION_PVT.Select_Message_Text: '||SQLERRM),1,2000));

Line: 446

END Select_Message_Text;

Line: 498

	SELECT notification_attachment,notification_output_type
    INTO x_formatted_output,x_output_type
	  FROM DPP_NOTIFICATION_BLOBS
	 WHERE execution_detail_id = p_execution_detail_id;