APPS.IGIPMSMD SQL Statements

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

Line: 28

     SELECT dist.invoice_id, dist.set_of_books_id, dist.period_name, dist.amount
            , dist.distribution_line_number, dist.dist_code_combination_id
            , dist.description
     FROM   ap_invoice_distributions dist
     WHERE  dist.distribution_line_number = cp_distribution_line_number
     AND    dist.invoice_id               = cp_invoice_id
     ;

Line: 40

     SELECT ext_dist.*
     FROM   igi_mpp_ap_invoice_dists  ext_dist
     WHERE  ext_dist.distribution_line_number = cp_distribution_line_number
     AND    ext_dist.invoice_id               = cp_invoice_id
     ;

Line: 48

        SELECT  rr.rule_id, rr.type
        FROM    ra_rules rr
        where   rr.rule_id = cp_accounting_rule_id
        ;

Line: 54

        SELECT ras.period_number, ras.percent, ras.rule_id
        FROM   ra_rule_schedules ras
        WHERE  ras.rule_id = cp_accounting_rule_id
        ORDER BY period_number
        ;

Line: 79

      SELECT effective_period_num
      FROM   gl_period_statuses
      WHERE  application_id = AP_APPLICATION_ID
      AND    set_of_books_id = fp_sob_id
      AND    period_name    = fp_period_name
      ;

Line: 98

        SELECT  gps.effective_period_num, gps.period_name
        FROM    gl_period_statuses gps
        WHERE   gps.application_id = AP_APPLICATION_ID
        AND     gps.set_of_books_id = fp_sob_id
        AND     gps.adjustment_period_flag <> 'Y'
        AND     gps.effective_period_num   >= cp_eff_period_num
        ORDER BY gps.effective_period_num
        ;

Line: 141

        SELECT invoice_currency_code
        from   ap_invoices
        where  invoice_id = fp_invoice_id
        ;

Line: 171

        SELECT 'x'
        FROM   ra_rules
        WHERE  type = 'ACC_DUR'
        AND    rule_id = fp_accounting_rule_id
        ;

Line: 195

   PROCEDURE InsertRecord     ( p_mpp_dist_line_num in number
                              , p_dist              in c_dist%ROWTYPE
                              , p_period_name       in varchar2
                              , p_rule_id           in number
                              , p_amount            in number
                              )

   IS

   BEGIN
   --bug 3199481 fnd logging changes: sdixit: start block
       IF (l_state_level >=  l_debug_level ) THEN
          FND_LOG.STRING  (l_state_level , 'igi.pls.igipmmdb.IGIPMSMD.InsertRecord',
                          '>> >> ** Mpp dist line number '|| p_mpp_dist_line_num );

Line: 211

          FND_LOG.STRING  (l_state_level , 'igi.pls.igipmmdb.IGIPMSMD.InsertRecord',
                           '>> >> ** Mpp dist amount      '|| p_amount );

Line: 216

         INSERT INTO  igi_mpp_ap_invoice_dists_det
               ( mpp_dist_line_number
               , distribution_line_number
               , invoice_id
               , last_updated_by
               , code_combination_id
               , last_update_date
               , period_name
               , created_by
               , creation_date
               , accounting_rule_id
               , description
               , amount
               , last_update_login  ) values (
                 p_mpp_dist_line_num
               , p_dist.distribution_line_number
               , p_dist.invoice_id
               , g_user_id
               , p_dist.dist_code_combination_id
               , g_date
               , p_period_name
               , g_user_id
               , g_date
               , p_rule_id
               , p_dist.description
               , p_amount
               , g_login_id  ) ;

Line: 251

           SELECT  period_name
           FROM    gl_period_statuses
           where   application_id = AP_APPLICATION_ID
           and     set_of_books_id = fp_sob_id
           and     adjustment_period_flag = 'N'
           and     fp_date between start_date and end_date
           ;

Line: 349

                          '>> Inserting the record into MPP details...' );

Line: 353

              InsertRecord     ( p_mpp_dist_line_num
                         , p_dist
                         , l_period_name
                         , p_accounting_rule_id
                         , l_amount
                         ) ;

Line: 382

             SELECT  nvl(percent,0)/100  percent_value
             FROM    ra_rule_schedules
             WHERE   rule_id = fp_rule_id
             AND     period_number = 1
             ;

Line: 434

        InsertRecord     ( p_mpp_dist_line_num
                         , p_dist
                         , l_first_period_name
                         , p_accounting_rule_id
                         , l_amount
                         ) ;

Line: 487

                          '>> Inserting the record into MPP details...' );

Line: 490

             InsertRecord     ( p_mpp_dist_line_num
                         , p_dist
                         , l_period_name
                         , p_accounting_rule_id
                         , l_amount
                         ) ;

Line: 563

        UPDATE igi_mpp_ap_invoice_dists_det
        SET    amount = amount + l_running_amount
        WHERE  invoice_id  = l_dist.invoice_id
        AND    distribution_line_number = l_dist.distribution_line_number
        AND    mpp_dist_line_number     = l_mpp_dist_line_num
        ;

Line: 589

   PROCEDURE Update_MPP_Details
     ( p_invoice_id in number
     , p_distribution_line_number in number
     , p_accounting_rule_id       in number
     )   IS
   BEGIN
      NULL;

Line: 600

   PROCEDURE Delete_MPP_details
     ( p_invoice_id in number
     , p_distribution_line_number in number
     , p_accounting_rule_id       in number
     , p_ignore_mpp_flag          in number
     )
   IS
   BEGIN
      NULL;