[Home] [Help]
PACKAGE: APPS.ARP_ADJUSTMENTS_PKG
Source
1 PACKAGE ARP_ADJUSTMENTS_PKG AS
2 /* $Header: ARTIADJS.pls 120.4 2005/10/30 04:27:17 appldev ship $ */
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
12 PROCEDURE lock_f_ct_id( p_customer_trx_id
13 IN ra_customer_trx.customer_trx_id%type );
14
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
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,
33 p_amount IN number,
34 p_acctd_amount IN number,
35 p_apply_date IN date,
36 p_gl_date IN date,
37 p_gl_posted_date IN date,
38 p_set_of_books_id IN number,
39 p_code_combination_id IN number,
40 p_type IN varchar2,
41 p_adjustment_type IN varchar2,
42 p_status IN varchar2,
43 p_line_adjusted IN number,
44 p_freight_adjusted IN number,
45 p_tax_adjusted IN number,
46 p_receivables_charges_adj IN number,
47 p_batch_id IN number,
48 p_customer_trx_id IN number,
49 p_subsequent_trx_id IN number,
50 p_customer_trx_line_id IN number,
51 p_associated_cash_receipt_id IN number,
52 p_chargeback_customer_trx_id IN number,
53 p_payment_schedule_id IN number,
54 p_receivables_trx_id IN number,
55 p_distribution_set_id IN number,
56 p_associated_application_id IN number,
57 p_comments IN varchar2,
58 p_automatically_generated IN varchar2,
59 p_created_from IN varchar2,
60 p_reason_code IN varchar2,
61 p_postable IN varchar2,
62 p_approved_by IN number,
63 p_adjustment_number IN varchar2,
64 p_doc_sequence_value IN number,
65 p_doc_sequence_id IN number,
66 p_ussgl_transaction_code IN varchar2,
67 p_ussgl_trans_code_context IN varchar2,
68 p_attribute_category IN varchar2,
69 p_attribute1 IN varchar2,
70 p_attribute2 IN varchar2,
71 p_attribute3 IN varchar2,
72 p_attribute4 IN varchar2,
73 p_attribute5 IN varchar2,
74 p_attribute6 IN varchar2,
75 p_attribute7 IN varchar2,
76 p_attribute8 IN varchar2,
77 p_attribute9 IN varchar2,
78 p_attribute10 IN varchar2,
79 p_attribute11 IN varchar2,
80 p_attribute12 IN varchar2,
81 p_attribute13 IN varchar2,
82 p_attribute14 IN varchar2,
83 p_attribute15 IN varchar2,
84 p_posting_control_id IN number,
85 p_last_updated_by IN number,
86 p_last_update_date IN date,
87 p_last_update_login IN number,
88 p_created_by IN number,
89 p_creation_date IN date,
90 p_program_application_id 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
100 procedure delete_f_ct_id( p_customer_trx_id
101 IN ra_customer_trx.customer_trx_id%type);
102
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
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,
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,
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);
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
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
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;