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 704: ,LINE_NUMBER OKL_LINES_INTERFACE.LINE_NUMBER%TYPE

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

Line 1838: FROM OKL_LINES_INTERFACE OLI

1834:
1835: CURSOR release_csr (p_asset_number VARCHAR2,
1836: p_org_id NUMBER) IS
1837: SELECT 'Y'
1838: FROM OKL_LINES_INTERFACE OLI
1839: WHERE oli.contract_number_old = p_contract_number
1840: AND EXISTS ( SELECT fa.asset_id
1841: FROM FA_ADDITIONS_B FA,
1842: OKL_ASSET_RETURNS_B OAR,

Line 1884: FROM OKL_LINES_INTERFACE OLI

1880: CURSOR unrelease_csr (p_asset_number VARCHAR2,
1881: p_org_id NUMBER) IS
1882:
1883: SELECT 'Y'
1884: FROM OKL_LINES_INTERFACE OLI
1885: WHERE oli.contract_number_old = p_contract_number
1886: AND NOT EXISTS (SELECT fa.asset_id
1887: FROM FA_ADDITIONS_B FA,
1888: OKL_ASSET_RETURNS_B OAR,

Line 2003: p_line_number IN okl_lines_interface.line_number%TYPE,

1999: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
2000: p_import_request_stage IN okl_header_interface.import_request_stage%TYPE,
2001: p_product_id IN okl_header_interface.product_id%TYPE,
2002: p_product_name IN okl_header_interface.product_name%TYPE,
2003: p_line_number IN okl_lines_interface.line_number%TYPE,
2004: p_line_type IN okl_lines_interface.line_type%TYPE,
2005: p_amount IN okl_lines_interface.amount%TYPE,
2006: p_currency_code IN okl_lines_interface.currency_code%TYPE,
2007: p_asset_number IN okl_lines_interface.asset_number%TYPE,

Line 2004: p_line_type IN okl_lines_interface.line_type%TYPE,

2000: p_import_request_stage IN okl_header_interface.import_request_stage%TYPE,
2001: p_product_id IN okl_header_interface.product_id%TYPE,
2002: p_product_name IN okl_header_interface.product_name%TYPE,
2003: p_line_number IN okl_lines_interface.line_number%TYPE,
2004: p_line_type IN okl_lines_interface.line_type%TYPE,
2005: p_amount IN okl_lines_interface.amount%TYPE,
2006: p_currency_code IN okl_lines_interface.currency_code%TYPE,
2007: p_asset_number IN okl_lines_interface.asset_number%TYPE,
2008: p_inventory_item_name IN okl_lines_interface.inventory_item_name%TYPE,

Line 2005: p_amount IN okl_lines_interface.amount%TYPE,

2001: p_product_id IN okl_header_interface.product_id%TYPE,
2002: p_product_name IN okl_header_interface.product_name%TYPE,
2003: p_line_number IN okl_lines_interface.line_number%TYPE,
2004: p_line_type IN okl_lines_interface.line_type%TYPE,
2005: p_amount IN okl_lines_interface.amount%TYPE,
2006: p_currency_code IN okl_lines_interface.currency_code%TYPE,
2007: p_asset_number IN okl_lines_interface.asset_number%TYPE,
2008: p_inventory_item_name IN okl_lines_interface.inventory_item_name%TYPE,
2009: p_inventory_item_id IN okl_lines_interface.inventory_item_id%TYPE,

Line 2006: p_currency_code IN okl_lines_interface.currency_code%TYPE,

2002: p_product_name IN okl_header_interface.product_name%TYPE,
2003: p_line_number IN okl_lines_interface.line_number%TYPE,
2004: p_line_type IN okl_lines_interface.line_type%TYPE,
2005: p_amount IN okl_lines_interface.amount%TYPE,
2006: p_currency_code IN okl_lines_interface.currency_code%TYPE,
2007: p_asset_number IN okl_lines_interface.asset_number%TYPE,
2008: p_inventory_item_name IN okl_lines_interface.inventory_item_name%TYPE,
2009: p_inventory_item_id IN okl_lines_interface.inventory_item_id%TYPE,
2010: p_install_site_number IN okl_lines_interface.install_site_number%TYPE,

Line 2007: p_asset_number IN okl_lines_interface.asset_number%TYPE,

2003: p_line_number IN okl_lines_interface.line_number%TYPE,
2004: p_line_type IN okl_lines_interface.line_type%TYPE,
2005: p_amount IN okl_lines_interface.amount%TYPE,
2006: p_currency_code IN okl_lines_interface.currency_code%TYPE,
2007: p_asset_number IN okl_lines_interface.asset_number%TYPE,
2008: p_inventory_item_name IN okl_lines_interface.inventory_item_name%TYPE,
2009: p_inventory_item_id IN okl_lines_interface.inventory_item_id%TYPE,
2010: p_install_site_number IN okl_lines_interface.install_site_number%TYPE,
2011: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,

Line 2008: p_inventory_item_name IN okl_lines_interface.inventory_item_name%TYPE,

2004: p_line_type IN okl_lines_interface.line_type%TYPE,
2005: p_amount IN okl_lines_interface.amount%TYPE,
2006: p_currency_code IN okl_lines_interface.currency_code%TYPE,
2007: p_asset_number IN okl_lines_interface.asset_number%TYPE,
2008: p_inventory_item_name IN okl_lines_interface.inventory_item_name%TYPE,
2009: p_inventory_item_id IN okl_lines_interface.inventory_item_id%TYPE,
2010: p_install_site_number IN okl_lines_interface.install_site_number%TYPE,
2011: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
2012: p_asset_corporate_book IN okl_lines_interface.asset_corporate_book%TYPE,

Line 2009: p_inventory_item_id IN okl_lines_interface.inventory_item_id%TYPE,

2005: p_amount IN okl_lines_interface.amount%TYPE,
2006: p_currency_code IN okl_lines_interface.currency_code%TYPE,
2007: p_asset_number IN okl_lines_interface.asset_number%TYPE,
2008: p_inventory_item_name IN okl_lines_interface.inventory_item_name%TYPE,
2009: p_inventory_item_id IN okl_lines_interface.inventory_item_id%TYPE,
2010: p_install_site_number IN okl_lines_interface.install_site_number%TYPE,
2011: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
2012: p_asset_corporate_book IN okl_lines_interface.asset_corporate_book%TYPE,
2013: p_asset_category_id IN okl_lines_interface.asset_category_id%TYPE,

Line 2010: p_install_site_number IN okl_lines_interface.install_site_number%TYPE,

2006: p_currency_code IN okl_lines_interface.currency_code%TYPE,
2007: p_asset_number IN okl_lines_interface.asset_number%TYPE,
2008: p_inventory_item_name IN okl_lines_interface.inventory_item_name%TYPE,
2009: p_inventory_item_id IN okl_lines_interface.inventory_item_id%TYPE,
2010: p_install_site_number IN okl_lines_interface.install_site_number%TYPE,
2011: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
2012: p_asset_corporate_book IN okl_lines_interface.asset_corporate_book%TYPE,
2013: p_asset_category_id IN okl_lines_interface.asset_category_id%TYPE,
2014: p_asset_category_segment1 IN okl_lines_interface.asset_category_segment1%TYPE,

Line 2011: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,

2007: p_asset_number IN okl_lines_interface.asset_number%TYPE,
2008: p_inventory_item_name IN okl_lines_interface.inventory_item_name%TYPE,
2009: p_inventory_item_id IN okl_lines_interface.inventory_item_id%TYPE,
2010: p_install_site_number IN okl_lines_interface.install_site_number%TYPE,
2011: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
2012: p_asset_corporate_book IN okl_lines_interface.asset_corporate_book%TYPE,
2013: p_asset_category_id IN okl_lines_interface.asset_category_id%TYPE,
2014: p_asset_category_segment1 IN okl_lines_interface.asset_category_segment1%TYPE,
2015: p_asset_category_segment2 IN okl_lines_interface.asset_category_segment2%TYPE,

Line 2012: p_asset_corporate_book IN okl_lines_interface.asset_corporate_book%TYPE,

2008: p_inventory_item_name IN okl_lines_interface.inventory_item_name%TYPE,
2009: p_inventory_item_id IN okl_lines_interface.inventory_item_id%TYPE,
2010: p_install_site_number IN okl_lines_interface.install_site_number%TYPE,
2011: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
2012: p_asset_corporate_book IN okl_lines_interface.asset_corporate_book%TYPE,
2013: p_asset_category_id IN okl_lines_interface.asset_category_id%TYPE,
2014: p_asset_category_segment1 IN okl_lines_interface.asset_category_segment1%TYPE,
2015: p_asset_category_segment2 IN okl_lines_interface.asset_category_segment2%TYPE,
2016: p_asset_category_segment3 IN okl_lines_interface.asset_category_segment3%TYPE,

Line 2013: p_asset_category_id IN okl_lines_interface.asset_category_id%TYPE,

2009: p_inventory_item_id IN okl_lines_interface.inventory_item_id%TYPE,
2010: p_install_site_number IN okl_lines_interface.install_site_number%TYPE,
2011: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
2012: p_asset_corporate_book IN okl_lines_interface.asset_corporate_book%TYPE,
2013: p_asset_category_id IN okl_lines_interface.asset_category_id%TYPE,
2014: p_asset_category_segment1 IN okl_lines_interface.asset_category_segment1%TYPE,
2015: p_asset_category_segment2 IN okl_lines_interface.asset_category_segment2%TYPE,
2016: p_asset_category_segment3 IN okl_lines_interface.asset_category_segment3%TYPE,
2017: p_asset_category_segment4 IN okl_lines_interface.asset_category_segment4%TYPE,

Line 2014: p_asset_category_segment1 IN okl_lines_interface.asset_category_segment1%TYPE,

2010: p_install_site_number IN okl_lines_interface.install_site_number%TYPE,
2011: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
2012: p_asset_corporate_book IN okl_lines_interface.asset_corporate_book%TYPE,
2013: p_asset_category_id IN okl_lines_interface.asset_category_id%TYPE,
2014: p_asset_category_segment1 IN okl_lines_interface.asset_category_segment1%TYPE,
2015: p_asset_category_segment2 IN okl_lines_interface.asset_category_segment2%TYPE,
2016: p_asset_category_segment3 IN okl_lines_interface.asset_category_segment3%TYPE,
2017: p_asset_category_segment4 IN okl_lines_interface.asset_category_segment4%TYPE,
2018: p_asset_category_segment5 IN okl_lines_interface.asset_category_segment5%TYPE,

Line 2015: p_asset_category_segment2 IN okl_lines_interface.asset_category_segment2%TYPE,

2011: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
2012: p_asset_corporate_book IN okl_lines_interface.asset_corporate_book%TYPE,
2013: p_asset_category_id IN okl_lines_interface.asset_category_id%TYPE,
2014: p_asset_category_segment1 IN okl_lines_interface.asset_category_segment1%TYPE,
2015: p_asset_category_segment2 IN okl_lines_interface.asset_category_segment2%TYPE,
2016: p_asset_category_segment3 IN okl_lines_interface.asset_category_segment3%TYPE,
2017: p_asset_category_segment4 IN okl_lines_interface.asset_category_segment4%TYPE,
2018: p_asset_category_segment5 IN okl_lines_interface.asset_category_segment5%TYPE,
2019: p_asset_category_segment6 IN okl_lines_interface.asset_category_segment6%TYPE,

Line 2016: p_asset_category_segment3 IN okl_lines_interface.asset_category_segment3%TYPE,

2012: p_asset_corporate_book IN okl_lines_interface.asset_corporate_book%TYPE,
2013: p_asset_category_id IN okl_lines_interface.asset_category_id%TYPE,
2014: p_asset_category_segment1 IN okl_lines_interface.asset_category_segment1%TYPE,
2015: p_asset_category_segment2 IN okl_lines_interface.asset_category_segment2%TYPE,
2016: p_asset_category_segment3 IN okl_lines_interface.asset_category_segment3%TYPE,
2017: p_asset_category_segment4 IN okl_lines_interface.asset_category_segment4%TYPE,
2018: p_asset_category_segment5 IN okl_lines_interface.asset_category_segment5%TYPE,
2019: p_asset_category_segment6 IN okl_lines_interface.asset_category_segment6%TYPE,
2020: p_asset_category_segment7 IN okl_lines_interface.asset_category_segment7%TYPE,

Line 2017: p_asset_category_segment4 IN okl_lines_interface.asset_category_segment4%TYPE,

2013: p_asset_category_id IN okl_lines_interface.asset_category_id%TYPE,
2014: p_asset_category_segment1 IN okl_lines_interface.asset_category_segment1%TYPE,
2015: p_asset_category_segment2 IN okl_lines_interface.asset_category_segment2%TYPE,
2016: p_asset_category_segment3 IN okl_lines_interface.asset_category_segment3%TYPE,
2017: p_asset_category_segment4 IN okl_lines_interface.asset_category_segment4%TYPE,
2018: p_asset_category_segment5 IN okl_lines_interface.asset_category_segment5%TYPE,
2019: p_asset_category_segment6 IN okl_lines_interface.asset_category_segment6%TYPE,
2020: p_asset_category_segment7 IN okl_lines_interface.asset_category_segment7%TYPE,
2021: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,

Line 2018: p_asset_category_segment5 IN okl_lines_interface.asset_category_segment5%TYPE,

2014: p_asset_category_segment1 IN okl_lines_interface.asset_category_segment1%TYPE,
2015: p_asset_category_segment2 IN okl_lines_interface.asset_category_segment2%TYPE,
2016: p_asset_category_segment3 IN okl_lines_interface.asset_category_segment3%TYPE,
2017: p_asset_category_segment4 IN okl_lines_interface.asset_category_segment4%TYPE,
2018: p_asset_category_segment5 IN okl_lines_interface.asset_category_segment5%TYPE,
2019: p_asset_category_segment6 IN okl_lines_interface.asset_category_segment6%TYPE,
2020: p_asset_category_segment7 IN okl_lines_interface.asset_category_segment7%TYPE,
2021: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,
2022: p_asset_location_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,

Line 2019: p_asset_category_segment6 IN okl_lines_interface.asset_category_segment6%TYPE,

2015: p_asset_category_segment2 IN okl_lines_interface.asset_category_segment2%TYPE,
2016: p_asset_category_segment3 IN okl_lines_interface.asset_category_segment3%TYPE,
2017: p_asset_category_segment4 IN okl_lines_interface.asset_category_segment4%TYPE,
2018: p_asset_category_segment5 IN okl_lines_interface.asset_category_segment5%TYPE,
2019: p_asset_category_segment6 IN okl_lines_interface.asset_category_segment6%TYPE,
2020: p_asset_category_segment7 IN okl_lines_interface.asset_category_segment7%TYPE,
2021: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,
2022: p_asset_location_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,
2023: p_asset_location_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,

Line 2020: p_asset_category_segment7 IN okl_lines_interface.asset_category_segment7%TYPE,

2016: p_asset_category_segment3 IN okl_lines_interface.asset_category_segment3%TYPE,
2017: p_asset_category_segment4 IN okl_lines_interface.asset_category_segment4%TYPE,
2018: p_asset_category_segment5 IN okl_lines_interface.asset_category_segment5%TYPE,
2019: p_asset_category_segment6 IN okl_lines_interface.asset_category_segment6%TYPE,
2020: p_asset_category_segment7 IN okl_lines_interface.asset_category_segment7%TYPE,
2021: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,
2022: p_asset_location_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,
2023: p_asset_location_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,
2024: p_asset_location_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,

Line 2021: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,

2017: p_asset_category_segment4 IN okl_lines_interface.asset_category_segment4%TYPE,
2018: p_asset_category_segment5 IN okl_lines_interface.asset_category_segment5%TYPE,
2019: p_asset_category_segment6 IN okl_lines_interface.asset_category_segment6%TYPE,
2020: p_asset_category_segment7 IN okl_lines_interface.asset_category_segment7%TYPE,
2021: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,
2022: p_asset_location_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,
2023: p_asset_location_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,
2024: p_asset_location_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,
2025: p_asset_location_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,

Line 2022: p_asset_location_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,

2018: p_asset_category_segment5 IN okl_lines_interface.asset_category_segment5%TYPE,
2019: p_asset_category_segment6 IN okl_lines_interface.asset_category_segment6%TYPE,
2020: p_asset_category_segment7 IN okl_lines_interface.asset_category_segment7%TYPE,
2021: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,
2022: p_asset_location_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,
2023: p_asset_location_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,
2024: p_asset_location_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,
2025: p_asset_location_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,
2026: p_asset_location_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,

Line 2023: p_asset_location_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,

2019: p_asset_category_segment6 IN okl_lines_interface.asset_category_segment6%TYPE,
2020: p_asset_category_segment7 IN okl_lines_interface.asset_category_segment7%TYPE,
2021: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,
2022: p_asset_location_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,
2023: p_asset_location_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,
2024: p_asset_location_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,
2025: p_asset_location_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,
2026: p_asset_location_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,
2027: p_asset_location_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,

Line 2024: p_asset_location_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,

2020: p_asset_category_segment7 IN okl_lines_interface.asset_category_segment7%TYPE,
2021: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,
2022: p_asset_location_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,
2023: p_asset_location_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,
2024: p_asset_location_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,
2025: p_asset_location_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,
2026: p_asset_location_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,
2027: p_asset_location_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
2028: p_asset_location_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,

Line 2025: p_asset_location_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,

2021: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,
2022: p_asset_location_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,
2023: p_asset_location_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,
2024: p_asset_location_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,
2025: p_asset_location_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,
2026: p_asset_location_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,
2027: p_asset_location_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
2028: p_asset_location_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
2029: p_depreciation_method_id IN okl_lines_interface.depreciation_method_id%TYPE,

Line 2026: p_asset_location_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,

2022: p_asset_location_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,
2023: p_asset_location_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,
2024: p_asset_location_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,
2025: p_asset_location_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,
2026: p_asset_location_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,
2027: p_asset_location_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
2028: p_asset_location_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
2029: p_depreciation_method_id IN okl_lines_interface.depreciation_method_id%TYPE,
2030: p_depreciation_method_code IN okl_lines_interface.depreciation_method_code%TYPE,

Line 2027: p_asset_location_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,

2023: p_asset_location_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,
2024: p_asset_location_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,
2025: p_asset_location_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,
2026: p_asset_location_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,
2027: p_asset_location_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
2028: p_asset_location_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
2029: p_depreciation_method_id IN okl_lines_interface.depreciation_method_id%TYPE,
2030: p_depreciation_method_code IN okl_lines_interface.depreciation_method_code%TYPE,
2031: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,

Line 2028: p_asset_location_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,

2024: p_asset_location_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,
2025: p_asset_location_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,
2026: p_asset_location_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,
2027: p_asset_location_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
2028: p_asset_location_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
2029: p_depreciation_method_id IN okl_lines_interface.depreciation_method_id%TYPE,
2030: p_depreciation_method_code IN okl_lines_interface.depreciation_method_code%TYPE,
2031: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,
2032: p_fee_code IN okl_lines_interface.fee_code%TYPE,

Line 2029: p_depreciation_method_id IN okl_lines_interface.depreciation_method_id%TYPE,

2025: p_asset_location_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,
2026: p_asset_location_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,
2027: p_asset_location_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
2028: p_asset_location_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
2029: p_depreciation_method_id IN okl_lines_interface.depreciation_method_id%TYPE,
2030: p_depreciation_method_code IN okl_lines_interface.depreciation_method_code%TYPE,
2031: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,
2032: p_fee_code IN okl_lines_interface.fee_code%TYPE,
2033: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,

Line 2030: p_depreciation_method_code IN okl_lines_interface.depreciation_method_code%TYPE,

2026: p_asset_location_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,
2027: p_asset_location_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
2028: p_asset_location_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
2029: p_depreciation_method_id IN okl_lines_interface.depreciation_method_id%TYPE,
2030: p_depreciation_method_code IN okl_lines_interface.depreciation_method_code%TYPE,
2031: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,
2032: p_fee_code IN okl_lines_interface.fee_code%TYPE,
2033: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
2034: p_fee_type IN okl_lines_interface.fee_type%TYPE,

Line 2031: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,

2027: p_asset_location_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
2028: p_asset_location_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
2029: p_depreciation_method_id IN okl_lines_interface.depreciation_method_id%TYPE,
2030: p_depreciation_method_code IN okl_lines_interface.depreciation_method_code%TYPE,
2031: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,
2032: p_fee_code IN okl_lines_interface.fee_code%TYPE,
2033: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
2034: p_fee_type IN okl_lines_interface.fee_type%TYPE,
2035: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,

Line 2032: p_fee_code IN okl_lines_interface.fee_code%TYPE,

2028: p_asset_location_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
2029: p_depreciation_method_id IN okl_lines_interface.depreciation_method_id%TYPE,
2030: p_depreciation_method_code IN okl_lines_interface.depreciation_method_code%TYPE,
2031: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,
2032: p_fee_code IN okl_lines_interface.fee_code%TYPE,
2033: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
2034: p_fee_type IN okl_lines_interface.fee_type%TYPE,
2035: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,
2036: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,

Line 2033: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,

2029: p_depreciation_method_id IN okl_lines_interface.depreciation_method_id%TYPE,
2030: p_depreciation_method_code IN okl_lines_interface.depreciation_method_code%TYPE,
2031: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,
2032: p_fee_code IN okl_lines_interface.fee_code%TYPE,
2033: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
2034: p_fee_type IN okl_lines_interface.fee_type%TYPE,
2035: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,
2036: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,
2037: p_counter_group_name IN okl_lines_interface.counter_group_name%TYPE,

Line 2034: p_fee_type IN okl_lines_interface.fee_type%TYPE,

2030: p_depreciation_method_code IN okl_lines_interface.depreciation_method_code%TYPE,
2031: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,
2032: p_fee_code IN okl_lines_interface.fee_code%TYPE,
2033: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
2034: p_fee_type IN okl_lines_interface.fee_type%TYPE,
2035: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,
2036: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,
2037: p_counter_group_name IN okl_lines_interface.counter_group_name%TYPE,
2038: p_counter_group_id IN okl_lines_interface.counter_group_id%TYPE,

Line 2035: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,

2031: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,
2032: p_fee_code IN okl_lines_interface.fee_code%TYPE,
2033: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
2034: p_fee_type IN okl_lines_interface.fee_type%TYPE,
2035: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,
2036: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,
2037: p_counter_group_name IN okl_lines_interface.counter_group_name%TYPE,
2038: p_counter_group_id IN okl_lines_interface.counter_group_id%TYPE,
2039: p_usage_bill_frequency_code IN okl_lines_interface.usage_bill_frequency_code%TYPE,

Line 2036: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,

2032: p_fee_code IN okl_lines_interface.fee_code%TYPE,
2033: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
2034: p_fee_type IN okl_lines_interface.fee_type%TYPE,
2035: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,
2036: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,
2037: p_counter_group_name IN okl_lines_interface.counter_group_name%TYPE,
2038: p_counter_group_id IN okl_lines_interface.counter_group_id%TYPE,
2039: p_usage_bill_frequency_code IN okl_lines_interface.usage_bill_frequency_code%TYPE,
2040: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,

Line 2037: p_counter_group_name IN okl_lines_interface.counter_group_name%TYPE,

2033: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
2034: p_fee_type IN okl_lines_interface.fee_type%TYPE,
2035: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,
2036: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,
2037: p_counter_group_name IN okl_lines_interface.counter_group_name%TYPE,
2038: p_counter_group_id IN okl_lines_interface.counter_group_id%TYPE,
2039: p_usage_bill_frequency_code IN okl_lines_interface.usage_bill_frequency_code%TYPE,
2040: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,
2041: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,

Line 2038: p_counter_group_id IN okl_lines_interface.counter_group_id%TYPE,

2034: p_fee_type IN okl_lines_interface.fee_type%TYPE,
2035: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,
2036: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,
2037: p_counter_group_name IN okl_lines_interface.counter_group_name%TYPE,
2038: p_counter_group_id IN okl_lines_interface.counter_group_id%TYPE,
2039: p_usage_bill_frequency_code IN okl_lines_interface.usage_bill_frequency_code%TYPE,
2040: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,
2041: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,
2042: p_usage_period IN okl_lines_interface.usage_period%TYPE,

Line 2039: p_usage_bill_frequency_code IN okl_lines_interface.usage_bill_frequency_code%TYPE,

2035: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,
2036: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,
2037: p_counter_group_name IN okl_lines_interface.counter_group_name%TYPE,
2038: p_counter_group_id IN okl_lines_interface.counter_group_id%TYPE,
2039: p_usage_bill_frequency_code IN okl_lines_interface.usage_bill_frequency_code%TYPE,
2040: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,
2041: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,
2042: p_usage_period IN okl_lines_interface.usage_period%TYPE,
2043: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,

Line 2040: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,

2036: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,
2037: p_counter_group_name IN okl_lines_interface.counter_group_name%TYPE,
2038: p_counter_group_id IN okl_lines_interface.counter_group_id%TYPE,
2039: p_usage_bill_frequency_code IN okl_lines_interface.usage_bill_frequency_code%TYPE,
2040: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,
2041: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,
2042: p_usage_period IN okl_lines_interface.usage_period%TYPE,
2043: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,
2044: p_tax_cost IN okl_lines_interface.tax_cost%TYPE,

Line 2041: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,

2037: p_counter_group_name IN okl_lines_interface.counter_group_name%TYPE,
2038: p_counter_group_id IN okl_lines_interface.counter_group_id%TYPE,
2039: p_usage_bill_frequency_code IN okl_lines_interface.usage_bill_frequency_code%TYPE,
2040: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,
2041: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,
2042: p_usage_period IN okl_lines_interface.usage_period%TYPE,
2043: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,
2044: p_tax_cost IN okl_lines_interface.tax_cost%TYPE,
2045: p_tax_book IN okl_lines_interface.tax_book%TYPE,

Line 2042: p_usage_period IN okl_lines_interface.usage_period%TYPE,

2038: p_counter_group_id IN okl_lines_interface.counter_group_id%TYPE,
2039: p_usage_bill_frequency_code IN okl_lines_interface.usage_bill_frequency_code%TYPE,
2040: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,
2041: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,
2042: p_usage_period IN okl_lines_interface.usage_period%TYPE,
2043: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,
2044: p_tax_cost IN okl_lines_interface.tax_cost%TYPE,
2045: p_tax_book IN okl_lines_interface.tax_book%TYPE,
2046: p_life_in_months_tax IN okl_lines_interface.life_in_months_tax%TYPE,

Line 2043: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,

2039: p_usage_bill_frequency_code IN okl_lines_interface.usage_bill_frequency_code%TYPE,
2040: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,
2041: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,
2042: p_usage_period IN okl_lines_interface.usage_period%TYPE,
2043: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,
2044: p_tax_cost IN okl_lines_interface.tax_cost%TYPE,
2045: p_tax_book IN okl_lines_interface.tax_book%TYPE,
2046: p_life_in_months_tax IN okl_lines_interface.life_in_months_tax%TYPE,
2047: p_deprn_method_tax IN okl_lines_interface.deprn_method_tax%TYPE,

Line 2044: p_tax_cost IN okl_lines_interface.tax_cost%TYPE,

2040: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,
2041: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,
2042: p_usage_period IN okl_lines_interface.usage_period%TYPE,
2043: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,
2044: p_tax_cost IN okl_lines_interface.tax_cost%TYPE,
2045: p_tax_book IN okl_lines_interface.tax_book%TYPE,
2046: p_life_in_months_tax IN okl_lines_interface.life_in_months_tax%TYPE,
2047: p_deprn_method_tax IN okl_lines_interface.deprn_method_tax%TYPE,
2048: p_deprn_rate_tax IN okl_lines_interface.deprn_rate_tax%TYPE,

Line 2045: p_tax_book IN okl_lines_interface.tax_book%TYPE,

2041: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,
2042: p_usage_period IN okl_lines_interface.usage_period%TYPE,
2043: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,
2044: p_tax_cost IN okl_lines_interface.tax_cost%TYPE,
2045: p_tax_book IN okl_lines_interface.tax_book%TYPE,
2046: p_life_in_months_tax IN okl_lines_interface.life_in_months_tax%TYPE,
2047: p_deprn_method_tax IN okl_lines_interface.deprn_method_tax%TYPE,
2048: p_deprn_rate_tax IN okl_lines_interface.deprn_rate_tax%TYPE,
2049: p_in_service_date IN okl_lines_interface.in_service_date%TYPE,

Line 2046: p_life_in_months_tax IN okl_lines_interface.life_in_months_tax%TYPE,

2042: p_usage_period IN okl_lines_interface.usage_period%TYPE,
2043: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,
2044: p_tax_cost IN okl_lines_interface.tax_cost%TYPE,
2045: p_tax_book IN okl_lines_interface.tax_book%TYPE,
2046: p_life_in_months_tax IN okl_lines_interface.life_in_months_tax%TYPE,
2047: p_deprn_method_tax IN okl_lines_interface.deprn_method_tax%TYPE,
2048: p_deprn_rate_tax IN okl_lines_interface.deprn_rate_tax%TYPE,
2049: p_in_service_date IN okl_lines_interface.in_service_date%TYPE,
2050: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,

Line 2047: p_deprn_method_tax IN okl_lines_interface.deprn_method_tax%TYPE,

2043: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,
2044: p_tax_cost IN okl_lines_interface.tax_cost%TYPE,
2045: p_tax_book IN okl_lines_interface.tax_book%TYPE,
2046: p_life_in_months_tax IN okl_lines_interface.life_in_months_tax%TYPE,
2047: p_deprn_method_tax IN okl_lines_interface.deprn_method_tax%TYPE,
2048: p_deprn_rate_tax IN okl_lines_interface.deprn_rate_tax%TYPE,
2049: p_in_service_date IN okl_lines_interface.in_service_date%TYPE,
2050: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,
2051: p_inv_org_id IN okl_header_interface.inventory_organization_id%TYPE,

Line 2048: p_deprn_rate_tax IN okl_lines_interface.deprn_rate_tax%TYPE,

2044: p_tax_cost IN okl_lines_interface.tax_cost%TYPE,
2045: p_tax_book IN okl_lines_interface.tax_book%TYPE,
2046: p_life_in_months_tax IN okl_lines_interface.life_in_months_tax%TYPE,
2047: p_deprn_method_tax IN okl_lines_interface.deprn_method_tax%TYPE,
2048: p_deprn_rate_tax IN okl_lines_interface.deprn_rate_tax%TYPE,
2049: p_in_service_date IN okl_lines_interface.in_service_date%TYPE,
2050: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,
2051: p_inv_org_id IN okl_header_interface.inventory_organization_id%TYPE,
2052: p_term_quote_id IN okl_lines_interface.termination_quote_id%TYPE,

Line 2049: p_in_service_date IN okl_lines_interface.in_service_date%TYPE,

2045: p_tax_book IN okl_lines_interface.tax_book%TYPE,
2046: p_life_in_months_tax IN okl_lines_interface.life_in_months_tax%TYPE,
2047: p_deprn_method_tax IN okl_lines_interface.deprn_method_tax%TYPE,
2048: p_deprn_rate_tax IN okl_lines_interface.deprn_rate_tax%TYPE,
2049: p_in_service_date IN okl_lines_interface.in_service_date%TYPE,
2050: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,
2051: p_inv_org_id IN okl_header_interface.inventory_organization_id%TYPE,
2052: p_term_quote_id IN okl_lines_interface.termination_quote_id%TYPE,
2053: p_term_quote_number IN okl_lines_interface.termination_quote_number%TYPE,

Line 2050: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,

2046: p_life_in_months_tax IN okl_lines_interface.life_in_months_tax%TYPE,
2047: p_deprn_method_tax IN okl_lines_interface.deprn_method_tax%TYPE,
2048: p_deprn_rate_tax IN okl_lines_interface.deprn_rate_tax%TYPE,
2049: p_in_service_date IN okl_lines_interface.in_service_date%TYPE,
2050: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,
2051: p_inv_org_id IN okl_header_interface.inventory_organization_id%TYPE,
2052: p_term_quote_id IN okl_lines_interface.termination_quote_id%TYPE,
2053: p_term_quote_number IN okl_lines_interface.termination_quote_number%TYPE,
2054: p_fee_purpose_code IN okl_lines_interface.fee_purpose_code%TYPE

Line 2052: p_term_quote_id IN okl_lines_interface.termination_quote_id%TYPE,

2048: p_deprn_rate_tax IN okl_lines_interface.deprn_rate_tax%TYPE,
2049: p_in_service_date IN okl_lines_interface.in_service_date%TYPE,
2050: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,
2051: p_inv_org_id IN okl_header_interface.inventory_organization_id%TYPE,
2052: p_term_quote_id IN okl_lines_interface.termination_quote_id%TYPE,
2053: p_term_quote_number IN okl_lines_interface.termination_quote_number%TYPE,
2054: p_fee_purpose_code IN okl_lines_interface.fee_purpose_code%TYPE
2055: ) IS
2056: -- 4475344

Line 2053: p_term_quote_number IN okl_lines_interface.termination_quote_number%TYPE,

2049: p_in_service_date IN okl_lines_interface.in_service_date%TYPE,
2050: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,
2051: p_inv_org_id IN okl_header_interface.inventory_organization_id%TYPE,
2052: p_term_quote_id IN okl_lines_interface.termination_quote_id%TYPE,
2053: p_term_quote_number IN okl_lines_interface.termination_quote_number%TYPE,
2054: p_fee_purpose_code IN okl_lines_interface.fee_purpose_code%TYPE
2055: ) IS
2056: -- 4475344
2057: /*

Line 2054: p_fee_purpose_code IN okl_lines_interface.fee_purpose_code%TYPE

2050: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,
2051: p_inv_org_id IN okl_header_interface.inventory_organization_id%TYPE,
2052: p_term_quote_id IN okl_lines_interface.termination_quote_id%TYPE,
2053: p_term_quote_number IN okl_lines_interface.termination_quote_number%TYPE,
2054: p_fee_purpose_code IN okl_lines_interface.fee_purpose_code%TYPE
2055: ) IS
2056: -- 4475344
2057: /*
2058: CURSOR srv_supp_csr(p_contract_number OKL_PARTY_ROLES_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,

Line 2671: -- line number in OKL_LINES_INTERFACE table

2667:
2668: ------------------------------------------------------------------------------
2669: -- PROCEDURE check_contract_line
2670: -- It validates Party role line number/ Terms Line number/ Payments line number against contract
2671: -- line number in OKL_LINES_INTERFACE table
2672: -- Calls:
2673: -- None
2674: -- Called By:
2675: -- check_payment_record

Line 2687: FROM okl_lines_interface

2683:
2684: CURSOR line_csr (p_contract_number VARCHAR2,
2685: p_line_number NUMBER) IS
2686: SELECT 'X'
2687: FROM okl_lines_interface
2688: WHERE contract_number_old = p_contract_number
2689: AND line_number = p_line_number;
2690:
2691: l_dummy VARCHAR2(1);

Line 3097: FROM okl_lines_interface

3093: --
3094:
3095: CURSOR okl_line_csr (p_contract_number_old okc_k_headers_v.contract_number%TYPE) IS
3096: SELECT *
3097: FROM okl_lines_interface
3098: WHERE contract_number_old = p_contract_number_old
3099: ORDER BY line_number;
3100:
3101: --

Line 3910: p_line_number IN okl_lines_interface.line_number%TYPE,

3906: x_return_status OUT NOCOPY VARCHAR2,
3907: x_msg_count OUT NOCOPY NUMBER,
3908: x_msg_data OUT NOCOPY VARCHAR2,
3909: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
3910: p_line_number IN okl_lines_interface.line_number%TYPE,
3911: x_vendor_id OUT NOCOPY NUMBER,
3912: p_vendor_name IN OKX_VENDORS_V.NAME%TYPE
3913: ) IS
3914:

Line 3986: p_line_number IN okl_lines_interface.line_number%TYPE,

3982: x_return_status OUT NOCOPY VARCHAR2,
3983: x_msg_count OUT NOCOPY NUMBER,
3984: x_msg_data OUT NOCOPY VARCHAR2,
3985: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
3986: p_line_number IN okl_lines_interface.line_number%TYPE,
3987: p_party_id IN OKX_PARTIES_V.ID1%TYPE,
3988: p_party_number IN OKX_PARTIES_V.PARTY_NUMBER%TYPE,
3989: x_party_id OUT NOCOPY NUMBER
3990: ) IS

Line 4614: p_line_number IN OKL_LINES_INTERFACE.LINE_NUMBER%TYPE,

4610: ------------------------------------------------------------------------------
4611: FUNCTION get_payment_term(
4612: x_return_status OUT NOCOPY VARCHAR2,
4613: p_contract_number IN OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,
4614: p_line_number IN OKL_LINES_INTERFACE.LINE_NUMBER%TYPE,
4615: p_payment_term IN OKL_LINES_INTERFACE.PAYMENT_TERM%TYPE,
4616: p_payment_term_id IN OKL_LINES_INTERFACE.PAYMENT_TERM_ID%TYPE
4617: )
4618: RETURN NUMBER IS

Line 4615: p_payment_term IN OKL_LINES_INTERFACE.PAYMENT_TERM%TYPE,

4611: FUNCTION get_payment_term(
4612: x_return_status OUT NOCOPY VARCHAR2,
4613: p_contract_number IN OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,
4614: p_line_number IN OKL_LINES_INTERFACE.LINE_NUMBER%TYPE,
4615: p_payment_term IN OKL_LINES_INTERFACE.PAYMENT_TERM%TYPE,
4616: p_payment_term_id IN OKL_LINES_INTERFACE.PAYMENT_TERM_ID%TYPE
4617: )
4618: RETURN NUMBER IS
4619:

Line 4616: p_payment_term_id IN OKL_LINES_INTERFACE.PAYMENT_TERM_ID%TYPE

4612: x_return_status OUT NOCOPY VARCHAR2,
4613: p_contract_number IN OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,
4614: p_line_number IN OKL_LINES_INTERFACE.LINE_NUMBER%TYPE,
4615: p_payment_term IN OKL_LINES_INTERFACE.PAYMENT_TERM%TYPE,
4616: p_payment_term_id IN OKL_LINES_INTERFACE.PAYMENT_TERM_ID%TYPE
4617: )
4618: RETURN NUMBER IS
4619:
4620: CURSOR term_csr (p_payment_term VARCHAR2,

Line 4672: p_line_number IN OKL_LINES_INTERFACE.LINE_NUMBER%TYPE,

4668: ------------------------------------------------------------------------------
4669: FUNCTION get_vendor_paysite(
4670: x_return_status OUT NOCOPY VARCHAR2,
4671: p_contract_number IN OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,
4672: p_line_number IN OKL_LINES_INTERFACE.LINE_NUMBER%TYPE,
4673: p_vendor_paysite_name IN OKL_LINES_INTERFACE.VENDOR_PAYSITE_NAME%TYPE,
4674: p_vendor_paysite_id IN OKL_LINES_INTERFACE.VENDOR_PAYSITE_ID%TYPE
4675: )
4676: RETURN NUMBER IS

Line 4673: p_vendor_paysite_name IN OKL_LINES_INTERFACE.VENDOR_PAYSITE_NAME%TYPE,

4669: FUNCTION get_vendor_paysite(
4670: x_return_status OUT NOCOPY VARCHAR2,
4671: p_contract_number IN OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,
4672: p_line_number IN OKL_LINES_INTERFACE.LINE_NUMBER%TYPE,
4673: p_vendor_paysite_name IN OKL_LINES_INTERFACE.VENDOR_PAYSITE_NAME%TYPE,
4674: p_vendor_paysite_id IN OKL_LINES_INTERFACE.VENDOR_PAYSITE_ID%TYPE
4675: )
4676: RETURN NUMBER IS
4677: CURSOR site_csr (p_name VARCHAR2,

Line 4674: p_vendor_paysite_id IN OKL_LINES_INTERFACE.VENDOR_PAYSITE_ID%TYPE

4670: x_return_status OUT NOCOPY VARCHAR2,
4671: p_contract_number IN OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,
4672: p_line_number IN OKL_LINES_INTERFACE.LINE_NUMBER%TYPE,
4673: p_vendor_paysite_name IN OKL_LINES_INTERFACE.VENDOR_PAYSITE_NAME%TYPE,
4674: p_vendor_paysite_id IN OKL_LINES_INTERFACE.VENDOR_PAYSITE_ID%TYPE
4675: )
4676: RETURN NUMBER IS
4677: CURSOR site_csr (p_name VARCHAR2,
4678: p_id NUMBER) IS

Line 5365: p_line_type IN okl_lines_interface.line_type%TYPE,

5361: p_chr_id IN okc_k_headers_v.id%TYPE,
5362: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
5363: p_cle_id IN okl_k_lines_v.id%TYPE,
5364: p_line_number IN okc_k_lines_v.line_number%TYPE,
5365: p_line_type IN okl_lines_interface.line_type%TYPE,
5366: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,
5367: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
5368: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,
5369: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,

Line 5366: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,

5362: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
5363: p_cle_id IN okl_k_lines_v.id%TYPE,
5364: p_line_number IN okc_k_lines_v.line_number%TYPE,
5365: p_line_type IN okl_lines_interface.line_type%TYPE,
5366: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,
5367: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
5368: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,
5369: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,
5370: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,

Line 5367: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,

5363: p_cle_id IN okl_k_lines_v.id%TYPE,
5364: p_line_number IN okc_k_lines_v.line_number%TYPE,
5365: p_line_type IN okl_lines_interface.line_type%TYPE,
5366: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,
5367: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
5368: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,
5369: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,
5370: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,
5371: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,

Line 5368: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,

5364: p_line_number IN okc_k_lines_v.line_number%TYPE,
5365: p_line_type IN okl_lines_interface.line_type%TYPE,
5366: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,
5367: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
5368: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,
5369: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,
5370: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,
5371: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,
5372: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,

Line 5369: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,

5365: p_line_type IN okl_lines_interface.line_type%TYPE,
5366: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,
5367: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
5368: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,
5369: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,
5370: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,
5371: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,
5372: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,
5373: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,

Line 5370: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,

5366: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,
5367: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
5368: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,
5369: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,
5370: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,
5371: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,
5372: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,
5373: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,
5374: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,

Line 5371: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,

5367: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
5368: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,
5369: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,
5370: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,
5371: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,
5372: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,
5373: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,
5374: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,
5375: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,

Line 5372: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,

5368: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,
5369: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,
5370: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,
5371: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,
5372: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,
5373: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,
5374: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,
5375: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,
5376: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,

Line 5373: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,

5369: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,
5370: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,
5371: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,
5372: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,
5373: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,
5374: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,
5375: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,
5376: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,
5377: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,

Line 5374: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,

5370: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,
5371: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,
5372: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,
5373: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,
5374: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,
5375: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,
5376: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,
5377: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,
5378: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,

Line 5375: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,

5371: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,
5372: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,
5373: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,
5374: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,
5375: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,
5376: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,
5377: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,
5378: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,
5379: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,

Line 5376: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,

5372: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,
5373: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,
5374: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,
5375: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,
5376: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,
5377: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,
5378: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,
5379: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,
5380: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,

Line 5377: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,

5373: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,
5374: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,
5375: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,
5376: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,
5377: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,
5378: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,
5379: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,
5380: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,
5381: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,

Line 5378: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,

5374: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,
5375: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,
5376: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,
5377: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,
5378: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,
5379: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,
5380: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,
5381: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,
5382: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,

Line 5379: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,

5375: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,
5376: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,
5377: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,
5378: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,
5379: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,
5380: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,
5381: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,
5382: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,
5383: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,

Line 5380: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,

5376: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,
5377: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,
5378: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,
5379: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,
5380: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,
5381: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,
5382: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,
5383: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,
5384: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,

Line 5381: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,

5377: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,
5378: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,
5379: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,
5380: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,
5381: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,
5382: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,
5383: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,
5384: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,
5385: p_french_tax_name IN okl_lines_interface.french_tax_name%TYPE,

Line 5382: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,

5378: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,
5379: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,
5380: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,
5381: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,
5382: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,
5383: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,
5384: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,
5385: p_french_tax_name IN okl_lines_interface.french_tax_name%TYPE,
5386: p_prop_tax_bill_method IN okl_lines_interface.prop_tax_bill_method%TYPE,

Line 5383: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,

5379: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,
5380: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,
5381: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,
5382: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,
5383: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,
5384: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,
5385: p_french_tax_name IN okl_lines_interface.french_tax_name%TYPE,
5386: p_prop_tax_bill_method IN okl_lines_interface.prop_tax_bill_method%TYPE,
5387: p_prop_tax_as_contract_yn IN okl_lines_interface.prop_tax_as_contract_yn%TYPE ) IS

Line 5384: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,

5380: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,
5381: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,
5382: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,
5383: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,
5384: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,
5385: p_french_tax_name IN okl_lines_interface.french_tax_name%TYPE,
5386: p_prop_tax_bill_method IN okl_lines_interface.prop_tax_bill_method%TYPE,
5387: p_prop_tax_as_contract_yn IN okl_lines_interface.prop_tax_as_contract_yn%TYPE ) IS
5388:

Line 5385: p_french_tax_name IN okl_lines_interface.french_tax_name%TYPE,

5381: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,
5382: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,
5383: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,
5384: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,
5385: p_french_tax_name IN okl_lines_interface.french_tax_name%TYPE,
5386: p_prop_tax_bill_method IN okl_lines_interface.prop_tax_bill_method%TYPE,
5387: p_prop_tax_as_contract_yn IN okl_lines_interface.prop_tax_as_contract_yn%TYPE ) IS
5388:
5389: line_rule_failed EXCEPTION;

Line 5386: p_prop_tax_bill_method IN okl_lines_interface.prop_tax_bill_method%TYPE,

5382: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,
5383: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,
5384: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,
5385: p_french_tax_name IN okl_lines_interface.french_tax_name%TYPE,
5386: p_prop_tax_bill_method IN okl_lines_interface.prop_tax_bill_method%TYPE,
5387: p_prop_tax_as_contract_yn IN okl_lines_interface.prop_tax_as_contract_yn%TYPE ) IS
5388:
5389: line_rule_failed EXCEPTION;
5390: rule_group_failed EXCEPTION;

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

5383: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,
5384: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,
5385: p_french_tax_name IN okl_lines_interface.french_tax_name%TYPE,
5386: p_prop_tax_bill_method IN okl_lines_interface.prop_tax_bill_method%TYPE,
5387: p_prop_tax_as_contract_yn IN okl_lines_interface.prop_tax_as_contract_yn%TYPE ) IS
5388:
5389: line_rule_failed EXCEPTION;
5390: rule_group_failed EXCEPTION;
5391: rule_failed EXCEPTION;

Line 5880: p_line_type IN okl_lines_interface.line_type%TYPE,

5876: p_chr_id IN okc_k_headers_v.id%TYPE,
5877: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
5878: p_cle_id IN okl_k_lines_v.id%TYPE,
5879: p_line_number IN okc_k_lines_v.line_number%TYPE,
5880: p_line_type IN okl_lines_interface.line_type%TYPE,
5881: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,
5882: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
5883: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,
5884: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,

Line 5881: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,

5877: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
5878: p_cle_id IN okl_k_lines_v.id%TYPE,
5879: p_line_number IN okc_k_lines_v.line_number%TYPE,
5880: p_line_type IN okl_lines_interface.line_type%TYPE,
5881: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,
5882: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
5883: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,
5884: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,
5885: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,

Line 5882: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,

5878: p_cle_id IN okl_k_lines_v.id%TYPE,
5879: p_line_number IN okc_k_lines_v.line_number%TYPE,
5880: p_line_type IN okl_lines_interface.line_type%TYPE,
5881: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,
5882: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
5883: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,
5884: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,
5885: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,
5886: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,

Line 5883: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,

5879: p_line_number IN okc_k_lines_v.line_number%TYPE,
5880: p_line_type IN okl_lines_interface.line_type%TYPE,
5881: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,
5882: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
5883: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,
5884: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,
5885: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,
5886: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,
5887: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,

Line 5884: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,

5880: p_line_type IN okl_lines_interface.line_type%TYPE,
5881: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,
5882: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
5883: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,
5884: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,
5885: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,
5886: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,
5887: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,
5888: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,

Line 5885: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,

5881: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,
5882: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
5883: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,
5884: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,
5885: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,
5886: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,
5887: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,
5888: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,
5889: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,

Line 5886: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,

5882: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
5883: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,
5884: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,
5885: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,
5886: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,
5887: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,
5888: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,
5889: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,
5890: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,

Line 5887: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,

5883: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,
5884: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,
5885: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,
5886: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,
5887: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,
5888: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,
5889: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,
5890: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,
5891: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,

Line 5888: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,

5884: p_sales_tax_override_flag IN okl_lines_interface.sales_tax_override_flag%TYPE,
5885: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,
5886: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,
5887: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,
5888: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,
5889: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,
5890: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,
5891: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,
5892: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,

Line 5889: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,

5885: p_sales_tax_override_rate IN okl_lines_interface.sales_tax_override_rate%TYPE,
5886: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,
5887: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,
5888: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,
5889: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,
5890: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,
5891: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,
5892: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,
5893: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,

Line 5890: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,

5886: p_st_upd_lines_from_contract IN okl_lines_interface.st_update_lines_from_contract%TYPE,
5887: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,
5888: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,
5889: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,
5890: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,
5891: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,
5892: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,
5893: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,
5894: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,

Line 5891: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,

5887: p_st_transfer_of_title IN okl_lines_interface.st_transfer_of_title%TYPE,
5888: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,
5889: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,
5890: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,
5891: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,
5892: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,
5893: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,
5894: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,
5895: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,

Line 5892: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,

5888: p_st_sale_and_lease_back IN okl_lines_interface.st_sale_and_lease_back%TYPE,
5889: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,
5890: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,
5891: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,
5892: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,
5893: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,
5894: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,
5895: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,
5896: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,

Line 5893: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,

5889: p_st_purchase_of_lease IN okl_lines_interface.st_purchase_of_lease%TYPE,
5890: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,
5891: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,
5892: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,
5893: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,
5894: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,
5895: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,
5896: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,
5897: p_lien_type IN okl_lines_interface.lien_type%TYPE,

Line 5894: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,

5890: p_st_equipment_usage IN okl_lines_interface.st_equipment_usage%TYPE,
5891: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,
5892: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,
5893: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,
5894: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,
5895: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,
5896: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,
5897: p_lien_type IN okl_lines_interface.lien_type%TYPE,
5898: p_lien_filing_number IN okl_lines_interface.lien_filing_number%TYPE,

Line 5895: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,

5891: p_st_equipment_age IN okl_lines_interface.st_equipment_age%TYPE,
5892: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,
5893: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,
5894: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,
5895: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,
5896: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,
5897: p_lien_type IN okl_lines_interface.lien_type%TYPE,
5898: p_lien_filing_number IN okl_lines_interface.lien_filing_number%TYPE,
5899: p_lien_filing_date IN okl_lines_interface.lien_filing_date%TYPE,

Line 5896: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,

5892: p_st_asset_upfront_tax IN okl_lines_interface.st_asset_upfront_tax%TYPE,
5893: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,
5894: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,
5895: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,
5896: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,
5897: p_lien_type IN okl_lines_interface.lien_type%TYPE,
5898: p_lien_filing_number IN okl_lines_interface.lien_filing_number%TYPE,
5899: p_lien_filing_date IN okl_lines_interface.lien_filing_date%TYPE,
5900: p_lien_filing_status IN okl_lines_interface.lien_filing_status%TYPE,

Line 5897: p_lien_type IN okl_lines_interface.lien_type%TYPE,

5893: p_vat_tax_exempt IN okl_lines_interface.vat_tax_exempt%TYPE,
5894: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,
5895: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,
5896: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,
5897: p_lien_type IN okl_lines_interface.lien_type%TYPE,
5898: p_lien_filing_number IN okl_lines_interface.lien_filing_number%TYPE,
5899: p_lien_filing_date IN okl_lines_interface.lien_filing_date%TYPE,
5900: p_lien_filing_status IN okl_lines_interface.lien_filing_status%TYPE,
5901: p_lienholder_id IN okl_lines_interface.lienholder_id%TYPE,

Line 5898: p_lien_filing_number IN okl_lines_interface.lien_filing_number%TYPE,

5894: p_vat_tax_exempt_cert_number IN okl_lines_interface.vat_tax_exempt_cert_number%TYPE,
5895: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,
5896: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,
5897: p_lien_type IN okl_lines_interface.lien_type%TYPE,
5898: p_lien_filing_number IN okl_lines_interface.lien_filing_number%TYPE,
5899: p_lien_filing_date IN okl_lines_interface.lien_filing_date%TYPE,
5900: p_lien_filing_status IN okl_lines_interface.lien_filing_status%TYPE,
5901: p_lienholder_id IN okl_lines_interface.lienholder_id%TYPE,
5902: p_lienholder_number IN okl_lines_interface.lienholder_number%TYPE,

Line 5899: p_lien_filing_date IN okl_lines_interface.lien_filing_date%TYPE,

5895: p_vat_tax_override_flag IN okl_lines_interface.vat_tax_override_flag%TYPE,
5896: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,
5897: p_lien_type IN okl_lines_interface.lien_type%TYPE,
5898: p_lien_filing_number IN okl_lines_interface.lien_filing_number%TYPE,
5899: p_lien_filing_date IN okl_lines_interface.lien_filing_date%TYPE,
5900: p_lien_filing_status IN okl_lines_interface.lien_filing_status%TYPE,
5901: p_lienholder_id IN okl_lines_interface.lienholder_id%TYPE,
5902: p_lienholder_number IN okl_lines_interface.lienholder_number%TYPE,
5903: p_filing_jurisdiction IN okl_lines_interface.filing_jurisdiction%TYPE,

Line 5900: p_lien_filing_status IN okl_lines_interface.lien_filing_status%TYPE,

5896: p_vat_tax_override_rate IN okl_lines_interface.vat_tax_override_rate%TYPE,
5897: p_lien_type IN okl_lines_interface.lien_type%TYPE,
5898: p_lien_filing_number IN okl_lines_interface.lien_filing_number%TYPE,
5899: p_lien_filing_date IN okl_lines_interface.lien_filing_date%TYPE,
5900: p_lien_filing_status IN okl_lines_interface.lien_filing_status%TYPE,
5901: p_lienholder_id IN okl_lines_interface.lienholder_id%TYPE,
5902: p_lienholder_number IN okl_lines_interface.lienholder_number%TYPE,
5903: p_filing_jurisdiction IN okl_lines_interface.filing_jurisdiction%TYPE,
5904: p_filing_sub_jurisdiction IN okl_lines_interface.filing_sub_jurisdiction%TYPE,

Line 5901: p_lienholder_id IN okl_lines_interface.lienholder_id%TYPE,

5897: p_lien_type IN okl_lines_interface.lien_type%TYPE,
5898: p_lien_filing_number IN okl_lines_interface.lien_filing_number%TYPE,
5899: p_lien_filing_date IN okl_lines_interface.lien_filing_date%TYPE,
5900: p_lien_filing_status IN okl_lines_interface.lien_filing_status%TYPE,
5901: p_lienholder_id IN okl_lines_interface.lienholder_id%TYPE,
5902: p_lienholder_number IN okl_lines_interface.lienholder_number%TYPE,
5903: p_filing_jurisdiction IN okl_lines_interface.filing_jurisdiction%TYPE,
5904: p_filing_sub_jurisdiction IN okl_lines_interface.filing_sub_jurisdiction%TYPE,
5905: p_lien_expiration_date IN okl_lines_interface.lien_expiration_date%TYPE,

Line 5902: p_lienholder_number IN okl_lines_interface.lienholder_number%TYPE,

5898: p_lien_filing_number IN okl_lines_interface.lien_filing_number%TYPE,
5899: p_lien_filing_date IN okl_lines_interface.lien_filing_date%TYPE,
5900: p_lien_filing_status IN okl_lines_interface.lien_filing_status%TYPE,
5901: p_lienholder_id IN okl_lines_interface.lienholder_id%TYPE,
5902: p_lienholder_number IN okl_lines_interface.lienholder_number%TYPE,
5903: p_filing_jurisdiction IN okl_lines_interface.filing_jurisdiction%TYPE,
5904: p_filing_sub_jurisdiction IN okl_lines_interface.filing_sub_jurisdiction%TYPE,
5905: p_lien_expiration_date IN okl_lines_interface.lien_expiration_date%TYPE,
5906: p_lien_continuation_number IN okl_lines_interface.lien_continuation_number%TYPE,

Line 5903: p_filing_jurisdiction IN okl_lines_interface.filing_jurisdiction%TYPE,

5899: p_lien_filing_date IN okl_lines_interface.lien_filing_date%TYPE,
5900: p_lien_filing_status IN okl_lines_interface.lien_filing_status%TYPE,
5901: p_lienholder_id IN okl_lines_interface.lienholder_id%TYPE,
5902: p_lienholder_number IN okl_lines_interface.lienholder_number%TYPE,
5903: p_filing_jurisdiction IN okl_lines_interface.filing_jurisdiction%TYPE,
5904: p_filing_sub_jurisdiction IN okl_lines_interface.filing_sub_jurisdiction%TYPE,
5905: p_lien_expiration_date IN okl_lines_interface.lien_expiration_date%TYPE,
5906: p_lien_continuation_number IN okl_lines_interface.lien_continuation_number%TYPE,
5907: p_lien_continuation_date IN okl_lines_interface.lien_continuation_date%TYPE,

Line 5904: p_filing_sub_jurisdiction IN okl_lines_interface.filing_sub_jurisdiction%TYPE,

5900: p_lien_filing_status IN okl_lines_interface.lien_filing_status%TYPE,
5901: p_lienholder_id IN okl_lines_interface.lienholder_id%TYPE,
5902: p_lienholder_number IN okl_lines_interface.lienholder_number%TYPE,
5903: p_filing_jurisdiction IN okl_lines_interface.filing_jurisdiction%TYPE,
5904: p_filing_sub_jurisdiction IN okl_lines_interface.filing_sub_jurisdiction%TYPE,
5905: p_lien_expiration_date IN okl_lines_interface.lien_expiration_date%TYPE,
5906: p_lien_continuation_number IN okl_lines_interface.lien_continuation_number%TYPE,
5907: p_lien_continuation_date IN okl_lines_interface.lien_continuation_date%TYPE,
5908: p_title_type IN okl_lines_interface.title_type%TYPE,

Line 5905: p_lien_expiration_date IN okl_lines_interface.lien_expiration_date%TYPE,

5901: p_lienholder_id IN okl_lines_interface.lienholder_id%TYPE,
5902: p_lienholder_number IN okl_lines_interface.lienholder_number%TYPE,
5903: p_filing_jurisdiction IN okl_lines_interface.filing_jurisdiction%TYPE,
5904: p_filing_sub_jurisdiction IN okl_lines_interface.filing_sub_jurisdiction%TYPE,
5905: p_lien_expiration_date IN okl_lines_interface.lien_expiration_date%TYPE,
5906: p_lien_continuation_number IN okl_lines_interface.lien_continuation_number%TYPE,
5907: p_lien_continuation_date IN okl_lines_interface.lien_continuation_date%TYPE,
5908: p_title_type IN okl_lines_interface.title_type%TYPE,
5909: p_title_issuer_number IN okl_lines_interface.title_issuer_number%TYPE,

Line 5906: p_lien_continuation_number IN okl_lines_interface.lien_continuation_number%TYPE,

5902: p_lienholder_number IN okl_lines_interface.lienholder_number%TYPE,
5903: p_filing_jurisdiction IN okl_lines_interface.filing_jurisdiction%TYPE,
5904: p_filing_sub_jurisdiction IN okl_lines_interface.filing_sub_jurisdiction%TYPE,
5905: p_lien_expiration_date IN okl_lines_interface.lien_expiration_date%TYPE,
5906: p_lien_continuation_number IN okl_lines_interface.lien_continuation_number%TYPE,
5907: p_lien_continuation_date IN okl_lines_interface.lien_continuation_date%TYPE,
5908: p_title_type IN okl_lines_interface.title_type%TYPE,
5909: p_title_issuer_number IN okl_lines_interface.title_issuer_number%TYPE,
5910: p_title_issuer_id IN okl_lines_interface.title_issuer_id%TYPE,

Line 5907: p_lien_continuation_date IN okl_lines_interface.lien_continuation_date%TYPE,

5903: p_filing_jurisdiction IN okl_lines_interface.filing_jurisdiction%TYPE,
5904: p_filing_sub_jurisdiction IN okl_lines_interface.filing_sub_jurisdiction%TYPE,
5905: p_lien_expiration_date IN okl_lines_interface.lien_expiration_date%TYPE,
5906: p_lien_continuation_number IN okl_lines_interface.lien_continuation_number%TYPE,
5907: p_lien_continuation_date IN okl_lines_interface.lien_continuation_date%TYPE,
5908: p_title_type IN okl_lines_interface.title_type%TYPE,
5909: p_title_issuer_number IN okl_lines_interface.title_issuer_number%TYPE,
5910: p_title_issuer_id IN okl_lines_interface.title_issuer_id%TYPE,
5911: p_title_date IN okl_lines_interface.title_date%TYPE,

Line 5908: p_title_type IN okl_lines_interface.title_type%TYPE,

5904: p_filing_sub_jurisdiction IN okl_lines_interface.filing_sub_jurisdiction%TYPE,
5905: p_lien_expiration_date IN okl_lines_interface.lien_expiration_date%TYPE,
5906: p_lien_continuation_number IN okl_lines_interface.lien_continuation_number%TYPE,
5907: p_lien_continuation_date IN okl_lines_interface.lien_continuation_date%TYPE,
5908: p_title_type IN okl_lines_interface.title_type%TYPE,
5909: p_title_issuer_number IN okl_lines_interface.title_issuer_number%TYPE,
5910: p_title_issuer_id IN okl_lines_interface.title_issuer_id%TYPE,
5911: p_title_date IN okl_lines_interface.title_date%TYPE,
5912: p_title_number IN okl_lines_interface.title_number%TYPE,

Line 5909: p_title_issuer_number IN okl_lines_interface.title_issuer_number%TYPE,

5905: p_lien_expiration_date IN okl_lines_interface.lien_expiration_date%TYPE,
5906: p_lien_continuation_number IN okl_lines_interface.lien_continuation_number%TYPE,
5907: p_lien_continuation_date IN okl_lines_interface.lien_continuation_date%TYPE,
5908: p_title_type IN okl_lines_interface.title_type%TYPE,
5909: p_title_issuer_number IN okl_lines_interface.title_issuer_number%TYPE,
5910: p_title_issuer_id IN okl_lines_interface.title_issuer_id%TYPE,
5911: p_title_date IN okl_lines_interface.title_date%TYPE,
5912: p_title_number IN okl_lines_interface.title_number%TYPE,
5913: p_registration_number IN okl_lines_interface.registration_number%TYPE,

Line 5910: p_title_issuer_id IN okl_lines_interface.title_issuer_id%TYPE,

5906: p_lien_continuation_number IN okl_lines_interface.lien_continuation_number%TYPE,
5907: p_lien_continuation_date IN okl_lines_interface.lien_continuation_date%TYPE,
5908: p_title_type IN okl_lines_interface.title_type%TYPE,
5909: p_title_issuer_number IN okl_lines_interface.title_issuer_number%TYPE,
5910: p_title_issuer_id IN okl_lines_interface.title_issuer_id%TYPE,
5911: p_title_date IN okl_lines_interface.title_date%TYPE,
5912: p_title_number IN okl_lines_interface.title_number%TYPE,
5913: p_registration_number IN okl_lines_interface.registration_number%TYPE,
5914: p_asset_registration_loc_name IN okl_lines_interface.asset_registration_loc_name%TYPE,

Line 5911: p_title_date IN okl_lines_interface.title_date%TYPE,

5907: p_lien_continuation_date IN okl_lines_interface.lien_continuation_date%TYPE,
5908: p_title_type IN okl_lines_interface.title_type%TYPE,
5909: p_title_issuer_number IN okl_lines_interface.title_issuer_number%TYPE,
5910: p_title_issuer_id IN okl_lines_interface.title_issuer_id%TYPE,
5911: p_title_date IN okl_lines_interface.title_date%TYPE,
5912: p_title_number IN okl_lines_interface.title_number%TYPE,
5913: p_registration_number IN okl_lines_interface.registration_number%TYPE,
5914: p_asset_registration_loc_name IN okl_lines_interface.asset_registration_loc_name%TYPE,
5915: p_title_custodian_name IN okl_lines_interface.title_custodian_name%TYPE,

Line 5912: p_title_number IN okl_lines_interface.title_number%TYPE,

5908: p_title_type IN okl_lines_interface.title_type%TYPE,
5909: p_title_issuer_number IN okl_lines_interface.title_issuer_number%TYPE,
5910: p_title_issuer_id IN okl_lines_interface.title_issuer_id%TYPE,
5911: p_title_date IN okl_lines_interface.title_date%TYPE,
5912: p_title_number IN okl_lines_interface.title_number%TYPE,
5913: p_registration_number IN okl_lines_interface.registration_number%TYPE,
5914: p_asset_registration_loc_name IN okl_lines_interface.asset_registration_loc_name%TYPE,
5915: p_title_custodian_name IN okl_lines_interface.title_custodian_name%TYPE,
5916: p_payee_site_name IN okl_lines_interface.payee_site_name%TYPE,

Line 5913: p_registration_number IN okl_lines_interface.registration_number%TYPE,

5909: p_title_issuer_number IN okl_lines_interface.title_issuer_number%TYPE,
5910: p_title_issuer_id IN okl_lines_interface.title_issuer_id%TYPE,
5911: p_title_date IN okl_lines_interface.title_date%TYPE,
5912: p_title_number IN okl_lines_interface.title_number%TYPE,
5913: p_registration_number IN okl_lines_interface.registration_number%TYPE,
5914: p_asset_registration_loc_name IN okl_lines_interface.asset_registration_loc_name%TYPE,
5915: p_title_custodian_name IN okl_lines_interface.title_custodian_name%TYPE,
5916: p_payee_site_name IN okl_lines_interface.payee_site_name%TYPE,
5917: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,

Line 5914: p_asset_registration_loc_name IN okl_lines_interface.asset_registration_loc_name%TYPE,

5910: p_title_issuer_id IN okl_lines_interface.title_issuer_id%TYPE,
5911: p_title_date IN okl_lines_interface.title_date%TYPE,
5912: p_title_number IN okl_lines_interface.title_number%TYPE,
5913: p_registration_number IN okl_lines_interface.registration_number%TYPE,
5914: p_asset_registration_loc_name IN okl_lines_interface.asset_registration_loc_name%TYPE,
5915: p_title_custodian_name IN okl_lines_interface.title_custodian_name%TYPE,
5916: p_payee_site_name IN okl_lines_interface.payee_site_name%TYPE,
5917: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,
5918: p_passthrough_basis_code IN okl_lines_interface.passthrough_basis_code%TYPE,

Line 5915: p_title_custodian_name IN okl_lines_interface.title_custodian_name%TYPE,

5911: p_title_date IN okl_lines_interface.title_date%TYPE,
5912: p_title_number IN okl_lines_interface.title_number%TYPE,
5913: p_registration_number IN okl_lines_interface.registration_number%TYPE,
5914: p_asset_registration_loc_name IN okl_lines_interface.asset_registration_loc_name%TYPE,
5915: p_title_custodian_name IN okl_lines_interface.title_custodian_name%TYPE,
5916: p_payee_site_name IN okl_lines_interface.payee_site_name%TYPE,
5917: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,
5918: p_passthrough_basis_code IN okl_lines_interface.passthrough_basis_code%TYPE,
5919: p_fee_code IN okl_lines_interface.fee_code%TYPE,

Line 5916: p_payee_site_name IN okl_lines_interface.payee_site_name%TYPE,

5912: p_title_number IN okl_lines_interface.title_number%TYPE,
5913: p_registration_number IN okl_lines_interface.registration_number%TYPE,
5914: p_asset_registration_loc_name IN okl_lines_interface.asset_registration_loc_name%TYPE,
5915: p_title_custodian_name IN okl_lines_interface.title_custodian_name%TYPE,
5916: p_payee_site_name IN okl_lines_interface.payee_site_name%TYPE,
5917: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,
5918: p_passthrough_basis_code IN okl_lines_interface.passthrough_basis_code%TYPE,
5919: p_fee_code IN okl_lines_interface.fee_code%TYPE,
5920: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,

Line 5917: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,

5913: p_registration_number IN okl_lines_interface.registration_number%TYPE,
5914: p_asset_registration_loc_name IN okl_lines_interface.asset_registration_loc_name%TYPE,
5915: p_title_custodian_name IN okl_lines_interface.title_custodian_name%TYPE,
5916: p_payee_site_name IN okl_lines_interface.payee_site_name%TYPE,
5917: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,
5918: p_passthrough_basis_code IN okl_lines_interface.passthrough_basis_code%TYPE,
5919: p_fee_code IN okl_lines_interface.fee_code%TYPE,
5920: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
5921: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,

Line 5918: p_passthrough_basis_code IN okl_lines_interface.passthrough_basis_code%TYPE,

5914: p_asset_registration_loc_name IN okl_lines_interface.asset_registration_loc_name%TYPE,
5915: p_title_custodian_name IN okl_lines_interface.title_custodian_name%TYPE,
5916: p_payee_site_name IN okl_lines_interface.payee_site_name%TYPE,
5917: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,
5918: p_passthrough_basis_code IN okl_lines_interface.passthrough_basis_code%TYPE,
5919: p_fee_code IN okl_lines_interface.fee_code%TYPE,
5920: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
5921: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,
5922: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,

Line 5919: p_fee_code IN okl_lines_interface.fee_code%TYPE,

5915: p_title_custodian_name IN okl_lines_interface.title_custodian_name%TYPE,
5916: p_payee_site_name IN okl_lines_interface.payee_site_name%TYPE,
5917: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,
5918: p_passthrough_basis_code IN okl_lines_interface.passthrough_basis_code%TYPE,
5919: p_fee_code IN okl_lines_interface.fee_code%TYPE,
5920: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
5921: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,
5922: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,
5923: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,

Line 5920: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,

5916: p_payee_site_name IN okl_lines_interface.payee_site_name%TYPE,
5917: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,
5918: p_passthrough_basis_code IN okl_lines_interface.passthrough_basis_code%TYPE,
5919: p_fee_code IN okl_lines_interface.fee_code%TYPE,
5920: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
5921: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,
5922: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,
5923: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,
5924: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,

Line 5921: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,

5917: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,
5918: p_passthrough_basis_code IN okl_lines_interface.passthrough_basis_code%TYPE,
5919: p_fee_code IN okl_lines_interface.fee_code%TYPE,
5920: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
5921: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,
5922: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,
5923: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,
5924: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,
5925: p_minimum_qty_usage IN okl_lines_interface.minimum_qty_usage%TYPE,

Line 5922: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,

5918: p_passthrough_basis_code IN okl_lines_interface.passthrough_basis_code%TYPE,
5919: p_fee_code IN okl_lines_interface.fee_code%TYPE,
5920: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
5921: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,
5922: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,
5923: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,
5924: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,
5925: p_minimum_qty_usage IN okl_lines_interface.minimum_qty_usage%TYPE,
5926: p_default_qty_usage IN okl_lines_interface.default_qty_usage%TYPE,

Line 5923: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,

5919: p_fee_code IN okl_lines_interface.fee_code%TYPE,
5920: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
5921: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,
5922: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,
5923: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,
5924: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,
5925: p_minimum_qty_usage IN okl_lines_interface.minimum_qty_usage%TYPE,
5926: p_default_qty_usage IN okl_lines_interface.default_qty_usage%TYPE,
5927: p_amcv_flag IN okl_lines_interface.amcv_flag%TYPE,

Line 5924: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,

5920: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
5921: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,
5922: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,
5923: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,
5924: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,
5925: p_minimum_qty_usage IN okl_lines_interface.minimum_qty_usage%TYPE,
5926: p_default_qty_usage IN okl_lines_interface.default_qty_usage%TYPE,
5927: p_amcv_flag IN okl_lines_interface.amcv_flag%TYPE,
5928: p_level_flag IN okl_lines_interface.level_flag%TYPE,

Line 5925: p_minimum_qty_usage IN okl_lines_interface.minimum_qty_usage%TYPE,

5921: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,
5922: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,
5923: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,
5924: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,
5925: p_minimum_qty_usage IN okl_lines_interface.minimum_qty_usage%TYPE,
5926: p_default_qty_usage IN okl_lines_interface.default_qty_usage%TYPE,
5927: p_amcv_flag IN okl_lines_interface.amcv_flag%TYPE,
5928: p_level_flag IN okl_lines_interface.level_flag%TYPE,
5929: p_base_reading IN okl_lines_interface.base_reading%TYPE,

Line 5926: p_default_qty_usage IN okl_lines_interface.default_qty_usage%TYPE,

5922: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,
5923: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,
5924: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,
5925: p_minimum_qty_usage IN okl_lines_interface.minimum_qty_usage%TYPE,
5926: p_default_qty_usage IN okl_lines_interface.default_qty_usage%TYPE,
5927: p_amcv_flag IN okl_lines_interface.amcv_flag%TYPE,
5928: p_level_flag IN okl_lines_interface.level_flag%TYPE,
5929: p_base_reading IN okl_lines_interface.base_reading%TYPE,
5930: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,

Line 5927: p_amcv_flag IN okl_lines_interface.amcv_flag%TYPE,

5923: p_price_list_name IN okl_lines_interface.price_list_name%TYPE,
5924: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,
5925: p_minimum_qty_usage IN okl_lines_interface.minimum_qty_usage%TYPE,
5926: p_default_qty_usage IN okl_lines_interface.default_qty_usage%TYPE,
5927: p_amcv_flag IN okl_lines_interface.amcv_flag%TYPE,
5928: p_level_flag IN okl_lines_interface.level_flag%TYPE,
5929: p_base_reading IN okl_lines_interface.base_reading%TYPE,
5930: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,
5931: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,

Line 5928: p_level_flag IN okl_lines_interface.level_flag%TYPE,

5924: p_price_list_id IN okl_lines_interface.price_list_id%TYPE,
5925: p_minimum_qty_usage IN okl_lines_interface.minimum_qty_usage%TYPE,
5926: p_default_qty_usage IN okl_lines_interface.default_qty_usage%TYPE,
5927: p_amcv_flag IN okl_lines_interface.amcv_flag%TYPE,
5928: p_level_flag IN okl_lines_interface.level_flag%TYPE,
5929: p_base_reading IN okl_lines_interface.base_reading%TYPE,
5930: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,
5931: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,
5932: p_fixed_usage_quantity IN okl_lines_interface.fixed_usage_quantity%TYPE,

Line 5929: p_base_reading IN okl_lines_interface.base_reading%TYPE,

5925: p_minimum_qty_usage IN okl_lines_interface.minimum_qty_usage%TYPE,
5926: p_default_qty_usage IN okl_lines_interface.default_qty_usage%TYPE,
5927: p_amcv_flag IN okl_lines_interface.amcv_flag%TYPE,
5928: p_level_flag IN okl_lines_interface.level_flag%TYPE,
5929: p_base_reading IN okl_lines_interface.base_reading%TYPE,
5930: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,
5931: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,
5932: p_fixed_usage_quantity IN okl_lines_interface.fixed_usage_quantity%TYPE,
5933: p_usage_period IN okl_lines_interface.usage_period%TYPE,

Line 5930: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,

5926: p_default_qty_usage IN okl_lines_interface.default_qty_usage%TYPE,
5927: p_amcv_flag IN okl_lines_interface.amcv_flag%TYPE,
5928: p_level_flag IN okl_lines_interface.level_flag%TYPE,
5929: p_base_reading IN okl_lines_interface.base_reading%TYPE,
5930: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,
5931: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,
5932: p_fixed_usage_quantity IN okl_lines_interface.fixed_usage_quantity%TYPE,
5933: p_usage_period IN okl_lines_interface.usage_period%TYPE,
5934: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,

Line 5931: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,

5927: p_amcv_flag IN okl_lines_interface.amcv_flag%TYPE,
5928: p_level_flag IN okl_lines_interface.level_flag%TYPE,
5929: p_base_reading IN okl_lines_interface.base_reading%TYPE,
5930: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,
5931: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,
5932: p_fixed_usage_quantity IN okl_lines_interface.fixed_usage_quantity%TYPE,
5933: p_usage_period IN okl_lines_interface.usage_period%TYPE,
5934: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,
5935: p_fee_no_of_period IN okl_lines_interface.fee_exp_no_of_periods%TYPE,

Line 5932: p_fixed_usage_quantity IN okl_lines_interface.fixed_usage_quantity%TYPE,

5928: p_level_flag IN okl_lines_interface.level_flag%TYPE,
5929: p_base_reading IN okl_lines_interface.base_reading%TYPE,
5930: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,
5931: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,
5932: p_fixed_usage_quantity IN okl_lines_interface.fixed_usage_quantity%TYPE,
5933: p_usage_period IN okl_lines_interface.usage_period%TYPE,
5934: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,
5935: p_fee_no_of_period IN okl_lines_interface.fee_exp_no_of_periods%TYPE,
5936: p_fee_frequency IN okl_lines_interface.fee_exp_frequency%TYPE,

Line 5933: p_usage_period IN okl_lines_interface.usage_period%TYPE,

5929: p_base_reading IN okl_lines_interface.base_reading%TYPE,
5930: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,
5931: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,
5932: p_fixed_usage_quantity IN okl_lines_interface.fixed_usage_quantity%TYPE,
5933: p_usage_period IN okl_lines_interface.usage_period%TYPE,
5934: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,
5935: p_fee_no_of_period IN okl_lines_interface.fee_exp_no_of_periods%TYPE,
5936: p_fee_frequency IN okl_lines_interface.fee_exp_frequency%TYPE,
5937: p_fee_amount_per_period IN okl_lines_interface.fee_exp_amount_per_period%TYPE,

Line 5934: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,

5930: p_base_reading_uom_code IN okl_lines_interface.base_reading_uom_code%TYPE,
5931: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,
5932: p_fixed_usage_quantity IN okl_lines_interface.fixed_usage_quantity%TYPE,
5933: p_usage_period IN okl_lines_interface.usage_period%TYPE,
5934: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,
5935: p_fee_no_of_period IN okl_lines_interface.fee_exp_no_of_periods%TYPE,
5936: p_fee_frequency IN okl_lines_interface.fee_exp_frequency%TYPE,
5937: p_fee_amount_per_period IN okl_lines_interface.fee_exp_amount_per_period%TYPE,
5938: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,

Line 5935: p_fee_no_of_period IN okl_lines_interface.fee_exp_no_of_periods%TYPE,

5931: p_usage_type_code IN okl_lines_interface.usage_type_code%TYPE,
5932: p_fixed_usage_quantity IN okl_lines_interface.fixed_usage_quantity%TYPE,
5933: p_usage_period IN okl_lines_interface.usage_period%TYPE,
5934: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,
5935: p_fee_no_of_period IN okl_lines_interface.fee_exp_no_of_periods%TYPE,
5936: p_fee_frequency IN okl_lines_interface.fee_exp_frequency%TYPE,
5937: p_fee_amount_per_period IN okl_lines_interface.fee_exp_amount_per_period%TYPE,
5938: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,
5939: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,

Line 5936: p_fee_frequency IN okl_lines_interface.fee_exp_frequency%TYPE,

5932: p_fixed_usage_quantity IN okl_lines_interface.fixed_usage_quantity%TYPE,
5933: p_usage_period IN okl_lines_interface.usage_period%TYPE,
5934: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,
5935: p_fee_no_of_period IN okl_lines_interface.fee_exp_no_of_periods%TYPE,
5936: p_fee_frequency IN okl_lines_interface.fee_exp_frequency%TYPE,
5937: p_fee_amount_per_period IN okl_lines_interface.fee_exp_amount_per_period%TYPE,
5938: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,
5939: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,
5940: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,

Line 5937: p_fee_amount_per_period IN okl_lines_interface.fee_exp_amount_per_period%TYPE,

5933: p_usage_period IN okl_lines_interface.usage_period%TYPE,
5934: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,
5935: p_fee_no_of_period IN okl_lines_interface.fee_exp_no_of_periods%TYPE,
5936: p_fee_frequency IN okl_lines_interface.fee_exp_frequency%TYPE,
5937: p_fee_amount_per_period IN okl_lines_interface.fee_exp_amount_per_period%TYPE,
5938: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,
5939: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,
5940: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,
5941: p_french_tax_name IN okl_lines_interface.french_tax_name%TYPE,

Line 5938: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,

5934: p_usage_no_of_period IN okl_lines_interface.usage_no_of_period%TYPE,
5935: p_fee_no_of_period IN okl_lines_interface.fee_exp_no_of_periods%TYPE,
5936: p_fee_frequency IN okl_lines_interface.fee_exp_frequency%TYPE,
5937: p_fee_amount_per_period IN okl_lines_interface.fee_exp_amount_per_period%TYPE,
5938: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,
5939: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,
5940: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,
5941: p_french_tax_name IN okl_lines_interface.french_tax_name%TYPE,
5942: -- Added by rravikir (Fix for Bug 3947959)

Line 5939: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,

5935: p_fee_no_of_period IN okl_lines_interface.fee_exp_no_of_periods%TYPE,
5936: p_fee_frequency IN okl_lines_interface.fee_exp_frequency%TYPE,
5937: p_fee_amount_per_period IN okl_lines_interface.fee_exp_amount_per_period%TYPE,
5938: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,
5939: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,
5940: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,
5941: p_french_tax_name IN okl_lines_interface.french_tax_name%TYPE,
5942: -- Added by rravikir (Fix for Bug 3947959)
5943: p_prop_tax_bill_method IN okl_lines_interface.prop_tax_bill_method%TYPE,

Line 5940: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,

5936: p_fee_frequency IN okl_lines_interface.fee_exp_frequency%TYPE,
5937: p_fee_amount_per_period IN okl_lines_interface.fee_exp_amount_per_period%TYPE,
5938: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,
5939: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,
5940: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,
5941: p_french_tax_name IN okl_lines_interface.french_tax_name%TYPE,
5942: -- Added by rravikir (Fix for Bug 3947959)
5943: p_prop_tax_bill_method IN okl_lines_interface.prop_tax_bill_method%TYPE,
5944: p_prop_tax_as_contract_yn IN okl_lines_interface.prop_tax_as_contract_yn%TYPE

Line 5941: p_french_tax_name IN okl_lines_interface.french_tax_name%TYPE,

5937: p_fee_amount_per_period IN okl_lines_interface.fee_exp_amount_per_period%TYPE,
5938: p_prop_tax_applicable IN okl_lines_interface.prop_tax_applicable%TYPE,
5939: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,
5940: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,
5941: p_french_tax_name IN okl_lines_interface.french_tax_name%TYPE,
5942: -- Added by rravikir (Fix for Bug 3947959)
5943: p_prop_tax_bill_method IN okl_lines_interface.prop_tax_bill_method%TYPE,
5944: p_prop_tax_as_contract_yn IN okl_lines_interface.prop_tax_as_contract_yn%TYPE
5945: -- End

Line 5943: p_prop_tax_bill_method IN okl_lines_interface.prop_tax_bill_method%TYPE,

5939: p_prop_tax_lease_rep IN okl_lines_interface.prop_tax_lease_rep%TYPE,
5940: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,
5941: p_french_tax_name IN okl_lines_interface.french_tax_name%TYPE,
5942: -- Added by rravikir (Fix for Bug 3947959)
5943: p_prop_tax_bill_method IN okl_lines_interface.prop_tax_bill_method%TYPE,
5944: p_prop_tax_as_contract_yn IN okl_lines_interface.prop_tax_as_contract_yn%TYPE
5945: -- End
5946: ) IS
5947:

Line 5944: p_prop_tax_as_contract_yn IN okl_lines_interface.prop_tax_as_contract_yn%TYPE

5940: p_french_tax_code IN okl_lines_interface.french_tax_code%TYPE,
5941: p_french_tax_name IN okl_lines_interface.french_tax_name%TYPE,
5942: -- Added by rravikir (Fix for Bug 3947959)
5943: p_prop_tax_bill_method IN okl_lines_interface.prop_tax_bill_method%TYPE,
5944: p_prop_tax_as_contract_yn IN okl_lines_interface.prop_tax_as_contract_yn%TYPE
5945: -- End
5946: ) IS
5947:
5948: line_rule_failed EXCEPTION;

Line 19053: p_line_number IN OKL_LINES_INTERFACE.LINE_NUMBER%TYPE,

19049: ------------------------------------------------------------------------------
19050: FUNCTION get_vendor_paygroup(
19051: x_return_status OUT NOCOPY VARCHAR2,
19052: p_contract_number IN OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,
19053: p_line_number IN OKL_LINES_INTERFACE.LINE_NUMBER%TYPE,
19054: p_auth_org_id IN OKL_HEADER_INTERFACE.authoring_org_id%TYPE,
19055: p_vendor_paysite_id IN OKL_LINES_INTERFACE.VENDOR_PAYSITE_ID%TYPE
19056: )
19057: RETURN NUMBER IS

Line 19055: p_vendor_paysite_id IN OKL_LINES_INTERFACE.VENDOR_PAYSITE_ID%TYPE

19051: x_return_status OUT NOCOPY VARCHAR2,
19052: p_contract_number IN OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,
19053: p_line_number IN OKL_LINES_INTERFACE.LINE_NUMBER%TYPE,
19054: p_auth_org_id IN OKL_HEADER_INTERFACE.authoring_org_id%TYPE,
19055: p_vendor_paysite_id IN OKL_LINES_INTERFACE.VENDOR_PAYSITE_ID%TYPE
19056: )
19057: RETURN NUMBER IS
19058: CURSOR paygroup_csr (p_paysite_id NUMBER,
19059: p_org_id NUMBER) IS

Line 19103: p_line_type IN okl_lines_interface.line_type%TYPE,

19099: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
19100: p_chr_id IN okc_k_headers_v.id%TYPE,
19101: p_auth_org_id IN okl_header_interface.authoring_org_id%TYPE,
19102: p_line_number IN okc_k_lines_v.line_number%TYPE,
19103: p_line_type IN okl_lines_interface.line_type%TYPE,
19104: p_fin_cle_id IN NUMBER,
19105: p_model_cle_id IN NUMBER,
19106: p_service_line_id IN NUMBER,
19107: p_fee_line_id IN NUMBER,

Line 19126: p_payment_term IN okl_lines_interface.payment_term%TYPE,

19122: p_guarantee_date IN okl_party_roles_interface.guarantee_date%TYPE,
19123: p_guarantee_comment IN okl_party_roles_interface.guarantee_comment%TYPE,
19124: p_guarantor_site_number IN okl_party_roles_interface.guarantor_site_number%TYPE,
19125: p_guarantor_site_id IN okl_party_roles_interface.guarantor_site_id%TYPE,
19126: p_payment_term IN okl_lines_interface.payment_term%TYPE,
19127: p_payment_term_id IN okl_lines_interface.payment_term_id%TYPE,
19128: p_vendor_paysite_id IN okl_lines_interface.vendor_paysite_id%TYPE,
19129: p_vendor_paysite_name IN okl_lines_interface.vendor_paysite_name%TYPE,
19130: p_vendor_payment_method IN okl_lines_interface.vendor_payment_method%TYPE,

Line 19127: p_payment_term_id IN okl_lines_interface.payment_term_id%TYPE,

19123: p_guarantee_comment IN okl_party_roles_interface.guarantee_comment%TYPE,
19124: p_guarantor_site_number IN okl_party_roles_interface.guarantor_site_number%TYPE,
19125: p_guarantor_site_id IN okl_party_roles_interface.guarantor_site_id%TYPE,
19126: p_payment_term IN okl_lines_interface.payment_term%TYPE,
19127: p_payment_term_id IN okl_lines_interface.payment_term_id%TYPE,
19128: p_vendor_paysite_id IN okl_lines_interface.vendor_paysite_id%TYPE,
19129: p_vendor_paysite_name IN okl_lines_interface.vendor_paysite_name%TYPE,
19130: p_vendor_payment_method IN okl_lines_interface.vendor_payment_method%TYPE,
19131: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,

Line 19128: p_vendor_paysite_id IN okl_lines_interface.vendor_paysite_id%TYPE,

19124: p_guarantor_site_number IN okl_party_roles_interface.guarantor_site_number%TYPE,
19125: p_guarantor_site_id IN okl_party_roles_interface.guarantor_site_id%TYPE,
19126: p_payment_term IN okl_lines_interface.payment_term%TYPE,
19127: p_payment_term_id IN okl_lines_interface.payment_term_id%TYPE,
19128: p_vendor_paysite_id IN okl_lines_interface.vendor_paysite_id%TYPE,
19129: p_vendor_paysite_name IN okl_lines_interface.vendor_paysite_name%TYPE,
19130: p_vendor_payment_method IN okl_lines_interface.vendor_payment_method%TYPE,
19131: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,
19132: p_passthrough_basis_code IN okl_lines_interface.passthrough_basis_code%TYPE,

Line 19129: p_vendor_paysite_name IN okl_lines_interface.vendor_paysite_name%TYPE,

19125: p_guarantor_site_id IN okl_party_roles_interface.guarantor_site_id%TYPE,
19126: p_payment_term IN okl_lines_interface.payment_term%TYPE,
19127: p_payment_term_id IN okl_lines_interface.payment_term_id%TYPE,
19128: p_vendor_paysite_id IN okl_lines_interface.vendor_paysite_id%TYPE,
19129: p_vendor_paysite_name IN okl_lines_interface.vendor_paysite_name%TYPE,
19130: p_vendor_payment_method IN okl_lines_interface.vendor_payment_method%TYPE,
19131: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,
19132: p_passthrough_basis_code IN okl_lines_interface.passthrough_basis_code%TYPE,
19133: p_billable_vendor_id IN okl_party_roles_interface.billable_vendor_id%TYPE,

Line 19130: p_vendor_payment_method IN okl_lines_interface.vendor_payment_method%TYPE,

19126: p_payment_term IN okl_lines_interface.payment_term%TYPE,
19127: p_payment_term_id IN okl_lines_interface.payment_term_id%TYPE,
19128: p_vendor_paysite_id IN okl_lines_interface.vendor_paysite_id%TYPE,
19129: p_vendor_paysite_name IN okl_lines_interface.vendor_paysite_name%TYPE,
19130: p_vendor_payment_method IN okl_lines_interface.vendor_payment_method%TYPE,
19131: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,
19132: p_passthrough_basis_code IN okl_lines_interface.passthrough_basis_code%TYPE,
19133: p_billable_vendor_id IN okl_party_roles_interface.billable_vendor_id%TYPE,
19134: p_billable_vendor_name IN okl_party_roles_interface.billable_vendor_name%TYPE,

Line 19131: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,

19127: p_payment_term_id IN okl_lines_interface.payment_term_id%TYPE,
19128: p_vendor_paysite_id IN okl_lines_interface.vendor_paysite_id%TYPE,
19129: p_vendor_paysite_name IN okl_lines_interface.vendor_paysite_name%TYPE,
19130: p_vendor_payment_method IN okl_lines_interface.vendor_payment_method%TYPE,
19131: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,
19132: p_passthrough_basis_code IN okl_lines_interface.passthrough_basis_code%TYPE,
19133: p_billable_vendor_id IN okl_party_roles_interface.billable_vendor_id%TYPE,
19134: p_billable_vendor_name IN okl_party_roles_interface.billable_vendor_name%TYPE,
19135: p_vend_as_customer_number IN okl_party_roles_interface.vend_as_customer_number%TYPE,

Line 19132: p_passthrough_basis_code IN okl_lines_interface.passthrough_basis_code%TYPE,

19128: p_vendor_paysite_id IN okl_lines_interface.vendor_paysite_id%TYPE,
19129: p_vendor_paysite_name IN okl_lines_interface.vendor_paysite_name%TYPE,
19130: p_vendor_payment_method IN okl_lines_interface.vendor_payment_method%TYPE,
19131: p_passthrough_percent IN okl_lines_interface.passthrough_percent%TYPE,
19132: p_passthrough_basis_code IN okl_lines_interface.passthrough_basis_code%TYPE,
19133: p_billable_vendor_id IN okl_party_roles_interface.billable_vendor_id%TYPE,
19134: p_billable_vendor_name IN okl_party_roles_interface.billable_vendor_name%TYPE,
19135: p_vend_as_customer_number IN okl_party_roles_interface.vend_as_customer_number%TYPE,
19136: p_vend_as_customer_id IN okl_party_roles_interface.vend_as_customer_id%TYPE,

Line 21666: p_line_type IN okl_lines_interface.line_type%TYPE,

21662: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
21663: p_chr_id IN okc_k_headers_v.id%TYPE,
21664: p_auth_org_id IN okl_header_interface.authoring_org_id%TYPE,
21665: p_line_number IN okc_k_lines_v.line_number%TYPE,
21666: p_line_type IN okl_lines_interface.line_type%TYPE,
21667: p_cle_id IN okc_k_lines_v.id%TYPE,
21668: p_bill_to_address_id IN okl_terms_interface.bill_to_address_id%TYPE,
21669: p_bill_to_address IN okl_terms_interface.bill_to_address%TYPE,
21670: p_bank_account_id IN okl_terms_interface.bank_account_id%TYPE,

Line 22231: p_line_number IN okl_lines_interface.line_number%TYPE,

22227: x_return_status OUT NOCOPY VARCHAR2,
22228: x_msg_count OUT NOCOPY NUMBER,
22229: x_msg_data OUT NOCOPY VARCHAR2,
22230: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
22231: p_line_number IN okl_lines_interface.line_number%TYPE,
22232: p_payment_type_code IN VARCHAR2,
22233: p_stream_purpose IN okl_payments_interface.stream_purpose_code%TYPE,
22234: p_chr_id IN NUMBER,
22235: p_cle_id IN NUMBER,

Line 22432: p_line_number IN okl_lines_interface.line_number%TYPE,

22428: x_return_status OUT NOCOPY VARCHAR2,
22429: x_msg_count OUT NOCOPY NUMBER,
22430: x_msg_data OUT NOCOPY VARCHAR2,
22431: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
22432: p_line_number IN okl_lines_interface.line_number%TYPE,
22433: p_payment_sch_number IN okl_payments_interface.payment_schedule_number%TYPE,
22434: p_payment_freq_code IN okl_payments_interface.payment_frequency_code%TYPE,
22435: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,
22436: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,

Line 22630: p_line_number IN okl_lines_interface.line_number%TYPE,

22626: x_return_status OUT NOCOPY VARCHAR2,
22627: x_msg_count OUT NOCOPY NUMBER,
22628: x_msg_data OUT NOCOPY VARCHAR2,
22629: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
22630: p_line_number IN okl_lines_interface.line_number%TYPE,
22631: p_line_type IN okl_lines_interface.line_type%TYPE,
22632: p_inventory_org_id IN okl_header_interface.inventory_organization_id%TYPE,
22633: p_inventory_item_id IN okl_lines_interface.inventory_item_id%TYPE,
22634: p_inventory_item_name IN okl_lines_interface.inventory_item_name%TYPE,

Line 22631: p_line_type IN okl_lines_interface.line_type%TYPE,

22627: x_msg_count OUT NOCOPY NUMBER,
22628: x_msg_data OUT NOCOPY VARCHAR2,
22629: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
22630: p_line_number IN okl_lines_interface.line_number%TYPE,
22631: p_line_type IN okl_lines_interface.line_type%TYPE,
22632: p_inventory_org_id IN okl_header_interface.inventory_organization_id%TYPE,
22633: p_inventory_item_id IN okl_lines_interface.inventory_item_id%TYPE,
22634: p_inventory_item_name IN okl_lines_interface.inventory_item_name%TYPE,
22635: x_inventory_org_id OUT NOCOPY NUMBER,

Line 22633: p_inventory_item_id IN okl_lines_interface.inventory_item_id%TYPE,

22629: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
22630: p_line_number IN okl_lines_interface.line_number%TYPE,
22631: p_line_type IN okl_lines_interface.line_type%TYPE,
22632: p_inventory_org_id IN okl_header_interface.inventory_organization_id%TYPE,
22633: p_inventory_item_id IN okl_lines_interface.inventory_item_id%TYPE,
22634: p_inventory_item_name IN okl_lines_interface.inventory_item_name%TYPE,
22635: x_inventory_org_id OUT NOCOPY NUMBER,
22636: x_inventory_item_id OUT NOCOPY NUMBER
22637: ) IS

Line 22634: p_inventory_item_name IN okl_lines_interface.inventory_item_name%TYPE,

22630: p_line_number IN okl_lines_interface.line_number%TYPE,
22631: p_line_type IN okl_lines_interface.line_type%TYPE,
22632: p_inventory_org_id IN okl_header_interface.inventory_organization_id%TYPE,
22633: p_inventory_item_id IN okl_lines_interface.inventory_item_id%TYPE,
22634: p_inventory_item_name IN okl_lines_interface.inventory_item_name%TYPE,
22635: x_inventory_org_id OUT NOCOPY NUMBER,
22636: x_inventory_item_id OUT NOCOPY NUMBER
22637: ) IS
22638: l_proc_name VARCHAR2(35) := 'GET_INVENTORY_ORG_ITEM_ID';

Line 22808: p_line_number IN okl_lines_interface.line_number%TYPE,

22804: x_return_status OUT NOCOPY VARCHAR2,
22805: x_msg_count OUT NOCOPY NUMBER,
22806: x_msg_data OUT NOCOPY VARCHAR2,
22807: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
22808: p_line_number IN okl_lines_interface.line_number%TYPE,
22809: p_asset_number IN okl_lines_interface.asset_number%TYPE,
22810: x_id1 OUT NOCOPY okx_assets_v.id1%TYPE,
22811: x_id2 OUT NOCOPY okx_assets_v.id2%TYPE
22812: ) IS

Line 22809: p_asset_number IN okl_lines_interface.asset_number%TYPE,

22805: x_msg_count OUT NOCOPY NUMBER,
22806: x_msg_data OUT NOCOPY VARCHAR2,
22807: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
22808: p_line_number IN okl_lines_interface.line_number%TYPE,
22809: p_asset_number IN okl_lines_interface.asset_number%TYPE,
22810: x_id1 OUT NOCOPY okx_assets_v.id1%TYPE,
22811: x_id2 OUT NOCOPY okx_assets_v.id2%TYPE
22812: ) IS
22813:

Line 23176: p_line_number IN okl_lines_interface.line_number%TYPE,

23172: x_return_status OUT NOCOPY VARCHAR2,
23173: x_msg_count OUT NOCOPY NUMBER,
23174: x_msg_data OUT NOCOPY VARCHAR2,
23175: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
23176: p_line_number IN okl_lines_interface.line_number%TYPE,
23177: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
23178: p_install_site_number IN okl_lines_interface.install_site_number%TYPE,
23179: x_install_site_id OUT NOCOPY okl_lines_interface.install_site_id%TYPE
23180: ) IS

Line 23177: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,

23173: x_msg_count OUT NOCOPY NUMBER,
23174: x_msg_data OUT NOCOPY VARCHAR2,
23175: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
23176: p_line_number IN okl_lines_interface.line_number%TYPE,
23177: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
23178: p_install_site_number IN okl_lines_interface.install_site_number%TYPE,
23179: x_install_site_id OUT NOCOPY okl_lines_interface.install_site_id%TYPE
23180: ) IS
23181: l_proc_name VARCHAR2(35) := 'GET_INSTALL_SITE_ID';

Line 23178: p_install_site_number IN okl_lines_interface.install_site_number%TYPE,

23174: x_msg_data OUT NOCOPY VARCHAR2,
23175: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
23176: p_line_number IN okl_lines_interface.line_number%TYPE,
23177: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
23178: p_install_site_number IN okl_lines_interface.install_site_number%TYPE,
23179: x_install_site_id OUT NOCOPY okl_lines_interface.install_site_id%TYPE
23180: ) IS
23181: l_proc_name VARCHAR2(35) := 'GET_INSTALL_SITE_ID';
23182: install_failed EXCEPTION;

Line 23179: x_install_site_id OUT NOCOPY okl_lines_interface.install_site_id%TYPE

23175: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
23176: p_line_number IN okl_lines_interface.line_number%TYPE,
23177: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
23178: p_install_site_number IN okl_lines_interface.install_site_number%TYPE,
23179: x_install_site_id OUT NOCOPY okl_lines_interface.install_site_id%TYPE
23180: ) IS
23181: l_proc_name VARCHAR2(35) := 'GET_INSTALL_SITE_ID';
23182: install_failed EXCEPTION;
23183: l_id1 okx_party_site_uses_v.id1%TYPE;

Line 23249: p_line_number IN okl_lines_interface.line_number%TYPE,

23245: x_return_status OUT NOCOPY VARCHAR2,
23246: x_msg_count OUT NOCOPY NUMBER,
23247: x_msg_data OUT NOCOPY VARCHAR2,
23248: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
23249: p_line_number IN okl_lines_interface.line_number%TYPE,
23250: p_lty_code IN VARCHAR2,
23251: p_top_line_lty_code IN VARCHAR2,
23252: x_lse_id OUT NOCOPY NUMBER
23253: ) IS

Line 23346: p_intf_line IN OKL_LINES_INTERFACE%ROWTYPE

23342: PROCEDURE validate_real_est(
23343: x_return_status OUT NOCOPY VARCHAR2,
23344: x_msg_count OUT NOCOPY NUMBER,
23345: x_msg_data OUT NOCOPY VARCHAR2,
23346: p_intf_line IN OKL_LINES_INTERFACE%ROWTYPE
23347: ) IS
23348:
23349: l_proc_name VARCHAR2(150) := 'OKL_LINES_INTERFACE: validate_real_est';
23350: l_progress varchar2(150);

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

23345: x_msg_data OUT NOCOPY VARCHAR2,
23346: p_intf_line IN OKL_LINES_INTERFACE%ROWTYPE
23347: ) IS
23348:
23349: l_proc_name VARCHAR2(150) := 'OKL_LINES_INTERFACE: validate_real_est';
23350: l_progress varchar2(150);
23351: l_dummy number;
23352: l_prc boolean := false;
23353:

Line 23453: p_asset_number IN okl_lines_interface.asset_number%TYPE,

23449: PROCEDURE get_link_asset_id(
23450: x_return_status OUT NOCOPY VARCHAR2,
23451: x_msg_count OUT NOCOPY NUMBER,
23452: x_msg_data OUT NOCOPY VARCHAR2,
23453: p_asset_number IN okl_lines_interface.asset_number%TYPE,
23454: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
23455: p_chr_id IN okc_k_headers_v.id%TYPE,
23456: p_line_number IN okc_k_lines_v.line_number%TYPE,
23457: x_asset_line_id OUT NOCOPY okc_k_lines_v.id%TYPE

Line 23534: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,

23530: x_msg_data OUT NOCOPY VARCHAR2,
23531: p_contract_number IN VARCHAR2,
23532: p_line_number IN NUMBER,
23533: p_asset_line_id IN NUMBER,
23534: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,
23535: p_usage_item_name IN VARCHAR2,
23536: p_inv_org_id IN NUMBER
23537: ) IS
23538: l_proc_name VARCHAR2(35) := 'VALIDATE_USAGE_ITEM_ASSOC';

Line 23606: p_term_quote_id IN okl_lines_interface.termination_quote_id%TYPE,

23602: x_msg_data OUT NOCOPY VARCHAR2,
23603: p_chr_id IN NUMBER,
23604: p_contract_number IN VARCHAR2,
23605: p_line_number IN NUMBER,
23606: p_term_quote_id IN okl_lines_interface.termination_quote_id%TYPE,
23607: p_term_quote_number IN okl_lines_interface.termination_quote_number%TYPE,
23608: x_term_quote_id OUT NOCOPY okl_lines_interface.termination_quote_id%TYPE
23609: ) IS
23610:

Line 23607: p_term_quote_number IN okl_lines_interface.termination_quote_number%TYPE,

23603: p_chr_id IN NUMBER,
23604: p_contract_number IN VARCHAR2,
23605: p_line_number IN NUMBER,
23606: p_term_quote_id IN okl_lines_interface.termination_quote_id%TYPE,
23607: p_term_quote_number IN okl_lines_interface.termination_quote_number%TYPE,
23608: x_term_quote_id OUT NOCOPY okl_lines_interface.termination_quote_id%TYPE
23609: ) IS
23610:
23611: l_proc_name VARCHAR2(35) := 'VALIDATE_TERM_QUOTE';

Line 23608: x_term_quote_id OUT NOCOPY okl_lines_interface.termination_quote_id%TYPE

23604: p_contract_number IN VARCHAR2,
23605: p_line_number IN NUMBER,
23606: p_term_quote_id IN okl_lines_interface.termination_quote_id%TYPE,
23607: p_term_quote_number IN okl_lines_interface.termination_quote_number%TYPE,
23608: x_term_quote_id OUT NOCOPY okl_lines_interface.termination_quote_id%TYPE
23609: ) IS
23610:
23611: l_proc_name VARCHAR2(35) := 'VALIDATE_TERM_QUOTE';
23612: l_quote_id NUMBER;

Line 23690: p_line_type IN okl_lines_interface.line_type%TYPE,

23686: x_msg_count OUT NOCOPY NUMBER,
23687: x_msg_data OUT NOCOPY VARCHAR2,
23688: p_contract_id IN okc_k_headers_b.id%TYPE,
23689: p_line_id IN okc_k_lines_b.id%TYPE,
23690: p_line_type IN okl_lines_interface.line_type%TYPE,
23691: p_pth_start_date IN okl_party_payment_hdr.passthru_start_date%TYPE,
23692: p_pth_base_payout_basis IN okl_party_payment_hdr.payout_basis%TYPE,
23693: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
23694: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,

Line 23693: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,

23689: p_line_id IN okc_k_lines_b.id%TYPE,
23690: p_line_type IN okl_lines_interface.line_type%TYPE,
23691: p_pth_start_date IN okl_party_payment_hdr.passthru_start_date%TYPE,
23692: p_pth_base_payout_basis IN okl_party_payment_hdr.payout_basis%TYPE,
23693: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
23694: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
23695: p_pth_evg_payout_basis IN okl_party_payment_hdr.payout_basis%TYPE,
23696: p_pth_payout_basis_formula IN okl_party_payment_hdr.payout_basis_formula%TYPE,
23697: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,

Line 23694: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,

23690: p_line_type IN okl_lines_interface.line_type%TYPE,
23691: p_pth_start_date IN okl_party_payment_hdr.passthru_start_date%TYPE,
23692: p_pth_base_payout_basis IN okl_party_payment_hdr.payout_basis%TYPE,
23693: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
23694: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
23695: p_pth_evg_payout_basis IN okl_party_payment_hdr.payout_basis%TYPE,
23696: p_pth_payout_basis_formula IN okl_party_payment_hdr.payout_basis_formula%TYPE,
23697: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
23698: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,

Line 23697: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,

23693: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
23694: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
23695: p_pth_evg_payout_basis IN okl_party_payment_hdr.payout_basis%TYPE,
23696: p_pth_payout_basis_formula IN okl_party_payment_hdr.payout_basis_formula%TYPE,
23697: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
23698: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
23699: x_party_pmnt_hdr_tbl OUT NOCOPY okl_party_payments_pvt.pphv_tbl_type
23700: ) IS
23701:

Line 23698: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,

23694: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
23695: p_pth_evg_payout_basis IN okl_party_payment_hdr.payout_basis%TYPE,
23696: p_pth_payout_basis_formula IN okl_party_payment_hdr.payout_basis_formula%TYPE,
23697: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
23698: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
23699: x_party_pmnt_hdr_tbl OUT NOCOPY okl_party_payments_pvt.pphv_tbl_type
23700: ) IS
23701:
23702: l_proc_name VARCHAR2(35) := 'CREATE_PARTY_PAYMENT_HDR';

Line 23933: p_line_number IN okl_lines_interface.line_number%TYPE,

23929: x_msg_count OUT NOCOPY NUMBER,
23930: x_msg_data OUT NOCOPY VARCHAR2,
23931: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
23932: p_chr_id IN okc_k_headers_v.id%TYPE,
23933: p_line_number IN okl_lines_interface.line_number%TYPE,
23934: p_line_type IN okl_lines_interface.line_type%TYPE,
23935: p_line_type_prev IN okl_lines_interface.line_type%TYPE,
23936: p_inv_item_id IN okl_lines_interface.inventory_item_id%TYPE,
23937: p_inv_org_id IN okl_header_interface.inventory_organization_id%TYPE,

Line 23934: p_line_type IN okl_lines_interface.line_type%TYPE,

23930: x_msg_data OUT NOCOPY VARCHAR2,
23931: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
23932: p_chr_id IN okc_k_headers_v.id%TYPE,
23933: p_line_number IN okl_lines_interface.line_number%TYPE,
23934: p_line_type IN okl_lines_interface.line_type%TYPE,
23935: p_line_type_prev IN okl_lines_interface.line_type%TYPE,
23936: p_inv_item_id IN okl_lines_interface.inventory_item_id%TYPE,
23937: p_inv_org_id IN okl_header_interface.inventory_organization_id%TYPE,
23938: p_line_amount IN okl_lines_interface.amount%TYPE,

Line 23935: p_line_type_prev IN okl_lines_interface.line_type%TYPE,

23931: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
23932: p_chr_id IN okc_k_headers_v.id%TYPE,
23933: p_line_number IN okl_lines_interface.line_number%TYPE,
23934: p_line_type IN okl_lines_interface.line_type%TYPE,
23935: p_line_type_prev IN okl_lines_interface.line_type%TYPE,
23936: p_inv_item_id IN okl_lines_interface.inventory_item_id%TYPE,
23937: p_inv_org_id IN okl_header_interface.inventory_organization_id%TYPE,
23938: p_line_amount IN okl_lines_interface.amount%TYPE,
23939: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,

Line 23936: p_inv_item_id IN okl_lines_interface.inventory_item_id%TYPE,

23932: p_chr_id IN okc_k_headers_v.id%TYPE,
23933: p_line_number IN okl_lines_interface.line_number%TYPE,
23934: p_line_type IN okl_lines_interface.line_type%TYPE,
23935: p_line_type_prev IN okl_lines_interface.line_type%TYPE,
23936: p_inv_item_id IN okl_lines_interface.inventory_item_id%TYPE,
23937: p_inv_org_id IN okl_header_interface.inventory_organization_id%TYPE,
23938: p_line_amount IN okl_lines_interface.amount%TYPE,
23939: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,
23940: p_init_direct_cost IN okl_lines_interface.initial_direct_cost%TYPE,

Line 23938: p_line_amount IN okl_lines_interface.amount%TYPE,

23934: p_line_type IN okl_lines_interface.line_type%TYPE,
23935: p_line_type_prev IN okl_lines_interface.line_type%TYPE,
23936: p_inv_item_id IN okl_lines_interface.inventory_item_id%TYPE,
23937: p_inv_org_id IN okl_header_interface.inventory_organization_id%TYPE,
23938: p_line_amount IN okl_lines_interface.amount%TYPE,
23939: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,
23940: p_init_direct_cost IN okl_lines_interface.initial_direct_cost%TYPE,
23941: p_fee_code IN okl_lines_interface.fee_code%TYPE,
23942: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,

Line 23939: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,

23935: p_line_type_prev IN okl_lines_interface.line_type%TYPE,
23936: p_inv_item_id IN okl_lines_interface.inventory_item_id%TYPE,
23937: p_inv_org_id IN okl_header_interface.inventory_organization_id%TYPE,
23938: p_line_amount IN okl_lines_interface.amount%TYPE,
23939: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,
23940: p_init_direct_cost IN okl_lines_interface.initial_direct_cost%TYPE,
23941: p_fee_code IN okl_lines_interface.fee_code%TYPE,
23942: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
23943: p_fee_type IN okl_lines_interface.fee_type%TYPE,

Line 23940: p_init_direct_cost IN okl_lines_interface.initial_direct_cost%TYPE,

23936: p_inv_item_id IN okl_lines_interface.inventory_item_id%TYPE,
23937: p_inv_org_id IN okl_header_interface.inventory_organization_id%TYPE,
23938: p_line_amount IN okl_lines_interface.amount%TYPE,
23939: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,
23940: p_init_direct_cost IN okl_lines_interface.initial_direct_cost%TYPE,
23941: p_fee_code IN okl_lines_interface.fee_code%TYPE,
23942: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
23943: p_fee_type IN okl_lines_interface.fee_type%TYPE,
23944: p_asset_number IN okl_lines_interface.asset_number%TYPE,

Line 23941: p_fee_code IN okl_lines_interface.fee_code%TYPE,

23937: p_inv_org_id IN okl_header_interface.inventory_organization_id%TYPE,
23938: p_line_amount IN okl_lines_interface.amount%TYPE,
23939: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,
23940: p_init_direct_cost IN okl_lines_interface.initial_direct_cost%TYPE,
23941: p_fee_code IN okl_lines_interface.fee_code%TYPE,
23942: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
23943: p_fee_type IN okl_lines_interface.fee_type%TYPE,
23944: p_asset_number IN okl_lines_interface.asset_number%TYPE,
23945: p_currency_code IN okl_lines_interface.currency_code%TYPE,

Line 23942: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,

23938: p_line_amount IN okl_lines_interface.amount%TYPE,
23939: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,
23940: p_init_direct_cost IN okl_lines_interface.initial_direct_cost%TYPE,
23941: p_fee_code IN okl_lines_interface.fee_code%TYPE,
23942: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
23943: p_fee_type IN okl_lines_interface.fee_type%TYPE,
23944: p_asset_number IN okl_lines_interface.asset_number%TYPE,
23945: p_currency_code IN okl_lines_interface.currency_code%TYPE,
23946: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,

Line 23943: p_fee_type IN okl_lines_interface.fee_type%TYPE,

23939: p_link_asset_amount IN okl_lines_interface.link_asset_amount%TYPE,
23940: p_init_direct_cost IN okl_lines_interface.initial_direct_cost%TYPE,
23941: p_fee_code IN okl_lines_interface.fee_code%TYPE,
23942: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
23943: p_fee_type IN okl_lines_interface.fee_type%TYPE,
23944: p_asset_number IN okl_lines_interface.asset_number%TYPE,
23945: p_currency_code IN okl_lines_interface.currency_code%TYPE,
23946: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,
23947: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,

Line 23944: p_asset_number IN okl_lines_interface.asset_number%TYPE,

23940: p_init_direct_cost IN okl_lines_interface.initial_direct_cost%TYPE,
23941: p_fee_code IN okl_lines_interface.fee_code%TYPE,
23942: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
23943: p_fee_type IN okl_lines_interface.fee_type%TYPE,
23944: p_asset_number IN okl_lines_interface.asset_number%TYPE,
23945: p_currency_code IN okl_lines_interface.currency_code%TYPE,
23946: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,
23947: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,
23948: p_header_start_date IN DATE,

Line 23945: p_currency_code IN okl_lines_interface.currency_code%TYPE,

23941: p_fee_code IN okl_lines_interface.fee_code%TYPE,
23942: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
23943: p_fee_type IN okl_lines_interface.fee_type%TYPE,
23944: p_asset_number IN okl_lines_interface.asset_number%TYPE,
23945: p_currency_code IN okl_lines_interface.currency_code%TYPE,
23946: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,
23947: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,
23948: p_header_start_date IN DATE,
23949: p_header_end_date IN DATE,

Line 23946: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,

23942: p_stream_purpose IN okl_lines_interface.stream_purpose_code%TYPE,
23943: p_fee_type IN okl_lines_interface.fee_type%TYPE,
23944: p_asset_number IN okl_lines_interface.asset_number%TYPE,
23945: p_currency_code IN okl_lines_interface.currency_code%TYPE,
23946: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,
23947: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,
23948: p_header_start_date IN DATE,
23949: p_header_end_date IN DATE,
23950: p_line_start_date IN DATE,

Line 23947: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,

23943: p_fee_type IN okl_lines_interface.fee_type%TYPE,
23944: p_asset_number IN okl_lines_interface.asset_number%TYPE,
23945: p_currency_code IN okl_lines_interface.currency_code%TYPE,
23946: p_usage_item_name IN okl_lines_interface.usage_item_name%TYPE,
23947: p_usage_item_id IN okl_lines_interface.usage_item_id%TYPE,
23948: p_header_start_date IN DATE,
23949: p_header_end_date IN DATE,
23950: p_line_start_date IN DATE,
23951: p_line_end_date IN DATE,

Line 23952: p_inv_item_id_prev IN okl_lines_interface.inventory_item_id%TYPE,

23948: p_header_start_date IN DATE,
23949: p_header_end_date IN DATE,
23950: p_line_start_date IN DATE,
23951: p_line_end_date IN DATE,
23952: p_inv_item_id_prev IN okl_lines_interface.inventory_item_id%TYPE,
23953: p_term_quote_id IN OKL_LINES_INTERFACE.TERMINATION_QUOTE_ID%TYPE,
23954: p_term_quote_number IN OKL_LINES_INTERFACE.TERMINATION_QUOTE_NUMBER%TYPE,
23955: x_inv_item_id_prev OUT NOCOPY okl_lines_interface.inventory_item_id%TYPE,
23956: p_cle_id IN okl_k_lines_v.id%TYPE,

Line 23953: p_term_quote_id IN OKL_LINES_INTERFACE.TERMINATION_QUOTE_ID%TYPE,

23949: p_header_end_date IN DATE,
23950: p_line_start_date IN DATE,
23951: p_line_end_date IN DATE,
23952: p_inv_item_id_prev IN okl_lines_interface.inventory_item_id%TYPE,
23953: p_term_quote_id IN OKL_LINES_INTERFACE.TERMINATION_QUOTE_ID%TYPE,
23954: p_term_quote_number IN OKL_LINES_INTERFACE.TERMINATION_QUOTE_NUMBER%TYPE,
23955: x_inv_item_id_prev OUT NOCOPY okl_lines_interface.inventory_item_id%TYPE,
23956: p_cle_id IN okl_k_lines_v.id%TYPE,
23957: x_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE,

Line 23954: p_term_quote_number IN OKL_LINES_INTERFACE.TERMINATION_QUOTE_NUMBER%TYPE,

23950: p_line_start_date IN DATE,
23951: p_line_end_date IN DATE,
23952: p_inv_item_id_prev IN okl_lines_interface.inventory_item_id%TYPE,
23953: p_term_quote_id IN OKL_LINES_INTERFACE.TERMINATION_QUOTE_ID%TYPE,
23954: p_term_quote_number IN OKL_LINES_INTERFACE.TERMINATION_QUOTE_NUMBER%TYPE,
23955: x_inv_item_id_prev OUT NOCOPY okl_lines_interface.inventory_item_id%TYPE,
23956: p_cle_id IN okl_k_lines_v.id%TYPE,
23957: x_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE,
23958: x_sub_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE, -- Bug# 3110115

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

23951: p_line_end_date IN DATE,
23952: p_inv_item_id_prev IN okl_lines_interface.inventory_item_id%TYPE,
23953: p_term_quote_id IN OKL_LINES_INTERFACE.TERMINATION_QUOTE_ID%TYPE,
23954: p_term_quote_number IN OKL_LINES_INTERFACE.TERMINATION_QUOTE_NUMBER%TYPE,
23955: x_inv_item_id_prev OUT NOCOPY okl_lines_interface.inventory_item_id%TYPE,
23956: p_cle_id IN okl_k_lines_v.id%TYPE,
23957: x_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE,
23958: x_sub_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE, -- Bug# 3110115
23959: p_new_line_flag IN okl_lines_interface.explicit_new_line_flag%TYPE,

Line 23959: p_new_line_flag IN okl_lines_interface.explicit_new_line_flag%TYPE,

23955: x_inv_item_id_prev OUT NOCOPY okl_lines_interface.inventory_item_id%TYPE,
23956: p_cle_id IN okl_k_lines_v.id%TYPE,
23957: x_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE,
23958: x_sub_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE, -- Bug# 3110115
23959: p_new_line_flag IN okl_lines_interface.explicit_new_line_flag%TYPE,
23960: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
23961: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
23962: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
23963: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,

Line 23960: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,

23956: p_cle_id IN okl_k_lines_v.id%TYPE,
23957: x_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE,
23958: x_sub_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE, -- Bug# 3110115
23959: p_new_line_flag IN okl_lines_interface.explicit_new_line_flag%TYPE,
23960: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
23961: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
23962: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
23963: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,
23964: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,

Line 23961: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,

23957: x_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE,
23958: x_sub_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE, -- Bug# 3110115
23959: p_new_line_flag IN okl_lines_interface.explicit_new_line_flag%TYPE,
23960: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
23961: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
23962: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
23963: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,
23964: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,
23965: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,

Line 23962: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,

23958: x_sub_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE, -- Bug# 3110115
23959: p_new_line_flag IN okl_lines_interface.explicit_new_line_flag%TYPE,
23960: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
23961: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
23962: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
23963: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,
23964: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,
23965: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,
23966: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,

Line 23963: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,

23959: p_new_line_flag IN okl_lines_interface.explicit_new_line_flag%TYPE,
23960: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
23961: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
23962: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
23963: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,
23964: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,
23965: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,
23966: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
23967: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,

Line 23964: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,

23960: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
23961: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
23962: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
23963: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,
23964: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,
23965: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,
23966: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
23967: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
23968: p_fee_purpose_code IN okl_lines_interface.fee_purpose_code%TYPE

Line 23965: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,

23961: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
23962: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
23963: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,
23964: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,
23965: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,
23966: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
23967: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
23968: p_fee_purpose_code IN okl_lines_interface.fee_purpose_code%TYPE
23969: ) IS

Line 23966: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,

23962: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
23963: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,
23964: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,
23965: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,
23966: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
23967: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
23968: p_fee_purpose_code IN okl_lines_interface.fee_purpose_code%TYPE
23969: ) IS
23970: l_proc_name VARCHAR2(35) := 'PROCESS_OTHER_LINE';

Line 23967: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,

23963: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,
23964: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,
23965: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,
23966: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
23967: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
23968: p_fee_purpose_code IN okl_lines_interface.fee_purpose_code%TYPE
23969: ) IS
23970: l_proc_name VARCHAR2(35) := 'PROCESS_OTHER_LINE';
23971: x_lse_id okc_line_styles_v.id%TYPE;

Line 23968: p_fee_purpose_code IN okl_lines_interface.fee_purpose_code%TYPE

23964: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,
23965: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,
23966: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
23967: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
23968: p_fee_purpose_code IN okl_lines_interface.fee_purpose_code%TYPE
23969: ) IS
23970: l_proc_name VARCHAR2(35) := 'PROCESS_OTHER_LINE';
23971: x_lse_id okc_line_styles_v.id%TYPE;
23972: x_inv_org_id NUMBER;

Line 24003: p_line_number OKL_LINES_INTERFACE.LINE_NUMBER%TYPE) IS

23999:
24000: x_term_quote_id NUMBER;
24001:
24002: CURSOR fee_vendor_csr (p_contract_number OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,
24003: p_line_number OKL_LINES_INTERFACE.LINE_NUMBER%TYPE) IS
24004: SELECT fees_vendor_name,
24005: fees_vendor_id
24006: FROM okl_party_roles_interface
24007: WHERE contract_number_old = p_contract_number

Line 25814: p_line_number IN OKL_LINES_INTERFACE.LINE_NUMBER%TYPE,

25810: x_return_status OUT NOCOPY VARCHAR2,
25811: x_msg_count OUT NOCOPY VARCHAR2,
25812: x_msg_data OUT NOCOPY VARCHAR2,
25813: p_contract_number IN OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,
25814: p_line_number IN OKL_LINES_INTERFACE.LINE_NUMBER%TYPE,
25815: x_payment_level OUT NOCOPY VARCHAR2
25816: ) IS
25817:
25818: l_proc_name VARCHAR2(35) := 'CHECK_PAYMENT_LEVEL';

Line 25821: p_line OKL_LINES_INTERFACE.LINE_NUMBER%TYPE) IS

25817:
25818: l_proc_name VARCHAR2(35) := 'CHECK_PAYMENT_LEVEL';
25819:
25820: CURSOR line_csr (p_cont_number OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,
25821: p_line OKL_LINES_INTERFACE.LINE_NUMBER%TYPE) IS
25822: SELECT line_type,
25823: asset_number
25824: FROM okl_lines_interface
25825: WHERE contract_number_old = p_cont_number

Line 25824: FROM okl_lines_interface

25820: CURSOR line_csr (p_cont_number OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,
25821: p_line OKL_LINES_INTERFACE.LINE_NUMBER%TYPE) IS
25822: SELECT line_type,
25823: asset_number
25824: FROM okl_lines_interface
25825: WHERE contract_number_old = p_cont_number
25826: AND line_number = p_line;
25827:
25828: l_line_type OKL_LINES_INTERFACE.LINE_TYPE%TYPE;

Line 25828: l_line_type OKL_LINES_INTERFACE.LINE_TYPE%TYPE;

25824: FROM okl_lines_interface
25825: WHERE contract_number_old = p_cont_number
25826: AND line_number = p_line;
25827:
25828: l_line_type OKL_LINES_INTERFACE.LINE_TYPE%TYPE;
25829: l_asset_number OKL_LINES_INTERFACE.ASSET_NUMBER%TYPE;
25830:
25831: BEGIN
25832: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 25829: l_asset_number OKL_LINES_INTERFACE.ASSET_NUMBER%TYPE;

25825: WHERE contract_number_old = p_cont_number
25826: AND line_number = p_line;
25827:
25828: l_line_type OKL_LINES_INTERFACE.LINE_TYPE%TYPE;
25829: l_asset_number OKL_LINES_INTERFACE.ASSET_NUMBER%TYPE;
25830:
25831: BEGIN
25832: x_return_status := OKL_API.G_RET_STS_SUCCESS;
25833: debug_message(l_proc_name);

Line 26198: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,

26194: p_contract_number IN VARCHAR2,
26195: p_asset_number IN VARCHAR2,
26196: p_asset_id IN OKL_LA_RELEASE_ASSETS_UV.ASSET_ID%TYPE,
26197: p_line_number IN NUMBER,
26198: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
26199: p_install_site_num IN okl_lines_interface.install_site_number%TYPE,
26200: p_unit_price IN okl_lines_interface.original_cost%TYPE,
26201: p_deprn_method IN okl_lines_interface.depreciation_method_code%TYPE,
26202: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,

Line 26199: p_install_site_num IN okl_lines_interface.install_site_number%TYPE,

26195: p_asset_number IN VARCHAR2,
26196: p_asset_id IN OKL_LA_RELEASE_ASSETS_UV.ASSET_ID%TYPE,
26197: p_line_number IN NUMBER,
26198: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
26199: p_install_site_num IN okl_lines_interface.install_site_number%TYPE,
26200: p_unit_price IN okl_lines_interface.original_cost%TYPE,
26201: p_deprn_method IN okl_lines_interface.depreciation_method_code%TYPE,
26202: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,
26203: p_deprn_rate IN okl_lines_interface.depreciation_rate%TYPE,

Line 26200: p_unit_price IN okl_lines_interface.original_cost%TYPE,

26196: p_asset_id IN OKL_LA_RELEASE_ASSETS_UV.ASSET_ID%TYPE,
26197: p_line_number IN NUMBER,
26198: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
26199: p_install_site_num IN okl_lines_interface.install_site_number%TYPE,
26200: p_unit_price IN okl_lines_interface.original_cost%TYPE,
26201: p_deprn_method IN okl_lines_interface.depreciation_method_code%TYPE,
26202: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,
26203: p_deprn_rate IN okl_lines_interface.depreciation_rate%TYPE,
26204: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,

Line 26201: p_deprn_method IN okl_lines_interface.depreciation_method_code%TYPE,

26197: p_line_number IN NUMBER,
26198: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
26199: p_install_site_num IN okl_lines_interface.install_site_number%TYPE,
26200: p_unit_price IN okl_lines_interface.original_cost%TYPE,
26201: p_deprn_method IN okl_lines_interface.depreciation_method_code%TYPE,
26202: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,
26203: p_deprn_rate IN okl_lines_interface.depreciation_rate%TYPE,
26204: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,
26205: p_asset_loc_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,

Line 26202: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,

26198: p_install_site_id IN okl_lines_interface.install_site_id%TYPE,
26199: p_install_site_num IN okl_lines_interface.install_site_number%TYPE,
26200: p_unit_price IN okl_lines_interface.original_cost%TYPE,
26201: p_deprn_method IN okl_lines_interface.depreciation_method_code%TYPE,
26202: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,
26203: p_deprn_rate IN okl_lines_interface.depreciation_rate%TYPE,
26204: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,
26205: p_asset_loc_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,
26206: p_asset_loc_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,

Line 26203: p_deprn_rate IN okl_lines_interface.depreciation_rate%TYPE,

26199: p_install_site_num IN okl_lines_interface.install_site_number%TYPE,
26200: p_unit_price IN okl_lines_interface.original_cost%TYPE,
26201: p_deprn_method IN okl_lines_interface.depreciation_method_code%TYPE,
26202: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,
26203: p_deprn_rate IN okl_lines_interface.depreciation_rate%TYPE,
26204: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,
26205: p_asset_loc_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,
26206: p_asset_loc_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,
26207: p_asset_loc_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,

Line 26204: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,

26200: p_unit_price IN okl_lines_interface.original_cost%TYPE,
26201: p_deprn_method IN okl_lines_interface.depreciation_method_code%TYPE,
26202: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,
26203: p_deprn_rate IN okl_lines_interface.depreciation_rate%TYPE,
26204: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,
26205: p_asset_loc_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,
26206: p_asset_loc_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,
26207: p_asset_loc_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,
26208: p_asset_loc_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,

Line 26205: p_asset_loc_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,

26201: p_deprn_method IN okl_lines_interface.depreciation_method_code%TYPE,
26202: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,
26203: p_deprn_rate IN okl_lines_interface.depreciation_rate%TYPE,
26204: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,
26205: p_asset_loc_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,
26206: p_asset_loc_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,
26207: p_asset_loc_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,
26208: p_asset_loc_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,
26209: p_asset_loc_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,

Line 26206: p_asset_loc_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,

26202: p_life_in_months IN okl_lines_interface.life_in_months%TYPE,
26203: p_deprn_rate IN okl_lines_interface.depreciation_rate%TYPE,
26204: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,
26205: p_asset_loc_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,
26206: p_asset_loc_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,
26207: p_asset_loc_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,
26208: p_asset_loc_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,
26209: p_asset_loc_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,
26210: p_asset_loc_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,

Line 26207: p_asset_loc_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,

26203: p_deprn_rate IN okl_lines_interface.depreciation_rate%TYPE,
26204: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,
26205: p_asset_loc_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,
26206: p_asset_loc_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,
26207: p_asset_loc_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,
26208: p_asset_loc_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,
26209: p_asset_loc_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,
26210: p_asset_loc_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
26211: p_asset_loc_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,

Line 26208: p_asset_loc_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,

26204: p_asset_location_id IN okl_lines_interface.asset_location_id%TYPE,
26205: p_asset_loc_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,
26206: p_asset_loc_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,
26207: p_asset_loc_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,
26208: p_asset_loc_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,
26209: p_asset_loc_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,
26210: p_asset_loc_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
26211: p_asset_loc_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
26212: p_salvage_value IN okl_lines_interface.salvage_value%TYPE,

Line 26209: p_asset_loc_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,

26205: p_asset_loc_segment1 IN okl_lines_interface.asset_location_segment1%TYPE,
26206: p_asset_loc_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,
26207: p_asset_loc_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,
26208: p_asset_loc_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,
26209: p_asset_loc_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,
26210: p_asset_loc_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
26211: p_asset_loc_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
26212: p_salvage_value IN okl_lines_interface.salvage_value%TYPE,
26213: p_salvage_ptg IN okl_lines_interface.salvage_value_percent%TYPE,

Line 26210: p_asset_loc_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,

26206: p_asset_loc_segment2 IN okl_lines_interface.asset_location_segment2%TYPE,
26207: p_asset_loc_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,
26208: p_asset_loc_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,
26209: p_asset_loc_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,
26210: p_asset_loc_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
26211: p_asset_loc_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
26212: p_salvage_value IN okl_lines_interface.salvage_value%TYPE,
26213: p_salvage_ptg IN okl_lines_interface.salvage_value_percent%TYPE,
26214: p_residual_grnty_amt IN okl_lines_interface.residual_amount_guarantee%TYPE,

Line 26211: p_asset_loc_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,

26207: p_asset_loc_segment3 IN okl_lines_interface.asset_location_segment3%TYPE,
26208: p_asset_loc_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,
26209: p_asset_loc_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,
26210: p_asset_loc_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
26211: p_asset_loc_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
26212: p_salvage_value IN okl_lines_interface.salvage_value%TYPE,
26213: p_salvage_ptg IN okl_lines_interface.salvage_value_percent%TYPE,
26214: p_residual_grnty_amt IN okl_lines_interface.residual_amount_guarantee%TYPE,
26215: p_residual_code IN okl_lines_interface.guarantor_type_code%TYPE,

Line 26212: p_salvage_value IN okl_lines_interface.salvage_value%TYPE,

26208: p_asset_loc_segment4 IN okl_lines_interface.asset_location_segment4%TYPE,
26209: p_asset_loc_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,
26210: p_asset_loc_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
26211: p_asset_loc_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
26212: p_salvage_value IN okl_lines_interface.salvage_value%TYPE,
26213: p_salvage_ptg IN okl_lines_interface.salvage_value_percent%TYPE,
26214: p_residual_grnty_amt IN okl_lines_interface.residual_amount_guarantee%TYPE,
26215: p_residual_code IN okl_lines_interface.guarantor_type_code%TYPE,
26216: p_residual_ptg IN okl_lines_interface.residual_percent%TYPE,

Line 26213: p_salvage_ptg IN okl_lines_interface.salvage_value_percent%TYPE,

26209: p_asset_loc_segment5 IN okl_lines_interface.asset_location_segment5%TYPE,
26210: p_asset_loc_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
26211: p_asset_loc_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
26212: p_salvage_value IN okl_lines_interface.salvage_value%TYPE,
26213: p_salvage_ptg IN okl_lines_interface.salvage_value_percent%TYPE,
26214: p_residual_grnty_amt IN okl_lines_interface.residual_amount_guarantee%TYPE,
26215: p_residual_code IN okl_lines_interface.guarantor_type_code%TYPE,
26216: p_residual_ptg IN okl_lines_interface.residual_percent%TYPE,
26217: p_residual_amt IN okl_lines_interface.residual_amount%TYPE,

Line 26214: p_residual_grnty_amt IN okl_lines_interface.residual_amount_guarantee%TYPE,

26210: p_asset_loc_segment6 IN okl_lines_interface.asset_location_segment6%TYPE,
26211: p_asset_loc_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
26212: p_salvage_value IN okl_lines_interface.salvage_value%TYPE,
26213: p_salvage_ptg IN okl_lines_interface.salvage_value_percent%TYPE,
26214: p_residual_grnty_amt IN okl_lines_interface.residual_amount_guarantee%TYPE,
26215: p_residual_code IN okl_lines_interface.guarantor_type_code%TYPE,
26216: p_residual_ptg IN okl_lines_interface.residual_percent%TYPE,
26217: p_residual_amt IN okl_lines_interface.residual_amount%TYPE,
26218: p_tax_book IN okl_lines_interface.tax_book%TYPE,

Line 26215: p_residual_code IN okl_lines_interface.guarantor_type_code%TYPE,

26211: p_asset_loc_segment7 IN okl_lines_interface.asset_location_segment7%TYPE,
26212: p_salvage_value IN okl_lines_interface.salvage_value%TYPE,
26213: p_salvage_ptg IN okl_lines_interface.salvage_value_percent%TYPE,
26214: p_residual_grnty_amt IN okl_lines_interface.residual_amount_guarantee%TYPE,
26215: p_residual_code IN okl_lines_interface.guarantor_type_code%TYPE,
26216: p_residual_ptg IN okl_lines_interface.residual_percent%TYPE,
26217: p_residual_amt IN okl_lines_interface.residual_amount%TYPE,
26218: p_tax_book IN okl_lines_interface.tax_book%TYPE,
26219: p_tax_deprn IN okl_lines_interface.deprn_method_tax%TYPE,

Line 26216: p_residual_ptg IN okl_lines_interface.residual_percent%TYPE,

26212: p_salvage_value IN okl_lines_interface.salvage_value%TYPE,
26213: p_salvage_ptg IN okl_lines_interface.salvage_value_percent%TYPE,
26214: p_residual_grnty_amt IN okl_lines_interface.residual_amount_guarantee%TYPE,
26215: p_residual_code IN okl_lines_interface.guarantor_type_code%TYPE,
26216: p_residual_ptg IN okl_lines_interface.residual_percent%TYPE,
26217: p_residual_amt IN okl_lines_interface.residual_amount%TYPE,
26218: p_tax_book IN okl_lines_interface.tax_book%TYPE,
26219: p_tax_deprn IN okl_lines_interface.deprn_method_tax%TYPE,
26220: p_tax_life_in_mnth IN okl_lines_interface.life_in_months_tax%TYPE,

Line 26217: p_residual_amt IN okl_lines_interface.residual_amount%TYPE,

26213: p_salvage_ptg IN okl_lines_interface.salvage_value_percent%TYPE,
26214: p_residual_grnty_amt IN okl_lines_interface.residual_amount_guarantee%TYPE,
26215: p_residual_code IN okl_lines_interface.guarantor_type_code%TYPE,
26216: p_residual_ptg IN okl_lines_interface.residual_percent%TYPE,
26217: p_residual_amt IN okl_lines_interface.residual_amount%TYPE,
26218: p_tax_book IN okl_lines_interface.tax_book%TYPE,
26219: p_tax_deprn IN okl_lines_interface.deprn_method_tax%TYPE,
26220: p_tax_life_in_mnth IN okl_lines_interface.life_in_months_tax%TYPE,
26221: p_tax_deprn_rate IN okl_lines_interface.deprn_rate_tax%TYPE,

Line 26218: p_tax_book IN okl_lines_interface.tax_book%TYPE,

26214: p_residual_grnty_amt IN okl_lines_interface.residual_amount_guarantee%TYPE,
26215: p_residual_code IN okl_lines_interface.guarantor_type_code%TYPE,
26216: p_residual_ptg IN okl_lines_interface.residual_percent%TYPE,
26217: p_residual_amt IN okl_lines_interface.residual_amount%TYPE,
26218: p_tax_book IN okl_lines_interface.tax_book%TYPE,
26219: p_tax_deprn IN okl_lines_interface.deprn_method_tax%TYPE,
26220: p_tax_life_in_mnth IN okl_lines_interface.life_in_months_tax%TYPE,
26221: p_tax_deprn_rate IN okl_lines_interface.deprn_rate_tax%TYPE,
26222: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,

Line 26219: p_tax_deprn IN okl_lines_interface.deprn_method_tax%TYPE,

26215: p_residual_code IN okl_lines_interface.guarantor_type_code%TYPE,
26216: p_residual_ptg IN okl_lines_interface.residual_percent%TYPE,
26217: p_residual_amt IN okl_lines_interface.residual_amount%TYPE,
26218: p_tax_book IN okl_lines_interface.tax_book%TYPE,
26219: p_tax_deprn IN okl_lines_interface.deprn_method_tax%TYPE,
26220: p_tax_life_in_mnth IN okl_lines_interface.life_in_months_tax%TYPE,
26221: p_tax_deprn_rate IN okl_lines_interface.deprn_rate_tax%TYPE,
26222: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
26223: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,

Line 26220: p_tax_life_in_mnth IN okl_lines_interface.life_in_months_tax%TYPE,

26216: p_residual_ptg IN okl_lines_interface.residual_percent%TYPE,
26217: p_residual_amt IN okl_lines_interface.residual_amount%TYPE,
26218: p_tax_book IN okl_lines_interface.tax_book%TYPE,
26219: p_tax_deprn IN okl_lines_interface.deprn_method_tax%TYPE,
26220: p_tax_life_in_mnth IN okl_lines_interface.life_in_months_tax%TYPE,
26221: p_tax_deprn_rate IN okl_lines_interface.deprn_rate_tax%TYPE,
26222: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
26223: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
26224: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,

Line 26221: p_tax_deprn_rate IN okl_lines_interface.deprn_rate_tax%TYPE,

26217: p_residual_amt IN okl_lines_interface.residual_amount%TYPE,
26218: p_tax_book IN okl_lines_interface.tax_book%TYPE,
26219: p_tax_deprn IN okl_lines_interface.deprn_method_tax%TYPE,
26220: p_tax_life_in_mnth IN okl_lines_interface.life_in_months_tax%TYPE,
26221: p_tax_deprn_rate IN okl_lines_interface.deprn_rate_tax%TYPE,
26222: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
26223: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
26224: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
26225: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,

Line 26222: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,

26218: p_tax_book IN okl_lines_interface.tax_book%TYPE,
26219: p_tax_deprn IN okl_lines_interface.deprn_method_tax%TYPE,
26220: p_tax_life_in_mnth IN okl_lines_interface.life_in_months_tax%TYPE,
26221: p_tax_deprn_rate IN okl_lines_interface.deprn_rate_tax%TYPE,
26222: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
26223: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
26224: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
26225: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,
26226: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,

Line 26223: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,

26219: p_tax_deprn IN okl_lines_interface.deprn_method_tax%TYPE,
26220: p_tax_life_in_mnth IN okl_lines_interface.life_in_months_tax%TYPE,
26221: p_tax_deprn_rate IN okl_lines_interface.deprn_rate_tax%TYPE,
26222: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
26223: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
26224: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
26225: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,
26226: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,
26227: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,

Line 26224: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,

26220: p_tax_life_in_mnth IN okl_lines_interface.life_in_months_tax%TYPE,
26221: p_tax_deprn_rate IN okl_lines_interface.deprn_rate_tax%TYPE,
26222: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
26223: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
26224: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
26225: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,
26226: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,
26227: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,
26228: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,

Line 26225: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,

26221: p_tax_deprn_rate IN okl_lines_interface.deprn_rate_tax%TYPE,
26222: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
26223: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
26224: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
26225: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,
26226: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,
26227: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,
26228: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
26229: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,

Line 26226: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,

26222: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
26223: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
26224: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
26225: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,
26226: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,
26227: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,
26228: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
26229: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
26230: p_attribute_category IN okl_lines_interface.attribute_category%TYPE,

Line 26227: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,

26223: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
26224: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
26225: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,
26226: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,
26227: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,
26228: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
26229: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
26230: p_attribute_category IN okl_lines_interface.attribute_category%TYPE,
26231: p_attribute1 IN okl_lines_interface.attribute1%TYPE,

Line 26228: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,

26224: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,
26225: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,
26226: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,
26227: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,
26228: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
26229: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
26230: p_attribute_category IN okl_lines_interface.attribute_category%TYPE,
26231: p_attribute1 IN okl_lines_interface.attribute1%TYPE,
26232: p_attribute2 IN okl_lines_interface.attribute2%TYPE,

Line 26229: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,

26225: p_pth_start_date IN okl_lines_interface.pth_start_date%TYPE,
26226: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,
26227: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,
26228: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
26229: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
26230: p_attribute_category IN okl_lines_interface.attribute_category%TYPE,
26231: p_attribute1 IN okl_lines_interface.attribute1%TYPE,
26232: p_attribute2 IN okl_lines_interface.attribute2%TYPE,
26233: p_attribute3 IN okl_lines_interface.attribute3%TYPE,

Line 26230: p_attribute_category IN okl_lines_interface.attribute_category%TYPE,

26226: p_pth_evg_payout_basis IN okl_lines_interface.pth_evg_payout_basis%TYPE,
26227: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,
26228: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
26229: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
26230: p_attribute_category IN okl_lines_interface.attribute_category%TYPE,
26231: p_attribute1 IN okl_lines_interface.attribute1%TYPE,
26232: p_attribute2 IN okl_lines_interface.attribute2%TYPE,
26233: p_attribute3 IN okl_lines_interface.attribute3%TYPE,
26234: p_attribute4 IN okl_lines_interface.attribute4%TYPE,

Line 26231: p_attribute1 IN okl_lines_interface.attribute1%TYPE,

26227: p_pth_payout_basis_formula IN okl_lines_interface.pth_payout_basis_formula%TYPE,
26228: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
26229: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
26230: p_attribute_category IN okl_lines_interface.attribute_category%TYPE,
26231: p_attribute1 IN okl_lines_interface.attribute1%TYPE,
26232: p_attribute2 IN okl_lines_interface.attribute2%TYPE,
26233: p_attribute3 IN okl_lines_interface.attribute3%TYPE,
26234: p_attribute4 IN okl_lines_interface.attribute4%TYPE,
26235: p_attribute5 IN okl_lines_interface.attribute5%TYPE,

Line 26232: p_attribute2 IN okl_lines_interface.attribute2%TYPE,

26228: p_pth_evg_stream_code IN okl_lines_interface.pth_evg_stream_code%TYPE,
26229: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
26230: p_attribute_category IN okl_lines_interface.attribute_category%TYPE,
26231: p_attribute1 IN okl_lines_interface.attribute1%TYPE,
26232: p_attribute2 IN okl_lines_interface.attribute2%TYPE,
26233: p_attribute3 IN okl_lines_interface.attribute3%TYPE,
26234: p_attribute4 IN okl_lines_interface.attribute4%TYPE,
26235: p_attribute5 IN okl_lines_interface.attribute5%TYPE,
26236: p_attribute6 IN okl_lines_interface.attribute6%TYPE,

Line 26233: p_attribute3 IN okl_lines_interface.attribute3%TYPE,

26229: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
26230: p_attribute_category IN okl_lines_interface.attribute_category%TYPE,
26231: p_attribute1 IN okl_lines_interface.attribute1%TYPE,
26232: p_attribute2 IN okl_lines_interface.attribute2%TYPE,
26233: p_attribute3 IN okl_lines_interface.attribute3%TYPE,
26234: p_attribute4 IN okl_lines_interface.attribute4%TYPE,
26235: p_attribute5 IN okl_lines_interface.attribute5%TYPE,
26236: p_attribute6 IN okl_lines_interface.attribute6%TYPE,
26237: p_attribute7 IN okl_lines_interface.attribute7%TYPE,

Line 26234: p_attribute4 IN okl_lines_interface.attribute4%TYPE,

26230: p_attribute_category IN okl_lines_interface.attribute_category%TYPE,
26231: p_attribute1 IN okl_lines_interface.attribute1%TYPE,
26232: p_attribute2 IN okl_lines_interface.attribute2%TYPE,
26233: p_attribute3 IN okl_lines_interface.attribute3%TYPE,
26234: p_attribute4 IN okl_lines_interface.attribute4%TYPE,
26235: p_attribute5 IN okl_lines_interface.attribute5%TYPE,
26236: p_attribute6 IN okl_lines_interface.attribute6%TYPE,
26237: p_attribute7 IN okl_lines_interface.attribute7%TYPE,
26238: p_attribute8 IN okl_lines_interface.attribute8%TYPE,

Line 26235: p_attribute5 IN okl_lines_interface.attribute5%TYPE,

26231: p_attribute1 IN okl_lines_interface.attribute1%TYPE,
26232: p_attribute2 IN okl_lines_interface.attribute2%TYPE,
26233: p_attribute3 IN okl_lines_interface.attribute3%TYPE,
26234: p_attribute4 IN okl_lines_interface.attribute4%TYPE,
26235: p_attribute5 IN okl_lines_interface.attribute5%TYPE,
26236: p_attribute6 IN okl_lines_interface.attribute6%TYPE,
26237: p_attribute7 IN okl_lines_interface.attribute7%TYPE,
26238: p_attribute8 IN okl_lines_interface.attribute8%TYPE,
26239: p_attribute9 IN okl_lines_interface.attribute9%TYPE,

Line 26236: p_attribute6 IN okl_lines_interface.attribute6%TYPE,

26232: p_attribute2 IN okl_lines_interface.attribute2%TYPE,
26233: p_attribute3 IN okl_lines_interface.attribute3%TYPE,
26234: p_attribute4 IN okl_lines_interface.attribute4%TYPE,
26235: p_attribute5 IN okl_lines_interface.attribute5%TYPE,
26236: p_attribute6 IN okl_lines_interface.attribute6%TYPE,
26237: p_attribute7 IN okl_lines_interface.attribute7%TYPE,
26238: p_attribute8 IN okl_lines_interface.attribute8%TYPE,
26239: p_attribute9 IN okl_lines_interface.attribute9%TYPE,
26240: p_attribute10 IN okl_lines_interface.attribute10%TYPE,

Line 26237: p_attribute7 IN okl_lines_interface.attribute7%TYPE,

26233: p_attribute3 IN okl_lines_interface.attribute3%TYPE,
26234: p_attribute4 IN okl_lines_interface.attribute4%TYPE,
26235: p_attribute5 IN okl_lines_interface.attribute5%TYPE,
26236: p_attribute6 IN okl_lines_interface.attribute6%TYPE,
26237: p_attribute7 IN okl_lines_interface.attribute7%TYPE,
26238: p_attribute8 IN okl_lines_interface.attribute8%TYPE,
26239: p_attribute9 IN okl_lines_interface.attribute9%TYPE,
26240: p_attribute10 IN okl_lines_interface.attribute10%TYPE,
26241: p_attribute11 IN okl_lines_interface.attribute11%TYPE,

Line 26238: p_attribute8 IN okl_lines_interface.attribute8%TYPE,

26234: p_attribute4 IN okl_lines_interface.attribute4%TYPE,
26235: p_attribute5 IN okl_lines_interface.attribute5%TYPE,
26236: p_attribute6 IN okl_lines_interface.attribute6%TYPE,
26237: p_attribute7 IN okl_lines_interface.attribute7%TYPE,
26238: p_attribute8 IN okl_lines_interface.attribute8%TYPE,
26239: p_attribute9 IN okl_lines_interface.attribute9%TYPE,
26240: p_attribute10 IN okl_lines_interface.attribute10%TYPE,
26241: p_attribute11 IN okl_lines_interface.attribute11%TYPE,
26242: p_attribute12 IN okl_lines_interface.attribute12%TYPE,

Line 26239: p_attribute9 IN okl_lines_interface.attribute9%TYPE,

26235: p_attribute5 IN okl_lines_interface.attribute5%TYPE,
26236: p_attribute6 IN okl_lines_interface.attribute6%TYPE,
26237: p_attribute7 IN okl_lines_interface.attribute7%TYPE,
26238: p_attribute8 IN okl_lines_interface.attribute8%TYPE,
26239: p_attribute9 IN okl_lines_interface.attribute9%TYPE,
26240: p_attribute10 IN okl_lines_interface.attribute10%TYPE,
26241: p_attribute11 IN okl_lines_interface.attribute11%TYPE,
26242: p_attribute12 IN okl_lines_interface.attribute12%TYPE,
26243: p_attribute13 IN okl_lines_interface.attribute13%TYPE,

Line 26240: p_attribute10 IN okl_lines_interface.attribute10%TYPE,

26236: p_attribute6 IN okl_lines_interface.attribute6%TYPE,
26237: p_attribute7 IN okl_lines_interface.attribute7%TYPE,
26238: p_attribute8 IN okl_lines_interface.attribute8%TYPE,
26239: p_attribute9 IN okl_lines_interface.attribute9%TYPE,
26240: p_attribute10 IN okl_lines_interface.attribute10%TYPE,
26241: p_attribute11 IN okl_lines_interface.attribute11%TYPE,
26242: p_attribute12 IN okl_lines_interface.attribute12%TYPE,
26243: p_attribute13 IN okl_lines_interface.attribute13%TYPE,
26244: p_attribute14 IN okl_lines_interface.attribute14%TYPE,

Line 26241: p_attribute11 IN okl_lines_interface.attribute11%TYPE,

26237: p_attribute7 IN okl_lines_interface.attribute7%TYPE,
26238: p_attribute8 IN okl_lines_interface.attribute8%TYPE,
26239: p_attribute9 IN okl_lines_interface.attribute9%TYPE,
26240: p_attribute10 IN okl_lines_interface.attribute10%TYPE,
26241: p_attribute11 IN okl_lines_interface.attribute11%TYPE,
26242: p_attribute12 IN okl_lines_interface.attribute12%TYPE,
26243: p_attribute13 IN okl_lines_interface.attribute13%TYPE,
26244: p_attribute14 IN okl_lines_interface.attribute14%TYPE,
26245: p_attribute15 IN okl_lines_interface.attribute15%TYPE,

Line 26242: p_attribute12 IN okl_lines_interface.attribute12%TYPE,

26238: p_attribute8 IN okl_lines_interface.attribute8%TYPE,
26239: p_attribute9 IN okl_lines_interface.attribute9%TYPE,
26240: p_attribute10 IN okl_lines_interface.attribute10%TYPE,
26241: p_attribute11 IN okl_lines_interface.attribute11%TYPE,
26242: p_attribute12 IN okl_lines_interface.attribute12%TYPE,
26243: p_attribute13 IN okl_lines_interface.attribute13%TYPE,
26244: p_attribute14 IN okl_lines_interface.attribute14%TYPE,
26245: p_attribute15 IN okl_lines_interface.attribute15%TYPE,
26246: x_clev_fin_rec OUT NOCOPY clev_rec_type,

Line 26243: p_attribute13 IN okl_lines_interface.attribute13%TYPE,

26239: p_attribute9 IN okl_lines_interface.attribute9%TYPE,
26240: p_attribute10 IN okl_lines_interface.attribute10%TYPE,
26241: p_attribute11 IN okl_lines_interface.attribute11%TYPE,
26242: p_attribute12 IN okl_lines_interface.attribute12%TYPE,
26243: p_attribute13 IN okl_lines_interface.attribute13%TYPE,
26244: p_attribute14 IN okl_lines_interface.attribute14%TYPE,
26245: p_attribute15 IN okl_lines_interface.attribute15%TYPE,
26246: x_clev_fin_rec OUT NOCOPY clev_rec_type,
26247: x_clev_model_rec OUT NOCOPY clev_rec_type,

Line 26244: p_attribute14 IN okl_lines_interface.attribute14%TYPE,

26240: p_attribute10 IN okl_lines_interface.attribute10%TYPE,
26241: p_attribute11 IN okl_lines_interface.attribute11%TYPE,
26242: p_attribute12 IN okl_lines_interface.attribute12%TYPE,
26243: p_attribute13 IN okl_lines_interface.attribute13%TYPE,
26244: p_attribute14 IN okl_lines_interface.attribute14%TYPE,
26245: p_attribute15 IN okl_lines_interface.attribute15%TYPE,
26246: x_clev_fin_rec OUT NOCOPY clev_rec_type,
26247: x_clev_model_rec OUT NOCOPY clev_rec_type,
26248: x_clev_fa_rec OUT NOCOPY clev_rec_type,

Line 26245: p_attribute15 IN okl_lines_interface.attribute15%TYPE,

26241: p_attribute11 IN okl_lines_interface.attribute11%TYPE,
26242: p_attribute12 IN okl_lines_interface.attribute12%TYPE,
26243: p_attribute13 IN okl_lines_interface.attribute13%TYPE,
26244: p_attribute14 IN okl_lines_interface.attribute14%TYPE,
26245: p_attribute15 IN okl_lines_interface.attribute15%TYPE,
26246: x_clev_fin_rec OUT NOCOPY clev_rec_type,
26247: x_clev_model_rec OUT NOCOPY clev_rec_type,
26248: x_clev_fa_rec OUT NOCOPY clev_rec_type,
26249: x_clev_ib_rec OUT NOCOPY clev_rec_type

Line 26621: FROM okl_lines_interface

26617:
26618: CURSOR addon_csr (p_contract_number VARCHAR2,
26619: p_asset_number VARCHAR2) IS
26620: SELECT *
26621: FROM okl_lines_interface
26622: WHERE line_type = 'ASSET_ADDON'
26623: AND contract_number_old = p_contract_number
26624: AND asset_number = p_asset_number;
26625:

Line 26879: FROM okl_lines_interface

26875:
26876: CURSOR subsidy_csr (p_contract_number VARCHAR2,
26877: p_asset_number VARCHAR2) IS
26878: SELECT *
26879: FROM okl_lines_interface
26880: WHERE line_type = 'ASSET_SUBSIDY'
26881: AND contract_number_old = p_contract_number
26882: AND asset_number = p_asset_number;
26883:

Line 27280: l_line_number_prev okl_lines_interface.line_number%TYPE;

27276: -- l_new_yn VARCHAR2(1);
27277: x_comb_id NUMBER;
27278: x_rgp_id NUMBER;
27279: l_contract_number_old_prev okl_header_interface.contract_number_old%TYPE;
27280: l_line_number_prev okl_lines_interface.line_number%TYPE;
27281: l_asset_number_prev okl_payments_interface.asset_number%TYPE;
27282: l_payment_type_code_prev okl_payments_interface.payment_type_code%TYPE;
27283: l_pmnt_sch_num_prev NUMBER;
27284: l_start_date_prev DATE;

Line 28196: FROM okl_lines_interface

28192: --
28193:
28194: CURSOR okl_line_csr (p_contract_number_old VARCHAR2) IS
28195: SELECT *
28196: FROM okl_lines_interface
28197: WHERE contract_number_old = p_contract_number_old
28198: AND serial_number IS NULL -- indicates TOP line
28199: AND line_type <> 'ASSET_SUBSIDY' -- this line_type is being processed in process_subsidy()
28200: AND line_type <> 'ASSET_ADDON' -- this line_type is being processed in process_addon()

Line 28208: FROM okl_lines_interface

28204:
28205: CURSOR okl_ib_csr (p_contract_number_old VARCHAR2,
28206: p_line_number NUMBER) IS
28207: SELECT serial_number
28208: FROM okl_lines_interface
28209: WHERE contract_number_old = p_contract_number_old
28210: AND serial_number IS NOT NULL
28211: AND line_number = p_line_number;
28212:

Line 31620: from okl_lines_interface b

31616: l_temp_count number := 1;
31617:
31618: cursor c1 is
31619: select b.contract_number_old, count(*)
31620: from okl_lines_interface b
31621: where b.contract_number_old in (
31622: select a.contract_number_old
31623: from okl_header_interface a
31624: where

Line 31855: from okl_lines_interface a

31851: )
31852: AND b.status in ('NEW','ERROR');
31853:
31854: select count(*) into l_line_count
31855: from okl_lines_interface a
31856: where a.contract_number_old in (
31857: select b.contract_number_old
31858: from okl_header_interface b
31859: where (