APPS.CN_NOTIFICATION_PUB SQL Statements

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

Line: 6

G_LAST_UPDATE_DATE     DATE 		     := Sysdate;

Line: 7

G_LAST_UPDATED_BY      NUMBER 		:= fnd_global.user_id;

Line: 10

G_LAST_UPDATE_LOGIN    NUMBER		     := fnd_global.login_id;

Line: 37

    SELECT collected_flag
      INTO l_col_flag
      FROM cn_not_trx_all cnt
     WHERE cnt.source_trx_line_id = p_line_id
           AND NVL(cnt.org_id,-99) = NVL(p_org_id,-99)
           AND cnt.source_doc_type = p_source_doc_type
           AND cnt.not_trx_id = (SELECT max(cnt1.not_trx_id)
				             FROM cn_not_trx_all cnt1
				            WHERE cnt1.source_trx_line_id = p_line_id );

Line: 130

       SELECT events.event_id
       FROM   cn_table_maps_all tm,
              cn_modules_all_b modules,
              cn_events_all_b events
       WHERE  tm.mapping_type = p_source_doc_type
              AND NVL(tm.org_id,-99) = NVL(cp_org_id,-99)
              AND modules.module_id = tm.module_id
              AND NVL(modules.org_id,-99) = NVL(cp_org_id,-99)
              AND events.event_id = modules.event_id
              AND NVL(events.org_id,-99) = NVL(cp_org_id,-99);

Line: 167

   x_loading_status := 'CN_INSERTED';

Line: 232

   cn_process_audits_pkg.insert_row
	( l_rowid, l_proc_audit_id, NULL, 'NOT', 'Update Notification Api',
	  NULL, NULL, NULL, NULL, NULL, SYSDATE, NULL, p_org_id);

Line: 244

     SELECT
         NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),
                              ' ', NULL,
                              SUBSTRB(USERENV('CLIENT_INFO'),1,10)
                              )
                       ),
              -99
           )
     INTO l_org_id
     FROM DUAL;

Line: 282

     SELECT FLOOR(cn_not_trx_s.CURRVAL/NVL(cn_global_var.g_system_batch_size,200)),
            cn_not_trx_s.NEXTVAL
     INTO   l_batch_id,
            l_not_trx_id
     FROM   DUAL;

Line: 291

     INSERT INTO cn_not_trx_all (
       org_id,
       not_trx_id,
       batch_id,
       notified_date,
       processed_date,
       notification_run_id,
       collected_flag,
       source_trx_id,
       source_trx_line_id,
	  source_doc_type,
       adjusted_flag,
       event_id)
     VALUES
       (l_org_id,
       l_not_trx_id,
       l_batch_id,
       SYSDATE,
       SYSDATE,
       l_proc_audit_id,
       'N',
       p_header_id,
       p_line_id,
	  p_source_doc_type,
       p_adjusted_flag,
       l_event_id);

Line: 410

                 p_action_code  => 'I',     /* I - Insert  */
                 p_bind_data_id => l_bind_data_id,
                 p_OAI_param    => NULL,
                 p_OAI_array    => l_OAI_array,
                 x_return_code  => l_return_code);