APPS.OKI_LOAD_ENR_PVT SQL Statements

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

Line: 57

    SELECT rowid
    FROM   oki_exp_not_renewed enr
    WHERE  enr.period_set_name   = p_period_set_name
    AND    enr.period_name       = p_period_name
    AND    enr.authoring_org_id  = p_authoring_org_id
    AND    enr.customer_party_id = p_customer_party_id
    AND   (enr.contact_id        = p_contact_id
           or enr.contact_id IS NULL )
    AND    enr.scs_code          = p_scs_code
    ;

Line: 99

    SELECT oki_exp_not_renewed_s1.nextval seq
    FROM dual
    ;

Line: 118

    INSERT INTO oki_exp_not_renewed
    (        id
           , period_set_name
           , period_name
           , period_type
           , authoring_org_id
           , authoring_org_name
           , customer_party_id
           , customer_name
           , contact_id
           , salesrep_name
           , scs_code
           , base_lost_amount
           , contract_count
           , 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_contact_id
           , p_salesrep_name
           , p_scs_code
           , p_base_lost_amount
           , p_contract_count
           , oki_load_enr_pvt.g_request_id
           , oki_load_enr_pvt.g_program_application_id
           , oki_load_enr_pvt.g_program_id
           , oki_load_enr_pvt.g_program_update_date ) ;

Line: 199

    UPDATE oki_exp_not_renewed SET
        base_lost_amount       = p_base_lost_amount
      , contract_count         = p_contract_count
      , request_id             = oki_load_enr_pvt.g_request_id
      , program_application_id = oki_load_enr_pvt.g_program_application_id
      , program_id             = oki_load_enr_pvt.g_program_id
      , program_update_date    = oki_load_enr_pvt.g_program_update_date
    WHERE ROWID = p_enr_rowid ;

Line: 283

    SELECT   slr.contact_id
           , NULL salesrep_name /* 1150 Change slr.salesrep_name to null */
             -- display consolidate amount in correct currency format
           , NVL(SUM(cpl/*11510 change ocl*/.base_price_negotiated), 0) base_price_negotiated_amount
             -- display number in correct number format
           , COUNT(DISTINCT (shd.chr_id )) contract_count
    FROM     /*11510 change removed oki_expired_lines oel */
             oki_cov_prd_lines cpl
           , oki_sales_k_hdrs shd
           , oki_k_salesreps slr
    WHERE    shd.chr_id                = /*oel*/cpl.chr_id
    /*11510 changes start */
    AND      cpl.is_exp_not_renewed_yn = 'Y'
    /*11510 changes end */
    AND      cpl/*oel*/.end_date BETWEEN p_glpr_start_date AND p_glpr_end_date
    AND      shd.customer_party_id = p_customer_party_id
    AND      shd.authoring_org_id  = p_authoring_org_id
    AND      shd.scs_code          = p_scs_code
    AND      slr.contract_id(+)    = shd.chr_id
    GROUP BY slr.contact_id   ;

Line: 308

    SELECT DISTINCT(shd.customer_party_id) customer_id
           , NULL customer_name /*11510 change null out shd.customer_name  */
           , shd.authoring_org_id authoring_org_id
           , NULL authoring_org_name /*11510 change null out shd.organization_name  */
           , shd.scs_code scs_code
    FROM   oki_sales_k_hdrs shd
    ;

Line: 357

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

Line: 366

            l_loc := 'Insert the new record.' ;

Line: 390

            l_loc := 'Update the existing record.' ;

Line: 500

    SELECT   slr.contact_id
           , NULL salesrep_name /*11510 Change  modified slr.salesrep_name */
             -- display consolidate amount in correct currency format
           , NVL(SUM(cpl.base_price_negotiated), 0) base_price_negotiated_amount
             -- display number in correct number format
           , COUNT(DISTINCT (shd.chr_id )) contract_count
    FROM     /*11510 change removed oki_expired_lines oel added oki_cov_prd_lines */
             oki_cov_prd_lines cpl
           , oki_sales_k_hdrs shd
           , oki_k_salesreps slr
    WHERE    shd.chr_id             = cpl.chr_id
/*11510 change start*/
    AND      cpl.is_exp_not_renewed_yn = 'Y'
/*11510 change end*/
    AND      cpl.end_date           BETWEEN p_glpr_start_date AND p_glpr_end_date
    AND      shd.customer_party_id  = p_customer_party_id
    AND      slr.contract_id(+)     = shd.chr_id
    AND      shd.scs_code           = p_scs_code
    GROUP BY slr.contact_id ;

Line: 524

    SELECT DISTINCT(shd.customer_party_id) customer_id
           , NULL customer_name /*11510 change null out shd.customer_name */
           , shd.scs_code
    FROM   oki_sales_k_hdrs shd
    ;

Line: 570

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

Line: 578

            l_loc := 'Insert the new record.' ;

Line: 602

            l_loc := 'Update the existing record.' ;

Line: 708

    SELECT
             -- display consolidate amount in correct currency format
            NVL(SUM(cpl.base_price_negotiated), 0) base_price_negotiated_amount
             -- display number in correct number format
           , COUNT(DISTINCT (shd.chr_id )) contract_count
    FROM    /*11510 change removed oki_expired_lines oel*/
             oki_cov_prd_lines cpl
           , oki_sales_k_hdrs shd
    WHERE    shd.chr_id             = cpl.chr_id
  /*11510 change start*/
    AND      cpl.is_exp_not_renewed_yn = 'Y'
 /*11510 change end*/
    AND      cpl.end_date           BETWEEN p_glpr_start_date AND p_glpr_end_date
    AND      shd.customer_party_id  = p_customer_party_id
    ;

Line: 727

    SELECT DISTINCT(shd.customer_party_id) customer_id
           , NULL customer_name /*11510 change null out customer name*/
           , shd.authoring_org_id authoring_org_id
           , NULL authoring_org_name /*11510 change null out authoring_org_name*/
    FROM   oki_sales_k_hdrs shd
    ;

Line: 772

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

Line: 781

            l_loc := 'Insert the new record.' ;

Line: 805

            l_loc := 'Update the existing record.' ;

Line: 957

    oki_refresh_pvt.update_oki_refresh( l_table_name, l_retcode ) ;

Line: 1015

  g_program_update_date    :=  SYSDATE ;