APPS.CSFW_SETUP_PKG SQL Statements

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

Line: 4

  PROCEDURE insert_phonetics_row
    (
      p_phonetics_id      IN VARCHAR2 ,
      p_language          IN VARCHAR2 ,
      p_phonetic          IN VARCHAR2 ,
      p_code              IN VARCHAR2 ,
      p_description       IN VARCHAR2 ,
      p_enabled_flag      IN VARCHAR2 ,
      p_start_date_active IN VARCHAR2 ,
      p_end_date_active   IN VARCHAR2 ,
      p_created_by        IN VARCHAR2 ,
      p_creation_date     IN VARCHAR2 ,
      p_last_updated_by   IN VARCHAR2 ,
      p_last_update_login IN VARCHAR2 ,
      p_last_update_date  IN VARCHAR2 )
  IS
  BEGIN
    /*
    IF p_created_by IS NULL THEN
    p_created_by  := fnd_global.user_id;

Line: 25

    IF p_last_updated_by IS NULL THEN
    p_last_updated_by  := fnd_global.user_id;

Line: 28

    IF p_last_update_login IS NULL THEN
    p_last_update_login  := fnd_global.login_id;

Line: 34

    IF p_last_update_date IS NULL THEN
    p_last_update_date  := sysdate;

Line: 38

    INSERT
    INTO csf_phonetic_values
      (
        phonetics_id,
        language,
        phonetic,
        code,
        description,
        enabled_flag,
        start_date_active,
        end_date_active,
        created_by,
        creation_date,
        last_updated_by,
        last_update_login,
        last_update_date
      )
      VALUES
      (
        p_phonetics_id,
        p_language,
        p_phonetic,
        p_code,
        p_description,
        p_enabled_flag,
        decode(p_start_date_active,NULL,NULL,to_date(p_start_date_active, 'YYYY/MM/DD')),
        decode(p_end_date_active,NULL,NULL,to_date(p_end_date_active, 'YYYY/MM/DD')),
        p_created_by,
        to_date(p_creation_date, 'YYYY/MM/DD'),
        p_last_updated_by,
        p_last_update_login,
        to_date(p_last_update_date, 'YYYY/MM/DD')
      );

Line: 71

  END insert_phonetics_row;

Line: 73

  PROCEDURE update_phonetics_row
    (
      p_phonetics_id      IN VARCHAR2 ,
      p_language          IN VARCHAR2 ,
      p_phonetic          IN VARCHAR2 ,
      p_code              IN VARCHAR2 ,
      p_description       IN VARCHAR2 ,
      p_enabled_flag      IN VARCHAR2 ,
      p_start_date_active IN VARCHAR2 ,
      p_end_date_active   IN VARCHAR2 ,
      p_created_by        IN VARCHAR2 ,
      p_creation_date     IN VARCHAR2 ,
      p_last_updated_by   IN VARCHAR2 ,
      p_last_update_login IN VARCHAR2 ,
      p_last_update_date  IN VARCHAR2
    )
  IS
    l_phonetics_id NUMBER;

Line: 94

    if p_last_updated_by is null then
    p_last_updated_by   := fnd_global.user_id;

Line: 97

    if p_last_update_login is null then
    p_last_update_login := fnd_global.login_id;

Line: 100

    if p_last_update_date is null then
    p_last_update_date  := sysdate;

Line: 104

    UPDATE csf_phonetic_values
    SET language        = p_language,
      phonetic          = p_phonetic,
      code              = p_code,
      description       = p_description,
      enabled_flag      = p_enabled_flag,
      start_date_active = decode(p_start_date_active,NULL,NULL,to_date(p_start_date_active, 'YYYY/MM/DD')),
      end_date_active   = decode(p_end_date_active,NULL,NULL,to_date(p_end_date_active, 'YYYY/MM/DD')),
      created_by        = p_created_by,
      creation_date     = to_date(p_creation_date, 'YYYY/MM/DD'),
      last_updated_by   = p_last_updated_by,
      last_update_login = p_last_update_login,
      last_update_date  = to_date(p_last_update_date, 'YYYY/MM/DD')
    WHERE phonetics_id  = l_phonetics_id;

Line: 121

  END update_phonetics_row;

Line: 135

      p_last_updated_by   IN VARCHAR2 ,
      p_last_update_login IN VARCHAR2 ,
      p_last_update_date  IN VARCHAR2 )
  IS
  BEGIN
    update_phonetics_row (
        p_phonetics_id => p_phonetics_id,
        p_language => p_language,
        p_phonetic => p_phonetic,
        p_code => p_code,
        p_description => p_description,
        p_enabled_flag => p_enabled_flag,
        p_start_date_active => p_start_date_active,
        p_end_date_active => p_end_date_active,
        p_created_by => p_created_by,
        p_creation_date => p_creation_date,
        p_last_updated_by => p_last_updated_by,
        p_last_update_login => p_last_update_login,
        p_last_update_date => p_last_update_date
        );

Line: 157

    insert_phonetics_row (
        p_phonetics_id => p_phonetics_id,
        p_language => p_language,
        p_phonetic => p_phonetic,
        p_code => p_code,
        p_description => p_description,
        p_enabled_flag => p_enabled_flag,
        p_start_date_active => p_start_date_active,
        p_end_date_active => p_end_date_active,
        p_created_by => p_created_by,
        p_creation_date => p_creation_date,
        p_last_updated_by => p_last_updated_by,
        p_last_update_login => p_last_update_login,
        p_last_update_date => p_last_update_date
        );

Line: 182

		l_deleted_records	number;

Line: 187

			SELECT sequence_name
			FROM all_sequences
			WHERE sequence_name LIKE 'CSFW_MSESSION_URLID_S%'
			AND sequence_owner = USER;

Line: 224

			DELETE FROM CSFW_MSESSION_COOKIE
			WHERE session_id IN
			  (SELECT session_id
				FROM CSFW_MSESSION
				WHERE last_access_date <= l_end_date
			  ) RETURNING count(*) INTO l_deleted_records;

Line: 233

						'Deleted records for CSFW_MSESSION_COOKIE = ' || l_deleted_records);

Line: 257

			DELETE FROM CSFW_MSESSION_URL
			WHERE session_id IN
			  (SELECT session_id
				FROM CSFW_MSESSION
				WHERE last_access_date <= l_end_date
			  ) RETURNING count(*) INTO l_deleted_records;

Line: 266

						'Deleted records for CSFW_MSESSION_URL = ' || l_deleted_records);

Line: 289

			DELETE FROM CSFW_MSESSION
			WHERE last_access_date <= l_end_date
			RETURNING count(*) INTO l_deleted_records;

Line: 295

						'Deleted records for CSFW_MSESSION = ' || l_deleted_records);