DBA Data[Home] [Help]

APPS.AMS_PRTY_URL_ASSOC_PVT dependencies on FND_API

Line 48: assoc_id NUMBER := FND_API.G_MISS_NUM,

44:
45: --===================================================================
46: TYPE prty_url_assoc_rec_type IS RECORD
47: (
48: assoc_id NUMBER := FND_API.G_MISS_NUM,
49: creation_date DATE := FND_API.G_MISS_DATE,
50: created_by NUMBER := FND_API.G_MISS_NUM,
51: last_update_date DATE := FND_API.G_MISS_DATE,
52: last_updated_by NUMBER := FND_API.G_MISS_NUM,

Line 49: creation_date DATE := FND_API.G_MISS_DATE,

45: --===================================================================
46: TYPE prty_url_assoc_rec_type IS RECORD
47: (
48: assoc_id NUMBER := FND_API.G_MISS_NUM,
49: creation_date DATE := FND_API.G_MISS_DATE,
50: created_by NUMBER := FND_API.G_MISS_NUM,
51: last_update_date DATE := FND_API.G_MISS_DATE,
52: last_updated_by NUMBER := FND_API.G_MISS_NUM,
53: last_update_login NUMBER := FND_API.G_MISS_NUM,

Line 50: created_by NUMBER := FND_API.G_MISS_NUM,

46: TYPE prty_url_assoc_rec_type IS RECORD
47: (
48: assoc_id NUMBER := FND_API.G_MISS_NUM,
49: creation_date DATE := FND_API.G_MISS_DATE,
50: created_by NUMBER := FND_API.G_MISS_NUM,
51: last_update_date DATE := FND_API.G_MISS_DATE,
52: last_updated_by NUMBER := FND_API.G_MISS_NUM,
53: last_update_login NUMBER := FND_API.G_MISS_NUM,
54: object_version_number NUMBER := FND_API.G_MISS_NUM,

Line 51: last_update_date DATE := FND_API.G_MISS_DATE,

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

Line 52: last_updated_by NUMBER := FND_API.G_MISS_NUM,

48: assoc_id NUMBER := FND_API.G_MISS_NUM,
49: creation_date DATE := FND_API.G_MISS_DATE,
50: created_by NUMBER := FND_API.G_MISS_NUM,
51: last_update_date DATE := FND_API.G_MISS_DATE,
52: last_updated_by NUMBER := FND_API.G_MISS_NUM,
53: last_update_login NUMBER := FND_API.G_MISS_NUM,
54: object_version_number NUMBER := FND_API.G_MISS_NUM,
55: system_url_id NUMBER := FND_API.G_MISS_NUM,
56: used_by_obj_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 53: last_update_login NUMBER := FND_API.G_MISS_NUM,

49: creation_date DATE := FND_API.G_MISS_DATE,
50: created_by NUMBER := FND_API.G_MISS_NUM,
51: last_update_date DATE := FND_API.G_MISS_DATE,
52: last_updated_by NUMBER := FND_API.G_MISS_NUM,
53: last_update_login NUMBER := FND_API.G_MISS_NUM,
54: object_version_number NUMBER := FND_API.G_MISS_NUM,
55: system_url_id NUMBER := FND_API.G_MISS_NUM,
56: used_by_obj_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: used_by_obj_id NUMBER := FND_API.G_MISS_NUM

Line 54: object_version_number NUMBER := FND_API.G_MISS_NUM,

50: created_by NUMBER := FND_API.G_MISS_NUM,
51: last_update_date DATE := FND_API.G_MISS_DATE,
52: last_updated_by NUMBER := FND_API.G_MISS_NUM,
53: last_update_login NUMBER := FND_API.G_MISS_NUM,
54: object_version_number NUMBER := FND_API.G_MISS_NUM,
55: system_url_id NUMBER := FND_API.G_MISS_NUM,
56: used_by_obj_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: used_by_obj_id NUMBER := FND_API.G_MISS_NUM
58: );

Line 55: system_url_id NUMBER := FND_API.G_MISS_NUM,

51: last_update_date DATE := FND_API.G_MISS_DATE,
52: last_updated_by NUMBER := FND_API.G_MISS_NUM,
53: last_update_login NUMBER := FND_API.G_MISS_NUM,
54: object_version_number NUMBER := FND_API.G_MISS_NUM,
55: system_url_id NUMBER := FND_API.G_MISS_NUM,
56: used_by_obj_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: used_by_obj_id NUMBER := FND_API.G_MISS_NUM
58: );
59:

Line 56: used_by_obj_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

52: last_updated_by NUMBER := FND_API.G_MISS_NUM,
53: last_update_login NUMBER := FND_API.G_MISS_NUM,
54: object_version_number NUMBER := FND_API.G_MISS_NUM,
55: system_url_id NUMBER := FND_API.G_MISS_NUM,
56: used_by_obj_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: used_by_obj_id NUMBER := FND_API.G_MISS_NUM
58: );
59:
60: g_miss_prty_url_assoc_rec prty_url_assoc_rec_type;

Line 57: used_by_obj_id NUMBER := FND_API.G_MISS_NUM

53: last_update_login NUMBER := FND_API.G_MISS_NUM,
54: object_version_number NUMBER := FND_API.G_MISS_NUM,
55: system_url_id NUMBER := FND_API.G_MISS_NUM,
56: used_by_obj_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: used_by_obj_id NUMBER := FND_API.G_MISS_NUM
58: );
59:
60: g_miss_prty_url_assoc_rec prty_url_assoc_rec_type;
61: TYPE prty_url_assoc_tbl_type IS TABLE OF prty_url_assoc_rec_type INDEX BY BINARY_INTEGER;

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

73: -- Parameters
74: --
75: -- IN
76: -- p_api_version_number IN NUMBER Required
77: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
78: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
79: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
80: -- p_prty_url_assoc_rec IN prty_url_assoc_rec_type Required
81: --

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

74: --
75: -- IN
76: -- p_api_version_number IN NUMBER Required
77: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
78: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
79: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
80: -- p_prty_url_assoc_rec IN prty_url_assoc_rec_type Required
81: --
82: -- OUT NOCOPY

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

75: -- IN
76: -- p_api_version_number IN NUMBER Required
77: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
78: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
79: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
80: -- p_prty_url_assoc_rec IN prty_url_assoc_rec_type Required
81: --
82: -- OUT NOCOPY
83: -- x_return_status OUT NOCOPY VARCHAR2

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

92: --
93:
94: PROCEDURE Create_Prty_Url_Assoc(
95: p_api_version_number IN NUMBER,
96: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97: p_commit IN VARCHAR2 := FND_API.G_FALSE,
98: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
99:
100: x_return_status OUT NOCOPY VARCHAR2,

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

93:
94: PROCEDURE Create_Prty_Url_Assoc(
95: p_api_version_number IN NUMBER,
96: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97: p_commit IN VARCHAR2 := FND_API.G_FALSE,
98: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
99:
100: x_return_status OUT NOCOPY VARCHAR2,
101: x_msg_count OUT NOCOPY NUMBER,

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

94: PROCEDURE Create_Prty_Url_Assoc(
95: p_api_version_number IN NUMBER,
96: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97: p_commit IN VARCHAR2 := FND_API.G_FALSE,
98: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
99:
100: x_return_status OUT NOCOPY VARCHAR2,
101: x_msg_count OUT NOCOPY NUMBER,
102: x_msg_data OUT NOCOPY VARCHAR2,

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

117: -- Parameters
118: --
119: -- IN
120: -- p_api_version_number IN NUMBER Required
121: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
122: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
123: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
124: -- p_prty_url_assoc_rec IN prty_url_assoc_rec_type Required
125: --

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

118: --
119: -- IN
120: -- p_api_version_number IN NUMBER Required
121: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
122: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
123: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
124: -- p_prty_url_assoc_rec IN prty_url_assoc_rec_type Required
125: --
126: -- OUT NOCOPY

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

119: -- IN
120: -- p_api_version_number IN NUMBER Required
121: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
122: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
123: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
124: -- p_prty_url_assoc_rec IN prty_url_assoc_rec_type Required
125: --
126: -- OUT NOCOPY
127: -- x_return_status OUT NOCOPY VARCHAR2

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

136: --
137:
138: PROCEDURE Update_Prty_Url_Assoc(
139: p_api_version_number IN NUMBER,
140: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
141: p_commit IN VARCHAR2 := FND_API.G_FALSE,
142: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
143:
144: x_return_status OUT NOCOPY VARCHAR2,

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

137:
138: PROCEDURE Update_Prty_Url_Assoc(
139: p_api_version_number IN NUMBER,
140: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
141: p_commit IN VARCHAR2 := FND_API.G_FALSE,
142: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
143:
144: x_return_status OUT NOCOPY VARCHAR2,
145: x_msg_count OUT NOCOPY NUMBER,

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

138: PROCEDURE Update_Prty_Url_Assoc(
139: p_api_version_number IN NUMBER,
140: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
141: p_commit IN VARCHAR2 := FND_API.G_FALSE,
142: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
143:
144: x_return_status OUT NOCOPY VARCHAR2,
145: x_msg_count OUT NOCOPY NUMBER,
146: x_msg_data OUT NOCOPY VARCHAR2,

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

161: -- Parameters
162: --
163: -- IN
164: -- p_api_version_number IN NUMBER Required
165: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
166: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
167: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
168: -- p_ASSOC_ID IN NUMBER
169: -- p_object_version_number IN NUMBER Optional Default = NULL

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

162: --
163: -- IN
164: -- p_api_version_number IN NUMBER Required
165: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
166: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
167: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
168: -- p_ASSOC_ID IN NUMBER
169: -- p_object_version_number IN NUMBER Optional Default = NULL
170: --

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

163: -- IN
164: -- p_api_version_number IN NUMBER Required
165: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
166: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
167: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
168: -- p_ASSOC_ID IN NUMBER
169: -- p_object_version_number IN NUMBER Optional Default = NULL
170: --
171: -- OUT NOCOPY

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

181: --
182:
183: PROCEDURE Delete_Prty_Url_Assoc(
184: p_api_version_number IN NUMBER,
185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
186: p_commit IN VARCHAR2 := FND_API.G_FALSE,
187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,

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

182:
183: PROCEDURE Delete_Prty_Url_Assoc(
184: p_api_version_number IN NUMBER,
185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
186: p_commit IN VARCHAR2 := FND_API.G_FALSE,
187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,

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

183: PROCEDURE Delete_Prty_Url_Assoc(
184: p_api_version_number IN NUMBER,
185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
186: p_commit IN VARCHAR2 := FND_API.G_FALSE,
187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_assoc_id IN NUMBER,

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

204: -- Parameters
205: --
206: -- IN
207: -- p_api_version_number IN NUMBER Required
208: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
209: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
210: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
211: -- p_prty_url_assoc_rec IN prty_url_assoc_rec_type Required
212: --

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

205: --
206: -- IN
207: -- p_api_version_number IN NUMBER Required
208: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
209: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
210: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
211: -- p_prty_url_assoc_rec IN prty_url_assoc_rec_type Required
212: --
213: -- OUT NOCOPY

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

206: -- IN
207: -- p_api_version_number IN NUMBER Required
208: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
209: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
210: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
211: -- p_prty_url_assoc_rec IN prty_url_assoc_rec_type Required
212: --
213: -- OUT NOCOPY
214: -- x_return_status OUT NOCOPY VARCHAR2

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

223: --
224:
225: PROCEDURE Lock_Prty_Url_Assoc(
226: p_api_version_number IN NUMBER,
227: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
228:
229: x_return_status OUT NOCOPY VARCHAR2,
230: x_msg_count OUT NOCOPY NUMBER,
231: x_msg_data OUT NOCOPY VARCHAR2,

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

247: -- End of Comments
248:
249: PROCEDURE Validate_prty_url_assoc(
250: p_api_version_number IN NUMBER,
251: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
252: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
253: p_prty_url_assoc_rec IN prty_url_assoc_rec_type,
254: x_return_status OUT NOCOPY VARCHAR2,
255: x_msg_count OUT NOCOPY NUMBER,

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

248:
249: PROCEDURE Validate_prty_url_assoc(
250: p_api_version_number IN NUMBER,
251: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
252: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
253: p_prty_url_assoc_rec IN prty_url_assoc_rec_type,
254: x_return_status OUT NOCOPY VARCHAR2,
255: x_msg_count OUT NOCOPY NUMBER,
256: x_msg_data OUT NOCOPY VARCHAR2

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

285: -- End of Comments
286:
287: PROCEDURE Validate_prty_url_assoc_rec(
288: p_api_version_number IN NUMBER,
289: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
290: x_return_status OUT NOCOPY VARCHAR2,
291: x_msg_count OUT NOCOPY NUMBER,
292: x_msg_data OUT NOCOPY VARCHAR2,
293: p_prty_url_assoc_rec IN prty_url_assoc_rec_type