38: g_db_object varchar2(30) := null;
39:
40: PROCEDURE Create_Kpi_Group(
41: p_commit IN VARCHAR2 := FND_API.G_FALSE
42: ,p_Bsc_Kpi_Group_Rec IN BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec
43: ,x_return_status OUT NOCOPY VARCHAR2
44: ,x_msg_count OUT NOCOPY NUMBER
45: ,x_msg_data OUT NOCOPY VARCHAR2
46: ) is
224: ************************************************************************************/
225:
226: procedure Retrieve_Kpi_Group(
227: p_commit IN varchar2 := FND_API.G_FALSE
228: ,p_Bsc_Kpi_Group_Rec IN BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec
229: ,x_Bsc_Kpi_Group_Rec IN OUT NOCOPY BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec
230: ,x_return_status OUT NOCOPY VARCHAR2
231: ,x_msg_count OUT NOCOPY NUMBER
232: ,x_msg_data OUT NOCOPY VARCHAR2
225:
226: procedure Retrieve_Kpi_Group(
227: p_commit IN varchar2 := FND_API.G_FALSE
228: ,p_Bsc_Kpi_Group_Rec IN BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec
229: ,x_Bsc_Kpi_Group_Rec IN OUT NOCOPY BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec
230: ,x_return_status OUT NOCOPY VARCHAR2
231: ,x_msg_count OUT NOCOPY NUMBER
232: ,x_msg_data OUT NOCOPY VARCHAR2
233: ) is
322: ************************************************************************************/
323:
324: procedure Update_Kpi_Group(
325: p_commit IN varchar2 := FND_API.G_FALSE
326: ,p_Bsc_Kpi_Group_Rec IN BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec
327: ,x_return_status OUT NOCOPY varchar2
328: ,x_msg_count OUT NOCOPY number
329: ,x_msg_data OUT NOCOPY varchar2
330: ) is
328: ,x_msg_count OUT NOCOPY number
329: ,x_msg_data OUT NOCOPY varchar2
330: ) is
331:
332: l_Bsc_Kpi_Group_Rec BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec;
333:
334: l_count number;
335: l_name_count number;
336: l_update_TL number := 0;
562: ************************************************************************************/
563:
564: procedure Delete_Kpi_Group(
565: p_commit IN VARCHAR2 := FND_API.G_FALSE
566: ,p_Bsc_Kpi_Group_Rec IN BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec
567: ,x_return_status OUT NOCOPY varchar2
568: ,x_msg_count OUT NOCOPY number
569: ,x_msg_data OUT NOCOPY varchar2
570: ) is