DBA Data[Home] [Help]

APPS.AMS_LIST_RUNNING_TOTAL_PVT dependencies on FND_GLOBAL

Line 87: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

83: SET recalc_table_status = 'IN_PROGRESS',
84: mv_available_flag = 'N',
85: request_id = l_request_id,
86: LAST_UPDATE_DATE = SYSDATE,
87: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
88: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
89: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID,
90: PROGRAM_UPDATE_DATE = SYSDATE
91: WHERE template_id = p_template_id;

Line 88: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,

84: mv_available_flag = 'N',
85: request_id = l_request_id,
86: LAST_UPDATE_DATE = SYSDATE,
87: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
88: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
89: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID,
90: PROGRAM_UPDATE_DATE = SYSDATE
91: WHERE template_id = p_template_id;
92: ELSE

Line 89: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID,

85: request_id = l_request_id,
86: LAST_UPDATE_DATE = SYSDATE,
87: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
88: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
89: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID,
90: PROGRAM_UPDATE_DATE = SYSDATE
91: WHERE template_id = p_template_id;
92: ELSE
93: UPDATE ams_query_template_all

Line 97: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

93: UPDATE ams_query_template_all
94: SET recalc_table_status = 'DRAFT',
95: mv_available_flag = 'N',
96: LAST_UPDATE_DATE = SYSDATE,
97: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
98: WHERE template_id = p_template_id;
99:
100: l_view_name := 'AMS_QT_'||to_char(p_template_id)||'_MV';
101: open c_view_exists(l_view_name);