DBA Data[Home] [Help]

APPS.GCS_XML_DYNAMIC_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 468

  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);
Line: 482

  END add_select_clause_dsload_list;
Line: 483

  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);
Line: 567

      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) ';
Line: 601

  END add_select_clause_to_list;
Line: 654

  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;
Line: 661

      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);
Line: 667

      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);
Line: 674

      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);
Line: 681

      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);
Line: 687

      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);
Line: 693

      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);
Line: 699

      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);
Line: 706

        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);
Line: 714

        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);
Line: 722

        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);
Line: 730

        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);
Line: 738

        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);
Line: 746

        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);
Line: 754

        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);
Line: 762

        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);
Line: 770

        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);
Line: 778

        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);
Line: 785

    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);
Line: 793

      add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'),
                                'customer_name',
                                'fcb',
                                p_rownum,
                                p_xml_file_type);
Line: 800

      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);
Line: 806

      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);
Line: 811

      add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'),
                                'product_name',
                                'fpb',
                                p_rownum,
                                p_xml_file_type);
Line: 816

      add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'),
                                'project_name',
                                'fpjb',
                                p_rownum,
                                p_xml_file_type);
Line: 821

      add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'),
                                'task_name',
                                'ftb',
                                p_rownum,
                                p_xml_file_type);
Line: 827

        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);
Line: 834

        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);
Line: 841

        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);
Line: 848

        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);
Line: 855

        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);
Line: 862

        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);
Line: 869

        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);
Line: 876

        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);
Line: 883

        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);
Line: 890

        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);
Line: 897

      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);
Line: 902

      add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'),
                                'channel_id',
                                'fb',
                                p_rownum,
                                p_xml_file_type);
Line: 907

      add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'),
                                'customer_id',
                                'fb',
                                p_rownum,
                                p_xml_file_type);
Line: 913

      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);
Line: 919

      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);
Line: 924

      add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'),
                                'product_id',
                                'fb',
                                p_rownum,
                                p_xml_file_type);
Line: 929

      add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'),
                                'project_id',
                                'fb',
                                p_rownum,
                                p_xml_file_type);
Line: 934

      add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'),
                                'task_id',
                                'fb',
                                p_rownum,
                                p_xml_file_type);
Line: 940

        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);
Line: 947

        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);
Line: 954

        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);
Line: 961

        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);
Line: 968

        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);
Line: 975

        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);
Line: 982

        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);
Line: 989

        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);
Line: 996

        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);
Line: 1003

        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);
Line: 1010

      add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('LINE_ITEM_ID'),
                                'line_item_id',
                                'gel',
                                p_rownum,
                                p_xml_file_type);
Line: 1015

      add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('CHANNEL_ID'),
                                'channel_id',
                                'gel',
                                p_rownum,
                                p_xml_file_type);
Line: 1020

      add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('CUSTOMER_ID'),
                                'customer_id',
                                'gel',
                                p_rownum,
                                p_xml_file_type);
Line: 1025

      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);
Line: 1030

      add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID'),
                                'natural_account_id',
                                'gel',
                                p_rownum,
                                p_xml_file_type);
Line: 1035

      add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('PRODUCT_ID'),
                                'product_id',
                                'gel',
                                p_rownum,
                                p_xml_file_type);
Line: 1040

      add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('PROJECT_ID'),
                                'project_id',
                                'gel',
                                p_rownum,
                                p_xml_file_type);
Line: 1045

      add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('TASK_ID'),
                                'task_id',
                                'gel',
                                p_rownum,
                                p_xml_file_type);
Line: 1051

        add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM1_ID'),
                                  'user_dim1_id',
                                  'gel',
                                  p_rownum,
                                  p_xml_file_type);
Line: 1058

        add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM2_ID'),
                                  'user_dim2_id',
                                  'gel',
                                  p_rownum,
                                  p_xml_file_type);
Line: 1065

        add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM3_ID'),
                                  'user_dim3_id',
                                  'gel',
                                  p_rownum,
                                  p_xml_file_type);
Line: 1072

        add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM4_ID'),
                                  'user_dim4_id',
                                  'gel',
                                  p_rownum,
                                  p_xml_file_type);
Line: 1079

        add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM5_ID'),
                                  'user_dim5_id',
                                  'gel',
                                  p_rownum,
                                  p_xml_file_type);
Line: 1086

        add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM6_ID'),
                                  'user_dim6_id',
                                  'gel',
                                  p_rownum,
                                  p_xml_file_type);
Line: 1093

        add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM7_ID'),
                                  'user_dim7_id',
                                  'gel',
                                  p_rownum,
                                  p_xml_file_type);
Line: 1100

        add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM8_ID'),
                                  'user_dim8_id',
                                  'gel',
                                  p_rownum,
                                  p_xml_file_type);
Line: 1107

        add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM9_ID'),
                                  'user_dim9_id',
                                  'gel',
                                  p_rownum,
                                  p_xml_file_type);
Line: 1114

        add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM10_ID'),
                                  'user_dim10_id',
                                  'gel',
                                  p_rownum,
                                  p_xml_file_type);
Line: 1121

      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);
Line: 1126

      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);
Line: 1131

      add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CHANNEL_ID'),
                                'channel_id',
                                'fb',
                                p_rownum,
                                p_xml_file_type);
Line: 1136

      add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('CUSTOMER_ID'),
                                'customer_id',
                                'fb',
                                p_rownum,
                                p_xml_file_type);
Line: 1141

      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);
Line: 1146

      add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PRODUCT_ID'),
                                'product_id',
                                'fb',
                                p_rownum,
                                p_xml_file_type);
Line: 1151

      add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('PROJECT_ID'),
                                'project_id',
                                'fb',
                                p_rownum,
                                p_xml_file_type);
Line: 1156

      add_select_clause_to_list(gcs_utility_pkg.get_fem_dim_required('TASK_ID'),
                                'task_id',
                                'fb',
                                p_rownum,
                                p_xml_file_type);
Line: 1162

        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);
Line: 1169

        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);
Line: 1176

        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);
Line: 1183

        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);
Line: 1190

        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);
Line: 1197

        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);
Line: 1204

        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);
Line: 1211

        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);
Line: 1218

        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);
Line: 1225

        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);
Line: 1232

      add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('CHANNEL_ID'),
                                'channel_name',
                                'fchb',
                                p_rownum,
                                p_xml_file_type);
Line: 1237

      add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('CUSTOMER_ID'),
                                'customer_name',
                                'fcb',
                                p_rownum,
                                p_xml_file_type);
Line: 1242

      add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('FINANCIAL_ELEM_ID'),
                                'financial_elem_name',
                                'ffeb',
                                p_rownum,
                                p_xml_file_type);
Line: 1247

      add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID'),
                                'natural_account_name',
                                'fnab',
                                p_rownum,
                                p_xml_file_type);
Line: 1252

      add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('PRODUCT_ID'),
                                'product_name',
                                'fpb',
                                p_rownum,
                                p_xml_file_type);
Line: 1257

      add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('PROJECT_ID'),
                                'project_name',
                                'fpjb',
                                p_rownum,
                                p_xml_file_type);
Line: 1262

      add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('TASK_ID'),
                                'task_name',
                                'ftb',
                                p_rownum,
                                p_xml_file_type);
Line: 1268

        add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM1_ID'),
                                  'user_dim1_name',
                                  'fud1',
                                  p_rownum,
                                  p_xml_file_type);
Line: 1275

        add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM2_ID'),
                                  'user_dim2_name',
                                  'fud2',
                                  p_rownum,
                                  p_xml_file_type);
Line: 1282

        add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM3_ID'),
                                  'user_dim3_name',
                                  'fud3',
                                  p_rownum,
                                  p_xml_file_type);
Line: 1289

        add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM4_ID'),
                                  'user_dim4_name',
                                  'fud4',
                                  p_rownum,
                                  p_xml_file_type);
Line: 1296

        add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM5_ID'),
                                  'user_dim5_name',
                                  'fud5',
                                  p_rownum,
                                  p_xml_file_type);
Line: 1303

        add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM6_ID'),
                                  'user_dim6_name',
                                  'fud6',
                                  p_rownum,
                                  p_xml_file_type);
Line: 1310

        add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM7_ID'),
                                  'user_dim7_name',
                                  'fud7',
                                  p_rownum,
                                  p_xml_file_type);
Line: 1317

        add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM8_ID'),
                                  'user_dim8_name',
                                  'fud8',
                                  p_rownum,
                                  p_xml_file_type);
Line: 1324

        add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM9_ID'),
                                  'user_dim9_name',
                                  'fud9',
                                  p_rownum,
                                  p_xml_file_type);
Line: 1331

        add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM10_ID'),
                                  'user_dim10_name',
                                  'fud10',
                                  p_rownum,
                                  p_xml_file_type);
Line: 1338

  END build_select_clause_list;
Line: 2073

    ad_ddl.build_statement('  g_gcs_dims_select_list VARCHAR2(2000) := ',
                           r);
Line: 2076

    build_select_clause_list(r, 'ENTRY');
Line: 2098

    build_select_clause_list(r, 'ENTRY_XML');
Line: 2105

    build_select_clause_list(r, 'VSMPID');
Line: 2111

    ad_ddl.build_statement('  g_fem_dims_select_list_dsload VARCHAR2(2000) := ',
                           r);
Line: 2114

    build_select_clause_list(r, 'DSLOAD');
Line: 2119

    ad_ddl.build_statement('  g_fem_dims_select_list_dstb VARCHAR2(2000) := ',
                           r);
Line: 2122

    build_select_clause_list(r, 'DSTB');
Line: 2161

    build_select_clause_list(r, 'DSTB_XML');
Line: 2179

    ad_ddl.build_statement('  g_fem_nonposted_select_stmnt VARCHAR2(5000) := ',
                           r);
Line: 2182

    build_select_clause_list(r, 'NONPOSTED_SELECT');
Line: 2191

    build_select_clause_list(r, 'NONPOSTED_GROUP');