DBA Data[Home] [Help]

APPS.BIS_PMF_REG_SERVICE_PVT dependencies on BIS_DIMENSION_LEVEL_PUB

Line 356: (p_Dimension_Level_rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_rec_Type)

352: , viewByLevelNum OUT NOCOPY NUMBER
353: );
354:
355: FUNCTION is_time_level
356: (p_Dimension_Level_rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_rec_Type)
357: RETURN BOOLEAN;
358:
359: --
360: PROCEDURE filter_duplicates (

Line 414: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

410: IS
411:
412: l_report_data_tbl report_data_tbl_type;
413: l_target_level_rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
414: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
415: l_dimension_level_number NUMBER;
416: l_param_set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
417: l_param_set_tbl_new BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
418: l_param_set_tbl_orig BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;

Line 726: l_Dimension_Level_Tbl BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type;

722: )
723: IS
724:
725: l_time_level_id NUMBER := NULL;
726: l_Dimension_Level_Tbl BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type;
727: l_debug VARCHAR2(32000);
728: l_request_id VARCHAR2(32000);
729:
730: BEGIN

Line 974: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

970: )
971: IS
972:
973: l_target_level_rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
974: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
975: l_dimension_level_number NUMBER;
976: l_param_set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
977: l_param_set_tbl_new BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
978: l_param_set_tbl_orig BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;

Line 1213: l_dimension_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

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;
1216: l_Concurrent_Request_Tbl BIS_CONCURRENT_MANAGER_PVT.PMF_Request_Tbl_Type;
1217: l_return_status VARCHAR2(1000);

Line 1696: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_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;
1697: l_dimension_level_number NUMBER;
1698: l_time_level_short_name VARCHAR2(32000);
1699: l_time_short_name VARCHAR2(32000);
1700: l_total_time_level_short VARCHAR2(32000);

Line 2071: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

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);
2074: l_Target_Level_rec_p BIS_Target_Level_PUB.Target_Level_rec_Type;
2075: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 2663: l_dimension_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

2659: l_repeat_result VARCHAR2(32000);
2660: l_submit_result varchar2(32000);
2661: l_request_desc varchar2(32000);
2662: l_measure_rec BIS_MEASURE_PUB.measure_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;

Line 2672: l_dimension_level_rec_p BIS_DIMENSION_LEVEL_PUB.Dimension_Level_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;
2672: l_dimension_level_rec_p BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
2673:
2674: begin
2675:
2676: BIS_UTILITIES_PUB.put_line(p_text =>'Submitting detailed concurrent request');

Line 2697: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level

2693:
2694:
2695: l_dimension_level_rec.dimension_level_id := p_time_dimension_level_id ;
2696: l_dimension_level_rec_p := l_dimension_level_rec;
2697: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level
2698: ( p_api_version => 1.0
2699: , p_dimension_Level_Rec => l_dimension_level_rec_p
2700: , x_dimension_Level_rec => l_dimension_level_rec
2701: , x_return_status => l_return_status

Line 2828: l_dimension_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

2824: l_result BOOLEAN;
2825: l_request_desc varchar2(32000);
2826: l_user_name VARCHAR2(32000);
2827: l_measure_rec BIS_MEASURE_PUB.measure_rec_type;
2828: l_dimension_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
2829: l_return_status VARCHAR2(1000);
2830: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2831: l_api_version NUMBER := 1;
2832:

Line 3748: (p_Dimension_Level_rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_rec_Type)

3744:
3745: END has_Dimension_Level_Values;
3746:
3747: FUNCTION is_time_level
3748: (p_Dimension_Level_rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_rec_Type)
3749: RETURN BOOLEAN
3750:
3751: IS
3752: l_Dimension_Level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_rec_Type;

Line 3752: l_Dimension_Level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_rec_Type;

3748: (p_Dimension_Level_rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_rec_Type)
3749: RETURN BOOLEAN
3750:
3751: IS
3752: l_Dimension_Level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_rec_Type;
3753: l_return_status VARCHAR2(32000);
3754: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3755:
3756: BEGIN