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

Line 48: -- Init BSC/APPS global variables

44: h_bind_vars_values BSC_UPDATE_UTIL.t_array_of_number;
45: h_num_bind_vars NUMBER;
46:
47: BEGIN
48: -- Init BSC/APPS global variables
49: BSC_APPS.Init_Bsc_Apps;
50:
51: --Get all The Base periodicities
52: --OPEN c_base_per FOR c_base_per_sql USING 1, 1;

Line 49: BSC_APPS.Init_Bsc_Apps;

45: h_num_bind_vars NUMBER;
46:
47: BEGIN
48: -- Init BSC/APPS global variables
49: BSC_APPS.Init_Bsc_Apps;
50:
51: --Get all The Base periodicities
52: --OPEN c_base_per FOR c_base_per_sql USING 1, 1;
53: OPEN c_base_per(1, 1);

Line 167: IF NOT BSC_APPS.APPS_ENV THEN

163: h_do_it := FALSE;
164:
165: h_index_name := UPPER(x_index_name);
166:
167: IF NOT BSC_APPS.APPS_ENV THEN
168: -- Personal
169: --OPEN c_index FOR c_index_sql USING h_index_name;
170: OPEN c_index(h_index_name);
171: FETCH c_index INTO h_index;

Line 178: --OPEN c_index_apps FOR c_index_apps_sql USING h_index_name, BSC_APPS.BSC_APPS_SCHEMA;

174: END IF;
175: CLOSE c_index;
176: ELSE
177: -- APPS
178: --OPEN c_index_apps FOR c_index_apps_sql USING h_index_name, BSC_APPS.BSC_APPS_SCHEMA;
179: OPEN c_index_apps(h_index_name, BSC_APPS.BSC_APPS_SCHEMA);
180: FETCH c_index_apps INTO h_index;
181: IF c_index_apps%NOTFOUND THEN
182: h_do_it := TRUE;

Line 179: OPEN c_index_apps(h_index_name, BSC_APPS.BSC_APPS_SCHEMA);

175: CLOSE c_index;
176: ELSE
177: -- APPS
178: --OPEN c_index_apps FOR c_index_apps_sql USING h_index_name, BSC_APPS.BSC_APPS_SCHEMA;
179: OPEN c_index_apps(h_index_name, BSC_APPS.BSC_APPS_SCHEMA);
180: FETCH c_index_apps INTO h_index;
181: IF c_index_apps%NOTFOUND THEN
182: h_do_it := TRUE;
183: END IF;

Line 190: ') TABLESPACE '||BSC_APPS.Get_Tablespace_Name(x_tbs_type)||

186:
187: IF h_do_it THEN
188: h_sql := 'CREATE UNIQUE INDEX '||x_index_name||
189: ' ON '||x_table_name||' ('||x_lst_columns||
190: ') TABLESPACE '||BSC_APPS.Get_Tablespace_Name(x_tbs_type)||
191: ' '||BSC_APPS.bsc_storage_clause;
192: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_INDEX, x_index_name);
193: END IF;
194:

Line 191: ' '||BSC_APPS.bsc_storage_clause;

187: IF h_do_it THEN
188: h_sql := 'CREATE UNIQUE INDEX '||x_index_name||
189: ' ON '||x_table_name||' ('||x_lst_columns||
190: ') TABLESPACE '||BSC_APPS.Get_Tablespace_Name(x_tbs_type)||
191: ' '||BSC_APPS.bsc_storage_clause;
192: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_INDEX, x_index_name);
193: END IF;
194:
195: RETURN TRUE;

Line 192: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_INDEX, x_index_name);

188: h_sql := 'CREATE UNIQUE INDEX '||x_index_name||
189: ' ON '||x_table_name||' ('||x_lst_columns||
190: ') TABLESPACE '||BSC_APPS.Get_Tablespace_Name(x_tbs_type)||
191: ' '||BSC_APPS.bsc_storage_clause;
192: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_INDEX, x_index_name);
193: END IF;
194:
195: RETURN TRUE;
196:

Line 265: WHERE table_name = x_table_name AND owner = BSC_APPS.BSC_APPS_SCHEMA;

261:
262: SELECT COUNT(*)
263: INTO h_count
264: FROM all_tab_columns
265: WHERE table_name = x_table_name AND owner = BSC_APPS.BSC_APPS_SCHEMA;
266:
267: IF h_count = 0 THEN
268: -- table does not exists
269: h_create_it := TRUE;

Line 277: OPEN c_table_columns(x_table_name, BSC_APPS.BSC_APPS_SCHEMA);

273: h_drop_it := TRUE;
274: h_create_it := TRUE;
275: ELSE
276: h_i := 1;
277: OPEN c_table_columns(x_table_name, BSC_APPS.BSC_APPS_SCHEMA);
278: LOOP
279: FETCH c_table_columns INTO h_column_name, h_data_type, h_data_length, h_data_precision;
280: EXIT WHEN c_table_columns%NOTFOUND;
281: IF (UPPER(x_table_columns(h_i).column_name) <> h_column_name) OR

Line 298: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_TABLE, x_table_name);

294: END IF;
295:
296: IF h_drop_it THEN
297: h_sql := 'DROP TABLE '||x_table_name;
298: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_TABLE, x_table_name);
299: END IF;
300:
301: IF h_create_it THEN
302: h_lst_cols_desc := NULL;

Line 325: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_TABLE, x_table_name);

321: END LOOP;
322:
323: h_sql := 'CREATE GLOBAL TEMPORARY TABLE '||x_table_name||' ('||h_lst_cols_desc||
324: ') ON COMMIT PRESERVE ROWS';
325: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_TABLE, x_table_name);
326:
327: -- Create index
328: IF h_lst_cols_index IS NOT NULL THEN
329: h_index_name := x_table_name||'_N1';

Line 334: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_INDEX, h_index_name);

330: loop --modifed code for 4099338
331: begin
332: h_sql := 'CREATE INDEX '||h_index_name||
333: ' ON '||x_table_name||' ('||h_lst_cols_index||')';
334: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_INDEX, h_index_name);
335: exit;
336: exception
337: when others then
338: if h_lst_cols_index is null then

Line 368: WHERE index_name = h_index_name AND owner = BSC_APPS.BSC_APPS_SCHEMA;

364:
365: SELECT COUNT(*)
366: INTO h_count
367: FROM all_indexes
368: WHERE index_name = h_index_name AND owner = BSC_APPS.BSC_APPS_SCHEMA;
369:
370: IF h_count > 0 THEN
371: -- Index exist but it is not needed
372: h_sql := 'DROP INDEX '||h_index_name;

Line 373: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_INDEX, h_index_name);

369:
370: IF h_count > 0 THEN
371: -- Index exist but it is not needed
372: h_sql := 'DROP INDEX '||h_index_name;
373: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_INDEX, h_index_name);
374: END IF;
375: END IF;
376: END IF;
377:

Line 436: WHERE table_name = x_table_name AND owner = BSC_APPS.BSC_APPS_SCHEMA;

432:
433: SELECT COUNT(*)
434: INTO h_count
435: FROM all_tab_columns
436: WHERE table_name = x_table_name AND owner = BSC_APPS.BSC_APPS_SCHEMA;
437:
438: IF h_count = 0 THEN
439: -- table does not exists
440: h_create_it := TRUE;

Line 448: OPEN c_table_columns(x_table_name, BSC_APPS.BSC_APPS_SCHEMA);

444: h_drop_it := TRUE;
445: h_create_it := TRUE;
446: ELSE
447: h_i := 1;
448: OPEN c_table_columns(x_table_name, BSC_APPS.BSC_APPS_SCHEMA);
449: LOOP
450: FETCH c_table_columns INTO h_column_name, h_data_type, h_data_length, h_data_precision;
451: EXIT WHEN c_table_columns%NOTFOUND;
452: IF (UPPER(x_table_columns(h_i).column_name) <> h_column_name) OR

Line 469: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_TABLE, x_table_name);

465: END IF;
466:
467: IF h_drop_it THEN
468: h_sql := 'DROP TABLE '||x_table_name;
469: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_TABLE, x_table_name);
470: END IF;
471:
472: IF h_create_it THEN
473: h_lst_cols_desc := NULL;

Line 496: ' '||BSC_APPS.bsc_storage_clause;

492: END LOOP;
493:
494: h_sql := 'CREATE TABLE '||x_table_name||' ('||h_lst_cols_desc||')'||
495: ' TABLESPACE '||x_tablespace||
496: ' '||BSC_APPS.bsc_storage_clause;
497: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_TABLE, x_table_name);
498:
499: -- Create index
500: IF h_lst_cols_index IS NOT NULL THEN

Line 497: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_TABLE, x_table_name);

493:
494: h_sql := 'CREATE TABLE '||x_table_name||' ('||h_lst_cols_desc||')'||
495: ' TABLESPACE '||x_tablespace||
496: ' '||BSC_APPS.bsc_storage_clause;
497: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_TABLE, x_table_name);
498:
499: -- Create index
500: IF h_lst_cols_index IS NOT NULL THEN
501: h_index_name := x_table_name||'_N1';

Line 505: ' '||BSC_APPS.bsc_storage_clause;

501: h_index_name := x_table_name||'_N1';
502: h_sql := 'CREATE INDEX '||h_index_name||
503: ' ON '||x_table_name||' ('||h_lst_cols_index||')'||
504: ' TABLESPACE '||x_idx_tablespace||
505: ' '||BSC_APPS.bsc_storage_clause;
506: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_INDEX, h_index_name);
507: END IF;
508: END IF;
509:

Line 506: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_INDEX, h_index_name);

502: h_sql := 'CREATE INDEX '||h_index_name||
503: ' ON '||x_table_name||' ('||h_lst_cols_index||')'||
504: ' TABLESPACE '||x_idx_tablespace||
505: ' '||BSC_APPS.bsc_storage_clause;
506: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_INDEX, h_index_name);
507: END IF;
508: END IF;
509:
510: RETURN TRUE;

Line 624: c_index_apps t_cursor; -- x_index_name, BSC_APPS.BSC_APPS_SCHEMA

620: FROM user_indexes
621: WHERE index_name = p_index_name;
622:
623: /*
624: c_index_apps t_cursor; -- x_index_name, BSC_APPS.BSC_APPS_SCHEMA
625: c_index_apps_sql VARCHAR2(2000) := 'SELECT index_name'||
626: ' FROM all_indexes'||
627: ' WHERE index_name = :1 AND owner = :2';
628: */

Line 642: IF NOT BSC_APPS.APPS_ENV THEN

638: h_do_it := FALSE;
639:
640: h_index_name := UPPER(x_index_name);
641:
642: IF NOT BSC_APPS.APPS_ENV THEN
643: -- Personal
644: --OPEN c_index FOR c_index_sql USING h_index_name;
645: OPEN c_index(h_index_name);
646: FETCH c_index INTO h_index;

Line 653: --OPEN c_index_apps FOR c_index_apps_sql USING h_index_name, BSC_APPS.BSC_APPS_SCHEMA;

649: END IF;
650: CLOSE c_index;
651: ELSE
652: -- Personal
653: --OPEN c_index_apps FOR c_index_apps_sql USING h_index_name, BSC_APPS.BSC_APPS_SCHEMA;
654: OPEN c_index_apps(h_index_name, BSC_APPS.BSC_APPS_SCHEMA);
655: FETCH c_index_apps INTO h_index;
656: IF c_index_apps%FOUND THEN
657: h_do_it := TRUE;

Line 654: OPEN c_index_apps(h_index_name, BSC_APPS.BSC_APPS_SCHEMA);

650: CLOSE c_index;
651: ELSE
652: -- Personal
653: --OPEN c_index_apps FOR c_index_apps_sql USING h_index_name, BSC_APPS.BSC_APPS_SCHEMA;
654: OPEN c_index_apps(h_index_name, BSC_APPS.BSC_APPS_SCHEMA);
655: FETCH c_index_apps INTO h_index;
656: IF c_index_apps%FOUND THEN
657: h_do_it := TRUE;
658: END IF;

Line 664: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_INDEX, x_index_name);

660: END IF;
661:
662: IF h_do_it THEN
663: h_sql := 'DROP INDEX '||x_index_name;
664: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_INDEX, x_index_name);
665: END IF;
666:
667: RETURN TRUE;
668:

Line 693: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_TABLE, x_table_name);

689: -- Truncate table to release space --> Bug: DROP TABLE don't release the space immediately
690: Truncate_Table(x_table_name);
691:
692: h_sql := 'DROP TABLE '||x_table_name;
693: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_TABLE, x_table_name);
694: END IF;
695:
696: RETURN TRUE;
697:

Line 2760: IF BSC_APPS.CheckError('BSC_INTEGRATION_APIS.Get_Number_Of_Periods') THEN

2756:
2757: ELSE
2758: -- EDW periodicity
2759: h_num_periods := BSC_INTEGRATION_APIS.Get_Number_Of_Periods(x_current_fy, x_periodicity, h_calendar_id);
2760: IF BSC_APPS.CheckError('BSC_INTEGRATION_APIS.Get_Number_Of_Periods') THEN
2761: -- Error
2762: RETURN NULL;
2763: END IF;
2764:

Line 3516: -- BSC_APPS.other_index_tbs_type) THEN

3512: --IF NVL(x_action, 3) = 3 THEN
3513: -- IF NOT Create_Unique_Index('BSC_SYS_PERIODS_TL',
3514: -- 'BSC_SYS_PERIODS_TL_U1',
3515: -- 'YEAR, PERIODICITY_ID, PERIOD_ID, MONTH, LANGUAGE',
3516: -- BSC_APPS.other_index_tbs_type) THEN
3517: -- RAISE e_unexpected_error;
3518: -- END IF;
3519: -- COMMIT;
3520: --END IF;

Line 4549: -- Init BSC/APPS global variables

4545: e_error_load_rpt_cal EXCEPTION;
4546: h_error_message VARCHAR2(2000);
4547:
4548: BEGIN
4549: -- Init BSC/APPS global variables
4550: BSC_APPS.Init_Bsc_Apps;
4551:
4552: -- Init calendar tables
4553: IF NOT BSC_UPDATE_UTIL.Init_Calendar_Tables(x_calendar_id, x_action) THEN

Line 4550: BSC_APPS.Init_Bsc_Apps;

4546: h_error_message VARCHAR2(2000);
4547:
4548: BEGIN
4549: -- Init BSC/APPS global variables
4550: BSC_APPS.Init_Bsc_Apps;
4551:
4552: -- Init calendar tables
4553: IF NOT BSC_UPDATE_UTIL.Init_Calendar_Tables(x_calendar_id, x_action) THEN
4554: RAISE e_error;

Line 4560: IF BSC_APPS.bsc_mv THEN

4556:
4557: -- BSC_MV Note: Populate reporting calendar
4558: --Fix bug#3847656: We only need to call Load_Reporting_Calendar when x_action=2
4559: IF x_action = 2 THEN
4560: IF BSC_APPS.bsc_mv THEN
4561: --Fix bug#4027813: call reporting calendar onlyto process this calendar
4562: IF NOT BSC_BIA_WRAPPER.Load_Reporting_Calendar(x_calendar_id, h_error_message) THEN
4563: RAISE e_error_load_rpt_cal;
4564: END IF;

Line 4644: -- Init BSC/APPS global variables

4640: SAVEPOINT BscUpdateUtilPopCalTables;
4641: FND_MSG_PUB.Initialize;
4642: x_return_status := FND_API.G_RET_STS_SUCCESS;
4643:
4644: -- Init BSC/APPS global variables
4645: BSC_APPS.Init_Bsc_Apps;
4646:
4647: -- Init calendar tables
4648: IF NOT BSC_UPDATE_UTIL.Init_Calendar_Tables(p_calendar_id) THEN

Line 4645: BSC_APPS.Init_Bsc_Apps;

4641: FND_MSG_PUB.Initialize;
4642: x_return_status := FND_API.G_RET_STS_SUCCESS;
4643:
4644: -- Init BSC/APPS global variables
4645: BSC_APPS.Init_Bsc_Apps;
4646:
4647: -- Init calendar tables
4648: IF NOT BSC_UPDATE_UTIL.Init_Calendar_Tables(p_calendar_id) THEN
4649: RAISE e_error;

Line 4741: h_user_id := BSC_APPS.fnd_global_user_id;

4737:
4738: -- Ref: bug#3482442 In corner cases this query can return more than one
4739: -- row and it will fail. AUDSID is not PK. After meeting with
4740: -- Vinod and Kris and Venu, we should use FNG_GLOBAL.user_id
4741: h_user_id := BSC_APPS.fnd_global_user_id;
4742:
4743: /*
4744: h_sql := 'UPDATE bsc_sys_calendars_b'||
4745: ' SET fiscal_year = :1, last_updated_by = :2, last_update_date = SYSDATE'||

Line 4792: get_table_apps t_cursor; -- X_Table, BSC_APPS.BSC_APPS_SCHEMA

4788: FROM USER_TABLES
4789: WHERE table_name = p_table_name;
4790:
4791: /*
4792: get_table_apps t_cursor; -- X_Table, BSC_APPS.BSC_APPS_SCHEMA
4793: get_table_apps_sql VARCHAR2(2000) := 'SELECT table_name'||
4794: ' FROM ALL_TABLES'||
4795: ' WHERE table_name = :1'||
4796: ' AND owner = :2';

Line 4808: IF NOT BSC_APPS.APPS_ENV THEN

4804: h_table VARCHAR2(30);
4805: BEGIN
4806: h_table := UPPER(X_Table);
4807:
4808: IF NOT BSC_APPS.APPS_ENV THEN
4809: -- Personal
4810: --OPEN get_table FOR get_table_sql USING h_table;
4811: OPEN get_table(h_table);
4812: FETCH get_table INTO h_tbl;

Line 4820: --OPEN get_table_apps FOR get_table_apps_sql USING h_table, BSC_APPS.BSC_APPS_SCHEMA;

4816: END IF;
4817: CLOSE get_table;
4818: ELSE
4819: -- APPS
4820: --OPEN get_table_apps FOR get_table_apps_sql USING h_table, BSC_APPS.BSC_APPS_SCHEMA;
4821: OPEN get_table_apps(h_table, BSC_APPS.BSC_APPS_SCHEMA);
4822: FETCH get_table_apps INTO h_tbl;
4823: IF get_table_apps%NOTFOUND THEN
4824: CLOSE get_table_apps;

Line 4821: OPEN get_table_apps(h_table, BSC_APPS.BSC_APPS_SCHEMA);

4817: CLOSE get_table;
4818: ELSE
4819: -- APPS
4820: --OPEN get_table_apps FOR get_table_apps_sql USING h_table, BSC_APPS.BSC_APPS_SCHEMA;
4821: OPEN get_table_apps(h_table, BSC_APPS.BSC_APPS_SCHEMA);
4822: FETCH get_table_apps INTO h_tbl;
4823: IF get_table_apps%NOTFOUND THEN
4824: CLOSE get_table_apps;
4825: RETURN (FALSE);

Line 4912: h_bsc_schema := BSC_APPS.bsc_apps_schema;

4908: h_bsc_schema VARCHAR2(30);
4909:
4910: BEGIN
4911:
4912: h_bsc_schema := BSC_APPS.bsc_apps_schema;
4913: IF h_bsc_schema IS NOT NULL THEN
4914: h_bsc_schema := h_bsc_schema||'.';
4915: END IF;
4916:

Line 4972: -- Init BSC/APPS global variables

4968:
4969: h_sql VARCHAR2(32000);
4970:
4971: BEGIN
4972: -- Init BSC/APPS global variables
4973: BSC_APPS.Init_Bsc_Apps;
4974: --- Update the SOURCE columns
4975: --OPEN c_new_per FOR c_new_per_sql USING x_calendar_id, 1;
4976: OPEN c_new_per(x_calendar_id, 1);

Line 4973: BSC_APPS.Init_Bsc_Apps;

4969: h_sql VARCHAR2(32000);
4970:
4971: BEGIN
4972: -- Init BSC/APPS global variables
4973: BSC_APPS.Init_Bsc_Apps;
4974: --- Update the SOURCE columns
4975: --OPEN c_new_per FOR c_new_per_sql USING x_calendar_id, 1;
4976: OPEN c_new_per(x_calendar_id, 1);
4977: FETCH c_new_per INTO h_source;

Line 5192: h_user_id := BSC_APPS.fnd_global_user_id;

5188: BEGIN
5189: -- Ref: bug#3482442 In corner cases this query can return more than one
5190: -- row and it will fail. AUDSID is not PK. After meeting with
5191: -- Vinod and Kris and Venu, we should use FNG_GLOBAL.user_id
5192: h_user_id := BSC_APPS.fnd_global_user_id;
5193:
5194: /*
5195: h_sql := 'UPDATE bsc_kpis_b'||
5196: ' SET last_updated_by = :1,'||

Line 5241: h_user_id := BSC_APPS.fnd_global_user_id;

5237:
5238: -- Ref: bug#3482442 In corner cases this query can return more than one
5239: -- row and it will fail. AUDSID is not PK. After meeting with
5240: -- Vinod and Kris and Venu, we should use FNG_GLOBAL.user_id
5241: h_user_id := BSC_APPS.fnd_global_user_id;
5242:
5243: h_sql := 'UPDATE bsc_kpis_b'||
5244: ' SET last_updated_by = :1, last_update_date = SYSDATE'||
5245: ' WHERE '||x_condition;

Line 5282: h_user_id := BSC_APPS.fnd_global_user_id;

5278:
5279: -- Ref: bug#3482442 In corner cases this query can return more than one
5280: -- row and it will fail. AUDSID is not PK. After meeting with
5281: -- Vinod and Kris and Venu, we should use FNG_GLOBAL.user_id
5282: h_user_id := BSC_APPS.fnd_global_user_id;
5283:
5284: /*
5285: h_sql := 'UPDATE bsc_tabs_b'||
5286: ' SET last_updated_by = :1,'||

Line 5337: h_user_id := BSC_APPS.fnd_global_user_id;

5333:
5334: -- Ref: bug#3482442 In corner cases this query can return more than one
5335: -- row and it will fail. AUDSID is not PK. After meeting with
5336: -- Vinod and Kris and Venu, we should use FNG_GLOBAL.user_id
5337: h_user_id := BSC_APPS.fnd_global_user_id;
5338:
5339: h_sql := 'UPDATE bsc_tabs_b'||
5340: ' SET last_updated_by = :1, last_update_date = SYSDATE'||
5341: ' WHERE tab_id IN ('||

Line 5378: h_user_id := BSC_APPS.fnd_global_user_id;

5374:
5375: -- Ref: bug#3482442 In corner cases this query can return more than one
5376: -- row and it will fail. AUDSID is not PK. After meeting with
5377: -- Vinod and Kris and Venu, we should use FNG_GLOBAL.user_id
5378: h_user_id := BSC_APPS.fnd_global_user_id;
5379:
5380: /*
5381: h_sql := 'UPDATE bsc_kpis_b'||
5382: ' SET last_updated_by = :1,'||

Line 5428: h_user_id := BSC_APPS.fnd_global_user_id;

5424:
5425: -- Ref: bug#3482442 In corner cases this query can return more than one
5426: -- row and it will fail. AUDSID is not PK. After meeting with
5427: -- Vinod and Kris and Venu, we should use FNG_GLOBAL.user_id
5428: h_user_id := BSC_APPS.fnd_global_user_id;
5429:
5430: /*
5431: h_sql := 'UPDATE bsc_sys_init'||
5432: ' SET last_updated_by = :1,'||

Line 5945: h_user_id := BSC_APPS.fnd_global_user_id;

5941:
5942: -- Ref: bug#3482442 In corner cases this query can return more than one
5943: -- row and it will fail. AUDSID is not PK. After meeting with
5944: -- Vinod and Kris and Venu, we should use FNG_GLOBAL.user_id
5945: h_user_id := BSC_APPS.fnd_global_user_id;
5946:
5947: /*
5948: h_sql := 'UPDATE bsc_sys_init'||
5949: ' SET property_value = :1,'||

Line 6260: NVL(BSC_APPS.Get_Property_Value(m1.s_color_formula, 'pFormulaSource'), m1.measure_col) || ')' ||

6256: )
6257: RETURN VARCHAR2 IS
6258: CURSOR c_measure_formula(p_indicator NUMBER, p_kpi_measure_id NUMBER) IS
6259: SELECT m1.operation || '(' ||
6260: NVL(BSC_APPS.Get_Property_Value(m1.s_color_formula, 'pFormulaSource'), m1.measure_col) || ')' ||
6261: ds.operation ||
6262: DECODE(ds.measure_id2,
6263: NULL, NULL,
6264: m2.operation || '(' || NVL(BSC_APPS.Get_Property_Value(m2.s_color_formula, 'pFormulaSource'), m2.measure_col) || ')' ) measure_formula

Line 6264: m2.operation || '(' || NVL(BSC_APPS.Get_Property_Value(m2.s_color_formula, 'pFormulaSource'), m2.measure_col) || ')' ) measure_formula

6260: NVL(BSC_APPS.Get_Property_Value(m1.s_color_formula, 'pFormulaSource'), m1.measure_col) || ')' ||
6261: ds.operation ||
6262: DECODE(ds.measure_id2,
6263: NULL, NULL,
6264: m2.operation || '(' || NVL(BSC_APPS.Get_Property_Value(m2.s_color_formula, 'pFormulaSource'), m2.measure_col) || ')' ) measure_formula
6265: FROM bsc_tab_indicators tab_ind,
6266: bsc_kpi_analysis_measures_b anal_meas,
6267: bsc_sys_datasets_b ds,
6268: bsc_sys_measures m1,