APPS.AR_DEFERRAL_REASONS_GRP SQL Statements

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

Line: 109

    SELECT customer_trx_line_id, customer_trx_id
    FROM   ra_customer_trx_lines
    WHERE  interface_line_context    = p_order_line.interface_line_context
    AND    interface_line_attribute1 = p_order_line.interface_line_attribute1
    AND    interface_line_attribute2 = p_order_line.interface_line_attribute2
    AND    interface_line_attribute3 = p_order_line.interface_line_attribute3
    AND    interface_line_attribute4 = p_order_line.interface_line_attribute4
    AND    interface_line_attribute5 = p_order_line.interface_line_attribute5
    AND    interface_line_attribute6 = p_order_line.interface_line_attribute6;

Line: 120

    SELECT child.customer_trx_line_id, child.customer_trx_id
    FROM   ra_customer_trx_lines pline,
           ar_deferred_lines     child
    WHERE  pline.customer_trx_line_id = parent_trx_line_id
    AND    pline.interface_line_context = g_om_context
    AND    child.parent_line_id = to_number(pline.interface_line_attribute6);

Line: 245

  /* This updates parent or target lines */
  IF l_target_in_ar = FALSE
  THEN
     UPDATE AR_INTERFACE_CONTS ic
     SET    COMPLETED_FLAG = 'Y',
            EXPIRATION_DATE = sysdate
     WHERE  ic.interface_line_context = g_om_context
     AND    interface_line_context    = p_order_line.interface_line_context
     AND    interface_line_attribute1 = p_order_line.interface_line_attribute1
     AND    interface_line_attribute2 = p_order_line.interface_line_attribute2
     AND    interface_line_attribute3 = p_order_line.interface_line_attribute3
     AND    interface_line_attribute4 = p_order_line.interface_line_attribute4
     AND    interface_line_attribute5 = p_order_line.interface_line_attribute5
     AND    interface_line_attribute6 = p_order_line.interface_line_attribute6
     AND EXISTS (SELECT 'acceptance contingency'
                 FROM   ar_deferral_reasons dr
                 WHERE  dr.contingency_id = ic.contingency_id
                 AND    dr.revrec_event_code = 'CUSTOMER_ACCEPTANCE');

Line: 267

        arp_debug.debug('  parent interface lines updated : ' || l_rows);

Line: 271

  /* This updates any child lines in interface table */
  UPDATE AR_INTERFACE_CONTS ic
  SET    COMPLETED_FLAG = 'Y',
         EXPIRATION_DATE = sysdate
  WHERE  interface_line_context = g_om_context
  AND    nvl(completed_flag, 'N') = 'N'
  AND EXISTS (SELECT 'child exists'
              FROM   ra_interface_lines il
              WHERE  il.parent_line_id =
                to_number(p_order_line.interface_line_attribute6)
              AND    il.interface_line_context = ic.interface_line_context
              AND    il.interface_line_attribute1 = ic.interface_line_attribute1
              AND    il.interface_line_attribute2 = ic.interface_line_attribute2
              AND    il.interface_line_attribute3 = ic.interface_line_attribute3
              AND    il.interface_line_attribute4 = ic.interface_line_attribute4
              AND    il.interface_line_attribute5 = ic.interface_line_attribute5
              AND    il.interface_line_attribute6 = ic.interface_line_attribute6)
  AND EXISTS (SELECT 'acceptance contingency'
              FROM   ar_deferral_reasons dr
              WHERE  dr.contingency_id = ic.contingency_id
              AND    dr.revrec_event_code = 'CUSTOMER_ACCEPTANCE');

Line: 296

     arp_debug.debug('  child interface lines updated : ' || l_rows);

Line: 350

    SELECT wdd.source_line_id order_line_id
    FROM   wsh_delivery_details wdd,
           wsh_delivery_assignments wda
    WHERE  wdd.delivery_detail_id = wda.delivery_detail_id
    AND    wda.delivery_id = p_delivery_id;

Line: 357

    SELECT customer_trx_line_id, customer_trx_id
    FROM   ra_customer_trx_lines
    WHERE  interface_line_context    = p_order_line.interface_line_context
    AND    interface_line_attribute1 = p_order_line.interface_line_attribute1
    AND    interface_line_attribute1 = p_order_line.interface_line_attribute2
    AND    interface_line_attribute1 = p_order_line.interface_line_attribute3
    AND    interface_line_attribute1 = p_order_line.interface_line_attribute4
    AND    interface_line_attribute1 = p_order_line.interface_line_attribute5
    AND    interface_line_attribute1 = p_order_line.interface_line_attribute6;