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.PN_RECOVERY_EXTRACT_PKG dependencies on PN_REC_EXP_LINE

Line 1625: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,

1621: -- 02-JUL-03 ftanudja o added constraint p_extr code <> null
1622: ------------------------------------------------------------------------------+
1623:
1624: FUNCTION check_dates(
1625: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
1626: p_from_date pn_rec_exp_line.from_date%TYPE,
1627: p_to_date pn_rec_exp_line.to_date%TYPE,
1628: p_property_id pn_rec_exp_line.property_id%TYPE,
1629: p_location_id pn_rec_exp_line.location_id%TYPE,

Line 1626: p_from_date pn_rec_exp_line.from_date%TYPE,

1622: ------------------------------------------------------------------------------+
1623:
1624: FUNCTION check_dates(
1625: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
1626: p_from_date pn_rec_exp_line.from_date%TYPE,
1627: p_to_date pn_rec_exp_line.to_date%TYPE,
1628: p_property_id pn_rec_exp_line.property_id%TYPE,
1629: p_location_id pn_rec_exp_line.location_id%TYPE,
1630: p_extract_code pn_rec_exp_line.expense_extract_code%TYPE

Line 1627: p_to_date pn_rec_exp_line.to_date%TYPE,

1623:
1624: FUNCTION check_dates(
1625: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
1626: p_from_date pn_rec_exp_line.from_date%TYPE,
1627: p_to_date pn_rec_exp_line.to_date%TYPE,
1628: p_property_id pn_rec_exp_line.property_id%TYPE,
1629: p_location_id pn_rec_exp_line.location_id%TYPE,
1630: p_extract_code pn_rec_exp_line.expense_extract_code%TYPE
1631: ) RETURN BOOLEAN

Line 1628: p_property_id pn_rec_exp_line.property_id%TYPE,

1624: FUNCTION check_dates(
1625: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
1626: p_from_date pn_rec_exp_line.from_date%TYPE,
1627: p_to_date pn_rec_exp_line.to_date%TYPE,
1628: p_property_id pn_rec_exp_line.property_id%TYPE,
1629: p_location_id pn_rec_exp_line.location_id%TYPE,
1630: p_extract_code pn_rec_exp_line.expense_extract_code%TYPE
1631: ) RETURN BOOLEAN
1632: IS

Line 1629: p_location_id pn_rec_exp_line.location_id%TYPE,

1625: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
1626: p_from_date pn_rec_exp_line.from_date%TYPE,
1627: p_to_date pn_rec_exp_line.to_date%TYPE,
1628: p_property_id pn_rec_exp_line.property_id%TYPE,
1629: p_location_id pn_rec_exp_line.location_id%TYPE,
1630: p_extract_code pn_rec_exp_line.expense_extract_code%TYPE
1631: ) RETURN BOOLEAN
1632: IS
1633: l_result BOOLEAN := TRUE;

Line 1630: p_extract_code pn_rec_exp_line.expense_extract_code%TYPE

1626: p_from_date pn_rec_exp_line.from_date%TYPE,
1627: p_to_date pn_rec_exp_line.to_date%TYPE,
1628: p_property_id pn_rec_exp_line.property_id%TYPE,
1629: p_location_id pn_rec_exp_line.location_id%TYPE,
1630: p_extract_code pn_rec_exp_line.expense_extract_code%TYPE
1631: ) RETURN BOOLEAN
1632: IS
1633: l_result BOOLEAN := TRUE;
1634:

Line 1636: SELECT 'TRUE' FROM pn_rec_exp_line

1632: IS
1633: l_result BOOLEAN := TRUE;
1634:
1635: CURSOR line_check_crossing_dates IS
1636: SELECT 'TRUE' FROM pn_rec_exp_line
1637: WHERE ((p_from_date BETWEEN from_date AND to_date) OR
1638: (p_to_date BETWEEN from_date AND to_date))
1639: AND (((location_id = p_location_id) OR (location_id IS NULL AND p_location_id IS NULL)) OR
1640: (((property_id = p_property_id) OR (property_id IS NULL AND p_property_id IS NULL))

Line 1739: p_extract_code pn_rec_exp_line.expense_extract_code%TYPE,

1735: -- 19-MAR-03 ftanudja o created
1736: ------------------------------------------------------------------------------+
1737:
1738: FUNCTION check_extract_code(
1739: p_extract_code pn_rec_exp_line.expense_extract_code%TYPE,
1740: p_loc_id pn_rec_exp_line.location_id%TYPE,
1741: p_prop_id pn_rec_exp_line.property_id%TYPE,
1742: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
1743: p_from_date pn_rec_exp_line.from_date%TYPE,

Line 1740: p_loc_id pn_rec_exp_line.location_id%TYPE,

1736: ------------------------------------------------------------------------------+
1737:
1738: FUNCTION check_extract_code(
1739: p_extract_code pn_rec_exp_line.expense_extract_code%TYPE,
1740: p_loc_id pn_rec_exp_line.location_id%TYPE,
1741: p_prop_id pn_rec_exp_line.property_id%TYPE,
1742: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
1743: p_from_date pn_rec_exp_line.from_date%TYPE,
1744: p_to_date pn_rec_exp_line.to_date%TYPE,

Line 1741: p_prop_id pn_rec_exp_line.property_id%TYPE,

1737:
1738: FUNCTION check_extract_code(
1739: p_extract_code pn_rec_exp_line.expense_extract_code%TYPE,
1740: p_loc_id pn_rec_exp_line.location_id%TYPE,
1741: p_prop_id pn_rec_exp_line.property_id%TYPE,
1742: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
1743: p_from_date pn_rec_exp_line.from_date%TYPE,
1744: p_to_date pn_rec_exp_line.to_date%TYPE,
1745: p_currency pn_rec_exp_line.currency_code%TYPE)

Line 1742: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,

1738: FUNCTION check_extract_code(
1739: p_extract_code pn_rec_exp_line.expense_extract_code%TYPE,
1740: p_loc_id pn_rec_exp_line.location_id%TYPE,
1741: p_prop_id pn_rec_exp_line.property_id%TYPE,
1742: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
1743: p_from_date pn_rec_exp_line.from_date%TYPE,
1744: p_to_date pn_rec_exp_line.to_date%TYPE,
1745: p_currency pn_rec_exp_line.currency_code%TYPE)
1746: RETURN BOOLEAN

Line 1743: p_from_date pn_rec_exp_line.from_date%TYPE,

1739: p_extract_code pn_rec_exp_line.expense_extract_code%TYPE,
1740: p_loc_id pn_rec_exp_line.location_id%TYPE,
1741: p_prop_id pn_rec_exp_line.property_id%TYPE,
1742: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
1743: p_from_date pn_rec_exp_line.from_date%TYPE,
1744: p_to_date pn_rec_exp_line.to_date%TYPE,
1745: p_currency pn_rec_exp_line.currency_code%TYPE)
1746: RETURN BOOLEAN
1747: IS

Line 1744: p_to_date pn_rec_exp_line.to_date%TYPE,

1740: p_loc_id pn_rec_exp_line.location_id%TYPE,
1741: p_prop_id pn_rec_exp_line.property_id%TYPE,
1742: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
1743: p_from_date pn_rec_exp_line.from_date%TYPE,
1744: p_to_date pn_rec_exp_line.to_date%TYPE,
1745: p_currency pn_rec_exp_line.currency_code%TYPE)
1746: RETURN BOOLEAN
1747: IS
1748: CURSOR check_exists IS

Line 1745: p_currency pn_rec_exp_line.currency_code%TYPE)

1741: p_prop_id pn_rec_exp_line.property_id%TYPE,
1742: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
1743: p_from_date pn_rec_exp_line.from_date%TYPE,
1744: p_to_date pn_rec_exp_line.to_date%TYPE,
1745: p_currency pn_rec_exp_line.currency_code%TYPE)
1746: RETURN BOOLEAN
1747: IS
1748: CURSOR check_exists IS
1749: SELECT location_id,

Line 1756: FROM pn_rec_exp_line_all

1752: to_date,
1753: as_of_date,
1754: currency_code,
1755: org_id
1756: FROM pn_rec_exp_line_all
1757: WHERE expense_extract_code = p_extract_code;
1758:
1759: l_exist BOOLEAN := FALSE;
1760: l_same BOOLEAN := FALSE;

Line 1818: p_exp_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,

1814: -- 19-MAR-03 ftanudja o created
1815: ------------------------------------------------------------------------------+
1816:
1817: FUNCTION check_ccid_n_type(
1818: p_exp_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
1819: p_cc_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
1820: p_from_date pn_rec_exp_line.from_date%TYPE,
1821: p_to_date pn_rec_exp_line.to_date%TYPE
1822: ) RETURN BOOLEAN

Line 1819: p_cc_id pn_rec_exp_line_dtl.expense_account_id%TYPE,

1815: ------------------------------------------------------------------------------+
1816:
1817: FUNCTION check_ccid_n_type(
1818: p_exp_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
1819: p_cc_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
1820: p_from_date pn_rec_exp_line.from_date%TYPE,
1821: p_to_date pn_rec_exp_line.to_date%TYPE
1822: ) RETURN BOOLEAN
1823: IS

Line 1820: p_from_date pn_rec_exp_line.from_date%TYPE,

1816:
1817: FUNCTION check_ccid_n_type(
1818: p_exp_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
1819: p_cc_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
1820: p_from_date pn_rec_exp_line.from_date%TYPE,
1821: p_to_date pn_rec_exp_line.to_date%TYPE
1822: ) RETURN BOOLEAN
1823: IS
1824: l_result BOOLEAN := TRUE;

Line 1821: p_to_date pn_rec_exp_line.to_date%TYPE

1817: FUNCTION check_ccid_n_type(
1818: p_exp_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
1819: p_cc_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
1820: p_from_date pn_rec_exp_line.from_date%TYPE,
1821: p_to_date pn_rec_exp_line.to_date%TYPE
1822: ) RETURN BOOLEAN
1823: IS
1824: l_result BOOLEAN := TRUE;
1825: CURSOR check_ccid_type IS

Line 1827: FROM pn_rec_exp_line_dtl dtl,

1823: IS
1824: l_result BOOLEAN := TRUE;
1825: CURSOR check_ccid_type IS
1826: SELECT 'EXISTS'
1827: FROM pn_rec_exp_line_dtl dtl,
1828: pn_rec_exp_line hdr
1829: WHERE dtl.expense_line_id = hdr.expense_line_id
1830: AND hdr.from_date = p_from_date
1831: AND hdr.to_date = p_to_date

Line 1828: pn_rec_exp_line hdr

1824: l_result BOOLEAN := TRUE;
1825: CURSOR check_ccid_type IS
1826: SELECT 'EXISTS'
1827: FROM pn_rec_exp_line_dtl dtl,
1828: pn_rec_exp_line hdr
1829: WHERE dtl.expense_line_id = hdr.expense_line_id
1830: AND hdr.from_date = p_from_date
1831: AND hdr.to_date = p_to_date
1832: AND dtl.expense_type_code = p_exp_type_code

Line 1859: p_expense_line_dtl_id OUT NOCOPY pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,

1855: ------------------------------------------------------------------------------+
1856:
1857: PROCEDURE validate_and_process_lines(
1858: p_transfer_flag OUT NOCOPY pn_rec_exp_itf.transfer_flag%TYPE,
1859: p_expense_line_dtl_id OUT NOCOPY pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,
1860: p_expense_line_id IN OUT NOCOPY pn_rec_exp_line_dtl.expense_line_id%TYPE,
1861: p_is_header_set IN OUT NOCOPY BOOLEAN,
1862: p_expense_type_code pn_rec_exp_itf.expense_type_code%TYPE,
1863: p_expense_account_id pn_rec_exp_itf.expense_account_id%TYPE,

Line 1860: p_expense_line_id IN OUT NOCOPY pn_rec_exp_line_dtl.expense_line_id%TYPE,

1856:
1857: PROCEDURE validate_and_process_lines(
1858: p_transfer_flag OUT NOCOPY pn_rec_exp_itf.transfer_flag%TYPE,
1859: p_expense_line_dtl_id OUT NOCOPY pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,
1860: p_expense_line_id IN OUT NOCOPY pn_rec_exp_line_dtl.expense_line_id%TYPE,
1861: p_is_header_set IN OUT NOCOPY BOOLEAN,
1862: p_expense_type_code pn_rec_exp_itf.expense_type_code%TYPE,
1863: p_expense_account_id pn_rec_exp_itf.expense_account_id%TYPE,
1864: p_account_description pn_rec_exp_itf.account_description%TYPE,

Line 1870: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,

1866: p_budgeted_amount pn_rec_exp_itf.budgeted_amount%TYPE,
1867: p_currency_code pn_rec_exp_itf.currency_code%TYPE,
1868: p_location_id pn_rec_exp_itf.location_id%TYPE,
1869: p_property_id pn_rec_exp_itf.property_id%TYPE,
1870: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
1871: p_from_date pn_rec_exp_line.from_date%TYPE,
1872: p_to_date pn_rec_exp_line.to_date%TYPE,
1873: p_extract_code IN OUT NOCOPY pn_rec_exp_line.expense_extract_code%TYPE,
1874: p_keep_override VARCHAR2,

Line 1871: p_from_date pn_rec_exp_line.from_date%TYPE,

1867: p_currency_code pn_rec_exp_itf.currency_code%TYPE,
1868: p_location_id pn_rec_exp_itf.location_id%TYPE,
1869: p_property_id pn_rec_exp_itf.property_id%TYPE,
1870: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
1871: p_from_date pn_rec_exp_line.from_date%TYPE,
1872: p_to_date pn_rec_exp_line.to_date%TYPE,
1873: p_extract_code IN OUT NOCOPY pn_rec_exp_line.expense_extract_code%TYPE,
1874: p_keep_override VARCHAR2,
1875: p_reextract BOOLEAN,

Line 1872: p_to_date pn_rec_exp_line.to_date%TYPE,

1868: p_location_id pn_rec_exp_itf.location_id%TYPE,
1869: p_property_id pn_rec_exp_itf.property_id%TYPE,
1870: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
1871: p_from_date pn_rec_exp_line.from_date%TYPE,
1872: p_to_date pn_rec_exp_line.to_date%TYPE,
1873: p_extract_code IN OUT NOCOPY pn_rec_exp_line.expense_extract_code%TYPE,
1874: p_keep_override VARCHAR2,
1875: p_reextract BOOLEAN,
1876: p_attribute_category pn_rec_exp_itf.attribute_category%TYPE,

Line 1873: p_extract_code IN OUT NOCOPY pn_rec_exp_line.expense_extract_code%TYPE,

1869: p_property_id pn_rec_exp_itf.property_id%TYPE,
1870: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
1871: p_from_date pn_rec_exp_line.from_date%TYPE,
1872: p_to_date pn_rec_exp_line.to_date%TYPE,
1873: p_extract_code IN OUT NOCOPY pn_rec_exp_line.expense_extract_code%TYPE,
1874: p_keep_override VARCHAR2,
1875: p_reextract BOOLEAN,
1876: p_attribute_category pn_rec_exp_itf.attribute_category%TYPE,
1877: p_attribute1 pn_rec_exp_itf.attribute1%TYPE,

Line 1918: pn_rec_exp_line_pkg.insert_row(

1914:
1915: l_info:= ' inserting expense line header';
1916: pnp_debug_pkg.log(l_info);
1917:
1918: pn_rec_exp_line_pkg.insert_row(
1919: x_org_id => to_number(pn_mo_cache_utils.get_current_org_id),
1920: x_expense_line_id => p_expense_line_id,
1921: x_expense_extract_code => p_extract_code,
1922: x_currency_code => p_currency_code,

Line 1940: pn_rec_exp_line_dtl_pkg.insert_row(

1936:
1937: l_info:= ' inserting expense line detail for header id: '||p_expense_line_id;
1938: pnp_debug_pkg.log(l_info);
1939:
1940: pn_rec_exp_line_dtl_pkg.insert_row(
1941: x_org_id => to_number(pn_mo_cache_utils.get_current_org_id),
1942: x_expense_line_id => p_expense_line_id,
1943: x_expense_line_dtl_id => p_expense_line_dtl_id,
1944: x_parent_expense_line_id => null,

Line 2020: p_location_id pn_rec_exp_line.location_id%TYPE,

2016: -- 15-JUL-05 SatyaDeep o Replaced base views with their _ALL tables
2017: ------------------------------------------------------------------------------+
2018:
2019: PROCEDURE extract_expense_lines(
2020: p_location_id pn_rec_exp_line.location_id%TYPE,
2021: p_property_id pn_rec_exp_line.property_id%TYPE,
2022: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
2023: p_from_date pn_rec_exp_line.from_date%TYPE,
2024: p_to_date pn_rec_exp_line.to_date%TYPE,

Line 2021: p_property_id pn_rec_exp_line.property_id%TYPE,

2017: ------------------------------------------------------------------------------+
2018:
2019: PROCEDURE extract_expense_lines(
2020: p_location_id pn_rec_exp_line.location_id%TYPE,
2021: p_property_id pn_rec_exp_line.property_id%TYPE,
2022: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
2023: p_from_date pn_rec_exp_line.from_date%TYPE,
2024: p_to_date pn_rec_exp_line.to_date%TYPE,
2025: p_currency_code pn_rec_exp_line.currency_code%TYPE,

Line 2022: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,

2018:
2019: PROCEDURE extract_expense_lines(
2020: p_location_id pn_rec_exp_line.location_id%TYPE,
2021: p_property_id pn_rec_exp_line.property_id%TYPE,
2022: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
2023: p_from_date pn_rec_exp_line.from_date%TYPE,
2024: p_to_date pn_rec_exp_line.to_date%TYPE,
2025: p_currency_code pn_rec_exp_line.currency_code%TYPE,
2026: p_extract_code IN OUT NOCOPY pn_rec_exp_line.expense_extract_code%TYPE,

Line 2023: p_from_date pn_rec_exp_line.from_date%TYPE,

2019: PROCEDURE extract_expense_lines(
2020: p_location_id pn_rec_exp_line.location_id%TYPE,
2021: p_property_id pn_rec_exp_line.property_id%TYPE,
2022: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
2023: p_from_date pn_rec_exp_line.from_date%TYPE,
2024: p_to_date pn_rec_exp_line.to_date%TYPE,
2025: p_currency_code pn_rec_exp_line.currency_code%TYPE,
2026: p_extract_code IN OUT NOCOPY pn_rec_exp_line.expense_extract_code%TYPE,
2027: p_keep_override VARCHAR2)

Line 2024: p_to_date pn_rec_exp_line.to_date%TYPE,

2020: p_location_id pn_rec_exp_line.location_id%TYPE,
2021: p_property_id pn_rec_exp_line.property_id%TYPE,
2022: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
2023: p_from_date pn_rec_exp_line.from_date%TYPE,
2024: p_to_date pn_rec_exp_line.to_date%TYPE,
2025: p_currency_code pn_rec_exp_line.currency_code%TYPE,
2026: p_extract_code IN OUT NOCOPY pn_rec_exp_line.expense_extract_code%TYPE,
2027: p_keep_override VARCHAR2)
2028: IS

Line 2025: p_currency_code pn_rec_exp_line.currency_code%TYPE,

2021: p_property_id pn_rec_exp_line.property_id%TYPE,
2022: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
2023: p_from_date pn_rec_exp_line.from_date%TYPE,
2024: p_to_date pn_rec_exp_line.to_date%TYPE,
2025: p_currency_code pn_rec_exp_line.currency_code%TYPE,
2026: p_extract_code IN OUT NOCOPY pn_rec_exp_line.expense_extract_code%TYPE,
2027: p_keep_override VARCHAR2)
2028: IS
2029: CURSOR get_itf_lines_info IS

Line 2026: p_extract_code IN OUT NOCOPY pn_rec_exp_line.expense_extract_code%TYPE,

2022: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
2023: p_from_date pn_rec_exp_line.from_date%TYPE,
2024: p_to_date pn_rec_exp_line.to_date%TYPE,
2025: p_currency_code pn_rec_exp_line.currency_code%TYPE,
2026: p_extract_code IN OUT NOCOPY pn_rec_exp_line.expense_extract_code%TYPE,
2027: p_keep_override VARCHAR2)
2028: IS
2029: CURSOR get_itf_lines_info IS
2030: SELECT expense_type_code,

Line 2073: FROM pn_rec_exp_line_all hdr

2069: FOR UPDATE OF transfer_flag, expense_line_dtl_id NOWAIT;
2070:
2071: CURSOR is_reextract IS
2072: SELECT expense_line_id
2073: FROM pn_rec_exp_line_all hdr
2074: WHERE hdr.expense_extract_code = p_extract_code
2075: AND p_extract_code IS NOT NULL
2076: AND rownum < 2;
2077:

Line 2082: l_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE;

2078: l_desc VARCHAR2(100) := 'pn_recovery_extract_pkg.extract_expense_lines' ;
2079: l_info VARCHAR2(300);
2080: l_is_header_set BOOLEAN;
2081: l_reextract BOOLEAN;
2082: l_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE;
2083: l_expense_line_id pn_rec_exp_line_dtl.expense_line_id%TYPE;
2084: l_transfer_flag pn_rec_exp_itf.transfer_flag%TYPE;
2085: l_total NUMBER := 0;
2086: l_failed NUMBER := 0;

Line 2083: l_expense_line_id pn_rec_exp_line_dtl.expense_line_id%TYPE;

2079: l_info VARCHAR2(300);
2080: l_is_header_set BOOLEAN;
2081: l_reextract BOOLEAN;
2082: l_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE;
2083: l_expense_line_id pn_rec_exp_line_dtl.expense_line_id%TYPE;
2084: l_transfer_flag pn_rec_exp_itf.transfer_flag%TYPE;
2085: l_total NUMBER := 0;
2086: l_failed NUMBER := 0;
2087:

Line 2346: p_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,

2342: PROCEDURE process_exp_cls_dtl_dtl_data(
2343: p_detail_data IN OUT NOCOPY exp_cls_line_dtl_tbl,
2344: p_master_data_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
2345: p_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
2346: p_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,
2347: p_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
2348: p_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
2349: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2350: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,

Line 2347: p_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,

2343: p_detail_data IN OUT NOCOPY exp_cls_line_dtl_tbl,
2344: p_master_data_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
2345: p_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
2346: p_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,
2347: p_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
2348: p_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
2349: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2350: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,
2351: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,

Line 2348: p_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,

2344: p_master_data_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
2345: p_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
2346: p_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,
2347: p_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
2348: p_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
2349: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2350: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,
2351: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,
2352: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,

Line 2655: PROCEDURE dismantle_exp_line_from_dtl(p_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE)

2651: -- 06-AUG-03 ftanudja o add deletion mechanism for expcl lines w/ no child.
2652: -- 15-JUL-05 SatyaDeepo Replaced base views with their _ALL tables
2653: ------------------------------------------------------------------------------+
2654:
2655: PROCEDURE dismantle_exp_line_from_dtl(p_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE)
2656: IS
2657: CURSOR get_affected_lines IS
2658: SELECT expense_class_line_dtl_id,
2659: expense_class_line_id

Line 2785: p_location_id pn_rec_exp_line.location_id%TYPE,

2781: -- 15-JUL-05 SatyaDeepo Replaced base views with their _ALL tables
2782: ------------------------------------------------------------------------------+
2783:
2784: PROCEDURE populate_expense_class_details(
2785: p_location_id pn_rec_exp_line.location_id%TYPE,
2786: p_property_id pn_rec_exp_line.property_id%TYPE,
2787: p_as_of_date VARCHAR2,
2788: p_from_date VARCHAR2,
2789: p_to_date VARCHAR2,

Line 2786: p_property_id pn_rec_exp_line.property_id%TYPE,

2782: ------------------------------------------------------------------------------+
2783:
2784: PROCEDURE populate_expense_class_details(
2785: p_location_id pn_rec_exp_line.location_id%TYPE,
2786: p_property_id pn_rec_exp_line.property_id%TYPE,
2787: p_as_of_date VARCHAR2,
2788: p_from_date VARCHAR2,
2789: p_to_date VARCHAR2,
2790: p_extract_code pn_rec_exp_line.expense_extract_code%TYPE,

Line 2790: p_extract_code pn_rec_exp_line.expense_extract_code%TYPE,

2786: p_property_id pn_rec_exp_line.property_id%TYPE,
2787: p_as_of_date VARCHAR2,
2788: p_from_date VARCHAR2,
2789: p_to_date VARCHAR2,
2790: p_extract_code pn_rec_exp_line.expense_extract_code%TYPE,
2791: p_keep_override VARCHAR2)
2792: IS
2793:
2794: CURSOR get_exp_line_id IS

Line 2797: FROM pn_rec_exp_line_all hdr

2793:
2794: CURSOR get_exp_line_id IS
2795: SELECT expense_line_id,
2796: currency_code
2797: FROM pn_rec_exp_line_all hdr
2798: WHERE hdr.expense_extract_code = p_extract_code
2799: AND rownum < 2;
2800:
2801: CURSOR get_expcl_by_prop (p_propid pn_rec_exp_line.property_id%TYPE,

Line 2801: CURSOR get_expcl_by_prop (p_propid pn_rec_exp_line.property_id%TYPE,

2797: FROM pn_rec_exp_line_all hdr
2798: WHERE hdr.expense_extract_code = p_extract_code
2799: AND rownum < 2;
2800:
2801: CURSOR get_expcl_by_prop (p_propid pn_rec_exp_line.property_id%TYPE,
2802: p_currency_code pn_rec_exp_line.currency_code%TYPE) IS
2803: SELECT expense_class_id
2804: FROM pn_rec_expcl_all
2805: WHERE property_id = p_propid

Line 2802: p_currency_code pn_rec_exp_line.currency_code%TYPE) IS

2798: WHERE hdr.expense_extract_code = p_extract_code
2799: AND rownum < 2;
2800:
2801: CURSOR get_expcl_by_prop (p_propid pn_rec_exp_line.property_id%TYPE,
2802: p_currency_code pn_rec_exp_line.currency_code%TYPE) IS
2803: SELECT expense_class_id
2804: FROM pn_rec_expcl_all
2805: WHERE property_id = p_propid
2806: AND location_id IS NULL

Line 2809: CURSOR get_expcl_by_locn (p_locnid pn_rec_exp_line.location_id%TYPE,

2805: WHERE property_id = p_propid
2806: AND location_id IS NULL
2807: AND currency_code = p_currency_code;
2808:
2809: CURSOR get_expcl_by_locn (p_locnid pn_rec_exp_line.location_id%TYPE,
2810: p_currency_code pn_rec_exp_line.currency_code%TYPE) IS
2811: SELECT expense_class_id
2812: FROM pn_rec_expcl_all
2813: WHERE location_id = p_locnid

Line 2810: p_currency_code pn_rec_exp_line.currency_code%TYPE) IS

2806: AND location_id IS NULL
2807: AND currency_code = p_currency_code;
2808:
2809: CURSOR get_expcl_by_locn (p_locnid pn_rec_exp_line.location_id%TYPE,
2810: p_currency_code pn_rec_exp_line.currency_code%TYPE) IS
2811: SELECT expense_class_id
2812: FROM pn_rec_expcl_all
2813: WHERE location_id = p_locnid
2814: AND currency_code = p_currency_code;

Line 2825: l_propid pn_rec_exp_line.property_id%TYPE;

2821: AND active_end_date > fnd_date.canonical_to_date(p_from_date)
2822: START WITH location_id = p_location_id
2823: CONNECT BY location_id = PRIOR parent_location_id;
2824:
2825: l_propid pn_rec_exp_line.property_id%TYPE;
2826: l_dummy VARCHAR2(300);
2827: l_info VARCHAR2(100);
2828: l_desc VARCHAR2(100) := 'pn_recovery_extract_pkg.populate_expense_class_details' ;
2829: l_total NUMBER := 0;

Line 2943: p_location_id pn_rec_exp_line.location_id%TYPE,

2939: -- 15-JUL-05 SatyaDeepo Replaced base views with their _ALL tables
2940: ------------------------------------------------------------------------------+
2941:
2942: PROCEDURE populate_area_class_details(
2943: p_location_id pn_rec_exp_line.location_id%TYPE,
2944: p_property_id pn_rec_exp_line.property_id%TYPE,
2945: p_as_of_date VARCHAR2,
2946: p_from_date VARCHAR2,
2947: p_to_date VARCHAR2,

Line 2944: p_property_id pn_rec_exp_line.property_id%TYPE,

2940: ------------------------------------------------------------------------------+
2941:
2942: PROCEDURE populate_area_class_details(
2943: p_location_id pn_rec_exp_line.location_id%TYPE,
2944: p_property_id pn_rec_exp_line.property_id%TYPE,
2945: p_as_of_date VARCHAR2,
2946: p_from_date VARCHAR2,
2947: p_to_date VARCHAR2,
2948: p_keep_override VARCHAR2)

Line 2951: CURSOR get_arcl_by_prop (l_propid pn_rec_exp_line.property_id%TYPE) IS

2947: p_to_date VARCHAR2,
2948: p_keep_override VARCHAR2)
2949: IS
2950:
2951: CURSOR get_arcl_by_prop (l_propid pn_rec_exp_line.property_id%TYPE) IS
2952: SELECT area_class_id
2953: FROM pn_rec_arcl_all
2954: WHERE property_id = l_propid
2955: AND location_id IS NULL;

Line 2957: CURSOR get_arcl_by_locn (l_locnid pn_rec_exp_line.location_id%TYPE) IS

2953: FROM pn_rec_arcl_all
2954: WHERE property_id = l_propid
2955: AND location_id IS NULL;
2956:
2957: CURSOR get_arcl_by_locn (l_locnid pn_rec_exp_line.location_id%TYPE) IS
2958: SELECT area_class_id
2959: FROM pn_rec_arcl_all
2960: WHERE location_id = l_locnid;
2961:

Line 2971: l_propid pn_rec_exp_line.property_id%TYPE;

2967: AND active_end_date > fnd_date.canonical_to_date(p_from_date)
2968: START WITH location_id = p_location_id
2969: CONNECT BY location_id = PRIOR parent_location_id;
2970:
2971: l_propid pn_rec_exp_line.property_id%TYPE;
2972: l_desc VARCHAR2(100) := 'pn_recovery_extract_pkg.populate_area_class_details' ;
2973: l_info VARCHAR2(100);
2974: l_dummy VARCHAR2(300);
2975: l_total NUMBER := 0;

Line 3189: p_expense_line_id IN pn_rec_exp_line.expense_line_id%TYPE,

3185: p_expense_class_id IN pn_rec_expcl.expense_class_id%TYPE,
3186: p_as_of_date IN VARCHAR2,
3187: p_from_date IN VARCHAR2,
3188: p_to_date IN VARCHAR2,
3189: p_expense_line_id IN pn_rec_exp_line.expense_line_id%TYPE,
3190: p_keep_override IN VARCHAR2)
3191: IS
3192:
3193: CURSOR check_currency IS

Line 3195: FROM pn_rec_exp_line_all

3191: IS
3192:
3193: CURSOR check_currency IS
3194: SELECT 1
3195: FROM pn_rec_exp_line_all
3196: WHERE expense_line_id = p_expense_line_id
3197: AND currency_code NOT IN
3198: (SELECT currency_code FROM pn_rec_expcl_all
3199: WHERE expense_class_id = p_expense_class_id);

Line 3223: p_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE) IS

3219: AND class_type.expense_class_type_id = class_inclusion.expense_class_type_id
3220: AND class.expense_class_id = p_expense_class_id;
3221:
3222: CURSOR get_exp_lines_info (
3223: p_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE) IS
3224: SELECT nvl(lines_dtl.actual_amount_ovr, lines_dtl.actual_amount) actual_amount,
3225: nvl(lines_dtl.budgeted_amount_ovr, lines_dtl.budgeted_amount) budgeted_amount,
3226: lines_dtl.expense_type_code,
3227: lines_dtl.expense_account_id,

Line 3233: FROM pn_rec_exp_line_dtl_all lines_dtl

3229: lines_dtl.property_id,
3230: lines_dtl.expense_line_dtl_id,
3231: lines_dtl.expense_line_id,
3232: lines_dtl.expense_line_indicator
3233: FROM pn_rec_exp_line_dtl_all lines_dtl
3234: WHERE (lines_dtl.expense_line_id = p_expense_line_id OR
3235: lines_dtl.parent_expense_line_id IN
3236: (SELECT expense_line_dtl_id
3237: FROM pn_rec_exp_line_dtl_all

Line 3237: FROM pn_rec_exp_line_dtl_all

3233: FROM pn_rec_exp_line_dtl_all lines_dtl
3234: WHERE (lines_dtl.expense_line_id = p_expense_line_id OR
3235: lines_dtl.parent_expense_line_id IN
3236: (SELECT expense_line_dtl_id
3237: FROM pn_rec_exp_line_dtl_all
3238: WHERE expense_line_id = p_expense_line_id))
3239: AND lines_dtl.expense_type_code = p_expense_type_code
3240: AND lines_dtl.recoverable_flag = 'Y';
3241:

Line 3286: pn_rec_exp_line_all lines

3282: FROM pn_rec_expcl_dtl_all summary,
3283: pn_rec_expcl_dtlln_all class_line,
3284: pn_rec_expcl_dtlacc_all class_line_dtl,
3285: pn_rec_expcl_all class,
3286: pn_rec_exp_line_all lines
3287: WHERE class_line.expense_class_line_id = class_line_dtl.expense_class_line_id
3288: AND class_line.expense_class_dtl_id = summary.expense_class_dtl_id
3289: AND summary.expense_class_id = class.expense_class_id
3290: AND class.expense_class_id = p_expense_class_id

Line 3298: pn_rec_exp_line_all line_hdr,

3294: CURSOR get_prior_cls_dtl_id IS
3295: SELECT summary.expense_class_dtl_id
3296: FROM pn_rec_expcl_dtl_all summary,
3297: pn_rec_expcl_all class,
3298: pn_rec_exp_line_all line_hdr,
3299: (SELECT to_date, as_of_date FROM pn_rec_exp_line_all
3300: WHERE expense_line_id = p_expense_line_id) ref_line_hdr
3301: WHERE summary.expense_class_id = class.expense_class_id
3302: AND summary.expense_line_id = line_hdr.expense_line_id

Line 3299: (SELECT to_date, as_of_date FROM pn_rec_exp_line_all

3295: SELECT summary.expense_class_dtl_id
3296: FROM pn_rec_expcl_dtl_all summary,
3297: pn_rec_expcl_all class,
3298: pn_rec_exp_line_all line_hdr,
3299: (SELECT to_date, as_of_date FROM pn_rec_exp_line_all
3300: WHERE expense_line_id = p_expense_line_id) ref_line_hdr
3301: WHERE summary.expense_class_id = class.expense_class_id
3302: AND summary.expense_line_id = line_hdr.expense_line_id
3303: AND class.expense_class_id = p_expense_class_id

Line 3767: p_currency_code IN pn_rec_exp_line.currency_code%TYPE,

3763: p_property_code IN pn_properties.property_code%TYPE,
3764: p_as_of_date IN VARCHAR2,
3765: p_from_date IN VARCHAR2,
3766: p_to_date IN VARCHAR2,
3767: p_currency_code IN pn_rec_exp_line.currency_code%TYPE,
3768: p_pop_exp_class_dtl IN VARCHAR2,
3769: p_pop_area_class_dtl IN VARCHAR2,
3770: p_keep_override IN VARCHAR2,
3771: p_extract_code IN pn_rec_exp_line.expense_extract_code%TYPE,

Line 3771: p_extract_code IN pn_rec_exp_line.expense_extract_code%TYPE,

3767: p_currency_code IN pn_rec_exp_line.currency_code%TYPE,
3768: p_pop_exp_class_dtl IN VARCHAR2,
3769: p_pop_area_class_dtl IN VARCHAR2,
3770: p_keep_override IN VARCHAR2,
3771: p_extract_code IN pn_rec_exp_line.expense_extract_code%TYPE,
3772: p_called_from IN VARCHAR2)
3773: IS
3774: l_as_of_date DATE;
3775: l_from_date DATE;

Line 3777: l_currency pn_rec_exp_line.currency_code%TYPE;

3773: IS
3774: l_as_of_date DATE;
3775: l_from_date DATE;
3776: l_to_date DATE;
3777: l_currency pn_rec_exp_line.currency_code%TYPE;
3778: l_info VARCHAR2(300);
3779: l_desc VARCHAR2(100) := 'pn_recovery_extract_pkg.extract_line_expense_area' ;
3780: l_err VARCHAR2(100);
3781: l_location_id pn_locations.location_id%TYPE;

Line 3783: l_extract_code pn_rec_exp_line.expense_extract_code%TYPE;

3779: l_desc VARCHAR2(100) := 'pn_recovery_extract_pkg.extract_line_expense_area' ;
3780: l_err VARCHAR2(100);
3781: l_location_id pn_locations.location_id%TYPE;
3782: l_property_id pn_locations.property_id%TYPE;
3783: l_extract_code pn_rec_exp_line.expense_extract_code%TYPE;
3784:
3785: CURSOR derive_loc_id_from_loc_code IS
3786: SELECT location_id, property_id
3787: FROM pn_locations

Line 3934: p_extract_code IN pn_rec_exp_line.expense_extract_code%TYPE,

3930:
3931: PROCEDURE purge_expense_lines_itf_data(
3932: errbuf OUT NOCOPY VARCHAR2,
3933: retcode OUT NOCOPY VARCHAR2,
3934: p_extract_code IN pn_rec_exp_line.expense_extract_code%TYPE,
3935: p_location_code IN pn_locations.location_code%TYPE,
3936: p_property_code IN pn_properties.property_code%TYPE,
3937: p_from_date IN VARCHAR2,
3938: p_to_date IN VARCHAR2,

Line 3959: l_extract_code pn_rec_exp_line.expense_extract_code%TYPE;

3955: l_sqlhead VARCHAR2(300);
3956: l_sqltail VARCHAR2(900) := null;
3957: l_info VARCHAR2(300);
3958: l_desc VARCHAR2(100) := 'pn_recovery_extract_pkg.purge_expense_lines_itf_data' ;
3959: l_extract_code pn_rec_exp_line.expense_extract_code%TYPE;
3960: l_transfer_flag pn_rec_exp_itf.transfer_flag%TYPE;
3961: l_from_date DATE;
3962: l_to_date DATE;
3963: l_statement VARCHAR2(5000);

Line 3994: ' FROM pn_rec_exp_line_all hdr, pn_rec_exp_line_dtl_all dtl ' ||

3990: IF p_extract_code IS NOT NULL THEN
3991:
3992: l_sqltail := ' expense_line_dtl_id IN ' ||
3993: '(SELECT dtl.expense_line_dtl_id ' ||
3994: ' FROM pn_rec_exp_line_all hdr, pn_rec_exp_line_dtl_all dtl ' ||
3995: ' WHERE hdr.expense_line_id = dtl.expense_line_id ' ||
3996: ' AND hdr.expense_extract_code = :l_extract_code)';
3997:
3998: END IF;