DBA Data[Home] [Help]

APPS.ARP_PROGRAM_GENERATE_BR dependencies on RA_CUSTOMER_TRX

Line 11: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,

7: p_print_flag IN VARCHAR2,
8: p_batch_id IN RA_BATCHES.batch_id%TYPE,
9: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
10: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
11: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
12: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
13: P_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
14: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
15: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,

Line 12: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,

8: p_batch_id IN RA_BATCHES.batch_id%TYPE,
9: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
10: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
11: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
12: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
13: P_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
14: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
15: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
16: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 16: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

12: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
13: P_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
14: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
15: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
16: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
17: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
18: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
19: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
20: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,

Line 17: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

13: P_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
14: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
15: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
16: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
17: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
18: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
19: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
20: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
21: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE);

Line 52: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,

48: p_attribute14 IN VARCHAR2,
49: p_attribute15 IN VARCHAR2,
50: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
51: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
52: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
53: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
54: P_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
55: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
56: p_cust_bank_branch_id IN CE_BANK_BRANCHES_V.branch_party_id%TYPE,

Line 53: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,

49: p_attribute15 IN VARCHAR2,
50: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
51: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
52: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
53: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
54: P_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
55: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
56: p_cust_bank_branch_id IN CE_BANK_BRANCHES_V.branch_party_id%TYPE,
57: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 57: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

53: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
54: P_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
55: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
56: p_cust_bank_branch_id IN CE_BANK_BRANCHES_V.branch_party_id%TYPE,
57: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
58: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
59: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
60: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
61: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,

Line 58: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

54: P_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
55: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
56: p_cust_bank_branch_id IN CE_BANK_BRANCHES_V.branch_party_id%TYPE,
57: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
58: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
59: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
60: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
61: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
62: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE);

Line 97: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,

93: p_attribute14 IN VARCHAR2,
94: p_attribute15 IN VARCHAR2,
95: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
96: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
97: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
98: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
99: P_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
100: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
101: p_cust_bank_branch_id IN CE_BANK_BRANCHES_V.branch_party_id%TYPE,

Line 98: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,

94: p_attribute15 IN VARCHAR2,
95: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
96: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
97: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
98: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
99: P_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
100: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
101: p_cust_bank_branch_id IN CE_BANK_BRANCHES_V.branch_party_id%TYPE,
102: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 102: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

98: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
99: P_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
100: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
101: p_cust_bank_branch_id IN CE_BANK_BRANCHES_V.branch_party_id%TYPE,
102: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
103: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
104: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
105: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
106: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,

Line 103: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

99: P_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
100: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
101: p_cust_bank_branch_id IN CE_BANK_BRANCHES_V.branch_party_id%TYPE,
102: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
103: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
104: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
105: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
106: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
107: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,

Line 123: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,

119: p_call IN NUMBER,
120: p_batch_id IN RA_BATCHES.batch_id%TYPE,
121: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
122: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
123: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
124: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
125: P_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
126: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
127: p_cust_bank_branch_id IN CE_BANK_BRANCHES_V.branch_party_id%TYPE,

Line 124: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,

120: p_batch_id IN RA_BATCHES.batch_id%TYPE,
121: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
122: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
123: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
124: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
125: P_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
126: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
127: p_cust_bank_branch_id IN CE_BANK_BRANCHES_V.branch_party_id%TYPE,
128: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 128: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

124: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
125: P_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
126: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
127: p_cust_bank_branch_id IN CE_BANK_BRANCHES_V.branch_party_id%TYPE,
128: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
129: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
130: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
131: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
132: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,

Line 129: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

125: P_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
126: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
127: p_cust_bank_branch_id IN CE_BANK_BRANCHES_V.branch_party_id%TYPE,
128: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
129: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
130: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
131: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
132: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
133: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE);

Line 141: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,

137: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,
138: p_suffixe_select_statement OUT NOCOPY varchar2,
139: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
140: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
141: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
142: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
143: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
144: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
145: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 142: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,

138: p_suffixe_select_statement OUT NOCOPY varchar2,
139: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
140: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
141: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
142: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
143: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
144: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
145: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
146: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,

Line 144: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

140: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
141: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
142: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
143: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
144: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
145: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
146: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
147: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
148: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,

Line 145: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

141: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
142: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
143: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
144: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
145: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
146: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
147: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
148: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
149: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,

Line 150: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE);

146: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
147: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
148: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
149: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
150: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE);
151:
152: -- bug 3922691 : consolidate code used in 2 procedures
153: PROCEDURE construct_hz(
154: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,

Line 164: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,

160: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,
161: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
162: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
163: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
164: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
165: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
166: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
167: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
168: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 165: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,

161: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
162: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
163: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
164: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
165: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
166: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
167: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
168: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
169: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,

Line 167: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

163: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
164: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
165: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
166: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
167: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
168: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
169: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
170: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
171: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,

Line 168: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

164: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
165: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
166: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
167: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
168: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
169: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
170: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
171: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
172: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,

Line 175: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,

171: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
172: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
173: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
174: p_batch_id IN RA_BATCHES.batch_id%TYPE,
175: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,
176: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
177: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
178: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE);
179:

Line 176: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,

172: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
173: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
174: p_batch_id IN RA_BATCHES.batch_id%TYPE,
175: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,
176: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
177: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
178: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE);
179:
180: -- bug 3922691 : remove p_suffixe_select_statement, add p_lead_days

Line 177: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,

173: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
174: p_batch_id IN RA_BATCHES.batch_id%TYPE,
175: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,
176: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
177: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
178: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE);
179:
180: -- bug 3922691 : remove p_suffixe_select_statement, add p_lead_days
181: PROCEDURE select_trx_NIMM(

Line 178: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE);

174: p_batch_id IN RA_BATCHES.batch_id%TYPE,
175: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,
176: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
177: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
178: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE);
179:
180: -- bug 3922691 : remove p_suffixe_select_statement, add p_lead_days
181: PROCEDURE select_trx_NIMM(
182: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,

Line 186: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,

182: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,
183: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
184: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
185: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
186: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
187: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
188: p_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
189: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
190: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 187: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,

183: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
184: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
185: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
186: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
187: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
188: p_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
189: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
190: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
191: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,

Line 189: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

185: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
186: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
187: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
188: p_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
189: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
190: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
191: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
192: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
193: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,

Line 190: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

186: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
187: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
188: p_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
189: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
190: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
191: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
192: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
193: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
194: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,

Line 197: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,

193: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
194: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
195: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
196: p_batch_id IN RA_BATCHES.batch_id%TYPE,
197: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,
198: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
199: p_payment_schedule_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
200: p_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
201: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,

Line 198: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,

194: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
195: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
196: p_batch_id IN RA_BATCHES.batch_id%TYPE,
197: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,
198: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
199: p_payment_schedule_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
200: p_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
201: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
202: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE);

Line 200: p_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,

196: p_batch_id IN RA_BATCHES.batch_id%TYPE,
197: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,
198: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
199: p_payment_schedule_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
200: p_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
201: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
202: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE);
203:
204: PROCEDURE create_BR(

Line 201: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,

197: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,
198: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
199: p_payment_schedule_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
200: p_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
201: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
202: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE);
203:
204: PROCEDURE create_BR(
205: p_draft_mode IN VARCHAR2,

Line 202: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE);

198: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
199: p_payment_schedule_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
200: p_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
201: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
202: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE);
203:
204: PROCEDURE create_BR(
205: p_draft_mode IN VARCHAR2,
206: p_call IN NUMBER,

Line 214: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE DEFAULT NULL,

210: p_maturity_date_rule_code IN AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE,
211: p_br_min_acctd_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
212: p_br_max_acctd_amount IN AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE,
213: p_currency_code IN RA_BATCHES.currency_code%TYPE,
214: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE DEFAULT NULL,
215: p_le_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
216: p_bill_id OUT NOCOPY RA_CUSTOMER_TRX.customer_trx_id%TYPE,
217: p_request_id OUT NOCOPY NUMBER);
218:

Line 215: p_le_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,

211: p_br_min_acctd_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
212: p_br_max_acctd_amount IN AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE,
213: p_currency_code IN RA_BATCHES.currency_code%TYPE,
214: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE DEFAULT NULL,
215: p_le_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
216: p_bill_id OUT NOCOPY RA_CUSTOMER_TRX.customer_trx_id%TYPE,
217: p_request_id OUT NOCOPY NUMBER);
218:
219:

Line 216: p_bill_id OUT NOCOPY RA_CUSTOMER_TRX.customer_trx_id%TYPE,

212: p_br_max_acctd_amount IN AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE,
213: p_currency_code IN RA_BATCHES.currency_code%TYPE,
214: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE DEFAULT NULL,
215: p_le_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
216: p_bill_id OUT NOCOPY RA_CUSTOMER_TRX.customer_trx_id%TYPE,
217: p_request_id OUT NOCOPY NUMBER);
218:
219:
220: -- Bug 1420183 Added p_receipt_method_id

Line 222: p_request_id IN RA_CUSTOMER_TRX.request_id%TYPE,

218:
219:
220: -- Bug 1420183 Added p_receipt_method_id
221: PROCEDURE AR_BR_INSERT_INTO_REPORT_TABLE(
222: p_request_id IN RA_CUSTOMER_TRX.request_id%TYPE,
223: p_batch_id IN RA_BATCHES.batch_id%TYPE,
224: p_br_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
225: p_bill_number IN RA_CUSTOMER_TRX.TRX_NUMBER%TYPE,
226: p_br_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,

Line 224: p_br_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,

220: -- Bug 1420183 Added p_receipt_method_id
221: PROCEDURE AR_BR_INSERT_INTO_REPORT_TABLE(
222: p_request_id IN RA_CUSTOMER_TRX.request_id%TYPE,
223: p_batch_id IN RA_BATCHES.batch_id%TYPE,
224: p_br_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
225: p_bill_number IN RA_CUSTOMER_TRX.TRX_NUMBER%TYPE,
226: p_br_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
227: p_br_currency IN RA_BATCHES.currency_code%TYPE,
228: p_batch_status IN RA_BATCHES.status%TYPE,

Line 225: p_bill_number IN RA_CUSTOMER_TRX.TRX_NUMBER%TYPE,

221: PROCEDURE AR_BR_INSERT_INTO_REPORT_TABLE(
222: p_request_id IN RA_CUSTOMER_TRX.request_id%TYPE,
223: p_batch_id IN RA_BATCHES.batch_id%TYPE,
224: p_br_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
225: p_bill_number IN RA_CUSTOMER_TRX.TRX_NUMBER%TYPE,
226: p_br_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
227: p_br_currency IN RA_BATCHES.currency_code%TYPE,
228: p_batch_status IN RA_BATCHES.status%TYPE,
229: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,

Line 230: p_drawee_id IN RA_CUSTOMER_TRX.drawee_id%TYPE,

226: p_br_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
227: p_br_currency IN RA_BATCHES.currency_code%TYPE,
228: p_batch_status IN RA_BATCHES.status%TYPE,
229: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
230: p_drawee_id IN RA_CUSTOMER_TRX.drawee_id%TYPE,
231: p_drawee_contact_id IN RA_CUSTOMER_TRX.drawee_contact_id%TYPE,
232: p_drawee_site_use_id IN RA_CUSTOMER_TRX.drawee_site_use_id%TYPE,
233: p_drawee_bank_account_id IN RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE,
234: p_transaction_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,

Line 231: p_drawee_contact_id IN RA_CUSTOMER_TRX.drawee_contact_id%TYPE,

227: p_br_currency IN RA_BATCHES.currency_code%TYPE,
228: p_batch_status IN RA_BATCHES.status%TYPE,
229: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
230: p_drawee_id IN RA_CUSTOMER_TRX.drawee_id%TYPE,
231: p_drawee_contact_id IN RA_CUSTOMER_TRX.drawee_contact_id%TYPE,
232: p_drawee_site_use_id IN RA_CUSTOMER_TRX.drawee_site_use_id%TYPE,
233: p_drawee_bank_account_id IN RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE,
234: p_transaction_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
235: p_amount_assigned IN RA_CUSTOMER_TRX.br_amount%TYPE,

Line 232: p_drawee_site_use_id IN RA_CUSTOMER_TRX.drawee_site_use_id%TYPE,

228: p_batch_status IN RA_BATCHES.status%TYPE,
229: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
230: p_drawee_id IN RA_CUSTOMER_TRX.drawee_id%TYPE,
231: p_drawee_contact_id IN RA_CUSTOMER_TRX.drawee_contact_id%TYPE,
232: p_drawee_site_use_id IN RA_CUSTOMER_TRX.drawee_site_use_id%TYPE,
233: p_drawee_bank_account_id IN RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE,
234: p_transaction_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
235: p_amount_assigned IN RA_CUSTOMER_TRX.br_amount%TYPE,
236: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE);

Line 233: p_drawee_bank_account_id IN RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE,

229: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
230: p_drawee_id IN RA_CUSTOMER_TRX.drawee_id%TYPE,
231: p_drawee_contact_id IN RA_CUSTOMER_TRX.drawee_contact_id%TYPE,
232: p_drawee_site_use_id IN RA_CUSTOMER_TRX.drawee_site_use_id%TYPE,
233: p_drawee_bank_account_id IN RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE,
234: p_transaction_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
235: p_amount_assigned IN RA_CUSTOMER_TRX.br_amount%TYPE,
236: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE);
237:

Line 234: p_transaction_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,

230: p_drawee_id IN RA_CUSTOMER_TRX.drawee_id%TYPE,
231: p_drawee_contact_id IN RA_CUSTOMER_TRX.drawee_contact_id%TYPE,
232: p_drawee_site_use_id IN RA_CUSTOMER_TRX.drawee_site_use_id%TYPE,
233: p_drawee_bank_account_id IN RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE,
234: p_transaction_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
235: p_amount_assigned IN RA_CUSTOMER_TRX.br_amount%TYPE,
236: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE);
237:
238: PROCEDURE run_report_pvt(

Line 235: p_amount_assigned IN RA_CUSTOMER_TRX.br_amount%TYPE,

231: p_drawee_contact_id IN RA_CUSTOMER_TRX.drawee_contact_id%TYPE,
232: p_drawee_site_use_id IN RA_CUSTOMER_TRX.drawee_site_use_id%TYPE,
233: p_drawee_bank_account_id IN RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE,
234: p_transaction_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
235: p_amount_assigned IN RA_CUSTOMER_TRX.br_amount%TYPE,
236: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE);
237:
238: PROCEDURE run_report_pvt(
239: p_batch_id IN RA_BATCHES.batch_id%TYPE);

Line 399: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE DEFAULT NULL,

395: p_trx_date_high IN VARCHAR2 DEFAULT NULL,
396: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE DEFAULT NULL,
397: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE DEFAULT NULL,
398: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE DEFAULT NULL,
399: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE DEFAULT NULL,
400: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE DEFAULT NULL,
401: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE DEFAULT NULL,
402: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE DEFAULT NULL,
403: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE DEFAULT NULL,

Line 400: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE DEFAULT NULL,

396: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE DEFAULT NULL,
397: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE DEFAULT NULL,
398: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE DEFAULT NULL,
399: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE DEFAULT NULL,
400: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE DEFAULT NULL,
401: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE DEFAULT NULL,
402: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE DEFAULT NULL,
403: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE DEFAULT NULL,
404: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE DEFAULT NULL) IS

Line 616: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,

612: p_print_flag IN VARCHAR2,
613: p_batch_id IN RA_BATCHES.batch_id%TYPE,
614: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
615: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
616: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
617: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
618: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
619: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
620: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,

Line 617: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,

613: p_batch_id IN RA_BATCHES.batch_id%TYPE,
614: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
615: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
616: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
617: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
618: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
619: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
620: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
621: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 621: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

617: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
618: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
619: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
620: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
621: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
622: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
623: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
624: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
625: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,

Line 622: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

618: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
619: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
620: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
621: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
622: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
623: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
624: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
625: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
626: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE) IS

Line 734: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,

730: p_attribute14 IN VARCHAR2,
731: p_attribute15 IN VARCHAR2,
732: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
733: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
734: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
735: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
736: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
737: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
738: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,

Line 735: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,

731: p_attribute15 IN VARCHAR2,
732: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
733: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
734: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
735: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
736: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
737: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
738: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
739: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 739: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

735: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
736: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
737: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
738: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
739: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
740: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
741: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
742: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
743: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,

Line 740: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

736: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
737: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
738: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
739: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
740: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
741: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
742: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
743: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
744: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE) IS

Line 899: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,

895: p_attribute14 IN VARCHAR2,
896: p_attribute15 IN VARCHAR2,
897: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
898: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
899: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
900: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
901: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
902: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
903: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,

Line 900: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,

896: p_attribute15 IN VARCHAR2,
897: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
898: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
899: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
900: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
901: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
902: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
903: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
904: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 904: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

900: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
901: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
902: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
903: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
904: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
905: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
906: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
907: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
908: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,

Line 905: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

901: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
902: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
903: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
904: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
905: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
906: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
907: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
908: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
909: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,

Line 1171: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,

1167: p_call IN NUMBER,
1168: p_batch_id IN RA_BATCHES.batch_id%TYPE,
1169: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1170: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1171: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
1172: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
1173: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
1174: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
1175: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,

Line 1172: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,

1168: p_batch_id IN RA_BATCHES.batch_id%TYPE,
1169: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1170: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1171: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
1172: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
1173: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
1174: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
1175: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
1176: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 1176: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

1172: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
1173: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
1174: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
1175: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
1176: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
1177: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
1178: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
1179: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
1180: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,

Line 1177: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

1173: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
1174: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
1175: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
1176: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
1177: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
1178: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
1179: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
1180: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
1181: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE) IS

Line 1204: ra_customer_trx trx,

1200: trx.invoice_currency_code, trx.exchange_rate, trx.legal_entity_id
1201: FROM ra_batches batch,
1202: ar_receipt_classes class,
1203: ar_receipt_methods pm,
1204: ra_customer_trx trx,
1205: ra_cust_trx_types type,
1206: fnd_currencies_vl cur
1207: WHERE pm.receipt_method_id = NVL(p_rcpt_meth_id,pm.receipt_method_id)
1208: AND type.cust_trx_type_id = NVL(p_trx_type_id,type.cust_trx_type_id)

Line 1240: ra_customer_trx trx,

1236: SELECT distinct instrument_id customer_bank_account_id
1237: FROM ra_batches batch,
1238: ar_receipt_classes class,
1239: ar_receipt_methods pm,
1240: ra_customer_trx trx,
1241: ra_cust_trx_types type,
1242: fnd_currencies_vl cur,
1243: iby_trxn_extensions_v extn
1244: WHERE pm.receipt_method_id = rm_id

Line 1291: l_invoice_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;

1287: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;
1288: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
1289: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
1290:
1291: l_invoice_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;
1292: l_exchange_rate RA_CUSTOMER_TRX.exchange_rate%TYPE;
1293: l_le_id RA_CUSTOMER_TRX.legal_entity_id%TYPE;
1294:
1295: -- Bug 1808976

Line 1292: l_exchange_rate RA_CUSTOMER_TRX.exchange_rate%TYPE;

1288: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
1289: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
1290:
1291: l_invoice_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;
1292: l_exchange_rate RA_CUSTOMER_TRX.exchange_rate%TYPE;
1293: l_le_id RA_CUSTOMER_TRX.legal_entity_id%TYPE;
1294:
1295: -- Bug 1808976
1296: l_customer_bank_account_id RA_CUSTOMER_TRX.customer_bank_account_id%TYPE; -- this will FOREVER be -999

Line 1293: l_le_id RA_CUSTOMER_TRX.legal_entity_id%TYPE;

1289: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
1290:
1291: l_invoice_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;
1292: l_exchange_rate RA_CUSTOMER_TRX.exchange_rate%TYPE;
1293: l_le_id RA_CUSTOMER_TRX.legal_entity_id%TYPE;
1294:
1295: -- Bug 1808976
1296: l_customer_bank_account_id RA_CUSTOMER_TRX.customer_bank_account_id%TYPE; -- this will FOREVER be -999
1297: l_customer_bank_account_id2 RA_CUSTOMER_TRX.customer_bank_account_id%TYPE; -- this changes per customer

Line 1296: l_customer_bank_account_id RA_CUSTOMER_TRX.customer_bank_account_id%TYPE; -- this will FOREVER be -999

1292: l_exchange_rate RA_CUSTOMER_TRX.exchange_rate%TYPE;
1293: l_le_id RA_CUSTOMER_TRX.legal_entity_id%TYPE;
1294:
1295: -- Bug 1808976
1296: l_customer_bank_account_id RA_CUSTOMER_TRX.customer_bank_account_id%TYPE; -- this will FOREVER be -999
1297: l_customer_bank_account_id2 RA_CUSTOMER_TRX.customer_bank_account_id%TYPE; -- this changes per customer
1298:
1299: c_grouping cur_typ;
1300:

Line 1297: l_customer_bank_account_id2 RA_CUSTOMER_TRX.customer_bank_account_id%TYPE; -- this changes per customer

1293: l_le_id RA_CUSTOMER_TRX.legal_entity_id%TYPE;
1294:
1295: -- Bug 1808976
1296: l_customer_bank_account_id RA_CUSTOMER_TRX.customer_bank_account_id%TYPE; -- this will FOREVER be -999
1297: l_customer_bank_account_id2 RA_CUSTOMER_TRX.customer_bank_account_id%TYPE; -- this changes per customer
1298:
1299: c_grouping cur_typ;
1300:
1301: -- 2nd break criteria

Line 1309: l_bill_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;

1305: l_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
1306: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
1307: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
1308:
1309: l_bill_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
1310: l_request_id NUMBER;
1311: -- 3922691
1312: l_print BOOLEAN := TRUE;
1313: l_print1 BOOLEAN := TRUE;

Line 2022: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,

2018: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,
2019: p_suffixe_select_statement OUT NOCOPY varchar2,
2020: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2021: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2022: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2023: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2024: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2025: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
2026: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 2023: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,

2019: p_suffixe_select_statement OUT NOCOPY varchar2,
2020: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2021: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2022: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2023: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2024: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2025: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
2026: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
2027: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,

Line 2025: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

2021: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2022: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2023: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2024: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2025: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
2026: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
2027: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
2028: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
2029: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,

Line 2026: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

2022: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2023: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2024: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2025: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
2026: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
2027: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
2028: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
2029: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
2030: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,

Line 2031: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE

2027: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
2028: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
2029: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
2030: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
2031: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE
2032: ) IS
2033:
2034: l_trx_select_statement VARCHAR2(4000) := NULL;
2035:

Line 2054: - use NOT EXISTS in check against ra_customer_trx_lines

2050: /* Bug 3922691 :
2051: - replace trx.trx_date with ps.trx_date
2052: - replace (ps.due_date - pm.lead_days) <= SYSDATE
2053: with ps.due_date <= SYSDATE + pm.lead_days
2054: - use NOT EXISTS in check against ra_customer_trx_lines
2055: - remove join to hz_cust_acct_sites, this is done in construct_hz
2056: */
2057: /* Bug 4928711 - Removed the references to ap_bank_accounts */
2058:

Line 2063: ra_customer_trx trx,

2059: l_trx_select_statement :=
2060: 'FROM ra_batches batch,
2061: ar_receipt_methods pm,
2062: ar_payment_schedules ps,
2063: ra_customer_trx trx,
2064: ra_cust_trx_types type,
2065: fnd_currencies_vl cur,
2066: hz_cust_accounts cust,
2067: hz_parties party,

Line 2187: ra_customer_trx_lines br_lines,

2183: and nvl(extn.instrument_id,-1) = decode(:p_customer_bank_account_id,-999, nvl(extn.instrument_id,-1),nvl(:p_customer_bank_account_id,-1))
2184: AND NOT EXISTS
2185: (SELECT br_ref_payment_schedule_id
2186: from
2187: ra_customer_trx_lines br_lines,
2188: ar_transaction_history th
2189: where br_lines.br_ref_payment_schedule_id = ps.payment_schedule_id
2190: and br_lines.customer_trx_id = th.customer_trx_id
2191: and th.current_record_flag = ''Y''

Line 2252: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,

2248: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,
2249: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
2250: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2251: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2252: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2253: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2254: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2255: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
2256: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 2253: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,

2249: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
2250: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2251: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2252: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2253: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2254: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2255: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
2256: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
2257: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,

Line 2255: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

2251: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2252: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2253: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2254: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2255: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
2256: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
2257: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
2258: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
2259: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,

Line 2256: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

2252: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2253: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2254: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2255: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
2256: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
2257: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
2258: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
2259: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
2260: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,

Line 2263: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,

2259: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
2260: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
2261: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
2262: p_batch_id IN RA_BATCHES.batch_id%TYPE,
2263: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,
2264: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
2265: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
2266: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE) IS
2267:

Line 2264: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,

2260: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
2261: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
2262: p_batch_id IN RA_BATCHES.batch_id%TYPE,
2263: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,
2264: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
2265: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
2266: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE) IS
2267:
2268: l_trx_select_statement VARCHAR2(5000) :=NULL;

Line 2265: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,

2261: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
2262: p_batch_id IN RA_BATCHES.batch_id%TYPE,
2263: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,
2264: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
2265: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
2266: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE) IS
2267:
2268: l_trx_select_statement VARCHAR2(5000) :=NULL;
2269: l_suffixe_select_statement VARCHAR2(5000) :=NULL;

Line 2266: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE) IS

2262: p_batch_id IN RA_BATCHES.batch_id%TYPE,
2263: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,
2264: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
2265: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
2266: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE) IS
2267:
2268: l_trx_select_statement VARCHAR2(5000) :=NULL;
2269: l_suffixe_select_statement VARCHAR2(5000) :=NULL;
2270: l_suffix_hz VARCHAR2(5000) := NULL;

Line 2500: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,

2496: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,
2497: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
2498: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2499: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2500: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2501: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2502: p_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
2503: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
2504: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 2501: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,

2497: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
2498: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2499: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2500: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2501: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2502: p_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
2503: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
2504: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
2505: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,

Line 2503: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

2499: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2500: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2501: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2502: p_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
2503: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
2504: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
2505: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
2506: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
2507: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,

Line 2504: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

2500: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2501: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2502: p_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
2503: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
2504: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
2505: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
2506: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
2507: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
2508: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,

Line 2511: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,

2507: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
2508: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
2509: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
2510: p_batch_id IN RA_BATCHES.batch_id%TYPE,
2511: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,
2512: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
2513: p_payment_schedule_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
2514: p_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
2515: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,

Line 2512: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,

2508: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
2509: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
2510: p_batch_id IN RA_BATCHES.batch_id%TYPE,
2511: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,
2512: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
2513: p_payment_schedule_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
2514: p_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
2515: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
2516: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE) IS

Line 2514: p_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,

2510: p_batch_id IN RA_BATCHES.batch_id%TYPE,
2511: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,
2512: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
2513: p_payment_schedule_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
2514: p_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
2515: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
2516: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE) IS
2517:
2518: l_trx_select_statement VARCHAR2(5000) :=NULL;

Line 2515: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,

2511: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,
2512: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
2513: p_payment_schedule_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
2514: p_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
2515: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
2516: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE) IS
2517:
2518: l_trx_select_statement VARCHAR2(5000) :=NULL;
2519: l_suffixe_select_statement VARCHAR2(5000) :=NULL;

Line 2516: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE) IS

2512: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
2513: p_payment_schedule_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
2514: p_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
2515: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
2516: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE) IS
2517:
2518: l_trx_select_statement VARCHAR2(5000) :=NULL;
2519: l_suffixe_select_statement VARCHAR2(5000) :=NULL;
2520: l_suffix_hz VARCHAR2(5000) := NULL;

Line 2758: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE DEFAULT NULL,

2754: p_maturity_date_rule_code IN AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE,
2755: p_br_min_acctd_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
2756: p_br_max_acctd_amount IN AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE,
2757: p_currency_code IN RA_BATCHES.currency_code%TYPE,
2758: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE DEFAULT NULL,
2759: p_le_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
2760: p_bill_id OUT NOCOPY RA_CUSTOMER_TRX.customer_trx_id%TYPE,
2761: p_request_id OUT NOCOPY NUMBER) IS
2762:

Line 2759: p_le_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,

2755: p_br_min_acctd_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
2756: p_br_max_acctd_amount IN AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE,
2757: p_currency_code IN RA_BATCHES.currency_code%TYPE,
2758: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE DEFAULT NULL,
2759: p_le_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
2760: p_bill_id OUT NOCOPY RA_CUSTOMER_TRX.customer_trx_id%TYPE,
2761: p_request_id OUT NOCOPY NUMBER) IS
2762:
2763:

Line 2760: p_bill_id OUT NOCOPY RA_CUSTOMER_TRX.customer_trx_id%TYPE,

2756: p_br_max_acctd_amount IN AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE,
2757: p_currency_code IN RA_BATCHES.currency_code%TYPE,
2758: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE DEFAULT NULL,
2759: p_le_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
2760: p_bill_id OUT NOCOPY RA_CUSTOMER_TRX.customer_trx_id%TYPE,
2761: p_request_id OUT NOCOPY NUMBER) IS
2762:
2763:
2764: c_trx cur_typ;

Line 2774: l_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;

2770: l_msg_data VARCHAR2(4000);
2771:
2772: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
2773:
2774: l_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
2775: l_br_maturity_date RA_CUSTOMER_TRX.term_due_date%TYPE;
2776: l_cust_trx_type_id RA_CUSTOMER_TRX.cust_trx_type_id%TYPE;
2777: l_drawee_id RA_CUSTOMER_TRX.drawee_id%TYPE;
2778: l_drawee_site_use_id RA_CUSTOMER_TRX.drawee_site_use_id%TYPE;

Line 2775: l_br_maturity_date RA_CUSTOMER_TRX.term_due_date%TYPE;

2771:
2772: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
2773:
2774: l_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
2775: l_br_maturity_date RA_CUSTOMER_TRX.term_due_date%TYPE;
2776: l_cust_trx_type_id RA_CUSTOMER_TRX.cust_trx_type_id%TYPE;
2777: l_drawee_id RA_CUSTOMER_TRX.drawee_id%TYPE;
2778: l_drawee_site_use_id RA_CUSTOMER_TRX.drawee_site_use_id%TYPE;
2779: l_drawee_contact_id RA_CUSTOMER_TRX.drawee_contact_id%TYPE;

Line 2776: l_cust_trx_type_id RA_CUSTOMER_TRX.cust_trx_type_id%TYPE;

2772: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
2773:
2774: l_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
2775: l_br_maturity_date RA_CUSTOMER_TRX.term_due_date%TYPE;
2776: l_cust_trx_type_id RA_CUSTOMER_TRX.cust_trx_type_id%TYPE;
2777: l_drawee_id RA_CUSTOMER_TRX.drawee_id%TYPE;
2778: l_drawee_site_use_id RA_CUSTOMER_TRX.drawee_site_use_id%TYPE;
2779: l_drawee_contact_id RA_CUSTOMER_TRX.drawee_contact_id%TYPE;
2780: l_drawee_bank_account_id RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE;

Line 2777: l_drawee_id RA_CUSTOMER_TRX.drawee_id%TYPE;

2773:
2774: l_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
2775: l_br_maturity_date RA_CUSTOMER_TRX.term_due_date%TYPE;
2776: l_cust_trx_type_id RA_CUSTOMER_TRX.cust_trx_type_id%TYPE;
2777: l_drawee_id RA_CUSTOMER_TRX.drawee_id%TYPE;
2778: l_drawee_site_use_id RA_CUSTOMER_TRX.drawee_site_use_id%TYPE;
2779: l_drawee_contact_id RA_CUSTOMER_TRX.drawee_contact_id%TYPE;
2780: l_drawee_bank_account_id RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE;
2781: l_created_from RA_CUSTOMER_TRX.created_from%TYPE;

Line 2778: l_drawee_site_use_id RA_CUSTOMER_TRX.drawee_site_use_id%TYPE;

2774: l_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
2775: l_br_maturity_date RA_CUSTOMER_TRX.term_due_date%TYPE;
2776: l_cust_trx_type_id RA_CUSTOMER_TRX.cust_trx_type_id%TYPE;
2777: l_drawee_id RA_CUSTOMER_TRX.drawee_id%TYPE;
2778: l_drawee_site_use_id RA_CUSTOMER_TRX.drawee_site_use_id%TYPE;
2779: l_drawee_contact_id RA_CUSTOMER_TRX.drawee_contact_id%TYPE;
2780: l_drawee_bank_account_id RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE;
2781: l_created_from RA_CUSTOMER_TRX.created_from%TYPE;
2782:

Line 2779: l_drawee_contact_id RA_CUSTOMER_TRX.drawee_contact_id%TYPE;

2775: l_br_maturity_date RA_CUSTOMER_TRX.term_due_date%TYPE;
2776: l_cust_trx_type_id RA_CUSTOMER_TRX.cust_trx_type_id%TYPE;
2777: l_drawee_id RA_CUSTOMER_TRX.drawee_id%TYPE;
2778: l_drawee_site_use_id RA_CUSTOMER_TRX.drawee_site_use_id%TYPE;
2779: l_drawee_contact_id RA_CUSTOMER_TRX.drawee_contact_id%TYPE;
2780: l_drawee_bank_account_id RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE;
2781: l_created_from RA_CUSTOMER_TRX.created_from%TYPE;
2782:
2783: -- Bug 1808976

Line 2780: l_drawee_bank_account_id RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE;

2776: l_cust_trx_type_id RA_CUSTOMER_TRX.cust_trx_type_id%TYPE;
2777: l_drawee_id RA_CUSTOMER_TRX.drawee_id%TYPE;
2778: l_drawee_site_use_id RA_CUSTOMER_TRX.drawee_site_use_id%TYPE;
2779: l_drawee_contact_id RA_CUSTOMER_TRX.drawee_contact_id%TYPE;
2780: l_drawee_bank_account_id RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE;
2781: l_created_from RA_CUSTOMER_TRX.created_from%TYPE;
2782:
2783: -- Bug 1808976
2784: l_site_id RA_CUSTOMER_TRX.bill_to_site_use_id%TYPE;

Line 2781: l_created_from RA_CUSTOMER_TRX.created_from%TYPE;

2777: l_drawee_id RA_CUSTOMER_TRX.drawee_id%TYPE;
2778: l_drawee_site_use_id RA_CUSTOMER_TRX.drawee_site_use_id%TYPE;
2779: l_drawee_contact_id RA_CUSTOMER_TRX.drawee_contact_id%TYPE;
2780: l_drawee_bank_account_id RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE;
2781: l_created_from RA_CUSTOMER_TRX.created_from%TYPE;
2782:
2783: -- Bug 1808976
2784: l_site_id RA_CUSTOMER_TRX.bill_to_site_use_id%TYPE;
2785: l_bill_to_site_id RA_CUSTOMER_TRX.bill_to_site_use_id%TYPE;

Line 2784: l_site_id RA_CUSTOMER_TRX.bill_to_site_use_id%TYPE;

2780: l_drawee_bank_account_id RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE;
2781: l_created_from RA_CUSTOMER_TRX.created_from%TYPE;
2782:
2783: -- Bug 1808976
2784: l_site_id RA_CUSTOMER_TRX.bill_to_site_use_id%TYPE;
2785: l_bill_to_site_id RA_CUSTOMER_TRX.bill_to_site_use_id%TYPE;
2786:
2787:
2788: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE;

Line 2785: l_bill_to_site_id RA_CUSTOMER_TRX.bill_to_site_use_id%TYPE;

2781: l_created_from RA_CUSTOMER_TRX.created_from%TYPE;
2782:
2783: -- Bug 1808976
2784: l_site_id RA_CUSTOMER_TRX.bill_to_site_use_id%TYPE;
2785: l_bill_to_site_id RA_CUSTOMER_TRX.bill_to_site_use_id%TYPE;
2786:
2787:
2788: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE;
2789:

Line 2788: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE;

2784: l_site_id RA_CUSTOMER_TRX.bill_to_site_use_id%TYPE;
2785: l_bill_to_site_id RA_CUSTOMER_TRX.bill_to_site_use_id%TYPE;
2786:
2787:
2788: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE;
2789:
2790: l_bill_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
2791: l_bill_number RA_CUSTOMER_TRX.trx_number%TYPE;
2792: l_bill_status AR_TRANSACTION_HISTORY.status%TYPE;

Line 2790: l_bill_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;

2786:
2787:
2788: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE;
2789:
2790: l_bill_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
2791: l_bill_number RA_CUSTOMER_TRX.trx_number%TYPE;
2792: l_bill_status AR_TRANSACTION_HISTORY.status%TYPE;
2793: l_request_id NUMBER;
2794:

Line 2791: l_bill_number RA_CUSTOMER_TRX.trx_number%TYPE;

2787:
2788: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE;
2789:
2790: l_bill_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
2791: l_bill_number RA_CUSTOMER_TRX.trx_number%TYPE;
2792: l_bill_status AR_TRANSACTION_HISTORY.status%TYPE;
2793: l_request_id NUMBER;
2794:
2795: l_batch_process_status RA_BATCHES.batch_process_status%TYPE;

Line 2842: l_trx_number RA_CUSTOMER_TRX.TRX_NUMBER%TYPE;

2838: l_bill_to_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2839:
2840: -- Bug 1708420 : define variable to hold BR_INHERIT_INV_NUM_FLAG value
2841: l_br_inherit_inv_num_flag AR_RECEIPT_METHODS.BR_INHERIT_INV_NUM_FLAG%TYPE;
2842: l_trx_number RA_CUSTOMER_TRX.TRX_NUMBER%TYPE;
2843: l_count_trxid NUMBER;
2844: l_count_ps NUMBER;
2845: l_cust_trx_id RA_CUSTOMER_TRX.CUSTOMER_TRX_ID%TYPE;
2846:

Line 2845: l_cust_trx_id RA_CUSTOMER_TRX.CUSTOMER_TRX_ID%TYPE;

2841: l_br_inherit_inv_num_flag AR_RECEIPT_METHODS.BR_INHERIT_INV_NUM_FLAG%TYPE;
2842: l_trx_number RA_CUSTOMER_TRX.TRX_NUMBER%TYPE;
2843: l_count_trxid NUMBER;
2844: l_count_ps NUMBER;
2845: l_cust_trx_id RA_CUSTOMER_TRX.CUSTOMER_TRX_ID%TYPE;
2846:
2847: -- Bug2290332: Check for Automatic Transaction Numbering
2848: CURSOR bs_details(p_batch_source_id IN number) is
2849: SELECT auto_trx_numbering_flag, name

Line 3716: select org_id into jnk1 from ra_customer_trx where customer_trx_id = l_bill_id;

3712: l_bill_status);
3713: end if;
3714:
3715:
3716: select org_id into jnk1 from ra_customer_trx where customer_trx_id = l_bill_id;
3717: select org_id into jnk2 from ar_transaction_history where customer_trx_id = l_bill_id;
3718:
3719: program_debug(p_call,'done with AR_BILLS_CREATION_PUB.Create_BR_Header org_id = ' || to_char(jnk1) || 'org_id = ' ||
3720: to_char(jnk2));

Line 3800: select org_id into jnk1 from ra_customer_trx_lines where customer_trx_line_id = l_customer_trx_line_id;

3796: NULL, -- p_attribute15
3797: l_org_id, -- p_org_id
3798: l_customer_trx_line_id);
3799:
3800: select org_id into jnk1 from ra_customer_trx_lines where customer_trx_line_id = l_customer_trx_line_id;
3801: program_debug(p_call,'done with AR_BILLS_CREATION_PUB.Create_BR_Assignment for NIMM, org_id = '
3802: || to_char(jnk1));
3803:
3804: EXCEPTION /* Bug 3472744 Enclosed the following check in Exception block */

Line 4001: ra_customer_trx trx

3997:
3998: SELECT NVL(default_printing_option,'NOT')
3999: into l_default_printing_option
4000: FROM ra_cust_trx_types type,
4001: ra_customer_trx trx
4002: WHERE trx.customer_trx_id = l_bill_id
4003: AND trx.cust_trx_type_id = type.cust_trx_type_id;
4004:
4005: l_request_id := NULL;

Line 4181: p_request_id IN RA_CUSTOMER_TRX.request_id%TYPE,

4177: | MODIFICATION HISTORY - Created by Attila Rimai - 13/07/2000 |
4178: | |
4179: +===========================================================================*/
4180: PROCEDURE ar_br_insert_into_report_table(
4181: p_request_id IN RA_CUSTOMER_TRX.request_id%TYPE,
4182: p_batch_id IN RA_BATCHES.batch_id%TYPE,
4183: p_br_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
4184: p_bill_number IN RA_CUSTOMER_TRX.trx_number%TYPE,
4185: p_br_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,

Line 4183: p_br_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,

4179: +===========================================================================*/
4180: PROCEDURE ar_br_insert_into_report_table(
4181: p_request_id IN RA_CUSTOMER_TRX.request_id%TYPE,
4182: p_batch_id IN RA_BATCHES.batch_id%TYPE,
4183: p_br_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
4184: p_bill_number IN RA_CUSTOMER_TRX.trx_number%TYPE,
4185: p_br_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
4186: p_br_currency IN RA_BATCHES.currency_code%TYPE,
4187: p_batch_status IN RA_BATCHES.status%TYPE,

Line 4184: p_bill_number IN RA_CUSTOMER_TRX.trx_number%TYPE,

4180: PROCEDURE ar_br_insert_into_report_table(
4181: p_request_id IN RA_CUSTOMER_TRX.request_id%TYPE,
4182: p_batch_id IN RA_BATCHES.batch_id%TYPE,
4183: p_br_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
4184: p_bill_number IN RA_CUSTOMER_TRX.trx_number%TYPE,
4185: p_br_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
4186: p_br_currency IN RA_BATCHES.currency_code%TYPE,
4187: p_batch_status IN RA_BATCHES.status%TYPE,
4188: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,

Line 4189: p_drawee_id IN RA_CUSTOMER_TRX.drawee_id%TYPE,

4185: p_br_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
4186: p_br_currency IN RA_BATCHES.currency_code%TYPE,
4187: p_batch_status IN RA_BATCHES.status%TYPE,
4188: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
4189: p_drawee_id IN RA_CUSTOMER_TRX.drawee_id%TYPE,
4190: p_drawee_contact_id IN RA_CUSTOMER_TRX.drawee_contact_id%TYPE,
4191: p_drawee_site_use_id IN RA_CUSTOMER_TRX.drawee_site_use_id%TYPE,
4192: p_drawee_bank_account_id IN RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE,
4193: p_transaction_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,

Line 4190: p_drawee_contact_id IN RA_CUSTOMER_TRX.drawee_contact_id%TYPE,

4186: p_br_currency IN RA_BATCHES.currency_code%TYPE,
4187: p_batch_status IN RA_BATCHES.status%TYPE,
4188: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
4189: p_drawee_id IN RA_CUSTOMER_TRX.drawee_id%TYPE,
4190: p_drawee_contact_id IN RA_CUSTOMER_TRX.drawee_contact_id%TYPE,
4191: p_drawee_site_use_id IN RA_CUSTOMER_TRX.drawee_site_use_id%TYPE,
4192: p_drawee_bank_account_id IN RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE,
4193: p_transaction_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
4194: p_amount_assigned IN RA_CUSTOMER_TRX.br_amount%TYPE,

Line 4191: p_drawee_site_use_id IN RA_CUSTOMER_TRX.drawee_site_use_id%TYPE,

4187: p_batch_status IN RA_BATCHES.status%TYPE,
4188: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
4189: p_drawee_id IN RA_CUSTOMER_TRX.drawee_id%TYPE,
4190: p_drawee_contact_id IN RA_CUSTOMER_TRX.drawee_contact_id%TYPE,
4191: p_drawee_site_use_id IN RA_CUSTOMER_TRX.drawee_site_use_id%TYPE,
4192: p_drawee_bank_account_id IN RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE,
4193: p_transaction_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
4194: p_amount_assigned IN RA_CUSTOMER_TRX.br_amount%TYPE,
4195: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE) IS

Line 4192: p_drawee_bank_account_id IN RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE,

4188: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
4189: p_drawee_id IN RA_CUSTOMER_TRX.drawee_id%TYPE,
4190: p_drawee_contact_id IN RA_CUSTOMER_TRX.drawee_contact_id%TYPE,
4191: p_drawee_site_use_id IN RA_CUSTOMER_TRX.drawee_site_use_id%TYPE,
4192: p_drawee_bank_account_id IN RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE,
4193: p_transaction_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
4194: p_amount_assigned IN RA_CUSTOMER_TRX.br_amount%TYPE,
4195: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE) IS
4196:

Line 4193: p_transaction_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,

4189: p_drawee_id IN RA_CUSTOMER_TRX.drawee_id%TYPE,
4190: p_drawee_contact_id IN RA_CUSTOMER_TRX.drawee_contact_id%TYPE,
4191: p_drawee_site_use_id IN RA_CUSTOMER_TRX.drawee_site_use_id%TYPE,
4192: p_drawee_bank_account_id IN RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE,
4193: p_transaction_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
4194: p_amount_assigned IN RA_CUSTOMER_TRX.br_amount%TYPE,
4195: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE) IS
4196:
4197: -- Bug 1420183

Line 4194: p_amount_assigned IN RA_CUSTOMER_TRX.br_amount%TYPE,

4190: p_drawee_contact_id IN RA_CUSTOMER_TRX.drawee_contact_id%TYPE,
4191: p_drawee_site_use_id IN RA_CUSTOMER_TRX.drawee_site_use_id%TYPE,
4192: p_drawee_bank_account_id IN RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE,
4193: p_transaction_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
4194: p_amount_assigned IN RA_CUSTOMER_TRX.br_amount%TYPE,
4195: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE) IS
4196:
4197: -- Bug 1420183
4198: -- Could pass creation rule code, min/max amounts into this procedure as parameters, but since

Line 4853: p_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,

4849: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4850: x_return_status OUT NOCOPY VARCHAR2,
4851: x_msg_count OUT NOCOPY NUMBER,
4852: x_msg_data OUT NOCOPY VARCHAR2,
4853: p_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
4854: p_bill_id OUT NOCOPY RA_CUSTOMER_TRX.customer_trx_id%TYPE,
4855: p_request_id OUT NOCOPY NUMBER,
4856: p_nb_bill OUT NOCOPY NUMBER) IS
4857:

Line 4854: p_bill_id OUT NOCOPY RA_CUSTOMER_TRX.customer_trx_id%TYPE,

4850: x_return_status OUT NOCOPY VARCHAR2,
4851: x_msg_count OUT NOCOPY NUMBER,
4852: x_msg_data OUT NOCOPY VARCHAR2,
4853: p_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
4854: p_bill_id OUT NOCOPY RA_CUSTOMER_TRX.customer_trx_id%TYPE,
4855: p_request_id OUT NOCOPY NUMBER,
4856: p_nb_bill OUT NOCOPY NUMBER) IS
4857:
4858: l_api_name CONSTANT varchar2(30) := 'auto_create_br_API';

Line 4875: ra_customer_trx trx

4871: -- trx.customer_bank_account_id, Bug 5051673
4872: trx.payment_trxn_extension_id,
4873: trx.legal_entity_id
4874: FROM ar_receipt_methods pm,
4875: ra_customer_trx trx
4876: WHERE trx.customer_trx_id = p_customer_trx_id
4877: AND trx.receipt_method_id = pm.receipt_method_id;
4878:
4879: c_grouping cur_typ;

Line 4895: l_invoice_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;

4891: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
4892: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;
4893: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
4894: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
4895: l_invoice_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;
4896: l_le_id RA_CUSTOMER_TRX.legal_entity_id%TYPE;
4897:
4898: -- bug 1808976 :
4899: l_customer_bank_account_id RA_CUSTOMER_TRX.customer_bank_account_id%TYPE;

Line 4896: l_le_id RA_CUSTOMER_TRX.legal_entity_id%TYPE;

4892: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;
4893: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
4894: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
4895: l_invoice_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;
4896: l_le_id RA_CUSTOMER_TRX.legal_entity_id%TYPE;
4897:
4898: -- bug 1808976 :
4899: l_customer_bank_account_id RA_CUSTOMER_TRX.customer_bank_account_id%TYPE;
4900:

Line 4899: l_customer_bank_account_id RA_CUSTOMER_TRX.customer_bank_account_id%TYPE;

4895: l_invoice_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;
4896: l_le_id RA_CUSTOMER_TRX.legal_entity_id%TYPE;
4897:
4898: -- bug 1808976 :
4899: l_customer_bank_account_id RA_CUSTOMER_TRX.customer_bank_account_id%TYPE;
4900:
4901: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
4902: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
4903: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;

Line 4912: l_bill_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;

4908: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
4909: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
4910: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
4911:
4912: l_bill_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
4913: l_request_id NUMBER;
4914:
4915: BEGIN
4916:

Line 4983: ' ra_customer_trx trx,'||

4979: */
4980:
4981: l_suffixe_select_statement := ' FROM ar_payment_schedules ps,'||
4982: ' ra_cust_trx_types type,'||
4983: ' ra_customer_trx trx,'||
4984: ' ar_receipt_methods pm '||
4985: 'WHERE ps.cust_trx_type_id = type.cust_trx_type_id '||
4986: 'AND (type.type IN (''INV'',''DEP'',''CB'') OR '||
4987: ' (type.type IN (''CM'',''DM'') AND ps.term_id <> 5)) '||

Line 4992: 'ra_customer_trx_lines br_lines, '||

4988: 'AND ps.customer_trx_id = NVL(:p_customer_trx_id,ps.customer_trx_id) '||
4989: 'AND ps.payment_schedule_id NOT IN '||
4990: '(SELECT br_ref_payment_schedule_id '||
4991: ' from '||
4992: 'ra_customer_trx_lines br_lines, '||
4993: 'ar_transaction_history th '||
4994: 'where br_lines.br_ref_payment_schedule_id = ps.payment_schedule_id '||
4995: 'and br_lines.customer_trx_id = th.customer_trx_id '||
4996: 'and th.current_record_flag = ''Y'' '||