DBA Data[Home] [Help]

APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on FND_GLOBAL

Line 917: l_conc_request_id := fnd_global.conc_request_id;

913: END IF;
914:
915: IF (p_concurrent_flag = 'Y') THEN
916: l_commit := FND_API.G_TRUE;
917: l_conc_request_id := fnd_global.conc_request_id;
918: IF (l_conc_request_id = -1) OR (l_conc_request_id IS NULL) OR (l_conc_request_id <= 0) THEN
919: -- this will happen only when called from UMP Terminate_MR_Instances api.
920: l_conc_request_id := fnd_global.login_id;
921: END IF;

Line 920: l_conc_request_id := fnd_global.login_id;

916: l_commit := FND_API.G_TRUE;
917: l_conc_request_id := fnd_global.conc_request_id;
918: IF (l_conc_request_id = -1) OR (l_conc_request_id IS NULL) OR (l_conc_request_id <= 0) THEN
919: -- this will happen only when called from UMP Terminate_MR_Instances api.
920: l_conc_request_id := fnd_global.login_id;
921: END IF;
922: ELSE
923: l_conc_request_id := fnd_global.session_id;
924: END IF;

Line 923: l_conc_request_id := fnd_global.session_id;

919: -- this will happen only when called from UMP Terminate_MR_Instances api.
920: l_conc_request_id := fnd_global.login_id;
921: END IF;
922: ELSE
923: l_conc_request_id := fnd_global.session_id;
924: END IF;
925:
926: -- validate p_num_of_workers.
927: l_num_of_workers := trunc(p_num_of_workers);

Line 9712: X_LAST_UPDATED_BY => fnd_global.user_id,

9708: X_ATTRIBUTE14 => l_ue_rec.attribute14,
9709: X_ATTRIBUTE15 => l_ue_rec.attribute15,
9710: X_OBJECT_VERSION_NUMBER => l_ue_rec.object_version_number + 1,
9711: X_LAST_UPDATE_DATE => sysdate,
9712: X_LAST_UPDATED_BY => fnd_global.user_id,
9713: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
9714:
9715: -- Now update all the child MRs status too.
9716: FOR ue_reln_rec IN decendent_csr(ahl_unplanned_ue_rec.unit_effectivity_id) LOOP

Line 9713: X_LAST_UPDATE_LOGIN => fnd_global.login_id);

9709: X_ATTRIBUTE15 => l_ue_rec.attribute15,
9710: X_OBJECT_VERSION_NUMBER => l_ue_rec.object_version_number + 1,
9711: X_LAST_UPDATE_DATE => sysdate,
9712: X_LAST_UPDATED_BY => fnd_global.user_id,
9713: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
9714:
9715: -- Now update all the child MRs status too.
9716: FOR ue_reln_rec IN decendent_csr(ahl_unplanned_ue_rec.unit_effectivity_id) LOOP
9717:

Line 9777: X_LAST_UPDATED_BY => fnd_global.user_id,

9773: X_ATTRIBUTE14 => l_ue_rec.attribute14,
9774: X_ATTRIBUTE15 => l_ue_rec.attribute15,
9775: X_OBJECT_VERSION_NUMBER => l_ue_rec.object_version_number + 1,
9776: X_LAST_UPDATE_DATE => sysdate,
9777: X_LAST_UPDATED_BY => fnd_global.user_id,
9778: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
9779: ELSE
9780: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UE_NOTFOUND');
9781: FND_MESSAGE.Set_Token('UE_ID',l_ue_rec.unit_effectivity_id);

Line 9778: X_LAST_UPDATE_LOGIN => fnd_global.login_id);

9774: X_ATTRIBUTE15 => l_ue_rec.attribute15,
9775: X_OBJECT_VERSION_NUMBER => l_ue_rec.object_version_number + 1,
9776: X_LAST_UPDATE_DATE => sysdate,
9777: X_LAST_UPDATED_BY => fnd_global.user_id,
9778: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
9779: ELSE
9780: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UE_NOTFOUND');
9781: FND_MESSAGE.Set_Token('UE_ID',l_ue_rec.unit_effectivity_id);
9782: FND_MSG_PUB.ADD;

Line 10828: l_conc_req_id := fnd_global.conc_request_id;

10824: -- initialize return status.
10825: x_return_status := FND_API.G_RET_STS_SUCCESS;
10826:
10827: IF (p_concurrent_flag = 'Y') THEN
10828: l_conc_req_id := fnd_global.conc_request_id;
10829: ELSE
10830: l_conc_req_id := fnd_global.session_id;
10831: END IF;
10832:

Line 10830: l_conc_req_id := fnd_global.session_id;

10826:
10827: IF (p_concurrent_flag = 'Y') THEN
10828: l_conc_req_id := fnd_global.conc_request_id;
10829: ELSE
10830: l_conc_req_id := fnd_global.session_id;
10831: END IF;
10832:
10833: -- validate p_num_of_workers.
10834: l_num_of_workers := trunc(p_num_of_workers);

Line 10952: l_conc_child_req_id := fnd_global.conc_request_id;

10948:
10949: -- initialize return status.
10950: retcode := 0;
10951:
10952: l_conc_child_req_id := fnd_global.conc_request_id;
10953:
10954: IF G_debug = 'Y' THEN
10955: AHL_DEBUG_PUB.debug('Start Process_Unit_Range for concurrent pgm ID:' || l_conc_child_req_id);
10956: AHL_DEBUG_PUB.debug('Parent concurrent pgm ID:' || p_parent_conc_pgm_id);

Line 11381: fnd_global.user_id,

11377: (p_conc_request_id,
11378: l_instance_id_tbl(instance_indx),
11379: null,
11380: sysdate,
11381: fnd_global.user_id,
11382: sysdate,
11383: fnd_global.user_id,
11384: fnd_global.conc_login_id,
11385: 1);

Line 11383: fnd_global.user_id,

11379: null,
11380: sysdate,
11381: fnd_global.user_id,
11382: sysdate,
11383: fnd_global.user_id,
11384: fnd_global.conc_login_id,
11385: 1);
11386:
11387: l_instance_id_tbl.DELETE;

Line 11384: fnd_global.conc_login_id,

11380: sysdate,
11381: fnd_global.user_id,
11382: sysdate,
11383: fnd_global.user_id,
11384: fnd_global.conc_login_id,
11385: 1);
11386:
11387: l_instance_id_tbl.DELETE;
11388:

Line 11433: fnd_global.user_id,

11429: (p_conc_request_id,
11430: l_instance_id_tbl(instance_indx),
11431: null,
11432: sysdate,
11433: fnd_global.user_id,
11434: sysdate,
11435: fnd_global.user_id,
11436: fnd_global.conc_login_id,
11437: 1);

Line 11435: fnd_global.user_id,

11431: null,
11432: sysdate,
11433: fnd_global.user_id,
11434: sysdate,
11435: fnd_global.user_id,
11436: fnd_global.conc_login_id,
11437: 1);
11438:
11439: EXCEPTION

Line 11436: fnd_global.conc_login_id,

11432: sysdate,
11433: fnd_global.user_id,
11434: sysdate,
11435: fnd_global.user_id,
11436: fnd_global.conc_login_id,
11437: 1);
11438:
11439: EXCEPTION
11440: WHEN DML_ERRORS THEN

Line 11555: last_update_login = fnd_global.login_id,

11551: UPDATE ahl_bue_worker_data
11552: set child_conc_request_id = p_conc_child_req_id,
11553: last_update_date = sysdate,
11554: object_version_number = object_version_number + 1,
11555: last_update_login = fnd_global.login_id,
11556: last_updated_by = fnd_global.user_id
11557: WHERE ROWID = l_rowid
11558: AND object_version_number = l_object_version_number;
11559: --WHERE CURRENT OF ahl_bue_worker_csr;

Line 11556: last_updated_by = fnd_global.user_id

11552: set child_conc_request_id = p_conc_child_req_id,
11553: last_update_date = sysdate,
11554: object_version_number = object_version_number + 1,
11555: last_update_login = fnd_global.login_id,
11556: last_updated_by = fnd_global.user_id
11557: WHERE ROWID = l_rowid
11558: AND object_version_number = l_object_version_number;
11559: --WHERE CURRENT OF ahl_bue_worker_csr;
11560:

Line 12058: fnd_global.user_id,

12054: (p_conc_request_id,
12055: l_instance_id_tbl(instance_indx),
12056: null,
12057: sysdate,
12058: fnd_global.user_id,
12059: sysdate,
12060: fnd_global.user_id,
12061: fnd_global.conc_login_id,
12062: 1);

Line 12060: fnd_global.user_id,

12056: null,
12057: sysdate,
12058: fnd_global.user_id,
12059: sysdate,
12060: fnd_global.user_id,
12061: fnd_global.conc_login_id,
12062: 1);
12063:
12064: EXCEPTION

Line 12061: fnd_global.conc_login_id,

12057: sysdate,
12058: fnd_global.user_id,
12059: sysdate,
12060: fnd_global.user_id,
12061: fnd_global.conc_login_id,
12062: 1);
12063:
12064: EXCEPTION
12065: WHEN DML_ERRORS THEN

Line 12124: fnd_global.user_id,

12120: (p_conc_request_id,
12121: l_instance_id_tbl(instance_indx),
12122: null,
12123: sysdate,
12124: fnd_global.user_id,
12125: sysdate,
12126: fnd_global.user_id,
12127: fnd_global.conc_login_id,
12128: 1);

Line 12126: fnd_global.user_id,

12122: null,
12123: sysdate,
12124: fnd_global.user_id,
12125: sysdate,
12126: fnd_global.user_id,
12127: fnd_global.conc_login_id,
12128: 1);
12129:
12130: EXCEPTION

Line 12127: fnd_global.conc_login_id,

12123: sysdate,
12124: fnd_global.user_id,
12125: sysdate,
12126: fnd_global.user_id,
12127: fnd_global.conc_login_id,
12128: 1);
12129:
12130: EXCEPTION
12131: WHEN DML_ERRORS THEN