APPS.QPR_DASHBOARD_UTIL dependencies on QPR_DASHBOARD_MASTER_B

Line 30: FROM QPR_DASHBOARD_MASTER_B

26: TEMPLATE_NOT_FOUND EXCEPTION;
27:
28: CURSOR c_dashboard is
29: SELECT dashboard_id,source_template_id
30: FROM QPR_DASHBOARD_MASTER_B
31: WHERE user_id is null
32: and plan_id is null
33: and default_flag = 'Y'
34: and dashboard_type = 'T';

Line 42: FROM QPR_DASHBOARD_MASTER_B

38: SAVEPOINT Create_Dashboard_Default_P;
39: BEGIN
40: SELECT dashboard_type
41: INTO l_dashboard_type
42: FROM QPR_DASHBOARD_MASTER_B
43: WHERE user_id = p_user_id
44: and plan_id = p_plan_id
45: and default_flag = 'Y';
46: EXCEPTION

Line 82: UPDATE QPR_DASHBOARD_MASTER_B

78: WHERE dashboard_id = l_dashboard_id
79: and language = (select USERENV('Lang') from dual);
80:
81:
82: UPDATE QPR_DASHBOARD_MASTER_B
83: SET dashboard_id = n_dashboard_id
84: ,user_id = p_user_id
85: ,plan_id = p_plan_id
86: ,dashboard_type = 'I'

Line 264: INSERT INTO QPR_DASHBOARD_MASTER_B

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
265: ( SOURCE_TEMPLATE_ID
266: , DASHBOARD_ID
267: , DASHBOARD_TYPE
268: , DEFAULT_FLAG

Line 345: ,QPR_DASHBOARD_MASTER_B DMB

341: CURSOR Get_Dashboard_Details_C(c_price_plan_id NUMBER)
342: IS
343: SELECT DT.DASHBOARD_DETAIL_ID
344: FROM QPR_DASHBOARD_DETAILS DT
345: ,QPR_DASHBOARD_MASTER_B DMB
346: WHERE DMB.DASHBOARD_ID = DT.DASHBOARD_ID
347: AND DMB.PLAN_ID = c_price_plan_id;
348:
349:

Line 368: FROM QPR_DASHBOARD_MASTER_B

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);
370:
371: DELETE FROM QPR_DASHBOARD_MASTER_B
372: WHERE PLAN_ID = p_price_plan_id;

Line 371: DELETE FROM QPR_DASHBOARD_MASTER_B

367: (SELECT DASHBOARD_ID
368: FROM QPR_DASHBOARD_MASTER_B
369: WHERE PLAN_ID = p_price_plan_id);
370:
371: DELETE FROM QPR_DASHBOARD_MASTER_B
372: WHERE PLAN_ID = p_price_plan_id;
373:
374: x_return_status := FND_API.G_RET_STS_SUCCESS;
375: EXCEPTION