46:
47: --===================================================================
48: TYPE iba_pl_stylesheets_rec_type IS RECORD
49: (
50: stylesheet_id NUMBER := FND_API.G_MISS_NUM,
51: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: stylesheet_filename VARCHAR2(500) := FND_API.G_MISS_CHAR,
53: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: created_by NUMBER := FND_API.G_MISS_NUM,
47: --===================================================================
48: TYPE iba_pl_stylesheets_rec_type IS RECORD
49: (
50: stylesheet_id NUMBER := FND_API.G_MISS_NUM,
51: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: stylesheet_filename VARCHAR2(500) := FND_API.G_MISS_CHAR,
53: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: created_by NUMBER := FND_API.G_MISS_NUM,
55: creation_date DATE := FND_API.G_MISS_DATE,
48: TYPE iba_pl_stylesheets_rec_type IS RECORD
49: (
50: stylesheet_id NUMBER := FND_API.G_MISS_NUM,
51: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: stylesheet_filename VARCHAR2(500) := FND_API.G_MISS_CHAR,
53: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: created_by NUMBER := FND_API.G_MISS_NUM,
55: creation_date DATE := FND_API.G_MISS_DATE,
56: last_updated_by NUMBER := FND_API.G_MISS_NUM,
49: (
50: stylesheet_id NUMBER := FND_API.G_MISS_NUM,
51: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: stylesheet_filename VARCHAR2(500) := FND_API.G_MISS_CHAR,
53: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: created_by NUMBER := FND_API.G_MISS_NUM,
55: creation_date DATE := FND_API.G_MISS_DATE,
56: last_updated_by NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
50: stylesheet_id NUMBER := FND_API.G_MISS_NUM,
51: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: stylesheet_filename VARCHAR2(500) := FND_API.G_MISS_CHAR,
53: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: created_by NUMBER := FND_API.G_MISS_NUM,
55: creation_date DATE := FND_API.G_MISS_DATE,
56: last_updated_by NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
51: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: stylesheet_filename VARCHAR2(500) := FND_API.G_MISS_CHAR,
53: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: created_by NUMBER := FND_API.G_MISS_NUM,
55: creation_date DATE := FND_API.G_MISS_DATE,
56: last_updated_by NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: object_version_number NUMBER := FND_API.G_MISS_NUM,
52: stylesheet_filename VARCHAR2(500) := FND_API.G_MISS_CHAR,
53: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: created_by NUMBER := FND_API.G_MISS_NUM,
55: creation_date DATE := FND_API.G_MISS_DATE,
56: last_updated_by NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: object_version_number NUMBER := FND_API.G_MISS_NUM,
60: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
53: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: created_by NUMBER := FND_API.G_MISS_NUM,
55: creation_date DATE := FND_API.G_MISS_DATE,
56: last_updated_by NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: object_version_number NUMBER := FND_API.G_MISS_NUM,
60: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
61: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
54: created_by NUMBER := FND_API.G_MISS_NUM,
55: creation_date DATE := FND_API.G_MISS_DATE,
56: last_updated_by NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: object_version_number NUMBER := FND_API.G_MISS_NUM,
60: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
61: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
62: );
55: creation_date DATE := FND_API.G_MISS_DATE,
56: last_updated_by NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: object_version_number NUMBER := FND_API.G_MISS_NUM,
60: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
61: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
62: );
63:
56: last_updated_by NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: object_version_number NUMBER := FND_API.G_MISS_NUM,
60: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
61: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
62: );
63:
64: g_miss_iba_pl_stylesheets_rec iba_pl_stylesheets_rec_type;
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: object_version_number NUMBER := FND_API.G_MISS_NUM,
60: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
61: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
62: );
63:
64: g_miss_iba_pl_stylesheets_rec iba_pl_stylesheets_rec_type;
65: TYPE iba_pl_stylesheets_tbl_type IS TABLE OF iba_pl_stylesheets_rec_type INDEX BY BINARY_INTEGER;
77: -- Parameters
78: --
79: -- IN
80: -- p_api_version_number IN NUMBER Required
81: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
82: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
83: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
84: -- p_iba_pl_stylesheets_rec IN iba_pl_stylesheets_rec_type Required
85: --
78: --
79: -- IN
80: -- p_api_version_number IN NUMBER Required
81: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
82: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
83: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
84: -- p_iba_pl_stylesheets_rec IN iba_pl_stylesheets_rec_type Required
85: --
86: -- OUT
79: -- IN
80: -- p_api_version_number IN NUMBER Required
81: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
82: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
83: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
84: -- p_iba_pl_stylesheets_rec IN iba_pl_stylesheets_rec_type Required
85: --
86: -- OUT
87: -- x_return_status OUT VARCHAR2
96: --
97:
98: PROCEDURE Create_Iba_Pl_Stylesheets(
99: p_api_version_number 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:
104: x_return_status OUT NOCOPY VARCHAR2,
97:
98: PROCEDURE Create_Iba_Pl_Stylesheets(
99: p_api_version_number 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:
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
98: PROCEDURE Create_Iba_Pl_Stylesheets(
99: p_api_version_number 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:
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,
121: -- Parameters
122: --
123: -- IN
124: -- p_api_version_number IN NUMBER Required
125: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
126: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
127: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
128: -- p_iba_pl_stylesheets_rec IN iba_pl_stylesheets_rec_type Required
129: --
122: --
123: -- IN
124: -- p_api_version_number IN NUMBER Required
125: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
126: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
127: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
128: -- p_iba_pl_stylesheets_rec IN iba_pl_stylesheets_rec_type Required
129: --
130: -- OUT
123: -- IN
124: -- p_api_version_number IN NUMBER Required
125: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
126: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
127: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
128: -- p_iba_pl_stylesheets_rec IN iba_pl_stylesheets_rec_type Required
129: --
130: -- OUT
131: -- x_return_status OUT VARCHAR2
140: --
141:
142: PROCEDURE Update_Iba_Pl_Stylesheets(
143: p_api_version_number IN NUMBER,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147:
148: x_return_status OUT NOCOPY VARCHAR2,
141:
142: PROCEDURE Update_Iba_Pl_Stylesheets(
143: p_api_version_number IN NUMBER,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147:
148: x_return_status OUT NOCOPY VARCHAR2,
149: x_msg_count OUT NOCOPY NUMBER,
142: PROCEDURE Update_Iba_Pl_Stylesheets(
143: p_api_version_number IN NUMBER,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147:
148: x_return_status OUT NOCOPY VARCHAR2,
149: x_msg_count OUT NOCOPY NUMBER,
150: x_msg_data OUT NOCOPY VARCHAR2,
165: -- Parameters
166: --
167: -- IN
168: -- p_api_version_number IN NUMBER Required
169: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
170: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
171: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
172: -- p_STYLESHEET_ID IN NUMBER
173: -- p_object_version_number IN NUMBER Optional Default = NULL
166: --
167: -- IN
168: -- p_api_version_number IN NUMBER Required
169: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
170: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
171: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
172: -- p_STYLESHEET_ID IN NUMBER
173: -- p_object_version_number IN NUMBER Optional Default = NULL
174: --
167: -- IN
168: -- p_api_version_number IN NUMBER Required
169: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
170: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
171: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
172: -- p_STYLESHEET_ID IN NUMBER
173: -- p_object_version_number IN NUMBER Optional Default = NULL
174: --
175: -- OUT
185: --
186:
187: PROCEDURE Delete_Iba_Pl_Stylesheets(
188: p_api_version_number IN NUMBER,
189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
190: p_commit IN VARCHAR2 := FND_API.G_FALSE,
191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
192: x_return_status OUT NOCOPY VARCHAR2,
193: x_msg_count OUT NOCOPY NUMBER,
186:
187: PROCEDURE Delete_Iba_Pl_Stylesheets(
188: p_api_version_number IN NUMBER,
189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
190: p_commit IN VARCHAR2 := FND_API.G_FALSE,
191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
192: x_return_status OUT NOCOPY VARCHAR2,
193: x_msg_count OUT NOCOPY NUMBER,
194: x_msg_data OUT NOCOPY VARCHAR2,
187: PROCEDURE Delete_Iba_Pl_Stylesheets(
188: p_api_version_number IN NUMBER,
189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
190: p_commit IN VARCHAR2 := FND_API.G_FALSE,
191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
192: x_return_status OUT NOCOPY VARCHAR2,
193: x_msg_count OUT NOCOPY NUMBER,
194: x_msg_data OUT NOCOPY VARCHAR2,
195: p_stylesheet_id IN NUMBER,
208: -- Parameters
209: --
210: -- IN
211: -- p_api_version_number IN NUMBER Required
212: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
213: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
214: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
215: -- p_iba_pl_stylesheets_rec IN iba_pl_stylesheets_rec_type Required
216: --
209: --
210: -- IN
211: -- p_api_version_number IN NUMBER Required
212: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
213: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
214: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
215: -- p_iba_pl_stylesheets_rec IN iba_pl_stylesheets_rec_type Required
216: --
217: -- OUT
210: -- IN
211: -- p_api_version_number IN NUMBER Required
212: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
213: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
214: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
215: -- p_iba_pl_stylesheets_rec IN iba_pl_stylesheets_rec_type Required
216: --
217: -- OUT
218: -- x_return_status OUT VARCHAR2
227: --
228:
229: PROCEDURE Lock_Iba_Pl_Stylesheets(
230: p_api_version_number IN NUMBER,
231: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
232:
233: x_return_status OUT NOCOPY VARCHAR2,
234: x_msg_count OUT NOCOPY NUMBER,
235: x_msg_data OUT NOCOPY VARCHAR2,
251: -- End of Comments
252:
253: PROCEDURE Validate_iba_pl_stylesheets(
254: p_api_version_number IN NUMBER
255: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
256: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
257: , p_iba_pl_stylesheets_rec IN iba_pl_stylesheets_rec_type
258: , x_return_status OUT NOCOPY VARCHAR2
259: , x_msg_count OUT NOCOPY NUMBER
252:
253: PROCEDURE Validate_iba_pl_stylesheets(
254: p_api_version_number IN NUMBER
255: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
256: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
257: , p_iba_pl_stylesheets_rec IN iba_pl_stylesheets_rec_type
258: , x_return_status OUT NOCOPY VARCHAR2
259: , x_msg_count OUT NOCOPY NUMBER
260: , x_msg_data OUT NOCOPY VARCHAR2
290: -- End of Comments
291:
292: PROCEDURE Validate_iba_pl_style_rec(
293: p_api_version_number IN NUMBER,
294: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
295: x_return_status OUT NOCOPY VARCHAR2,
296: x_msg_count OUT NOCOPY NUMBER,
297: x_msg_data OUT NOCOPY VARCHAR2,
298: p_iba_pl_stylesheets_rec IN iba_pl_stylesheets_rec_type