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_AGR_LINES_ALL

Line 832: | pn_rec_agr_lines_all with pn_rec_agr_lines

828: |
829: | 07-APR-03 Daniel o Created
830: | 22-NOV-05 Kiran o Changed csr_check_line_status, csr_check_period_line
831: | calc_all_cons, calc_all_no_cons, calc_no_cons; replaced
832: | pn_rec_agr_lines_all with pn_rec_agr_lines
833: +============================================================================*/
834:
835: PROCEDURE CALCULATE_REC_AMOUNT(
836: p_rec_agreement_id IN NUMBER

Line 864: l_rate pn_rec_agr_lines_all.fixed_rate%TYPE:= 0;

860: l_ten_actual_recovery pn_rec_period_lines_all.actual_recovery%TYPE:=0;
861: l_contr_actual_recovery pn_rec_period_lines_all.actual_recovery%TYPE:=0;
862: l_amount_per_sft NUMBER:=0;
863: l_budget_amount_per_sft NUMBER:=0;
864: l_rate pn_rec_agr_lines_all.fixed_rate%TYPE:= 0;
865: l_constrained_actual pn_rec_period_lines_all.constrained_actual%TYPE:=0;
866: l_constrained_budget pn_rec_period_lines_all.constrained_actual%TYPE:=0;
867: l_actual_prorata_share pn_rec_period_lines_all.actual_prorata_share%TYPE:=0;
868: l_reconciled_amount pn_rec_period_lines_all.reconciled_amount%TYPE:=0;

Line 918: FROM pn_rec_agr_lines_all lines

914: ,lines.fixed_amount
915: ,lines.fixed_rate
916: ,lines.fixed_pct
917: ,lines.multiple_pct
918: FROM pn_rec_agr_lines_all lines
919: WHERE lines.rec_agreement_id = p_rec_agreement_id
920: AND p_as_of_date between lines.start_date AND end_date ;
921:
922: --------------------------------------------------------------------------

Line 938: FROM pn_rec_agr_lines_all lines

934: ,lines.fixed_amount
935: ,lines.fixed_rate
936: ,lines.fixed_pct
937: ,lines.multiple_pct
938: FROM pn_rec_agr_lines_all lines
939: WHERE lines.rec_agr_line_id = p_rec_agr_line_id
940: AND p_as_of_date between lines.start_date AND end_date ;
941:
942: CURSOR csr_check_line_status IS

Line 947: ,pn_rec_agr_lines_all lines

943: SELECT 'Y'
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

Line 966: ,pn_rec_agr_lines_all lines

962: SELECT 'Y'
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

Line 987: ,pn_rec_agr_lines_all lines

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
991: AND plines.end_date = p_calc_period_end_date

Line 1007: ,pn_rec_agr_lines_all lines

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
1011: AND plines.end_date = p_calc_period_end_date

Line 2330: FROM PN_REC_AGR_LINES_ALL

2326: ROLLBACK;
2327: UPDATE pn_rec_period_lines_all
2328: SET STATUS = 'Error'
2329: WHERE rec_agr_line_id in (SELECT rec_agr_line_id
2330: FROM PN_REC_AGR_LINES_ALL
2331: WHERE rec_agreement_id = p_rec_agreement_id)
2332: AND start_date = p_calc_period_start_date
2333: AND end_date = p_calc_period_end_date
2334: AND rec_calc_period_id = p_rec_calc_period_id;

Line 2468: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE

2464: | the total_area based on area_type
2465: | 26-Apr-2010 asahoo o Bug#9579092, fixed the wrong comparision of l_area_class_dtl_id with area_class_dtl_line_id
2466: +===========================================================================*/
2467: FUNCTION get_tot_prop_area (
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

Line 2629: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE

2625: |
2626: | 19-MAY-2003 Daniel Thota o Created
2627: +===========================================================================*/
2628: FUNCTION ten_recoverable_area (
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

Line 2718: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE

2714: | clause in the cursor to use them.
2715: | Fix for bug # 3123283
2716: +===========================================================================*/
2717: FUNCTION get_contr_actual_recovery (
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

Line 2732: FROM pn_rec_agr_lines_all

2728:
2729: -- Fix for bug # 3123283
2730: CURSOR csr_get_line IS
2731: SELECT purpose, type
2732: FROM pn_rec_agr_lines_all
2733: WHERE rec_agr_line_id = p_rec_agr_line_id;
2734: -- Fix for bug # 3123283
2735:
2736: cursor chk_contr_calculated (p_line_purpose VARCHAR2, p_line_type VARCHAR2) is --Fix for bug # 3123283

Line 2743: ,pn_rec_agr_lines_all lines

2739: WHERE exists(
2740: SELECT 'Y'
2741: FROM pn_rec_period_lines_all period_lines
2742: ,pn_rec_agreements_all recagr
2743: ,pn_rec_agr_lines_all lines
2744: WHERE nvl(period_lines.actual_prorata_share,0) = 0
2745: AND period_lines.start_date = p_calc_period_start_date
2746: AND period_lines.end_date = p_calc_period_end_date
2747: AND period_lines.as_of_date = p_as_of_date

Line 2784: l_line_purpose pn_rec_agr_lines_all.PURPOSE%TYPE;

2780: l_contr_actual_recovery pn_rec_period_lines_all.actual_recovery%TYPE := 0;
2781: l_exists VARCHAR2(1) := 'N';
2782:
2783: -- Fix for bug # 3123283
2784: l_line_purpose pn_rec_agr_lines_all.PURPOSE%TYPE;
2785: l_line_type pn_rec_agr_lines_all.TYPE%TYPE;
2786:
2787: BEGIN
2788:

Line 2785: l_line_type pn_rec_agr_lines_all.TYPE%TYPE;

2781: l_exists VARCHAR2(1) := 'N';
2782:
2783: -- Fix for bug # 3123283
2784: l_line_purpose pn_rec_agr_lines_all.PURPOSE%TYPE;
2785: l_line_type pn_rec_agr_lines_all.TYPE%TYPE;
2786:
2787: BEGIN
2788:
2789: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_contr_actual_recovery (+) ');

Line 2827: ,pn_rec_agr_lines_all lines

2823: SELECT NVL(SUM(NVL(period_lines.actual_prorata_share,0)),0)
2824: INTO l_contr_actual_recovery
2825: FROM pn_rec_period_lines_all period_lines
2826: ,pn_rec_agreements_all recagr
2827: ,pn_rec_agr_lines_all lines
2828: WHERE period_lines.start_date = p_calc_period_start_date
2829: AND period_lines.end_date = p_calc_period_end_date
2830: AND period_lines.as_of_date = p_as_of_date
2831: AND lines.rec_agr_line_id = period_lines.rec_agr_line_id

Line 2992: ,pn_rec_agr_lines_all agrline

2988: ,pn_rec_expcl_dtl_all exp_detail_hdr
2989: ,pn_rec_exp_line_all exp_extract_hdr
2990: ,pn_rec_expcl_dtlln_all exp_detail_line
2991: ,pn_rec_expcl_dtlacc_all exp_detail_acc
2992: ,pn_rec_agr_lines_all agrline
2993: WHERE exp_detail_hdr.expense_class_dtl_id = exp_detail_line.expense_class_dtl_id
2994: AND exp_detail_line.cust_account_id = p_customer_id
2995: AND exp_detail_line.lease_id = p_lease_id
2996: AND exp_detail_line.location_id = p_location_id

Line 3073: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE

3069: | 27-AUG-04 abanerje o Modified the select statement to apply the share%
3070: | to the budgeted amount. Bug 3711709.
3071: +===========================================================================*/
3072: FUNCTION get_budget_expenses (
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

Line 3184: p_payment_purpose pn_rec_agr_lines_all.purpose%TYPE

3180: | so that billing terms of a lease are now associated with a location.
3181: | Added a new parameter p_location_id for the function
3182: +===========================================================================*/
3183: FUNCTION get_billed_recovery (
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

Line 3185: ,p_payment_type pn_rec_agr_lines_all.type%TYPE

3181: | Added a new parameter p_location_id for the function
3182: +===========================================================================*/
3183: FUNCTION get_billed_recovery (
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

Line 3190: ,p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%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
3194:

Line 3276: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE

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

Line 3372: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE

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

Line 5142: ,pn_rec_agr_lines_all agrlines

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
5146: and period.rec_calc_period_id = bill.rec_calc_period_id

Line 5164: ,pn_rec_agr_lines_all agrlines

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
5168: and period.rec_calc_period_id = bill.rec_calc_period_id

Line 5237: l_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_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:
5241: pnp_debug_pkg.log('PN_REC_CALC_PKG.lock_area_exp_cls_dtl (+) ');