DBA Data[Home] [Help]

APPS.BIS_PMF_REG_SERVICE_PVT dependencies on BIS_CONCURRENT_MANAGER_PVT

Line 37: , p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET

33: , p_session_id IN varchar2 default null
34: , p_alert_type IN varchar2 default null
35: , p_notify_owners_flag IN varchar2 default null
36: , p_current_row IN VARCHAR2 := 'N'
37: , p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
38: ) ;
39:
40: --
41: -- Procedure Which Accepts the parameters Performance measure

Line 58: ,p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET

54: ,p_session_id IN varchar2 default null
55: ,p_alert_type IN varchar2 default null
56: ,p_notify_owners_flag IN varchar2 default null
57: , p_current_row IN VARCHAR2 := 'N'
58: ,p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
59: );
60:
61: --
62: -- Procedure Which Accepts the parameters Performance measure

Line 180: --, p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET

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
183: );
184:

Line 196: --, p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET

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
199: );
200:

Line 244: , p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET

240: , p_time_dimension_level_id IN NUMBER default null
241: , p_session_id IN varchar2 default null
242: , p_current_row IN varchar2 default null
243: , p_alert_type IN varchar2 default null
244: , p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
245: );
246:
247: --
248: -- Helper routine which calls fnd_request APIs

Line 287: , p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET

283: , p_Measure_short_name IN VARCHAR2
284: , p_time_level_id IN NUMBER
285: , p_alert_type IN VARCHAR2
286: , p_current_row IN VARCHAR2
287: , p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
288: , x_Concurrent_Request_rec
289: OUT NOCOPY BIS_CONCURRENT_MANAGER_PVT.PMF_Request_rec_Type
290: );
291:

Line 289: OUT NOCOPY BIS_CONCURRENT_MANAGER_PVT.PMF_Request_rec_Type

285: , p_alert_type IN VARCHAR2
286: , p_current_row IN VARCHAR2
287: , p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
288: , x_Concurrent_Request_rec
289: OUT NOCOPY BIS_CONCURRENT_MANAGER_PVT.PMF_Request_rec_Type
290: );
291:
292: PROCEDURE Verify_Target_Level
293: ( p_Target_Level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type

Line 408: ,p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET

404: ,p_alert_type IN varchar2 default null
405: ,p_session_id IN varchar2 default null
406: ,p_notify_owners_flag IN varchar2 default null
407: , p_current_row IN VARCHAR2 := 'N'
408: ,p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
409: )
410: IS
411:
412: l_report_data_tbl report_data_tbl_type;

Line 443: l_alert_based_on := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET;

439: BEGIN
440:
441: l_alert_based_on := p_alert_based_on;
442: IF (l_alert_based_on IS NULL) THEN
443: l_alert_based_on := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET;
444: END IF;
445:
446: -- Debug messages should not be printed (irrespective of debug profile option).
447: bis_utilities_pvt.set_debug_log_flag ( -- 2715218

Line 721: , p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET

717: , p_session_id IN varchar2 default null
718: , p_alert_type IN varchar2 default null
719: , p_notify_owners_flag IN varchar2 default null
720: , p_current_row IN VARCHAR2 := 'N'
721: , p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
722: )
723: IS
724:
725: l_time_level_id NUMBER := NULL;

Line 821: ,p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET

817: ,p_session_id IN varchar2 default null
818: ,p_alert_type IN varchar2 default null
819: ,p_notify_owners_flag IN varchar2 default null
820: , p_current_row IN VARCHAR2 := 'N'
821: ,p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
822: )
823: IS
824:
825: l_param_set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;

Line 1216: l_Concurrent_Request_Tbl BIS_CONCURRENT_MANAGER_PVT.PMF_Request_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;
1216: l_Concurrent_Request_Tbl BIS_CONCURRENT_MANAGER_PVT.PMF_Request_Tbl_Type;
1217: l_return_status VARCHAR2(1000);
1218: l_request_id_tbl BIS_UTILITIES_PUB.BIS_VARCHAR_TBL;
1219: l_debug VARCHAR2(32000);
1220: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 1295: BIS_CONCURRENT_MANAGER_PVT.Submit_Concurrent_Request

1291: );
1292:
1293: BIS_UTILITIES_PUB.put_line(p_text =>'Submit concurrent requests for Detial Alert Service');
1294: --
1295: BIS_CONCURRENT_MANAGER_PVT.Submit_Concurrent_Request
1296: ( p_Concurrent_Request_Tbl => l_Concurrent_Request_Tbl
1297: , x_request_id_tbl => l_request_id_tbl
1298: , x_errbuf => l_errbuf
1299: , x_retcode => l_retcode

Line 1682: , p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET

1678: ( p_api_version IN NUMBER
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: )

Line 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

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;
2039: x_target_tbl(l_count) := p_target_tbl(i);
2040: ELSIF ( (p_alert_based_on = BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_CHANGE) AND (p_target_tbl(i).target IS NULL) ) THEN
2041: l_count := x_target_tbl.COUNT + 1;

Line 2040: ELSIF ( (p_alert_based_on = BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_CHANGE) AND (p_target_tbl(i).target IS NULL) ) THEN

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;
2039: x_target_tbl(l_count) := p_target_tbl(i);
2040: ELSIF ( (p_alert_based_on = BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_CHANGE) AND (p_target_tbl(i).target IS NULL) ) THEN
2041: l_count := x_target_tbl.COUNT + 1;
2042: x_target_tbl(l_count) := p_target_tbl(i);
2043: END IF;
2044: END LOOP;

Line 2060: --, p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET

2056: ( p_api_version IN NUMBER
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: )

Line 2336: --, p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET

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
2339: )
2340: IS

Line 2489: --, p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET

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
2492: )
2493: IS

Line 2655: , p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET

2651: , p_time_dimension_level_id IN NUMBER default null
2652: , p_session_id IN varchar2 default null
2653: , p_current_row IN varchar2 default null
2654: , p_alert_type IN varchar2 default null
2655: , p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
2656: )
2657: IS
2658: l_request_id VARCHAR2(32000);
2659: l_repeat_result VARCHAR2(32000);

Line 2667: l_Concurrent_Request_rec BIS_CONCURRENT_MANAGER_PVT.PMF_Request_rec_Type;

2663: l_dimension_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
2664: l_return_status VARCHAR2(1000);
2665: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2666: l_api_version NUMBER := 1;
2667: l_Concurrent_Request_rec BIS_CONCURRENT_MANAGER_PVT.PMF_Request_rec_Type;
2668: ERRBUF VARCHAR2(32000);
2669: RETCODE VARCHAR2(32000);
2670: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
2671: l_measure_rec_p BIS_MEASURE_PUB.measure_rec_type;

Line 2720: BIS_CONCURRENT_MANAGER_PVT.Set_Repeat_Options

2716: , l_repeat_interval
2717: , l_repeat_unit);
2718: */
2719:
2720: BIS_CONCURRENT_MANAGER_PVT.Set_Repeat_Options
2721: ( p_repeat_interval => p_frequencyInterval
2722: , p_repeat_units => p_frequencyUnits
2723: , P_Start_time => p_StartTime
2724: , P_end_time => p_EndTime

Line 2754: BIS_CONCURRENT_MANAGER_PVT.Submit_Concurrent_Request

2750: );
2751:
2752: BIS_UTILITIES_PUB.put_line(p_text =>'Submit concurrent requests for Detail Alert Service');
2753: --
2754: BIS_CONCURRENT_MANAGER_PVT.Submit_Concurrent_Request
2755: ( p_Concurrent_Request_rec => l_Concurrent_Request_rec
2756: , x_request_id => l_request_id
2757: , x_errbuf => ERRBUF
2758: , x_retcode => RETCODE

Line 3025: , p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET

3021: , p_Measure_short_name IN VARCHAR2
3022: , p_time_level_id IN NUMBER
3023: , p_alert_type IN VARCHAR2
3024: , p_current_row IN VARCHAR2
3025: , p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
3026: , x_Concurrent_Request_rec
3027: OUT NOCOPY BIS_CONCURRENT_MANAGER_PVT.PMF_Request_rec_Type
3028: )
3029: IS

Line 3027: OUT NOCOPY BIS_CONCURRENT_MANAGER_PVT.PMF_Request_rec_Type

3023: , p_alert_type IN VARCHAR2
3024: , p_current_row IN VARCHAR2
3025: , p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
3026: , x_Concurrent_Request_rec
3027: OUT NOCOPY BIS_CONCURRENT_MANAGER_PVT.PMF_Request_rec_Type
3028: )
3029: IS
3030:
3031: l_Concurrent_Request_rec

Line 3032: BIS_CONCURRENT_MANAGER_PVT.PMF_Request_rec_Type;

3028: )
3029: IS
3030:
3031: l_Concurrent_Request_rec
3032: BIS_CONCURRENT_MANAGER_PVT.PMF_Request_rec_Type;
3033:
3034: BEGIN
3035:
3036: l_Concurrent_Request_rec := x_Concurrent_Request_rec;

Line 3042: := BIS_CONCURRENT_MANAGER_PVT.G_ALERT_PROGRAM;

3038:
3039: l_Concurrent_Request_rec.application_short_name
3040: := BIS_UTILITIES_PVT.G_BIS_APPLICATION_SHORT_NAME;
3041: l_Concurrent_Request_rec.program
3042: := BIS_CONCURRENT_MANAGER_PVT.G_ALERT_PROGRAM;
3043: l_Concurrent_Request_rec.start_time := p_start_time;
3044: l_Concurrent_Request_rec.description := p_request_desc;
3045:
3046: l_Concurrent_Request_rec.argument1 := p_measure_id;