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_OIN_PVT SQL Statements

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

Line: 101


    SELECT
            ID,
            PARTY_ID,
            PARTY_NAME,
            PARTY_TYPE,
            DATE_OF_BIRTH,
            PLACE_OF_BIRTH,
            PERSON_IDENTIFIER,
            PERSON_IDEN_TYPE,
            COUNTRY,
            ADDRESS1,
            ADDRESS2,
            ADDRESS3,
            ADDRESS4,
            CITY,
            POSTAL_CODE,
            STATE,
            PROVINCE,
            COUNTY,
            PO_BOX_NUMBER,
            HOUSE_NUMBER,
            STREET_SUFFIX,
            APARTMENT_NUMBER,
            STREET,
            RURAL_ROUTE_NUMBER,
            STREET_NUMBER,
            BUILDING,
            FLOOR,
            SUITE,
            ROOM,
            POSTAL_PLUS4_CODE,
            CAS_ID,
            CASE_NUMBER,
            KHR_ID,
            CONTRACT_NUMBER,
            CONTRACT_TYPE,
            CONTRACT_STATUS,
            ORIGINAL_AMOUNT,
            START_DATE,
            CLOSE_DATE,
            TERM_DURATION,
            MONTHLY_PAYMENT_AMOUNT,
            LAST_PAYMENT_DATE,
            DELINQUENCY_OCCURANCE_DATE,
            PAST_DUE_AMOUNT,
            REMAINING_AMOUNT,
            CREDIT_INDICATOR,
            NOTIFICATION_DATE,
            CREDIT_BUREAU_REPORT_DATE,
            EXTERNAL_AGENCY_TRANSFER_DATE,
            EXTERNAL_AGENCY_RECALL_DATE,
            REFERRAL_NUMBER,
            CONTACT_ID,
            CONTACT_NAME,
            CONTACT_PHONE,
            CONTACT_EMAIL,
            OBJECT_VERSION_NUMBER,
            ORG_ID,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM OKL_OPEN_INT
     WHERE OKL_OPEN_INT.id    = p_id;

Line: 253


              l_oinv_rec.program_update_date,
              l_oinv_rec.attribute_category,
              l_oinv_rec.attribute1,
              l_oinv_rec.attribute2,
              l_oinv_rec.attribute3,
              l_oinv_rec.attribute4,
              l_oinv_rec.attribute5,
              l_oinv_rec.attribute6,
              l_oinv_rec.attribute7,
              l_oinv_rec.attribute8,
              l_oinv_rec.attribute9,
              l_oinv_rec.attribute10,
              l_oinv_rec.attribute11,
              l_oinv_rec.attribute12,
              l_oinv_rec.attribute13,
              l_oinv_rec.attribute14,
              l_oinv_rec.attribute15,
              l_oinv_rec.created_by,
              l_oinv_rec.creation_date,
              l_oinv_rec.last_updated_by,
              l_oinv_rec.last_update_date,
              l_oinv_rec.last_update_login;

Line: 316


    SELECT
            ID,
            PARTY_ID,
            PARTY_NAME,
            PARTY_TYPE,
            DATE_OF_BIRTH,
            PLACE_OF_BIRTH,
            PERSON_IDENTIFIER,
            PERSON_IDEN_TYPE,
            COUNTRY,
            ADDRESS1,
            ADDRESS2,
            ADDRESS3,
            ADDRESS4,
            CITY,
            POSTAL_CODE,
            STATE,
            PROVINCE,
            COUNTY,
            PO_BOX_NUMBER,
            HOUSE_NUMBER,
            STREET_SUFFIX,
            APARTMENT_NUMBER,
            STREET,
            RURAL_ROUTE_NUMBER,
            STREET_NUMBER,
            BUILDING,
            FLOOR,
            SUITE,
            ROOM,
            POSTAL_PLUS4_CODE,
            CAS_ID,
            CASE_NUMBER,
            KHR_ID,
            CONTRACT_NUMBER,
            CONTRACT_TYPE,
            CONTRACT_STATUS,
            ORIGINAL_AMOUNT,
            START_DATE,
            CLOSE_DATE,
            TERM_DURATION,
            MONTHLY_PAYMENT_AMOUNT,
            LAST_PAYMENT_DATE,
            DELINQUENCY_OCCURANCE_DATE,
            PAST_DUE_AMOUNT,
            REMAINING_AMOUNT,
            CREDIT_INDICATOR,
            NOTIFICATION_DATE,
            CREDIT_BUREAU_REPORT_DATE,
            EXTERNAL_AGENCY_TRANSFER_DATE,
            EXTERNAL_AGENCY_RECALL_DATE,
            REFERRAL_NUMBER,
            CONTACT_ID,
            CONTACT_NAME,
            CONTACT_PHONE,
            CONTACT_EMAIL,
            OBJECT_VERSION_NUMBER,
            ORG_ID,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Open_Int
     WHERE okl_open_int.id      = p_id;

Line: 468


              l_oin_rec.program_update_date,
              l_oin_rec.attribute_category,
              l_oin_rec.attribute1,
              l_oin_rec.attribute2,
              l_oin_rec.attribute3,
              l_oin_rec.attribute4,
              l_oin_rec.attribute5,
              l_oin_rec.attribute6,
              l_oin_rec.attribute7,
              l_oin_rec.attribute8,
              l_oin_rec.attribute9,
              l_oin_rec.attribute10,
              l_oin_rec.attribute11,
              l_oin_rec.attribute12,
              l_oin_rec.attribute13,
              l_oin_rec.attribute14,
              l_oin_rec.attribute15,
              l_oin_rec.created_by,
              l_oin_rec.creation_date,
              l_oin_rec.last_updated_by,
              l_oin_rec.last_update_date,
              l_oin_rec.last_update_login;

Line: 711


    IF (l_oinv_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
      l_oinv_rec.program_update_date := NULL;

Line: 768


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

Line: 771


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

Line: 774


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

Line: 1331


    p_to.program_update_date := p_from.program_update_date;

Line: 1350


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1351


    p_to.last_update_date := p_from.last_update_date;

Line: 1352


    p_to.last_update_login := p_from.last_update_login;

Line: 1419


    p_to.program_update_date := p_from.program_update_date;

Line: 1438


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1439


    p_to.last_update_date := p_from.last_update_date;

Line: 1440


    p_to.last_update_login := p_from.last_update_login;

Line: 1686


  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_oin_rec                      IN oin_rec_type,
    x_oin_rec                      OUT NOCOPY oin_rec_type) AS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1695


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

Line: 1731


    INSERT INTO OKL_OPEN_INT(
      id,
      party_id,
      party_name,
      party_type,
      date_of_birth,
      place_of_birth,
      person_identifier,
      person_iden_type,
      country,
      address1,
      address2,
      address3,
      address4,
      city,
      postal_code,
      state,
      province,
      county,
      po_box_number,
      house_number,
      street_suffix,
      apartment_number,
      street,
      rural_route_number,
      street_number,
      building,
      floor,
      suite,
      room,
      postal_plus4_code,
      cas_id,
      case_number,
      khr_id,
      contract_number,
      contract_type,
      contract_status,
      original_amount,
      start_date,
      close_date,
      term_duration,
      monthly_payment_amount,
      last_payment_date,
      delinquency_occurance_date,
      past_due_amount,
      remaining_amount,
      credit_indicator,
      notification_date,
      credit_bureau_report_date,
      external_agency_transfer_date,
      external_agency_recall_date,
      referral_number,
      contact_id,
      contact_name,
      contact_phone,
      contact_email,
      object_version_number,
      org_id,
      request_id,
      program_application_id,
      program_id,
      program_update_date,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login)
    VALUES (
      l_oin_rec.id,
      l_oin_rec.party_id,
      l_oin_rec.party_name,
      l_oin_rec.party_type,
      l_oin_rec.date_of_birth,
      l_oin_rec.place_of_birth,
      l_oin_rec.person_identifier,
      l_oin_rec.person_iden_type,
      l_oin_rec.country,
      l_oin_rec.address1,
      l_oin_rec.address2,
      l_oin_rec.address3,
      l_oin_rec.address4,
      l_oin_rec.city,
      l_oin_rec.postal_code,
      l_oin_rec.state,
      l_oin_rec.province,
      l_oin_rec.county,
      l_oin_rec.po_box_number,
      l_oin_rec.house_number,
      l_oin_rec.street_suffix,
      l_oin_rec.apartment_number,
      l_oin_rec.street,
      l_oin_rec.rural_route_number,
      l_oin_rec.street_number,
      l_oin_rec.building,
      l_oin_rec.floor,
      l_oin_rec.suite,
      l_oin_rec.room,
      l_oin_rec.postal_plus4_code,
      l_oin_rec.cas_id,
      l_oin_rec.case_number,
      l_oin_rec.khr_id,
      l_oin_rec.contract_number,
      l_oin_rec.contract_type,
      l_oin_rec.contract_status,
      l_oin_rec.original_amount,
      l_oin_rec.start_date,
      l_oin_rec.close_date,
      l_oin_rec.term_duration,
      l_oin_rec.monthly_payment_amount,
      l_oin_rec.last_payment_date,
      l_oin_rec.delinquency_occurance_date,
      l_oin_rec.past_due_amount,
      l_oin_rec.remaining_amount,
      l_oin_rec.credit_indicator,
      l_oin_rec.notification_date,
      l_oin_rec.credit_bureau_report_date,
      l_oin_rec.external_agency_transfer_date,
      l_oin_rec.external_agency_recall_date,
      l_oin_rec.referral_number,
      l_oin_rec.contact_id,
      l_oin_rec.contact_name,
      l_oin_rec.contact_phone,
      l_oin_rec.contact_email,
      l_oin_rec.object_version_number,
      l_oin_rec.org_id,
      l_oin_rec.request_id,
      l_oin_rec.program_application_id,
      l_oin_rec.program_id,
      l_oin_rec.program_update_date,
      l_oin_rec.attribute_category,
      l_oin_rec.attribute1,
      l_oin_rec.attribute2,
      l_oin_rec.attribute3,
      l_oin_rec.attribute4,
      l_oin_rec.attribute5,
      l_oin_rec.attribute6,
      l_oin_rec.attribute7,
      l_oin_rec.attribute8,
      l_oin_rec.attribute9,
      l_oin_rec.attribute10,
      l_oin_rec.attribute11,
      l_oin_rec.attribute12,
      l_oin_rec.attribute13,
      l_oin_rec.attribute14,
      l_oin_rec.attribute15,
      l_oin_rec.created_by,
      l_oin_rec.creation_date,
      l_oin_rec.last_updated_by,
      l_oin_rec.last_update_date,
      l_oin_rec.last_update_login);

Line: 1932


  END insert_row;

Line: 1936


  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_oinv_rec                     IN oinv_rec_type,
    x_oinv_rec                     OUT NOCOPY oinv_rec_type) AS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1946


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

Line: 1962


      l_oinv_rec.LAST_UPDATE_DATE := l_oinv_rec.CREATION_DATE;

Line: 1963


      l_oinv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1964


      l_oinv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1981


	  SELECT
	  		DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
	  		DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_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_oinv_rec.request_id,
	  	   x_oinv_rec.program_application_id,
	  	   x_oinv_rec.program_id,
	  	   x_oinv_rec.program_update_date
	  FROM dual;

Line: 2045


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_oin_rec,
      lx_oin_rec
    );

Line: 2094


  END insert_row;

Line: 2098


  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_oinv_tbl                     IN oinv_tbl_type,
    x_oinv_tbl                     OUT NOCOPY oinv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2109


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

Line: 2123


          insert_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_oinv_rec                     => p_oinv_tbl(i),
            x_oinv_rec                     => x_oinv_tbl(i));

Line: 2191


  END insert_row;

Line: 2196


  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_oinv_tbl                     IN oinv_tbl_type,
    x_oinv_tbl                     OUT NOCOPY oinv_tbl_type) AS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2206


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

Line: 2213


      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_oinv_tbl                     => p_oinv_tbl,
        x_oinv_tbl                     => x_oinv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2255


  END insert_row;

Line: 2273


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_OPEN_INT
     WHERE ID = p_oin_rec.id
       AND OBJECT_VERSION_NUMBER = p_oin_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 2280


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_OPEN_INT
     WHERE ID = p_oin_rec.id;

Line: 2321


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2330


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2610


  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_oin_rec                      IN oin_rec_type,
    x_oin_rec                      OUT NOCOPY oin_rec_type) AS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2619


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

Line: 2879


        IF (x_oin_rec.program_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_oin_rec.program_update_date := l_oin_rec.program_update_date;

Line: 2955


        IF (x_oin_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_oin_rec.last_updated_by := l_oin_rec.last_updated_by;

Line: 2959


        IF (x_oin_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_oin_rec.last_update_date := l_oin_rec.last_update_date;

Line: 2963


        IF (x_oin_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_oin_rec.last_update_login := l_oin_rec.last_update_login;

Line: 3009


    UPDATE OKL_OPEN_INT
    SET PARTY_ID = l_def_oin_rec.party_id,
        PARTY_NAME = l_def_oin_rec.party_name,
        PARTY_TYPE = l_def_oin_rec.party_type,
        DATE_OF_BIRTH = l_def_oin_rec.date_of_birth,
        PLACE_OF_BIRTH = l_def_oin_rec.place_of_birth,
        PERSON_IDENTIFIER = l_def_oin_rec.person_identifier,
        PERSON_IDEN_TYPE = l_def_oin_rec.person_iden_type,
        COUNTRY = l_def_oin_rec.country,
        ADDRESS1 = l_def_oin_rec.address1,
        ADDRESS2 = l_def_oin_rec.address2,
        ADDRESS3 = l_def_oin_rec.address3,
        ADDRESS4 = l_def_oin_rec.address4,
        CITY = l_def_oin_rec.city,
        POSTAL_CODE = l_def_oin_rec.postal_code,
        STATE = l_def_oin_rec.state,
        PROVINCE = l_def_oin_rec.province,
        COUNTY = l_def_oin_rec.county,
        PO_BOX_NUMBER = l_def_oin_rec.po_box_number,
        HOUSE_NUMBER = l_def_oin_rec.house_number,
        STREET_SUFFIX = l_def_oin_rec.street_suffix,
        APARTMENT_NUMBER = l_def_oin_rec.apartment_number,
        STREET = l_def_oin_rec.street,
        RURAL_ROUTE_NUMBER = l_def_oin_rec.rural_route_number,
        STREET_NUMBER = l_def_oin_rec.street_number,
        BUILDING = l_def_oin_rec.building,
        FLOOR = l_def_oin_rec.floor,
        SUITE = l_def_oin_rec.suite,
        ROOM = l_def_oin_rec.room,
        POSTAL_PLUS4_CODE = l_def_oin_rec.postal_plus4_code,
        CAS_ID = l_def_oin_rec.cas_id,
        CASE_NUMBER = l_def_oin_rec.case_number,
        KHR_ID = l_def_oin_rec.khr_id,
        CONTRACT_NUMBER = l_def_oin_rec.contract_number,
        CONTRACT_TYPE = l_def_oin_rec.contract_type,
        CONTRACT_STATUS = l_def_oin_rec.contract_status,
        ORIGINAL_AMOUNT = l_def_oin_rec.original_amount,
        START_DATE = l_def_oin_rec.start_date,
        CLOSE_DATE = l_def_oin_rec.close_date,
        TERM_DURATION = l_def_oin_rec.term_duration,
        MONTHLY_PAYMENT_AMOUNT = l_def_oin_rec.monthly_payment_amount,
        LAST_PAYMENT_DATE = l_def_oin_rec.last_payment_date,
        DELINQUENCY_OCCURANCE_DATE = l_def_oin_rec.delinquency_occurance_date,
        PAST_DUE_AMOUNT = l_def_oin_rec.past_due_amount,
        REMAINING_AMOUNT = l_def_oin_rec.remaining_amount,
        CREDIT_INDICATOR = l_def_oin_rec.credit_indicator,
        NOTIFICATION_DATE = l_def_oin_rec.notification_date,
        CREDIT_BUREAU_REPORT_DATE = l_def_oin_rec.credit_bureau_report_date,
        EXTERNAL_AGENCY_TRANSFER_DATE = l_def_oin_rec.external_agency_transfer_date,
        EXTERNAL_AGENCY_RECALL_DATE = l_def_oin_rec.external_agency_recall_date,
        REFERRAL_NUMBER = l_def_oin_rec.referral_number,
        CONTACT_ID = l_def_oin_rec.contact_id,
        CONTACT_NAME = l_def_oin_rec.contact_name,
        CONTACT_PHONE = l_def_oin_rec.contact_phone,
        CONTACT_EMAIL = l_def_oin_rec.contact_email,
        OBJECT_VERSION_NUMBER = l_def_oin_rec.object_version_number,
        ORG_ID = l_def_oin_rec.org_id,
        REQUEST_ID = l_def_oin_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_oin_rec.program_application_id,
        PROGRAM_ID = l_def_oin_rec.program_id,
        PROGRAM_UPDATE_DATE = l_def_oin_rec.program_update_date,
        ATTRIBUTE_CATEGORY = l_def_oin_rec.attribute_category,
        ATTRIBUTE1 = l_def_oin_rec.attribute1,
        ATTRIBUTE2 = l_def_oin_rec.attribute2,
        ATTRIBUTE3 = l_def_oin_rec.attribute3,
        ATTRIBUTE4 = l_def_oin_rec.attribute4,
        ATTRIBUTE5 = l_def_oin_rec.attribute5,
        ATTRIBUTE6 = l_def_oin_rec.attribute6,
        ATTRIBUTE7 = l_def_oin_rec.attribute7,
        ATTRIBUTE8 = l_def_oin_rec.attribute8,
        ATTRIBUTE9 = l_def_oin_rec.attribute9,
        ATTRIBUTE10 = l_def_oin_rec.attribute10,
        ATTRIBUTE11 = l_def_oin_rec.attribute11,
        ATTRIBUTE12 = l_def_oin_rec.attribute12,
        ATTRIBUTE13 = l_def_oin_rec.attribute13,
        ATTRIBUTE14 = l_def_oin_rec.attribute14,
        ATTRIBUTE15 = l_def_oin_rec.attribute15,
        CREATED_BY = l_def_oin_rec.created_by,
        CREATION_DATE = l_def_oin_rec.creation_date,
        LAST_UPDATED_BY = l_def_oin_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_oin_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_oin_rec.last_update_login
    WHERE ID = l_def_oin_rec.id;

Line: 3127


  END update_row;

Line: 3131


  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_oinv_rec                     IN oinv_rec_type,
    x_oinv_rec                     OUT NOCOPY oinv_rec_type) AS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3141


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

Line: 3156


      l_oinv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 3157


      l_oinv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 3158


      l_oinv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 3417


        IF (x_oinv_rec.program_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_oinv_rec.program_update_date := l_db_oinv_rec.program_update_date;

Line: 3493


        IF (x_oinv_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_oinv_rec.last_updated_by := l_db_oinv_rec.last_updated_by;

Line: 3497


        IF (x_oinv_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_oinv_rec.last_update_date := l_db_oinv_rec.last_update_date;

Line: 3501


        IF (x_oinv_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_oinv_rec.last_update_login := l_db_oinv_rec.last_update_login;

Line: 3521


        SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID), x_oinv_rec.request_id),
             NVL(DECODE(Fnd_Global.PROG_APPL_ID,   -1,NULL,Fnd_Global.PROG_APPL_ID), x_oinv_rec.program_application_id),
             NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID), x_oinv_rec.program_id),
             DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE), NULL,x_oinv_rec.program_update_date,SYSDATE)
        INTO
        x_oinv_rec.request_id,
        x_oinv_rec.program_application_id,
        x_oinv_rec.program_id,
        x_oinv_rec.program_update_date
        FROM   dual;

Line: 3604


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_oin_rec,
      lx_oin_rec
    );

Line: 3652


  END update_row;

Line: 3656


  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_oinv_tbl                     IN oinv_tbl_type,
    x_oinv_tbl                     OUT NOCOPY oinv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3667


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

Line: 3681


          update_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_oinv_rec                     => p_oinv_tbl(i),
            x_oinv_rec                     => x_oinv_tbl(i));

Line: 3749


  END update_row;

Line: 3754


  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_oinv_tbl                     IN oinv_tbl_type,
    x_oinv_tbl                     OUT NOCOPY oinv_tbl_type) AS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3764


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

Line: 3771


      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_oinv_tbl                     => p_oinv_tbl,
        x_oinv_tbl                     => x_oinv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3813


  END update_row;

Line: 3821


  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_oin_rec                      IN oin_rec_type) AS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3829


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

Line: 3844


    DELETE FROM OKL_OPEN_INT
     WHERE ID = p_oin_rec.id;

Line: 3880


  END delete_row;

Line: 3884


  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_oinv_rec                     IN oinv_rec_type) AS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3893


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

Line: 3917


    delete_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_oin_rec
    );

Line: 3962


  END delete_row;

Line: 3966


  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_oinv_tbl                     IN oinv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3976


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

Line: 3990


          delete_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_oinv_rec                     => p_oinv_tbl(i));

Line: 4057


  END delete_row;

Line: 4062


  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_oinv_tbl                     IN oinv_tbl_type) AS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 4071


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

Line: 4078


      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_oinv_tbl                     => p_oinv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 4119


  END delete_row;