eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_INDICATOR_REGION_PVT dependencies on BIS_USER_IND_SELECTIONS

Line 16: select rowid from BIS_USER_IND_SELECTIONS

12: l_rowid VARCHAR2(18);
13: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
14:
15: cursor c is
16: select rowid from BIS_USER_IND_SELECTIONS
17: where IND_SELECTION_ID = l_user_ind_id;
18:
19: BEGIN
20: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 22: select BIS_USER_IND_SELECTIONS_S.NEXTVAL into l_user_ind_id from dual;

18:
19: BEGIN
20: x_return_status := FND_API.G_RET_STS_SUCCESS;
21:
22: select BIS_USER_IND_SELECTIONS_S.NEXTVAL into l_user_ind_id from dual;
23: -- mdamle 01/15/2001 - Remove Org and add Dim6 and Dim7
24: insert into BIS_USER_IND_SELECTIONS (
25: IND_SELECTION_ID
26: ,USER_ID

Line 24: insert into BIS_USER_IND_SELECTIONS (

20: x_return_status := FND_API.G_RET_STS_SUCCESS;
21:
22: select BIS_USER_IND_SELECTIONS_S.NEXTVAL into l_user_ind_id from dual;
23: -- mdamle 01/15/2001 - Remove Org and add Dim6 and Dim7
24: insert into BIS_USER_IND_SELECTIONS (
25: IND_SELECTION_ID
26: ,USER_ID
27: ,TARGET_LEVEL_ID
28: -- ,ORGANIZATION_ID

Line 136: FROM bis_user_ind_selections a

132: ,a.dimension6_level_value
133: ,a.dimension7_level_value
134: ,a.responsibility_id
135: ,a.plan_id
136: FROM bis_user_ind_selections a
137: ,fnd_user_resp_groups b
138: ,bis_indicators c
139: ,bis_target_levels d
140: WHERE a.user_id = p_user_id

Line 470: select * from bis_user_ind_selections

466: l_Dim_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
467: l_Org_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
468:
469: CURSOR c_user_ind_selection IS
470: select * from bis_user_ind_selections
471: where Target_Level_ID = p_target_level_id;
472:
473: BEGIN
474:

Line 766: DELETE FROM BIS_USER_IND_SELECTIONS

762: BEGIN
763:
764: x_return_status := FND_API.G_RET_STS_SUCCESS;
765:
766: DELETE FROM BIS_USER_IND_SELECTIONS
767: WHERE user_id = p_user_id
768: AND plug_id = p_plug_id;
769:
770: COMMIT;

Line 809: FROM bis_user_ind_selections uis

805: l_user_id NUMBER;
806: CURSOR cr_label IS
807: SELECT DISTINCT uis.ind_selection_id
808: , uis.label
809: FROM bis_user_ind_selections uis
810: WHERE uis.user_id = l_user_ID
811: AND uis.plug_id = p_Plug_ID;
812:
813: BEGIN