DBA Data[Home] [Help]

APPS.ZX_TPI_PLUGIN_PKG dependencies on ZX_API_REGISTRATIONS

Line 54: FROM zx_api_registrations a

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

Line 76: FROM zx_api_registrations a

72: , a.context_ccid
73: , a.package_name
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

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

639:
640: END LOOP;
641:
642: IF c_srvctyp%ROWCOUNT = 0 THEN
643: print_debug('-- CG: No data found in ZX_API_REGISTRATIONS');
644: Close c_srvctyp;
645: retcode := FND_API.G_RET_STS_UNEXP_ERROR;
646: return;
647: ELSE