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

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

Line: 99


    DELETE FROM OKL_PROPERTY_TAX_TL T
     WHERE NOT EXISTS (
        SELECT NULL
          FROM OKL_PROPERTY_TAX_ALL_B B --Changed _TL to _B by rvaduri for MLS compliance
         WHERE B.ID =T.ID
        );

Line: 106


    UPDATE OKL_PROPERTY_TAX_TL T SET(
        ASSET_DESCRIPTION) = (SELECT
                                  B.ASSET_DESCRIPTION
                                FROM OKL_PROPERTY_TAX_TL B
                               WHERE B.ID = T.ID
				AND B.LANGUAGE = T.SOURCE_LANG)
      WHERE ( T.ID, T.LANGUAGE)
          IN (SELECT
                  SUBT.ID
		 ,SUBT.LANGUAGE
                FROM OKL_PROPERTY_TAX_TL SUBB, OKL_PROPERTY_TAX_TL SUBT
               WHERE SUBB.ID = SUBT.ID
	         AND SUBB.LANGUAGE = SUBT.LANGUAGE
                 AND ( SUBB.ASSET_DESCRIPTION <> SUBT.ASSET_DESCRIPTION
                      OR (SUBB.LANGUAGE IS NOT NULL AND SUBT.LANGUAGE IS NULL)
                      OR (SUBB.ASSET_DESCRIPTION IS NULL AND SUBT.ASSET_DESCRIPTION IS NOT NULL)
              ));

Line: 124


    INSERT INTO OKL_PROPERTY_TAX_TL (
        ID,
        LANGUAGE,
        SOURCE_LANG,
        SFWT_FLAG,
        ASSET_DESCRIPTION,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN)
      SELECT
            B.ID,
            L.LANGUAGE_CODE,
            B.SOURCE_LANG,
            B.SFWT_FLAG,
            B.ASSET_DESCRIPTION,
            B.CREATED_BY,
            B.CREATION_DATE,
            B.LAST_UPDATED_BY,
            B.LAST_UPDATE_DATE,
            B.LAST_UPDATE_LOGIN
        FROM OKL_PROPERTY_TAX_TL B, FND_LANGUAGES L
       WHERE L.INSTALLED_FLAG IN ('I', 'B')
         AND B.LANGUAGE = USERENV('LANG')
         AND NOT EXISTS (
                    SELECT NULL
                      FROM OKL_PROPERTY_TAX_TL T
                     WHERE T.ID = B.ID
		-- Added as per Bug 2876076 by rvaduri
		     AND T.LANGUAGE = L.LANGUAGE_CODE
                    );

Line: 166


    SELECT
            ID,
            SEQUENCE_NUMBER,
            ASSET_ID,
            ASSET_NUMBER,
            ASSET_DESCRIPTION,
            KHR_ID,
            KLE_ID,
            ASSET_UNITS,
            LANGUAGE,
            SOURCE_LANG,
            SFWT_FLAG,
            ASSET_ADDRESS_1,
            ASSET_ADDRESS_2,
            ASSET_ADDRESS_3,
            ASSET_ADDRESS_4,
            ASSET_CITY,
            ASSET_STATE,
            ASSET_COUNTRY,
            TAX_ASSESSMENT_AMOUNT,
            TAX_JURISDICTION_CITY,
            TAX_JURISDICTION_CITY_RATE,
            TAX_JURISDICTION_COUNTY,
            TAX_JURISDICTION_COUNTY_RATE,
            TAX_JURISDICTION_STATE,
            TAX_JURISDICTION_STATE_RATE,
            TAX_JURISDICTION_SCHOOL,
            TAX_JURISDICTION_SCHOOL_RATE,
            TAX_JURISDICTION_COUNTRY,
            TAX_JURISDICTION_COUNTRY_RATE,
            TAX_ASSESSMENT_DATE,
            MILRATE,
            PROPERTY_TAX_AMOUNT,
            OEC,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
            ,contract_number
	    ,sty_name
	    ,sty_id
	    ,invoice_date
	    ,amount
        ,org_id
        ,JURSDCTN_TYPE
        ,JURSDCTN_NAME
        ,MLRT_TAX
        ,TAX_VENDOR_ID
        ,TAX_VENDOR_NAME
        ,TAX_VENDOR_SITE_ID
        ,TAX_VENDOR_SITE_NAME
      FROM OKL_PROPERTY_TAX_V
     WHERE OKL_PROPERTY_TAX_V.id = p_id;

Line: 262


              l_ptcv_rec.last_updated_by,
              l_ptcv_rec.last_update_date,
              l_ptcv_rec.last_update_login
              ,l_ptcv_rec.contract_number
	      ,l_ptcv_rec.sty_name
	      ,l_ptcv_rec.sty_id
	      ,l_ptcv_rec.invoice_date
	      ,l_ptcv_rec.amount
 	      ,l_ptcv_rec.org_id
          ,l_ptcv_rec.JURSDCTN_TYPE
          ,l_ptcv_rec.JURSDCTN_NAME
          ,l_ptcv_rec.MLRT_TAX
          ,l_ptcv_rec.TAX_VENDOR_ID
          ,l_ptcv_rec.TAX_VENDOR_NAME
          ,l_ptcv_rec.TAX_VENDOR_SITE_ID
          ,l_ptcv_rec.TAX_VENDOR_SITE_NAME;

Line: 319


    SELECT
            ID,
            SEQUENCE_NUMBER,
            ASSET_ID,
            ASSET_NUMBER,
            KHR_ID,
            KLE_ID,
            ASSET_UNITS,
            ASSET_ADDRESS_1,
            ASSET_ADDRESS_2,
            ASSET_ADDRESS_3,
            ASSET_ADDRESS_4,
            ASSET_CITY,
            ASSET_STATE,
            ASSET_COUNTRY,
            TAX_ASSESSMENT_AMOUNT,
            TAX_JURISDICTION_CITY,
            TAX_JURISDICTION_CITY_RATE,
            TAX_JURISDICTION_COUNTY,
            TAX_JURISDICTION_COUNTY_RATE,
            TAX_JURISDICTION_STATE,
            TAX_JURISDICTION_STATE_RATE,
            TAX_JURISDICTION_SCHOOL,
            TAX_JURISDICTION_SCHOOL_RATE,
            TAX_JURISDICTION_COUNTRY,
            TAX_JURISDICTION_COUNTRY_RATE,
            TAX_ASSESSMENT_DATE,
            MILRATE,
            PROPERTY_TAX_AMOUNT,
            OEC,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
            ,contract_number
	    ,sty_name
	    ,sty_id
	    ,invoice_date
	    ,amount
	    ,org_id
        ,JURSDCTN_TYPE
        ,JURSDCTN_NAME
        ,MLRT_TAX
        ,TAX_VENDOR_ID
        ,TAX_VENDOR_NAME
        ,TAX_VENDOR_SITE_ID
        ,TAX_VENDOR_SITE_NAME
      FROM OKL_PROPERTY_TAX_B
     WHERE okl_property_tax_b.id = p_id;

Line: 407


              l_ptc_rec.last_updated_by,
              l_ptc_rec.last_update_date,
              l_ptc_rec.last_update_login
             ,l_ptc_rec.contract_number
	     ,l_ptc_rec.sty_name
	     ,l_ptc_rec.sty_id
	     ,l_ptc_rec.invoice_date
	     ,l_ptc_rec.amount
	     ,l_ptc_rec.org_id
         ,l_ptc_rec.JURSDCTN_TYPE
         ,l_ptc_rec.JURSDCTN_NAME
         ,l_ptc_rec.MLRT_TAX
         ,l_ptc_rec.TAX_VENDOR_ID
         ,l_ptc_rec.TAX_VENDOR_NAME
         ,l_ptc_rec.TAX_VENDOR_SITE_ID
         ,l_ptc_rec.TAX_VENDOR_SITE_NAME;

Line: 464


    SELECT
            ID,
            LANGUAGE,
            SOURCE_LANG,
            SFWT_FLAG,
            ASSET_DESCRIPTION,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Property_Tax_Tl
     WHERE Okl_Property_Tax_Tl.id = p_id;

Line: 491


              l_ptct_rec.last_updated_by,
              l_ptct_rec.last_update_date,
              l_ptct_rec.last_update_login;

Line: 640


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

Line: 643


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

Line: 646


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

Line: 1036


      SELECT 'x'
        FROM Okl_K_Headers_V
       WHERE okl_k_headers_v.id   = p_id;

Line: 1042


      SELECT 'x'
        FROM Okl_K_Lines_V
       WHERE okl_k_lines_v.id     = p_id;

Line: 1136


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1137


    p_to.last_update_date := p_from.last_update_date;

Line: 1138


    p_to.last_update_login := p_from.last_update_login;

Line: 1191


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1192


    p_to.last_update_date := p_from.last_update_date;

Line: 1193


    p_to.last_update_login := p_from.last_update_login;

Line: 1223


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1224


    p_to.last_update_date := p_from.last_update_date;

Line: 1225


    p_to.last_update_login := p_from.last_update_login;

Line: 1239


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1240


    p_to.last_update_date := p_from.last_update_date;

Line: 1241


    p_to.last_update_login := p_from.last_update_login;

Line: 1487


  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_ptc_rec                      IN ptc_rec_type,
    x_ptc_rec                      OUT NOCOPY ptc_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1496


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

Line: 1532


    INSERT INTO OKL_PROPERTY_TAX_B(
      id,
      sequence_number,
      asset_id,
      asset_number,
      khr_id,
      kle_id,
      asset_units,
      asset_address_1,
      asset_address_2,
      asset_address_3,
      asset_address_4,
      asset_city,
      asset_state,
      asset_country,
      tax_assessment_amount,
      tax_jurisdiction_city,
      tax_jurisdiction_city_rate,
      tax_jurisdiction_county,
      tax_jurisdiction_county_rate,
      tax_jurisdiction_state,
      tax_jurisdiction_state_rate,
      tax_jurisdiction_school,
      tax_jurisdiction_school_rate,
      tax_jurisdiction_country,
      tax_jurisdiction_country_rate,
      tax_assessment_date,
      milrate,
      property_tax_amount,
      oec,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
      ,contract_number
      ,sty_name
      ,sty_id
      ,invoice_date
      ,amount
      ,org_id
      ,JURSDCTN_TYPE
      ,JURSDCTN_NAME
      ,MLRT_TAX
      ,TAX_VENDOR_ID
      ,TAX_VENDOR_NAME
      ,TAX_VENDOR_SITE_ID
      ,TAX_VENDOR_SITE_NAME
)
    VALUES (
      l_ptc_rec.id,
      l_ptc_rec.sequence_number,
      l_ptc_rec.asset_id,
      l_ptc_rec.asset_number,
      l_ptc_rec.khr_id,
      l_ptc_rec.kle_id,
      l_ptc_rec.asset_units,
      l_ptc_rec.asset_address_1,
      l_ptc_rec.asset_address_2,
      l_ptc_rec.asset_address_3,
      l_ptc_rec.asset_address_4,
      l_ptc_rec.asset_city,
      l_ptc_rec.asset_state,
      l_ptc_rec.asset_country,
      l_ptc_rec.tax_assessment_amount,
      l_ptc_rec.tax_jurisdiction_city,
      l_ptc_rec.tax_jurisdiction_city_rate,
      l_ptc_rec.tax_jurisdiction_county,
      l_ptc_rec.tax_jurisdiction_county_rate,
      l_ptc_rec.tax_jurisdiction_state,
      l_ptc_rec.tax_jurisdiction_state_rate,
      l_ptc_rec.tax_jurisdiction_school,
      l_ptc_rec.tax_jurisdiction_school_rate,
      l_ptc_rec.tax_jurisdiction_country,
      l_ptc_rec.tax_jurisdiction_country_rate,
      l_ptc_rec.tax_assessment_date,
      l_ptc_rec.milrate,
      l_ptc_rec.property_tax_amount,
      l_ptc_rec.oec,
      l_ptc_rec.created_by,
      l_ptc_rec.creation_date,
      l_ptc_rec.last_updated_by,
      l_ptc_rec.last_update_date,
      l_ptc_rec.last_update_login
      ,l_ptc_rec.contract_number
      ,l_ptc_rec.sty_name
      ,l_ptc_rec.sty_id
      ,l_ptc_rec.invoice_date
      ,l_ptc_rec.amount
      ,l_ptc_rec.org_id
      -- Addition for Est Property Tax
      ,l_ptc_rec.JURSDCTN_TYPE
      ,l_ptc_rec.JURSDCTN_NAME
      ,l_ptc_rec.MLRT_TAX
      ,l_ptc_rec.TAX_VENDOR_ID
      ,l_ptc_rec.TAX_VENDOR_NAME
      ,l_ptc_rec.TAX_VENDOR_SITE_ID
      ,l_ptc_rec.TAX_VENDOR_SITE_NAME
      -- End Addition for Est Property Tax
      );

Line: 1667


  END insert_row;

Line: 1671


  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_ptct_rec                     IN ptct_rec_type,
    x_ptct_rec                     OUT NOCOPY ptct_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1680


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

Line: 1685


      SELECT *
        FROM FND_LANGUAGES
       WHERE INSTALLED_FLAG IN ('I', 'B');

Line: 1724


      INSERT INTO OKL_PROPERTY_TAX_TL(
        id,
        language,
        source_lang,
        sfwt_flag,
        asset_description,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_ptct_rec.id,
        l_ptct_rec.language,
        l_ptct_rec.source_lang,
        l_ptct_rec.sfwt_flag,
        l_ptct_rec.asset_description,
        l_ptct_rec.created_by,
        l_ptct_rec.creation_date,
        l_ptct_rec.last_updated_by,
        l_ptct_rec.last_update_date,
        l_ptct_rec.last_update_login);

Line: 1782


  END insert_row;

Line: 1786


  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_ptcv_rec                     IN ptcv_rec_type,
    x_ptcv_rec                     OUT NOCOPY ptcv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1796


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

Line: 1814


      l_ptcv_rec.LAST_UPDATE_DATE := l_ptcv_rec.CREATION_DATE;

Line: 1815


      l_ptcv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1816


      l_ptcv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1881


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_ptc_rec,
      lx_ptc_rec
    );

Line: 1895


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_ptct_rec,
      lx_ptct_rec
    );

Line: 1944


  END insert_row;

Line: 1948


  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_ptcv_tbl                     IN ptcv_tbl_type,
    x_ptcv_tbl                     OUT NOCOPY ptcv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1959


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

Line: 1973


          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_ptcv_rec                     => p_ptcv_tbl(i),
            x_ptcv_rec                     => x_ptcv_tbl(i));

Line: 2041


  END insert_row;

Line: 2046


  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_ptcv_tbl                     IN ptcv_tbl_type,
    x_ptcv_tbl                     OUT NOCOPY ptcv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2056


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

Line: 2063


      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_ptcv_tbl                     => p_ptcv_tbl,
        x_ptcv_tbl                     => x_ptcv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2105


  END insert_row;

Line: 2123


    SELECT *
      FROM OKL_PROPERTY_TAX_B
     WHERE ID = p_ptc_rec.id
    FOR UPDATE NOWAIT;

Line: 2159


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2290


      IF (l_lock_var.last_updated_by <> p_ptc_rec.last_updated_by) THEN
        OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line: 2294


      IF (l_lock_var.last_update_date <> p_ptc_rec.last_update_date) THEN
        OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line: 2298


      IF (l_lock_var.last_update_login <> p_ptc_rec.last_update_login) THEN
        OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line: 2375


    SELECT *
      FROM OKL_PROPERTY_TAX_TL
     WHERE ID = p_ptct_rec.id
    FOR UPDATE NOWAIT;

Line: 2411


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2705


  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_ptc_rec                      IN ptc_rec_type,
    x_ptc_rec                      OUT NOCOPY ptc_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2714


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

Line: 2858


        IF (x_ptc_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_ptc_rec.last_updated_by := l_ptc_rec.last_updated_by;

Line: 2862


        IF (x_ptc_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_ptc_rec.last_update_date := l_ptc_rec.last_update_date;

Line: 2866


        IF (x_ptc_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_ptc_rec.last_update_login := l_ptc_rec.last_update_login;

Line: 2973


    UPDATE OKL_PROPERTY_TAX_B
    SET SEQUENCE_NUMBER = l_def_ptc_rec.sequence_number,
        ASSET_ID = l_def_ptc_rec.asset_id,
        ASSET_NUMBER = l_def_ptc_rec.asset_number,
        KHR_ID = l_def_ptc_rec.khr_id,
        KLE_ID = l_def_ptc_rec.kle_id,
        ASSET_UNITS = l_def_ptc_rec.asset_units,
        ASSET_ADDRESS_1 = l_def_ptc_rec.asset_address_1,
        ASSET_ADDRESS_2 = l_def_ptc_rec.asset_address_2,
        ASSET_ADDRESS_3 = l_def_ptc_rec.asset_address_3,
        ASSET_ADDRESS_4 = l_def_ptc_rec.asset_address_4,
        ASSET_CITY = l_def_ptc_rec.asset_city,
        ASSET_STATE = l_def_ptc_rec.asset_state,
        ASSET_COUNTRY = l_def_ptc_rec.asset_country,
        TAX_ASSESSMENT_AMOUNT = l_def_ptc_rec.tax_assessment_amount,
        TAX_JURISDICTION_CITY = l_def_ptc_rec.tax_jurisdiction_city,
        TAX_JURISDICTION_CITY_RATE = l_def_ptc_rec.tax_jurisdiction_city_rate,
        TAX_JURISDICTION_COUNTY = l_def_ptc_rec.tax_jurisdiction_county,
        TAX_JURISDICTION_COUNTY_RATE = l_def_ptc_rec.tax_jurisdiction_county_rate,
        TAX_JURISDICTION_STATE = l_def_ptc_rec.tax_jurisdiction_state,
        TAX_JURISDICTION_STATE_RATE = l_def_ptc_rec.tax_jurisdiction_state_rate,
        TAX_JURISDICTION_SCHOOL = l_def_ptc_rec.tax_jurisdiction_school,
        TAX_JURISDICTION_SCHOOL_RATE = l_def_ptc_rec.tax_jurisdiction_school_rate,
        TAX_JURISDICTION_COUNTRY = l_def_ptc_rec.tax_jurisdiction_country,
        TAX_JURISDICTION_COUNTRY_RATE = l_def_ptc_rec.tax_jurisdiction_country_rate,
        TAX_ASSESSMENT_DATE = l_def_ptc_rec.tax_assessment_date,
        MILRATE = l_def_ptc_rec.milrate,
        PROPERTY_TAX_AMOUNT = l_def_ptc_rec.property_tax_amount,
        OEC = l_def_ptc_rec.oec,
        CREATED_BY = l_def_ptc_rec.created_by,
        CREATION_DATE = l_def_ptc_rec.creation_date,
        LAST_UPDATED_BY = l_def_ptc_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_ptc_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_ptc_rec.last_update_login,
        contract_number = l_def_ptc_rec.contract_number,
        sty_name = l_def_ptc_rec.sty_name,
        sty_id = l_def_ptc_rec.sty_id,
        invoice_date = l_def_ptc_rec.invoice_date,
        amount = l_def_ptc_rec.amount,
        org_id = l_def_ptc_rec.org_id,
        -- Addition for Est Property Tax
        JURSDCTN_TYPE = l_def_ptc_rec.JURSDCTN_TYPE,
        JURSDCTN_NAME = l_def_ptc_rec.JURSDCTN_NAME,
        MLRT_TAX = l_def_ptc_rec.MLRT_TAX,
        TAX_VENDOR_ID = l_def_ptc_rec.TAX_VENDOR_ID,
        TAX_VENDOR_NAME = l_def_ptc_rec.TAX_VENDOR_NAME,
        TAX_VENDOR_SITE_ID = l_def_ptc_rec.TAX_VENDOR_SITE_ID,
        TAX_VENDOR_SITE_NAME = l_def_ptc_rec.TAX_VENDOR_SITE_NAME
        -- End Addition for Est Property Tax
    WHERE ID = l_def_ptc_rec.id;

Line: 3058


  END update_row;

Line: 3062


  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_ptct_rec                     IN ptct_rec_type,
    x_ptct_rec                     OUT NOCOPY ptct_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3071


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

Line: 3119


        IF (x_ptct_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_ptct_rec.last_updated_by := l_ptct_rec.last_updated_by;

Line: 3123


        IF (x_ptct_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_ptct_rec.last_update_date := l_ptct_rec.last_update_date;

Line: 3127


        IF (x_ptct_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_ptct_rec.last_update_login := l_ptct_rec.last_update_login;

Line: 3174


    UPDATE OKL_PROPERTY_TAX_TL
    SET ASSET_DESCRIPTION = l_def_ptct_rec.asset_description,
        SOURCE_LANG = l_def_ptct_rec.source_lang,-- Fix for bug 3637102
        CREATED_BY = l_def_ptct_rec.created_by,
        CREATION_DATE = l_def_ptct_rec.creation_date,
        LAST_UPDATED_BY = l_def_ptct_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_ptct_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_ptct_rec.last_update_login
    WHERE ID = l_def_ptct_rec.id
      AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);--Fix for bug 3637102

Line: 3186


    UPDATE OKL_PROPERTY_TAX_TL
    SET SFWT_FLAG = 'Y'
    WHERE ID = l_def_ptct_rec.id
      AND SOURCE_LANG <> USERENV('LANG');

Line: 3225


  END update_row;

Line: 3229


  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_ptcv_rec                     IN ptcv_rec_type,
    x_ptcv_rec                     OUT NOCOPY ptcv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3239


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

Line: 3256


      l_ptcv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 3257


      l_ptcv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 3258


      l_ptcv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 3417


        IF (x_ptcv_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_ptcv_rec.last_updated_by := l_db_ptcv_rec.last_updated_by;

Line: 3421


        IF (x_ptcv_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_ptcv_rec.last_update_date := l_db_ptcv_rec.last_update_date;

Line: 3425


        IF (x_ptcv_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_ptcv_rec.last_update_login := l_db_ptcv_rec.last_update_login;

Line: 3573


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_ptc_rec,
      lx_ptc_rec
    );

Line: 3587


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_ptct_rec,
      lx_ptct_rec
    );

Line: 3635


  END update_row;

Line: 3639


  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_ptcv_tbl                     IN ptcv_tbl_type,
    x_ptcv_tbl                     OUT NOCOPY ptcv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3650


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

Line: 3664


          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_ptcv_rec                     => p_ptcv_tbl(i),
            x_ptcv_rec                     => x_ptcv_tbl(i));

Line: 3732


  END update_row;

Line: 3737


  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_ptcv_tbl                     IN ptcv_tbl_type,
    x_ptcv_tbl                     OUT NOCOPY ptcv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3747


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

Line: 3754


      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_ptcv_tbl                     => p_ptcv_tbl,
        x_ptcv_tbl                     => x_ptcv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3796


  END update_row;

Line: 3804


  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_ptc_rec                      IN ptc_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3812


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

Line: 3827


    DELETE FROM OKL_PROPERTY_TAX_B
     WHERE ID = p_ptc_rec.id;

Line: 3863


  END delete_row;

Line: 3867


  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_ptct_rec                     IN ptct_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3875


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

Line: 3890


    DELETE FROM OKL_PROPERTY_TAX_TL
     WHERE ID = p_ptct_rec.id;

Line: 3926


  END delete_row;

Line: 3930


  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_ptcv_rec                     IN ptcv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3939


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

Line: 3965


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

Line: 3977


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

Line: 4022


  END delete_row;

Line: 4026


  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_ptcv_tbl                     IN ptcv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 4036


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

Line: 4050


          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_ptcv_rec                     => p_ptcv_tbl(i));

Line: 4117


  END delete_row;

Line: 4122


  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_ptcv_tbl                     IN ptcv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 4131


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

Line: 4138


      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_ptcv_tbl                     => p_ptcv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 4179


  END delete_row;