DBA Data[Home] [Help]

APPS.AMS_PRETTY_URL_PVT dependencies on FND_API

Line 79: pretty_url_id NUMBER := FND_API.G_MISS_NUM,

75:
76: --===================================================================
77: TYPE pretty_url_rec_type IS RECORD
78: (
79: pretty_url_id NUMBER := FND_API.G_MISS_NUM,
80: creation_date DATE := FND_API.G_MISS_DATE,
81: created_by NUMBER := FND_API.G_MISS_NUM,
82: last_update_date DATE := FND_API.G_MISS_DATE,
83: last_updated_by NUMBER := FND_API.G_MISS_NUM,

Line 80: creation_date DATE := FND_API.G_MISS_DATE,

76: --===================================================================
77: TYPE pretty_url_rec_type IS RECORD
78: (
79: pretty_url_id NUMBER := FND_API.G_MISS_NUM,
80: creation_date DATE := FND_API.G_MISS_DATE,
81: created_by NUMBER := FND_API.G_MISS_NUM,
82: last_update_date DATE := FND_API.G_MISS_DATE,
83: last_updated_by NUMBER := FND_API.G_MISS_NUM,
84: last_update_login NUMBER := FND_API.G_MISS_NUM,

Line 81: created_by NUMBER := FND_API.G_MISS_NUM,

77: TYPE pretty_url_rec_type IS RECORD
78: (
79: pretty_url_id NUMBER := FND_API.G_MISS_NUM,
80: creation_date DATE := FND_API.G_MISS_DATE,
81: created_by NUMBER := FND_API.G_MISS_NUM,
82: last_update_date DATE := FND_API.G_MISS_DATE,
83: last_updated_by NUMBER := FND_API.G_MISS_NUM,
84: last_update_login NUMBER := FND_API.G_MISS_NUM,
85: object_version_number NUMBER := FND_API.G_MISS_NUM,

Line 82: last_update_date DATE := FND_API.G_MISS_DATE,

78: (
79: pretty_url_id NUMBER := FND_API.G_MISS_NUM,
80: creation_date DATE := FND_API.G_MISS_DATE,
81: created_by NUMBER := FND_API.G_MISS_NUM,
82: last_update_date DATE := FND_API.G_MISS_DATE,
83: last_updated_by NUMBER := FND_API.G_MISS_NUM,
84: last_update_login NUMBER := FND_API.G_MISS_NUM,
85: object_version_number NUMBER := FND_API.G_MISS_NUM,
86: landing_page_url VARCHAR2(2000) := FND_API.G_MISS_CHAR

Line 83: last_updated_by NUMBER := FND_API.G_MISS_NUM,

79: pretty_url_id NUMBER := FND_API.G_MISS_NUM,
80: creation_date DATE := FND_API.G_MISS_DATE,
81: created_by NUMBER := FND_API.G_MISS_NUM,
82: last_update_date DATE := FND_API.G_MISS_DATE,
83: last_updated_by NUMBER := FND_API.G_MISS_NUM,
84: last_update_login NUMBER := FND_API.G_MISS_NUM,
85: object_version_number NUMBER := FND_API.G_MISS_NUM,
86: landing_page_url VARCHAR2(2000) := FND_API.G_MISS_CHAR
87: );

Line 84: last_update_login NUMBER := FND_API.G_MISS_NUM,

80: creation_date DATE := FND_API.G_MISS_DATE,
81: created_by NUMBER := FND_API.G_MISS_NUM,
82: last_update_date DATE := FND_API.G_MISS_DATE,
83: last_updated_by NUMBER := FND_API.G_MISS_NUM,
84: last_update_login NUMBER := FND_API.G_MISS_NUM,
85: object_version_number NUMBER := FND_API.G_MISS_NUM,
86: landing_page_url VARCHAR2(2000) := FND_API.G_MISS_CHAR
87: );
88:

Line 85: object_version_number NUMBER := FND_API.G_MISS_NUM,

81: created_by NUMBER := FND_API.G_MISS_NUM,
82: last_update_date DATE := FND_API.G_MISS_DATE,
83: last_updated_by NUMBER := FND_API.G_MISS_NUM,
84: last_update_login NUMBER := FND_API.G_MISS_NUM,
85: object_version_number NUMBER := FND_API.G_MISS_NUM,
86: landing_page_url VARCHAR2(2000) := FND_API.G_MISS_CHAR
87: );
88:
89: g_miss_pretty_url_rec pretty_url_rec_type;

Line 86: landing_page_url VARCHAR2(2000) := FND_API.G_MISS_CHAR

82: last_update_date DATE := FND_API.G_MISS_DATE,
83: last_updated_by NUMBER := FND_API.G_MISS_NUM,
84: last_update_login NUMBER := FND_API.G_MISS_NUM,
85: object_version_number NUMBER := FND_API.G_MISS_NUM,
86: landing_page_url VARCHAR2(2000) := FND_API.G_MISS_CHAR
87: );
88:
89: g_miss_pretty_url_rec pretty_url_rec_type;
90: TYPE pretty_url_tbl_type IS TABLE OF pretty_url_rec_type INDEX BY BINARY_INTEGER;

Line 106: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

102: -- Parameters
103: --
104: -- IN
105: -- p_api_version_number IN NUMBER Required
106: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
107: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
108: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
109: -- p_pretty_url_rec IN pretty_url_rec_type Required
110: --

Line 107: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

103: --
104: -- IN
105: -- p_api_version_number IN NUMBER Required
106: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
107: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
108: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
109: -- p_pretty_url_rec IN pretty_url_rec_type Required
110: --
111: -- OUT NOCOPY

Line 108: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

104: -- IN
105: -- p_api_version_number IN NUMBER Required
106: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
107: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
108: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
109: -- p_pretty_url_rec IN pretty_url_rec_type Required
110: --
111: -- OUT NOCOPY
112: -- x_return_status OUT NOCOPY VARCHAR2

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

121: --
122:
123: PROCEDURE Create_Pretty_Url(
124: p_api_version_number IN NUMBER,
125: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
126: p_commit IN VARCHAR2 := FND_API.G_FALSE,
127: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
128:
129: x_return_status OUT NOCOPY VARCHAR2,

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

122:
123: PROCEDURE Create_Pretty_Url(
124: p_api_version_number IN NUMBER,
125: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
126: p_commit IN VARCHAR2 := FND_API.G_FALSE,
127: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
128:
129: x_return_status OUT NOCOPY VARCHAR2,
130: x_msg_count OUT NOCOPY NUMBER,

Line 127: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

123: PROCEDURE Create_Pretty_Url(
124: p_api_version_number IN NUMBER,
125: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
126: p_commit IN VARCHAR2 := FND_API.G_FALSE,
127: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
128:
129: x_return_status OUT NOCOPY VARCHAR2,
130: x_msg_count OUT NOCOPY NUMBER,
131: x_msg_data OUT NOCOPY VARCHAR2,

Line 150: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

146: -- Parameters
147: --
148: -- IN
149: -- p_api_version_number IN NUMBER Required
150: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
151: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
152: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
153: -- p_pretty_url_rec IN pretty_url_rec_type Required
154: --

Line 151: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

147: --
148: -- IN
149: -- p_api_version_number IN NUMBER Required
150: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
151: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
152: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
153: -- p_pretty_url_rec IN pretty_url_rec_type Required
154: --
155: -- OUT NOCOPY

Line 152: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

148: -- IN
149: -- p_api_version_number IN NUMBER Required
150: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
151: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
152: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
153: -- p_pretty_url_rec IN pretty_url_rec_type Required
154: --
155: -- OUT NOCOPY
156: -- x_return_status OUT NOCOPY VARCHAR2

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

165: --
166:
167: PROCEDURE Update_Pretty_Url(
168: p_api_version_number IN NUMBER,
169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172:
173: x_return_status OUT NOCOPY VARCHAR2,

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

166:
167: PROCEDURE Update_Pretty_Url(
168: p_api_version_number IN NUMBER,
169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172:
173: x_return_status OUT NOCOPY VARCHAR2,
174: x_msg_count OUT NOCOPY NUMBER,

Line 171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

167: PROCEDURE Update_Pretty_Url(
168: p_api_version_number IN NUMBER,
169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172:
173: x_return_status OUT NOCOPY VARCHAR2,
174: x_msg_count OUT NOCOPY NUMBER,
175: x_msg_data OUT NOCOPY VARCHAR2,

Line 194: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

190: -- Parameters
191: --
192: -- IN
193: -- p_api_version_number IN NUMBER Required
194: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
195: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
196: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
197: -- p_PRETTY_URL_ID IN NUMBER
198: -- p_object_version_number IN NUMBER Optional Default = NULL

Line 195: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

191: --
192: -- IN
193: -- p_api_version_number IN NUMBER Required
194: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
195: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
196: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
197: -- p_PRETTY_URL_ID IN NUMBER
198: -- p_object_version_number IN NUMBER Optional Default = NULL
199: --

Line 196: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

192: -- IN
193: -- p_api_version_number IN NUMBER Required
194: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
195: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
196: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
197: -- p_PRETTY_URL_ID IN NUMBER
198: -- p_object_version_number IN NUMBER Optional Default = NULL
199: --
200: -- OUT NOCOPY

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

210: --
211:
212: PROCEDURE Delete_Pretty_Url(
213: p_api_version_number IN NUMBER,
214: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
215: p_commit IN VARCHAR2 := FND_API.G_FALSE,
216: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,

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

211:
212: PROCEDURE Delete_Pretty_Url(
213: p_api_version_number IN NUMBER,
214: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
215: p_commit IN VARCHAR2 := FND_API.G_FALSE,
216: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,
219: x_msg_data OUT NOCOPY VARCHAR2,

Line 216: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

212: PROCEDURE Delete_Pretty_Url(
213: p_api_version_number IN NUMBER,
214: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
215: p_commit IN VARCHAR2 := FND_API.G_FALSE,
216: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,
219: x_msg_data OUT NOCOPY VARCHAR2,
220: p_pretty_url_id IN NUMBER,

Line 237: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

233: -- Parameters
234: --
235: -- IN
236: -- p_api_version_number IN NUMBER Required
237: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
238: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
239: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
240: -- p_pretty_url_rec IN pretty_url_rec_type Required
241: --

Line 238: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

234: --
235: -- IN
236: -- p_api_version_number IN NUMBER Required
237: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
238: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
239: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
240: -- p_pretty_url_rec IN pretty_url_rec_type Required
241: --
242: -- OUT NOCOPY

Line 239: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

235: -- IN
236: -- p_api_version_number IN NUMBER Required
237: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
238: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
239: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
240: -- p_pretty_url_rec IN pretty_url_rec_type Required
241: --
242: -- OUT NOCOPY
243: -- x_return_status OUT NOCOPY VARCHAR2

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

252: --
253:
254: PROCEDURE Lock_Pretty_Url(
255: p_api_version_number IN NUMBER,
256: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
257:
258: x_return_status OUT NOCOPY VARCHAR2,
259: x_msg_count OUT NOCOPY NUMBER,
260: x_msg_data OUT NOCOPY VARCHAR2,

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

276: -- End of Comments
277:
278: PROCEDURE Validate_pretty_url(
279: p_api_version_number IN NUMBER,
280: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
281: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
282: p_pretty_url_rec IN pretty_url_rec_type,
283: x_return_status OUT NOCOPY VARCHAR2,
284: x_msg_count OUT NOCOPY NUMBER,

Line 281: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

277:
278: PROCEDURE Validate_pretty_url(
279: p_api_version_number IN NUMBER,
280: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
281: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
282: p_pretty_url_rec IN pretty_url_rec_type,
283: x_return_status OUT NOCOPY VARCHAR2,
284: x_msg_count OUT NOCOPY NUMBER,
285: x_msg_data OUT NOCOPY VARCHAR2

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

314: -- End of Comments
315:
316: PROCEDURE Validate_pretty_url_rec(
317: p_api_version_number IN NUMBER,
318: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
319: x_return_status OUT NOCOPY VARCHAR2,
320: x_msg_count OUT NOCOPY NUMBER,
321: x_msg_data OUT NOCOPY VARCHAR2,
322: p_pretty_url_rec IN pretty_url_rec_type