APPS.JAI_CMN_RGM_TERMS_PKG SQL Statements

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

Line: 83

|| 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: 101

  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: 132

END insert_jai_rgm_trm_schedules_t ;

Line: 153

	  SELECT
      rgtm.term_id
    , rgtm.number_of_instalments
    , rgci.installment_number
    , rgci.claim_interval
    , rgci.day_of_claim
    , rgci.month_of_claim
    , rgci.day_of_month
    , rgci.claim_percentage
	  FROM
      jai_rgm_terms                 rgtm
    , jai_rgm_term_installments     rgci
	  WHERE rgtm.term_id = rgci.term_id
      AND rgtm.term_id = pn_rgm_term_id
    ORDER BY installment_number;

Line: 173

  SELECT
         jai_rgm_trm_schedules_t_s.nextval
  FROM
         dual ;

Line: 558

      /* Insert into the temp table*/
      insert_jai_rgm_trm_schedules_t( p_schedule_id
                                    , ln_installment_number
                                    , ln_installment_amount
                                    , ld_installment_date
                                    );

Line: 607

  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: 618

  SELECT regime_code
  FROM   JAI_RGM_DEFINITIONS
  WHERE  regime_id = p_regime_id ;

Line: 632

  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: 776

SELECT term_in_use_flag
FROM   jai_rgm_terms
WHERE  term_id = p_term_id ;

Line: 811

    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 ;