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 544: l_start_date pn_rec_calc_periods_all.start_date%TYPE := fnd_date.canonical_to_date(p_calc_period_startdate); --Bug#6438840

540: l_lease_id pn_rec_agreements_all.lease_id%TYPE := NULL;
541: l_location_id pn_rec_agreements_all.location_id%TYPE := NULL;
542: l_customer_id pn_rec_agreements_all.customer_id%TYPE := NULL;
543: l_cust_site_id pn_rec_agreements_all.cust_site_id%TYPE := NULL;
544: l_start_date pn_rec_calc_periods_all.start_date%TYPE := fnd_date.canonical_to_date(p_calc_period_startdate); --Bug#6438840
545: l_end_date pn_rec_calc_periods_all.end_date%TYPE := fnd_date.canonical_to_date(p_calc_period_enddate); --Bug#6438840
546: l_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE := fnd_date.canonical_to_date(p_as_ofdate); --Bug#6438840
547: l_calc_period_ending pn_rec_calc_periods_all.end_date%TYPE :=
548: trunc(fnd_date.canonical_to_date(p_calc_period_ending));

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

541: l_location_id pn_rec_agreements_all.location_id%TYPE := NULL;
542: l_customer_id pn_rec_agreements_all.customer_id%TYPE := NULL;
543: l_cust_site_id pn_rec_agreements_all.cust_site_id%TYPE := NULL;
544: l_start_date pn_rec_calc_periods_all.start_date%TYPE := fnd_date.canonical_to_date(p_calc_period_startdate); --Bug#6438840
545: l_end_date pn_rec_calc_periods_all.end_date%TYPE := fnd_date.canonical_to_date(p_calc_period_enddate); --Bug#6438840
546: l_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE := fnd_date.canonical_to_date(p_as_ofdate); --Bug#6438840
547: l_calc_period_ending pn_rec_calc_periods_all.end_date%TYPE :=
548: trunc(fnd_date.canonical_to_date(p_calc_period_ending));
549:

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

542: l_customer_id pn_rec_agreements_all.customer_id%TYPE := NULL;
543: l_cust_site_id pn_rec_agreements_all.cust_site_id%TYPE := NULL;
544: l_start_date pn_rec_calc_periods_all.start_date%TYPE := fnd_date.canonical_to_date(p_calc_period_startdate); --Bug#6438840
545: l_end_date pn_rec_calc_periods_all.end_date%TYPE := fnd_date.canonical_to_date(p_calc_period_enddate); --Bug#6438840
546: l_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE := fnd_date.canonical_to_date(p_as_ofdate); --Bug#6438840
547: l_calc_period_ending pn_rec_calc_periods_all.end_date%TYPE :=
548: trunc(fnd_date.canonical_to_date(p_calc_period_ending));
549:
550: l_error VARCHAR2(2000) := 'Success';

Line 547: l_calc_period_ending pn_rec_calc_periods_all.end_date%TYPE :=

543: l_cust_site_id pn_rec_agreements_all.cust_site_id%TYPE := NULL;
544: l_start_date pn_rec_calc_periods_all.start_date%TYPE := fnd_date.canonical_to_date(p_calc_period_startdate); --Bug#6438840
545: l_end_date pn_rec_calc_periods_all.end_date%TYPE := fnd_date.canonical_to_date(p_calc_period_enddate); --Bug#6438840
546: l_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE := fnd_date.canonical_to_date(p_as_ofdate); --Bug#6438840
547: l_calc_period_ending pn_rec_calc_periods_all.end_date%TYPE :=
548: trunc(fnd_date.canonical_to_date(p_calc_period_ending));
549:
550: l_error VARCHAR2(2000) := 'Success';
551: l_error_code NUMBER := 0;

Line 640: l_rec_calc_period_id pn_rec_calc_periods_all.rec_calc_period_id%TYPE;

636:
637: l_processed NUMBER := 0;
638: l_success_count NUMBER := 0;
639: l_fail_count NUMBER := 0;
640: l_rec_calc_period_id pn_rec_calc_periods_all.rec_calc_period_id%TYPE;
641:
642: BEGIN
643:
644: pnp_debug_pkg.log('PN_REC_CALC_PKG.CALCULATE_REC_AMOUNT_BATCH (+) ');

Line 948: ,pn_rec_calc_periods_all calc_periods

944: FROM DUAL
945: WHERE exists (SELECT NULL
946: FROM pn_rec_period_lines_all plines
947: ,pn_rec_agr_lines_all lines
948: ,pn_rec_calc_periods_all calc_periods
949: WHERE lines.rec_agreement_id = p_rec_agreement_id
950: AND p_as_of_date between lines.start_date and lines.end_date
951: AND plines.rec_agr_line_id = lines.rec_agr_line_id
952: AND plines.start_date = p_calc_period_start_date

Line 967: ,pn_rec_calc_periods_all calc_periods

963: FROM DUAL
964: WHERE not exists (SELECT NULL
965: FROM pn_rec_period_lines_all plines
966: ,pn_rec_agr_lines_all lines
967: ,pn_rec_calc_periods_all calc_periods
968: WHERE lines.rec_agreement_id = p_rec_agreement_id
969: AND p_as_of_date between lines.start_date and lines.end_date
970: AND plines.rec_agr_line_id = lines.rec_agr_line_id
971: AND plines.start_date = p_calc_period_start_date

Line 986: ,pn_rec_calc_periods_all calc_periods

982:
983: CURSOR calc_all_cons IS
984: SELECT NVL(SUM(NVL(plines.reconciled_amount,0)),0) RECONCILED_AMOUNT
985: FROM pn_rec_period_lines_all plines
986: ,pn_rec_calc_periods_all calc_periods
987: ,pn_rec_agr_lines_all lines
988: WHERE lines.rec_agreement_id = p_rec_agreement_id
989: AND plines.rec_agr_line_id = lines.rec_agr_line_id
990: AND plines.start_date = p_calc_period_start_date

Line 1006: ,pn_rec_calc_periods_all calc_periods

1002: ,NVL(plines.reconciled_amount,0) RECONCILED_AMOUNT
1003: ,plines.billing_type
1004: ,plines.billing_purpose
1005: FROM pn_rec_period_lines_all plines
1006: ,pn_rec_calc_periods_all calc_periods
1007: ,pn_rec_agr_lines_all lines
1008: WHERE lines.rec_agreement_id = p_rec_agreement_id
1009: AND plines.rec_agr_line_id = lines.rec_agr_line_id
1010: AND plines.start_date = p_calc_period_start_date

Line 1029: ,pn_rec_calc_periods_all calc_periods

1025: ,nvl(plines.reconciled_amount,0) RECONCILED_AMOUNT
1026: ,plines.billing_type
1027: ,plines.billing_purpose
1028: FROM pn_rec_period_lines_all plines
1029: ,pn_rec_calc_periods_all calc_periods
1030: WHERE plines.rec_agr_line_id = p_rec_agr_line_id
1031: AND plines.start_date = p_calc_period_start_date
1032: AND plines.end_date = p_calc_period_end_date
1033: AND upper(plines.status) = 'COMPLETE'

Line 2472: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE

2468: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE
2469: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE
2470: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
2471: ,p_location_id pn_rec_agreements_all.location_id%TYPE
2472: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
2473: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
2474: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
2475: )
2476: RETURN pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE IS

Line 2473: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE

2469: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE
2470: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
2471: ,p_location_id pn_rec_agreements_all.location_id%TYPE
2472: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
2473: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
2474: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
2475: )
2476: RETURN pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE IS
2477:

Line 2474: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE

2470: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
2471: ,p_location_id pn_rec_agreements_all.location_id%TYPE
2472: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
2473: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
2474: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
2475: )
2476: RETURN pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE IS
2477:
2478: l_tot_prop_area pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;

Line 2633: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE

2629: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE
2630: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE
2631: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
2632: ,p_location_id pn_rec_agreements_all.location_id%TYPE
2633: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
2634: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
2635: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
2636: )
2637: RETURN ten_recoverable_area_rec IS

Line 2634: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE

2630: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE
2631: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
2632: ,p_location_id pn_rec_agreements_all.location_id%TYPE
2633: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
2634: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
2635: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
2636: )
2637: RETURN ten_recoverable_area_rec IS
2638:

Line 2635: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE

2631: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
2632: ,p_location_id pn_rec_agreements_all.location_id%TYPE
2633: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
2634: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
2635: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
2636: )
2637: RETURN ten_recoverable_area_rec IS
2638:
2639: l_ten_recoverable_area_rec ten_recoverable_area_rec;

Line 2722: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE

2718: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE
2719: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE
2720: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
2721: ,p_location_id pn_rec_agreements_all.location_id%TYPE
2722: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
2723: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
2724: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
2725: ,p_called_from VARCHAR2
2726: )

Line 2723: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE

2719: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE
2720: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
2721: ,p_location_id pn_rec_agreements_all.location_id%TYPE
2722: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
2723: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
2724: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
2725: ,p_called_from VARCHAR2
2726: )
2727: RETURN pn_rec_period_lines_all.actual_recovery%TYPE IS

Line 2724: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE

2720: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
2721: ,p_location_id pn_rec_agreements_all.location_id%TYPE
2722: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
2723: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
2724: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
2725: ,p_called_from VARCHAR2
2726: )
2727: RETURN pn_rec_period_lines_all.actual_recovery%TYPE IS
2728:

Line 3077: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE

3073: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE
3074: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE
3075: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
3076: ,p_location_id pn_rec_agreements_all.location_id%TYPE
3077: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
3078: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
3079: ,p_calc_period_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
3080: )
3081: RETURN pn_rec_expcl_dtlln_all.budgeted_amt%TYPE IS

Line 3078: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE

3074: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE
3075: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
3076: ,p_location_id pn_rec_agreements_all.location_id%TYPE
3077: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
3078: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
3079: ,p_calc_period_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
3080: )
3081: RETURN pn_rec_expcl_dtlln_all.budgeted_amt%TYPE IS
3082:

Line 3079: ,p_calc_period_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE

3075: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
3076: ,p_location_id pn_rec_agreements_all.location_id%TYPE
3077: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
3078: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
3079: ,p_calc_period_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
3080: )
3081: RETURN pn_rec_expcl_dtlln_all.budgeted_amt%TYPE IS
3082:
3083: l_budget_expenses pn_rec_expcl_dtlln_all.budgeted_amt%TYPE;

Line 3188: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE

3184: p_payment_purpose pn_rec_agr_lines_all.purpose%TYPE
3185: ,p_payment_type pn_rec_agr_lines_all.type%TYPE
3186: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
3187: ,p_location_id pn_rec_agreements_all.location_id%TYPE
3188: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
3189: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
3190: ,p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE
3191: ,p_rec_calc_period_id pn_rec_calc_periods_all.rec_calc_period_id%TYPE
3192: )

Line 3189: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE

3185: ,p_payment_type pn_rec_agr_lines_all.type%TYPE
3186: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE
3187: ,p_location_id pn_rec_agreements_all.location_id%TYPE
3188: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
3189: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
3190: ,p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE
3191: ,p_rec_calc_period_id pn_rec_calc_periods_all.rec_calc_period_id%TYPE
3192: )
3193: RETURN pn_rec_period_lines_all.billed_recovery%TYPE IS

Line 3191: ,p_rec_calc_period_id pn_rec_calc_periods_all.rec_calc_period_id%TYPE

3187: ,p_location_id pn_rec_agreements_all.location_id%TYPE
3188: ,p_calc_period_start_date pn_rec_calc_periods_all.start_date%TYPE
3189: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE
3190: ,p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE
3191: ,p_rec_calc_period_id pn_rec_calc_periods_all.rec_calc_period_id%TYPE
3192: )
3193: RETURN pn_rec_period_lines_all.billed_recovery%TYPE IS
3194:
3195: l_billed_recovery pn_rec_period_lines_all.billed_recovery%TYPE;

Line 3277: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE

3273: | 19-MAY-2003 Daniel Thota o Created
3274: +===========================================================================*/
3275: FUNCTION get_line_constraints (
3276: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE
3277: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
3278: )
3279: RETURN g_line_constr_type IS
3280:
3281: CURSOR get_line_constr_csr IS

Line 3373: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE

3369: | 19-MAY-2003 Daniel Thota o Created
3370: +===========================================================================*/
3371: FUNCTION get_line_abatements (
3372: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE
3373: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
3374: )
3375: RETURN pn_rec_agr_linabat_all.amount%TYPE IS
3376:
3377:

Line 3551: FROM pn_rec_calc_periods_all

3547: where REC_PERIOD_LINES_ID = X_REC_PERIOD_LINES_ID;
3548:
3549: CURSOR org_cur IS
3550: SELECT org_id
3551: FROM pn_rec_calc_periods_all
3552: WHERE rec_calc_period_id = X_REC_CALC_PERIOD_ID;
3553:
3554: l_org_ID NUMBER;
3555:

Line 4858: ,p_start_date pn_rec_calc_periods_all.start_date%TYPE

4854: | 19-MAY-2003 Daniel Thota o Created
4855: +===========================================================================*/
4856: FUNCTION get_prior_period_actual_amount(
4857: p_rec_agr_line_id pn_rec_period_lines_all.rec_agr_line_id%TYPE
4858: ,p_start_date pn_rec_calc_periods_all.start_date%TYPE
4859: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
4860: ,p_called_from VARCHAR2
4861: )
4862: RETURN pn_rec_period_lines_all.constrained_actual%TYPE IS

Line 4859: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE

4855: +===========================================================================*/
4856: FUNCTION get_prior_period_actual_amount(
4857: p_rec_agr_line_id pn_rec_period_lines_all.rec_agr_line_id%TYPE
4858: ,p_start_date pn_rec_calc_periods_all.start_date%TYPE
4859: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
4860: ,p_called_from VARCHAR2
4861: )
4862: RETURN pn_rec_period_lines_all.constrained_actual%TYPE IS
4863:

Line 4969: ,p_start_date pn_rec_calc_periods_all.start_date%TYPE

4965: | 23-aug-2003 achauhan o Created
4966: +===========================================================================*/
4967: FUNCTION get_prior_period_cap(
4968: p_rec_agr_line_id pn_rec_period_lines_all.rec_agr_line_id%TYPE
4969: ,p_start_date pn_rec_calc_periods_all.start_date%TYPE
4970: ,p_end_date pn_rec_calc_periods_all.end_date%TYPE
4971: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
4972: ,p_called_from VARCHAR2
4973: )

Line 4970: ,p_end_date pn_rec_calc_periods_all.end_date%TYPE

4966: +===========================================================================*/
4967: FUNCTION get_prior_period_cap(
4968: p_rec_agr_line_id pn_rec_period_lines_all.rec_agr_line_id%TYPE
4969: ,p_start_date pn_rec_calc_periods_all.start_date%TYPE
4970: ,p_end_date pn_rec_calc_periods_all.end_date%TYPE
4971: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
4972: ,p_called_from VARCHAR2
4973: )
4974: RETURN pn_rec_period_lines_all.actual_recovery%TYPE IS

Line 4971: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE

4967: FUNCTION get_prior_period_cap(
4968: p_rec_agr_line_id pn_rec_period_lines_all.rec_agr_line_id%TYPE
4969: ,p_start_date pn_rec_calc_periods_all.start_date%TYPE
4970: ,p_end_date pn_rec_calc_periods_all.end_date%TYPE
4971: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
4972: ,p_called_from VARCHAR2
4973: )
4974: RETURN pn_rec_period_lines_all.actual_recovery%TYPE IS
4975:

Line 4993: pn_rec_calc_periods_all recperiod

4989: CURSOR csr_get_prior_periods (p_start_date date, p_fst_end_date date) is
4990: SELECT lineconst.VALUE
4991: FROM pn_rec_period_lines_all period_lines,
4992: pn_rec_agr_linconst_all lineconst,
4993: pn_rec_calc_periods_all recperiod
4994: WHERE period_lines.rec_agr_line_id = p_rec_agr_line_id
4995: AND recperiod.rec_calc_period_id = period_lines.rec_calc_period_id
4996: AND recperiod.start_date > p_fst_end_date
4997: AND recperiod.end_date > p_fst_end_date

Line 5141: ,pn_rec_calc_periods_all period

5137: period.as_of_date as as_of_date ,
5138: agrlines.rec_agr_line_id as rec_agr_line_id
5139: from pn_payment_terms_all term
5140: ,pn_rec_period_bill_all bill
5141: ,pn_rec_calc_periods_all period
5142: ,pn_rec_agr_lines_all agrlines
5143: ,pn_rec_agreements_all agr
5144: where term.payment_term_id = p_payment_term_id
5145: and bill.period_billrec_id = term.period_billrec_id

Line 5163: ,pn_rec_calc_periods_all period

5159: period.as_of_date as as_of_date ,
5160: agrlines.rec_agr_line_id as rec_agr_line_id
5161: from pn_payment_terms_all term
5162: ,pn_rec_period_bill_all bill
5163: ,pn_rec_calc_periods_all period
5164: ,pn_rec_agr_lines_all agrlines
5165: ,pn_rec_agreements_all agr
5166: where term.payment_term_id = p_payment_term_id
5167: and bill.period_billrec_id = term.period_billrec_id

Line 5234: l_start_date pn_rec_calc_periods_all.start_date%TYPE;

5230:
5231: l_customer_id pn_rec_agreements_all.customer_id%TYPE;
5232: l_lease_id pn_rec_agreements_all.lease_id%TYPE;
5233: l_location_id pn_rec_agreements_all.location_id%TYPE;
5234: l_start_date pn_rec_calc_periods_all.start_date%TYPE;
5235: l_end_date pn_rec_calc_periods_all.end_date%TYPE;
5236: l_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE;
5237: l_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE;
5238:

Line 5235: l_end_date pn_rec_calc_periods_all.end_date%TYPE;

5231: l_customer_id pn_rec_agreements_all.customer_id%TYPE;
5232: l_lease_id pn_rec_agreements_all.lease_id%TYPE;
5233: l_location_id pn_rec_agreements_all.location_id%TYPE;
5234: l_start_date pn_rec_calc_periods_all.start_date%TYPE;
5235: l_end_date pn_rec_calc_periods_all.end_date%TYPE;
5236: l_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE;
5237: l_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE;
5238:
5239: begin

Line 5236: l_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE;

5232: l_lease_id pn_rec_agreements_all.lease_id%TYPE;
5233: l_location_id pn_rec_agreements_all.location_id%TYPE;
5234: l_start_date pn_rec_calc_periods_all.start_date%TYPE;
5235: l_end_date pn_rec_calc_periods_all.end_date%TYPE;
5236: l_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE;
5237: l_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE;
5238:
5239: begin
5240:

Line 5376: p_start_date pn_rec_calc_periods_all.start_date%TYPE,

5372: | 30-Dec-2008 acprakas o Bug#7645185. Modified the insert stmt to populate org_id also.
5373: +===========================================================================*/
5374:
5375: FUNCTION validate_create_calc_period(p_rec_agreement_id pn_rec_agreements_all.REC_AGREEMENT_ID%TYPE,
5376: p_start_date pn_rec_calc_periods_all.start_date%TYPE,
5377: p_end_date pn_rec_calc_periods_all.end_date%TYPE,
5378: p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE)
5379: RETURN NUMBER
5380: IS

Line 5377: p_end_date pn_rec_calc_periods_all.end_date%TYPE,

5373: +===========================================================================*/
5374:
5375: FUNCTION validate_create_calc_period(p_rec_agreement_id pn_rec_agreements_all.REC_AGREEMENT_ID%TYPE,
5376: p_start_date pn_rec_calc_periods_all.start_date%TYPE,
5377: p_end_date pn_rec_calc_periods_all.end_date%TYPE,
5378: p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE)
5379: RETURN NUMBER
5380: IS
5381: l_rec_calc_period_id pn_rec_calc_periods_all.rec_calc_period_id%TYPE;

Line 5378: p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE)

5374:
5375: FUNCTION validate_create_calc_period(p_rec_agreement_id pn_rec_agreements_all.REC_AGREEMENT_ID%TYPE,
5376: p_start_date pn_rec_calc_periods_all.start_date%TYPE,
5377: p_end_date pn_rec_calc_periods_all.end_date%TYPE,
5378: p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE)
5379: RETURN NUMBER
5380: IS
5381: l_rec_calc_period_id pn_rec_calc_periods_all.rec_calc_period_id%TYPE;
5382: l_period_count NUMBER;

Line 5381: l_rec_calc_period_id pn_rec_calc_periods_all.rec_calc_period_id%TYPE;

5377: p_end_date pn_rec_calc_periods_all.end_date%TYPE,
5378: p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE)
5379: RETURN NUMBER
5380: IS
5381: l_rec_calc_period_id pn_rec_calc_periods_all.rec_calc_period_id%TYPE;
5382: l_period_count NUMBER;
5383: l_org_id NUMBER;
5384: BEGIN
5385: pnp_debug_pkg.log('PN_REC_CALC_PKG.validate_create_calc_period (+) ');

Line 5389: FROM pn_rec_calc_periods_all

5385: pnp_debug_pkg.log('PN_REC_CALC_PKG.validate_create_calc_period (+) ');
5386:
5387: SELECT count(1)
5388: INTO l_period_count
5389: FROM pn_rec_calc_periods_all
5390: WHERE rec_agreement_id = p_rec_agreement_id
5391: AND start_date = p_start_date
5392: AND end_date = p_end_date
5393: AND as_of_date = p_as_of_date;

Line 5403: insert into pn_rec_calc_periods_all

5399: select pn_rec_calc_periods_s.nextval
5400: into l_rec_calc_period_id
5401: from dual;
5402:
5403: insert into pn_rec_calc_periods_all
5404: (rec_calc_period_id,
5405: REC_AGREEMENT_ID,
5406: last_update_date,
5407: last_updated_by,