APPS.ZX_TPI_PLUGIN_PKG dependencies on ZX_API_OWNER_STATUSES

Line 27: FROM zx_api_owner_statuses

23:
24: Cursor c_apiowner(p_srvc_cat IN VARCHAR2,p_api_owner_id IN NUMBER) is
25: SELECT distinct api_owner_id
26: , status_code
27: FROM zx_api_owner_statuses
28: WHERE upper(service_category_code) = upper(p_srvc_cat)
29: AND api_owner_id = nvl(p_api_owner_id, api_owner_id)
30: ORDER BY api_owner_id asc;
31:

Line 43: , zx_api_owner_statuses c

39: , b.service_type_code
40: , b.data_transfer_code
41: FROM zx_api_registrations a
42: , zx_service_types b
43: , zx_api_owner_statuses c
44: WHERE a.service_type_id = b.service_type_id
45: AND a.api_owner_id = c.api_owner_id
46: AND upper(c.service_category_code) = upper(p_srvc_cat)
47: AND a.api_owner_id = nvl(p_api_owner_id,a.api_owner_id)

Line 65: , zx_api_owner_statuses c

61: , a.procedure_name
62: , b.service_type_code
63: FROM zx_api_registrations a
64: , zx_service_types b
65: , zx_api_owner_statuses c
66: WHERE a.service_type_id = b.service_type_id
67: and a.api_owner_id = c.api_owner_id
68: and upper(c.service_category_code) = upper(p_srvc_cat)
69: and a.api_owner_id = nvl(p_api_owner_id, a.api_owner_id)

Line 534: FROM zx_api_owner_statuses

530: SELECT 'Y' into l_exists
531: FROM dual
532: WHERE exists
533: ( SELECT api_owner_id
534: FROM zx_api_owner_statuses
535: WHERE
536: status_code in ('DELETED','NEW')
537: );
538: EXCEPTION

Line 556: FROM zx_api_owner_statuses

552: l_exists_in_owner_statuses := 'Y';
553: BEGIN
554: SELECT 'Y'
555: INTO l_exists_in_owner_statuses
556: FROM zx_api_owner_statuses
557: WHERE upper(service_category_code) = upper(p_srvc_category)
558: AND api_owner_id = p_api_owner_id;
559: EXCEPTION
560: WHEN OTHERS THEN

Line 565: print_debug('-- CG: Inserting a record in zx_api_owner_statuses for API owners');

561: l_exists_in_owner_statuses := 'N';
562: END;
563:
564: IF l_exists_in_owner_statuses = 'N' THEN
565: print_debug('-- CG: Inserting a record in zx_api_owner_statuses for API owners');
566: INSERT INTO zx_api_owner_statuses(api_owner_id
567: , service_category_code
568: , status_code
569: , creation_date

Line 566: INSERT INTO zx_api_owner_statuses(api_owner_id

562: END;
563:
564: IF l_exists_in_owner_statuses = 'N' THEN
565: print_debug('-- CG: Inserting a record in zx_api_owner_statuses for API owners');
566: INSERT INTO zx_api_owner_statuses(api_owner_id
567: , service_category_code
568: , status_code
569: , creation_date
570: , created_by

Line 834: UPDATE ZX_API_OWNER_STATUSES SET STATUS_CODE = 'GENERATED'

830: /* Updating the status of all records to GENERATED */
831: /* ----------------------------------------------------------------------------- */
832:
833:
834: UPDATE ZX_API_OWNER_STATUSES SET STATUS_CODE = 'GENERATED'
835: WHERE api_owner_id = t_prv.api_owner_id(l_prvidx);
836:
837: END IF;
838: