3:
4:
5: pg_user_id number;
6:
7: PROCEDURE set_to_dummy( p_adj_rec OUT NOCOPY ar_adjustments%rowtype);
8:
9: PROCEDURE lock_p( p_adjustment_id IN ar_adjustments.adjustment_id%type
10: );
11:
5: pg_user_id number;
6:
7: PROCEDURE set_to_dummy( p_adj_rec OUT NOCOPY ar_adjustments%rowtype);
8:
9: PROCEDURE lock_p( p_adjustment_id IN ar_adjustments.adjustment_id%type
10: );
11:
12: PROCEDURE lock_f_ct_id( p_customer_trx_id
13: IN ra_customer_trx.customer_trx_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:
24: PROCEDURE lock_fetch_p( p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,
25: p_adjustment_id IN
26: ar_adjustments.adjustment_id%type);
27:
28: PROCEDURE lock_compare_p( p_adj_rec IN ar_adjustments%rowtype,
22: IN ra_customer_trx_lines.customer_trx_line_id%type);
23:
24: PROCEDURE lock_fetch_p( p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,
25: p_adjustment_id IN
26: ar_adjustments.adjustment_id%type);
27:
28: PROCEDURE lock_compare_p( p_adj_rec IN ar_adjustments%rowtype,
29: p_adjustment_id IN ar_adjustments.adjustment_id%type);
30:
24: PROCEDURE lock_fetch_p( p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,
25: p_adjustment_id IN
26: ar_adjustments.adjustment_id%type);
27:
28: PROCEDURE lock_compare_p( p_adj_rec IN ar_adjustments%rowtype,
29: p_adjustment_id IN ar_adjustments.adjustment_id%type);
30:
31: PROCEDURE lock_compare_cover(
32: p_adjustment_id IN number,
25: p_adjustment_id IN
26: ar_adjustments.adjustment_id%type);
27:
28: PROCEDURE lock_compare_p( p_adj_rec IN ar_adjustments%rowtype,
29: p_adjustment_id IN ar_adjustments.adjustment_id%type);
30:
31: PROCEDURE lock_compare_cover(
32: p_adjustment_id IN number,
33: p_amount IN number,
91: p_program_id IN number,
92: p_program_update_date IN date,
93: p_request_id IN number );
94:
95: PROCEDURE fetch_p( p_adj_rec OUT NOCOPY ar_adjustments%rowtype,
96: p_adjustment_id IN ar_adjustments.adjustment_id%type);
97:
98: procedure delete_p( p_adjustment_id IN ar_adjustments.adjustment_id%type);
99:
92: p_program_update_date IN date,
93: p_request_id IN number );
94:
95: PROCEDURE fetch_p( p_adj_rec OUT NOCOPY ar_adjustments%rowtype,
96: p_adjustment_id IN ar_adjustments.adjustment_id%type);
97:
98: procedure delete_p( p_adjustment_id IN ar_adjustments.adjustment_id%type);
99:
100: procedure delete_f_ct_id( p_customer_trx_id
94:
95: PROCEDURE fetch_p( p_adj_rec OUT NOCOPY ar_adjustments%rowtype,
96: p_adjustment_id IN ar_adjustments.adjustment_id%type);
97:
98: procedure delete_p( p_adjustment_id IN ar_adjustments.adjustment_id%type);
99:
100: procedure delete_f_ct_id( p_customer_trx_id
101: IN ra_customer_trx.customer_trx_id%type);
102:
108:
109: procedure delete_f_ctl_id( p_customer_trx_line_id
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:
109: procedure delete_f_ctl_id( p_customer_trx_line_id
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,
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,
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,
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);
124:
125: PROCEDURE update_f_ps_id( p_adj_rec IN ar_adjustments%rowtype,
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,
128: p_exchange_rate IN
129: ar_payment_schedules.exchange_rate%type);
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,
134: p_exchange_rate IN
135: ar_payment_schedules.exchange_rate%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
140: ar_payment_schedules.exchange_rate%type,
141: p_adjustment_number OUT NOCOPY
142: ar_adjustments.adjustment_number%type,
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:
145: );
146:
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:
145: );
146:
147: PROCEDURE merge_adj_recs( p_old_adj_rec IN ar_adjustments%rowtype,
143: p_adjustment_id OUT NOCOPY ar_adjustments.adjustment_id%type
144:
145: );
146:
147: PROCEDURE merge_adj_recs( p_old_adj_rec IN ar_adjustments%rowtype,
148: p_new_adj_rec IN ar_adjustments%rowtype,
149: p_out_adj_rec OUT NOCOPY ar_adjustments%rowtype );
150:
151: PROCEDURE display_adj_rec(
144:
145: );
146:
147: PROCEDURE merge_adj_recs( p_old_adj_rec IN ar_adjustments%rowtype,
148: p_new_adj_rec IN ar_adjustments%rowtype,
149: p_out_adj_rec OUT NOCOPY ar_adjustments%rowtype );
150:
151: PROCEDURE display_adj_rec(
152: p_adj_rec IN ar_adjustments%rowtype);
145: );
146:
147: PROCEDURE merge_adj_recs( p_old_adj_rec IN ar_adjustments%rowtype,
148: p_new_adj_rec IN ar_adjustments%rowtype,
149: p_out_adj_rec OUT NOCOPY ar_adjustments%rowtype );
150:
151: PROCEDURE display_adj_rec(
152: p_adj_rec IN ar_adjustments%rowtype);
153:
148: p_new_adj_rec IN ar_adjustments%rowtype,
149: p_out_adj_rec OUT NOCOPY ar_adjustments%rowtype );
150:
151: PROCEDURE display_adj_rec(
152: p_adj_rec IN ar_adjustments%rowtype);
153:
154: PROCEDURE display_adj_p(p_adjustment_id IN ar_adjustments.adjustment_id%type);
155:
156: FUNCTION get_text_dummy(p_null IN NUMBER DEFAULT null) RETURN varchar2;
150:
151: PROCEDURE display_adj_rec(
152: p_adj_rec IN ar_adjustments%rowtype);
153:
154: PROCEDURE display_adj_p(p_adjustment_id IN ar_adjustments.adjustment_id%type);
155:
156: FUNCTION get_text_dummy(p_null IN NUMBER DEFAULT null) RETURN varchar2;
157:
158: END ARP_ADJUSTMENTS_PKG;