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.AHL_UMP_PROCESSUNIT_EXTN_PVT dependencies on FND_GLOBAL

Line 595: LAST_UPDATED_BY = fnd_global.user_id,

591: UPDATE AHL_UNIT_EFFECTIVITIES_B
592: SET REPETITIVE_MR_FLAG = 'N',
593: DATE_RUN = SYSDATE,
594: LAST_UPDATE_DATE = SYSDATE,
595: LAST_UPDATED_BY = fnd_global.user_id,
596: LAST_UPDATE_LOGIN = fnd_global.login_id
597: WHERE unit_effectivity_id = l_min_mr_ue_id;
598: -- update l_min_ue_id
599: UPDATE AHL_UNIT_EFFECTIVITIES_B

Line 596: LAST_UPDATE_LOGIN = fnd_global.login_id

592: SET REPETITIVE_MR_FLAG = 'N',
593: DATE_RUN = SYSDATE,
594: LAST_UPDATE_DATE = SYSDATE,
595: LAST_UPDATED_BY = fnd_global.user_id,
596: LAST_UPDATE_LOGIN = fnd_global.login_id
597: WHERE unit_effectivity_id = l_min_mr_ue_id;
598: -- update l_min_ue_id
599: UPDATE AHL_UNIT_EFFECTIVITIES_B
600: SET REPETITIVE_MR_FLAG = 'Y',

Line 617: LAST_UPDATED_BY = fnd_global.user_id,

613: UPDATE AHL_UNIT_EFFECTIVITIES_B
614: SET REPETITIVE_MR_FLAG = 'Y',
615: DATE_RUN = SYSDATE,
616: LAST_UPDATE_DATE = SYSDATE,
617: LAST_UPDATED_BY = fnd_global.user_id,
618: LAST_UPDATE_LOGIN = fnd_global.login_id
619: WHERE unit_effectivity_id = l_min_mr_ue_id;
620: END IF;
621: ELSIF (l_min_mr_flag = FALSE AND l_min_def_flag = TRUE) THEN

Line 618: LAST_UPDATE_LOGIN = fnd_global.login_id

614: SET REPETITIVE_MR_FLAG = 'Y',
615: DATE_RUN = SYSDATE,
616: LAST_UPDATE_DATE = SYSDATE,
617: LAST_UPDATED_BY = fnd_global.user_id,
618: LAST_UPDATE_LOGIN = fnd_global.login_id
619: WHERE unit_effectivity_id = l_min_mr_ue_id;
620: END IF;
621: ELSIF (l_min_mr_flag = FALSE AND l_min_def_flag = TRUE) THEN
622: -- update l_min_ue_id

Line 634: LAST_UPDATED_BY = fnd_global.user_id,

630: UPDATE AHL_UNIT_EFFECTIVITIES_B
631: SET REPETITIVE_MR_FLAG = 'N',
632: DATE_RUN = SYSDATE,
633: LAST_UPDATE_DATE = SYSDATE,
634: LAST_UPDATED_BY = fnd_global.user_id,
635: LAST_UPDATE_LOGIN = fnd_global.login_id
636: WHERE unit_effectivity_id = l_min_mr_ue_id;
637: ELSIF (l_min_mr_flag = FALSE AND l_min_def_flag = FALSE) THEN
638: IF (l_min_ue_id IS NOT NULL) THEN

Line 635: LAST_UPDATE_LOGIN = fnd_global.login_id

631: SET REPETITIVE_MR_FLAG = 'N',
632: DATE_RUN = SYSDATE,
633: LAST_UPDATE_DATE = SYSDATE,
634: LAST_UPDATED_BY = fnd_global.user_id,
635: LAST_UPDATE_LOGIN = fnd_global.login_id
636: WHERE unit_effectivity_id = l_min_mr_ue_id;
637: ELSIF (l_min_mr_flag = FALSE AND l_min_def_flag = FALSE) THEN
638: IF (l_min_ue_id IS NOT NULL) THEN
639: -- update l_min_ue_id

Line 652: LAST_UPDATED_BY = fnd_global.user_id,

648: UPDATE AHL_UNIT_EFFECTIVITIES_B
649: SET REPETITIVE_MR_FLAG = 'Y',
650: DATE_RUN = SYSDATE,
651: LAST_UPDATE_DATE = SYSDATE,
652: LAST_UPDATED_BY = fnd_global.user_id,
653: LAST_UPDATE_LOGIN = fnd_global.login_id
654: WHERE unit_effectivity_id = l_min_mr_ue_id;
655: END IF;
656: END IF;

Line 653: LAST_UPDATE_LOGIN = fnd_global.login_id

649: SET REPETITIVE_MR_FLAG = 'Y',
650: DATE_RUN = SYSDATE,
651: LAST_UPDATE_DATE = SYSDATE,
652: LAST_UPDATED_BY = fnd_global.user_id,
653: LAST_UPDATE_LOGIN = fnd_global.login_id
654: WHERE unit_effectivity_id = l_min_mr_ue_id;
655: END IF;
656: END IF;
657:

Line 833: X_LAST_UPDATED_BY => fnd_global.user_id,

829: X_ATTRIBUTE14 => l_ue_rec.attribute14,
830: X_ATTRIBUTE15 => l_ue_rec.attribute15,
831: X_OBJECT_VERSION_NUMBER => l_ue_rec.object_version_number, -- no change to this needed.
832: X_LAST_UPDATE_DATE => sysdate,
833: X_LAST_UPDATED_BY => fnd_global.user_id,
834: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
835: ELSE
836:
837: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UE_NOTFOUND');

Line 834: X_LAST_UPDATE_LOGIN => fnd_global.login_id);

830: X_ATTRIBUTE15 => l_ue_rec.attribute15,
831: X_OBJECT_VERSION_NUMBER => l_ue_rec.object_version_number, -- no change to this needed.
832: X_LAST_UPDATE_DATE => sysdate,
833: X_LAST_UPDATED_BY => fnd_global.user_id,
834: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
835: ELSE
836:
837: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UE_NOTFOUND');
838: FND_MESSAGE.Set_Token('UE_ID',l_ue_rec.unit_effectivity_id);

Line 1059: LAST_UPDATED_BY = fnd_global.user_id,

1055: SET repetitive_mr_flag = 'N',
1056: date_run = sysdate,
1057: last_update_date = sysdate,
1058: object_version_number = object_version_number + 1,
1059: LAST_UPDATED_BY = fnd_global.user_id,
1060: LAST_UPDATE_LOGIN = fnd_global.login_id
1061: WHERE unit_effectivity_id = exception_rec.unit_effectivity_id;
1062: END IF;
1063: ELSE

Line 1060: LAST_UPDATE_LOGIN = fnd_global.login_id

1056: date_run = sysdate,
1057: last_update_date = sysdate,
1058: object_version_number = object_version_number + 1,
1059: LAST_UPDATED_BY = fnd_global.user_id,
1060: LAST_UPDATE_LOGIN = fnd_global.login_id
1061: WHERE unit_effectivity_id = exception_rec.unit_effectivity_id;
1062: END IF;
1063: ELSE
1064: IF (exception_rec.defer_from_ue_id IS NULL) OR

Line 1178: X_LAST_UPDATED_BY => fnd_global.user_id,

1174: X_ATTRIBUTE14 => exception_rec.attribute14,
1175: X_ATTRIBUTE15 => exception_rec.attribute15,
1176: X_OBJECT_VERSION_NUMBER => exception_rec.object_version_number + 1,
1177: X_LAST_UPDATE_DATE => sysdate,
1178: X_LAST_UPDATED_BY => fnd_global.user_id,
1179: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
1180:
1181: -- Delete the corresponding rows in ahl_schedule materials for this ue.
1182: Delete_Sch_Materials(exception_rec.unit_effectivity_id);

Line 1179: X_LAST_UPDATE_LOGIN => fnd_global.login_id);

1175: X_ATTRIBUTE15 => exception_rec.attribute15,
1176: X_OBJECT_VERSION_NUMBER => exception_rec.object_version_number + 1,
1177: X_LAST_UPDATE_DATE => sysdate,
1178: X_LAST_UPDATED_BY => fnd_global.user_id,
1179: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
1180:
1181: -- Delete the corresponding rows in ahl_schedule materials for this ue.
1182: Delete_Sch_Materials(exception_rec.unit_effectivity_id);
1183:

Line 1246: X_LAST_UPDATED_BY => fnd_global.user_id,

1242: X_ATTRIBUTE14 => l_ue_rec.attribute14,
1243: X_ATTRIBUTE15 => l_ue_rec.attribute15,
1244: X_OBJECT_VERSION_NUMBER => l_ue_rec.object_version_number + 1,
1245: X_LAST_UPDATE_DATE => sysdate,
1246: X_LAST_UPDATED_BY => fnd_global.user_id,
1247: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
1248:
1249: -- Delete the corresponding rows in ahl_schedule materials for this ue.
1250: Delete_Sch_Materials(l_ue_rec.unit_effectivity_id);

Line 1247: X_LAST_UPDATE_LOGIN => fnd_global.login_id);

1243: X_ATTRIBUTE15 => l_ue_rec.attribute15,
1244: X_OBJECT_VERSION_NUMBER => l_ue_rec.object_version_number + 1,
1245: X_LAST_UPDATE_DATE => sysdate,
1246: X_LAST_UPDATED_BY => fnd_global.user_id,
1247: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
1248:
1249: -- Delete the corresponding rows in ahl_schedule materials for this ue.
1250: Delete_Sch_Materials(l_ue_rec.unit_effectivity_id);
1251:

Line 1400: X_CREATED_BY => fnd_global.user_id,

1396: X_ATTRIBUTE14 => null, /* ATTRIBUTE14 */
1397: X_ATTRIBUTE15 => null, /* ATTRIBUTE15 */
1398: X_OBJECT_VERSION_NUMBER => 1, /* object version */
1399: X_CREATION_DATE => sysdate,
1400: X_CREATED_BY => fnd_global.user_id,
1401: X_LAST_UPDATE_DATE => sysdate,
1402: X_LAST_UPDATED_BY => fnd_global.user_id,
1403: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
1404: -- JKJain, NR Analysis and Forecasting

Line 1402: X_LAST_UPDATED_BY => fnd_global.user_id,

1398: X_OBJECT_VERSION_NUMBER => 1, /* object version */
1399: X_CREATION_DATE => sysdate,
1400: X_CREATED_BY => fnd_global.user_id,
1401: X_LAST_UPDATE_DATE => sysdate,
1402: X_LAST_UPDATED_BY => fnd_global.user_id,
1403: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
1404: -- JKJain, NR Analysis and Forecasting
1405: X_FLEET_HEADER_ID => p_x_temp_mr_rec.fleet_header_id);
1406:

Line 1403: X_LAST_UPDATE_LOGIN => fnd_global.login_id,

1399: X_CREATION_DATE => sysdate,
1400: X_CREATED_BY => fnd_global.user_id,
1401: X_LAST_UPDATE_DATE => sysdate,
1402: X_LAST_UPDATED_BY => fnd_global.user_id,
1403: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
1404: -- JKJain, NR Analysis and Forecasting
1405: X_FLEET_HEADER_ID => p_x_temp_mr_rec.fleet_header_id);
1406:
1407: p_x_temp_mr_rec.unit_effectivity_id := l_unit_effectivity_id;

Line 1501: X_LAST_UPDATED_BY => fnd_global.user_id,

1497: X_ATTRIBUTE14 => p_mr_rec.ATTRIBUTE14,
1498: X_ATTRIBUTE15 => p_mr_rec.ATTRIBUTE15,
1499: X_OBJECT_VERSION_NUMBER => p_mr_rec.object_version_number+1,
1500: X_LAST_UPDATE_DATE => sysdate,
1501: X_LAST_UPDATED_BY => fnd_global.user_id,
1502: X_LAST_UPDATE_LOGIN => fnd_global.login_id ,
1503: -- JKJain, NR Analysis and Forecasting
1504: X_FLEET_HEADER_ID => p_temp_mr_rec.fleet_header_id);
1505:

Line 1502: X_LAST_UPDATE_LOGIN => fnd_global.login_id ,

1498: X_ATTRIBUTE15 => p_mr_rec.ATTRIBUTE15,
1499: X_OBJECT_VERSION_NUMBER => p_mr_rec.object_version_number+1,
1500: X_LAST_UPDATE_DATE => sysdate,
1501: X_LAST_UPDATED_BY => fnd_global.user_id,
1502: X_LAST_UPDATE_LOGIN => fnd_global.login_id ,
1503: -- JKJain, NR Analysis and Forecasting
1504: X_FLEET_HEADER_ID => p_temp_mr_rec.fleet_header_id);
1505:
1506: -- added for SB Enh

Line 1709: X_LAST_UPDATED_BY => fnd_global.user_id,

1705: X_ATTRIBUTE14 => null, /* ATTRIBUTE14 */
1706: X_ATTRIBUTE15 => null, /* ATTRIBUTE15 */
1707: X_OBJECT_VERSION_NUMBER => 1,
1708: X_LAST_UPDATE_DATE => sysdate,
1709: X_LAST_UPDATED_BY => fnd_global.user_id,
1710: X_CREATION_DATE => sysdate,
1711: X_CREATED_BY => fnd_global.user_id,
1712: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
1713:

Line 1711: X_CREATED_BY => fnd_global.user_id,

1707: X_OBJECT_VERSION_NUMBER => 1,
1708: X_LAST_UPDATE_DATE => sysdate,
1709: X_LAST_UPDATED_BY => fnd_global.user_id,
1710: X_CREATION_DATE => sysdate,
1711: X_CREATED_BY => fnd_global.user_id,
1712: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
1713:
1714: END LOOP;
1715:

Line 1712: X_LAST_UPDATE_LOGIN => fnd_global.login_id);

1708: X_LAST_UPDATE_DATE => sysdate,
1709: X_LAST_UPDATED_BY => fnd_global.user_id,
1710: X_CREATION_DATE => sysdate,
1711: X_CREATED_BY => fnd_global.user_id,
1712: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
1713:
1714: END LOOP;
1715:
1716: IF G_DEBUG = 'Y' THEN

Line 1917: LAST_UPDATED_BY = fnd_global.user_id,

1913: latest_due_date = p_temp_mr_rec.latest_due_date,
1914: counter_id = p_temp_mr_rec.counter_id,
1915: object_version_number = object_version_number+1,
1916: LAST_UPDATE_DATE = sysdate,
1917: LAST_UPDATED_BY = fnd_global.user_id,
1918: LAST_UPDATE_LOGIN = fnd_global.login_id,
1919: -- JKJain, NR Analysis and Forecasting
1920: FLEET_HEADER_ID = p_temp_mr_rec.fleet_header_id
1921: WHERE unit_effectivity_id IN (SELECT related_ue_id

Line 1918: LAST_UPDATE_LOGIN = fnd_global.login_id,

1914: counter_id = p_temp_mr_rec.counter_id,
1915: object_version_number = object_version_number+1,
1916: LAST_UPDATE_DATE = sysdate,
1917: LAST_UPDATED_BY = fnd_global.user_id,
1918: LAST_UPDATE_LOGIN = fnd_global.login_id,
1919: -- JKJain, NR Analysis and Forecasting
1920: FLEET_HEADER_ID = p_temp_mr_rec.fleet_header_id
1921: WHERE unit_effectivity_id IN (SELECT related_ue_id
1922: FROM ahl_ue_relationships

Line 2107: LAST_UPDATED_BY = fnd_global.user_id,

2103: UPDATE ahl_unit_deferrals_b
2104: SET UNIT_EFFECTIVITY_ID = l_temp_mr_rec.unit_effectivity_id,
2105: last_update_date = sysdate,
2106: object_version_number = object_version_number + 1,
2107: LAST_UPDATED_BY = fnd_global.user_id,
2108: LAST_UPDATE_LOGIN = fnd_global.login_id
2109: WHERE unit_deferral_id = l_unit_deferral_id;
2110: END IF;
2111: CLOSE unit_deferral_csr;

Line 2108: LAST_UPDATE_LOGIN = fnd_global.login_id

2104: SET UNIT_EFFECTIVITY_ID = l_temp_mr_rec.unit_effectivity_id,
2105: last_update_date = sysdate,
2106: object_version_number = object_version_number + 1,
2107: LAST_UPDATED_BY = fnd_global.user_id,
2108: LAST_UPDATE_LOGIN = fnd_global.login_id
2109: WHERE unit_deferral_id = l_unit_deferral_id;
2110: END IF;
2111: CLOSE unit_deferral_csr;
2112:

Line 2413: X_LAST_UPDATED_BY => fnd_global.user_id,

2409: X_ATTRIBUTE14 => l_unit_effectivity_rec.ATTRIBUTE14,
2410: X_ATTRIBUTE15 => l_unit_effectivity_rec.ATTRIBUTE15,
2411: X_OBJECT_VERSION_NUMBER => l_unit_effectivity_rec.object_version_number+1,
2412: X_LAST_UPDATE_DATE => sysdate,
2413: X_LAST_UPDATED_BY => fnd_global.user_id,
2414: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
2415: -- JKJain, NR Analysis and Forecasting
2416: X_FLEET_HEADER_ID => l_unit_effectivity_rec.fleet_header_id );
2417: CLOSE ahl_unit_effectivity_csr;

Line 2414: X_LAST_UPDATE_LOGIN => fnd_global.login_id,

2410: X_ATTRIBUTE15 => l_unit_effectivity_rec.ATTRIBUTE15,
2411: X_OBJECT_VERSION_NUMBER => l_unit_effectivity_rec.object_version_number+1,
2412: X_LAST_UPDATE_DATE => sysdate,
2413: X_LAST_UPDATED_BY => fnd_global.user_id,
2414: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
2415: -- JKJain, NR Analysis and Forecasting
2416: X_FLEET_HEADER_ID => l_unit_effectivity_rec.fleet_header_id );
2417: CLOSE ahl_unit_effectivity_csr;
2418:

Line 2506: X_LAST_UPDATED_BY => fnd_global.user_id,

2502: X_ATTRIBUTE14 => l_unit_effectivity_rec.ATTRIBUTE14,
2503: X_ATTRIBUTE15 => l_unit_effectivity_rec.ATTRIBUTE15,
2504: X_OBJECT_VERSION_NUMBER => l_unit_effectivity_rec.object_version_number+1,
2505: X_LAST_UPDATE_DATE => sysdate,
2506: X_LAST_UPDATED_BY => fnd_global.user_id,
2507: X_LAST_UPDATE_LOGIN => fnd_global.login_id );
2508:
2509:
2510: -- Delete the corresponding rows in ahl_schedule materials for this ue.

Line 2507: X_LAST_UPDATE_LOGIN => fnd_global.login_id );

2503: X_ATTRIBUTE15 => l_unit_effectivity_rec.ATTRIBUTE15,
2504: X_OBJECT_VERSION_NUMBER => l_unit_effectivity_rec.object_version_number+1,
2505: X_LAST_UPDATE_DATE => sysdate,
2506: X_LAST_UPDATED_BY => fnd_global.user_id,
2507: X_LAST_UPDATE_LOGIN => fnd_global.login_id );
2508:
2509:
2510: -- Delete the corresponding rows in ahl_schedule materials for this ue.
2511: IF (l_unit_effectivity_rec.due_date IS NULL

Line 2605: X_CREATED_BY => fnd_global.user_id,

2601: X_ATTRIBUTE14 => null, /* ATTRIBUTE14 */
2602: X_ATTRIBUTE15 => null, /* ATTRIBUTE15 */
2603: X_OBJECT_VERSION_NUMBER => 1, /* object version */
2604: X_CREATION_DATE => sysdate,
2605: X_CREATED_BY => fnd_global.user_id,
2606: X_LAST_UPDATE_DATE => sysdate,
2607: X_LAST_UPDATED_BY => fnd_global.user_id,
2608: X_LAST_UPDATE_LOGIN => fnd_global.login_id );
2609:

Line 2607: X_LAST_UPDATED_BY => fnd_global.user_id,

2603: X_OBJECT_VERSION_NUMBER => 1, /* object version */
2604: X_CREATION_DATE => sysdate,
2605: X_CREATED_BY => fnd_global.user_id,
2606: X_LAST_UPDATE_DATE => sysdate,
2607: X_LAST_UPDATED_BY => fnd_global.user_id,
2608: X_LAST_UPDATE_LOGIN => fnd_global.login_id );
2609:
2610: l_new_top_ue_id := l_unit_effectivity_id;
2611:

Line 2608: X_LAST_UPDATE_LOGIN => fnd_global.login_id );

2604: X_CREATION_DATE => sysdate,
2605: X_CREATED_BY => fnd_global.user_id,
2606: X_LAST_UPDATE_DATE => sysdate,
2607: X_LAST_UPDATED_BY => fnd_global.user_id,
2608: X_LAST_UPDATE_LOGIN => fnd_global.login_id );
2609:
2610: l_new_top_ue_id := l_unit_effectivity_id;
2611:
2612: -- update new UE ID for top node.

Line 2625: LAST_UPDATED_BY = fnd_global.user_id,

2621: UPDATE AHL_UNIT_DEFERRALS_B
2622: SET unit_effectivity_id = l_new_top_ue_id,
2623: last_update_date = sysdate,
2624: object_version_number = object_version_number + 1,
2625: LAST_UPDATED_BY = fnd_global.user_id,
2626: LAST_UPDATE_LOGIN = fnd_global.login_id
2627: WHERE unit_effectivity_id = unit_sr_def_rec.unit_effectivity_id;
2628:
2629: -- added for SB Enh - only for top node.

Line 2626: LAST_UPDATE_LOGIN = fnd_global.login_id

2622: SET unit_effectivity_id = l_new_top_ue_id,
2623: last_update_date = sysdate,
2624: object_version_number = object_version_number + 1,
2625: LAST_UPDATED_BY = fnd_global.user_id,
2626: LAST_UPDATE_LOGIN = fnd_global.login_id
2627: WHERE unit_effectivity_id = unit_sr_def_rec.unit_effectivity_id;
2628:
2629: -- added for SB Enh - only for top node.
2630: IF (unit_sr_def_rec.object_type = 'MR') THEN

Line 2703: X_CREATED_BY => fnd_global.user_id,

2699: X_ATTRIBUTE14 => null, /* ATTRIBUTE14 */
2700: X_ATTRIBUTE15 => null, /* ATTRIBUTE15 */
2701: X_OBJECT_VERSION_NUMBER => 1, /* object version */
2702: X_CREATION_DATE => sysdate,
2703: X_CREATED_BY => fnd_global.user_id,
2704: X_LAST_UPDATE_DATE => sysdate,
2705: X_LAST_UPDATED_BY => fnd_global.user_id,
2706: X_LAST_UPDATE_LOGIN => fnd_global.login_id );
2707:

Line 2705: X_LAST_UPDATED_BY => fnd_global.user_id,

2701: X_OBJECT_VERSION_NUMBER => 1, /* object version */
2702: X_CREATION_DATE => sysdate,
2703: X_CREATED_BY => fnd_global.user_id,
2704: X_LAST_UPDATE_DATE => sysdate,
2705: X_LAST_UPDATED_BY => fnd_global.user_id,
2706: X_LAST_UPDATE_LOGIN => fnd_global.login_id );
2707:
2708: UPDATE ahl_temp_unit_SR_deferrals
2709: SET unit_effectivity_id = l_unit_effectivity_id,

Line 2706: X_LAST_UPDATE_LOGIN => fnd_global.login_id );

2702: X_CREATION_DATE => sysdate,
2703: X_CREATED_BY => fnd_global.user_id,
2704: X_LAST_UPDATE_DATE => sysdate,
2705: X_LAST_UPDATED_BY => fnd_global.user_id,
2706: X_LAST_UPDATE_LOGIN => fnd_global.login_id );
2707:
2708: UPDATE ahl_temp_unit_SR_deferrals
2709: SET unit_effectivity_id = l_unit_effectivity_id,
2710: object_type = l_unit_effectivity_rec.object_type

Line 2766: X_LAST_UPDATED_BY => fnd_global.user_id,

2762: X_ATTRIBUTE14 => null, /* ATTRIBUTE14 */
2763: X_ATTRIBUTE15 => null, /* ATTRIBUTE15 */
2764: X_OBJECT_VERSION_NUMBER => 1,
2765: X_LAST_UPDATE_DATE => sysdate,
2766: X_LAST_UPDATED_BY => fnd_global.user_id,
2767: X_CREATION_DATE => sysdate,
2768: X_CREATED_BY => fnd_global.user_id,
2769: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
2770:

Line 2768: X_CREATED_BY => fnd_global.user_id,

2764: X_OBJECT_VERSION_NUMBER => 1,
2765: X_LAST_UPDATE_DATE => sysdate,
2766: X_LAST_UPDATED_BY => fnd_global.user_id,
2767: X_CREATION_DATE => sysdate,
2768: X_CREATED_BY => fnd_global.user_id,
2769: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
2770:
2771: END LOOP;
2772:

Line 2769: X_LAST_UPDATE_LOGIN => fnd_global.login_id);

2765: X_LAST_UPDATE_DATE => sysdate,
2766: X_LAST_UPDATED_BY => fnd_global.user_id,
2767: X_CREATION_DATE => sysdate,
2768: X_CREATED_BY => fnd_global.user_id,
2769: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
2770:
2771: END LOOP;
2772:
2773: -- If object_type = 'SR', check for any terminated MR's for immediate children of the SR-UE.

Line 2845: X_CREATED_BY => fnd_global.user_id,

2841: X_ATTRIBUTE14 => null, /* ATTRIBUTE14 */
2842: X_ATTRIBUTE15 => null, /* ATTRIBUTE15 */
2843: X_OBJECT_VERSION_NUMBER => 1, /* object version */
2844: X_CREATION_DATE => sysdate,
2845: X_CREATED_BY => fnd_global.user_id,
2846: X_LAST_UPDATE_DATE => sysdate,
2847: X_LAST_UPDATED_BY => fnd_global.user_id,
2848: X_LAST_UPDATE_LOGIN => fnd_global.login_id );
2849:

Line 2847: X_LAST_UPDATED_BY => fnd_global.user_id,

2843: X_OBJECT_VERSION_NUMBER => 1, /* object version */
2844: X_CREATION_DATE => sysdate,
2845: X_CREATED_BY => fnd_global.user_id,
2846: X_LAST_UPDATE_DATE => sysdate,
2847: X_LAST_UPDATED_BY => fnd_global.user_id,
2848: X_LAST_UPDATE_LOGIN => fnd_global.login_id );
2849:
2850: CLOSE ahl_unit_effectivity_csr;
2851:

Line 2848: X_LAST_UPDATE_LOGIN => fnd_global.login_id );

2844: X_CREATION_DATE => sysdate,
2845: X_CREATED_BY => fnd_global.user_id,
2846: X_LAST_UPDATE_DATE => sysdate,
2847: X_LAST_UPDATED_BY => fnd_global.user_id,
2848: X_LAST_UPDATE_LOGIN => fnd_global.login_id );
2849:
2850: CLOSE ahl_unit_effectivity_csr;
2851:
2852: -- Now create the relationship record.

Line 2877: X_LAST_UPDATED_BY => fnd_global.user_id,

2873: X_ATTRIBUTE14 => null, /* ATTRIBUTE14 */
2874: X_ATTRIBUTE15 => null, /* ATTRIBUTE15 */
2875: X_OBJECT_VERSION_NUMBER => 1,
2876: X_LAST_UPDATE_DATE => sysdate,
2877: X_LAST_UPDATED_BY => fnd_global.user_id,
2878: X_CREATION_DATE => sysdate,
2879: X_CREATED_BY => fnd_global.user_id,
2880: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
2881:

Line 2879: X_CREATED_BY => fnd_global.user_id,

2875: X_OBJECT_VERSION_NUMBER => 1,
2876: X_LAST_UPDATE_DATE => sysdate,
2877: X_LAST_UPDATED_BY => fnd_global.user_id,
2878: X_CREATION_DATE => sysdate,
2879: X_CREATED_BY => fnd_global.user_id,
2880: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
2881:
2882: END IF;
2883: END LOOP;

Line 2880: X_LAST_UPDATE_LOGIN => fnd_global.login_id);

2876: X_LAST_UPDATE_DATE => sysdate,
2877: X_LAST_UPDATED_BY => fnd_global.user_id,
2878: X_CREATION_DATE => sysdate,
2879: X_CREATED_BY => fnd_global.user_id,
2880: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
2881:
2882: END IF;
2883: END LOOP;
2884: END IF;

Line 2913: LAST_UPDATED_BY = fnd_global.user_id,

2909: message_code = 'VISIT-ASSIGN',
2910: object_version_number = object_version_number + 1,
2911: DATE_RUN = sysdate,
2912: LAST_UPDATE_DATE = sysdate,
2913: LAST_UPDATED_BY = fnd_global.user_id,
2914: LAST_UPDATE_LOGIN = fnd_global.login_id
2915: WHERE unit_effectivity_id IN (SELECT related_ue_id
2916: FROM ahl_ue_relationships
2917: WHERE originator_ue_id = l_delete_ue_id_tbl(i)

Line 2914: LAST_UPDATE_LOGIN = fnd_global.login_id

2910: object_version_number = object_version_number + 1,
2911: DATE_RUN = sysdate,
2912: LAST_UPDATE_DATE = sysdate,
2913: LAST_UPDATED_BY = fnd_global.user_id,
2914: LAST_UPDATE_LOGIN = fnd_global.login_id
2915: WHERE unit_effectivity_id IN (SELECT related_ue_id
2916: FROM ahl_ue_relationships
2917: WHERE originator_ue_id = l_delete_ue_id_tbl(i)
2918: AND relationship_code = 'PARENT');

Line 2927: LAST_UPDATED_BY = fnd_global.user_id,

2923: message_code = 'VISIT-ASSIGN',
2924: object_version_number = object_version_number + 1,
2925: DATE_RUN = sysdate,
2926: LAST_UPDATE_DATE = sysdate,
2927: LAST_UPDATED_BY = fnd_global.user_id,
2928: LAST_UPDATE_LOGIN = fnd_global.login_id
2929: WHERE unit_effectivity_id = l_delete_ue_id_tbl(i);
2930:
2931: ELSIF (l_visit_status IS NULL) THEN

Line 2928: LAST_UPDATE_LOGIN = fnd_global.login_id

2924: object_version_number = object_version_number + 1,
2925: DATE_RUN = sysdate,
2926: LAST_UPDATE_DATE = sysdate,
2927: LAST_UPDATED_BY = fnd_global.user_id,
2928: LAST_UPDATE_LOGIN = fnd_global.login_id
2929: WHERE unit_effectivity_id = l_delete_ue_id_tbl(i);
2930:
2931: ELSIF (l_visit_status IS NULL) THEN
2932: -- delete ahl_ue_relationships

Line 3312: last_updated_by = fnd_global.user_id,

3308: loop_chain_seq_num = l_upd_UE_tbl_records(i).loop_chain_seq_num,
3309: start_lc_ue_id = l_upd_UE_tbl_records(i).start_lc_ue_id,
3310: date_run = sysdate,
3311: last_update_date = sysdate,
3312: last_updated_by = fnd_global.user_id,
3313: last_update_login = fnd_global.login_id,
3314: object_version_number = OBJECT_VERSION_NUMBER + 1
3315: WHERE
3316: unit_effectivity_id = l_upd_UE_tbl_records(i).UNIT_EFFECTIVITY_ID;

Line 3313: last_update_login = fnd_global.login_id,

3309: start_lc_ue_id = l_upd_UE_tbl_records(i).start_lc_ue_id,
3310: date_run = sysdate,
3311: last_update_date = sysdate,
3312: last_updated_by = fnd_global.user_id,
3313: last_update_login = fnd_global.login_id,
3314: object_version_number = OBJECT_VERSION_NUMBER + 1
3315: WHERE
3316: unit_effectivity_id = l_upd_UE_tbl_records(i).UNIT_EFFECTIVITY_ID;
3317:

Line 3713: last_updated_by = fnd_global.user_id,

3709: loop_chain_seq_num = l_upd_UE_tbl_records(i).loop_chain_seq_num,
3710: start_lc_ue_id = l_upd_UE_tbl_records(i).start_lc_ue_id,
3711: date_run = sysdate,
3712: last_update_date = sysdate,
3713: last_updated_by = fnd_global.user_id,
3714: last_update_login = fnd_global.login_id,
3715: object_version_number = OBJECT_VERSION_NUMBER + 1
3716: WHERE
3717: unit_effectivity_id = l_upd_UE_tbl_records(i).UNIT_EFFECTIVITY_ID;

Line 3714: last_update_login = fnd_global.login_id,

3710: start_lc_ue_id = l_upd_UE_tbl_records(i).start_lc_ue_id,
3711: date_run = sysdate,
3712: last_update_date = sysdate,
3713: last_updated_by = fnd_global.user_id,
3714: last_update_login = fnd_global.login_id,
3715: object_version_number = OBJECT_VERSION_NUMBER + 1
3716: WHERE
3717: unit_effectivity_id = l_upd_UE_tbl_records(i).UNIT_EFFECTIVITY_ID;
3718:

Line 3894: l_user_id NUMBER := to_number(fnd_global.USER_ID);

3890: WHERE ORIGINATOR_UE_ID = c_unit_effectivity_id
3891: AND relationship_code = 'PARENT';
3892:
3893:
3894: l_user_id NUMBER := to_number(fnd_global.USER_ID);
3895: l_temp_sim_ue_rec ahl_ue_simulations%ROWTYPE;
3896: l_temp_individual_mr_rec temp_individual_mrs_csr%ROWTYPE;
3897: l_simulation_ue_id NUMBER;
3898: l_originator_ue_id NUMBER;

Line 3979: l_temp_sim_ue_rec.last_update_login := fnd_global.login_id;

3975: l_temp_sim_ue_rec.creation_date := sysdate;
3976: l_temp_sim_ue_rec.last_update_date := sysdate;
3977: l_temp_sim_ue_rec.last_updated_by := l_user_id;
3978: l_temp_sim_ue_rec.created_by := l_user_id;
3979: l_temp_sim_ue_rec.last_update_login := fnd_global.login_id;
3980: l_temp_sim_ue_rec.security_group_id := NULL;
3981: l_temp_sim_ue_rec.originator_ue_id := null;
3982: l_temp_sim_ue_rec.parent_ue_id := null;
3983:

Line 4456: l_temp_sim_ue_rec.last_updated_by := fnd_global.user_id;

4452: l_temp_sim_ue_rec.cs_incident_id := l_temp_ue_rec.cs_incident_id;
4453: l_temp_sim_ue_rec.object_version_number := 1;
4454: l_temp_sim_ue_rec.creation_date := sysdate;
4455: l_temp_sim_ue_rec.last_update_date := sysdate;
4456: l_temp_sim_ue_rec.last_updated_by := fnd_global.user_id;
4457: l_temp_sim_ue_rec.created_by := fnd_global.user_id;
4458: l_temp_sim_ue_rec.last_update_login := fnd_global.login_id;
4459: l_temp_sim_ue_rec.security_group_id := NULL;
4460: l_temp_sim_ue_rec.originator_ue_id := p_originator_ue_id;

Line 4457: l_temp_sim_ue_rec.created_by := fnd_global.user_id;

4453: l_temp_sim_ue_rec.object_version_number := 1;
4454: l_temp_sim_ue_rec.creation_date := sysdate;
4455: l_temp_sim_ue_rec.last_update_date := sysdate;
4456: l_temp_sim_ue_rec.last_updated_by := fnd_global.user_id;
4457: l_temp_sim_ue_rec.created_by := fnd_global.user_id;
4458: l_temp_sim_ue_rec.last_update_login := fnd_global.login_id;
4459: l_temp_sim_ue_rec.security_group_id := NULL;
4460: l_temp_sim_ue_rec.originator_ue_id := p_originator_ue_id;
4461: l_temp_sim_ue_rec.parent_ue_id := p_parent_ue_id;

Line 4458: l_temp_sim_ue_rec.last_update_login := fnd_global.login_id;

4454: l_temp_sim_ue_rec.creation_date := sysdate;
4455: l_temp_sim_ue_rec.last_update_date := sysdate;
4456: l_temp_sim_ue_rec.last_updated_by := fnd_global.user_id;
4457: l_temp_sim_ue_rec.created_by := fnd_global.user_id;
4458: l_temp_sim_ue_rec.last_update_login := fnd_global.login_id;
4459: l_temp_sim_ue_rec.security_group_id := NULL;
4460: l_temp_sim_ue_rec.originator_ue_id := p_originator_ue_id;
4461: l_temp_sim_ue_rec.parent_ue_id := p_parent_ue_id;
4462: