APPS.CS_SR_EVENT_CODES_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  PX_EVENT_CODE in out NOCOPY VARCHAR2,
  P_RELATIONSHIP_TYPE in VARCHAR2,
  P_START_DATE_ACTIVE in DATE,
  P_END_DATE_ACTIVE in DATE,
  P_WF_BUSINESS_EVENT_ID in VARCHAR2,
  P_SEEDED_FLAG in VARCHAR2,
  P_APPLICATION_ID in NUMBER,
  P_FROM_TO_STATUS in VARCHAR2,
  P_INCIDENT_STATUS in VARCHAR2,
  P_NAME in VARCHAR2,
  P_DESCRIPTION in VARCHAR2,
  P_CREATION_DATE in DATE,
  P_CREATED_BY in NUMBER,
  P_LAST_UPDATE_DATE in DATE,
  P_LAST_UPDATED_BY in NUMBER,
  P_LAST_UPDATE_LOGIN in NUMBER,
  X_OBJECT_VERSION_NUMBER out NOCOPY NUMBER
) is
 l_object_version_number NUMBER := 1;

Line: 24

  insert into CS_SR_EVENT_CODES_B (
    RELATIONSHIP_TYPE,
    START_DATE_ACTIVE,
    END_DATE_ACTIVE,
    WF_BUSINESS_EVENT_ID,
    SEEDED_FLAG,
    APPLICATION_ID,
    OBJECT_VERSION_NUMBER,
    FROM_TO_STATUS,
    INCIDENT_STATUS,
    EVENT_CODE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    P_RELATIONSHIP_TYPE,
    P_START_DATE_ACTIVE,
    P_END_DATE_ACTIVE,
    P_WF_BUSINESS_EVENT_ID,
    P_SEEDED_FLAG,
    P_APPLICATION_ID,
    l_object_version_number,
    P_FROM_TO_STATUS,
    P_INCIDENT_STATUS,
    Px_EVENT_CODE,
    Decode(P_CREATION_DATE,NULL,SYSDATE,P_CREATION_DATE),
    P_CREATED_BY,
    Decode(P_LAST_UPDATE_DATE,NULL,SYSDATE,P_LAST_UPDATE_DATE),
    P_LAST_UPDATED_BY,
    P_LAST_UPDATE_LOGIN
  );

Line: 58

  insert into CS_SR_EVENT_CODES_TL (
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    EVENT_CODE,
    NAME,
    DESCRIPTION,
    LANGUAGE,
    SOURCE_LANG
  ) select
    P_CREATION_DATE,
    P_CREATED_BY,
    P_LAST_UPDATE_DATE,
    P_LAST_UPDATED_BY,
    P_LAST_UPDATE_LOGIN,
    PX_EVENT_CODE,
    P_NAME,
    P_DESCRIPTION,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from CS_SR_EVENT_CODES_TL T
    where T.EVENT_CODE = PX_EVENT_CODE
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 89

end INSERT_ROW;

Line: 95

  cursor c is select
      OBJECT_VERSION_NUMBER
    from CS_SR_EVENT_CODES_VL
    where EVENT_CODE = P_EVENT_CODE
    for update of EVENT_CODE nowait;

Line: 108

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

Line: 122

procedure UPDATE_ROW (
  P_EVENT_CODE in VARCHAR2,
  P_RELATIONSHIP_TYPE in VARCHAR2,
  P_START_DATE_ACTIVE in DATE,
  P_END_DATE_ACTIVE in DATE,
  P_WF_BUSINESS_EVENT_ID in VARCHAR2,
  P_SEEDED_FLAG in VARCHAR2,
  P_APPLICATION_ID in NUMBER,
  P_FROM_TO_STATUS in VARCHAR2,
  P_INCIDENT_STATUS in VARCHAR2,
  P_NAME in VARCHAR2,
  P_DESCRIPTION in VARCHAR2,
  P_LAST_UPDATE_DATE in DATE,
  P_LAST_UPDATED_BY in NUMBER,
  P_LAST_UPDATE_LOGIN in NUMBER,
  X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER
) is
	l_object_Version_number number;

Line: 141

  update CS_SR_EVENT_CODES_B set
    RELATIONSHIP_TYPE = P_RELATIONSHIP_TYPE,
    START_DATE_ACTIVE = P_START_DATE_ACTIVE,
    END_DATE_ACTIVE = P_END_DATE_ACTIVE,
    WF_BUSINESS_EVENT_ID = P_WF_BUSINESS_EVENT_ID,
    SEEDED_FLAG = P_SEEDED_FLAG,
    APPLICATION_ID = P_APPLICATION_ID,
    OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
    FROM_TO_STATUS = P_FROM_TO_STATUS,
    INCIDENT_STATUS = P_INCIDENT_STATUS,
    LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = P_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN
  where EVENT_CODE = P_EVENT_CODE
  RETURNING OBJECT_VERSION_NUMBER INTO L_OBJECT_VERSION_NUMBER;

Line: 163

  update CS_SR_EVENT_CODES_TL set
    NAME = P_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 EVENT_CODE = P_EVENT_CODE
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 176

end UPDATE_ROW;

Line: 178

procedure DELETE_ROW (
  P_EVENT_CODE in VARCHAR2
) is
begin
  delete from CS_SR_EVENT_CODES_TL
  where EVENT_CODE = P_EVENT_CODE;

Line: 189

  delete from CS_SR_EVENT_CODES_B
  where EVENT_CODE = P_EVENT_CODE;

Line: 195

end DELETE_ROW;

Line: 200

  delete from CS_SR_EVENT_CODES_TL T
  where not exists
    (select NULL
    from CS_SR_EVENT_CODES_B B
    where B.EVENT_CODE = T.EVENT_CODE
    );

Line: 207

  update CS_SR_EVENT_CODES_TL T set (
      NAME,
      DESCRIPTION
    ) = (select
      B.NAME,
      B.DESCRIPTION
    from CS_SR_EVENT_CODES_TL B
    where B.EVENT_CODE = T.EVENT_CODE
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.EVENT_CODE,
      T.LANGUAGE
  ) in (select
      SUBT.EVENT_CODE,
      SUBT.LANGUAGE
    from CS_SR_EVENT_CODES_TL SUBB, CS_SR_EVENT_CODES_TL SUBT
    where SUBB.EVENT_CODE = SUBT.EVENT_CODE
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.NAME <> SUBT.NAME
      or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
      or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
      or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
  ));

Line: 231

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

Line: 278

  P_LAST_UPDATE_DATE           IN VARCHAR2,
  P_LAST_UPDATED_BY            IN NUMBER,
  P_LAST_UPDATE_LOGIN          IN NUMBER,
  P_OBJECT_VERSION_NUMBER      IN NUMBER )

IS

 -- Out local variables for the update / insert row procedures.
   lx_object_version_number  NUMBER := 0;

Line: 301

   UPDATE_ROW (
       P_EVENT_CODE                 =>l_event_code,
       P_RELATIONSHIP_TYPE          =>p_relationship_type,
       P_START_DATE_ACTIVE          =>to_date(p_start_date_active,'DD-MM-YYYY'),
       P_END_DATE_ACTIVE            =>to_date(p_end_date_active,'DD-MM-YYYY'),
       P_WF_BUSINESS_EVENT_ID       =>P_WF_BUSINESS_EVENT_ID,
       P_SEEDED_FLAG                =>p_seeded_flag,
       P_APPLICATION_ID             =>p_application_id,
       P_FROM_TO_STATUS             =>p_from_to_status,
       P_INCIDENT_STATUS            =>p_incident_status,
       P_NAME                       =>p_name,
       P_DESCRIPTION                =>p_description,
       P_LAST_UPDATE_DATE           =>nvl(to_date(p_last_update_date,
                                                 'DD-MM-YYYY'),sysdate),
       P_LAST_UPDATED_BY            =>l_user_id,
       P_LAST_UPDATE_LOGIN          =>0,
       X_OBJECT_VERSION_NUMBER      =>lx_object_version_number
   );

Line: 322

      INSERT_ROW (
        PX_EVENT_CODE               =>l_event_code,
        P_RELATIONSHIP_TYPE         =>p_relationship_type,
        P_START_DATE_ACTIVE         =>to_date(p_start_date_active,'DD-MM-YYYY'),
        P_END_DATE_ACTIVE           =>to_date(p_end_date_active,'DD-MM-YYYY'),
        P_WF_BUSINESS_EVENT_ID      =>P_WF_BUSINESS_EVENT_ID,
        P_SEEDED_FLAG               =>p_seeded_flag,
        P_APPLICATION_ID            =>p_application_id,
        P_FROM_TO_STATUS            =>p_from_to_status,
        P_INCIDENT_STATUS           =>p_incident_status,
        P_NAME                      =>p_name,
        P_DESCRIPTION               =>p_description,
        P_CREATION_DATE             =>nvl(to_date( p_creation_date,
                                                  'DD-MM-YYYY'),sysdate),
        P_CREATED_BY                =>l_user_id,
        P_LAST_UPDATE_DATE          =>nvl(to_date( p_last_update_date,
                                                  'DD-MM-YYYY'),sysdate),
        P_LAST_UPDATED_BY           =>l_user_id,
        P_LAST_UPDATE_LOGIN         =>0,
        X_OBJECT_VERSION_NUMBER     =>lx_object_version_number
       );

Line: 349

                          X_LAST_UPDATE_DATE in date,
                          X_LAST_UPDATE_LOGIN in number,
                          X_OWNER in varchar2)
is

l_user_id  number;

Line: 364

update CS_SR_EVENT_CODES_TL set
 name = nvl(x_name,name),
 description = nvl(x_description,name),
 last_update_date = nvl(x_last_update_date,sysdate),
 last_updated_by = l_user_id,
 last_update_login = 0,
 source_lang = userenv('LANG')
 where event_code = x_event_code
 and userenv('LANG') in (LANGUAGE,SOURCE_LANG);