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.

[Home] [Help]

APPS.PN_REC_CALC_PKG dependencies on PN_REC_AGR_LINES_ALL

Line 807: | pn_rec_agr_lines_all with pn_rec_agr_lines

803: |
804: | 07-APR-03 Daniel o Created
805: | 22-NOV-05 Kiran o Changed csr_check_line_status, csr_check_period_line
806: | calc_all_cons, calc_all_no_cons, calc_no_cons; replaced
807: | pn_rec_agr_lines_all with pn_rec_agr_lines
808: +============================================================================*/
809:
810: PROCEDURE CALCULATE_REC_AMOUNT(
811: p_rec_agreement_id IN NUMBER

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

835: l_ten_actual_recovery pn_rec_period_lines_all.actual_recovery%TYPE:=0;
836: l_contr_actual_recovery pn_rec_period_lines_all.actual_recovery%TYPE:=0;
837: l_amount_per_sft NUMBER:=0;
838: l_budget_amount_per_sft NUMBER:=0;
839: l_rate pn_rec_agr_lines_all.fixed_rate%TYPE:= 0;
840: l_constrained_actual pn_rec_period_lines_all.constrained_actual%TYPE:=0;
841: l_constrained_budget pn_rec_period_lines_all.constrained_actual%TYPE:=0;
842: l_actual_prorata_share pn_rec_period_lines_all.actual_prorata_share%TYPE:=0;
843: l_reconciled_amount pn_rec_period_lines_all.reconciled_amount%TYPE:=0;

Line 893: FROM pn_rec_agr_lines_all lines

889: ,lines.fixed_amount
890: ,lines.fixed_rate
891: ,lines.fixed_pct
892: ,lines.multiple_pct
893: FROM pn_rec_agr_lines_all lines
894: WHERE lines.rec_agreement_id = p_rec_agreement_id
895: AND p_as_of_date between lines.start_date AND end_date ;
896:
897: --------------------------------------------------------------------------

Line 913: FROM pn_rec_agr_lines_all lines

909: ,lines.fixed_amount
910: ,lines.fixed_rate
911: ,lines.fixed_pct
912: ,lines.multiple_pct
913: FROM pn_rec_agr_lines_all lines
914: WHERE lines.rec_agr_line_id = p_rec_agr_line_id
915: AND p_as_of_date between lines.start_date AND end_date ;
916:
917: CURSOR csr_check_line_status IS

Line 922: ,pn_rec_agr_lines_all lines

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

Line 941: ,pn_rec_agr_lines_all lines

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

Line 962: ,pn_rec_agr_lines_all lines

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

Line 982: ,pn_rec_agr_lines_all lines

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

Line 2300: FROM PN_REC_AGR_LINES_ALL

2296: ROLLBACK;
2297: UPDATE pn_rec_period_lines_all
2298: SET STATUS = 'Error'
2299: WHERE rec_agr_line_id in (SELECT rec_agr_line_id
2300: FROM PN_REC_AGR_LINES_ALL
2301: WHERE rec_agreement_id = p_rec_agreement_id)
2302: AND start_date = p_calc_period_start_date
2303: AND end_date = p_calc_period_end_date
2304: AND rec_calc_period_id = p_rec_calc_period_id;

Line 2437: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE

2433: | 22-Aug-2003 Ashish oBug#3107849 added the code to return
2434: | the total_area based on area_type
2435: +===========================================================================*/
2436: FUNCTION get_tot_prop_area (
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

Line 2595: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE

2591: |
2592: | 19-MAY-2003 Daniel Thota o Created
2593: +===========================================================================*/
2594: FUNCTION ten_recoverable_area (
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

Line 2684: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE

2680: | clause in the cursor to use them.
2681: | Fix for bug # 3123283
2682: +===========================================================================*/
2683: FUNCTION get_contr_actual_recovery (
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

Line 2698: FROM pn_rec_agr_lines_all

2694:
2695: -- Fix for bug # 3123283
2696: CURSOR csr_get_line IS
2697: SELECT purpose, type
2698: FROM pn_rec_agr_lines_all
2699: WHERE rec_agr_line_id = p_rec_agr_line_id;
2700: -- Fix for bug # 3123283
2701:
2702: cursor chk_contr_calculated (p_line_purpose VARCHAR2, p_line_type VARCHAR2) is --Fix for bug # 3123283

Line 2709: ,pn_rec_agr_lines_all lines

2705: WHERE exists(
2706: SELECT 'Y'
2707: FROM pn_rec_period_lines_all period_lines
2708: ,pn_rec_agreements_all recagr
2709: ,pn_rec_agr_lines_all lines
2710: WHERE nvl(period_lines.actual_prorata_share,0) = 0
2711: AND period_lines.start_date = p_calc_period_start_date
2712: AND period_lines.end_date = p_calc_period_end_date
2713: AND period_lines.as_of_date = p_as_of_date

Line 2750: l_line_purpose pn_rec_agr_lines_all.PURPOSE%TYPE;

2746: l_contr_actual_recovery pn_rec_period_lines_all.actual_recovery%TYPE := 0;
2747: l_exists VARCHAR2(1) := 'N';
2748:
2749: -- Fix for bug # 3123283
2750: l_line_purpose pn_rec_agr_lines_all.PURPOSE%TYPE;
2751: l_line_type pn_rec_agr_lines_all.TYPE%TYPE;
2752:
2753: BEGIN
2754:

Line 2751: l_line_type pn_rec_agr_lines_all.TYPE%TYPE;

2747: l_exists VARCHAR2(1) := 'N';
2748:
2749: -- Fix for bug # 3123283
2750: l_line_purpose pn_rec_agr_lines_all.PURPOSE%TYPE;
2751: l_line_type pn_rec_agr_lines_all.TYPE%TYPE;
2752:
2753: BEGIN
2754:
2755: pnp_debug_pkg.log('PN_REC_CALC_PKG.get_contr_actual_recovery (+) ');

Line 2793: ,pn_rec_agr_lines_all lines

2789: SELECT NVL(SUM(NVL(period_lines.actual_prorata_share,0)),0)
2790: INTO l_contr_actual_recovery
2791: FROM pn_rec_period_lines_all period_lines
2792: ,pn_rec_agreements_all recagr
2793: ,pn_rec_agr_lines_all lines
2794: WHERE period_lines.start_date = p_calc_period_start_date
2795: AND period_lines.end_date = p_calc_period_end_date
2796: AND period_lines.as_of_date = p_as_of_date
2797: AND lines.rec_agr_line_id = period_lines.rec_agr_line_id

Line 2988: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE

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

Line 3099: p_payment_purpose pn_rec_agr_lines_all.purpose%TYPE

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

Line 3100: ,p_payment_type pn_rec_agr_lines_all.type%TYPE

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

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

Line 3191: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE

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

Line 3287: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE

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

Line 5057: ,pn_rec_agr_lines_all agrlines

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

Line 5079: ,pn_rec_agr_lines_all agrlines

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

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