[Home] [Help]
2522: fnd_global.conc_login_id --last_update_login
2523: );
2524:
2525:
2526: INSERT INTO ZX_API_REGISTRATIONS (
2527: API_REGISTRATION_ID,
2528: API_OWNER_ID,
2529: CONTEXT_CCID,
2530: PACKAGE_NAME,
2537: LAST_UPDATE_DATE,
2538: LAST_UPDATED_BY,
2539: LAST_UPDATE_LOGIN
2540: )
2541: SELECT ZX_API_REGISTRATIONS_S.nextval,
2542: ru.first_pty_org_id,
2543: comb.code_combination_id,
2544: decode(srvc.srvc_provider_id,1,'ZX_VTX_USER_PKG','ZX_TAXWARE_USER_PKG'),
2545: decode(srvctypes.service_type_code,'DERIVE_HDR_ATTRS','DERIVE_HDR_EXT_ATTR',
2564: AND comb.segment_attribute2 is null
2565: AND comb.context_flex_structure_id = srvctypes.context_flex_structure_id
2566: AND srvctypes.service_type_code in ('DERIVE_HDR_ATTRS','DERIVE_LINE_ATTRS')
2567: AND NOT EXISTS (SELECT 1
2568: FROM ZX_API_REGISTRATIONS api
2569: WHERE api.service_type_id = srvctypes.service_type_id
2570: AND api.context_ccid = comb.code_combination_id
2571: AND api.api_owner_id = ru.first_pty_org_id
2572: );
2731: and comb.segment_attribute1= usage.tax_regime_code
2732: and comb.segment_attribute2= 'O2C'
2733: and usage.first_pty_org_id= p_api_owner_id
2734: and srvc.regime_usage_id=usage.regime_usage_id
2735: and not exists (select 1 from zx_api_registrations
2736: where API_OWNER_ID = srvc.srvc_provider_id
2737: and CONTEXT_CCID = p_context_cc_id);
2738: Exception
2739: When others then