DBA Data[Home] [Help]

APPS.GCS_RP_UTIL_BUILD_PKG SQL Statements

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

Line: 7

  PROCEDURE add_insert_clause_to_list  ( p_dimension_required   IN VARCHAR2,
                                         p_prefix               IN VARCHAR2,
                                         p_rownum               IN OUT NOCOPY NUMBER,
                                         p_column_name          IN VARCHAR2)
  IS
  BEGIN
    IF (p_dimension_required = 'Y') THEN
       ad_ddl.build_statement('           ' || p_prefix || p_column_name || ',     ', p_rownum); p_rownum:=p_rownum+1;
Line: 16

  END add_insert_clause_to_list;
Line: 18

  PROCEDURE build_insert_clause_list (p_rownum   	IN OUT NOCOPY NUMBER,
                                      p_prefix          IN VARCHAR2)
  IS
  l_dim_info gcs_utility_pkg.t_hash_gcs_dimension_info := gcs_utility_pkg.g_gcs_dimension_info;
Line: 24

      add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('CHANNEL_ID'),
                                p_prefix,
                                p_rownum,
				'channel_id');
Line: 29

      add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('CUSTOMER_ID'),
                                p_prefix,
                                p_rownum,
				'customer_id');
Line: 34

      add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('FINANCIAL_ELEM_ID'),
                                p_prefix,
                                p_rownum,
                                'financial_elem_id');
Line: 39

      add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('LINE_ITEM_ID'),
                                p_prefix,
                                p_rownum,
                                'line_item_id');
Line: 44

      add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID'),
                                p_prefix,
                                p_rownum,
				'natural_account_id');
Line: 49

      add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('PRODUCT_ID'),
                                p_prefix,
                                p_rownum,
				'product_id');
Line: 54

      add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('PROJECT_ID'),
                                p_prefix,
                                p_rownum,
				'project_id');
Line: 59

      add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('TASK_ID'),
                                p_prefix,
                                p_rownum,
				'task_id');
Line: 65

        add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM10_ID'),
                                  p_prefix,
                                  p_rownum,
				  'user_dim10_id');
Line: 72

        add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM1_ID'),
                                  p_prefix,
                                  p_rownum,
                                  'user_dim1_id');
Line: 79

        add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM2_ID'),
                                  p_prefix,
                                  p_rownum,
                                  'user_dim2_id');
Line: 86

        add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM3_ID'),
                                  p_prefix,
                                  p_rownum,
                                  'user_dim3_id');
Line: 93

        add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM4_ID'),
                                  p_prefix,
                                  p_rownum,
                                  'user_dim4_id');
Line: 100

        add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM5_ID'),
                                  p_prefix,
                                  p_rownum,
                                  'user_dim5_id');
Line: 107

        add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM6_ID'),
                                  p_prefix,
                                  p_rownum,
                                  'user_dim6_id');
Line: 114

        add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM7_ID'),
                                  p_prefix,
                                  p_rownum,
                                  'user_dim7_id');
Line: 121

        add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM8_ID'),
                                  p_prefix,
                                  p_rownum,
                                  'user_dim8_id');
Line: 128

        add_insert_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM9_ID'),
                                  p_prefix,
                                  p_rownum,
                                  'user_dim9_id');
Line: 134

  END build_insert_clause_list;
Line: 136

  PROCEDURE add_select_clause_to_list  ( p_dimension_required   IN VARCHAR2,
					 p_table_alias		IN VARCHAR2,
                                         p_rownum               IN OUT NOCOPY NUMBER,
					 p_column_name          IN VARCHAR2)
  IS
  BEGIN
    IF (p_dimension_required = 'Y') THEN
       ad_ddl.build_statement(' , ' || p_table_alias || p_column_name, p_rownum); p_rownum := p_rownum +1;
Line: 145

  END add_select_clause_to_list;
Line: 147

  PROCEDURE build_select_clause_list (p_rownum   	IN OUT NOCOPY NUMBER,
				      p_table_alias	IN VARCHAR2)
  IS
  l_dim_info gcs_utility_pkg.t_hash_gcs_dimension_info := gcs_utility_pkg.g_gcs_dimension_info;
Line: 153

      add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('CHANNEL_ID'),
                                p_table_alias,
                                p_rownum,
				'channel_id');
Line: 158

      add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('CUSTOMER_ID'),
                                p_table_alias,
                                p_rownum,
				'customer_id');
Line: 163

      add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('FINANCIAL_ELEM_ID'),
                                p_table_alias,
                                p_rownum,
                                'financial_elem_id');
Line: 168

      add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('LINE_ITEM_ID'),
                                p_table_alias,
                                p_rownum,
                                'line_item_id');
Line: 173

      add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('NATURAL_ACCOUNT_ID'),
				p_table_alias,
                                p_rownum,
				'natural_account_id');
Line: 178

      add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('PRODUCT_ID'),
                                p_table_alias,
                                p_rownum,
				'product_id');
Line: 183

      add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('PROJECT_ID'),
                                p_table_alias,
                                p_rownum,
				'project_id');
Line: 188

      add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('TASK_ID'),
				p_table_alias,
                                p_rownum,
				'task_id');
Line: 194

        add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM10_ID'),
                                  p_table_alias,
                                  p_rownum,
				  'user_dim10_id');
Line: 201

        add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM1_ID'),
                                  p_table_alias,
                                  p_rownum,
                                  'user_dim1_id');
Line: 208

        add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM2_ID'),
                                  p_table_alias,
                                  p_rownum,
                                  'user_dim2_id');
Line: 215

        add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM3_ID'),
                                  p_table_alias,
                                  p_rownum,
                                  'user_dim3_id');
Line: 222

        add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM4_ID'),
                                  p_table_alias,
                                  p_rownum,
                                  'user_dim4_id');
Line: 229

        add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM5_ID'),
                                  p_table_alias,
                                  p_rownum,
                                  'user_dim5_id');
Line: 236

        add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM6_ID'),
                                  p_table_alias,
                                  p_rownum,
                                  'user_dim6_id');
Line: 243

        add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM7_ID'),
                                  p_table_alias,
                                  p_rownum,
                                  'user_dim7_id');
Line: 250

        add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM8_ID'),
                                  p_table_alias,
                                  p_rownum,
                                  'user_dim8_id');
Line: 257

        add_select_clause_to_list(gcs_utility_pkg.get_dimension_required('USER_DIM9_ID'),
                                  p_table_alias,
                                  p_rownum,
                                  'user_dim9_id');
Line: 263

  END build_select_clause_list;
Line: 441

    build_select_clause_list(r,'b.');
Line: 445

    build_select_clause_list(r,'src_');
Line: 449

    build_select_clause_list(r,'tgt_');
Line: 453

    build_select_clause_list(r, 'off_');
Line: 456

    ad_ddl.build_statement('  g_core_insert_stmt VARCHAR2(2000) := ', r); r:=r+1;
Line: 457

    ad_ddl.build_statement('  ''INSERT INTO gcs_entries_gt(   ', r); r:=r+1;
Line: 480

    ad_ddl.build_statement('  ''SELECT :rid                              , ', r); r:=r+1;
Line: 527

    ad_ddl.build_statement('  --   Generated SQL statement to insert data into gcs_entry_lines from gcs_entries_gt   ', r); r:=r+1;
Line: 531

    ad_ddl.build_statement('  -- p_row_count: #of rows inserted                                                      ', r); r:=r+1;
Line: 566

    ad_ddl.build_statement('  --   Generated SQL statement to insert data into gcs_entry_lines from gcs_entries_gt   ', r); r:=r+1;
Line: 570

    ad_ddl.build_statement('  -- p_row_count: #of rows inserted                                                      ', r); r:=r+1;
Line: 584

    ad_ddl.build_statement('      select ''N''                                                                       ', r); r:=r+1;
Line: 593

    ad_ddl.build_statement('    insert into gcs_entry_lines                                                          ', r); r:=r+1;
Line: 596

    build_insert_clause_list(p_rownum          => r,
                             p_prefix          => null);
Line: 604

    ad_ddl.build_statement('           last_updated_by,                                                              ', r); r:=r+1;
Line: 605

    ad_ddl.build_statement('           last_update_date,                                                             ', r); r:=r+1;
Line: 606

    ad_ddl.build_statement('           last_update_login                                                             ', r); r:=r+1;
Line: 608

    ad_ddl.build_statement('    SELECT p_entry_id,                                                                   ', r); r:=r+1;
Line: 610

    build_insert_clause_list(p_rownum          => r,
                             p_prefix          => 'geg.tgt_');
Line: 625

    build_group_by_clause(r,'geg.tgt_', 'insertassignment');
Line: 628

    ad_ddl.build_statement('    --check number of rows inserted                                                      ', r); r:=r+1;
Line: 631

    ad_ddl.build_statement('    --insert rows if the offset flag was used                                            ', r); r:=r+1;
Line: 633

    ad_ddl.build_statement('      insert into gcs_entry_lines                                                        ', r); r:=r+1;
Line: 636

    build_insert_clause_list(p_rownum          => r,
                             p_prefix          => null);
Line: 644

    ad_ddl.build_statement('             last_updated_by,                                                            ', r); r:=r+1;
Line: 645

    ad_ddl.build_statement('             last_update_date,                                                           ', r); r:=r+1;
Line: 646

    ad_ddl.build_statement('             last_update_login                                                           ', r); r:=r+1;
Line: 648

    ad_ddl.build_statement('      SELECT p_entry_id,                                                                 ', r); r:=r+1;
Line: 650

    build_insert_clause_list(p_rownum          => r,
                             p_prefix          => 'geg.off_');
Line: 665

    build_group_by_clause(r,'geg.off_', 'insertassignment');
Line: 669

    ad_ddl.build_statement('    insert into gcs_entry_lines                                                          ', r); r:=r+1;
Line: 672

    build_insert_clause_list(p_rownum          => r,
                             p_prefix          => null);
Line: 680

    ad_ddl.build_statement('           last_updated_by,                                                              ', r); r:=r+1;
Line: 681

    ad_ddl.build_statement('           last_update_date,                                                             ', r); r:=r+1;
Line: 682

    ad_ddl.build_statement('           last_update_login                                                             ', r); r:=r+1;
Line: 684

    ad_ddl.build_statement('    SELECT p_entry_id,                                                                   ', r); r:=r+1;
Line: 686

    build_insert_clause_list(p_rownum          => r,
                             p_prefix          => 'geg.tgt_');
Line: 701

    build_group_by_clause(r,'geg.tgt_', 'insertassignment');
Line: 704

    ad_ddl.build_statement('    --check number of rows inserted                                                      ', r); r:=r+1;
Line: 707

    ad_ddl.build_statement('    --insert rows if the offset flag was used                                            ', r); r:=r+1;
Line: 709

    ad_ddl.build_statement('      insert into gcs_entry_lines                                                        ', r); r:=r+1;
Line: 712

    build_insert_clause_list(p_rownum          => r,
                             p_prefix          => null);
Line: 720

    ad_ddl.build_statement('             last_updated_by,                                                            ', r); r:=r+1;
Line: 721

    ad_ddl.build_statement('             last_update_date,                                                           ', r); r:=r+1;
Line: 722

    ad_ddl.build_statement('             last_update_login                                                           ', r); r:=r+1;
Line: 724

    ad_ddl.build_statement('      SELECT p_entry_id,                                                                 ', r); r:=r+1;
Line: 726

    build_insert_clause_list(p_rownum          => r,
                             p_prefix          => 'geg.off_');
Line: 741

    build_group_by_clause(r,'geg.off_', 'insertassignment');