157: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
158: )
159: IS
160: l_meas_rec BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type;
161: l_resp_rec BIS_Responsibility_PVT.Responsibility_rec_Type;
162: l_resp_rec_p BIS_Responsibility_PVT.Responsibility_rec_Type;
163:
164: cursor sec_cursor is
165: select RESPONSIBILITY_ID
158: )
159: IS
160: l_meas_rec BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type;
161: l_resp_rec BIS_Responsibility_PVT.Responsibility_rec_Type;
162: l_resp_rec_p BIS_Responsibility_PVT.Responsibility_rec_Type;
163:
164: cursor sec_cursor is
165: select RESPONSIBILITY_ID
166: from bis_indicator_resps
207: -- l_flag :=1;
208: l_meas_rec.RESPONSIBILITY_ID := cr.RESPONSIBILITY_ID;
209: l_resp_rec.RESPONSIBILITY_ID := cr.RESPONSIBILITY_ID;
210: l_resp_rec_p := l_resp_rec;
211: BIS_RESPONSIBILITY_PVT.Retrieve_Responsibility
212: ( p_api_version => 1.0
213: , p_Responsibility_Rec => l_resp_rec_p
214: , x_Responsibility_Rec => l_resp_rec
215: , x_return_status => x_return_status
277: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
278: )
279: IS
280: l_meas_rec BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type;
281: l_resp_rec BIS_Responsibility_PVT.Responsibility_rec_Type;
282:
283: cursor sec_cursor is
284: select a.RESPONSIBILITY_ID
285: , a.RESPONSIBILITY_KEY