APPS.PN_RETRO_ADJUSTMENT_PKG dependencies on PN_ADJUSTMENT_SUMMARIES

Line 187: FROM pn_adjustment_summaries summary

183: CURSOR fetch_adj_items IS
184: SELECT summary.adjustment_summary_id,
185: summary.adj_schedule_date,
186: summary.sum_adj_amount
187: FROM pn_adjustment_summaries summary
188: WHERE summary.payment_term_id = p_term_id
189: ORDER BY summary.adj_schedule_date;
190:
191: l_orig_item_tbl payment_item_tbl_type;

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

830: p_del_itm_table OUT NOCOPY payment_item_tbl_type
831: )
832: IS
833:
834: CURSOR get_item_details (p_adj_summ_id pn_adjustment_summaries.adjustment_summary_id%TYPE)IS
835: SELECT item.payment_item_id,
836: item.actual_amount amount,
837: schedule.payment_schedule_id,
838: schedule.schedule_date

Line 1606: l_adj_summ_id pn_adjustment_summaries.adjustment_summary_id%TYPE;

1602: )
1603: IS
1604: l_start_date pn_adjustment_details.adj_start_date%TYPE;
1605: l_end_date pn_adjustment_details.adj_end_date%TYPE;
1606: l_adj_summ_id pn_adjustment_summaries.adjustment_summary_id%TYPE;
1607:
1608: l_group_num NUMBER := 0;
1609: l_consolidate BOOLEAN;
1610:

Line 1636: INSERT INTO pn_adjustment_summaries (

1632: l_info := ' inserting into adjustment summary table for schedule date:'||
1633: p_adj_table(i).schedule_date;
1634: pnp_debug_pkg.log(l_info);
1635:
1636: INSERT INTO pn_adjustment_summaries (
1637: adjustment_summary_id,
1638: adj_schedule_date,
1639: payment_term_id,
1640: sum_adj_amount,

Line 1647: pn_adjustment_summaries_s.nextval,

1643: last_update_date,
1644: last_updated_by,
1645: last_update_login
1646: ) VALUES (
1647: pn_adjustment_summaries_s.nextval,
1648: p_adj_table(i).schedule_date,
1649: p_term_id,
1650: p_adj_table(i).amount,
1651: SYSDATE,

Line 1732: UPDATE pn_adjustment_summaries

1728: l_info := ' updating adjustment summary id:'||
1729: p_adj_table(i).adj_summ_id;
1730: pnp_debug_pkg.log(l_info);
1731:
1732: UPDATE pn_adjustment_summaries
1733: SET sum_adj_amount = sum_adj_amount + p_adj_table(i).amount,
1734: last_update_date = SYSDATE,
1735: last_updated_by = fnd_global.user_id,
1736: last_update_login = fnd_global.login_id