APPS.BSC_PORTLET_KPILISTCUST dependencies on BSC_NUM_LIST

Line 358: p_number_array IN BSC_NUM_LIST

354: PROCEDURE update_indicators (
355: p_resp_id IN NUMBER,
356: p_last_update_date IN DATE,
357: p_last_updated_by IN NUMBER,
358: p_number_array IN BSC_NUM_LIST
359: ) IS
360:
361: l_kpi_id Number;
362: l_paramlist_id Number;

Line 377: FROM TABLE(CAST(p_number_array AS BSC_NUM_LIST)) t) AND

373: BA.RESPONSIBILITY_ID = p_resp_id AND
374: BA.INDICATOR IN (
375: SELECT
376: t.COLUMN_VALUE
377: FROM TABLE(CAST(p_number_array AS BSC_NUM_LIST)) t) AND
378: BA.INDICATOR = BK.INDICATOR AND
379: BTI.INDICATOR = BK.INDICATOR AND
380: BTA.TAB_ID = BTI.TAB_ID AND
381: BTA.RESPONSIBILITY_ID = BA.RESPONSIBILITY_ID AND

Line 441: p_number_array IN BSC_NUM_LIST

437: p_plug_id IN NUMBER,
438: p_resp_id IN NUMBER,
439: p_last_update_date IN DATE,
440: p_last_updated_by IN NUMBER,
441: p_number_array IN BSC_NUM_LIST
442: ) IS
443:
444:
445:

Line 477: FROM TABLE(CAST(p_number_array AS BSC_NUM_LIST)) t) AND

473: BA.RESPONSIBILITY_ID = p_resp_id AND
474: BA.INDICATOR IN (
475: SELECT
476: t.COLUMN_VALUE
477: FROM TABLE(CAST(p_number_array AS BSC_NUM_LIST)) t) AND
478: BA.INDICATOR = BK.INDICATOR AND
479: BTI.INDICATOR = BK.INDICATOR AND
480: BTA.TAB_ID = BTI.TAB_ID AND
481: BTA.RESPONSIBILITY_ID = BA.RESPONSIBILITY_ID AND

Line 522: p_number_array IN BSC_NUM_LIST,

518: p_kpi_measure_details_flag IN NUMBER,
519: p_createy_by IN NUMBER,
520: p_last_updated_by IN NUMBER,
521: p_porlet_name IN VARCHAR2,
522: p_number_array IN BSC_NUM_LIST,
523: p_o_ret_status OUT NOCOPY NUMBER) RETURN VARCHAR2 IS
524:
525: insert_err EXCEPTION;
526: update_err EXCEPTION;