APPS.BIS_MEASURE_SECURITY_PVT dependencies on BIS_INDICATOR_RESPS

Line 73: select bis_indicator_resps_s.NextVal into l_id from dual;

69: END IF;
70: --2465354
71:
72: l_login_id := fnd_global.LOGIN_ID;
73: select bis_indicator_resps_s.NextVal into l_id from dual;
74:
75: BEGIN
76: insert into bis_indicator_resps
77: (

Line 76: insert into bis_indicator_resps

72: l_login_id := fnd_global.LOGIN_ID;
73: select bis_indicator_resps_s.NextVal into l_id from dual;
74:
75: BEGIN
76: insert into bis_indicator_resps
77: (
78: INDICATOR_RESP_ID
79: , RESPONSIBILITY_ID
80: , TARGET_LEVEL_ID

Line 166: from bis_indicator_resps

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
167: where TARGET_LEVEL_ID=p_Target_Level_Rec.Target_Level_Id;
168:
169: l_flag number := 0;
170: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 287: from fnd_responsibility_vl a, bis_indicator_resps b

283: cursor sec_cursor is
284: select a.RESPONSIBILITY_ID
285: , a.RESPONSIBILITY_KEY
286: , a.RESPONSIBILITY_NAME
287: from fnd_responsibility_vl a, bis_indicator_resps b
288: where VERSION='W'
289: and start_date <= sysdate
290: and nvl(end_date, sysdate) >= sysdate
291: and a.RESPONSIBILITY_ID=b.RESPONSIBILITY_ID and b.TARGET_LEVEL_ID=p_Target_Level_Rec.Target_Level_Id

Line 491: delete from bis_indicator_resps

487: -- , x_return_status => x_return_status
488: -- , x_error_Tbl => x_error_Tbl-
489: -- );
490:
491: delete from bis_indicator_resps
492: where target_level_id = p_Target_Level_Rec.Target_Level_Id;
493:
494: if (p_commit = FND_API.G_TRUE) then
495: commit;

Line 524: delete from bis_indicator_resps

520: IF( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
521: RAISE FND_API.G_EXC_ERROR;
522: END IF;
523:
524: delete from bis_indicator_resps
525: where target_level_id = p_Measure_Security_Rec.Target_Level_Id
526: and RESPONSIBILITY_ID = p_Measure_Security_Rec.Responsibility_id;
527:
528: if (p_commit = FND_API.G_TRUE) then

Line 761: from bis_indicator_resps ir

757: , il.target_level_name
758: , ir.Responsibility_ID
759: , fr.RESPONSIBILITY_NAME
760: , fr.RESPONSIBILITY_KEY
761: from bis_indicator_resps ir
762: , fnd_user_resp_groups ur
763: , bisbv_target_levels il
764: , fnd_responsibility_vl fr
765: where ur.user_id = p_user_id

Line 778: from bis_indicator_resps ir

774: , il.target_level_name
775: , ir.Responsibility_ID
776: , fr.RESPONSIBILITY_NAME
777: , fr.RESPONSIBILITY_KEY
778: from bis_indicator_resps ir
779: , fnd_user_resp_groups ur
780: , bisbv_target_levels il
781: , fnd_responsibility_vl fr
782: where ur.user_id = p_user_id

Line 795: from bis_indicator_resps ir

791: , il.target_level_name
792: , ir.Responsibility_ID
793: , fr.RESPONSIBILITY_NAME
794: , fr.RESPONSIBILITY_KEY
795: from bis_indicator_resps ir
796: , fnd_user_resp_groups ur
797: , bisbv_target_levels il
798: , fnd_responsibility_vl fr
799: where ur.user_id = p_user_id

Line 934: FROM bis_indicator_Resps

930: FROM fnd_user_resp_groups
931: WHERE user_id=p_user_id;
932: CURSOR c_indresp(p_target_level_id IN NUMBER) IS
933: SELECT responsibility_id
934: FROM bis_indicator_Resps
935: WHERE target_level_id=p_target_level_id;
936:
937: BEGIN
938:

Line 1048: DELETE FROM bis_indicator_resps

1044: SAVEPOINT delete_resps;
1045: x_return_status := FND_API.G_RET_STS_SUCCESS;
1046: SELECT indicator_id INTO l_indicator_id FROM bis_indicators WHERE short_name = p_measure_short_name;
1047: FOR target_cursor IN target_level_cursor(l_indicator_id) LOOP
1048: DELETE FROM bis_indicator_resps
1049: WHERE target_level_id = target_cursor.target_level_id;
1050: END LOOP;
1051:
1052: IF (p_commit = FND_API.G_TRUE) THEN