DBA Data[Home] [Help]

APPS.AMS_SYSTEM_PRETTY_URL_PVT dependencies on FND_API

Line 50: system_url_id NUMBER := FND_API.G_MISS_NUM,

46:
47: --===================================================================
48: TYPE system_pretty_url_rec_type IS RECORD
49: (
50: system_url_id NUMBER := FND_API.G_MISS_NUM,
51: creation_date DATE := FND_API.G_MISS_DATE,
52: created_by NUMBER := FND_API.G_MISS_NUM,
53: last_update_date DATE := FND_API.G_MISS_DATE,
54: last_updated_by NUMBER := FND_API.G_MISS_NUM,

Line 51: creation_date DATE := FND_API.G_MISS_DATE,

47: --===================================================================
48: TYPE system_pretty_url_rec_type IS RECORD
49: (
50: system_url_id NUMBER := FND_API.G_MISS_NUM,
51: creation_date DATE := FND_API.G_MISS_DATE,
52: created_by NUMBER := FND_API.G_MISS_NUM,
53: last_update_date DATE := FND_API.G_MISS_DATE,
54: last_updated_by NUMBER := FND_API.G_MISS_NUM,
55: last_update_login NUMBER := FND_API.G_MISS_NUM,

Line 52: created_by NUMBER := FND_API.G_MISS_NUM,

48: TYPE system_pretty_url_rec_type IS RECORD
49: (
50: system_url_id NUMBER := FND_API.G_MISS_NUM,
51: creation_date DATE := FND_API.G_MISS_DATE,
52: created_by NUMBER := FND_API.G_MISS_NUM,
53: last_update_date DATE := FND_API.G_MISS_DATE,
54: last_updated_by NUMBER := FND_API.G_MISS_NUM,
55: last_update_login NUMBER := FND_API.G_MISS_NUM,
56: object_version_number NUMBER := FND_API.G_MISS_NUM,

Line 53: last_update_date DATE := FND_API.G_MISS_DATE,

49: (
50: system_url_id NUMBER := FND_API.G_MISS_NUM,
51: creation_date DATE := FND_API.G_MISS_DATE,
52: created_by NUMBER := FND_API.G_MISS_NUM,
53: last_update_date DATE := FND_API.G_MISS_DATE,
54: last_updated_by NUMBER := FND_API.G_MISS_NUM,
55: last_update_login NUMBER := FND_API.G_MISS_NUM,
56: object_version_number NUMBER := FND_API.G_MISS_NUM,
57: pretty_url_id NUMBER := FND_API.G_MISS_NUM,

Line 54: last_updated_by NUMBER := FND_API.G_MISS_NUM,

50: system_url_id NUMBER := FND_API.G_MISS_NUM,
51: creation_date DATE := FND_API.G_MISS_DATE,
52: created_by NUMBER := FND_API.G_MISS_NUM,
53: last_update_date DATE := FND_API.G_MISS_DATE,
54: last_updated_by NUMBER := FND_API.G_MISS_NUM,
55: last_update_login NUMBER := FND_API.G_MISS_NUM,
56: object_version_number NUMBER := FND_API.G_MISS_NUM,
57: pretty_url_id NUMBER := FND_API.G_MISS_NUM,
58: additional_url_param VARCHAR2(2000) := FND_API.G_MISS_CHAR,

Line 55: last_update_login NUMBER := FND_API.G_MISS_NUM,

51: creation_date DATE := FND_API.G_MISS_DATE,
52: created_by NUMBER := FND_API.G_MISS_NUM,
53: last_update_date DATE := FND_API.G_MISS_DATE,
54: last_updated_by NUMBER := FND_API.G_MISS_NUM,
55: last_update_login NUMBER := FND_API.G_MISS_NUM,
56: object_version_number NUMBER := FND_API.G_MISS_NUM,
57: pretty_url_id NUMBER := FND_API.G_MISS_NUM,
58: additional_url_param VARCHAR2(2000) := FND_API.G_MISS_CHAR,
59: system_url VARCHAR2(4000) := FND_API.G_MISS_CHAR,

Line 56: object_version_number NUMBER := FND_API.G_MISS_NUM,

52: created_by NUMBER := FND_API.G_MISS_NUM,
53: last_update_date DATE := FND_API.G_MISS_DATE,
54: last_updated_by NUMBER := FND_API.G_MISS_NUM,
55: last_update_login NUMBER := FND_API.G_MISS_NUM,
56: object_version_number NUMBER := FND_API.G_MISS_NUM,
57: pretty_url_id NUMBER := FND_API.G_MISS_NUM,
58: additional_url_param VARCHAR2(2000) := FND_API.G_MISS_CHAR,
59: system_url VARCHAR2(4000) := FND_API.G_MISS_CHAR,
60: ctd_id NUMBER := FND_API.G_MISS_NUM,

Line 57: pretty_url_id NUMBER := FND_API.G_MISS_NUM,

53: last_update_date DATE := FND_API.G_MISS_DATE,
54: last_updated_by NUMBER := FND_API.G_MISS_NUM,
55: last_update_login NUMBER := FND_API.G_MISS_NUM,
56: object_version_number NUMBER := FND_API.G_MISS_NUM,
57: pretty_url_id NUMBER := FND_API.G_MISS_NUM,
58: additional_url_param VARCHAR2(2000) := FND_API.G_MISS_CHAR,
59: system_url VARCHAR2(4000) := FND_API.G_MISS_CHAR,
60: ctd_id NUMBER := FND_API.G_MISS_NUM,
61: track_url VARCHAR2(2000) := FND_API.G_MISS_CHAR

Line 58: additional_url_param VARCHAR2(2000) := FND_API.G_MISS_CHAR,

54: last_updated_by NUMBER := FND_API.G_MISS_NUM,
55: last_update_login NUMBER := FND_API.G_MISS_NUM,
56: object_version_number NUMBER := FND_API.G_MISS_NUM,
57: pretty_url_id NUMBER := FND_API.G_MISS_NUM,
58: additional_url_param VARCHAR2(2000) := FND_API.G_MISS_CHAR,
59: system_url VARCHAR2(4000) := FND_API.G_MISS_CHAR,
60: ctd_id NUMBER := FND_API.G_MISS_NUM,
61: track_url VARCHAR2(2000) := FND_API.G_MISS_CHAR
62: );

Line 59: system_url VARCHAR2(4000) := FND_API.G_MISS_CHAR,

55: last_update_login NUMBER := FND_API.G_MISS_NUM,
56: object_version_number NUMBER := FND_API.G_MISS_NUM,
57: pretty_url_id NUMBER := FND_API.G_MISS_NUM,
58: additional_url_param VARCHAR2(2000) := FND_API.G_MISS_CHAR,
59: system_url VARCHAR2(4000) := FND_API.G_MISS_CHAR,
60: ctd_id NUMBER := FND_API.G_MISS_NUM,
61: track_url VARCHAR2(2000) := FND_API.G_MISS_CHAR
62: );
63:

Line 60: ctd_id NUMBER := FND_API.G_MISS_NUM,

56: object_version_number NUMBER := FND_API.G_MISS_NUM,
57: pretty_url_id NUMBER := FND_API.G_MISS_NUM,
58: additional_url_param VARCHAR2(2000) := FND_API.G_MISS_CHAR,
59: system_url VARCHAR2(4000) := FND_API.G_MISS_CHAR,
60: ctd_id NUMBER := FND_API.G_MISS_NUM,
61: track_url VARCHAR2(2000) := FND_API.G_MISS_CHAR
62: );
63:
64: g_miss_system_pretty_url_rec system_pretty_url_rec_type;

Line 61: track_url VARCHAR2(2000) := FND_API.G_MISS_CHAR

57: pretty_url_id NUMBER := FND_API.G_MISS_NUM,
58: additional_url_param VARCHAR2(2000) := FND_API.G_MISS_CHAR,
59: system_url VARCHAR2(4000) := FND_API.G_MISS_CHAR,
60: ctd_id NUMBER := FND_API.G_MISS_NUM,
61: track_url VARCHAR2(2000) := FND_API.G_MISS_CHAR
62: );
63:
64: g_miss_system_pretty_url_rec system_pretty_url_rec_type;
65: TYPE system_pretty_url_tbl_type IS TABLE OF system_pretty_url_rec_type INDEX BY BINARY_INTEGER;

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

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_system_pretty_url_rec IN system_pretty_url_rec_type Required
85: --

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

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_system_pretty_url_rec IN system_pretty_url_rec_type Required
85: --
86: -- OUT NOCOPY

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

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_system_pretty_url_rec IN system_pretty_url_rec_type Required
85: --
86: -- OUT NOCOPY
87: -- x_return_status OUT NOCOPY VARCHAR2

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

96: --
97:
98: PROCEDURE Create_System_Pretty_Url(
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,

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

97:
98: PROCEDURE Create_System_Pretty_Url(
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,

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

98: PROCEDURE Create_System_Pretty_Url(
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,

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

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_system_pretty_url_rec IN system_pretty_url_rec_type Required
129: --

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

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_system_pretty_url_rec IN system_pretty_url_rec_type Required
129: --
130: -- OUT NOCOPY

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

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_system_pretty_url_rec IN system_pretty_url_rec_type Required
129: --
130: -- OUT NOCOPY
131: -- x_return_status OUT NOCOPY VARCHAR2

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

140: --
141:
142: PROCEDURE Update_System_Pretty_Url(
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,

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

141:
142: PROCEDURE Update_System_Pretty_Url(
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,

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

142: PROCEDURE Update_System_Pretty_Url(
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,

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

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_SYSTEM_URL_ID IN NUMBER
173: -- p_object_version_number IN NUMBER Optional Default = NULL

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

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_SYSTEM_URL_ID IN NUMBER
173: -- p_object_version_number IN NUMBER Optional Default = NULL
174: --

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

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_SYSTEM_URL_ID IN NUMBER
173: -- p_object_version_number IN NUMBER Optional Default = NULL
174: --
175: -- OUT NOCOPY

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

185: --
186:
187: PROCEDURE Delete_System_Pretty_Url(
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,

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

186:
187: PROCEDURE Delete_System_Pretty_Url(
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,

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

187: PROCEDURE Delete_System_Pretty_Url(
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_system_url_id IN NUMBER,

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

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_system_pretty_url_rec IN system_pretty_url_rec_type Required
216: --

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

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_system_pretty_url_rec IN system_pretty_url_rec_type Required
216: --
217: -- OUT NOCOPY

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

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_system_pretty_url_rec IN system_pretty_url_rec_type Required
216: --
217: -- OUT NOCOPY
218: -- x_return_status OUT NOCOPY VARCHAR2

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

227: --
228:
229: PROCEDURE Lock_System_Pretty_Url(
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,

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

251: -- End of Comments
252:
253: PROCEDURE Validate_system_pretty_url(
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_system_pretty_url_rec IN system_pretty_url_rec_type,
258: x_return_status OUT NOCOPY VARCHAR2,
259: x_msg_count OUT NOCOPY NUMBER,

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

252:
253: PROCEDURE Validate_system_pretty_url(
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_system_pretty_url_rec IN system_pretty_url_rec_type,
258: x_return_status OUT NOCOPY VARCHAR2,
259: x_msg_count OUT NOCOPY NUMBER,
260: x_msg_data OUT NOCOPY VARCHAR2

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

289: -- End of Comments
290:
291: PROCEDURE Validate_system_pretty_url_rec(
292: p_api_version_number IN NUMBER,
293: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
294: x_return_status OUT NOCOPY VARCHAR2,
295: x_msg_count OUT NOCOPY NUMBER,
296: x_msg_data OUT NOCOPY VARCHAR2,
297: p_system_pretty_url_rec IN system_pretty_url_rec_type