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,
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,
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,
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,
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,
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
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: );
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:
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;
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;
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: --
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
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
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,
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,
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,
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: --
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
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
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,
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,
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,
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
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: --
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
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,
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,
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,
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: --
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
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
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,
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,
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
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