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.

[Home] [Help]

APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on FND_GLOBAL

Line 1089: l_conc_request_id := fnd_global.conc_request_id;

1085: END IF;
1086:
1087: IF (p_concurrent_flag = 'Y') THEN
1088: l_commit := FND_API.G_TRUE;
1089: l_conc_request_id := fnd_global.conc_request_id;
1090: IF (l_conc_request_id = -1) OR (l_conc_request_id IS NULL) OR (l_conc_request_id <= 0) THEN
1091: -- this will happen only when called from UMP Terminate_MR_Instances api.
1092: l_conc_request_id := fnd_global.login_id;
1093: END IF;

Line 1092: l_conc_request_id := fnd_global.login_id;

1088: l_commit := FND_API.G_TRUE;
1089: l_conc_request_id := fnd_global.conc_request_id;
1090: IF (l_conc_request_id = -1) OR (l_conc_request_id IS NULL) OR (l_conc_request_id <= 0) THEN
1091: -- this will happen only when called from UMP Terminate_MR_Instances api.
1092: l_conc_request_id := fnd_global.login_id;
1093: END IF;
1094: ELSE
1095: l_conc_request_id := fnd_global.session_id;
1096: END IF;

Line 1095: l_conc_request_id := fnd_global.session_id;

1091: -- this will happen only when called from UMP Terminate_MR_Instances api.
1092: l_conc_request_id := fnd_global.login_id;
1093: END IF;
1094: ELSE
1095: l_conc_request_id := fnd_global.session_id;
1096: END IF;
1097:
1098: -- validate p_num_of_workers.
1099: l_num_of_workers := trunc(p_num_of_workers);

Line 11278: X_LAST_UPDATED_BY => fnd_global.user_id,

11274: X_ATTRIBUTE14 => l_ue_rec.attribute14,
11275: X_ATTRIBUTE15 => l_ue_rec.attribute15,
11276: X_OBJECT_VERSION_NUMBER => l_ue_rec.object_version_number + 1,
11277: X_LAST_UPDATE_DATE => sysdate,
11278: X_LAST_UPDATED_BY => fnd_global.user_id,
11279: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
11280:
11281: -- Now update all the child MRs status too.
11282: FOR ue_reln_rec IN decendent_csr(ahl_unplanned_ue_rec.unit_effectivity_id) LOOP

Line 11279: X_LAST_UPDATE_LOGIN => fnd_global.login_id);

11275: X_ATTRIBUTE15 => l_ue_rec.attribute15,
11276: X_OBJECT_VERSION_NUMBER => l_ue_rec.object_version_number + 1,
11277: X_LAST_UPDATE_DATE => sysdate,
11278: X_LAST_UPDATED_BY => fnd_global.user_id,
11279: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
11280:
11281: -- Now update all the child MRs status too.
11282: FOR ue_reln_rec IN decendent_csr(ahl_unplanned_ue_rec.unit_effectivity_id) LOOP
11283:

Line 11343: X_LAST_UPDATED_BY => fnd_global.user_id,

11339: X_ATTRIBUTE14 => l_ue_rec.attribute14,
11340: X_ATTRIBUTE15 => l_ue_rec.attribute15,
11341: X_OBJECT_VERSION_NUMBER => l_ue_rec.object_version_number + 1,
11342: X_LAST_UPDATE_DATE => sysdate,
11343: X_LAST_UPDATED_BY => fnd_global.user_id,
11344: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
11345: ELSE
11346: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UE_NOTFOUND');
11347: FND_MESSAGE.Set_Token('UE_ID',l_ue_rec.unit_effectivity_id);

Line 11344: X_LAST_UPDATE_LOGIN => fnd_global.login_id);

11340: X_ATTRIBUTE15 => l_ue_rec.attribute15,
11341: X_OBJECT_VERSION_NUMBER => l_ue_rec.object_version_number + 1,
11342: X_LAST_UPDATE_DATE => sysdate,
11343: X_LAST_UPDATED_BY => fnd_global.user_id,
11344: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
11345: ELSE
11346: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UE_NOTFOUND');
11347: FND_MESSAGE.Set_Token('UE_ID',l_ue_rec.unit_effectivity_id);
11348: FND_MSG_PUB.ADD;

Line 12441: l_conc_req_id := fnd_global.conc_request_id;

12437: -- initialize return status.
12438: x_return_status := FND_API.G_RET_STS_SUCCESS;
12439:
12440: IF (p_concurrent_flag = 'Y') THEN
12441: l_conc_req_id := fnd_global.conc_request_id;
12442: ELSE
12443: l_conc_req_id := fnd_global.session_id;
12444: END IF;
12445:

Line 12443: l_conc_req_id := fnd_global.session_id;

12439:
12440: IF (p_concurrent_flag = 'Y') THEN
12441: l_conc_req_id := fnd_global.conc_request_id;
12442: ELSE
12443: l_conc_req_id := fnd_global.session_id;
12444: END IF;
12445:
12446: -- validate p_num_of_workers.
12447: l_num_of_workers := trunc(p_num_of_workers);

Line 12594: l_conc_child_req_id := fnd_global.conc_request_id;

12590:
12591: -- initialize return status.
12592: retcode := 0;
12593:
12594: l_conc_child_req_id := fnd_global.conc_request_id;
12595:
12596: -- JKJain, NR Analysis and Forecasting
12597: --Fetch simulation_plan_id for the first record.
12598: OPEN get_sim_plan_id(p_parent_conc_pgm_id);

Line 13107: fnd_global.user_id,

13103: (p_conc_request_id,
13104: l_instance_id_tbl(instance_indx),
13105: null,
13106: sysdate,
13107: fnd_global.user_id,
13108: sysdate,
13109: fnd_global.user_id,
13110: fnd_global.conc_login_id,
13111: 1,

Line 13109: fnd_global.user_id,

13105: null,
13106: sysdate,
13107: fnd_global.user_id,
13108: sysdate,
13109: fnd_global.user_id,
13110: fnd_global.conc_login_id,
13111: 1,
13112: G_SIMULATION_PLAN_ID);
13113:

Line 13110: fnd_global.conc_login_id,

13106: sysdate,
13107: fnd_global.user_id,
13108: sysdate,
13109: fnd_global.user_id,
13110: fnd_global.conc_login_id,
13111: 1,
13112: G_SIMULATION_PLAN_ID);
13113:
13114: l_instance_id_tbl.DELETE;

Line 13165: fnd_global.user_id,

13161: (p_conc_request_id,
13162: l_instance_id_tbl(instance_indx),
13163: null,
13164: sysdate,
13165: fnd_global.user_id,
13166: sysdate,
13167: fnd_global.user_id,
13168: fnd_global.conc_login_id,
13169: 1,

Line 13167: fnd_global.user_id,

13163: null,
13164: sysdate,
13165: fnd_global.user_id,
13166: sysdate,
13167: fnd_global.user_id,
13168: fnd_global.conc_login_id,
13169: 1,
13170: -- JKJain, NR Analysis and Forecasting
13171: G_SIMULATION_PLAN_ID);

Line 13168: fnd_global.conc_login_id,

13164: sysdate,
13165: fnd_global.user_id,
13166: sysdate,
13167: fnd_global.user_id,
13168: fnd_global.conc_login_id,
13169: 1,
13170: -- JKJain, NR Analysis and Forecasting
13171: G_SIMULATION_PLAN_ID);
13172:

Line 13237: fnd_global.user_id,

13233: (p_conc_request_id,
13234: l_instance_id_tbl(instance_indx),
13235: null,
13236: sysdate,
13237: fnd_global.user_id,
13238: sysdate,
13239: fnd_global.user_id,
13240: fnd_global.conc_login_id,
13241: 1);

Line 13239: fnd_global.user_id,

13235: null,
13236: sysdate,
13237: fnd_global.user_id,
13238: sysdate,
13239: fnd_global.user_id,
13240: fnd_global.conc_login_id,
13241: 1);
13242:
13243: EXCEPTION

Line 13240: fnd_global.conc_login_id,

13236: sysdate,
13237: fnd_global.user_id,
13238: sysdate,
13239: fnd_global.user_id,
13240: fnd_global.conc_login_id,
13241: 1);
13242:
13243: EXCEPTION
13244: WHEN DML_ERRORS THEN

Line 13388: last_update_login = fnd_global.login_id,

13384: UPDATE ahl_bue_worker_data
13385: set child_conc_request_id = p_conc_child_req_id,
13386: last_update_date = sysdate,
13387: object_version_number = object_version_number + 1,
13388: last_update_login = fnd_global.login_id,
13389: last_updated_by = fnd_global.user_id
13390: WHERE ROWID = l_rowid
13391: AND object_version_number = l_object_version_number;
13392: --WHERE CURRENT OF ahl_bue_worker_csr;

Line 13389: last_updated_by = fnd_global.user_id

13385: set child_conc_request_id = p_conc_child_req_id,
13386: last_update_date = sysdate,
13387: object_version_number = object_version_number + 1,
13388: last_update_login = fnd_global.login_id,
13389: last_updated_by = fnd_global.user_id
13390: WHERE ROWID = l_rowid
13391: AND object_version_number = l_object_version_number;
13392: --WHERE CURRENT OF ahl_bue_worker_csr;
13393:

Line 13922: fnd_global.user_id,

13918: (p_conc_request_id,
13919: l_instance_id_tbl(instance_indx),
13920: null,
13921: sysdate,
13922: fnd_global.user_id,
13923: sysdate,
13924: fnd_global.user_id,
13925: fnd_global.conc_login_id,
13926: 1);

Line 13924: fnd_global.user_id,

13920: null,
13921: sysdate,
13922: fnd_global.user_id,
13923: sysdate,
13924: fnd_global.user_id,
13925: fnd_global.conc_login_id,
13926: 1);
13927:
13928: EXCEPTION

Line 13925: fnd_global.conc_login_id,

13921: sysdate,
13922: fnd_global.user_id,
13923: sysdate,
13924: fnd_global.user_id,
13925: fnd_global.conc_login_id,
13926: 1);
13927:
13928: EXCEPTION
13929: WHEN DML_ERRORS THEN

Line 13988: fnd_global.user_id,

13984: (p_conc_request_id,
13985: l_instance_id_tbl(instance_indx),
13986: null,
13987: sysdate,
13988: fnd_global.user_id,
13989: sysdate,
13990: fnd_global.user_id,
13991: fnd_global.conc_login_id,
13992: 1);

Line 13990: fnd_global.user_id,

13986: null,
13987: sysdate,
13988: fnd_global.user_id,
13989: sysdate,
13990: fnd_global.user_id,
13991: fnd_global.conc_login_id,
13992: 1);
13993:
13994: EXCEPTION

Line 13991: fnd_global.conc_login_id,

13987: sysdate,
13988: fnd_global.user_id,
13989: sysdate,
13990: fnd_global.user_id,
13991: fnd_global.conc_login_id,
13992: 1);
13993:
13994: EXCEPTION
13995: WHEN DML_ERRORS THEN

Line 14648: l_user_id := to_number(fnd_global.USER_ID);

14644:
14645: -- Calculate counter_remain and call get_date_from_uf.
14646: IF (p_x_warranty_counter_tbl.COUNT > 0) THEN
14647:
14648: l_user_id := to_number(fnd_global.USER_ID);
14649: l_login_id := to_number(fnd_global.LOGIN_ID);
14650: l_calc_due_date := null ;
14651: l_due_date := null;
14652:

Line 14649: l_login_id := to_number(fnd_global.LOGIN_ID);

14645: -- Calculate counter_remain and call get_date_from_uf.
14646: IF (p_x_warranty_counter_tbl.COUNT > 0) THEN
14647:
14648: l_user_id := to_number(fnd_global.USER_ID);
14649: l_login_id := to_number(fnd_global.LOGIN_ID);
14650: l_calc_due_date := null ;
14651: l_due_date := null;
14652:
14653: FOR i IN p_x_warranty_counter_tbl.FIRST..p_x_warranty_counter_tbl.LAST LOOP

Line 16178: last_updated_by = fnd_global.user_id,

16174: SET due_date = l_due_date,
16175: due_counter_value = l_due_counter_value,
16176: counter_id = l_counter_id,
16177: last_update_date = sysdate,
16178: last_updated_by = fnd_global.user_id,
16179: object_version_number = object_version_number + 1
16180: WHERE unit_effectivity_id = p_unit_effectivity_id;
16181:
16182: -- update child UEs.

Line 16188: last_updated_by = fnd_global.user_id,

16184: SET due_date = l_due_date,
16185: due_counter_value = l_due_counter_value,
16186: counter_id = l_counter_id,
16187: last_update_date = sysdate,
16188: last_updated_by = fnd_global.user_id,
16189: object_version_number = object_version_number + 1
16190: WHERE unit_effectivity_id IN (select related_ue_id
16191: from ahl_ue_relationships
16192: where originator_ue_id = p_unit_effectivity_id);