APPS.BSC_PORTLET_KPILISTCUST dependencies on BSC_USER_KPILIST_PLUGS

Line 107: -- table: BSC_USER_KPILIST_PLUGS

103: -- insert_row
104: --
105: -- PURPOSE
106: -- This procedure is used internally. It is used to insert
107: -- table: BSC_USER_KPILIST_PLUGS
108: --
109: -- PARAMETERS
110: --
111: -- HISTORY

Line 125: INSERT INTO BSC_USER_KPILIST_PLUGS (

121: p_last_updated_by IN NUMBER
122: ) IS
123: insert_err EXCEPTION;
124: BEGIN
125: INSERT INTO BSC_USER_KPILIST_PLUGS (
126: PLUG_ID,
127: DETAILS_FLAG,
128: GROUP_FLAG,
129: KPI_MEASURE_DETAILS_FLAG,

Line 160: -- table: BSC_USER_KPILIST_PLUGS

156: -- insert_row - signature with "p_reference_path IN VARCHAR2"
157: --
158: -- PURPOSE
159: -- This procedure is used internally. It is used to insert
160: -- table: BSC_USER_KPILIST_PLUGS
161: --
162: -- PARAMETERS
163: --
164: -- HISTORY

Line 179: INSERT INTO BSC_USER_KPILIST_PLUGS (

175: p_last_updated_by IN NUMBER
176: ) IS
177: insert_err EXCEPTION;
178: BEGIN
179: INSERT INTO BSC_USER_KPILIST_PLUGS (
180: PLUG_ID,
181: DETAILS_FLAG,
182: GROUP_FLAG,
183: KPI_MEASURE_DETAILS_FLAG,

Line 217: -- table: BSC_USER_KPILIST_PLUGS

213: -- update_row
214: --
215: -- PURPOSE
216: -- This procedure is used internally. It is used to update
217: -- table: BSC_USER_KPILIST_PLUGS
218: --
219: -- PARAMETERS
220: --
221: -- HISTORY

Line 237: BSC_USER_KPILIST_PLUGS

233:
234: update_err EXCEPTION;
235: BEGIN
236: UPDATE
237: BSC_USER_KPILIST_PLUGS
238: SET
239: DETAILS_FLAG = p_details_flag,
240: GROUP_FLAG = p_group_flag,
241: KPI_MEASURE_DETAILS_FLAG = p_kpi_measure_details_flag,

Line 259: -- table: BSC_USER_KPILIST_PLUGS

255: -- update_row - updated with reference path
256: --
257: -- PURPOSE
258: -- This procedure is used internally. It is used to update
259: -- table: BSC_USER_KPILIST_PLUGS
260: --
261: -- PARAMETERS
262: --
263: -- HISTORY

Line 280: BSC_USER_KPILIST_PLUGS

276:
277: update_err EXCEPTION;
278: BEGIN
279: UPDATE
280: BSC_USER_KPILIST_PLUGS
281: SET
282: DETAILS_FLAG = p_details_flag,
283: GROUP_FLAG = p_group_flag,
284: KPI_MEASURE_DETAILS_FLAG = p_kpi_measure_details_flag,

Line 534: FROM BSC_USER_KPILIST_PLUGS k

530:
531: BEGIN
532: SELECT count(*)
533: INTO l_count
534: FROM BSC_USER_KPILIST_PLUGS k
535: WHERE
536: k.PLUG_ID = p_plug_id;
537:
538: --DBMS_OUTPUT.PUT_LINE('set_cust_n');

Line 542: -- update bsc_user_kpilist_plugs

538: --DBMS_OUTPUT.PUT_LINE('set_cust_n');
539: --DBMS_OUTPUT.PUT_LINE('l_count-->'||l_count);
540:
541: ---------------------------------
542: -- update bsc_user_kpilist_plugs
543: ---------------------------------
544: IF (l_count > 0) THEN -- record exists, need to update
545: update_row(p_plug_id, p_reference_path ,p_details_flag, p_group_flag, p_kpi_measure_details_flag, sysdate, p_last_updated_by);
546: ELSE -- record does not exist, insert it

Line 571: l_errmesg := 'Error inserting to BSC_USER_KPILIST_PLUGS';

567:
568: WHEN insert_err THEN
569: ROLLBACK;
570: p_o_ret_status := bsc_portlet_util.CODE_RET_ERROR;
571: l_errmesg := 'Error inserting to BSC_USER_KPILIST_PLUGS';
572: RETURN l_errmesg;
573:
574:
575: WHEN update_err THEN

Line 578: l_errmesg := 'Error updating to BSC_USER_KPILIST_PLUGS';

574:
575: WHEN update_err THEN
576: ROLLBACK;
577: p_o_ret_status := bsc_portlet_util.CODE_RET_ERROR;
578: l_errmesg := 'Error updating to BSC_USER_KPILIST_PLUGS';
579: RETURN l_errmesg;
580:
581: WHEN OTHERS THEN
582: ROLLBACK;

Line 627: FROM bsc_user_kpilist_plugs k,

623: -- bug fix 2072699
624:
625: CURSOR c_kg_p IS
626: SELECT p.RESPONSIBILITY_ID, NVL(k.DETAILS_FLAG, 0), NVL(k.GROUP_FLAG, 0), p.TITLE, NVL(k.kpi_measure_details_flag, 0)
627: FROM bsc_user_kpilist_plugs k,
628: icx_portlet_customizations p
629: WHERE
630: p.PLUG_ID = p_plug_id AND
631: k.PLUG_ID(+)= p.PLUG_ID;