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.AHL_SUBSCRIPTIONS_PKG SQL Statements

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

Line: 3


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_SUBSCRIPTION_ID in NUMBER,
  X_ATTRIBUTE5 in VARCHAR2,
  X_DOCUMENT_ID in NUMBER,
  X_REQUESTED_BY_PARTY_ID in NUMBER,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_ATTRIBUTE15 in VARCHAR2,
  X_SUBSCRIBED_FRM_PARTY_ID in NUMBER,
  X_QUANTITY in NUMBER,
  X_STATUS_CODE in VARCHAR2,
  X_PURCHASE_ORDER_NO in VARCHAR2,
  X_FREQUENCY_CODE in VARCHAR2,
  X_SUBSCRIPTION_TYPE_CODE in VARCHAR2,
  X_MEDIA_TYPE_CODE in VARCHAR2,
  X_START_DATE in DATE,
  X_END_DATE in DATE,
  X_COMMENTS in VARCHAR2,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
  cursor C is select ROWID from AHL_SUBSCRIPTIONS_B
    where SUBSCRIPTION_ID = X_SUBSCRIPTION_ID
    ;

Line: 45


  insert into AHL_SUBSCRIPTIONS_B (
    ATTRIBUTE5,
    SUBSCRIPTION_ID,
    DOCUMENT_ID,
    REQUESTED_BY_PARTY_ID,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    OBJECT_VERSION_NUMBER,
    ATTRIBUTE15,
    SUBSCRIBED_FRM_PARTY_ID,
    QUANTITY,
    STATUS_CODE,
    PURCHASE_ORDER_NO,
    FREQUENCY_CODE,
    SUBSCRIPTION_TYPE_CODE,
    MEDIA_TYPE_CODE,
    START_DATE,
    END_DATE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_ATTRIBUTE5,
    X_SUBSCRIPTION_ID,
    X_DOCUMENT_ID,
    X_REQUESTED_BY_PARTY_ID,
    X_ATTRIBUTE6,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_ATTRIBUTE11,
    X_ATTRIBUTE12,
    X_ATTRIBUTE13,
    X_ATTRIBUTE14,
    X_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_OBJECT_VERSION_NUMBER,
    X_ATTRIBUTE15,
    X_SUBSCRIBED_FRM_PARTY_ID,
    X_QUANTITY,
    X_STATUS_CODE,
    X_PURCHASE_ORDER_NO,
    X_FREQUENCY_CODE,
    X_SUBSCRIPTION_TYPE_CODE,
    X_MEDIA_TYPE_CODE,
    X_START_DATE,
    X_END_DATE,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 117


  insert into AHL_SUBSCRIPTIONS_TL (
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    COMMENTS,
    SUBSCRIPTION_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_COMMENTS,
    X_SUBSCRIPTION_ID,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from AHL_SUBSCRIPTIONS_TL T
    where T.SUBSCRIPTION_ID = X_SUBSCRIPTION_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 153


end INSERT_ROW;

Line: 187


  cursor c is select
      ATTRIBUTE5,
      DOCUMENT_ID,
      REQUESTED_BY_PARTY_ID,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      OBJECT_VERSION_NUMBER,
      ATTRIBUTE15,
      SUBSCRIBED_FRM_PARTY_ID,
      QUANTITY,
      STATUS_CODE,
      PURCHASE_ORDER_NO,
      FREQUENCY_CODE,
      SUBSCRIPTION_TYPE_CODE,
      MEDIA_TYPE_CODE,
      START_DATE,
      END_DATE
    from AHL_SUBSCRIPTIONS_B
    where SUBSCRIPTION_ID = X_SUBSCRIPTION_ID
    for update of SUBSCRIPTION_ID nowait;

Line: 221


  cursor c1 is select
      COMMENTS,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from AHL_SUBSCRIPTIONS_TL
    where SUBSCRIPTION_ID = X_SUBSCRIPTION_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of SUBSCRIPTION_ID nowait;

Line: 233


    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 310


procedure UPDATE_ROW (
  X_SUBSCRIPTION_ID in NUMBER,
  X_ATTRIBUTE5 in VARCHAR2,
  X_DOCUMENT_ID in NUMBER,
  X_REQUESTED_BY_PARTY_ID in NUMBER,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_ATTRIBUTE15 in VARCHAR2,
  X_SUBSCRIBED_FRM_PARTY_ID in NUMBER,
  X_QUANTITY in NUMBER,
  X_STATUS_CODE in VARCHAR2,
  X_PURCHASE_ORDER_NO in VARCHAR2,
  X_FREQUENCY_CODE in VARCHAR2,
  X_SUBSCRIPTION_TYPE_CODE in VARCHAR2,
  X_MEDIA_TYPE_CODE in VARCHAR2,
  X_START_DATE in DATE,
  X_END_DATE in DATE,
  X_COMMENTS in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update AHL_SUBSCRIPTIONS_B set
    ATTRIBUTE5 = X_ATTRIBUTE5,
    DOCUMENT_ID = X_DOCUMENT_ID,
    REQUESTED_BY_PARTY_ID = X_REQUESTED_BY_PARTY_ID,
    ATTRIBUTE6 = X_ATTRIBUTE6,
    ATTRIBUTE7 = X_ATTRIBUTE7,
    ATTRIBUTE8 = X_ATTRIBUTE8,
    ATTRIBUTE9 = X_ATTRIBUTE9,
    ATTRIBUTE10 = X_ATTRIBUTE10,
    ATTRIBUTE11 = X_ATTRIBUTE11,
    ATTRIBUTE12 = X_ATTRIBUTE12,
    ATTRIBUTE13 = X_ATTRIBUTE13,
    ATTRIBUTE14 = X_ATTRIBUTE14,
    ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
    ATTRIBUTE1 = X_ATTRIBUTE1,
    ATTRIBUTE2 = X_ATTRIBUTE2,
    ATTRIBUTE3 = X_ATTRIBUTE3,
    ATTRIBUTE4 = X_ATTRIBUTE4,
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    ATTRIBUTE15 = X_ATTRIBUTE15,
    SUBSCRIBED_FRM_PARTY_ID = X_SUBSCRIBED_FRM_PARTY_ID,
    QUANTITY = X_QUANTITY,
    STATUS_CODE = X_STATUS_CODE,
    PURCHASE_ORDER_NO = X_PURCHASE_ORDER_NO,
    FREQUENCY_CODE = X_FREQUENCY_CODE,
    SUBSCRIPTION_TYPE_CODE = X_SUBSCRIPTION_TYPE_CODE,
    MEDIA_TYPE_CODE = X_MEDIA_TYPE_CODE,
    START_DATE = X_START_DATE,
    END_DATE = X_END_DATE,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where SUBSCRIPTION_ID = X_SUBSCRIPTION_ID;

Line: 384


  update AHL_SUBSCRIPTIONS_TL set
    COMMENTS = X_COMMENTS,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    SOURCE_LANG = userenv('LANG')
  where SUBSCRIPTION_ID = X_SUBSCRIPTION_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 396


end UPDATE_ROW;

Line: 398


procedure DELETE_ROW (
  X_SUBSCRIPTION_ID in NUMBER
) is
begin
  delete from AHL_SUBSCRIPTIONS_TL
  where SUBSCRIPTION_ID = X_SUBSCRIPTION_ID;

Line: 409


  delete from AHL_SUBSCRIPTIONS_B
  where SUBSCRIPTION_ID = X_SUBSCRIPTION_ID;

Line: 415


end DELETE_ROW;

Line: 420


  delete from AHL_SUBSCRIPTIONS_TL T
  where not exists
    (select NULL
    from AHL_SUBSCRIPTIONS_B B
    where B.SUBSCRIPTION_ID = T.SUBSCRIPTION_ID
    );

Line: 427


  update AHL_SUBSCRIPTIONS_TL T set (
      COMMENTS
    ) = (select
      B.COMMENTS
    from AHL_SUBSCRIPTIONS_TL B
    where B.SUBSCRIPTION_ID = T.SUBSCRIPTION_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.SUBSCRIPTION_ID,
      T.LANGUAGE
  ) in (select
      SUBT.SUBSCRIPTION_ID,
      SUBT.LANGUAGE
    from AHL_SUBSCRIPTIONS_TL SUBB, AHL_SUBSCRIPTIONS_TL SUBT
    where SUBB.SUBSCRIPTION_ID = SUBT.SUBSCRIPTION_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.COMMENTS <> SUBT.COMMENTS
      or (SUBB.COMMENTS is null and SUBT.COMMENTS is not null)
      or (SUBB.COMMENTS is not null and SUBT.COMMENTS is null)
  ));

Line: 448


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

Line: 520


  select  object_version_number
  from    AHL_SUBSCRIPTIONS_B
  where   SUBSCRIPTION_ID =  X_SUBSCRIPTION_ID;

Line: 525


  select 'x'
  from   AHL_SUBSCRIPTIONS_B
  where  SUBSCRIPTION_ID = X_SUBSCRIPTION_ID;

Line: 530


   select AHL_SUBSCRIPTIONS_B_S.NEXTVAL
   from DUAL;

Line: 555


AHL_SUBSCRIPTIONS_PKG.INSERT_ROW (
X_ROWID			=>	l_row_id	,
X_SUBSCRIPTION_ID	=>	l_obj_id	,
X_ATTRIBUTE5		=>	X_ATTRIBUTE5	,
X_DOCUMENT_ID		=>	X_DOCUMENT_ID	,
X_REQUESTED_BY_PARTY_ID	=>	X_REQUESTED_BY_PARTY_ID	,
X_ATTRIBUTE6		=>	X_ATTRIBUTE6	,
X_ATTRIBUTE7		=>	X_ATTRIBUTE7	,
X_ATTRIBUTE8		=>	X_ATTRIBUTE8	,
X_ATTRIBUTE9		=>	X_ATTRIBUTE9	,
X_ATTRIBUTE10		=>	X_ATTRIBUTE10	,
X_ATTRIBUTE11		=>	X_ATTRIBUTE11	,
X_ATTRIBUTE12		=>	X_ATTRIBUTE12	,
X_ATTRIBUTE13		=>	X_ATTRIBUTE13	,
X_ATTRIBUTE14		=>	X_ATTRIBUTE14	,
X_ATTRIBUTE_CATEGORY	=>	X_ATTRIBUTE_CATEGORY	,
X_ATTRIBUTE1		=>	X_ATTRIBUTE1	,
X_ATTRIBUTE2		=>	X_ATTRIBUTE2	,
X_ATTRIBUTE3		=>	X_ATTRIBUTE3	,
X_ATTRIBUTE4		=>	X_ATTRIBUTE4	,
X_OBJECT_VERSION_NUMBER	=>	l_obj_verno	,
X_ATTRIBUTE15		=>	X_ATTRIBUTE15	,
X_SUBSCRIBED_FRM_PARTY_ID	=>	X_SUBSCRIBED_FRM_PARTY_ID	,
X_QUANTITY		=>	X_QUANTITY	,
X_STATUS_CODE		=>	X_STATUS_CODE	,
X_PURCHASE_ORDER_NO	=>	X_PURCHASE_ORDER_NO	,
X_FREQUENCY_CODE	=>	X_FREQUENCY_CODE	,
X_SUBSCRIPTION_TYPE_CODE	=>	X_SUBSCRIPTION_TYPE_CODE	,
X_MEDIA_TYPE_CODE	=>	X_MEDIA_TYPE_CODE	,
X_START_DATE		=>	X_START_DATE	,
X_END_DATE		=>	X_END_DATE	,
X_COMMENTS		=>	X_COMMENTS	,

X_CREATION_DATE 	=>      SYSDATE         ,
X_CREATED_BY            =>      l_user_id       ,
X_LAST_UPDATE_DATE      =>      SYSDATE         ,
X_LAST_UPDATED_BY       =>      l_user_id       ,
X_LAST_UPDATE_LOGIN     =>      0
);

Line: 603


AHL_SUBSCRIPTIONS_PKG.UPDATE_ROW (
X_SUBSCRIPTION_ID	=>	X_SUBSCRIPTION_ID	,
X_ATTRIBUTE5		=>	X_ATTRIBUTE5	,
X_DOCUMENT_ID		=>	X_DOCUMENT_ID	,
X_REQUESTED_BY_PARTY_ID	=>	X_REQUESTED_BY_PARTY_ID	,
X_ATTRIBUTE6		=>	X_ATTRIBUTE6	,
X_ATTRIBUTE7		=>	X_ATTRIBUTE7	,
X_ATTRIBUTE8		=>	X_ATTRIBUTE8	,
X_ATTRIBUTE9		=>	X_ATTRIBUTE9	,
X_ATTRIBUTE10		=>	X_ATTRIBUTE10	,
X_ATTRIBUTE11		=>	X_ATTRIBUTE11	,
X_ATTRIBUTE12		=>	X_ATTRIBUTE12	,
X_ATTRIBUTE13		=>	X_ATTRIBUTE13	,
X_ATTRIBUTE14		=>	X_ATTRIBUTE14	,
X_ATTRIBUTE_CATEGORY	=>	X_ATTRIBUTE_CATEGORY	,
X_ATTRIBUTE1		=>	X_ATTRIBUTE1	,
X_ATTRIBUTE2		=>	X_ATTRIBUTE2	,
X_ATTRIBUTE3		=>	X_ATTRIBUTE3	,
X_ATTRIBUTE4		=>	X_ATTRIBUTE4	,
X_OBJECT_VERSION_NUMBER	=>	l_obj_verno	,
X_ATTRIBUTE15		=>	X_ATTRIBUTE15	,
X_SUBSCRIBED_FRM_PARTY_ID	=>	X_SUBSCRIBED_FRM_PARTY_ID	,
X_QUANTITY		=>	X_QUANTITY	,
X_STATUS_CODE		=>	X_STATUS_CODE	,
X_PURCHASE_ORDER_NO	=>	X_PURCHASE_ORDER_NO	,
X_FREQUENCY_CODE	=>	X_FREQUENCY_CODE	,
X_SUBSCRIPTION_TYPE_CODE	=>	X_SUBSCRIPTION_TYPE_CODE	,
X_MEDIA_TYPE_CODE	=>	X_MEDIA_TYPE_CODE	,
X_START_DATE		=>	X_START_DATE	,
X_END_DATE		=>	X_END_DATE	,
X_COMMENTS		=>	X_COMMENTS	,

X_LAST_UPDATE_DATE      =>      SYSDATE         ,
X_LAST_UPDATED_BY       =>      l_user_id       ,
X_LAST_UPDATE_LOGIN     =>      0
	);

Line: 650


    update AHL_SUBSCRIPTIONS_TL set
       comments = nvl(X_COMMENTS, comments),
       source_lang = userenv('LANG'),
       last_update_date = sysdate,
       last_updated_by = decode(x_owner, 'SEED', 1, 0),
       last_update_login = 0
    where  SUBSCRIPTION_ID = X_SUBSCRIPTION_ID
    and      userenv('LANG') in (language, source_lang);