APPS.PN_RETRO_ADJUSTMENT_PKG dependencies on PN_PAYMENT_TERMS_HISTORY

Line 1599: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,

1595: p_term_id pn_payment_terms.payment_term_id%TYPE,
1596: p_term_freq pn_payment_terms.frequency_code%TYPE,
1597: p_term_start_dt pn_payment_terms.start_date%TYPE,
1598: p_term_end_dt pn_payment_terms.end_date%TYPE,
1599: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,
1600: p_adj_table payment_item_tbl_type,
1601: p_org_id NUMBER
1602: )
1603: IS

Line 2018: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,

2014: -- 14-OCT-04 ftanudja o Created.
2015: -- 14-JAN-05 atuppad o Added code to update total_adj_amount
2016: ------------------------------------------------------------------------------+
2017: PROCEDURE update_terms_history(
2018: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,
2019: p_adj_type_cd pn_payment_items.last_adjustment_type_code%TYPE,
2020: p_lease_change_id pn_lease_changes.lease_change_id%TYPE,
2021: p_term_id pn_payment_terms.payment_term_id%TYPE
2022: )

Line 2029: pn_payment_terms_history pth

2025: -- Get total adj amount
2026: CURSOR get_total_adj_amt IS
2027: SELECT SUM(pad.adjustment_amount) total_adj_amount
2028: FROM pn_adjustment_details pad,
2029: pn_payment_terms_history pth
2030: WHERE pth.payment_term_id = p_term_id
2031: AND pth.lease_change_id = p_lease_change_id
2032: AND pad.term_history_id = pth.term_history_id;
2033:

Line 2046: UPDATE pn_payment_terms_history

2042: FOR amt_rec IN get_total_adj_amt LOOP
2043: l_amount := amt_rec.total_adj_amount;
2044: END LOOP;
2045:
2046: UPDATE pn_payment_terms_history
2047: SET adjustment_type_code = p_adj_type_cd,
2048: total_adj_amount = l_amount,
2049: last_update_date = SYSDATE,
2050: last_update_login = fnd_global.login_id,

Line 2086: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,

2082: p_term_end_dt pn_payment_terms.end_date%TYPE,
2083: p_term_sch_day pn_payment_terms.schedule_day%TYPE,
2084: p_term_act_amt pn_payment_terms.actual_amount%TYPE,
2085: p_term_freq pn_payment_terms.frequency_code%TYPE,
2086: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,
2087: p_adj_type_cd pn_payment_items.last_adjustment_type_code%TYPE
2088: )
2089: IS
2090: CURSOR get_last_appr_sched IS