APPS.ZX_API_PRVDR_PUB dependencies on ZX_API_OWNER_STATUSES

Line 295: FROM ZX_API_OWNER_STATUSES

291: -- Check the status of the API owner.
292: BEGIN
293: SELECT status_code
294: INTO l_api_status
295: FROM ZX_API_OWNER_STATUSES
296: WHERE api_owner_id = l_api_owner_id
297: AND service_category_code = G_SRVC_CATEGORY;
298: EXCEPTION
299: WHEN no_data_found then

Line 301: -- Insert a record into zx_api_owner_statuses table.

297: AND service_category_code = G_SRVC_CATEGORY;
298: EXCEPTION
299: WHEN no_data_found then
300: -- No entry found in the zx_api_owner_stratuses
301: -- Insert a record into zx_api_owner_statuses table.
302: l_api_status := 'NEW';
303: INSERT INTO ZX_API_OWNER_STATUSES
304: (api_owner_id
305: , service_category_code

Line 303: INSERT INTO ZX_API_OWNER_STATUSES

299: WHEN no_data_found then
300: -- No entry found in the zx_api_owner_stratuses
301: -- Insert a record into zx_api_owner_statuses table.
302: l_api_status := 'NEW';
303: INSERT INTO ZX_API_OWNER_STATUSES
304: (api_owner_id
305: , service_category_code
306: , status_code
307: , creation_date

Line 324: UPDATE ZX_API_OWNER_STATUSES

320: END;
321:
322: /*Status record exists- update them*/
323: IF l_api_status = 'DELETED' THEN
324: UPDATE ZX_API_OWNER_STATUSES
325: SET status_code = 'NEW'
326: WHERE api_owner_id = l_api_owner_id
327: AND service_category_code = G_SRVC_CATEGORY;
328: ELSIF l_api_status = 'GENERATED' THEN

Line 329: UPDATE ZX_API_OWNER_STATUSES

325: SET status_code = 'NEW'
326: WHERE api_owner_id = l_api_owner_id
327: AND service_category_code = G_SRVC_CATEGORY;
328: ELSIF l_api_status = 'GENERATED' THEN
329: UPDATE ZX_API_OWNER_STATUSES
330: SET status_code = 'MODIFIED'
331: WHERE api_owner_id = l_api_owner_id
332: AND service_category_code = G_SRVC_CATEGORY;
333: END IF;

Line 427: FROM ZX_API_OWNER_STATUSES

423: IF x_error_msg_tbl.COUNT = 0 THEN
424: BEGIN
425: SELECT status_code
426: INTO l_api_status
427: FROM ZX_API_OWNER_STATUSES
428: WHERE api_owner_id = l_api_owner_id
429: AND service_category_code = G_SRVC_CATEGORY;
430:
431: EXCEPTION

Line 438: UPDATE ZX_API_OWNER_STATUSES

434: END;
435:
436: IF l_count = 1 THEN
437: IF l_api_status in ('NEW','GENERATED','MODIFIED') THEN
438: UPDATE ZX_API_OWNER_STATUSES
439: SET status_code = 'DELETED'
440: WHERE api_owner_id = l_api_owner_id
441: AND service_category_code = G_SRVC_CATEGORY;
442: END IF;

Line 445: UPDATE ZX_API_OWNER_STATUSES

441: AND service_category_code = G_SRVC_CATEGORY;
442: END IF;
443: ELSE
444: IF l_api_status = 'GENERATED' THEN
445: UPDATE ZX_API_OWNER_STATUSES
446: SET status_code = 'MODIFIED'
447: WHERE api_owner_id = l_api_owner_id
448: AND service_category_code = G_SRVC_CATEGORY;
449: END IF;