APPS.BIS_CORRECTIVE_ACTION_PVT dependencies on BIS_TARGET_PUB

Line 209: ( p_target_Owners_rec IN BIS_TARGET_PUB.Target_Owners_Rec_Type

205: , p_comparison_result IN VARCHAR2
206: ) RETURN VARCHAR2 ;
207:
208: PROCEDURE Get_Result_Owners
209: ( p_target_Owners_rec IN BIS_TARGET_PUB.Target_Owners_Rec_Type
210: , p_comparison_result IN VARCHAR2
211: , x_owners_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
212: , x_owners_sh_nm_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
213: , x_number_out_of_range OUT NOCOPY NUMBER

Line 358: l_target_rec BIS_TARGET_PUB.Target_rec_type;

354: l_alert_details VARCHAR2(32000);
355: l_alert_details1 VARCHAR2(32000);
356: l_label VARCHAR2(32000);
357: l_label1 VARCHAR2(32000);
358: l_target_rec BIS_TARGET_PUB.Target_rec_type;
359: l_actual_rec BIS_ACTUAL_PUB.Actual_rec_type;
360: l_actual_rec1 BIS_ACTUAL_PUB.Actual_rec_type; -- 2164190 sashaik
361: l_dimension_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
362: l_dim_level_value_rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;

Line 1397: l_Target_owners_rec BIS_TARGET_PUB.Target_Owners_Rec_Type;

1393: IS
1394:
1395: l_Param_Set_Rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
1396: l_Param_Set_Tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
1397: l_Target_owners_rec BIS_TARGET_PUB.Target_Owners_Rec_Type;
1398: l_Alert_recipients_tbl BIS_UTILITIES_PUB.BIS_VARCHAR_TBL;
1399: l_Alert_recipients_sh_nm_tbl BIS_UTILITIES_PUB.BIS_VARCHAR_TBL;
1400: l_notifiers_code VARCHAR2(32000);
1401: l_user_tbl wf_directory.UserTable;

Line 1517: ( p_target_Owners_rec IN BIS_TARGET_PUB.Target_Owners_Rec_Type

1513: BIS_UTILITIES_PUB.put_line(p_text =>'exception at Get_Alert_Recipients: '||sqlerrm);
1514: END Get_Alert_Recipients;
1515:
1516: PROCEDURE Get_Result_Owners
1517: ( p_target_Owners_rec IN BIS_TARGET_PUB.Target_Owners_Rec_Type
1518: , p_comparison_result IN VARCHAR2
1519: , x_owners_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
1520: , x_owners_sh_nm_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
1521: , x_number_out_of_range OUT NOCOPY NUMBER

Line 1595: l_target_rec BIS_TARGET_PUB.Target_Rec_Type;

1591: )
1592: IS
1593:
1594: l_target_level_rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
1595: l_target_rec BIS_TARGET_PUB.Target_Rec_Type;
1596:
1597: l_message_tbl BIS_UTILITIES_PUB.BIS_VARCHAR_TBL;
1598: l_Message_Banner_tbl BIS_UTILITIES_PUB.BIS_VARCHAR_TBL;
1599: l_Message_Intro_tbl BIS_UTILITIES_PUB.BIS_VARCHAR_TBL;