[Home] [Help]
PACKAGE: APPS.PSB_FLEX_MAPPING_PVT
Source
1 PACKAGE PSB_Flex_Mapping_PVT AS
2 /* $Header: PSBVFLXS.pls 120.2 2005/07/13 11:26:07 shtripat ship $ */
3
4 --
5 -- Global Variables for Views
6 --
7 g_Application_Column_Name VARCHAR2(30) ;
8 g_Flex_Set_ID NUMBER;
9
10 g_seg_name FND_FLEX_EXT.SEGMENTARRAY;
11 g_flex_code NUMBER;
12 g_num_segs NUMBER;
13
14 TYPE SegNumArray IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
15 g_seg_num segnumarray;
16
17 --
18 PROCEDURE Insert_Row
19 (
20 p_api_version IN NUMBER,
21 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
22 p_commit IN VARCHAR2 := FND_API.G_FALSE,
23 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
24 p_return_status OUT NOCOPY VARCHAR2,
25 p_msg_count OUT NOCOPY NUMBER,
26 p_msg_data OUT NOCOPY VARCHAR2,
27 --
28 p_Row_Id IN OUT NOCOPY VARCHAR2,
29 p_Flex_Mapping_Set_ID IN NUMBER,
30 p_Flex_Mapping_Value_ID IN NUMBER,
31 p_Budget_Year_Type_ID IN NUMBER,
32 p_Application_Column_Name IN VARCHAR2,
33 p_Flex_Value_Set_ID IN NUMBER,
34 p_Flex_Value_ID IN NUMBER,
35 p_From_Flex_Value_ID IN NUMBER,
36 p_mode IN varchar2 default 'R'
37 );
38
39
40 PROCEDURE Lock_Row
41 (
42 p_api_version IN NUMBER,
43 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44 p_commit IN VARCHAR2 := FND_API.G_FALSE,
45 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46 p_return_status OUT NOCOPY VARCHAR2,
47 p_msg_count OUT NOCOPY NUMBER,
48 p_msg_data OUT NOCOPY VARCHAR2,
49 --
50 p_Flex_Mapping_Set_ID IN NUMBER,
51 p_Flex_Mapping_Value_ID IN NUMBER,
52 p_Budget_Year_Type_ID IN NUMBER,
53 p_Application_Column_Name IN VARCHAR2,
54 p_Flex_Value_Set_ID IN NUMBER,
55 p_Flex_Value_ID IN NUMBER,
56 p_From_Flex_Value_ID IN NUMBER,
57 --
58 p_row_locked OUT NOCOPY VARCHAR2
59 );
60
61
62 PROCEDURE Update_Row
63 (
64 p_api_version IN NUMBER,
65 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
66 p_commit IN VARCHAR2 := FND_API.G_FALSE,
67 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
68 p_return_status OUT NOCOPY VARCHAR2,
69 p_msg_count OUT NOCOPY NUMBER,
70 p_msg_data OUT NOCOPY VARCHAR2,
71 --
72 p_Flex_Mapping_Set_ID IN NUMBER,
73 p_Flex_Mapping_Value_ID IN NUMBER,
74 p_Budget_Year_Type_ID IN NUMBER,
75 p_Application_Column_Name IN VARCHAR2,
76 p_Flex_Value_Set_ID IN NUMBER,
77 p_Flex_Value_ID IN NUMBER,
78 p_From_Flex_Value_ID IN NUMBER,
79 p_mode IN VARCHAR2 default 'R'
80 );
81
82
83 PROCEDURE Delete_Row
84 (
85 p_api_version IN NUMBER,
86 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
87 p_commit IN VARCHAR2 := FND_API.G_FALSE,
88 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
89 p_return_status OUT NOCOPY VARCHAR2,
90 p_msg_count OUT NOCOPY NUMBER,
91 p_msg_data OUT NOCOPY VARCHAR2,
92 --
93 p_Flex_Mapping_Value_ID IN NUMBER
94 );
95
96 ---
97 --- table handler for psb_flex_mapping_sets
98 ---
99
100 PROCEDURE Sets_Insert_Row
101 (
102 p_api_version IN NUMBER,
103 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
104 p_commit IN VARCHAR2 := FND_API.G_FALSE,
105 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
106 p_return_status OUT NOCOPY VARCHAR2,
107 p_msg_count OUT NOCOPY NUMBER,
108 p_msg_data OUT NOCOPY VARCHAR2,
109 --
110 p_Flex_Mapping_Set_ID IN NUMBER,
111 p_Name IN VARCHAR2,
112 p_Description IN VARCHAR2,
113 p_set_of_books_id IN NUMBER,
114 p_mode in varchar2 default 'R'
115 );
116
117
118 PROCEDURE Sets_Update_Row
119 (
120 p_api_version IN NUMBER,
121 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
122 p_commit IN VARCHAR2 := FND_API.G_FALSE,
123 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124 p_return_status OUT NOCOPY VARCHAR2,
125 p_msg_count OUT NOCOPY NUMBER,
126 p_msg_data OUT NOCOPY VARCHAR2,
127 --
128 p_Flex_Mapping_Set_ID IN NUMBER,
129 p_Name IN VARCHAR2,
130 p_Description IN VARCHAR2,
131 p_set_of_books_id IN NUMBER,
132 p_mode in varchar2 default 'R'
133 );
134
135 PROCEDURE Sets_Lock_Row
136 (
137 p_api_version IN NUMBER,
138 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
139 p_commit IN VARCHAR2 := FND_API.G_FALSE,
140 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
141 p_return_status OUT NOCOPY VARCHAR2,
142 p_msg_count OUT NOCOPY NUMBER,
143 p_msg_data OUT NOCOPY VARCHAR2,
144 --
145 p_Flex_Mapping_Set_ID IN NUMBER,
146 p_Name IN VARCHAR2,
147 p_Description IN VARCHAR2,
148 p_set_of_books_id IN NUMBER,
149 --
150 p_row_locked OUT NOCOPY VARCHAR2
151 );
152 PROCEDURE Sets_Delete_Row
153 (
154 p_api_version IN NUMBER,
155 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
156 p_commit IN VARCHAR2 := FND_API.G_FALSE,
157 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
158 p_return_status OUT NOCOPY VARCHAR2,
159 p_msg_count OUT NOCOPY NUMBER,
160 p_msg_data OUT NOCOPY VARCHAR2,
161 --
162 p_Flex_Mapping_Set_ID IN NUMBER
163 );
164
165 --
166 PROCEDURE Flex_Info
167 ( p_return_status OUT NOCOPY VARCHAR2,
168 p_flex_code IN NUMBER
169 );
170 --
171 FUNCTION Get_Mapped_CCID
172 (
173 p_api_version IN NUMBER,
174 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
175 p_commit IN VARCHAR2 := FND_API.G_FALSE,
176 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
177 --
178 p_CCID IN NUMBER,
179 p_Budget_Year_Type_ID IN NUMBER,
180 p_Flexfield_Mapping_Set_ID IN NUMBER,
181 p_Mapping_Mode IN VARCHAR2 := 'WORKSHEET'
182
183 ) RETURN NUMBER;
184
185 FUNCTION Get_Mapped_Account
186 (
187 p_api_version IN NUMBER,
188 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
189 p_commit IN VARCHAR2 := FND_API.G_FALSE,
190 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
191 --
192 p_CCID IN NUMBER,
193 p_Budget_Year_Type_ID IN NUMBER,
194 p_Flexfield_Mapping_Set_ID IN NUMBER
195
196 ) RETURN VARCHAR2;
197
198 PROCEDURE Pass_View_Parameters ( p_flex_set_id IN NUMBER,
199 p_application_column_name IN VARCHAR2);
200 FUNCTION Get_Application_Column_Name RETURN varchar2;
201 pragma RESTRICT_REFERENCES ( Get_Application_Column_Name, WNDS, WNPS );
202
203 FUNCTION Get_Flex_Set_ID RETURN NUMBER;
204 pragma RESTRICT_REFERENCES ( Get_Flex_Set_ID, WNDS, WNPS );
205
206 END PSB_Flex_Mapping_PVT ;