1 PACKAGE PSB_GL_Budget_Set_Pvt AUTHID CURRENT_USER AS
2 /* $Header: PSBVGBSS.pls 115.8 2002/11/29 10:16:37 vbellur ship $ */
3
4 PROCEDURE Insert_Row
5 (
6 p_api_version IN NUMBER,
7 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8 p_commit IN VARCHAR2 := FND_API.G_FALSE,
9 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10 p_return_status OUT NOCOPY VARCHAR2,
11 p_msg_count OUT NOCOPY NUMBER,
12 p_msg_data OUT NOCOPY VARCHAR2,
13 --
14 p_row_id IN OUT NOCOPY VARCHAR2,
15 p_gl_budget_set_id IN OUT NOCOPY NUMBER,
16 p_gl_budget_set_name IN VARCHAR2,
17 p_set_of_books_id IN NUMBER,
18 p_last_update_date IN DATE,
19 p_last_updated_by IN NUMBER,
20 p_last_update_login IN NUMBER,
21 p_created_by IN NUMBER,
22 p_creation_date IN DATE ,
23 p_context IN VARCHAR2,
24 p_attribute1 IN VARCHAR2,
25 p_attribute2 IN VARCHAR2,
26 p_attribute3 IN VARCHAR2,
27 p_attribute4 IN VARCHAR2,
28 p_attribute5 IN VARCHAR2,
29 p_attribute6 IN VARCHAR2,
30 p_attribute7 IN VARCHAR2,
31 p_attribute8 IN VARCHAR2,
32 p_attribute9 IN VARCHAR2,
33 p_attribute10 IN VARCHAR2
34 );
35
36
37 PROCEDURE Lock_Row
38 (
39 p_api_version IN NUMBER,
40 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
41 p_commit IN VARCHAR2 := FND_API.G_FALSE,
42 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
43 p_return_status OUT NOCOPY VARCHAR2,
44 p_msg_count OUT NOCOPY NUMBER,
45 p_msg_data OUT NOCOPY VARCHAR2,
46 --
47 p_row_id IN VARCHAR2,
48 p_gl_budget_set_id IN NUMBER,
49 p_gl_budget_set_name IN VARCHAR2,
50 p_set_of_books_id IN NUMBER,
51 p_context IN VARCHAR2,
52 p_attribute1 IN VARCHAR2,
53 p_attribute2 IN VARCHAR2,
54 p_attribute3 IN VARCHAR2,
55 p_attribute4 IN VARCHAR2,
56 p_attribute5 IN VARCHAR2,
57 p_attribute6 IN VARCHAR2,
58 p_attribute7 IN VARCHAR2,
59 p_attribute8 IN VARCHAR2,
60 p_attribute9 IN VARCHAR2,
61 p_attribute10 IN VARCHAR2,
62 --
63 p_row_locked OUT NOCOPY VARCHAR2
64 );
65
66
67 PROCEDURE Update_Row
68 (
69 p_api_version IN NUMBER,
70 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
71 p_commit IN VARCHAR2 := FND_API.G_FALSE,
72 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73 p_return_status OUT NOCOPY VARCHAR2,
74 p_msg_count OUT NOCOPY NUMBER,
75 p_msg_data OUT NOCOPY VARCHAR2,
76 --
77 p_row_id IN VARCHAR2,
78 p_gl_budget_set_name IN VARCHAR2,
79 p_set_of_books_id IN NUMBER,
80 p_last_update_date IN DATE,
81 p_last_updated_by IN NUMBER,
82 p_last_update_login IN NUMBER,
83 p_context IN VARCHAR2,
84 p_attribute1 IN VARCHAR2,
85 p_attribute2 IN VARCHAR2,
86 p_attribute3 IN VARCHAR2,
87 p_attribute4 IN VARCHAR2,
88 p_attribute5 IN VARCHAR2,
89 p_attribute6 IN VARCHAR2,
90 p_attribute7 IN VARCHAR2,
91 p_attribute8 IN VARCHAR2,
92 p_attribute9 IN VARCHAR2,
93 p_attribute10 IN VARCHAR2
94 );
95
96
97 PROCEDURE Delete_Row
98 (
99 p_api_version IN NUMBER,
100 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101 p_commit IN VARCHAR2 := FND_API.G_FALSE,
102 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103 p_return_status OUT NOCOPY VARCHAR2,
104 p_msg_count OUT NOCOPY NUMBER,
105 p_msg_data OUT NOCOPY VARCHAR2,
106 --
107 p_row_id IN VARCHAR2
108 );
109
110
111 PROCEDURE Check_Unique
112 (
113 p_api_version IN NUMBER,
114 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
115 p_commit IN VARCHAR2 := FND_API.G_FALSE,
116 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117 p_return_status OUT NOCOPY VARCHAR2,
118 p_msg_count OUT NOCOPY NUMBER,
119 p_msg_data OUT NOCOPY VARCHAR2,
120 --
121 p_row_id IN VARCHAR2,
122 p_gl_budget_set_name IN VARCHAR2,
123 p_set_of_books_id IN NUMBER,
124 p_return_value IN OUT NOCOPY VARCHAR2
125 );
126
127
128 PROCEDURE Validate_Account_Overlap
129 (
130 p_api_version IN NUMBER,
131 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
132 p_commit IN VARCHAR2 := FND_API.G_FALSE,
133 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
134 p_return_status OUT NOCOPY VARCHAR2,
135 p_msg_count OUT NOCOPY NUMBER,
136 p_msg_data OUT NOCOPY VARCHAR2,
137 --
138 p_gl_budget_set_id IN NUMBER,
139 p_validation_status IN OUT NOCOPY VARCHAR2
140 );
141
142
143 PROCEDURE Validate_Account_Overlap_CP
144 (
145 errbuf OUT NOCOPY VARCHAR2,
146 retcode OUT NOCOPY VARCHAR2,
147 --
148 p_gl_budget_set_id IN NUMBER
149 );
150
151 /* Bug No. 2564791 start */
152 PROCEDURE Check_References
153 (
154 p_api_version IN NUMBER,
155 p_init_msg_list IN VARCHAR2,
156 p_commit IN VARCHAR2,
157 p_validation_level IN NUMBER,
158 p_return_status OUT NOCOPY VARCHAR2,
159 p_msg_count OUT NOCOPY NUMBER,
160 p_msg_data OUT NOCOPY VARCHAR2,
161 --
162 p_gl_budget_set_id IN NUMBER
163 );
164 /* Bug No. 2564791 End */
165
166 END PSB_GL_Budget_Set_Pvt ;