APPS.EAM_FAILURECODES_PVT SQL Statements

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

Line: 49

           SELECT effective_end_date
             INTO l_eff_end_date
             FROM eam_failure_codes
            WHERE failure_code = p_failurecode_rec.code;

Line: 54

           SELECT effective_end_date
             INTO l_eff_end_date
             FROM eam_cause_codes
            WHERE cause_code = p_failurecode_rec.code;

Line: 59

           SELECT effective_end_date
             INTO l_eff_end_date
             FROM eam_resolution_codes
            WHERE resolution_code = p_failurecode_rec.code;

Line: 97

            SELECT count(1)
              INTO l_code_in_use
              FROM eam_failure_combinations
             WHERE failure_code = p_failurecode_rec.code
               AND rownum < 2;

Line: 103

            SELECT count(1)
              INTO l_code_in_use
              FROM eam_failure_combinations
             WHERE cause_code = p_failurecode_rec.code
               AND rownum < 2;

Line: 109

            SELECT count(1)
              INTO l_code_in_use
              FROM eam_failure_combinations
             WHERE resolution_code = p_failurecode_rec.code
               AND rownum < 2;

Line: 159

            SELECT min(set_id)
              INTO l_set_id
              FROM eam_failure_sets
             WHERE set_name = p_combination_rec.set_name;

Line: 171

      SELECT min(effective_end_date)
        INTO l_set_end_date
        FROM eam_failure_sets
       WHERE set_id = l_set_id;

Line: 189

         SELECT effective_end_date
           INTO l_failure_end_date
           FROM eam_failure_codes
          WHERE failure_code = p_combination_rec.failure_code;

Line: 200

         SELECT effective_end_date
           INTO l_cause_end_date
           FROM eam_cause_codes
          WHERE cause_code = p_combination_rec.cause_code;

Line: 211

         SELECT effective_end_date
           INTO l_resolution_end_date
           FROM eam_resolution_codes
          WHERE resolution_code = p_combination_rec.resolution_code;

Line: 228

         SELECT count(1)
	   INTO l_combination_exists
	   FROM eam_failure_combinations
	  WHERE combination_id = p_combination_rec.combination_id;

Line: 235

           SELECT combination_id
             INTO l_combination_id
             FROM eam_failure_combinations
            WHERE set_id = l_set_id
              AND failure_code = p_combination_rec.failure_code
              AND cause_code = p_combination_rec.cause_code
              AND resolution_code = p_combination_rec.resolution_code;

Line: 302

           SELECT min(combination_id)
             INTO l_combination_id
             FROM eam_failure_combinations
            WHERE set_id = l_set_id
              AND failure_code = p_combination_rec.failure_code
              AND cause_code = p_combination_rec.cause_code
              AND resolution_code = p_combination_rec.resolution_code;

Line: 313

            SELECT count(1)
              INTO l_combination_used
              FROM eam_asset_failure_codes
             WHERE combination_id = l_combination_id
               AND rownum < 2;

Line: 347

SELECT description, effective_end_date
  FROM eam_failure_codes
 WHERE failure_code = l_code
   FOR UPDATE NOWAIT;

Line: 353

SELECT description, effective_end_date
  FROM eam_cause_codes
 WHERE cause_code = l_code
   FOR UPDATE NOWAIT;

Line: 359

SELECT description, effective_end_date
  FROM eam_resolution_codes
 WHERE resolution_code = l_code
   FOR UPDATE NOWAIT;

Line: 394

	   -- Insert into eam failure codes
	   INSERT INTO eam_failure_codes
	               (failure_code      ,
                        description       ,
                        effective_end_date,
                        created_by        ,
                        creation_date     ,
                        last_update_date  ,
                        last_updated_by   ,
                        last_update_login)
                 VALUES (p_failurecode_rec.code          ,
                         p_failurecode_rec.description       ,
                         p_failurecode_rec.effective_end_date,
                         fnd_global.user_id,
                         SYSDATE,
                         SYSDATE,
                         fnd_global.user_id,
                         NULL);

Line: 414

	   -- Insert into eam cause codes
	   INSERT INTO eam_cause_codes
	               (cause_code      ,
                        description       ,
                        effective_end_date,
                        created_by        ,
                        creation_date     ,
                        last_update_date  ,
                        last_updated_by   ,
                        last_update_login)
                 VALUES (p_failurecode_rec.code              ,
                         p_failurecode_rec.description       ,
                         p_failurecode_rec.effective_end_date,
                         fnd_global.user_id,
                         SYSDATE,
                         SYSDATE,
                         fnd_global.user_id,
                         NULL);

Line: 434

	   -- Insert into eam resolution codes
	   INSERT INTO eam_resolution_codes
	               (resolution_code      ,
                        description       ,
                        effective_end_date,
                        created_by        ,
                        creation_date     ,
                        last_update_date  ,
                        last_updated_by   ,
                        last_update_login)
                 VALUES (p_failurecode_rec.code              ,
                         p_failurecode_rec.description       ,
                         p_failurecode_rec.effective_end_date,
                         fnd_global.user_id,
                         SYSDATE,
                         SYSDATE,
                         fnd_global.user_id,
                         NULL);

Line: 458

             UPDATE eam_failure_codes
                SET description = decode(p_failurecode_rec.description,
                                         NULL,description,
                                         FND_API.G_MISS_CHAR, NULL,
                                         p_failurecode_rec.description),
                    effective_end_date = decode(
                                         p_failurecode_rec.effective_end_date,
                                         NULL,effective_end_date,
                                         FND_API.G_MISS_DATE,NULL,
                                         p_failurecode_rec.effective_end_date)
              WHERE failure_code = l_code;

Line: 472

             UPDATE eam_cause_codes
                SET description = decode(p_failurecode_rec.description,
                                         NULL,description,
                                         FND_API.G_MISS_CHAR, NULL,
                                         p_failurecode_rec.description),
                    effective_end_date = decode(
                                         p_failurecode_rec.effective_end_date,
                                         NULL,effective_end_date,
                                         FND_API.G_MISS_DATE,NULL,
                                         p_failurecode_rec.effective_end_date)
              WHERE cause_code = l_code;

Line: 486

             UPDATE eam_resolution_codes
                SET description = decode(p_failurecode_rec.description,
                                         NULL,description,
                                         FND_API.G_MISS_CHAR, NULL,
                                         p_failurecode_rec.description),
                    effective_end_date = decode(
                                         p_failurecode_rec.effective_end_date,
                                         NULL,effective_end_date,
                                         FND_API.G_MISS_DATE,NULL,
                                         p_failurecode_rec.effective_end_date)
              WHERE resolution_code = l_code;

Line: 503

             DELETE FROM eam_failure_codes
              WHERE failure_code = l_code;

Line: 506

             DELETE FROM eam_cause_codes
              WHERE cause_code = l_code;

Line: 509

             DELETE FROM eam_resolution_codes
              WHERE resolution_code = l_code;

Line: 592

l_last_update_date       DATE;

Line: 593

l_last_updated_by        NUMBER;

Line: 594

l_last_update_login      NUMBER;

Line: 597

SELECT effective_end_date
  FROM eam_failure_combinations
 WHERE combination_id = l_combination_id
   FOR UPDATE NOWAIT;

Line: 627

    IF (p_combination_rec.last_update_date is null) THEN
          l_created_by             := fnd_global.user_id;

Line: 630

          l_last_update_date       := SYSDATE;

Line: 631

          l_last_updated_by        := fnd_global.user_id;

Line: 632

          l_last_update_login      := NULL;

Line: 636

          l_last_update_date       := p_combination_rec.last_update_date;

Line: 637

          l_last_updated_by        := p_combination_rec.last_updated_by;

Line: 638

          l_last_update_login      := p_combination_rec.last_update_login;

Line: 703

	    -- Insert into eam failure combinations
	     INSERT INTO eam_failure_combinations
                    (combination_id       ,
                     set_id               ,
                     failure_code         ,
                     cause_code           ,
                     resolution_code      ,
                     effective_end_date   ,
	             created_by           ,
	             creation_date        ,
	             last_update_date     ,
	             last_updated_by      ,
	             last_update_login)
	      VALUES (eam_failure_combinations_s.nextval          ,
	              l_set_id                            ,
	              p_combination_rec.failure_code      ,
	              p_combination_rec.cause_code        ,
	              p_combination_rec.resolution_code   ,
	              p_combination_rec.effective_end_date,
                      l_created_by        ,
                      l_creation_date     ,
                      l_last_update_date  ,
                      l_last_updated_by   ,
                      l_last_update_login)
             RETURNING combination_id INTO l_combination_id;

Line: 736

           UPDATE eam_failure_combinations
              SET effective_end_date =
                             decode(p_combination_rec.effective_end_date,
                             NULL, effective_end_date,
                             FND_API.G_MISS_DATE, NULL,
                             p_combination_rec.effective_end_date),
                  last_update_date = l_last_update_date,
                  last_updated_by = l_last_updated_by,
                  last_update_login = l_last_update_login
            WHERE combination_id = l_combination_id;

Line: 754

      DELETE FROM eam_failure_combinations
       WHERE combination_id = l_combination_id;

Line: 838

    INSERT INTO eam_failure_combinations
                    (combination_id       ,
                     set_id               ,
                     failure_code         ,
                     cause_code           ,
                     resolution_code      ,
                     effective_end_date   ,
	             created_by           ,
	             creation_date        ,
	             last_update_date     ,
	             last_updated_by      ,
	             last_update_login)
	      SELECT eam_failure_combinations_s.nextval,
	             p_destination_set_id  ,
	             efc.failure_code      ,
	             efc.cause_code        ,
	             efc.resolution_code   ,
	             efc.effective_end_date,
                     fnd_global.user_id,
                     SYSDATE,
                     SYSDATE,
                     fnd_global.user_id,
                     NULL
                FROM eam_failure_combinations efc
               WHERE set_id = p_source_set_id
                 AND effective_end_date IS NULL
                 AND NOT EXISTS
                     (SELECT 1
                        FROM eam_failure_combinations efc2
                       WHERE efc2.set_id = p_destination_set_id
                         AND efc2.failure_code = efc.failure_code
                         AND efc2.cause_code = efc.cause_code
                         AND efc2.resolution_code = efc2.resolution_code);

Line: 973

	  p_last_update_date       IN DATE      ,
	  p_last_updated_by        IN NUMBER    ,
	  p_last_update_login      IN NUMBER    ,
          x_return_status    OUT NOCOPY VARCHAR2,
          x_msg_count        OUT NOCOPY NUMBER  ,
          x_msg_data         OUT NOCOPY VARCHAR2,
          x_combination_id   OUT NOCOPY NUMBER
          ) IS
l_combination_rec  EAM_FailureCodes_PUB.eam_combination_rec_type;

Line: 995

        l_combination_rec.last_update_date       := p_last_update_date;

Line: 996

        l_combination_rec.last_updated_by        := p_last_updated_by;

Line: 997

        l_combination_rec.last_update_login      := p_last_update_login;

Line: 1022

          p_last_update_date  IN DATE    ,
          x_return_status    OUT NOCOPY VARCHAR2,
          x_msg_count        OUT NOCOPY NUMBER  ,
          x_msg_data         OUT NOCOPY VARCHAR2
         ) IS
CURSOR lock_fc IS
SELECT description, effective_end_date, last_update_date
  FROM eam_failure_codes
 WHERE failure_code = p_code
   FOR UPDATE NOWAIT;

Line: 1034

SELECT description, effective_end_date, last_update_date
  FROM eam_cause_codes
 WHERE cause_code = p_code
   FOR UPDATE NOWAIT;

Line: 1040

SELECT description, effective_end_date, last_update_date
  FROM eam_resolution_codes
 WHERE resolution_code = p_code
   FOR UPDATE NOWAIT;

Line: 1047

l_last_update_date      DATE;

Line: 1059

              INTO l_description, l_end_date, l_last_update_date;

Line: 1065

              INTO l_description, l_end_date, l_last_update_date;

Line: 1071

              INTO l_description, l_end_date, l_last_update_date;

Line: 1075

         IF (p_last_update_date <> l_last_update_date) THEN
                       FND_MESSAGE.SET_NAME ('FND', 'FND_RECORD_CHANGED_ERROR');

Line: 1081

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

Line: 1108

	  p_last_update_date IN DATE 	 ,
          x_return_status    OUT NOCOPY VARCHAR2,
          x_msg_count        OUT NOCOPY NUMBER  ,
          x_msg_data         OUT NOCOPY VARCHAR2
          ) IS
CURSOR lock_combination IS
SELECT effective_end_date,last_update_date
  FROM eam_failure_combinations
 WHERE combination_id = p_combination_id
   FOR UPDATE NOWAIT;

Line: 1120

l_last_update_date      DATE;

Line: 1131

                INTO l_end_date, l_last_update_date;

Line: 1134

                IF (p_last_update_date <> l_last_update_date) THEN
                        FND_MESSAGE.SET_NAME ('FND', 'FND_RECORD_CHANGED_ERROR');

Line: 1140

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