7: BSC_GRANTEE_TYPE CONSTANT VARCHAR2(5) :='USER';
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
15: ,x_msg_data OUT NOCOPY varchar2
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
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
32: ,x_msg_data OUT NOCOPY varchar2
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
40: ,x_msg_data OUT NOCOPY varchar2
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
48: ,x_msg_data OUT NOCOPY varchar2
49: );
50:
51: procedure Move_Tab(
52: p_commit IN varchar2 := FND_API.G_FALSE
53: ,p_tab_id number
54: ,p_tab_index number
55: ,x_return_status OUT NOCOPY varchar2
56: ,x_msg_count OUT NOCOPY number
57: ,x_msg_data OUT NOCOPY varchar2
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
65: ,x_msg_data OUT NOCOPY varchar2
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
100: , p_user_name IN VARCHAR2
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