APPS.CSM_MAIL_RECIPIENTS_PKG SQL Statements

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

Line: 22

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

Line: 29

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

BEGIN

-- Insert in this table is not to be
-- transfered to CRM table. Therefore discard all inserts and report OK.
x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 44

END APPLY_INSERT;

Line: 48

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

l_dummy NUMBER;

Line: 61

  CSM_UTIL_PKG.LOG ( 'Entering Update for '|| p_record.notification_id
					,'CSM_MAIL_RECIPIENTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);

Line: 64

  if p_record.delete_flag IS NOT NULL AND substr(p_record.delete_flag,1,1) = 'Y' then

		CSM_UTIL_PKG.LOG ( 'Delete flag set for notification '|| p_record.notification_id
					,'CSM_MAIL_RECIPIENTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);

Line: 76

			CSM_ACC_PKG.Delete_Acc
			( P_PUBLICATION_ITEM_NAMES => g_notification_pubi_name
			 ,P_ACC_TABLE_NAME         => g_notification_acc_table_name
			 ,P_PK1_NAME               => g_notification_pk1_name
			 ,P_PK1_NUM_VALUE          => p_record.notification_id
			 ,P_USER_ID                =>  asg_base.get_user_id(p_record.clid$$cs)
			);

Line: 83

  else -- any other update - means this msg is read
		CSM_UTIL_PKG.LOG ( 'Read flag is being set for notification '|| p_record.notification_id
					,'CSM_MAIL_RECIPIENTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);

Line: 87

		 select 1 into l_dummy
		 from   wf_notification_attributes wna
		 where  wna.notification_id = p_record.notification_id
		 and    wna.name            = 'READ_FLAG';

Line: 101

  CSM_UTIL_PKG.LOG ( 'Leaving Update for '|| p_record.notification_id
					,'CSM_MAIL_RECIPIENTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);

Line: 106

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

Line: 111

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

Line: 115

END APPLY_UPDATE;

Line: 133

    APPLY_INSERT
      (
        p_record,
        p_error_msg,
        x_return_status
      );

Line: 141

    APPLY_UPDATE
      (
        p_record,
        p_error_msg,
        x_return_status
      );

Line: 150

        ( 'Delete is not supported for this entity'
      || ' for PK ' || p_record.notification_id,'CSM_MAIL_RECIPIENTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR );

Line: 181

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

      /*** Yes -> delete record from inqueue ***/

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

Line: 228

      /*** 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_recipients.notification_id ,'CSM_MAIL_RECIPIENTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

Line: 239

      /*** 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_recipients.notification_id,'CSM_MAIL_RECIPIENTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here