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_INDEX_LEASE_PERIODS_PKG dependencies on PN_VAR_RENT_PKG

Line 625: pn_var_rent_pkg.lock_row_exception('INDEX_PERIOD_ID',tlinfo.index_period_id);

621: END IF;
622: CLOSE c1;
623:
624: IF NOT (tlinfo.index_period_id = x_index_period_id) THEN
625: pn_var_rent_pkg.lock_row_exception('INDEX_PERIOD_ID',tlinfo.index_period_id);
626: END IF;
627:
628: IF NOT (tlinfo.index_lease_id = x_index_lease_id) THEN
629: pn_var_rent_pkg.lock_row_exception('INDEX_LEASE_ID',tlinfo.index_lease_id);

Line 629: pn_var_rent_pkg.lock_row_exception('INDEX_LEASE_ID',tlinfo.index_lease_id);

625: pn_var_rent_pkg.lock_row_exception('INDEX_PERIOD_ID',tlinfo.index_period_id);
626: END IF;
627:
628: IF NOT (tlinfo.index_lease_id = x_index_lease_id) THEN
629: pn_var_rent_pkg.lock_row_exception('INDEX_LEASE_ID',tlinfo.index_lease_id);
630: END IF;
631:
632: IF NOT (tlinfo.line_number = x_line_number) THEN
633: pn_var_rent_pkg.lock_row_exception('LINE_NUMBER',tlinfo.line_number);

Line 633: pn_var_rent_pkg.lock_row_exception('LINE_NUMBER',tlinfo.line_number);

629: pn_var_rent_pkg.lock_row_exception('INDEX_LEASE_ID',tlinfo.index_lease_id);
630: END IF;
631:
632: IF NOT (tlinfo.line_number = x_line_number) THEN
633: pn_var_rent_pkg.lock_row_exception('LINE_NUMBER',tlinfo.line_number);
634: END IF;
635:
636: IF NOT (tlinfo.assessment_date = x_assessment_date) THEN
637: pn_var_rent_pkg.lock_row_exception('ASSESSMENT_DATE',tlinfo.assessment_date);

Line 637: pn_var_rent_pkg.lock_row_exception('ASSESSMENT_DATE',tlinfo.assessment_date);

633: pn_var_rent_pkg.lock_row_exception('LINE_NUMBER',tlinfo.line_number);
634: END IF;
635:
636: IF NOT (tlinfo.assessment_date = x_assessment_date) THEN
637: pn_var_rent_pkg.lock_row_exception('ASSESSMENT_DATE',tlinfo.assessment_date);
638: END IF;
639:
640: IF NOT ((tlinfo.basis_start_date = x_basis_start_date)
641: OR ((tlinfo.basis_start_date IS NULL) AND x_basis_start_date IS NULL)) THEN

Line 642: pn_var_rent_pkg.lock_row_exception('BASIS_START_DATE',tlinfo.basis_start_date);

638: END IF;
639:
640: IF NOT ((tlinfo.basis_start_date = x_basis_start_date)
641: OR ((tlinfo.basis_start_date IS NULL) AND x_basis_start_date IS NULL)) THEN
642: pn_var_rent_pkg.lock_row_exception('BASIS_START_DATE',tlinfo.basis_start_date);
643: END IF;
644:
645: IF NOT ((tlinfo.basis_end_date = x_basis_end_date)
646: OR ((tlinfo.basis_end_date IS NULL) AND x_basis_end_date IS NULL)) THEN

Line 647: pn_var_rent_pkg.lock_row_exception('BASIS_END_DATE',tlinfo.basis_end_date);

643: END IF;
644:
645: IF NOT ((tlinfo.basis_end_date = x_basis_end_date)
646: OR ((tlinfo.basis_end_date IS NULL) AND x_basis_end_date IS NULL)) THEN
647: pn_var_rent_pkg.lock_row_exception('BASIS_END_DATE',tlinfo.basis_end_date);
648: END IF;
649:
650: IF NOT ((tlinfo.index_finder_date = x_index_finder_date)
651: OR ((tlinfo.index_finder_date IS NULL) AND x_index_finder_date IS NULL)) THEN

Line 652: pn_var_rent_pkg.lock_row_exception('INDEX_FINDER_DATE',tlinfo.index_finder_date);

648: END IF;
649:
650: IF NOT ((tlinfo.index_finder_date = x_index_finder_date)
651: OR ((tlinfo.index_finder_date IS NULL) AND x_index_finder_date IS NULL)) THEN
652: pn_var_rent_pkg.lock_row_exception('INDEX_FINDER_DATE',tlinfo.index_finder_date);
653: END IF;
654:
655: IF NOT ((tlinfo.current_index_line_id = x_current_index_line_id)
656: OR ((tlinfo.current_index_line_id IS NULL) AND x_current_index_line_id IS NULL)) THEN

Line 657: pn_var_rent_pkg.lock_row_exception('CURRENT_INDEX_LINE_ID',tlinfo.current_index_line_id);

653: END IF;
654:
655: IF NOT ((tlinfo.current_index_line_id = x_current_index_line_id)
656: OR ((tlinfo.current_index_line_id IS NULL) AND x_current_index_line_id IS NULL)) THEN
657: pn_var_rent_pkg.lock_row_exception('CURRENT_INDEX_LINE_ID',tlinfo.current_index_line_id);
658: END IF;
659:
660: IF NOT ((tlinfo.current_index_line_value = x_current_index_line_value)
661: OR ((tlinfo.current_index_line_value IS NULL) AND x_current_index_line_value IS NULL)) THEN

Line 662: pn_var_rent_pkg.lock_row_exception('CURRENT_INDEX_LINE_VALUE',tlinfo.current_index_line_value);

658: END IF;
659:
660: IF NOT ((tlinfo.current_index_line_value = x_current_index_line_value)
661: OR ((tlinfo.current_index_line_value IS NULL) AND x_current_index_line_value IS NULL)) THEN
662: pn_var_rent_pkg.lock_row_exception('CURRENT_INDEX_LINE_VALUE',tlinfo.current_index_line_value);
663: END IF;
664:
665: IF NOT ((tlinfo.previous_index_line_id = x_previous_index_line_id)
666: OR ((tlinfo.previous_index_line_id IS NULL) AND x_previous_index_line_id IS NULL)) THEN

Line 667: pn_var_rent_pkg.lock_row_exception('PREVIOUS_INDEX_LINE_ID',tlinfo.previous_index_line_id);

663: END IF;
664:
665: IF NOT ((tlinfo.previous_index_line_id = x_previous_index_line_id)
666: OR ((tlinfo.previous_index_line_id IS NULL) AND x_previous_index_line_id IS NULL)) THEN
667: pn_var_rent_pkg.lock_row_exception('PREVIOUS_INDEX_LINE_ID',tlinfo.previous_index_line_id);
668: END IF;
669:
670: IF NOT ((tlinfo.previous_index_line_value = x_previous_index_line_value)
671: OR ((tlinfo.previous_index_line_value IS NULL) AND x_previous_index_line_value IS NULL)) THEN

Line 672: pn_var_rent_pkg.lock_row_exception('PREVIOUS_INDEX_LINE_VALUE',tlinfo.previous_index_line_value);

668: END IF;
669:
670: IF NOT ((tlinfo.previous_index_line_value = x_previous_index_line_value)
671: OR ((tlinfo.previous_index_line_value IS NULL) AND x_previous_index_line_value IS NULL)) THEN
672: pn_var_rent_pkg.lock_row_exception('PREVIOUS_INDEX_LINE_VALUE',tlinfo.previous_index_line_value);
673: END IF;
674:
675: IF NOT ((tlinfo.current_basis = x_current_basis)
676: OR ((tlinfo.current_basis IS NULL) AND x_current_basis IS NULL)) THEN

Line 677: pn_var_rent_pkg.lock_row_exception('CURRENT_BASIS',tlinfo.current_basis);

673: END IF;
674:
675: IF NOT ((tlinfo.current_basis = x_current_basis)
676: OR ((tlinfo.current_basis IS NULL) AND x_current_basis IS NULL)) THEN
677: pn_var_rent_pkg.lock_row_exception('CURRENT_BASIS',tlinfo.current_basis);
678: END IF;
679:
680: IF NOT ((tlinfo.relationship = x_relationship)
681: OR ((tlinfo.relationship IS NULL) AND x_relationship IS NULL)) THEN

Line 682: pn_var_rent_pkg.lock_row_exception('RELATIONSHIP',tlinfo.relationship);

678: END IF;
679:
680: IF NOT ((tlinfo.relationship = x_relationship)
681: OR ((tlinfo.relationship IS NULL) AND x_relationship IS NULL)) THEN
682: pn_var_rent_pkg.lock_row_exception('RELATIONSHIP',tlinfo.relationship);
683: END IF;
684:
685: IF NOT ((tlinfo.index_percent_change = x_index_percent_change)
686: OR ((tlinfo.index_percent_change IS NULL) AND x_index_percent_change IS NULL)) THEN

Line 687: pn_var_rent_pkg.lock_row_exception('INDEX_PERCENT_CHANGE',tlinfo.index_percent_change);

683: END IF;
684:
685: IF NOT ((tlinfo.index_percent_change = x_index_percent_change)
686: OR ((tlinfo.index_percent_change IS NULL) AND x_index_percent_change IS NULL)) THEN
687: pn_var_rent_pkg.lock_row_exception('INDEX_PERCENT_CHANGE',tlinfo.index_percent_change);
688: END IF;
689:
690: IF NOT ((tlinfo.basis_percent_change = x_basis_percent_change)
691: OR ((tlinfo.basis_percent_change IS NULL) AND x_basis_percent_change IS NULL)) THEN

Line 692: pn_var_rent_pkg.lock_row_exception('BASIS_PERCENT_CHANGE',tlinfo.basis_percent_change);

688: END IF;
689:
690: IF NOT ((tlinfo.basis_percent_change = x_basis_percent_change)
691: OR ((tlinfo.basis_percent_change IS NULL) AND x_basis_percent_change IS NULL)) THEN
692: pn_var_rent_pkg.lock_row_exception('BASIS_PERCENT_CHANGE',tlinfo.basis_percent_change);
693: END IF;
694:
695: IF NOT ((tlinfo.unconstraint_rent_due = x_unconstraint_rent_due)
696: OR ((tlinfo.unconstraint_rent_due IS NULL) AND x_unconstraint_rent_due IS NULL)) THEN

Line 697: pn_var_rent_pkg.lock_row_exception('UNCONSTRAINT_RENT_DUE',tlinfo.unconstraint_rent_due);

693: END IF;
694:
695: IF NOT ((tlinfo.unconstraint_rent_due = x_unconstraint_rent_due)
696: OR ((tlinfo.unconstraint_rent_due IS NULL) AND x_unconstraint_rent_due IS NULL)) THEN
697: pn_var_rent_pkg.lock_row_exception('UNCONSTRAINT_RENT_DUE',tlinfo.unconstraint_rent_due);
698: END IF;
699:
700: IF NOT ((tlinfo.constraint_rent_due = x_constraint_rent_due)
701: OR ((tlinfo.constraint_rent_due IS NULL) AND x_constraint_rent_due IS NULL)) THEN

Line 702: pn_var_rent_pkg.lock_row_exception('CONSTRAINT_RENT_DUE',tlinfo.constraint_rent_due);

698: END IF;
699:
700: IF NOT ((tlinfo.constraint_rent_due = x_constraint_rent_due)
701: OR ((tlinfo.constraint_rent_due IS NULL) AND x_constraint_rent_due IS NULL)) THEN
702: pn_var_rent_pkg.lock_row_exception('CONSTRAINT_RENT_DUE',tlinfo.constraint_rent_due);
703: END IF;
704:
705: IF NOT ((tlinfo.index_multiplier = x_index_multiplier)
706: OR ((tlinfo.index_multiplier IS NULL) AND x_index_multiplier IS NULL)) THEN

Line 707: pn_var_rent_pkg.lock_row_exception('CONSTRAINT_RENT_DUE',tlinfo.index_multiplier);

703: END IF;
704:
705: IF NOT ((tlinfo.index_multiplier = x_index_multiplier)
706: OR ((tlinfo.index_multiplier IS NULL) AND x_index_multiplier IS NULL)) THEN
707: pn_var_rent_pkg.lock_row_exception('CONSTRAINT_RENT_DUE',tlinfo.index_multiplier);
708: END IF;
709:
710: IF NOT ((tlinfo.constraint_applied_amount = x_constraint_applied_amount)
711: OR ((tlinfo.constraint_applied_amount IS NULL) AND x_constraint_applied_amount IS NULL)) THEN

Line 712: pn_var_rent_pkg.lock_row_exception('CONSTRAINT_RENT_DUE',tlinfo.constraint_applied_amount);

708: END IF;
709:
710: IF NOT ((tlinfo.constraint_applied_amount = x_constraint_applied_amount)
711: OR ((tlinfo.constraint_applied_amount IS NULL) AND x_constraint_applied_amount IS NULL)) THEN
712: pn_var_rent_pkg.lock_row_exception('CONSTRAINT_RENT_DUE',tlinfo.constraint_applied_amount);
713: END IF;
714:
715: IF NOT ((tlinfo.constraint_applied_percent = x_constraint_applied_percent)
716: OR ((tlinfo.constraint_applied_percent IS NULL) AND x_constraint_applied_percent IS NULL)) THEN

Line 717: pn_var_rent_pkg.lock_row_exception('CONSTRAINT_RENT_DUE',tlinfo.constraint_applied_percent);

713: END IF;
714:
715: IF NOT ((tlinfo.constraint_applied_percent = x_constraint_applied_percent)
716: OR ((tlinfo.constraint_applied_percent IS NULL) AND x_constraint_applied_percent IS NULL)) THEN
717: pn_var_rent_pkg.lock_row_exception('CONSTRAINT_RENT_DUE',tlinfo.constraint_applied_percent);
718: END IF;
719:
720: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_PERIODS_PKG.lock_row (-)');
721: END lock_row;