DBA Data[Home] [Help]

APPS.AHL_UC_UNITCONFIG_PVT dependencies on FND_GLOBAL

Line 766: fnd_global.user_id,

762: VALUES(
763: p_x_uc_header_rec.uc_header_id,
764: p_x_uc_header_rec.object_version_number,
765: sysdate,
766: fnd_global.user_id,
767: sysdate,
768: fnd_global.user_id,
769: fnd_global.login_id,
770: --trim added by jrotich for fixing bug#13090588 BEGIN

Line 768: fnd_global.user_id,

764: p_x_uc_header_rec.object_version_number,
765: sysdate,
766: fnd_global.user_id,
767: sysdate,
768: fnd_global.user_id,
769: fnd_global.login_id,
770: --trim added by jrotich for fixing bug#13090588 BEGIN
771: trim(p_x_uc_header_rec.uc_name),
772: --Modification by jrotich for fixing bug#13090588

Line 769: fnd_global.login_id,

765: sysdate,
766: fnd_global.user_id,
767: sysdate,
768: fnd_global.user_id,
769: fnd_global.login_id,
770: --trim added by jrotich for fixing bug#13090588 BEGIN
771: trim(p_x_uc_header_rec.uc_name),
772: --Modification by jrotich for fixing bug#13090588
773: p_x_uc_header_rec.mc_header_id,

Line 1010: last_updated_by = fnd_global.user_id,

1006:
1007: UPDATE ahl_unit_config_headers SET
1008: object_version_number = object_version_number + 1,
1009: last_update_date = sysdate,
1010: last_updated_by = fnd_global.user_id,
1011: last_update_login = fnd_global.login_id,
1012: --trim added by jrotich for fixing bug#13090588 BEGIN
1013: name = trim(p_x_uc_header_rec.uc_name),
1014: --Modification by jrotich for fixing bug#13090588 END

Line 1011: last_update_login = fnd_global.login_id,

1007: UPDATE ahl_unit_config_headers SET
1008: object_version_number = object_version_number + 1,
1009: last_update_date = sysdate,
1010: last_updated_by = fnd_global.user_id,
1011: last_update_login = fnd_global.login_id,
1012: --trim added by jrotich for fixing bug#13090588 BEGIN
1013: name = trim(p_x_uc_header_rec.uc_name),
1014: --Modification by jrotich for fixing bug#13090588 END
1015: master_config_id = p_x_uc_header_rec.mc_header_id,

Line 1299: last_updated_by = fnd_global.user_id,

1295: parent_uc_header_id = NULL,
1296: --Suitable for both standalone units and sub units
1297: object_version_number = object_version_number + 1,
1298: last_update_date = SYSDATE,
1299: last_updated_by = fnd_global.user_id,
1300: last_update_login = fnd_global.login_id
1301: WHERE unit_config_header_id = p_uc_header_id
1302: AND object_version_number = p_object_version_number;
1303:

Line 1300: last_update_login = fnd_global.login_id

1296: --Suitable for both standalone units and sub units
1297: object_version_number = object_version_number + 1,
1298: last_update_date = SYSDATE,
1299: last_updated_by = fnd_global.user_id,
1300: last_update_login = fnd_global.login_id
1301: WHERE unit_config_header_id = p_uc_header_id
1302: AND object_version_number = p_object_version_number;
1303:
1304: IF SQL%NOTFOUND THEN

Line 1414: last_updated_by = fnd_global.user_id,

1410: UPDATE ahl_unit_config_headers
1411: SET active_end_date = sysdate,
1412: object_version_number = object_version_number + 1,
1413: last_update_date = sysdate,
1414: last_updated_by = fnd_global.user_id,
1415: last_update_login = fnd_global.login_id
1416: WHERE unit_config_header_id = l_subunits.unit_config_header_id;
1417: --here no object_version_number check
1418:

Line 1415: last_update_login = fnd_global.login_id

1411: SET active_end_date = sysdate,
1412: object_version_number = object_version_number + 1,
1413: last_update_date = sysdate,
1414: last_updated_by = fnd_global.user_id,
1415: last_update_login = fnd_global.login_id
1416: WHERE unit_config_header_id = l_subunits.unit_config_header_id;
1417: --here no object_version_number check
1418:
1419: ahl_util_uc_pkg.copy_uc_header_to_history(l_subunits.unit_config_header_id,l_return_status);