APPS.JAI_AP_DVA_TRIGGER_PKG SQL Statements

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

Line: 25

  v_last_upd_dt       DATE; --   := pr_new.Last_Update_Date ;

Line: 26

  v_last_upd_by       NUMBER; -- := pr_new.Last_Updated_By;

Line: 27

  v_last_upd_login    NUMBER; -- := pr_new.Last_Update_Login;

Line: 36

  SELECT MAX( Vendor_Site_Id )
  FROM   Po_Vendor_Sites_All
  WHERE  Vendor_Site_Code = code;

Line: 41

  SELECT Vendor_Site_Code
  FROM   Po_Vendor_Sites_All
  WHERE  Vendor_Site_Id = v_dup_vendor_site_id;

Line: 49

  SELECT Excise_Duty_Region, Excise_Duty_Zone, Excise_Duty_Reg_No,
          Excise_Duty_Range, Excise_Duty_Division, Excise_Duty_Circle,
          Excise_Duty_Comm, St_Reg_No, Cst_Reg_No, Ec_Code,
          Tax_Category_List
  FROM   JAI_CMN_VENDOR_SITES
  WHERE  Vendor_Id = v_dup_vendor_id
  AND    Vendor_Site_Id = v_n_vendor_site_id;

Line: 102

  v_last_upd_dt        := pr_new.Last_Update_Date ;

Line: 103

  v_last_upd_by        := pr_new.Last_Updated_By;

Line: 104

  v_last_upd_login     := pr_new.Last_Update_Login;

Line: 113

  UPDATE JAI_CMN_VENDOR_SITES
  SET    Inactive_Flag = 'Y',
   Last_Updated_By = v_last_upd_by,
   Last_Update_Date = v_last_upd_dt,
   Last_Update_Login = v_last_upd_login
  WHERE  Vendor_id = v_dup_vendor_id
  AND    Vendor_Site_Id = v_dup_vendor_site_id;

Line: 121

 /* copied the below update from ja_in_po_tds_ins_supp_merg as part of its obsoletion */
  UPDATE JAI_CMN_VENDOR_SITES --Ja_In_Po_Vendor_Sites
  SET    Inactive_Flag = 'Y',
   Last_Updated_By = v_last_upd_by,
   Last_Update_Date = v_last_upd_dt,
   Last_Update_Login = v_last_upd_login
  WHERE  Vendor_id = v_dup_vendor_id
  AND    Vendor_Site_Id = 0;

Line: 143

      INSERT INTO JAI_CMN_VENDOR_SITES( VENDOR_ID,
           VENDOR_SITE_ID,
           EXCISE_DUTY_REGION,
           EXCISE_DUTY_ZONE,
           EXCISE_DUTY_REG_NO,
           EXCISE_DUTY_RANGE,
           EXCISE_DUTY_DIVISION,
           EXCISE_DUTY_CIRCLE,
           EXCISE_DUTY_COMM,
           ST_REG_NO,
           CST_REG_NO,
           EC_CODE,
           CREATION_DATE,
           CREATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_LOGIN,
           TAX_CATEGORY_LIST,
           INACTIVE_FLAG )
      VALUES
            ( v_vendor_id,
              v_n_vendor_site_id,
              Excise_Rec.Excise_Duty_Region,
              Excise_Rec.Excise_Duty_Zone,
              Excise_Rec.Excise_Duty_Reg_No,
              Excise_Rec.Excise_Duty_Range,
              Excise_Rec.Excise_Duty_Division,
              Excise_Rec.Excise_Duty_Circle,
              Excise_Rec.Excise_Duty_Comm,
              Excise_Rec.St_Reg_No,
              Excise_Rec.Cst_Reg_No,
              Excise_Rec.Ec_Code,
              v_cre_dt,
              v_cre_by,
              v_last_upd_dt,
              v_last_upd_by,
              v_last_upd_login,
              Excise_Rec.Tax_Category_List,
              NULL
    );