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_ITF

Line 1718: FUNCTION check_expense_type(p_exp_type_code pn_rec_exp_itf.expense_type_code%TYPE)

1714: -- HISTORY:
1715: -- 19-MAR-03 ftanudja o created
1716: ------------------------------------------------------------------------------+
1717:
1718: FUNCTION check_expense_type(p_exp_type_code pn_rec_exp_itf.expense_type_code%TYPE)
1719: RETURN BOOLEAN
1720: IS
1721: CURSOR type_check IS
1722: SELECT 'TRUE' FROM fnd_lookups

Line 1795: FUNCTION check_account_id(p_cc_id pn_rec_exp_itf.expense_account_id%TYPE)

1791: -- HISTORY:
1792: -- 19-MAR-03 ftanudja o created
1793: ------------------------------------------------------------------------------+
1794:
1795: FUNCTION check_account_id(p_cc_id pn_rec_exp_itf.expense_account_id%TYPE)
1796: RETURN BOOLEAN
1797: IS
1798: l_result BOOLEAN := FALSE;
1799: CURSOR ccid_check IS

Line 1858: p_transfer_flag OUT NOCOPY pn_rec_exp_itf.transfer_flag%TYPE,

1854: -- 15-JUL-05 SatyaDeep o Replaced base views with their _ALL tables
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,

Line 1862: p_expense_type_code pn_rec_exp_itf.expense_type_code%TYPE,

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,
1865: p_actual_amount pn_rec_exp_itf.actual_amount%TYPE,
1866: p_budgeted_amount pn_rec_exp_itf.budgeted_amount%TYPE,

Line 1863: p_expense_account_id pn_rec_exp_itf.expense_account_id%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,
1865: p_actual_amount pn_rec_exp_itf.actual_amount%TYPE,
1866: p_budgeted_amount pn_rec_exp_itf.budgeted_amount%TYPE,
1867: p_currency_code pn_rec_exp_itf.currency_code%TYPE,

Line 1864: p_account_description pn_rec_exp_itf.account_description%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,
1865: p_actual_amount pn_rec_exp_itf.actual_amount%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,

Line 1865: p_actual_amount pn_rec_exp_itf.actual_amount%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,
1865: p_actual_amount pn_rec_exp_itf.actual_amount%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,

Line 1866: p_budgeted_amount pn_rec_exp_itf.budgeted_amount%TYPE,

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,
1865: p_actual_amount pn_rec_exp_itf.actual_amount%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,

Line 1867: p_currency_code pn_rec_exp_itf.currency_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,
1865: p_actual_amount pn_rec_exp_itf.actual_amount%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,

Line 1868: p_location_id pn_rec_exp_itf.location_id%TYPE,

1864: p_account_description pn_rec_exp_itf.account_description%TYPE,
1865: p_actual_amount pn_rec_exp_itf.actual_amount%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,

Line 1869: p_property_id pn_rec_exp_itf.property_id%TYPE,

1865: p_actual_amount pn_rec_exp_itf.actual_amount%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,

Line 1876: p_attribute_category pn_rec_exp_itf.attribute_category%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,
1878: p_attribute2 pn_rec_exp_itf.attribute2%TYPE,
1879: p_attribute3 pn_rec_exp_itf.attribute3%TYPE,
1880: p_attribute4 pn_rec_exp_itf.attribute4%TYPE,

Line 1877: p_attribute1 pn_rec_exp_itf.attribute1%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,
1878: p_attribute2 pn_rec_exp_itf.attribute2%TYPE,
1879: p_attribute3 pn_rec_exp_itf.attribute3%TYPE,
1880: p_attribute4 pn_rec_exp_itf.attribute4%TYPE,
1881: p_attribute5 pn_rec_exp_itf.attribute5%TYPE,

Line 1878: p_attribute2 pn_rec_exp_itf.attribute2%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,
1878: p_attribute2 pn_rec_exp_itf.attribute2%TYPE,
1879: p_attribute3 pn_rec_exp_itf.attribute3%TYPE,
1880: p_attribute4 pn_rec_exp_itf.attribute4%TYPE,
1881: p_attribute5 pn_rec_exp_itf.attribute5%TYPE,
1882: p_attribute6 pn_rec_exp_itf.attribute6%TYPE,

Line 1879: p_attribute3 pn_rec_exp_itf.attribute3%TYPE,

1875: p_reextract BOOLEAN,
1876: p_attribute_category pn_rec_exp_itf.attribute_category%TYPE,
1877: p_attribute1 pn_rec_exp_itf.attribute1%TYPE,
1878: p_attribute2 pn_rec_exp_itf.attribute2%TYPE,
1879: p_attribute3 pn_rec_exp_itf.attribute3%TYPE,
1880: p_attribute4 pn_rec_exp_itf.attribute4%TYPE,
1881: p_attribute5 pn_rec_exp_itf.attribute5%TYPE,
1882: p_attribute6 pn_rec_exp_itf.attribute6%TYPE,
1883: p_attribute7 pn_rec_exp_itf.attribute7%TYPE,

Line 1880: p_attribute4 pn_rec_exp_itf.attribute4%TYPE,

1876: p_attribute_category pn_rec_exp_itf.attribute_category%TYPE,
1877: p_attribute1 pn_rec_exp_itf.attribute1%TYPE,
1878: p_attribute2 pn_rec_exp_itf.attribute2%TYPE,
1879: p_attribute3 pn_rec_exp_itf.attribute3%TYPE,
1880: p_attribute4 pn_rec_exp_itf.attribute4%TYPE,
1881: p_attribute5 pn_rec_exp_itf.attribute5%TYPE,
1882: p_attribute6 pn_rec_exp_itf.attribute6%TYPE,
1883: p_attribute7 pn_rec_exp_itf.attribute7%TYPE,
1884: p_attribute8 pn_rec_exp_itf.attribute8%TYPE,

Line 1881: p_attribute5 pn_rec_exp_itf.attribute5%TYPE,

1877: p_attribute1 pn_rec_exp_itf.attribute1%TYPE,
1878: p_attribute2 pn_rec_exp_itf.attribute2%TYPE,
1879: p_attribute3 pn_rec_exp_itf.attribute3%TYPE,
1880: p_attribute4 pn_rec_exp_itf.attribute4%TYPE,
1881: p_attribute5 pn_rec_exp_itf.attribute5%TYPE,
1882: p_attribute6 pn_rec_exp_itf.attribute6%TYPE,
1883: p_attribute7 pn_rec_exp_itf.attribute7%TYPE,
1884: p_attribute8 pn_rec_exp_itf.attribute8%TYPE,
1885: p_attribute9 pn_rec_exp_itf.attribute9%TYPE,

Line 1882: p_attribute6 pn_rec_exp_itf.attribute6%TYPE,

1878: p_attribute2 pn_rec_exp_itf.attribute2%TYPE,
1879: p_attribute3 pn_rec_exp_itf.attribute3%TYPE,
1880: p_attribute4 pn_rec_exp_itf.attribute4%TYPE,
1881: p_attribute5 pn_rec_exp_itf.attribute5%TYPE,
1882: p_attribute6 pn_rec_exp_itf.attribute6%TYPE,
1883: p_attribute7 pn_rec_exp_itf.attribute7%TYPE,
1884: p_attribute8 pn_rec_exp_itf.attribute8%TYPE,
1885: p_attribute9 pn_rec_exp_itf.attribute9%TYPE,
1886: p_attribute10 pn_rec_exp_itf.attribute10%TYPE,

Line 1883: p_attribute7 pn_rec_exp_itf.attribute7%TYPE,

1879: p_attribute3 pn_rec_exp_itf.attribute3%TYPE,
1880: p_attribute4 pn_rec_exp_itf.attribute4%TYPE,
1881: p_attribute5 pn_rec_exp_itf.attribute5%TYPE,
1882: p_attribute6 pn_rec_exp_itf.attribute6%TYPE,
1883: p_attribute7 pn_rec_exp_itf.attribute7%TYPE,
1884: p_attribute8 pn_rec_exp_itf.attribute8%TYPE,
1885: p_attribute9 pn_rec_exp_itf.attribute9%TYPE,
1886: p_attribute10 pn_rec_exp_itf.attribute10%TYPE,
1887: p_attribute11 pn_rec_exp_itf.attribute11%TYPE,

Line 1884: p_attribute8 pn_rec_exp_itf.attribute8%TYPE,

1880: p_attribute4 pn_rec_exp_itf.attribute4%TYPE,
1881: p_attribute5 pn_rec_exp_itf.attribute5%TYPE,
1882: p_attribute6 pn_rec_exp_itf.attribute6%TYPE,
1883: p_attribute7 pn_rec_exp_itf.attribute7%TYPE,
1884: p_attribute8 pn_rec_exp_itf.attribute8%TYPE,
1885: p_attribute9 pn_rec_exp_itf.attribute9%TYPE,
1886: p_attribute10 pn_rec_exp_itf.attribute10%TYPE,
1887: p_attribute11 pn_rec_exp_itf.attribute11%TYPE,
1888: p_attribute12 pn_rec_exp_itf.attribute12%TYPE,

Line 1885: p_attribute9 pn_rec_exp_itf.attribute9%TYPE,

1881: p_attribute5 pn_rec_exp_itf.attribute5%TYPE,
1882: p_attribute6 pn_rec_exp_itf.attribute6%TYPE,
1883: p_attribute7 pn_rec_exp_itf.attribute7%TYPE,
1884: p_attribute8 pn_rec_exp_itf.attribute8%TYPE,
1885: p_attribute9 pn_rec_exp_itf.attribute9%TYPE,
1886: p_attribute10 pn_rec_exp_itf.attribute10%TYPE,
1887: p_attribute11 pn_rec_exp_itf.attribute11%TYPE,
1888: p_attribute12 pn_rec_exp_itf.attribute12%TYPE,
1889: p_attribute13 pn_rec_exp_itf.attribute13%TYPE,

Line 1886: p_attribute10 pn_rec_exp_itf.attribute10%TYPE,

1882: p_attribute6 pn_rec_exp_itf.attribute6%TYPE,
1883: p_attribute7 pn_rec_exp_itf.attribute7%TYPE,
1884: p_attribute8 pn_rec_exp_itf.attribute8%TYPE,
1885: p_attribute9 pn_rec_exp_itf.attribute9%TYPE,
1886: p_attribute10 pn_rec_exp_itf.attribute10%TYPE,
1887: p_attribute11 pn_rec_exp_itf.attribute11%TYPE,
1888: p_attribute12 pn_rec_exp_itf.attribute12%TYPE,
1889: p_attribute13 pn_rec_exp_itf.attribute13%TYPE,
1890: p_attribute14 pn_rec_exp_itf.attribute14%TYPE,

Line 1887: p_attribute11 pn_rec_exp_itf.attribute11%TYPE,

1883: p_attribute7 pn_rec_exp_itf.attribute7%TYPE,
1884: p_attribute8 pn_rec_exp_itf.attribute8%TYPE,
1885: p_attribute9 pn_rec_exp_itf.attribute9%TYPE,
1886: p_attribute10 pn_rec_exp_itf.attribute10%TYPE,
1887: p_attribute11 pn_rec_exp_itf.attribute11%TYPE,
1888: p_attribute12 pn_rec_exp_itf.attribute12%TYPE,
1889: p_attribute13 pn_rec_exp_itf.attribute13%TYPE,
1890: p_attribute14 pn_rec_exp_itf.attribute14%TYPE,
1891: p_attribute15 pn_rec_exp_itf.attribute15%TYPE)

Line 1888: p_attribute12 pn_rec_exp_itf.attribute12%TYPE,

1884: p_attribute8 pn_rec_exp_itf.attribute8%TYPE,
1885: p_attribute9 pn_rec_exp_itf.attribute9%TYPE,
1886: p_attribute10 pn_rec_exp_itf.attribute10%TYPE,
1887: p_attribute11 pn_rec_exp_itf.attribute11%TYPE,
1888: p_attribute12 pn_rec_exp_itf.attribute12%TYPE,
1889: p_attribute13 pn_rec_exp_itf.attribute13%TYPE,
1890: p_attribute14 pn_rec_exp_itf.attribute14%TYPE,
1891: p_attribute15 pn_rec_exp_itf.attribute15%TYPE)
1892: IS

Line 1889: p_attribute13 pn_rec_exp_itf.attribute13%TYPE,

1885: p_attribute9 pn_rec_exp_itf.attribute9%TYPE,
1886: p_attribute10 pn_rec_exp_itf.attribute10%TYPE,
1887: p_attribute11 pn_rec_exp_itf.attribute11%TYPE,
1888: p_attribute12 pn_rec_exp_itf.attribute12%TYPE,
1889: p_attribute13 pn_rec_exp_itf.attribute13%TYPE,
1890: p_attribute14 pn_rec_exp_itf.attribute14%TYPE,
1891: p_attribute15 pn_rec_exp_itf.attribute15%TYPE)
1892: IS
1893: l_desc VARCHAR2(100) := 'pn_recovery_extract_pkg.validate_and_process_lines' ;

Line 1890: p_attribute14 pn_rec_exp_itf.attribute14%TYPE,

1886: p_attribute10 pn_rec_exp_itf.attribute10%TYPE,
1887: p_attribute11 pn_rec_exp_itf.attribute11%TYPE,
1888: p_attribute12 pn_rec_exp_itf.attribute12%TYPE,
1889: p_attribute13 pn_rec_exp_itf.attribute13%TYPE,
1890: p_attribute14 pn_rec_exp_itf.attribute14%TYPE,
1891: p_attribute15 pn_rec_exp_itf.attribute15%TYPE)
1892: IS
1893: l_desc VARCHAR2(100) := 'pn_recovery_extract_pkg.validate_and_process_lines' ;
1894: l_info VARCHAR2(300);

Line 1891: p_attribute15 pn_rec_exp_itf.attribute15%TYPE)

1887: p_attribute11 pn_rec_exp_itf.attribute11%TYPE,
1888: p_attribute12 pn_rec_exp_itf.attribute12%TYPE,
1889: p_attribute13 pn_rec_exp_itf.attribute13%TYPE,
1890: p_attribute14 pn_rec_exp_itf.attribute14%TYPE,
1891: p_attribute15 pn_rec_exp_itf.attribute15%TYPE)
1892: IS
1893: l_desc VARCHAR2(100) := 'pn_recovery_extract_pkg.validate_and_process_lines' ;
1894: l_info VARCHAR2(300);
1895: l_is_valid BOOLEAN;

Line 2054: FROM pn_rec_exp_itf

2050: attribute12,
2051: attribute13,
2052: attribute14,
2053: attribute15
2054: FROM pn_rec_exp_itf
2055: WHERE transfer_flag = 'N'
2056: AND from_date = p_from_date
2057: AND to_date = p_to_date
2058: AND currency_code = p_currency_code

Line 2084: l_transfer_flag pn_rec_exp_itf.transfer_flag%TYPE;

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:
2088: BEGIN

Line 2172: UPDATE pn_rec_exp_itf

2168:
2169: l_info := ' updating interface table ';
2170: pnp_debug_pkg.log(l_info);
2171:
2172: UPDATE pn_rec_exp_itf
2173: SET transfer_flag = l_transfer_flag,
2174: expense_line_dtl_id = l_expense_line_dtl_id
2175: WHERE CURRENT OF get_itf_lines_info;
2176:

Line 3939: p_transfer_flag IN pn_rec_exp_itf.transfer_flag%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,
3939: p_transfer_flag IN pn_rec_exp_itf.transfer_flag%TYPE,
3940: p_delete_all_flag IN VARCHAR2)
3941: IS
3942:
3943: CURSOR derive_loc_id_from_loc_code IS

Line 3960: l_transfer_flag pn_rec_exp_itf.transfer_flag%TYPE;

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);
3964: l_cursor INTEGER;

Line 3975: DELETE pn_rec_exp_itf;

3971:
3972: IF p_delete_all_flag = 'Y' THEN
3973: l_info := ' purging everything ';
3974: pnp_debug_pkg.log(l_info);
3975: DELETE pn_rec_exp_itf;
3976: return;
3977: END IF;
3978: pnp_debug_pkg.log('p_extract_code='||p_extract_code);
3979: l_cursor := dbms_sql.open_cursor;

Line 3980: l_sqlhead := 'DELETE pn_rec_exp_itf WHERE ';

3976: return;
3977: END IF;
3978: pnp_debug_pkg.log('p_extract_code='||p_extract_code);
3979: l_cursor := dbms_sql.open_cursor;
3980: l_sqlhead := 'DELETE pn_rec_exp_itf WHERE ';
3981:
3982: l_info := ' figuring expense extract code';
3983: pnp_debug_pkg.log(l_info);
3984: l_extract_code := p_extract_code;