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_CALC_PERIODS_ALL

Line 5: g_calc_period_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE;

1: package PN_REC_CALC_PKG as
2: /* $Header: PNRECALS.pls 120.0.12010000.2 2008/09/04 12:26:31 mumohan ship $ */
3:
4: g_rec_agr_line_id pn_rec_agr_linconst_all.rec_agr_line_id%TYPE;
5: g_calc_period_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE;
6:
7: g_ext_precision number;
8: g_min_acct_unit number;
9: g_currency_code gl_sets_of_books.currency_code%type;

Line 137: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE

133: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE
134: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE
135: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
136: ,p_location_id pn_rec_agreements_all.location_id%TYPE
137: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%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: )

Line 138: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE

134: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE
135: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
136: ,p_location_id pn_rec_agreements_all.location_id%TYPE
137: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%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;

Line 139: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE

135: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
136: ,p_location_id pn_rec_agreements_all.location_id%TYPE
137: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%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:

Line 149: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE

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
147: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
148: ,p_location_id pn_rec_agreements_all.location_id%TYPE
149: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
150: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
151: ,p_calc_period_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
152: )
153: RETURN pn_rec_expcl_dtlln_all.budgeted_amt%TYPE;

Line 150: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE

146: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE
147: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
148: ,p_location_id pn_rec_agreements_all.location_id%TYPE
149: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
150: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
151: ,p_calc_period_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
152: )
153: RETURN pn_rec_expcl_dtlln_all.budgeted_amt%TYPE;
154:

Line 151: ,p_calc_period_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE

147: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
148: ,p_location_id pn_rec_agreements_all.location_id%TYPE
149: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
150: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
151: ,p_calc_period_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
152: )
153: RETURN pn_rec_expcl_dtlln_all.budgeted_amt%TYPE;
154:
155: FUNCTION get_tot_prop_area (

Line 160: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE

156: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE
157: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE
158: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
159: ,p_location_id pn_rec_agreements_all.location_id%TYPE
160: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
161: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
162: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
163: )
164: RETURN pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;

Line 161: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE

157: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE
158: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
159: ,p_location_id pn_rec_agreements_all.location_id%TYPE
160: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
161: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
162: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
163: )
164: RETURN pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;
165:

Line 162: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE

158: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
159: ,p_location_id pn_rec_agreements_all.location_id%TYPE
160: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
161: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
162: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
163: )
164: RETURN pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;
165:
166: FUNCTION ten_recoverable_area (

Line 171: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE

167: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE
168: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE
169: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
170: ,p_location_id pn_rec_agreements_all.location_id%TYPE
171: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
172: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
173: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
174: )
175: RETURN ten_recoverable_area_rec;

Line 172: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE

168: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE
169: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
170: ,p_location_id pn_rec_agreements_all.location_id%TYPE
171: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
172: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
173: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
174: )
175: RETURN ten_recoverable_area_rec;
176:

Line 173: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE

169: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
170: ,p_location_id pn_rec_agreements_all.location_id%TYPE
171: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
172: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
173: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
174: )
175: RETURN ten_recoverable_area_rec;
176:
177: -- 04-Nov-2003 Daniel Thota o Changed the where clause to account for multi-tenancy

Line 186: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE

182: p_payment_purpose pn_rec_agr_lines_all.purpose%TYPE
183: ,p_payment_type pn_rec_agr_lines_all.type%TYPE
184: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
185: ,p_location_id pn_rec_agreements_all.location_id%TYPE
186: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%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: )

Line 187: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE

183: ,p_payment_type pn_rec_agr_lines_all.type%TYPE
184: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
185: ,p_location_id pn_rec_agreements_all.location_id%TYPE
186: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%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;

Line 189: ,p_rec_calc_period_id pn_rec_calc_periods_all.rec_calc_period_id%TYPE

185: ,p_location_id pn_rec_agreements_all.location_id%TYPE
186: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%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 (

Line 195: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE

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
196: )
197: RETURN g_line_constr_type;
198:
199: FUNCTION get_line_abatements (

Line 201: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE

197: RETURN g_line_constr_type;
198:
199: FUNCTION get_line_abatements (
200: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE
201: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
202: )
203: RETURN pn_rec_agr_linabat_all.amount%TYPE;
204:
205: FUNCTION find_if_period_line_exists (

Line 348: ,p_start_date pn_rec_calc_periods_all.start_date%TYPE

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: )
352: RETURN pn_rec_period_lines_all.constrained_actual%TYPE;

Line 349: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE DEFAULT NULL

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: )
352: RETURN pn_rec_period_lines_all.constrained_actual%TYPE;
353:

Line 356: ,p_start_date pn_rec_calc_periods_all.start_date%TYPE

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'
360: )

Line 357: ,p_end_date pn_rec_calc_periods_all.end_date%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'
360: )
361: RETURN pn_rec_period_lines_all.actual_recovery%TYPE;

Line 358: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE

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'
360: )
361: RETURN pn_rec_period_lines_all.actual_recovery%TYPE;
362:

Line 366: p_start_date pn_rec_calc_periods_all.start_date%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,
366: p_start_date pn_rec_calc_periods_all.start_date%TYPE,
367: p_end_date pn_rec_calc_periods_all.end_date%TYPE,
368: p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE)
369: RETURN NUMBER;
370:

Line 367: p_end_date pn_rec_calc_periods_all.end_date%TYPE,

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,
366: p_start_date pn_rec_calc_periods_all.start_date%TYPE,
367: p_end_date pn_rec_calc_periods_all.end_date%TYPE,
368: p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE)
369: RETURN NUMBER;
370:
371: END PN_REC_CALC_PKG;

Line 368: p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE)

364:
365: FUNCTION validate_create_calc_period(p_rec_agreement_id pn_rec_agreements_all.REC_AGREEMENT_ID%TYPE,
366: p_start_date pn_rec_calc_periods_all.start_date%TYPE,
367: p_end_date pn_rec_calc_periods_all.end_date%TYPE,
368: p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE)
369: RETURN NUMBER;
370:
371: END PN_REC_CALC_PKG;