APPS.AMS_IBA_PL_PLACEMENTS_B_PKG SQL Statements

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

Line: 35

PROCEDURE Insert_Row(
          px_placement_id   IN OUT NOCOPY NUMBER,
          p_site_id    NUMBER,
          p_site_ref_code    VARCHAR2,
          p_page_id    NUMBER,
          p_page_ref_code    VARCHAR2,
          p_location_code    VARCHAR2,
          p_param1    VARCHAR2,
          p_param2    VARCHAR2,
          p_param3    VARCHAR2,
          p_param4    VARCHAR2,
          p_param5    VARCHAR2,
          p_stylesheet_id    NUMBER,
          p_posting_id    NUMBER,
          p_status_code    VARCHAR2,
          p_track_events_flag    VARCHAR2,
          p_created_by    NUMBER,
          p_creation_date    DATE,
          p_last_updated_by    NUMBER,
          p_last_update_date    DATE,
          p_last_update_login    NUMBER,
          px_object_version_number   IN OUT NOCOPY NUMBER,
          p_name in VARCHAR2,
          p_description in VARCHAR2
)

 IS
   x_rowid    VARCHAR2(30);

Line: 71

   INSERT INTO AMS_IBA_PL_PLACEMENTS_B(
           placement_id,
           site_id,
           site_ref_code,
           page_id,
           page_ref_code,
           location_code,
           param1,
           param2,
           param3,
           param4,
           param5,
           stylesheet_id,
           posting_id,
           status_code,
           track_events_flag,
           created_by,
           creation_date,
           last_updated_by,
           last_update_date,
           last_update_login,
           object_version_number
   ) VALUES (
           DECODE( px_placement_id, FND_API.g_miss_num, NULL, px_placement_id),
           DECODE( p_site_id, FND_API.g_miss_num, NULL, p_site_id),
           DECODE( p_site_ref_code, FND_API.g_miss_char, NULL, p_site_ref_code),
           DECODE( p_page_id, FND_API.g_miss_num, NULL, p_page_id),
           DECODE( p_page_ref_code, FND_API.g_miss_char, NULL, p_page_ref_code),
           DECODE( p_location_code, FND_API.g_miss_char, NULL, p_location_code),
           DECODE( p_param1, FND_API.g_miss_char, NULL, p_param1),
           DECODE( p_param2, FND_API.g_miss_char, NULL, p_param2),
           DECODE( p_param3, FND_API.g_miss_char, NULL, p_param3),
           DECODE( p_param4, FND_API.g_miss_char, NULL, p_param4),
           DECODE( p_param5, FND_API.g_miss_char, NULL, p_param5),
           DECODE( p_stylesheet_id, FND_API.g_miss_num, NULL, p_stylesheet_id),
           DECODE( p_posting_id, FND_API.g_miss_num, NULL, p_posting_id),
           DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
           DECODE( p_track_events_flag, FND_API.g_miss_char, NULL, p_track_events_flag),
           DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
           DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
           DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
           DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
           DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
           DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));

Line: 116

  insert into AMS_IBA_PL_PLACEMENTS_TL (
    PLACEMENT_ID,
    NAME,
    DESCRIPTION,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    OBJECT_VERSION_NUMBER,
    LANGUAGE,
    SOURCE_LANG
  ) select
        DECODE( px_placement_id, FND_API.g_miss_num, NULL, px_placement_id),
        DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
	DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
        DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
        DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
        DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
        DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
        DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
        DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
        l.language_code,
        userenv('LANG')
  FROM fnd_languages l
  WHERE l.installed_flag IN ('I', 'B')
  AND NOT EXISTS
    (SELECT NULL
    FROM ams_iba_pl_placements_tl t
    WHERE t.placement_id = DECODE( px_placement_id, FND_API.g_miss_num, NULL, px_placement_id)
    AND t.language = l.language_code);

Line: 148

END Insert_Row;

Line: 167

PROCEDURE Update_Row(
          p_placement_id    NUMBER,
          p_site_id    NUMBER,
          p_site_ref_code    VARCHAR2,
          p_page_id    NUMBER,
          p_page_ref_code    VARCHAR2,
          p_location_code    VARCHAR2,
          p_param1    VARCHAR2,
          p_param2    VARCHAR2,
          p_param3    VARCHAR2,
          p_param4    VARCHAR2,
          p_param5    VARCHAR2,
          p_stylesheet_id    NUMBER,
          p_posting_id    NUMBER,
          p_status_code    VARCHAR2,
          p_track_events_flag    VARCHAR2,
          p_created_by    NUMBER,
          p_creation_date    DATE,
          p_last_updated_by    NUMBER,
          p_last_update_date    DATE,
          p_last_update_login    NUMBER,
          p_object_version_number    NUMBER,
          p_name        VARCHAR2,
          p_description VARCHAR2)

 IS
 BEGIN
    Update AMS_IBA_PL_PLACEMENTS_B
    SET
              site_id = DECODE( p_site_id, FND_API.g_miss_num, site_id, p_site_id),
              site_ref_code = DECODE( p_site_ref_code, FND_API.g_miss_char, site_ref_code, p_site_ref_code),
              page_id = DECODE( p_page_id, FND_API.g_miss_num, page_id, p_page_id),
              page_ref_code = DECODE( p_page_ref_code, FND_API.g_miss_char, page_ref_code, p_page_ref_code),
              location_code = DECODE( p_location_code, FND_API.g_miss_char, location_code, p_location_code),
              param1 = DECODE( p_param1, FND_API.g_miss_char, param1, p_param1),
              param2 = DECODE( p_param2, FND_API.g_miss_char, param2, p_param2),
              param3 = DECODE( p_param3, FND_API.g_miss_char, param3, p_param3),
              param4 = DECODE( p_param4, FND_API.g_miss_char, param4, p_param4),
              param5 = DECODE( p_param5, FND_API.g_miss_char, param5, p_param5),
              stylesheet_id = DECODE( p_stylesheet_id, FND_API.g_miss_num, stylesheet_id, p_stylesheet_id),
              posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),
              status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
              track_events_flag = DECODE( p_track_events_flag, FND_API.g_miss_char, track_events_flag, p_track_events_flag),
              last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
              last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
              last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
              object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number)
   WHERE PLACEMENT_ID = p_PLACEMENT_ID
   AND   object_version_number = p_object_version_number;

Line: 221

  UPDATE ams_iba_pl_placements_tl SET
    name = DECODE(p_name,FND_API.g_miss_char,name,p_name),
    description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
    last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
    last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
    last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
    source_lang = USERENV('LANG')
  WHERE placement_id = p_placement_id
  AND USERENV('LANG') IN (language, source_lang);

Line: 235

END Update_Row;

Line: 254

PROCEDURE Delete_Row(
    p_placement_id  NUMBER)
 IS
 BEGIN

   DELETE FROM ams_iba_pl_placements_tl
   WHERE placement_id = p_placement_id;

Line: 267

   DELETE FROM ams_iba_pl_placements_b
   WHERE placement_id = p_placement_id;

Line: 274

 END Delete_Row ;

Line: 279

  delete from AMS_IBA_PL_PLACEMENTS_TL T
  where not exists
    (select NULL
    from AMS_IBA_PL_PLACEMENTS_B B
    where B.PLACEMENT_ID = T.PLACEMENT_ID
    );

Line: 286

  update AMS_IBA_PL_PLACEMENTS_TL T set (
      NAME,
      description
    ) = (select
      B.NAME,
      B.description
    from AMS_IBA_PL_PLACEMENTS_TL B
    where B.PLACEMENT_ID = T.PLACEMENT_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.PLACEMENT_ID,
      T.LANGUAGE
  ) in (select
      SUBT.PLACEMENT_ID,
      SUBT.LANGUAGE
    from AMS_IBA_PL_PLACEMENTS_TL SUBB, AMS_IBA_PL_PLACEMENTS_TL SUBT
    where SUBB.PLACEMENT_ID = SUBT.PLACEMENT_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.NAME <> SUBT.NAME
      or SUBB.LANGUAGE <> SUBT.LANGUAGE
  ));

Line: 308

  insert into AMS_IBA_PL_PLACEMENTS_TL (
    OBJECT_VERSION_NUMBER,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    PLACEMENT_ID,
    NAME,
    DESCRIPTION,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.OBJECT_VERSION_NUMBER,
    B.CREATED_BY,
    B.CREATION_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATE_LOGIN,
    B.PLACEMENT_ID,
    B.NAME,
    B.DESCRIPTION,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from AMS_IBA_PL_PLACEMENTS_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from AMS_IBA_PL_PLACEMENTS_TL T
    where T.PLACEMENT_ID = B.PLACEMENT_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 377

          p_last_updated_by    NUMBER,
          p_last_update_date    DATE,
          p_last_update_login    NUMBER,
          p_object_version_number    NUMBER)

 IS
   CURSOR C IS
        SELECT *
         FROM AMS_IBA_PL_PLACEMENTS_B
        WHERE PLACEMENT_ID =  p_PLACEMENT_ID
        FOR UPDATE of PLACEMENT_ID NOWAIT;

Line: 394

        FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

Line: 448

       AND (    ( Recinfo.last_updated_by = p_last_updated_by)
            OR (    ( Recinfo.last_updated_by IS NULL )
                AND (  p_last_updated_by IS NULL )))
       AND (    ( Recinfo.last_update_date = p_last_update_date)
            OR (    ( Recinfo.last_update_date IS NULL )
                AND (  p_last_update_date IS NULL )))
       AND (    ( Recinfo.last_update_login = p_last_update_login)
            OR (    ( Recinfo.last_update_login IS NULL )
                AND (  p_last_update_login IS NULL )))
       AND (    ( Recinfo.object_version_number = p_object_version_number)
            OR (    ( Recinfo.object_version_number IS NULL )
                AND (  p_object_version_number IS NULL )))
       ) THEN
       RETURN;