DBA Data[Home] [Help]

APPS.BIS_PMF_REG_SERVICE_PVT dependencies on BIS_PMF_ALERT_REG_PUB

Line 171: ( p_param_set_tbl_orig IN BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type

167: -- added to the diff table. all rows (including new) is put into
168: -- all table.
169: --
170: PROCEDURE Compare_param_sets
171: ( p_param_set_tbl_orig IN BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
172: , p_param_set_tbl_new IN BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
173: , x_param_set_tbl_all OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
174: , x_param_set_tbl_diff OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
175: );

Line 172: , p_param_set_tbl_new IN BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type

168: -- all table.
169: --
170: PROCEDURE Compare_param_sets
171: ( p_param_set_tbl_orig IN BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
172: , p_param_set_tbl_new IN BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
173: , x_param_set_tbl_all OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
174: , x_param_set_tbl_diff OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
175: );
176:

Line 173: , x_param_set_tbl_all OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type

169: --
170: PROCEDURE Compare_param_sets
171: ( p_param_set_tbl_orig IN BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
172: , p_param_set_tbl_new IN BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
173: , x_param_set_tbl_all OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_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

Line 174: , x_param_set_tbl_diff OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type

170: PROCEDURE Compare_param_sets
171: ( p_param_set_tbl_orig IN BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
172: , p_param_set_tbl_new IN BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
173: , x_param_set_tbl_all OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_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

Line 274: ( p_Param_Set_rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type

270: );
271:
272:
273: PROCEDURE Add_Subscribers
274: ( p_Param_Set_rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
275: , x_request_id OUT NOCOPY varchar2
276: , x_return_status OUT NOCOPY varchar2
277: );
278:

Line 416: l_param_set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;

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;
419: l_param_set_tbl_all BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
420: l_param_set_tbl_diff BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;

Line 417: l_param_set_tbl_new BIS_PMF_ALERT_REG_PUB.parameter_set_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;
419: l_param_set_tbl_all BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
420: l_param_set_tbl_diff BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
421:

Line 418: l_param_set_tbl_orig BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_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;
419: l_param_set_tbl_all BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
420: l_param_set_tbl_diff BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
421:
422: l_target_level_id NUMBER;

Line 419: l_param_set_tbl_all BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_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;
419: l_param_set_tbl_all BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
420: l_param_set_tbl_diff BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
421:
422: l_target_level_id NUMBER;
423: l_notify_owners_flag VARCHAR2(100);

Line 420: l_param_set_tbl_diff BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;

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;
419: l_param_set_tbl_all BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
420: l_param_set_tbl_diff BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
421:
422: l_target_level_id NUMBER;
423: l_notify_owners_flag VARCHAR2(100);
424: -- l_user_id VARCHAR2(100);

Line 825: l_param_set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;

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;
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);

Line 826: l_param_set_tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;

822: )
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;

Line 976: l_param_set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;

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;
979: l_param_set_tbl_all BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
980: l_param_set_tbl_diff BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;

Line 977: l_param_set_tbl_new BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;

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;
979: l_param_set_tbl_all BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
980: l_param_set_tbl_diff BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
981:

Line 978: l_param_set_tbl_orig BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_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;
979: l_param_set_tbl_all BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
980: l_param_set_tbl_diff BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
981:
982: l_target_level_id NUMBER;

Line 979: l_param_set_tbl_all BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_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;
979: l_param_set_tbl_all BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
980: l_param_set_tbl_diff BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
981:
982: l_target_level_id NUMBER;
983: l_notify_owners_flag VARCHAR2(100);

Line 980: l_param_set_tbl_diff BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;

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;
979: l_param_set_tbl_all BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
980: l_param_set_tbl_diff BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
981:
982: l_target_level_id NUMBER;
983: l_notify_owners_flag VARCHAR2(100);
984: -- l_user_id VARCHAR2(100);

Line 1421: l_param_set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;

1417: )
1418: IS
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);

Line 1422: l_param_set_tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;

1418: IS
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);

Line 1499: , p_Param_Set_Rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type

1495: -- registration repository and invoke the submit request procedure
1496: --
1497: PROCEDURE Register_Parameter_Set
1498: ( p_api_version IN NUMBER
1499: , p_Param_Set_Rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
1500: , p_session_id IN varchar2 default null
1501: , p_alert_type IN varchar2 default null
1502: , p_request_id OUT NOCOPY varchar2
1503: , x_return_status OUT NOCOPY VARCHAR2

Line 1514: l_Param_Set_Rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;

1510: l_request_id VARCHAR2(32000);
1511: l_debug VARCHAR2(32000);
1512: l_notifiers_code VARCHAR2(32000);
1513: l_commit VARCHAR2(32000) := FND_API.G_TRUE;
1514: l_Param_Set_Rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
1515: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1516:
1517: BEGIN
1518: /*

Line 1538: := BIS_PMF_ALERT_REG_PUB.Parameter_set_Exist

1534: -- Check whether there is a concurrent program exist for
1535: -- the given PM and time dimension level id
1536: --
1537: l_param_exist
1538: := BIS_PMF_ALERT_REG_PUB.Parameter_set_Exist
1539: ( p_api_version => p_api_version
1540: , p_Param_Set_Rec => p_Param_Set_Rec
1541: , x_notifiers_code => l_notifiers_code
1542: , x_return_status => x_return_status

Line 1563: BIS_PMF_ALERT_REG_PUB.Create_Parameter_set

1559: END IF;
1560:
1561: IF NOT l_param_exist THEN
1562: l_Param_Set_Rec := p_Param_Set_Rec;
1563: BIS_PMF_ALERT_REG_PUB.Create_Parameter_set
1564: ( p_api_version => p_api_version
1565: , p_commit => l_commit
1566: , p_Param_Set_Rec => l_Param_Set_Rec
1567: , x_return_status => x_return_status

Line 1609: ( p_Param_Set_rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type

1605: );
1606: End Register_Parameter_Set;
1607:
1608: PROCEDURE Add_Subscribers
1609: ( p_Param_Set_rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
1610: , x_request_id OUT NOCOPY varchar2
1611: , x_return_status OUT NOCOPY varchar2
1612: )
1613: IS

Line 2882: l_param_set_tbl BIS_PMF_ALERT_REG_PUB.parameter_set_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:
2884: BEGIN
2885:
2886: BIS_UTILITIES_PUB.put_line(p_text =>'retrieving report info');

Line 3115: ( p_param_set_tbl_orig IN BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type

3111: -- added to the diff table. all rows (including new) is put into
3112: -- all table.
3113: --
3114: PROCEDURE Compare_param_sets
3115: ( p_param_set_tbl_orig IN BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
3116: , p_param_set_tbl_new IN BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
3117: , x_param_set_tbl_all OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
3118: , x_param_set_tbl_diff OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
3119: )

Line 3116: , p_param_set_tbl_new IN BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type

3112: -- all table.
3113: --
3114: PROCEDURE Compare_param_sets
3115: ( p_param_set_tbl_orig IN BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
3116: , p_param_set_tbl_new IN BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
3117: , x_param_set_tbl_all OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
3118: , x_param_set_tbl_diff OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
3119: )
3120: IS

Line 3117: , x_param_set_tbl_all OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type

3113: --
3114: PROCEDURE Compare_param_sets
3115: ( p_param_set_tbl_orig IN BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
3116: , p_param_set_tbl_new IN BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
3117: , x_param_set_tbl_all OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
3118: , x_param_set_tbl_diff OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
3119: )
3120: IS
3121:

Line 3118: , x_param_set_tbl_diff OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type

3114: PROCEDURE Compare_param_sets
3115: ( p_param_set_tbl_orig IN BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
3116: , p_param_set_tbl_new IN BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
3117: , x_param_set_tbl_all OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
3118: , x_param_set_tbl_diff OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
3119: )
3120: IS
3121:
3122: l_param_set_rec_new BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;

Line 3122: l_param_set_rec_new BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;

3118: , x_param_set_tbl_diff OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
3119: )
3120: IS
3121:
3122: l_param_set_rec_new BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
3123: l_param_set_tbl_all BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
3124: l_param_set_tbl_diff BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
3125: in_orig BOOLEAN := FALSE;
3126:

Line 3123: l_param_set_tbl_all BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;

3119: )
3120: IS
3121:
3122: l_param_set_rec_new BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
3123: l_param_set_tbl_all BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
3124: l_param_set_tbl_diff BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
3125: in_orig BOOLEAN := FALSE;
3126:
3127: BEGIN

Line 3124: l_param_set_tbl_diff BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;

3120: IS
3121:
3122: l_param_set_rec_new BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
3123: l_param_set_tbl_all BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
3124: l_param_set_tbl_diff BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
3125: in_orig BOOLEAN := FALSE;
3126:
3127: BEGIN
3128:

Line 3253: , x_parameter_set_tbl OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type

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
3256:
3257: l_param_set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;

Line 3257: l_param_set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;

3253: , x_parameter_set_tbl OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
3254: )
3255: IS
3256:
3257: l_param_set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
3258: l_param_set_tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
3259: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3260: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
3261:

Line 3258: l_param_set_tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;

3254: )
3255: IS
3256:
3257: l_param_set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
3258: l_param_set_tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
3259: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3260: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
3261:
3262: BEGIN