APPS.ZX_AR_FORMULA_MIG_PKG dependencies on ZX_RULES_B

Line 699: AND EXISTS (SELECT 1 FROM ZX_RULES_B R

695:
696: UPDATE ZX_TAXES_B T
697: SET TAXABLE_BASIS_RULE_FLAG = 'Y'
698: WHERE RECORD_TYPE_CODE = 'MIGRATED'
699: AND EXISTS (SELECT 1 FROM ZX_RULES_B R
700: WHERE R.TAX_REGIME_CODE = T.TAX_REGIME_CODE
701: AND R.TAX = T.TAX
702: AND R.CONTENT_OWNER_ID = T.CONTENT_OWNER_ID
703: AND R.SERVICE_TYPE_CODE = 'DET_TAXABLE_BASIS'

Line 716: AND EXISTS (SELECT 1 FROM ZX_RULES_B R

712:
713: UPDATE ZX_TAXES_B T
714: SET TAXABLE_BASIS_RULE_FLAG = 'Y'
715: WHERE RECORD_TYPE_CODE = 'MIGRATED'
716: AND EXISTS (SELECT 1 FROM ZX_RULES_B R
717: WHERE R.TAX_REGIME_CODE = T.TAX_REGIME_CODE
718: AND R.TAX = T.TAX
719: AND R.CONTENT_OWNER_ID = T.CONTENT_OWNER_ID
720: AND R.SERVICE_TYPE_CODE = 'DET_TAXABLE_BASIS'

Line 1035: * Based on the input parameters, row(s) would be created in to ZX_RULES_B, *

1031: END CREATE_FORMULA;
1032:
1033: /****************************************************************************************
1034: * Procedure: CREATE_RULES *
1035: * Based on the input parameters, row(s) would be created in to ZX_RULES_B, *
1036: * ZX_RULES_TL and ZX_PROCESS_RESULTS. *
1037: *****************************************************************************************/
1038:
1039: PROCEDURE CREATE_RULES

Line 1040: ( --parameters rqrd for zx_rules_b

1036: * ZX_RULES_TL and ZX_PROCESS_RESULTS. *
1037: *****************************************************************************************/
1038:
1039: PROCEDURE CREATE_RULES
1040: ( --parameters rqrd for zx_rules_b
1041: p_tax IN zx_rates_b.tax%TYPE,
1042: p_tax_regime_code IN zx_rates_b.tax_regime_code%TYPE,
1043: p_effective_from IN ar_vat_tax_all.start_date%TYPE,
1044: p_effective_to IN ar_vat_tax_all.end_date%TYPE,

Line 1054: --l_tax_rule_id zx_rules_b.tax_rule_id%TYPE;

1050: p_tax_condition_id IN ar_tax_group_codes_all.tax_condition_id%TYPE,
1051: p_tax_exception_id IN ar_tax_group_codes_all.tax_exception_id%TYPE,
1052: x_return_status OUT NOCOPY VARCHAR2 ) IS
1053:
1054: --l_tax_rule_id zx_rules_b.tax_rule_id%TYPE;
1055: l_tax_rule_code zx_rules_b.tax_rule_code%TYPE;
1056: l_tax_rule_id NUMBER;
1057:
1058: BEGIN

Line 1055: l_tax_rule_code zx_rules_b.tax_rule_code%TYPE;

1051: p_tax_exception_id IN ar_tax_group_codes_all.tax_exception_id%TYPE,
1052: x_return_status OUT NOCOPY VARCHAR2 ) IS
1053:
1054: --l_tax_rule_id zx_rules_b.tax_rule_id%TYPE;
1055: l_tax_rule_code zx_rules_b.tax_rule_code%TYPE;
1056: l_tax_rule_id NUMBER;
1057:
1058: BEGIN
1059:

Line 1067: SUBSTRB('O_TB_' || p_tax,1,24)||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_RULES_B_S'),

1063:
1064:
1065: SELECT DECODE(SIGN(LENGTHB('O_TB_' || p_tax) - 30),
1066: 1,
1067: SUBSTRB('O_TB_' || p_tax,1,24)||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_RULES_B_S'),
1068: 'O_TB_' || p_tax)
1069: INTO l_tax_rule_code
1070: FROM DUAL;
1071:

Line 1074: -- Inserting values in table zx_rules_b

1070: FROM DUAL;
1071:
1072: arp_util_tax.debug('l_tax_rule_code'||l_tax_rule_code);
1073:
1074: -- Inserting values in table zx_rules_b
1075:
1076: BEGIN
1077: --bug# 4610260 : Changed the ZX_RULES_B to ZX_RULES_B_TMP
1078: INSERT INTO zx_rules_b_tmp

Line 1077: --bug# 4610260 : Changed the ZX_RULES_B to ZX_RULES_B_TMP

1073:
1074: -- Inserting values in table zx_rules_b
1075:
1076: BEGIN
1077: --bug# 4610260 : Changed the ZX_RULES_B to ZX_RULES_B_TMP
1078: INSERT INTO zx_rules_b_tmp
1079: (tax_rule_code,
1080: tax,
1081: tax_regime_code,

Line 1078: INSERT INTO zx_rules_b_tmp

1074: -- Inserting values in table zx_rules_b
1075:
1076: BEGIN
1077: --bug# 4610260 : Changed the ZX_RULES_B to ZX_RULES_B_TMP
1078: INSERT INTO zx_rules_b_tmp
1079: (tax_rule_code,
1080: tax,
1081: tax_regime_code,
1082: service_type_code,

Line 1120: zx_rules_b_s.NEXTVAL,

1116: p_enabled_flag,
1117: 'MIGRATED',
1118: 'STCC',
1119: p_content_owner_id,
1120: zx_rules_b_s.NEXTVAL,
1121: fnd_global.user_id,
1122: SYSDATE,
1123: fnd_global.user_id,
1124: SYSDATE,

Line 1136: FROM zx_rules_B

1132: WHERE
1133: --Re-runnability
1134:
1135: NOT EXISTS (SELECT 1
1136: FROM zx_rules_B
1137: WHERE substrb(tax_rule_code,1,24) = (SELECT DECODE(SIGN(LENGTHB('O_TB_' || p_tax) - 30),
1138: 1,
1139: SUBSTRB('O_TB_' || p_tax,1,24),
1140: SUBSTRB('O_TB_' || p_tax,1,24))

Line 1186: FROM fnd_languages l, zx_rules_b rules

1182: SYSDATE,
1183: fnd_global.conc_login_id,
1184: l.language_code,
1185: userenv('LANG')
1186: FROM fnd_languages l, zx_rules_b rules
1187: WHERE l.installed_flag IN ('I', 'B')
1188: AND rules.record_type_code = 'MIGRATED'
1189: AND rules.tax_rule_code = l_tax_rule_code
1190: AND NOT EXISTS (SELECT NULL

Line 1205: FROM zx_rules_b

1201: -- Bug 8429806
1202: BEGIN
1203: SELECT tax_rule_id
1204: INTO l_tax_rule_id
1205: FROM zx_rules_b
1206: WHERE substrb(tax_rule_code,1,24) = substrb(l_tax_rule_code,1,24)
1207: AND tax_regime_code = p_tax_regime_code
1208: AND tax = p_tax
1209: AND content_owner_id = p_content_owner_id

Line 1278: p_enabled_flag, -- also used in insert of zx_rules_b

1274: NULL,
1275: NULL,
1276: NULL,
1277: NULL,
1278: p_enabled_flag, -- also used in insert of zx_rules_b
1279: 'N',
1280: 'N',
1281: 'MIGRATED',
1282: NULL,

Line 1284: p_content_owner_id, -- also used in insert of zx_rules_b also

1280: 'N',
1281: 'MIGRATED',
1282: NULL,
1283: zx_process_results_s.NEXTVAL,
1284: p_content_owner_id, -- also used in insert of zx_rules_b also
1285: p_condition_group_id,
1286: l_tax_rule_id, -- zx_rules_b.tax_rule_id(based on rule created above)8429806
1287: p_tax_condition_id, --condition set id
1288: p_tax_exception_id, --exception set id

Line 1286: l_tax_rule_id, -- zx_rules_b.tax_rule_id(based on rule created above)8429806

1282: NULL,
1283: zx_process_results_s.NEXTVAL,
1284: p_content_owner_id, -- also used in insert of zx_rules_b also
1285: p_condition_group_id,
1286: l_tax_rule_id, -- zx_rules_b.tax_rule_id(based on rule created above)8429806
1287: p_tax_condition_id, --condition set id
1288: p_tax_exception_id, --exception set id
1289: fnd_global.user_id,
1290: SYSDATE,