[Home] [Help]
1077: -- 10-AUG-05 piagrawa o Bug #4284035 - Passed org id of the lease to insert_row
1078: ------------------------------------------------------------------------------+
1079: PROCEDURE find_schedule (
1080: p_lease_id pn_leases.lease_id%TYPE,
1081: p_lease_change_id pn_lease_changes.lease_change_id%TYPE,
1082: p_term_id pn_payment_terms.payment_term_id%TYPE,
1083: p_schedule_date pn_payment_schedules.schedule_date%TYPE,
1084: p_schedule_id OUT NOCOPY pn_payment_schedules.payment_schedule_id%TYPE
1085: )
1208: ------------------------------------------------------------------------------+
1209: PROCEDURE get_schedule_id_for_new_items(
1210: p_lease_id pn_leases.lease_id%TYPE,
1211: p_term_id pn_payment_terms.payment_term_id%TYPE,
1212: p_lease_change_id pn_lease_changes.lease_change_id%TYPE,
1213: p_sched_tbl IN OUT NOCOPY payment_item_tbl_type
1214: )
1215: IS
1216: l_info VARCHAR2(100);
2037: ------------------------------------------------------------------------------+
2038: PROCEDURE update_terms_history(
2039: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,
2040: p_adj_type_cd pn_payment_items.last_adjustment_type_code%TYPE,
2041: p_lease_change_id pn_lease_changes.lease_change_id%TYPE,
2042: p_term_id pn_payment_terms.payment_term_id%TYPE
2043: )
2044: IS
2045:
2096: -- to pass org id.
2097: ------------------------------------------------------------------------------+
2098: PROCEDURE create_retro_adjustments(
2099: p_lease_id pn_payment_terms.lease_id%TYPE,
2100: p_lease_chg_id pn_lease_changes.lease_change_id%TYPE,
2101: p_term_id pn_payment_terms.payment_term_id%TYPE,
2102: p_term_start_dt pn_payment_terms.start_date%TYPE,
2103: p_term_end_dt pn_payment_terms.end_date%TYPE,
2104: p_term_sch_day pn_payment_terms.schedule_day%TYPE,