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.PNRX_RENT_INCREASE_DETAILACC dependencies on PNRX_RENT_INCREASE_DETAIL

Line 1: PACKAGE BODY pnrx_rent_increase_detailacc AS

1: PACKAGE BODY pnrx_rent_increase_detailacc AS
2: /* $Header: PNRXADRB.pls 120.0 2007/10/03 14:25:27 rthumma noship $ */
3: PROCEDURE rent_increase_detailacc (
4: p_lease_number_low IN VARCHAR2 DEFAULT NULL,
5: p_lease_number_high IN VARCHAR2 DEFAULT NULL,

Line 32: l_vendor_rec pnrx_rent_increase_detail.vendor_rec;

28: l_assess_date VARCHAR2 (10);
29: l_precision NUMBER; -- slk
30: l_ext_precision NUMBER; -- slk
31: l_min_acct_unit NUMBER; -- slk
32: l_vendor_rec pnrx_rent_increase_detail.vendor_rec;
33: l_customer_rec pnrx_rent_increase_detail.customer_rec;
34: l_lease_detail pnrx_rent_increase_detail.lease_detail;
35: l_lease_detail_null pnrx_rent_increase_detail.lease_detail;
36: v_status VARCHAR2 (30) :='APPROVED';

Line 33: l_customer_rec pnrx_rent_increase_detail.customer_rec;

29: l_precision NUMBER; -- slk
30: l_ext_precision NUMBER; -- slk
31: l_min_acct_unit NUMBER; -- slk
32: l_vendor_rec pnrx_rent_increase_detail.vendor_rec;
33: l_customer_rec pnrx_rent_increase_detail.customer_rec;
34: l_lease_detail pnrx_rent_increase_detail.lease_detail;
35: l_lease_detail_null pnrx_rent_increase_detail.lease_detail;
36: v_status VARCHAR2 (30) :='APPROVED';
37:

Line 34: l_lease_detail pnrx_rent_increase_detail.lease_detail;

30: l_ext_precision NUMBER; -- slk
31: l_min_acct_unit NUMBER; -- slk
32: l_vendor_rec pnrx_rent_increase_detail.vendor_rec;
33: l_customer_rec pnrx_rent_increase_detail.customer_rec;
34: l_lease_detail pnrx_rent_increase_detail.lease_detail;
35: l_lease_detail_null pnrx_rent_increase_detail.lease_detail;
36: v_status VARCHAR2 (30) :='APPROVED';
37:
38: TYPE cur_typ IS REF CURSOR;

Line 35: l_lease_detail_null pnrx_rent_increase_detail.lease_detail;

31: l_min_acct_unit NUMBER; -- slk
32: l_vendor_rec pnrx_rent_increase_detail.vendor_rec;
33: l_customer_rec pnrx_rent_increase_detail.customer_rec;
34: l_lease_detail pnrx_rent_increase_detail.lease_detail;
35: l_lease_detail_null pnrx_rent_increase_detail.lease_detail;
36: v_status VARCHAR2 (30) :='APPROVED';
37:
38: TYPE cur_typ IS REF CURSOR;
39:

Line 588: pnrx_rent_increase_detail.get_vendor (l_lease_detail.vendor_id);

584: pn_index_lease_common_pkg.get_approver (
585: l_lease_detail.abstracted_by_user
586: );
587: l_vendor_rec :=
588: pnrx_rent_increase_detail.get_vendor (l_lease_detail.vendor_id);
589: term_rec.vendor_name := l_vendor_rec.vendor_name;
590: term_rec.supplier_number := l_vendor_rec.vendor_number;
591: term_rec.vendor_site_code :=
592: pnrx_rent_increase_detail.get_vendor_site (

Line 592: pnrx_rent_increase_detail.get_vendor_site (

588: pnrx_rent_increase_detail.get_vendor (l_lease_detail.vendor_id);
589: term_rec.vendor_name := l_vendor_rec.vendor_name;
590: term_rec.supplier_number := l_vendor_rec.vendor_number;
591: term_rec.vendor_site_code :=
592: pnrx_rent_increase_detail.get_vendor_site (
593: l_lease_detail.vendor_site_id
594: );
595: l_customer_rec :=
596: pnrx_rent_increase_detail.get_customer (

Line 596: pnrx_rent_increase_detail.get_customer (

592: pnrx_rent_increase_detail.get_vendor_site (
593: l_lease_detail.vendor_site_id
594: );
595: l_customer_rec :=
596: pnrx_rent_increase_detail.get_customer (
597: l_lease_detail.customer_id
598: );
599: term_rec.customer_name := l_customer_rec.customer_name;
600: term_rec.customer_number := l_customer_rec.customer_number;

Line 602: pnrx_rent_increase_detail.get_customer_bill_site (

598: );
599: term_rec.customer_name := l_customer_rec.customer_name;
600: term_rec.customer_number := l_customer_rec.customer_number;
601: term_rec.customer_bill_site :=
602: pnrx_rent_increase_detail.get_customer_bill_site (
603: l_lease_detail.customer_site_use_id
604: );
605: term_rec.customer_ship_site :=
606: pnrx_rent_increase_detail.get_customer_ship_site (

Line 606: pnrx_rent_increase_detail.get_customer_ship_site (

602: pnrx_rent_increase_detail.get_customer_bill_site (
603: l_lease_detail.customer_site_use_id
604: );
605: term_rec.customer_ship_site :=
606: pnrx_rent_increase_detail.get_customer_ship_site (
607: l_lease_detail.cust_ship_site_id
608: );
609: term_rec.account_rule_name :=
610: pn_index_lease_common_pkg.get_accounting_rule (

Line 614: pnrx_rent_increase_detail.get_index_name (

610: pn_index_lease_common_pkg.get_accounting_rule (
611: l_lease_detail.account_rule_id
612: );
613: term_rec.index_name :=
614: pnrx_rent_increase_detail.get_index_name (
615: l_lease_detail.index_id
616: );
617: term_rec.location_code :=
618: pnrx_rent_increase_detail.get_location_code (

Line 618: pnrx_rent_increase_detail.get_location_code (

614: pnrx_rent_increase_detail.get_index_name (
615: l_lease_detail.index_id
616: );
617: term_rec.location_code :=
618: pnrx_rent_increase_detail.get_location_code (
619: l_lease_detail.location_id
620: );
621: term_rec.project_number :=
622: pnrx_rent_increase_detail.get_project_number (

Line 622: pnrx_rent_increase_detail.get_project_number (

618: pnrx_rent_increase_detail.get_location_code (
619: l_lease_detail.location_id
620: );
621: term_rec.project_number :=
622: pnrx_rent_increase_detail.get_project_number (
623: l_lease_detail.project_id
624: );
625: term_rec.task_number :=
626: pnrx_rent_increase_detail.get_task_number (

Line 626: pnrx_rent_increase_detail.get_task_number (

622: pnrx_rent_increase_detail.get_project_number (
623: l_lease_detail.project_id
624: );
625: term_rec.task_number :=
626: pnrx_rent_increase_detail.get_task_number (
627: l_lease_detail.task_id
628: );
629: term_rec.organization_name :=
630: pnp_util_func.get_ap_organization_name (

Line 645: pnrx_rent_increase_detail.get_lookup_meaning (

641: pn_r12_util_pkg.get_ap_tax_code_name (
642: l_lease_detail.tax_code_id
643: );
644: term_rec.account_class_meaning :=
645: pnrx_rent_increase_detail.get_lookup_meaning (
646: l_lease_detail.account_class,
647: 'PN_PAY_ACCOUNT_TYPE'
648: );
649: END IF;

Line 662: pnrx_rent_increase_detail.get_lookup_meaning (

658: pn_r12_util_pkg.get_ar_tax_code_name (
659: l_lease_detail.tax_code_id
660: );
661: term_rec.account_class_meaning :=
662: pnrx_rent_increase_detail.get_lookup_meaning (
663: l_lease_detail.account_class,
664: 'PN_REC_ACCOUNT_TYPE'
665: );
666: END IF;

Line 671: pnrx_rent_increase_detail.get_lookup_meaning (

667:
668: term_rec.salesrep_name :=
669: pnp_util_func.get_salesrep_name (l_lease_detail.salesrep_id,l_org_id);
670: term_rec.lease_class_meaning :=
671: pnrx_rent_increase_detail.get_lookup_meaning (
672: l_lease_detail.lease_class_code,
673: 'PN_LEASE_CLASS'
674: );
675: term_rec.increase_on_meaning :=

Line 676: pnrx_rent_increase_detail.get_lookup_meaning (

672: l_lease_detail.lease_class_code,
673: 'PN_LEASE_CLASS'
674: );
675: term_rec.increase_on_meaning :=
676: pnrx_rent_increase_detail.get_lookup_meaning (
677: l_lease_detail.increase_on,
678: 'PN_PAYMENT_TERM_TYPE'
679: );
680: term_rec.reference_period_meaning :=

Line 681: pnrx_rent_increase_detail.get_lookup_meaning (

677: l_lease_detail.increase_on,
678: 'PN_PAYMENT_TERM_TYPE'
679: );
680: term_rec.reference_period_meaning :=
681: pnrx_rent_increase_detail.get_lookup_meaning (
682: l_lease_detail.reference_period,
683: 'PN_INDEX_REF_PERIOD'
684: );
685: term_rec.negative_rent_type_meaning :=

Line 686: pnrx_rent_increase_detail.get_lookup_meaning (

682: l_lease_detail.reference_period,
683: 'PN_INDEX_REF_PERIOD'
684: );
685: term_rec.negative_rent_type_meaning :=
686: pnrx_rent_increase_detail.get_lookup_meaning (
687: l_lease_detail.negative_rent_type,
688: 'PN_INDEX_NEGATIVE_RENT'
689: );
690: term_rec.relationship_meaning :=

Line 691: pnrx_rent_increase_detail.get_lookup_meaning (

687: l_lease_detail.negative_rent_type,
688: 'PN_INDEX_NEGATIVE_RENT'
689: );
690: term_rec.relationship_meaning :=
691: pnrx_rent_increase_detail.get_lookup_meaning (
692: l_lease_detail.relationship,
693: 'PN_INDEX_RELATION'
694: );
695: term_rec.frequency_meaning :=

Line 696: pnrx_rent_increase_detail.get_lookup_meaning (

692: l_lease_detail.relationship,
693: 'PN_INDEX_RELATION'
694: );
695: term_rec.frequency_meaning :=
696: pnrx_rent_increase_detail.get_lookup_meaning (
697: l_lease_detail.frequency_code,
698: 'PN_PAYMENT_FREQUENCY_TYPE'
699: );
700:

Line 702: pnrx_rent_increase_detail.get_lookup_meaning (

698: 'PN_PAYMENT_FREQUENCY_TYPE'
699: );
700:
701: term_rec.spread_frequency_meaning :=
702: pnrx_rent_increase_detail.get_lookup_meaning (
703: l_lease_detail.spread_frequency,
704: 'PN_PAYMENT_FREQUENCY_TYPE'
705: );
706:

Line 708: pnrx_rent_increase_detail.get_lookup_meaning (

704: 'PN_PAYMENT_FREQUENCY_TYPE'
705: );
706:
707: term_rec.payment_purpose_meaning :=
708: pnrx_rent_increase_detail.get_lookup_meaning (
709: l_lease_detail.payment_purpose_code,
710: 'PN_PAYMENT_PURPOSE_TYPE'
711: );
712: term_rec.payment_term_type_meaning :=

Line 713: pnrx_rent_increase_detail.get_lookup_meaning (

709: l_lease_detail.payment_purpose_code,
710: 'PN_PAYMENT_PURPOSE_TYPE'
711: );
712: term_rec.payment_term_type_meaning :=
713: pnrx_rent_increase_detail.get_lookup_meaning (
714: l_lease_detail.payment_term_type_code,
715: 'PN_PAYMENT_TERM_TYPE'
716: );
717: term_rec.area :=

Line 755: pnrx_rent_increase_detail.get_lookup_meaning (

751: p_chart_of_accounts_id,
752: l_lease_detail.account_id
753: );
754: term_rec.constraint_proration :=
755: pnrx_rent_increase_detail.get_lookup_meaning (
756: l_lease_detail.proration_rule,
757: 'PN_CONSTRAINT_PRORATION'
758: );
759: term_rec.index_finder_method :=

Line 760: pnrx_rent_increase_detail.get_lookup_meaning (

756: l_lease_detail.proration_rule,
757: 'PN_CONSTRAINT_PRORATION'
758: );
759: term_rec.index_finder_method :=
760: pnrx_rent_increase_detail.get_lookup_meaning (
761: l_lease_detail.index_finder_method,
762: 'PN_INDEX_FINDER_METHOD'
763: );
764: term_rec.basis_type :=

Line 765: pnrx_rent_increase_detail.get_lookup_meaning (

761: l_lease_detail.index_finder_method,
762: 'PN_INDEX_FINDER_METHOD'
763: );
764: term_rec.basis_type :=
765: pnrx_rent_increase_detail.get_lookup_meaning (
766: l_lease_detail.basis_type,
767: 'PN_INDEX_BASIS_TYPE'
768: );
769: term_rec.include_in_var_rent :=

Line 770: pnrx_rent_increase_detail.get_lookup_meaning (

766: l_lease_detail.basis_type,
767: 'PN_INDEX_BASIS_TYPE'
768: );
769: term_rec.include_in_var_rent :=
770: pnrx_rent_increase_detail.get_lookup_meaning (
771: term_rec.include_in_var_rent,
772: 'PN_PAYMENT_BKPT_BASIS_TYPE'
773: );
774: pnp_debug_pkg.put_log_msg ('pn_rentincdet_get_details(-)');

Line 1040: END pnrx_rent_increase_detailacc;

1036: errbuf := SUBSTR (SQLERRM, 1, 235);
1037: RAISE;
1038: COMMIT;
1039: END rent_increase_detailacc;
1040: END pnrx_rent_increase_detailacc;