[Home] [Help]
2485: zx_srvc_subscriptions srvc
2486: WHERE srvc.regime_usage_id=p_regime_usage_id
2487: and srvc.regime_usage_id=ru.regime_usage_id
2488: AND NOT EXISTS (SELECT 1
2489: FROM ZX_API_CODE_COMBINATIONS comb
2490: WHERE comb.segment_attribute1 = ru.tax_regime_code
2491: AND comb.segment_attribute2 is null
2492: );
2493: Exception
2496: End;
2497:
2498: IF (p_srvc_prvdr_id IN (1,2)) THEN --bug8746079
2499: if (l_tax_regime_code is not NULL) then
2500: INSERT INTO ZX_API_CODE_COMBINATIONS (
2501: CONTEXT_FLEX_STRUCTURE_ID,
2502: CODE_COMBINATION_ID,
2503: SEGMENT_ATTRIBUTE1,
2504: SUMMARY_FLAG,
2509: LAST_UPDATE_DATE,
2510: LAST_UPDATED_BY,
2511: LAST_UPDATE_LOGIN)
2512: VALUES (l_context_flex_structure_id,
2513: ZX_API_CODE_COMBINATIONS_S.nextval,
2514: l_tax_regime_code,
2515: 'N',
2516: 'Y',
2517: 'EBTAX_CREATED',
2552: sysdate, --last_update_date
2553: fnd_global.user_id, --last_updated_by
2554: fnd_global.conc_login_id --last_update_login;
2555: FROM ZX_REGIMES_USAGES ru,
2556: ZX_API_CODE_COMBINATIONS comb,
2557: ZX_SRVC_SUBSCRIPTIONS srvc,
2558: ZX_SERVICE_TYPES srvctypes
2559: WHERE ru.regime_usage_id = p_regime_usage_id
2560: AND srvc.srvc_provider_id = p_srvc_prvdr_id
2606: comb.code_combination_id
2607: INTO l_api_owner_id,
2608: l_context_cc_id
2609: FROM ZX_REGIMES_USAGES ru,
2610: ZX_API_CODE_COMBINATIONS comb,
2611: ZX_SRVC_SUBSCRIPTIONS srvc,
2612: ZX_SERVICE_TYPES srvctypes
2613: WHERE ru.regime_usage_id = p_regime_usage_id
2614: AND srvc.srvc_provider_id = p_srvc_prvdr_id
2723: Begin
2724: Select
2725: distinct srvc.srvc_provider_id
2726: into l_srvc_provider_id
2727: from zx_api_code_combinations comb,
2728: zx_regimes_usages usage,
2729: zx_srvc_subscriptions srvc
2730: where comb.code_combination_id= p_context_cc_id
2731: and comb.segment_attribute1= usage.tax_regime_code