DBA Data[Home] [Help]

APPS.PN_REC_CALC_PKG dependencies on PN_REC_AGR_LINES_ALL

Line 133: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE

129: ,p_error_code IN OUT NOCOPY NUMBER
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

Line 145: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE

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

Line 156: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE

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

Line 167: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE

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

Line 182: p_payment_purpose pn_rec_agr_lines_all.purpose%TYPE

178: -- so that billing terms of a lease are now associated with a location.
179: -- Added a new parameter p_location_id for the function
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

Line 183: ,p_payment_type pn_rec_agr_lines_all.type%TYPE

179: -- Added a new parameter p_location_id for the function
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

Line 188: ,p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%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;
192:

Line 194: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_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
196: )
197: RETURN g_line_constr_type;
198:

Line 200: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE

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