APPS.BSC_KPI_PVT dependencies on BSC_USER_KPI_ACCESS

Line 3449: l_db_object := 'BSC_USER_KPI_ACCESS';

3445: FND_MSG_PUB.ADD;
3446: RAISE FND_API.G_EXC_ERROR;
3447: end if;
3448:
3449: l_db_object := 'BSC_USER_KPI_ACCESS';
3450:
3451:
3452: insert into BSC_USER_KPI_ACCESS( responsibility_id
3453: ,indicator

Line 3452: insert into BSC_USER_KPI_ACCESS( responsibility_id

3448:
3449: l_db_object := 'BSC_USER_KPI_ACCESS';
3450:
3451:
3452: insert into BSC_USER_KPI_ACCESS( responsibility_id
3453: ,indicator
3454: ,creation_date
3455: ,created_by
3456: ,last_update_date

Line 3563: from BSC_USER_KPI_ACCESS

3559: ,x_Bsc_Kpi_Entity_Rec.Last_Updated_By
3560: ,x_Bsc_Kpi_Entity_Rec.Last_Update_Login
3561: ,x_Bsc_Kpi_Entity_Rec.Bsc_Resp_Start_Date
3562: ,x_Bsc_Kpi_Entity_Rec.Bsc_Resp_End_Date
3563: from BSC_USER_KPI_ACCESS
3564: where indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
3565: and responsibility_id = p_Bsc_Kpi_Entity_Rec.Bsc_Responsibility_Id;
3566:
3567:

Line 3686: update BSC_USER_KPI_ACCESS

3682: if p_Bsc_Kpi_Entity_Rec.Bsc_Resp_End_Date is not null then
3683: l_Bsc_Kpi_Entity_Rec.Bsc_Resp_End_Date := p_Bsc_Kpi_Entity_Rec.Bsc_Resp_End_Date;
3684: end if;
3685:
3686: update BSC_USER_KPI_ACCESS
3687: set responsibility_id = l_Bsc_Kpi_Entity_Rec.Bsc_Responsibility_Id
3688: ,creation_date = l_Bsc_Kpi_Entity_Rec.Creation_Date
3689: ,created_by = l_Bsc_Kpi_Entity_Rec.Created_By
3690: ,last_update_date = l_Bsc_Kpi_Entity_Rec.Last_Update_Date

Line 3779: delete from BSC_USER_KPI_ACCESS

3775: FND_MSG_PUB.ADD;
3776: RAISE FND_API.G_EXC_ERROR;
3777: end if;
3778:
3779: delete from BSC_USER_KPI_ACCESS
3780: where indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
3781:
3782: if (p_commit = FND_API.G_TRUE) then
3783: commit;

Line 7768: FROM bsc_user_kpi_access

7764: RAISE FND_API.G_EXC_ERROR;
7765: END IF;
7766:
7767: DELETE
7768: FROM bsc_user_kpi_access
7769: WHERE indicator=p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7770:
7771:
7772: IF (p_commit = FND_API.G_TRUE) THEN