APPS.EAM_FAILURECODES_PVT dependencies on EAM_FAILURE_CODES

Line 51: FROM eam_failure_codes

47: BEGIN
48: IF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_FAILURE_CODE) THEN
49: SELECT effective_end_date
50: INTO l_eff_end_date
51: FROM eam_failure_codes
52: WHERE failure_code = p_failurecode_rec.code;
53: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_CAUSE_CODE) THEN
54: SELECT effective_end_date
55: INTO l_eff_end_date

Line 191: FROM eam_failure_codes

187:
188: BEGIN
189: SELECT effective_end_date
190: INTO l_failure_end_date
191: FROM eam_failure_codes
192: WHERE failure_code = p_combination_rec.failure_code;
193: l_failure_exists := SQL%ROWCOUNT;
194: EXCEPTION
195: WHEN NO_DATA_FOUND THEN

Line 348: FROM eam_failure_codes

344: l_code VARCHAR2(80);
345:
346: CURSOR lock_fc IS
347: SELECT description, effective_end_date
348: FROM eam_failure_codes
349: WHERE failure_code = l_code
350: FOR UPDATE NOWAIT;
351:
352: CURSOR lock_cc IS

Line 394: -- Insert into eam failure codes

390: IF (p_mode = 'C') THEN
391:
392: IF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_FAILURE_CODE) THEN
393:
394: -- Insert into eam failure codes
395: INSERT INTO eam_failure_codes
396: (failure_code ,
397: description ,
398: effective_end_date,

Line 395: INSERT INTO eam_failure_codes

391:
392: IF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_FAILURE_CODE) THEN
393:
394: -- Insert into eam failure codes
395: INSERT INTO eam_failure_codes
396: (failure_code ,
397: description ,
398: effective_end_date,
399: created_by ,

Line 458: UPDATE eam_failure_codes

454: ELSIF (p_mode = 'U') THEN
455:
456: IF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_FAILURE_CODE) THEN
457: OPEN lock_fc;
458: UPDATE eam_failure_codes
459: SET description = decode(p_failurecode_rec.description,
460: NULL,description,
461: FND_API.G_MISS_CHAR, NULL,
462: p_failurecode_rec.description),

Line 503: DELETE FROM eam_failure_codes

499:
500: ELSIF (p_mode = 'D') THEN
501:
502: IF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_FAILURE_CODE) THEN
503: DELETE FROM eam_failure_codes
504: WHERE failure_code = l_code;
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;

Line 1029: FROM eam_failure_codes

1025: x_msg_data OUT NOCOPY VARCHAR2
1026: ) IS
1027: CURSOR lock_fc IS
1028: SELECT description, effective_end_date, last_update_date
1029: FROM eam_failure_codes
1030: WHERE failure_code = p_code
1031: FOR UPDATE NOWAIT;
1032:
1033: CURSOR lock_cc IS