APPS.OKI_LOAD_FBO_PVT SQL Statements

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

Line: 48

    SELECT rowid
    FROM   oki_forecast_by_orgs fbo
    WHERE  fbo.period_set_name  = p_period_set_name
    AND    fbo.period_name      = p_period_name
    AND    fbo.authoring_org_id = p_authoring_org_id
    AND    fbo.scs_code         = p_scs_code
    ;

Line: 83

    SELECT oki_forecast_by_orgs_s1.nextval seq
    FROM dual
    ;

Line: 102

    INSERT INTO oki_forecast_by_orgs
    (        id
           , period_name
           , period_set_name
           , period_type
           , authoring_org_id
           , authoring_org_name
           , scs_code
           , base_forecast_amount
           , base_booked_amount
           , request_id
           , program_application_id
           , program_id
           , program_update_date )
    VALUES ( l_sequence
           , p_period_name
           , p_period_set_name
           , p_period_type
           , p_authoring_org_id
           , p_authoring_org_name
           , p_scs_code
           , p_base_forecast_amount
           , p_base_booked_amount
           , oki_load_fbo_pvt.g_request_id
           , oki_load_fbo_pvt.g_program_application_id
           , oki_load_fbo_pvt.g_program_id
           , oki_load_fbo_pvt.g_program_update_date ) ;

Line: 174

    UPDATE oki_forecast_by_orgs SET
        base_forecast_amount   = p_base_forecast_amount
      , base_booked_amount     = p_base_booked_amount
      , request_id             = oki_load_fbo_pvt.g_request_id
      , program_application_id = oki_load_fbo_pvt.g_program_application_id
      , program_id             = oki_load_fbo_pvt.g_program_id
      , program_update_date    = oki_load_fbo_pvt.g_program_update_date
    WHERE ROWID =  p_fbo_rowid ;

Line: 249

    SELECT   DISTINCT shd.authoring_org_id org_id
           , /*11510 change */ NULL  organization_name
           , shd.scs_code
    FROM     oki_sales_k_hdrs shd
    ;

Line: 263

    SELECT     NVL(SUM(shd.base_forecast_amount), 0) base_forecast_amount
    FROM       oki_sales_k_hdrs shd
    -- Contract is a renewal contract
    WHERE      shd.is_new_yn        IS NULL
    -- Contract must have undergone forecasting
    AND        shd.close_date       IS NOT NULL
    AND        shd.win_percent      IS NOT NULL
    -- get forecast amount for a particular org
    AND        shd.authoring_org_id = p_authoring_org_id
    -- Expected close date is in the period
    AND        shd.close_date BETWEEN p_glpr_start_date AND p_glpr_end_date
    AND        shd.scs_code   = p_scs_code
    ;

Line: 286

    SELECT     NVL(SUM(shd.base_contract_amount), 0) base_contract_amount
    FROM       oki_sales_k_hdrs shd
    -- Contract is a renewal contract
    WHERE      shd.is_new_yn        IS NULL
    -- Contract is signed or active
    AND        shd.ste_code         IN ('SIGNED', 'ACTIVE')
    -- get booked amount for a particular org
    AND        shd.authoring_org_id = p_authoring_org_id
    -- Lesser of the signed DATE or the start date falls within
    -- the period
    AND        least(NVL(shd.date_signed, shd.start_date), shd.start_date)
                            BETWEEN p_glpr_start_date AND p_glpr_end_date
    AND        shd.scs_code = p_scs_code
    ;

Line: 348

        l_loc := 'Opening cursor to determine if insert or update should occur.'  ;

Line: 355

            l_loc := 'Insert the new record.' ;

Line: 373

            l_loc := 'Update the existing record.' ;

Line: 474

    SELECT   DISTINCT shd.authoring_org_id org_id
           , /*11510 change*/ NULL  organization_name
    FROM     oki_sales_k_hdrs shd
    ;

Line: 486

    SELECT     NVL(SUM(shd.base_forecast_amount), 0) base_forecast_amount
    FROM       oki_sales_k_hdrs shd
    -- Contract is a renewal contract
    WHERE      shd.is_new_yn        IS NULL
    -- Contract must have undergone forecasting
    AND        shd.close_date       IS NOT NULL
    AND        shd.win_percent      IS NOT NULL
    -- get forecast amount for a particular org
    AND        shd.authoring_org_id = p_authoring_org_id
    -- Expected close date is in the period
    AND        shd.close_date BETWEEN p_glpr_start_date AND p_glpr_end_date
    ;

Line: 507

    SELECT     NVL(SUM(shd.base_contract_amount), 0) base_contract_amount
    FROM       oki_sales_k_hdrs shd
    -- Contract is a renewal contract
    WHERE      shd.is_new_yn        IS NULL
    -- Contract is signed or active
    AND        shd.ste_code         IN ('SIGNED', 'ACTIVE')
    -- get booked amount for a particular org
    AND        shd.authoring_org_id = p_authoring_org_id
    -- Lesser of the signed DATE or the start date falls within
    -- the period
    AND        least(NVL(shd.date_signed, shd.start_date), shd.start_date)
                     BETWEEN p_glpr_start_date AND p_glpr_end_date
    ;

Line: 568

        l_loc := 'Opening cursor to determine if insert or update should occur.'  ;

Line: 575

            l_loc := 'Insert the new record.' ;

Line: 593

            l_loc := 'Update the existing record.' ;

Line: 735

    oki_refresh_pvt.update_oki_refresh( l_table_name, l_retcode ) ;

Line: 792

  g_program_update_date    :=  SYSDATE ;