APPS.OKI_LOAD_RBK_PVT SQL Statements

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

Line: 48

    SELECT rowid
    FROM   oki_rnwl_bookings rbk
    WHERE  rbk.summary_build_date    = p_summary_build_date
    AND    rbk.authoring_org_id      = p_authoring_org_id
    AND    rbk.customer_party_id     = p_customer_party_id
    AND    rbk.scs_code              = p_scs_code
    AND    rbk.measure_code          = p_measure_code
    ;

Line: 90

    INSERT INTO oki_rnwl_bookings
    (
             summary_build_date
           , authoring_org_id
           , organization_name
           , customer_party_id
           , customer_name
           , scs_code
           , measure_code
           , measure_code_meaning
           , bin_code_seq
           , curr_base_contract_amount
           , prev_base_contract_amount
           , request_id
           , program_application_id
           , program_id
           , program_update_date )
    VALUES (
             p_summary_build_date
           , p_authoring_org_id
           , p_organization_name
           , p_customer_party_id
           , p_customer_name
           , p_scs_code
           , p_measure_code
           , p_measure_code_meaning
           , p_bin_code_seq
           , p_curr_base_contract_amount
           , p_prev_base_contract_amount
           , oki_load_rbk_pvt.g_request_id
           , oki_load_rbk_pvt.g_program_application_id
           , oki_load_rbk_pvt.g_program_id
           , oki_load_rbk_pvt.g_program_update_date ) ;

Line: 173

    UPDATE oki_rnwl_bookings SET
        curr_base_contract_amount = p_curr_base_contract_amount
      , prev_base_contract_amount = p_prev_base_contract_amount
      , measure_code_meaning      = p_measure_code_meaning
      , bin_code_seq              = p_bin_code_seq
      , organization_name         = p_organization_name
      , customer_name             = p_customer_name
      , request_id                = oki_load_rbk_pvt.g_request_id
      , program_application_id    = oki_load_rbk_pvt.g_program_application_id
      , program_id                = oki_load_rbk_pvt.g_program_id
      , program_update_date       = oki_load_rbk_pvt.g_program_update_date
    WHERE ROWID =  p_rbk_rowid ;

Line: 271

    SELECT NVL(SUM(base_contract_amount), 0) value
         , COUNT(shd.chr_id) contract_count
    FROM   oki_sales_k_hdrs shd
    WHERE  shd.is_new_yn         IS NULL
    AND    (   shd.date_canceled IS NULL
            OR shd.date_canceled >= p_qtr_start_date )
    AND    (   shd.date_signed   IS NULL
            OR shd.date_signed   >= p_qtr_start_date )
    AND    shd.start_date         < p_qtr_start_date
    AND    shd.base_contract_amount BETWEEN 0
                                        AND oki_utl_pub.g_contract_limit
    AND    shd.authoring_org_id = p_authoring_org_id
    ;

Line: 294

    SELECT NVL(SUM(base_contract_amount), 0) value
       , COUNT(shd.chr_id) contract_count
    FROM   oki_sales_k_hdrs shd
    WHERE  shd.is_new_yn     IS NULL
    AND    shd.date_signed   IS NOT NULL
    AND    shd.date_approved IS NOT NULL
    AND    shd.start_date     < p_qtr_start_date
    AND    GREATEST(shd.date_signed, shd.date_approved )
               BETWEEN p_qtr_start_date AND p_summary_build_date
    AND    shd.base_contract_amount BETWEEN 0
                                        AND oki_utl_pub.g_contract_limit
    AND    shd.authoring_org_id = p_authoring_org_id
    ;

Line: 317

    SELECT NVL(SUM(base_contract_amount), 0) value
         , COUNT(shd.chr_id) contract_count
    FROM   oki_sales_k_hdrs shd
    WHERE  shd.is_new_yn       IS NULL
    AND    shd.date_signed     IS NOT NULL
    AND    shd.start_date BETWEEN p_qtr_start_date AND p_qtr_end_date
    AND    GREATEST(shd.date_signed, shd.date_approved) <= p_qtr_end_date
    AND    shd.base_contract_amount BETWEEN 0
                                       AND oki_utl_pub.g_contract_limit
    AND    shd.authoring_org_id = p_authoring_org_id
    ;

Line: 338

    SELECT NVL(SUM(base_contract_amount), 0) value
         , COUNT(shd.chr_id) contract_count
    FROM   oki_sales_k_hdrs shd
    WHERE  shd.date_signed   <= p_summary_build_date
    AND    shd.date_approved <= p_summary_build_date
    AND    shd.is_new_yn      = 'Y'
    AND    shd.start_date BETWEEN p_qtr_start_date
                               AND p_summary_build_date
    AND    (   shd.date_terminated IS NULL
            OR shd.date_terminated  > p_summary_build_date )
    AND    shd.base_contract_amount BETWEEN 0
                                        AND oki_utl_pub.g_contract_limit
    AND    shd.authoring_org_id = p_authoring_org_id
    ;

Line: 362

    SELECT NVL(SUM(base_contract_amount), 0)  value
         , COUNT(shd.chr_id) contract_count
    FROM   oki_sales_k_hdrs shd
    WHERE  date_terminated  BETWEEN p_qtr_start_date
                                AND p_summary_build_date
    AND    shd.date_signed   IS NOT NULL
    AND    shd.date_approved IS NOT NULL
    AND    shd.base_contract_amount BETWEEN 0
                                        AND oki_utl_pub.g_contract_limit
    AND    shd.authoring_org_id = p_authoring_org_id
  ;

Line: 429

      l_loc := 'Inserting / updating ' || l_measure_type || '.' ;

Line: 439

        l_loc := 'Insert the new record --  ' || l_measure_type || '.' ;

Line: 459

        l_loc := 'Update the record -- ' || l_measure_type || '.' ;

Line: 526

      l_loc := 'Inserting / updating ' || l_measure_type || '.' ;

Line: 536

        l_loc := 'Insert the new record --  ' || l_measure_type || '.' ;

Line: 556

        l_loc := 'Update the record -- ' || l_measure_type || '.' ;

Line: 617

      l_loc := 'Inserting / updating ' || l_measure_type || '.' ;

Line: 625

        l_loc := 'Insert the new record --  ' || l_measure_type || '.' ;

Line: 645

        l_loc := 'Update the record -- ' || l_measure_type || '.' ;

Line: 687

      l_loc := 'Inserting / updating ' || l_measure_type || '.' ;

Line: 695

        l_loc := 'Insert the new record --  ' || l_measure_type || '.' ;

Line: 715

        l_loc := 'Update the record -- ' || l_measure_type || '.' ;

Line: 778

      l_loc := 'Inserting / updating ' || l_measure_type || '.' ;

Line: 786

        l_loc := 'Insert the new record --  ' || l_measure_type || '.' ;

Line: 806

        l_loc := 'Update the record -- ' || l_measure_type || '.' ;

Line: 869

      l_loc := 'Inserting / updating ' || l_measure_type || '.' ;

Line: 877

        l_loc := 'Insert the new record --  ' || l_measure_type || '.' ;

Line: 897

        l_loc := 'Update the record -- ' || l_measure_type || '.' ;

Line: 960

      l_loc := 'Inserting / updating ' || l_measure_type || '.' ;

Line: 968

        l_loc := 'Insert the new record --  ' || l_measure_type || '.' ;

Line: 988

        l_loc := 'Update the record -- ' || l_measure_type || '.' ;

Line: 1051

      l_loc := 'Inserting / updating ' || l_measure_type || '.' ;

Line: 1059

        l_loc := 'Insert the new record --  ' || l_measure_type || '.' ;

Line: 1079

        l_loc := 'Update the record -- ' || l_measure_type || '.' ;

Line: 1130

      l_loc := 'Inserting / updating ' || l_measure_type || '.' ;

Line: 1138

        l_loc := 'Insert the new record --  ' || l_measure_type || '.' ;

Line: 1158

        l_loc := 'Update the record -- ' || l_measure_type || '.' ;

Line: 1298

    SELECT NVL(SUM(base_contract_amount), 0) value
         , COUNT(shd.chr_id) contract_count
    FROM   oki_sales_k_hdrs shd
    WHERE  shd.is_new_yn         IS NULL
    AND    (   shd.date_canceled IS NULL
            OR shd.date_canceled >= p_qtr_start_date )
    AND    (   shd.date_signed   IS NULL
            OR shd.date_signed   >= p_qtr_start_date )
    AND    shd.start_date         < p_qtr_start_date
    AND    shd.base_contract_amount BETWEEN 0
                                        AND oki_utl_pub.g_contract_limit
    ;

Line: 1319

    SELECT NVL(SUM(base_contract_amount), 0) value
       , COUNT(shd.chr_id) contract_count
    FROM   oki_sales_k_hdrs shd
    WHERE  shd.is_new_yn     IS NULL
    AND    shd.date_signed   IS NOT NULL
    AND    shd.date_approved IS NOT NULL
    AND    shd.start_date     < p_qtr_start_date
    AND    GREATEST(shd.date_signed, shd.date_approved )
               BETWEEN p_qtr_start_date AND p_summary_build_date
    AND    shd.base_contract_amount BETWEEN 0
                                        AND oki_utl_pub.g_contract_limit
    ;

Line: 1339

    SELECT NVL(SUM(base_contract_amount), 0) value
         , COUNT(shd.chr_id) contract_count
    FROM   oki_sales_k_hdrs shd
    WHERE  shd.is_new_yn       IS NULL
    AND    shd.date_signed     IS NOT NULL
    AND    shd.start_date BETWEEN p_qtr_start_date AND p_qtr_end_date
    AND    GREATEST(shd.date_signed, shd.date_approved) <= p_qtr_end_date
    AND    shd.base_contract_amount BETWEEN 0
                                       AND oki_utl_pub.g_contract_limit
    ;

Line: 1358

    SELECT NVL(SUM(base_contract_amount), 0) value
         , COUNT(shd.chr_id) contract_count
    FROM   oki_sales_k_hdrs shd
    WHERE  shd.date_signed   <= p_summary_build_date
    AND    shd.date_approved <= p_summary_build_date
    AND    shd.is_new_yn      = 'Y'
    AND    shd.start_date BETWEEN p_qtr_start_date
                               AND p_summary_build_date
    AND    (   shd.date_terminated IS NULL
            OR shd.date_terminated  > p_summary_build_date )
    AND    shd.base_contract_amount BETWEEN 0
                                        AND oki_utl_pub.g_contract_limit
    ;

Line: 1380

    SELECT NVL(SUM(base_contract_amount), 0)  value
         , COUNT(shd.chr_id) contract_count
    FROM   oki_sales_k_hdrs shd
    WHERE  date_terminated  BETWEEN p_qtr_start_date
                                AND p_summary_build_date
    AND    shd.date_signed   IS NOT NULL
    AND    shd.date_approved IS NOT NULL
    AND    shd.base_contract_amount BETWEEN 0
                                        AND oki_utl_pub.g_contract_limit
  ;

Line: 1436

    l_loc := 'Inserting / updating ' || l_measure_type || '.' ;

Line: 1444

      l_loc := 'Insert the new record --  ' || l_measure_type || '.' ;

Line: 1464

      l_loc := 'Update the record -- ' || l_measure_type || '.' ;

Line: 1525

    l_loc := 'Inserting / updating ' || l_measure_type || '.' ;

Line: 1533

      l_loc := 'Insert the new record --  ' || l_measure_type || '.' ;

Line: 1553

      l_loc := 'Update the record -- ' || l_measure_type || '.' ;

Line: 1610

    l_loc := 'Inserting / updating ' || l_measure_type || '.' ;

Line: 1618

      l_loc := 'Insert the new record --  ' || l_measure_type || '.' ;

Line: 1638

      l_loc := 'Update the record -- ' || l_measure_type || '.' ;

Line: 1680

    l_loc := 'Inserting / updating ' || l_measure_type || '.' ;

Line: 1688

      l_loc := 'Insert the new record --  ' || l_measure_type || '.' ;

Line: 1709

      l_loc := 'Update the record -- ' || l_measure_type || '.' ;

Line: 1746

    l_loc := 'Inserting / updating ' || l_measure_type || '.' ;

Line: 1753

      l_loc := 'Insert the new record --  ' || l_measure_type || '.' ;

Line: 1773

      l_loc := 'Update the record -- ' || l_measure_type || '.' ;

Line: 1831

    l_loc := 'Inserting / updating ' || l_measure_type || '.' ;

Line: 1839

      l_loc := 'Insert the new record --  ' || l_measure_type || '.' ;

Line: 1859

      l_loc := 'Update the record -- ' || l_measure_type || '.' ;

Line: 1918

    l_loc := 'Inserting / updating ' || l_measure_type || '.' ;

Line: 1925

      l_loc := 'Insert the new record --  ' || l_measure_type || '.' ;

Line: 1945

      l_loc := 'Update the record -- ' || l_measure_type || '.' ;

Line: 2004

    l_loc := 'Inserting / updating ' || l_measure_type || '.' ;

Line: 2012

      l_loc := 'Insert the new record --  ' || l_measure_type || '.' ;

Line: 2032

      l_loc := 'Update the record -- ' || l_measure_type || '.' ;

Line: 2091

    l_loc := 'Inserting / updating ' || l_measure_type || '.' ;

Line: 2099

      l_loc := 'Insert the new record --  ' || l_measure_type || '.' ;

Line: 2119

      l_loc := 'Update the record -- ' || l_measure_type || '.' ;

Line: 2168

    l_loc := 'Inserting / updating ' || l_measure_type || '.' ;

Line: 2176

      l_loc := 'Insert the new record --  ' || l_measure_type || '.' ;

Line: 2196

      l_loc := 'Update the record -- ' || l_measure_type || '.' ;

Line: 2375

    oki_refresh_pvt.update_oki_refresh( l_table_name, l_retcode ) ;

Line: 2430

  g_program_update_date    :=  SYSDATE ;