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.EAM_FAILURECODES_PVT dependencies on EAM_FAILURE_COMBINATIONS

Line 99: FROM eam_failure_combinations

95:
96: IF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_FAILURE_CODE) THEN
97: SELECT count(1)
98: INTO l_code_in_use
99: FROM eam_failure_combinations
100: WHERE failure_code = p_failurecode_rec.code
101: AND rownum < 2;
102: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_CAUSE_CODE) THEN
103: SELECT count(1)

Line 105: FROM eam_failure_combinations

101: AND rownum < 2;
102: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_CAUSE_CODE) THEN
103: SELECT count(1)
104: INTO l_code_in_use
105: FROM eam_failure_combinations
106: WHERE cause_code = p_failurecode_rec.code
107: AND rownum < 2;
108: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_RESOLUTION_CODE) THEN
109: SELECT count(1)

Line 111: FROM eam_failure_combinations

107: AND rownum < 2;
108: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_RESOLUTION_CODE) THEN
109: SELECT count(1)
110: INTO l_code_in_use
111: FROM eam_failure_combinations
112: WHERE resolution_code = p_failurecode_rec.code
113: AND rownum < 2;
114: END IF;
115:

Line 230: FROM eam_failure_combinations

226:
227: IF (p_combination_rec.combination_id IS NOT NULL) THEN
228: SELECT count(1)
229: INTO l_combination_exists
230: FROM eam_failure_combinations
231: WHERE combination_id = p_combination_rec.combination_id;
232: l_combination_id := p_combination_rec.combination_id;
233: ELSE
234: BEGIN

Line 237: FROM eam_failure_combinations

233: ELSE
234: BEGIN
235: SELECT combination_id
236: INTO l_combination_id
237: FROM eam_failure_combinations
238: WHERE set_id = l_set_id
239: AND failure_code = p_combination_rec.failure_code
240: AND cause_code = p_combination_rec.cause_code
241: AND resolution_code = p_combination_rec.resolution_code;

Line 304: FROM eam_failure_combinations

300: ELSIF (p_mode = 'D') THEN
301: IF (l_combination_exists = 0) THEN
302: SELECT min(combination_id)
303: INTO l_combination_id
304: FROM eam_failure_combinations
305: WHERE set_id = l_set_id
306: AND failure_code = p_combination_rec.failure_code
307: AND cause_code = p_combination_rec.cause_code
308: AND resolution_code = p_combination_rec.resolution_code;

Line 598: FROM eam_failure_combinations

594: l_last_update_login NUMBER;
595:
596: CURSOR lock_combination IS
597: SELECT effective_end_date
598: FROM eam_failure_combinations
599: WHERE combination_id = l_combination_id
600: FOR UPDATE NOWAIT;
601:
602: BEGIN

Line 703: -- Insert into eam failure combinations

699: IF (l_failure_code_status = FND_API.G_RET_STS_SUCCESS AND
700: l_cause_code_status = FND_API.G_RET_STS_SUCCESS AND
701: l_resolution_code_status = FND_API.G_RET_STS_SUCCESS) THEN
702:
703: -- Insert into eam failure combinations
704: INSERT INTO eam_failure_combinations
705: (combination_id ,
706: set_id ,
707: failure_code ,

Line 704: INSERT INTO eam_failure_combinations

700: l_cause_code_status = FND_API.G_RET_STS_SUCCESS AND
701: l_resolution_code_status = FND_API.G_RET_STS_SUCCESS) THEN
702:
703: -- Insert into eam failure combinations
704: INSERT INTO eam_failure_combinations
705: (combination_id ,
706: set_id ,
707: failure_code ,
708: cause_code ,

Line 716: VALUES (eam_failure_combinations_s.nextval ,

712: creation_date ,
713: last_update_date ,
714: last_updated_by ,
715: last_update_login)
716: VALUES (eam_failure_combinations_s.nextval ,
717: l_set_id ,
718: p_combination_rec.failure_code ,
719: p_combination_rec.cause_code ,
720: p_combination_rec.resolution_code ,

Line 732: -- update eam failure combinations

728:
729: END IF;
730:
731: ELSIF (p_mode = 'U') THEN
732: -- update eam failure combinations
733: BEGIN
734: OPEN lock_combination;
735:
736: UPDATE eam_failure_combinations

Line 736: UPDATE eam_failure_combinations

732: -- update eam failure combinations
733: BEGIN
734: OPEN lock_combination;
735:
736: UPDATE eam_failure_combinations
737: SET effective_end_date =
738: decode(p_combination_rec.effective_end_date,
739: NULL, effective_end_date,
740: FND_API.G_MISS_DATE, NULL,

Line 753: -- delete from eam failure combinations

749: WHEN G_LOCKROW_EXCEPTION THEN
750: Raise_Error ('EAM_ROW_LOCKED',NULL,NULL);
751: END;
752: ELSIF (p_mode = 'D') THEN
753: -- delete from eam failure combinations
754: DELETE FROM eam_failure_combinations
755: WHERE combination_id = l_combination_id;
756: END IF;
757:

Line 754: DELETE FROM eam_failure_combinations

750: Raise_Error ('EAM_ROW_LOCKED',NULL,NULL);
751: END;
752: ELSIF (p_mode = 'D') THEN
753: -- delete from eam failure combinations
754: DELETE FROM eam_failure_combinations
755: WHERE combination_id = l_combination_id;
756: END IF;
757:
758: x_combination_id := l_combination_id;

Line 838: INSERT INTO eam_failure_combinations

834: -- Initialize API return status to success
835: x_return_status := FND_API.G_RET_STS_SUCCESS;
836:
837: -- Copy active combinations from source set to destination set
838: INSERT INTO eam_failure_combinations
839: (combination_id ,
840: set_id ,
841: failure_code ,
842: cause_code ,

Line 850: SELECT eam_failure_combinations_s.nextval,

846: creation_date ,
847: last_update_date ,
848: last_updated_by ,
849: last_update_login)
850: SELECT eam_failure_combinations_s.nextval,
851: p_destination_set_id ,
852: efc.failure_code ,
853: efc.cause_code ,
854: efc.resolution_code ,

Line 861: FROM eam_failure_combinations efc

857: SYSDATE,
858: SYSDATE,
859: fnd_global.user_id,
860: NULL
861: FROM eam_failure_combinations efc
862: WHERE set_id = p_source_set_id
863: AND effective_end_date IS NULL
864: AND NOT EXISTS
865: (SELECT 1

Line 866: FROM eam_failure_combinations efc2

862: WHERE set_id = p_source_set_id
863: AND effective_end_date IS NULL
864: AND NOT EXISTS
865: (SELECT 1
866: FROM eam_failure_combinations efc2
867: WHERE efc2.set_id = p_destination_set_id
868: AND efc2.failure_code = efc.failure_code
869: AND efc2.cause_code = efc.cause_code
870: AND efc2.resolution_code = efc2.resolution_code);

Line 1115: FROM eam_failure_combinations

1111: x_msg_data OUT NOCOPY VARCHAR2
1112: ) IS
1113: CURSOR lock_combination IS
1114: SELECT effective_end_date,last_update_date
1115: FROM eam_failure_combinations
1116: WHERE combination_id = p_combination_id
1117: FOR UPDATE NOWAIT;
1118:
1119: l_end_date DATE;