APPS.EAM_FAILURESETS_PVT dependencies on EAM_FAILURE_SET_ASSOCIATIONS

Line 95: FROM eam_failure_set_associations efsa,

91: p_failureset_rec.effective_end_date <> l_old_eff_end_date)) THEN
92: BEGIN
93: SELECT efsa.inventory_item_id, msik.concatenated_segments
94: INTO l_inventory_item_id, l_item
95: FROM eam_failure_set_associations efsa,
96: mtl_system_items_kfv msik
97: WHERE efsa.set_id = l_set_id
98: AND msik.inventory_item_id = efsa.inventory_item_id
99: AND EXISTS

Line 101: FROM eam_failure_set_associations efsa1,

97: WHERE efsa.set_id = l_set_id
98: AND msik.inventory_item_id = efsa.inventory_item_id
99: AND EXISTS
100: (SELECT 1
101: FROM eam_failure_set_associations efsa1,
102: eam_failure_sets efs
103: WHERE efsa1.inventory_item_id = efsa.inventory_item_id
104: AND efsa1.set_id <> efsa.set_id
105: AND efs.set_id = efsa1.set_id

Line 198: FROM eam_failure_set_associations

194:
195: -- check for existing set association
196: SELECT count(1)
197: INTO l_association_exists
198: FROM eam_failure_set_associations
199: WHERE set_id = l_set_id
200: AND inventory_item_id = p_association_rec.inventory_item_id
201: AND effective_end_date IS NULL;
202:

Line 213: FROM eam_failure_set_associations efsa,

209:
210: l_association_exists := 0;
211: SELECT count(1)
212: INTO l_association_exists
213: FROM eam_failure_set_associations efsa,
214: eam_failure_sets efs
215: WHERE efsa.inventory_item_id = p_association_rec.inventory_item_id
216: AND efsa.set_id <> l_set_id
217: AND efs.set_id = efsa.set_id

Line 429: FROM eam_failure_set_associations

425: l_last_update_login NUMBER;
426:
427: CURSOR lock_association(p_set_id NUMBER, p_item_id NUMBER) IS
428: SELECT failure_code_required, effective_end_date
429: FROM eam_failure_set_associations
430: WHERE set_id = p_set_id
431: AND inventory_item_id = p_item_id
432: AND effective_end_date IS NULL
433: FOR UPDATE NOWAIT;

Line 475: UPDATE eam_failure_set_associations

471: END IF;
472:
473: IF (p_mode = 'C') THEN
474:
475: UPDATE eam_failure_set_associations
476: SET effective_end_date = NULL,
477: last_update_date = l_last_update_date,
478: last_updated_by = l_last_updated_by,
479: last_update_login = l_last_update_login

Line 484: -- Insert into eam failure set associations

480: WHERE set_id = l_set_id
481: AND inventory_item_id = p_association_rec.inventory_item_id;
482:
483: IF (SQL%ROWCOUNT = 0) THEN
484: -- Insert into eam failure set associations
485: INSERT INTO eam_failure_set_associations
486: (set_id ,
487: inventory_item_id ,
488: failure_code_required,

Line 485: INSERT INTO eam_failure_set_associations

481: AND inventory_item_id = p_association_rec.inventory_item_id;
482:
483: IF (SQL%ROWCOUNT = 0) THEN
484: -- Insert into eam failure set associations
485: INSERT INTO eam_failure_set_associations
486: (set_id ,
487: inventory_item_id ,
488: failure_code_required,
489: created_by ,

Line 504: -- update eam failure set associations

500: l_last_updated_by ,
501: l_last_update_login);
502: END IF;
503: ELSIF (p_mode IN ('U','D')) THEN
504: -- update eam failure set associations
505: BEGIN
506: OPEN lock_association(l_set_id, p_association_rec.inventory_item_id);
507: IF (p_mode = 'U') THEN
508:

Line 509: UPDATE eam_failure_set_associations

505: BEGIN
506: OPEN lock_association(l_set_id, p_association_rec.inventory_item_id);
507: IF (p_mode = 'U') THEN
508:
509: UPDATE eam_failure_set_associations
510: SET failure_code_required = decode(
511: p_association_rec.failure_code_required,
512: 'Y','Y',
513: NULL, failure_code_required,

Line 524: UPDATE eam_failure_set_associations

520: AND effective_end_date IS NULL;
521:
522: ELSIF (p_mode = 'D') THEN
523:
524: UPDATE eam_failure_set_associations
525: SET effective_end_date = SYSDATE,
526: last_update_date = l_last_update_date,
527: last_updated_by = l_last_updated_by,
528: last_update_login = l_last_update_login

Line 693: FROM eam_failure_set_associations

689: )
690: IS
691: CURSOR lock_association(c_set_id NUMBER, c_item_id NUMBER) IS
692: SELECT failure_code_required, effective_end_date, last_update_date
693: FROM eam_failure_set_associations
694: WHERE set_id = c_set_id
695: AND inventory_item_id = c_item_id
696: AND effective_end_date IS NULL
697: FOR UPDATE NOWAIT;