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_REC_CALC_PKG dependencies on PN_REC_PERIOD_LINES_ALL

Line 112: p_rec_calc_period_id pn_rec_period_lines_all.rec_calc_period_id%TYPE

108: ,p_error_code IN OUT NOCOPY NUMBER
109: );
110:
111: FUNCTION get_recoverable_area (
112: p_rec_calc_period_id pn_rec_period_lines_all.rec_calc_period_id%TYPE
113: ,p_rec_agr_line_id pn_rec_period_lines_all.rec_agr_line_id%TYPE
114: )
115: RETURN pn_rec_period_lines_all.recoverable_area%TYPE;
116:

Line 113: ,p_rec_agr_line_id pn_rec_period_lines_all.rec_agr_line_id%TYPE

109: );
110:
111: FUNCTION get_recoverable_area (
112: p_rec_calc_period_id pn_rec_period_lines_all.rec_calc_period_id%TYPE
113: ,p_rec_agr_line_id pn_rec_period_lines_all.rec_agr_line_id%TYPE
114: )
115: RETURN pn_rec_period_lines_all.recoverable_area%TYPE;
116:
117: PROCEDURE get_line_expenses (

Line 115: RETURN pn_rec_period_lines_all.recoverable_area%TYPE;

111: FUNCTION get_recoverable_area (
112: p_rec_calc_period_id pn_rec_period_lines_all.rec_calc_period_id%TYPE
113: ,p_rec_agr_line_id pn_rec_period_lines_all.rec_agr_line_id%TYPE
114: )
115: RETURN pn_rec_period_lines_all.recoverable_area%TYPE;
116:
117: PROCEDURE get_line_expenses (
118: p_rec_agr_line_id IN NUMBER
119: ,p_customer_id IN NUMBER

Line 142: RETURN pn_rec_period_lines_all.actual_recovery%TYPE;

138: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
139: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
140: ,p_called_from VARCHAR2 DEFAULT 'CALCUI'
141: )
142: RETURN pn_rec_period_lines_all.actual_recovery%TYPE;
143:
144: FUNCTION get_budget_expenses (
145: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE
146: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE

Line 191: RETURN pn_rec_period_lines_all.billed_recovery%TYPE;

187: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
188: ,p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE
189: ,p_rec_calc_period_id pn_rec_calc_periods_all.rec_calc_period_id%TYPE
190: )
191: RETURN pn_rec_period_lines_all.billed_recovery%TYPE;
192:
193: FUNCTION get_line_constraints (
194: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE
195: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE

Line 206: p_rec_agr_line_id pn_rec_period_lines_all.rec_agr_line_id%TYPE

202: )
203: RETURN pn_rec_agr_linabat_all.amount%TYPE;
204:
205: FUNCTION find_if_period_line_exists (
206: p_rec_agr_line_id pn_rec_period_lines_all.rec_agr_line_id%TYPE
207: ,p_rec_calc_period_id pn_rec_period_lines_all.rec_calc_period_id%TYPE
208: )
209: RETURN pn_rec_period_lines_all.rec_period_lines_id%TYPE;
210:

Line 207: ,p_rec_calc_period_id pn_rec_period_lines_all.rec_calc_period_id%TYPE

203: RETURN pn_rec_agr_linabat_all.amount%TYPE;
204:
205: FUNCTION find_if_period_line_exists (
206: p_rec_agr_line_id pn_rec_period_lines_all.rec_agr_line_id%TYPE
207: ,p_rec_calc_period_id pn_rec_period_lines_all.rec_calc_period_id%TYPE
208: )
209: RETURN pn_rec_period_lines_all.rec_period_lines_id%TYPE;
210:
211: procedure INSERT_PERIOD_LINES_ROW (

Line 209: RETURN pn_rec_period_lines_all.rec_period_lines_id%TYPE;

205: FUNCTION find_if_period_line_exists (
206: p_rec_agr_line_id pn_rec_period_lines_all.rec_agr_line_id%TYPE
207: ,p_rec_calc_period_id pn_rec_period_lines_all.rec_calc_period_id%TYPE
208: )
209: RETURN pn_rec_period_lines_all.rec_period_lines_id%TYPE;
210:
211: procedure INSERT_PERIOD_LINES_ROW (
212: X_ROWID in out NOCOPY VARCHAR2
213: ,X_REC_PERIOD_LINES_ID in out NOCOPY NUMBER

Line 347: p_rec_agr_line_id pn_rec_period_lines_all.rec_agr_line_id%TYPE

343: )
344: RETURN period_bill_record;
345:
346: FUNCTION get_prior_period_actual_amount(
347: p_rec_agr_line_id pn_rec_period_lines_all.rec_agr_line_id%TYPE
348: ,p_start_date pn_rec_calc_periods_all.start_date%TYPE
349: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE DEFAULT NULL
350: ,p_called_from VARCHAR2 DEFAULT 'CALCUI'
351: )

Line 352: RETURN pn_rec_period_lines_all.constrained_actual%TYPE;

348: ,p_start_date pn_rec_calc_periods_all.start_date%TYPE
349: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE DEFAULT NULL
350: ,p_called_from VARCHAR2 DEFAULT 'CALCUI'
351: )
352: RETURN pn_rec_period_lines_all.constrained_actual%TYPE;
353:
354: FUNCTION get_prior_period_cap(
355: p_rec_agr_line_id pn_rec_period_lines_all.rec_agr_line_id%TYPE
356: ,p_start_date pn_rec_calc_periods_all.start_date%TYPE

Line 355: p_rec_agr_line_id pn_rec_period_lines_all.rec_agr_line_id%TYPE

351: )
352: RETURN pn_rec_period_lines_all.constrained_actual%TYPE;
353:
354: FUNCTION get_prior_period_cap(
355: p_rec_agr_line_id pn_rec_period_lines_all.rec_agr_line_id%TYPE
356: ,p_start_date pn_rec_calc_periods_all.start_date%TYPE
357: ,p_end_date pn_rec_calc_periods_all.end_date%TYPE
358: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
359: ,p_called_from VARCHAR2 DEFAULT 'CALCUI'

Line 361: RETURN pn_rec_period_lines_all.actual_recovery%TYPE;

357: ,p_end_date pn_rec_calc_periods_all.end_date%TYPE
358: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
359: ,p_called_from VARCHAR2 DEFAULT 'CALCUI'
360: )
361: RETURN pn_rec_period_lines_all.actual_recovery%TYPE;
362:
363: PROCEDURE lock_area_exp_cls_dtl( p_payment_term_id IN pn_payment_terms_all.payment_term_id%TYPE);
364:
365: FUNCTION validate_create_calc_period(p_rec_agreement_id pn_rec_agreements_all.REC_AGREEMENT_ID%TYPE,