APPS.CN_SYS_TABLES_PVT dependencies on FND_API

Line 47: -- Default = FND_API.G_FALSE

43: -- Pre-reqs : None.
44: -- Parameters :
45: -- IN : p_api_version IN NUMBER Required
46: -- p_init_msg_list IN VARCHAR2 Optional
47: -- Default = FND_API.G_FALSE
48: -- p_commit IN VARCHAR2 Optional
49: -- Default = FND_API.G_FALSE
50: -- p_validation_level IN NUMBER Optional
51: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 49: -- Default = FND_API.G_FALSE

45: -- IN : p_api_version IN NUMBER Required
46: -- p_init_msg_list IN VARCHAR2 Optional
47: -- Default = FND_API.G_FALSE
48: -- p_commit IN VARCHAR2 Optional
49: -- Default = FND_API.G_FALSE
50: -- p_validation_level IN NUMBER Optional
51: -- Default = FND_API.G_VALID_LEVEL_FULL
52: -- p_table_rec IN table_rec_type Required
53: -- OUT : x_return_status OUT VARCHAR2(1)

Line 51: -- Default = FND_API.G_VALID_LEVEL_FULL

47: -- Default = FND_API.G_FALSE
48: -- p_commit IN VARCHAR2 Optional
49: -- Default = FND_API.G_FALSE
50: -- p_validation_level IN NUMBER Optional
51: -- Default = FND_API.G_VALID_LEVEL_FULL
52: -- p_table_rec IN table_rec_type Required
53: -- OUT : x_return_status OUT VARCHAR2(1)
54: -- x_msg_count OUT NUMBER
55: -- x_msg_data OUT VARCHAR2(2000)

Line 65: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

61: --
62: -- End of comments
63: PROCEDURE Create_Table
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 :=
68: FND_API.G_VALID_LEVEL_FULL ,
69: p_table_rec IN OUT NOCOPY table_rec_type ,

Line 66: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

62: -- End of comments
63: PROCEDURE Create_Table
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 :=
68: FND_API.G_VALID_LEVEL_FULL ,
69: p_table_rec IN OUT NOCOPY table_rec_type ,
70: x_return_status OUT NOCOPY VARCHAR2 ,

Line 68: FND_API.G_VALID_LEVEL_FULL ,

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 :=
68: FND_API.G_VALID_LEVEL_FULL ,
69: p_table_rec IN OUT NOCOPY table_rec_type ,
70: x_return_status OUT NOCOPY VARCHAR2 ,
71: x_msg_count OUT NOCOPY NUMBER ,
72: x_msg_data OUT NOCOPY VARCHAR2 );

Line 82: -- Default = FND_API.G_FALSE

78: -- Pre-reqs : None.
79: -- Parameters :
80: -- IN : p_api_version IN NUMBER Required
81: -- p_init_msg_list IN VARCHAR2 Optional
82: -- Default = FND_API.G_FALSE
83: -- p_commit IN VARCHAR2 Optional
84: -- Default = FND_API.G_FALSE
85: -- p_validation_level IN NUMBER Optional
86: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 84: -- Default = FND_API.G_FALSE

80: -- IN : p_api_version IN NUMBER Required
81: -- p_init_msg_list IN VARCHAR2 Optional
82: -- Default = FND_API.G_FALSE
83: -- p_commit IN VARCHAR2 Optional
84: -- Default = FND_API.G_FALSE
85: -- p_validation_level IN NUMBER Optional
86: -- Default = FND_API.G_VALID_LEVEL_FULL
87: -- p_old_table_rec IN table_rec_type Required
88: -- p_new_table_rec IN table_rec_type Required

Line 86: -- Default = FND_API.G_VALID_LEVEL_FULL

82: -- Default = FND_API.G_FALSE
83: -- p_commit IN VARCHAR2 Optional
84: -- Default = FND_API.G_FALSE
85: -- p_validation_level IN NUMBER Optional
86: -- Default = FND_API.G_VALID_LEVEL_FULL
87: -- p_old_table_rec IN table_rec_type Required
88: -- p_new_table_rec IN table_rec_type Required
89: -- OUT : x_return_status OUT VARCHAR2(1)
90: -- x_msg_count OUT NUMBER

Line 100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

96: --
97: -- End of comments
98: PROCEDURE Update_Table
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 :=
103: FND_API.G_VALID_LEVEL_FULL ,
104: p_table_rec IN OUT NOCOPY table_rec_type ,

Line 101: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

97: -- End of comments
98: PROCEDURE Update_Table
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 :=
103: FND_API.G_VALID_LEVEL_FULL ,
104: p_table_rec IN OUT NOCOPY table_rec_type ,
105: x_return_status OUT NOCOPY VARCHAR2 ,

Line 103: FND_API.G_VALID_LEVEL_FULL ,

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 :=
103: FND_API.G_VALID_LEVEL_FULL ,
104: p_table_rec IN OUT NOCOPY table_rec_type ,
105: x_return_status OUT NOCOPY VARCHAR2 ,
106: x_msg_count OUT NOCOPY NUMBER ,
107: x_msg_data OUT NOCOPY VARCHAR2 );

Line 117: -- Default = FND_API.G_FALSE

113: -- Pre-reqs : None.
114: -- Parameters :
115: -- IN : p_api_version IN NUMBER Required
116: -- p_init_msg_list IN VARCHAR2 Optional
117: -- Default = FND_API.G_FALSE
118: -- p_commit IN VARCHAR2 Optional
119: -- Default = FND_API.G_FALSE
120: -- p_validation_level IN NUMBER Optional
121: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 119: -- Default = FND_API.G_FALSE

115: -- IN : p_api_version IN NUMBER Required
116: -- p_init_msg_list IN VARCHAR2 Optional
117: -- Default = FND_API.G_FALSE
118: -- p_commit IN VARCHAR2 Optional
119: -- Default = FND_API.G_FALSE
120: -- p_validation_level IN NUMBER Optional
121: -- Default = FND_API.G_VALID_LEVEL_FULL
122: -- p_table_rec IN table_rec_type Required
123: -- OUT : x_return_status OUT VARCHAR2(1)

Line 121: -- Default = FND_API.G_VALID_LEVEL_FULL

117: -- Default = FND_API.G_FALSE
118: -- p_commit IN VARCHAR2 Optional
119: -- Default = FND_API.G_FALSE
120: -- p_validation_level IN NUMBER Optional
121: -- Default = FND_API.G_VALID_LEVEL_FULL
122: -- p_table_rec IN table_rec_type Required
123: -- OUT : x_return_status OUT VARCHAR2(1)
124: -- x_msg_count OUT NUMBER
125: -- x_msg_data OUT VARCHAR2(2000)

Line 136: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

132:
133:
134: PROCEDURE Delete_Table
135: (p_api_version IN NUMBER ,
136: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
137: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
138: p_validation_level IN NUMBER :=
139: FND_API.G_VALID_LEVEL_FULL ,
140: p_table_rec IN table_rec_type ,

Line 137: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

133:
134: PROCEDURE Delete_Table
135: (p_api_version IN NUMBER ,
136: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
137: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
138: p_validation_level IN NUMBER :=
139: FND_API.G_VALID_LEVEL_FULL ,
140: p_table_rec IN table_rec_type ,
141: x_return_status OUT NOCOPY VARCHAR2 ,

Line 139: FND_API.G_VALID_LEVEL_FULL ,

135: (p_api_version IN NUMBER ,
136: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
137: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
138: p_validation_level IN NUMBER :=
139: FND_API.G_VALID_LEVEL_FULL ,
140: p_table_rec IN table_rec_type ,
141: x_return_status OUT NOCOPY VARCHAR2 ,
142: x_msg_count OUT NOCOPY NUMBER ,
143: x_msg_data OUT NOCOPY VARCHAR2 );

Line 154: -- Default = FND_API.G_FALSE

150: -- Pre-reqs : None.
151: -- Parameters :
152: -- IN : p_api_version IN NUMBER Required
153: -- p_init_msg_list IN VARCHAR2 Optional
154: -- Default = FND_API.G_FALSE
155: -- p_commit IN VARCHAR2 Optional
156: -- Default = FND_API.G_FALSE
157: -- p_validation_level IN NUMBER Optional
158: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 156: -- Default = FND_API.G_FALSE

152: -- IN : p_api_version IN NUMBER Required
153: -- p_init_msg_list IN VARCHAR2 Optional
154: -- Default = FND_API.G_FALSE
155: -- p_commit IN VARCHAR2 Optional
156: -- Default = FND_API.G_FALSE
157: -- p_validation_level IN NUMBER Optional
158: -- Default = FND_API.G_VALID_LEVEL_FULL
159: -- p_column_rec IN column_rec_type Required
160: -- OUT : x_return_status OUT VARCHAR2(1)

Line 158: -- Default = FND_API.G_VALID_LEVEL_FULL

154: -- Default = FND_API.G_FALSE
155: -- p_commit IN VARCHAR2 Optional
156: -- Default = FND_API.G_FALSE
157: -- p_validation_level IN NUMBER Optional
158: -- Default = FND_API.G_VALID_LEVEL_FULL
159: -- p_column_rec IN column_rec_type Required
160: -- OUT : x_return_status OUT VARCHAR2(1)
161: -- x_msg_count OUT NUMBER
162: -- x_msg_data OUT VARCHAR2(2000)

Line 173: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

169: -- End of comments
170:
171: PROCEDURE Update_Column
172: (p_api_version IN NUMBER ,
173: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
174: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
175: p_validation_level IN NUMBER :=
176: FND_API.G_VALID_LEVEL_FULL ,
177: p_column_rec IN column_rec_type ,

Line 174: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

170:
171: PROCEDURE Update_Column
172: (p_api_version IN NUMBER ,
173: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
174: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
175: p_validation_level IN NUMBER :=
176: FND_API.G_VALID_LEVEL_FULL ,
177: p_column_rec IN column_rec_type ,
178: x_return_status OUT NOCOPY VARCHAR2 ,

Line 176: FND_API.G_VALID_LEVEL_FULL ,

172: (p_api_version IN NUMBER ,
173: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
174: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
175: p_validation_level IN NUMBER :=
176: FND_API.G_VALID_LEVEL_FULL ,
177: p_column_rec IN column_rec_type ,
178: x_return_status OUT NOCOPY VARCHAR2 ,
179: x_msg_count OUT NOCOPY NUMBER ,
180: x_msg_data OUT NOCOPY VARCHAR2 );

Line 191: -- Default = FND_API.G_FALSE

187: -- Pre-reqs : None.
188: -- Parameters :
189: -- IN : p_api_version IN NUMBER Required
190: -- p_init_msg_list IN VARCHAR2 Optional
191: -- Default = FND_API.G_FALSE
192: -- p_commit IN VARCHAR2 Optional
193: -- Default = FND_API.G_FALSE
194: -- p_validation_level IN NUMBER Optional
195: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 193: -- Default = FND_API.G_FALSE

189: -- IN : p_api_version IN NUMBER Required
190: -- p_init_msg_list IN VARCHAR2 Optional
191: -- Default = FND_API.G_FALSE
192: -- p_commit IN VARCHAR2 Optional
193: -- Default = FND_API.G_FALSE
194: -- p_validation_level IN NUMBER Optional
195: -- Default = FND_API.G_VALID_LEVEL_FULL
196: -- p_column_rec IN column_rec_type Required
197: -- OUT : x_return_status OUT VARCHAR2(1)

Line 195: -- Default = FND_API.G_VALID_LEVEL_FULL

191: -- Default = FND_API.G_FALSE
192: -- p_commit IN VARCHAR2 Optional
193: -- Default = FND_API.G_FALSE
194: -- p_validation_level IN NUMBER Optional
195: -- Default = FND_API.G_VALID_LEVEL_FULL
196: -- p_column_rec IN column_rec_type Required
197: -- OUT : x_return_status OUT VARCHAR2(1)
198: -- x_msg_count OUT NUMBER
199: -- x_msg_data OUT VARCHAR2(2000)

Line 210: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

206: -- End of comments
207:
208: PROCEDURE Insert_Column
209: (p_api_version IN NUMBER ,
210: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
211: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
212: p_validation_level IN NUMBER :=
213: FND_API.G_VALID_LEVEL_FULL ,
214: p_schema_name IN varchar2 ,

Line 211: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

207:
208: PROCEDURE Insert_Column
209: (p_api_version IN NUMBER ,
210: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
211: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
212: p_validation_level IN NUMBER :=
213: FND_API.G_VALID_LEVEL_FULL ,
214: p_schema_name IN varchar2 ,
215: p_table_name IN varchar2 ,

Line 213: FND_API.G_VALID_LEVEL_FULL ,

209: (p_api_version IN NUMBER ,
210: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
211: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
212: p_validation_level IN NUMBER :=
213: FND_API.G_VALID_LEVEL_FULL ,
214: p_schema_name IN varchar2 ,
215: p_table_name IN varchar2 ,
216: p_column_name IN varchar2 ,
217: p_column_rec IN column_rec_type ,

Line 231: -- Default = FND_API.G_FALSE

227: -- Pre-reqs : None.
228: -- Parameters :
229: -- IN : p_api_version IN NUMBER Required
230: -- p_init_msg_list IN VARCHAR2 Optional
231: -- Default = FND_API.G_FALSE
232: -- p_commit IN VARCHAR2 Optional
233: -- Default = FND_API.G_FALSE
234: -- p_validation_level IN NUMBER Optional
235: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 233: -- Default = FND_API.G_FALSE

229: -- IN : p_api_version IN NUMBER Required
230: -- p_init_msg_list IN VARCHAR2 Optional
231: -- Default = FND_API.G_FALSE
232: -- p_commit IN VARCHAR2 Optional
233: -- Default = FND_API.G_FALSE
234: -- p_validation_level IN NUMBER Optional
235: -- Default = FND_API.G_VALID_LEVEL_FULL
236: -- p_column_id IN NUMBER Required
237: -- OUT : x_return_status OUT VARCHAR2(1)

Line 235: -- Default = FND_API.G_VALID_LEVEL_FULL

231: -- Default = FND_API.G_FALSE
232: -- p_commit IN VARCHAR2 Optional
233: -- Default = FND_API.G_FALSE
234: -- p_validation_level IN NUMBER Optional
235: -- Default = FND_API.G_VALID_LEVEL_FULL
236: -- p_column_id IN NUMBER Required
237: -- OUT : x_return_status OUT VARCHAR2(1)
238: -- x_msg_count OUT NUMBER
239: -- x_msg_data OUT VARCHAR2(2000)

Line 251: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

247:
248:
249: PROCEDURE Delete_Column
250: (p_api_version IN NUMBER ,
251: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
252: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
253: p_validation_level IN NUMBER :=
254: FND_API.G_VALID_LEVEL_FULL ,
255: p_column_id IN number ,

Line 252: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

248:
249: PROCEDURE Delete_Column
250: (p_api_version IN NUMBER ,
251: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
252: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
253: p_validation_level IN NUMBER :=
254: FND_API.G_VALID_LEVEL_FULL ,
255: p_column_id IN number ,
256: x_return_status OUT NOCOPY VARCHAR2 ,

Line 254: FND_API.G_VALID_LEVEL_FULL ,

250: (p_api_version IN NUMBER ,
251: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
252: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
253: p_validation_level IN NUMBER :=
254: FND_API.G_VALID_LEVEL_FULL ,
255: p_column_id IN number ,
256: x_return_status OUT NOCOPY VARCHAR2 ,
257: x_msg_count OUT NOCOPY NUMBER ,
258: x_msg_data OUT NOCOPY VARCHAR2 );