eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SIF_PVT SQL Statements

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

Line: 17


    SELECT OKL_SIF_SEQ.NEXTVAL INTO	l_newvalue FROM dual;

Line: 53


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            FASB_ACCT_TREATMENT_METHOD,
            IRS_TAX_TREATMENT_METHOD,
                     SIF_MODE,
			DATE_DELIVERY,
			TOTAL_FUNDING,
			SECURITY_DEPOSIT_AMOUNT,
			SIS_CODE,
			KHR_ID,
			PRICING_TEMPLATE_NAME,
			DATE_PROCESSED,
			DATE_SEC_DEPOSIT_COLLECTED,
			DATE_PAYMENTS_COMMENCEMENT,
			TRANSACTION_NUMBER,
			COUNTRY,
			LENDING_RATE,
			RVI_YN,
			RVI_RATE,
			ADJUST,
			ADJUSTMENT_METHOD,
			IMPLICIT_INTEREST_RATE,
			ORP_CODE,
			STREAM_INTERFACE_ATTRIBUTE01,
			STREAM_INTERFACE_ATTRIBUTE02,
			STREAM_INTERFACE_ATTRIBUTE03,
			STREAM_INTERFACE_ATTRIBUTE04,
			STREAM_INTERFACE_ATTRIBUTE05,
			STREAM_INTERFACE_ATTRIBUTE06,
			STREAM_INTERFACE_ATTRIBUTE07,
			STREAM_INTERFACE_ATTRIBUTE08,
			STREAM_INTERFACE_ATTRIBUTE09,
			STREAM_INTERFACE_ATTRIBUTE10,
			STREAM_INTERFACE_ATTRIBUTE11,
			STREAM_INTERFACE_ATTRIBUTE12,
			STREAM_INTERFACE_ATTRIBUTE13,
			STREAM_INTERFACE_ATTRIBUTE14,
   			STREAM_INTERFACE_ATTRIBUTE15,
            CREATED_BY,
            LAST_UPDATED_BY,
            CREATION_DATE,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            -- mvasudev -- 02/21/2002
            -- new columns added for concurrent program manager
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
	    -- mvasudev -- 05/13/2002
	    JTOT_OBJECT1_CODE,
	    OBJECT1_ID1,
	    OBJECT1_ID2,
	    TERM,
	    STRUCTURE,
	    DEAL_TYPE,
	    LOG_FILE,
	    FIRST_PAYMENT,
	    LAST_PAYMENT,
            -- mvasudev, Bug#2650599
            SIF_ID,
            PURPOSE_CODE
            -- end, mvasudev, Bug#2650599
      FROM Okl_Stream_Interfaces
     WHERE okl_stream_interfaces.id = p_id;

Line: 165


            l_sif_rec.LAST_UPDATED_BY,
            l_sif_rec.CREATION_DATE,
            l_sif_rec.LAST_UPDATE_DATE,
            l_sif_rec.LAST_UPDATE_LOGIN,
            -- mvasudev -- 02/21/2002
            -- new columns added for concurrent program manager
            l_sif_rec.REQUEST_ID,
            l_sif_rec.PROGRAM_APPLICATION_ID,
            l_sif_rec.PROGRAM_ID,
            l_sif_rec.PROGRAM_UPDATE_DATE,
	    -- mvasudev -- 05/13/2002
	    l_sif_rec.JTOT_OBJECT1_CODE,
	    l_sif_rec.OBJECT1_ID1,
	    l_sif_rec.OBJECT1_ID2,
	    l_sif_rec.TERM,
	    l_sif_rec.STRUCTURE,
	    l_sif_rec.DEAL_TYPE,
	    l_sif_rec.LOG_FILE,
	    l_sif_rec.FIRST_PAYMENT,
	    l_sif_rec.LAST_PAYMENT,
            -- mvasudev, Bug#2650599
            l_sif_rec.SIF_ID,
            l_sif_rec.PURPOSE_CODE;

Line: 209


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            FASB_ACCT_TREATMENT_METHOD,
			IRS_TAX_TREATMENT_METHOD,
            SIF_MODE,
			DATE_DELIVERY,
			TOTAL_FUNDING,
			SECURITY_DEPOSIT_AMOUNT,
			SIS_CODE,
			KHR_ID,
			PRICING_TEMPLATE_NAME,
			DATE_PROCESSED,
			DATE_SEC_DEPOSIT_COLLECTED,
			DATE_PAYMENTS_COMMENCEMENT,
			TRANSACTION_NUMBER,
			COUNTRY,
			LENDING_RATE,
			RVI_YN,
			RVI_RATE,
			ADJUST,
			ADJUSTMENT_METHOD,
			IMPLICIT_INTEREST_RATE,
			ORP_CODE,
			STREAM_INTERFACE_ATTRIBUTE01,
			STREAM_INTERFACE_ATTRIBUTE02,
			STREAM_INTERFACE_ATTRIBUTE03,
			STREAM_INTERFACE_ATTRIBUTE04,
			STREAM_INTERFACE_ATTRIBUTE05,
			STREAM_INTERFACE_ATTRIBUTE06,
			STREAM_INTERFACE_ATTRIBUTE07,
			STREAM_INTERFACE_ATTRIBUTE08,
			STREAM_INTERFACE_ATTRIBUTE09,
			STREAM_INTERFACE_ATTRIBUTE10,
			STREAM_INTERFACE_ATTRIBUTE11,
			STREAM_INTERFACE_ATTRIBUTE12,
			STREAM_INTERFACE_ATTRIBUTE13,
			STREAM_INTERFACE_ATTRIBUTE14,
   			STREAM_INTERFACE_ATTRIBUTE15,
            CREATED_BY,
            LAST_UPDATED_BY,
            CREATION_DATE,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            -- mvasudev -- 02/21/2002
            -- new columns added for concurrent program manager
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
	    -- mvasudev -- 05/13/2002
	    JTOT_OBJECT1_CODE,
	    OBJECT1_ID1,
	    OBJECT1_ID2,
	    TERM,
	    STRUCTURE,
	    DEAL_TYPE,
	    LOG_FILE,
	    FIRST_PAYMENT,
	    LAST_PAYMENT,
            -- mvasudev, Bug#2650599
            SIF_ID,
            PURPOSE_CODE
            -- end, mvasudev, Bug#2650599
      FROM OKL_STREAM_INTERFACES_V
     WHERE OKL_STREAM_INTERFACES_V.id = p_id;

Line: 321


            l_sifv_rec.LAST_UPDATED_BY,
            l_sifv_rec.CREATION_DATE,
            l_sifv_rec.LAST_UPDATE_DATE,
            l_sifv_rec.LAST_UPDATE_LOGIN,
            -- mvasudev -- 02/21/2002
            -- new columns added for concurrent program manager
            l_sifv_rec.REQUEST_ID,
            l_sifv_rec.PROGRAM_APPLICATION_ID,
            l_sifv_rec.PROGRAM_ID,
            l_sifv_rec.PROGRAM_UPDATE_DATE,
	    -- mvasudev -- 05/13/2002
	    l_sifv_rec.JTOT_OBJECT1_CODE,
	    l_sifv_rec.OBJECT1_ID1,
	    l_sifv_rec.OBJECT1_ID2,
	    l_sifv_rec.TERM,
	    l_sifv_rec.STRUCTURE,
	    l_sifv_rec.DEAL_TYPE,
	    l_sifv_rec.LOG_FILE,
	    l_sifv_rec.FIRST_PAYMENT,
	    l_sifv_rec.LAST_PAYMENT,
            -- mvasudev, Bug#2650599
            l_sifv_rec.SIF_ID,
            l_sifv_rec.PURPOSE_CODE;

Line: 484


    IF (l_sifv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_sifv_rec.last_updated_by := NULL;

Line: 490


    IF (l_sifv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_sifv_rec.last_update_date := NULL;

Line: 493


    IF (l_sifv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_sifv_rec.last_update_login := NULL;

Line: 508


    IF (l_sifv_rec.PROGRAM_UPDATE_DATE = OKC_API.G_MISS_DATE) THEN
      l_sifv_rec.PROGRAM_UPDATE_DATE := NULL;

Line: 998


  SELECT '1'
    FROM OKL_K_HEADERS_V
   WHERE OKL_K_HEADERS_V.id = p_id;

Line: 1368


    SELECT select_id, from_table
    FROM JTF_OBJECTS_B JOB
    WHERE JOB.OBJECT_CODE = p_obj_code;

Line: 1378


    l_select_clause VARCHAR2(100);

Line: 1413


  		    INTO l_select_clause, l_from_clause;

Line: 1422


  		    l_query_string := 'SELECT ''1''' ||
  		                       ' FROM '  || l_from_clause   ||
  		                       ' WHERE ' || l_select_clause || ' = ' || p_sifv_rec.OBJECT1_ID1;

Line: 1485


  SELECT '1'
    FROM OKL_STREAM_INTERFACES
   WHERE OKL_STREAM_INTERFACES.id = p_id;

Line: 1822


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1824


    p_to.last_update_date := p_from.last_update_date;

Line: 1825


    p_to.last_update_login := p_from.last_update_login;

Line: 1831


    p_to.PROGRAM_UPDATE_DATE := p_from.PROGRAM_UPDATE_DATE;

Line: 1898


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1900


    p_to.last_update_date := p_from.last_update_date;

Line: 1901


    p_to.last_update_login := p_from.last_update_login;

Line: 1907


    p_to.PROGRAM_UPDATE_DATE := p_from.PROGRAM_UPDATE_DATE;

Line: 2105


  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_sif_rec                      IN sif_rec_type,
    x_sif_rec                      OUT NOCOPY sif_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2114


    l_api_name                     CONSTANT VARCHAR2(30) := 'INTERFACES_insert_row';

Line: 2150


    INSERT INTO OKL_STREAM_INTERFACES(
            id,
            object_version_number,
            fasb_acct_treatment_method,
			irs_tax_treatment_method,
            sif_mode,
			date_delivery,
			total_funding,
			security_deposit_amount,
			sis_code,
			khr_id,
			pricing_template_name,
			date_processed,
			date_sec_deposit_collected,
			date_payments_commencement,
			transaction_number,
			country,
			lending_rate,
			rvi_yn,
			rvi_rate,
			adjust,
			adjustment_method,
			implicit_interest_rate,
			orp_code,
			stream_interface_attribute01,
			stream_interface_attribute02,
			stream_interface_attribute03,
			stream_interface_attribute04,
			stream_interface_attribute05,
			stream_interface_attribute06,
			stream_interface_attribute07,
			stream_interface_attribute08,
			stream_interface_attribute09,
			stream_interface_attribute10,
			stream_interface_attribute11,
			stream_interface_attribute12,
			stream_interface_attribute13,
			stream_interface_attribute14,
   			stream_interface_attribute15,
            created_by,
            last_updated_by,
            creation_date,
            last_update_date,
            last_update_login,
            -- mvasudev -- 02/21/2002
            -- new columns added for concurrent program manager
            request_id,
            program_application_id,
            program_id,
            program_update_date,
	    -- mvasudev -- 05/13/2002
	    jtot_object1_code,
	    object1_id1,
	    object1_id2,
	    term,
	    structure,
	    deal_type,
	    log_file,
	    first_payment,
	    last_payment,
             --  mvasudev, Bug#2650599
             sif_id,
             purpose_code
             -- end, mvasudev, Bug#2650599
            )
      VALUES (
            l_sif_rec.id,
            l_sif_rec.object_version_number,
            l_sif_rec.fasb_acct_treatment_method,
			l_sif_rec.irs_tax_treatment_method,
            l_sif_rec.sif_mode,
			l_sif_rec.date_delivery,
			l_sif_rec.total_funding,
			l_sif_rec.security_deposit_amount,
			l_sif_rec.sis_code,
			l_sif_rec.khr_id,
			l_sif_rec.pricing_template_name,
			l_sif_rec.date_processed,
			l_sif_rec.date_sec_deposit_collected,
			l_sif_rec.date_payments_commencement,
			l_sif_rec.transaction_number,
			l_sif_rec.country,
			l_sif_rec.lending_rate,
			l_sif_rec.rvi_yn,
			l_sif_rec.rvi_rate,
			l_sif_rec.adjust,
			l_sif_rec.adjustment_method,
			l_sif_rec.implicit_interest_rate,
			l_sif_rec.orp_code,
			l_sif_rec.stream_interface_attribute01,
			l_sif_rec.stream_interface_attribute02,
			l_sif_rec.stream_interface_attribute03,
			l_sif_rec.stream_interface_attribute04,
			l_sif_rec.stream_interface_attribute05,
			l_sif_rec.stream_interface_attribute06,
			l_sif_rec.stream_interface_attribute07,
			l_sif_rec.stream_interface_attribute08,
			l_sif_rec.stream_interface_attribute09,
			l_sif_rec.stream_interface_attribute10,
			l_sif_rec.stream_interface_attribute11,
			l_sif_rec.stream_interface_attribute12,
			l_sif_rec.stream_interface_attribute13,
			l_sif_rec.stream_interface_attribute14,
   			l_sif_rec.stream_interface_attribute15,
            l_sif_rec.created_by,
            l_sif_rec.last_updated_by,
            l_sif_rec.creation_date,
            l_sif_rec.last_update_date,
            l_sif_rec.last_update_login,
            -- mvasudev -- 02/21/2002
            -- new columns added for concurrent program manager
            l_sif_rec.request_id,
            l_sif_rec.program_application_id,
            l_sif_rec.program_id,
            l_sif_rec.program_update_date,
	    -- mvasudev -- 05/13/2002
	    l_sif_rec.JTOT_OBJECT1_CODE,
	    l_sif_rec.OBJECT1_ID1,
	    l_sif_rec.OBJECT1_ID2,
	    l_sif_rec.TERM,
	    l_sif_rec.STRUCTURE,
	    l_sif_rec.DEAL_TYPE,
	    l_sif_rec.LOG_FILE,
	    l_sif_rec.FIRST_PAYMENT,
	    l_sif_rec.LAST_PAYMENT,
            --  mvasudev, Bug#2650599
	    l_sif_rec.sif_id,
	    l_sif_rec.purpose_code
	    -- end, mvasudev, Bug#2650599
            );

Line: 2314


  END insert_row;

Line: 2318


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_sifv_rec                     IN sifv_rec_type,
    x_sifv_rec                     OUT NOCOPY sifv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2328


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_insert_row';

Line: 2344


      l_sifv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2345


      l_sifv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2346


      l_sifv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2362


      SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL,Fnd_Global.CONC_REQUEST_ID),
             DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL,Fnd_Global.PROG_APPL_ID),
             DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL,Fnd_Global.CONC_PROGRAM_ID),
             DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
      INTO   x_sifv_rec.REQUEST_ID
            ,x_sifv_rec.PROGRAM_APPLICATION_ID
            ,x_sifv_rec.PROGRAM_ID
            ,x_sifv_rec.PROGRAM_UPDATE_DATE
      FROM DUAL;

Line: 2423


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_sif_rec,
      lx_sif_rec
    );

Line: 2471


  END insert_row;

Line: 2475


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_sifv_tbl                     IN sifv_tbl_type,
    x_sifv_tbl                     OUT NOCOPY sifv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2485


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';

Line: 2500


        insert_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_sifv_rec                     => p_sifv_tbl(i),
          x_sifv_rec                     => x_sifv_tbl(i));

Line: 2558


  END insert_row;

Line: 2576


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_STREAM_INTERFACES
     WHERE ID = p_sif_rec.id
       AND OBJECT_VERSION_NUMBER = p_sif_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 2583


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_STREAM_INTERFACES
    WHERE ID = p_sif_rec.id;

Line: 2624


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2633


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2843


  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_sif_rec                      IN sif_rec_type,
    x_sif_rec                      OUT NOCOPY sif_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2852


    l_api_name                     CONSTANT VARCHAR2(30) := 'INTERFACES_update_row';

Line: 3030


      IF (x_sif_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_sif_rec.last_updated_by := l_sif_rec.last_updated_by;

Line: 3038


      IF (x_sif_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_sif_rec.last_update_date := l_sif_rec.last_update_date;

Line: 3042


      IF (x_sif_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_sif_rec.last_update_login := l_sif_rec.last_update_login;

Line: 3060


      IF (x_sif_rec.PROGRAM_UPDATE_DATE = OKC_API.G_MISS_DATE)
      THEN
        x_sif_rec.PROGRAM_UPDATE_DATE := l_sif_rec.PROGRAM_UPDATE_DATE;

Line: 3151


    UPDATE  OKL_STREAM_INTERFACES
    SET FASB_ACCT_TREATMENT_METHOD = l_def_sif_rec.FASB_ACCT_TREATMENT_METHOD,
		IRS_TAX_TREATMENT_METHOD = l_def_sif_rec.IRS_TAX_TREATMENT_METHOD,
		SIF_MODE = l_def_sif_rec.SIF_MODE,
		DATE_DELIVERY = l_def_sif_rec.DATE_DELIVERY,
		TOTAL_FUNDING = l_def_sif_rec.TOTAL_FUNDING,
		SECURITY_DEPOSIT_AMOUNT = l_def_sif_rec.SECURITY_DEPOSIT_AMOUNT,
		SIS_CODE = l_def_sif_rec.SIS_CODE,
		KHR_ID = l_def_sif_rec.KHR_ID,
		PRICING_TEMPLATE_NAME = l_def_sif_rec.PRICING_TEMPLATE_NAME,
		DATE_PROCESSED = l_def_sif_rec.DATE_PROCESSED,
		DATE_SEC_DEPOSIT_COLLECTED = l_def_sif_rec.DATE_SEC_DEPOSIT_COLLECTED,
		DATE_PAYMENTS_COMMENCEMENT = l_def_sif_rec.DATE_PAYMENTS_COMMENCEMENT,
		TRANSACTION_NUMBER = l_def_sif_rec.TRANSACTION_NUMBER,
		COUNTRY = l_def_sif_rec.COUNTRY,
		LENDING_RATE = l_def_sif_rec.LENDING_RATE,
		RVI_YN = l_def_sif_rec.RVI_YN,
		RVI_RATE = l_def_sif_rec.RVI_RATE,
		ADJUST = l_def_sif_rec.ADJUST,
		ADJUSTMENT_METHOD = l_def_sif_rec.ADJUSTMENT_METHOD,
		IMPLICIT_INTEREST_RATE = l_def_sif_rec.IMPLICIT_INTEREST_RATE,
		ORP_CODE = l_def_sif_rec.ORP_CODE,
		STREAM_INTERFACE_ATTRIBUTE01 = l_def_sif_rec.STREAM_INTERFACE_ATTRIBUTE01,
		STREAM_INTERFACE_ATTRIBUTE02 = l_def_sif_rec.STREAM_INTERFACE_ATTRIBUTE02,
		STREAM_INTERFACE_ATTRIBUTE03 = l_def_sif_rec.STREAM_INTERFACE_ATTRIBUTE03,
		STREAM_INTERFACE_ATTRIBUTE04 = l_def_sif_rec.STREAM_INTERFACE_ATTRIBUTE04,
		STREAM_INTERFACE_ATTRIBUTE05 = l_def_sif_rec.STREAM_INTERFACE_ATTRIBUTE05,
		STREAM_INTERFACE_ATTRIBUTE06 = l_def_sif_rec.STREAM_INTERFACE_ATTRIBUTE06,
		STREAM_INTERFACE_ATTRIBUTE07 = l_def_sif_rec.STREAM_INTERFACE_ATTRIBUTE07,
		STREAM_INTERFACE_ATTRIBUTE08 = l_def_sif_rec.STREAM_INTERFACE_ATTRIBUTE08,
		STREAM_INTERFACE_ATTRIBUTE09 = l_def_sif_rec.STREAM_INTERFACE_ATTRIBUTE09,
		STREAM_INTERFACE_ATTRIBUTE10 = l_def_sif_rec.STREAM_INTERFACE_ATTRIBUTE10,
		STREAM_INTERFACE_ATTRIBUTE11 = l_def_sif_rec.STREAM_INTERFACE_ATTRIBUTE11,
		STREAM_INTERFACE_ATTRIBUTE12 = l_def_sif_rec.STREAM_INTERFACE_ATTRIBUTE12,
		STREAM_INTERFACE_ATTRIBUTE13 = l_def_sif_rec.STREAM_INTERFACE_ATTRIBUTE13,
		STREAM_INTERFACE_ATTRIBUTE14 = l_def_sif_rec.STREAM_INTERFACE_ATTRIBUTE14,
		STREAM_INTERFACE_ATTRIBUTE15 = l_def_sif_rec.STREAM_INTERFACE_ATTRIBUTE15,
		CREATED_BY = l_def_sif_rec.CREATED_BY,
		LAST_UPDATED_BY = l_def_sif_rec.LAST_UPDATED_BY,
		CREATION_DATE = l_def_sif_rec.CREATION_DATE,
		LAST_UPDATE_DATE = l_def_sif_rec.LAST_UPDATE_DATE,
		LAST_UPDATE_LOGIN = l_def_sif_rec.LAST_UPDATE_LOGIN,
            -- mvasudev -- 02/21/2002
            -- new columns added for concurrent program manager
		REQUEST_ID = l_def_sif_rec.REQUEST_ID,
		PROGRAM_APPLICATION_ID = l_def_sif_rec.PROGRAM_APPLICATION_ID,
		PROGRAM_ID = l_def_sif_rec.PROGRAM_ID,
		PROGRAM_UPDATE_DATE = l_def_sif_rec.PROGRAM_UPDATE_DATE,
            -- mvasudev -- 05/13/2002
                JTOT_OBJECT1_CODE = l_def_sif_rec.JTOT_OBJECT1_CODE,
                OBJECT1_ID1 = l_def_sif_rec.OBJECT1_ID1,
                OBJECT1_ID2 = l_def_sif_rec.OBJECT1_ID2,
                TERM = l_def_sif_rec.TERM,
                STRUCTURE = l_def_sif_rec.STRUCTURE,
                DEAL_TYPE = l_def_sif_rec.DEAL_TYPE,
                LOG_FILE = l_def_sif_rec.LOG_FILE,
                FIRST_PAYMENT = l_def_sif_rec.FIRST_PAYMENT,
                LAST_PAYMENT = l_def_sif_rec.LAST_PAYMENT,
                --  mvasudev, Bug#2650599
                SIF_ID = l_def_sif_rec.SIF_ID,
                PURPOSE_CODE = l_def_sif_rec.PURPOSE_CODE
                -- end, mvasudev, Bug#2650599
    WHERE ID = l_def_sif_rec.id;

Line: 3248


  END update_row;

Line: 3252


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_sifv_rec                     IN sifv_rec_type,
    x_sifv_rec                     OUT NOCOPY sifv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3262


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_update_row';

Line: 3276


      l_sifv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 3277


      l_sifv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 3278


      l_sifv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 3447


      IF (x_sifv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_sifv_rec.last_updated_by := l_sifv_rec.last_updated_by;

Line: 3455


      IF (x_sifv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_sifv_rec.last_update_date := l_sifv_rec.last_update_date;

Line: 3459


      IF (x_sifv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_sifv_rec.last_update_login := l_sifv_rec.last_update_login;

Line: 3477


      IF (x_sifv_rec.PROGRAM_UPDATE_DATE = OKC_API.G_MISS_DATE)
      THEN
        x_sifv_rec.PROGRAM_UPDATE_DATE := l_sifv_rec.PROGRAM_UPDATE_DATE;

Line: 3595


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_sif_rec,
      lx_sif_rec
    );

Line: 3642


  END update_row;

Line: 3646


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_sifv_tbl                     IN sifv_tbl_type,
    x_sifv_tbl                     OUT NOCOPY sifv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3656


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_update_row';

Line: 3670


        update_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_sifv_rec                     => p_sifv_tbl(i),
          x_sifv_rec                     => x_sifv_tbl(i));

Line: 3735


  END update_row;

Line: 3743


  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_sif_rec                      IN sif_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3751


    l_api_name                     CONSTANT VARCHAR2(30) := 'INTERFACES_delete_row';

Line: 3765


    DELETE FROM OKL_STREAM_INTERFACES
     WHERE ID = l_sif_rec.id;

Line: 3800


  END delete_row;

Line: 3804


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_sifv_rec                     IN sifv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3813


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_delete_row';

Line: 3837


    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_sif_rec
    );

Line: 3881


  END delete_row;

Line: 3885


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_sifv_tbl                     IN sifv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3894


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';

Line: 3909


        delete_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_sifv_rec                     => p_sifv_tbl(i));

Line: 3967


  END delete_row;