[Home] [Help]
2476: fnd_global.conc_login_id --last_update_login
2477: );
2478:
2479:
2480: INSERT INTO ZX_API_REGISTRATIONS (
2481: API_REGISTRATION_ID,
2482: API_OWNER_ID,
2483: CONTEXT_CCID,
2484: PACKAGE_NAME,
2491: LAST_UPDATE_DATE,
2492: LAST_UPDATED_BY,
2493: LAST_UPDATE_LOGIN
2494: )
2495: SELECT ZX_API_REGISTRATIONS_S.nextval,
2496: ru.first_pty_org_id,
2497: comb.code_combination_id,
2498: decode(srvc.srvc_provider_id,1,'ZX_VTX_USER_PKG','ZX_TAXWARE_USER_PKG'),
2499: decode(srvctypes.service_type_code,'DERIVE_HDR_ATTRS','DERIVE_HDR_EXT_ATTR',
2518: AND comb.segment_attribute2 is null
2519: AND comb.context_flex_structure_id = srvctypes.context_flex_structure_id
2520: AND srvctypes.service_type_code in ('DERIVE_HDR_ATTRS','DERIVE_LINE_ATTRS')
2521: AND NOT EXISTS (SELECT 1
2522: FROM ZX_API_REGISTRATIONS api
2523: WHERE api.service_type_id = srvctypes.service_type_id
2524: AND api.context_ccid = comb.code_combination_id
2525: AND api.api_owner_id = ru.first_pty_org_id
2526: );
2684: and comb.segment_attribute1= usage.tax_regime_code
2685: and comb.segment_attribute2= 'O2C'
2686: and usage.first_pty_org_id= p_api_owner_id
2687: and srvc.regime_usage_id=usage.regime_usage_id
2688: and not exists (select 1 from zx_api_registrations
2689: where API_OWNER_ID = srvc.srvc_provider_id
2690: and CONTEXT_CCID = p_context_cc_id);
2691: Exception
2692: When others then