eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_PORTLET_GRAPH dependencies on BSC_USER_KPIGRAPH_PLUGS

Line 19: -- it deletes the record from bsc_user_kpigraph_plugs table.

15: -- Plug
16: --
17: -- PURPOSE
18: -- This procedure displays the Kpi graph portlet. If p_delete = 'Y',
19: -- it deletes the record from bsc_user_kpigraph_plugs table.
20: --
21: -- PARAMETERS
22: --
23: -- HISTORY

Line 45: FROM BSC_USER_KPIGRAPH_PLUGS k,

41: CURSOR c_kg_p IS
42: SELECT k.RESPONSIBILITY_ID,
43: bt.TAB_ID,
44: k.INDICATOR
45: FROM BSC_USER_KPIGRAPH_PLUGS k,
46: BSC_TAB_INDICATORS bt
47: WHERE k.USER_ID = l_user_id
48: AND k.PLUG_ID = p_plug_id
49: AND k.INDICATOR = bt.INDICATOR;

Line 54: FROM BSC_USER_KPIGRAPH_PLUGS k

50:
51:
52: CURSOR c_plug IS
53: SELECT k.INDICATOR
54: FROM BSC_USER_KPIGRAPH_PLUGS k
55: WHERE k.USER_ID = l_user_id
56: AND k.PLUG_ID = p_plug_id;
57:
58:

Line 63: FROM BSC_USER_KPIGRAPH_PLUGS k,

59:
60:
61: CURSOR c_tab_kpi IS
62: SELECT bt.TAB_ID
63: FROM BSC_USER_KPIGRAPH_PLUGS k,
64: BSC_TAB_INDICATORS bt
65: WHERE k.USER_ID = l_user_id
66: AND k.PLUG_ID = p_plug_id
67: AND k.INDICATOR = bt.INDICATOR;

Line 77: -- should clean up bsc_user_kpigraph_plugs

73: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'',p_session_id);
74:
75: IF p_delete = 'Y' THEN
76: --------------------------------------------
77: -- should clean up bsc_user_kpigraph_plugs
78: --------------------------------------------
79: DELETE FROM bsc_user_kpigraph_plugs
80: WHERE user_id = l_user_id
81: AND plug_id = p_plug_id;

Line 79: DELETE FROM bsc_user_kpigraph_plugs

75: IF p_delete = 'Y' THEN
76: --------------------------------------------
77: -- should clean up bsc_user_kpigraph_plugs
78: --------------------------------------------
79: DELETE FROM bsc_user_kpigraph_plugs
80: WHERE user_id = l_user_id
81: AND plug_id = p_plug_id;
82:
83: COMMIT;

Line 88: -- find the record in BSC_USER_KPIGRAPH_PLUGS

84: RETURN;
85: ELSE -- p_delete = 'N'
86:
87: --------------------------------------------
88: -- find the record in BSC_USER_KPIGRAPH_PLUGS
89: --------------------------------------------
90: OPEN c_kg_p;
91: FETCH c_kg_p INTO l_resp_id, l_tab_id, l_kpi_id;
92:

Line 127: -- bug# 1745058, make sure if no row in BSC_USER_KPIGRAPH_PLUGS

123: TRUE, bsc_portlet_util.VALUE_NOT_SET, p_display_name);
124:
125:
126: ----------------------------------------------
127: -- bug# 1745058, make sure if no row in BSC_USER_KPIGRAPH_PLUGS
128: ----------------------------------------------
129: OPEN c_plug;
130: FETCH c_plug INTO l_temp;
131:

Line 207: bsc_user_kpigraph_plugs bp,

203: FROM
204: fnd_user_resp_groups fg,
205: fnd_responsibility fr,
206: bsc_user_responsibility_v br,
207: bsc_user_kpigraph_plugs bp,
208: bsc_tab_indicators bti,
209: bsc_user_tab_access bta,
210: bsc_user_kpi_access bk
211: WHERE

Line 904: FROM BSC_USER_KPIGRAPH_PLUGS k,

900: CURSOR c_kg_p IS
901: SELECT k.RESPONSIBILITY_ID,
902: bt.TAB_ID,
903: k.INDICATOR
904: FROM BSC_USER_KPIGRAPH_PLUGS k,
905: BSC_TAB_INDICATORS bt
906: WHERE k.USER_ID = l_user_id
907: AND k.PLUG_ID = p_plug_id
908: AND k.INDICATOR = bt.INDICATOR;

Line 916: -- find the record in BSC_USER_KPIGRAPH_PLUGS

912: IF icx_sec.validatePlugSession(p_plug_id,p_session_id) THEN
913:
914: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'',p_session_id);
915: --------------------------------------------
916: -- find the record in BSC_USER_KPIGRAPH_PLUGS
917: --------------------------------------------
918: OPEN c_kg_p;
919: FETCH c_kg_p INTO p_o_resp_id, p_o_tab_id, p_o_kpi_id;
920:

Line 973: FROM BSC_USER_KPIGRAPH_PLUGS k

969:
970: BEGIN
971: SELECT count(*)
972: INTO l_count
973: FROM BSC_USER_KPIGRAPH_PLUGS k
974: WHERE
975: k.USER_ID = p_user_id AND
976: k.PLUG_ID = p_plug_id;
977:

Line 981: BSC_USER_KPIGRAPH_PLUGS

977:
978: IF (l_count > 0) THEN -- record exists, need to update
979:
980: UPDATE
981: BSC_USER_KPIGRAPH_PLUGS
982: SET
983: RESPONSIBILITY_ID = p_resp_id,
984: INDICATOR = p_kpi_id,
985: LAST_UPDATE_DATE = SYSDATE,

Line 997: INSERT INTO BSC_USER_KPIGRAPH_PLUGS (

993: END IF;
994:
995: ELSE -- record does not exist, insert it
996:
997: INSERT INTO BSC_USER_KPIGRAPH_PLUGS (
998: USER_ID, PLUG_ID, RESPONSIBILITY_ID, INDICATOR,
999: CREATION_DATE, CREATED_BY,
1000: LAST_UPDATE_DATE, LAST_UPDATED_BY,
1001: LAST_UPDATE_LOGIN)

Line 1027: l_errmesg := 'Error inserting to BSC_USER_KPIGRAPH_PLUGS';

1023:
1024: WHEN insert_err THEN
1025: ROLLBACK;
1026: p_o_ret_status := bsc_portlet_util.CODE_RET_ERROR;
1027: l_errmesg := 'Error inserting to BSC_USER_KPIGRAPH_PLUGS';
1028: RETURN l_errmesg;
1029:
1030:
1031: WHEN update_err THEN

Line 1034: l_errmesg := 'Error updating to BSC_USER_KPIGRAPH_PLUGS';

1030:
1031: WHEN update_err THEN
1032: ROLLBACK;
1033: p_o_ret_status := bsc_portlet_util.CODE_RET_ERROR;
1034: l_errmesg := 'Error updating to BSC_USER_KPIGRAPH_PLUGS';
1035: RETURN l_errmesg;
1036:
1037: WHEN OTHERS THEN
1038: ROLLBACK;

Line 1081: FROM bsc_user_kpigraph_plugs k,

1077:
1078:
1079: CURSOR c_kg_p IS
1080: SELECT k.RESPONSIBILITY_ID, k.INDICATOR, p.DISPLAY_NAME
1081: FROM bsc_user_kpigraph_plugs k,
1082: icx_page_plugs p
1083: WHERE
1084: p.PLUG_ID = l_plug_id AND
1085: k.PLUG_ID(+)= p.PLUG_ID AND