15: PROCEDURE lock_f_st_id( p_subsequent_trx_id
16: IN ra_customer_trx.customer_trx_id%type );
17:
18: PROCEDURE lock_f_ps_id( p_payment_schedule_id
19: IN ar_payment_schedules.payment_schedule_id%type );
20:
21: PROCEDURE lock_f_ctl_id( p_customer_trx_line_id
22: IN ra_customer_trx_lines.customer_trx_line_id%type);
23:
103: procedure delete_f_st_id( p_subsequent_trx_id
104: IN ra_customer_trx.customer_trx_id%type);
105:
106: procedure delete_f_ps_id( p_payment_schedule_id
107: IN ar_payment_schedules.payment_schedule_id%type);
108:
109: procedure delete_f_ctl_id( p_customer_trx_line_id
110: IN ra_customer_trx_lines.customer_trx_line_id%type);
111:
110: IN ra_customer_trx_lines.customer_trx_line_id%type);
111:
112: PROCEDURE update_p( p_adj_rec IN ar_adjustments%rowtype,
113: p_adjustment_id IN ar_adjustments.adjustment_id%type,
114: p_exchange_rate IN ar_payment_schedules.exchange_rate%type
115: );
116:
117: PROCEDURE update_f_ct_id( p_adj_rec IN ar_adjustments%rowtype,
118: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
115: );
116:
117: PROCEDURE update_f_ct_id( p_adj_rec IN ar_adjustments%rowtype,
118: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
119: p_exchange_rate IN ar_payment_schedules.exchange_rate%type);
120:
121: PROCEDURE update_f_st_id( p_adj_rec IN ar_adjustments%rowtype,
122: p_subsequent_trx_id IN ra_customer_trx.customer_trx_id%type,
123: p_exchange_rate IN ar_payment_schedules.exchange_rate%type);
119: p_exchange_rate IN ar_payment_schedules.exchange_rate%type);
120:
121: PROCEDURE update_f_st_id( p_adj_rec IN ar_adjustments%rowtype,
122: p_subsequent_trx_id IN ra_customer_trx.customer_trx_id%type,
123: p_exchange_rate IN ar_payment_schedules.exchange_rate%type);
124:
125: PROCEDURE update_f_ps_id( p_adj_rec IN ar_adjustments%rowtype,
126: p_payment_schedule_id IN
127: ar_payment_schedules.payment_schedule_id%type,
123: p_exchange_rate IN ar_payment_schedules.exchange_rate%type);
124:
125: PROCEDURE update_f_ps_id( p_adj_rec IN ar_adjustments%rowtype,
126: p_payment_schedule_id IN
127: ar_payment_schedules.payment_schedule_id%type,
128: p_exchange_rate IN
129: ar_payment_schedules.exchange_rate%type);
130:
131: PROCEDURE update_f_ctl_id( p_adj_rec IN ar_adjustments%rowtype,
125: PROCEDURE update_f_ps_id( p_adj_rec IN ar_adjustments%rowtype,
126: p_payment_schedule_id IN
127: ar_payment_schedules.payment_schedule_id%type,
128: p_exchange_rate IN
129: ar_payment_schedules.exchange_rate%type);
130:
131: PROCEDURE update_f_ctl_id( p_adj_rec IN ar_adjustments%rowtype,
132: p_customer_trx_line_id IN
133: ra_customer_trx_lines.customer_trx_line_id%type,
131: PROCEDURE update_f_ctl_id( p_adj_rec IN ar_adjustments%rowtype,
132: p_customer_trx_line_id IN
133: ra_customer_trx_lines.customer_trx_line_id%type,
134: p_exchange_rate IN
135: ar_payment_schedules.exchange_rate%type);
136:
137:
138: PROCEDURE insert_p( p_adj_rec IN ar_adjustments%rowtype,
139: p_exchange_rate IN
136:
137:
138: PROCEDURE insert_p( p_adj_rec IN ar_adjustments%rowtype,
139: p_exchange_rate IN
140: ar_payment_schedules.exchange_rate%type,
141: p_adjustment_number OUT NOCOPY
142: ar_adjustments.adjustment_number%type,
143: p_adjustment_id OUT NOCOPY ar_adjustments.adjustment_id%type
144: