APPS.BSC_SCORECARD_PUB dependencies on BSC_SCORECARD_PVT

Line 63: if BSC_SCORECARD_PVT.Validate_Tab(l_Bsc_Tab_Entity_Rec.Bsc_Tab_Name) > 0 then

59: l_Bsc_Tab_Entity_Rec := p_Bsc_Tab_Entity_Rec;
60:
61: -- Check that this Tab name does not exist.
62: if l_Bsc_Tab_Entity_Rec.Bsc_Tab_Name is not null then
63: if BSC_SCORECARD_PVT.Validate_Tab(l_Bsc_Tab_Entity_Rec.Bsc_Tab_Name) > 0 then
64: FND_MESSAGE.SET_NAME('BSC','BSC_TAB_NAME_EXISTS');
65: FND_MESSAGE.SET_TOKEN('BSC_TAB', l_Bsc_Tab_Entity_Rec.Bsc_Tab_Name);
66: FND_MSG_PUB.ADD;
67: RAISE FND_API.G_EXC_ERROR;

Line 98: BSC_SCORECARD_PVT.Create_Tab( p_commit

94: --DBMS_OUTPUT.PUT_LINE('tab name ==============' || l_Bsc_Tab_Entity_Rec.Bsc_Tab_Name);
95:
96:
97:
98: BSC_SCORECARD_PVT.Create_Tab( p_commit
99: ,l_Bsc_Tab_Entity_Rec
100: ,x_return_status
101: ,x_msg_count
102: ,x_msg_data);

Line 303: BSC_SCORECARD_PVT.Retrieve_Tab( p_commit

299:
300: begin
301: FND_MSG_PUB.Initialize;
302: x_return_status := FND_API.G_RET_STS_SUCCESS;
303: BSC_SCORECARD_PVT.Retrieve_Tab( p_commit
304: ,p_Bsc_Tab_Entity_Rec
305: ,x_Bsc_Tab_Entity_Rec
306: ,x_return_status
307: ,x_msg_count

Line 364: BSC_SCORECARD_PVT.Update_Tab( p_commit

360:
361: begin
362: FND_MSG_PUB.Initialize;
363: x_return_status := FND_API.G_RET_STS_SUCCESS;
364: BSC_SCORECARD_PVT.Update_Tab( p_commit
365: ,p_Bsc_Tab_Entity_Rec
366: ,x_return_status
367: ,x_msg_count
368: ,x_msg_data);

Line 424: BSC_SCORECARD_PVT.Delete_Tab( p_commit

420:
421: begin
422: FND_MSG_PUB.Initialize;
423: x_return_status := FND_API.G_RET_STS_SUCCESS;
424: BSC_SCORECARD_PVT.Delete_Tab( p_commit
425: ,p_Bsc_Tab_Entity_Rec
426: ,x_return_status
427: ,x_msg_count
428: ,x_msg_data);

Line 505: BSC_SCORECARD_PVT.Create_Tab_Access

501: l_Bsc_Tab_Entity_Rec.Bsc_Responsibility_Id := CD.responsibility_id;
502:
503: IF(l_Count = 0) THEN
504: --dbms_output.put_line(' calling create tab_access for resp id :-' || l_Bsc_Tab_Entity_Rec.Bsc_Responsibility_Id);
505: BSC_SCORECARD_PVT.Create_Tab_Access
506: ( p_commit
507: , l_Bsc_Tab_Entity_Rec
508: , x_return_status
509: , x_msg_count

Line 680: BSC_SCORECARD_PVT.Create_Tab_Grants( p_commit

676: -- set local record equal to the one passed.
677: l_Bsc_Tab_Entity_Rec := p_Bsc_Tab_Entity_Rec;
678:
679: -- Insert the record for the current responsibility.
680: BSC_SCORECARD_PVT.Create_Tab_Grants( p_commit
681: ,l_Bsc_Tab_Entity_Rec
682: ,x_return_status
683: ,x_msg_count
684: ,x_msg_data);

Line 740: BSC_SCORECARD_PVT.Update_System_Time_Stamp( p_commit

736:
737: begin
738: FND_MSG_PUB.Initialize;
739: x_return_status := FND_API.G_RET_STS_SUCCESS;
740: BSC_SCORECARD_PVT.Update_System_Time_Stamp( p_commit
741: ,p_Bsc_Tab_Entity_Rec
742: ,x_return_status
743: ,x_msg_count
744: ,x_msg_data);

Line 800: BSC_SCORECARD_PVT.Update_Tab_Time_Stamp( p_commit

796:
797: begin
798: FND_MSG_PUB.Initialize;
799: x_return_status := FND_API.G_RET_STS_SUCCESS;
800: BSC_SCORECARD_PVT.Update_Tab_Time_Stamp( p_commit
801: ,p_Bsc_Tab_Entity_Rec
802: ,x_return_status
803: ,x_msg_count
804: ,x_msg_data);

Line 1137: WHILE (BSC_SCORECARD_PVT.Is_More( p_grant_uids => l_grant_guids

1133:
1134: BEGIN
1135: l_grant_guids := p_grant_guids;
1136:
1137: WHILE (BSC_SCORECARD_PVT.Is_More( p_grant_uids => l_grant_guids
1138: , p_grant_uid => l_single_grant_guid)) LOOP
1139:
1140: SELECT grantee_key,instance_pk1_value
1141: INTO l_grantee_key, l_tab_id

Line 1151: WHILE (BSC_SCORECARD_PVT.Is_More( p_grant_uids => l_check_children

1147: IF (l_tablist_name IS NULL AND l_check_children IS NOT NULL) THEN
1148: l_tablist_name := l_check_children;
1149:
1150: ELSIF (l_check_children IS NOT NULL) THEN
1151: WHILE (BSC_SCORECARD_PVT.Is_More( p_grant_uids => l_check_children
1152: , p_grant_uid => l_check_child)) LOOP
1153: IF(INSTR(', '||l_tablist_name||', ',', '||l_check_child||', ') = 0) THEN
1154: l_tablist_name := l_tablist_name ||', '||l_check_child;
1155: