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.BIS_PMF_REG_SERVICE_PVT dependencies on BIS_TARGET_PUB

Line 178: ( p_Target_tbl IN BIS_TARGET_PUB.Target_Tbl_type

174: , x_param_set_tbl_diff OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
175: );
176:
177: Procedure Get_current_Target
178: ( p_Target_tbl IN BIS_TARGET_PUB.Target_Tbl_type
179: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_rec_Type
180: --, p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
181: , x_target_tbl IN OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type
182: , x_return_status OUT NOCOPY VARCHAR2

Line 181: , x_target_tbl IN OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type

177: Procedure Get_current_Target
178: ( p_Target_tbl IN BIS_TARGET_PUB.Target_Tbl_type
179: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_rec_Type
180: --, p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
181: , x_target_tbl IN OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type
182: , x_return_status OUT NOCOPY VARCHAR2
183: );
184:
185: Procedure Get_Previous_Target

Line 186: ( p_Target_tbl IN BIS_TARGET_PUB.Target_Tbl_type

182: , x_return_status OUT NOCOPY VARCHAR2
183: );
184:
185: Procedure Get_Previous_Target
186: ( p_Target_tbl IN BIS_TARGET_PUB.Target_Tbl_type
187: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_rec_Type
188: , x_target_tbl IN OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type
189: , x_return_status OUT NOCOPY VARCHAR2
190: );

Line 188: , x_target_tbl IN OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type

184:
185: Procedure Get_Previous_Target
186: ( p_Target_tbl IN BIS_TARGET_PUB.Target_Tbl_type
187: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_rec_Type
188: , x_target_tbl IN OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type
189: , x_return_status OUT NOCOPY VARCHAR2
190: );
191:
192:

Line 194: ( p_Target_tbl IN BIS_TARGET_PUB.Target_Tbl_type

190: );
191:
192:
193: Procedure update_total_time
194: ( p_Target_tbl IN BIS_TARGET_PUB.Target_Tbl_type
195: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_rec_Type
196: --, p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
197: , x_target_tbl IN OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type
198: , x_return_status OUT NOCOPY VARCHAR2

Line 197: , x_target_tbl IN OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type

193: Procedure update_total_time
194: ( p_Target_tbl IN BIS_TARGET_PUB.Target_Tbl_type
195: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_rec_Type
196: --, p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
197: , x_target_tbl IN OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type
198: , x_return_status OUT NOCOPY VARCHAR2
199: );
200:
201: --

Line 224: , x_target_tbl OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type

220: ,p_parameter7_level IN varchar2 default null
221: ,p_parameter7_value IN varchar2 default null
222: , p_viewby_level_id IN varchar2 default null
223: , x_target_level_tbl OUT NOCOPY BIS_TARGET_LEVEL_PUB.Target_Level_Tbl_type
224: , x_target_tbl OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type
225: , x_return_status OUT NOCOPY VARCHAR2
226: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
227: );
228:

Line 306: ( p_Target_rec IN BIS_Target_PUB.Target_Rec_Type

302: , x_Target_Level_rec OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type
303: );
304:
305: PROCEDURE Verify_Target
306: ( p_Target_rec IN BIS_Target_PUB.Target_Rec_Type
307: , p_parameter1_value IN varchar2 default null
308: , p_parameter2_value IN varchar2 default null
309: , p_parameter3_value IN varchar2 default null
310: , p_parameter4_value IN varchar2 default null

Line 314: , x_Target_rec OUT NOCOPY BIS_Target_PUB.Target_Rec_Type

310: , p_parameter4_value IN varchar2 default null
311: , p_parameter5_value IN varchar2 default null
312: , p_parameter6_value IN varchar2 default null
313: , p_parameter7_value IN varchar2 default null
314: , x_Target_rec OUT NOCOPY BIS_Target_PUB.Target_Rec_Type
315: );
316:
317: FUNCTION has_Dimension_Levels
318: ( p_Target_Level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type

Line 331: ( p_Target_rec IN BIS_Target_PUB.Target_Rec_Type

327: )
328: RETURN BOOLEAN;
329:
330: FUNCTION has_Dimension_Level_Values
331: ( p_Target_rec IN BIS_Target_PUB.Target_Rec_Type
332: , p_parameter1_value IN varchar2 default null
333: , p_parameter2_value IN varchar2 default null
334: , p_parameter3_value IN varchar2 default null
335: , p_parameter4_value IN varchar2 default null

Line 361: p_target_tbl IN BIS_TARGET_PUB.target_tbl_type

357: RETURN BOOLEAN;
358:
359: --
360: PROCEDURE filter_duplicates (
361: p_target_tbl IN BIS_TARGET_PUB.target_tbl_type
362: ,x_target_tbl OUT NOCOPY BIS_TARGET_PUB.target_tbl_type
363: );
364:
365: --

Line 362: ,x_target_tbl OUT NOCOPY BIS_TARGET_PUB.target_tbl_type

358:
359: --
360: PROCEDURE filter_duplicates (
361: p_target_tbl IN BIS_TARGET_PUB.target_tbl_type
362: ,x_target_tbl OUT NOCOPY BIS_TARGET_PUB.target_tbl_type
363: );
364:
365: --
366: PROCEDURE filter_alert_based_on (

Line 367: p_target_tbl IN BIS_TARGET_PUB.target_tbl_type

363: );
364:
365: --
366: PROCEDURE filter_alert_based_on (
367: p_target_tbl IN BIS_TARGET_PUB.target_tbl_type
368: ,p_alert_based_on IN VARCHAR2
369: ,x_target_tbl OUT NOCOPY BIS_TARGET_PUB.target_tbl_type
370: ,x_return_status OUT NOCOPY VARCHAR2
371: ) ;

Line 369: ,x_target_tbl OUT NOCOPY BIS_TARGET_PUB.target_tbl_type

365: --
366: PROCEDURE filter_alert_based_on (
367: p_target_tbl IN BIS_TARGET_PUB.target_tbl_type
368: ,p_alert_based_on IN VARCHAR2
369: ,x_target_tbl OUT NOCOPY BIS_TARGET_PUB.target_tbl_type
370: ,x_return_status OUT NOCOPY VARCHAR2
371: ) ;
372:
373: --

Line 827: l_target_tbl BIS_TARGET_PUB.Target_Tbl_type;

823: IS
824:
825: l_param_set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
826: l_param_set_tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
827: l_target_tbl BIS_TARGET_PUB.Target_Tbl_type;
828: l_return_status VARCHAR2(1000);
829: l_request_scheduled VARCHAR2(1000);
830: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
831: l_api_version NUMBER := 1;

Line 1211: l_target_tbl BIS_TARGET_PUB.Target_Tbl_type;

1207: , x_request_id OUT NOCOPY varchar2
1208: )
1209: IS
1210:
1211: l_target_tbl BIS_TARGET_PUB.Target_Tbl_type;
1212: l_target_level_tbl BIS_TARGET_LEVEL_PUB.Target_Level_Tbl_type;
1213: l_dimension_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
1214: l_Alert_Request_rec BIS_ALERT_SERVICE_PVT.Alert_Request_rec_Type;
1215: l_Alert_Request_tbl BIS_ALERT_SERVICE_PVT.Alert_Request_tbl_Type;

Line 1423: l_target_tbl BIS_TARGET_PUB.Target_Tbl_type;

1419: l_notifiers_code VARCHAR2(32000);
1420: l_request_id VARCHAR2(32000);
1421: l_param_set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
1422: l_param_set_tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
1423: l_target_tbl BIS_TARGET_PUB.Target_Tbl_type;
1424: l_report_data_tbl report_data_tbl_type;
1425: l_return_status VARCHAR2(1000);
1426: l_request_scheduled VARCHAR2(1000);
1427: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 1683: , x_target_tbl OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type

1679: , p_measure_id IN NUMBER
1680: , p_time_dimension_level_id IN NUMBER
1681: , p_current_row IN VARCHAR2 := NULL
1682: , p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
1683: , x_target_tbl OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type
1684: , x_return_status OUT NOCOPY VARCHAR2
1685: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1686: )
1687: IS

Line 1691: l_target_tbl_tmp BIS_TARGET_PUB.Target_Tbl_type;

1687: IS
1688:
1689: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
1690: l_Target_Level_tbl BIS_Target_Level_PUB.Target_Level_Tbl_Type;
1691: l_target_tbl_tmp BIS_TARGET_PUB.Target_Tbl_type;
1692: l_target_tbl BIS_TARGET_PUB.Target_Tbl_type;
1693: l_Indicator_Region_Tbl BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
1694:
1695: l_target_count NUMBER := 1;

Line 1692: l_target_tbl BIS_TARGET_PUB.Target_Tbl_type;

1688:
1689: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
1690: l_Target_Level_tbl BIS_Target_Level_PUB.Target_Level_Tbl_Type;
1691: l_target_tbl_tmp BIS_TARGET_PUB.Target_Tbl_type;
1692: l_target_tbl BIS_TARGET_PUB.Target_Tbl_type;
1693: l_Indicator_Region_Tbl BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
1694:
1695: l_target_count NUMBER := 1;
1696: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

Line 1703: l_target_tbl_tmp_p BIS_TARGET_PUB.Target_Tbl_type;

1699: l_time_short_name VARCHAR2(32000);
1700: l_total_time_level_short VARCHAR2(32000);
1701: l_is_total_time BOOLEAN := FALSE;
1702: l_Is_Rolling_Period_Level NUMBER := 0; -- bug 2408906
1703: l_target_tbl_tmp_p BIS_TARGET_PUB.Target_Tbl_type;
1704: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1705: l_flag BOOLEAN := FALSE;
1706: c_num NUMBER := -9999;
1707: c_var VARCHAR2(5) := '-9999';

Line 1800: BIS_TARGET_PUB.Retrieve_targets

1796:
1797: BIS_UTILITIES_PUB.put_line(p_text => ' --------~~~~~~~~~~~~~~~~~~~~~~~~~~~~~-------- ' );
1798: BIS_UTILITIES_PUB.put_line(p_text => ' Begin Retrieving targets from bis_target_values ' );
1799:
1800: BIS_TARGET_PUB.Retrieve_targets
1801: ( p_api_version => p_api_version
1802: , p_Target_Level_Rec => l_Target_Level_tbl(i)
1803: , p_all_info => FND_API.G_FALSE
1804: , x_Target_tbl => l_Target_tbl_tmp

Line 1863: l_Target_tbl_tmp(l_target_count).is_pm_region := BIS_TARGET_PUB.G_IS_PM_REGION; -- indicates it is a PM region entry

1859: l_Target_tbl_tmp(l_target_count).Dim6_Level_Value_ID :=
1860: l_Indicator_Region_Tbl(j).Dim6_Level_Value_ID;
1861: l_Target_tbl_tmp(l_target_count).Dim7_Level_Value_ID :=
1862: l_Indicator_Region_Tbl(j).Dim7_Level_Value_ID;
1863: l_Target_tbl_tmp(l_target_count).is_pm_region := BIS_TARGET_PUB.G_IS_PM_REGION; -- indicates it is a PM region entry
1864: END IF;
1865: END LOOP;
1866:
1867: BIS_UTILITIES_PUB.put_line(p_text => ' End Retrieving targets from bis_user_ind_selections ' );

Line 1979: p_target_tbl IN BIS_TARGET_PUB.target_tbl_type

1975: -- Since time dimension level value gets added in get_current_target/get_previous_target for PM region values
1976: -- it needs to be checked for duplicates again
1977:
1978: PROCEDURE filter_duplicates (
1979: p_target_tbl IN BIS_TARGET_PUB.target_tbl_type
1980: ,x_target_tbl OUT NOCOPY BIS_TARGET_PUB.target_tbl_type
1981: )
1982: IS
1983: l_found BOOLEAN := FALSE;

Line 1980: ,x_target_tbl OUT NOCOPY BIS_TARGET_PUB.target_tbl_type

1976: -- it needs to be checked for duplicates again
1977:
1978: PROCEDURE filter_duplicates (
1979: p_target_tbl IN BIS_TARGET_PUB.target_tbl_type
1980: ,x_target_tbl OUT NOCOPY BIS_TARGET_PUB.target_tbl_type
1981: )
1982: IS
1983: l_found BOOLEAN := FALSE;
1984: l_count NUMBER := 0;

Line 2024: p_target_tbl IN BIS_TARGET_PUB.target_tbl_type

2020: -- If the alert is to be target based, then the "Change based" alerts should be filtered out
2021: -- and vice-versa, since the input table to this method contains all the targets set (change/target based) for a measure.
2022: --
2023: PROCEDURE filter_alert_based_on (
2024: p_target_tbl IN BIS_TARGET_PUB.target_tbl_type
2025: ,p_alert_based_on IN VARCHAR2
2026: ,x_target_tbl OUT NOCOPY BIS_TARGET_PUB.target_tbl_type
2027: ,x_return_status OUT NOCOPY VARCHAR2
2028: )

Line 2026: ,x_target_tbl OUT NOCOPY BIS_TARGET_PUB.target_tbl_type

2022: --
2023: PROCEDURE filter_alert_based_on (
2024: p_target_tbl IN BIS_TARGET_PUB.target_tbl_type
2025: ,p_alert_based_on IN VARCHAR2
2026: ,x_target_tbl OUT NOCOPY BIS_TARGET_PUB.target_tbl_type
2027: ,x_return_status OUT NOCOPY VARCHAR2
2028: )
2029: IS
2030: l_count NUMBER := 0;

Line 2034: IF (p_target_tbl(i).is_pm_region = BIS_TARGET_PUB.G_IS_PM_REGION) THEN

2030: l_count NUMBER := 0;
2031: BEGIN
2032:
2033: FOR i IN p_target_tbl.FIRST .. p_target_tbl.LAST LOOP
2034: IF (p_target_tbl(i).is_pm_region = BIS_TARGET_PUB.G_IS_PM_REGION) THEN
2035: l_count := x_target_tbl.COUNT + 1;
2036: x_target_tbl(l_count) := p_target_tbl(i);
2037: ELSIF ( (p_alert_based_on = BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET) AND (p_target_tbl(i).target IS NOT NULL) ) THEN
2038: l_count := x_target_tbl.COUNT + 1;

Line 2061: , x_target_tbl OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type

2057: , p_target_level_id IN NUMBER
2058: , p_time_dimension_level_id IN NUMBER := NULL
2059: , p_current_row IN VARCHAR2 := NULL
2060: --, p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
2061: , x_target_tbl OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type
2062: , x_return_status OUT NOCOPY VARCHAR2
2063: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2064: )
2065: IS

Line 2068: l_target_tbl_tmp BIS_TARGET_PUB.Target_Tbl_type;

2064: )
2065: IS
2066:
2067: l_Target_Level_rec BIS_Target_Level_PUB.Target_Level_rec_Type;
2068: l_target_tbl_tmp BIS_TARGET_PUB.Target_Tbl_type;
2069: l_target_tbl BIS_TARGET_PUB.Target_Tbl_type;
2070: l_target_count NUMBER := 0;
2071: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
2072: l_dimension_level_number NUMBER;

Line 2069: l_target_tbl BIS_TARGET_PUB.Target_Tbl_type;

2065: IS
2066:
2067: l_Target_Level_rec BIS_Target_Level_PUB.Target_Level_rec_Type;
2068: l_target_tbl_tmp BIS_TARGET_PUB.Target_Tbl_type;
2069: l_target_tbl BIS_TARGET_PUB.Target_Tbl_type;
2070: l_target_count NUMBER := 0;
2071: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
2072: l_dimension_level_number NUMBER;
2073: l_current_row VARCHAR2(10);

Line 2076: l_Target_tbl_tmp_p BIS_TARGET_PUB.Target_Tbl_type;

2072: l_dimension_level_number NUMBER;
2073: l_current_row VARCHAR2(10);
2074: l_Target_Level_rec_p BIS_Target_Level_PUB.Target_Level_rec_Type;
2075: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2076: l_Target_tbl_tmp_p BIS_TARGET_PUB.Target_Tbl_type;
2077: Begin
2078:
2079: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieving target information 0002.'
2080: ||' , target level id: '||p_target_level_id

Line 2118: BIS_TARGET_PUB.Retrieve_targets

2114: IF p_time_dimension_level_id IS NULL
2115: OR l_Dimension_Level_Rec.dimension_level_id = p_time_dimension_level_id
2116: THEN
2117:
2118: BIS_TARGET_PUB.Retrieve_targets
2119: ( p_api_version => p_api_version
2120: , p_Target_Level_Rec => l_Target_Level_rec
2121: , p_all_info => FND_API.G_FALSE
2122: , x_Target_tbl => l_Target_tbl_tmp

Line 2194: ( p_Target_tbl IN BIS_TARGET_PUB.Target_Tbl_type

2190: End Retrieve_target_info;
2191:
2192:
2193: Procedure Get_Previous_Target
2194: ( p_Target_tbl IN BIS_TARGET_PUB.Target_Tbl_type
2195: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_rec_Type
2196: , x_target_tbl IN OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type
2197: , x_return_status OUT NOCOPY VARCHAR2
2198: )

Line 2196: , x_target_tbl IN OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type

2192:
2193: Procedure Get_Previous_Target
2194: ( p_Target_tbl IN BIS_TARGET_PUB.Target_Tbl_type
2195: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_rec_Type
2196: , x_target_tbl IN OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type
2197: , x_return_status OUT NOCOPY VARCHAR2
2198: )
2199: IS
2200:

Line 2201: l_target_tbl BIS_TARGET_PUB.Target_Tbl_type;

2197: , x_return_status OUT NOCOPY VARCHAR2
2198: )
2199: IS
2200:
2201: l_target_tbl BIS_TARGET_PUB.Target_Tbl_type;
2202: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
2203: l_dimension_level_number NUMBER;
2204: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2205: l_time_id VARCHAR2(80);

Line 2278: ELSIF (p_target_tbl(j).is_pm_region = BIS_TARGET_PUB.G_IS_PM_REGION) THEN -- see Get_Current_Target

2274: ||l_Dim_Level_Value_Rec.Dimension_Level_value_id );
2275: */
2276:
2277: l_target_tbl(l_target_tbl.COUNT+1) := p_target_tbl(j);
2278: ELSIF (p_target_tbl(j).is_pm_region = BIS_TARGET_PUB.G_IS_PM_REGION) THEN -- see Get_Current_Target
2279:
2280: -- BIS_UTILITIES_PUB.put_line(p_text => ' BISVARSB: this time level value is NOT PREVIOUS time period ' ) ;
2281:
2282: if BIS_UTILITIES_PUB.Value_Missing(p_Target_tbl(j).target) = FND_API.G_TRUE

Line 2334: ( p_Target_tbl IN BIS_TARGET_PUB.Target_Tbl_type

2330:
2331:
2332:
2333: Procedure Get_Current_Target
2334: ( p_Target_tbl IN BIS_TARGET_PUB.Target_Tbl_type
2335: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_rec_Type
2336: --, p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
2337: , x_target_tbl IN OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type
2338: , x_return_status OUT NOCOPY VARCHAR2

Line 2337: , x_target_tbl IN OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type

2333: Procedure Get_Current_Target
2334: ( p_Target_tbl IN BIS_TARGET_PUB.Target_Tbl_type
2335: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_rec_Type
2336: --, p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
2337: , x_target_tbl IN OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type
2338: , x_return_status OUT NOCOPY VARCHAR2
2339: )
2340: IS
2341:

Line 2342: l_target_tbl BIS_TARGET_PUB.Target_Tbl_type;

2338: , x_return_status OUT NOCOPY VARCHAR2
2339: )
2340: IS
2341:
2342: l_target_tbl BIS_TARGET_PUB.Target_Tbl_type;
2343: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
2344: l_dimension_level_number NUMBER;
2345: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2346: l_time_id VARCHAR2(80);

Line 2426: ELSIF (p_target_tbl(j).is_pm_region = BIS_TARGET_PUB.G_IS_PM_REGION) THEN

2422: l_target_tbl(l_target_tbl.COUNT+1) := p_target_tbl(j);
2423:
2424: -- The condition below, with targets missing, to be used to identify pm region entries will not be satisfied
2425: -- for "set targets" anymore after change based alerting (bug# 3148615) since change does not have targets-only tolerance
2426: ELSIF (p_target_tbl(j).is_pm_region = BIS_TARGET_PUB.G_IS_PM_REGION) THEN
2427:
2428: -- BIS_UTILITIES_PUB.put_line(p_text => ' This time period is not in current period ' ) ;
2429:
2430: -- Following step is for the records retrieved

Line 2487: ( p_Target_tbl IN BIS_TARGET_PUB.Target_Tbl_type

2483:
2484:
2485:
2486: Procedure update_total_time
2487: ( p_Target_tbl IN BIS_TARGET_PUB.Target_Tbl_type
2488: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_rec_Type
2489: --, p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
2490: , x_target_tbl IN OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type
2491: , x_return_status OUT NOCOPY VARCHAR2

Line 2490: , x_target_tbl IN OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type

2486: Procedure update_total_time
2487: ( p_Target_tbl IN BIS_TARGET_PUB.Target_Tbl_type
2488: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_rec_Type
2489: --, p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
2490: , x_target_tbl IN OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type
2491: , x_return_status OUT NOCOPY VARCHAR2
2492: )
2493: IS
2494:

Line 2495: l_target_tbl BIS_TARGET_PUB.Target_Tbl_type;

2491: , x_return_status OUT NOCOPY VARCHAR2
2492: )
2493: IS
2494:
2495: l_target_tbl BIS_TARGET_PUB.Target_Tbl_type;
2496: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
2497: l_dimension_level_number NUMBER;
2498: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2499: l_time_id VARCHAR2(80);

Line 2529: IF ( (p_Target_tbl(j).is_pm_region = BIS_TARGET_PUB.G_IS_PM_REGION) AND

2525: l_time_id := -1;
2526: BIS_UTILITIES_PUB.put_line(p_text =>'OLTP Total Time ');
2527: end if;
2528: -- Explained in Get_Current_Target() above.
2529: IF ( (p_Target_tbl(j).is_pm_region = BIS_TARGET_PUB.G_IS_PM_REGION) AND
2530: ((BIS_UTILITIES_PUB.Value_Missing(p_Target_tbl(j).target) = FND_API.G_TRUE) OR (BIS_UTILITIES_PUB.Value_NULL(p_Target_tbl(j).target)= FND_API.G_TRUE)) ) THEN
2531:
2532: l_target_count := l_target_tbl.COUNT+1;
2533:

Line 2867: , x_target_tbl OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type

2863: , p_parameter7_level IN varchar2 default null
2864: , p_parameter7_value IN varchar2 default null
2865: , p_viewby_level_id IN varchar2 default null
2866: , x_target_level_tbl OUT NOCOPY BIS_TARGET_LEVEL_PUB.Target_Level_Tbl_type
2867: , x_target_tbl OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type
2868: , x_return_status OUT NOCOPY VARCHAR2
2869: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2870: )
2871: IS

Line 2877: l_target_tbl BIS_TARGET_PUB.Target_Tbl_type;

2873: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
2874: l_Target_Level_tbl BIS_Target_Level_PUB.Target_Level_Tbl_Type;
2875: l_Target_Level_rec BIS_Target_Level_PUB.Target_Level_rec_Type;
2876: l_Target_Level_tbl_tmp BIS_Target_Level_PUB.Target_Level_Tbl_Type;
2877: l_target_tbl BIS_TARGET_PUB.Target_Tbl_type;
2878: l_target_rec BIS_TARGET_PUB.Target_rec_type;
2879: l_target_tbl_tmp BIS_TARGET_PUB.Target_Tbl_type;
2880: l_return_status VARCHAR2(32000);
2881: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 2878: l_target_rec BIS_TARGET_PUB.Target_rec_type;

2874: l_Target_Level_tbl BIS_Target_Level_PUB.Target_Level_Tbl_Type;
2875: l_Target_Level_rec BIS_Target_Level_PUB.Target_Level_rec_Type;
2876: l_Target_Level_tbl_tmp BIS_Target_Level_PUB.Target_Level_Tbl_Type;
2877: l_target_tbl BIS_TARGET_PUB.Target_Tbl_type;
2878: l_target_rec BIS_TARGET_PUB.Target_rec_type;
2879: l_target_tbl_tmp BIS_TARGET_PUB.Target_Tbl_type;
2880: l_return_status VARCHAR2(32000);
2881: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2882: l_param_set_tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;

Line 2879: l_target_tbl_tmp BIS_TARGET_PUB.Target_Tbl_type;

2875: l_Target_Level_rec BIS_Target_Level_PUB.Target_Level_rec_Type;
2876: l_Target_Level_tbl_tmp BIS_Target_Level_PUB.Target_Level_Tbl_Type;
2877: l_target_tbl BIS_TARGET_PUB.Target_Tbl_type;
2878: l_target_rec BIS_TARGET_PUB.Target_rec_type;
2879: l_target_tbl_tmp BIS_TARGET_PUB.Target_Tbl_type;
2880: l_return_status VARCHAR2(32000);
2881: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2882: l_param_set_tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
2883:

Line 3251: , p_target_tbl IN BIS_TARGET_PUB.Target_Tbl_type

3247:
3248: PROCEDURE Form_Parameter_Set
3249: ( p_measure_id IN NUMBER
3250: , p_time_level_id IN NUMBER := NULL
3251: , p_target_tbl IN BIS_TARGET_PUB.Target_Tbl_type
3252: , p_Notifiers_Code IN VARCHAR2 := NULL
3253: , x_parameter_set_tbl OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
3254: )
3255: IS

Line 3534: ( p_Target_rec IN BIS_Target_PUB.Target_Rec_Type

3530:
3531: END Verify_Target_Level;
3532:
3533: PROCEDURE Verify_Target
3534: ( p_Target_rec IN BIS_Target_PUB.Target_Rec_Type
3535: , p_parameter1_value IN varchar2 default null
3536: , p_parameter2_value IN varchar2 default null
3537: , p_parameter3_value IN varchar2 default null
3538: , p_parameter4_value IN varchar2 default null

Line 3542: , x_Target_rec OUT NOCOPY BIS_Target_PUB.Target_Rec_Type

3538: , p_parameter4_value IN varchar2 default null
3539: , p_parameter5_value IN varchar2 default null
3540: , p_parameter6_value IN varchar2 default null
3541: , p_parameter7_value IN varchar2 default null
3542: , x_Target_rec OUT NOCOPY BIS_Target_PUB.Target_Rec_Type
3543: )
3544: IS
3545:
3546: l_Target_rec BIS_Target_PUB.Target_Rec_Type;

Line 3546: l_Target_rec BIS_Target_PUB.Target_Rec_Type;

3542: , x_Target_rec OUT NOCOPY BIS_Target_PUB.Target_Rec_Type
3543: )
3544: IS
3545:
3546: l_Target_rec BIS_Target_PUB.Target_Rec_Type;
3547:
3548: BEGIN
3549:
3550: IF has_Dimension_Level_Values

Line 3695: ( p_Target_rec IN BIS_Target_PUB.Target_Rec_Type

3691:
3692: END check_View_by;
3693:
3694: FUNCTION has_Dimension_Level_Values
3695: ( p_Target_rec IN BIS_Target_PUB.Target_Rec_Type
3696: , p_parameter1_value IN varchar2 default null
3697: , p_parameter2_value IN varchar2 default null
3698: , p_parameter3_value IN varchar2 default null
3699: , p_parameter4_value IN varchar2 default null