DBA Data[Home] [Help]

APPS.AMS_LISTHEADER_PVT dependencies on FND_GLOBAL

Line 1470: FND_GLOBAL.user_id,

1466: APPLY_SUPPRESSION_FLAG
1467: ) values (
1468: decode(l_listheader_rec.LIST_HEADER_ID ,FND_API.g_miss_num,null,l_listheader_rec.LIST_HEADER_ID) ,
1469: sysdate,
1470: FND_GLOBAL.user_id,
1471: sysdate,
1472: FND_GLOBAL.user_id,
1473: FND_GLOBAL.conc_login_id,
1474: 1,

Line 1472: FND_GLOBAL.user_id,

1468: decode(l_listheader_rec.LIST_HEADER_ID ,FND_API.g_miss_num,null,l_listheader_rec.LIST_HEADER_ID) ,
1469: sysdate,
1470: FND_GLOBAL.user_id,
1471: sysdate,
1472: FND_GLOBAL.user_id,
1473: FND_GLOBAL.conc_login_id,
1474: 1,
1475: decode(l_listheader_rec.REQUEST_ID ,FND_API.g_miss_num,null,l_listheader_rec.REQUEST_ID) ,
1476: decode(l_listheader_rec.PROGRAM_ID ,FND_API.g_miss_num,null,l_listheader_rec.PROGRAM_ID) ,

Line 1473: FND_GLOBAL.conc_login_id,

1469: sysdate,
1470: FND_GLOBAL.user_id,
1471: sysdate,
1472: FND_GLOBAL.user_id,
1473: FND_GLOBAL.conc_login_id,
1474: 1,
1475: decode(l_listheader_rec.REQUEST_ID ,FND_API.g_miss_num,null,l_listheader_rec.REQUEST_ID) ,
1476: decode(l_listheader_rec.PROGRAM_ID ,FND_API.g_miss_num,null,l_listheader_rec.PROGRAM_ID) ,
1477: decode(l_listheader_rec.PROGRAM_APPLICATION_ID ,FND_API.g_miss_num,null,l_listheader_rec.PROGRAM_APPLICATION_ID) ,

Line 1613: FND_GLOBAL.user_id,

1609: decode(l_listheader_rec.LIST_NAME ,FND_API.g_miss_char,null,l_listheader_rec.LIST_NAME) ,
1610: decode(l_listheader_rec.DESCRIPTION ,FND_API.g_miss_char,null,l_listheader_rec.DESCRIPTION) ,
1611: decode(l_listheader_rec.LIST_HEADER_ID ,FND_API.g_miss_num,null,l_listheader_rec.LIST_HEADER_ID) ,
1612: sysdate,
1613: FND_GLOBAL.user_id,
1614: sysdate,
1615: FND_GLOBAL.user_id,
1616: FND_GLOBAL.conc_login_id
1617: from FND_LANGUAGES L

Line 1615: FND_GLOBAL.user_id,

1611: decode(l_listheader_rec.LIST_HEADER_ID ,FND_API.g_miss_num,null,l_listheader_rec.LIST_HEADER_ID) ,
1612: sysdate,
1613: FND_GLOBAL.user_id,
1614: sysdate,
1615: FND_GLOBAL.user_id,
1616: FND_GLOBAL.conc_login_id
1617: from FND_LANGUAGES L
1618: where L.INSTALLED_FLAG in ('I', 'B')
1619: and not exists

Line 1616: FND_GLOBAL.conc_login_id

1612: sysdate,
1613: FND_GLOBAL.user_id,
1614: sysdate,
1615: FND_GLOBAL.user_id,
1616: FND_GLOBAL.conc_login_id
1617: from FND_LANGUAGES L
1618: where L.INSTALLED_FLAG in ('I', 'B')
1619: and not exists
1620: (select NULL

Line 1922: ,last_updated_by = FND_GLOBAL.User_Id

1918:
1919: UPDATE ams_list_headers_all
1920: SET
1921: last_update_date = sysdate
1922: ,last_updated_by = FND_GLOBAL.User_Id
1923: ,last_update_login = FND_GLOBAL.Conc_Login_Id
1924: ,object_version_number = l_listheader_rec.object_version_number + 1
1925: ,request_id = l_listheader_rec.request_id
1926: ,program_id = l_listheader_rec.program_id

Line 1923: ,last_update_login = FND_GLOBAL.Conc_Login_Id

1919: UPDATE ams_list_headers_all
1920: SET
1921: last_update_date = sysdate
1922: ,last_updated_by = FND_GLOBAL.User_Id
1923: ,last_update_login = FND_GLOBAL.Conc_Login_Id
1924: ,object_version_number = l_listheader_rec.object_version_number + 1
1925: ,request_id = l_listheader_rec.request_id
1926: ,program_id = l_listheader_rec.program_id
1927: ,program_application_id = l_listheader_rec.program_application_id

Line 2053: LAST_UPDATE_BY = FND_GLOBAL.user_id,

2049: update AMS_LIST_HEADERS_ALL_TL set
2050: LIST_NAME = l_listheader_rec.LIST_NAME,
2051: DESCRIPTION = l_listheader_rec.DESCRIPTION,
2052: LAST_UPDATE_DATE = sysdate,
2053: LAST_UPDATE_BY = FND_GLOBAL.user_id,
2054: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id,
2055: SOURCE_LANG = userenv('LANG')
2056: where LIST_HEADER_ID = l_listheader_rec.LIST_HEADER_ID
2057: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 2054: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id,

2050: LIST_NAME = l_listheader_rec.LIST_NAME,
2051: DESCRIPTION = l_listheader_rec.DESCRIPTION,
2052: LAST_UPDATE_DATE = sysdate,
2053: LAST_UPDATE_BY = FND_GLOBAL.user_id,
2054: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id,
2055: SOURCE_LANG = userenv('LANG')
2056: where LIST_HEADER_ID = l_listheader_rec.LIST_HEADER_ID
2057: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
2058: