APPS.ARP_LLCA_ADJUST_PKG SQL Statements

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

Line: 15

  SELECT sob.set_of_books_id,
         sob.chart_of_accounts_id,
         sob.currency_code,
         c.precision,
         c.minimum_accountable_unit,
         sysp.code_combination_id_gain,
         sysp.code_combination_id_loss,
         sysp.code_combination_id_round
  INTO   p_ae_sys_rec.set_of_books_id,
         p_ae_sys_rec.coa_id,
         p_ae_sys_rec.base_currency,
         p_ae_sys_rec.base_precision,
         p_ae_sys_rec.base_min_acc_unit,
         p_ae_sys_rec.gain_cc_id,
         p_ae_sys_rec.loss_cc_id,
         p_ae_sys_rec.round_cc_id
 FROM   ar_system_parameters sysp,
         gl_sets_of_books sob,
         fnd_currencies c
  WHERE  sob.set_of_books_id = sysp.set_of_books_id
  AND    sob.currency_code   = c.currency_code;

Line: 95

   Select sum(DECODE( lines.line_type,
                      'TAX',0,
                      'FREIGHT', 0,
                      1) * lines.amount_due_remaining) l_line_rem,
          sum(DECODE (lines.line_type,
                      'TAX', 1, 0) * lines.amount_due_remaining) l_tax_rem,
          MAX(DECODE(lines.line_type, 'LINE',
                     lines.line_number, 0))
      INTO
          l_line_rem,
          l_tax_rem,
          l_apply_to
      FROM ra_customer_trx ct,
           ra_customer_trx_lines lines
     WHERE (lines.customer_Trx_line_id = p_customer_trx_line_id or
            lines.link_to_cust_trx_line_id = p_customer_trx_line_id)
       AND  ct.customer_Trx_id = lines.customer_trx_id
       AND  ct.customer_trx_id = p_customer_trx_id;

Line: 115

   SELECT ar_activity_details_s.nextval
    INTO l_line_id
    FROM dual;

Line: 119

   INSERT INTO AR_ACTIVITY_DETAILS (
        LINE_ID,
        APPLY_TO,
        customer_trx_line_id,
        CASH_RECEIPT_ID,
        GROUP_ID,
        AMOUNT,
        TAX,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATE_LOGIN,
        LAST_UPDATE_DATE,
        LAST_UPDATED_BY,
        OBJECT_VERSION_NUMBER,
        CREATED_BY_MODULE,
        SOURCE_ID,
        SOURCE_TABLE
    )

    VALUES (
        l_line_id,                         -- line_id
        1,                                 -- APPLY_TO
        p_customer_trx_line_id,            -- customer_Trx_line_id
        NULL,                              -- cash_Receipt_id
        NULL,                              -- Group_ID (ll grp adj not implem)
        p_line_adjusted,                   -- Amount
        p_tax_adjusted,                    -- TAX
        NVL(FND_GLOBAL.user_id,-1),        -- Created_by
        SYSDATE,                           -- Creation_date
        decode(FND_GLOBAL.conc_login_id,
               null,FND_GLOBAL.login_id,
               -1, FND_GLOBAL.login_id,
               FND_GLOBAL.conc_login_id),  -- Last_update_login
        SYSDATE,                           -- Last_update_date
        NVL(FND_GLOBAL.user_id,-1),        -- last_updated_by
        0,                                 -- object_version_number
        'ARXTWADJ',                        -- created_by_module
        p_adj_id,                          -- source_id
        'ADJ'                              -- source_table
           );

Line: 176

      /* Insert lines into GT table for processing- if we have a line amt */
      IF (p_line_adjusted <> 0) THEN
         INSERT INTO AR_LINE_DIST_INTERFACE_GT
         (  GT_ID,
            SOURCE_ID,
            SOURCE_TABLE,
            CUSTOMER_TRX_ID,
            CUSTOMER_TRX_LINE_ID,
            LINE_TYPE,
            LINE_AMOUNT,
            ED_LINE_AMOUNT,
            UNED_LINE_AMOUNT)
         VALUES (
            l_gt_id,                  -- gt_id
            p_adj_id,                 -- source_id
            'ADJ'  ,                  -- source_table
            p_customer_trx_id,        -- customer_trx_id
            p_customer_trx_line_id,   -- customer_Trx_line_id
            'LINE',                   -- line_type
            p_line_adjusted,          -- line_amount
            NULL,                     -- ed_line_amount
            NULL                      -- uned_line_amount
         );

Line: 213

      SELECT *
        INTO l_adj_rec
        FROM ar_adjustments
       WHERE adjustment_id = p_adj_id;

Line: 218

      SELECT *
            INTO   l_trx_rec
            FROM   ra_customer_trx
            WHERE  customer_trx_id = p_customer_trx_id;

Line: 304

     SELECT  lines.extended_amount tax_amt,
             customer_trx_line_id
       FROM  ra_customer_trx_lines lines
      WHERE lines.line_type = 'TAX'
        AND lines.link_to_cust_trx_line_id = p_customer_trx_line_id;

Line: 315

  SELECT
       sum(tl.extended_amount),
       Count(tl.customer_Trx_line_id)
    INTO    l_sum,
            l_total_tax_lines
    FROM    ra_customer_trx_lines tl
   WHERE  tl.customer_trx_id = p_customer_trx_id
     AND  tl.link_to_cust_trx_line_id = p_customer_trx_line_id;

Line: 333

   SELECT tax_rounding_rule
     INTO l_rounding_rule
     FROM zx_product_options
    WHERE application_id = 222;

Line: 369

           the rounding before inserting into the gt table.  */
        IF ( l_row = l_total_tax_lines) THEN
           l_tax_proration := p_tax_adjusted - l_total_proration;

Line: 375

        INSERT INTO AR_LINE_DIST_INTERFACE_GT
         (  GT_ID,
            SOURCE_ID,
            SOURCE_TABLE,
            CUSTOMER_TRX_ID,
            CUSTOMER_TRX_LINE_ID,
            LINE_TYPE,
            TAX_AMOUNT,
            ED_TAX_AMOUNT,
            UNED_TAX_AMOUNT)
         VALUES (
            p_gt_id,                  -- gt_id
            p_adjustment_id,          -- source_id
            'ADJ'  ,                  -- source_table
            p_customer_trx_id,        -- customer_trx_id
            c_tl.customer_trx_line_id,   -- customer_Trx_line_id
            'TAX',                    -- line_type
            l_tax_proration,          -- tax_amount
            NULL,                     -- ed_tax_amount
            NULL                      -- uned_tax_amount
         );