APPS.ASP_ALERTS_SVC_CONTRACT SQL Statements

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

Line: 76

  l_LAST_UPDATED_BY number;

Line: 77

  l_LAST_UPDATE_LOGIN number;

Line: 86

    SELECT program_ref_date
    FROM  asp_program_run_dates
    WHERE  program_object_code = 'ASPEXPSC' --'SERVICE_CONTRACT'
       and status_code = 'S'
       and rownum < 2;

Line: 93

    select
      a.id as contract_id
    from
    okc_k_headers_all_b a, okc_statuses_b b
    where application_id = 515
    and a.sts_code = b.code
    and b.ste_code in ('ACTIVE', 'EXPIRED', 'SIGNED')
    and trunc(a.end_date)  between trunc(l_current_run_ref_date) and
                           trunc(l_current_run_ref_date + p_number_of_days);

Line: 105

    select
      a.id as contract_id
    from
    okc_k_headers_all_b a, okc_statuses_b b
    where application_id = 515
    and a.sts_code = b.code
    and b.ste_code in ('ACTIVE', 'EXPIRED', 'SIGNED')
    and trunc(a.end_date) between trunc(l_program_ref_date+1)
                          and trunc(l_current_run_ref_date + p_number_of_days);

Line: 144

  l_LAST_UPDATED_BY := l_PROGRAM_LOGIN_ID;

Line: 145

  l_LAST_UPDATE_LOGIN :=  TO_NUMBER(fnd_profile.value('CONC_LOGIN_ID'));

Line: 189

        SELECT l_contract_id ||'-'|| to_char(asp_wf_alerts_s.nextval) INTO l_item_key FROM DUAL;

Line: 213

    delete asp_program_run_dates where PROGRAM_OBJECT_CODE = 'ASPEXPSC';

Line: 214

    insert into asp_program_run_dates(
     PROGRAM_RUN_ID,
     PROGRAM_OBJECT_CODE,
     STATUS_CODE,
     DESCRIPTION,
     PROGRAM_START_DATE,
     PROGRAM_END_DATE,
     PROGRAM_REF_DATE,
     RELATED_OBJECT_INFO,
     REQUEST_ID,
     PROGRAM_APPLICATION_ID,
     PROGRAM_ID,
     PROGRAM_LOGIN_ID,
     OBJECT_VERSION_NUMBER,
     CREATION_DATE,
     CREATED_BY,
     LAST_UPDATE_DATE,
     LAST_UPDATED_BY,
     LAST_UPDATE_LOGIN
    )values(
     asp_program_run_dates_s.nextval,
     'ASPEXPSC', --'SERVICE_CONTRACT'
     'S',
     null,
     l_PROGRAM_START_DATE,
     null,
     l_current_run_ref_date + p_number_of_days,
     null,
     l_REQUEST_ID,
     l_PROGRAM_APPLICATION_ID,
     l_PROGRAM_ID,
     l_PROGRAM_LOGIN_ID,
     1,
     sysdate,
     l_CREATED_BY,
     sysdate,
     l_LAST_UPDATED_BY,
     l_LAST_UPDATE_LOGIN
    );

Line: 288

        SELECT l_contract_id ||'-'|| to_char(asp_wf_alerts_s.nextval) INTO l_item_key FROM DUAL;

Line: 314

    update asp_program_run_dates
    set program_ref_date = (l_current_run_ref_date + p_number_of_days)
    where program_object_code = 'ASPEXPSC' --'SERVICE_CONTRACT'
        and status_code = 'S';