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 1637: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,

1633: -- 02-JUL-03 ftanudja o added constraint p_extr code <> null
1634: ------------------------------------------------------------------------------+
1635:
1636: FUNCTION check_dates(
1637: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
1638: p_from_date pn_rec_exp_line.from_date%TYPE,
1639: p_to_date pn_rec_exp_line.to_date%TYPE,
1640: p_property_id pn_rec_exp_line.property_id%TYPE,
1641: p_location_id pn_rec_exp_line.location_id%TYPE,

Line 1638: p_from_date pn_rec_exp_line.from_date%TYPE,

1634: ------------------------------------------------------------------------------+
1635:
1636: FUNCTION check_dates(
1637: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
1638: p_from_date pn_rec_exp_line.from_date%TYPE,
1639: p_to_date pn_rec_exp_line.to_date%TYPE,
1640: p_property_id pn_rec_exp_line.property_id%TYPE,
1641: p_location_id pn_rec_exp_line.location_id%TYPE,
1642: p_extract_code pn_rec_exp_line.expense_extract_code%TYPE

Line 1639: p_to_date pn_rec_exp_line.to_date%TYPE,

1635:
1636: FUNCTION check_dates(
1637: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
1638: p_from_date pn_rec_exp_line.from_date%TYPE,
1639: p_to_date pn_rec_exp_line.to_date%TYPE,
1640: p_property_id pn_rec_exp_line.property_id%TYPE,
1641: p_location_id pn_rec_exp_line.location_id%TYPE,
1642: p_extract_code pn_rec_exp_line.expense_extract_code%TYPE
1643: ) RETURN BOOLEAN

Line 1640: p_property_id pn_rec_exp_line.property_id%TYPE,

1636: FUNCTION check_dates(
1637: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
1638: p_from_date pn_rec_exp_line.from_date%TYPE,
1639: p_to_date pn_rec_exp_line.to_date%TYPE,
1640: p_property_id pn_rec_exp_line.property_id%TYPE,
1641: p_location_id pn_rec_exp_line.location_id%TYPE,
1642: p_extract_code pn_rec_exp_line.expense_extract_code%TYPE
1643: ) RETURN BOOLEAN
1644: IS

Line 1641: p_location_id pn_rec_exp_line.location_id%TYPE,

1637: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
1638: p_from_date pn_rec_exp_line.from_date%TYPE,
1639: p_to_date pn_rec_exp_line.to_date%TYPE,
1640: p_property_id pn_rec_exp_line.property_id%TYPE,
1641: p_location_id pn_rec_exp_line.location_id%TYPE,
1642: p_extract_code pn_rec_exp_line.expense_extract_code%TYPE
1643: ) RETURN BOOLEAN
1644: IS
1645: l_result BOOLEAN := TRUE;

Line 1642: p_extract_code pn_rec_exp_line.expense_extract_code%TYPE

1638: p_from_date pn_rec_exp_line.from_date%TYPE,
1639: p_to_date pn_rec_exp_line.to_date%TYPE,
1640: p_property_id pn_rec_exp_line.property_id%TYPE,
1641: p_location_id pn_rec_exp_line.location_id%TYPE,
1642: p_extract_code pn_rec_exp_line.expense_extract_code%TYPE
1643: ) RETURN BOOLEAN
1644: IS
1645: l_result BOOLEAN := TRUE;
1646:

Line 1648: SELECT 'TRUE' FROM pn_rec_exp_line

1644: IS
1645: l_result BOOLEAN := TRUE;
1646:
1647: CURSOR line_check_crossing_dates IS
1648: SELECT 'TRUE' FROM pn_rec_exp_line
1649: WHERE ((p_from_date BETWEEN from_date AND to_date) OR
1650: (p_to_date BETWEEN from_date AND to_date))
1651: AND (((location_id = p_location_id) OR (location_id IS NULL AND p_location_id IS NULL)) OR
1652: (((property_id = p_property_id) OR (property_id IS NULL AND p_property_id IS NULL))

Line 1751: p_extract_code pn_rec_exp_line.expense_extract_code%TYPE,

1747: -- 19-MAR-03 ftanudja o created
1748: ------------------------------------------------------------------------------+
1749:
1750: FUNCTION check_extract_code(
1751: p_extract_code pn_rec_exp_line.expense_extract_code%TYPE,
1752: p_loc_id pn_rec_exp_line.location_id%TYPE,
1753: p_prop_id pn_rec_exp_line.property_id%TYPE,
1754: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
1755: p_from_date pn_rec_exp_line.from_date%TYPE,

Line 1752: p_loc_id pn_rec_exp_line.location_id%TYPE,

1748: ------------------------------------------------------------------------------+
1749:
1750: FUNCTION check_extract_code(
1751: p_extract_code pn_rec_exp_line.expense_extract_code%TYPE,
1752: p_loc_id pn_rec_exp_line.location_id%TYPE,
1753: p_prop_id pn_rec_exp_line.property_id%TYPE,
1754: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
1755: p_from_date pn_rec_exp_line.from_date%TYPE,
1756: p_to_date pn_rec_exp_line.to_date%TYPE,

Line 1753: p_prop_id pn_rec_exp_line.property_id%TYPE,

1749:
1750: FUNCTION check_extract_code(
1751: p_extract_code pn_rec_exp_line.expense_extract_code%TYPE,
1752: p_loc_id pn_rec_exp_line.location_id%TYPE,
1753: p_prop_id pn_rec_exp_line.property_id%TYPE,
1754: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
1755: p_from_date pn_rec_exp_line.from_date%TYPE,
1756: p_to_date pn_rec_exp_line.to_date%TYPE,
1757: p_currency pn_rec_exp_line.currency_code%TYPE)

Line 1754: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,

1750: FUNCTION check_extract_code(
1751: p_extract_code pn_rec_exp_line.expense_extract_code%TYPE,
1752: p_loc_id pn_rec_exp_line.location_id%TYPE,
1753: p_prop_id pn_rec_exp_line.property_id%TYPE,
1754: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
1755: p_from_date pn_rec_exp_line.from_date%TYPE,
1756: p_to_date pn_rec_exp_line.to_date%TYPE,
1757: p_currency pn_rec_exp_line.currency_code%TYPE)
1758: RETURN BOOLEAN

Line 1755: p_from_date pn_rec_exp_line.from_date%TYPE,

1751: p_extract_code pn_rec_exp_line.expense_extract_code%TYPE,
1752: p_loc_id pn_rec_exp_line.location_id%TYPE,
1753: p_prop_id pn_rec_exp_line.property_id%TYPE,
1754: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
1755: p_from_date pn_rec_exp_line.from_date%TYPE,
1756: p_to_date pn_rec_exp_line.to_date%TYPE,
1757: p_currency pn_rec_exp_line.currency_code%TYPE)
1758: RETURN BOOLEAN
1759: IS

Line 1756: p_to_date pn_rec_exp_line.to_date%TYPE,

1752: p_loc_id pn_rec_exp_line.location_id%TYPE,
1753: p_prop_id pn_rec_exp_line.property_id%TYPE,
1754: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
1755: p_from_date pn_rec_exp_line.from_date%TYPE,
1756: p_to_date pn_rec_exp_line.to_date%TYPE,
1757: p_currency pn_rec_exp_line.currency_code%TYPE)
1758: RETURN BOOLEAN
1759: IS
1760: CURSOR check_exists IS

Line 1757: p_currency pn_rec_exp_line.currency_code%TYPE)

1753: p_prop_id pn_rec_exp_line.property_id%TYPE,
1754: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
1755: p_from_date pn_rec_exp_line.from_date%TYPE,
1756: p_to_date pn_rec_exp_line.to_date%TYPE,
1757: p_currency pn_rec_exp_line.currency_code%TYPE)
1758: RETURN BOOLEAN
1759: IS
1760: CURSOR check_exists IS
1761: SELECT location_id,

Line 1768: FROM pn_rec_exp_line_all

1764: to_date,
1765: as_of_date,
1766: currency_code,
1767: org_id
1768: FROM pn_rec_exp_line_all
1769: WHERE expense_extract_code = p_extract_code;
1770:
1771: l_exist BOOLEAN := FALSE;
1772: l_same BOOLEAN := FALSE;

Line 1830: p_exp_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,

1826: -- 19-MAR-03 ftanudja o created
1827: ------------------------------------------------------------------------------+
1828:
1829: FUNCTION check_ccid_n_type(
1830: p_exp_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
1831: p_cc_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
1832: p_from_date pn_rec_exp_line.from_date%TYPE,
1833: p_to_date pn_rec_exp_line.to_date%TYPE
1834: ) RETURN BOOLEAN

Line 1831: p_cc_id pn_rec_exp_line_dtl.expense_account_id%TYPE,

1827: ------------------------------------------------------------------------------+
1828:
1829: FUNCTION check_ccid_n_type(
1830: p_exp_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
1831: p_cc_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
1832: p_from_date pn_rec_exp_line.from_date%TYPE,
1833: p_to_date pn_rec_exp_line.to_date%TYPE
1834: ) RETURN BOOLEAN
1835: IS

Line 1832: p_from_date pn_rec_exp_line.from_date%TYPE,

1828:
1829: FUNCTION check_ccid_n_type(
1830: p_exp_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
1831: p_cc_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
1832: p_from_date pn_rec_exp_line.from_date%TYPE,
1833: p_to_date pn_rec_exp_line.to_date%TYPE
1834: ) RETURN BOOLEAN
1835: IS
1836: l_result BOOLEAN := TRUE;

Line 1833: p_to_date pn_rec_exp_line.to_date%TYPE

1829: FUNCTION check_ccid_n_type(
1830: p_exp_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
1831: p_cc_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
1832: p_from_date pn_rec_exp_line.from_date%TYPE,
1833: p_to_date pn_rec_exp_line.to_date%TYPE
1834: ) RETURN BOOLEAN
1835: IS
1836: l_result BOOLEAN := TRUE;
1837: CURSOR check_ccid_type IS

Line 1839: FROM pn_rec_exp_line_dtl dtl,

1835: IS
1836: l_result BOOLEAN := TRUE;
1837: CURSOR check_ccid_type IS
1838: SELECT 'EXISTS'
1839: FROM pn_rec_exp_line_dtl dtl,
1840: pn_rec_exp_line hdr
1841: WHERE dtl.expense_line_id = hdr.expense_line_id
1842: AND hdr.from_date = p_from_date
1843: AND hdr.to_date = p_to_date

Line 1840: pn_rec_exp_line hdr

1836: l_result BOOLEAN := TRUE;
1837: CURSOR check_ccid_type IS
1838: SELECT 'EXISTS'
1839: FROM pn_rec_exp_line_dtl dtl,
1840: pn_rec_exp_line hdr
1841: WHERE dtl.expense_line_id = hdr.expense_line_id
1842: AND hdr.from_date = p_from_date
1843: AND hdr.to_date = p_to_date
1844: AND dtl.expense_type_code = p_exp_type_code

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

1867: ------------------------------------------------------------------------------+
1868:
1869: PROCEDURE validate_and_process_lines(
1870: p_transfer_flag OUT NOCOPY pn_rec_exp_itf.transfer_flag%TYPE,
1871: p_expense_line_dtl_id OUT NOCOPY pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,
1872: p_expense_line_id IN OUT NOCOPY pn_rec_exp_line_dtl.expense_line_id%TYPE,
1873: p_is_header_set IN OUT NOCOPY BOOLEAN,
1874: p_expense_type_code pn_rec_exp_itf.expense_type_code%TYPE,
1875: p_expense_account_id pn_rec_exp_itf.expense_account_id%TYPE,

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

1868:
1869: PROCEDURE validate_and_process_lines(
1870: p_transfer_flag OUT NOCOPY pn_rec_exp_itf.transfer_flag%TYPE,
1871: p_expense_line_dtl_id OUT NOCOPY pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,
1872: p_expense_line_id IN OUT NOCOPY pn_rec_exp_line_dtl.expense_line_id%TYPE,
1873: p_is_header_set IN OUT NOCOPY BOOLEAN,
1874: p_expense_type_code pn_rec_exp_itf.expense_type_code%TYPE,
1875: p_expense_account_id pn_rec_exp_itf.expense_account_id%TYPE,
1876: p_account_description pn_rec_exp_itf.account_description%TYPE,

Line 1882: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,

1878: p_budgeted_amount pn_rec_exp_itf.budgeted_amount%TYPE,
1879: p_currency_code pn_rec_exp_itf.currency_code%TYPE,
1880: p_location_id pn_rec_exp_itf.location_id%TYPE,
1881: p_property_id pn_rec_exp_itf.property_id%TYPE,
1882: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
1883: p_from_date pn_rec_exp_line.from_date%TYPE,
1884: p_to_date pn_rec_exp_line.to_date%TYPE,
1885: p_extract_code IN OUT NOCOPY pn_rec_exp_line.expense_extract_code%TYPE,
1886: p_keep_override VARCHAR2,

Line 1883: p_from_date pn_rec_exp_line.from_date%TYPE,

1879: p_currency_code pn_rec_exp_itf.currency_code%TYPE,
1880: p_location_id pn_rec_exp_itf.location_id%TYPE,
1881: p_property_id pn_rec_exp_itf.property_id%TYPE,
1882: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
1883: p_from_date pn_rec_exp_line.from_date%TYPE,
1884: p_to_date pn_rec_exp_line.to_date%TYPE,
1885: p_extract_code IN OUT NOCOPY pn_rec_exp_line.expense_extract_code%TYPE,
1886: p_keep_override VARCHAR2,
1887: p_reextract BOOLEAN,

Line 1884: p_to_date pn_rec_exp_line.to_date%TYPE,

1880: p_location_id pn_rec_exp_itf.location_id%TYPE,
1881: p_property_id pn_rec_exp_itf.property_id%TYPE,
1882: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
1883: p_from_date pn_rec_exp_line.from_date%TYPE,
1884: p_to_date pn_rec_exp_line.to_date%TYPE,
1885: p_extract_code IN OUT NOCOPY pn_rec_exp_line.expense_extract_code%TYPE,
1886: p_keep_override VARCHAR2,
1887: p_reextract BOOLEAN,
1888: p_attribute_category pn_rec_exp_itf.attribute_category%TYPE,

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

1881: p_property_id pn_rec_exp_itf.property_id%TYPE,
1882: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
1883: p_from_date pn_rec_exp_line.from_date%TYPE,
1884: p_to_date pn_rec_exp_line.to_date%TYPE,
1885: p_extract_code IN OUT NOCOPY pn_rec_exp_line.expense_extract_code%TYPE,
1886: p_keep_override VARCHAR2,
1887: p_reextract BOOLEAN,
1888: p_attribute_category pn_rec_exp_itf.attribute_category%TYPE,
1889: p_attribute1 pn_rec_exp_itf.attribute1%TYPE,

Line 1930: pn_rec_exp_line_pkg.insert_row(

1926:
1927: l_info:= ' inserting expense line header';
1928: pnp_debug_pkg.log(l_info);
1929:
1930: pn_rec_exp_line_pkg.insert_row(
1931: x_org_id => to_number(pn_mo_cache_utils.get_current_org_id),
1932: x_expense_line_id => p_expense_line_id,
1933: x_expense_extract_code => p_extract_code,
1934: x_currency_code => p_currency_code,

Line 1952: pn_rec_exp_line_dtl_pkg.insert_row(

1948:
1949: l_info:= ' inserting expense line detail for header id: '||p_expense_line_id;
1950: pnp_debug_pkg.log(l_info);
1951:
1952: pn_rec_exp_line_dtl_pkg.insert_row(
1953: x_org_id => to_number(pn_mo_cache_utils.get_current_org_id),
1954: x_expense_line_id => p_expense_line_id,
1955: x_expense_line_dtl_id => p_expense_line_dtl_id,
1956: x_parent_expense_line_id => null,

Line 2032: p_location_id pn_rec_exp_line.location_id%TYPE,

2028: -- 15-JUL-05 SatyaDeep o Replaced base views with their _ALL tables
2029: ------------------------------------------------------------------------------+
2030:
2031: PROCEDURE extract_expense_lines(
2032: p_location_id pn_rec_exp_line.location_id%TYPE,
2033: p_property_id pn_rec_exp_line.property_id%TYPE,
2034: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
2035: p_from_date pn_rec_exp_line.from_date%TYPE,
2036: p_to_date pn_rec_exp_line.to_date%TYPE,

Line 2033: p_property_id pn_rec_exp_line.property_id%TYPE,

2029: ------------------------------------------------------------------------------+
2030:
2031: PROCEDURE extract_expense_lines(
2032: p_location_id pn_rec_exp_line.location_id%TYPE,
2033: p_property_id pn_rec_exp_line.property_id%TYPE,
2034: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
2035: p_from_date pn_rec_exp_line.from_date%TYPE,
2036: p_to_date pn_rec_exp_line.to_date%TYPE,
2037: p_currency_code pn_rec_exp_line.currency_code%TYPE,

Line 2034: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,

2030:
2031: PROCEDURE extract_expense_lines(
2032: p_location_id pn_rec_exp_line.location_id%TYPE,
2033: p_property_id pn_rec_exp_line.property_id%TYPE,
2034: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
2035: p_from_date pn_rec_exp_line.from_date%TYPE,
2036: p_to_date pn_rec_exp_line.to_date%TYPE,
2037: p_currency_code pn_rec_exp_line.currency_code%TYPE,
2038: p_extract_code IN OUT NOCOPY pn_rec_exp_line.expense_extract_code%TYPE,

Line 2035: p_from_date pn_rec_exp_line.from_date%TYPE,

2031: PROCEDURE extract_expense_lines(
2032: p_location_id pn_rec_exp_line.location_id%TYPE,
2033: p_property_id pn_rec_exp_line.property_id%TYPE,
2034: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
2035: p_from_date pn_rec_exp_line.from_date%TYPE,
2036: p_to_date pn_rec_exp_line.to_date%TYPE,
2037: p_currency_code pn_rec_exp_line.currency_code%TYPE,
2038: p_extract_code IN OUT NOCOPY pn_rec_exp_line.expense_extract_code%TYPE,
2039: p_keep_override VARCHAR2)

Line 2036: p_to_date pn_rec_exp_line.to_date%TYPE,

2032: p_location_id pn_rec_exp_line.location_id%TYPE,
2033: p_property_id pn_rec_exp_line.property_id%TYPE,
2034: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
2035: p_from_date pn_rec_exp_line.from_date%TYPE,
2036: p_to_date pn_rec_exp_line.to_date%TYPE,
2037: p_currency_code pn_rec_exp_line.currency_code%TYPE,
2038: p_extract_code IN OUT NOCOPY pn_rec_exp_line.expense_extract_code%TYPE,
2039: p_keep_override VARCHAR2)
2040: IS

Line 2037: p_currency_code pn_rec_exp_line.currency_code%TYPE,

2033: p_property_id pn_rec_exp_line.property_id%TYPE,
2034: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
2035: p_from_date pn_rec_exp_line.from_date%TYPE,
2036: p_to_date pn_rec_exp_line.to_date%TYPE,
2037: p_currency_code pn_rec_exp_line.currency_code%TYPE,
2038: p_extract_code IN OUT NOCOPY pn_rec_exp_line.expense_extract_code%TYPE,
2039: p_keep_override VARCHAR2)
2040: IS
2041: CURSOR get_itf_lines_info IS

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

2034: p_as_of_date pn_rec_exp_line.as_of_date%TYPE,
2035: p_from_date pn_rec_exp_line.from_date%TYPE,
2036: p_to_date pn_rec_exp_line.to_date%TYPE,
2037: p_currency_code pn_rec_exp_line.currency_code%TYPE,
2038: p_extract_code IN OUT NOCOPY pn_rec_exp_line.expense_extract_code%TYPE,
2039: p_keep_override VARCHAR2)
2040: IS
2041: CURSOR get_itf_lines_info IS
2042: SELECT expense_type_code,

Line 2085: FROM pn_rec_exp_line_all hdr

2081: FOR UPDATE OF transfer_flag, expense_line_dtl_id NOWAIT;
2082:
2083: CURSOR is_reextract IS
2084: SELECT expense_line_id
2085: FROM pn_rec_exp_line_all hdr
2086: WHERE hdr.expense_extract_code = p_extract_code
2087: AND p_extract_code IS NOT NULL
2088: AND rownum < 2;
2089:

Line 2094: l_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE;

2090: l_desc VARCHAR2(100) := 'pn_recovery_extract_pkg.extract_expense_lines' ;
2091: l_info VARCHAR2(300);
2092: l_is_header_set BOOLEAN;
2093: l_reextract BOOLEAN;
2094: l_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE;
2095: l_expense_line_id pn_rec_exp_line_dtl.expense_line_id%TYPE;
2096: l_transfer_flag pn_rec_exp_itf.transfer_flag%TYPE;
2097: l_total NUMBER := 0;
2098: l_failed NUMBER := 0;

Line 2095: l_expense_line_id pn_rec_exp_line_dtl.expense_line_id%TYPE;

2091: l_info VARCHAR2(300);
2092: l_is_header_set BOOLEAN;
2093: l_reextract BOOLEAN;
2094: l_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE;
2095: l_expense_line_id pn_rec_exp_line_dtl.expense_line_id%TYPE;
2096: l_transfer_flag pn_rec_exp_itf.transfer_flag%TYPE;
2097: l_total NUMBER := 0;
2098: l_failed NUMBER := 0;
2099:

Line 2358: p_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,

2354: PROCEDURE process_exp_cls_dtl_dtl_data(
2355: p_detail_data IN OUT NOCOPY exp_cls_line_dtl_tbl,
2356: p_master_data_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
2357: p_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
2358: p_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,
2359: p_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
2360: p_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
2361: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2362: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,

Line 2359: p_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,

2355: p_detail_data IN OUT NOCOPY exp_cls_line_dtl_tbl,
2356: p_master_data_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
2357: p_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
2358: p_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,
2359: p_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
2360: p_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
2361: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2362: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,
2363: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,

Line 2360: p_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,

2356: p_master_data_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE,
2357: p_expense_class_line_dtl_id pn_rec_expcl_dtlacc.expense_class_line_dtl_id%TYPE,
2358: p_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE,
2359: p_expense_account_id pn_rec_exp_line_dtl.expense_account_id%TYPE,
2360: p_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE,
2361: p_expense_amount pn_rec_expcl_dtlln.expense_amt%TYPE,
2362: p_budget_amount pn_rec_expcl_dtlln.budgeted_amt%TYPE,
2363: p_recoverable_amount pn_rec_expcl_dtlln.recoverable_amt%TYPE,
2364: p_cpt_recoverable_amount pn_rec_expcl_dtlln.computed_recoverable_amt%TYPE,

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

2663: -- 06-AUG-03 ftanudja o add deletion mechanism for expcl lines w/ no child.
2664: -- 15-JUL-05 SatyaDeepo Replaced base views with their _ALL tables
2665: ------------------------------------------------------------------------------+
2666:
2667: PROCEDURE dismantle_exp_line_from_dtl(p_expense_line_dtl_id pn_rec_exp_line_dtl.expense_line_dtl_id%TYPE)
2668: IS
2669: CURSOR get_affected_lines IS
2670: SELECT expense_class_line_dtl_id,
2671: expense_class_line_id

Line 2797: p_location_id pn_rec_exp_line.location_id%TYPE,

2793: -- 15-JUL-05 SatyaDeepo Replaced base views with their _ALL tables
2794: ------------------------------------------------------------------------------+
2795:
2796: PROCEDURE populate_expense_class_details(
2797: p_location_id pn_rec_exp_line.location_id%TYPE,
2798: p_property_id pn_rec_exp_line.property_id%TYPE,
2799: p_as_of_date VARCHAR2,
2800: p_from_date VARCHAR2,
2801: p_to_date VARCHAR2,

Line 2798: p_property_id pn_rec_exp_line.property_id%TYPE,

2794: ------------------------------------------------------------------------------+
2795:
2796: PROCEDURE populate_expense_class_details(
2797: p_location_id pn_rec_exp_line.location_id%TYPE,
2798: p_property_id pn_rec_exp_line.property_id%TYPE,
2799: p_as_of_date VARCHAR2,
2800: p_from_date VARCHAR2,
2801: p_to_date VARCHAR2,
2802: p_extract_code pn_rec_exp_line.expense_extract_code%TYPE,

Line 2802: p_extract_code pn_rec_exp_line.expense_extract_code%TYPE,

2798: p_property_id pn_rec_exp_line.property_id%TYPE,
2799: p_as_of_date VARCHAR2,
2800: p_from_date VARCHAR2,
2801: p_to_date VARCHAR2,
2802: p_extract_code pn_rec_exp_line.expense_extract_code%TYPE,
2803: p_keep_override VARCHAR2)
2804: IS
2805:
2806: CURSOR get_exp_line_id IS

Line 2809: FROM pn_rec_exp_line_all hdr

2805:
2806: CURSOR get_exp_line_id IS
2807: SELECT expense_line_id,
2808: currency_code
2809: FROM pn_rec_exp_line_all hdr
2810: WHERE hdr.expense_extract_code = p_extract_code
2811: AND rownum < 2;
2812:
2813: CURSOR get_expcl_by_prop (p_propid pn_rec_exp_line.property_id%TYPE,

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

2809: FROM pn_rec_exp_line_all hdr
2810: WHERE hdr.expense_extract_code = p_extract_code
2811: AND rownum < 2;
2812:
2813: CURSOR get_expcl_by_prop (p_propid pn_rec_exp_line.property_id%TYPE,
2814: p_currency_code pn_rec_exp_line.currency_code%TYPE) IS
2815: SELECT expense_class_id
2816: FROM pn_rec_expcl_all
2817: WHERE property_id = p_propid

Line 2814: p_currency_code pn_rec_exp_line.currency_code%TYPE) IS

2810: WHERE hdr.expense_extract_code = p_extract_code
2811: AND rownum < 2;
2812:
2813: CURSOR get_expcl_by_prop (p_propid pn_rec_exp_line.property_id%TYPE,
2814: p_currency_code pn_rec_exp_line.currency_code%TYPE) IS
2815: SELECT expense_class_id
2816: FROM pn_rec_expcl_all
2817: WHERE property_id = p_propid
2818: AND location_id IS NULL

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

2817: WHERE property_id = p_propid
2818: AND location_id IS NULL
2819: AND currency_code = p_currency_code;
2820:
2821: CURSOR get_expcl_by_locn (p_locnid pn_rec_exp_line.location_id%TYPE,
2822: p_currency_code pn_rec_exp_line.currency_code%TYPE) IS
2823: SELECT expense_class_id
2824: FROM pn_rec_expcl_all
2825: WHERE location_id = p_locnid

Line 2822: p_currency_code pn_rec_exp_line.currency_code%TYPE) IS

2818: AND location_id IS NULL
2819: AND currency_code = p_currency_code;
2820:
2821: CURSOR get_expcl_by_locn (p_locnid pn_rec_exp_line.location_id%TYPE,
2822: p_currency_code pn_rec_exp_line.currency_code%TYPE) IS
2823: SELECT expense_class_id
2824: FROM pn_rec_expcl_all
2825: WHERE location_id = p_locnid
2826: AND currency_code = p_currency_code;

Line 2837: l_propid pn_rec_exp_line.property_id%TYPE;

2833: AND active_end_date > fnd_date.canonical_to_date(p_from_date)
2834: START WITH location_id = p_location_id
2835: CONNECT BY location_id = PRIOR parent_location_id;
2836:
2837: l_propid pn_rec_exp_line.property_id%TYPE;
2838: l_dummy VARCHAR2(300);
2839: l_info VARCHAR2(100);
2840: l_desc VARCHAR2(100) := 'pn_recovery_extract_pkg.populate_expense_class_details' ;
2841: l_total NUMBER := 0;

Line 2955: p_location_id pn_rec_exp_line.location_id%TYPE,

2951: -- 15-JUL-05 SatyaDeepo Replaced base views with their _ALL tables
2952: ------------------------------------------------------------------------------+
2953:
2954: PROCEDURE populate_area_class_details(
2955: p_location_id pn_rec_exp_line.location_id%TYPE,
2956: p_property_id pn_rec_exp_line.property_id%TYPE,
2957: p_as_of_date VARCHAR2,
2958: p_from_date VARCHAR2,
2959: p_to_date VARCHAR2,

Line 2956: p_property_id pn_rec_exp_line.property_id%TYPE,

2952: ------------------------------------------------------------------------------+
2953:
2954: PROCEDURE populate_area_class_details(
2955: p_location_id pn_rec_exp_line.location_id%TYPE,
2956: p_property_id pn_rec_exp_line.property_id%TYPE,
2957: p_as_of_date VARCHAR2,
2958: p_from_date VARCHAR2,
2959: p_to_date VARCHAR2,
2960: p_keep_override VARCHAR2)

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

2959: p_to_date VARCHAR2,
2960: p_keep_override VARCHAR2)
2961: IS
2962:
2963: CURSOR get_arcl_by_prop (l_propid pn_rec_exp_line.property_id%TYPE) IS
2964: SELECT area_class_id
2965: FROM pn_rec_arcl_all
2966: WHERE property_id = l_propid
2967: AND location_id IS NULL;

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

2965: FROM pn_rec_arcl_all
2966: WHERE property_id = l_propid
2967: AND location_id IS NULL;
2968:
2969: CURSOR get_arcl_by_locn (l_locnid pn_rec_exp_line.location_id%TYPE) IS
2970: SELECT area_class_id
2971: FROM pn_rec_arcl_all
2972: WHERE location_id = l_locnid;
2973:

Line 2983: l_propid pn_rec_exp_line.property_id%TYPE;

2979: AND active_end_date > fnd_date.canonical_to_date(p_from_date)
2980: START WITH location_id = p_location_id
2981: CONNECT BY location_id = PRIOR parent_location_id;
2982:
2983: l_propid pn_rec_exp_line.property_id%TYPE;
2984: l_desc VARCHAR2(100) := 'pn_recovery_extract_pkg.populate_area_class_details' ;
2985: l_info VARCHAR2(100);
2986: l_dummy VARCHAR2(300);
2987: l_total NUMBER := 0;

Line 3201: p_expense_line_id IN pn_rec_exp_line.expense_line_id%TYPE,

3197: p_expense_class_id IN pn_rec_expcl.expense_class_id%TYPE,
3198: p_as_of_date IN VARCHAR2,
3199: p_from_date IN VARCHAR2,
3200: p_to_date IN VARCHAR2,
3201: p_expense_line_id IN pn_rec_exp_line.expense_line_id%TYPE,
3202: p_keep_override IN VARCHAR2)
3203: IS
3204:
3205: CURSOR check_currency IS

Line 3207: FROM pn_rec_exp_line_all

3203: IS
3204:
3205: CURSOR check_currency IS
3206: SELECT 1
3207: FROM pn_rec_exp_line_all
3208: WHERE expense_line_id = p_expense_line_id
3209: AND currency_code NOT IN
3210: (SELECT currency_code FROM pn_rec_expcl_all
3211: WHERE expense_class_id = p_expense_class_id);

Line 3235: p_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE) IS

3231: AND class_type.expense_class_type_id = class_inclusion.expense_class_type_id
3232: AND class.expense_class_id = p_expense_class_id;
3233:
3234: CURSOR get_exp_lines_info (
3235: p_expense_type_code pn_rec_exp_line_dtl.expense_type_code%TYPE) IS
3236: SELECT nvl(lines_dtl.actual_amount_ovr, lines_dtl.actual_amount) actual_amount,
3237: nvl(lines_dtl.budgeted_amount_ovr, lines_dtl.budgeted_amount) budgeted_amount,
3238: lines_dtl.expense_type_code,
3239: lines_dtl.expense_account_id,

Line 3245: FROM pn_rec_exp_line_dtl_all lines_dtl

3241: lines_dtl.property_id,
3242: lines_dtl.expense_line_dtl_id,
3243: lines_dtl.expense_line_id,
3244: lines_dtl.expense_line_indicator
3245: FROM pn_rec_exp_line_dtl_all lines_dtl
3246: WHERE (lines_dtl.expense_line_id = p_expense_line_id OR
3247: lines_dtl.parent_expense_line_id IN
3248: (SELECT expense_line_dtl_id
3249: FROM pn_rec_exp_line_dtl_all

Line 3249: FROM pn_rec_exp_line_dtl_all

3245: FROM pn_rec_exp_line_dtl_all lines_dtl
3246: WHERE (lines_dtl.expense_line_id = p_expense_line_id OR
3247: lines_dtl.parent_expense_line_id IN
3248: (SELECT expense_line_dtl_id
3249: FROM pn_rec_exp_line_dtl_all
3250: WHERE expense_line_id = p_expense_line_id))
3251: AND lines_dtl.expense_type_code = p_expense_type_code
3252: AND lines_dtl.recoverable_flag = 'Y';
3253:

Line 3298: pn_rec_exp_line_all lines

3294: FROM pn_rec_expcl_dtl_all summary,
3295: pn_rec_expcl_dtlln_all class_line,
3296: pn_rec_expcl_dtlacc_all class_line_dtl,
3297: pn_rec_expcl_all class,
3298: pn_rec_exp_line_all lines
3299: WHERE class_line.expense_class_line_id = class_line_dtl.expense_class_line_id
3300: AND class_line.expense_class_dtl_id = summary.expense_class_dtl_id
3301: AND summary.expense_class_id = class.expense_class_id
3302: AND class.expense_class_id = p_expense_class_id

Line 3310: pn_rec_exp_line_all line_hdr,

3306: CURSOR get_prior_cls_dtl_id IS
3307: SELECT summary.expense_class_dtl_id
3308: FROM pn_rec_expcl_dtl_all summary,
3309: pn_rec_expcl_all class,
3310: pn_rec_exp_line_all line_hdr,
3311: (SELECT to_date, as_of_date FROM pn_rec_exp_line_all
3312: WHERE expense_line_id = p_expense_line_id) ref_line_hdr
3313: WHERE summary.expense_class_id = class.expense_class_id
3314: AND summary.expense_line_id = line_hdr.expense_line_id

Line 3311: (SELECT to_date, as_of_date FROM pn_rec_exp_line_all

3307: SELECT summary.expense_class_dtl_id
3308: FROM pn_rec_expcl_dtl_all summary,
3309: pn_rec_expcl_all class,
3310: pn_rec_exp_line_all line_hdr,
3311: (SELECT to_date, as_of_date FROM pn_rec_exp_line_all
3312: WHERE expense_line_id = p_expense_line_id) ref_line_hdr
3313: WHERE summary.expense_class_id = class.expense_class_id
3314: AND summary.expense_line_id = line_hdr.expense_line_id
3315: AND class.expense_class_id = p_expense_class_id

Line 3779: p_currency_code IN pn_rec_exp_line.currency_code%TYPE,

3775: p_property_code IN pn_properties.property_code%TYPE,
3776: p_as_of_date IN VARCHAR2,
3777: p_from_date IN VARCHAR2,
3778: p_to_date IN VARCHAR2,
3779: p_currency_code IN pn_rec_exp_line.currency_code%TYPE,
3780: p_pop_exp_class_dtl IN VARCHAR2,
3781: p_pop_area_class_dtl IN VARCHAR2,
3782: p_keep_override IN VARCHAR2,
3783: p_extract_code IN pn_rec_exp_line.expense_extract_code%TYPE,

Line 3783: p_extract_code IN pn_rec_exp_line.expense_extract_code%TYPE,

3779: p_currency_code IN pn_rec_exp_line.currency_code%TYPE,
3780: p_pop_exp_class_dtl IN VARCHAR2,
3781: p_pop_area_class_dtl IN VARCHAR2,
3782: p_keep_override IN VARCHAR2,
3783: p_extract_code IN pn_rec_exp_line.expense_extract_code%TYPE,
3784: p_called_from IN VARCHAR2)
3785: IS
3786: l_as_of_date DATE;
3787: l_from_date DATE;

Line 3789: l_currency pn_rec_exp_line.currency_code%TYPE;

3785: IS
3786: l_as_of_date DATE;
3787: l_from_date DATE;
3788: l_to_date DATE;
3789: l_currency pn_rec_exp_line.currency_code%TYPE;
3790: l_info VARCHAR2(300);
3791: l_desc VARCHAR2(100) := 'pn_recovery_extract_pkg.extract_line_expense_area' ;
3792: l_err VARCHAR2(100);
3793: l_location_id pn_locations.location_id%TYPE;

Line 3795: l_extract_code pn_rec_exp_line.expense_extract_code%TYPE;

3791: l_desc VARCHAR2(100) := 'pn_recovery_extract_pkg.extract_line_expense_area' ;
3792: l_err VARCHAR2(100);
3793: l_location_id pn_locations.location_id%TYPE;
3794: l_property_id pn_locations.property_id%TYPE;
3795: l_extract_code pn_rec_exp_line.expense_extract_code%TYPE;
3796:
3797: CURSOR derive_loc_id_from_loc_code IS
3798: SELECT location_id, property_id
3799: FROM pn_locations

Line 3946: p_extract_code IN pn_rec_exp_line.expense_extract_code%TYPE,

3942:
3943: PROCEDURE purge_expense_lines_itf_data(
3944: errbuf OUT NOCOPY VARCHAR2,
3945: retcode OUT NOCOPY VARCHAR2,
3946: p_extract_code IN pn_rec_exp_line.expense_extract_code%TYPE,
3947: p_location_code IN pn_locations.location_code%TYPE,
3948: p_property_code IN pn_properties.property_code%TYPE,
3949: p_from_date IN VARCHAR2,
3950: p_to_date IN VARCHAR2,

Line 3971: l_extract_code pn_rec_exp_line.expense_extract_code%TYPE;

3967: l_sqlhead VARCHAR2(300);
3968: l_sqltail VARCHAR2(900) := null;
3969: l_info VARCHAR2(300);
3970: l_desc VARCHAR2(100) := 'pn_recovery_extract_pkg.purge_expense_lines_itf_data' ;
3971: l_extract_code pn_rec_exp_line.expense_extract_code%TYPE;
3972: l_transfer_flag pn_rec_exp_itf.transfer_flag%TYPE;
3973: l_from_date DATE;
3974: l_to_date DATE;
3975: l_statement VARCHAR2(5000);

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

4002: IF p_extract_code IS NOT NULL THEN
4003:
4004: l_sqltail := ' expense_line_dtl_id IN ' ||
4005: '(SELECT dtl.expense_line_dtl_id ' ||
4006: ' FROM pn_rec_exp_line_all hdr, pn_rec_exp_line_dtl_all dtl ' ||
4007: ' WHERE hdr.expense_line_id = dtl.expense_line_id ' ||
4008: ' AND hdr.expense_extract_code = :l_extract_code)';
4009:
4010: END IF;