80: -- Parameters
81: --
82: -- IN
83: -- p_api_version_number IN NUMBER Required
84: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
85: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
86: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
87: -- p_tap_access_terrs_rec IN tap_access_terrs_rec_type Required
88: --
81: --
82: -- IN
83: -- p_api_version_number IN NUMBER Required
84: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
85: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
86: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
87: -- p_tap_access_terrs_rec IN tap_access_terrs_rec_type Required
88: --
89: -- OUT
82: -- IN
83: -- p_api_version_number IN NUMBER Required
84: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
85: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
86: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
87: -- p_tap_access_terrs_rec IN tap_access_terrs_rec_type Required
88: --
89: -- OUT
90: -- x_return_status OUT VARCHAR2
102: -- ==============================================================================
103:
104: PROCEDURE Create_Tap_Access_Terrs(
105: p_api_version_number IN NUMBER,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109: x_return_status OUT NOCOPY VARCHAR2,
110: x_msg_count OUT NOCOPY NUMBER,
103:
104: PROCEDURE Create_Tap_Access_Terrs(
105: p_api_version_number IN NUMBER,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109: x_return_status OUT NOCOPY VARCHAR2,
110: x_msg_count OUT NOCOPY NUMBER,
111: x_msg_data OUT NOCOPY VARCHAR2,
104: PROCEDURE Create_Tap_Access_Terrs(
105: p_api_version_number IN NUMBER,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109: x_return_status OUT NOCOPY VARCHAR2,
110: x_msg_count OUT NOCOPY NUMBER,
111: x_msg_data OUT NOCOPY VARCHAR2,
112: p_tap_access_terrs_rec IN tap_access_terrs_rec_type := g_miss_tap_access_terrs_rec
124: -- Parameters
125: --
126: -- IN
127: -- p_api_version_number IN NUMBER Required
128: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
129: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
130: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
131: -- p_tap_access_terrs_rec IN tap_access_terrs_rec_type Required
132: --
125: --
126: -- IN
127: -- p_api_version_number IN NUMBER Required
128: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
129: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
130: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
131: -- p_tap_access_terrs_rec IN tap_access_terrs_rec_type Required
132: --
133: -- OUT
126: -- IN
127: -- p_api_version_number IN NUMBER Required
128: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
129: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
130: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
131: -- p_tap_access_terrs_rec IN tap_access_terrs_rec_type Required
132: --
133: -- OUT
134: -- x_return_status OUT VARCHAR2
146: -- ==============================================================================
147:
148: PROCEDURE Update_Tap_Access_Terrs(
149: p_api_version_number IN NUMBER,
150: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
151: p_commit IN VARCHAR2 := FND_API.G_FALSE,
152: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
153:
154: x_return_status OUT NOCOPY VARCHAR2,
147:
148: PROCEDURE Update_Tap_Access_Terrs(
149: p_api_version_number IN NUMBER,
150: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
151: p_commit IN VARCHAR2 := FND_API.G_FALSE,
152: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
153:
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
148: PROCEDURE Update_Tap_Access_Terrs(
149: p_api_version_number IN NUMBER,
150: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
151: p_commit IN VARCHAR2 := FND_API.G_FALSE,
152: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
153:
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
170: -- Parameters
171: --
172: -- IN
173: -- p_api_version_number IN NUMBER Required
174: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
175: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
176: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
177: -- p_partner_access_id IN NUMBER
178: -- p_terr_id IN NUMBER
171: --
172: -- IN
173: -- p_api_version_number IN NUMBER Required
174: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
175: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
176: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
177: -- p_partner_access_id IN NUMBER
178: -- p_terr_id IN NUMBER
179: -- p_object_version_number IN NUMBER Optional Default = NULL
172: -- IN
173: -- p_api_version_number IN NUMBER Required
174: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
175: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
176: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
177: -- p_partner_access_id IN NUMBER
178: -- p_terr_id IN NUMBER
179: -- p_object_version_number IN NUMBER Optional Default = NULL
180: --
194: -- ==============================================================================
195:
196: PROCEDURE Delete_Tap_Access_Terrs(
197: p_api_version_number IN NUMBER,
198: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
199: p_commit IN VARCHAR2 := FND_API.G_FALSE,
200: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
201: x_return_status OUT NOCOPY VARCHAR2,
202: x_msg_count OUT NOCOPY NUMBER,
195:
196: PROCEDURE Delete_Tap_Access_Terrs(
197: p_api_version_number IN NUMBER,
198: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
199: p_commit IN VARCHAR2 := FND_API.G_FALSE,
200: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
201: x_return_status OUT NOCOPY VARCHAR2,
202: x_msg_count OUT NOCOPY NUMBER,
203: x_msg_data OUT NOCOPY VARCHAR2,
196: PROCEDURE Delete_Tap_Access_Terrs(
197: p_api_version_number IN NUMBER,
198: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
199: p_commit IN VARCHAR2 := FND_API.G_FALSE,
200: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
201: x_return_status OUT NOCOPY VARCHAR2,
202: x_msg_count OUT NOCOPY NUMBER,
203: x_msg_data OUT NOCOPY VARCHAR2,
204: p_partner_access_id IN NUMBER,
218: -- Parameters
219: --
220: -- IN
221: -- p_api_version_number IN NUMBER Required
222: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
223: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
224: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
225: -- p_tap_access_terrs_rec IN tap_access_terrs_rec_type Required
226: --
219: --
220: -- IN
221: -- p_api_version_number IN NUMBER Required
222: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
223: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
224: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
225: -- p_tap_access_terrs_rec IN tap_access_terrs_rec_type Required
226: --
227: -- OUT
220: -- IN
221: -- p_api_version_number IN NUMBER Required
222: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
223: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
224: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
225: -- p_tap_access_terrs_rec IN tap_access_terrs_rec_type Required
226: --
227: -- OUT
228: -- x_return_status OUT VARCHAR2
240: -- ==============================================================================
241:
242: PROCEDURE Lock_Tap_Access_Terrs(
243: p_api_version_number IN NUMBER,
244: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
245:
246: x_return_status OUT NOCOPY VARCHAR2,
247: x_msg_count OUT NOCOPY NUMBER,
248: x_msg_data OUT NOCOPY VARCHAR2,
275:
276:
277: PROCEDURE Validate_Tap_Access_Terrs(
278: p_api_version_number IN NUMBER,
279: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
280: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
281: p_validation_mode IN VARCHAR2,
282: p_tap_access_terrs_rec IN tap_access_terrs_rec_type,
283: x_return_status OUT NOCOPY VARCHAR2,
276:
277: PROCEDURE Validate_Tap_Access_Terrs(
278: p_api_version_number IN NUMBER,
279: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
280: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
281: p_validation_mode IN VARCHAR2,
282: p_tap_access_terrs_rec IN tap_access_terrs_rec_type,
283: x_return_status OUT NOCOPY VARCHAR2,
284: x_msg_count OUT NOCOPY NUMBER,
334:
335:
336: PROCEDURE Validate_Tap_Access_Terrs_Rec (
337: p_api_version_number IN NUMBER,
338: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
339: x_return_status OUT NOCOPY VARCHAR2,
340: x_msg_count OUT NOCOPY NUMBER,
341: x_msg_data OUT NOCOPY VARCHAR2,
342: p_tap_access_terrs_rec IN tap_access_terrs_rec_type