[Home] [Help]
PACKAGE: APPS.ARP_TRX_DEFAULTS_3
Source
1 PACKAGE ARP_TRX_DEFAULTS_3 AUTHID CURRENT_USER AS
2 /* $Header: ARTUDF3S.pls 120.9.12010000.1 2008/07/24 16:57:53 appldev ship $ */
3
4 TYPE address_rec_type IS RECORD (
5 cust_acct_site_id NUMBER,
6 address1 hz_locations.address1%type,
7 address2 hz_locations.address2%type,
8 address3 hz_locations.address3%type,
9 address4 hz_locations.address4%type,
10 city hz_locations.city%type,
11 state hz_locations.state%type,
12 province hz_locations.province%type,
13 postal_code hz_locations.postal_code%type,
14 country fnd_territories_vl.territory_short_name%type -- hz_locations.city%type
15 );
16
17 PROCEDURE get_default_remit_to(
18 p_remit_to_address_id OUT NOCOPY
19 NUMBER,
20 p_remit_to_address_rec OUT NOCOPY address_rec_type
21 );
22
23 PROCEDURE get_remit_to_address(
24 p_match_state IN
25 hz_locations.state%type,
26 p_match_country IN
27 hz_locations.country%type,
28 p_match_postal_code IN
29 hz_locations.postal_code%type,
30 p_match_address_id IN
31 NUMBER,
32 p_match_site_use_id IN
33 NUMBER,
34 p_remit_to_address_id OUT NOCOPY
35 NUMBER,
36 p_remit_to_address_rec OUT NOCOPY
37 address_rec_type
38 );
39
40 PROCEDURE get_remit_to_default(
41 p_state IN hz_locations.state%type,
42 p_postal_code IN hz_locations.postal_code%type,
43 p_country IN hz_locations.country%type,
44 p_address_id OUT NOCOPY NUMBER,
45 p_address1 OUT NOCOPY hz_locations.address1%type,
46 p_address2 OUT NOCOPY hz_locations.address2%type,
47 p_address3 OUT NOCOPY varchar2,
48 p_concatenated_address OUT NOCOPY varchar2
49 );
50
51
52
53 PROCEDURE get_payment_method_default(
54 p_trx_date IN
55 ra_customer_trx.trx_date%type,
56 p_currency_code IN
57 fnd_currencies.currency_code%type,
58 p_paying_customer_id IN
59 hz_cust_accounts.cust_account_id%type,
60 p_paying_site_use_id IN
61 hz_cust_site_uses.site_use_id%type,
62 p_bill_to_customer_id IN
63 hz_cust_accounts.cust_account_id%type,
64 p_bill_to_site_use_id IN
65 hz_cust_site_uses.site_use_id%type,
66 p_payment_method_name OUT NOCOPY
67 ar_receipt_methods.name%type,
71 ar_receipt_classes.creation_method_code%type,
68 p_receipt_method_id OUT NOCOPY
69 ar_receipt_methods.receipt_method_id%type,
70 p_creation_method_code OUT NOCOPY
72 p_trx_manual_flag IN VARCHAR2 DEFAULT 'N'
73 );
74
75 FUNCTION check_payment_method(
76 p_trx_date IN
77 ra_customer_trx.trx_date%type,
78 p_customer_id IN
79 ra_customer_trx.customer_trx_id%type,
80 p_site_use_id IN
81 hz_cust_site_uses.site_use_id%type,
82 p_currency_code IN
83 fnd_currencies.currency_code%type,
84 p_payment_method_name OUT NOCOPY
85 ar_receipt_methods.name%type,
86 p_receipt_method_id OUT NOCOPY
87 ar_receipt_methods.receipt_method_id%type,
88 p_creation_method_code OUT NOCOPY
89 ar_receipt_classes.creation_method_code%type
90 ) RETURN BOOLEAN;
91
92
93 PROCEDURE get_bank_defaults(
94 p_trx_date IN
95 ra_customer_trx.trx_date%type,
96 p_currency_code IN
97 fnd_currencies.currency_code%type,
98 p_paying_customer_id IN
99 hz_cust_accounts.cust_account_id%type,
100 p_paying_site_use_id IN
101 hz_cust_site_uses.site_use_id%type,
102 p_bill_to_customer_id IN
103 hz_cust_accounts.cust_account_id%type,
104 p_bill_to_site_use_id IN
105 hz_cust_site_uses.site_use_id%type,
106 p_payment_type_code IN
107 ar_receipt_methods.payment_type_code%type,
108 p_customer_bank_account_id OUT NOCOPY
109 ce_bank_accounts.bank_account_id%type,
110 p_bank_account_num OUT NOCOPY
111 ce_bank_accounts.bank_account_num%type,
112 p_bank_name OUT NOCOPY
113 ce_bank_branches_v.bank_name%type,
114 p_bank_branch_name OUT NOCOPY
115 ce_bank_branches_v.bank_branch_name%type,
116 p_bank_branch_id OUT NOCOPY
117 ce_bank_branches_v.branch_party_id%TYPE,
118 p_trx_manual_flag IN VARCHAR2 DEFAULT 'N'
119 );
120
121 PROCEDURE get_pay_method_and_bank_deflts(
122 p_trx_date IN
123 ra_customer_trx.trx_date%type,
127 hz_cust_accounts.cust_account_id%type,
124 p_currency_code IN
125 fnd_currencies.currency_code%type,
126 p_paying_customer_id IN
128 p_paying_site_use_id IN
129 hz_cust_site_uses.site_use_id%type,
130 p_bill_to_customer_id IN
131 hz_cust_accounts.cust_account_id%type,
132 p_bill_to_site_use_id IN
133 hz_cust_site_uses.site_use_id%type,
134 p_payment_type_code IN
135 ar_receipt_methods.payment_type_code%type,
136 p_payment_method_name OUT NOCOPY
137 ar_receipt_methods.name%type,
138 p_receipt_method_id OUT NOCOPY
139 ar_receipt_methods.receipt_method_id%type,
140 p_creation_method_code OUT NOCOPY
141 ar_receipt_classes.creation_method_code%type,
142 p_customer_bank_account_id OUT NOCOPY
143 ce_bank_accounts.bank_account_id%type,
144 p_bank_account_num OUT NOCOPY
145 ce_bank_accounts.bank_account_num%type,
146 p_bank_name OUT NOCOPY
147 ce_bank_branches_v.bank_name%type,
148 p_bank_branch_name OUT NOCOPY
149 ce_bank_branches_v.bank_branch_name%type,
150 p_bank_branch_id OUT NOCOPY
151 ce_bank_branches_v.branch_party_id%TYPE,
152 p_trx_manual_flag IN VARCHAR2 DEFAULT 'N'
153 );
154
155 PROCEDURE get_term_default(
156 p_term_id IN ra_terms.term_id%type,
157 p_type_term_id IN ra_terms.term_id%type,
158 p_type_term_name IN ra_terms.name%type,
159 p_customer_id IN hz_cust_accounts.cust_account_id%type,
160 p_site_use_id IN hz_cust_site_uses.site_use_id%type,
161 p_trx_date IN ra_customer_trx.trx_date%type,
162 p_class IN ra_cust_trx_types.type%type,
163 p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,
164 p_default_term_id OUT NOCOPY ra_terms.term_id%type,
165 p_default_term_name OUT NOCOPY ra_terms.name%type,
166 p_number_of_due_dates OUT NOCOPY number,
167 p_term_due_date OUT NOCOPY
168 ra_customer_trx.term_due_date%type
169 );
170
171 PROCEDURE Get_Additional_Customer_Info(
172 p_customer_id IN number,
173 p_site_use_id IN number,
174 p_invoice_currency_code IN varchar2,
175 p_previous_customer_trx_id IN number,
176 p_ct_prev_initial_cust_trx_id IN number,
177 p_trx_date IN date,
178 p_code_combination_id_gain IN number,
179 p_override_terms OUT NOCOPY varchar2,
180 p_commitments_exist_flag OUT NOCOPY varchar2,
181 p_agreements_exist_flag OUT NOCOPY varchar2);
182
183
184 FUNCTION get_payment_channel_name(
185 p_payment_channel_code IN
186 ar_receipt_methods.payment_channel_code%type
187 ) RETURN VARCHAR2;
188
189 FUNCTION get_party_id (
190 p_cust_account_id IN
191 hz_cust_accounts.cust_account_id%type
192 ) RETURN NUMBER;
193
194 FUNCTION get_payment_instrument(
195 p_payment_trxn_extension_id IN
196 ra_customer_trx.payment_trxn_extension_id%type,
197 p_payment_channel_code IN
198 ar_receipt_methods.payment_channel_code%type
199 ) RETURN VARCHAR2;
200
201
202 --4778839
203 PROCEDURE get_br_bank_defaults( p_payment_trxn_extension_id IN
204 ra_customer_trx.payment_trxn_extension_id%type,
205 p_payment_channel_code IN
206 ar_receipt_methods.payment_channel_code%type,
207 p_bank_name OUT NOCOPY
208 iby_trxn_extensions_v.bank_name%type,
209 p_branch_name OUT NOCOPY
210 iby_trxn_extensions_v.bank_branch_name%type,
211 p_instr_assign_id OUT NOCOPY
212 iby_trxn_extensions_v.instr_assignment_id%type,
213 p_instr_number OUT NOCOPY
217 --Bug 5507178
214 iby_trxn_extensions_v.account_number%type);
215
216
218 PROCEDURE get_instr_defaults(p_org_id IN ra_customer_trx.org_id%type,
219 p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
220 p_paying_site_use_id IN iby_fndcpt_payer_assgn_instr_v.acct_site_use_id%type,
221 p_instrument_type IN iby_fndcpt_payer_assgn_instr_v.instrument_type%type,
222 p_currency_code IN iby_fndcpt_payer_assgn_instr_v.currency_code%type ,
223 p_instrument_assignment_id OUT NOCOPY iby_trxn_extensions_v.instr_assignment_id%type
224 );
225
226 PROCEDURE init;
227
228 END ARP_TRX_DEFAULTS_3;