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_DTL

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