APPS.QPR_DASHBOARD_UTIL dependencies on QPR_DASHBOARD_MASTER_TL

Line 77: FROM QPR_DASHBOARD_MASTER_TL

73: --generate proper error log ask shanmu
74:
75: SELECT dashboard_name,source_lang
76: INTO l_dashboard_name,l_source_lang
77: FROM QPR_DASHBOARD_MASTER_TL
78: WHERE dashboard_id = l_dashboard_id
79: and language = (select USERENV('Lang') from dual);
80:
81:

Line 89: UPDATE QPR_DASHBOARD_MASTER_TL

85: ,plan_id = p_plan_id
86: ,dashboard_type = 'I'
87: WHERE dashboard_id = l_dashboard_id;
88:
89: UPDATE QPR_DASHBOARD_MASTER_TL
90: SET dashboard_id = n_dashboard_id
91: WHERE dashboard_id = l_dashboard_id;
92:
93: Generate_Default_Rows(l_dashboard_name,l_source_template_id,l_dashboard_id,l_source_lang,l_dsb_table,l_return_status);

Line 235: INSERT INTO QPR_DASHBOARD_MASTER_TL

231:
232: BEGIN
233:
234: SAVEPOINT Generate_default_Rows_V;
235: INSERT INTO QPR_DASHBOARD_MASTER_TL
236: ( DASHBOARD_ID
237: , DASHBOARD_NAME
238: , LANGUAGE
239: , SOURCE_LANG

Line 260: from qpr_dashboard_master_tl t

256: where l.installed_flag in ('I','B')
257: and b.installed_flag = 'B'
258: and not exists
259: (select null
260: from qpr_dashboard_master_tl t
261: where t.dashboard_id = p_dashboard_id
262: and t.language = l.language_code);
263:
264: INSERT INTO QPR_DASHBOARD_MASTER_B

Line 365: DELETE FROM QPR_DASHBOARD_MASTER_TL

361: WHERE DASHBOARD_DETAIL_ID = l_detail_id;
362: END LOOP;
363: CLOSE Get_Dashboard_Details_C;
364:
365: DELETE FROM QPR_DASHBOARD_MASTER_TL
366: WHERE DASHBOARD_ID IN
367: (SELECT DASHBOARD_ID
368: FROM QPR_DASHBOARD_MASTER_B
369: WHERE PLAN_ID = p_price_plan_id);