[Home] [Help]
2402: | PROCEDURE |
2403: | create_process_results |
2404: | |
2405: | DESCRIPTION |
2406: | This routine inserts data into ZX_PROCESS_RESULTS by following same |
2407: | logic used while inserting the data in ZX_CONDITION_GROUPS_B. |
2408: | |
2409: | SCOPE - PUBLIC |
2410: | |
2431: END IF;
2432:
2433: IF (nvl(p_sync_module,'AP') = 'AP') THEN
2434: --Process_Results for AP Tax codes and Tax Groups Setup
2435: INSERT INTO ZX_PROCESS_RESULTS
2436: (
2437: CONDITION_GROUP_CODE ,
2438: PRIORITY ,
2439: RESULT_TYPE_CODE ,
2490: 'N' ,--ALLOW_EXEMPTIONS_FLAG
2491: 'N' ,--ALLOW_EXCEPTIONS_FLAG
2492: 'MIGRATED' ,--RECORD_TYPE_CODE
2493: NULL ,--RESULT_API
2494: zx_process_results_s.nextval ,--RESULT_ID
2495: CONTENT_OWNER_ID ,
2496: CONDITION_GROUP_ID ,
2497: TAX_RULE_ID ,
2498: fnd_global.user_id ,
2534: AND cond_groups.condition_group_code = rates.tax_rate_code
2535: AND cond_groups.enabled_flag = codes.enabled_flag
2536: --Added following AND condition for Sync process
2537: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
2538: AND not exists (select 1 from zx_process_results where
2539: tax_rule_id = rules.tax_rule_id
2540: and condition_group_code = cond_groups.condition_group_code
2541: and rate_result = rates.tax_rate_code
2542: )
2582: AND cond_groups.CONDITION_GROUP_CODE = group_codes.NAME
2583: --AND cond_groups.enabled_flag = codes.enabled_flag --Bug 5061471
2584: AND rules.effective_from = GROUPS.start_date -- bug 6680676
2585: AND NVL(rules.effective_to, sysdate) = NVL(GROUPS.end_date, sysdate)
2586: AND not exists (select 1 from zx_process_results where
2587: tax_rule_id = rules.tax_rule_id
2588: and condition_group_code = cond_groups.condition_group_code
2589: and rate_result = rates.tax_rate_code
2590: )
2593:
2594:
2595: IF (nvl(p_sync_module,'AR') = 'AR') THEN
2596: --Process_Results for AR Tax codes and Tax Groups Setup
2597: INSERT INTO ZX_PROCESS_RESULTS
2598: (
2599: CONDITION_GROUP_CODE ,
2600: PRIORITY ,
2601: RESULT_TYPE_CODE ,
2653: 'N' ,--ALLOW_EXEMPTIONS_FLAG
2654: 'N' ,--ALLOW_EXCEPTIONS_FLAG
2655: 'MIGRATED' ,--RECORD_TYPE_CODE
2656: NULL ,--RESULT_API
2657: zx_process_results_s.nextval ,--RESULT_ID
2658: CONTENT_OWNER_ID ,
2659: CONDITION_GROUP_ID ,
2660: TAX_RULE_ID ,
2661: CONDITION_SET_ID ,
2707: AND codes.org_id = sys.org_id --Bug 5090631
2708: AND sys.tax_method ='SALES_TAX'
2709: --Added following AND condition for Sync process
2710: AND codes.vat_tax_id = nvl(p_tax_id,codes.vat_tax_id)
2711: AND not exists (select 1 from zx_process_results where
2712: tax_rule_id = rules.tax_rule_id
2713: and condition_group_code = cond_groups.condition_group_code
2714: and rate_result = rates.tax_rate_code
2715: )
2767: AND cond_groups.condition_group_code = SUBSTRB(gvat.tax_code,1,40)
2768: ||DECODE(gvat.tax_constraint_id,
2769: NULL, '', '~'||gvat.tax_constraint_id)
2770: --AND cond_groups.enabled_flag = vat.enabled_flag --Bug 5061471
2771: AND not exists (select 1 from zx_process_results where
2772: tax_rule_id = rules.tax_rule_id
2773: and condition_group_code = cond_groups.condition_group_code
2774: and rate_result = rates.tax_rate_code
2775: )
2777:
2778:
2779: --Create process results for Location Based Taxes
2780:
2781: INSERT INTO ZX_PROCESS_RESULTS (
2782: CONDITION_GROUP_CODE ,
2783: PRIORITY ,
2784: RESULT_TYPE_CODE ,
2785: TAX_STATUS_CODE ,
2843: NULL, -- PROGRAM_ID ,
2844: CONDITION_SET_ID ,
2845: EXCEPTION_SET_ID ,
2846: NULL , -- PROGRAM_LOGIN_ID ,
2847: zx_process_results_s.nextval,
2848: CONTENT_OWNER_ID ,
2849: condition_group_id,
2850: tax_rule_id,
2851: fnd_global.user_id , --CREATED_BY ,
2895: ||DECODE(vat.tax_constraint_id,
2896: NULL, '', '~'||vat.tax_constraint_id)
2897: --Added following AND condition for Sync process
2898: AND vat.vat_tax_id = nvl(p_tax_id,vat.vat_tax_id)
2899: AND not exists (select 1 from zx_process_results where
2900: tax_rule_id = rules.tax_rule_id
2901: and condition_group_code = cg.condition_group_code
2902: and result_type_code ='CODE' --Bug 5385949
2903: and rate_result is null
2955: AND cond_groups.condition_group_code = SUBSTRB(gvat.tax_code,1,40)
2956: ||DECODE(gvat.tax_constraint_id,
2957: NULL, '', '~'||gvat.tax_constraint_id)
2958: AND cond_groups.enabled_flag = vat.enabled_flag
2959: AND not exists (select 1 from zx_process_results where
2960: tax_rule_id = rules.tax_rule_id
2961: and condition_group_code = cond_groups.condition_group_code
2962: AND ALPHANUMERIC_RESULT = 'APPLICABLE'
2963: )
2965:
2966: -- Create applicability rule process results for the tax codes in the OKL tax group with at lease one
2967: -- not null PFC, PTFC, TBC
2968:
2969: INSERT INTO ZX_PROCESS_RESULTS (
2970: CONDITION_GROUP_CODE ,
2971: PRIORITY ,
2972: RESULT_TYPE_CODE ,
2973: TAX_STATUS_CODE ,
3031: NULL, -- PROGRAM_ID ,
3032: CONDITION_SET_ID ,
3033: EXCEPTION_SET_ID ,
3034: NULL , -- PROGRAM_LOGIN_ID ,
3035: zx_process_results_s.nextval,
3036: CONTENT_OWNER_ID ,
3037: condition_group_id,
3038: tax_rule_id,
3039: fnd_global.user_id , --CREATED_BY ,
3092: = taxgrp.product_fisc_classification ||
3093: taxgrp.trx_business_category_code ||
3094: taxgrp.party_fisc_classification
3095: AND cg.enabled_flag = 'Y'
3096: AND not exists (select 1 from zx_process_results where
3097: tax_rule_id = rules.tax_rule_id
3098: and condition_group_code = cg.condition_group_code
3099: and result_type_code = 'APPLICABILITY'
3100: )
3168: = taxgrp.product_fisc_classification ||
3169: taxgrp.trx_business_category_code ||
3170: taxgrp.party_fisc_classification
3171: AND cg.enabled_flag = 'Y'
3172: AND not exists (select 1 from zx_process_results where
3173: tax_rule_id = rules.tax_rule_id
3174: and condition_group_code = cg.condition_group_code
3175: and result_type_code ='APPLICABILITY'
3176: )
3179:
3180: -- Create rate det rule process results for the tax codes in the OKL tax group with at lease one
3181: -- not null PFC, PTFC, TBC
3182:
3183: INSERT INTO ZX_PROCESS_RESULTS (
3184: CONDITION_GROUP_CODE ,
3185: PRIORITY ,
3186: RESULT_TYPE_CODE ,
3187: TAX_STATUS_CODE ,
3245: NULL, -- PROGRAM_ID ,
3246: CONDITION_SET_ID ,
3247: EXCEPTION_SET_ID ,
3248: NULL , -- PROGRAM_LOGIN_ID ,
3249: zx_process_results_s.nextval,
3250: CONTENT_OWNER_ID ,
3251: condition_group_id,
3252: tax_rule_id,
3253: fnd_global.user_id , --CREATED_BY ,
3306: = taxgrp.product_fisc_classification ||
3307: taxgrp.trx_business_category_code ||
3308: taxgrp.party_fisc_classification
3309: AND cg.enabled_flag = vat.enabled_flag
3310: AND not exists (select 1 from zx_process_results where
3311: tax_rule_id = rules.tax_rule_id
3312: and condition_group_code = cg.condition_group_code
3313: and result_type_code = 'CODE'
3314: )
3378: = taxgrp.product_fisc_classification ||
3379: taxgrp.trx_business_category_code ||
3380: taxgrp.party_fisc_classification
3381: AND cg.enabled_flag = vat.enabled_flag
3382: AND not exists (select 1 from zx_process_results where
3383: tax_rule_id = rules.tax_rule_id
3384: and condition_group_code = cg.condition_group_code
3385: and result_type_code ='CODE'
3386: )