APPS.ZX_TPI_PLUGIN_PKG dependencies on ZX_API_OWNER_STATUSES

Line 28: FROM zx_api_owner_statuses

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

Line 40: FROM zx_api_owner_statuses

36:
37: Cursor c_gen_apiowner(p_srvc_cat IN VARCHAR2) is
38: SELECT distinct api_owner_id
39: , status_code
40: FROM zx_api_owner_statuses
41: WHERE upper(service_category_code) = upper(p_srvc_cat)
42: AND status_code = 'GENERATED'
43: ORDER BY api_owner_id asc;
44:

Line 56: , zx_api_owner_statuses c

52: , b.service_type_code
53: , b.data_transfer_code
54: FROM zx_api_registrations a
55: , zx_service_types b
56: , zx_api_owner_statuses c
57: WHERE a.service_type_id = b.service_type_id
58: AND a.api_owner_id = c.api_owner_id
59: AND upper(c.service_category_code) = upper(p_srvc_cat)
60: AND a.api_owner_id = nvl(p_api_owner_id,a.api_owner_id)

Line 78: , zx_api_owner_statuses c

74: , a.procedure_name
75: , b.service_type_code
76: FROM zx_api_registrations a
77: , zx_service_types b
78: , zx_api_owner_statuses c
79: WHERE a.service_type_id = b.service_type_id
80: and a.api_owner_id = c.api_owner_id
81: and upper(c.service_category_code) = upper(p_srvc_cat)
82: and a.api_owner_id = nvl(p_api_owner_id, a.api_owner_id)

Line 560: FROM zx_api_owner_statuses

556: SELECT 'Y' into l_exists
557: FROM dual
558: WHERE exists
559: ( SELECT api_owner_id
560: FROM zx_api_owner_statuses
561: WHERE
562: status_code in ('DELETED','NEW')
563: );
564: EXCEPTION

Line 582: FROM zx_api_owner_statuses

578: l_exists_in_owner_statuses := 'Y';
579: BEGIN
580: SELECT 'Y'
581: INTO l_exists_in_owner_statuses
582: FROM zx_api_owner_statuses
583: WHERE upper(service_category_code) = upper(p_srvc_category)
584: AND api_owner_id = p_api_owner_id;
585: EXCEPTION
586: WHEN OTHERS THEN

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

587: l_exists_in_owner_statuses := 'N';
588: END;
589:
590: IF l_exists_in_owner_statuses = 'N' THEN
591: print_debug('-- CG: Inserting a record in zx_api_owner_statuses for API owners');
592: INSERT INTO zx_api_owner_statuses(api_owner_id
593: , service_category_code
594: , status_code
595: , creation_date

Line 592: INSERT INTO zx_api_owner_statuses(api_owner_id

588: END;
589:
590: IF l_exists_in_owner_statuses = 'N' THEN
591: print_debug('-- CG: Inserting a record in zx_api_owner_statuses for API owners');
592: INSERT INTO zx_api_owner_statuses(api_owner_id
593: , service_category_code
594: , status_code
595: , creation_date
596: , created_by

Line 863: UPDATE ZX_API_OWNER_STATUSES SET STATUS_CODE = 'GENERATED'

859: /* Updating the status of all records to GENERATED */
860: /* ----------------------------------------------------------------------------- */
861:
862:
863: UPDATE ZX_API_OWNER_STATUSES SET STATUS_CODE = 'GENERATED'
864: WHERE api_owner_id = t_prv.api_owner_id(l_prvidx);
865:
866: END IF;
867: