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.

[Home] [Help]

APPS.PN_RECOVERY_EXTRACT_PKG dependencies on PN_REC_EXP_LINE_DTL

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 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 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 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 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 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 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;