APPS.JAI_CMN_RGM_TERMS_PKG SQL Statements

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

Line: 77

|| Insert values into jai_rgm_trm_schedules_t
|| Private procedure
***************************************************/

PROCEDURE insert_jai_rgm_trm_schedules_t
                                       (
                                         pn_schedule_id     IN  JAI_RGM_TRM_SCHEDULES_T.SCHEDULE_ID%TYPE        ,
                                         pn_instalment_no   IN  JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_NO%TYPE     ,
                                         pn_instalment_amt  IN  JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_AMOUNT%TYPE ,
                                         pd_instalment_date IN  JAI_RGM_TRM_SCHEDULES_T.INSTALLMENT_DATE%TYPE
                                       )
IS

  /* Added by Ramananda for bug#4407165 */
  lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_terms_pkg.insert_jai_rgm_trm_schedules_t';

Line: 95

  INSERT INTO jai_rgm_trm_schedules_t
  (
    SCHEDULE_ID         ,
    INSTALLMENT_NO      ,
    INSTALLMENT_AMOUNT  ,
    INSTALLMENT_DATE    ,
    CREATION_DATE       ,
    CREATED_BY          ,
    LAST_UPDATE_DATE    ,
    LAST_UPDATE_LOGIN   ,
    LAST_UPDATED_BY
  )
  VALUES
  (
    pn_schedule_id      ,
    pn_instalment_no    ,
    pn_instalment_amt   ,
    pd_instalment_date  ,
    SYSDATE             ,
    999999              ,
    SYSDATE             ,
    NULL                ,
    NULL
  ) ;

Line: 126

END insert_jai_rgm_trm_schedules_t ;

Line: 145

  SELECT
          start_period          ,
          DECODE ( start_period, 'NEXT_MONTH' , 1 , 'NEXT_QRTR' , 3 , 'NEXT_FIN_YEAR' , 12 ) ,
          start_day_of_month  ,
          start_frequency_day ,
          number_of_instalments ,
          instalment_frequency  ,
          instalment_period     ,
          DECODE ( instalment_period, 'MONTH' , 1 , 'QRTR' , 3 , 'YEAR' , 12 ) ,
          day_of_month ,
          frequency_day
  FROM
          jai_rgm_terms
  WHERE
          term_id = p_rgm_term_id ;

Line: 163

  SELECT
         jai_rgm_trm_schedules_t_s.nextval
  FROM
         dual ;

Line: 308

    || Insert the first instalment
    || on start_date
    */
    insert_jai_rgm_trm_schedules_t
                                 (
                                   p_schedule_id      ,
                                   1                  ,
                                   ln_instalment_amt  ,
                                   ld_start_date
                                 );

Line: 334

      || Insert the subsequent instalments
      */
      insert_jai_rgm_trm_schedules_t
                                   (
                                     p_schedule_id       ,
                                     cur_inst_no         ,
                                     ln_instalment_amt   ,
                                     ld_next_date
                                   ) ;

Line: 384

  SELECT attribute_value
  FROM   JAI_RGM_ORG_REGNS_V jorrv
  WHERE  jorrv.regime_id                 = p_regime_id
  AND    jorrv.attribute_code            = p_att_code
  AND    jorrv.attribute_type_code       = p_att_type_code
  AND    jorrv.organization_id           = p_org_id
  AND    jorrv.organization_type         = p_party_type
  AND    jorrv.location_id               = nvl ( p_loc_id , jorrv.location_id ) ;

Line: 395

  SELECT regime_code
  FROM   JAI_RGM_DEFINITIONS
  WHERE  regime_id = p_regime_id ;

Line: 409

  SELECT term_id
  FROM   JAI_RGM_TERM_ASSIGNS
  WHERE  NVL ( location_id       , p_loc_id         ) = p_loc_id
  AND    NVL ( organization_type , p_party_type     ) = p_party_type
  AND    NVL ( organization_id   , p_org_id         ) = p_org_id
  AND    NVL ( regime_regno      , p_reg_regno      ) = p_reg_regno
  AND    NVL ( regime_item_class , p_reg_item_class ) = p_reg_item_class
  AND    regime_id                                    = p_reg_id ;

Line: 553

SELECT term_in_use_flag
FROM   jai_rgm_terms
WHERE  term_id = p_term_id ;

Line: 588

    UPDATE  jai_rgm_terms
    SET     term_in_use_flag  = 'Y' ,
            last_update_date  = sysdate ,
            last_update_login = fnd_global.login_id ,
            last_updated_by   = fnd_global.user_id
    WHERE   term_id = p_term_id ;