DBA Data[Home] [Help]

APPS.AHL_UC_TREE_PVT dependencies on FND_GLOBAL

Line 1516: last_updated_by = fnd_global.user_id,

1512: --For standalone no object_version_number change here because we have to update the
1513: --status for the same record after migration
1514: UPDATE ahl_unit_config_headers
1515: SET master_config_id = p_mc_header_id,
1516: last_updated_by = fnd_global.user_id,
1517: last_update_date = SYSDATE,
1518: last_update_login = fnd_global.login_id
1519: WHERE unit_config_header_id = p_uc_header_id
1520: AND object_version_number = l_uc_header_attr.object_version_number;

Line 1518: last_update_login = fnd_global.login_id

1514: UPDATE ahl_unit_config_headers
1515: SET master_config_id = p_mc_header_id,
1516: last_updated_by = fnd_global.user_id,
1517: last_update_date = SYSDATE,
1518: last_update_login = fnd_global.login_id
1519: WHERE unit_config_header_id = p_uc_header_id
1520: AND object_version_number = l_uc_header_attr.object_version_number;
1521: ELSE
1522: UPDATE ahl_unit_config_headers

Line 1525: last_updated_by = fnd_global.user_id,

1521: ELSE
1522: UPDATE ahl_unit_config_headers
1523: SET master_config_id = p_mc_header_id,
1524: object_version_number = object_version_number + 1,
1525: last_updated_by = fnd_global.user_id,
1526: last_update_date = SYSDATE,
1527: last_update_login = fnd_global.login_id
1528: WHERE unit_config_header_id = p_uc_header_id
1529: AND object_version_number = l_uc_header_attr.object_version_number;

Line 1527: last_update_login = fnd_global.login_id

1523: SET master_config_id = p_mc_header_id,
1524: object_version_number = object_version_number + 1,
1525: last_updated_by = fnd_global.user_id,
1526: last_update_date = SYSDATE,
1527: last_update_login = fnd_global.login_id
1528: WHERE unit_config_header_id = p_uc_header_id
1529: AND object_version_number = l_uc_header_attr.object_version_number;
1530: END IF;
1531: IF SQL%ROWCOUNT = 0 THEN

Line 1704: last_updated_by = fnd_global.user_id,

1700: UPDATE ahl_unit_config_headers
1701: SET unit_config_status_code = 'COMPLETE',
1702: active_uc_status_code = 'UNAPPROVED',
1703: object_version_number = object_version_number + 1,
1704: last_updated_by = fnd_global.user_id,
1705: last_update_date = SYSDATE,
1706: last_update_login = fnd_global.login_id
1707: WHERE unit_config_header_id = l_root_uc_header_id
1708: AND object_version_number = l_root_uc_ovn;

Line 1706: last_update_login = fnd_global.login_id

1702: active_uc_status_code = 'UNAPPROVED',
1703: object_version_number = object_version_number + 1,
1704: last_updated_by = fnd_global.user_id,
1705: last_update_date = SYSDATE,
1706: last_update_login = fnd_global.login_id
1707: WHERE unit_config_header_id = l_root_uc_header_id
1708: AND object_version_number = l_root_uc_ovn;
1709: IF SQL%ROWCOUNT = 0 THEN
1710: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 1727: last_updated_by = fnd_global.user_id,

1723: UPDATE ahl_unit_config_headers
1724: SET unit_config_status_code = 'INCOMPLETE',
1725: active_uc_status_code = 'UNAPPROVED',
1726: object_version_number = object_version_number + 1,
1727: last_updated_by = fnd_global.user_id,
1728: last_update_date = SYSDATE,
1729: last_update_login = fnd_global.login_id
1730: WHERE unit_config_header_id = l_root_uc_header_id
1731: AND object_version_number = l_root_uc_ovn;

Line 1729: last_update_login = fnd_global.login_id

1725: active_uc_status_code = 'UNAPPROVED',
1726: object_version_number = object_version_number + 1,
1727: last_updated_by = fnd_global.user_id,
1728: last_update_date = SYSDATE,
1729: last_update_login = fnd_global.login_id
1730: WHERE unit_config_header_id = l_root_uc_header_id
1731: AND object_version_number = l_root_uc_ovn;
1732: IF SQL%ROWCOUNT = 0 THEN
1733: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 1751: last_updated_by = fnd_global.user_id,

1747: l_root_active_uc_status_code <> 'UNAPPROVED')) THEN
1748: UPDATE ahl_unit_config_headers
1749: SET active_uc_status_code = 'UNAPPROVED',
1750: object_version_number = object_version_number + 1,
1751: last_updated_by = fnd_global.user_id,
1752: last_update_date = SYSDATE,
1753: last_update_login = fnd_global.login_id
1754: WHERE unit_config_header_id = l_root_uc_header_id
1755: AND object_version_number = l_root_uc_ovn;

Line 1753: last_update_login = fnd_global.login_id

1749: SET active_uc_status_code = 'UNAPPROVED',
1750: object_version_number = object_version_number + 1,
1751: last_updated_by = fnd_global.user_id,
1752: last_update_date = SYSDATE,
1753: last_update_login = fnd_global.login_id
1754: WHERE unit_config_header_id = l_root_uc_header_id
1755: AND object_version_number = l_root_uc_ovn;
1756: IF SQL%ROWCOUNT = 0 THEN
1757: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );