APPS.PN_RETRO_ADJUSTMENT_PKG dependencies on PN_ADJUSTMENT_SUMMARIES

Line 208: FROM pn_adjustment_summaries summary

204: CURSOR fetch_adj_items IS
205: SELECT summary.adjustment_summary_id,
206: summary.adj_schedule_date,
207: summary.sum_adj_amount
208: FROM pn_adjustment_summaries summary
209: WHERE summary.payment_term_id = p_term_id
210: ORDER BY summary.adj_schedule_date;
211:
212: l_orig_item_tbl payment_item_tbl_type;

Line 855: CURSOR get_item_details (p_adj_summ_id pn_adjustment_summaries.adjustment_summary_id%TYPE)IS

851: p_del_itm_table OUT NOCOPY payment_item_tbl_type
852: )
853: IS
854:
855: CURSOR get_item_details (p_adj_summ_id pn_adjustment_summaries.adjustment_summary_id%TYPE)IS
856: SELECT item.payment_item_id,
857: item.actual_amount amount,
858: schedule.payment_schedule_id,
859: schedule.schedule_date

Line 1627: l_adj_summ_id pn_adjustment_summaries.adjustment_summary_id%TYPE;

1623: )
1624: IS
1625: l_start_date pn_adjustment_details.adj_start_date%TYPE;
1626: l_end_date pn_adjustment_details.adj_end_date%TYPE;
1627: l_adj_summ_id pn_adjustment_summaries.adjustment_summary_id%TYPE;
1628:
1629: l_group_num NUMBER := 0;
1630: l_consolidate BOOLEAN;
1631:

Line 1657: INSERT INTO pn_adjustment_summaries (

1653: l_info := ' inserting into adjustment summary table for schedule date:'||
1654: p_adj_table(i).schedule_date;
1655: pnp_debug_pkg.log(l_info);
1656:
1657: INSERT INTO pn_adjustment_summaries (
1658: adjustment_summary_id,
1659: adj_schedule_date,
1660: payment_term_id,
1661: sum_adj_amount,

Line 1668: pn_adjustment_summaries_s.nextval,

1664: last_update_date,
1665: last_updated_by,
1666: last_update_login
1667: ) VALUES (
1668: pn_adjustment_summaries_s.nextval,
1669: p_adj_table(i).schedule_date,
1670: p_term_id,
1671: p_adj_table(i).amount,
1672: SYSDATE,

Line 1753: UPDATE pn_adjustment_summaries

1749: l_info := ' updating adjustment summary id:'||
1750: p_adj_table(i).adj_summ_id;
1751: pnp_debug_pkg.log(l_info);
1752:
1753: UPDATE pn_adjustment_summaries
1754: SET sum_adj_amount = sum_adj_amount + p_adj_table(i).amount,
1755: last_update_date = SYSDATE,
1756: last_updated_by = fnd_global.user_id,
1757: last_update_login = fnd_global.login_id