The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE add_select_clause_dsload_list(p_dimension_required IN VARCHAR2,
p_display_col_name IN VARCHAR2,
p_display_col_alias IN VARCHAR2,
p_table_alias IN VARCHAR2,
p_rownum IN OUT NOCOPY NUMBER,
p_xml_file_type IN VARCHAR2) IS
BEGIN
IF (p_dimension_required = 'Y') THEN
ad_ddl.build_statement(' '' ' || p_table_alias || '.' ||
p_display_col_name || ' ' ||
p_display_col_alias || ' , ''|| g_nl||',
p_rownum);
END add_select_clause_dsload_list;
PROCEDURE add_select_clause_to_list(p_dimension_required IN VARCHAR2,
p_display_col_name IN VARCHAR2,
p_table_alias IN VARCHAR2,
p_rownum IN OUT NOCOPY NUMBER,
p_xml_file_type IN VARCHAR2) IS
DecodeStatement varchar2(1000);
ELSIF (p_xml_file_type = 'NONPOSTED_SELECT' OR
p_xml_file_type = 'NONPOSTED_GROUP') THEN
DecodeStatement := 'decode (EXTENDED_ACCOUNT_TYPE,' ||
'''''REVENUE'''',455,' ||
'''''EXPENSE'''',457,100) ';
END add_select_clause_to_list;
PROCEDURE build_select_clause_list(p_rownum IN OUT NOCOPY NUMBER,
p_xml_file_type IN VARCHAR2) IS
l_dim_info gcs_utility_pkg.t_hash_gcs_dimension_info := gcs_utility_pkg.g_gcs_dimension_info;
add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'),
'CHANNEL_DISPLAY_CODE',
'channel_name',
'gbit',
p_rownum,
p_xml_file_type);
add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'),
'CUSTOMER_DISPLAY_CODE',
'customer_name',
'gbit',
p_rownum,
p_xml_file_type);
add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'),
'FINANCIAL_ELEM_DISPLAY_CODE',
'financial_elem_name',
'gbit',
p_rownum,
p_xml_file_type);
add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'),
'NATURAL_ACCOUNT_DISPLAY_CODE',
'natural_account_name',
'gbit',
p_rownum,
p_xml_file_type);
add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'),
'PRODUCT_DISPLAY_CODE',
'product_name',
'gbit',
p_rownum,
p_xml_file_type);
add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'),
'PROJECT_DISPLAY_CODE',
'project_name',
'gbit',
p_rownum,
p_xml_file_type);
add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'),
'TASK_DISPLAY_CODE',
'task_name',
'gbit',
p_rownum,
p_xml_file_type);
add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'),
'USER_DIM1_DISPLAY_CODE',
'user_dim1_name',
'gbit',
p_rownum,
p_xml_file_type);
add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'),
'USER_DIM2_DISPLAY_CODE',
'user_dim2_name',
'gbit',
p_rownum,
p_xml_file_type);
add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'),
'USER_DIM3_DISPLAY_CODE',
'user_dim3_name',
'gbit',
p_rownum,
p_xml_file_type);
add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'),
'USER_DIM4_DISPLAY_CODE',
'user_dim4_name',
'gbit',
p_rownum,
p_xml_file_type);
add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'),
'USER_DIM5_DISPLAY_CODE',
'user_dim5_name',
'gbit',
p_rownum,
p_xml_file_type);
add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'),
'USER_DIM6_DISPLAY_CODE',
'user_dim6_name',
'gbit',
p_rownum,
p_xml_file_type);
add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'),
'USER_DIM7_DISPLAY_CODE',
'user_dim7_name',
'gbit',
p_rownum,
p_xml_file_type);
add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'),
'USER_DIM8_DISPLAY_CODE',
'user_dim8_name',
'gbit',
p_rownum,
p_xml_file_type);
add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'),
'USER_DIM9_DISPLAY_CODE',
'user_dim9_name',
'gbit',
p_rownum,
p_xml_file_type);
add_select_clause_dsload_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),
'USER_DIM10_DISPLAY_CODE',
'user_dim10_name',
'gbit',
p_rownum,
p_xml_file_type);
ELSIF (p_xml_file_type = 'NONPOSTED_SELECT' OR
p_xml_file_type = 'NONPOSTED_GROUP' OR p_xml_file_type = 'DSTB' OR
p_xml_file_type = 'DSTB_XML' /*OR p_xml_file_type = 'DSTB_XML_ID'*/) THEN --fix 5351083
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'),
'channel_name',
'fchb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'),
'customer_name',
'fcb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'),
'financial_elem_name',
'ffeb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'),
'natural_account_name',
'fnab',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'),
'product_name',
'fpb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'),
'project_name',
'fpjb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'),
'task_name',
'ftb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'),
'user_dim1_name',
'fud1',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'),
'user_dim2_name',
'fud2',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'),
'user_dim3_name',
'fud3',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'),
'user_dim4_name',
'fud4',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'),
'user_dim5_name',
'fud5',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'),
'user_dim6_name',
'fud6',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'),
'user_dim7_name',
'fud7',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'),
'user_dim8_name',
'fud8',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'),
'user_dim9_name',
'fud9',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),
'user_dim10_name',
'fud10',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('LINE_ITEM_ID'),
'line_item_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'),
'channel_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'),
'customer_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('FINANCIAL_ELEM_ID'),
'financial_elem_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'),
'natural_account_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'),
'product_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'),
'project_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'),
'task_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'),
'user_dim1_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'),
'user_dim2_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'),
'user_dim3_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'),
'user_dim4_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'),
'user_dim5_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'),
'user_dim6_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'),
'user_dim7_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'),
'user_dim8_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'),
'user_dim9_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),
'user_dim10_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('LINE_ITEM_ID'),
'line_item_id',
'gel',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('CHANNEL_ID'),
'channel_id',
'gel',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('CUSTOMER_ID'),
'customer_id',
'gel',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('COMPANY_COST_CENTER_ORG_ID'),
'company_cost_center_org_id',
'gel',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID'),
'natural_account_id',
'gel',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('PRODUCT_ID'),
'product_id',
'gel',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('PROJECT_ID'),
'project_id',
'gel',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('TASK_ID'),
'task_id',
'gel',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM1_ID'),
'user_dim1_id',
'gel',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM2_ID'),
'user_dim2_id',
'gel',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM3_ID'),
'user_dim3_id',
'gel',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM4_ID'),
'user_dim4_id',
'gel',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM5_ID'),
'user_dim5_id',
'gel',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM6_ID'),
'user_dim6_id',
'gel',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM7_ID'),
'user_dim7_id',
'gel',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM8_ID'),
'user_dim8_id',
'gel',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM9_ID'),
'user_dim9_id',
'gel',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM10_ID'),
'user_dim10_id',
'gel',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('COMPANY_COST_CENTER_ORG_ID'),
'company_cost_center_org_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('LINE_ITEM_ID'),
'line_item_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'),
'channel_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'),
'customer_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('NATURAL_ACCOUNT_ID'),
'natural_account_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'),
'product_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'),
'project_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'),
'task_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM1_ID'),
'user_dim1_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM2_ID'),
'user_dim2_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM3_ID'),
'user_dim3_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM4_ID'),
'user_dim4_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM5_ID'),
'user_dim5_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM6_ID'),
'user_dim6_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM7_ID'),
'user_dim7_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID'),
'user_dim8_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID'),
'user_dim9_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID'),
'user_dim10_id',
'fb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('CHANNEL_ID'),
'channel_name',
'fchb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('CUSTOMER_ID'),
'customer_name',
'fcb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('FINANCIAL_ELEM_ID'),
'financial_elem_name',
'ffeb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID'),
'natural_account_name',
'fnab',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('PRODUCT_ID'),
'product_name',
'fpb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('PROJECT_ID'),
'project_name',
'fpjb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('TASK_ID'),
'task_name',
'ftb',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM1_ID'),
'user_dim1_name',
'fud1',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM2_ID'),
'user_dim2_name',
'fud2',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM3_ID'),
'user_dim3_name',
'fud3',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM4_ID'),
'user_dim4_name',
'fud4',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM5_ID'),
'user_dim5_name',
'fud5',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM6_ID'),
'user_dim6_name',
'fud6',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM7_ID'),
'user_dim7_name',
'fud7',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM8_ID'),
'user_dim8_name',
'fud8',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM9_ID'),
'user_dim9_name',
'fud9',
p_rownum,
p_xml_file_type);
add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM10_ID'),
'user_dim10_name',
'fud10',
p_rownum,
p_xml_file_type);
END build_select_clause_list;
ad_ddl.build_statement(' g_gcs_dims_select_list VARCHAR2(2000) := ',
r);
build_select_clause_list(r, 'ENTRY');
build_select_clause_list(r, 'ENTRY_XML');
build_select_clause_list(r, 'VSMPID');
ad_ddl.build_statement(' g_fem_dims_select_list_dsload VARCHAR2(2000) := ',
r);
build_select_clause_list(r, 'DSLOAD');
ad_ddl.build_statement(' g_fem_dims_select_list_dstb VARCHAR2(2000) := ',
r);
build_select_clause_list(r, 'DSTB');
build_select_clause_list(r, 'DSTB_XML');
ad_ddl.build_statement(' g_fem_nonposted_select_stmnt VARCHAR2(5000) := ',
r);
build_select_clause_list(r, 'NONPOSTED_SELECT');
build_select_clause_list(r, 'NONPOSTED_GROUP');