DBA Data[Home] [Help]

APPS.AMS_LIST_RUNNING_TOTAL_PVT dependencies on FND_GLOBAL

Line 66: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

62: SET recalc_table_status = 'IN_PROGRESS',
63: mv_available_flag = 'N',
64: request_id = l_request_id,
65: LAST_UPDATE_DATE = SYSDATE,
66: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
67: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
68: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID,
69: PROGRAM_UPDATE_DATE = SYSDATE
70: WHERE template_id = p_template_id;

Line 67: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,

63: mv_available_flag = 'N',
64: request_id = l_request_id,
65: LAST_UPDATE_DATE = SYSDATE,
66: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
67: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
68: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID,
69: PROGRAM_UPDATE_DATE = SYSDATE
70: WHERE template_id = p_template_id;
71: ELSE

Line 68: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID,

64: request_id = l_request_id,
65: LAST_UPDATE_DATE = SYSDATE,
66: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
67: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
68: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID,
69: PROGRAM_UPDATE_DATE = SYSDATE
70: WHERE template_id = p_template_id;
71: ELSE
72: UPDATE ams_query_template_all

Line 76: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

72: UPDATE ams_query_template_all
73: SET recalc_table_status = 'DRAFT',
74: mv_available_flag = 'N',
75: LAST_UPDATE_DATE = SYSDATE,
76: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
77: WHERE template_id = p_template_id;
78:
79: l_view_name := 'AMS_QT_'||to_char(p_template_id)||'_MV';
80: open c_view_exists(l_view_name);