The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure INSERT_ROW (
X_ROWID in out nocopy VARCHAR2,
X_CONDITION_GROUP_ID in NUMBER,
X_DETERMINING_FACTOR_CODE10 in VARCHAR2,
X_COUNTRY_CODE in VARCHAR2,
X_TAX_PARAMETER_CODE10 in VARCHAR2,
X_DATA_TYPE10_CODE in VARCHAR2,
X_DETERMINING_FACTOR_CLAS10_CO in VARCHAR2,
X_DETERMINING_FACTOR_CQ10_CODE in VARCHAR2,
X_OPERATOR10_CODE in VARCHAR2,
X_NUMERIC_VALUE10 in NUMBER,
X_DATE_VALUE10 in DATE,
X_ALPHANUMERIC_VALUE10 in VARCHAR2,
X_VALUE_LOW10 in VARCHAR2,
X_VALUE_HIGH10 in VARCHAR2,
X_Record_Type_CODE in VARCHAR2,
X_REQUEST_ID in NUMBER,
X_CONDITION_GROUP_CODE in VARCHAR2,
X_DET_FACTOR_TEMPL_CODE in VARCHAR2,
X_LEDGER_ID in NUMBER,
X_CHART_OF_ACCOUNTS_ID in NUMBER,
X_More_Than_Max_Cond_Flag in VARCHAR2,
X_Enabled_Flag in VARCHAR2,
X_DETERMINING_FACTOR_CODE1 in VARCHAR2,
X_TAX_PARAMETER_CODE1 in VARCHAR2,
X_DATA_TYPE1_CODE in VARCHAR2,
X_DETERMINING_FACTOR_CLASS1_CO in VARCHAR2,
X_DETERMINING_FACTOR_CQ1_CODE in VARCHAR2,
X_OPERATOR1_CODE in VARCHAR2,
X_NUMERIC_VALUE1 in NUMBER,
X_DATE_VALUE1 in DATE,
X_ALPHANUMERIC_VALUE1 in VARCHAR2,
X_VALUE_LOW1 in VARCHAR2,
X_VALUE_HIGH1 in VARCHAR2,
X_DETERMINING_FACTOR_CODE2 in VARCHAR2,
X_TAX_PARAMETER_CODE2 in VARCHAR2,
X_DATA_TYPE2_CODE in VARCHAR2,
X_DETERMINING_FACTOR_CLASS2_CO in VARCHAR2,
X_DETERMINING_FACTOR_CQ2_CODE in VARCHAR2,
X_OPERATOR2_CODE in VARCHAR2,
X_NUMERIC_VALUE2 in NUMBER,
X_DATE_VALUE2 in DATE,
X_ALPHANUMERIC_VALUE2 in VARCHAR2,
X_VALUE_LOW2 in VARCHAR2,
X_VALUE_HIGH2 in VARCHAR2,
X_DETERMINING_FACTOR_CODE3 in VARCHAR2,
X_TAX_PARAMETER_CODE3 in VARCHAR2,
X_DATA_TYPE3_CODE in VARCHAR2,
X_DETERMINING_FACTOR_CLASS3_CO in VARCHAR2,
X_DETERMINING_FACTOR_CQ3_CODE in VARCHAR2,
X_OPERATOR3_CODE in VARCHAR2,
X_NUMERIC_VALUE3 in NUMBER,
X_DATE_VALUE3 in DATE,
X_ALPHANUMERIC_VALUE3 in VARCHAR2,
X_VALUE_LOW3 in VARCHAR2,
X_VALUE_HIGH3 in VARCHAR2,
X_DETERMINING_FACTOR_CODE4 in VARCHAR2,
X_TAX_PARAMETER_CODE4 in VARCHAR2,
X_DATA_TYPE4_CODE in VARCHAR2,
X_DETERMINING_FACTOR_CLASS4_CO in VARCHAR2,
X_DETERMINING_FACTOR_CQ4_CODE in VARCHAR2,
X_OPERATOR4_CODE in VARCHAR2,
X_NUMERIC_VALUE4 in NUMBER,
X_DATE_VALUE4 in DATE,
X_ALPHANUMERIC_VALUE4 in VARCHAR2,
X_VALUE_LOW4 in VARCHAR2,
X_VALUE_HIGH4 in VARCHAR2,
X_DETERMINING_FACTOR_CODE5 in VARCHAR2,
X_TAX_PARAMETER_CODE5 in VARCHAR2,
X_data_Type5_CODE in VARCHAR2,
X_DETERMINING_FACTOR_CLASS5_CO in VARCHAR2,
X_DETERMINING_FACTOR_CQ5_CODE in VARCHAR2,
X_OPERATOR5_CODE in VARCHAR2,
X_NUMERIC_VALUE5 in NUMBER,
X_DATE_VALUE5 in DATE,
X_ALPHANUMERIC_VALUE5 in VARCHAR2,
X_VALUE_LOW5 in VARCHAR2,
X_VALUE_HIGH5 in VARCHAR2,
X_DETERMINING_FACTOR_CODE6 in VARCHAR2,
X_TAX_PARAMETER_CODE6 in VARCHAR2,
X_DATA_TYPE6_CODE in VARCHAR2,
X_DETERMINING_FACTOR_CLASS6_CO in VARCHAR2,
X_DETERMINING_FACTOR_CQ6_CODE in VARCHAR2,
X_OPERATOR6_CODE in VARCHAR2,
X_NUMERIC_VALUE6 in NUMBER,
X_DATE_VALUE6 in DATE,
X_ALPHANUMERIC_VALUE6 in VARCHAR2,
X_VALUE_LOW6 in VARCHAR2,
X_VALUE_HIGH6 in VARCHAR2,
X_DETERMINING_FACTOR_CODE7 in VARCHAR2,
X_TAX_PARAMETER_CODE7 in VARCHAR2,
X_DATA_TYPE7_CODE in VARCHAR2,
X_DETERMINING_FACTOR_CLASS7_CO in VARCHAR2,
X_DETERMINING_FACTOR_CQ7_CODE in VARCHAR2,
X_OPERATOR7_CODE in VARCHAR2,
X_NUMERIC_VALUE7 in NUMBER,
X_DATE_VALUE7 in DATE,
X_ALPHANUMERIC_VALUE7 in VARCHAR2,
X_VALUE_LOW7 in VARCHAR2,
X_VALUE_HIGH7 in VARCHAR2,
X_DETERMINING_FACTOR_CODE8 in VARCHAR2,
X_TAX_PARAMETER_CODE8 in VARCHAR2,
X_DATA_TYPE8_CODE in VARCHAR2,
X_DETERMINING_FACTOR_CLASS8_CO in VARCHAR2,
X_DETERMINING_FACTOR_CQ8_CODE in VARCHAR2,
X_OPERATOR8_CODE in VARCHAR2,
X_NUMERIC_VALUE8 in NUMBER,
X_DATE_VALUE8 in DATE,
X_ALPHANUMERIC_VALUE8 in VARCHAR2,
X_VALUE_LOW8 in VARCHAR2,
X_VALUE_HIGH8 in VARCHAR2,
X_DETERMINING_FACTOR_CODE9 in VARCHAR2,
X_TAX_PARAMETER_CODE9 in VARCHAR2,
X_DATA_TYPE9_CODE in VARCHAR2,
X_DETERMINING_FACTOR_CLASS9_CO in VARCHAR2,
X_DETERMINING_FACTOR_CQ9_CODE in VARCHAR2,
X_OPERATOR9_CODE in VARCHAR2,
X_NUMERIC_VALUE9 in NUMBER,
X_DATE_VALUE9 in DATE,
X_ALPHANUMERIC_VALUE9 in VARCHAR2,
X_VALUE_LOW9 in VARCHAR2,
X_VALUE_HIGH9 in VARCHAR2,
X_CONDITION_GROUP_NAME in VARCHAR2,
X_CONDITION_GROUP_DESC in VARCHAR2,
X_CREATION_DATE in DATE,
X_CREATED_BY in NUMBER,
X_LAST_UPDATE_DATE in DATE,
X_LAST_UPDATED_BY in NUMBER,
X_LAST_UPDATE_LOGIN in NUMBER,
X_PROGRAM_APPLICATION_ID in NUMBER,
X_PROGRAM_ID in NUMBER,
X_PROGRAM_LOGIN_ID in NUMBER,
X_CONSTRAINT_ID IN NUMBER,
X_OBJECT_VERSION_NUMBER in NUMBER) is
cursor C is select ROWID from ZX_CONDITION_GROUPS_B
where CONDITION_GROUP_ID = X_CONDITION_GROUP_ID ;
insert into ZX_CONDITION_GROUPS_B (
DETERMINING_FACTOR_CODE10,
COUNTRY_CODE,
TAX_PARAMETER_CODE10,
DATA_TYPE10_Code,
Determining_Factor_Clas10_Code,
DETERMINING_FACTOR_CQ10_Code,
OPERATOR10_Code,
NUMERIC_VALUE10,
DATE_VALUE10,
ALPHANUMERIC_VALUE10,
VALUE_LOW10,
VALUE_HIGH10,
Record_Type_Code,
REQUEST_ID,
CONDITION_GROUP_ID,
CONDITION_GROUP_CODE,
DET_FACTOR_TEMPL_CODE,
LEDGER_ID,
CHART_OF_ACCOUNTS_ID,
More_Than_Max_Cond_Flag,
Enabled_Flag,
DETERMINING_FACTOR_CODE1,
TAX_PARAMETER_CODE1,
DATA_TYPE1_Code,
Determining_Factor_Class1_Code,
DETERMINING_FACTOR_CQ1_Code,
OPERATOR1_Code,
NUMERIC_VALUE1,
DATE_VALUE1,
ALPHANUMERIC_VALUE1,
VALUE_LOW1,
VALUE_HIGH1,
DETERMINING_FACTOR_CODE2,
TAX_PARAMETER_CODE2,
DATA_TYPE2_Code,
Determining_Factor_Class2_Code,
DETERMINING_FACTOR_CQ2_Code,
OPERATOR2_Code,
NUMERIC_VALUE2,
DATE_VALUE2,
ALPHANUMERIC_VALUE2,
VALUE_LOW2,
VALUE_HIGH2,
DETERMINING_FACTOR_CODE3,
TAX_PARAMETER_CODE3,
DATA_TYPE3_Code,
Determining_Factor_Class3_Code,
DETERMINING_FACTOR_CQ3_Code,
OPERATOR3_Code,
NUMERIC_VALUE3,
DATE_VALUE3,
ALPHANUMERIC_VALUE3,
VALUE_LOW3,
VALUE_HIGH3,
DETERMINING_FACTOR_CODE4,
TAX_PARAMETER_CODE4,
DATA_TYPE4_Code,
Determining_Factor_Class4_Code,
DETERMINING_FACTOR_CQ4_Code,
OPERATOR4_Code,
NUMERIC_VALUE4,
DATE_VALUE4,
ALPHANUMERIC_VALUE4,
VALUE_LOW4,
VALUE_HIGH4,
DETERMINING_FACTOR_CODE5,
TAX_PARAMETER_CODE5,
DATA_TYPE5_Code,
Determining_Factor_Class5_Code,
DETERMINING_FACTOR_CQ5_Code,
OPERATOR5_Code,
NUMERIC_VALUE5,
DATE_VALUE5,
ALPHANUMERIC_VALUE5,
VALUE_LOW5,
VALUE_HIGH5,
DETERMINING_FACTOR_CODE6,
TAX_PARAMETER_CODE6,
DATA_TYPE6_Code,
Determining_Factor_Class6_Code,
DETERMINING_FACTOR_CQ6_Code,
OPERATOR6_Code,
NUMERIC_VALUE6,
DATE_VALUE6,
ALPHANUMERIC_VALUE6,
VALUE_LOW6,
VALUE_HIGH6,
DETERMINING_FACTOR_CODE7,
TAX_PARAMETER_CODE7,
DATA_TYPE7_Code,
Determining_Factor_Class7_Code,
DETERMINING_FACTOR_CQ7_Code,
OPERATOR7_Code,
NUMERIC_VALUE7,
DATE_VALUE7,
ALPHANUMERIC_VALUE7,
VALUE_LOW7,
VALUE_HIGH7,
DETERMINING_FACTOR_CODE8,
TAX_PARAMETER_CODE8,
DATA_TYPE8_Code,
Determining_Factor_Class8_Code,
DETERMINING_FACTOR_CQ8_Code,
OPERATOR8_Code,
NUMERIC_VALUE8,
DATE_VALUE8,
ALPHANUMERIC_VALUE8,
VALUE_LOW8,
VALUE_HIGH8,
DETERMINING_FACTOR_CODE9,
TAX_PARAMETER_CODE9,
DATA_TYPE9_Code,
Determining_Factor_Class9_Code,
DETERMINING_FACTOR_CQ9_Code,
OPERATOR9_Code,
NUMERIC_VALUE9,
DATE_VALUE9,
ALPHANUMERIC_VALUE9,
VALUE_LOW9,
VALUE_HIGH9,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_LOGIN_ID,
CONSTRAINT_ID,
OBJECT_VERSION_NUMBER )
values (
X_DETERMINING_FACTOR_CODE10,
X_COUNTRY_CODE,
X_TAX_PARAMETER_CODE10,
X_DATA_TYPE10_Code,
X_DETERMINING_FACTOR_CLAS10_CO,
X_DETERMINING_FACTOR_CQ10_Code,
X_OPERATOR10_Code,
X_NUMERIC_VALUE10,
X_DATE_VALUE10,
X_ALPHANUMERIC_VALUE10,
X_VALUE_LOW10,
X_VALUE_HIGH10,
X_Record_Type_Code,
X_REQUEST_ID,
X_CONDITION_GROUP_ID,
X_CONDITION_GROUP_CODE,
X_DET_FACTOR_TEMPL_CODE,
X_LEDGER_ID,
X_CHART_OF_ACCOUNTS_ID,
NVL(X_MORE_THAN_MAX_COND_FLAG,'N'),
NVL(X_ENABLED_FLAG,'N'),
X_DETERMINING_FACTOR_CODE1,
X_TAX_PARAMETER_CODE1,
X_DATA_TYPE1_Code,
X_DETERMINING_FACTOR_CLASS1_Co,
X_DETERMINING_FACTOR_CQ1_Code,
X_OPERATOR1_Code,
X_NUMERIC_VALUE1,
X_DATE_VALUE1,
X_ALPHANUMERIC_VALUE1,
X_VALUE_LOW1,
X_VALUE_HIGH1,
X_DETERMINING_FACTOR_CODE2,
X_TAX_PARAMETER_CODE2,
X_DATA_TYPE2_Code,
X_DETERMINING_FACTOR_CLASS2_Co,
X_DETERMINING_FACTOR_CQ2_Code,
X_OPERATOR2_Code,
X_NUMERIC_VALUE2,
X_DATE_VALUE2,
X_ALPHANUMERIC_VALUE2,
X_VALUE_LOW2,
X_VALUE_HIGH2,
X_DETERMINING_FACTOR_CODE3,
X_TAX_PARAMETER_CODE3,
X_DATA_TYPE3_Code,
X_DETERMINING_FACTOR_CLASS3_Co,
X_DETERMINING_FACTOR_CQ3_Code,
X_OPERATOR3_Code,
X_NUMERIC_VALUE3,
X_DATE_VALUE3,
X_ALPHANUMERIC_VALUE3,
X_VALUE_LOW3,
X_VALUE_HIGH3,
X_DETERMINING_FACTOR_CODE4,
X_TAX_PARAMETER_CODE4,
X_DATA_TYPE4_Code,
X_DETERMINING_FACTOR_CLASS4_Co,
X_DETERMINING_FACTOR_CQ4_Code,
X_OPERATOR4_Code,
X_NUMERIC_VALUE4,
X_DATE_VALUE4,
X_ALPHANUMERIC_VALUE4,
X_VALUE_LOW4,
X_VALUE_HIGH4,
X_DETERMINING_FACTOR_CODE5,
X_TAX_PARAMETER_CODE5,
X_data_Type5_Code,
X_DETERMINING_FACTOR_CLASS5_Co,
X_DETERMINING_FACTOR_CQ5_Code,
X_OPERATOR5_Code,
X_NUMERIC_VALUE5,
X_DATE_VALUE5,
X_ALPHANUMERIC_VALUE5,
X_VALUE_LOW5,
X_VALUE_HIGH5,
X_DETERMINING_FACTOR_CODE6,
X_TAX_PARAMETER_CODE6,
X_DATA_TYPE6_Code,
X_DETERMINING_FACTOR_CLASS6_Co,
X_DETERMINING_FACTOR_CQ6_Code,
X_OPERATOR6_Code,
X_NUMERIC_VALUE6,
X_DATE_VALUE6,
X_ALPHANUMERIC_VALUE6,
X_VALUE_LOW6,
X_VALUE_HIGH6,
X_DETERMINING_FACTOR_CODE7,
X_TAX_PARAMETER_CODE7,
X_DATA_TYPE7_Code,
X_DETERMINING_FACTOR_CLASS7_Co,
X_DETERMINING_FACTOR_CQ7_Code,
X_OPERATOR7_Code,
X_NUMERIC_VALUE7,
X_DATE_VALUE7,
X_ALPHANUMERIC_VALUE7,
X_VALUE_LOW7,
X_VALUE_HIGH7,
X_DETERMINING_FACTOR_CODE8,
X_TAX_PARAMETER_CODE8,
X_DATA_TYPE8_Code,
X_DETERMINING_FACTOR_CLASS8_Co,
X_DETERMINING_FACTOR_CQ8_Code,
X_OPERATOR8_Code,
X_NUMERIC_VALUE8,
X_DATE_VALUE8,
X_ALPHANUMERIC_VALUE8,
X_VALUE_LOW8,
X_VALUE_HIGH8,
X_DETERMINING_FACTOR_CODE9,
X_TAX_PARAMETER_CODE9,
X_DATA_TYPE9_Code,
X_DETERMINING_FACTOR_CLASS9_Co,
X_DETERMINING_FACTOR_CQ9_Code,
X_OPERATOR9_Code,
X_NUMERIC_VALUE9,
X_DATE_VALUE9,
X_ALPHANUMERIC_VALUE9,
X_VALUE_LOW9,
X_VALUE_HIGH9,
X_CREATION_DATE,
X_CREATED_BY,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN,
X_PROGRAM_APPLICATION_ID,
X_PROGRAM_ID,
X_PROGRAM_LOGIN_ID,
X_CONSTRAINT_ID,
X_OBJECT_VERSION_NUMBER);
insert into ZX_CONDITION_GROUPS_TL (
CONDITION_GROUP_ID,
CONDITION_GROUP_NAME,
CONDITION_GROUP_DESC,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
LANGUAGE,
SOURCE_LANG)
select
X_CONDITION_GROUP_ID,
X_CONDITION_GROUP_NAME,
X_CONDITION_GROUP_DESC,
X_CREATION_DATE,
X_CREATED_BY,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN,
L.LANGUAGE_CODE,
userenv('LANG')
from FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and not exists
(select NULL
from ZX_CONDITION_GROUPS_TL T
where T.CONDITION_GROUP_ID = X_CONDITION_GROUP_ID
and T.LANGUAGE = L.LANGUAGE_CODE);
end INSERT_ROW;
cursor c is select
DETERMINING_FACTOR_CODE10,
COUNTRY_CODE,
TAX_PARAMETER_CODE10,
DATA_TYPE10_Code,
Determining_Factor_Clas10_Code,
DETERMINING_FACTOR_CQ10_Code,
OPERATOR10_Code,
NUMERIC_VALUE10,
DATE_VALUE10,
ALPHANUMERIC_VALUE10,
VALUE_LOW10,
VALUE_HIGH10,
Record_Type_Code,
REQUEST_ID,
CONDITION_GROUP_CODE,
DET_FACTOR_TEMPL_CODE,
LEDGER_ID,
CHART_OF_ACCOUNTS_ID,
More_Than_Max_Cond_Flag,
Enabled_Flag,
DETERMINING_FACTOR_CODE1,
TAX_PARAMETER_CODE1,
DATA_TYPE1_Code,
Determining_Factor_Class1_Code,
DETERMINING_FACTOR_CQ1_Code,
OPERATOR1_Code,
NUMERIC_VALUE1,
DATE_VALUE1,
ALPHANUMERIC_VALUE1,
VALUE_LOW1,
VALUE_HIGH1,
DETERMINING_FACTOR_CODE2,
TAX_PARAMETER_CODE2,
DATA_TYPE2_Code,
Determining_Factor_Class2_Code,
DETERMINING_FACTOR_CQ2_Code,
OPERATOR2_Code,
NUMERIC_VALUE2,
DATE_VALUE2,
ALPHANUMERIC_VALUE2,
VALUE_LOW2,
VALUE_HIGH2,
DETERMINING_FACTOR_CODE3,
TAX_PARAMETER_CODE3,
DATA_TYPE3_Code,
Determining_Factor_Class3_Code,
DETERMINING_FACTOR_CQ3_Code,
OPERATOR3_Code,
NUMERIC_VALUE3,
DATE_VALUE3,
ALPHANUMERIC_VALUE3,
VALUE_LOW3,
VALUE_HIGH3,
DETERMINING_FACTOR_CODE4,
TAX_PARAMETER_CODE4,
DATA_TYPE4_Code,
Determining_Factor_Class4_Code,
DETERMINING_FACTOR_CQ4_Code,
OPERATOR4_Code,
NUMERIC_VALUE4,
DATE_VALUE4,
ALPHANUMERIC_VALUE4,
VALUE_LOW4,
VALUE_HIGH4,
DETERMINING_FACTOR_CODE5,
TAX_PARAMETER_CODE5,
DATA_TYPE5_Code,
Determining_Factor_Class5_Code,
DETERMINING_FACTOR_CQ5_Code,
OPERATOR5_Code,
NUMERIC_VALUE5,
DATE_VALUE5,
ALPHANUMERIC_VALUE5,
VALUE_LOW5,
VALUE_HIGH5,
DETERMINING_FACTOR_CODE6,
TAX_PARAMETER_CODE6,
DATA_TYPE6_Code,
Determining_Factor_Class6_Code,
DETERMINING_FACTOR_CQ6_Code,
OPERATOR6_Code,
NUMERIC_VALUE6,
DATE_VALUE6,
ALPHANUMERIC_VALUE6,
VALUE_LOW6,
VALUE_HIGH6,
DETERMINING_FACTOR_CODE7,
TAX_PARAMETER_CODE7,
DATA_TYPE7_Code,
Determining_Factor_Class7_Code,
DETERMINING_FACTOR_CQ7_Code,
OPERATOR7_Code,
NUMERIC_VALUE7,
DATE_VALUE7,
ALPHANUMERIC_VALUE7,
VALUE_LOW7,
VALUE_HIGH7,
DETERMINING_FACTOR_CODE8,
TAX_PARAMETER_CODE8,
DATA_TYPE8_Code,
Determining_Factor_Class8_Code,
DETERMINING_FACTOR_CQ8_Code,
OPERATOR8_Code,
NUMERIC_VALUE8,
DATE_VALUE8,
ALPHANUMERIC_VALUE8,
VALUE_LOW8,
VALUE_HIGH8,
DETERMINING_FACTOR_CODE9,
TAX_PARAMETER_CODE9,
DATA_TYPE9_Code,
Determining_Factor_Class9_Code,
DETERMINING_FACTOR_CQ9_Code,
OPERATOR9_Code,
NUMERIC_VALUE9,
DATE_VALUE9,
ALPHANUMERIC_VALUE9,
VALUE_LOW9,
VALUE_HIGH9,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_LOGIN_ID ,
CONSTRAINT_ID ,
OBJECT_VERSION_NUMBER
from ZX_CONDITION_GROUPS_B
where CONDITION_GROUP_ID = X_CONDITION_GROUP_ID
for update of CONDITION_GROUP_ID nowait;
cursor c1 is select
CONDITION_GROUP_NAME,
CONDITION_GROUP_DESC,
decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
from ZX_CONDITION_GROUPS_TL
where CONDITION_GROUP_ID = X_CONDITION_GROUP_ID
and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
for update of CONDITION_GROUP_ID nowait;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
procedure UPDATE_ROW (
X_CONDITION_GROUP_ID in NUMBER,
X_DETERMINING_FACTOR_CODE10 in VARCHAR2,
X_COUNTRY_CODE in VARCHAR2,
X_TAX_PARAMETER_CODE10 in VARCHAR2,
X_DATA_TYPE10_CODE in VARCHAR2,
X_DETERMINING_FACTOR_CLAS10_CO in VARCHAR2,
X_DETERMINING_FACTOR_CQ10_CODE in VARCHAR2,
X_OPERATOR10_CODE in VARCHAR2,
X_NUMERIC_VALUE10 in NUMBER,
X_DATE_VALUE10 in DATE,
X_ALPHANUMERIC_VALUE10 in VARCHAR2,
X_VALUE_LOW10 in VARCHAR2,
X_VALUE_HIGH10 in VARCHAR2,
X_Record_Type_CODE in VARCHAR2,
X_REQUEST_ID in NUMBER,
X_CONDITION_GROUP_CODE in VARCHAR2,
X_DET_FACTOR_TEMPL_CODE in VARCHAR2,
X_LEDGER_ID in NUMBER,
X_CHART_OF_ACCOUNTS_ID in NUMBER,
X_More_Than_Max_Cond_Flag in VARCHAR2,
X_Enabled_Flag in VARCHAR2,
X_DETERMINING_FACTOR_CODE1 in VARCHAR2,
X_TAX_PARAMETER_CODE1 in VARCHAR2,
X_DATA_TYPE1_CODE in VARCHAR2,
X_DETERMINING_FACTOR_CLASS1_CO in VARCHAR2,
X_DETERMINING_FACTOR_CQ1_CODE in VARCHAR2,
X_OPERATOR1_CODE in VARCHAR2,
X_NUMERIC_VALUE1 in NUMBER,
X_DATE_VALUE1 in DATE,
X_ALPHANUMERIC_VALUE1 in VARCHAR2,
X_VALUE_LOW1 in VARCHAR2,
X_VALUE_HIGH1 in VARCHAR2,
X_DETERMINING_FACTOR_CODE2 in VARCHAR2,
X_TAX_PARAMETER_CODE2 in VARCHAR2,
X_DATA_TYPE2_CODE in VARCHAR2,
X_DETERMINING_FACTOR_CLASS2_CO in VARCHAR2,
X_DETERMINING_FACTOR_CQ2_CODE in VARCHAR2,
X_OPERATOR2_CODE in VARCHAR2,
X_NUMERIC_VALUE2 in NUMBER,
X_DATE_VALUE2 in DATE,
X_ALPHANUMERIC_VALUE2 in VARCHAR2,
X_VALUE_LOW2 in VARCHAR2,
X_VALUE_HIGH2 in VARCHAR2,
X_DETERMINING_FACTOR_CODE3 in VARCHAR2,
X_TAX_PARAMETER_CODE3 in VARCHAR2,
X_DATA_TYPE3_CODE in VARCHAR2,
X_DETERMINING_FACTOR_CLASS3_CO in VARCHAR2,
X_DETERMINING_FACTOR_CQ3_CODE in VARCHAR2,
X_OPERATOR3_CODE in VARCHAR2,
X_NUMERIC_VALUE3 in NUMBER,
X_DATE_VALUE3 in DATE,
X_ALPHANUMERIC_VALUE3 in VARCHAR2,
X_VALUE_LOW3 in VARCHAR2,
X_VALUE_HIGH3 in VARCHAR2,
X_DETERMINING_FACTOR_CODE4 in VARCHAR2,
X_TAX_PARAMETER_CODE4 in VARCHAR2,
X_DATA_TYPE4_CODE in VARCHAR2,
X_DETERMINING_FACTOR_CLASS4_CO in VARCHAR2,
X_DETERMINING_FACTOR_CQ4_CODE in VARCHAR2,
X_OPERATOR4_CODE in VARCHAR2,
X_NUMERIC_VALUE4 in NUMBER,
X_DATE_VALUE4 in DATE,
X_ALPHANUMERIC_VALUE4 in VARCHAR2,
X_VALUE_LOW4 in VARCHAR2,
X_VALUE_HIGH4 in VARCHAR2,
X_DETERMINING_FACTOR_CODE5 in VARCHAR2,
X_TAX_PARAMETER_CODE5 in VARCHAR2,
X_data_Type5_CODE in VARCHAR2,
X_DETERMINING_FACTOR_CLASS5_CO in VARCHAR2,
X_DETERMINING_FACTOR_CQ5_CODE in VARCHAR2,
X_OPERATOR5_CODE in VARCHAR2,
X_NUMERIC_VALUE5 in NUMBER,
X_DATE_VALUE5 in DATE,
X_ALPHANUMERIC_VALUE5 in VARCHAR2,
X_VALUE_LOW5 in VARCHAR2,
X_VALUE_HIGH5 in VARCHAR2,
X_DETERMINING_FACTOR_CODE6 in VARCHAR2,
X_TAX_PARAMETER_CODE6 in VARCHAR2,
X_DATA_TYPE6_CODE in VARCHAR2,
X_DETERMINING_FACTOR_CLASS6_CO in VARCHAR2,
X_DETERMINING_FACTOR_CQ6_CODE in VARCHAR2,
X_OPERATOR6_CODE in VARCHAR2,
X_NUMERIC_VALUE6 in NUMBER,
X_DATE_VALUE6 in DATE,
X_ALPHANUMERIC_VALUE6 in VARCHAR2,
X_VALUE_LOW6 in VARCHAR2,
X_VALUE_HIGH6 in VARCHAR2,
X_DETERMINING_FACTOR_CODE7 in VARCHAR2,
X_TAX_PARAMETER_CODE7 in VARCHAR2,
X_DATA_TYPE7_CODE in VARCHAR2,
X_DETERMINING_FACTOR_CLASS7_CO in VARCHAR2,
X_DETERMINING_FACTOR_CQ7_CODE in VARCHAR2,
X_OPERATOR7_CODE in VARCHAR2,
X_NUMERIC_VALUE7 in NUMBER,
X_DATE_VALUE7 in DATE,
X_ALPHANUMERIC_VALUE7 in VARCHAR2,
X_VALUE_LOW7 in VARCHAR2,
X_VALUE_HIGH7 in VARCHAR2,
X_DETERMINING_FACTOR_CODE8 in VARCHAR2,
X_TAX_PARAMETER_CODE8 in VARCHAR2,
X_DATA_TYPE8_CODE in VARCHAR2,
X_DETERMINING_FACTOR_CLASS8_CO in VARCHAR2,
X_DETERMINING_FACTOR_CQ8_CODE in VARCHAR2,
X_OPERATOR8_CODE in VARCHAR2,
X_NUMERIC_VALUE8 in NUMBER,
X_DATE_VALUE8 in DATE,
X_ALPHANUMERIC_VALUE8 in VARCHAR2,
X_VALUE_LOW8 in VARCHAR2,
X_VALUE_HIGH8 in VARCHAR2,
X_DETERMINING_FACTOR_CODE9 in VARCHAR2,
X_TAX_PARAMETER_CODE9 in VARCHAR2,
X_DATA_TYPE9_CODE in VARCHAR2,
X_DETERMINING_FACTOR_CLASS9_CO in VARCHAR2,
X_DETERMINING_FACTOR_CQ9_CODE in VARCHAR2,
X_OPERATOR9_CODE in VARCHAR2,
X_NUMERIC_VALUE9 in NUMBER,
X_DATE_VALUE9 in DATE,
X_ALPHANUMERIC_VALUE9 in VARCHAR2,
X_VALUE_LOW9 in VARCHAR2,
X_VALUE_HIGH9 in VARCHAR2,
X_CONDITION_GROUP_NAME in VARCHAR2,
X_CONDITION_GROUP_DESC in VARCHAR2,
X_LAST_UPDATE_DATE in DATE,
X_LAST_UPDATED_BY in NUMBER,
X_LAST_UPDATE_LOGIN in NUMBER,
X_PROGRAM_APPLICATION_ID in NUMBER,
X_PROGRAM_ID in NUMBER,
X_PROGRAM_LOGIN_ID in NUMBER,
X_CONSTRAINT_ID IN NUMBER,
X_OBJECT_VERSION_NUMBER in NUMBER) is
CURSOR C1 is
SELECT Enabled_Flag
FROM ZX_CONDITION_GROUPS_VL
WHERE CONDITION_GROUP_ID = X_CONDITION_GROUP_ID;
SELECT TAX_RULE_ID,RESULT_ID
FROM ZX_PROCESS_RESULTS
WHERE Enabled_Flag = 'Y'
AND CONDITION_GROUP_CODE = X_CONDITION_GROUP_CODE;
SELECT TAX_RULE_ID
FROM ZX_PROCESS_RESULTS
WHERE TAX_RULE_ID = p_cur_rule_id and Enabled_Flag = 'Y'
and RESULT_ID <> p_cur_result_id;
SELECT *
FROM ZX_RULES_VL
WHERE TAX_RULE_ID = p_cur_rule_id1;
ZX_RULES_PKG.UPDATE_ROW( p_rule_id,
p_rule_rec.TAX_RULE_CODE ,
p_rule_rec.TAX ,
p_rule_rec.TAX_REGIME_CODE ,
p_rule_rec.SERVICE_TYPE_CODE ,
p_rule_rec.RECOVERY_TYPE_CODE ,
p_rule_rec.PRIORITY ,
p_rule_rec.System_Default_Flag ,
p_rule_rec.EFFECTIVE_FROM ,
p_rule_rec.EFFECTIVE_TO ,
p_rule_rec.Record_Type_CODE ,
p_rule_rec.REQUEST_ID ,
p_rule_rec.TAX_RULE_NAME ,
p_rule_rec.TAX_RULE_DESC ,
p_rule_rec.LAST_UPDATE_DATE ,
p_rule_rec.LAST_UPDATED_BY ,
p_rule_rec.LAST_UPDATE_LOGIN ,
p_rule_rec.PROGRAM_APPLICATION_ID ,
p_rule_rec.PROGRAM_ID ,
p_rule_rec.PROGRAM_LOGIN_ID ,
'N',
p_rule_rec.APPLICATION_ID ,
p_rule_rec.CONTENT_OWNER_ID ,
p_rule_rec.DET_FACTOR_TEMPL_CODE,
p_rule_rec.EVENT_CLASS_MAPPING_ID,
p_rule_rec.TAX_EVENT_CLASS_CODE ,
p_rule_rec.OBJECT_VERSION_NUMBER,
p_rule_rec.DETERMINING_FACTOR_CQ_CODE,
p_rule_rec.GEOGRAPHY_TYPE ,
p_rule_rec.GEOGRAPHY_ID ,
p_rule_rec.TAX_LAW_REF_CODE ,
p_rule_rec.TAX_LAW_REF_DESC ,
p_rule_rec.LAST_UPDATE_MODE_FLAG ,
p_rule_rec.NEVER_BEEN_ENABLED_FLAG
);
UPDATE ZX_PROCESS_RESULTS SET Enabled_Flag = 'N'
WHERE CONDITION_GROUP_ID = X_CONDITION_GROUP_ID;
update ZX_CONDITION_GROUPS_B set
DETERMINING_FACTOR_CODE10 = X_DETERMINING_FACTOR_CODE10,
COUNTRY_CODE = X_COUNTRY_CODE,
TAX_PARAMETER_CODE10 = X_TAX_PARAMETER_CODE10,
DATA_TYPE10_CODE = X_DATA_TYPE10_Code,
Determining_Factor_Clas10_CODE = X_DETERMINING_FACTOR_CLAS10_CO,
DETERMINING_FACTOR_CQ10_CODE = X_DETERMINING_FACTOR_CQ10_Code,
OPERATOR10_CODE = X_OPERATOR10_Code,
NUMERIC_VALUE10 = X_NUMERIC_VALUE10,
DATE_VALUE10 = X_DATE_VALUE10,
ALPHANUMERIC_VALUE10 = X_ALPHANUMERIC_VALUE10,
VALUE_LOW10 = X_VALUE_LOW10,
VALUE_HIGH10 = X_VALUE_HIGH10,
Record_Type_CODE = X_Record_Type_Code,
REQUEST_ID = X_REQUEST_ID,
CONDITION_GROUP_CODE = X_CONDITION_GROUP_CODE,
DET_FACTOR_TEMPL_CODE = X_DET_FACTOR_TEMPL_CODE,
LEDGER_ID = X_LEDGER_ID,
CHART_OF_ACCOUNTS_ID = X_CHART_OF_ACCOUNTS_ID,
More_Than_Max_Cond_Flag = NVL(X_MORE_THAN_MAX_COND_FLAG,'N'),
Enabled_Flag = NVL(X_ENABLED_FLAG,'N'),
DETERMINING_FACTOR_CODE1 = X_DETERMINING_FACTOR_CODE1,
TAX_PARAMETER_CODE1 = X_TAX_PARAMETER_CODE1,
DATA_TYPE1_CODE = X_DATA_TYPE1_Code,
Determining_Factor_Class1_CODE = X_DETERMINING_FACTOR_CLASS1_Co,
DETERMINING_FACTOR_CQ1_CODE = X_DETERMINING_FACTOR_CQ1_Code,
OPERATOR1_CODE = X_OPERATOR1_Code,
NUMERIC_VALUE1 = X_NUMERIC_VALUE1,
DATE_VALUE1 = X_DATE_VALUE1,
ALPHANUMERIC_VALUE1 = X_ALPHANUMERIC_VALUE1,
VALUE_LOW1 = X_VALUE_LOW1,
VALUE_HIGH1 = X_VALUE_HIGH1,
DETERMINING_FACTOR_CODE2 = X_DETERMINING_FACTOR_CODE2,
TAX_PARAMETER_CODE2 = X_TAX_PARAMETER_CODE2,
DATA_TYPE2_CODE = X_DATA_TYPE2_Code,
Determining_Factor_Class2_CODE = X_DETERMINING_FACTOR_CLASS2_Co,
DETERMINING_FACTOR_CQ2_CODE = X_DETERMINING_FACTOR_CQ2_Code,
OPERATOR2_CODE = X_OPERATOR2_Code,
NUMERIC_VALUE2 = X_NUMERIC_VALUE2,
DATE_VALUE2 = X_DATE_VALUE2,
ALPHANUMERIC_VALUE2 = X_ALPHANUMERIC_VALUE2,
VALUE_LOW2 = X_VALUE_LOW2,
VALUE_HIGH2 = X_VALUE_HIGH2,
DETERMINING_FACTOR_CODE3 = X_DETERMINING_FACTOR_CODE3,
TAX_PARAMETER_CODE3 = X_TAX_PARAMETER_CODE3,
DATA_TYPE3_CODE = X_DATA_TYPE3_Code,
Determining_Factor_Class3_CODE = X_DETERMINING_FACTOR_CLASS3_Co,
DETERMINING_FACTOR_CQ3_CODE = X_DETERMINING_FACTOR_CQ3_Code,
OPERATOR3_CODE = X_OPERATOR3_Code,
NUMERIC_VALUE3 = X_NUMERIC_VALUE3,
DATE_VALUE3 = X_DATE_VALUE3,
ALPHANUMERIC_VALUE3 = X_ALPHANUMERIC_VALUE3,
VALUE_LOW3 = X_VALUE_LOW3,
VALUE_HIGH3 = X_VALUE_HIGH3,
DETERMINING_FACTOR_CODE4 = X_DETERMINING_FACTOR_CODE4,
TAX_PARAMETER_CODE4 = X_TAX_PARAMETER_CODE4,
DATA_TYPE4_CODE = X_DATA_TYPE4_Code,
Determining_Factor_Class4_CODE = X_DETERMINING_FACTOR_CLASS4_Co,
DETERMINING_FACTOR_CQ4_CODE = X_DETERMINING_FACTOR_CQ4_Code,
OPERATOR4_CODE = X_OPERATOR4_Code,
NUMERIC_VALUE4 = X_NUMERIC_VALUE4,
DATE_VALUE4 = X_DATE_VALUE4,
ALPHANUMERIC_VALUE4 = X_ALPHANUMERIC_VALUE4,
VALUE_LOW4 = X_VALUE_LOW4,
VALUE_HIGH4 = X_VALUE_HIGH4,
DETERMINING_FACTOR_CODE5 = X_DETERMINING_FACTOR_CODE5,
TAX_PARAMETER_CODE5 = X_TAX_PARAMETER_CODE5,
DATA_TYPE5_CODE = X_data_Type5_Code,
Determining_Factor_Class5_CODE = X_DETERMINING_FACTOR_CLASS5_Co,
DETERMINING_FACTOR_CQ5_CODE = X_DETERMINING_FACTOR_CQ5_Code,
OPERATOR5_CODE = X_OPERATOR5_Code,
NUMERIC_VALUE5 = X_NUMERIC_VALUE5,
DATE_VALUE5 = X_DATE_VALUE5,
ALPHANUMERIC_VALUE5 = X_ALPHANUMERIC_VALUE5,
VALUE_LOW5 = X_VALUE_LOW5,
VALUE_HIGH5 = X_VALUE_HIGH5,
DETERMINING_FACTOR_CODE6 = X_DETERMINING_FACTOR_CODE6,
TAX_PARAMETER_CODE6 = X_TAX_PARAMETER_CODE6,
DATA_TYPE6_CODE = X_DATA_TYPE6_Code,
Determining_Factor_Class6_CODE = X_DETERMINING_FACTOR_CLASS6_Co,
DETERMINING_FACTOR_CQ6_CODE = X_DETERMINING_FACTOR_CQ6_Code,
OPERATOR6_CODE = X_OPERATOR6_Code,
NUMERIC_VALUE6 = X_NUMERIC_VALUE6,
DATE_VALUE6 = X_DATE_VALUE6,
ALPHANUMERIC_VALUE6 = X_ALPHANUMERIC_VALUE6,
VALUE_LOW6 = X_VALUE_LOW6,
VALUE_HIGH6 = X_VALUE_HIGH6,
DETERMINING_FACTOR_CODE7 = X_DETERMINING_FACTOR_CODE7,
TAX_PARAMETER_CODE7 = X_TAX_PARAMETER_CODE7,
DATA_TYPE7_CODE = X_DATA_TYPE7_Code,
Determining_Factor_Class7_CODE = X_DETERMINING_FACTOR_CLASS7_Co,
DETERMINING_FACTOR_CQ7_CODE = X_DETERMINING_FACTOR_CQ7_Code,
OPERATOR7_CODE = X_OPERATOR7_Code,
NUMERIC_VALUE7 = X_NUMERIC_VALUE7,
DATE_VALUE7 = X_DATE_VALUE7,
ALPHANUMERIC_VALUE7 = X_ALPHANUMERIC_VALUE7,
VALUE_LOW7 = X_VALUE_LOW7,
VALUE_HIGH7 = X_VALUE_HIGH7,
DETERMINING_FACTOR_CODE8 = X_DETERMINING_FACTOR_CODE8,
TAX_PARAMETER_CODE8 = X_TAX_PARAMETER_CODE8,
DATA_TYPE8_CODE = X_DATA_TYPE8_Code,
Determining_Factor_Class8_CODE = X_DETERMINING_FACTOR_CLASS8_Co,
DETERMINING_FACTOR_CQ8_CODE = X_DETERMINING_FACTOR_CQ8_Code,
OPERATOR8_CODE = X_OPERATOR8_Code,
NUMERIC_VALUE8 = X_NUMERIC_VALUE8,
DATE_VALUE8 = X_DATE_VALUE8,
ALPHANUMERIC_VALUE8 = X_ALPHANUMERIC_VALUE8,
VALUE_LOW8 = X_VALUE_LOW8,
VALUE_HIGH8 = X_VALUE_HIGH8,
DETERMINING_FACTOR_CODE9 = X_DETERMINING_FACTOR_CODE9,
TAX_PARAMETER_CODE9 = X_TAX_PARAMETER_CODE9,
DATA_TYPE9_CODE = X_DATA_TYPE9_Code,
Determining_Factor_Class9_CODE = X_DETERMINING_FACTOR_CLASS9_Co,
DETERMINING_FACTOR_CQ9_CODE = X_DETERMINING_FACTOR_CQ9_Code,
OPERATOR9_CODE = X_OPERATOR9_Code,
NUMERIC_VALUE9 = X_NUMERIC_VALUE9,
DATE_VALUE9 = X_DATE_VALUE9,
ALPHANUMERIC_VALUE9 = X_ALPHANUMERIC_VALUE9,
VALUE_LOW9 = X_VALUE_LOW9,
VALUE_HIGH9 = X_VALUE_HIGH9,
LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
LAST_UPDATED_BY = X_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID,
PROGRAM_ID = X_PROGRAM_ID,
PROGRAM_LOGIN_ID = X_PROGRAM_LOGIN_ID,
CONSTRAINT_ID = X_CONSTRAINT_ID,
OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER
where CONDITION_GROUP_ID = X_CONDITION_GROUP_ID;
update ZX_CONDITION_GROUPS_TL set
CONDITION_GROUP_NAME = X_CONDITION_GROUP_NAME,
CONDITION_GROUP_DESC = X_CONDITION_GROUP_DESC,
LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
LAST_UPDATED_BY = X_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
SOURCE_LANG = userenv('LANG')
where CONDITION_GROUP_ID = X_CONDITION_GROUP_ID
and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
end UPDATE_ROW;
procedure DELETE_ROW (
X_CONDITION_GROUP_ID in NUMBER) is
begin
delete from ZX_CONDITION_GROUPS_TL
where CONDITION_GROUP_ID = X_CONDITION_GROUP_ID;
delete from ZX_CONDITION_GROUPS_B
where CONDITION_GROUP_ID = X_CONDITION_GROUP_ID;
end DELETE_ROW;
delete from ZX_CONDITION_GROUPS_TL T
where not exists
(select NULL
from ZX_CONDITION_GROUPS_B B
where B.CONDITION_GROUP_ID = T.CONDITION_GROUP_ID);
update ZX_CONDITION_GROUPS_TL T set (
CONDITION_GROUP_NAME,
CONDITION_GROUP_DESC) = (select B.CONDITION_GROUP_NAME,
B.CONDITION_GROUP_DESC
from ZX_CONDITION_GROUPS_TL B
where B.CONDITION_GROUP_ID = T.CONDITION_GROUP_ID
and B.LANGUAGE = T.SOURCE_LANG)
where (T.CONDITION_GROUP_ID, T.LANGUAGE) in
(select SUBT.CONDITION_GROUP_ID,
SUBT.LANGUAGE
from ZX_CONDITION_GROUPS_TL SUBB, ZX_CONDITION_GROUPS_TL SUBT
where SUBB.CONDITION_GROUP_ID = SUBT.CONDITION_GROUP_ID
and SUBB.LANGUAGE = SUBT.SOURCE_LANG
and (SUBB.CONDITION_GROUP_NAME <> SUBT.CONDITION_GROUP_NAME
or SUBB.CONDITION_GROUP_DESC <> SUBT.CONDITION_GROUP_DESC
or (SUBB.CONDITION_GROUP_DESC is null
and SUBT.CONDITION_GROUP_DESC is not null)
or (SUBB.CONDITION_GROUP_DESC is not null
and SUBT.CONDITION_GROUP_DESC is null) ));
insert into ZX_CONDITION_GROUPS_TL (
CONDITION_GROUP_ID,
CONDITION_GROUP_NAME,
CONDITION_GROUP_DESC,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
LANGUAGE,
SOURCE_LANG)
select
B.CONDITION_GROUP_ID,
B.CONDITION_GROUP_NAME,
B.CONDITION_GROUP_DESC,
B.CREATION_DATE,
B.CREATED_BY,
B.LAST_UPDATE_DATE,
B.LAST_UPDATED_BY,
B.LAST_UPDATE_LOGIN,
L.LANGUAGE_CODE,
B.SOURCE_LANG
from ZX_CONDITION_GROUPS_TL B, FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and B.LANGUAGE = userenv('LANG')
and not exists
(select NULL
from ZX_CONDITION_GROUPS_TL T
where T.CONDITION_GROUP_ID = B.CONDITION_GROUP_ID
and T.LANGUAGE = L.LANGUAGE_CODE);
/*procedure bulk_insert_condition_groups (
X_CONDITION_GROUP_ID IN t_condition_group_id,
X_DETERMINING_FACTOR_CODE10 IN t_determining_factor_code,
X_COUNTRY_CODE IN t_country_code,
X_TAX_PARAMETER_CODE10 IN t_tax_parameter_code,
X_DATA_TYPE10_CODE IN t_data_type,
X_DETERMINING_FACTOR_CLAS10_CO IN t_determining_factor_class,
X_DETERMINING_FACTOR_CQ10_CODE IN t_determining_factor_cq,
X_OPERATOR10_CODE IN t_operator,
X_NUMERIC_VALUE10 IN t_numeric_value,
X_DATE_VALUE10 IN t_date_value,
X_ALPHANUMERIC_VALUE10 IN t_alphanumeric_value,
X_VALUE_LOW10 IN t_value_low,
X_VALUE_HIGH10 IN t_value_high,
X_Record_Type_CODE IN t_record_type,
X_CONDITION_GROUP_CODE IN t_condition_group_code,
X_DET_FACTOR_TEMPL_CODE IN t_det_factor_templ_code,
X_APPLICATION_ID IN t_application_id,
X_LEDGER_ID IN t_ledger_id,
X_CHART_OF_ACCOUNTS_ID IN t_chart_of_accounts_id,
X_More_Than_Max_Cond_Flag IN t_more_than_max_cond_flg,
X_Enabled_Flag IN t_enabled_flg,
X_DETERMINING_FACTOR_CODE1 IN t_determining_factor_code,
X_TAX_PARAMETER_CODE1 IN t_tax_parameter_code,
X_DATA_TYPE1_CODE IN t_data_type,
X_DETERMINING_FACTOR_CLASS1_CO IN t_determining_factor_class,
X_DETERMINING_FACTOR_CQ1_CODE IN t_determining_factor_cq,
X_OPERATOR1_CODE IN t_operator,
X_NUMERIC_VALUE1 IN t_numeric_value,
X_DATE_VALUE1 IN t_date_value,
X_ALPHANUMERIC_VALUE1 IN t_alphanumeric_value,
X_VALUE_LOW1 IN t_value_low,
X_VALUE_HIGH1 IN t_value_high,
X_DETERMINING_FACTOR_CODE2 IN t_determining_factor_code,
X_TAX_PARAMETER_CODE2 IN t_tax_parameter_code,
X_DATA_TYPE2_CODE IN t_data_type,
X_DETERMINING_FACTOR_CLASS2_CO IN t_determining_factor_class,
X_DETERMINING_FACTOR_CQ2_CODE IN t_determining_factor_cq,
X_OPERATOR2_CODE IN t_operator,
X_NUMERIC_VALUE2 IN t_numeric_value,
X_DATE_VALUE2 IN t_date_value,
X_ALPHANUMERIC_VALUE2 IN t_alphanumeric_value,
X_VALUE_LOW2 IN t_value_low,
X_VALUE_HIGH2 IN t_value_high,
X_DETERMINING_FACTOR_CODE3 IN t_determining_factor_code,
X_TAX_PARAMETER_CODE3 IN t_tax_parameter_code,
X_DATA_TYPE3_CODE IN t_data_type,
X_DETERMINING_FACTOR_CLASS3_CO IN t_determining_factor_class,
X_DETERMINING_FACTOR_CQ3_CODE IN t_determining_factor_cq,
X_OPERATOR3_CODE IN t_operator,
X_NUMERIC_VALUE3 IN t_numeric_value,
X_DATE_VALUE3 IN t_date_value,
X_ALPHANUMERIC_VALUE3 IN t_alphanumeric_value,
X_VALUE_LOW3 IN t_value_low,
X_VALUE_HIGH3 IN t_value_high,
X_DETERMINING_FACTOR_CODE4 IN t_determining_factor_code,
X_TAX_PARAMETER_CODE4 IN t_tax_parameter_code,
X_DATA_TYPE4_CODE IN t_data_type,
X_DETERMINING_FACTOR_CLASS4_CO IN t_determining_factor_class,
X_DETERMINING_FACTOR_CQ4_CODE IN t_determining_factor_cq,
X_OPERATOR4_CODE IN t_operator,
X_NUMERIC_VALUE4 IN t_numeric_value,
X_DATE_VALUE4 IN t_date_value,
X_ALPHANUMERIC_VALUE4 IN t_alphanumeric_value,
X_VALUE_LOW4 IN t_value_low,
X_VALUE_HIGH4 IN t_value_high,
X_DETERMINING_FACTOR_CODE5 IN t_determining_factor_code,
X_TAX_PARAMETER_CODE5 IN t_tax_parameter_code,
X_data_Type5_CODE IN t_data_type,
X_DETERMINING_FACTOR_CLASS5_CO IN t_determining_factor_class,
X_DETERMINING_FACTOR_CQ5_CODE IN t_determining_factor_cq,
X_OPERATOR5_CODE IN t_operator,
X_NUMERIC_VALUE5 IN t_numeric_value,
X_DATE_VALUE5 IN t_date_value,
X_ALPHANUMERIC_VALUE5 IN t_alphanumeric_value,
X_VALUE_LOW5 IN t_value_low,
X_VALUE_HIGH5 IN t_value_high,
X_DETERMINING_FACTOR_CODE6 IN t_determining_factor_code,
X_TAX_PARAMETER_CODE6 IN t_tax_parameter_code,
X_DATA_TYPE6_CODE IN t_data_type,
X_DETERMINING_FACTOR_CLASS6_CO IN t_determining_factor_class,
X_DETERMINING_FACTOR_CQ6_CODE IN t_determining_factor_cq,
X_OPERATOR6_CODE IN t_operator,
X_NUMERIC_VALUE6 IN t_numeric_value,
X_DATE_VALUE6 IN t_date_value,
X_ALPHANUMERIC_VALUE6 IN t_alphanumeric_value,
X_VALUE_LOW6 IN t_value_low,
X_VALUE_HIGH6 IN t_value_high,
X_DETERMINING_FACTOR_CODE7 IN t_determining_factor_code,
X_TAX_PARAMETER_CODE7 IN t_tax_parameter_code,
X_DATA_TYPE7_CODE IN t_data_type,
X_DETERMINING_FACTOR_CLASS7_CO IN t_determining_factor_class,
X_DETERMINING_FACTOR_CQ7_CODE IN t_determining_factor_cq,
X_OPERATOR7_CODE IN t_operator,
X_NUMERIC_VALUE7 IN t_numeric_value,
X_DATE_VALUE7 IN t_date_value,
X_ALPHANUMERIC_VALUE7 IN t_alphanumeric_value,
X_VALUE_LOW7 IN t_value_low,
X_VALUE_HIGH7 IN t_value_high,
X_DETERMINING_FACTOR_CODE8 IN t_determining_factor_code,
X_TAX_PARAMETER_CODE8 IN t_tax_parameter_code,
X_DATA_TYPE8_CODE IN t_data_type,
X_DETERMINING_FACTOR_CLASS8_CO IN t_determining_factor_class,
X_DETERMINING_FACTOR_CQ8_CODE IN t_determining_factor_cq,
X_OPERATOR8_CODE IN t_operator,
X_NUMERIC_VALUE8 IN t_numeric_value,
X_DATE_VALUE8 IN t_date_value,
X_ALPHANUMERIC_VALUE8 IN t_alphanumeric_value,
X_VALUE_LOW8 IN t_value_low,
X_VALUE_HIGH8 IN t_value_high,
X_DETERMINING_FACTOR_CODE9 IN t_determining_factor_code,
X_TAX_PARAMETER_CODE9 IN t_tax_parameter_code,
X_DATA_TYPE9_CODE IN t_data_type,
X_DETERMINING_FACTOR_CLASS9_CO IN t_determining_factor_class,
X_DETERMINING_FACTOR_CQ9_CODE IN t_determining_factor_cq,
X_OPERATOR9_CODE IN t_operator,
X_NUMERIC_VALUE9 IN t_numeric_value,
X_DATE_VALUE9 IN t_date_value,
X_ALPHANUMERIC_VALUE9 IN t_alphanumeric_value,
X_VALUE_LOW9 IN t_value_low,
X_VALUE_HIGH9 IN t_value_high,
X_CONDITION_GROUP_NAME IN t_condition_group_name,
X_CONDITION_GROUP_DESC IN t_condition_group_desc) is
begin
If x_condition_group_id.count <> 0 then
forall i in x_condition_group_id.first..x_condition_group_id.last
INSERT INTO ZX_CONDITION_GROUPS_B (
DETERMINING_FACTOR_CODE10,
COUNTRY_CODE,
TAX_PARAMETER_CODE10,
DATA_TYPE10_Code,
Determining_Factor_Clas10_Code,
DETERMINING_FACTOR_CQ10_Code,
OPERATOR10_Code,
NUMERIC_VALUE10,
DATE_VALUE10,
ALPHANUMERIC_VALUE10,
VALUE_LOW10,
VALUE_HIGH10,
Record_Type_Code,
CONDITION_GROUP_ID,
CONDITION_GROUP_CODE,
DET_FACTOR_TEMPL_CODE,
APPLICATION_ID,
LEDGER_ID,
CHART_OF_ACCOUNTS_ID,
More_Than_Max_Cond_Flag,
Enabled_Flag,
DETERMINING_FACTOR_CODE1,
TAX_PARAMETER_CODE1,
DATA_TYPE1_Code,
Determining_Factor_Class1_Code,
DETERMINING_FACTOR_CQ1_Code,
OPERATOR1_Code,
NUMERIC_VALUE1,
DATE_VALUE1,
ALPHANUMERIC_VALUE1,
VALUE_LOW1,
VALUE_HIGH1,
DETERMINING_FACTOR_CODE2,
TAX_PARAMETER_CODE2,
DATA_TYPE2_Code,
Determining_Factor_Class2_Code,
DETERMINING_FACTOR_CQ2_Code,
OPERATOR2_Code,
NUMERIC_VALUE2,
DATE_VALUE2,
ALPHANUMERIC_VALUE2,
VALUE_LOW2,
VALUE_HIGH2,
DETERMINING_FACTOR_CODE3,
TAX_PARAMETER_CODE3,
DATA_TYPE3_Code,
Determining_Factor_Class3_Code,
DETERMINING_FACTOR_CQ3_Code,
OPERATOR3_Code,
NUMERIC_VALUE3,
DATE_VALUE3,
ALPHANUMERIC_VALUE3,
VALUE_LOW3,
VALUE_HIGH3,
DETERMINING_FACTOR_CODE4,
TAX_PARAMETER_CODE4,
DATA_TYPE4_Code,
Determining_Factor_Class4_Code,
DETERMINING_FACTOR_CQ4_Code,
OPERATOR4_Code,
NUMERIC_VALUE4,
DATE_VALUE4,
ALPHANUMERIC_VALUE4,
VALUE_LOW4,
VALUE_HIGH4,
DETERMINING_FACTOR_CODE5,
TAX_PARAMETER_CODE5,
DATA_TYPE5_Code,
Determining_Factor_Class5_Code,
DETERMINING_FACTOR_CQ5_Code,
OPERATOR5_Code,
NUMERIC_VALUE5,
DATE_VALUE5,
ALPHANUMERIC_VALUE5,
VALUE_LOW5,
VALUE_HIGH5,
DETERMINING_FACTOR_CODE6,
TAX_PARAMETER_CODE6,
DATA_TYPE6_Code,
Determining_Factor_Class6_Code,
DETERMINING_FACTOR_CQ6_Code,
OPERATOR6_Code,
NUMERIC_VALUE6,
DATE_VALUE6,
ALPHANUMERIC_VALUE6,
VALUE_LOW6,
VALUE_HIGH6,
DETERMINING_FACTOR_CODE7,
TAX_PARAMETER_CODE7,
DATA_TYPE7_Code,
Determining_Factor_Class7_Code,
DETERMINING_FACTOR_CQ7_Code,
OPERATOR7_Code,
NUMERIC_VALUE7,
DATE_VALUE7,
ALPHANUMERIC_VALUE7,
VALUE_LOW7,
VALUE_HIGH7,
DETERMINING_FACTOR_CODE8,
TAX_PARAMETER_CODE8,
DATA_TYPE8_Code,
Determining_Factor_Class8_Code,
DETERMINING_FACTOR_CQ8_Code,
OPERATOR8_Code,
NUMERIC_VALUE8,
DATE_VALUE8,
ALPHANUMERIC_VALUE8,
VALUE_LOW8,
VALUE_HIGH8,
DETERMINING_FACTOR_CODE9,
TAX_PARAMETER_CODE9,
DATA_TYPE9_Code,
Determining_Factor_Class9_Code,
DETERMINING_FACTOR_CQ9_Code,
OPERATOR9_Code,
NUMERIC_VALUE9,
DATE_VALUE9,
ALPHANUMERIC_VALUE9,
VALUE_LOW9,
VALUE_HIGH9,
CREATED_BY ,
CREATION_DATE ,
LAST_UPDATED_BY ,
LAST_UPDATE_DATE ,
LAST_UPDATE_LOGIN ,
REQUEST_ID ,
PROGRAM_APPLICATION_ID ,
PROGRAM_ID ,
PROGRAM_LOGIN_ID)
values ( X_DETERMINING_FACTOR_CODE10(i),
X_COUNTRY_CODE(i),
X_TAX_PARAMETER_CODE10(i),
X_DATA_TYPE10_Code(i),
X_Determining_Factor_Clas10_Co(i),
X_DETERMINING_FACTOR_CQ10_Code(i),
X_OPERATOR10_Code(i),
X_NUMERIC_VALUE10(i),
X_DATE_VALUE10(i),
X_ALPHANUMERIC_VALUE10(i),
X_VALUE_LOW10(i),
X_VALUE_HIGH10(i),
X_Record_Type_Code(i),
X_CONDITION_GROUP_ID(i),
X_CONDITION_GROUP_CODE(i),
X_DET_FACTOR_TEMPL_CODE(i),
X_APPLICATION_ID(i),
X_LEDGER_ID(i),
X_CHART_OF_ACCOUNTS_ID(i),
NVL(X_More_Than_Max_Cond_Flag(i),'N'),
NVL(X_Enabled_Flag(i),'N'),
X_DETERMINING_FACTOR_CODE1(i),
X_TAX_PARAMETER_CODE1(i),
X_DATA_TYPE1_Code(i),
X_DETERMINING_FACTOR_CLASS1_Co(i),
X_DETERMINING_FACTOR_CQ1_Code(i),
X_OPERATOR1_Code(i),
X_NUMERIC_VALUE1(i),
X_DATE_VALUE1(i),
X_ALPHANUMERIC_VALUE1(i),
X_VALUE_LOW1(i),
X_VALUE_HIGH1(i),
X_DETERMINING_FACTOR_CODE2(i),
X_TAX_PARAMETER_CODE2(i),
X_DATA_TYPE2_Code(i),
X_DETERMINING_FACTOR_CLASS2_Co(i),
X_DETERMINING_FACTOR_CQ2_Code(i),
X_OPERATOR2_Code(i),
X_NUMERIC_VALUE2(i),
X_DATE_VALUE2(i),
X_ALPHANUMERIC_VALUE2(i),
X_VALUE_LOW2(i),
X_VALUE_HIGH2(i),
X_DETERMINING_FACTOR_CODE3(i),
X_TAX_PARAMETER_CODE3(i),
X_DATA_TYPE3_Code(i),
X_DETERMINING_FACTOR_CLASS3_Co(i),
X_DETERMINING_FACTOR_CQ3_Code(i),
X_OPERATOR3_Code(i),
X_NUMERIC_VALUE3(i),
X_DATE_VALUE3(i),
X_ALPHANUMERIC_VALUE3(i),
X_VALUE_LOW3(i),
X_VALUE_HIGH3(i),
X_DETERMINING_FACTOR_CODE4(i),
X_TAX_PARAMETER_CODE4(i),
X_DATA_TYPE4_Code(i),
X_DETERMINING_FACTOR_CLASS4_Co(i),
X_DETERMINING_FACTOR_CQ4_Code(i),
X_OPERATOR4_Code(i),
X_NUMERIC_VALUE4(i),
X_DATE_VALUE4(i),
X_ALPHANUMERIC_VALUE4(i),
X_VALUE_LOW4(i),
X_VALUE_HIGH4(i),
X_DETERMINING_FACTOR_CODE5(i),
X_TAX_PARAMETER_CODE5(i),
X_data_Type5_Code(i),
X_DETERMINING_FACTOR_CLASS5_Co(i),
X_DETERMINING_FACTOR_CQ5_Code(i),
X_OPERATOR5_Code(i),
X_NUMERIC_VALUE5(i),
X_DATE_VALUE5(i),
X_ALPHANUMERIC_VALUE5(i),
X_VALUE_LOW5(i),
X_VALUE_HIGH5(i),
X_DETERMINING_FACTOR_CODE6(i),
X_TAX_PARAMETER_CODE6(i),
X_DATA_TYPE6_Code(i),
X_DETERMINING_FACTOR_CLASS6_Co(i),
X_DETERMINING_FACTOR_CQ6_Code(i),
X_OPERATOR6_Code(i),
X_NUMERIC_VALUE6(i),
X_DATE_VALUE6(i),
X_ALPHANUMERIC_VALUE6(i),
X_VALUE_LOW6(i),
X_VALUE_HIGH6(i),
X_DETERMINING_FACTOR_CODE7(i),
X_TAX_PARAMETER_CODE7(i),
X_DATA_TYPE7_Code(i),
X_DETERMINING_FACTOR_CLASS7_Co(i),
X_DETERMINING_FACTOR_CQ7_Code(i),
X_OPERATOR7_Code(i),
X_NUMERIC_VALUE7(i),
X_DATE_VALUE7(i),
X_ALPHANUMERIC_VALUE7(i),
X_VALUE_LOW7(i),
X_VALUE_HIGH7(i),
X_DETERMINING_FACTOR_CODE8(i),
X_TAX_PARAMETER_CODE8(i),
X_DATA_TYPE8_Code(i),
X_DETERMINING_FACTOR_CLASS8_Co(i),
X_DETERMINING_FACTOR_CQ8_Code(i),
X_OPERATOR8_Code(i),
X_NUMERIC_VALUE8(i),
X_DATE_VALUE8(i),
X_ALPHANUMERIC_VALUE8(i),
X_VALUE_LOW8(i),
X_VALUE_HIGH8(i),
X_DETERMINING_FACTOR_CODE9(i),
X_TAX_PARAMETER_CODE9(i),
X_DATA_TYPE9_Code(i),
X_DETERMINING_FACTOR_CLASS9_Co(i),
X_DETERMINING_FACTOR_CQ9_Code(i),
X_OPERATOR9_Code(i),
X_NUMERIC_VALUE9(i),
X_DATE_VALUE9(i),
X_ALPHANUMERIC_VALUE9(i),
X_VALUE_LOW9(i),
X_VALUE_HIGH9(i),
fnd_global.user_id ,
sysdate ,
fnd_global.user_id ,
sysdate ,
fnd_global.conc_login_id ,
fnd_global.conc_request_id ,
fnd_global.prog_appl_id ,
fnd_global.conc_program_id ,
fnd_global.conc_login_id
);
insert into ZX_CONDITION_GROUPS_TL (
CONDITION_GROUP_ID,
CONDITION_GROUP_NAME,
CONDITION_GROUP_DESC,
LANGUAGE,
SOURCE_LANG,
CREATED_BY ,
CREATION_DATE ,
LAST_UPDATED_BY ,
LAST_UPDATE_DATE ,
LAST_UPDATE_LOGIN)
select X_CONDITION_GROUP_ID(i),
X_CONDITION_GROUP_NAME(i),
X_CONDITION_GROUP_DESC(i),
L.LANGUAGE_CODE,
userenv('LANG'),
fnd_global.user_id ,
sysdate ,
fnd_global.user_id ,
sysdate ,
fnd_global.conc_login_id
from FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and not exists
(select NULL
from ZX_CONDITION_GROUPS_TL T
where T.CONDITION_GROUP_ID = X_CONDITION_GROUP_ID(i)
and T.LANGUAGE = L.LANGUAGE_CODE);
end bulk_insert_condition_groups; */