95: -12 * term_rec.assessment_interval
96: );
97:
98: BEGIN
99: pnp_debug_pkg.put_log_msg ('pn_rentincdet_where_cond_set(+)');
100:
101: --Initialise status parameters...
102: retcode := 0;
103: errbuf := '';
172: || ''''
173: || p_assess_date_to
174: || '''';
175: END IF;
176: pnp_debug_pkg.put_log_msg ('inlcude var rent'||p_include_draft);
177:
178: IF p_include_draft='N' OR p_include_draft IS NULL
179: THEN
180: include_draft_where :=
373: property_name_from := NULL;
374: property_name_where := NULL;
375: END IF;
376:
377: pnp_debug_pkg.put_log_msg ('pn_rentincdet_where_cond_set(-)');
378:
379: --lease cursor.....
380: OPEN c_lease_pn FOR 'SELECT
381: l.name
484: || property_name_where
485: || building_name_where
486: || rent_type_where
487: || include_draft_where;
488: pnp_debug_pkg.put_log_msg ('pn_rentincdet_open_cursor(+)');
489:
490: LOOP --start lease loop....
491: term_rec := term_rec_null;
492: l_lease_detail := l_lease_detail_null;
583: term_rec.tax_included,
584: term_rec.include_in_var_rent; -- slk
585:
586: EXIT WHEN c_lease_pn%NOTFOUND;
587: pnp_debug_pkg.put_log_msg ('pn_rentincdet_get_details(+)');
588: term_rec.abstracted_by_user_name :=
589: pn_index_lease_common_pkg.get_approver (
590: l_lease_detail.abstracted_by_user
591: );
740: 'PN_PAYMENT_BKPT_BASIS_TYPE'
741: );
742:
743:
744: pnp_debug_pkg.put_log_msg ('pn_rentincdet_get_details(-)');
745:
746: -- slk start
747: fnd_currency.get_info (term_rec.currency_code,
748: l_precision,
985: term_rec.last_update_login,
986: term_rec.request_id
987: );
988:
989: pnp_debug_pkg.put_log_msg ('pn_rentincdet_insert(-)');
990:
991: END LOOP; --end lease loop...
992:
993: pnp_debug_pkg.put_log_msg ('pn_rentincdet_open_cursor(-)');
989: pnp_debug_pkg.put_log_msg ('pn_rentincdet_insert(-)');
990:
991: END LOOP; --end lease loop...
992:
993: pnp_debug_pkg.put_log_msg ('pn_rentincdet_open_cursor(-)');
994:
995: EXCEPTION
996: WHEN OTHERS
997: THEN