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 1730: FUNCTION check_expense_type(p_exp_type_code pn_rec_exp_itf.expense_type_code%TYPE)

1726: -- HISTORY:
1727: -- 19-MAR-03 ftanudja o created
1728: ------------------------------------------------------------------------------+
1729:
1730: FUNCTION check_expense_type(p_exp_type_code pn_rec_exp_itf.expense_type_code%TYPE)
1731: RETURN BOOLEAN
1732: IS
1733: CURSOR type_check IS
1734: SELECT 'TRUE' FROM fnd_lookups

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

1803: -- HISTORY:
1804: -- 19-MAR-03 ftanudja o created
1805: ------------------------------------------------------------------------------+
1806:
1807: FUNCTION check_account_id(p_cc_id pn_rec_exp_itf.expense_account_id%TYPE)
1808: RETURN BOOLEAN
1809: IS
1810: l_result BOOLEAN := FALSE;
1811: CURSOR ccid_check IS

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

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

Line 1874: p_expense_type_code pn_rec_exp_itf.expense_type_code%TYPE,

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

Line 1875: p_expense_account_id pn_rec_exp_itf.expense_account_id%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,
1877: p_actual_amount pn_rec_exp_itf.actual_amount%TYPE,
1878: p_budgeted_amount pn_rec_exp_itf.budgeted_amount%TYPE,
1879: p_currency_code pn_rec_exp_itf.currency_code%TYPE,

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

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

Line 1878: p_budgeted_amount pn_rec_exp_itf.budgeted_amount%TYPE,

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

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

Line 1880: p_location_id pn_rec_exp_itf.location_id%TYPE,

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

Line 1881: p_property_id pn_rec_exp_itf.property_id%TYPE,

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

Line 1888: p_attribute_category pn_rec_exp_itf.attribute_category%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,
1890: p_attribute2 pn_rec_exp_itf.attribute2%TYPE,
1891: p_attribute3 pn_rec_exp_itf.attribute3%TYPE,
1892: p_attribute4 pn_rec_exp_itf.attribute4%TYPE,

Line 1889: p_attribute1 pn_rec_exp_itf.attribute1%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,
1890: p_attribute2 pn_rec_exp_itf.attribute2%TYPE,
1891: p_attribute3 pn_rec_exp_itf.attribute3%TYPE,
1892: p_attribute4 pn_rec_exp_itf.attribute4%TYPE,
1893: p_attribute5 pn_rec_exp_itf.attribute5%TYPE,

Line 1890: p_attribute2 pn_rec_exp_itf.attribute2%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,
1890: p_attribute2 pn_rec_exp_itf.attribute2%TYPE,
1891: p_attribute3 pn_rec_exp_itf.attribute3%TYPE,
1892: p_attribute4 pn_rec_exp_itf.attribute4%TYPE,
1893: p_attribute5 pn_rec_exp_itf.attribute5%TYPE,
1894: p_attribute6 pn_rec_exp_itf.attribute6%TYPE,

Line 1891: p_attribute3 pn_rec_exp_itf.attribute3%TYPE,

1887: p_reextract BOOLEAN,
1888: p_attribute_category pn_rec_exp_itf.attribute_category%TYPE,
1889: p_attribute1 pn_rec_exp_itf.attribute1%TYPE,
1890: p_attribute2 pn_rec_exp_itf.attribute2%TYPE,
1891: p_attribute3 pn_rec_exp_itf.attribute3%TYPE,
1892: p_attribute4 pn_rec_exp_itf.attribute4%TYPE,
1893: p_attribute5 pn_rec_exp_itf.attribute5%TYPE,
1894: p_attribute6 pn_rec_exp_itf.attribute6%TYPE,
1895: p_attribute7 pn_rec_exp_itf.attribute7%TYPE,

Line 1892: p_attribute4 pn_rec_exp_itf.attribute4%TYPE,

1888: p_attribute_category pn_rec_exp_itf.attribute_category%TYPE,
1889: p_attribute1 pn_rec_exp_itf.attribute1%TYPE,
1890: p_attribute2 pn_rec_exp_itf.attribute2%TYPE,
1891: p_attribute3 pn_rec_exp_itf.attribute3%TYPE,
1892: p_attribute4 pn_rec_exp_itf.attribute4%TYPE,
1893: p_attribute5 pn_rec_exp_itf.attribute5%TYPE,
1894: p_attribute6 pn_rec_exp_itf.attribute6%TYPE,
1895: p_attribute7 pn_rec_exp_itf.attribute7%TYPE,
1896: p_attribute8 pn_rec_exp_itf.attribute8%TYPE,

Line 1893: p_attribute5 pn_rec_exp_itf.attribute5%TYPE,

1889: p_attribute1 pn_rec_exp_itf.attribute1%TYPE,
1890: p_attribute2 pn_rec_exp_itf.attribute2%TYPE,
1891: p_attribute3 pn_rec_exp_itf.attribute3%TYPE,
1892: p_attribute4 pn_rec_exp_itf.attribute4%TYPE,
1893: p_attribute5 pn_rec_exp_itf.attribute5%TYPE,
1894: p_attribute6 pn_rec_exp_itf.attribute6%TYPE,
1895: p_attribute7 pn_rec_exp_itf.attribute7%TYPE,
1896: p_attribute8 pn_rec_exp_itf.attribute8%TYPE,
1897: p_attribute9 pn_rec_exp_itf.attribute9%TYPE,

Line 1894: p_attribute6 pn_rec_exp_itf.attribute6%TYPE,

1890: p_attribute2 pn_rec_exp_itf.attribute2%TYPE,
1891: p_attribute3 pn_rec_exp_itf.attribute3%TYPE,
1892: p_attribute4 pn_rec_exp_itf.attribute4%TYPE,
1893: p_attribute5 pn_rec_exp_itf.attribute5%TYPE,
1894: p_attribute6 pn_rec_exp_itf.attribute6%TYPE,
1895: p_attribute7 pn_rec_exp_itf.attribute7%TYPE,
1896: p_attribute8 pn_rec_exp_itf.attribute8%TYPE,
1897: p_attribute9 pn_rec_exp_itf.attribute9%TYPE,
1898: p_attribute10 pn_rec_exp_itf.attribute10%TYPE,

Line 1895: p_attribute7 pn_rec_exp_itf.attribute7%TYPE,

1891: p_attribute3 pn_rec_exp_itf.attribute3%TYPE,
1892: p_attribute4 pn_rec_exp_itf.attribute4%TYPE,
1893: p_attribute5 pn_rec_exp_itf.attribute5%TYPE,
1894: p_attribute6 pn_rec_exp_itf.attribute6%TYPE,
1895: p_attribute7 pn_rec_exp_itf.attribute7%TYPE,
1896: p_attribute8 pn_rec_exp_itf.attribute8%TYPE,
1897: p_attribute9 pn_rec_exp_itf.attribute9%TYPE,
1898: p_attribute10 pn_rec_exp_itf.attribute10%TYPE,
1899: p_attribute11 pn_rec_exp_itf.attribute11%TYPE,

Line 1896: p_attribute8 pn_rec_exp_itf.attribute8%TYPE,

1892: p_attribute4 pn_rec_exp_itf.attribute4%TYPE,
1893: p_attribute5 pn_rec_exp_itf.attribute5%TYPE,
1894: p_attribute6 pn_rec_exp_itf.attribute6%TYPE,
1895: p_attribute7 pn_rec_exp_itf.attribute7%TYPE,
1896: p_attribute8 pn_rec_exp_itf.attribute8%TYPE,
1897: p_attribute9 pn_rec_exp_itf.attribute9%TYPE,
1898: p_attribute10 pn_rec_exp_itf.attribute10%TYPE,
1899: p_attribute11 pn_rec_exp_itf.attribute11%TYPE,
1900: p_attribute12 pn_rec_exp_itf.attribute12%TYPE,

Line 1897: p_attribute9 pn_rec_exp_itf.attribute9%TYPE,

1893: p_attribute5 pn_rec_exp_itf.attribute5%TYPE,
1894: p_attribute6 pn_rec_exp_itf.attribute6%TYPE,
1895: p_attribute7 pn_rec_exp_itf.attribute7%TYPE,
1896: p_attribute8 pn_rec_exp_itf.attribute8%TYPE,
1897: p_attribute9 pn_rec_exp_itf.attribute9%TYPE,
1898: p_attribute10 pn_rec_exp_itf.attribute10%TYPE,
1899: p_attribute11 pn_rec_exp_itf.attribute11%TYPE,
1900: p_attribute12 pn_rec_exp_itf.attribute12%TYPE,
1901: p_attribute13 pn_rec_exp_itf.attribute13%TYPE,

Line 1898: p_attribute10 pn_rec_exp_itf.attribute10%TYPE,

1894: p_attribute6 pn_rec_exp_itf.attribute6%TYPE,
1895: p_attribute7 pn_rec_exp_itf.attribute7%TYPE,
1896: p_attribute8 pn_rec_exp_itf.attribute8%TYPE,
1897: p_attribute9 pn_rec_exp_itf.attribute9%TYPE,
1898: p_attribute10 pn_rec_exp_itf.attribute10%TYPE,
1899: p_attribute11 pn_rec_exp_itf.attribute11%TYPE,
1900: p_attribute12 pn_rec_exp_itf.attribute12%TYPE,
1901: p_attribute13 pn_rec_exp_itf.attribute13%TYPE,
1902: p_attribute14 pn_rec_exp_itf.attribute14%TYPE,

Line 1899: p_attribute11 pn_rec_exp_itf.attribute11%TYPE,

1895: p_attribute7 pn_rec_exp_itf.attribute7%TYPE,
1896: p_attribute8 pn_rec_exp_itf.attribute8%TYPE,
1897: p_attribute9 pn_rec_exp_itf.attribute9%TYPE,
1898: p_attribute10 pn_rec_exp_itf.attribute10%TYPE,
1899: p_attribute11 pn_rec_exp_itf.attribute11%TYPE,
1900: p_attribute12 pn_rec_exp_itf.attribute12%TYPE,
1901: p_attribute13 pn_rec_exp_itf.attribute13%TYPE,
1902: p_attribute14 pn_rec_exp_itf.attribute14%TYPE,
1903: p_attribute15 pn_rec_exp_itf.attribute15%TYPE)

Line 1900: p_attribute12 pn_rec_exp_itf.attribute12%TYPE,

1896: p_attribute8 pn_rec_exp_itf.attribute8%TYPE,
1897: p_attribute9 pn_rec_exp_itf.attribute9%TYPE,
1898: p_attribute10 pn_rec_exp_itf.attribute10%TYPE,
1899: p_attribute11 pn_rec_exp_itf.attribute11%TYPE,
1900: p_attribute12 pn_rec_exp_itf.attribute12%TYPE,
1901: p_attribute13 pn_rec_exp_itf.attribute13%TYPE,
1902: p_attribute14 pn_rec_exp_itf.attribute14%TYPE,
1903: p_attribute15 pn_rec_exp_itf.attribute15%TYPE)
1904: IS

Line 1901: p_attribute13 pn_rec_exp_itf.attribute13%TYPE,

1897: p_attribute9 pn_rec_exp_itf.attribute9%TYPE,
1898: p_attribute10 pn_rec_exp_itf.attribute10%TYPE,
1899: p_attribute11 pn_rec_exp_itf.attribute11%TYPE,
1900: p_attribute12 pn_rec_exp_itf.attribute12%TYPE,
1901: p_attribute13 pn_rec_exp_itf.attribute13%TYPE,
1902: p_attribute14 pn_rec_exp_itf.attribute14%TYPE,
1903: p_attribute15 pn_rec_exp_itf.attribute15%TYPE)
1904: IS
1905: l_desc VARCHAR2(100) := 'pn_recovery_extract_pkg.validate_and_process_lines' ;

Line 1902: p_attribute14 pn_rec_exp_itf.attribute14%TYPE,

1898: p_attribute10 pn_rec_exp_itf.attribute10%TYPE,
1899: p_attribute11 pn_rec_exp_itf.attribute11%TYPE,
1900: p_attribute12 pn_rec_exp_itf.attribute12%TYPE,
1901: p_attribute13 pn_rec_exp_itf.attribute13%TYPE,
1902: p_attribute14 pn_rec_exp_itf.attribute14%TYPE,
1903: p_attribute15 pn_rec_exp_itf.attribute15%TYPE)
1904: IS
1905: l_desc VARCHAR2(100) := 'pn_recovery_extract_pkg.validate_and_process_lines' ;
1906: l_info VARCHAR2(300);

Line 1903: p_attribute15 pn_rec_exp_itf.attribute15%TYPE)

1899: p_attribute11 pn_rec_exp_itf.attribute11%TYPE,
1900: p_attribute12 pn_rec_exp_itf.attribute12%TYPE,
1901: p_attribute13 pn_rec_exp_itf.attribute13%TYPE,
1902: p_attribute14 pn_rec_exp_itf.attribute14%TYPE,
1903: p_attribute15 pn_rec_exp_itf.attribute15%TYPE)
1904: IS
1905: l_desc VARCHAR2(100) := 'pn_recovery_extract_pkg.validate_and_process_lines' ;
1906: l_info VARCHAR2(300);
1907: l_is_valid BOOLEAN;

Line 2066: FROM pn_rec_exp_itf

2062: attribute12,
2063: attribute13,
2064: attribute14,
2065: attribute15
2066: FROM pn_rec_exp_itf
2067: WHERE transfer_flag = 'N'
2068: AND from_date = p_from_date
2069: AND to_date = p_to_date
2070: AND currency_code = p_currency_code

Line 2096: l_transfer_flag pn_rec_exp_itf.transfer_flag%TYPE;

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

Line 2184: UPDATE pn_rec_exp_itf

2180:
2181: l_info := ' updating interface table ';
2182: pnp_debug_pkg.log(l_info);
2183:
2184: UPDATE pn_rec_exp_itf
2185: SET transfer_flag = l_transfer_flag,
2186: expense_line_dtl_id = l_expense_line_dtl_id
2187: WHERE CURRENT OF get_itf_lines_info;
2188:

Line 3951: p_transfer_flag IN pn_rec_exp_itf.transfer_flag%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,
3951: p_transfer_flag IN pn_rec_exp_itf.transfer_flag%TYPE,
3952: p_delete_all_flag IN VARCHAR2)
3953: IS
3954:
3955: CURSOR derive_loc_id_from_loc_code IS

Line 3972: l_transfer_flag pn_rec_exp_itf.transfer_flag%TYPE;

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

Line 3987: DELETE pn_rec_exp_itf;

3983:
3984: IF p_delete_all_flag = 'Y' THEN
3985: l_info := ' purging everything ';
3986: pnp_debug_pkg.log(l_info);
3987: DELETE pn_rec_exp_itf;
3988: return;
3989: END IF;
3990: pnp_debug_pkg.log('p_extract_code='||p_extract_code);
3991: l_cursor := dbms_sql.open_cursor;

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

3988: return;
3989: END IF;
3990: pnp_debug_pkg.log('p_extract_code='||p_extract_code);
3991: l_cursor := dbms_sql.open_cursor;
3992: l_sqlhead := 'DELETE pn_rec_exp_itf WHERE ';
3993:
3994: l_info := ' figuring expense extract code';
3995: pnp_debug_pkg.log(l_info);
3996: l_extract_code := p_extract_code;