[Home] [Help]
2440: zx_srvc_subscriptions srvc
2441: WHERE srvc.regime_usage_id=p_regime_usage_id
2442: and srvc.regime_usage_id=ru.regime_usage_id
2443: AND NOT EXISTS (SELECT 1
2444: FROM ZX_API_CODE_COMBINATIONS comb
2445: WHERE comb.segment_attribute1 = ru.tax_regime_code
2446: AND comb.segment_attribute2 is null
2447: );
2448: Exception
2450: l_tax_regime_code := NULL;
2451: End;
2452:
2453: if (l_tax_regime_code is not NULL) then
2454: INSERT INTO ZX_API_CODE_COMBINATIONS (
2455: CONTEXT_FLEX_STRUCTURE_ID,
2456: CODE_COMBINATION_ID,
2457: SEGMENT_ATTRIBUTE1,
2458: SUMMARY_FLAG,
2463: LAST_UPDATE_DATE,
2464: LAST_UPDATED_BY,
2465: LAST_UPDATE_LOGIN)
2466: VALUES (l_context_flex_structure_id,
2467: ZX_API_CODE_COMBINATIONS_S.nextval,
2468: l_tax_regime_code,
2469: 'N',
2470: 'Y',
2471: 'EBTAX_CREATED',
2506: sysdate, --last_update_date
2507: fnd_global.user_id, --last_updated_by
2508: fnd_global.conc_login_id --last_update_login;
2509: FROM ZX_REGIMES_USAGES ru,
2510: ZX_API_CODE_COMBINATIONS comb,
2511: ZX_SRVC_SUBSCRIPTIONS srvc,
2512: ZX_SERVICE_TYPES srvctypes
2513: WHERE ru.regime_usage_id = p_regime_usage_id
2514: AND srvc.srvc_provider_id = p_srvc_prvdr_id
2560: comb.code_combination_id
2561: INTO l_api_owner_id,
2562: l_context_cc_id
2563: FROM ZX_REGIMES_USAGES ru,
2564: ZX_API_CODE_COMBINATIONS comb,
2565: ZX_SRVC_SUBSCRIPTIONS srvc,
2566: ZX_SERVICE_TYPES srvctypes
2567: WHERE ru.regime_usage_id = p_regime_usage_id
2568: AND srvc.srvc_provider_id = p_srvc_prvdr_id
2676: Begin
2677: Select
2678: distinct srvc.srvc_provider_id
2679: into l_srvc_provider_id
2680: from zx_api_code_combinations comb,
2681: zx_regimes_usages usage,
2682: zx_srvc_subscriptions srvc
2683: where comb.code_combination_id= p_context_cc_id
2684: and comb.segment_attribute1= usage.tax_regime_code