APPS.JTF_RS_RESOURCE_EXTNS_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_RESOURCE_ID in NUMBER,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_CATEGORY in VARCHAR2,
  X_RESOURCE_NUMBER in VARCHAR2,
  X_SOURCE_ID in NUMBER,
  X_ADDRESS_ID in NUMBER,
  X_CONTACT_ID in NUMBER,
  X_MANAGING_EMPLOYEE_ID in NUMBER,
  X_START_DATE_ACTIVE in DATE,
  X_END_DATE_ACTIVE in DATE,
  X_TIME_ZONE in NUMBER,
  X_COST_PER_HR in NUMBER,
  X_PRIMARY_LANGUAGE in VARCHAR2,
  X_SECONDARY_LANGUAGE in VARCHAR2,
  X_SUPPORT_SITE_ID in NUMBER,
  X_IES_AGENT_LOGIN in VARCHAR2,
  X_SERVER_GROUP_ID in NUMBER,
  X_ASSIGNED_TO_GROUP_ID in NUMBER,
  X_COST_CENTER in VARCHAR2,
  X_CHARGE_TO_COST_CENTER in VARCHAR2,
  X_COMPENSATION_CURRENCY_CODE in VARCHAR2,
  X_COMMISSIONABLE_FLAG in VARCHAR2,
  X_HOLD_REASON_CODE in VARCHAR2,
  X_HOLD_PAYMENT in VARCHAR2,
  X_COMP_SERVICE_TEAM_ID in NUMBER,
  X_TRANSACTION_NUMBER in NUMBER,
  X_USER_ID in NUMBER,
  --X_LOCATION in MDSYS.SDO_GEOMETRY,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE1 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,
  X_RESOURCE_NAME   in  VARCHAR2,
  X_SOURCE_NAME in   VARCHAR2,
  X_SOURCE_NUMBER   in  VARCHAR2,
  X_SOURCE_JOB_TITLE  in   VARCHAR2,
  X_SOURCE_EMAIL  in   VARCHAR2,
  X_SOURCE_PHONE  in   VARCHAR2,
  X_SOURCE_ORG_ID in   NUMBER,
  X_SOURCE_ORG_NAME  in VARCHAR2,
  X_SOURCE_ADDRESS1  in    VARCHAR2,
  X_SOURCE_ADDRESS2  in  VARCHAR2,
  X_SOURCE_ADDRESS3  in  VARCHAR2,
  X_SOURCE_ADDRESS4  in  VARCHAR2,
  X_SOURCE_CITY     in  VARCHAR2,
  X_SOURCE_POSTAL_CODE  in  VARCHAR2,
  X_SOURCE_STATE       in  VARCHAR2,
  X_SOURCE_PROVINCE     in  VARCHAR2,
  X_SOURCE_COUNTY      in   VARCHAR2,
  X_SOURCE_COUNTRY     in   VARCHAR2,
  X_SOURCE_MGR_ID       in  NUMBER,
  X_SOURCE_MGR_NAME       in  VARCHAR2,
  X_SOURCE_BUSINESS_GRP_ID       in  NUMBER,
  X_SOURCE_BUSINESS_GRP_NAME     in   VARCHAR2,
  X_SOURCE_FIRST_NAME       in  VARCHAR2,
  X_SOURCE_LAST_NAME        in  VARCHAR2,
  X_SOURCE_MIDDLE_NAME     in  VARCHAR2,
  X_SOURCE_CATEGORY        in  VARCHAR2,
  X_SOURCE_STATUS          in  VARCHAR2,
  X_SOURCE_OFFICE          in  VARCHAR2,
  X_SOURCE_LOCATION          in  VARCHAR2,
  X_SOURCE_MAILSTOP          in  VARCHAR2,
  X_USER_NAME              in  VARCHAR2,
  X_SOURCE_JOB_ID              in  VARCHAR2,
  X_PARTY_ID              in  VARCHAR2,
  X_SOURCE_MOBILE_PHONE          in  VARCHAR2,
  X_SOURCE_PAGER          in  VARCHAR2
) is
  cursor C is select ROWID from JTF_RS_RESOURCE_EXTNS
    where RESOURCE_ID = X_RESOURCE_ID
    ;

Line: 93

  insert into JTF_RS_RESOURCE_EXTNS (
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE11,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    CATEGORY,
    RESOURCE_NUMBER,
    SOURCE_ID,
    ADDRESS_ID,
    CONTACT_ID,
    MANAGING_EMPLOYEE_ID,
    START_DATE_ACTIVE,
    END_DATE_ACTIVE,
    TIME_ZONE,
    COST_PER_HR,
    PRIMARY_LANGUAGE,
    SECONDARY_LANGUAGE,
    SUPPORT_SITE_ID,
    IES_AGENT_LOGIN,
    SERVER_GROUP_ID,
    ASSIGNED_TO_GROUP_ID,
    COST_CENTER,
    CHARGE_TO_COST_CENTER,
    COMPENSATION_CURRENCY_CODE,
    COMMISSIONABLE_FLAG,
    HOLD_REASON_CODE,
    HOLD_PAYMENT,
    COMP_SERVICE_TEAM_ID,
    TRANSACTION_NUMBER,
    USER_ID,
    --LOCATION,
    OBJECT_VERSION_NUMBER,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    RESOURCE_ID,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    SOURCE_NAME     ,
    SOURCE_NUMBER    ,
    SOURCE_JOB_TITLE  ,
    SOURCE_EMAIL     ,
    SOURCE_PHONE    ,
    SOURCE_ORG_ID   ,
    SOURCE_ORG_NAME ,
    SOURCE_ADDRESS1 ,
    SOURCE_ADDRESS2 ,
    SOURCE_ADDRESS3 ,
    SOURCE_ADDRESS4 ,
    SOURCE_CITY      ,
    SOURCE_POSTAL_CODE,
    SOURCE_STATE      ,
    SOURCE_PROVINCE   ,
    SOURCE_COUNTY     ,
    SOURCE_COUNTRY  ,
    SOURCE_MGR_ID,
    SOURCE_MGR_NAME,
    SOURCE_BUSINESS_GRP_ID,
    SOURCE_BUSINESS_GRP_NAME,
    SOURCE_FIRST_NAME,
    SOURCE_LAST_NAME,
    SOURCE_MIDDLE_NAME,
    SOURCE_CATEGORY,
    SOURCE_STATUS,
    SOURCE_OFFICE,
    SOURCE_LOCATION,
    SOURCE_MAILSTOP,
    USER_NAME,
    SOURCE_JOB_ID,
    PERSON_PARTY_ID,
    SOURCE_MOBILE_PHONE,
    SOURCE_PAGER
  ) values (
    X_ATTRIBUTE12,
    X_ATTRIBUTE13,
    X_ATTRIBUTE14,
    X_ATTRIBUTE15,
    X_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE11,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATE_LOGIN,
    X_CATEGORY,
    X_RESOURCE_NUMBER,
    X_SOURCE_ID,
    X_ADDRESS_ID,
    X_CONTACT_ID,
    X_MANAGING_EMPLOYEE_ID,
    X_START_DATE_ACTIVE,
    X_END_DATE_ACTIVE,
    X_TIME_ZONE,
    X_COST_PER_HR,
    X_PRIMARY_LANGUAGE,
    X_SECONDARY_LANGUAGE,
    X_SUPPORT_SITE_ID,
    X_IES_AGENT_LOGIN,
    X_SERVER_GROUP_ID,
    X_ASSIGNED_TO_GROUP_ID,
    X_COST_CENTER,
    X_CHARGE_TO_COST_CENTER,
    X_COMPENSATION_CURRENCY_CODE,
    X_COMMISSIONABLE_FLAG,
    X_HOLD_REASON_CODE,
    nvl(X_HOLD_PAYMENT,'N'), -- Bug Number 1717900
    X_COMP_SERVICE_TEAM_ID,
    X_TRANSACTION_NUMBER,
    X_USER_ID,
    --X_LOCATION,
    1,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_RESOURCE_ID,
    X_CREATED_BY,
    X_CREATION_DATE,
    X_LAST_UPDATED_BY,
    X_SOURCE_NAME     ,
    X_SOURCE_NUMBER    ,
    X_SOURCE_JOB_TITLE  ,
    X_SOURCE_EMAIL     ,
    X_SOURCE_PHONE    ,
    X_SOURCE_ORG_ID   ,
    X_SOURCE_ORG_NAME ,
    X_SOURCE_ADDRESS1 ,
    X_SOURCE_ADDRESS2 ,
    X_SOURCE_ADDRESS3 ,
    X_SOURCE_ADDRESS4 ,
    X_SOURCE_CITY      ,
    X_SOURCE_POSTAL_CODE,
    X_SOURCE_STATE      ,
    X_SOURCE_PROVINCE   ,
    X_SOURCE_COUNTY     ,
    X_SOURCE_COUNTRY      ,
    X_SOURCE_MGR_ID,
    X_SOURCE_MGR_NAME,
    X_SOURCE_BUSINESS_GRP_ID,
    X_SOURCE_BUSINESS_GRP_NAME,
    X_SOURCE_FIRST_NAME,
    X_SOURCE_LAST_NAME,
    X_SOURCE_MIDDLE_NAME,
    X_SOURCE_CATEGORY,
    X_SOURCE_STATUS,
    X_SOURCE_OFFICE,
    X_SOURCE_LOCATION,
    X_SOURCE_MAILSTOP,
    X_USER_NAME,
    X_SOURCE_JOB_ID,
    X_PARTY_ID,
    X_SOURCE_MOBILE_PHONE,
    X_SOURCE_PAGER
    );

Line: 263

  insert into JTF_RS_RESOURCE_EXTNS_TL (
    RESOURCE_ID,
    CATEGORY,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    RESOURCE_NAME,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_RESOURCE_ID,
    X_CATEGORY,
    X_CREATED_BY,
    X_CREATION_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATE_LOGIN,
    X_RESOURCE_NAME,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from JTF_RS_RESOURCE_EXTNS_TL T
    where T.RESOURCE_ID = X_RESOURCE_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 301

end INSERT_ROW;

Line: 307

  cursor c1 is select
      OBJECT_VERSION_NUMBER
    from JTF_RS_RESOURCE_EXTNS_VL
    where RESOURCE_ID = X_RESOURCE_ID
    for update of RESOURCE_ID nowait;

Line: 318

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

Line: 333

procedure UPDATE_ROW (
  X_RESOURCE_ID in NUMBER,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_CATEGORY in VARCHAR2,
  X_RESOURCE_NUMBER in VARCHAR2,
  X_SOURCE_ID in NUMBER,
  X_ADDRESS_ID in NUMBER,
  X_CONTACT_ID in NUMBER,
  X_MANAGING_EMPLOYEE_ID in NUMBER,
  X_START_DATE_ACTIVE in DATE,
  X_END_DATE_ACTIVE in DATE,
  X_TIME_ZONE in NUMBER,
  X_COST_PER_HR in NUMBER,
  X_PRIMARY_LANGUAGE in VARCHAR2,
  X_SECONDARY_LANGUAGE in VARCHAR2,
  X_SUPPORT_SITE_ID in NUMBER,
  X_IES_AGENT_LOGIN in VARCHAR2,
  X_SERVER_GROUP_ID in NUMBER,
  X_ASSIGNED_TO_GROUP_ID in NUMBER,
  X_COST_CENTER in VARCHAR2,
  X_CHARGE_TO_COST_CENTER in VARCHAR2,
  X_COMPENSATION_CURRENCY_CODE in VARCHAR2,
  X_COMMISSIONABLE_FLAG in VARCHAR2,
  X_HOLD_REASON_CODE in VARCHAR2,
  X_HOLD_PAYMENT in VARCHAR2,
  X_COMP_SERVICE_TEAM_ID in NUMBER,
  X_TRANSACTION_NUMBER in NUMBER,
  X_USER_ID in NUMBER,
  --X_LOCATION in MDSYS.SDO_GEOMETRY,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_RESOURCE_NAME   in  VARCHAR2,
  X_SOURCE_NAME in   VARCHAR2,
  X_SOURCE_NUMBER   in  VARCHAR2,
  X_SOURCE_JOB_TITLE  in   VARCHAR2,
  X_SOURCE_EMAIL  in   VARCHAR2,
  X_SOURCE_PHONE  in   VARCHAR2,
  X_SOURCE_ORG_ID in   NUMBER,
  X_SOURCE_ORG_NAME  in VARCHAR2,
  X_SOURCE_ADDRESS1  in    VARCHAR2,
  X_SOURCE_ADDRESS2  in  VARCHAR2,
  X_SOURCE_ADDRESS3  in  VARCHAR2,
  X_SOURCE_ADDRESS4  in  VARCHAR2,
  X_SOURCE_CITY     in  VARCHAR2,
  X_SOURCE_POSTAL_CODE  in  VARCHAR2,
  X_SOURCE_STATE       in  VARCHAR2,
  X_SOURCE_PROVINCE     in  VARCHAR2,
  X_SOURCE_COUNTY      in   VARCHAR2,
  X_SOURCE_COUNTRY     in   VARCHAR2,
  X_SOURCE_MGR_ID       in  NUMBER,
  X_SOURCE_MGR_NAME       in  VARCHAR2,
  X_SOURCE_BUSINESS_GRP_ID       in  NUMBER,
  X_SOURCE_BUSINESS_GRP_NAME     in   VARCHAR2,
  X_SOURCE_FIRST_NAME       in  VARCHAR2,
  X_SOURCE_LAST_NAME        in  VARCHAR2,
  X_SOURCE_MIDDLE_NAME     in  VARCHAR2,
  X_SOURCE_CATEGORY        in  VARCHAR2,
  X_SOURCE_STATUS          in  VARCHAR2,
  X_SOURCE_OFFICE          in  VARCHAR2,
  X_SOURCE_LOCATION          in  VARCHAR2,
  X_SOURCE_MAILSTOP          in  VARCHAR2,
  X_USER_NAME              in  VARCHAR2,
  X_SOURCE_JOB_ID              in  VARCHAR2,
  X_PARTY_ID              in  VARCHAR2,
  X_SOURCE_MOBILE_PHONE          in  VARCHAR2,
  X_SOURCE_PAGER          in  VARCHAR2
) is
begin
  update JTF_RS_RESOURCE_EXTNS set
    ATTRIBUTE12 = X_ATTRIBUTE12,
    ATTRIBUTE13 = X_ATTRIBUTE13,
    ATTRIBUTE14 = X_ATTRIBUTE14,
    ATTRIBUTE15 = X_ATTRIBUTE15,
    ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
    ATTRIBUTE11 = X_ATTRIBUTE11,
    ATTRIBUTE7 = X_ATTRIBUTE7,
    ATTRIBUTE8 = X_ATTRIBUTE8,
    ATTRIBUTE9 = X_ATTRIBUTE9,
    ATTRIBUTE10 = X_ATTRIBUTE10,
    CATEGORY = X_CATEGORY,
    RESOURCE_NUMBER = X_RESOURCE_NUMBER,
    SOURCE_ID = X_SOURCE_ID,
    ADDRESS_ID = X_ADDRESS_ID,
    CONTACT_ID = X_CONTACT_ID,
    MANAGING_EMPLOYEE_ID = X_MANAGING_EMPLOYEE_ID,
    START_DATE_ACTIVE = X_START_DATE_ACTIVE,
    END_DATE_ACTIVE = X_END_DATE_ACTIVE,
    TIME_ZONE = X_TIME_ZONE,
    COST_PER_HR = X_COST_PER_HR,
    PRIMARY_LANGUAGE = X_PRIMARY_LANGUAGE,
    SECONDARY_LANGUAGE = X_SECONDARY_LANGUAGE,
    SUPPORT_SITE_ID = X_SUPPORT_SITE_ID,
    IES_AGENT_LOGIN = X_IES_AGENT_LOGIN,
    SERVER_GROUP_ID = X_SERVER_GROUP_ID,
    ASSIGNED_TO_GROUP_ID = X_ASSIGNED_TO_GROUP_ID,
    COST_CENTER = X_COST_CENTER,
    CHARGE_TO_COST_CENTER = X_CHARGE_TO_COST_CENTER,
    COMPENSATION_CURRENCY_CODE = X_COMPENSATION_CURRENCY_CODE,
    COMMISSIONABLE_FLAG = X_COMMISSIONABLE_FLAG,
    HOLD_REASON_CODE = X_HOLD_REASON_CODE,
    HOLD_PAYMENT = nvl(X_HOLD_PAYMENT,'N'),
    COMP_SERVICE_TEAM_ID = X_COMP_SERVICE_TEAM_ID,
    TRANSACTION_NUMBER = X_TRANSACTION_NUMBER,
    USER_ID = X_USER_ID,
    --LOCATION = X_LOCATION,
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    ATTRIBUTE2 = X_ATTRIBUTE2,
    ATTRIBUTE3 = X_ATTRIBUTE3,
    ATTRIBUTE4 = X_ATTRIBUTE4,
    ATTRIBUTE5 = X_ATTRIBUTE5,
    ATTRIBUTE6 = X_ATTRIBUTE6,
    ATTRIBUTE1 = X_ATTRIBUTE1,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    SOURCE_NAME = X_SOURCE_NAME     ,
    SOURCE_NUMBER   =  X_SOURCE_NUMBER    ,
    SOURCE_JOB_TITLE =  X_SOURCE_JOB_TITLE  ,
    SOURCE_EMAIL    =  X_SOURCE_EMAIL     ,
    SOURCE_PHONE   =  X_SOURCE_PHONE    ,
    SOURCE_ORG_ID  =  X_SOURCE_ORG_ID   ,
    SOURCE_ORG_NAME =  X_SOURCE_ORG_NAME ,
    SOURCE_ADDRESS1 =  X_SOURCE_ADDRESS1 ,
    SOURCE_ADDRESS2 =  X_SOURCE_ADDRESS2 ,
    SOURCE_ADDRESS3 =  X_SOURCE_ADDRESS3 ,
    SOURCE_ADDRESS4 =  X_SOURCE_ADDRESS4 ,
    SOURCE_CITY     =  X_SOURCE_CITY      ,
    SOURCE_POSTAL_CODE = X_SOURCE_POSTAL_CODE,
    SOURCE_STATE     =  X_SOURCE_STATE      ,
    SOURCE_PROVINCE  =  X_SOURCE_PROVINCE   ,
    SOURCE_COUNTY    =  X_SOURCE_COUNTY     ,
    SOURCE_COUNTRY     =  X_SOURCE_COUNTRY      ,
    SOURCE_MGR_ID = X_SOURCE_MGR_ID,
    SOURCE_MGR_NAME = X_SOURCE_MGR_NAME,
    SOURCE_BUSINESS_GRP_ID = X_SOURCE_BUSINESS_GRP_ID,
    SOURCE_BUSINESS_GRP_NAME = X_SOURCE_BUSINESS_GRP_NAME,
    SOURCE_FIRST_NAME = X_SOURCE_FIRST_NAME,
    SOURCE_MIDDLE_NAME = X_SOURCE_MIDDLE_NAME,
    SOURCE_LAST_NAME = X_SOURCE_LAST_NAME,
    SOURCE_CATEGORY = X_SOURCE_CATEGORY,
    SOURCE_STATUS = X_SOURCE_STATUS,
    SOURCE_OFFICE = X_SOURCE_OFFICE,
    SOURCE_LOCATION = X_SOURCE_LOCATION,
    SOURCE_MAILSTOP = X_SOURCE_MAILSTOP,
    USER_NAME     = X_USER_NAME,
    SOURCE_JOB_ID     = X_SOURCE_JOB_ID,
    PERSON_PARTY_ID     = X_PARTY_ID,
    SOURCE_MOBILE_PHONE = X_SOURCE_MOBILE_PHONE,
    SOURCE_PAGER = X_SOURCE_PAGER
  where RESOURCE_ID = X_RESOURCE_ID;

Line: 505

  update JTF_RS_RESOURCE_EXTNS_TL set
    RESOURCE_NAME = X_RESOURCE_NAME,
    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 RESOURCE_ID = X_RESOURCE_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 517

end UPDATE_ROW;

Line: 519

procedure DELETE_ROW (
  X_RESOURCE_ID in NUMBER
) is
begin

  delete from JTF_RS_RESOURCE_EXTNS_TL
  where RESOURCE_ID = X_RESOURCE_ID;

Line: 531

  delete from JTF_RS_RESOURCE_EXTNS
  where RESOURCE_ID = X_RESOURCE_ID;

Line: 538

end DELETE_ROW;

Line: 543

  delete from JTF_RS_RESOURCE_EXTNS_TL T
  where not exists
    (select NULL
    from JTF_RS_RESOURCE_EXTNS B
    where B.RESOURCE_ID = T.RESOURCE_ID
    );

Line: 550

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

Line: 571

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

Line: 607

 x_Last_update_date in date,
 x_last_updated_by in number,
 x_last_update_login in number)
is
begin

Update jtf_rs_resource_extns_tl set
resource_name		= nvl(x_resource_name,resource_name),
last_update_date	= nvl(x_last_update_date,sysdate),
last_updated_by		= x_last_updated_by,
last_update_login	= 0,
source_lang		= userenv('LANG')
where resource_id		= x_resource_id
and userenv('LANG') in (LANGUAGE,SOURCE_LANG);