DBA Data[Home] [Help]

APPS.PN_RETRO_ADJUSTMENT_PKG dependencies on PN_PAYMENT_SCHEDULES

Line 13: payment_status pn_payment_schedules.payment_status_lookup_code%TYPE,

9: end_date pn_payment_items.adj_end_date%TYPE,
10: trx_date pn_payment_items.due_date%TYPE,
11: amount pn_payment_terms.actual_amount%TYPE,
12: new_amount pn_payment_terms.actual_amount%TYPE,
13: payment_status pn_payment_schedules.payment_status_lookup_code%TYPE,
14: schedule_date pn_payment_schedules.schedule_date%TYPE,
15: schedule_id pn_payment_schedules.payment_schedule_id%TYPE,
16: adj_summ_id pn_adjustment_summaries.adjustment_summary_id%TYPE,
17: adj_date pn_adjustment_summaries.adj_schedule_date%TYPE);

Line 14: schedule_date pn_payment_schedules.schedule_date%TYPE,

10: trx_date pn_payment_items.due_date%TYPE,
11: amount pn_payment_terms.actual_amount%TYPE,
12: new_amount pn_payment_terms.actual_amount%TYPE,
13: payment_status pn_payment_schedules.payment_status_lookup_code%TYPE,
14: schedule_date pn_payment_schedules.schedule_date%TYPE,
15: schedule_id pn_payment_schedules.payment_schedule_id%TYPE,
16: adj_summ_id pn_adjustment_summaries.adjustment_summary_id%TYPE,
17: adj_date pn_adjustment_summaries.adj_schedule_date%TYPE);
18:

Line 15: schedule_id pn_payment_schedules.payment_schedule_id%TYPE,

11: amount pn_payment_terms.actual_amount%TYPE,
12: new_amount pn_payment_terms.actual_amount%TYPE,
13: payment_status pn_payment_schedules.payment_status_lookup_code%TYPE,
14: schedule_date pn_payment_schedules.schedule_date%TYPE,
15: schedule_id pn_payment_schedules.payment_schedule_id%TYPE,
16: adj_summ_id pn_adjustment_summaries.adjustment_summary_id%TYPE,
17: adj_date pn_adjustment_summaries.adj_schedule_date%TYPE);
18:
19: TYPE payment_item_tbl_type IS TABLE OF payment_item_rec INDEX BY BINARY_INTEGER;

Line 40: p_schedule_date pn_payment_schedules.schedule_date%TYPE,

36: PROCEDURE find_schedule (
37: p_lease_id pn_leases.lease_id%TYPE,
38: p_lease_change_id pn_lease_changes.lease_change_id%TYPE,
39: p_term_id pn_payment_terms.payment_term_id%TYPE,
40: p_schedule_date pn_payment_schedules.schedule_date%TYPE,
41: p_schedule_id OUT NOCOPY pn_payment_schedules.payment_schedule_id%TYPE
42: );
43:
44: PROCEDURE create_virtual_schedules(

Line 41: p_schedule_id OUT NOCOPY pn_payment_schedules.payment_schedule_id%TYPE

37: p_lease_id pn_leases.lease_id%TYPE,
38: p_lease_change_id pn_lease_changes.lease_change_id%TYPE,
39: p_term_id pn_payment_terms.payment_term_id%TYPE,
40: p_schedule_date pn_payment_schedules.schedule_date%TYPE,
41: p_schedule_id OUT NOCOPY pn_payment_schedules.payment_schedule_id%TYPE
42: );
43:
44: PROCEDURE create_virtual_schedules(
45: p_start_date pn_payment_terms.start_date%TYPE,