DBA Data[Home] [Help]

APPS.EAM_FAILURECODES_PVT dependencies on FND_GLOBAL

Line 407: fnd_global.user_id,

403: last_update_login)
404: VALUES (p_failurecode_rec.code ,
405: p_failurecode_rec.description ,
406: p_failurecode_rec.effective_end_date,
407: fnd_global.user_id,
408: SYSDATE,
409: SYSDATE,
410: fnd_global.user_id,
411: NULL);

Line 410: fnd_global.user_id,

406: p_failurecode_rec.effective_end_date,
407: fnd_global.user_id,
408: SYSDATE,
409: SYSDATE,
410: fnd_global.user_id,
411: NULL);
412: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_CAUSE_CODE) THEN
413:
414: -- Insert into eam cause codes

Line 427: fnd_global.user_id,

423: last_update_login)
424: VALUES (p_failurecode_rec.code ,
425: p_failurecode_rec.description ,
426: p_failurecode_rec.effective_end_date,
427: fnd_global.user_id,
428: SYSDATE,
429: SYSDATE,
430: fnd_global.user_id,
431: NULL);

Line 430: fnd_global.user_id,

426: p_failurecode_rec.effective_end_date,
427: fnd_global.user_id,
428: SYSDATE,
429: SYSDATE,
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

Line 447: fnd_global.user_id,

443: last_update_login)
444: VALUES (p_failurecode_rec.code ,
445: p_failurecode_rec.description ,
446: p_failurecode_rec.effective_end_date,
447: fnd_global.user_id,
448: SYSDATE,
449: SYSDATE,
450: fnd_global.user_id,
451: NULL);

Line 450: fnd_global.user_id,

446: p_failurecode_rec.effective_end_date,
447: fnd_global.user_id,
448: SYSDATE,
449: SYSDATE,
450: fnd_global.user_id,
451: NULL);
452: END IF;
453:
454: ELSIF (p_mode = 'U') THEN

Line 628: l_created_by := fnd_global.user_id;

624: Validate_Combination (p_mode, p_validation_level, p_combination_rec,
625: l_set_id,l_failure_exists, l_cause_exists,
626: l_resolution_exists, l_combination_id);
627: IF (p_combination_rec.last_update_date is null) THEN
628: l_created_by := fnd_global.user_id;
629: l_creation_date := SYSDATE;
630: l_last_update_date := SYSDATE;
631: l_last_updated_by := fnd_global.user_id;
632: l_last_update_login := NULL;

Line 631: l_last_updated_by := fnd_global.user_id;

627: IF (p_combination_rec.last_update_date is null) THEN
628: l_created_by := fnd_global.user_id;
629: l_creation_date := SYSDATE;
630: l_last_update_date := SYSDATE;
631: l_last_updated_by := fnd_global.user_id;
632: l_last_update_login := NULL;
633: ELSE
634: l_created_by := p_combination_rec.created_by;
635: l_creation_date := p_combination_rec.creation_date;

Line 856: fnd_global.user_id,

852: efc.failure_code ,
853: efc.cause_code ,
854: efc.resolution_code ,
855: efc.effective_end_date,
856: fnd_global.user_id,
857: SYSDATE,
858: SYSDATE,
859: fnd_global.user_id,
860: NULL

Line 859: fnd_global.user_id,

855: efc.effective_end_date,
856: fnd_global.user_id,
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