APPS.BSC_SEC_UTILITY dependencies on BSC_USER_KPI_ACCESS

Line 204: ----- remove the indicators of the tab from bsc_user_kpi_access

200: END IF;
201:
202:
203: -----if p_end_date is not null, and p_end_date<=sysdate, we need to
204: ----- remove the indicators of the tab from bsc_user_kpi_access
205: -----if p_end_date is null or p_end_date >sysdate need to reassign indicators to the resp
206: if ((p_end_date is not null and p_end_date <=sysdate)
207: or (p_start_date is not null and p_start_date >sysdate)) then
208: for l_indicators_rec in tab_indicators loop

Line 724: from bsc_user_kpi_access

720: select 'Y'
721: from dual
722: where exists
723: (select 'Y'
724: from bsc_user_kpi_access
725: where responsibility_id=p_resp_id
726: and indicator=p_indicator);
727:
728: l_dummy varchar2(1);

Line 760: insert into bsc_user_kpi_access (

756: ) ;
757:
758: else
759: ---insert a new row
760: insert into bsc_user_kpi_access (
761: responsibility_id,
762: indicator,
763: start_date,
764: end_date,

Line 852: update bsc_user_kpi_access

848: FND_MSG_PUB.initialize;
849: END IF;
850:
851: if (P_ROWID is not null) then
852: update bsc_user_kpi_access
853: set responsibility_id = P_RESP_ID,
854: indicator = P_INDICATOR,
855: start_date = P_START_DATE,
856: end_date = P_END_DATE,

Line 862: UPDATE bsc_user_kpi_access

858: last_update_login = l_last_update_login,
859: last_update_date = l_last_update_date
860: where rowid = P_ROWID;
861: else
862: UPDATE bsc_user_kpi_access
863: SET
864: start_date = P_START_DATE,
865: end_date = P_END_DATE,
866: LAST_UPDATE_DATE = L_LAST_UPDATE_DATE,

Line 929: delete from bsc_user_kpi_access

925: IF FND_API.to_Boolean( p_init_msg_list ) THEN
926: FND_MSG_PUB.initialize;
927: END IF;
928:
929: delete from bsc_user_kpi_access
930: where responsibility_id=p_resp_id
931: and indicator=p_indicator;
932:
933: