DBA Data[Home] [Help]

APPS.PNRX_RENT_INCREASE_SUMMARY dependencies on PNRX_RENT_INCREASE_DETAIL

Line 29: l_vendor_rec pnrx_rent_increase_detail.vendor_rec;

25: l_precision NUMBER; -- slk
26: l_ext_precision NUMBER; -- slk
27: l_min_acct_unit NUMBER; -- slk
28: l_currency_code pn_index_leases.currency_code%TYPE; -- slk
29: l_vendor_rec pnrx_rent_increase_detail.vendor_rec;
30: l_customer_rec pnrx_rent_increase_detail.customer_rec;
31: l_lease_detail pnrx_rent_increase_detail.lease_detail;
32: l_lease_detail_null pnrx_rent_increase_detail.lease_detail;
33: v_status VARCHAR2 (30) :='APPROVED';

Line 30: l_customer_rec pnrx_rent_increase_detail.customer_rec;

26: l_ext_precision NUMBER; -- slk
27: l_min_acct_unit NUMBER; -- slk
28: l_currency_code pn_index_leases.currency_code%TYPE; -- slk
29: l_vendor_rec pnrx_rent_increase_detail.vendor_rec;
30: l_customer_rec pnrx_rent_increase_detail.customer_rec;
31: l_lease_detail pnrx_rent_increase_detail.lease_detail;
32: l_lease_detail_null pnrx_rent_increase_detail.lease_detail;
33: v_status VARCHAR2 (30) :='APPROVED';
34:

Line 31: l_lease_detail pnrx_rent_increase_detail.lease_detail;

27: l_min_acct_unit NUMBER; -- slk
28: l_currency_code pn_index_leases.currency_code%TYPE; -- slk
29: l_vendor_rec pnrx_rent_increase_detail.vendor_rec;
30: l_customer_rec pnrx_rent_increase_detail.customer_rec;
31: l_lease_detail pnrx_rent_increase_detail.lease_detail;
32: l_lease_detail_null pnrx_rent_increase_detail.lease_detail;
33: v_status VARCHAR2 (30) :='APPROVED';
34:
35: TYPE cur_typ IS REF CURSOR;

Line 32: l_lease_detail_null pnrx_rent_increase_detail.lease_detail;

28: l_currency_code pn_index_leases.currency_code%TYPE; -- slk
29: l_vendor_rec pnrx_rent_increase_detail.vendor_rec;
30: l_customer_rec pnrx_rent_increase_detail.customer_rec;
31: l_lease_detail pnrx_rent_increase_detail.lease_detail;
32: l_lease_detail_null pnrx_rent_increase_detail.lease_detail;
33: v_status VARCHAR2 (30) :='APPROVED';
34:
35: TYPE cur_typ IS REF CURSOR;
36:

Line 486: pnrx_rent_increase_detail.get_index_name (

482: pn_index_lease_common_pkg.get_approver (
483: l_lease_detail.abstracted_by_user
484: );
485: term_rec.index_name :=
486: pnrx_rent_increase_detail.get_index_name (
487: l_lease_detail.index_id
488: );
489: term_rec.location_code :=
490: pnrx_rent_increase_detail.get_location_code (

Line 490: pnrx_rent_increase_detail.get_location_code (

486: pnrx_rent_increase_detail.get_index_name (
487: l_lease_detail.index_id
488: );
489: term_rec.location_code :=
490: pnrx_rent_increase_detail.get_location_code (
491: l_lease_detail.location_id
492: );
493: term_rec.lease_class_meaning :=
494: pnrx_rent_increase_detail.get_lookup_meaning (

Line 494: pnrx_rent_increase_detail.get_lookup_meaning (

490: pnrx_rent_increase_detail.get_location_code (
491: l_lease_detail.location_id
492: );
493: term_rec.lease_class_meaning :=
494: pnrx_rent_increase_detail.get_lookup_meaning (
495: l_lease_detail.lease_class_code,
496: 'PN_LEASE_CLASS'
497: );
498: term_rec.increase_on_meaning :=

Line 499: pnrx_rent_increase_detail.get_lookup_meaning (

495: l_lease_detail.lease_class_code,
496: 'PN_LEASE_CLASS'
497: );
498: term_rec.increase_on_meaning :=
499: pnrx_rent_increase_detail.get_lookup_meaning (
500: l_lease_detail.increase_on,
501: 'PN_PAYMENT_TERM_TYPE'
502: );
503: term_rec.reference_period_meaning :=

Line 504: pnrx_rent_increase_detail.get_lookup_meaning (

500: l_lease_detail.increase_on,
501: 'PN_PAYMENT_TERM_TYPE'
502: );
503: term_rec.reference_period_meaning :=
504: pnrx_rent_increase_detail.get_lookup_meaning (
505: l_lease_detail.reference_period,
506: 'PN_INDEX_REF_PERIOD'
507: );
508: term_rec.negative_rent_type_meaning :=

Line 509: pnrx_rent_increase_detail.get_lookup_meaning (

505: l_lease_detail.reference_period,
506: 'PN_INDEX_REF_PERIOD'
507: );
508: term_rec.negative_rent_type_meaning :=
509: pnrx_rent_increase_detail.get_lookup_meaning (
510: l_lease_detail.negative_rent_type,
511: 'PN_INDEX_NEGATIVE_RENT'
512: );
513: term_rec.relationship_meaning :=

Line 514: pnrx_rent_increase_detail.get_lookup_meaning (

510: l_lease_detail.negative_rent_type,
511: 'PN_INDEX_NEGATIVE_RENT'
512: );
513: term_rec.relationship_meaning :=
514: pnrx_rent_increase_detail.get_lookup_meaning (
515: l_lease_detail.relationship,
516: 'PN_INDEX_RELATION'
517: );
518: term_rec.spread_frequency_meaning :=

Line 519: pnrx_rent_increase_detail.get_lookup_meaning (

515: l_lease_detail.relationship,
516: 'PN_INDEX_RELATION'
517: );
518: term_rec.spread_frequency_meaning :=
519: pnrx_rent_increase_detail.get_lookup_meaning (
520: l_lease_detail.spread_frequency,
521: 'PN_PAYMENT_FREQUENCY_TYPE'
522: );
523: term_rec.constraint_proration :=

Line 524: pnrx_rent_increase_detail.get_lookup_meaning (

520: l_lease_detail.spread_frequency,
521: 'PN_PAYMENT_FREQUENCY_TYPE'
522: );
523: term_rec.constraint_proration :=
524: pnrx_rent_increase_detail.get_lookup_meaning (
525: l_lease_detail.proration_rule,
526: 'PN_CONSTRAINT_PRORATION'
527: );
528: term_rec.index_finder_method :=

Line 529: pnrx_rent_increase_detail.get_lookup_meaning (

525: l_lease_detail.proration_rule,
526: 'PN_CONSTRAINT_PRORATION'
527: );
528: term_rec.index_finder_method :=
529: pnrx_rent_increase_detail.get_lookup_meaning (
530: l_lease_detail.index_finder_method,
531: 'PN_INDEX_FINDER_METHOD'
532: );
533: term_rec.basis_type :=

Line 534: pnrx_rent_increase_detail.get_lookup_meaning (

530: l_lease_detail.index_finder_method,
531: 'PN_INDEX_FINDER_METHOD'
532: );
533: term_rec.basis_type :=
534: pnrx_rent_increase_detail.get_lookup_meaning (
535: l_lease_detail.basis_type,
536: 'PN_INDEX_BASIS_TYPE'
537: );
538: pnp_debug_pkg.put_log_msg ('pn_rentincdet_get_details(-)');