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_AGREEMENTS_ALL

Line 134: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE

130: );
131:
132: FUNCTION get_contr_actual_recovery (
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

Line 135: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE

131:
132: FUNCTION get_contr_actual_recovery (
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

Line 136: ,p_location_id pn_rec_agreements_all.location_id%TYPE

132: FUNCTION get_contr_actual_recovery (
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'

Line 146: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE

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

Line 147: ,p_lease_id pn_rec_agreements_all.lease_id%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
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

Line 148: ,p_location_id pn_rec_agreements_all.location_id%TYPE

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

Line 157: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE

153: RETURN pn_rec_expcl_dtlln_all.budgeted_amt%TYPE;
154:
155: FUNCTION get_tot_prop_area (
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

Line 158: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE

154:
155: FUNCTION get_tot_prop_area (
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

Line 159: ,p_location_id pn_rec_agreements_all.location_id%TYPE

155: FUNCTION get_tot_prop_area (
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: )

Line 168: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE

164: RETURN pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;
165:
166: FUNCTION ten_recoverable_area (
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

Line 169: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE

165:
166: FUNCTION ten_recoverable_area (
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

Line 170: ,p_location_id pn_rec_agreements_all.location_id%TYPE

166: FUNCTION ten_recoverable_area (
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: )

Line 184: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE

180:
181: FUNCTION get_billed_recovery (
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

Line 185: ,p_location_id pn_rec_agreements_all.location_id%TYPE

181: FUNCTION get_billed_recovery (
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

Line 365: FUNCTION validate_create_calc_period(p_rec_agreement_id pn_rec_agreements_all.REC_AGREEMENT_ID%TYPE,

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