DBA Data[Home] [Help]

APPS.AHL_UC_TREE_PVT dependencies on FND_GLOBAL

Line 1579: last_updated_by = fnd_global.user_id,

1575: --For standalone no object_version_number change here because we have to update the
1576: --status for the same record after migration
1577: UPDATE ahl_unit_config_headers
1578: SET master_config_id = p_mc_header_id,
1579: last_updated_by = fnd_global.user_id,
1580: last_update_date = SYSDATE,
1581: last_update_login = fnd_global.login_id
1582: WHERE unit_config_header_id = p_uc_header_id
1583: AND object_version_number = l_uc_header_attr.object_version_number;

Line 1581: last_update_login = fnd_global.login_id

1577: UPDATE ahl_unit_config_headers
1578: SET master_config_id = p_mc_header_id,
1579: last_updated_by = fnd_global.user_id,
1580: last_update_date = SYSDATE,
1581: last_update_login = fnd_global.login_id
1582: WHERE unit_config_header_id = p_uc_header_id
1583: AND object_version_number = l_uc_header_attr.object_version_number;
1584: ELSE
1585: UPDATE ahl_unit_config_headers

Line 1588: last_updated_by = fnd_global.user_id,

1584: ELSE
1585: UPDATE ahl_unit_config_headers
1586: SET master_config_id = p_mc_header_id,
1587: object_version_number = object_version_number + 1,
1588: last_updated_by = fnd_global.user_id,
1589: last_update_date = SYSDATE,
1590: last_update_login = fnd_global.login_id
1591: WHERE unit_config_header_id = p_uc_header_id
1592: AND object_version_number = l_uc_header_attr.object_version_number;

Line 1590: last_update_login = fnd_global.login_id

1586: SET master_config_id = p_mc_header_id,
1587: object_version_number = object_version_number + 1,
1588: last_updated_by = fnd_global.user_id,
1589: last_update_date = SYSDATE,
1590: last_update_login = fnd_global.login_id
1591: WHERE unit_config_header_id = p_uc_header_id
1592: AND object_version_number = l_uc_header_attr.object_version_number;
1593: END IF;
1594: IF SQL%ROWCOUNT = 0 THEN

Line 1767: last_updated_by = fnd_global.user_id,

1763: UPDATE ahl_unit_config_headers
1764: SET unit_config_status_code = 'COMPLETE',
1765: active_uc_status_code = 'UNAPPROVED',
1766: object_version_number = object_version_number + 1,
1767: last_updated_by = fnd_global.user_id,
1768: last_update_date = SYSDATE,
1769: last_update_login = fnd_global.login_id
1770: WHERE unit_config_header_id = l_root_uc_header_id
1771: AND object_version_number = l_root_uc_ovn;

Line 1769: last_update_login = fnd_global.login_id

1765: active_uc_status_code = 'UNAPPROVED',
1766: object_version_number = object_version_number + 1,
1767: last_updated_by = fnd_global.user_id,
1768: last_update_date = SYSDATE,
1769: last_update_login = fnd_global.login_id
1770: WHERE unit_config_header_id = l_root_uc_header_id
1771: AND object_version_number = l_root_uc_ovn;
1772: IF SQL%ROWCOUNT = 0 THEN
1773: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 1790: last_updated_by = fnd_global.user_id,

1786: UPDATE ahl_unit_config_headers
1787: SET unit_config_status_code = 'INCOMPLETE',
1788: active_uc_status_code = 'UNAPPROVED',
1789: object_version_number = object_version_number + 1,
1790: last_updated_by = fnd_global.user_id,
1791: last_update_date = SYSDATE,
1792: last_update_login = fnd_global.login_id
1793: WHERE unit_config_header_id = l_root_uc_header_id
1794: AND object_version_number = l_root_uc_ovn;

Line 1792: last_update_login = fnd_global.login_id

1788: active_uc_status_code = 'UNAPPROVED',
1789: object_version_number = object_version_number + 1,
1790: last_updated_by = fnd_global.user_id,
1791: last_update_date = SYSDATE,
1792: last_update_login = fnd_global.login_id
1793: WHERE unit_config_header_id = l_root_uc_header_id
1794: AND object_version_number = l_root_uc_ovn;
1795: IF SQL%ROWCOUNT = 0 THEN
1796: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );

Line 1814: last_updated_by = fnd_global.user_id,

1810: l_root_active_uc_status_code <> 'UNAPPROVED')) THEN
1811: UPDATE ahl_unit_config_headers
1812: SET active_uc_status_code = 'UNAPPROVED',
1813: object_version_number = object_version_number + 1,
1814: last_updated_by = fnd_global.user_id,
1815: last_update_date = SYSDATE,
1816: last_update_login = fnd_global.login_id
1817: WHERE unit_config_header_id = l_root_uc_header_id
1818: AND object_version_number = l_root_uc_ovn;

Line 1816: last_update_login = fnd_global.login_id

1812: SET active_uc_status_code = 'UNAPPROVED',
1813: object_version_number = object_version_number + 1,
1814: last_updated_by = fnd_global.user_id,
1815: last_update_date = SYSDATE,
1816: last_update_login = fnd_global.login_id
1817: WHERE unit_config_header_id = l_root_uc_header_id
1818: AND object_version_number = l_root_uc_ovn;
1819: IF SQL%ROWCOUNT = 0 THEN
1820: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );