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_OPEN_INTERFACE_PVT dependencies on OKL_LINES_INTERFACE

Line 707: ,LINE_NUMBER OKL_LINES_INTERFACE.LINE_NUMBER%TYPE

703: SUBTYPE tlpv_rec_type IS okl_txl_assets_pub.tlpv_rec_type;
704:
705: TYPE intf_party_rec_type IS RECORD (
706: CONTRACT_NUMBER OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE
707: ,LINE_NUMBER OKL_LINES_INTERFACE.LINE_NUMBER%TYPE
708: --
709: ,PARTY_ID HZ_PARTIES.PARTY_ID%TYPE
710: ,PARTY_NUMBER HZ_PARTIES.PARTY_NUMBER%TYPE
711: ,PARTY_NAME HZ_PARTIES.PARTY_NAME%TYPE

Line 1843: FROM OKL_LINES_INTERFACE OLI

1839: CURSOR release_csr (p_contract_number VARCHAR2,
1840: p_asset_number VARCHAR2,
1841: p_org_id NUMBER) IS
1842: SELECT 'Y'
1843: FROM OKL_LINES_INTERFACE OLI
1844: WHERE oli.contract_number_old = p_contract_number
1845: AND EXISTS ( SELECT fa.asset_id
1846: FROM FA_ADDITIONS_B FA,
1847: OKL_ASSET_RETURNS_B OAR,

Line 1890: FROM OKL_LINES_INTERFACE OLI

1886: CURSOR unrelease_csr (p_asset_number VARCHAR2,
1887: p_org_id NUMBER) IS
1888:
1889: SELECT 'Y'
1890: FROM OKL_LINES_INTERFACE OLI
1891: WHERE oli.contract_number_old = p_contract_number
1892: AND NOT EXISTS (SELECT fa.asset_id
1893: FROM FA_ADDITIONS_B FA,
1894: OKL_ASSET_RETURNS_B OAR,

Line 2013: FROM OKL_LINES_INTERFACE OLI

2009: ) IS
2010:
2011: CURSOR legacy_balance_csr (p_contract_number VARCHAR2) IS
2012: SELECT 'Y'
2013: FROM OKL_LINES_INTERFACE OLI
2014: WHERE oli.contract_number_old = p_contract_number
2015: AND oli.line_type = 'ASSET'
2016: AND oli.dt_effective_balance_legacy IS NOT NULL
2017: AND EXISTS ( SELECT 'Y'

Line 2018: FROM OKL_LINES_INTERFACE OLI1

2014: WHERE oli.contract_number_old = p_contract_number
2015: AND oli.line_type = 'ASSET'
2016: AND oli.dt_effective_balance_legacy IS NOT NULL
2017: AND EXISTS ( SELECT 'Y'
2018: FROM OKL_LINES_INTERFACE OLI1
2019: WHERE oli1.contract_number_old = p_contract_number
2020: AND oli1.line_type = 'ASSET'
2021: AND (oli1.dt_effective_balance_legacy IS NULL OR
2022: oli1.dt_effective_balance_legacy <> oli.dt_effective_balance_legacy)

Line 2094: p_line_number IN okl_lines_interface.line_number%TYPE,

2090: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
2091: p_import_request_stage IN okl_header_interface.import_request_stage%TYPE,
2092: p_product_id IN okl_header_interface.product_id%TYPE,
2093: p_product_name IN okl_header_interface.product_name%TYPE,
2094: p_line_number IN okl_lines_interface.line_number%TYPE,
2095: p_line_type IN okl_lines_interface.line_type%TYPE,
2096: p_amount IN okl_lines_interface.amount%TYPE,
2097: p_currency_code IN okl_lines_interface.currency_code%TYPE,
2098: p_asset_number IN okl_lines_interface.asset_number%TYPE,

Line 2095: p_line_type IN okl_lines_interface.line_type%TYPE,

2091: p_import_request_stage IN okl_header_interface.import_request_stage%TYPE,
2092: p_product_id IN okl_header_interface.product_id%TYPE,
2093: p_product_name IN okl_header_interface.product_name%TYPE,
2094: p_line_number IN okl_lines_interface.line_number%TYPE,
2095: p_line_type IN okl_lines_interface.line_type%TYPE,
2096: p_amount IN okl_lines_interface.amount%TYPE,
2097: p_currency_code IN okl_lines_interface.currency_code%TYPE,
2098: p_asset_number IN okl_lines_interface.asset_number%TYPE,
2099: p_inventory_item_name IN okl_lines_interface.inventory_item_name%TYPE,

Line 2096: p_amount IN okl_lines_interface.amount%TYPE,

2092: p_product_id IN okl_header_interface.product_id%TYPE,
2093: p_product_name IN okl_header_interface.product_name%TYPE,
2094: p_line_number IN okl_lines_interface.line_number%TYPE,
2095: p_line_type IN okl_lines_interface.line_type%TYPE,
2096: p_amount IN okl_lines_interface.amount%TYPE,
2097: p_currency_code IN okl_lines_interface.currency_code%TYPE,
2098: p_asset_number IN okl_lines_interface.asset_number%TYPE,
2099: p_inventory_item_name IN okl_lines_interface.inventory_item_name%TYPE,
2100: p_inventory_item_id IN okl_lines_interface.inventory_item_id%TYPE,

Line 2097: p_currency_code IN okl_lines_interface.currency_code%TYPE,

2093: p_product_name IN okl_header_interface.product_name%TYPE,
2094: p_line_number IN okl_lines_interface.line_number%TYPE,
2095: p_line_type IN okl_lines_interface.line_type%TYPE,
2096: p_amount IN okl_lines_interface.amount%TYPE,
2097: p_currency_code IN okl_lines_interface.currency_code%TYPE,
2098: p_asset_number IN okl_lines_interface.asset_number%TYPE,
2099: p_inventory_item_name IN okl_lines_interface.inventory_item_name%TYPE,
2100: p_inventory_item_id IN okl_lines_interface.inventory_item_id%TYPE,
2101: p_install_site_number IN okl_lines_interface.install_site_number%TYPE,

Line 2098: p_asset_number IN okl_lines_interface.asset_number%TYPE,

2094: p_line_number IN okl_lines_interface.line_number%TYPE,
2095: p_line_type IN okl_lines_interface.line_type%TYPE,
2096: p_amount IN okl_lines_interface.amount%TYPE,
2097: p_currency_code IN okl_lines_interface.currency_code%TYPE,
2098: p_asset_number IN okl_lines_interface.asset_number%TYPE,
2099: p_inventory_item_name IN okl_lines_interface.inventory_item_name%TYPE,
2100: p_inventory_item_id IN okl_lines_interface.inventory_item_id%TYPE,
2101: p_install_site_number IN okl_lines_interface.install_site_number%TYPE,
2102: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,

Line 2099: p_inventory_item_name IN okl_lines_interface.inventory_item_name%TYPE,

2095: p_line_type IN okl_lines_interface.line_type%TYPE,
2096: p_amount IN okl_lines_interface.amount%TYPE,
2097: p_currency_code IN okl_lines_interface.currency_code%TYPE,
2098: p_asset_number IN okl_lines_interface.asset_number%TYPE,
2099: p_inventory_item_name IN okl_lines_interface.inventory_item_name%TYPE,
2100: p_inventory_item_id IN okl_lines_interface.inventory_item_id%TYPE,
2101: p_install_site_number IN okl_lines_interface.install_site_number%TYPE,
2102: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
2103: p_asset_corporate_book IN okl_lines_interface.asset_corporate_book%TYPE,

Line 2100: p_inventory_item_id IN okl_lines_interface.inventory_item_id%TYPE,

2096: p_amount IN okl_lines_interface.amount%TYPE,
2097: p_currency_code IN okl_lines_interface.currency_code%TYPE,
2098: p_asset_number IN okl_lines_interface.asset_number%TYPE,
2099: p_inventory_item_name IN okl_lines_interface.inventory_item_name%TYPE,
2100: p_inventory_item_id IN okl_lines_interface.inventory_item_id%TYPE,
2101: p_install_site_number IN okl_lines_interface.install_site_number%TYPE,
2102: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
2103: p_asset_corporate_book IN okl_lines_interface.asset_corporate_book%TYPE,
2104: p_asset_category_id IN okl_lines_interface.asset_category_id%TYPE,

Line 2101: p_install_site_number IN okl_lines_interface.install_site_number%TYPE,

2097: p_currency_code IN okl_lines_interface.currency_code%TYPE,
2098: p_asset_number IN okl_lines_interface.asset_number%TYPE,
2099: p_inventory_item_name IN okl_lines_interface.inventory_item_name%TYPE,
2100: p_inventory_item_id IN okl_lines_interface.inventory_item_id%TYPE,
2101: p_install_site_number IN okl_lines_interface.install_site_number%TYPE,
2102: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
2103: p_asset_corporate_book IN okl_lines_interface.asset_corporate_book%TYPE,
2104: p_asset_category_id IN okl_lines_interface.asset_category_id%TYPE,
2105: p_asset_category_segment1 IN okl_lines_interface.asset_category_segment1%TYPE,

Line 2102: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,

2098: p_asset_number IN okl_lines_interface.asset_number%TYPE,
2099: p_inventory_item_name IN okl_lines_interface.inventory_item_name%TYPE,
2100: p_inventory_item_id IN okl_lines_interface.inventory_item_id%TYPE,
2101: p_install_site_number IN okl_lines_interface.install_site_number%TYPE,
2102: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
2103: p_asset_corporate_book IN okl_lines_interface.asset_corporate_book%TYPE,
2104: p_asset_category_id IN okl_lines_interface.asset_category_id%TYPE,
2105: p_asset_category_segment1 IN okl_lines_interface.asset_category_segment1%TYPE,
2106: p_asset_category_segment2 IN okl_lines_interface.asset_category_segment2%TYPE,

Line 2103: p_asset_corporate_book IN okl_lines_interface.asset_corporate_book%TYPE,

2099: p_inventory_item_name IN okl_lines_interface.inventory_item_name%TYPE,
2100: p_inventory_item_id IN okl_lines_interface.inventory_item_id%TYPE,
2101: p_install_site_number IN okl_lines_interface.install_site_number%TYPE,
2102: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
2103: p_asset_corporate_book IN okl_lines_interface.asset_corporate_book%TYPE,
2104: p_asset_category_id IN okl_lines_interface.asset_category_id%TYPE,
2105: p_asset_category_segment1 IN okl_lines_interface.asset_category_segment1%TYPE,
2106: p_asset_category_segment2 IN okl_lines_interface.asset_category_segment2%TYPE,
2107: p_asset_category_segment3 IN okl_lines_interface.asset_category_segment3%TYPE,

Line 2104: p_asset_category_id IN okl_lines_interface.asset_category_id%TYPE,

2100: p_inventory_item_id IN okl_lines_interface.inventory_item_id%TYPE,
2101: p_install_site_number IN okl_lines_interface.install_site_number%TYPE,
2102: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
2103: p_asset_corporate_book IN okl_lines_interface.asset_corporate_book%TYPE,
2104: p_asset_category_id IN okl_lines_interface.asset_category_id%TYPE,
2105: p_asset_category_segment1 IN okl_lines_interface.asset_category_segment1%TYPE,
2106: p_asset_category_segment2 IN okl_lines_interface.asset_category_segment2%TYPE,
2107: p_asset_category_segment3 IN okl_lines_interface.asset_category_segment3%TYPE,
2108: p_asset_category_segment4 IN okl_lines_interface.asset_category_segment4%TYPE,

Line 2105: p_asset_category_segment1 IN okl_lines_interface.asset_category_segment1%TYPE,

2101: p_install_site_number IN okl_lines_interface.install_site_number%TYPE,
2102: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
2103: p_asset_corporate_book IN okl_lines_interface.asset_corporate_book%TYPE,
2104: p_asset_category_id IN okl_lines_interface.asset_category_id%TYPE,
2105: p_asset_category_segment1 IN okl_lines_interface.asset_category_segment1%TYPE,
2106: p_asset_category_segment2 IN okl_lines_interface.asset_category_segment2%TYPE,
2107: p_asset_category_segment3 IN okl_lines_interface.asset_category_segment3%TYPE,
2108: p_asset_category_segment4 IN okl_lines_interface.asset_category_segment4%TYPE,
2109: p_asset_category_segment5 IN okl_lines_interface.asset_category_segment5%TYPE,

Line 2106: p_asset_category_segment2 IN okl_lines_interface.asset_category_segment2%TYPE,

2102: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
2103: p_asset_corporate_book IN okl_lines_interface.asset_corporate_book%TYPE,
2104: p_asset_category_id IN okl_lines_interface.asset_category_id%TYPE,
2105: p_asset_category_segment1 IN okl_lines_interface.asset_category_segment1%TYPE,
2106: p_asset_category_segment2 IN okl_lines_interface.asset_category_segment2%TYPE,
2107: p_asset_category_segment3 IN okl_lines_interface.asset_category_segment3%TYPE,
2108: p_asset_category_segment4 IN okl_lines_interface.asset_category_segment4%TYPE,
2109: p_asset_category_segment5 IN okl_lines_interface.asset_category_segment5%TYPE,
2110: p_asset_category_segment6 IN okl_lines_interface.asset_category_segment6%TYPE,

Line 2107: p_asset_category_segment3 IN okl_lines_interface.asset_category_segment3%TYPE,

2103: p_asset_corporate_book IN okl_lines_interface.asset_corporate_book%TYPE,
2104: p_asset_category_id IN okl_lines_interface.asset_category_id%TYPE,
2105: p_asset_category_segment1 IN okl_lines_interface.asset_category_segment1%TYPE,
2106: p_asset_category_segment2 IN okl_lines_interface.asset_category_segment2%TYPE,
2107: p_asset_category_segment3 IN okl_lines_interface.asset_category_segment3%TYPE,
2108: p_asset_category_segment4 IN okl_lines_interface.asset_category_segment4%TYPE,
2109: p_asset_category_segment5 IN okl_lines_interface.asset_category_segment5%TYPE,
2110: p_asset_category_segment6 IN okl_lines_interface.asset_category_segment6%TYPE,
2111: p_asset_category_segment7 IN okl_lines_interface.asset_category_segment7%TYPE,

Line 2108: p_asset_category_segment4 IN okl_lines_interface.asset_category_segment4%TYPE,

2104: p_asset_category_id IN okl_lines_interface.asset_category_id%TYPE,
2105: p_asset_category_segment1 IN okl_lines_interface.asset_category_segment1%TYPE,
2106: p_asset_category_segment2 IN okl_lines_interface.asset_category_segment2%TYPE,
2107: p_asset_category_segment3 IN okl_lines_interface.asset_category_segment3%TYPE,
2108: p_asset_category_segment4 IN okl_lines_interface.asset_category_segment4%TYPE,
2109: p_asset_category_segment5 IN okl_lines_interface.asset_category_segment5%TYPE,
2110: p_asset_category_segment6 IN okl_lines_interface.asset_category_segment6%TYPE,
2111: p_asset_category_segment7 IN okl_lines_interface.asset_category_segment7%TYPE,
2112: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,

Line 2109: p_asset_category_segment5 IN okl_lines_interface.asset_category_segment5%TYPE,

2105: p_asset_category_segment1 IN okl_lines_interface.asset_category_segment1%TYPE,
2106: p_asset_category_segment2 IN okl_lines_interface.asset_category_segment2%TYPE,
2107: p_asset_category_segment3 IN okl_lines_interface.asset_category_segment3%TYPE,
2108: p_asset_category_segment4 IN okl_lines_interface.asset_category_segment4%TYPE,
2109: p_asset_category_segment5 IN okl_lines_interface.asset_category_segment5%TYPE,
2110: p_asset_category_segment6 IN okl_lines_interface.asset_category_segment6%TYPE,
2111: p_asset_category_segment7 IN okl_lines_interface.asset_category_segment7%TYPE,
2112: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,
2113: p_asset_location_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,

Line 2110: p_asset_category_segment6 IN okl_lines_interface.asset_category_segment6%TYPE,

2106: p_asset_category_segment2 IN okl_lines_interface.asset_category_segment2%TYPE,
2107: p_asset_category_segment3 IN okl_lines_interface.asset_category_segment3%TYPE,
2108: p_asset_category_segment4 IN okl_lines_interface.asset_category_segment4%TYPE,
2109: p_asset_category_segment5 IN okl_lines_interface.asset_category_segment5%TYPE,
2110: p_asset_category_segment6 IN okl_lines_interface.asset_category_segment6%TYPE,
2111: p_asset_category_segment7 IN okl_lines_interface.asset_category_segment7%TYPE,
2112: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,
2113: p_asset_location_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,
2114: p_asset_location_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,

Line 2111: p_asset_category_segment7 IN okl_lines_interface.asset_category_segment7%TYPE,

2107: p_asset_category_segment3 IN okl_lines_interface.asset_category_segment3%TYPE,
2108: p_asset_category_segment4 IN okl_lines_interface.asset_category_segment4%TYPE,
2109: p_asset_category_segment5 IN okl_lines_interface.asset_category_segment5%TYPE,
2110: p_asset_category_segment6 IN okl_lines_interface.asset_category_segment6%TYPE,
2111: p_asset_category_segment7 IN okl_lines_interface.asset_category_segment7%TYPE,
2112: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,
2113: p_asset_location_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,
2114: p_asset_location_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,
2115: p_asset_location_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,

Line 2112: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,

2108: p_asset_category_segment4 IN okl_lines_interface.asset_category_segment4%TYPE,
2109: p_asset_category_segment5 IN okl_lines_interface.asset_category_segment5%TYPE,
2110: p_asset_category_segment6 IN okl_lines_interface.asset_category_segment6%TYPE,
2111: p_asset_category_segment7 IN okl_lines_interface.asset_category_segment7%TYPE,
2112: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,
2113: p_asset_location_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,
2114: p_asset_location_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,
2115: p_asset_location_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,
2116: p_asset_location_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,

Line 2113: p_asset_location_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,

2109: p_asset_category_segment5 IN okl_lines_interface.asset_category_segment5%TYPE,
2110: p_asset_category_segment6 IN okl_lines_interface.asset_category_segment6%TYPE,
2111: p_asset_category_segment7 IN okl_lines_interface.asset_category_segment7%TYPE,
2112: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,
2113: p_asset_location_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,
2114: p_asset_location_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,
2115: p_asset_location_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,
2116: p_asset_location_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,
2117: p_asset_location_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,

Line 2114: p_asset_location_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,

2110: p_asset_category_segment6 IN okl_lines_interface.asset_category_segment6%TYPE,
2111: p_asset_category_segment7 IN okl_lines_interface.asset_category_segment7%TYPE,
2112: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,
2113: p_asset_location_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,
2114: p_asset_location_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,
2115: p_asset_location_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,
2116: p_asset_location_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,
2117: p_asset_location_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,
2118: p_asset_location_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,

Line 2115: p_asset_location_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,

2111: p_asset_category_segment7 IN okl_lines_interface.asset_category_segment7%TYPE,
2112: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,
2113: p_asset_location_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,
2114: p_asset_location_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,
2115: p_asset_location_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,
2116: p_asset_location_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,
2117: p_asset_location_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,
2118: p_asset_location_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
2119: p_asset_location_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,

Line 2116: p_asset_location_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,

2112: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,
2113: p_asset_location_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,
2114: p_asset_location_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,
2115: p_asset_location_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,
2116: p_asset_location_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,
2117: p_asset_location_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,
2118: p_asset_location_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
2119: p_asset_location_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
2120: p_depreciation_method_id IN okl_lines_interface.depreciation_method_id%TYPE,

Line 2117: p_asset_location_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,

2113: p_asset_location_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,
2114: p_asset_location_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,
2115: p_asset_location_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,
2116: p_asset_location_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,
2117: p_asset_location_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,
2118: p_asset_location_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
2119: p_asset_location_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
2120: p_depreciation_method_id IN okl_lines_interface.depreciation_method_id%TYPE,
2121: p_depreciation_method_code IN okl_lines_interface.depreciation_method_code%TYPE,

Line 2118: p_asset_location_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,

2114: p_asset_location_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,
2115: p_asset_location_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,
2116: p_asset_location_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,
2117: p_asset_location_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,
2118: p_asset_location_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
2119: p_asset_location_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
2120: p_depreciation_method_id IN okl_lines_interface.depreciation_method_id%TYPE,
2121: p_depreciation_method_code IN okl_lines_interface.depreciation_method_code%TYPE,
2122: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,

Line 2119: p_asset_location_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,

2115: p_asset_location_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,
2116: p_asset_location_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,
2117: p_asset_location_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,
2118: p_asset_location_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
2119: p_asset_location_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
2120: p_depreciation_method_id IN okl_lines_interface.depreciation_method_id%TYPE,
2121: p_depreciation_method_code IN okl_lines_interface.depreciation_method_code%TYPE,
2122: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,
2123: p_fee_code IN okl_lines_interface.fee_code%TYPE,

Line 2120: p_depreciation_method_id IN okl_lines_interface.depreciation_method_id%TYPE,

2116: p_asset_location_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,
2117: p_asset_location_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,
2118: p_asset_location_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
2119: p_asset_location_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
2120: p_depreciation_method_id IN okl_lines_interface.depreciation_method_id%TYPE,
2121: p_depreciation_method_code IN okl_lines_interface.depreciation_method_code%TYPE,
2122: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,
2123: p_fee_code IN okl_lines_interface.fee_code%TYPE,
2124: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,

Line 2121: p_depreciation_method_code IN okl_lines_interface.depreciation_method_code%TYPE,

2117: p_asset_location_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,
2118: p_asset_location_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
2119: p_asset_location_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
2120: p_depreciation_method_id IN okl_lines_interface.depreciation_method_id%TYPE,
2121: p_depreciation_method_code IN okl_lines_interface.depreciation_method_code%TYPE,
2122: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,
2123: p_fee_code IN okl_lines_interface.fee_code%TYPE,
2124: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
2125: p_fee_type IN okl_lines_interface.fee_type%TYPE,

Line 2122: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,

2118: p_asset_location_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
2119: p_asset_location_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
2120: p_depreciation_method_id IN okl_lines_interface.depreciation_method_id%TYPE,
2121: p_depreciation_method_code IN okl_lines_interface.depreciation_method_code%TYPE,
2122: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,
2123: p_fee_code IN okl_lines_interface.fee_code%TYPE,
2124: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
2125: p_fee_type IN okl_lines_interface.fee_type%TYPE,
2126: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,

Line 2123: p_fee_code IN okl_lines_interface.fee_code%TYPE,

2119: p_asset_location_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
2120: p_depreciation_method_id IN okl_lines_interface.depreciation_method_id%TYPE,
2121: p_depreciation_method_code IN okl_lines_interface.depreciation_method_code%TYPE,
2122: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,
2123: p_fee_code IN okl_lines_interface.fee_code%TYPE,
2124: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
2125: p_fee_type IN okl_lines_interface.fee_type%TYPE,
2126: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,
2127: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,

Line 2124: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,

2120: p_depreciation_method_id IN okl_lines_interface.depreciation_method_id%TYPE,
2121: p_depreciation_method_code IN okl_lines_interface.depreciation_method_code%TYPE,
2122: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,
2123: p_fee_code IN okl_lines_interface.fee_code%TYPE,
2124: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
2125: p_fee_type IN okl_lines_interface.fee_type%TYPE,
2126: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,
2127: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,
2128: p_counter_group_name IN okl_lines_interface.counter_group_name%TYPE,

Line 2125: p_fee_type IN okl_lines_interface.fee_type%TYPE,

2121: p_depreciation_method_code IN okl_lines_interface.depreciation_method_code%TYPE,
2122: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,
2123: p_fee_code IN okl_lines_interface.fee_code%TYPE,
2124: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
2125: p_fee_type IN okl_lines_interface.fee_type%TYPE,
2126: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,
2127: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,
2128: p_counter_group_name IN okl_lines_interface.counter_group_name%TYPE,
2129: p_counter_group_id IN okl_lines_interface.counter_group_id%TYPE,

Line 2126: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,

2122: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,
2123: p_fee_code IN okl_lines_interface.fee_code%TYPE,
2124: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
2125: p_fee_type IN okl_lines_interface.fee_type%TYPE,
2126: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,
2127: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,
2128: p_counter_group_name IN okl_lines_interface.counter_group_name%TYPE,
2129: p_counter_group_id IN okl_lines_interface.counter_group_id%TYPE,
2130: p_usage_bill_frequency_code IN okl_lines_interface.usage_bill_frequency_code%TYPE,

Line 2127: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,

2123: p_fee_code IN okl_lines_interface.fee_code%TYPE,
2124: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
2125: p_fee_type IN okl_lines_interface.fee_type%TYPE,
2126: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,
2127: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,
2128: p_counter_group_name IN okl_lines_interface.counter_group_name%TYPE,
2129: p_counter_group_id IN okl_lines_interface.counter_group_id%TYPE,
2130: p_usage_bill_frequency_code IN okl_lines_interface.usage_bill_frequency_code%TYPE,
2131: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,

Line 2128: p_counter_group_name IN okl_lines_interface.counter_group_name%TYPE,

2124: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
2125: p_fee_type IN okl_lines_interface.fee_type%TYPE,
2126: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,
2127: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,
2128: p_counter_group_name IN okl_lines_interface.counter_group_name%TYPE,
2129: p_counter_group_id IN okl_lines_interface.counter_group_id%TYPE,
2130: p_usage_bill_frequency_code IN okl_lines_interface.usage_bill_frequency_code%TYPE,
2131: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,
2132: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,

Line 2129: p_counter_group_id IN okl_lines_interface.counter_group_id%TYPE,

2125: p_fee_type IN okl_lines_interface.fee_type%TYPE,
2126: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,
2127: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,
2128: p_counter_group_name IN okl_lines_interface.counter_group_name%TYPE,
2129: p_counter_group_id IN okl_lines_interface.counter_group_id%TYPE,
2130: p_usage_bill_frequency_code IN okl_lines_interface.usage_bill_frequency_code%TYPE,
2131: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,
2132: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,
2133: p_usage_period IN okl_lines_interface.usage_period%TYPE,

Line 2130: p_usage_bill_frequency_code IN okl_lines_interface.usage_bill_frequency_code%TYPE,

2126: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,
2127: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,
2128: p_counter_group_name IN okl_lines_interface.counter_group_name%TYPE,
2129: p_counter_group_id IN okl_lines_interface.counter_group_id%TYPE,
2130: p_usage_bill_frequency_code IN okl_lines_interface.usage_bill_frequency_code%TYPE,
2131: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,
2132: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,
2133: p_usage_period IN okl_lines_interface.usage_period%TYPE,
2134: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,

Line 2131: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,

2127: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,
2128: p_counter_group_name IN okl_lines_interface.counter_group_name%TYPE,
2129: p_counter_group_id IN okl_lines_interface.counter_group_id%TYPE,
2130: p_usage_bill_frequency_code IN okl_lines_interface.usage_bill_frequency_code%TYPE,
2131: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,
2132: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,
2133: p_usage_period IN okl_lines_interface.usage_period%TYPE,
2134: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,
2135: p_tax_cost IN okl_lines_interface.tax_cost%TYPE,

Line 2132: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,

2128: p_counter_group_name IN okl_lines_interface.counter_group_name%TYPE,
2129: p_counter_group_id IN okl_lines_interface.counter_group_id%TYPE,
2130: p_usage_bill_frequency_code IN okl_lines_interface.usage_bill_frequency_code%TYPE,
2131: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,
2132: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,
2133: p_usage_period IN okl_lines_interface.usage_period%TYPE,
2134: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,
2135: p_tax_cost IN okl_lines_interface.tax_cost%TYPE,
2136: p_tax_book IN okl_lines_interface.tax_book%TYPE,

Line 2133: p_usage_period IN okl_lines_interface.usage_period%TYPE,

2129: p_counter_group_id IN okl_lines_interface.counter_group_id%TYPE,
2130: p_usage_bill_frequency_code IN okl_lines_interface.usage_bill_frequency_code%TYPE,
2131: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,
2132: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,
2133: p_usage_period IN okl_lines_interface.usage_period%TYPE,
2134: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,
2135: p_tax_cost IN okl_lines_interface.tax_cost%TYPE,
2136: p_tax_book IN okl_lines_interface.tax_book%TYPE,
2137: p_life_in_months_tax IN okl_lines_interface.life_in_months_tax%TYPE,

Line 2134: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,

2130: p_usage_bill_frequency_code IN okl_lines_interface.usage_bill_frequency_code%TYPE,
2131: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,
2132: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,
2133: p_usage_period IN okl_lines_interface.usage_period%TYPE,
2134: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,
2135: p_tax_cost IN okl_lines_interface.tax_cost%TYPE,
2136: p_tax_book IN okl_lines_interface.tax_book%TYPE,
2137: p_life_in_months_tax IN okl_lines_interface.life_in_months_tax%TYPE,
2138: p_deprn_method_tax IN okl_lines_interface.deprn_method_tax%TYPE,

Line 2135: p_tax_cost IN okl_lines_interface.tax_cost%TYPE,

2131: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,
2132: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,
2133: p_usage_period IN okl_lines_interface.usage_period%TYPE,
2134: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,
2135: p_tax_cost IN okl_lines_interface.tax_cost%TYPE,
2136: p_tax_book IN okl_lines_interface.tax_book%TYPE,
2137: p_life_in_months_tax IN okl_lines_interface.life_in_months_tax%TYPE,
2138: p_deprn_method_tax IN okl_lines_interface.deprn_method_tax%TYPE,
2139: p_deprn_rate_tax IN okl_lines_interface.deprn_rate_tax%TYPE,

Line 2136: p_tax_book IN okl_lines_interface.tax_book%TYPE,

2132: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,
2133: p_usage_period IN okl_lines_interface.usage_period%TYPE,
2134: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,
2135: p_tax_cost IN okl_lines_interface.tax_cost%TYPE,
2136: p_tax_book IN okl_lines_interface.tax_book%TYPE,
2137: p_life_in_months_tax IN okl_lines_interface.life_in_months_tax%TYPE,
2138: p_deprn_method_tax IN okl_lines_interface.deprn_method_tax%TYPE,
2139: p_deprn_rate_tax IN okl_lines_interface.deprn_rate_tax%TYPE,
2140: p_in_service_date IN okl_lines_interface.in_service_date%TYPE,

Line 2137: p_life_in_months_tax IN okl_lines_interface.life_in_months_tax%TYPE,

2133: p_usage_period IN okl_lines_interface.usage_period%TYPE,
2134: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,
2135: p_tax_cost IN okl_lines_interface.tax_cost%TYPE,
2136: p_tax_book IN okl_lines_interface.tax_book%TYPE,
2137: p_life_in_months_tax IN okl_lines_interface.life_in_months_tax%TYPE,
2138: p_deprn_method_tax IN okl_lines_interface.deprn_method_tax%TYPE,
2139: p_deprn_rate_tax IN okl_lines_interface.deprn_rate_tax%TYPE,
2140: p_in_service_date IN okl_lines_interface.in_service_date%TYPE,
2141: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,

Line 2138: p_deprn_method_tax IN okl_lines_interface.deprn_method_tax%TYPE,

2134: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,
2135: p_tax_cost IN okl_lines_interface.tax_cost%TYPE,
2136: p_tax_book IN okl_lines_interface.tax_book%TYPE,
2137: p_life_in_months_tax IN okl_lines_interface.life_in_months_tax%TYPE,
2138: p_deprn_method_tax IN okl_lines_interface.deprn_method_tax%TYPE,
2139: p_deprn_rate_tax IN okl_lines_interface.deprn_rate_tax%TYPE,
2140: p_in_service_date IN okl_lines_interface.in_service_date%TYPE,
2141: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,
2142: p_inv_org_id IN okl_header_interface.inventory_organization_id%TYPE,

Line 2139: p_deprn_rate_tax IN okl_lines_interface.deprn_rate_tax%TYPE,

2135: p_tax_cost IN okl_lines_interface.tax_cost%TYPE,
2136: p_tax_book IN okl_lines_interface.tax_book%TYPE,
2137: p_life_in_months_tax IN okl_lines_interface.life_in_months_tax%TYPE,
2138: p_deprn_method_tax IN okl_lines_interface.deprn_method_tax%TYPE,
2139: p_deprn_rate_tax IN okl_lines_interface.deprn_rate_tax%TYPE,
2140: p_in_service_date IN okl_lines_interface.in_service_date%TYPE,
2141: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,
2142: p_inv_org_id IN okl_header_interface.inventory_organization_id%TYPE,
2143: p_term_quote_id IN okl_lines_interface.termination_quote_id%TYPE,

Line 2140: p_in_service_date IN okl_lines_interface.in_service_date%TYPE,

2136: p_tax_book IN okl_lines_interface.tax_book%TYPE,
2137: p_life_in_months_tax IN okl_lines_interface.life_in_months_tax%TYPE,
2138: p_deprn_method_tax IN okl_lines_interface.deprn_method_tax%TYPE,
2139: p_deprn_rate_tax IN okl_lines_interface.deprn_rate_tax%TYPE,
2140: p_in_service_date IN okl_lines_interface.in_service_date%TYPE,
2141: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,
2142: p_inv_org_id IN okl_header_interface.inventory_organization_id%TYPE,
2143: p_term_quote_id IN okl_lines_interface.termination_quote_id%TYPE,
2144: p_term_quote_number IN okl_lines_interface.termination_quote_number%TYPE,

Line 2141: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,

2137: p_life_in_months_tax IN okl_lines_interface.life_in_months_tax%TYPE,
2138: p_deprn_method_tax IN okl_lines_interface.deprn_method_tax%TYPE,
2139: p_deprn_rate_tax IN okl_lines_interface.deprn_rate_tax%TYPE,
2140: p_in_service_date IN okl_lines_interface.in_service_date%TYPE,
2141: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,
2142: p_inv_org_id IN okl_header_interface.inventory_organization_id%TYPE,
2143: p_term_quote_id IN okl_lines_interface.termination_quote_id%TYPE,
2144: p_term_quote_number IN okl_lines_interface.termination_quote_number%TYPE,
2145: p_fee_purpose_code IN okl_lines_interface.fee_purpose_code%TYPE,

Line 2143: p_term_quote_id IN okl_lines_interface.termination_quote_id%TYPE,

2139: p_deprn_rate_tax IN okl_lines_interface.deprn_rate_tax%TYPE,
2140: p_in_service_date IN okl_lines_interface.in_service_date%TYPE,
2141: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,
2142: p_inv_org_id IN okl_header_interface.inventory_organization_id%TYPE,
2143: p_term_quote_id IN okl_lines_interface.termination_quote_id%TYPE,
2144: p_term_quote_number IN okl_lines_interface.termination_quote_number%TYPE,
2145: p_fee_purpose_code IN okl_lines_interface.fee_purpose_code%TYPE,
2146: --Bug# 16344245
2147: p_amount_balance_legacy IN okl_lines_interface.amount_balance_legacy%TYPE,

Line 2144: p_term_quote_number IN okl_lines_interface.termination_quote_number%TYPE,

2140: p_in_service_date IN okl_lines_interface.in_service_date%TYPE,
2141: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,
2142: p_inv_org_id IN okl_header_interface.inventory_organization_id%TYPE,
2143: p_term_quote_id IN okl_lines_interface.termination_quote_id%TYPE,
2144: p_term_quote_number IN okl_lines_interface.termination_quote_number%TYPE,
2145: p_fee_purpose_code IN okl_lines_interface.fee_purpose_code%TYPE,
2146: --Bug# 16344245
2147: p_amount_balance_legacy IN okl_lines_interface.amount_balance_legacy%TYPE,
2148: p_dt_effective_balance_legacy IN okl_lines_interface.dt_effective_balance_legacy%TYPE

Line 2145: p_fee_purpose_code IN okl_lines_interface.fee_purpose_code%TYPE,

2141: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,
2142: p_inv_org_id IN okl_header_interface.inventory_organization_id%TYPE,
2143: p_term_quote_id IN okl_lines_interface.termination_quote_id%TYPE,
2144: p_term_quote_number IN okl_lines_interface.termination_quote_number%TYPE,
2145: p_fee_purpose_code IN okl_lines_interface.fee_purpose_code%TYPE,
2146: --Bug# 16344245
2147: p_amount_balance_legacy IN okl_lines_interface.amount_balance_legacy%TYPE,
2148: p_dt_effective_balance_legacy IN okl_lines_interface.dt_effective_balance_legacy%TYPE
2149: ) IS

Line 2147: p_amount_balance_legacy IN okl_lines_interface.amount_balance_legacy%TYPE,

2143: p_term_quote_id IN okl_lines_interface.termination_quote_id%TYPE,
2144: p_term_quote_number IN okl_lines_interface.termination_quote_number%TYPE,
2145: p_fee_purpose_code IN okl_lines_interface.fee_purpose_code%TYPE,
2146: --Bug# 16344245
2147: p_amount_balance_legacy IN okl_lines_interface.amount_balance_legacy%TYPE,
2148: p_dt_effective_balance_legacy IN okl_lines_interface.dt_effective_balance_legacy%TYPE
2149: ) IS
2150: -- 4475344
2151: /*

Line 2148: p_dt_effective_balance_legacy IN okl_lines_interface.dt_effective_balance_legacy%TYPE

2144: p_term_quote_number IN okl_lines_interface.termination_quote_number%TYPE,
2145: p_fee_purpose_code IN okl_lines_interface.fee_purpose_code%TYPE,
2146: --Bug# 16344245
2147: p_amount_balance_legacy IN okl_lines_interface.amount_balance_legacy%TYPE,
2148: p_dt_effective_balance_legacy IN okl_lines_interface.dt_effective_balance_legacy%TYPE
2149: ) IS
2150: -- 4475344
2151: /*
2152: CURSOR srv_supp_csr(p_contract_number OKL_PARTY_ROLES_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,

Line 2836: -- line number in OKL_LINES_INTERFACE table

2832:
2833: ------------------------------------------------------------------------------
2834: -- PROCEDURE check_contract_line
2835: -- It validates Party role line number/ Terms Line number/ Payments line number against contract
2836: -- line number in OKL_LINES_INTERFACE table
2837: -- Calls:
2838: -- None
2839: -- Called By:
2840: -- check_payment_record

Line 2852: FROM okl_lines_interface

2848:
2849: CURSOR line_csr (p_contract_number VARCHAR2,
2850: p_line_number NUMBER) IS
2851: SELECT 'X'
2852: FROM okl_lines_interface
2853: WHERE contract_number_old = p_contract_number
2854: AND line_number = p_line_number;
2855:
2856: l_dummy VARCHAR2(1);

Line 3262: FROM okl_lines_interface

3258: --
3259:
3260: CURSOR okl_line_csr (p_contract_number_old okc_k_headers_v.contract_number%TYPE) IS
3261: SELECT *
3262: FROM okl_lines_interface
3263: WHERE contract_number_old = p_contract_number_old
3264: ORDER BY line_number;
3265:
3266: --

Line 4078: p_line_number IN okl_lines_interface.line_number%TYPE,

4074: x_return_status OUT NOCOPY VARCHAR2,
4075: x_msg_count OUT NOCOPY NUMBER,
4076: x_msg_data OUT NOCOPY VARCHAR2,
4077: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
4078: p_line_number IN okl_lines_interface.line_number%TYPE,
4079: x_vendor_id OUT NOCOPY NUMBER,
4080: p_vendor_name IN OKX_VENDORS_V.NAME%TYPE
4081: ) IS
4082:

Line 4154: p_line_number IN okl_lines_interface.line_number%TYPE,

4150: x_return_status OUT NOCOPY VARCHAR2,
4151: x_msg_count OUT NOCOPY NUMBER,
4152: x_msg_data OUT NOCOPY VARCHAR2,
4153: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
4154: p_line_number IN okl_lines_interface.line_number%TYPE,
4155: p_party_id IN OKX_PARTIES_V.ID1%TYPE,
4156: p_party_number IN OKX_PARTIES_V.PARTY_NUMBER%TYPE,
4157: x_party_id OUT NOCOPY NUMBER
4158: ) IS

Line 4782: p_line_number IN OKL_LINES_INTERFACE.LINE_NUMBER%TYPE,

4778: ------------------------------------------------------------------------------
4779: FUNCTION get_payment_term(
4780: x_return_status OUT NOCOPY VARCHAR2,
4781: p_contract_number IN OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,
4782: p_line_number IN OKL_LINES_INTERFACE.LINE_NUMBER%TYPE,
4783: p_payment_term IN OKL_LINES_INTERFACE.PAYMENT_TERM%TYPE,
4784: p_payment_term_id IN OKL_LINES_INTERFACE.PAYMENT_TERM_ID%TYPE
4785: )
4786: RETURN NUMBER IS

Line 4783: p_payment_term IN OKL_LINES_INTERFACE.PAYMENT_TERM%TYPE,

4779: FUNCTION get_payment_term(
4780: x_return_status OUT NOCOPY VARCHAR2,
4781: p_contract_number IN OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,
4782: p_line_number IN OKL_LINES_INTERFACE.LINE_NUMBER%TYPE,
4783: p_payment_term IN OKL_LINES_INTERFACE.PAYMENT_TERM%TYPE,
4784: p_payment_term_id IN OKL_LINES_INTERFACE.PAYMENT_TERM_ID%TYPE
4785: )
4786: RETURN NUMBER IS
4787:

Line 4784: p_payment_term_id IN OKL_LINES_INTERFACE.PAYMENT_TERM_ID%TYPE

4780: x_return_status OUT NOCOPY VARCHAR2,
4781: p_contract_number IN OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,
4782: p_line_number IN OKL_LINES_INTERFACE.LINE_NUMBER%TYPE,
4783: p_payment_term IN OKL_LINES_INTERFACE.PAYMENT_TERM%TYPE,
4784: p_payment_term_id IN OKL_LINES_INTERFACE.PAYMENT_TERM_ID%TYPE
4785: )
4786: RETURN NUMBER IS
4787:
4788: CURSOR term_csr (p_payment_term VARCHAR2,

Line 4840: p_line_number IN OKL_LINES_INTERFACE.LINE_NUMBER%TYPE,

4836: ------------------------------------------------------------------------------
4837: FUNCTION get_vendor_paysite(
4838: x_return_status OUT NOCOPY VARCHAR2,
4839: p_contract_number IN OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,
4840: p_line_number IN OKL_LINES_INTERFACE.LINE_NUMBER%TYPE,
4841: p_vendor_paysite_name IN OKL_LINES_INTERFACE.VENDOR_PAYSITE_NAME%TYPE,
4842: p_vendor_paysite_id IN OKL_LINES_INTERFACE.VENDOR_PAYSITE_ID%TYPE
4843: )
4844: RETURN NUMBER IS

Line 4841: p_vendor_paysite_name IN OKL_LINES_INTERFACE.VENDOR_PAYSITE_NAME%TYPE,

4837: FUNCTION get_vendor_paysite(
4838: x_return_status OUT NOCOPY VARCHAR2,
4839: p_contract_number IN OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,
4840: p_line_number IN OKL_LINES_INTERFACE.LINE_NUMBER%TYPE,
4841: p_vendor_paysite_name IN OKL_LINES_INTERFACE.VENDOR_PAYSITE_NAME%TYPE,
4842: p_vendor_paysite_id IN OKL_LINES_INTERFACE.VENDOR_PAYSITE_ID%TYPE
4843: )
4844: RETURN NUMBER IS
4845: CURSOR site_csr (p_name VARCHAR2,

Line 4842: p_vendor_paysite_id IN OKL_LINES_INTERFACE.VENDOR_PAYSITE_ID%TYPE

4838: x_return_status OUT NOCOPY VARCHAR2,
4839: p_contract_number IN OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,
4840: p_line_number IN OKL_LINES_INTERFACE.LINE_NUMBER%TYPE,
4841: p_vendor_paysite_name IN OKL_LINES_INTERFACE.VENDOR_PAYSITE_NAME%TYPE,
4842: p_vendor_paysite_id IN OKL_LINES_INTERFACE.VENDOR_PAYSITE_ID%TYPE
4843: )
4844: RETURN NUMBER IS
4845: CURSOR site_csr (p_name VARCHAR2,
4846: p_id NUMBER) IS

Line 5533: p_line_type IN okl_lines_interface.line_type%TYPE,

5529: p_chr_id IN okc_k_headers_v.id%TYPE,
5530: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
5531: p_cle_id IN okl_k_lines_v.id%TYPE,
5532: p_line_number IN okc_k_lines_v.line_number%TYPE,
5533: p_line_type IN okl_lines_interface.line_type%TYPE,
5534: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,
5535: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
5536: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,
5537: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,

Line 5534: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,

5530: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
5531: p_cle_id IN okl_k_lines_v.id%TYPE,
5532: p_line_number IN okc_k_lines_v.line_number%TYPE,
5533: p_line_type IN okl_lines_interface.line_type%TYPE,
5534: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,
5535: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
5536: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,
5537: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,
5538: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,

Line 5535: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,

5531: p_cle_id IN okl_k_lines_v.id%TYPE,
5532: p_line_number IN okc_k_lines_v.line_number%TYPE,
5533: p_line_type IN okl_lines_interface.line_type%TYPE,
5534: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,
5535: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
5536: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,
5537: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,
5538: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,
5539: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,

Line 5536: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,

5532: p_line_number IN okc_k_lines_v.line_number%TYPE,
5533: p_line_type IN okl_lines_interface.line_type%TYPE,
5534: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,
5535: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
5536: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,
5537: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,
5538: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,
5539: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,
5540: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,

Line 5537: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,

5533: p_line_type IN okl_lines_interface.line_type%TYPE,
5534: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,
5535: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
5536: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,
5537: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,
5538: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,
5539: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,
5540: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,
5541: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,

Line 5538: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,

5534: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,
5535: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
5536: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,
5537: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,
5538: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,
5539: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,
5540: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,
5541: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,
5542: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,

Line 5539: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,

5535: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
5536: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,
5537: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,
5538: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,
5539: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,
5540: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,
5541: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,
5542: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,
5543: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,

Line 5540: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,

5536: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,
5537: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,
5538: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,
5539: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,
5540: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,
5541: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,
5542: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,
5543: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,
5544: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,

Line 5541: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,

5537: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,
5538: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,
5539: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,
5540: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,
5541: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,
5542: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,
5543: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,
5544: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,
5545: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,

Line 5542: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,

5538: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,
5539: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,
5540: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,
5541: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,
5542: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,
5543: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,
5544: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,
5545: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,
5546: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,

Line 5543: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,

5539: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,
5540: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,
5541: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,
5542: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,
5543: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,
5544: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,
5545: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,
5546: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,
5547: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,

Line 5544: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,

5540: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,
5541: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,
5542: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,
5543: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,
5544: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,
5545: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,
5546: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,
5547: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,
5548: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,

Line 5545: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,

5541: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,
5542: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,
5543: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,
5544: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,
5545: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,
5546: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,
5547: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,
5548: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,
5549: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,

Line 5546: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,

5542: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,
5543: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,
5544: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,
5545: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,
5546: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,
5547: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,
5548: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,
5549: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,
5550: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,

Line 5547: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,

5543: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,
5544: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,
5545: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,
5546: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,
5547: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,
5548: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,
5549: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,
5550: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,
5551: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,

Line 5548: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,

5544: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,
5545: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,
5546: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,
5547: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,
5548: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,
5549: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,
5550: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,
5551: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,
5552: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,

Line 5549: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,

5545: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,
5546: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,
5547: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,
5548: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,
5549: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,
5550: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,
5551: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,
5552: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,
5553: p_french_tax_name IN okl_lines_interface.french_tax_name%TYPE,

Line 5550: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,

5546: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,
5547: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,
5548: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,
5549: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,
5550: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,
5551: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,
5552: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,
5553: p_french_tax_name IN okl_lines_interface.french_tax_name%TYPE,
5554: p_prop_tax_bill_method IN okl_lines_interface.prop_tax_bill_method%TYPE,

Line 5551: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,

5547: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,
5548: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,
5549: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,
5550: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,
5551: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,
5552: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,
5553: p_french_tax_name IN okl_lines_interface.french_tax_name%TYPE,
5554: p_prop_tax_bill_method IN okl_lines_interface.prop_tax_bill_method%TYPE,
5555: p_prop_tax_as_contract_yn IN okl_lines_interface.prop_tax_as_contract_yn%TYPE ) IS

Line 5552: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,

5548: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,
5549: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,
5550: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,
5551: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,
5552: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,
5553: p_french_tax_name IN okl_lines_interface.french_tax_name%TYPE,
5554: p_prop_tax_bill_method IN okl_lines_interface.prop_tax_bill_method%TYPE,
5555: p_prop_tax_as_contract_yn IN okl_lines_interface.prop_tax_as_contract_yn%TYPE ) IS
5556:

Line 5553: p_french_tax_name IN okl_lines_interface.french_tax_name%TYPE,

5549: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,
5550: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,
5551: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,
5552: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,
5553: p_french_tax_name IN okl_lines_interface.french_tax_name%TYPE,
5554: p_prop_tax_bill_method IN okl_lines_interface.prop_tax_bill_method%TYPE,
5555: p_prop_tax_as_contract_yn IN okl_lines_interface.prop_tax_as_contract_yn%TYPE ) IS
5556:
5557: line_rule_failed EXCEPTION;

Line 5554: p_prop_tax_bill_method IN okl_lines_interface.prop_tax_bill_method%TYPE,

5550: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,
5551: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,
5552: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,
5553: p_french_tax_name IN okl_lines_interface.french_tax_name%TYPE,
5554: p_prop_tax_bill_method IN okl_lines_interface.prop_tax_bill_method%TYPE,
5555: p_prop_tax_as_contract_yn IN okl_lines_interface.prop_tax_as_contract_yn%TYPE ) IS
5556:
5557: line_rule_failed EXCEPTION;
5558: rule_group_failed EXCEPTION;

Line 5555: p_prop_tax_as_contract_yn IN okl_lines_interface.prop_tax_as_contract_yn%TYPE ) IS

5551: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,
5552: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,
5553: p_french_tax_name IN okl_lines_interface.french_tax_name%TYPE,
5554: p_prop_tax_bill_method IN okl_lines_interface.prop_tax_bill_method%TYPE,
5555: p_prop_tax_as_contract_yn IN okl_lines_interface.prop_tax_as_contract_yn%TYPE ) IS
5556:
5557: line_rule_failed EXCEPTION;
5558: rule_group_failed EXCEPTION;
5559: rule_failed EXCEPTION;

Line 6048: p_line_type IN okl_lines_interface.line_type%TYPE,

6044: p_chr_id IN okc_k_headers_v.id%TYPE,
6045: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
6046: p_cle_id IN okl_k_lines_v.id%TYPE,
6047: p_line_number IN okc_k_lines_v.line_number%TYPE,
6048: p_line_type IN okl_lines_interface.line_type%TYPE,
6049: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,
6050: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
6051: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,
6052: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,

Line 6049: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,

6045: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
6046: p_cle_id IN okl_k_lines_v.id%TYPE,
6047: p_line_number IN okc_k_lines_v.line_number%TYPE,
6048: p_line_type IN okl_lines_interface.line_type%TYPE,
6049: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,
6050: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
6051: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,
6052: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,
6053: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,

Line 6050: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,

6046: p_cle_id IN okl_k_lines_v.id%TYPE,
6047: p_line_number IN okc_k_lines_v.line_number%TYPE,
6048: p_line_type IN okl_lines_interface.line_type%TYPE,
6049: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,
6050: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
6051: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,
6052: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,
6053: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,
6054: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,

Line 6051: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,

6047: p_line_number IN okc_k_lines_v.line_number%TYPE,
6048: p_line_type IN okl_lines_interface.line_type%TYPE,
6049: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,
6050: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
6051: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,
6052: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,
6053: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,
6054: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,
6055: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,

Line 6052: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,

6048: p_line_type IN okl_lines_interface.line_type%TYPE,
6049: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,
6050: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
6051: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,
6052: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,
6053: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,
6054: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,
6055: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,
6056: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,

Line 6053: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,

6049: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,
6050: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
6051: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,
6052: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,
6053: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,
6054: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,
6055: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,
6056: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,
6057: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,

Line 6054: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,

6050: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
6051: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,
6052: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,
6053: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,
6054: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,
6055: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,
6056: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,
6057: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,
6058: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,

Line 6055: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,

6051: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,
6052: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,
6053: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,
6054: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,
6055: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,
6056: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,
6057: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,
6058: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,
6059: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,

Line 6056: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,

6052: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,
6053: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,
6054: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,
6055: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,
6056: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,
6057: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,
6058: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,
6059: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,
6060: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,

Line 6057: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,

6053: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,
6054: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,
6055: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,
6056: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,
6057: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,
6058: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,
6059: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,
6060: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,
6061: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,

Line 6058: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,

6054: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,
6055: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,
6056: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,
6057: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,
6058: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,
6059: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,
6060: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,
6061: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,
6062: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,

Line 6059: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,

6055: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,
6056: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,
6057: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,
6058: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,
6059: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,
6060: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,
6061: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,
6062: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,
6063: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,

Line 6060: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,

6056: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,
6057: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,
6058: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,
6059: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,
6060: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,
6061: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,
6062: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,
6063: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,
6064: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,

Line 6061: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,

6057: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,
6058: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,
6059: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,
6060: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,
6061: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,
6062: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,
6063: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,
6064: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,
6065: p_lien_type IN okl_lines_interface.lien_type%TYPE,

Line 6062: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,

6058: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,
6059: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,
6060: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,
6061: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,
6062: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,
6063: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,
6064: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,
6065: p_lien_type IN okl_lines_interface.lien_type%TYPE,
6066: p_lien_filing_number IN okl_lines_interface.lien_filing_number%TYPE,

Line 6063: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,

6059: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,
6060: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,
6061: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,
6062: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,
6063: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,
6064: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,
6065: p_lien_type IN okl_lines_interface.lien_type%TYPE,
6066: p_lien_filing_number IN okl_lines_interface.lien_filing_number%TYPE,
6067: p_lien_filing_date IN okl_lines_interface.lien_filing_date%TYPE,

Line 6064: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,

6060: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,
6061: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,
6062: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,
6063: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,
6064: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,
6065: p_lien_type IN okl_lines_interface.lien_type%TYPE,
6066: p_lien_filing_number IN okl_lines_interface.lien_filing_number%TYPE,
6067: p_lien_filing_date IN okl_lines_interface.lien_filing_date%TYPE,
6068: p_lien_filing_status IN okl_lines_interface.lien_filing_status%TYPE,

Line 6065: p_lien_type IN okl_lines_interface.lien_type%TYPE,

6061: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,
6062: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,
6063: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,
6064: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,
6065: p_lien_type IN okl_lines_interface.lien_type%TYPE,
6066: p_lien_filing_number IN okl_lines_interface.lien_filing_number%TYPE,
6067: p_lien_filing_date IN okl_lines_interface.lien_filing_date%TYPE,
6068: p_lien_filing_status IN okl_lines_interface.lien_filing_status%TYPE,
6069: p_lienholder_id IN okl_lines_interface.lienholder_id%TYPE,

Line 6066: p_lien_filing_number IN okl_lines_interface.lien_filing_number%TYPE,

6062: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,
6063: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,
6064: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,
6065: p_lien_type IN okl_lines_interface.lien_type%TYPE,
6066: p_lien_filing_number IN okl_lines_interface.lien_filing_number%TYPE,
6067: p_lien_filing_date IN okl_lines_interface.lien_filing_date%TYPE,
6068: p_lien_filing_status IN okl_lines_interface.lien_filing_status%TYPE,
6069: p_lienholder_id IN okl_lines_interface.lienholder_id%TYPE,
6070: p_lienholder_number IN okl_lines_interface.lienholder_number%TYPE,

Line 6067: p_lien_filing_date IN okl_lines_interface.lien_filing_date%TYPE,

6063: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,
6064: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,
6065: p_lien_type IN okl_lines_interface.lien_type%TYPE,
6066: p_lien_filing_number IN okl_lines_interface.lien_filing_number%TYPE,
6067: p_lien_filing_date IN okl_lines_interface.lien_filing_date%TYPE,
6068: p_lien_filing_status IN okl_lines_interface.lien_filing_status%TYPE,
6069: p_lienholder_id IN okl_lines_interface.lienholder_id%TYPE,
6070: p_lienholder_number IN okl_lines_interface.lienholder_number%TYPE,
6071: p_filing_jurisdiction IN okl_lines_interface.filing_jurisdiction%TYPE,

Line 6068: p_lien_filing_status IN okl_lines_interface.lien_filing_status%TYPE,

6064: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,
6065: p_lien_type IN okl_lines_interface.lien_type%TYPE,
6066: p_lien_filing_number IN okl_lines_interface.lien_filing_number%TYPE,
6067: p_lien_filing_date IN okl_lines_interface.lien_filing_date%TYPE,
6068: p_lien_filing_status IN okl_lines_interface.lien_filing_status%TYPE,
6069: p_lienholder_id IN okl_lines_interface.lienholder_id%TYPE,
6070: p_lienholder_number IN okl_lines_interface.lienholder_number%TYPE,
6071: p_filing_jurisdiction IN okl_lines_interface.filing_jurisdiction%TYPE,
6072: p_filing_sub_jurisdiction IN okl_lines_interface.filing_sub_jurisdiction%TYPE,

Line 6069: p_lienholder_id IN okl_lines_interface.lienholder_id%TYPE,

6065: p_lien_type IN okl_lines_interface.lien_type%TYPE,
6066: p_lien_filing_number IN okl_lines_interface.lien_filing_number%TYPE,
6067: p_lien_filing_date IN okl_lines_interface.lien_filing_date%TYPE,
6068: p_lien_filing_status IN okl_lines_interface.lien_filing_status%TYPE,
6069: p_lienholder_id IN okl_lines_interface.lienholder_id%TYPE,
6070: p_lienholder_number IN okl_lines_interface.lienholder_number%TYPE,
6071: p_filing_jurisdiction IN okl_lines_interface.filing_jurisdiction%TYPE,
6072: p_filing_sub_jurisdiction IN okl_lines_interface.filing_sub_jurisdiction%TYPE,
6073: p_lien_expiration_date IN okl_lines_interface.lien_expiration_date%TYPE,

Line 6070: p_lienholder_number IN okl_lines_interface.lienholder_number%TYPE,

6066: p_lien_filing_number IN okl_lines_interface.lien_filing_number%TYPE,
6067: p_lien_filing_date IN okl_lines_interface.lien_filing_date%TYPE,
6068: p_lien_filing_status IN okl_lines_interface.lien_filing_status%TYPE,
6069: p_lienholder_id IN okl_lines_interface.lienholder_id%TYPE,
6070: p_lienholder_number IN okl_lines_interface.lienholder_number%TYPE,
6071: p_filing_jurisdiction IN okl_lines_interface.filing_jurisdiction%TYPE,
6072: p_filing_sub_jurisdiction IN okl_lines_interface.filing_sub_jurisdiction%TYPE,
6073: p_lien_expiration_date IN okl_lines_interface.lien_expiration_date%TYPE,
6074: p_lien_continuation_number IN okl_lines_interface.lien_continuation_number%TYPE,

Line 6071: p_filing_jurisdiction IN okl_lines_interface.filing_jurisdiction%TYPE,

6067: p_lien_filing_date IN okl_lines_interface.lien_filing_date%TYPE,
6068: p_lien_filing_status IN okl_lines_interface.lien_filing_status%TYPE,
6069: p_lienholder_id IN okl_lines_interface.lienholder_id%TYPE,
6070: p_lienholder_number IN okl_lines_interface.lienholder_number%TYPE,
6071: p_filing_jurisdiction IN okl_lines_interface.filing_jurisdiction%TYPE,
6072: p_filing_sub_jurisdiction IN okl_lines_interface.filing_sub_jurisdiction%TYPE,
6073: p_lien_expiration_date IN okl_lines_interface.lien_expiration_date%TYPE,
6074: p_lien_continuation_number IN okl_lines_interface.lien_continuation_number%TYPE,
6075: p_lien_continuation_date IN okl_lines_interface.lien_continuation_date%TYPE,

Line 6072: p_filing_sub_jurisdiction IN okl_lines_interface.filing_sub_jurisdiction%TYPE,

6068: p_lien_filing_status IN okl_lines_interface.lien_filing_status%TYPE,
6069: p_lienholder_id IN okl_lines_interface.lienholder_id%TYPE,
6070: p_lienholder_number IN okl_lines_interface.lienholder_number%TYPE,
6071: p_filing_jurisdiction IN okl_lines_interface.filing_jurisdiction%TYPE,
6072: p_filing_sub_jurisdiction IN okl_lines_interface.filing_sub_jurisdiction%TYPE,
6073: p_lien_expiration_date IN okl_lines_interface.lien_expiration_date%TYPE,
6074: p_lien_continuation_number IN okl_lines_interface.lien_continuation_number%TYPE,
6075: p_lien_continuation_date IN okl_lines_interface.lien_continuation_date%TYPE,
6076: p_title_type IN okl_lines_interface.title_type%TYPE,

Line 6073: p_lien_expiration_date IN okl_lines_interface.lien_expiration_date%TYPE,

6069: p_lienholder_id IN okl_lines_interface.lienholder_id%TYPE,
6070: p_lienholder_number IN okl_lines_interface.lienholder_number%TYPE,
6071: p_filing_jurisdiction IN okl_lines_interface.filing_jurisdiction%TYPE,
6072: p_filing_sub_jurisdiction IN okl_lines_interface.filing_sub_jurisdiction%TYPE,
6073: p_lien_expiration_date IN okl_lines_interface.lien_expiration_date%TYPE,
6074: p_lien_continuation_number IN okl_lines_interface.lien_continuation_number%TYPE,
6075: p_lien_continuation_date IN okl_lines_interface.lien_continuation_date%TYPE,
6076: p_title_type IN okl_lines_interface.title_type%TYPE,
6077: p_title_issuer_number IN okl_lines_interface.title_issuer_number%TYPE,

Line 6074: p_lien_continuation_number IN okl_lines_interface.lien_continuation_number%TYPE,

6070: p_lienholder_number IN okl_lines_interface.lienholder_number%TYPE,
6071: p_filing_jurisdiction IN okl_lines_interface.filing_jurisdiction%TYPE,
6072: p_filing_sub_jurisdiction IN okl_lines_interface.filing_sub_jurisdiction%TYPE,
6073: p_lien_expiration_date IN okl_lines_interface.lien_expiration_date%TYPE,
6074: p_lien_continuation_number IN okl_lines_interface.lien_continuation_number%TYPE,
6075: p_lien_continuation_date IN okl_lines_interface.lien_continuation_date%TYPE,
6076: p_title_type IN okl_lines_interface.title_type%TYPE,
6077: p_title_issuer_number IN okl_lines_interface.title_issuer_number%TYPE,
6078: p_title_issuer_id IN okl_lines_interface.title_issuer_id%TYPE,

Line 6075: p_lien_continuation_date IN okl_lines_interface.lien_continuation_date%TYPE,

6071: p_filing_jurisdiction IN okl_lines_interface.filing_jurisdiction%TYPE,
6072: p_filing_sub_jurisdiction IN okl_lines_interface.filing_sub_jurisdiction%TYPE,
6073: p_lien_expiration_date IN okl_lines_interface.lien_expiration_date%TYPE,
6074: p_lien_continuation_number IN okl_lines_interface.lien_continuation_number%TYPE,
6075: p_lien_continuation_date IN okl_lines_interface.lien_continuation_date%TYPE,
6076: p_title_type IN okl_lines_interface.title_type%TYPE,
6077: p_title_issuer_number IN okl_lines_interface.title_issuer_number%TYPE,
6078: p_title_issuer_id IN okl_lines_interface.title_issuer_id%TYPE,
6079: p_title_date IN okl_lines_interface.title_date%TYPE,

Line 6076: p_title_type IN okl_lines_interface.title_type%TYPE,

6072: p_filing_sub_jurisdiction IN okl_lines_interface.filing_sub_jurisdiction%TYPE,
6073: p_lien_expiration_date IN okl_lines_interface.lien_expiration_date%TYPE,
6074: p_lien_continuation_number IN okl_lines_interface.lien_continuation_number%TYPE,
6075: p_lien_continuation_date IN okl_lines_interface.lien_continuation_date%TYPE,
6076: p_title_type IN okl_lines_interface.title_type%TYPE,
6077: p_title_issuer_number IN okl_lines_interface.title_issuer_number%TYPE,
6078: p_title_issuer_id IN okl_lines_interface.title_issuer_id%TYPE,
6079: p_title_date IN okl_lines_interface.title_date%TYPE,
6080: p_title_number IN okl_lines_interface.title_number%TYPE,

Line 6077: p_title_issuer_number IN okl_lines_interface.title_issuer_number%TYPE,

6073: p_lien_expiration_date IN okl_lines_interface.lien_expiration_date%TYPE,
6074: p_lien_continuation_number IN okl_lines_interface.lien_continuation_number%TYPE,
6075: p_lien_continuation_date IN okl_lines_interface.lien_continuation_date%TYPE,
6076: p_title_type IN okl_lines_interface.title_type%TYPE,
6077: p_title_issuer_number IN okl_lines_interface.title_issuer_number%TYPE,
6078: p_title_issuer_id IN okl_lines_interface.title_issuer_id%TYPE,
6079: p_title_date IN okl_lines_interface.title_date%TYPE,
6080: p_title_number IN okl_lines_interface.title_number%TYPE,
6081: p_registration_number IN okl_lines_interface.registration_number%TYPE,

Line 6078: p_title_issuer_id IN okl_lines_interface.title_issuer_id%TYPE,

6074: p_lien_continuation_number IN okl_lines_interface.lien_continuation_number%TYPE,
6075: p_lien_continuation_date IN okl_lines_interface.lien_continuation_date%TYPE,
6076: p_title_type IN okl_lines_interface.title_type%TYPE,
6077: p_title_issuer_number IN okl_lines_interface.title_issuer_number%TYPE,
6078: p_title_issuer_id IN okl_lines_interface.title_issuer_id%TYPE,
6079: p_title_date IN okl_lines_interface.title_date%TYPE,
6080: p_title_number IN okl_lines_interface.title_number%TYPE,
6081: p_registration_number IN okl_lines_interface.registration_number%TYPE,
6082: p_asset_registration_loc_name IN okl_lines_interface.asset_registration_loc_name%TYPE,

Line 6079: p_title_date IN okl_lines_interface.title_date%TYPE,

6075: p_lien_continuation_date IN okl_lines_interface.lien_continuation_date%TYPE,
6076: p_title_type IN okl_lines_interface.title_type%TYPE,
6077: p_title_issuer_number IN okl_lines_interface.title_issuer_number%TYPE,
6078: p_title_issuer_id IN okl_lines_interface.title_issuer_id%TYPE,
6079: p_title_date IN okl_lines_interface.title_date%TYPE,
6080: p_title_number IN okl_lines_interface.title_number%TYPE,
6081: p_registration_number IN okl_lines_interface.registration_number%TYPE,
6082: p_asset_registration_loc_name IN okl_lines_interface.asset_registration_loc_name%TYPE,
6083: p_title_custodian_name IN okl_lines_interface.title_custodian_name%TYPE,

Line 6080: p_title_number IN okl_lines_interface.title_number%TYPE,

6076: p_title_type IN okl_lines_interface.title_type%TYPE,
6077: p_title_issuer_number IN okl_lines_interface.title_issuer_number%TYPE,
6078: p_title_issuer_id IN okl_lines_interface.title_issuer_id%TYPE,
6079: p_title_date IN okl_lines_interface.title_date%TYPE,
6080: p_title_number IN okl_lines_interface.title_number%TYPE,
6081: p_registration_number IN okl_lines_interface.registration_number%TYPE,
6082: p_asset_registration_loc_name IN okl_lines_interface.asset_registration_loc_name%TYPE,
6083: p_title_custodian_name IN okl_lines_interface.title_custodian_name%TYPE,
6084: p_payee_site_name IN okl_lines_interface.payee_site_name%TYPE,

Line 6081: p_registration_number IN okl_lines_interface.registration_number%TYPE,

6077: p_title_issuer_number IN okl_lines_interface.title_issuer_number%TYPE,
6078: p_title_issuer_id IN okl_lines_interface.title_issuer_id%TYPE,
6079: p_title_date IN okl_lines_interface.title_date%TYPE,
6080: p_title_number IN okl_lines_interface.title_number%TYPE,
6081: p_registration_number IN okl_lines_interface.registration_number%TYPE,
6082: p_asset_registration_loc_name IN okl_lines_interface.asset_registration_loc_name%TYPE,
6083: p_title_custodian_name IN okl_lines_interface.title_custodian_name%TYPE,
6084: p_payee_site_name IN okl_lines_interface.payee_site_name%TYPE,
6085: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,

Line 6082: p_asset_registration_loc_name IN okl_lines_interface.asset_registration_loc_name%TYPE,

6078: p_title_issuer_id IN okl_lines_interface.title_issuer_id%TYPE,
6079: p_title_date IN okl_lines_interface.title_date%TYPE,
6080: p_title_number IN okl_lines_interface.title_number%TYPE,
6081: p_registration_number IN okl_lines_interface.registration_number%TYPE,
6082: p_asset_registration_loc_name IN okl_lines_interface.asset_registration_loc_name%TYPE,
6083: p_title_custodian_name IN okl_lines_interface.title_custodian_name%TYPE,
6084: p_payee_site_name IN okl_lines_interface.payee_site_name%TYPE,
6085: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,
6086: p_passthrough_basis_code IN okl_lines_interface.passthrough_basis_code%TYPE,

Line 6083: p_title_custodian_name IN okl_lines_interface.title_custodian_name%TYPE,

6079: p_title_date IN okl_lines_interface.title_date%TYPE,
6080: p_title_number IN okl_lines_interface.title_number%TYPE,
6081: p_registration_number IN okl_lines_interface.registration_number%TYPE,
6082: p_asset_registration_loc_name IN okl_lines_interface.asset_registration_loc_name%TYPE,
6083: p_title_custodian_name IN okl_lines_interface.title_custodian_name%TYPE,
6084: p_payee_site_name IN okl_lines_interface.payee_site_name%TYPE,
6085: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,
6086: p_passthrough_basis_code IN okl_lines_interface.passthrough_basis_code%TYPE,
6087: p_fee_code IN okl_lines_interface.fee_code%TYPE,

Line 6084: p_payee_site_name IN okl_lines_interface.payee_site_name%TYPE,

6080: p_title_number IN okl_lines_interface.title_number%TYPE,
6081: p_registration_number IN okl_lines_interface.registration_number%TYPE,
6082: p_asset_registration_loc_name IN okl_lines_interface.asset_registration_loc_name%TYPE,
6083: p_title_custodian_name IN okl_lines_interface.title_custodian_name%TYPE,
6084: p_payee_site_name IN okl_lines_interface.payee_site_name%TYPE,
6085: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,
6086: p_passthrough_basis_code IN okl_lines_interface.passthrough_basis_code%TYPE,
6087: p_fee_code IN okl_lines_interface.fee_code%TYPE,
6088: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,

Line 6085: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,

6081: p_registration_number IN okl_lines_interface.registration_number%TYPE,
6082: p_asset_registration_loc_name IN okl_lines_interface.asset_registration_loc_name%TYPE,
6083: p_title_custodian_name IN okl_lines_interface.title_custodian_name%TYPE,
6084: p_payee_site_name IN okl_lines_interface.payee_site_name%TYPE,
6085: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,
6086: p_passthrough_basis_code IN okl_lines_interface.passthrough_basis_code%TYPE,
6087: p_fee_code IN okl_lines_interface.fee_code%TYPE,
6088: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
6089: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,

Line 6086: p_passthrough_basis_code IN okl_lines_interface.passthrough_basis_code%TYPE,

6082: p_asset_registration_loc_name IN okl_lines_interface.asset_registration_loc_name%TYPE,
6083: p_title_custodian_name IN okl_lines_interface.title_custodian_name%TYPE,
6084: p_payee_site_name IN okl_lines_interface.payee_site_name%TYPE,
6085: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,
6086: p_passthrough_basis_code IN okl_lines_interface.passthrough_basis_code%TYPE,
6087: p_fee_code IN okl_lines_interface.fee_code%TYPE,
6088: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
6089: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,
6090: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,

Line 6087: p_fee_code IN okl_lines_interface.fee_code%TYPE,

6083: p_title_custodian_name IN okl_lines_interface.title_custodian_name%TYPE,
6084: p_payee_site_name IN okl_lines_interface.payee_site_name%TYPE,
6085: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,
6086: p_passthrough_basis_code IN okl_lines_interface.passthrough_basis_code%TYPE,
6087: p_fee_code IN okl_lines_interface.fee_code%TYPE,
6088: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
6089: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,
6090: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,
6091: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,

Line 6088: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,

6084: p_payee_site_name IN okl_lines_interface.payee_site_name%TYPE,
6085: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,
6086: p_passthrough_basis_code IN okl_lines_interface.passthrough_basis_code%TYPE,
6087: p_fee_code IN okl_lines_interface.fee_code%TYPE,
6088: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
6089: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,
6090: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,
6091: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,
6092: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,

Line 6089: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,

6085: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,
6086: p_passthrough_basis_code IN okl_lines_interface.passthrough_basis_code%TYPE,
6087: p_fee_code IN okl_lines_interface.fee_code%TYPE,
6088: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
6089: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,
6090: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,
6091: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,
6092: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,
6093: p_minimum_qty_usage IN okl_lines_interface.minimum_qty_usage%TYPE,

Line 6090: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,

6086: p_passthrough_basis_code IN okl_lines_interface.passthrough_basis_code%TYPE,
6087: p_fee_code IN okl_lines_interface.fee_code%TYPE,
6088: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
6089: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,
6090: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,
6091: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,
6092: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,
6093: p_minimum_qty_usage IN okl_lines_interface.minimum_qty_usage%TYPE,
6094: p_default_qty_usage IN okl_lines_interface.default_qty_usage%TYPE,

Line 6091: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,

6087: p_fee_code IN okl_lines_interface.fee_code%TYPE,
6088: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
6089: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,
6090: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,
6091: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,
6092: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,
6093: p_minimum_qty_usage IN okl_lines_interface.minimum_qty_usage%TYPE,
6094: p_default_qty_usage IN okl_lines_interface.default_qty_usage%TYPE,
6095: p_amcv_flag IN okl_lines_interface.amcv_flag%TYPE,

Line 6092: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,

6088: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
6089: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,
6090: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,
6091: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,
6092: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,
6093: p_minimum_qty_usage IN okl_lines_interface.minimum_qty_usage%TYPE,
6094: p_default_qty_usage IN okl_lines_interface.default_qty_usage%TYPE,
6095: p_amcv_flag IN okl_lines_interface.amcv_flag%TYPE,
6096: p_level_flag IN okl_lines_interface.level_flag%TYPE,

Line 6093: p_minimum_qty_usage IN okl_lines_interface.minimum_qty_usage%TYPE,

6089: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,
6090: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,
6091: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,
6092: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,
6093: p_minimum_qty_usage IN okl_lines_interface.minimum_qty_usage%TYPE,
6094: p_default_qty_usage IN okl_lines_interface.default_qty_usage%TYPE,
6095: p_amcv_flag IN okl_lines_interface.amcv_flag%TYPE,
6096: p_level_flag IN okl_lines_interface.level_flag%TYPE,
6097: p_base_reading IN okl_lines_interface.base_reading%TYPE,

Line 6094: p_default_qty_usage IN okl_lines_interface.default_qty_usage%TYPE,

6090: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,
6091: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,
6092: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,
6093: p_minimum_qty_usage IN okl_lines_interface.minimum_qty_usage%TYPE,
6094: p_default_qty_usage IN okl_lines_interface.default_qty_usage%TYPE,
6095: p_amcv_flag IN okl_lines_interface.amcv_flag%TYPE,
6096: p_level_flag IN okl_lines_interface.level_flag%TYPE,
6097: p_base_reading IN okl_lines_interface.base_reading%TYPE,
6098: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,

Line 6095: p_amcv_flag IN okl_lines_interface.amcv_flag%TYPE,

6091: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,
6092: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,
6093: p_minimum_qty_usage IN okl_lines_interface.minimum_qty_usage%TYPE,
6094: p_default_qty_usage IN okl_lines_interface.default_qty_usage%TYPE,
6095: p_amcv_flag IN okl_lines_interface.amcv_flag%TYPE,
6096: p_level_flag IN okl_lines_interface.level_flag%TYPE,
6097: p_base_reading IN okl_lines_interface.base_reading%TYPE,
6098: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,
6099: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,

Line 6096: p_level_flag IN okl_lines_interface.level_flag%TYPE,

6092: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,
6093: p_minimum_qty_usage IN okl_lines_interface.minimum_qty_usage%TYPE,
6094: p_default_qty_usage IN okl_lines_interface.default_qty_usage%TYPE,
6095: p_amcv_flag IN okl_lines_interface.amcv_flag%TYPE,
6096: p_level_flag IN okl_lines_interface.level_flag%TYPE,
6097: p_base_reading IN okl_lines_interface.base_reading%TYPE,
6098: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,
6099: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,
6100: p_fixed_usage_quantity IN okl_lines_interface.fixed_usage_quantity%TYPE,

Line 6097: p_base_reading IN okl_lines_interface.base_reading%TYPE,

6093: p_minimum_qty_usage IN okl_lines_interface.minimum_qty_usage%TYPE,
6094: p_default_qty_usage IN okl_lines_interface.default_qty_usage%TYPE,
6095: p_amcv_flag IN okl_lines_interface.amcv_flag%TYPE,
6096: p_level_flag IN okl_lines_interface.level_flag%TYPE,
6097: p_base_reading IN okl_lines_interface.base_reading%TYPE,
6098: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,
6099: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,
6100: p_fixed_usage_quantity IN okl_lines_interface.fixed_usage_quantity%TYPE,
6101: p_usage_period IN okl_lines_interface.usage_period%TYPE,

Line 6098: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,

6094: p_default_qty_usage IN okl_lines_interface.default_qty_usage%TYPE,
6095: p_amcv_flag IN okl_lines_interface.amcv_flag%TYPE,
6096: p_level_flag IN okl_lines_interface.level_flag%TYPE,
6097: p_base_reading IN okl_lines_interface.base_reading%TYPE,
6098: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,
6099: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,
6100: p_fixed_usage_quantity IN okl_lines_interface.fixed_usage_quantity%TYPE,
6101: p_usage_period IN okl_lines_interface.usage_period%TYPE,
6102: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,

Line 6099: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,

6095: p_amcv_flag IN okl_lines_interface.amcv_flag%TYPE,
6096: p_level_flag IN okl_lines_interface.level_flag%TYPE,
6097: p_base_reading IN okl_lines_interface.base_reading%TYPE,
6098: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,
6099: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,
6100: p_fixed_usage_quantity IN okl_lines_interface.fixed_usage_quantity%TYPE,
6101: p_usage_period IN okl_lines_interface.usage_period%TYPE,
6102: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,
6103: p_fee_no_of_period IN okl_lines_interface.fee_exp_no_of_periods%TYPE,

Line 6100: p_fixed_usage_quantity IN okl_lines_interface.fixed_usage_quantity%TYPE,

6096: p_level_flag IN okl_lines_interface.level_flag%TYPE,
6097: p_base_reading IN okl_lines_interface.base_reading%TYPE,
6098: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,
6099: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,
6100: p_fixed_usage_quantity IN okl_lines_interface.fixed_usage_quantity%TYPE,
6101: p_usage_period IN okl_lines_interface.usage_period%TYPE,
6102: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,
6103: p_fee_no_of_period IN okl_lines_interface.fee_exp_no_of_periods%TYPE,
6104: p_fee_frequency IN okl_lines_interface.fee_exp_frequency%TYPE,

Line 6101: p_usage_period IN okl_lines_interface.usage_period%TYPE,

6097: p_base_reading IN okl_lines_interface.base_reading%TYPE,
6098: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,
6099: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,
6100: p_fixed_usage_quantity IN okl_lines_interface.fixed_usage_quantity%TYPE,
6101: p_usage_period IN okl_lines_interface.usage_period%TYPE,
6102: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,
6103: p_fee_no_of_period IN okl_lines_interface.fee_exp_no_of_periods%TYPE,
6104: p_fee_frequency IN okl_lines_interface.fee_exp_frequency%TYPE,
6105: p_fee_amount_per_period IN okl_lines_interface.fee_exp_amount_per_period%TYPE,

Line 6102: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,

6098: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,
6099: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,
6100: p_fixed_usage_quantity IN okl_lines_interface.fixed_usage_quantity%TYPE,
6101: p_usage_period IN okl_lines_interface.usage_period%TYPE,
6102: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,
6103: p_fee_no_of_period IN okl_lines_interface.fee_exp_no_of_periods%TYPE,
6104: p_fee_frequency IN okl_lines_interface.fee_exp_frequency%TYPE,
6105: p_fee_amount_per_period IN okl_lines_interface.fee_exp_amount_per_period%TYPE,
6106: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,

Line 6103: p_fee_no_of_period IN okl_lines_interface.fee_exp_no_of_periods%TYPE,

6099: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,
6100: p_fixed_usage_quantity IN okl_lines_interface.fixed_usage_quantity%TYPE,
6101: p_usage_period IN okl_lines_interface.usage_period%TYPE,
6102: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,
6103: p_fee_no_of_period IN okl_lines_interface.fee_exp_no_of_periods%TYPE,
6104: p_fee_frequency IN okl_lines_interface.fee_exp_frequency%TYPE,
6105: p_fee_amount_per_period IN okl_lines_interface.fee_exp_amount_per_period%TYPE,
6106: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,
6107: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,

Line 6104: p_fee_frequency IN okl_lines_interface.fee_exp_frequency%TYPE,

6100: p_fixed_usage_quantity IN okl_lines_interface.fixed_usage_quantity%TYPE,
6101: p_usage_period IN okl_lines_interface.usage_period%TYPE,
6102: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,
6103: p_fee_no_of_period IN okl_lines_interface.fee_exp_no_of_periods%TYPE,
6104: p_fee_frequency IN okl_lines_interface.fee_exp_frequency%TYPE,
6105: p_fee_amount_per_period IN okl_lines_interface.fee_exp_amount_per_period%TYPE,
6106: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,
6107: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,
6108: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,

Line 6105: p_fee_amount_per_period IN okl_lines_interface.fee_exp_amount_per_period%TYPE,

6101: p_usage_period IN okl_lines_interface.usage_period%TYPE,
6102: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,
6103: p_fee_no_of_period IN okl_lines_interface.fee_exp_no_of_periods%TYPE,
6104: p_fee_frequency IN okl_lines_interface.fee_exp_frequency%TYPE,
6105: p_fee_amount_per_period IN okl_lines_interface.fee_exp_amount_per_period%TYPE,
6106: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,
6107: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,
6108: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,
6109: p_french_tax_name IN okl_lines_interface.french_tax_name%TYPE,

Line 6106: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,

6102: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,
6103: p_fee_no_of_period IN okl_lines_interface.fee_exp_no_of_periods%TYPE,
6104: p_fee_frequency IN okl_lines_interface.fee_exp_frequency%TYPE,
6105: p_fee_amount_per_period IN okl_lines_interface.fee_exp_amount_per_period%TYPE,
6106: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,
6107: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,
6108: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,
6109: p_french_tax_name IN okl_lines_interface.french_tax_name%TYPE,
6110: -- Added by rravikir (Fix for Bug 3947959)

Line 6107: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,

6103: p_fee_no_of_period IN okl_lines_interface.fee_exp_no_of_periods%TYPE,
6104: p_fee_frequency IN okl_lines_interface.fee_exp_frequency%TYPE,
6105: p_fee_amount_per_period IN okl_lines_interface.fee_exp_amount_per_period%TYPE,
6106: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,
6107: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,
6108: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,
6109: p_french_tax_name IN okl_lines_interface.french_tax_name%TYPE,
6110: -- Added by rravikir (Fix for Bug 3947959)
6111: p_prop_tax_bill_method IN okl_lines_interface.prop_tax_bill_method%TYPE,

Line 6108: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,

6104: p_fee_frequency IN okl_lines_interface.fee_exp_frequency%TYPE,
6105: p_fee_amount_per_period IN okl_lines_interface.fee_exp_amount_per_period%TYPE,
6106: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,
6107: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,
6108: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,
6109: p_french_tax_name IN okl_lines_interface.french_tax_name%TYPE,
6110: -- Added by rravikir (Fix for Bug 3947959)
6111: p_prop_tax_bill_method IN okl_lines_interface.prop_tax_bill_method%TYPE,
6112: p_prop_tax_as_contract_yn IN okl_lines_interface.prop_tax_as_contract_yn%TYPE

Line 6109: p_french_tax_name IN okl_lines_interface.french_tax_name%TYPE,

6105: p_fee_amount_per_period IN okl_lines_interface.fee_exp_amount_per_period%TYPE,
6106: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,
6107: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,
6108: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,
6109: p_french_tax_name IN okl_lines_interface.french_tax_name%TYPE,
6110: -- Added by rravikir (Fix for Bug 3947959)
6111: p_prop_tax_bill_method IN okl_lines_interface.prop_tax_bill_method%TYPE,
6112: p_prop_tax_as_contract_yn IN okl_lines_interface.prop_tax_as_contract_yn%TYPE
6113: -- End

Line 6111: p_prop_tax_bill_method IN okl_lines_interface.prop_tax_bill_method%TYPE,

6107: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,
6108: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,
6109: p_french_tax_name IN okl_lines_interface.french_tax_name%TYPE,
6110: -- Added by rravikir (Fix for Bug 3947959)
6111: p_prop_tax_bill_method IN okl_lines_interface.prop_tax_bill_method%TYPE,
6112: p_prop_tax_as_contract_yn IN okl_lines_interface.prop_tax_as_contract_yn%TYPE
6113: -- End
6114: ) IS
6115:

Line 6112: p_prop_tax_as_contract_yn IN okl_lines_interface.prop_tax_as_contract_yn%TYPE

6108: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,
6109: p_french_tax_name IN okl_lines_interface.french_tax_name%TYPE,
6110: -- Added by rravikir (Fix for Bug 3947959)
6111: p_prop_tax_bill_method IN okl_lines_interface.prop_tax_bill_method%TYPE,
6112: p_prop_tax_as_contract_yn IN okl_lines_interface.prop_tax_as_contract_yn%TYPE
6113: -- End
6114: ) IS
6115:
6116: line_rule_failed EXCEPTION;

Line 19234: p_line_number IN OKL_LINES_INTERFACE.LINE_NUMBER%TYPE,

19230: ------------------------------------------------------------------------------
19231: FUNCTION get_vendor_paygroup(
19232: x_return_status OUT NOCOPY VARCHAR2,
19233: p_contract_number IN OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,
19234: p_line_number IN OKL_LINES_INTERFACE.LINE_NUMBER%TYPE,
19235: p_auth_org_id IN OKL_HEADER_INTERFACE.authoring_org_id%TYPE,
19236: p_vendor_paysite_id IN OKL_LINES_INTERFACE.VENDOR_PAYSITE_ID%TYPE
19237: )
19238: /* RETURN NUMBER IS 13924672 */

Line 19236: p_vendor_paysite_id IN OKL_LINES_INTERFACE.VENDOR_PAYSITE_ID%TYPE

19232: x_return_status OUT NOCOPY VARCHAR2,
19233: p_contract_number IN OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,
19234: p_line_number IN OKL_LINES_INTERFACE.LINE_NUMBER%TYPE,
19235: p_auth_org_id IN OKL_HEADER_INTERFACE.authoring_org_id%TYPE,
19236: p_vendor_paysite_id IN OKL_LINES_INTERFACE.VENDOR_PAYSITE_ID%TYPE
19237: )
19238: /* RETURN NUMBER IS 13924672 */
19239: RETURN VARCHAR2 IS /* 13924672 */
19240: CURSOR paygroup_csr (p_paysite_id NUMBER,

Line 19285: p_line_type IN okl_lines_interface.line_type%TYPE,

19281: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
19282: p_chr_id IN okc_k_headers_v.id%TYPE,
19283: p_auth_org_id IN okl_header_interface.authoring_org_id%TYPE,
19284: p_line_number IN okc_k_lines_v.line_number%TYPE,
19285: p_line_type IN okl_lines_interface.line_type%TYPE,
19286: p_fin_cle_id IN NUMBER,
19287: p_model_cle_id IN NUMBER,
19288: p_service_line_id IN NUMBER,
19289: p_fee_line_id IN NUMBER,

Line 19308: p_payment_term IN okl_lines_interface.payment_term%TYPE,

19304: p_guarantee_date IN okl_party_roles_interface.guarantee_date%TYPE,
19305: p_guarantee_comment IN okl_party_roles_interface.guarantee_comment%TYPE,
19306: p_guarantor_site_number IN okl_party_roles_interface.guarantor_site_number%TYPE,
19307: p_guarantor_site_id IN okl_party_roles_interface.guarantor_site_id%TYPE,
19308: p_payment_term IN okl_lines_interface.payment_term%TYPE,
19309: p_payment_term_id IN okl_lines_interface.payment_term_id%TYPE,
19310: p_vendor_paysite_id IN okl_lines_interface.vendor_paysite_id%TYPE,
19311: p_vendor_paysite_name IN okl_lines_interface.vendor_paysite_name%TYPE,
19312: p_vendor_payment_method IN okl_lines_interface.vendor_payment_method%TYPE,

Line 19309: p_payment_term_id IN okl_lines_interface.payment_term_id%TYPE,

19305: p_guarantee_comment IN okl_party_roles_interface.guarantee_comment%TYPE,
19306: p_guarantor_site_number IN okl_party_roles_interface.guarantor_site_number%TYPE,
19307: p_guarantor_site_id IN okl_party_roles_interface.guarantor_site_id%TYPE,
19308: p_payment_term IN okl_lines_interface.payment_term%TYPE,
19309: p_payment_term_id IN okl_lines_interface.payment_term_id%TYPE,
19310: p_vendor_paysite_id IN okl_lines_interface.vendor_paysite_id%TYPE,
19311: p_vendor_paysite_name IN okl_lines_interface.vendor_paysite_name%TYPE,
19312: p_vendor_payment_method IN okl_lines_interface.vendor_payment_method%TYPE,
19313: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,

Line 19310: p_vendor_paysite_id IN okl_lines_interface.vendor_paysite_id%TYPE,

19306: p_guarantor_site_number IN okl_party_roles_interface.guarantor_site_number%TYPE,
19307: p_guarantor_site_id IN okl_party_roles_interface.guarantor_site_id%TYPE,
19308: p_payment_term IN okl_lines_interface.payment_term%TYPE,
19309: p_payment_term_id IN okl_lines_interface.payment_term_id%TYPE,
19310: p_vendor_paysite_id IN okl_lines_interface.vendor_paysite_id%TYPE,
19311: p_vendor_paysite_name IN okl_lines_interface.vendor_paysite_name%TYPE,
19312: p_vendor_payment_method IN okl_lines_interface.vendor_payment_method%TYPE,
19313: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,
19314: p_passthrough_basis_code IN okl_lines_interface.passthrough_basis_code%TYPE,

Line 19311: p_vendor_paysite_name IN okl_lines_interface.vendor_paysite_name%TYPE,

19307: p_guarantor_site_id IN okl_party_roles_interface.guarantor_site_id%TYPE,
19308: p_payment_term IN okl_lines_interface.payment_term%TYPE,
19309: p_payment_term_id IN okl_lines_interface.payment_term_id%TYPE,
19310: p_vendor_paysite_id IN okl_lines_interface.vendor_paysite_id%TYPE,
19311: p_vendor_paysite_name IN okl_lines_interface.vendor_paysite_name%TYPE,
19312: p_vendor_payment_method IN okl_lines_interface.vendor_payment_method%TYPE,
19313: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,
19314: p_passthrough_basis_code IN okl_lines_interface.passthrough_basis_code%TYPE,
19315: p_billable_vendor_id IN okl_party_roles_interface.billable_vendor_id%TYPE,

Line 19312: p_vendor_payment_method IN okl_lines_interface.vendor_payment_method%TYPE,

19308: p_payment_term IN okl_lines_interface.payment_term%TYPE,
19309: p_payment_term_id IN okl_lines_interface.payment_term_id%TYPE,
19310: p_vendor_paysite_id IN okl_lines_interface.vendor_paysite_id%TYPE,
19311: p_vendor_paysite_name IN okl_lines_interface.vendor_paysite_name%TYPE,
19312: p_vendor_payment_method IN okl_lines_interface.vendor_payment_method%TYPE,
19313: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,
19314: p_passthrough_basis_code IN okl_lines_interface.passthrough_basis_code%TYPE,
19315: p_billable_vendor_id IN okl_party_roles_interface.billable_vendor_id%TYPE,
19316: p_billable_vendor_name IN okl_party_roles_interface.billable_vendor_name%TYPE,

Line 19313: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,

19309: p_payment_term_id IN okl_lines_interface.payment_term_id%TYPE,
19310: p_vendor_paysite_id IN okl_lines_interface.vendor_paysite_id%TYPE,
19311: p_vendor_paysite_name IN okl_lines_interface.vendor_paysite_name%TYPE,
19312: p_vendor_payment_method IN okl_lines_interface.vendor_payment_method%TYPE,
19313: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,
19314: p_passthrough_basis_code IN okl_lines_interface.passthrough_basis_code%TYPE,
19315: p_billable_vendor_id IN okl_party_roles_interface.billable_vendor_id%TYPE,
19316: p_billable_vendor_name IN okl_party_roles_interface.billable_vendor_name%TYPE,
19317: p_vend_as_customer_number IN okl_party_roles_interface.vend_as_customer_number%TYPE,

Line 19314: p_passthrough_basis_code IN okl_lines_interface.passthrough_basis_code%TYPE,

19310: p_vendor_paysite_id IN okl_lines_interface.vendor_paysite_id%TYPE,
19311: p_vendor_paysite_name IN okl_lines_interface.vendor_paysite_name%TYPE,
19312: p_vendor_payment_method IN okl_lines_interface.vendor_payment_method%TYPE,
19313: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,
19314: p_passthrough_basis_code IN okl_lines_interface.passthrough_basis_code%TYPE,
19315: p_billable_vendor_id IN okl_party_roles_interface.billable_vendor_id%TYPE,
19316: p_billable_vendor_name IN okl_party_roles_interface.billable_vendor_name%TYPE,
19317: p_vend_as_customer_number IN okl_party_roles_interface.vend_as_customer_number%TYPE,
19318: p_vend_as_customer_id IN okl_party_roles_interface.vend_as_customer_id%TYPE,

Line 21852: p_line_type IN okl_lines_interface.line_type%TYPE,

21848: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
21849: p_chr_id IN okc_k_headers_v.id%TYPE,
21850: p_auth_org_id IN okl_header_interface.authoring_org_id%TYPE,
21851: p_line_number IN okc_k_lines_v.line_number%TYPE,
21852: p_line_type IN okl_lines_interface.line_type%TYPE,
21853: p_cle_id IN okc_k_lines_v.id%TYPE,
21854: p_bill_to_address_id IN okl_terms_interface.bill_to_address_id%TYPE,
21855: p_bill_to_address IN okl_terms_interface.bill_to_address%TYPE,
21856: p_bank_account_id IN okl_terms_interface.bank_account_id%TYPE,

Line 22418: p_line_number IN okl_lines_interface.line_number%TYPE,

22414: x_return_status OUT NOCOPY VARCHAR2,
22415: x_msg_count OUT NOCOPY NUMBER,
22416: x_msg_data OUT NOCOPY VARCHAR2,
22417: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
22418: p_line_number IN okl_lines_interface.line_number%TYPE,
22419: p_payment_type_code IN VARCHAR2,
22420: p_stream_purpose IN okl_payments_interface.stream_purpose_code%TYPE,
22421: p_chr_id IN NUMBER,
22422: p_cle_id IN NUMBER,

Line 22619: p_line_number IN okl_lines_interface.line_number%TYPE,

22615: x_return_status OUT NOCOPY VARCHAR2,
22616: x_msg_count OUT NOCOPY NUMBER,
22617: x_msg_data OUT NOCOPY VARCHAR2,
22618: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
22619: p_line_number IN okl_lines_interface.line_number%TYPE,
22620: p_payment_sch_number IN okl_payments_interface.payment_schedule_number%TYPE,
22621: p_payment_freq_code IN okl_payments_interface.payment_frequency_code%TYPE,
22622: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,
22623: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,

Line 22819: p_line_number IN okl_lines_interface.line_number%TYPE,

22815: x_return_status OUT NOCOPY VARCHAR2,
22816: x_msg_count OUT NOCOPY NUMBER,
22817: x_msg_data OUT NOCOPY VARCHAR2,
22818: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
22819: p_line_number IN okl_lines_interface.line_number%TYPE,
22820: p_line_type IN okl_lines_interface.line_type%TYPE,
22821: p_inventory_org_id IN okl_header_interface.inventory_organization_id%TYPE,
22822: p_inventory_item_id IN okl_lines_interface.inventory_item_id%TYPE,
22823: p_inventory_item_name IN okl_lines_interface.inventory_item_name%TYPE,

Line 22820: p_line_type IN okl_lines_interface.line_type%TYPE,

22816: x_msg_count OUT NOCOPY NUMBER,
22817: x_msg_data OUT NOCOPY VARCHAR2,
22818: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
22819: p_line_number IN okl_lines_interface.line_number%TYPE,
22820: p_line_type IN okl_lines_interface.line_type%TYPE,
22821: p_inventory_org_id IN okl_header_interface.inventory_organization_id%TYPE,
22822: p_inventory_item_id IN okl_lines_interface.inventory_item_id%TYPE,
22823: p_inventory_item_name IN okl_lines_interface.inventory_item_name%TYPE,
22824: x_inventory_org_id OUT NOCOPY NUMBER,

Line 22822: p_inventory_item_id IN okl_lines_interface.inventory_item_id%TYPE,

22818: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
22819: p_line_number IN okl_lines_interface.line_number%TYPE,
22820: p_line_type IN okl_lines_interface.line_type%TYPE,
22821: p_inventory_org_id IN okl_header_interface.inventory_organization_id%TYPE,
22822: p_inventory_item_id IN okl_lines_interface.inventory_item_id%TYPE,
22823: p_inventory_item_name IN okl_lines_interface.inventory_item_name%TYPE,
22824: x_inventory_org_id OUT NOCOPY NUMBER,
22825: x_inventory_item_id OUT NOCOPY NUMBER
22826: ) IS

Line 22823: p_inventory_item_name IN okl_lines_interface.inventory_item_name%TYPE,

22819: p_line_number IN okl_lines_interface.line_number%TYPE,
22820: p_line_type IN okl_lines_interface.line_type%TYPE,
22821: p_inventory_org_id IN okl_header_interface.inventory_organization_id%TYPE,
22822: p_inventory_item_id IN okl_lines_interface.inventory_item_id%TYPE,
22823: p_inventory_item_name IN okl_lines_interface.inventory_item_name%TYPE,
22824: x_inventory_org_id OUT NOCOPY NUMBER,
22825: x_inventory_item_id OUT NOCOPY NUMBER
22826: ) IS
22827: l_proc_name VARCHAR2(35) := 'GET_INVENTORY_ORG_ITEM_ID';

Line 22997: p_line_number IN okl_lines_interface.line_number%TYPE,

22993: x_return_status OUT NOCOPY VARCHAR2,
22994: x_msg_count OUT NOCOPY NUMBER,
22995: x_msg_data OUT NOCOPY VARCHAR2,
22996: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
22997: p_line_number IN okl_lines_interface.line_number%TYPE,
22998: p_asset_number IN okl_lines_interface.asset_number%TYPE,
22999: x_id1 OUT NOCOPY okx_assets_v.id1%TYPE,
23000: x_id2 OUT NOCOPY okx_assets_v.id2%TYPE
23001: ) IS

Line 22998: p_asset_number IN okl_lines_interface.asset_number%TYPE,

22994: x_msg_count OUT NOCOPY NUMBER,
22995: x_msg_data OUT NOCOPY VARCHAR2,
22996: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
22997: p_line_number IN okl_lines_interface.line_number%TYPE,
22998: p_asset_number IN okl_lines_interface.asset_number%TYPE,
22999: x_id1 OUT NOCOPY okx_assets_v.id1%TYPE,
23000: x_id2 OUT NOCOPY okx_assets_v.id2%TYPE
23001: ) IS
23002:

Line 23365: p_line_number IN okl_lines_interface.line_number%TYPE,

23361: x_return_status OUT NOCOPY VARCHAR2,
23362: x_msg_count OUT NOCOPY NUMBER,
23363: x_msg_data OUT NOCOPY VARCHAR2,
23364: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
23365: p_line_number IN okl_lines_interface.line_number%TYPE,
23366: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
23367: p_install_site_number IN okl_lines_interface.install_site_number%TYPE,
23368: x_install_site_id OUT NOCOPY okl_lines_interface.install_site_id%TYPE
23369: ) IS

Line 23366: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,

23362: x_msg_count OUT NOCOPY NUMBER,
23363: x_msg_data OUT NOCOPY VARCHAR2,
23364: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
23365: p_line_number IN okl_lines_interface.line_number%TYPE,
23366: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
23367: p_install_site_number IN okl_lines_interface.install_site_number%TYPE,
23368: x_install_site_id OUT NOCOPY okl_lines_interface.install_site_id%TYPE
23369: ) IS
23370: l_proc_name VARCHAR2(35) := 'GET_INSTALL_SITE_ID';

Line 23367: p_install_site_number IN okl_lines_interface.install_site_number%TYPE,

23363: x_msg_data OUT NOCOPY VARCHAR2,
23364: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
23365: p_line_number IN okl_lines_interface.line_number%TYPE,
23366: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
23367: p_install_site_number IN okl_lines_interface.install_site_number%TYPE,
23368: x_install_site_id OUT NOCOPY okl_lines_interface.install_site_id%TYPE
23369: ) IS
23370: l_proc_name VARCHAR2(35) := 'GET_INSTALL_SITE_ID';
23371: install_failed EXCEPTION;

Line 23368: x_install_site_id OUT NOCOPY okl_lines_interface.install_site_id%TYPE

23364: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
23365: p_line_number IN okl_lines_interface.line_number%TYPE,
23366: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
23367: p_install_site_number IN okl_lines_interface.install_site_number%TYPE,
23368: x_install_site_id OUT NOCOPY okl_lines_interface.install_site_id%TYPE
23369: ) IS
23370: l_proc_name VARCHAR2(35) := 'GET_INSTALL_SITE_ID';
23371: install_failed EXCEPTION;
23372: l_id1 okx_party_site_uses_v.id1%TYPE;

Line 23438: p_line_number IN okl_lines_interface.line_number%TYPE,

23434: x_return_status OUT NOCOPY VARCHAR2,
23435: x_msg_count OUT NOCOPY NUMBER,
23436: x_msg_data OUT NOCOPY VARCHAR2,
23437: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
23438: p_line_number IN okl_lines_interface.line_number%TYPE,
23439: p_lty_code IN VARCHAR2,
23440: p_top_line_lty_code IN VARCHAR2,
23441: x_lse_id OUT NOCOPY NUMBER
23442: ) IS

Line 23535: p_intf_line IN OKL_LINES_INTERFACE%ROWTYPE

23531: PROCEDURE validate_real_est(
23532: x_return_status OUT NOCOPY VARCHAR2,
23533: x_msg_count OUT NOCOPY NUMBER,
23534: x_msg_data OUT NOCOPY VARCHAR2,
23535: p_intf_line IN OKL_LINES_INTERFACE%ROWTYPE
23536: ) IS
23537:
23538: l_proc_name VARCHAR2(150) := 'OKL_LINES_INTERFACE: validate_real_est';
23539: l_progress varchar2(150);

Line 23538: l_proc_name VARCHAR2(150) := 'OKL_LINES_INTERFACE: validate_real_est';

23534: x_msg_data OUT NOCOPY VARCHAR2,
23535: p_intf_line IN OKL_LINES_INTERFACE%ROWTYPE
23536: ) IS
23537:
23538: l_proc_name VARCHAR2(150) := 'OKL_LINES_INTERFACE: validate_real_est';
23539: l_progress varchar2(150);
23540: l_dummy number;
23541: l_prc boolean := false;
23542:

Line 23642: p_asset_number IN okl_lines_interface.asset_number%TYPE,

23638: PROCEDURE get_link_asset_id(
23639: x_return_status OUT NOCOPY VARCHAR2,
23640: x_msg_count OUT NOCOPY NUMBER,
23641: x_msg_data OUT NOCOPY VARCHAR2,
23642: p_asset_number IN okl_lines_interface.asset_number%TYPE,
23643: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
23644: p_chr_id IN okc_k_headers_v.id%TYPE,
23645: p_line_number IN okc_k_lines_v.line_number%TYPE,
23646: x_asset_line_id OUT NOCOPY okc_k_lines_v.id%TYPE

Line 23723: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,

23719: x_msg_data OUT NOCOPY VARCHAR2,
23720: p_contract_number IN VARCHAR2,
23721: p_line_number IN NUMBER,
23722: p_asset_line_id IN NUMBER,
23723: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,
23724: p_usage_item_name IN VARCHAR2,
23725: p_inv_org_id IN NUMBER
23726: ) IS
23727: l_proc_name VARCHAR2(35) := 'VALIDATE_USAGE_ITEM_ASSOC';

Line 23795: p_term_quote_id IN okl_lines_interface.termination_quote_id%TYPE,

23791: x_msg_data OUT NOCOPY VARCHAR2,
23792: p_chr_id IN NUMBER,
23793: p_contract_number IN VARCHAR2,
23794: p_line_number IN NUMBER,
23795: p_term_quote_id IN okl_lines_interface.termination_quote_id%TYPE,
23796: p_term_quote_number IN okl_lines_interface.termination_quote_number%TYPE,
23797: x_term_quote_id OUT NOCOPY okl_lines_interface.termination_quote_id%TYPE
23798: ) IS
23799:

Line 23796: p_term_quote_number IN okl_lines_interface.termination_quote_number%TYPE,

23792: p_chr_id IN NUMBER,
23793: p_contract_number IN VARCHAR2,
23794: p_line_number IN NUMBER,
23795: p_term_quote_id IN okl_lines_interface.termination_quote_id%TYPE,
23796: p_term_quote_number IN okl_lines_interface.termination_quote_number%TYPE,
23797: x_term_quote_id OUT NOCOPY okl_lines_interface.termination_quote_id%TYPE
23798: ) IS
23799:
23800: l_proc_name VARCHAR2(35) := 'VALIDATE_TERM_QUOTE';

Line 23797: x_term_quote_id OUT NOCOPY okl_lines_interface.termination_quote_id%TYPE

23793: p_contract_number IN VARCHAR2,
23794: p_line_number IN NUMBER,
23795: p_term_quote_id IN okl_lines_interface.termination_quote_id%TYPE,
23796: p_term_quote_number IN okl_lines_interface.termination_quote_number%TYPE,
23797: x_term_quote_id OUT NOCOPY okl_lines_interface.termination_quote_id%TYPE
23798: ) IS
23799:
23800: l_proc_name VARCHAR2(35) := 'VALIDATE_TERM_QUOTE';
23801: l_quote_id NUMBER;

Line 23879: p_line_type IN okl_lines_interface.line_type%TYPE,

23875: x_msg_count OUT NOCOPY NUMBER,
23876: x_msg_data OUT NOCOPY VARCHAR2,
23877: p_contract_id IN okc_k_headers_b.id%TYPE,
23878: p_line_id IN okc_k_lines_b.id%TYPE,
23879: p_line_type IN okl_lines_interface.line_type%TYPE,
23880: p_pth_start_date IN okl_party_payment_hdr.passthru_start_date%TYPE,
23881: p_pth_base_payout_basis IN okl_party_payment_hdr.payout_basis%TYPE,
23882: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
23883: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,

Line 23882: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,

23878: p_line_id IN okc_k_lines_b.id%TYPE,
23879: p_line_type IN okl_lines_interface.line_type%TYPE,
23880: p_pth_start_date IN okl_party_payment_hdr.passthru_start_date%TYPE,
23881: p_pth_base_payout_basis IN okl_party_payment_hdr.payout_basis%TYPE,
23882: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
23883: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
23884: p_pth_evg_payout_basis IN okl_party_payment_hdr.payout_basis%TYPE,
23885: p_pth_payout_basis_formula IN okl_party_payment_hdr.payout_basis_formula%TYPE,
23886: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,

Line 23883: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,

23879: p_line_type IN okl_lines_interface.line_type%TYPE,
23880: p_pth_start_date IN okl_party_payment_hdr.passthru_start_date%TYPE,
23881: p_pth_base_payout_basis IN okl_party_payment_hdr.payout_basis%TYPE,
23882: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
23883: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
23884: p_pth_evg_payout_basis IN okl_party_payment_hdr.payout_basis%TYPE,
23885: p_pth_payout_basis_formula IN okl_party_payment_hdr.payout_basis_formula%TYPE,
23886: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
23887: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,

Line 23886: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,

23882: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
23883: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
23884: p_pth_evg_payout_basis IN okl_party_payment_hdr.payout_basis%TYPE,
23885: p_pth_payout_basis_formula IN okl_party_payment_hdr.payout_basis_formula%TYPE,
23886: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
23887: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
23888: x_party_pmnt_hdr_tbl OUT NOCOPY okl_party_payments_pvt.pphv_tbl_type
23889: ) IS
23890:

Line 23887: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,

23883: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
23884: p_pth_evg_payout_basis IN okl_party_payment_hdr.payout_basis%TYPE,
23885: p_pth_payout_basis_formula IN okl_party_payment_hdr.payout_basis_formula%TYPE,
23886: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
23887: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
23888: x_party_pmnt_hdr_tbl OUT NOCOPY okl_party_payments_pvt.pphv_tbl_type
23889: ) IS
23890:
23891: l_proc_name VARCHAR2(35) := 'CREATE_PARTY_PAYMENT_HDR';

Line 24122: p_line_number IN okl_lines_interface.line_number%TYPE,

24118: x_msg_count OUT NOCOPY NUMBER,
24119: x_msg_data OUT NOCOPY VARCHAR2,
24120: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
24121: p_chr_id IN okc_k_headers_v.id%TYPE,
24122: p_line_number IN okl_lines_interface.line_number%TYPE,
24123: p_line_type IN okl_lines_interface.line_type%TYPE,
24124: p_line_type_prev IN okl_lines_interface.line_type%TYPE,
24125: p_inv_item_id IN okl_lines_interface.inventory_item_id%TYPE,
24126: p_inv_org_id IN okl_header_interface.inventory_organization_id%TYPE,

Line 24123: p_line_type IN okl_lines_interface.line_type%TYPE,

24119: x_msg_data OUT NOCOPY VARCHAR2,
24120: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
24121: p_chr_id IN okc_k_headers_v.id%TYPE,
24122: p_line_number IN okl_lines_interface.line_number%TYPE,
24123: p_line_type IN okl_lines_interface.line_type%TYPE,
24124: p_line_type_prev IN okl_lines_interface.line_type%TYPE,
24125: p_inv_item_id IN okl_lines_interface.inventory_item_id%TYPE,
24126: p_inv_org_id IN okl_header_interface.inventory_organization_id%TYPE,
24127: p_line_amount IN okl_lines_interface.amount%TYPE,

Line 24124: p_line_type_prev IN okl_lines_interface.line_type%TYPE,

24120: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
24121: p_chr_id IN okc_k_headers_v.id%TYPE,
24122: p_line_number IN okl_lines_interface.line_number%TYPE,
24123: p_line_type IN okl_lines_interface.line_type%TYPE,
24124: p_line_type_prev IN okl_lines_interface.line_type%TYPE,
24125: p_inv_item_id IN okl_lines_interface.inventory_item_id%TYPE,
24126: p_inv_org_id IN okl_header_interface.inventory_organization_id%TYPE,
24127: p_line_amount IN okl_lines_interface.amount%TYPE,
24128: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,

Line 24125: p_inv_item_id IN okl_lines_interface.inventory_item_id%TYPE,

24121: p_chr_id IN okc_k_headers_v.id%TYPE,
24122: p_line_number IN okl_lines_interface.line_number%TYPE,
24123: p_line_type IN okl_lines_interface.line_type%TYPE,
24124: p_line_type_prev IN okl_lines_interface.line_type%TYPE,
24125: p_inv_item_id IN okl_lines_interface.inventory_item_id%TYPE,
24126: p_inv_org_id IN okl_header_interface.inventory_organization_id%TYPE,
24127: p_line_amount IN okl_lines_interface.amount%TYPE,
24128: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,
24129: p_init_direct_cost IN okl_lines_interface.initial_direct_cost%TYPE,

Line 24127: p_line_amount IN okl_lines_interface.amount%TYPE,

24123: p_line_type IN okl_lines_interface.line_type%TYPE,
24124: p_line_type_prev IN okl_lines_interface.line_type%TYPE,
24125: p_inv_item_id IN okl_lines_interface.inventory_item_id%TYPE,
24126: p_inv_org_id IN okl_header_interface.inventory_organization_id%TYPE,
24127: p_line_amount IN okl_lines_interface.amount%TYPE,
24128: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,
24129: p_init_direct_cost IN okl_lines_interface.initial_direct_cost%TYPE,
24130: p_fee_code IN okl_lines_interface.fee_code%TYPE,
24131: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,

Line 24128: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,

24124: p_line_type_prev IN okl_lines_interface.line_type%TYPE,
24125: p_inv_item_id IN okl_lines_interface.inventory_item_id%TYPE,
24126: p_inv_org_id IN okl_header_interface.inventory_organization_id%TYPE,
24127: p_line_amount IN okl_lines_interface.amount%TYPE,
24128: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,
24129: p_init_direct_cost IN okl_lines_interface.initial_direct_cost%TYPE,
24130: p_fee_code IN okl_lines_interface.fee_code%TYPE,
24131: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
24132: p_fee_type IN okl_lines_interface.fee_type%TYPE,

Line 24129: p_init_direct_cost IN okl_lines_interface.initial_direct_cost%TYPE,

24125: p_inv_item_id IN okl_lines_interface.inventory_item_id%TYPE,
24126: p_inv_org_id IN okl_header_interface.inventory_organization_id%TYPE,
24127: p_line_amount IN okl_lines_interface.amount%TYPE,
24128: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,
24129: p_init_direct_cost IN okl_lines_interface.initial_direct_cost%TYPE,
24130: p_fee_code IN okl_lines_interface.fee_code%TYPE,
24131: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
24132: p_fee_type IN okl_lines_interface.fee_type%TYPE,
24133: p_asset_number IN okl_lines_interface.asset_number%TYPE,

Line 24130: p_fee_code IN okl_lines_interface.fee_code%TYPE,

24126: p_inv_org_id IN okl_header_interface.inventory_organization_id%TYPE,
24127: p_line_amount IN okl_lines_interface.amount%TYPE,
24128: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,
24129: p_init_direct_cost IN okl_lines_interface.initial_direct_cost%TYPE,
24130: p_fee_code IN okl_lines_interface.fee_code%TYPE,
24131: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
24132: p_fee_type IN okl_lines_interface.fee_type%TYPE,
24133: p_asset_number IN okl_lines_interface.asset_number%TYPE,
24134: p_currency_code IN okl_lines_interface.currency_code%TYPE,

Line 24131: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,

24127: p_line_amount IN okl_lines_interface.amount%TYPE,
24128: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,
24129: p_init_direct_cost IN okl_lines_interface.initial_direct_cost%TYPE,
24130: p_fee_code IN okl_lines_interface.fee_code%TYPE,
24131: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
24132: p_fee_type IN okl_lines_interface.fee_type%TYPE,
24133: p_asset_number IN okl_lines_interface.asset_number%TYPE,
24134: p_currency_code IN okl_lines_interface.currency_code%TYPE,
24135: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,

Line 24132: p_fee_type IN okl_lines_interface.fee_type%TYPE,

24128: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,
24129: p_init_direct_cost IN okl_lines_interface.initial_direct_cost%TYPE,
24130: p_fee_code IN okl_lines_interface.fee_code%TYPE,
24131: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
24132: p_fee_type IN okl_lines_interface.fee_type%TYPE,
24133: p_asset_number IN okl_lines_interface.asset_number%TYPE,
24134: p_currency_code IN okl_lines_interface.currency_code%TYPE,
24135: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,
24136: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,

Line 24133: p_asset_number IN okl_lines_interface.asset_number%TYPE,

24129: p_init_direct_cost IN okl_lines_interface.initial_direct_cost%TYPE,
24130: p_fee_code IN okl_lines_interface.fee_code%TYPE,
24131: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
24132: p_fee_type IN okl_lines_interface.fee_type%TYPE,
24133: p_asset_number IN okl_lines_interface.asset_number%TYPE,
24134: p_currency_code IN okl_lines_interface.currency_code%TYPE,
24135: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,
24136: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,
24137: p_header_start_date IN DATE,

Line 24134: p_currency_code IN okl_lines_interface.currency_code%TYPE,

24130: p_fee_code IN okl_lines_interface.fee_code%TYPE,
24131: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
24132: p_fee_type IN okl_lines_interface.fee_type%TYPE,
24133: p_asset_number IN okl_lines_interface.asset_number%TYPE,
24134: p_currency_code IN okl_lines_interface.currency_code%TYPE,
24135: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,
24136: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,
24137: p_header_start_date IN DATE,
24138: p_header_end_date IN DATE,

Line 24135: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,

24131: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
24132: p_fee_type IN okl_lines_interface.fee_type%TYPE,
24133: p_asset_number IN okl_lines_interface.asset_number%TYPE,
24134: p_currency_code IN okl_lines_interface.currency_code%TYPE,
24135: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,
24136: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,
24137: p_header_start_date IN DATE,
24138: p_header_end_date IN DATE,
24139: p_line_start_date IN DATE,

Line 24136: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,

24132: p_fee_type IN okl_lines_interface.fee_type%TYPE,
24133: p_asset_number IN okl_lines_interface.asset_number%TYPE,
24134: p_currency_code IN okl_lines_interface.currency_code%TYPE,
24135: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,
24136: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,
24137: p_header_start_date IN DATE,
24138: p_header_end_date IN DATE,
24139: p_line_start_date IN DATE,
24140: p_line_end_date IN DATE,

Line 24141: p_inv_item_id_prev IN okl_lines_interface.inventory_item_id%TYPE,

24137: p_header_start_date IN DATE,
24138: p_header_end_date IN DATE,
24139: p_line_start_date IN DATE,
24140: p_line_end_date IN DATE,
24141: p_inv_item_id_prev IN okl_lines_interface.inventory_item_id%TYPE,
24142: p_term_quote_id IN OKL_LINES_INTERFACE.TERMINATION_QUOTE_ID%TYPE,
24143: p_term_quote_number IN OKL_LINES_INTERFACE.TERMINATION_QUOTE_NUMBER%TYPE,
24144: x_inv_item_id_prev OUT NOCOPY okl_lines_interface.inventory_item_id%TYPE,
24145: p_cle_id IN okl_k_lines_v.id%TYPE,

Line 24142: p_term_quote_id IN OKL_LINES_INTERFACE.TERMINATION_QUOTE_ID%TYPE,

24138: p_header_end_date IN DATE,
24139: p_line_start_date IN DATE,
24140: p_line_end_date IN DATE,
24141: p_inv_item_id_prev IN okl_lines_interface.inventory_item_id%TYPE,
24142: p_term_quote_id IN OKL_LINES_INTERFACE.TERMINATION_QUOTE_ID%TYPE,
24143: p_term_quote_number IN OKL_LINES_INTERFACE.TERMINATION_QUOTE_NUMBER%TYPE,
24144: x_inv_item_id_prev OUT NOCOPY okl_lines_interface.inventory_item_id%TYPE,
24145: p_cle_id IN okl_k_lines_v.id%TYPE,
24146: x_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE,

Line 24143: p_term_quote_number IN OKL_LINES_INTERFACE.TERMINATION_QUOTE_NUMBER%TYPE,

24139: p_line_start_date IN DATE,
24140: p_line_end_date IN DATE,
24141: p_inv_item_id_prev IN okl_lines_interface.inventory_item_id%TYPE,
24142: p_term_quote_id IN OKL_LINES_INTERFACE.TERMINATION_QUOTE_ID%TYPE,
24143: p_term_quote_number IN OKL_LINES_INTERFACE.TERMINATION_QUOTE_NUMBER%TYPE,
24144: x_inv_item_id_prev OUT NOCOPY okl_lines_interface.inventory_item_id%TYPE,
24145: p_cle_id IN okl_k_lines_v.id%TYPE,
24146: x_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE,
24147: x_sub_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE, -- Bug# 3110115

Line 24144: x_inv_item_id_prev OUT NOCOPY okl_lines_interface.inventory_item_id%TYPE,

24140: p_line_end_date IN DATE,
24141: p_inv_item_id_prev IN okl_lines_interface.inventory_item_id%TYPE,
24142: p_term_quote_id IN OKL_LINES_INTERFACE.TERMINATION_QUOTE_ID%TYPE,
24143: p_term_quote_number IN OKL_LINES_INTERFACE.TERMINATION_QUOTE_NUMBER%TYPE,
24144: x_inv_item_id_prev OUT NOCOPY okl_lines_interface.inventory_item_id%TYPE,
24145: p_cle_id IN okl_k_lines_v.id%TYPE,
24146: x_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE,
24147: x_sub_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE, -- Bug# 3110115
24148: p_new_line_flag IN okl_lines_interface.explicit_new_line_flag%TYPE,

Line 24148: p_new_line_flag IN okl_lines_interface.explicit_new_line_flag%TYPE,

24144: x_inv_item_id_prev OUT NOCOPY okl_lines_interface.inventory_item_id%TYPE,
24145: p_cle_id IN okl_k_lines_v.id%TYPE,
24146: x_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE,
24147: x_sub_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE, -- Bug# 3110115
24148: p_new_line_flag IN okl_lines_interface.explicit_new_line_flag%TYPE,
24149: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
24150: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
24151: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
24152: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,

Line 24149: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,

24145: p_cle_id IN okl_k_lines_v.id%TYPE,
24146: x_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE,
24147: x_sub_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE, -- Bug# 3110115
24148: p_new_line_flag IN okl_lines_interface.explicit_new_line_flag%TYPE,
24149: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
24150: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
24151: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
24152: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,
24153: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,

Line 24150: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,

24146: x_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE,
24147: x_sub_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE, -- Bug# 3110115
24148: p_new_line_flag IN okl_lines_interface.explicit_new_line_flag%TYPE,
24149: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
24150: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
24151: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
24152: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,
24153: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,
24154: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,

Line 24151: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,

24147: x_sub_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE, -- Bug# 3110115
24148: p_new_line_flag IN okl_lines_interface.explicit_new_line_flag%TYPE,
24149: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
24150: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
24151: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
24152: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,
24153: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,
24154: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,
24155: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,

Line 24152: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,

24148: p_new_line_flag IN okl_lines_interface.explicit_new_line_flag%TYPE,
24149: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
24150: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
24151: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
24152: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,
24153: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,
24154: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,
24155: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
24156: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,

Line 24153: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,

24149: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
24150: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
24151: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
24152: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,
24153: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,
24154: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,
24155: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
24156: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
24157: p_fee_purpose_code IN okl_lines_interface.fee_purpose_code%TYPE,

Line 24154: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,

24150: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
24151: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
24152: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,
24153: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,
24154: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,
24155: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
24156: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
24157: p_fee_purpose_code IN okl_lines_interface.fee_purpose_code%TYPE,
24158: --Bug# 11690042

Line 24155: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,

24151: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
24152: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,
24153: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,
24154: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,
24155: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
24156: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
24157: p_fee_purpose_code IN okl_lines_interface.fee_purpose_code%TYPE,
24158: --Bug# 11690042
24159: p_attribute_category IN okl_lines_interface.attribute_category%TYPE DEFAULT NULL,

Line 24156: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,

24152: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,
24153: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,
24154: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,
24155: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
24156: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
24157: p_fee_purpose_code IN okl_lines_interface.fee_purpose_code%TYPE,
24158: --Bug# 11690042
24159: p_attribute_category IN okl_lines_interface.attribute_category%TYPE DEFAULT NULL,
24160: p_attribute1 IN okl_lines_interface.attribute1%TYPE DEFAULT NULL,

Line 24157: p_fee_purpose_code IN okl_lines_interface.fee_purpose_code%TYPE,

24153: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,
24154: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,
24155: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
24156: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
24157: p_fee_purpose_code IN okl_lines_interface.fee_purpose_code%TYPE,
24158: --Bug# 11690042
24159: p_attribute_category IN okl_lines_interface.attribute_category%TYPE DEFAULT NULL,
24160: p_attribute1 IN okl_lines_interface.attribute1%TYPE DEFAULT NULL,
24161: p_attribute2 IN okl_lines_interface.attribute2%TYPE DEFAULT NULL,

Line 24159: p_attribute_category IN okl_lines_interface.attribute_category%TYPE DEFAULT NULL,

24155: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
24156: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
24157: p_fee_purpose_code IN okl_lines_interface.fee_purpose_code%TYPE,
24158: --Bug# 11690042
24159: p_attribute_category IN okl_lines_interface.attribute_category%TYPE DEFAULT NULL,
24160: p_attribute1 IN okl_lines_interface.attribute1%TYPE DEFAULT NULL,
24161: p_attribute2 IN okl_lines_interface.attribute2%TYPE DEFAULT NULL,
24162: p_attribute3 IN okl_lines_interface.attribute3%TYPE DEFAULT NULL,
24163: p_attribute4 IN okl_lines_interface.attribute4%TYPE DEFAULT NULL,

Line 24160: p_attribute1 IN okl_lines_interface.attribute1%TYPE DEFAULT NULL,

24156: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
24157: p_fee_purpose_code IN okl_lines_interface.fee_purpose_code%TYPE,
24158: --Bug# 11690042
24159: p_attribute_category IN okl_lines_interface.attribute_category%TYPE DEFAULT NULL,
24160: p_attribute1 IN okl_lines_interface.attribute1%TYPE DEFAULT NULL,
24161: p_attribute2 IN okl_lines_interface.attribute2%TYPE DEFAULT NULL,
24162: p_attribute3 IN okl_lines_interface.attribute3%TYPE DEFAULT NULL,
24163: p_attribute4 IN okl_lines_interface.attribute4%TYPE DEFAULT NULL,
24164: p_attribute5 IN okl_lines_interface.attribute5%TYPE DEFAULT NULL,

Line 24161: p_attribute2 IN okl_lines_interface.attribute2%TYPE DEFAULT NULL,

24157: p_fee_purpose_code IN okl_lines_interface.fee_purpose_code%TYPE,
24158: --Bug# 11690042
24159: p_attribute_category IN okl_lines_interface.attribute_category%TYPE DEFAULT NULL,
24160: p_attribute1 IN okl_lines_interface.attribute1%TYPE DEFAULT NULL,
24161: p_attribute2 IN okl_lines_interface.attribute2%TYPE DEFAULT NULL,
24162: p_attribute3 IN okl_lines_interface.attribute3%TYPE DEFAULT NULL,
24163: p_attribute4 IN okl_lines_interface.attribute4%TYPE DEFAULT NULL,
24164: p_attribute5 IN okl_lines_interface.attribute5%TYPE DEFAULT NULL,
24165: p_attribute6 IN okl_lines_interface.attribute6%TYPE DEFAULT NULL,

Line 24162: p_attribute3 IN okl_lines_interface.attribute3%TYPE DEFAULT NULL,

24158: --Bug# 11690042
24159: p_attribute_category IN okl_lines_interface.attribute_category%TYPE DEFAULT NULL,
24160: p_attribute1 IN okl_lines_interface.attribute1%TYPE DEFAULT NULL,
24161: p_attribute2 IN okl_lines_interface.attribute2%TYPE DEFAULT NULL,
24162: p_attribute3 IN okl_lines_interface.attribute3%TYPE DEFAULT NULL,
24163: p_attribute4 IN okl_lines_interface.attribute4%TYPE DEFAULT NULL,
24164: p_attribute5 IN okl_lines_interface.attribute5%TYPE DEFAULT NULL,
24165: p_attribute6 IN okl_lines_interface.attribute6%TYPE DEFAULT NULL,
24166: p_attribute7 IN okl_lines_interface.attribute7%TYPE DEFAULT NULL,

Line 24163: p_attribute4 IN okl_lines_interface.attribute4%TYPE DEFAULT NULL,

24159: p_attribute_category IN okl_lines_interface.attribute_category%TYPE DEFAULT NULL,
24160: p_attribute1 IN okl_lines_interface.attribute1%TYPE DEFAULT NULL,
24161: p_attribute2 IN okl_lines_interface.attribute2%TYPE DEFAULT NULL,
24162: p_attribute3 IN okl_lines_interface.attribute3%TYPE DEFAULT NULL,
24163: p_attribute4 IN okl_lines_interface.attribute4%TYPE DEFAULT NULL,
24164: p_attribute5 IN okl_lines_interface.attribute5%TYPE DEFAULT NULL,
24165: p_attribute6 IN okl_lines_interface.attribute6%TYPE DEFAULT NULL,
24166: p_attribute7 IN okl_lines_interface.attribute7%TYPE DEFAULT NULL,
24167: p_attribute8 IN okl_lines_interface.attribute8%TYPE DEFAULT NULL,

Line 24164: p_attribute5 IN okl_lines_interface.attribute5%TYPE DEFAULT NULL,

24160: p_attribute1 IN okl_lines_interface.attribute1%TYPE DEFAULT NULL,
24161: p_attribute2 IN okl_lines_interface.attribute2%TYPE DEFAULT NULL,
24162: p_attribute3 IN okl_lines_interface.attribute3%TYPE DEFAULT NULL,
24163: p_attribute4 IN okl_lines_interface.attribute4%TYPE DEFAULT NULL,
24164: p_attribute5 IN okl_lines_interface.attribute5%TYPE DEFAULT NULL,
24165: p_attribute6 IN okl_lines_interface.attribute6%TYPE DEFAULT NULL,
24166: p_attribute7 IN okl_lines_interface.attribute7%TYPE DEFAULT NULL,
24167: p_attribute8 IN okl_lines_interface.attribute8%TYPE DEFAULT NULL,
24168: p_attribute9 IN okl_lines_interface.attribute9%TYPE DEFAULT NULL,

Line 24165: p_attribute6 IN okl_lines_interface.attribute6%TYPE DEFAULT NULL,

24161: p_attribute2 IN okl_lines_interface.attribute2%TYPE DEFAULT NULL,
24162: p_attribute3 IN okl_lines_interface.attribute3%TYPE DEFAULT NULL,
24163: p_attribute4 IN okl_lines_interface.attribute4%TYPE DEFAULT NULL,
24164: p_attribute5 IN okl_lines_interface.attribute5%TYPE DEFAULT NULL,
24165: p_attribute6 IN okl_lines_interface.attribute6%TYPE DEFAULT NULL,
24166: p_attribute7 IN okl_lines_interface.attribute7%TYPE DEFAULT NULL,
24167: p_attribute8 IN okl_lines_interface.attribute8%TYPE DEFAULT NULL,
24168: p_attribute9 IN okl_lines_interface.attribute9%TYPE DEFAULT NULL,
24169: p_attribute10 IN okl_lines_interface.attribute10%TYPE DEFAULT NULL,

Line 24166: p_attribute7 IN okl_lines_interface.attribute7%TYPE DEFAULT NULL,

24162: p_attribute3 IN okl_lines_interface.attribute3%TYPE DEFAULT NULL,
24163: p_attribute4 IN okl_lines_interface.attribute4%TYPE DEFAULT NULL,
24164: p_attribute5 IN okl_lines_interface.attribute5%TYPE DEFAULT NULL,
24165: p_attribute6 IN okl_lines_interface.attribute6%TYPE DEFAULT NULL,
24166: p_attribute7 IN okl_lines_interface.attribute7%TYPE DEFAULT NULL,
24167: p_attribute8 IN okl_lines_interface.attribute8%TYPE DEFAULT NULL,
24168: p_attribute9 IN okl_lines_interface.attribute9%TYPE DEFAULT NULL,
24169: p_attribute10 IN okl_lines_interface.attribute10%TYPE DEFAULT NULL,
24170: p_attribute11 IN okl_lines_interface.attribute11%TYPE DEFAULT NULL,

Line 24167: p_attribute8 IN okl_lines_interface.attribute8%TYPE DEFAULT NULL,

24163: p_attribute4 IN okl_lines_interface.attribute4%TYPE DEFAULT NULL,
24164: p_attribute5 IN okl_lines_interface.attribute5%TYPE DEFAULT NULL,
24165: p_attribute6 IN okl_lines_interface.attribute6%TYPE DEFAULT NULL,
24166: p_attribute7 IN okl_lines_interface.attribute7%TYPE DEFAULT NULL,
24167: p_attribute8 IN okl_lines_interface.attribute8%TYPE DEFAULT NULL,
24168: p_attribute9 IN okl_lines_interface.attribute9%TYPE DEFAULT NULL,
24169: p_attribute10 IN okl_lines_interface.attribute10%TYPE DEFAULT NULL,
24170: p_attribute11 IN okl_lines_interface.attribute11%TYPE DEFAULT NULL,
24171: p_attribute12 IN okl_lines_interface.attribute12%TYPE DEFAULT NULL,

Line 24168: p_attribute9 IN okl_lines_interface.attribute9%TYPE DEFAULT NULL,

24164: p_attribute5 IN okl_lines_interface.attribute5%TYPE DEFAULT NULL,
24165: p_attribute6 IN okl_lines_interface.attribute6%TYPE DEFAULT NULL,
24166: p_attribute7 IN okl_lines_interface.attribute7%TYPE DEFAULT NULL,
24167: p_attribute8 IN okl_lines_interface.attribute8%TYPE DEFAULT NULL,
24168: p_attribute9 IN okl_lines_interface.attribute9%TYPE DEFAULT NULL,
24169: p_attribute10 IN okl_lines_interface.attribute10%TYPE DEFAULT NULL,
24170: p_attribute11 IN okl_lines_interface.attribute11%TYPE DEFAULT NULL,
24171: p_attribute12 IN okl_lines_interface.attribute12%TYPE DEFAULT NULL,
24172: p_attribute13 IN okl_lines_interface.attribute13%TYPE DEFAULT NULL,

Line 24169: p_attribute10 IN okl_lines_interface.attribute10%TYPE DEFAULT NULL,

24165: p_attribute6 IN okl_lines_interface.attribute6%TYPE DEFAULT NULL,
24166: p_attribute7 IN okl_lines_interface.attribute7%TYPE DEFAULT NULL,
24167: p_attribute8 IN okl_lines_interface.attribute8%TYPE DEFAULT NULL,
24168: p_attribute9 IN okl_lines_interface.attribute9%TYPE DEFAULT NULL,
24169: p_attribute10 IN okl_lines_interface.attribute10%TYPE DEFAULT NULL,
24170: p_attribute11 IN okl_lines_interface.attribute11%TYPE DEFAULT NULL,
24171: p_attribute12 IN okl_lines_interface.attribute12%TYPE DEFAULT NULL,
24172: p_attribute13 IN okl_lines_interface.attribute13%TYPE DEFAULT NULL,
24173: p_attribute14 IN okl_lines_interface.attribute14%TYPE DEFAULT NULL,

Line 24170: p_attribute11 IN okl_lines_interface.attribute11%TYPE DEFAULT NULL,

24166: p_attribute7 IN okl_lines_interface.attribute7%TYPE DEFAULT NULL,
24167: p_attribute8 IN okl_lines_interface.attribute8%TYPE DEFAULT NULL,
24168: p_attribute9 IN okl_lines_interface.attribute9%TYPE DEFAULT NULL,
24169: p_attribute10 IN okl_lines_interface.attribute10%TYPE DEFAULT NULL,
24170: p_attribute11 IN okl_lines_interface.attribute11%TYPE DEFAULT NULL,
24171: p_attribute12 IN okl_lines_interface.attribute12%TYPE DEFAULT NULL,
24172: p_attribute13 IN okl_lines_interface.attribute13%TYPE DEFAULT NULL,
24173: p_attribute14 IN okl_lines_interface.attribute14%TYPE DEFAULT NULL,
24174: p_attribute15 IN okl_lines_interface.attribute15%TYPE DEFAULT NULL,

Line 24171: p_attribute12 IN okl_lines_interface.attribute12%TYPE DEFAULT NULL,

24167: p_attribute8 IN okl_lines_interface.attribute8%TYPE DEFAULT NULL,
24168: p_attribute9 IN okl_lines_interface.attribute9%TYPE DEFAULT NULL,
24169: p_attribute10 IN okl_lines_interface.attribute10%TYPE DEFAULT NULL,
24170: p_attribute11 IN okl_lines_interface.attribute11%TYPE DEFAULT NULL,
24171: p_attribute12 IN okl_lines_interface.attribute12%TYPE DEFAULT NULL,
24172: p_attribute13 IN okl_lines_interface.attribute13%TYPE DEFAULT NULL,
24173: p_attribute14 IN okl_lines_interface.attribute14%TYPE DEFAULT NULL,
24174: p_attribute15 IN okl_lines_interface.attribute15%TYPE DEFAULT NULL,
24175: p_origination_income IN okl_lines_interface.origination_income%TYPE DEFAULT NULL

Line 24172: p_attribute13 IN okl_lines_interface.attribute13%TYPE DEFAULT NULL,

24168: p_attribute9 IN okl_lines_interface.attribute9%TYPE DEFAULT NULL,
24169: p_attribute10 IN okl_lines_interface.attribute10%TYPE DEFAULT NULL,
24170: p_attribute11 IN okl_lines_interface.attribute11%TYPE DEFAULT NULL,
24171: p_attribute12 IN okl_lines_interface.attribute12%TYPE DEFAULT NULL,
24172: p_attribute13 IN okl_lines_interface.attribute13%TYPE DEFAULT NULL,
24173: p_attribute14 IN okl_lines_interface.attribute14%TYPE DEFAULT NULL,
24174: p_attribute15 IN okl_lines_interface.attribute15%TYPE DEFAULT NULL,
24175: p_origination_income IN okl_lines_interface.origination_income%TYPE DEFAULT NULL
24176: ) IS

Line 24173: p_attribute14 IN okl_lines_interface.attribute14%TYPE DEFAULT NULL,

24169: p_attribute10 IN okl_lines_interface.attribute10%TYPE DEFAULT NULL,
24170: p_attribute11 IN okl_lines_interface.attribute11%TYPE DEFAULT NULL,
24171: p_attribute12 IN okl_lines_interface.attribute12%TYPE DEFAULT NULL,
24172: p_attribute13 IN okl_lines_interface.attribute13%TYPE DEFAULT NULL,
24173: p_attribute14 IN okl_lines_interface.attribute14%TYPE DEFAULT NULL,
24174: p_attribute15 IN okl_lines_interface.attribute15%TYPE DEFAULT NULL,
24175: p_origination_income IN okl_lines_interface.origination_income%TYPE DEFAULT NULL
24176: ) IS
24177: l_proc_name VARCHAR2(35) := 'PROCESS_OTHER_LINE';

Line 24174: p_attribute15 IN okl_lines_interface.attribute15%TYPE DEFAULT NULL,

24170: p_attribute11 IN okl_lines_interface.attribute11%TYPE DEFAULT NULL,
24171: p_attribute12 IN okl_lines_interface.attribute12%TYPE DEFAULT NULL,
24172: p_attribute13 IN okl_lines_interface.attribute13%TYPE DEFAULT NULL,
24173: p_attribute14 IN okl_lines_interface.attribute14%TYPE DEFAULT NULL,
24174: p_attribute15 IN okl_lines_interface.attribute15%TYPE DEFAULT NULL,
24175: p_origination_income IN okl_lines_interface.origination_income%TYPE DEFAULT NULL
24176: ) IS
24177: l_proc_name VARCHAR2(35) := 'PROCESS_OTHER_LINE';
24178: x_lse_id okc_line_styles_v.id%TYPE;

Line 24175: p_origination_income IN okl_lines_interface.origination_income%TYPE DEFAULT NULL

24171: p_attribute12 IN okl_lines_interface.attribute12%TYPE DEFAULT NULL,
24172: p_attribute13 IN okl_lines_interface.attribute13%TYPE DEFAULT NULL,
24173: p_attribute14 IN okl_lines_interface.attribute14%TYPE DEFAULT NULL,
24174: p_attribute15 IN okl_lines_interface.attribute15%TYPE DEFAULT NULL,
24175: p_origination_income IN okl_lines_interface.origination_income%TYPE DEFAULT NULL
24176: ) IS
24177: l_proc_name VARCHAR2(35) := 'PROCESS_OTHER_LINE';
24178: x_lse_id okc_line_styles_v.id%TYPE;
24179: x_inv_org_id NUMBER;

Line 24210: p_line_number OKL_LINES_INTERFACE.LINE_NUMBER%TYPE) IS

24206:
24207: x_term_quote_id NUMBER;
24208:
24209: CURSOR fee_vendor_csr (p_contract_number OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,
24210: p_line_number OKL_LINES_INTERFACE.LINE_NUMBER%TYPE) IS
24211: SELECT fees_vendor_name,
24212: fees_vendor_id
24213: FROM okl_party_roles_interface
24214: WHERE contract_number_old = p_contract_number

Line 26064: p_line_number IN OKL_LINES_INTERFACE.LINE_NUMBER%TYPE,

26060: x_return_status OUT NOCOPY VARCHAR2,
26061: x_msg_count OUT NOCOPY VARCHAR2,
26062: x_msg_data OUT NOCOPY VARCHAR2,
26063: p_contract_number IN OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,
26064: p_line_number IN OKL_LINES_INTERFACE.LINE_NUMBER%TYPE,
26065: x_payment_level OUT NOCOPY VARCHAR2
26066: ) IS
26067:
26068: l_proc_name VARCHAR2(35) := 'CHECK_PAYMENT_LEVEL';

Line 26071: p_line OKL_LINES_INTERFACE.LINE_NUMBER%TYPE) IS

26067:
26068: l_proc_name VARCHAR2(35) := 'CHECK_PAYMENT_LEVEL';
26069:
26070: CURSOR line_csr (p_cont_number OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,
26071: p_line OKL_LINES_INTERFACE.LINE_NUMBER%TYPE) IS
26072: SELECT line_type,
26073: asset_number
26074: FROM okl_lines_interface
26075: WHERE contract_number_old = p_cont_number

Line 26074: FROM okl_lines_interface

26070: CURSOR line_csr (p_cont_number OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,
26071: p_line OKL_LINES_INTERFACE.LINE_NUMBER%TYPE) IS
26072: SELECT line_type,
26073: asset_number
26074: FROM okl_lines_interface
26075: WHERE contract_number_old = p_cont_number
26076: AND line_number = p_line;
26077:
26078: l_line_type OKL_LINES_INTERFACE.LINE_TYPE%TYPE;

Line 26078: l_line_type OKL_LINES_INTERFACE.LINE_TYPE%TYPE;

26074: FROM okl_lines_interface
26075: WHERE contract_number_old = p_cont_number
26076: AND line_number = p_line;
26077:
26078: l_line_type OKL_LINES_INTERFACE.LINE_TYPE%TYPE;
26079: l_asset_number OKL_LINES_INTERFACE.ASSET_NUMBER%TYPE;
26080:
26081: BEGIN
26082: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 26079: l_asset_number OKL_LINES_INTERFACE.ASSET_NUMBER%TYPE;

26075: WHERE contract_number_old = p_cont_number
26076: AND line_number = p_line;
26077:
26078: l_line_type OKL_LINES_INTERFACE.LINE_TYPE%TYPE;
26079: l_asset_number OKL_LINES_INTERFACE.ASSET_NUMBER%TYPE;
26080:
26081: BEGIN
26082: x_return_status := OKL_API.G_RET_STS_SUCCESS;
26083: debug_message(l_proc_name);

Line 26454: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,

26450: p_asset_number IN VARCHAR2,
26451: p_asset_id IN OKL_LA_RELEASE_ASSETS_UV.ASSET_ID%TYPE,
26452: p_line_number IN NUMBER,
26453: p_re_lease_yn IN VARCHAR2, -- Bug #15992711 : added new parameter, to pass value of re_lease_yn flag
26454: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
26455: p_install_site_num IN okl_lines_interface.install_site_number%TYPE,
26456: p_unit_price IN okl_lines_interface.original_cost%TYPE,
26457: p_deprn_method IN okl_lines_interface.depreciation_method_code%TYPE,
26458: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,

Line 26455: p_install_site_num IN okl_lines_interface.install_site_number%TYPE,

26451: p_asset_id IN OKL_LA_RELEASE_ASSETS_UV.ASSET_ID%TYPE,
26452: p_line_number IN NUMBER,
26453: p_re_lease_yn IN VARCHAR2, -- Bug #15992711 : added new parameter, to pass value of re_lease_yn flag
26454: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
26455: p_install_site_num IN okl_lines_interface.install_site_number%TYPE,
26456: p_unit_price IN okl_lines_interface.original_cost%TYPE,
26457: p_deprn_method IN okl_lines_interface.depreciation_method_code%TYPE,
26458: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,
26459: p_deprn_rate IN okl_lines_interface.depreciation_rate%TYPE,

Line 26456: p_unit_price IN okl_lines_interface.original_cost%TYPE,

26452: p_line_number IN NUMBER,
26453: p_re_lease_yn IN VARCHAR2, -- Bug #15992711 : added new parameter, to pass value of re_lease_yn flag
26454: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
26455: p_install_site_num IN okl_lines_interface.install_site_number%TYPE,
26456: p_unit_price IN okl_lines_interface.original_cost%TYPE,
26457: p_deprn_method IN okl_lines_interface.depreciation_method_code%TYPE,
26458: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,
26459: p_deprn_rate IN okl_lines_interface.depreciation_rate%TYPE,
26460: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,

Line 26457: p_deprn_method IN okl_lines_interface.depreciation_method_code%TYPE,

26453: p_re_lease_yn IN VARCHAR2, -- Bug #15992711 : added new parameter, to pass value of re_lease_yn flag
26454: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
26455: p_install_site_num IN okl_lines_interface.install_site_number%TYPE,
26456: p_unit_price IN okl_lines_interface.original_cost%TYPE,
26457: p_deprn_method IN okl_lines_interface.depreciation_method_code%TYPE,
26458: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,
26459: p_deprn_rate IN okl_lines_interface.depreciation_rate%TYPE,
26460: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,
26461: p_asset_loc_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,

Line 26458: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,

26454: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
26455: p_install_site_num IN okl_lines_interface.install_site_number%TYPE,
26456: p_unit_price IN okl_lines_interface.original_cost%TYPE,
26457: p_deprn_method IN okl_lines_interface.depreciation_method_code%TYPE,
26458: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,
26459: p_deprn_rate IN okl_lines_interface.depreciation_rate%TYPE,
26460: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,
26461: p_asset_loc_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,
26462: p_asset_loc_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,

Line 26459: p_deprn_rate IN okl_lines_interface.depreciation_rate%TYPE,

26455: p_install_site_num IN okl_lines_interface.install_site_number%TYPE,
26456: p_unit_price IN okl_lines_interface.original_cost%TYPE,
26457: p_deprn_method IN okl_lines_interface.depreciation_method_code%TYPE,
26458: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,
26459: p_deprn_rate IN okl_lines_interface.depreciation_rate%TYPE,
26460: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,
26461: p_asset_loc_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,
26462: p_asset_loc_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,
26463: p_asset_loc_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,

Line 26460: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,

26456: p_unit_price IN okl_lines_interface.original_cost%TYPE,
26457: p_deprn_method IN okl_lines_interface.depreciation_method_code%TYPE,
26458: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,
26459: p_deprn_rate IN okl_lines_interface.depreciation_rate%TYPE,
26460: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,
26461: p_asset_loc_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,
26462: p_asset_loc_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,
26463: p_asset_loc_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,
26464: p_asset_loc_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,

Line 26461: p_asset_loc_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,

26457: p_deprn_method IN okl_lines_interface.depreciation_method_code%TYPE,
26458: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,
26459: p_deprn_rate IN okl_lines_interface.depreciation_rate%TYPE,
26460: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,
26461: p_asset_loc_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,
26462: p_asset_loc_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,
26463: p_asset_loc_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,
26464: p_asset_loc_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,
26465: p_asset_loc_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,

Line 26462: p_asset_loc_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,

26458: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,
26459: p_deprn_rate IN okl_lines_interface.depreciation_rate%TYPE,
26460: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,
26461: p_asset_loc_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,
26462: p_asset_loc_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,
26463: p_asset_loc_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,
26464: p_asset_loc_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,
26465: p_asset_loc_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,
26466: p_asset_loc_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,

Line 26463: p_asset_loc_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,

26459: p_deprn_rate IN okl_lines_interface.depreciation_rate%TYPE,
26460: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,
26461: p_asset_loc_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,
26462: p_asset_loc_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,
26463: p_asset_loc_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,
26464: p_asset_loc_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,
26465: p_asset_loc_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,
26466: p_asset_loc_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
26467: p_asset_loc_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,

Line 26464: p_asset_loc_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,

26460: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,
26461: p_asset_loc_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,
26462: p_asset_loc_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,
26463: p_asset_loc_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,
26464: p_asset_loc_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,
26465: p_asset_loc_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,
26466: p_asset_loc_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
26467: p_asset_loc_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
26468: p_salvage_value IN okl_lines_interface.salvage_value%TYPE,

Line 26465: p_asset_loc_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,

26461: p_asset_loc_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,
26462: p_asset_loc_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,
26463: p_asset_loc_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,
26464: p_asset_loc_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,
26465: p_asset_loc_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,
26466: p_asset_loc_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
26467: p_asset_loc_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
26468: p_salvage_value IN okl_lines_interface.salvage_value%TYPE,
26469: p_salvage_ptg IN okl_lines_interface.salvage_value_percent%TYPE,

Line 26466: p_asset_loc_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,

26462: p_asset_loc_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,
26463: p_asset_loc_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,
26464: p_asset_loc_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,
26465: p_asset_loc_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,
26466: p_asset_loc_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
26467: p_asset_loc_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
26468: p_salvage_value IN okl_lines_interface.salvage_value%TYPE,
26469: p_salvage_ptg IN okl_lines_interface.salvage_value_percent%TYPE,
26470: p_residual_grnty_amt IN okl_lines_interface.residual_amount_guarantee%TYPE,

Line 26467: p_asset_loc_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,

26463: p_asset_loc_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,
26464: p_asset_loc_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,
26465: p_asset_loc_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,
26466: p_asset_loc_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
26467: p_asset_loc_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
26468: p_salvage_value IN okl_lines_interface.salvage_value%TYPE,
26469: p_salvage_ptg IN okl_lines_interface.salvage_value_percent%TYPE,
26470: p_residual_grnty_amt IN okl_lines_interface.residual_amount_guarantee%TYPE,
26471: p_residual_code IN okl_lines_interface.guarantor_type_code%TYPE,

Line 26468: p_salvage_value IN okl_lines_interface.salvage_value%TYPE,

26464: p_asset_loc_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,
26465: p_asset_loc_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,
26466: p_asset_loc_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
26467: p_asset_loc_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
26468: p_salvage_value IN okl_lines_interface.salvage_value%TYPE,
26469: p_salvage_ptg IN okl_lines_interface.salvage_value_percent%TYPE,
26470: p_residual_grnty_amt IN okl_lines_interface.residual_amount_guarantee%TYPE,
26471: p_residual_code IN okl_lines_interface.guarantor_type_code%TYPE,
26472: p_residual_ptg IN okl_lines_interface.residual_percent%TYPE,

Line 26469: p_salvage_ptg IN okl_lines_interface.salvage_value_percent%TYPE,

26465: p_asset_loc_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,
26466: p_asset_loc_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
26467: p_asset_loc_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
26468: p_salvage_value IN okl_lines_interface.salvage_value%TYPE,
26469: p_salvage_ptg IN okl_lines_interface.salvage_value_percent%TYPE,
26470: p_residual_grnty_amt IN okl_lines_interface.residual_amount_guarantee%TYPE,
26471: p_residual_code IN okl_lines_interface.guarantor_type_code%TYPE,
26472: p_residual_ptg IN okl_lines_interface.residual_percent%TYPE,
26473: p_residual_amt IN okl_lines_interface.residual_amount%TYPE,

Line 26470: p_residual_grnty_amt IN okl_lines_interface.residual_amount_guarantee%TYPE,

26466: p_asset_loc_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
26467: p_asset_loc_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
26468: p_salvage_value IN okl_lines_interface.salvage_value%TYPE,
26469: p_salvage_ptg IN okl_lines_interface.salvage_value_percent%TYPE,
26470: p_residual_grnty_amt IN okl_lines_interface.residual_amount_guarantee%TYPE,
26471: p_residual_code IN okl_lines_interface.guarantor_type_code%TYPE,
26472: p_residual_ptg IN okl_lines_interface.residual_percent%TYPE,
26473: p_residual_amt IN okl_lines_interface.residual_amount%TYPE,
26474: p_tax_book IN okl_lines_interface.tax_book%TYPE,

Line 26471: p_residual_code IN okl_lines_interface.guarantor_type_code%TYPE,

26467: p_asset_loc_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
26468: p_salvage_value IN okl_lines_interface.salvage_value%TYPE,
26469: p_salvage_ptg IN okl_lines_interface.salvage_value_percent%TYPE,
26470: p_residual_grnty_amt IN okl_lines_interface.residual_amount_guarantee%TYPE,
26471: p_residual_code IN okl_lines_interface.guarantor_type_code%TYPE,
26472: p_residual_ptg IN okl_lines_interface.residual_percent%TYPE,
26473: p_residual_amt IN okl_lines_interface.residual_amount%TYPE,
26474: p_tax_book IN okl_lines_interface.tax_book%TYPE,
26475: p_tax_deprn IN okl_lines_interface.deprn_method_tax%TYPE,

Line 26472: p_residual_ptg IN okl_lines_interface.residual_percent%TYPE,

26468: p_salvage_value IN okl_lines_interface.salvage_value%TYPE,
26469: p_salvage_ptg IN okl_lines_interface.salvage_value_percent%TYPE,
26470: p_residual_grnty_amt IN okl_lines_interface.residual_amount_guarantee%TYPE,
26471: p_residual_code IN okl_lines_interface.guarantor_type_code%TYPE,
26472: p_residual_ptg IN okl_lines_interface.residual_percent%TYPE,
26473: p_residual_amt IN okl_lines_interface.residual_amount%TYPE,
26474: p_tax_book IN okl_lines_interface.tax_book%TYPE,
26475: p_tax_deprn IN okl_lines_interface.deprn_method_tax%TYPE,
26476: p_tax_life_in_mnth IN okl_lines_interface.life_in_months_tax%TYPE,

Line 26473: p_residual_amt IN okl_lines_interface.residual_amount%TYPE,

26469: p_salvage_ptg IN okl_lines_interface.salvage_value_percent%TYPE,
26470: p_residual_grnty_amt IN okl_lines_interface.residual_amount_guarantee%TYPE,
26471: p_residual_code IN okl_lines_interface.guarantor_type_code%TYPE,
26472: p_residual_ptg IN okl_lines_interface.residual_percent%TYPE,
26473: p_residual_amt IN okl_lines_interface.residual_amount%TYPE,
26474: p_tax_book IN okl_lines_interface.tax_book%TYPE,
26475: p_tax_deprn IN okl_lines_interface.deprn_method_tax%TYPE,
26476: p_tax_life_in_mnth IN okl_lines_interface.life_in_months_tax%TYPE,
26477: p_tax_deprn_rate IN okl_lines_interface.deprn_rate_tax%TYPE,

Line 26474: p_tax_book IN okl_lines_interface.tax_book%TYPE,

26470: p_residual_grnty_amt IN okl_lines_interface.residual_amount_guarantee%TYPE,
26471: p_residual_code IN okl_lines_interface.guarantor_type_code%TYPE,
26472: p_residual_ptg IN okl_lines_interface.residual_percent%TYPE,
26473: p_residual_amt IN okl_lines_interface.residual_amount%TYPE,
26474: p_tax_book IN okl_lines_interface.tax_book%TYPE,
26475: p_tax_deprn IN okl_lines_interface.deprn_method_tax%TYPE,
26476: p_tax_life_in_mnth IN okl_lines_interface.life_in_months_tax%TYPE,
26477: p_tax_deprn_rate IN okl_lines_interface.deprn_rate_tax%TYPE,
26478: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,

Line 26475: p_tax_deprn IN okl_lines_interface.deprn_method_tax%TYPE,

26471: p_residual_code IN okl_lines_interface.guarantor_type_code%TYPE,
26472: p_residual_ptg IN okl_lines_interface.residual_percent%TYPE,
26473: p_residual_amt IN okl_lines_interface.residual_amount%TYPE,
26474: p_tax_book IN okl_lines_interface.tax_book%TYPE,
26475: p_tax_deprn IN okl_lines_interface.deprn_method_tax%TYPE,
26476: p_tax_life_in_mnth IN okl_lines_interface.life_in_months_tax%TYPE,
26477: p_tax_deprn_rate IN okl_lines_interface.deprn_rate_tax%TYPE,
26478: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
26479: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,

Line 26476: p_tax_life_in_mnth IN okl_lines_interface.life_in_months_tax%TYPE,

26472: p_residual_ptg IN okl_lines_interface.residual_percent%TYPE,
26473: p_residual_amt IN okl_lines_interface.residual_amount%TYPE,
26474: p_tax_book IN okl_lines_interface.tax_book%TYPE,
26475: p_tax_deprn IN okl_lines_interface.deprn_method_tax%TYPE,
26476: p_tax_life_in_mnth IN okl_lines_interface.life_in_months_tax%TYPE,
26477: p_tax_deprn_rate IN okl_lines_interface.deprn_rate_tax%TYPE,
26478: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
26479: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
26480: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,

Line 26477: p_tax_deprn_rate IN okl_lines_interface.deprn_rate_tax%TYPE,

26473: p_residual_amt IN okl_lines_interface.residual_amount%TYPE,
26474: p_tax_book IN okl_lines_interface.tax_book%TYPE,
26475: p_tax_deprn IN okl_lines_interface.deprn_method_tax%TYPE,
26476: p_tax_life_in_mnth IN okl_lines_interface.life_in_months_tax%TYPE,
26477: p_tax_deprn_rate IN okl_lines_interface.deprn_rate_tax%TYPE,
26478: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
26479: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
26480: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
26481: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,

Line 26478: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,

26474: p_tax_book IN okl_lines_interface.tax_book%TYPE,
26475: p_tax_deprn IN okl_lines_interface.deprn_method_tax%TYPE,
26476: p_tax_life_in_mnth IN okl_lines_interface.life_in_months_tax%TYPE,
26477: p_tax_deprn_rate IN okl_lines_interface.deprn_rate_tax%TYPE,
26478: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
26479: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
26480: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
26481: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,
26482: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,

Line 26479: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,

26475: p_tax_deprn IN okl_lines_interface.deprn_method_tax%TYPE,
26476: p_tax_life_in_mnth IN okl_lines_interface.life_in_months_tax%TYPE,
26477: p_tax_deprn_rate IN okl_lines_interface.deprn_rate_tax%TYPE,
26478: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
26479: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
26480: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
26481: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,
26482: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,
26483: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,

Line 26480: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,

26476: p_tax_life_in_mnth IN okl_lines_interface.life_in_months_tax%TYPE,
26477: p_tax_deprn_rate IN okl_lines_interface.deprn_rate_tax%TYPE,
26478: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
26479: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
26480: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
26481: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,
26482: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,
26483: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,
26484: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,

Line 26481: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,

26477: p_tax_deprn_rate IN okl_lines_interface.deprn_rate_tax%TYPE,
26478: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
26479: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
26480: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
26481: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,
26482: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,
26483: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,
26484: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
26485: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,

Line 26482: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,

26478: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
26479: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
26480: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
26481: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,
26482: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,
26483: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,
26484: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
26485: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
26486: p_attribute_category IN okl_lines_interface.attribute_category%TYPE,

Line 26483: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,

26479: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
26480: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
26481: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,
26482: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,
26483: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,
26484: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
26485: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
26486: p_attribute_category IN okl_lines_interface.attribute_category%TYPE,
26487: p_attribute1 IN okl_lines_interface.attribute1%TYPE,

Line 26484: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,

26480: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
26481: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,
26482: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,
26483: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,
26484: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
26485: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
26486: p_attribute_category IN okl_lines_interface.attribute_category%TYPE,
26487: p_attribute1 IN okl_lines_interface.attribute1%TYPE,
26488: p_attribute2 IN okl_lines_interface.attribute2%TYPE,

Line 26485: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,

26481: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,
26482: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,
26483: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,
26484: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
26485: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
26486: p_attribute_category IN okl_lines_interface.attribute_category%TYPE,
26487: p_attribute1 IN okl_lines_interface.attribute1%TYPE,
26488: p_attribute2 IN okl_lines_interface.attribute2%TYPE,
26489: p_attribute3 IN okl_lines_interface.attribute3%TYPE,

Line 26486: p_attribute_category IN okl_lines_interface.attribute_category%TYPE,

26482: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,
26483: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,
26484: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
26485: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
26486: p_attribute_category IN okl_lines_interface.attribute_category%TYPE,
26487: p_attribute1 IN okl_lines_interface.attribute1%TYPE,
26488: p_attribute2 IN okl_lines_interface.attribute2%TYPE,
26489: p_attribute3 IN okl_lines_interface.attribute3%TYPE,
26490: p_attribute4 IN okl_lines_interface.attribute4%TYPE,

Line 26487: p_attribute1 IN okl_lines_interface.attribute1%TYPE,

26483: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,
26484: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
26485: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
26486: p_attribute_category IN okl_lines_interface.attribute_category%TYPE,
26487: p_attribute1 IN okl_lines_interface.attribute1%TYPE,
26488: p_attribute2 IN okl_lines_interface.attribute2%TYPE,
26489: p_attribute3 IN okl_lines_interface.attribute3%TYPE,
26490: p_attribute4 IN okl_lines_interface.attribute4%TYPE,
26491: p_attribute5 IN okl_lines_interface.attribute5%TYPE,

Line 26488: p_attribute2 IN okl_lines_interface.attribute2%TYPE,

26484: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
26485: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
26486: p_attribute_category IN okl_lines_interface.attribute_category%TYPE,
26487: p_attribute1 IN okl_lines_interface.attribute1%TYPE,
26488: p_attribute2 IN okl_lines_interface.attribute2%TYPE,
26489: p_attribute3 IN okl_lines_interface.attribute3%TYPE,
26490: p_attribute4 IN okl_lines_interface.attribute4%TYPE,
26491: p_attribute5 IN okl_lines_interface.attribute5%TYPE,
26492: p_attribute6 IN okl_lines_interface.attribute6%TYPE,

Line 26489: p_attribute3 IN okl_lines_interface.attribute3%TYPE,

26485: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
26486: p_attribute_category IN okl_lines_interface.attribute_category%TYPE,
26487: p_attribute1 IN okl_lines_interface.attribute1%TYPE,
26488: p_attribute2 IN okl_lines_interface.attribute2%TYPE,
26489: p_attribute3 IN okl_lines_interface.attribute3%TYPE,
26490: p_attribute4 IN okl_lines_interface.attribute4%TYPE,
26491: p_attribute5 IN okl_lines_interface.attribute5%TYPE,
26492: p_attribute6 IN okl_lines_interface.attribute6%TYPE,
26493: p_attribute7 IN okl_lines_interface.attribute7%TYPE,

Line 26490: p_attribute4 IN okl_lines_interface.attribute4%TYPE,

26486: p_attribute_category IN okl_lines_interface.attribute_category%TYPE,
26487: p_attribute1 IN okl_lines_interface.attribute1%TYPE,
26488: p_attribute2 IN okl_lines_interface.attribute2%TYPE,
26489: p_attribute3 IN okl_lines_interface.attribute3%TYPE,
26490: p_attribute4 IN okl_lines_interface.attribute4%TYPE,
26491: p_attribute5 IN okl_lines_interface.attribute5%TYPE,
26492: p_attribute6 IN okl_lines_interface.attribute6%TYPE,
26493: p_attribute7 IN okl_lines_interface.attribute7%TYPE,
26494: p_attribute8 IN okl_lines_interface.attribute8%TYPE,

Line 26491: p_attribute5 IN okl_lines_interface.attribute5%TYPE,

26487: p_attribute1 IN okl_lines_interface.attribute1%TYPE,
26488: p_attribute2 IN okl_lines_interface.attribute2%TYPE,
26489: p_attribute3 IN okl_lines_interface.attribute3%TYPE,
26490: p_attribute4 IN okl_lines_interface.attribute4%TYPE,
26491: p_attribute5 IN okl_lines_interface.attribute5%TYPE,
26492: p_attribute6 IN okl_lines_interface.attribute6%TYPE,
26493: p_attribute7 IN okl_lines_interface.attribute7%TYPE,
26494: p_attribute8 IN okl_lines_interface.attribute8%TYPE,
26495: p_attribute9 IN okl_lines_interface.attribute9%TYPE,

Line 26492: p_attribute6 IN okl_lines_interface.attribute6%TYPE,

26488: p_attribute2 IN okl_lines_interface.attribute2%TYPE,
26489: p_attribute3 IN okl_lines_interface.attribute3%TYPE,
26490: p_attribute4 IN okl_lines_interface.attribute4%TYPE,
26491: p_attribute5 IN okl_lines_interface.attribute5%TYPE,
26492: p_attribute6 IN okl_lines_interface.attribute6%TYPE,
26493: p_attribute7 IN okl_lines_interface.attribute7%TYPE,
26494: p_attribute8 IN okl_lines_interface.attribute8%TYPE,
26495: p_attribute9 IN okl_lines_interface.attribute9%TYPE,
26496: p_attribute10 IN okl_lines_interface.attribute10%TYPE,

Line 26493: p_attribute7 IN okl_lines_interface.attribute7%TYPE,

26489: p_attribute3 IN okl_lines_interface.attribute3%TYPE,
26490: p_attribute4 IN okl_lines_interface.attribute4%TYPE,
26491: p_attribute5 IN okl_lines_interface.attribute5%TYPE,
26492: p_attribute6 IN okl_lines_interface.attribute6%TYPE,
26493: p_attribute7 IN okl_lines_interface.attribute7%TYPE,
26494: p_attribute8 IN okl_lines_interface.attribute8%TYPE,
26495: p_attribute9 IN okl_lines_interface.attribute9%TYPE,
26496: p_attribute10 IN okl_lines_interface.attribute10%TYPE,
26497: p_attribute11 IN okl_lines_interface.attribute11%TYPE,

Line 26494: p_attribute8 IN okl_lines_interface.attribute8%TYPE,

26490: p_attribute4 IN okl_lines_interface.attribute4%TYPE,
26491: p_attribute5 IN okl_lines_interface.attribute5%TYPE,
26492: p_attribute6 IN okl_lines_interface.attribute6%TYPE,
26493: p_attribute7 IN okl_lines_interface.attribute7%TYPE,
26494: p_attribute8 IN okl_lines_interface.attribute8%TYPE,
26495: p_attribute9 IN okl_lines_interface.attribute9%TYPE,
26496: p_attribute10 IN okl_lines_interface.attribute10%TYPE,
26497: p_attribute11 IN okl_lines_interface.attribute11%TYPE,
26498: p_attribute12 IN okl_lines_interface.attribute12%TYPE,

Line 26495: p_attribute9 IN okl_lines_interface.attribute9%TYPE,

26491: p_attribute5 IN okl_lines_interface.attribute5%TYPE,
26492: p_attribute6 IN okl_lines_interface.attribute6%TYPE,
26493: p_attribute7 IN okl_lines_interface.attribute7%TYPE,
26494: p_attribute8 IN okl_lines_interface.attribute8%TYPE,
26495: p_attribute9 IN okl_lines_interface.attribute9%TYPE,
26496: p_attribute10 IN okl_lines_interface.attribute10%TYPE,
26497: p_attribute11 IN okl_lines_interface.attribute11%TYPE,
26498: p_attribute12 IN okl_lines_interface.attribute12%TYPE,
26499: p_attribute13 IN okl_lines_interface.attribute13%TYPE,

Line 26496: p_attribute10 IN okl_lines_interface.attribute10%TYPE,

26492: p_attribute6 IN okl_lines_interface.attribute6%TYPE,
26493: p_attribute7 IN okl_lines_interface.attribute7%TYPE,
26494: p_attribute8 IN okl_lines_interface.attribute8%TYPE,
26495: p_attribute9 IN okl_lines_interface.attribute9%TYPE,
26496: p_attribute10 IN okl_lines_interface.attribute10%TYPE,
26497: p_attribute11 IN okl_lines_interface.attribute11%TYPE,
26498: p_attribute12 IN okl_lines_interface.attribute12%TYPE,
26499: p_attribute13 IN okl_lines_interface.attribute13%TYPE,
26500: p_attribute14 IN okl_lines_interface.attribute14%TYPE,

Line 26497: p_attribute11 IN okl_lines_interface.attribute11%TYPE,

26493: p_attribute7 IN okl_lines_interface.attribute7%TYPE,
26494: p_attribute8 IN okl_lines_interface.attribute8%TYPE,
26495: p_attribute9 IN okl_lines_interface.attribute9%TYPE,
26496: p_attribute10 IN okl_lines_interface.attribute10%TYPE,
26497: p_attribute11 IN okl_lines_interface.attribute11%TYPE,
26498: p_attribute12 IN okl_lines_interface.attribute12%TYPE,
26499: p_attribute13 IN okl_lines_interface.attribute13%TYPE,
26500: p_attribute14 IN okl_lines_interface.attribute14%TYPE,
26501: p_attribute15 IN okl_lines_interface.attribute15%TYPE,

Line 26498: p_attribute12 IN okl_lines_interface.attribute12%TYPE,

26494: p_attribute8 IN okl_lines_interface.attribute8%TYPE,
26495: p_attribute9 IN okl_lines_interface.attribute9%TYPE,
26496: p_attribute10 IN okl_lines_interface.attribute10%TYPE,
26497: p_attribute11 IN okl_lines_interface.attribute11%TYPE,
26498: p_attribute12 IN okl_lines_interface.attribute12%TYPE,
26499: p_attribute13 IN okl_lines_interface.attribute13%TYPE,
26500: p_attribute14 IN okl_lines_interface.attribute14%TYPE,
26501: p_attribute15 IN okl_lines_interface.attribute15%TYPE,
26502: --Bug# 16344245

Line 26499: p_attribute13 IN okl_lines_interface.attribute13%TYPE,

26495: p_attribute9 IN okl_lines_interface.attribute9%TYPE,
26496: p_attribute10 IN okl_lines_interface.attribute10%TYPE,
26497: p_attribute11 IN okl_lines_interface.attribute11%TYPE,
26498: p_attribute12 IN okl_lines_interface.attribute12%TYPE,
26499: p_attribute13 IN okl_lines_interface.attribute13%TYPE,
26500: p_attribute14 IN okl_lines_interface.attribute14%TYPE,
26501: p_attribute15 IN okl_lines_interface.attribute15%TYPE,
26502: --Bug# 16344245
26503: p_amount_balance_legacy IN okl_lines_interface.amount_balance_legacy%TYPE,

Line 26500: p_attribute14 IN okl_lines_interface.attribute14%TYPE,

26496: p_attribute10 IN okl_lines_interface.attribute10%TYPE,
26497: p_attribute11 IN okl_lines_interface.attribute11%TYPE,
26498: p_attribute12 IN okl_lines_interface.attribute12%TYPE,
26499: p_attribute13 IN okl_lines_interface.attribute13%TYPE,
26500: p_attribute14 IN okl_lines_interface.attribute14%TYPE,
26501: p_attribute15 IN okl_lines_interface.attribute15%TYPE,
26502: --Bug# 16344245
26503: p_amount_balance_legacy IN okl_lines_interface.amount_balance_legacy%TYPE,
26504: p_dt_effective_balance_legacy IN okl_lines_interface.dt_effective_balance_legacy%TYPE,

Line 26501: p_attribute15 IN okl_lines_interface.attribute15%TYPE,

26497: p_attribute11 IN okl_lines_interface.attribute11%TYPE,
26498: p_attribute12 IN okl_lines_interface.attribute12%TYPE,
26499: p_attribute13 IN okl_lines_interface.attribute13%TYPE,
26500: p_attribute14 IN okl_lines_interface.attribute14%TYPE,
26501: p_attribute15 IN okl_lines_interface.attribute15%TYPE,
26502: --Bug# 16344245
26503: p_amount_balance_legacy IN okl_lines_interface.amount_balance_legacy%TYPE,
26504: p_dt_effective_balance_legacy IN okl_lines_interface.dt_effective_balance_legacy%TYPE,
26505: --Bug# 16344245

Line 26503: p_amount_balance_legacy IN okl_lines_interface.amount_balance_legacy%TYPE,

26499: p_attribute13 IN okl_lines_interface.attribute13%TYPE,
26500: p_attribute14 IN okl_lines_interface.attribute14%TYPE,
26501: p_attribute15 IN okl_lines_interface.attribute15%TYPE,
26502: --Bug# 16344245
26503: p_amount_balance_legacy IN okl_lines_interface.amount_balance_legacy%TYPE,
26504: p_dt_effective_balance_legacy IN okl_lines_interface.dt_effective_balance_legacy%TYPE,
26505: --Bug# 16344245
26506: x_clev_fin_rec OUT NOCOPY clev_rec_type,
26507: x_clev_model_rec OUT NOCOPY clev_rec_type,

Line 26504: p_dt_effective_balance_legacy IN okl_lines_interface.dt_effective_balance_legacy%TYPE,

26500: p_attribute14 IN okl_lines_interface.attribute14%TYPE,
26501: p_attribute15 IN okl_lines_interface.attribute15%TYPE,
26502: --Bug# 16344245
26503: p_amount_balance_legacy IN okl_lines_interface.amount_balance_legacy%TYPE,
26504: p_dt_effective_balance_legacy IN okl_lines_interface.dt_effective_balance_legacy%TYPE,
26505: --Bug# 16344245
26506: x_clev_fin_rec OUT NOCOPY clev_rec_type,
26507: x_clev_model_rec OUT NOCOPY clev_rec_type,
26508: x_clev_fa_rec OUT NOCOPY clev_rec_type,

Line 26893: FROM okl_lines_interface

26889:
26890: CURSOR addon_csr (p_contract_number VARCHAR2,
26891: p_asset_number VARCHAR2) IS
26892: SELECT *
26893: FROM okl_lines_interface
26894: WHERE line_type = 'ASSET_ADDON'
26895: AND contract_number_old = p_contract_number
26896: AND asset_number = p_asset_number;
26897:

Line 27151: FROM okl_lines_interface

27147:
27148: CURSOR subsidy_csr (p_contract_number VARCHAR2,
27149: p_asset_number VARCHAR2) IS
27150: SELECT *
27151: FROM okl_lines_interface
27152: WHERE line_type = 'ASSET_SUBSIDY'
27153: AND contract_number_old = p_contract_number
27154: AND asset_number = p_asset_number;
27155:

Line 27552: l_line_number_prev okl_lines_interface.line_number%TYPE;

27548: -- l_new_yn VARCHAR2(1);
27549: x_comb_id NUMBER;
27550: x_rgp_id NUMBER;
27551: l_contract_number_old_prev okl_header_interface.contract_number_old%TYPE;
27552: l_line_number_prev okl_lines_interface.line_number%TYPE;
27553: l_asset_number_prev okl_payments_interface.asset_number%TYPE;
27554: l_payment_type_code_prev okl_payments_interface.payment_type_code%TYPE;
27555: l_pmnt_sch_num_prev NUMBER;
27556: l_start_date_prev DATE;

Line 28493: FROM okl_lines_interface

28489: --
28490:
28491: CURSOR okl_line_csr (p_contract_number_old VARCHAR2) IS
28492: SELECT *
28493: FROM okl_lines_interface
28494: WHERE contract_number_old = p_contract_number_old
28495: AND serial_number IS NULL -- indicates TOP line
28496: AND line_type <> 'ASSET_SUBSIDY' -- this line_type is being processed in process_subsidy()
28497: AND line_type <> 'ASSET_ADDON' -- this line_type is being processed in process_addon()

Line 28505: FROM okl_lines_interface

28501:
28502: CURSOR okl_ib_csr (p_contract_number_old VARCHAR2,
28503: p_line_number NUMBER) IS
28504: SELECT serial_number
28505: FROM okl_lines_interface
28506: WHERE contract_number_old = p_contract_number_old
28507: AND serial_number IS NOT NULL
28508: AND line_number = p_line_number;
28509:

Line 32086: from okl_lines_interface b

32082: l_temp_count number := 1;
32083:
32084: cursor c1 is
32085: select b.contract_number_old, count(*)
32086: from okl_lines_interface b
32087: where b.contract_number_old in (
32088: select a.contract_number_old
32089: from okl_header_interface a
32090: where

Line 32321: from okl_lines_interface a

32317: )
32318: AND b.status in ('NEW','ERROR');
32319:
32320: select count(*) into l_line_count
32321: from okl_lines_interface a
32322: where a.contract_number_old in (
32323: select b.contract_number_old
32324: from okl_header_interface b
32325: where (