[Home] [Help]
2568: | PROCEDURE |
2569: | create_process_results |
2570: | |
2571: | DESCRIPTION |
2572: | This routine inserts data into ZX_PROCESS_RESULTS by following same |
2573: | logic used while inserting the data in ZX_CONDITION_GROUPS_B. |
2574: | |
2575: | SCOPE - PUBLIC |
2576: | |
2597: END IF;
2598:
2599: IF (nvl(p_sync_module,'AP') = 'AP' and p_dir_rate_rules_cnt > 0) THEN
2600: --Process_Results for AP Tax codes and Tax Groups Setup
2601: INSERT INTO ZX_PROCESS_RESULTS
2602: (
2603: CONDITION_GROUP_CODE ,
2604: PRIORITY ,
2605: RESULT_TYPE_CODE ,
2656: 'N' ,--ALLOW_EXEMPTIONS_FLAG
2657: 'N' ,--ALLOW_EXCEPTIONS_FLAG
2658: 'MIGRATED' ,--RECORD_TYPE_CODE
2659: NULL ,--RESULT_API
2660: zx_process_results_s.nextval ,--RESULT_ID
2661: CONTENT_OWNER_ID ,
2662: CONDITION_GROUP_ID ,
2663: TAX_RULE_ID ,
2664: fnd_global.user_id ,
2700: AND cond_groups.condition_group_code = rates.tax_rate_code
2701: AND cond_groups.enabled_flag = codes.enabled_flag
2702: --Added following AND condition for Sync process
2703: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)
2704: AND not exists (select 1 from zx_process_results where
2705: tax_rule_id = rules.tax_rule_id
2706: and condition_group_code = cond_groups.condition_group_code
2707: and rate_result = rates.tax_rate_code
2708: )
2749: AND cond_groups.CONDITION_GROUP_CODE in (group_codes.NAME, group_codes.NAME||'-'||'XIP')
2750: --AND cond_groups.enabled_flag = codes.enabled_flag --Bug 5061471
2751: AND rules.effective_from = GROUPS.start_date -- bug 6680676
2752: AND NVL(rules.effective_to, sysdate) = NVL(GROUPS.end_date, sysdate)
2753: AND not exists (select 1 from zx_process_results where
2754: tax_rule_id = rules.tax_rule_id
2755: and condition_group_code = cond_groups.condition_group_code
2756: and rate_result = rates.tax_rate_code
2757: )
2760:
2761:
2762: IF (nvl(p_sync_module,'AR') = 'AR' and p_dir_rate_rules_cnt > 0) THEN
2763: --Process_Results for AR Tax codes and Tax Groups Setup
2764: INSERT INTO ZX_PROCESS_RESULTS
2765: (
2766: CONDITION_GROUP_CODE ,
2767: PRIORITY ,
2768: RESULT_TYPE_CODE ,
2820: 'N' ,--ALLOW_EXEMPTIONS_FLAG
2821: 'N' ,--ALLOW_EXCEPTIONS_FLAG
2822: 'MIGRATED' ,--RECORD_TYPE_CODE
2823: NULL ,--RESULT_API
2824: zx_process_results_s.nextval ,--RESULT_ID
2825: CONTENT_OWNER_ID ,
2826: CONDITION_GROUP_ID ,
2827: TAX_RULE_ID ,
2828: CONDITION_SET_ID ,
2875: AND codes.org_id = sys.org_id --Bug 5090631
2876: AND sys.tax_method ='SALES_TAX'
2877: --Added following AND condition for Sync process
2878: AND codes.vat_tax_id = nvl(p_tax_id,codes.vat_tax_id)
2879: AND not exists (select 1 from zx_process_results where
2880: tax_rule_id = rules.tax_rule_id
2881: and condition_group_code = cond_groups.condition_group_code
2882: and rate_result = rates.tax_rate_code
2883: )
2941: SUBSTRB(gvat.tax_code,1, 40)||'~'||gvat.tax_constraint_id
2942: )
2943: )
2944: --AND cond_groups.enabled_flag = vat.enabled_flag --Bug 5061471
2945: AND not exists (select 1 from zx_process_results where
2946: tax_rule_id = rules.tax_rule_id
2947: and condition_group_code = cond_groups.condition_group_code
2948: and rate_result = rates.tax_rate_code
2949: )
2952:
2953: --Create process results for Location Based Taxes
2954: IF p_dir_loc_rules_cnt > 0 THEN
2955:
2956: INSERT INTO ZX_PROCESS_RESULTS (
2957: CONDITION_GROUP_CODE ,
2958: PRIORITY ,
2959: RESULT_TYPE_CODE ,
2960: TAX_STATUS_CODE ,
3018: NULL, -- PROGRAM_ID ,
3019: CONDITION_SET_ID ,
3020: EXCEPTION_SET_ID ,
3021: NULL , -- PROGRAM_LOGIN_ID ,
3022: zx_process_results_s.nextval,
3023: CONTENT_OWNER_ID ,
3024: condition_group_id,
3025: tax_rule_id,
3026: fnd_global.user_id , --CREATED_BY ,
3071: SUBSTRB(vat.tax_code,1, 40)||'~'||vat.tax_constraint_id
3072: )
3073: --Added following AND condition for Sync process
3074: AND vat.vat_tax_id = nvl(p_tax_id,vat.vat_tax_id)
3075: AND not exists (select 1 from zx_process_results where
3076: tax_rule_id = rules.tax_rule_id
3077: and condition_group_code = cg.condition_group_code
3078: and result_type_code ='CODE' --Bug 5385949
3079: and rate_result = decode(vat.leasing_flag,'Y',vat.tax_code,'STANDARD')
3137: SUBSTRB(gvat.tax_code,1, 40)||'~'||gvat.tax_constraint_id
3138: )
3139: )
3140: AND cond_groups.enabled_flag = vat.enabled_flag
3141: AND not exists (select 1 from zx_process_results where
3142: tax_rule_id = rules.tax_rule_id
3143: and condition_group_code = cond_groups.condition_group_code
3144: AND ALPHANUMERIC_RESULT = 'APPLICABLE'
3145: )
3148:
3149: -- Create applicability rule process results for the tax codes in the OKL tax group with at lease one
3150: -- not null PFC, PTFC, TBC
3151:
3152: INSERT INTO ZX_PROCESS_RESULTS (
3153: CONDITION_GROUP_CODE ,
3154: PRIORITY ,
3155: RESULT_TYPE_CODE ,
3156: TAX_STATUS_CODE ,
3214: NULL, -- PROGRAM_ID ,
3215: CONDITION_SET_ID ,
3216: EXCEPTION_SET_ID ,
3217: NULL , -- PROGRAM_LOGIN_ID ,
3218: zx_process_results_s.nextval,
3219: CONTENT_OWNER_ID ,
3220: condition_group_id,
3221: tax_rule_id,
3222: fnd_global.user_id , --CREATED_BY ,
3275: = taxgrp.product_fisc_classification ||
3276: taxgrp.trx_business_category_code ||
3277: taxgrp.party_fisc_classification
3278: AND cg.enabled_flag = 'Y'
3279: AND not exists (select 1 from zx_process_results where
3280: tax_rule_id = rules.tax_rule_id
3281: and condition_group_code = cg.condition_group_code
3282: and result_type_code = 'APPLICABILITY'
3283: )
3351: = taxgrp.product_fisc_classification ||
3352: taxgrp.trx_business_category_code ||
3353: taxgrp.party_fisc_classification
3354: AND cg.enabled_flag = 'Y'
3355: AND not exists (select 1 from zx_process_results where
3356: tax_rule_id = rules.tax_rule_id
3357: and condition_group_code = cg.condition_group_code
3358: and result_type_code ='APPLICABILITY'
3359: )
3362:
3363: -- Create rate det rule process results for the tax codes in the OKL tax group with at lease one
3364: -- not null PFC, PTFC, TBC
3365:
3366: INSERT INTO ZX_PROCESS_RESULTS (
3367: CONDITION_GROUP_CODE ,
3368: PRIORITY ,
3369: RESULT_TYPE_CODE ,
3370: TAX_STATUS_CODE ,
3428: NULL, -- PROGRAM_ID ,
3429: CONDITION_SET_ID ,
3430: EXCEPTION_SET_ID ,
3431: NULL , -- PROGRAM_LOGIN_ID ,
3432: zx_process_results_s.nextval,
3433: CONTENT_OWNER_ID ,
3434: condition_group_id,
3435: tax_rule_id,
3436: fnd_global.user_id , --CREATED_BY ,
3489: = taxgrp.product_fisc_classification ||
3490: taxgrp.trx_business_category_code ||
3491: taxgrp.party_fisc_classification
3492: AND cg.enabled_flag = vat.enabled_flag
3493: AND not exists (select 1 from zx_process_results where
3494: tax_rule_id = rules.tax_rule_id
3495: and condition_group_code = cg.condition_group_code
3496: and result_type_code = 'CODE'
3497: )
3561: = taxgrp.product_fisc_classification ||
3562: taxgrp.trx_business_category_code ||
3563: taxgrp.party_fisc_classification
3564: AND cg.enabled_flag = vat.enabled_flag
3565: AND not exists (select 1 from zx_process_results where
3566: tax_rule_id = rules.tax_rule_id
3567: and condition_group_code = cg.condition_group_code
3568: and result_type_code ='CODE'
3569: )