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

535: ,p_calc_period_ending IN VARCHAR2
536: ,p_org_id IN NUMBER
537: ) IS
538:
539: l_rec_agreement_id pn_rec_agreements_all.rec_agreement_id%TYPE := NULL;
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;

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

536: ,p_org_id IN NUMBER
537: ) IS
538:
539: l_rec_agreement_id pn_rec_agreements_all.rec_agreement_id%TYPE := NULL;
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

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

537: ) IS
538:
539: l_rec_agreement_id pn_rec_agreements_all.rec_agreement_id%TYPE := NULL;
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

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

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

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

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

Line 560: ,pn_rec_agreements_all pra

556: ,pra.location_id
557: ,pra.customer_id
558: ,pra.cust_site_id
559: FROM pn_leases pl
560: ,pn_rec_agreements_all pra
561: ,pn_locations_all ploc
562: WHERE pl.lease_id = pra.lease_id
563: AND ploc.location_id = pra.location_id
564: AND pl.lease_num >= nvl(p_lease_num_from, pl.lease_num)

Line 581: ,pn_rec_agreements_all pra

577: ,pra.location_id
578: ,pra.customer_id
579: ,pra.cust_site_id
580: FROM pn_leases pl
581: ,pn_rec_agreements_all pra
582: WHERE pl.lease_id = pra.lease_id
583: AND pl.lease_num >= nvl(p_lease_num_from, pl.lease_num)
584: AND pl.lease_num <= nvl(p_lease_num_to, pl.lease_num)
585: AND pra.rec_agreement_num >= nvl(p_rec_agr_num_from,pra.rec_agreement_num)

Line 598: ,pn_rec_agreements_all pra

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

Line 622: ,pn_rec_agreements_all pra

618: ,pra.location_id
619: ,pra.customer_id
620: ,pra.cust_site_id
621: FROM pn_leases pl
622: ,pn_rec_agreements_all pra
623: ,pn_locations_all ploc
624: ,pn_properties_all prop
625: WHERE pl.lease_id = pra.lease_id
626: AND ploc.location_id = pra.location_id

Line 890: l_rec_agr_name pn_rec_agreements_all.REC_AGREEMENT_NAME%TYPE;

886: l_end_date pn_rec_period_lines_all.end_date%TYPE;
887: l_billing_type pn_rec_period_lines_all.billing_type%TYPE;
888: l_billing_purpose pn_rec_period_lines_all.billing_purpose%TYPE;
889: l_error_code NUMBER := 0;
890: l_rec_agr_name pn_rec_agreements_all.REC_AGREEMENT_NAME%TYPE;
891: l_rec_agr_num pn_rec_agreements_all.REC_AGREEMENT_NUM%TYPE;
892: --------------------------------------------------------------------------
893: -- Cursor to bring all details of a line. This cursor will be used in the
894: -- event that the user chooses to hit the 'Calculate All' button and every

Line 891: l_rec_agr_num pn_rec_agreements_all.REC_AGREEMENT_NUM%TYPE;

887: l_billing_type pn_rec_period_lines_all.billing_type%TYPE;
888: l_billing_purpose pn_rec_period_lines_all.billing_purpose%TYPE;
889: l_error_code NUMBER := 0;
890: l_rec_agr_name pn_rec_agreements_all.REC_AGREEMENT_NAME%TYPE;
891: l_rec_agr_num pn_rec_agreements_all.REC_AGREEMENT_NUM%TYPE;
892: --------------------------------------------------------------------------
893: -- Cursor to bring all details of a line. This cursor will be used in the
894: -- event that the user chooses to hit the 'Calculate All' button and every
895: -- line lying within the calc period needs to be picked up for recoery calc

Line 904: FROM pn_rec_agreements_all

900: ,negative_recovery
901: ,rec_agreement_name
902: ,rec_agreement_num
903: ,org_id
904: FROM pn_rec_agreements_all
905: WHERE rec_agreement_id = p_rec_agreement_id;
906:
907: CURSOR agr_lines_all IS
908: SELECT lines.rec_agr_line_id

Line 1047: l_negative_recovery pn_rec_agreements_all.negative_recovery%TYPE;

1043: agr_lines_record agr_lines_all%ROWTYPE;
1044: calc_all_no_cons_rec calc_all_no_cons%ROWTYPE;
1045: calc_all_cons_rec calc_all_cons%ROWTYPE;
1046: calc_no_cons_rec calc_no_cons%ROWTYPE;
1047: l_negative_recovery pn_rec_agreements_all.negative_recovery%TYPE;
1048: l_opya_exists BOOLEAN := FALSE;
1049: l_opyc_exists BOOLEAN := FALSE;
1050: l_rate_amt_exists BOOLEAN := FALSE;
1051: l_total_lines NUMBER := 0;

Line 2469: ,p_customer_id pn_rec_agreements_all.customer_id%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
2473: ,p_calc_period_end_date pn_rec_calc_periods_all.end_date%TYPE

Line 2470: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE

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

Line 2471: ,p_location_id pn_rec_agreements_all.location_id%TYPE

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

Line 2630: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE

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

Line 2631: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE

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

Line 2632: ,p_location_id pn_rec_agreements_all.location_id%TYPE

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

Line 2719: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE

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

Line 2720: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE

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

Line 2721: ,p_location_id pn_rec_agreements_all.location_id%TYPE

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

Line 2742: ,pn_rec_agreements_all recagr

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

Line 2826: ,pn_rec_agreements_all recagr

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

Line 3074: ,p_customer_id pn_rec_agreements_all.customer_id%TYPE

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

Line 3075: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE

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

Line 3076: ,p_location_id pn_rec_agreements_all.location_id%TYPE

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

Line 3186: ,p_lease_id pn_rec_agreements_all.lease_id%TYPE

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

Line 3187: ,p_location_id pn_rec_agreements_all.location_id%TYPE

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

Line 3873: FROM pn_rec_agreements_all

3869: WHERE PERIOD_BILLREC_ID = X_PERIOD_BILLREC_ID;
3870:
3871: CURSOR org_cur IS
3872: SELECT org_id
3873: FROM pn_rec_agreements_all
3874: WHERE rec_agreement_id = X_REC_AGREEMENT_ID;
3875:
3876: l_org_ID NUMBER;
3877:

Line 4137: pn_rec_agreements_all prec

4133: CURSOR csr_template (p_rec_agreement_id IN NUMBER)
4134: IS
4135: SELECT ptt.*
4136: FROM pn_term_templates_all ptt,
4137: pn_rec_agreements_all prec
4138: WHERE ptt.term_template_id = prec.term_template_id
4139: AND prec.rec_agreement_id = p_rec_agreement_id;
4140:
4141: CURSOR csr_template_upg (p_rec_agreement_id IN NUMBER)

Line 4145: pn_rec_agreements_all prec

4141: CURSOR csr_template_upg (p_rec_agreement_id IN NUMBER)
4142: IS
4143: SELECT ptt.*
4144: FROM pn_term_templates_all ptt,
4145: pn_rec_agreements_all prec
4146: WHERE ptt.term_template_id = prec.term_template_id
4147: AND (ptt.tax_code_id IS NOT NULL OR ptt.tax_group_id IS NOT NULL)
4148: AND ptt.tax_classification_code IS NULL
4149: AND prec.rec_agreement_id = p_rec_agreement_id;

Line 5143: ,pn_rec_agreements_all agr

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

Line 5165: ,pn_rec_agreements_all agr

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

Line 5231: l_customer_id pn_rec_agreements_all.customer_id%TYPE;

5227: AND area_class_dtl_lines.lease_id = p_lease_id
5228: AND area_class_dtl_lines.location_id = p_location_id
5229: ;
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;

Line 5232: l_lease_id pn_rec_agreements_all.lease_id%TYPE;

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

Line 5233: l_location_id pn_rec_agreements_all.location_id%TYPE;

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

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

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