DBA Data[Home] [Help]

APPS.ZX_TPI_PLUGIN_PKG dependencies on ZX_API_REGISTRATIONS

Line 41: FROM zx_api_registrations a

37: SELECT distinct a.api_owner_id
38: , b.service_type_id
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

Line 63: FROM zx_api_registrations a

59: , a.context_ccid
60: , a.package_name
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

Line 617: print_debug('-- CG: No data found in ZX_API_REGISTRATIONS');

613:
614: END LOOP;
615:
616: IF c_srvctyp%ROWCOUNT = 0 THEN
617: print_debug('-- CG: No data found in ZX_API_REGISTRATIONS');
618: Close c_srvctyp;
619: retcode := FND_API.G_RET_STS_ERROR;
620: return;
621: ELSE