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;
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
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
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);