APPS.PN_RETRO_ADJUSTMENT_PKG dependencies on PN_PAYMENT_TERMS_HISTORY

Line 1620: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,

1616: p_term_id pn_payment_terms.payment_term_id%TYPE,
1617: p_term_freq pn_payment_terms.frequency_code%TYPE,
1618: p_term_start_dt pn_payment_terms.start_date%TYPE,
1619: p_term_end_dt pn_payment_terms.end_date%TYPE,
1620: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,
1621: p_adj_table payment_item_tbl_type,
1622: p_org_id NUMBER
1623: )
1624: IS

Line 2039: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,

2035: -- 14-OCT-04 ftanudja o Created.
2036: -- 14-JAN-05 atuppad o Added code to update total_adj_amount
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: )

Line 2050: pn_payment_terms_history pth

2046: -- Get total adj amount
2047: CURSOR get_total_adj_amt IS
2048: SELECT SUM(pad.adjustment_amount) total_adj_amount
2049: FROM pn_adjustment_details pad,
2050: pn_payment_terms_history pth
2051: WHERE pth.payment_term_id = p_term_id
2052: AND pth.lease_change_id = p_lease_change_id
2053: AND pad.term_history_id = pth.term_history_id;
2054:

Line 2067: UPDATE pn_payment_terms_history

2063: FOR amt_rec IN get_total_adj_amt LOOP
2064: l_amount := amt_rec.total_adj_amount;
2065: END LOOP;
2066:
2067: UPDATE pn_payment_terms_history
2068: SET adjustment_type_code = p_adj_type_cd,
2069: total_adj_amount = l_amount,
2070: last_update_date = SYSDATE,
2071: last_update_login = fnd_global.login_id,

Line 2107: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,

2103: p_term_end_dt pn_payment_terms.end_date%TYPE,
2104: p_term_sch_day pn_payment_terms.schedule_day%TYPE,
2105: p_term_act_amt pn_payment_terms.actual_amount%TYPE,
2106: p_term_freq pn_payment_terms.frequency_code%TYPE,
2107: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,
2108: p_adj_type_cd pn_payment_items.last_adjustment_type_code%TYPE
2109: )
2110: IS
2111: CURSOR get_last_appr_sched IS