APPS.BIS_SETUP_KPI_PKG dependencies on BIS_SETUP_KPI_PAGE

Line 112: execute immediate 'delete from BIS_SETUP_KPI_PAGE';

108: IF (g_populated = 'Y') THEN
109: --RETURN g_kpis_pages;
110: RETURN;
111: ELSE
112: execute immediate 'delete from BIS_SETUP_KPI_PAGE';
113: --IF (g_kpis_pages IS NOT NULL AND g_kpis_pages.COUNT > 0) THEN
114: -- g_kpis_pages.DELETE;
115: --END IF;
116: END IF;

Line 136: execute immediate 'insert into BIS_SETUP_KPI_PAGE values (:1, :2, :3, :4)'

132: IF (v_kpi.indicator_id IS NOT NULL) THEN
133: --v_page_kpi := t_bis_kpi_page_obj(v_page.page_name, v_page.page_internal_name, v_kpi.indicator_id, v_kpi.indicator_name);
134: --g_kpis_pages.extend;
135: --g_kpis_pages(g_kpis_pages.COUNT) := v_page_kpi;
136: execute immediate 'insert into BIS_SETUP_KPI_PAGE values (:1, :2, :3, :4)'
137: using v_page.page_name, v_page.page_internal_name,
138: v_kpi.indicator_id, v_kpi.indicator_name;
139:
140: --execute immediate 'insert into ywu_debug_bis_setup_kpi_page (:1, :2, :3, :4)'

Line 140: --execute immediate 'insert into ywu_debug_bis_setup_kpi_page (:1, :2, :3, :4)'

136: execute immediate 'insert into BIS_SETUP_KPI_PAGE values (:1, :2, :3, :4)'
137: using v_page.page_name, v_page.page_internal_name,
138: v_kpi.indicator_id, v_kpi.indicator_name;
139:
140: --execute immediate 'insert into ywu_debug_bis_setup_kpi_page (:1, :2, :3, :4)'
141: -- using v_page.page_name, v_page.page_internal_name,
142: -- v_kpi.indicator_id, v_kpi.indicator_name;
143: --COMMIT;
144: END IF;

Line 169: FROM bis_setup_kpi_page a,

165: IS
166: CURSOR c_pages_and_impl_flag(p_c_kpi_id NUMBER) IS
167: SELECT distinct b.IMPLEMENTATION_FLAG, a.page_name
168: --FROM TABLE(cast(getKpisAndPages AS t_bis_kpi_page_tab)) a,
169: FROM bis_setup_kpi_page a,
170: bis_obj_properties b
171: WHERE a.indicator_id = p_c_kpi_id
172: AND a.page_internal_name = b.object_name
173: AND b.object_type = 'PAGE';

Line 183: --initialize BIS_SETUP_KPI_PAGE

179: IF (p_kpi_id IS NULL) THEN
180: RETURN NULL;
181: END IF;
182:
183: --initialize BIS_SETUP_KPI_PAGE
184: --dbms_output.put_line('before calling getkpisandpages ');
185: --getkpisandpages;
186:
187: --dbms_output.put_line('after calling getkpisandpages ');

Line 234: FROM BIS_SETUP_KPI_PAGE

230: IS
231: CURSOR c_kpis(p_c_page_name VARCHAR2) IS
232: SELECT DISTINCT indicator_id, indicator_name
233: --FROM TABLE(cast(getKpisAndPages AS t_bis_kpi_page_tab))
234: FROM BIS_SETUP_KPI_PAGE
235: WHERE Upper(page_name) LIKE Upper(p_c_page_name);
236:
237: v_kpi t_bis_setup_kpi_obj := t_bis_setup_kpi_obj(-1, '');
238: v_ret_kpis t_bis_setup_kpi_tab := t_bis_setup_kpi_tab();

Line 250: --initialize BIS_SETUP_KPI_PAGE

246: --RETURN NULL;
247: RETURN;
248: END IF;
249:
250: --initialize BIS_SETUP_KPI_PAGE
251: --getkpisandpages;
252:
253: --dbms_output.put_line('before cleaning up BIS_SETUP_KPI');
254: -- clear up the global temporary table