APPS.CSM_MAIL_MESSAGES_PKG SQL Statements

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

Line: 18

  SELECT *
  FROM  csf_m_mail_messages_inq
  WHERE tranid$$ = b_tranid
  AND   clid$$cs = b_user_name;

Line: 24

  This procedure is called by APPLY_CLIENT_CHANGES when an inserted record is to be processed.
***/
PROCEDURE APPLY_INSERT
         (
           p_record        IN c_mail_messages%ROWTYPE,
           p_error_msg     OUT NOCOPY    VARCHAR2,
           x_return_status IN OUT NOCOPY VARCHAR2
         ) IS

cursor c_user_name
       ( b_user_name varchar2
       )
is
select fur.user_name
,      fur.start_date
,      fur.end_date
from   fnd_user fur
where  fur.user_name = b_user_name;

Line: 47

SELECT source_name
FROM jtf_rs_resource_extns jtrs
WHERE jtrs.user_name = p_username
AND SYSDATE BETWEEN start_date_active AND nvl(end_date_active, sysdate);

Line: 54

SELECT 'y'
FROM JTF_RS_GROUPS_B
WHERE GROUP_ID=b_group_id;

Line: 147

    SELECT 1 INTO l_num_grp FROM CSM_NOTIFICATIONS_ACC WHERE NOTIFICATION_ID=l_notification_id AND USER_ID=asg_base.get_user_id(l_sender);

Line: 150

     CSM_NOTIFICATION_EVENT_PKG.INSERT_NOTIFICATIONS_ACC(l_notification_id,asg_base.get_user_id(l_sender));

Line: 158

     fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);

Line: 163

     CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:'
               || ' for PK ' || p_record.NOTIFICATION_ID ,'CSM_MAIL_MESSAGES_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION);

Line: 166

END APPLY_INSERT;

Line: 186

    APPLY_INSERT
      (
        p_record,
        p_error_msg,
        x_return_status
      );

Line: 226

  a fast sync. This procedure will insert the data that came from mobile into the backend tables using
  public APIs.
***/
PROCEDURE APPLY_CLIENT_CHANGES
         (
           p_user_name     IN VARCHAR2,
           p_tranid        IN NUMBER,
           p_debug_level   IN NUMBER,
           x_return_status IN OUT NOCOPY VARCHAR2
         ) IS

  l_process_status VARCHAR2(1);

Line: 282

	   --if deferred and reapplied - reject won't delete applied record from inq
	   IF (r_mail_messages.dmltype$$<>'I') OR ( ASG_DEFER.is_deferred(p_user_name,p_tranid,g_pub_name,r_mail_messages.seqno$$)=FND_API.G_TRUE) THEN
			  /*** Yes -> delete record from inqueue ***/

			  CSM_UTIL_PKG.DELETE_RECORD
				(
				  p_user_name,
				  p_tranid,
				  r_mail_messages.seqno$$,
				  r_mail_messages.notification_id,
				  g_object_name,
				  g_pub_name,
				  l_error_msg,
				  l_process_status
				);

Line: 297

			  /*** was delete successful? ***/
			  IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
				/*** no -> rollback ***/
				  CSM_UTIL_PKG.LOG
				  ( 'Deleting from inqueue failed, rolling back to savepoint'
			  || ' for PK ' || r_mail_messages.notification_id ,'CSM_MAIL_MESSAGES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

Line: 308

      /*** Record was not processed successfully or delete failed -> defer and reject record ***/
        CSM_UTIL_PKG.LOG
        ( 'Record not processed successfully, deferring and rejecting record'
      || ' for PK ' || r_mail_messages.notification_id ,'CSM_MAIL_MESSAGES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here