APPS.OKI_LOAD_RAG_PVT SQL Statements

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

Line: 53

    SELECT rowid
    FROM   oki_renewal_aging rag
    WHERE  rag.period_set_name   = p_period_set_name
    AND    rag.period_name       = p_period_name
    AND    rag.authoring_org_id  = p_authoring_org_id
    AND    rag.customer_party_id = p_customer_party_id
    AND    rag.scs_code          = p_scs_code
    ;

Line: 93

    SELECT oki_renewal_aging_s1.nextval seq
    FROM dual ;

Line: 111

    INSERT INTO oki_renewal_aging
    (        id
           , period_set_name
           , period_name
           , period_type
           , authoring_org_id
           , authoring_org_name
           , customer_party_id
           , customer_name
           , scs_code
           , age_group1
           , age_group2
           , age_group3
           , age_group4
           , request_id
           , program_application_id
           , program_id
           , program_update_date )
    VALUES ( l_sequence
           , p_period_set_name
           , p_period_name
           , p_period_type
           , p_authoring_org_id
           , p_authoring_org_name
           , p_customer_party_id
           , p_customer_name
           , p_scs_code
           , p_age_group1
           , p_age_group2
           , p_age_group3
           , p_age_group4
           , oki_load_rag_pvt.g_request_id
           , oki_load_rag_pvt.g_program_application_id
           , oki_load_rag_pvt.g_program_id
           , oki_load_rag_pvt.g_program_update_date ) ;

Line: 192

    UPDATE oki_renewal_aging SET
        age_group1             = p_age_group1
      , age_group2             = p_age_group2
      , age_group3             = p_age_group3
      , age_group4             = p_age_group4
      , request_id             = oki_load_rag_pvt.g_request_id
      , program_application_id = oki_load_rag_pvt.g_program_application_id
      , program_id             = oki_load_rag_pvt.g_program_id
      , program_update_date    = oki_load_rag_pvt.g_program_update_date
    WHERE ROWID =  p_rag_rowid ;

Line: 346

    SELECT   DISTINCT shd.authoring_org_id org_id
           , /*11510 changes*/ NULL organization_name
           , shd.customer_party_id customer_id
           , /*11510 changes*/ NULL customer_name
           , shd.scs_code
    FROM     oki_sales_k_hdrs shd ;

Line: 368

    SELECT
         NVL(SUM(DECODE(SIGN( (TRUNC(p_summary_build_date) -
                            TRUNC(shd.creation_date)) - p_start_age_group1),
            1, DECODE(SIGN( p_end_age_group1 -
                     (TRUNC(p_summary_build_date) - trunc(shd.creation_date))),
                 1, shd.base_forecast_amount,
                 0, shd.base_forecast_amount,
                 0),
            0, shd.base_forecast_amount,
            0)), 0) age_group1,
         NVL(SUM(DECODE(SIGN( (TRUNC(p_summary_build_date) -
                            TRUNC(shd.creation_date)) - p_start_age_group2),
            1, DECODE(SIGN( p_end_age_group2 -
                     (TRUNC(p_summary_build_date) - TRUNC(shd.creation_date))),
                 1, shd.base_forecast_amount,
                 0, shd.base_forecast_amount,
                 0),
            0, shd.base_forecast_amount,
            0)), 0) age_group2,
         NVL(SUM(DECODE(SIGN( (TRUNC(p_summary_build_date) -
                            TRUNC(shd.creation_date)) - p_start_age_group3),
            1, decode(sign( p_end_age_group3 -
                     (trunc(p_summary_build_date) - trunc(shd.creation_date))),
                 1, shd.base_forecast_amount,
                 0, shd.base_forecast_amount,
                 0),
            0, shd.base_forecast_amount,
            0)), 0) age_group3,
         NVL(SUM(DECODE(SIGN( (TRUNC(p_summary_build_date) -
                            TRUNC(shd.creation_date)) - p_start_age_group4),
            1, shd.base_forecast_amount,
            0, shd.base_forecast_amount,
            0)), 0) age_group4
    FROM     oki_sales_k_hdrs shd
    -- contract has undergone forecasting
    WHERE    shd.win_percent is not null
    AND      shd.close_date  is not null
    -- renewal contract      is entered
    AND      shd.ste_code          = 'ENTERED'
    AND      is_new_yn         IS NULL
    AND      shd.authoring_org_id  = p_org_id
    AND      shd.customer_party_id = p_customer_party_id
    AND      shd.scs_code = p_scs_code
    ;

Line: 478

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

Line: 485

            l_loc := 'Insert the new record.' ;

Line: 508

            l_loc := 'Update the existing record.' ;

Line: 613

    SELECT   DISTINCT shd.authoring_org_id org_id
           , /*11510 changes*/ NULL organization_name
           , shd.customer_party_id
           , /*11510 changes*/ NULL customer_name
    FROM     oki_sales_k_hdrs shd  ;

Line: 633

    SELECT
         NVL(SUM(DECODE(SIGN( (TRUNC(p_summary_build_date) -
                            TRUNC(shd.creation_date)) - p_start_age_group1),
            1, DECODE(SIGN( p_end_age_group1 -
                     (TRUNC(p_summary_build_date) - trunc(shd.creation_date))),
                 1, shd.base_forecast_amount,
                 0, shd.base_forecast_amount,
                 0),
            0, shd.base_forecast_amount,
            0)), 0) age_group1,
         NVL(SUM(DECODE(SIGN( (TRUNC(p_summary_build_date) -
                            TRUNC(shd.creation_date)) - p_start_age_group2),
            1, DECODE(SIGN( p_end_age_group2 -
                     (TRUNC(p_summary_build_date) - TRUNC(shd.creation_date))),
                 1, shd.base_forecast_amount,
                 0, shd.base_forecast_amount,
                 0),
            0, shd.base_forecast_amount,
            0)), 0) age_group2,
         NVL(SUM(DECODE(SIGN( (TRUNC(p_summary_build_date) -
                            TRUNC(shd.creation_date)) - p_start_age_group3),
            1, decode(sign( p_end_age_group3 -
                     (trunc(p_summary_build_date) - trunc(shd.creation_date))),
                 1, shd.base_forecast_amount,
                 0, shd.base_forecast_amount,
                 0),
            0, shd.base_forecast_amount,
            0)), 0) age_group3,
         NVL(SUM(DECODE(SIGN( (TRUNC(p_summary_build_date) -
                            TRUNC(shd.creation_date)) - p_start_age_group4),
            1, shd.base_forecast_amount,
            0, shd.base_forecast_amount,
            0)), 0) age_group4
    FROM     oki_sales_k_hdrs shd
    -- contract has undergone forecasting
    WHERE    shd.win_percent is not null
    AND      shd.close_date  is not null
    -- renewal contract      is entered
    AND      shd.ste_code          = 'ENTERED'
    AND      is_new_yn         IS NULL
    AND      shd.authoring_org_id  = p_org_id
    AND      shd.customer_party_id = p_customer_party_id
    ;

Line: 726

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

Line: 734

            l_loc := 'Insert the new record.' ;

Line: 757

            l_loc := 'Update the existing record.' ;

Line: 862

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

Line: 880

    SELECT
         NVL(SUM(DECODE(SIGN( (TRUNC(p_summary_build_date) -
                            TRUNC(shd.creation_date)) - p_start_age_group1),
            1, DECODE(SIGN( p_end_age_group1 -
                     (TRUNC(p_summary_build_date) - trunc(shd.creation_date))),
                 1, shd.base_forecast_amount,
                 0, shd.base_forecast_amount,
                 0),
            0, shd.base_forecast_amount,
            0)), 0) age_group1,
         NVL(SUM(DECODE(SIGN( (TRUNC(p_summary_build_date) -
                            TRUNC(shd.creation_date)) - p_start_age_group2),
            1, DECODE(SIGN( p_end_age_group2 -
                     (TRUNC(p_summary_build_date) - TRUNC(shd.creation_date))),
                 1, shd.base_forecast_amount,
                 0, shd.base_forecast_amount,
                 0),
            0, shd.base_forecast_amount,
            0)), 0) age_group2,
         NVL(SUM(DECODE(SIGN( (TRUNC(p_summary_build_date) -
                            TRUNC(shd.creation_date)) - p_start_age_group3),
            1, decode(sign( p_end_age_group3 -
                     (trunc(p_summary_build_date) - trunc(shd.creation_date))),
                 1, shd.base_forecast_amount,
                 0, shd.base_forecast_amount,
                 0),
            0, shd.base_forecast_amount,
            0)), 0) age_group3,
         NVL(SUM(DECODE(SIGN( (TRUNC(p_summary_build_date) -
                            TRUNC(shd.creation_date)) - p_start_age_group4),
            1, shd.base_forecast_amount,
            0, shd.base_forecast_amount,
            0)), 0) age_group4
    FROM     oki_sales_k_hdrs shd
    -- contract has undergone forecasting
    WHERE    shd.win_percent is not null
    AND      shd.close_date  is not null
    -- renewal contract      is entered
    AND      shd.ste_code          = 'ENTERED'
    AND      is_new_yn         IS NULL
    AND      shd.authoring_org_id  = p_org_id
    ;

Line: 971

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

Line: 978

            l_loc := 'Insert the new record.' ;

Line: 1001

            l_loc := 'Update the existing record.' ;

Line: 1158

    oki_refresh_pvt.update_oki_refresh( l_table_name, l_retcode ) ;

Line: 1213

  g_program_update_date    :=  SYSDATE ;