DBA Data[Home] [Help]

APPS.BSC_BIS_KPI_CRUD_PUB dependencies on BSC_PMF_UI_WRAPPER

Line 1022: --DBMS_OUTPUT.PUT_LINE('Outside BSC_PMF_UI_WRAPPER.Delete_Kpi' );

1018:
1019: /*
1020: At this point, Delete ALL the KPI Metadata and info related to the KPI.
1021: */
1022: --DBMS_OUTPUT.PUT_LINE('Outside BSC_PMF_UI_WRAPPER.Delete_Kpi' );
1023: --DBMS_OUTPUT.PUT_LINE('Outside FND_FORM_FUNCTIONS_PKG.DELETE_ROW ' );
1024: BSC_PMF_UI_WRAPPER.Delete_Kpi(
1025: p_commit => p_commit
1026: ,p_Kpi_Id => l_Kpi_Id

Line 1024: BSC_PMF_UI_WRAPPER.Delete_Kpi(

1020: At this point, Delete ALL the KPI Metadata and info related to the KPI.
1021: */
1022: --DBMS_OUTPUT.PUT_LINE('Outside BSC_PMF_UI_WRAPPER.Delete_Kpi' );
1023: --DBMS_OUTPUT.PUT_LINE('Outside FND_FORM_FUNCTIONS_PKG.DELETE_ROW ' );
1024: BSC_PMF_UI_WRAPPER.Delete_Kpi(
1025: p_commit => p_commit
1026: ,p_Kpi_Id => l_Kpi_Id
1027: ,x_Return_Status => x_Return_Status
1028: ,x_Msg_Count => x_Msg_Count

Line 2180: BSC_PMF_UI_WRAPPER.Update_Kpi_Periodicities(

2176: CLOSE c_YearPeriodity;
2177: END IF;
2178:
2179: -- Asisgn BSC-BIS Periodicities to the KPI
2180: BSC_PMF_UI_WRAPPER.Update_Kpi_Periodicities(
2181: p_commit => p_commit
2182: ,p_kpi_id => p_kpi_id
2183: ,p_calendar_id => l_calendar_id
2184: ,p_periodicity_ids => l_periodicity_ids

Line 2200: BSC_PMF_UI_WRAPPER.Update_Kpi_Periodicities(

2196: OPEN c1 (1001);
2197: FETCH c1 INTO l_Calendar_Id;
2198: CLOSE c1;
2199:
2200: BSC_PMF_UI_WRAPPER.Update_Kpi_Periodicities(
2201: p_commit => p_Commit
2202: ,p_kpi_id => p_Kpi_Id
2203: ,p_calendar_id => l_Calendar_Id
2204: ,p_periodicity_ids => NULL

Line 5110: BSC_PMF_UI_WRAPPER.Create_Tab(

5106:
5107: --DBMS_OUTPUT.PUT_LINE('STAGE 4 - ' ||l_Tab_Id);
5108:
5109: IF (l_Tab_Id = BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY AND p_Obj_Type = BSC_BIS_KPI_CRUD_PUB.C_MULTI_BAR_INDICATOR) THEN
5110: BSC_PMF_UI_WRAPPER.Create_Tab(
5111: p_Commit => p_Commit
5112: ,p_Responsibility_Id => p_Responsibility_Id
5113: ,p_Parent_Tab_Id => NULL
5114: ,p_Owner_Id => NULL

Line 5139: BSC_PMF_UI_WRAPPER.Create_Kpi_Group(

5135: --DBMS_OUTPUT.PUT_LINE('STAGE 5 - ' ||l_Kpi_Group_Id);
5136:
5137: IF (l_Kpi_Group_Id = BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY) THEN
5138: -- Create a new KPI Group, aka Objective Group
5139: BSC_PMF_UI_WRAPPER.Create_Kpi_Group(
5140: p_Commit => p_Commit
5141: ,p_Tab_Id => NULL
5142: ,p_Kpi_Group_Id => NULL
5143: ,p_Kpi_Group_Short_Name => l_Key_Short_Name

Line 5168: BSC_PMF_UI_WRAPPER.Create_Kpi(

5164: l_obj_type := p_Obj_Type;
5165:
5166:
5167:
5168: BSC_PMF_UI_WRAPPER.Create_Kpi(
5169: p_Commit => p_Commit
5170: ,p_Group_Id => l_Kpi_Group_Id
5171: ,p_Responsibility_Id => p_Responsibility_Id
5172: ,p_Kpi_Name => l_User_Page_Report_Name

Line 5224: BSC_PMF_UI_WRAPPER.Assign_KPI(

5220:
5221: --DBMS_OUTPUT.PUT_LINE('INSIDE l_Kpi_Group_Id - ' ||l_Kpi_Group_Id);
5222: IF(l_obj_type = BSC_BIS_KPI_CRUD_PUB.C_SIMULATION_INDICATOR) THEN
5223:
5224: BSC_PMF_UI_WRAPPER.Assign_KPI(
5225: p_Commit => FND_API.G_FALSE
5226: ,p_kpi_id => l_kpi_id
5227: ,p_tab_id => l_Tab_Id
5228: ,x_return_status => x_return_status

Line 5238: BSC_PMF_UI_WRAPPER.Assign_KPI_Group(

5234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5235: END IF;
5236:
5237: ELSE
5238: BSC_PMF_UI_WRAPPER.Assign_KPI_Group(
5239: p_Commit => p_Commit
5240: ,p_Kpi_Group_Id => l_Kpi_Group_Id
5241: ,p_Tab_Id => l_Tab_Id
5242: ,x_Return_Status => x_Return_Status

Line 5263: BSC_PMF_UI_WRAPPER.Assign_KPI(

5259:
5260: l_kpi_id := Get_Kpi_Id(l_Key_Short_Name);
5261:
5262: IF(l_kpi_id <> -1000 AND Is_Assign_To_Tab(l_kpi_id,p_Obj_Tab_Id)=FND_API.G_FALSE)THEN
5263: BSC_PMF_UI_WRAPPER.Assign_KPI(
5264: p_Commit => FND_API.G_FALSE
5265: ,p_kpi_id => l_kpi_id
5266: ,p_tab_id => p_Obj_Tab_Id
5267: ,x_return_status => x_return_status

Line 7391: BSC_PMF_UI_WRAPPER.Delete_Kpi_Group(

7387: OPEN c_get_kpiGroup;
7388: FETCH c_get_kpiGroup INTO l_kpiGroup_id;
7389: CLOSE c_get_kpiGroup;
7390:
7391: BSC_PMF_UI_WRAPPER.Delete_Kpi_Group(
7392: p_kpi_group_id => l_kpiGroup_id
7393: , p_tab_id => -1
7394: , x_return_status => x_return_status
7395: , x_msg_count => x_msg_count

Line 7449: BSC_PMF_UI_WRAPPER.Delete_Tab(

7445: ,x_msg_count OUT NOCOPY number
7446: ,x_msg_data OUT NOCOPY varchar2
7447: ) IS
7448: BEGIN
7449: BSC_PMF_UI_WRAPPER.Delete_Tab(
7450: p_tab_id => p_tabId
7451: , x_return_status => x_return_status
7452: , x_msg_count => x_msg_count
7453: , x_msg_data => x_msg_data

Line 7482: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Delete_Tab ';

7478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7479: WHEN NO_DATA_FOUND THEN
7480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7481: IF (x_msg_data IS NOT NULL) THEN
7482: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Delete_Tab ';
7483: ELSE
7484: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Delete_Tab ';
7485: END IF;
7486: WHEN OTHERS THEN

Line 7484: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Delete_Tab ';

7480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7481: IF (x_msg_data IS NOT NULL) THEN
7482: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Delete_Tab ';
7483: ELSE
7484: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Delete_Tab ';
7485: END IF;
7486: WHEN OTHERS THEN
7487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7488: IF (x_msg_data IS NOT NULL) THEN

Line 7489: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Delete_Tab ';

7485: END IF;
7486: WHEN OTHERS THEN
7487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7488: IF (x_msg_data IS NOT NULL) THEN
7489: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Delete_Tab ';
7490: ELSE
7491: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Delete_Tab ';
7492: END IF;
7493: END Delete_S2E_Scorecard;

Line 7491: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Delete_Tab ';

7487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7488: IF (x_msg_data IS NOT NULL) THEN
7489: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Delete_Tab ';
7490: ELSE
7491: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Delete_Tab ';
7492: END IF;
7493: END Delete_S2E_Scorecard;
7494:
7495:

Line 8159: BSC_PMF_UI_WRAPPER.Update_Kpi(

8155:
8156: -- We have BSC_KPIS_TL.HELP is VARCHAR2(150);
8157: l_Region_Description := SUBSTR(l_Region_Description, 1, 150);
8158:
8159: BSC_PMF_UI_WRAPPER.Update_Kpi(
8160: p_Commit => p_Commit
8161: ,p_Kpi_Id => p_Kpi_Id
8162: ,x_Return_Status => x_return_status
8163: ,x_Msg_Count => x_msg_count

Line 8675: BSC_PMF_UI_WRAPPER.Delete_Kpi(

8671:
8672: */
8673:
8674:
8675: BSC_PMF_UI_WRAPPER.Delete_Kpi(
8676: p_commit => p_commit
8677: ,p_Kpi_Id => l_Kpi_Id
8678: ,x_Return_Status => x_Return_Status
8679: ,x_Msg_Count => x_Msg_Count

Line 8699: BSC_PMF_UI_WRAPPER.Delete_Kpi_Group(

8695: + Delete the Objective Group created for the AG Report
8696: */
8697: IF(l_Tab_Id <> BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY AND l_kpi_Group_Id <> BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY) THEN
8698:
8699: BSC_PMF_UI_WRAPPER.Delete_Kpi_Group(
8700: p_commit => p_Commit
8701: ,p_kpi_group_id => l_kpi_Group_Id
8702: ,p_tab_id => l_Tab_Id
8703: ,x_return_status => x_Return_Status

Line 8713: BSC_PMF_UI_WRAPPER.Delete_Kpi_Group(

8709: END IF;
8710:
8711:
8712: -- Delete the -1 entry as well.
8713: BSC_PMF_UI_WRAPPER.Delete_Kpi_Group(
8714: p_commit => p_Commit
8715: ,p_kpi_group_id => l_kpi_Group_Id
8716: ,p_tab_id => -1
8717: ,x_return_status => x_Return_Status

Line 8729: BSC_PMF_UI_WRAPPER.Delete_Tab(

8725: /*
8726: + Delete the Scorecard Created for the AG Report
8727: */
8728:
8729: BSC_PMF_UI_WRAPPER.Delete_Tab(
8730: p_commit => p_Commit
8731: , p_tab_id => l_Tab_Id
8732: , x_Return_Status => x_Return_Status
8733: , x_Msg_Count => x_Msg_Count

Line 9429: BSC_PMF_UI_WRAPPER.Delete_Tab

9425: END LOOP;
9426:
9427: IF(l_tab_id IS NOT NULL) THEN
9428:
9429: BSC_PMF_UI_WRAPPER.Delete_Tab
9430: (
9431: p_commit => p_commit
9432: , p_tab_id => l_tab_id
9433: , x_Return_Status => x_Return_Status