APPS.EAM_FAILURECODES_PVT dependencies on EAM_RESOLUTION_CODES

Line 61: FROM eam_resolution_codes

57: WHERE cause_code = p_failurecode_rec.code;
58: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_RESOLUTION_CODE) THEN
59: SELECT effective_end_date
60: INTO l_eff_end_date
61: FROM eam_resolution_codes
62: WHERE resolution_code = p_failurecode_rec.code;
63: END IF;
64:
65: l_code_exists := SQL%ROWCOUNT;

Line 213: FROM eam_resolution_codes

209:
210: BEGIN
211: SELECT effective_end_date
212: INTO l_resolution_end_date
213: FROM eam_resolution_codes
214: WHERE resolution_code = p_combination_rec.resolution_code;
215: l_resolution_exists := SQL%ROWCOUNT;
216: EXCEPTION
217: WHEN NO_DATA_FOUND THEN

Line 360: FROM eam_resolution_codes

356: FOR UPDATE NOWAIT;
357:
358: CURSOR lock_rc IS
359: SELECT description, effective_end_date
360: FROM eam_resolution_codes
361: WHERE resolution_code = l_code
362: FOR UPDATE NOWAIT;
363:
364: BEGIN

Line 434: -- Insert into eam resolution codes

430: fnd_global.user_id,
431: NULL);
432: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_RESOLUTION_CODE) THEN
433:
434: -- Insert into eam resolution codes
435: INSERT INTO eam_resolution_codes
436: (resolution_code ,
437: description ,
438: effective_end_date,

Line 435: INSERT INTO eam_resolution_codes

431: NULL);
432: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_RESOLUTION_CODE) THEN
433:
434: -- Insert into eam resolution codes
435: INSERT INTO eam_resolution_codes
436: (resolution_code ,
437: description ,
438: effective_end_date,
439: created_by ,

Line 486: UPDATE eam_resolution_codes

482: WHERE cause_code = l_code;
483: CLOSE lock_cc;
484: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_RESOLUTION_CODE) THEN
485: OPEN lock_rc;
486: UPDATE eam_resolution_codes
487: SET description = decode(p_failurecode_rec.description,
488: NULL,description,
489: FND_API.G_MISS_CHAR, NULL,
490: p_failurecode_rec.description),

Line 509: DELETE FROM eam_resolution_codes

505: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_CAUSE_CODE) THEN
506: DELETE FROM eam_cause_codes
507: WHERE cause_code = l_code;
508: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_RESOLUTION_CODE) THEN
509: DELETE FROM eam_resolution_codes
510: WHERE resolution_code = l_code;
511: END IF;
512:
513: END IF;

Line 1041: FROM eam_resolution_codes

1037: FOR UPDATE NOWAIT;
1038:
1039: CURSOR lock_rc IS
1040: SELECT description, effective_end_date, last_update_date
1041: FROM eam_resolution_codes
1042: WHERE resolution_code = p_code
1043: FOR UPDATE NOWAIT;
1044:
1045: l_description VARCHAR2(200);