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_COLOR dependencies on BIS_PMV_PAGE_PARAMETER_REC

Line 783: h_aw_limit_rec BIS_PMV_PAGE_PARAMETER_REC;

779: h_sql_stmt VARCHAR2(32700);
780:
781: --AW_INTEGRATION: new variables
782: h_aw_limit_tbl BIS_PMV_PAGE_PARAMETER_TBL;
783: h_aw_limit_rec BIS_PMV_PAGE_PARAMETER_REC;
784: h_calendar_id NUMBER;
785: h_min_per NUMBER;
786: h_max_per NUMBER;
787: h_per_parameter_value VARCHAR2(100);

Line 904: h_aw_limit_rec := BIS_PMV_PAGE_PARAMETER_REC(null,null,null,null,null,null);

900: IF x_aw_flag THEN
901: -- limit TYPE with 0 and 1
902: -- Fix bug#4574713: package become invalid after bis team added a new property in this record
903: -- actually we do not need this call
904: h_aw_limit_rec := BIS_PMV_PAGE_PARAMETER_REC(null,null,null,null,null,null);
905: h_aw_limit_rec.parameter_name := 'TYPE';
906: h_aw_limit_rec.parameter_value := '0';
907: h_aw_limit_rec.dimension := 'DIMENSION';
908: h_aw_limit_tbl.extend;

Line 911: h_aw_limit_rec := BIS_PMV_PAGE_PARAMETER_REC(null,null,null,null,null,null);

907: h_aw_limit_rec.dimension := 'DIMENSION';
908: h_aw_limit_tbl.extend;
909: h_aw_limit_tbl(h_aw_limit_tbl.LAST) := h_aw_limit_rec;
910:
911: h_aw_limit_rec := BIS_PMV_PAGE_PARAMETER_REC(null,null,null,null,null,null);
912: h_aw_limit_rec.parameter_name := 'TYPE';
913: h_aw_limit_rec.parameter_value := '1';
914: h_aw_limit_rec.dimension := 'DIMENSION';
915: h_aw_limit_tbl.extend;

Line 940: h_aw_limit_rec := BIS_PMV_PAGE_PARAMETER_REC(null,null,null,null,null,null);

936:
937: h_per_parameter_value := h_min_per||'.'||x_current_fy||' TO '||
938: h_max_per||'.'||x_current_fy;
939: END IF;
940: h_aw_limit_rec := BIS_PMV_PAGE_PARAMETER_REC(null,null,null,null,null,null);
941: h_aw_limit_rec.parameter_name := x_periodicity_id;
942: h_aw_limit_rec.parameter_value := h_per_parameter_value;
943: h_aw_limit_rec.dimension := 'PERIODICITY';
944: h_aw_limit_tbl.extend;

Line 953: h_aw_limit_rec := BIS_PMV_PAGE_PARAMETER_REC(null,null,null,null,null,null);

949: OPEN c_table_columns(h_table_name, h_column_type);
950: LOOP
951: FETCH c_table_columns INTO h_column_name;
952: EXIT WHEN c_table_columns%NOTFOUND;
953: h_aw_limit_rec := BIS_PMV_PAGE_PARAMETER_REC(null,null,null,null,null,null);
954: h_aw_limit_rec.parameter_name := h_column_name;
955: h_aw_limit_rec.dimension := 'MEASURE';
956: h_aw_limit_tbl.extend;
957: h_aw_limit_tbl(h_aw_limit_tbl.LAST) := h_aw_limit_rec;

Line 2452: h_aw_limit_rec BIS_PMV_PAGE_PARAMETER_REC;

2448:
2449: h_key_value NUMBER;
2450:
2451: --AW_INTEGRATION: new variables
2452: h_aw_limit_rec BIS_PMV_PAGE_PARAMETER_REC;
2453:
2454: BEGIN
2455: h_column_type_p := 'P';
2456:

Line 2499: h_aw_limit_rec := BIS_PMV_PAGE_PARAMETER_REC(null,null,null,null,null,null);

2495: x_bind_vars_values(x_num_bind_vars) := h_pl_profit_account;
2496:
2497: --AW_INTEGRATION: This is to limit the dimension before querying the view.
2498: IF x_aw_flag THEN
2499: h_aw_limit_rec := BIS_PMV_PAGE_PARAMETER_REC(null,null,null,null,null,null);
2500: h_aw_limit_rec.parameter_name := BSC_UPDATE_UTIL.Get_Dim_Level_Table_Name(x_comp_level_pk_col);
2501: h_aw_limit_rec.parameter_value := h_pl_profit_account;
2502: h_aw_limit_rec.dimension := 'DIMENSION';
2503: x_aw_limit_tbl.extend;

Line 2535: h_aw_limit_rec := BIS_PMV_PAGE_PARAMETER_REC(null,null,null,null,null,null);

2531: END IF;
2532:
2533: --AW_INTEGRATION: Add all the values (including 0 code) of this dimension to the limit table
2534: IF x_aw_flag THEN
2535: h_aw_limit_rec := BIS_PMV_PAGE_PARAMETER_REC(null,null,null,null,null,null);
2536: h_aw_limit_rec.parameter_name := BSC_UPDATE_UTIL.Get_Dim_Level_Table_Name(h_table_key);
2537: h_aw_limit_rec.parameter_value := '^ALL';
2538: h_aw_limit_rec.dimension := 'DIMENSION';
2539: x_aw_limit_tbl.extend;

Line 2562: h_aw_limit_rec := BIS_PMV_PAGE_PARAMETER_REC(null,null,null,null,null,null);

2558: x_bind_vars_values(x_num_bind_vars) := '0';
2559:
2560: --AW_INTEGRATION: Add all the values of this dimension (including 0 code) to the limit table
2561: IF x_aw_flag THEN
2562: h_aw_limit_rec := BIS_PMV_PAGE_PARAMETER_REC(null,null,null,null,null,null);
2563: h_aw_limit_rec.parameter_name := BSC_UPDATE_UTIL.Get_Dim_Level_Table_Name(h_table_key);
2564: h_aw_limit_rec.parameter_value := '^ALL';
2565: h_aw_limit_rec.dimension := 'DIMENSION';
2566: x_aw_limit_tbl.extend;

Line 2581: h_aw_limit_rec := BIS_PMV_PAGE_PARAMETER_REC(null,null,null,null,null,null);

2577: x_bind_vars_values(x_num_bind_vars) := h_default_key_value;
2578:
2579: --AW_INTEGRATION: Add this key item to the limit table
2580: IF x_aw_flag THEN
2581: h_aw_limit_rec := BIS_PMV_PAGE_PARAMETER_REC(null,null,null,null,null,null);
2582: h_aw_limit_rec.parameter_name := BSC_UPDATE_UTIL.Get_Dim_Level_Table_Name(h_table_key);
2583: h_aw_limit_rec.parameter_value := h_default_key_value;
2584: h_aw_limit_rec.dimension := 'DIMENSION';
2585: x_aw_limit_tbl.extend;

Line 2606: h_aw_limit_rec := BIS_PMV_PAGE_PARAMETER_REC(null,null,null,null,null,null);

2602: x_bind_vars_values(x_num_bind_vars) := '0';
2603:
2604: -- AW_INTEGRATION: Add to the limit table
2605: IF x_aw_flag THEN
2606: h_aw_limit_rec := BIS_PMV_PAGE_PARAMETER_REC(null,null,null,null,null,null);
2607: h_aw_limit_rec.parameter_name := BSC_UPDATE_UTIL.Get_Dim_Level_Table_Name(h_table_key);
2608: h_aw_limit_rec.parameter_value := '0';
2609: h_aw_limit_rec.dimension := 'DIMENSION';
2610: x_aw_limit_tbl.extend;