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_BIS_PMDLDR_DELDATA dependencies on BSC_APPS

Line 33: BSC_APPS.Add_Value_Big_In_Cond( 3, name );

29:
30: PROCEDURE ADD_TABLE(name varchar2)
31: IS
32: BEGIN
33: BSC_APPS.Add_Value_Big_In_Cond( 3, name );
34: G_TABNAME_TABLE_SIZE := G_TABNAME_TABLE_SIZE + 1;
35: G_TABNAME_TABLE(G_TABNAME_TABLE_SIZE).name := name;
36:
37: END;

Line 43: l_dummy := BSC_APPS.Get_New_Big_In_Cond_Varchar2( 4, 'TABLE_NAME');

39: PROCEDURE REFRESH_BSC_TMP_BIG_IN_COND
40: IS
41: l_dummy varchar2(2000);
42: BEGIN
43: l_dummy := BSC_APPS.Get_New_Big_In_Cond_Varchar2( 4, 'TABLE_NAME');
44:
45: For i in 1..G_TABNAME_TABLE_SIZE
46: loop
47: BSC_APPS.Add_Value_Big_In_Cond( 4, G_TABNAME_TABLE(i).name );

Line 47: BSC_APPS.Add_Value_Big_In_Cond( 4, G_TABNAME_TABLE(i).name );

43: l_dummy := BSC_APPS.Get_New_Big_In_Cond_Varchar2( 4, 'TABLE_NAME');
44:
45: For i in 1..G_TABNAME_TABLE_SIZE
46: loop
47: BSC_APPS.Add_Value_Big_In_Cond( 4, G_TABNAME_TABLE(i).name );
48: end loop;
49: --debug('Refreshed ' || G_TABNAME_TABLE_SIZE || ' to temp' );
50: G_TABNAME_TABLE.delete;
51: G_TABNAME_TABLE_SIZE := 0;

Line 90: BSC_APPS.Init_Bsc_Apps;

86: BEGIN
87: G_KPI_TABLE_SIZE := 0;
88: G_KPI_TABLE.delete;
89:
90: BSC_APPS.Init_Bsc_Apps;
91: BSC_APPS.Init_Big_In_Cond_Table;
92:
93: G_TABNAME_TABLE_SIZE := 0;
94: G_TABNAME_TABLE.delete;

Line 91: BSC_APPS.Init_Big_In_Cond_Table;

87: G_KPI_TABLE_SIZE := 0;
88: G_KPI_TABLE.delete;
89:
90: BSC_APPS.Init_Bsc_Apps;
91: BSC_APPS.Init_Big_In_Cond_Table;
92:
93: G_TABNAME_TABLE_SIZE := 0;
94: G_TABNAME_TABLE.delete;
95:

Line 238: l_stmtWhereInIndics:= BSC_APPS.Get_New_Big_In_Cond_Number( 5, 'INDICATOR');

234: cur_kpi_mark curType;
235: l_rownum number := 0;
236: BEGIN
237: --l_stmtWhereInTables := substr(l_stmtWhereInTables, instr(l_stmtWhereInTables, 'IN') + 2 );
238: l_stmtWhereInIndics:= BSC_APPS.Get_New_Big_In_Cond_Number( 5, 'INDICATOR');
239:
240: l_stmtNotWhereInIndics := substr(p_stmtWhereInIndics, instr(p_stmtWhereInIndics, ' IN') + 3 );
241: l_stmt :=
242: 'SELECT DISTINCT INDICATOR ' ||

Line 252: BSC_APPS.Add_Value_Big_In_Cond( 5, l_kpi );

248: open cur_kpi_mark for l_stmt;
249: loop
250: FETCH cur_kpi_mark INTO l_kpi;
251: exit when cur_kpi_mark%NOTFOUND;
252: BSC_APPS.Add_Value_Big_In_Cond( 5, l_kpi );
253:
254: end loop;
255: close cur_kpi_mark;
256: END;

Line 268: l_stmtWhereInIndics:= BSC_APPS.Get_New_Big_In_Cond_Number( 1, 'INDICATOR');

264: l_rownum number :=0;
265: l_rowmarked number;
266: l_rec_level number := 0 ;
267: BEGIN
268: l_stmtWhereInIndics:= BSC_APPS.Get_New_Big_In_Cond_Number( 1, 'INDICATOR');
269: l_stmtWhereInTables := BSC_APPS.Get_New_Big_In_Cond_Varchar2( 3, 'TABLE_NAME');
270: l_stmtTempWhereInSrcTables := BSC_APPS.Get_New_Big_In_Cond_Varchar2( 4, 'SOURCE_TABLE_NAME');
271: l_stmtTempWhereInSTables := BSC_APPS.Get_New_Big_In_Cond_Varchar2( 4, 'TABLE_NAME');
272: l_stmtWhereInTables := substr(l_stmtWhereInTables, instr(l_stmtWhereInTables, 'IN') + 2 );

Line 269: l_stmtWhereInTables := BSC_APPS.Get_New_Big_In_Cond_Varchar2( 3, 'TABLE_NAME');

265: l_rowmarked number;
266: l_rec_level number := 0 ;
267: BEGIN
268: l_stmtWhereInIndics:= BSC_APPS.Get_New_Big_In_Cond_Number( 1, 'INDICATOR');
269: l_stmtWhereInTables := BSC_APPS.Get_New_Big_In_Cond_Varchar2( 3, 'TABLE_NAME');
270: l_stmtTempWhereInSrcTables := BSC_APPS.Get_New_Big_In_Cond_Varchar2( 4, 'SOURCE_TABLE_NAME');
271: l_stmtTempWhereInSTables := BSC_APPS.Get_New_Big_In_Cond_Varchar2( 4, 'TABLE_NAME');
272: l_stmtWhereInTables := substr(l_stmtWhereInTables, instr(l_stmtWhereInTables, 'IN') + 2 );
273:

Line 270: l_stmtTempWhereInSrcTables := BSC_APPS.Get_New_Big_In_Cond_Varchar2( 4, 'SOURCE_TABLE_NAME');

266: l_rec_level number := 0 ;
267: BEGIN
268: l_stmtWhereInIndics:= BSC_APPS.Get_New_Big_In_Cond_Number( 1, 'INDICATOR');
269: l_stmtWhereInTables := BSC_APPS.Get_New_Big_In_Cond_Varchar2( 3, 'TABLE_NAME');
270: l_stmtTempWhereInSrcTables := BSC_APPS.Get_New_Big_In_Cond_Varchar2( 4, 'SOURCE_TABLE_NAME');
271: l_stmtTempWhereInSTables := BSC_APPS.Get_New_Big_In_Cond_Varchar2( 4, 'TABLE_NAME');
272: l_stmtWhereInTables := substr(l_stmtWhereInTables, instr(l_stmtWhereInTables, 'IN') + 2 );
273:
274:

Line 271: l_stmtTempWhereInSTables := BSC_APPS.Get_New_Big_In_Cond_Varchar2( 4, 'TABLE_NAME');

267: BEGIN
268: l_stmtWhereInIndics:= BSC_APPS.Get_New_Big_In_Cond_Number( 1, 'INDICATOR');
269: l_stmtWhereInTables := BSC_APPS.Get_New_Big_In_Cond_Varchar2( 3, 'TABLE_NAME');
270: l_stmtTempWhereInSrcTables := BSC_APPS.Get_New_Big_In_Cond_Varchar2( 4, 'SOURCE_TABLE_NAME');
271: l_stmtTempWhereInSTables := BSC_APPS.Get_New_Big_In_Cond_Varchar2( 4, 'TABLE_NAME');
272: l_stmtWhereInTables := substr(l_stmtWhereInTables, instr(l_stmtWhereInTables, 'IN') + 2 );
273:
274:
275: debug('l_stmtWhereInIndics '||l_stmtWhereInIndics);

Line 282: BSC_APPS.Add_Value_Big_In_Cond(1, G_KPI_TABLE(i).indicator);

278: debug('l_stmtTempWhereInSTables ' || l_stmtTempWhereInSTables);
279:
280: For i in 1..G_KPI_TABLE_SIZE
281: loop
282: BSC_APPS.Add_Value_Big_In_Cond(1, G_KPI_TABLE(i).indicator);
283: -- debug('Fetched ' || G_KPI_TABLE(i).indicator || ' to BSC_TMP_BIG_IN_COND' );
284: end loop;
285: l_rownum := INIT_RELATED_TABLES( l_stmtWhereInIndics);
286: