DBA Data[Home] [Help]

APPS.AMS_LISTHEADER_PVT dependencies on FND_GLOBAL

Line 1460: FND_GLOBAL.user_id,

1456: APPLY_SUPPRESSION_FLAG
1457: ) values (
1458: decode(l_listheader_rec.LIST_HEADER_ID ,FND_API.g_miss_num,null,l_listheader_rec.LIST_HEADER_ID) ,
1459: sysdate,
1460: FND_GLOBAL.user_id,
1461: sysdate,
1462: FND_GLOBAL.user_id,
1463: FND_GLOBAL.conc_login_id,
1464: 1,

Line 1462: FND_GLOBAL.user_id,

1458: decode(l_listheader_rec.LIST_HEADER_ID ,FND_API.g_miss_num,null,l_listheader_rec.LIST_HEADER_ID) ,
1459: sysdate,
1460: FND_GLOBAL.user_id,
1461: sysdate,
1462: FND_GLOBAL.user_id,
1463: FND_GLOBAL.conc_login_id,
1464: 1,
1465: decode(l_listheader_rec.REQUEST_ID ,FND_API.g_miss_num,null,l_listheader_rec.REQUEST_ID) ,
1466: decode(l_listheader_rec.PROGRAM_ID ,FND_API.g_miss_num,null,l_listheader_rec.PROGRAM_ID) ,

Line 1463: FND_GLOBAL.conc_login_id,

1459: sysdate,
1460: FND_GLOBAL.user_id,
1461: sysdate,
1462: FND_GLOBAL.user_id,
1463: FND_GLOBAL.conc_login_id,
1464: 1,
1465: decode(l_listheader_rec.REQUEST_ID ,FND_API.g_miss_num,null,l_listheader_rec.REQUEST_ID) ,
1466: decode(l_listheader_rec.PROGRAM_ID ,FND_API.g_miss_num,null,l_listheader_rec.PROGRAM_ID) ,
1467: decode(l_listheader_rec.PROGRAM_APPLICATION_ID ,FND_API.g_miss_num,null,l_listheader_rec.PROGRAM_APPLICATION_ID) ,

Line 1600: FND_GLOBAL.user_id,

1596: decode(l_listheader_rec.LIST_NAME ,FND_API.g_miss_char,null,l_listheader_rec.LIST_NAME) ,
1597: decode(l_listheader_rec.DESCRIPTION ,FND_API.g_miss_char,null,l_listheader_rec.DESCRIPTION) ,
1598: decode(l_listheader_rec.LIST_HEADER_ID ,FND_API.g_miss_num,null,l_listheader_rec.LIST_HEADER_ID) ,
1599: sysdate,
1600: FND_GLOBAL.user_id,
1601: sysdate,
1602: FND_GLOBAL.user_id,
1603: FND_GLOBAL.conc_login_id
1604: from FND_LANGUAGES L

Line 1602: FND_GLOBAL.user_id,

1598: decode(l_listheader_rec.LIST_HEADER_ID ,FND_API.g_miss_num,null,l_listheader_rec.LIST_HEADER_ID) ,
1599: sysdate,
1600: FND_GLOBAL.user_id,
1601: sysdate,
1602: FND_GLOBAL.user_id,
1603: FND_GLOBAL.conc_login_id
1604: from FND_LANGUAGES L
1605: where L.INSTALLED_FLAG in ('I', 'B')
1606: and not exists

Line 1603: FND_GLOBAL.conc_login_id

1599: sysdate,
1600: FND_GLOBAL.user_id,
1601: sysdate,
1602: FND_GLOBAL.user_id,
1603: FND_GLOBAL.conc_login_id
1604: from FND_LANGUAGES L
1605: where L.INSTALLED_FLAG in ('I', 'B')
1606: and not exists
1607: (select NULL

Line 1909: ,last_updated_by = FND_GLOBAL.User_Id

1905:
1906: UPDATE ams_list_headers_all
1907: SET
1908: last_update_date = sysdate
1909: ,last_updated_by = FND_GLOBAL.User_Id
1910: ,last_update_login = FND_GLOBAL.Conc_Login_Id
1911: ,object_version_number = l_listheader_rec.object_version_number + 1
1912: ,request_id = l_listheader_rec.request_id
1913: ,program_id = l_listheader_rec.program_id

Line 1910: ,last_update_login = FND_GLOBAL.Conc_Login_Id

1906: UPDATE ams_list_headers_all
1907: SET
1908: last_update_date = sysdate
1909: ,last_updated_by = FND_GLOBAL.User_Id
1910: ,last_update_login = FND_GLOBAL.Conc_Login_Id
1911: ,object_version_number = l_listheader_rec.object_version_number + 1
1912: ,request_id = l_listheader_rec.request_id
1913: ,program_id = l_listheader_rec.program_id
1914: ,program_application_id = l_listheader_rec.program_application_id

Line 2040: LAST_UPDATE_BY = FND_GLOBAL.user_id,

2036: update AMS_LIST_HEADERS_ALL_TL set
2037: LIST_NAME = l_listheader_rec.LIST_NAME,
2038: DESCRIPTION = l_listheader_rec.DESCRIPTION,
2039: LAST_UPDATE_DATE = sysdate,
2040: LAST_UPDATE_BY = FND_GLOBAL.user_id,
2041: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id,
2042: SOURCE_LANG = userenv('LANG')
2043: where LIST_HEADER_ID = l_listheader_rec.LIST_HEADER_ID
2044: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 2041: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id,

2037: LIST_NAME = l_listheader_rec.LIST_NAME,
2038: DESCRIPTION = l_listheader_rec.DESCRIPTION,
2039: LAST_UPDATE_DATE = sysdate,
2040: LAST_UPDATE_BY = FND_GLOBAL.user_id,
2041: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id,
2042: SOURCE_LANG = userenv('LANG')
2043: where LIST_HEADER_ID = l_listheader_rec.LIST_HEADER_ID
2044: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
2045: