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_AGREEMENTS_ALL

Line 75: l_rec_agreement_id pn_rec_agreements_all.rec_agreement_id%TYPE := NULL;

71: ,p_calc_period_ending IN VARCHAR2
72: ,p_org_id IN NUMBER
73: ) IS
74:
75: l_rec_agreement_id pn_rec_agreements_all.rec_agreement_id%TYPE := NULL;
76: l_lease_id pn_rec_agreements_all.lease_id%TYPE := NULL;
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;

Line 76: l_lease_id pn_rec_agreements_all.lease_id%TYPE := NULL;

72: ,p_org_id IN NUMBER
73: ) IS
74:
75: l_rec_agreement_id pn_rec_agreements_all.rec_agreement_id%TYPE := NULL;
76: l_lease_id pn_rec_agreements_all.lease_id%TYPE := NULL;
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:

Line 77: l_location_id pn_rec_agreements_all.location_id%TYPE := NULL;

73: ) IS
74:
75: l_rec_agreement_id pn_rec_agreements_all.rec_agreement_id%TYPE := NULL;
76: l_lease_id pn_rec_agreements_all.lease_id%TYPE := NULL;
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;

Line 78: l_customer_id pn_rec_agreements_all.customer_id%TYPE := NULL;

74:
75: l_rec_agreement_id pn_rec_agreements_all.rec_agreement_id%TYPE := NULL;
76: l_lease_id pn_rec_agreements_all.lease_id%TYPE := NULL;
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 ;

Line 79: l_cust_site_id pn_rec_agreements_all.cust_site_id%TYPE := NULL;

75: l_rec_agreement_id pn_rec_agreements_all.rec_agreement_id%TYPE := NULL;
76: l_lease_id pn_rec_agreements_all.lease_id%TYPE := NULL;
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 ;

Line 93: FROM pn_rec_agreements_all

89:
90: CURSOR csr_get_agr IS
91: SELECT rec_agreement_num,
92: rec_agreement_name
93: FROM pn_rec_agreements_all
94: WHERE rec_agreement_id = p_rec_agreement_id;
95:
96: CURSOR csr_get_lease IS
97: SELECT name,

Line 120: ,pn_rec_agreements_all pra

116: ,prc.end_date
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)

Line 150: ,pn_rec_agreements_all pra

146: ,prc.end_date
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)

Line 176: ,pn_rec_agreements_all pra

172: ,prc.end_date
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

Line 209: ,pn_rec_agreements_all pra

205: ,prc.end_date
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

Line 514: l_rec_agreement_id pn_rec_agreements_all.rec_agreement_id%TYPE := NULL;

510: ,p_calc_period_ending IN VARCHAR2
511: ,p_org_id IN NUMBER
512: ) IS
513:
514: l_rec_agreement_id pn_rec_agreements_all.rec_agreement_id%TYPE := NULL;
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;

Line 515: l_lease_id pn_rec_agreements_all.lease_id%TYPE := NULL;

511: ,p_org_id IN NUMBER
512: ) IS
513:
514: l_rec_agreement_id pn_rec_agreements_all.rec_agreement_id%TYPE := NULL;
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

Line 516: l_location_id pn_rec_agreements_all.location_id%TYPE := NULL;

512: ) IS
513:
514: l_rec_agreement_id pn_rec_agreements_all.rec_agreement_id%TYPE := NULL;
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

Line 517: l_customer_id pn_rec_agreements_all.customer_id%TYPE := NULL;

513:
514: l_rec_agreement_id pn_rec_agreements_all.rec_agreement_id%TYPE := NULL;
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

Line 518: l_cust_site_id pn_rec_agreements_all.cust_site_id%TYPE := NULL;

514: l_rec_agreement_id pn_rec_agreements_all.rec_agreement_id%TYPE := NULL;
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 :=

Line 535: ,pn_rec_agreements_all pra

531: ,pra.location_id
532: ,pra.customer_id
533: ,pra.cust_site_id
534: FROM pn_leases pl
535: ,pn_rec_agreements_all pra
536: ,pn_locations_all ploc
537: WHERE pl.lease_id = pra.lease_id
538: AND ploc.location_id = pra.location_id
539: AND pl.lease_num >= nvl(p_lease_num_from, pl.lease_num)

Line 556: ,pn_rec_agreements_all pra

552: ,pra.location_id
553: ,pra.customer_id
554: ,pra.cust_site_id
555: FROM pn_leases pl
556: ,pn_rec_agreements_all pra
557: WHERE pl.lease_id = pra.lease_id
558: AND pl.lease_num >= nvl(p_lease_num_from, pl.lease_num)
559: AND pl.lease_num <= nvl(p_lease_num_to, pl.lease_num)
560: AND pra.rec_agreement_num >= nvl(p_rec_agr_num_from,pra.rec_agreement_num)

Line 573: ,pn_rec_agreements_all pra

569: ,pra.location_id
570: ,pra.customer_id
571: ,pra.cust_site_id
572: FROM pn_leases pl
573: ,pn_rec_agreements_all pra
574: ,pn_locations_all ploc
575: ,pn_properties_all prop
576: WHERE pl.lease_id = pra.lease_id
577: AND ploc.location_id = pra.location_id

Line 597: ,pn_rec_agreements_all pra

593: ,pra.location_id
594: ,pra.customer_id
595: ,pra.cust_site_id
596: FROM pn_leases pl
597: ,pn_rec_agreements_all pra
598: ,pn_locations_all ploc
599: ,pn_properties_all prop
600: WHERE pl.lease_id = pra.lease_id
601: AND ploc.location_id = pra.location_id

Line 865: l_rec_agr_name pn_rec_agreements_all.REC_AGREEMENT_NAME%TYPE;

861: l_end_date pn_rec_period_lines_all.end_date%TYPE;
862: l_billing_type pn_rec_period_lines_all.billing_type%TYPE;
863: l_billing_purpose pn_rec_period_lines_all.billing_purpose%TYPE;
864: l_error_code NUMBER := 0;
865: l_rec_agr_name pn_rec_agreements_all.REC_AGREEMENT_NAME%TYPE;
866: l_rec_agr_num pn_rec_agreements_all.REC_AGREEMENT_NUM%TYPE;
867: --------------------------------------------------------------------------
868: -- Cursor to bring all details of a line. This cursor will be used in the
869: -- event that the user chooses to hit the 'Calculate All' button and every

Line 866: l_rec_agr_num pn_rec_agreements_all.REC_AGREEMENT_NUM%TYPE;

862: l_billing_type pn_rec_period_lines_all.billing_type%TYPE;
863: l_billing_purpose pn_rec_period_lines_all.billing_purpose%TYPE;
864: l_error_code NUMBER := 0;
865: l_rec_agr_name pn_rec_agreements_all.REC_AGREEMENT_NAME%TYPE;
866: l_rec_agr_num pn_rec_agreements_all.REC_AGREEMENT_NUM%TYPE;
867: --------------------------------------------------------------------------
868: -- Cursor to bring all details of a line. This cursor will be used in the
869: -- event that the user chooses to hit the 'Calculate All' button and every
870: -- line lying within the calc period needs to be picked up for recoery calc

Line 879: FROM pn_rec_agreements_all

875: ,negative_recovery
876: ,rec_agreement_name
877: ,rec_agreement_num
878: ,org_id
879: FROM pn_rec_agreements_all
880: WHERE rec_agreement_id = p_rec_agreement_id;
881:
882: CURSOR agr_lines_all IS
883: SELECT lines.rec_agr_line_id

Line 1022: l_negative_recovery pn_rec_agreements_all.negative_recovery%TYPE;

1018: agr_lines_record agr_lines_all%ROWTYPE;
1019: calc_all_no_cons_rec calc_all_no_cons%ROWTYPE;
1020: calc_all_cons_rec calc_all_cons%ROWTYPE;
1021: calc_no_cons_rec calc_no_cons%ROWTYPE;
1022: l_negative_recovery pn_rec_agreements_all.negative_recovery%TYPE;
1023: l_opya_exists BOOLEAN := FALSE;
1024: l_opyc_exists BOOLEAN := FALSE;
1025: l_rate_amt_exists BOOLEAN := FALSE;
1026: l_total_lines NUMBER := 0;

Line 2438: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE

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
2442: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE

Line 2439: ,p_lease_id pn_rec_agreements_all.lease_id%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
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

Line 2440: ,p_location_id pn_rec_agreements_all.location_id%TYPE

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

Line 2596: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE

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
2600: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE

Line 2597: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE

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

Line 2598: ,p_location_id pn_rec_agreements_all.location_id%TYPE

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

Line 2685: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE

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
2689: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE

Line 2686: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE

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

Line 2687: ,p_location_id pn_rec_agreements_all.location_id%TYPE

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

Line 2708: ,pn_rec_agreements_all recagr

2704: FROM dual
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

Line 2792: ,pn_rec_agreements_all recagr

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

Line 2989: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE

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
2993: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE

Line 2990: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE

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

Line 2991: ,p_location_id pn_rec_agreements_all.location_id%TYPE

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

Line 3101: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE

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

Line 3102: ,p_location_id pn_rec_agreements_all.location_id%TYPE

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

Line 3788: FROM pn_rec_agreements_all

3784: WHERE PERIOD_BILLREC_ID = X_PERIOD_BILLREC_ID;
3785:
3786: CURSOR org_cur IS
3787: SELECT org_id
3788: FROM pn_rec_agreements_all
3789: WHERE rec_agreement_id = X_REC_AGREEMENT_ID;
3790:
3791: l_org_ID NUMBER;
3792:

Line 4052: pn_rec_agreements_all prec

4048: CURSOR csr_template (p_rec_agreement_id IN NUMBER)
4049: IS
4050: SELECT ptt.*
4051: FROM pn_term_templates_all ptt,
4052: pn_rec_agreements_all prec
4053: WHERE ptt.term_template_id = prec.term_template_id
4054: AND prec.rec_agreement_id = p_rec_agreement_id;
4055:
4056: CURSOR csr_template_upg (p_rec_agreement_id IN NUMBER)

Line 4060: pn_rec_agreements_all prec

4056: CURSOR csr_template_upg (p_rec_agreement_id IN NUMBER)
4057: IS
4058: SELECT ptt.*
4059: FROM pn_term_templates_all ptt,
4060: pn_rec_agreements_all prec
4061: WHERE ptt.term_template_id = prec.term_template_id
4062: AND (ptt.tax_code_id IS NOT NULL OR ptt.tax_group_id IS NOT NULL)
4063: AND ptt.tax_classification_code IS NULL
4064: AND prec.rec_agreement_id = p_rec_agreement_id;

Line 5058: ,pn_rec_agreements_all agr

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
5062: and agrlines.rec_agreement_id = bill.rec_agreement_id

Line 5080: ,pn_rec_agreements_all agr

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
5084: and agrlines.rec_agreement_id = bill.rec_agreement_id

Line 5146: l_customer_id pn_rec_agreements_all.customer_id%TYPE;

5142: AND area_class_dtl_lines.lease_id = p_lease_id
5143: AND area_class_dtl_lines.location_id = p_location_id
5144: ;
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;

Line 5147: l_lease_id pn_rec_agreements_all.lease_id%TYPE;

5143: AND area_class_dtl_lines.location_id = p_location_id
5144: ;
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;

Line 5148: l_location_id pn_rec_agreements_all.location_id%TYPE;

5144: ;
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;

Line 5290: FUNCTION validate_create_calc_period(p_rec_agreement_id pn_rec_agreements_all.REC_AGREEMENT_ID%TYPE,

5286: | 05-Dec-2005 acprakas o Created
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