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 81: l_start_date pn_rec_calc_periods_all.start_date%TYPE;

77: l_location_id pn_rec_agreements_all.location_id%TYPE := NULL;
78: l_customer_id pn_rec_agreements_all.customer_id%TYPE := NULL;
79: l_cust_site_id pn_rec_agreements_all.cust_site_id%TYPE := NULL;
80:
81: l_start_date pn_rec_calc_periods_all.start_date%TYPE;
82: l_end_date pn_rec_calc_periods_all.end_date%TYPE ;
83: l_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE ;
84: l_calc_period_ending pn_rec_calc_periods_all.end_date%TYPE :=
85: trunc(fnd_date.canonical_to_date(p_calc_period_ending));

Line 82: l_end_date pn_rec_calc_periods_all.end_date%TYPE ;

78: l_customer_id pn_rec_agreements_all.customer_id%TYPE := NULL;
79: l_cust_site_id pn_rec_agreements_all.cust_site_id%TYPE := NULL;
80:
81: l_start_date pn_rec_calc_periods_all.start_date%TYPE;
82: l_end_date pn_rec_calc_periods_all.end_date%TYPE ;
83: l_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE ;
84: l_calc_period_ending pn_rec_calc_periods_all.end_date%TYPE :=
85: trunc(fnd_date.canonical_to_date(p_calc_period_ending));
86:

Line 83: l_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE ;

79: l_cust_site_id pn_rec_agreements_all.cust_site_id%TYPE := NULL;
80:
81: l_start_date pn_rec_calc_periods_all.start_date%TYPE;
82: l_end_date pn_rec_calc_periods_all.end_date%TYPE ;
83: l_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE ;
84: l_calc_period_ending pn_rec_calc_periods_all.end_date%TYPE :=
85: trunc(fnd_date.canonical_to_date(p_calc_period_ending));
86:
87: l_error VARCHAR2(2000) := 'Success';

Line 84: l_calc_period_ending pn_rec_calc_periods_all.end_date%TYPE :=

80:
81: l_start_date pn_rec_calc_periods_all.start_date%TYPE;
82: l_end_date pn_rec_calc_periods_all.end_date%TYPE ;
83: l_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE ;
84: l_calc_period_ending pn_rec_calc_periods_all.end_date%TYPE :=
85: trunc(fnd_date.canonical_to_date(p_calc_period_ending));
86:
87: l_error VARCHAR2(2000) := 'Success';
88: l_error_code NUMBER := 0;

Line 121: ,pn_rec_calc_periods_all prc

117: ,prc.as_of_date
118: ,prc.rec_calc_period_id
119: FROM pn_leases pl
120: ,pn_rec_agreements_all pra
121: ,pn_rec_calc_periods_all prc
122: ,pn_locations_all ploc
123: WHERE pl.lease_id = pra.lease_id
124: AND pra.customer_id = nvl(p_customer_id,pra.customer_id)
125: AND pra.cust_site_id = nvl(p_cust_site_id,pra.cust_site_id)

Line 151: ,pn_rec_calc_periods_all prc

147: ,prc.as_of_date
148: ,prc.rec_calc_period_id
149: FROM pn_leases pl
150: ,pn_rec_agreements_all pra
151: ,pn_rec_calc_periods_all prc
152: WHERE pl.lease_id = pra.lease_id
153: AND pra.customer_id = nvl(p_customer_id,pra.customer_id)
154: AND pra.cust_site_id = nvl(p_cust_site_id,pra.cust_site_id)
155: AND pra.rec_agreement_id = prc.rec_agreement_id

Line 177: ,pn_rec_calc_periods_all prc

173: ,prc.as_of_date
174: ,prc.rec_calc_period_id
175: FROM pn_leases pl
176: ,pn_rec_agreements_all pra
177: ,pn_rec_calc_periods_all prc
178: ,pn_locations_all ploc
179: ,pn_properties_all prop
180: WHERE pl.lease_id = pra.lease_id
181: AND pra.customer_id = nvl(p_customer_id,pra.customer_id)

Line 210: ,pn_rec_calc_periods_all prc

206: ,prc.as_of_date
207: ,prc.rec_calc_period_id
208: FROM pn_leases pl
209: ,pn_rec_agreements_all pra
210: ,pn_rec_calc_periods_all prc
211: ,pn_locations_all ploc
212: ,pn_properties_all prop
213: WHERE pl.lease_id = pra.lease_id
214: AND pra.customer_id = nvl(p_customer_id,pra.customer_id)

Line 232: l_rec_calc_period_id pn_rec_calc_periods_all.rec_calc_period_id%TYPE;

228:
229: l_processed NUMBER := 0;
230: l_success_count NUMBER := 0;
231: l_fail_count NUMBER := 0;
232: l_rec_calc_period_id pn_rec_calc_periods_all.rec_calc_period_id%TYPE;
233:
234: BEGIN
235:
236: pnp_debug_pkg.log('PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT_BATCH (+) ');

Line 519: l_start_date pn_rec_calc_periods_all.start_date%TYPE := fnd_date.canonical_to_date(p_calc_period_startdate); --Bug#6438840

515: l_lease_id pn_rec_agreements_all.lease_id%TYPE := NULL;
516: l_location_id pn_rec_agreements_all.location_id%TYPE := NULL;
517: l_customer_id pn_rec_agreements_all.customer_id%TYPE := NULL;
518: l_cust_site_id pn_rec_agreements_all.cust_site_id%TYPE := NULL;
519: l_start_date pn_rec_calc_periods_all.start_date%TYPE := fnd_date.canonical_to_date(p_calc_period_startdate); --Bug#6438840
520: l_end_date pn_rec_calc_periods_all.end_date%TYPE := fnd_date.canonical_to_date(p_calc_period_enddate); --Bug#6438840
521: l_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE := fnd_date.canonical_to_date(p_as_ofdate); --Bug#6438840
522: l_calc_period_ending pn_rec_calc_periods_all.end_date%TYPE :=
523: trunc(fnd_date.canonical_to_date(p_calc_period_ending));

Line 520: l_end_date pn_rec_calc_periods_all.end_date%TYPE := fnd_date.canonical_to_date(p_calc_period_enddate); --Bug#6438840

516: l_location_id pn_rec_agreements_all.location_id%TYPE := NULL;
517: l_customer_id pn_rec_agreements_all.customer_id%TYPE := NULL;
518: l_cust_site_id pn_rec_agreements_all.cust_site_id%TYPE := NULL;
519: l_start_date pn_rec_calc_periods_all.start_date%TYPE := fnd_date.canonical_to_date(p_calc_period_startdate); --Bug#6438840
520: l_end_date pn_rec_calc_periods_all.end_date%TYPE := fnd_date.canonical_to_date(p_calc_period_enddate); --Bug#6438840
521: l_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE := fnd_date.canonical_to_date(p_as_ofdate); --Bug#6438840
522: l_calc_period_ending pn_rec_calc_periods_all.end_date%TYPE :=
523: trunc(fnd_date.canonical_to_date(p_calc_period_ending));
524:

Line 521: l_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE := fnd_date.canonical_to_date(p_as_ofdate); --Bug#6438840

517: l_customer_id pn_rec_agreements_all.customer_id%TYPE := NULL;
518: l_cust_site_id pn_rec_agreements_all.cust_site_id%TYPE := NULL;
519: l_start_date pn_rec_calc_periods_all.start_date%TYPE := fnd_date.canonical_to_date(p_calc_period_startdate); --Bug#6438840
520: l_end_date pn_rec_calc_periods_all.end_date%TYPE := fnd_date.canonical_to_date(p_calc_period_enddate); --Bug#6438840
521: l_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE := fnd_date.canonical_to_date(p_as_ofdate); --Bug#6438840
522: l_calc_period_ending pn_rec_calc_periods_all.end_date%TYPE :=
523: trunc(fnd_date.canonical_to_date(p_calc_period_ending));
524:
525: l_error VARCHAR2(2000) := 'Success';

Line 522: l_calc_period_ending pn_rec_calc_periods_all.end_date%TYPE :=

518: l_cust_site_id pn_rec_agreements_all.cust_site_id%TYPE := NULL;
519: l_start_date pn_rec_calc_periods_all.start_date%TYPE := fnd_date.canonical_to_date(p_calc_period_startdate); --Bug#6438840
520: l_end_date pn_rec_calc_periods_all.end_date%TYPE := fnd_date.canonical_to_date(p_calc_period_enddate); --Bug#6438840
521: l_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE := fnd_date.canonical_to_date(p_as_ofdate); --Bug#6438840
522: l_calc_period_ending pn_rec_calc_periods_all.end_date%TYPE :=
523: trunc(fnd_date.canonical_to_date(p_calc_period_ending));
524:
525: l_error VARCHAR2(2000) := 'Success';
526: l_error_code NUMBER := 0;

Line 615: l_rec_calc_period_id pn_rec_calc_periods_all.rec_calc_period_id%TYPE;

611:
612: l_processed NUMBER := 0;
613: l_success_count NUMBER := 0;
614: l_fail_count NUMBER := 0;
615: l_rec_calc_period_id pn_rec_calc_periods_all.rec_calc_period_id%TYPE;
616:
617: BEGIN
618:
619: pnp_debug_pkg.log('PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT_BATCH (+) ');

Line 923: ,pn_rec_calc_periods_all calc_periods

919: FROM DUAL
920: WHERE exists (SELECT NULL
921: FROM pn_rec_period_lines_all plines
922: ,pn_rec_agr_lines_all lines
923: ,pn_rec_calc_periods_all calc_periods
924: WHERE lines.rec_agreement_id = p_rec_agreement_id
925: AND p_as_of_date between lines.start_date and lines.end_date
926: AND plines.rec_agr_line_id = lines.rec_agr_line_id
927: AND plines.start_date = p_calc_period_start_date

Line 942: ,pn_rec_calc_periods_all calc_periods

938: FROM DUAL
939: WHERE not exists (SELECT NULL
940: FROM pn_rec_period_lines_all plines
941: ,pn_rec_agr_lines_all lines
942: ,pn_rec_calc_periods_all calc_periods
943: WHERE lines.rec_agreement_id = p_rec_agreement_id
944: AND p_as_of_date between lines.start_date and lines.end_date
945: AND plines.rec_agr_line_id = lines.rec_agr_line_id
946: AND plines.start_date = p_calc_period_start_date

Line 961: ,pn_rec_calc_periods_all calc_periods

957:
958: CURSOR calc_all_cons IS
959: SELECT NVL(SUM(NVL(plines.reconciled_amount,0)),0) RECONCILED_AMOUNT
960: FROM pn_rec_period_lines_all plines
961: ,pn_rec_calc_periods_all calc_periods
962: ,pn_rec_agr_lines_all lines
963: WHERE lines.rec_agreement_id = p_rec_agreement_id
964: AND plines.rec_agr_line_id = lines.rec_agr_line_id
965: AND plines.start_date = p_calc_period_start_date

Line 981: ,pn_rec_calc_periods_all calc_periods

977: ,NVL(plines.reconciled_amount,0) RECONCILED_AMOUNT
978: ,plines.billing_type
979: ,plines.billing_purpose
980: FROM pn_rec_period_lines_all plines
981: ,pn_rec_calc_periods_all calc_periods
982: ,pn_rec_agr_lines_all lines
983: WHERE lines.rec_agreement_id = p_rec_agreement_id
984: AND plines.rec_agr_line_id = lines.rec_agr_line_id
985: AND plines.start_date = p_calc_period_start_date

Line 1004: ,pn_rec_calc_periods_all calc_periods

1000: ,nvl(plines.reconciled_amount,0) RECONCILED_AMOUNT
1001: ,plines.billing_type
1002: ,plines.billing_purpose
1003: FROM pn_rec_period_lines_all plines
1004: ,pn_rec_calc_periods_all calc_periods
1005: WHERE plines.rec_agr_line_id = p_rec_agr_line_id
1006: AND plines.start_date = p_calc_period_start_date
1007: AND plines.end_date = p_calc_period_end_date
1008: AND upper(plines.status) = 'COMPLETE'

Line 2441: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE

2437: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE
2438: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE
2439: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
2440: ,p_location_id pn_rec_agreements_all.location_id%TYPE
2441: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
2442: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
2443: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
2444: )
2445: RETURN pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE IS

Line 2442: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE

2438: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE
2439: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
2440: ,p_location_id pn_rec_agreements_all.location_id%TYPE
2441: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
2442: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
2443: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
2444: )
2445: RETURN pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE IS
2446:

Line 2443: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE

2439: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
2440: ,p_location_id pn_rec_agreements_all.location_id%TYPE
2441: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
2442: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
2443: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
2444: )
2445: RETURN pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE IS
2446:
2447: l_tot_prop_area pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;

Line 2599: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE

2595: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE
2596: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE
2597: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
2598: ,p_location_id pn_rec_agreements_all.location_id%TYPE
2599: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
2600: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
2601: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
2602: )
2603: RETURN ten_recoverable_area_rec IS

Line 2600: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE

2596: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE
2597: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
2598: ,p_location_id pn_rec_agreements_all.location_id%TYPE
2599: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
2600: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
2601: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
2602: )
2603: RETURN ten_recoverable_area_rec IS
2604:

Line 2601: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE

2597: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
2598: ,p_location_id pn_rec_agreements_all.location_id%TYPE
2599: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
2600: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
2601: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
2602: )
2603: RETURN ten_recoverable_area_rec IS
2604:
2605: l_ten_recoverable_area_rec ten_recoverable_area_rec;

Line 2688: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE

2684: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE
2685: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE
2686: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
2687: ,p_location_id pn_rec_agreements_all.location_id%TYPE
2688: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
2689: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
2690: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
2691: ,p_called_from VARCHAR2
2692: )

Line 2689: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE

2685: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE
2686: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
2687: ,p_location_id pn_rec_agreements_all.location_id%TYPE
2688: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
2689: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
2690: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
2691: ,p_called_from VARCHAR2
2692: )
2693: RETURN pn_rec_period_lines_all.actual_recovery%TYPE IS

Line 2690: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE

2686: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
2687: ,p_location_id pn_rec_agreements_all.location_id%TYPE
2688: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
2689: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
2690: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
2691: ,p_called_from VARCHAR2
2692: )
2693: RETURN pn_rec_period_lines_all.actual_recovery%TYPE IS
2694:

Line 2992: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE

2988: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE
2989: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE
2990: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
2991: ,p_location_id pn_rec_agreements_all.location_id%TYPE
2992: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
2993: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
2994: ,p_calc_period_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
2995: )
2996: RETURN pn_rec_expcl_dtlln_all.budgeted_amt%TYPE IS

Line 2993: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE

2989: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE
2990: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
2991: ,p_location_id pn_rec_agreements_all.location_id%TYPE
2992: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
2993: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
2994: ,p_calc_period_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
2995: )
2996: RETURN pn_rec_expcl_dtlln_all.budgeted_amt%TYPE IS
2997:

Line 2994: ,p_calc_period_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE

2990: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
2991: ,p_location_id pn_rec_agreements_all.location_id%TYPE
2992: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
2993: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
2994: ,p_calc_period_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
2995: )
2996: RETURN pn_rec_expcl_dtlln_all.budgeted_amt%TYPE IS
2997:
2998: l_budget_expenses pn_rec_expcl_dtlln_all.budgeted_amt%TYPE;

Line 3103: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE

3099: p_payment_purpose pn_rec_agr_lines_all.purpose%TYPE
3100: ,p_payment_type pn_rec_agr_lines_all.type%TYPE
3101: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
3102: ,p_location_id pn_rec_agreements_all.location_id%TYPE
3103: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
3104: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
3105: ,p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE
3106: ,p_rec_calc_period_id pn_rec_calc_periods_all.rec_calc_period_id%TYPE
3107: )

Line 3104: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE

3100: ,p_payment_type pn_rec_agr_lines_all.type%TYPE
3101: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
3102: ,p_location_id pn_rec_agreements_all.location_id%TYPE
3103: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
3104: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
3105: ,p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE
3106: ,p_rec_calc_period_id pn_rec_calc_periods_all.rec_calc_period_id%TYPE
3107: )
3108: RETURN pn_rec_period_lines_all.billed_recovery%TYPE IS

Line 3106: ,p_rec_calc_period_id pn_rec_calc_periods_all.rec_calc_period_id%TYPE

3102: ,p_location_id pn_rec_agreements_all.location_id%TYPE
3103: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
3104: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
3105: ,p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE
3106: ,p_rec_calc_period_id pn_rec_calc_periods_all.rec_calc_period_id%TYPE
3107: )
3108: RETURN pn_rec_period_lines_all.billed_recovery%TYPE IS
3109:
3110: l_billed_recovery pn_rec_period_lines_all.billed_recovery%TYPE;

Line 3192: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE

3188: | 19-MAY-2003 Daniel Thota o Created
3189: +===========================================================================*/
3190: FUNCTION get_line_constraints (
3191: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE
3192: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
3193: )
3194: RETURN g_line_constr_type IS
3195:
3196: CURSOR get_line_constr_csr IS

Line 3288: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE

3284: | 19-MAY-2003 Daniel Thota o Created
3285: +===========================================================================*/
3286: FUNCTION get_line_abatements (
3287: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE
3288: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
3289: )
3290: RETURN pn_rec_agr_linabat_all.amount%TYPE IS
3291:
3292:

Line 3466: FROM pn_rec_calc_periods_all

3462: where REC_PERIOD_LINES_ID = X_REC_PERIOD_LINES_ID;
3463:
3464: CURSOR org_cur IS
3465: SELECT org_id
3466: FROM pn_rec_calc_periods_all
3467: WHERE rec_calc_period_id = X_REC_CALC_PERIOD_ID;
3468:
3469: l_org_ID NUMBER;
3470:

Line 4773: ,p_start_date pn_rec_calc_periods_all.start_date%TYPE

4769: | 19-MAY-2003 Daniel Thota o Created
4770: +===========================================================================*/
4771: FUNCTION get_prior_period_actual_amount(
4772: p_rec_agr_line_id pn_rec_period_lines_all.rec_agr_line_id%TYPE
4773: ,p_start_date pn_rec_calc_periods_all.start_date%TYPE
4774: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
4775: ,p_called_from VARCHAR2
4776: )
4777: RETURN pn_rec_period_lines_all.constrained_actual%TYPE IS

Line 4774: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE

4770: +===========================================================================*/
4771: FUNCTION get_prior_period_actual_amount(
4772: p_rec_agr_line_id pn_rec_period_lines_all.rec_agr_line_id%TYPE
4773: ,p_start_date pn_rec_calc_periods_all.start_date%TYPE
4774: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
4775: ,p_called_from VARCHAR2
4776: )
4777: RETURN pn_rec_period_lines_all.constrained_actual%TYPE IS
4778:

Line 4884: ,p_start_date pn_rec_calc_periods_all.start_date%TYPE

4880: | 23-aug-2003 achauhan o Created
4881: +===========================================================================*/
4882: FUNCTION get_prior_period_cap(
4883: p_rec_agr_line_id pn_rec_period_lines_all.rec_agr_line_id%TYPE
4884: ,p_start_date pn_rec_calc_periods_all.start_date%TYPE
4885: ,p_end_date pn_rec_calc_periods_all.end_date%TYPE
4886: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
4887: ,p_called_from VARCHAR2
4888: )

Line 4885: ,p_end_date pn_rec_calc_periods_all.end_date%TYPE

4881: +===========================================================================*/
4882: FUNCTION get_prior_period_cap(
4883: p_rec_agr_line_id pn_rec_period_lines_all.rec_agr_line_id%TYPE
4884: ,p_start_date pn_rec_calc_periods_all.start_date%TYPE
4885: ,p_end_date pn_rec_calc_periods_all.end_date%TYPE
4886: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
4887: ,p_called_from VARCHAR2
4888: )
4889: RETURN pn_rec_period_lines_all.actual_recovery%TYPE IS

Line 4886: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE

4882: FUNCTION get_prior_period_cap(
4883: p_rec_agr_line_id pn_rec_period_lines_all.rec_agr_line_id%TYPE
4884: ,p_start_date pn_rec_calc_periods_all.start_date%TYPE
4885: ,p_end_date pn_rec_calc_periods_all.end_date%TYPE
4886: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
4887: ,p_called_from VARCHAR2
4888: )
4889: RETURN pn_rec_period_lines_all.actual_recovery%TYPE IS
4890:

Line 4908: pn_rec_calc_periods_all recperiod

4904: CURSOR csr_get_prior_periods (p_start_date date, p_fst_end_date date) is
4905: SELECT lineconst.VALUE
4906: FROM pn_rec_period_lines_all period_lines,
4907: pn_rec_agr_linconst_all lineconst,
4908: pn_rec_calc_periods_all recperiod
4909: WHERE period_lines.rec_agr_line_id = p_rec_agr_line_id
4910: AND recperiod.rec_calc_period_id = period_lines.rec_calc_period_id
4911: AND recperiod.start_date > p_fst_end_date
4912: AND recperiod.end_date > p_fst_end_date

Line 5056: ,pn_rec_calc_periods_all period

5052: period.as_of_date as as_of_date ,
5053: agrlines.rec_agr_line_id as rec_agr_line_id
5054: from pn_payment_terms_all term
5055: ,pn_rec_period_bill_all bill
5056: ,pn_rec_calc_periods_all period
5057: ,pn_rec_agr_lines_all agrlines
5058: ,pn_rec_agreements_all agr
5059: where term.payment_term_id = p_payment_term_id
5060: and bill.period_billrec_id = term.period_billrec_id

Line 5078: ,pn_rec_calc_periods_all period

5074: period.as_of_date as as_of_date ,
5075: agrlines.rec_agr_line_id as rec_agr_line_id
5076: from pn_payment_terms_all term
5077: ,pn_rec_period_bill_all bill
5078: ,pn_rec_calc_periods_all period
5079: ,pn_rec_agr_lines_all agrlines
5080: ,pn_rec_agreements_all agr
5081: where term.payment_term_id = p_payment_term_id
5082: and bill.period_billrec_id = term.period_billrec_id

Line 5149: l_start_date pn_rec_calc_periods_all.start_date%TYPE;

5145:
5146: l_customer_id pn_rec_agreements_all.customer_id%TYPE;
5147: l_lease_id pn_rec_agreements_all.lease_id%TYPE;
5148: l_location_id pn_rec_agreements_all.location_id%TYPE;
5149: l_start_date pn_rec_calc_periods_all.start_date%TYPE;
5150: l_end_date pn_rec_calc_periods_all.end_date%TYPE;
5151: l_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE;
5152: l_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE;
5153:

Line 5150: l_end_date pn_rec_calc_periods_all.end_date%TYPE;

5146: l_customer_id pn_rec_agreements_all.customer_id%TYPE;
5147: l_lease_id pn_rec_agreements_all.lease_id%TYPE;
5148: l_location_id pn_rec_agreements_all.location_id%TYPE;
5149: l_start_date pn_rec_calc_periods_all.start_date%TYPE;
5150: l_end_date pn_rec_calc_periods_all.end_date%TYPE;
5151: l_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE;
5152: l_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE;
5153:
5154: begin

Line 5151: l_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE;

5147: l_lease_id pn_rec_agreements_all.lease_id%TYPE;
5148: l_location_id pn_rec_agreements_all.location_id%TYPE;
5149: l_start_date pn_rec_calc_periods_all.start_date%TYPE;
5150: l_end_date pn_rec_calc_periods_all.end_date%TYPE;
5151: l_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE;
5152: l_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE;
5153:
5154: begin
5155:

Line 5291: p_start_date pn_rec_calc_periods_all.start_date%TYPE,

5287: | 30-Dec-2008 acprakas o Bug#7645185. Modified the insert stmt to populate org_id also.
5288: +===========================================================================*/
5289:
5290: FUNCTION validate_create_calc_period(p_rec_agreement_id pn_rec_agreements_all.REC_AGREEMENT_ID%TYPE,
5291: p_start_date pn_rec_calc_periods_all.start_date%TYPE,
5292: p_end_date pn_rec_calc_periods_all.end_date%TYPE,
5293: p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE)
5294: RETURN NUMBER
5295: IS

Line 5292: p_end_date pn_rec_calc_periods_all.end_date%TYPE,

5288: +===========================================================================*/
5289:
5290: FUNCTION validate_create_calc_period(p_rec_agreement_id pn_rec_agreements_all.REC_AGREEMENT_ID%TYPE,
5291: p_start_date pn_rec_calc_periods_all.start_date%TYPE,
5292: p_end_date pn_rec_calc_periods_all.end_date%TYPE,
5293: p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE)
5294: RETURN NUMBER
5295: IS
5296: l_rec_calc_period_id pn_rec_calc_periods_all.rec_calc_period_id%TYPE;

Line 5293: p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE)

5289:
5290: FUNCTION validate_create_calc_period(p_rec_agreement_id pn_rec_agreements_all.REC_AGREEMENT_ID%TYPE,
5291: p_start_date pn_rec_calc_periods_all.start_date%TYPE,
5292: p_end_date pn_rec_calc_periods_all.end_date%TYPE,
5293: p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE)
5294: RETURN NUMBER
5295: IS
5296: l_rec_calc_period_id pn_rec_calc_periods_all.rec_calc_period_id%TYPE;
5297: l_period_count NUMBER;

Line 5296: l_rec_calc_period_id pn_rec_calc_periods_all.rec_calc_period_id%TYPE;

5292: p_end_date pn_rec_calc_periods_all.end_date%TYPE,
5293: p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE)
5294: RETURN NUMBER
5295: IS
5296: l_rec_calc_period_id pn_rec_calc_periods_all.rec_calc_period_id%TYPE;
5297: l_period_count NUMBER;
5298: l_org_id NUMBER;
5299: BEGIN
5300: pnp_debug_pkg.log('PN_REC_CALC_PKG.validate_create_calc_period (+) ');

Line 5304: FROM pn_rec_calc_periods_all

5300: pnp_debug_pkg.log('PN_REC_CALC_PKG.validate_create_calc_period (+) ');
5301:
5302: SELECT count(1)
5303: INTO l_period_count
5304: FROM pn_rec_calc_periods_all
5305: WHERE rec_agreement_id = p_rec_agreement_id
5306: AND start_date = p_start_date
5307: AND end_date = p_end_date
5308: AND as_of_date = p_as_of_date;

Line 5318: insert into pn_rec_calc_periods_all

5314: select pn_rec_calc_periods_s.nextval
5315: into l_rec_calc_period_id
5316: from dual;
5317:
5318: insert into pn_rec_calc_periods_all
5319: (rec_calc_period_id,
5320: REC_AGREEMENT_ID,
5321: last_update_date,
5322: last_updated_by,