APPS.CN_NOTIFY_AIA SQL Statements

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

Line: 29

    CURSOR batch_size IS SELECT system_batch_size FROM cn_repositories WHERE org_id = x_org_id;

Line: 43

    cn_process_audits_pkg.insert_row(x_rowid, x_proc_audit_id, NULL,
      'NOT', 'Notification run', NULL, NULL, NULL, NULL, NULL, SYSDATE, NULL, x_org_id);

Line: 57

    INSERT INTO  cn_not_trx (
        not_trx_id,
        batch_id,
        processed_date,
        notified_date,
        notification_run_id,
        collected_flag,
        event_id,
        source_trx_id,
        source_trx_line_id,
        source_doc_type,
        org_id)
      SELECT
        cn_not_trx_s.NEXTVAL,
        x_proc_audit_id,
        cco10143.processed_date,
        SYSDATE,
        x_proc_audit_id,
        'N',
        -1020,
        NULL,
        cco10143.trans_seq_id,     --*** Line Table Key Column
        'AIA',     --*** Source Type
        x_org_id
      FROM
        cn_collection_aia cco10143
      WHERE     --*** Header.Primary_Key = Line.Foreign_Key
        1 = 1
        AND TRUNC(processed_date) BETWEEN x_start_date AND x_end_date
          AND NOT EXISTS (
            SELECT 1
            FROM  cn_not_trx
            WHERE source_trx_line_id = cco10143.trans_seq_id     --*** Line.Primary_Key
            AND   event_id = -1020
            AND   org_id = x_org_id);

Line: 97

    cn_process_audits_pkg.update_row(x_proc_audit_id, NULL, SYSDATE, 0,
      'Finished notification run: Notified ' || x_trx_count || ' aia records.');

Line: 102

      cn_message_pkg.debug('notify_aia: No rows inserted into CN_NOT_TRX. Possible reason: Transactions have not been posted to AIA Interface table and processed date is null.');

Line: 103

      fnd_file.put_line(fnd_file.Log, 'notify_aia: No rows inserted into CN_NOT_TRX. Possible reason: Transactions have not been posted to AIA Interface table and processed date is null.');

Line: 123

    cn_process_audits_pkg.update_row(X_proc_audit_id, NULL, SYSDATE, SQLCODE,
      SQLERRM);