DBA Data[Home] [Help]

APPS.AHL_FLEET_FORECAST_PVT dependencies on FND_GLOBAL

Line 198: last_updated_by = FND_GLOBAL.user_id,

194: /* UPDATE AHL_MR_EFFECTIVITIES
195: SET fleet_header_id = NULL,
196: object_version_number = object_version_number + 1,
197: last_update_date = SYSDATE,
198: last_updated_by = FND_GLOBAL.user_id,
199: last_update_login = FND_GLOBAL.login_id
200: WHERE fleet_header_id = p_fleet_id;*/
201: -- Delete MR effectivities
202: DELETE

Line 199: last_update_login = FND_GLOBAL.login_id

195: SET fleet_header_id = NULL,
196: object_version_number = object_version_number + 1,
197: last_update_date = SYSDATE,
198: last_updated_by = FND_GLOBAL.user_id,
199: last_update_login = FND_GLOBAL.login_id
200: WHERE fleet_header_id = p_fleet_id;*/
201: -- Delete MR effectivities
202: DELETE
203: FROM AHL_MR_EFFECTIVITIES

Line 280: last_updated_by = FND_GLOBAL.user_id,

276: UPDATE AHL_FLEET_HEADERS_B
277: SET object_version_number = object_version_number + 1,
278: status_code = 'DELETED',
279: last_update_date = SYSDATE,
280: last_updated_by = FND_GLOBAL.user_id,
281: last_update_login = FND_GLOBAL.login_id
282: WHERE fleet_header_id = p_fleet_id
283: AND object_version_number = p_obj_version_no;
284: -- rowcount will be 0 when ovn does not match

Line 281: last_update_login = FND_GLOBAL.login_id

277: SET object_version_number = object_version_number + 1,
278: status_code = 'DELETED',
279: last_update_date = SYSDATE,
280: last_updated_by = FND_GLOBAL.user_id,
281: last_update_login = FND_GLOBAL.login_id
282: WHERE fleet_header_id = p_fleet_id
283: AND object_version_number = p_obj_version_no;
284: -- rowcount will be 0 when ovn does not match
285: IF ( SQL%ROWCOUNT = 0 ) THEN

Line 311: last_updated_by = FND_GLOBAL.user_id,

307: /*UPDATE AHL_MR_EFFECTIVITIES
308: SET fleet_header_id = NULL,
309: object_version_number = object_version_number + 1,
310: last_update_date = SYSDATE,
311: last_updated_by = FND_GLOBAL.user_id,
312: last_update_login = FND_GLOBAL.login_id
313: WHERE fleet_header_id = p_fleet_id;*/
314:
315: -- Unit Downtime

Line 312: last_update_login = FND_GLOBAL.login_id

308: SET fleet_header_id = NULL,
309: object_version_number = object_version_number + 1,
310: last_update_date = SYSDATE,
311: last_updated_by = FND_GLOBAL.user_id,
312: last_update_login = FND_GLOBAL.login_id
313: WHERE fleet_header_id = p_fleet_id;*/
314:
315: -- Unit Downtime
316: DELETE

Line 681: p_user_id => fnd_global.user_id,

677: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
678: x_return_status => l_return_status,
679: x_msg_count => l_msg_count,
680: x_msg_data => l_msg_data,
681: p_user_id => fnd_global.user_id,
682: p_login_id => fnd_global.login_id,
683: p_request_id => l_nr_task_rec.incident_id,
684: p_object_version_number => l_nr_task_rec.incident_object_version_number,
685: p_request_number => null,

Line 682: p_login_id => fnd_global.login_id,

678: x_return_status => l_return_status,
679: x_msg_count => l_msg_count,
680: x_msg_data => l_msg_data,
681: p_user_id => fnd_global.user_id,
682: p_login_id => fnd_global.login_id,
683: p_request_id => l_nr_task_rec.incident_id,
684: p_object_version_number => l_nr_task_rec.incident_object_version_number,
685: p_request_number => null,
686: p_x_sr_mr_association_tbl => l_mr_sr_assoc_tbl

Line 1005: p_user_id => fnd_global.user_id,

1001: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1002: x_return_status => l_return_status,
1003: x_msg_count => l_msg_count,
1004: x_msg_data => l_msg_data,
1005: p_user_id => fnd_global.user_id,
1006: p_login_id => fnd_global.login_id,
1007: p_request_id => l_nr_task_rec.incident_id, --populated by create_sr API
1008: p_object_version_number => l_cur_sr_details.object_version_number,
1009: p_request_number => null,

Line 1006: p_login_id => fnd_global.login_id,

1002: x_return_status => l_return_status,
1003: x_msg_count => l_msg_count,
1004: x_msg_data => l_msg_data,
1005: p_user_id => fnd_global.user_id,
1006: p_login_id => fnd_global.login_id,
1007: p_request_id => l_nr_task_rec.incident_id, --populated by create_sr API
1008: p_object_version_number => l_cur_sr_details.object_version_number,
1009: p_request_number => null,
1010: p_x_sr_mr_association_tbl => l_mr_sr_assoc_tbl

Line 1026: last_updated_by = FND_GLOBAL.user_id,

1022: UPDATE ahl_fleet_unit_assocs
1023: SET reconfig_sr_id = l_nr_task_rec.incident_id,
1024: object_version_number = l_fleet_unit_asso_rec.object_version_number + 1,
1025: last_update_date = SYSDATE,
1026: last_updated_by = FND_GLOBAL.user_id,
1027: last_update_login = FND_GLOBAL.login_id
1028: WHERE fleet_unit_assoc_id = l_fleet_unit_asso_rec.fleet_unit_assoc_id
1029: AND object_version_number = l_fleet_unit_asso_rec.object_version_number;
1030:

Line 1027: last_update_login = FND_GLOBAL.login_id

1023: SET reconfig_sr_id = l_nr_task_rec.incident_id,
1024: object_version_number = l_fleet_unit_asso_rec.object_version_number + 1,
1025: last_update_date = SYSDATE,
1026: last_updated_by = FND_GLOBAL.user_id,
1027: last_update_login = FND_GLOBAL.login_id
1028: WHERE fleet_unit_assoc_id = l_fleet_unit_asso_rec.fleet_unit_assoc_id
1029: AND object_version_number = l_fleet_unit_asso_rec.object_version_number;
1030:
1031: IF (SQL%NOTFOUND)

Line 1273: p_user_id => fnd_global.user_id,

1269: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1270: x_return_status => l_return_status,
1271: x_msg_count => l_msg_count,
1272: x_msg_data => l_msg_data,
1273: p_user_id => fnd_global.user_id,
1274: p_login_id => fnd_global.login_id,
1275: p_request_id => l_nr_task_rec.incident_id,
1276: p_object_version_number => l_nr_task_rec.incident_object_version_number,
1277: p_request_number => null,

Line 1274: p_login_id => fnd_global.login_id,

1270: x_return_status => l_return_status,
1271: x_msg_count => l_msg_count,
1272: x_msg_data => l_msg_data,
1273: p_user_id => fnd_global.user_id,
1274: p_login_id => fnd_global.login_id,
1275: p_request_id => l_nr_task_rec.incident_id,
1276: p_object_version_number => l_nr_task_rec.incident_object_version_number,
1277: p_request_number => null,
1278: p_x_sr_mr_association_tbl => l_mr_sr_assoc_tbl

Line 1346: p_user_id => fnd_global.user_id,

1342: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1343: x_return_status => l_return_status,
1344: x_msg_count => l_msg_count,
1345: x_msg_data => l_msg_data,
1346: p_user_id => fnd_global.user_id,
1347: p_login_id => fnd_global.login_id,
1348: p_request_id => l_nr_task_rec.incident_id,
1349: p_object_version_number => l_nr_task_rec.incident_object_version_number,
1350: p_request_number => null,

Line 1347: p_login_id => fnd_global.login_id,

1343: x_return_status => l_return_status,
1344: x_msg_count => l_msg_count,
1345: x_msg_data => l_msg_data,
1346: p_user_id => fnd_global.user_id,
1347: p_login_id => fnd_global.login_id,
1348: p_request_id => l_nr_task_rec.incident_id,
1349: p_object_version_number => l_nr_task_rec.incident_object_version_number,
1350: p_request_number => null,
1351: p_x_sr_mr_association_tbl => l_mr_sr_assoc_tbl

Line 1391: last_updated_by = FND_GLOBAL.user_id,

1387: UPDATE ahl_fleet_unit_assocs
1388: SET reconfig_sr_id = NULL,
1389: object_version_number = object_version_number + 1,
1390: last_update_date = SYSDATE,
1391: last_updated_by = FND_GLOBAL.user_id,
1392: last_update_login = FND_GLOBAL.login_id
1393: WHERE fleet_unit_assoc_id = l_fleet_unit_asso_rec.fleet_unit_assoc_id
1394: AND object_version_number = l_fleet_unit_asso_rec.object_version_number;
1395:

Line 1392: last_update_login = FND_GLOBAL.login_id

1388: SET reconfig_sr_id = NULL,
1389: object_version_number = object_version_number + 1,
1390: last_update_date = SYSDATE,
1391: last_updated_by = FND_GLOBAL.user_id,
1392: last_update_login = FND_GLOBAL.login_id
1393: WHERE fleet_unit_assoc_id = l_fleet_unit_asso_rec.fleet_unit_assoc_id
1394: AND object_version_number = l_fleet_unit_asso_rec.object_version_number;
1395:
1396: IF (SQL%NOTFOUND)