APPS.BIS_MEASURE_SECURITY_PVT dependencies on BIS_MEASURE_SECURITY_PUB

Line 35: ,p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type

31: Procedure Create_Measure_Security
32: ( p_api_version IN NUMBER
33: , p_commit IN VARCHAR2 := FND_API.G_FALSE
34: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
35: ,p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
36: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER --2465354
37: , x_return_status OUT NOCOPY VARCHAR2
38: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
39: )

Line 155: OUT NOCOPY BIS_MEASURE_SECURITY_PUB.Measure_Security_Tbl_Type

151: PROCEDURE Retrieve_Measure_Securities
152: ( p_api_version IN NUMBER
153: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
154: , x_Measure_Security_tbl
155: OUT NOCOPY BIS_MEASURE_SECURITY_PUB.Measure_Security_Tbl_Type
156: , x_return_status OUT NOCOPY VARCHAR2
157: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
158: )
159: IS

Line 160: l_meas_rec BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type;

156: , x_return_status OUT NOCOPY VARCHAR2
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

Line 275: OUT NOCOPY BIS_MEASURE_SECURITY_PUB.Measure_Security_Tbl_Type

271: PROCEDURE Retrieve_Measure_Sec_Sorted
272: ( p_api_version IN NUMBER
273: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
274: , x_Measure_Security_tbl
275: OUT NOCOPY BIS_MEASURE_SECURITY_PUB.Measure_Security_Tbl_Type
276: , x_return_status OUT NOCOPY VARCHAR2
277: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
278: )
279: IS

Line 280: l_meas_rec BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type;

276: , x_return_status OUT NOCOPY VARCHAR2
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

Line 379: , p_Measure_Security_Rec IN BIS_Measure_SECURITY_PUB.Measure_Security_Rec_Type

375: --
376: --
377: PROCEDURE Retrieve_Measure_Security
378: ( p_api_version IN NUMBER
379: , p_Measure_Security_Rec IN BIS_Measure_SECURITY_PUB.Measure_Security_Rec_Type
380: , x_Measure_Security_Rec OUT NOCOPY BIS_Measure_SECURITY_PUB.Measure_Security_Rec_Type
381: , x_return_status OUT NOCOPY VARCHAR2
382: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
383: )

Line 380: , x_Measure_Security_Rec OUT NOCOPY BIS_Measure_SECURITY_PUB.Measure_Security_Rec_Type

376: --
377: PROCEDURE Retrieve_Measure_Security
378: ( p_api_version IN NUMBER
379: , p_Measure_Security_Rec IN BIS_Measure_SECURITY_PUB.Measure_Security_Rec_Type
380: , x_Measure_Security_Rec OUT NOCOPY BIS_Measure_SECURITY_PUB.Measure_Security_Rec_Type
381: , x_return_status OUT NOCOPY VARCHAR2
382: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
383: )
384: IS

Line 424: , p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type

420: Procedure Update_Measure_Security
421: ( p_api_version IN NUMBER
422: , p_commit IN VARCHAR2 := FND_API.G_FALSE
423: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
424: , p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
425: , x_return_status OUT NOCOPY VARCHAR2
426: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
427: )
428: IS

Line 504: , p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type

500:
501: Procedure Delete_Measure_Security
502: ( p_api_version IN NUMBER
503: , p_commit IN VARCHAR2 := FND_API.G_FALSE
504: , p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
505: , x_return_status OUT NOCOPY VARCHAR2
506: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
507: )
508: IS

Line 562: ,p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type

558: -- Validates Measure_Security
559: PROCEDURE Validate_Measure_Security
560: ( p_api_version IN NUMBER
561: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
562: ,p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
563: , x_return_status OUT NOCOPY VARCHAR2
564: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
565: )
566: IS

Line 680: , p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type

676: --
677: -- Value - ID conversion
678: PROCEDURE Value_ID_Conversion
679: ( p_api_version IN NUMBER
680: , p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
681: , x_Measure_Security_Rec OUT NOCOPY BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
682: , x_return_status OUT NOCOPY VARCHAR2
683: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
684: )

Line 681: , x_Measure_Security_Rec OUT NOCOPY BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type

677: -- Value - ID conversion
678: PROCEDURE Value_ID_Conversion
679: ( p_api_version IN NUMBER
680: , p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
681: , x_Measure_Security_Rec OUT NOCOPY BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
682: , x_return_status OUT NOCOPY VARCHAR2
683: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
684: )
685: IS

Line 748: , x_Measure_security_Tbl OUT NOCOPY BIS_MEASURE_SECURITY_PUB.Measure_Security_Tbl_Type

744: Procedure Retrieve_Tar_Level_User_Resps
745: ( p_api_version IN NUMBER
746: , p_user_id IN NUMBER
747: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
748: , x_Measure_security_Tbl OUT NOCOPY BIS_MEASURE_SECURITY_PUB.Measure_Security_Tbl_Type
749: , x_return_status OUT NOCOPY VARCHAR2
750: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
751: )
752: is

Line 805: l_rec BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type;

801: and ir.responsibility_id = fr.responsibility_id
802: and il.target_level_id = ir.target_level_id
803: and il.target_level_name = p_target_level_rec.target_level_name;
804:
805: l_rec BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type;
806: l_flag number := 0;
807: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
808: BEGIN
809: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 920: , p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type

916: PROCEDURE Validate_Measure_Security
917: ( p_api_version IN NUMBER
918: , p_user_id IN NUMBER
919: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
920: , p_Measure_Security_Rec IN BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type
921: , x_return_status OUT NOCOPY VARCHAR2
922: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
923: )
924: IS