8: BSC_PROGRAM_NAME CONSTANT VARCHAR2(15) :='BSC_PMD_GRANTS';
9: BSC_VIEWER_ACCESS CONSTANT VARCHAR2(30) :='BSC_SCORECARD_USER';
10: procedure Create_Tab(
11: p_commit IN varchar2 := FND_API.G_FALSE
12: ,p_Bsc_Tab_Entity_Rec IN BSC_SCORECARD_PUB.Bsc_Tab_Entity_Rec
13: ,x_return_status OUT NOCOPY varchar2
14: ,x_msg_count OUT NOCOPY number
15: ,x_msg_data OUT NOCOPY varchar2
16: );
16: );
17:
18: procedure Retrieve_Tab(
19: p_commit IN varchar2 := FND_API.G_FALSE
20: ,p_Bsc_Tab_Entity_Rec IN BSC_SCORECARD_PUB.Bsc_Tab_Entity_Rec
21: ,x_Bsc_Tab_Entity_Rec IN OUT NOCOPY BSC_SCORECARD_PUB.Bsc_Tab_Entity_Rec
22: ,x_return_status OUT NOCOPY varchar2
23: ,x_msg_count OUT NOCOPY number
24: ,x_msg_data OUT NOCOPY varchar2
17:
18: procedure Retrieve_Tab(
19: p_commit IN varchar2 := FND_API.G_FALSE
20: ,p_Bsc_Tab_Entity_Rec IN BSC_SCORECARD_PUB.Bsc_Tab_Entity_Rec
21: ,x_Bsc_Tab_Entity_Rec IN OUT NOCOPY BSC_SCORECARD_PUB.Bsc_Tab_Entity_Rec
22: ,x_return_status OUT NOCOPY varchar2
23: ,x_msg_count OUT NOCOPY number
24: ,x_msg_data OUT NOCOPY varchar2
25: );
25: );
26:
27: procedure Update_Tab(
28: p_commit IN varchar2 := FND_API.G_FALSE
29: ,p_Bsc_Tab_Entity_Rec IN BSC_SCORECARD_PUB.Bsc_Tab_Entity_Rec
30: ,x_return_status OUT NOCOPY varchar2
31: ,x_msg_count OUT NOCOPY number
32: ,x_msg_data OUT NOCOPY varchar2
33: );
33: );
34:
35: procedure Delete_Tab(
36: p_commit IN varchar2 := FND_API.G_FALSE
37: ,p_Bsc_Tab_Entity_Rec IN BSC_SCORECARD_PUB.Bsc_Tab_Entity_Rec
38: ,x_return_status OUT NOCOPY varchar2
39: ,x_msg_count OUT NOCOPY number
40: ,x_msg_data OUT NOCOPY varchar2
41: );
41: );
42:
43: procedure Create_Tab_Access(
44: p_commit IN varchar2 := FND_API.G_FALSE
45: ,p_Bsc_Tab_Entity_Rec IN BSC_SCORECARD_PUB.Bsc_Tab_Entity_Rec
46: ,x_return_status OUT NOCOPY varchar2
47: ,x_msg_count OUT NOCOPY number
48: ,x_msg_data OUT NOCOPY varchar2
49: );
58: );
59:
60: procedure Update_Tab_Time_Stamp(
61: p_commit IN varchar2 := FND_API.G_FALSE
62: ,p_Bsc_Tab_Entity_Rec IN BSC_SCORECARD_PUB.Bsc_Tab_Entity_Rec
63: ,x_return_status OUT NOCOPY varchar2
64: ,x_msg_count OUT NOCOPY number
65: ,x_msg_data OUT NOCOPY varchar2
66: );
66: );
67:
68: procedure Update_System_Time_Stamp(
69: p_commit IN varchar2 := FND_API.G_FALSE
70: ,p_Bsc_Tab_Entity_Rec IN BSC_SCORECARD_PUB.Bsc_Tab_Entity_Rec
71: ,x_return_status OUT NOCOPY varchar2
72: ,x_msg_count OUT NOCOPY number
73: ,x_msg_data OUT NOCOPY varchar2
74: );
101: );
102:
103: procedure Create_Tab_Grants(
104: p_commit IN varchar2 := FND_API.G_FALSE
105: ,p_Bsc_Tab_Entity_Rec IN BSC_SCORECARD_PUB.Bsc_Tab_Entity_Rec
106: ,x_return_status OUT NOCOPY varchar2
107: ,x_msg_count OUT NOCOPY number
108: ,x_msg_data OUT NOCOPY varchar2
109: );