eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_NEG_STYLES_TL_PKG SQL Statements

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

Line: 4


PROCEDURE insert_row (
     p_style_id                      IN  pon_negotiation_styles.style_id%TYPE
    ,p_status                        IN  pon_negotiation_styles.status%TYPE
    ,p_system_flag                   IN  pon_negotiation_styles.system_flag%TYPE
    ,p_line_attribute_enabled_flag   IN  pon_negotiation_styles.line_attribute_enabled_flag%TYPE
    ,p_line_mas_enabled_flag         IN  pon_negotiation_styles.line_mas_enabled_flag%TYPE
    ,p_price_element_enabled_flag    IN  pon_negotiation_styles.price_element_enabled_flag%TYPE
    ,p_rfi_line_enabled_flag         IN  pon_negotiation_styles.rfi_line_enabled_flag%TYPE
    ,p_lot_enabled_flag              IN  pon_negotiation_styles.lot_enabled_flag%TYPE
    ,p_group_enabled_flag            IN  pon_negotiation_styles.group_enabled_flag%TYPE
    ,p_large_neg_enabled_flag        IN  pon_negotiation_styles.large_neg_enabled_flag%TYPE
    ,p_hdr_attribute_enabled_flag    IN  pon_negotiation_styles.hdr_attribute_enabled_flag%TYPE
    ,p_neg_team_enabled_flag         IN  pon_negotiation_styles.neg_team_enabled_flag%TYPE
    ,p_proxy_bidding_enabled_flag    IN  pon_negotiation_styles.proxy_bidding_enabled_flag%TYPE
    ,p_power_bidding_enabled_flag    IN  pon_negotiation_styles.power_bidding_enabled_flag%TYPE
    ,p_auto_extend_enabled_flag      IN  pon_negotiation_styles.auto_extend_enabled_flag%TYPE
    ,p_team_scoring_enabled_flag     IN  pon_negotiation_styles.team_scoring_enabled_flag%TYPE
    ,p_creation_date                 IN  pon_negotiation_styles.creation_date%TYPE
    ,p_created_by                    IN  pon_negotiation_styles.created_by%TYPE
    ,p_last_update_date              IN  pon_negotiation_styles.last_update_date%TYPE
    ,p_last_updated_by               IN  pon_negotiation_styles.last_updated_by%TYPE
    ,p_last_update_login             IN  pon_negotiation_styles.last_update_login%TYPE
    ,p_qty_price_tiers_enabled_flag  IN  pon_negotiation_styles.qty_price_tiers_enabled_flag%TYPE
    ,p_style_name                    IN  pon_negotiation_styles_tl.style_name%TYPE
    ,p_description                   IN  pon_negotiation_styles_tl.description%TYPE) IS

BEGIN

  INSERT INTO pon_negotiation_styles
     (style_id
     ,status
     ,system_flag
     ,line_attribute_enabled_flag
     ,line_mas_enabled_flag
     ,price_element_enabled_flag
     ,rfi_line_enabled_flag
     ,lot_enabled_flag
     ,group_enabled_flag
     ,large_neg_enabled_flag
     ,hdr_attribute_enabled_flag
     ,neg_team_enabled_flag
     ,proxy_bidding_enabled_flag
     ,power_bidding_enabled_flag
     ,auto_extend_enabled_flag
     ,team_scoring_enabled_flag
     ,creation_date
     ,created_by
     ,last_update_date
     ,last_updated_by
     ,last_update_login
     ,qty_price_tiers_enabled_flag)
  VALUES
     (p_style_id
     ,p_status
     ,p_system_flag
     ,p_line_attribute_enabled_flag
     ,p_line_mas_enabled_flag
     ,p_price_element_enabled_flag
     ,p_rfi_line_enabled_flag
     ,p_lot_enabled_flag
     ,p_group_enabled_flag
     ,p_large_neg_enabled_flag
     ,p_hdr_attribute_enabled_flag
     ,p_neg_team_enabled_flag
     ,p_proxy_bidding_enabled_flag
     ,p_power_bidding_enabled_flag
     ,p_auto_extend_enabled_flag
     ,p_team_scoring_enabled_flag
     ,p_creation_date
     ,p_created_by
     ,p_last_update_date
     ,p_last_updated_by
     ,p_last_update_login
     ,p_qty_price_tiers_enabled_flag);

Line: 79


  INSERT INTO pon_negotiation_styles_tl
      (style_id
      ,style_name
      ,description
      ,language
      ,source_lang
      ,creation_date
      ,created_by
      ,last_update_date
      ,last_updated_by
      ,last_update_login)
    SELECT
       p_style_id
      ,p_style_name
      ,p_description
      ,l.language_code
      ,USERENV('LANG')
      ,p_creation_date
      ,p_created_by
      ,p_last_update_date
      ,p_last_updated_by
      ,p_last_update_login
     FROM
       fnd_languages l
     WHERE installed_flag  in ('I', 'B')
       AND NOT EXISTS
         (SELECT NULL
	    FROM pon_negotiation_styles_tl tl
	   WHERE tl.style_id        = p_style_id
	     AND tl.language        = l.language_code);

Line: 110


END insert_row;

Line: 112


PROCEDURE update_row (
    p_style_id                       IN  pon_negotiation_styles.style_id%TYPE
    ,p_status                        IN  pon_negotiation_styles.status%TYPE
    ,p_system_flag                   IN  pon_negotiation_styles.system_flag%TYPE
    ,p_line_attribute_enabled_flag   IN  pon_negotiation_styles.line_attribute_enabled_flag%TYPE
    ,p_line_mas_enabled_flag         IN  pon_negotiation_styles.line_mas_enabled_flag%TYPE
    ,p_price_element_enabled_flag    IN  pon_negotiation_styles.price_element_enabled_flag%TYPE
    ,p_rfi_line_enabled_flag         IN  pon_negotiation_styles.rfi_line_enabled_flag%TYPE
    ,p_lot_enabled_flag              IN  pon_negotiation_styles.lot_enabled_flag%TYPE
    ,p_group_enabled_flag            IN  pon_negotiation_styles.group_enabled_flag%TYPE
    ,p_large_neg_enabled_flag        IN  pon_negotiation_styles.large_neg_enabled_flag%TYPE
    ,p_hdr_attribute_enabled_flag    IN  pon_negotiation_styles.hdr_attribute_enabled_flag%TYPE
    ,p_neg_team_enabled_flag         IN  pon_negotiation_styles.neg_team_enabled_flag%TYPE
    ,p_proxy_bidding_enabled_flag    IN  pon_negotiation_styles.proxy_bidding_enabled_flag%TYPE
    ,p_power_bidding_enabled_flag    IN  pon_negotiation_styles.power_bidding_enabled_flag%TYPE
    ,p_auto_extend_enabled_flag      IN  pon_negotiation_styles.auto_extend_enabled_flag%TYPE
    ,p_team_scoring_enabled_flag     IN  pon_negotiation_styles.team_scoring_enabled_flag%TYPE
    ,p_last_update_date              IN  pon_negotiation_styles.last_update_date%TYPE
    ,p_last_updated_by               IN  pon_negotiation_styles.last_updated_by%TYPE
    ,p_last_update_login             IN  pon_negotiation_styles.last_update_login%TYPE
    ,p_qty_price_tiers_enabled_flag  IN  pon_negotiation_styles.qty_price_tiers_enabled_flag%TYPE
    ,p_style_name                    IN  pon_negotiation_styles_tl.style_name%TYPE
    ,p_description                   IN  pon_negotiation_styles_tl.description%TYPE) IS
BEGIN

   UPDATE pon_negotiation_styles
      SET status                       = p_status
          ,system_flag                 = p_system_flag
          ,line_attribute_enabled_flag = p_line_attribute_enabled_flag
          ,line_mas_enabled_flag       = p_line_mas_enabled_flag
          ,price_element_enabled_flag  = p_price_element_enabled_flag
          ,rfi_line_enabled_flag       = p_rfi_line_enabled_flag
          ,lot_enabled_flag            = p_lot_enabled_flag
          ,group_enabled_flag          = p_group_enabled_flag
          ,large_neg_enabled_flag      = p_large_neg_enabled_flag
          ,hdr_attribute_enabled_flag  = p_hdr_attribute_enabled_flag
          ,neg_team_enabled_flag       = p_neg_team_enabled_flag
          ,proxy_bidding_enabled_flag  = p_proxy_bidding_enabled_flag
          ,power_bidding_enabled_flag  = p_power_bidding_enabled_flag
          ,auto_extend_enabled_flag    = p_auto_extend_enabled_flag
          ,team_scoring_enabled_flag   = p_team_scoring_enabled_flag
          ,last_update_date            = p_last_update_date
          ,last_updated_by             = p_last_updated_by
          ,last_update_login           = p_last_update_login
          ,qty_price_tiers_enabled_flag = p_qty_price_tiers_enabled_flag
     WHERE style_id = p_style_id;

Line: 165


   UPDATE pon_negotiation_styles_tl
      SET  style_name                  = p_style_name
           ,description                = p_description
           ,last_update_date           = p_last_update_date
           ,last_updated_by            = p_last_updated_by
           ,last_update_login          = p_last_update_login
           ,source_lang                = userenv('LANG')
    WHERE style_id = p_style_id
    AND USERENV('LANG') IN (language, source_lang);

Line: 180


END update_row;

Line: 190


     p_last_update_date             IN  VARCHAR2) IS

   f_luby    number;  -- entity owner in file

Line: 193


   f_ludate  date;    -- entity update date in file

Line: 195


   db_ludate date;    -- entity update date in db

Line: 203


   f_ludate := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 205


   select LAST_UPDATED_BY, LAST_UPDATE_DATE
   into db_luby, db_ludate
   from pon_negotiation_styles_tl
   where style_id = p_style_id
   and userenv('LANG') = LANGUAGE;

Line: 212


     UPDATE pon_negotiation_styles_tl
        SET style_name              = p_style_name
            ,description            = p_description
            ,last_update_date       = f_ludate
            ,last_updated_by        = f_luby
            ,last_update_login      = 0
            ,source_lang            = userenv('LANG')
      WHERE style_id = p_style_id
        AND USERENV('LANG') IN (language, source_lang);

Line: 235


    ,p_last_update_date              IN  VARCHAR2
    ,p_custom_mode                   IN  VARCHAR2
    ,p_status                        IN  pon_negotiation_styles.status%TYPE
    ,p_system_flag                   IN  pon_negotiation_styles.system_flag%TYPE
    ,p_line_attribute_enabled_flag   IN  pon_negotiation_styles.line_attribute_enabled_flag%TYPE
    ,p_line_mas_enabled_flag         IN  pon_negotiation_styles.line_mas_enabled_flag%TYPE
    ,p_price_element_enabled_flag    IN  pon_negotiation_styles.price_element_enabled_flag%TYPE
    ,p_rfi_line_enabled_flag         IN  pon_negotiation_styles.rfi_line_enabled_flag%TYPE
    ,p_lot_enabled_flag              IN  pon_negotiation_styles.lot_enabled_flag%TYPE
    ,p_group_enabled_flag            IN  pon_negotiation_styles.group_enabled_flag%TYPE
    ,p_large_neg_enabled_flag        IN  pon_negotiation_styles.large_neg_enabled_flag%TYPE
    ,p_hdr_attribute_enabled_flag    IN  pon_negotiation_styles.hdr_attribute_enabled_flag%TYPE
    ,p_neg_team_enabled_flag         IN  pon_negotiation_styles.neg_team_enabled_flag%TYPE
    ,p_proxy_bidding_enabled_flag    IN  pon_negotiation_styles.proxy_bidding_enabled_flag%TYPE
    ,p_power_bidding_enabled_flag    IN  pon_negotiation_styles.power_bidding_enabled_flag%TYPE
    ,p_auto_extend_enabled_flag      IN  pon_negotiation_styles.auto_extend_enabled_flag%TYPE
    ,p_team_scoring_enabled_flag     IN  pon_negotiation_styles.team_scoring_enabled_flag%TYPE
    ,p_qty_price_tiers_enabled_flag  IN  pon_negotiation_styles.qty_price_tiers_enabled_flag%TYPE
    ,p_style_name                    IN  pon_negotiation_styles_tl.style_name%TYPE
    ,p_description                   IN  pon_negotiation_styles_tl.description%TYPE) IS
 -- Last update information from the file being uploaded
    l_f_last_updated_by               pon_negotiation_styles.last_updated_by%TYPE;

Line: 257


    l_f_last_update_date              pon_negotiation_styles.last_update_date%TYPE;

Line: 260


    l_db_last_updated_by              pon_negotiation_styles.last_updated_by%TYPE;

Line: 261


    l_db_last_update_date             pon_negotiation_styles.last_update_date%TYPE;

Line: 268


    l_f_last_updated_by := fnd_load_util.OWNER_ID(p_owner);

Line: 271


    l_f_last_update_date := NVL(TO_DATE(p_last_update_date, 'YYYY/MM/DD'), SYSDATE);

Line: 273


    SELECT last_updated_by,
           last_update_date
      INTO l_db_last_updated_by,
           l_db_last_update_date
      FROM pon_negotiation_styles
     WHERE style_id = p_style_id;

Line: 281


   update_row (
    p_style_id                       => p_style_id
    ,p_status                        => p_status
    ,p_system_flag                   => p_system_flag
    ,p_line_attribute_enabled_flag   => p_line_attribute_enabled_flag
    ,p_line_mas_enabled_flag         => p_line_mas_enabled_flag
    ,p_price_element_enabled_flag    => p_price_element_enabled_flag
    ,p_rfi_line_enabled_flag         => p_rfi_line_enabled_flag
    ,p_lot_enabled_flag              => p_lot_enabled_flag
    ,p_group_enabled_flag            => p_group_enabled_flag
    ,p_large_neg_enabled_flag        => p_large_neg_enabled_flag
    ,p_hdr_attribute_enabled_flag    => p_hdr_attribute_enabled_flag
    ,p_neg_team_enabled_flag         => p_neg_team_enabled_flag
    ,p_proxy_bidding_enabled_flag    => p_proxy_bidding_enabled_flag
    ,p_power_bidding_enabled_flag    => p_power_bidding_enabled_flag
    ,p_auto_extend_enabled_flag      => p_auto_extend_enabled_flag
    ,p_team_scoring_enabled_flag     => p_team_scoring_enabled_flag
    ,p_last_update_date              => l_f_last_update_date
    ,p_last_updated_by               => l_f_last_updated_by
    ,p_last_update_login             => 0
    ,p_qty_price_tiers_enabled_flag  => p_qty_price_tiers_enabled_flag
    ,p_style_name                    => p_style_name
    ,p_description                   => p_description);

Line: 311


   insert_row (
     p_style_id                      =>  p_style_id
    ,p_status                        =>  p_status
    ,p_system_flag                   =>  p_system_flag
    ,p_line_attribute_enabled_flag   =>  p_line_attribute_enabled_flag
    ,p_line_mas_enabled_flag         =>  p_line_mas_enabled_flag
    ,p_price_element_enabled_flag    =>  p_price_element_enabled_flag
    ,p_rfi_line_enabled_flag         =>  p_rfi_line_enabled_flag
    ,p_lot_enabled_flag              =>  p_lot_enabled_flag
    ,p_group_enabled_flag            =>  p_group_enabled_flag
    ,p_large_neg_enabled_flag        =>  p_large_neg_enabled_flag
    ,p_hdr_attribute_enabled_flag    =>  p_hdr_attribute_enabled_flag
    ,p_neg_team_enabled_flag         =>  p_neg_team_enabled_flag
    ,p_proxy_bidding_enabled_flag    =>  p_proxy_bidding_enabled_flag
    ,p_power_bidding_enabled_flag    =>  p_power_bidding_enabled_flag
    ,p_auto_extend_enabled_flag      =>  p_auto_extend_enabled_flag
    ,p_team_scoring_enabled_flag     =>  p_team_scoring_enabled_flag
    ,p_creation_date                 =>  l_f_last_update_date
    ,p_created_by                    =>  l_f_last_updated_by
    ,p_last_update_date              =>  l_f_last_update_date
    ,p_last_updated_by               =>  l_f_last_updated_by
    ,p_last_update_login             =>  0
    ,p_qty_price_tiers_enabled_flag  =>  p_qty_price_tiers_enabled_flag
    ,p_style_name                    =>  p_style_name
    ,p_description                   =>  p_description);

Line: 339


PROCEDURE delete_row (
    p_style_id                 IN  pon_negotiation_styles.style_id%TYPE
) IS

BEGIN

   DELETE FROM pon_negotiation_styles
         WHERE style_id = p_style_id;

Line: 353


   DELETE FROM pon_negotiation_styles_tl
         WHERE style_id = p_style_id;

Line: 356


END delete_row;

Line: 363


    INSERT INTO pon_negotiation_styles_TL (
      style_id,
      style_name,
      description,
      language,
      source_lang,
      creation_date,
      created_by,
      last_update_date,
      last_updated_by,
      last_update_login
    )
    SELECT
      style_id,
      style_name,
      description,
      lang.language_code,
      source_lang,
      tl.creation_date,
      tl.created_by,
      tl.last_update_date,
      tl.last_updated_by,
      tl.last_update_login
    FROM pon_negotiation_styles_tl tl,
         fnd_languages lang
    WHERE language = USERENV('LANG')
    AND lang.INSTALLED_FLAG in ('I', 'B')
    AND NOT EXISTS (SELECT NULL
                      FROM pon_negotiation_styles_TL tl2
                     WHERE tl2.style_id = tl.style_id
                       AND tl2.language = lang.language_code);