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 387: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE DEFAULT NULL,

383: p_trx_date_high IN VARCHAR2 DEFAULT NULL,
384: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE DEFAULT NULL,
385: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE DEFAULT NULL,
386: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE DEFAULT NULL,
387: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE DEFAULT NULL,
388: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE DEFAULT NULL,
389: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE DEFAULT NULL,
390: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE DEFAULT NULL,
391: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE DEFAULT NULL,

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

384: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE DEFAULT NULL,
385: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE DEFAULT NULL,
386: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE DEFAULT NULL,
387: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE DEFAULT NULL,
388: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE DEFAULT NULL,
389: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE DEFAULT NULL,
390: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE DEFAULT NULL,
391: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE DEFAULT NULL,
392: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE DEFAULT NULL) IS

Line 596: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,

592: p_print_flag IN VARCHAR2,
593: p_batch_id IN RA_BATCHES.batch_id%TYPE,
594: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
595: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
596: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
597: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
598: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
599: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
600: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,

Line 597: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,

593: p_batch_id IN RA_BATCHES.batch_id%TYPE,
594: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
595: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
596: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
597: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
598: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
599: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
600: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
601: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 601: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

597: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
598: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
599: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
600: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
601: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
602: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
603: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
604: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
605: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,

Line 602: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

598: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
599: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
600: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
601: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
602: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
603: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
604: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
605: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
606: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE) IS

Line 714: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,

710: p_attribute14 IN VARCHAR2,
711: p_attribute15 IN VARCHAR2,
712: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
713: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
714: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
715: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
716: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
717: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
718: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,

Line 715: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,

711: p_attribute15 IN VARCHAR2,
712: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
713: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
714: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
715: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
716: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
717: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
718: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
719: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 719: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

715: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
716: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
717: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
718: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
719: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
720: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
721: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
722: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
723: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,

Line 720: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

716: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
717: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
718: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
719: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
720: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
721: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
722: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
723: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
724: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE) IS

Line 879: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,

875: p_attribute14 IN VARCHAR2,
876: p_attribute15 IN VARCHAR2,
877: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
878: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
879: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
880: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
881: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
882: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
883: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,

Line 880: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,

876: p_attribute15 IN VARCHAR2,
877: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
878: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
879: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
880: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
881: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
882: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
883: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
884: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 884: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

880: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
881: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
882: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
883: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
884: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
885: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
886: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
887: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
888: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,

Line 885: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

881: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
882: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
883: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
884: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
885: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
886: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
887: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
888: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
889: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,

Line 1152: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,

1148: p_call IN NUMBER,
1149: p_batch_id IN RA_BATCHES.batch_id%TYPE,
1150: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1151: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1152: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
1153: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
1154: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
1155: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
1156: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,

Line 1153: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,

1149: p_batch_id IN RA_BATCHES.batch_id%TYPE,
1150: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1151: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1152: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
1153: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
1154: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
1155: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
1156: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
1157: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 1157: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

1153: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
1154: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
1155: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
1156: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
1157: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
1158: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
1159: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
1160: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
1161: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,

Line 1158: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

1154: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
1155: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
1156: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
1157: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
1158: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
1159: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
1160: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
1161: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
1162: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE) IS

Line 1182: ra_customer_trx trx,

1178: trx.invoice_currency_code, trx.exchange_rate, trx.legal_entity_id
1179: FROM ra_batches batch,
1180: ar_receipt_classes class,
1181: ar_receipt_methods pm,
1182: ra_customer_trx trx,
1183: ra_cust_trx_types type,
1184: fnd_currencies_vl cur
1185: WHERE pm.receipt_method_id = NVL(p_rcpt_meth_id,pm.receipt_method_id)
1186: AND type.cust_trx_type_id = NVL(p_trx_type_id,type.cust_trx_type_id)

Line 1219: ra_customer_trx trx,

1215: SELECT distinct instrument_id customer_bank_account_id
1216: FROM ra_batches batch,
1217: ar_receipt_classes class,
1218: ar_receipt_methods pm,
1219: ra_customer_trx trx,
1220: ra_cust_trx_types type,
1221: fnd_currencies_vl cur,
1222: iby_trxn_extensions_v extn
1223: WHERE pm.receipt_method_id = rm_id

Line 1273: l_invoice_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;

1269: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;
1270: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
1271: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
1272:
1273: l_invoice_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;
1274: l_exchange_rate RA_CUSTOMER_TRX.exchange_rate%TYPE;
1275: l_le_id RA_CUSTOMER_TRX.legal_entity_id%TYPE;
1276:
1277: -- Bug 1808976

Line 1274: l_exchange_rate RA_CUSTOMER_TRX.exchange_rate%TYPE;

1270: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
1271: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
1272:
1273: l_invoice_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;
1274: l_exchange_rate RA_CUSTOMER_TRX.exchange_rate%TYPE;
1275: l_le_id RA_CUSTOMER_TRX.legal_entity_id%TYPE;
1276:
1277: -- Bug 1808976
1278: l_customer_bank_account_id RA_CUSTOMER_TRX.customer_bank_account_id%TYPE; -- this will FOREVER be -999

Line 1275: l_le_id RA_CUSTOMER_TRX.legal_entity_id%TYPE;

1271: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
1272:
1273: l_invoice_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;
1274: l_exchange_rate RA_CUSTOMER_TRX.exchange_rate%TYPE;
1275: l_le_id RA_CUSTOMER_TRX.legal_entity_id%TYPE;
1276:
1277: -- Bug 1808976
1278: l_customer_bank_account_id RA_CUSTOMER_TRX.customer_bank_account_id%TYPE; -- this will FOREVER be -999
1279: l_customer_bank_account_id2 RA_CUSTOMER_TRX.customer_bank_account_id%TYPE; -- this changes per customer

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

1274: l_exchange_rate RA_CUSTOMER_TRX.exchange_rate%TYPE;
1275: l_le_id RA_CUSTOMER_TRX.legal_entity_id%TYPE;
1276:
1277: -- Bug 1808976
1278: l_customer_bank_account_id RA_CUSTOMER_TRX.customer_bank_account_id%TYPE; -- this will FOREVER be -999
1279: l_customer_bank_account_id2 RA_CUSTOMER_TRX.customer_bank_account_id%TYPE; -- this changes per customer
1280:
1281: c_grouping cur_typ;
1282:

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

1275: l_le_id RA_CUSTOMER_TRX.legal_entity_id%TYPE;
1276:
1277: -- Bug 1808976
1278: l_customer_bank_account_id RA_CUSTOMER_TRX.customer_bank_account_id%TYPE; -- this will FOREVER be -999
1279: l_customer_bank_account_id2 RA_CUSTOMER_TRX.customer_bank_account_id%TYPE; -- this changes per customer
1280:
1281: c_grouping cur_typ;
1282:
1283: -- 2nd break criteria

Line 1291: l_bill_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;

1287: l_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
1288: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
1289: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
1290:
1291: l_bill_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
1292: l_request_id NUMBER;
1293: -- 3922691
1294: l_print BOOLEAN := TRUE;
1295: l_print1 BOOLEAN := TRUE;

Line 1873: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,

1869: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,
1870: p_suffixe_select_statement OUT NOCOPY varchar2,
1871: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1872: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1873: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
1874: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
1875: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
1876: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
1877: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 1874: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,

1870: p_suffixe_select_statement OUT NOCOPY varchar2,
1871: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1872: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1873: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
1874: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
1875: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
1876: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
1877: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
1878: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,

Line 1876: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

1872: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1873: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
1874: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
1875: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
1876: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
1877: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
1878: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
1879: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
1880: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,

Line 1877: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

1873: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
1874: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
1875: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
1876: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
1877: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
1878: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
1879: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
1880: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
1881: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,

Line 1882: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE

1878: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
1879: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
1880: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
1881: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
1882: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE
1883: ) IS
1884:
1885: l_trx_select_statement VARCHAR2(4000) := NULL;
1886:

Line 1905: - use NOT EXISTS in check against ra_customer_trx_lines

1901: /* Bug 3922691 :
1902: - replace trx.trx_date with ps.trx_date
1903: - replace (ps.due_date - pm.lead_days) <= SYSDATE
1904: with ps.due_date <= SYSDATE + pm.lead_days
1905: - use NOT EXISTS in check against ra_customer_trx_lines
1906: - remove join to hz_cust_acct_sites, this is done in construct_hz
1907: */
1908: /* Bug 4928711 - Removed the references to ap_bank_accounts */
1909:

Line 1914: ra_customer_trx trx,

1910: l_trx_select_statement :=
1911: 'FROM ra_batches batch,
1912: ar_receipt_methods pm,
1913: ar_payment_schedules ps,
1914: ra_customer_trx trx,
1915: ra_cust_trx_types type,
1916: fnd_currencies_vl cur,
1917: hz_cust_accounts cust,
1918: hz_parties party,

Line 2046: ra_customer_trx_lines br_lines,

2042: 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))
2043: AND NOT EXISTS
2044: (SELECT br_ref_payment_schedule_id
2045: from
2046: ra_customer_trx_lines br_lines,
2047: ar_transaction_history th
2048: where br_lines.br_ref_payment_schedule_id = ps.payment_schedule_id
2049: and br_lines.customer_trx_id = th.customer_trx_id
2050: and th.current_record_flag = ''Y''

Line 2111: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,

2107: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,
2108: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
2109: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2110: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2111: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2112: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2113: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2114: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
2115: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 2112: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,

2108: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
2109: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2110: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2111: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2112: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2113: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2114: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
2115: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
2116: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,

Line 2114: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

2110: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2111: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2112: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2113: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2114: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
2115: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
2116: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
2117: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
2118: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,

Line 2115: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

2111: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2112: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2113: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2114: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
2115: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
2116: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
2117: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
2118: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
2119: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,

Line 2122: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,

2118: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
2119: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
2120: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
2121: p_batch_id IN RA_BATCHES.batch_id%TYPE,
2122: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,
2123: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
2124: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
2125: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE) IS
2126:

Line 2123: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,

2119: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
2120: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
2121: p_batch_id IN RA_BATCHES.batch_id%TYPE,
2122: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,
2123: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
2124: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
2125: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE) IS
2126:
2127: l_trx_select_statement VARCHAR2(5000) :=NULL;

Line 2124: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,

2120: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
2121: p_batch_id IN RA_BATCHES.batch_id%TYPE,
2122: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,
2123: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
2124: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
2125: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE) IS
2126:
2127: l_trx_select_statement VARCHAR2(5000) :=NULL;
2128: l_suffixe_select_statement VARCHAR2(5000) :=NULL;

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

2121: p_batch_id IN RA_BATCHES.batch_id%TYPE,
2122: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,
2123: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
2124: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
2125: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE) IS
2126:
2127: l_trx_select_statement VARCHAR2(5000) :=NULL;
2128: l_suffixe_select_statement VARCHAR2(5000) :=NULL;
2129: l_suffix_hz VARCHAR2(5000) := NULL;

Line 2359: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,

2355: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,
2356: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
2357: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2358: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2359: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2360: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2361: p_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
2362: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
2363: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 2360: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,

2356: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
2357: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2358: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2359: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2360: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2361: p_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
2362: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
2363: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
2364: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,

Line 2362: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,

2358: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2359: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2360: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2361: p_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
2362: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
2363: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
2364: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
2365: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
2366: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,

Line 2363: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

2359: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2360: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2361: p_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
2362: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
2363: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
2364: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
2365: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
2366: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
2367: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,

Line 2370: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,

2366: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
2367: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
2368: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
2369: p_batch_id IN RA_BATCHES.batch_id%TYPE,
2370: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,
2371: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
2372: p_payment_schedule_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
2373: p_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
2374: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,

Line 2371: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,

2367: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
2368: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
2369: p_batch_id IN RA_BATCHES.batch_id%TYPE,
2370: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,
2371: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
2372: p_payment_schedule_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
2373: p_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
2374: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
2375: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE) IS

Line 2373: p_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,

2369: p_batch_id IN RA_BATCHES.batch_id%TYPE,
2370: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,
2371: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
2372: p_payment_schedule_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
2373: p_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
2374: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
2375: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE) IS
2376:
2377: l_trx_select_statement VARCHAR2(5000) :=NULL;

Line 2374: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,

2370: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,
2371: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
2372: p_payment_schedule_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
2373: p_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
2374: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
2375: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE) IS
2376:
2377: l_trx_select_statement VARCHAR2(5000) :=NULL;
2378: l_suffixe_select_statement VARCHAR2(5000) :=NULL;

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

2371: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,
2372: p_payment_schedule_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
2373: p_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
2374: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
2375: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE) IS
2376:
2377: l_trx_select_statement VARCHAR2(5000) :=NULL;
2378: l_suffixe_select_statement VARCHAR2(5000) :=NULL;
2379: l_suffix_hz VARCHAR2(5000) := NULL;

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

2613: p_maturity_date_rule_code IN AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE,
2614: p_br_min_acctd_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
2615: p_br_max_acctd_amount IN AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE,
2616: p_currency_code IN RA_BATCHES.currency_code%TYPE,
2617: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE DEFAULT NULL,
2618: p_le_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
2619: p_bill_id OUT NOCOPY RA_CUSTOMER_TRX.customer_trx_id%TYPE,
2620: p_request_id OUT NOCOPY NUMBER) IS
2621:

Line 2618: p_le_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,

2614: p_br_min_acctd_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
2615: p_br_max_acctd_amount IN AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE,
2616: p_currency_code IN RA_BATCHES.currency_code%TYPE,
2617: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE DEFAULT NULL,
2618: p_le_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
2619: p_bill_id OUT NOCOPY RA_CUSTOMER_TRX.customer_trx_id%TYPE,
2620: p_request_id OUT NOCOPY NUMBER) IS
2621:
2622:

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

2615: p_br_max_acctd_amount IN AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE,
2616: p_currency_code IN RA_BATCHES.currency_code%TYPE,
2617: p_customer_bank_account_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE DEFAULT NULL,
2618: p_le_id IN RA_CUSTOMER_TRX.customer_bank_account_id%TYPE,
2619: p_bill_id OUT NOCOPY RA_CUSTOMER_TRX.customer_trx_id%TYPE,
2620: p_request_id OUT NOCOPY NUMBER) IS
2621:
2622:
2623: c_trx cur_typ;

Line 2633: l_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;

2629: l_msg_data VARCHAR2(4000);
2630:
2631: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
2632:
2633: l_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
2634: l_br_maturity_date RA_CUSTOMER_TRX.term_due_date%TYPE;
2635: l_cust_trx_type_id RA_CUSTOMER_TRX.cust_trx_type_id%TYPE;
2636: l_drawee_id RA_CUSTOMER_TRX.drawee_id%TYPE;
2637: l_drawee_site_use_id RA_CUSTOMER_TRX.drawee_site_use_id%TYPE;

Line 2634: l_br_maturity_date RA_CUSTOMER_TRX.term_due_date%TYPE;

2630:
2631: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
2632:
2633: l_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
2634: l_br_maturity_date RA_CUSTOMER_TRX.term_due_date%TYPE;
2635: l_cust_trx_type_id RA_CUSTOMER_TRX.cust_trx_type_id%TYPE;
2636: l_drawee_id RA_CUSTOMER_TRX.drawee_id%TYPE;
2637: l_drawee_site_use_id RA_CUSTOMER_TRX.drawee_site_use_id%TYPE;
2638: l_drawee_contact_id RA_CUSTOMER_TRX.drawee_contact_id%TYPE;

Line 2635: l_cust_trx_type_id RA_CUSTOMER_TRX.cust_trx_type_id%TYPE;

2631: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
2632:
2633: l_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
2634: l_br_maturity_date RA_CUSTOMER_TRX.term_due_date%TYPE;
2635: l_cust_trx_type_id RA_CUSTOMER_TRX.cust_trx_type_id%TYPE;
2636: l_drawee_id RA_CUSTOMER_TRX.drawee_id%TYPE;
2637: l_drawee_site_use_id RA_CUSTOMER_TRX.drawee_site_use_id%TYPE;
2638: l_drawee_contact_id RA_CUSTOMER_TRX.drawee_contact_id%TYPE;
2639: l_drawee_bank_account_id RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE;

Line 2636: l_drawee_id RA_CUSTOMER_TRX.drawee_id%TYPE;

2632:
2633: l_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
2634: l_br_maturity_date RA_CUSTOMER_TRX.term_due_date%TYPE;
2635: l_cust_trx_type_id RA_CUSTOMER_TRX.cust_trx_type_id%TYPE;
2636: l_drawee_id RA_CUSTOMER_TRX.drawee_id%TYPE;
2637: l_drawee_site_use_id RA_CUSTOMER_TRX.drawee_site_use_id%TYPE;
2638: l_drawee_contact_id RA_CUSTOMER_TRX.drawee_contact_id%TYPE;
2639: l_drawee_bank_account_id RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE;
2640: l_created_from RA_CUSTOMER_TRX.created_from%TYPE;

Line 2637: l_drawee_site_use_id RA_CUSTOMER_TRX.drawee_site_use_id%TYPE;

2633: l_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
2634: l_br_maturity_date RA_CUSTOMER_TRX.term_due_date%TYPE;
2635: l_cust_trx_type_id RA_CUSTOMER_TRX.cust_trx_type_id%TYPE;
2636: l_drawee_id RA_CUSTOMER_TRX.drawee_id%TYPE;
2637: l_drawee_site_use_id RA_CUSTOMER_TRX.drawee_site_use_id%TYPE;
2638: l_drawee_contact_id RA_CUSTOMER_TRX.drawee_contact_id%TYPE;
2639: l_drawee_bank_account_id RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE;
2640: l_created_from RA_CUSTOMER_TRX.created_from%TYPE;
2641:

Line 2638: l_drawee_contact_id RA_CUSTOMER_TRX.drawee_contact_id%TYPE;

2634: l_br_maturity_date RA_CUSTOMER_TRX.term_due_date%TYPE;
2635: l_cust_trx_type_id RA_CUSTOMER_TRX.cust_trx_type_id%TYPE;
2636: l_drawee_id RA_CUSTOMER_TRX.drawee_id%TYPE;
2637: l_drawee_site_use_id RA_CUSTOMER_TRX.drawee_site_use_id%TYPE;
2638: l_drawee_contact_id RA_CUSTOMER_TRX.drawee_contact_id%TYPE;
2639: l_drawee_bank_account_id RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE;
2640: l_created_from RA_CUSTOMER_TRX.created_from%TYPE;
2641:
2642: -- Bug 1808976

Line 2639: l_drawee_bank_account_id RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE;

2635: l_cust_trx_type_id RA_CUSTOMER_TRX.cust_trx_type_id%TYPE;
2636: l_drawee_id RA_CUSTOMER_TRX.drawee_id%TYPE;
2637: l_drawee_site_use_id RA_CUSTOMER_TRX.drawee_site_use_id%TYPE;
2638: l_drawee_contact_id RA_CUSTOMER_TRX.drawee_contact_id%TYPE;
2639: l_drawee_bank_account_id RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE;
2640: l_created_from RA_CUSTOMER_TRX.created_from%TYPE;
2641:
2642: -- Bug 1808976
2643: l_site_id RA_CUSTOMER_TRX.bill_to_site_use_id%TYPE;

Line 2640: l_created_from RA_CUSTOMER_TRX.created_from%TYPE;

2636: l_drawee_id RA_CUSTOMER_TRX.drawee_id%TYPE;
2637: l_drawee_site_use_id RA_CUSTOMER_TRX.drawee_site_use_id%TYPE;
2638: l_drawee_contact_id RA_CUSTOMER_TRX.drawee_contact_id%TYPE;
2639: l_drawee_bank_account_id RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE;
2640: l_created_from RA_CUSTOMER_TRX.created_from%TYPE;
2641:
2642: -- Bug 1808976
2643: l_site_id RA_CUSTOMER_TRX.bill_to_site_use_id%TYPE;
2644: l_bill_to_site_id RA_CUSTOMER_TRX.bill_to_site_use_id%TYPE;

Line 2643: l_site_id RA_CUSTOMER_TRX.bill_to_site_use_id%TYPE;

2639: l_drawee_bank_account_id RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE;
2640: l_created_from RA_CUSTOMER_TRX.created_from%TYPE;
2641:
2642: -- Bug 1808976
2643: l_site_id RA_CUSTOMER_TRX.bill_to_site_use_id%TYPE;
2644: l_bill_to_site_id RA_CUSTOMER_TRX.bill_to_site_use_id%TYPE;
2645:
2646:
2647: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE;

Line 2644: l_bill_to_site_id RA_CUSTOMER_TRX.bill_to_site_use_id%TYPE;

2640: l_created_from RA_CUSTOMER_TRX.created_from%TYPE;
2641:
2642: -- Bug 1808976
2643: l_site_id RA_CUSTOMER_TRX.bill_to_site_use_id%TYPE;
2644: l_bill_to_site_id RA_CUSTOMER_TRX.bill_to_site_use_id%TYPE;
2645:
2646:
2647: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE;
2648:

Line 2647: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE;

2643: l_site_id RA_CUSTOMER_TRX.bill_to_site_use_id%TYPE;
2644: l_bill_to_site_id RA_CUSTOMER_TRX.bill_to_site_use_id%TYPE;
2645:
2646:
2647: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE;
2648:
2649: l_bill_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
2650: l_bill_number RA_CUSTOMER_TRX.trx_number%TYPE;
2651: l_bill_status AR_TRANSACTION_HISTORY.status%TYPE;

Line 2649: l_bill_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;

2645:
2646:
2647: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE;
2648:
2649: l_bill_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
2650: l_bill_number RA_CUSTOMER_TRX.trx_number%TYPE;
2651: l_bill_status AR_TRANSACTION_HISTORY.status%TYPE;
2652: l_request_id NUMBER;
2653:

Line 2650: l_bill_number RA_CUSTOMER_TRX.trx_number%TYPE;

2646:
2647: l_customer_trx_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE;
2648:
2649: l_bill_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
2650: l_bill_number RA_CUSTOMER_TRX.trx_number%TYPE;
2651: l_bill_status AR_TRANSACTION_HISTORY.status%TYPE;
2652: l_request_id NUMBER;
2653:
2654: l_batch_process_status RA_BATCHES.batch_process_status%TYPE;

Line 2701: l_trx_number RA_CUSTOMER_TRX.TRX_NUMBER%TYPE;

2697: l_bill_to_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
2698:
2699: -- Bug 1708420 : define variable to hold BR_INHERIT_INV_NUM_FLAG value
2700: l_br_inherit_inv_num_flag AR_RECEIPT_METHODS.BR_INHERIT_INV_NUM_FLAG%TYPE;
2701: l_trx_number RA_CUSTOMER_TRX.TRX_NUMBER%TYPE;
2702: l_count_trxid NUMBER;
2703: l_count_ps NUMBER;
2704: l_cust_trx_id RA_CUSTOMER_TRX.CUSTOMER_TRX_ID%TYPE;
2705:

Line 2704: l_cust_trx_id RA_CUSTOMER_TRX.CUSTOMER_TRX_ID%TYPE;

2700: l_br_inherit_inv_num_flag AR_RECEIPT_METHODS.BR_INHERIT_INV_NUM_FLAG%TYPE;
2701: l_trx_number RA_CUSTOMER_TRX.TRX_NUMBER%TYPE;
2702: l_count_trxid NUMBER;
2703: l_count_ps NUMBER;
2704: l_cust_trx_id RA_CUSTOMER_TRX.CUSTOMER_TRX_ID%TYPE;
2705:
2706: -- Bug2290332: Check for Automatic Transaction Numbering
2707: CURSOR bs_details(p_batch_source_id IN number) is
2708: SELECT auto_trx_numbering_flag, name

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

3553: l_bill_status);
3554: end if;
3555:
3556:
3557: select org_id into jnk1 from ra_customer_trx where customer_trx_id = l_bill_id;
3558: select org_id into jnk2 from ar_transaction_history where customer_trx_id = l_bill_id;
3559:
3560: program_debug(p_call,'done with AR_BILLS_CREATION_PUB.Create_BR_Header org_id = ' || to_char(jnk1) || 'org_id = ' ||
3561: to_char(jnk2));

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

3637: NULL, -- p_attribute15
3638: l_org_id, -- p_org_id
3639: l_customer_trx_line_id);
3640:
3641: select org_id into jnk1 from ra_customer_trx_lines where customer_trx_line_id = l_customer_trx_line_id;
3642: program_debug(p_call,'done with AR_BILLS_CREATION_PUB.Create_BR_Assignment for NIMM, org_id = '
3643: || to_char(jnk1));
3644:
3645: EXCEPTION /* Bug 3472744 Enclosed the following check in Exception block */

Line 3842: ra_customer_trx trx

3838:
3839: SELECT NVL(default_printing_option,'NOT')
3840: into l_default_printing_option
3841: FROM ra_cust_trx_types type,
3842: ra_customer_trx trx
3843: WHERE trx.customer_trx_id = l_bill_id
3844: AND trx.cust_trx_type_id = type.cust_trx_type_id;
3845:
3846: l_request_id := NULL;

Line 4022: p_request_id IN RA_CUSTOMER_TRX.request_id%TYPE,

4018: | MODIFICATION HISTORY - Created by Attila Rimai - 13/07/2000 |
4019: | |
4020: +===========================================================================*/
4021: PROCEDURE ar_br_insert_into_report_table(
4022: p_request_id IN RA_CUSTOMER_TRX.request_id%TYPE,
4023: p_batch_id IN RA_BATCHES.batch_id%TYPE,
4024: p_br_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
4025: p_bill_number IN RA_CUSTOMER_TRX.trx_number%TYPE,
4026: p_br_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,

Line 4024: p_br_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,

4020: +===========================================================================*/
4021: PROCEDURE ar_br_insert_into_report_table(
4022: p_request_id IN RA_CUSTOMER_TRX.request_id%TYPE,
4023: p_batch_id IN RA_BATCHES.batch_id%TYPE,
4024: p_br_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
4025: p_bill_number IN RA_CUSTOMER_TRX.trx_number%TYPE,
4026: p_br_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
4027: p_br_currency IN RA_BATCHES.currency_code%TYPE,
4028: p_batch_status IN RA_BATCHES.status%TYPE,

Line 4025: p_bill_number IN RA_CUSTOMER_TRX.trx_number%TYPE,

4021: PROCEDURE ar_br_insert_into_report_table(
4022: p_request_id IN RA_CUSTOMER_TRX.request_id%TYPE,
4023: p_batch_id IN RA_BATCHES.batch_id%TYPE,
4024: p_br_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
4025: p_bill_number IN RA_CUSTOMER_TRX.trx_number%TYPE,
4026: p_br_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
4027: p_br_currency IN RA_BATCHES.currency_code%TYPE,
4028: p_batch_status IN RA_BATCHES.status%TYPE,
4029: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,

Line 4030: p_drawee_id IN RA_CUSTOMER_TRX.drawee_id%TYPE,

4026: p_br_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
4027: p_br_currency IN RA_BATCHES.currency_code%TYPE,
4028: p_batch_status IN RA_BATCHES.status%TYPE,
4029: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
4030: p_drawee_id IN RA_CUSTOMER_TRX.drawee_id%TYPE,
4031: p_drawee_contact_id IN RA_CUSTOMER_TRX.drawee_contact_id%TYPE,
4032: p_drawee_site_use_id IN RA_CUSTOMER_TRX.drawee_site_use_id%TYPE,
4033: p_drawee_bank_account_id IN RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE,
4034: p_transaction_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,

Line 4031: p_drawee_contact_id IN RA_CUSTOMER_TRX.drawee_contact_id%TYPE,

4027: p_br_currency IN RA_BATCHES.currency_code%TYPE,
4028: p_batch_status IN RA_BATCHES.status%TYPE,
4029: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
4030: p_drawee_id IN RA_CUSTOMER_TRX.drawee_id%TYPE,
4031: p_drawee_contact_id IN RA_CUSTOMER_TRX.drawee_contact_id%TYPE,
4032: p_drawee_site_use_id IN RA_CUSTOMER_TRX.drawee_site_use_id%TYPE,
4033: p_drawee_bank_account_id IN RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE,
4034: p_transaction_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
4035: p_amount_assigned IN RA_CUSTOMER_TRX.br_amount%TYPE,

Line 4032: p_drawee_site_use_id IN RA_CUSTOMER_TRX.drawee_site_use_id%TYPE,

4028: p_batch_status IN RA_BATCHES.status%TYPE,
4029: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
4030: p_drawee_id IN RA_CUSTOMER_TRX.drawee_id%TYPE,
4031: p_drawee_contact_id IN RA_CUSTOMER_TRX.drawee_contact_id%TYPE,
4032: p_drawee_site_use_id IN RA_CUSTOMER_TRX.drawee_site_use_id%TYPE,
4033: p_drawee_bank_account_id IN RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE,
4034: p_transaction_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
4035: p_amount_assigned IN RA_CUSTOMER_TRX.br_amount%TYPE,
4036: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE) IS

Line 4033: p_drawee_bank_account_id IN RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE,

4029: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
4030: p_drawee_id IN RA_CUSTOMER_TRX.drawee_id%TYPE,
4031: p_drawee_contact_id IN RA_CUSTOMER_TRX.drawee_contact_id%TYPE,
4032: p_drawee_site_use_id IN RA_CUSTOMER_TRX.drawee_site_use_id%TYPE,
4033: p_drawee_bank_account_id IN RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE,
4034: p_transaction_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
4035: p_amount_assigned IN RA_CUSTOMER_TRX.br_amount%TYPE,
4036: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE) IS
4037:

Line 4034: p_transaction_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,

4030: p_drawee_id IN RA_CUSTOMER_TRX.drawee_id%TYPE,
4031: p_drawee_contact_id IN RA_CUSTOMER_TRX.drawee_contact_id%TYPE,
4032: p_drawee_site_use_id IN RA_CUSTOMER_TRX.drawee_site_use_id%TYPE,
4033: p_drawee_bank_account_id IN RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE,
4034: p_transaction_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
4035: p_amount_assigned IN RA_CUSTOMER_TRX.br_amount%TYPE,
4036: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE) IS
4037:
4038: -- Bug 1420183

Line 4035: p_amount_assigned IN RA_CUSTOMER_TRX.br_amount%TYPE,

4031: p_drawee_contact_id IN RA_CUSTOMER_TRX.drawee_contact_id%TYPE,
4032: p_drawee_site_use_id IN RA_CUSTOMER_TRX.drawee_site_use_id%TYPE,
4033: p_drawee_bank_account_id IN RA_CUSTOMER_TRX.drawee_bank_account_id%TYPE,
4034: p_transaction_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
4035: p_amount_assigned IN RA_CUSTOMER_TRX.br_amount%TYPE,
4036: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE) IS
4037:
4038: -- Bug 1420183
4039: -- Could pass creation rule code, min/max amounts into this procedure as parameters, but since

Line 4694: p_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,

4690: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4691: x_return_status OUT NOCOPY VARCHAR2,
4692: x_msg_count OUT NOCOPY NUMBER,
4693: x_msg_data OUT NOCOPY VARCHAR2,
4694: p_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
4695: p_bill_id OUT NOCOPY RA_CUSTOMER_TRX.customer_trx_id%TYPE,
4696: p_request_id OUT NOCOPY NUMBER,
4697: p_nb_bill OUT NOCOPY NUMBER) IS
4698:

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

4691: x_return_status OUT NOCOPY VARCHAR2,
4692: x_msg_count OUT NOCOPY NUMBER,
4693: x_msg_data OUT NOCOPY VARCHAR2,
4694: p_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
4695: p_bill_id OUT NOCOPY RA_CUSTOMER_TRX.customer_trx_id%TYPE,
4696: p_request_id OUT NOCOPY NUMBER,
4697: p_nb_bill OUT NOCOPY NUMBER) IS
4698:
4699: l_api_name CONSTANT varchar2(30) := 'auto_create_br_API';

Line 4716: ra_customer_trx trx

4712: -- trx.customer_bank_account_id, Bug 5051673
4713: trx.payment_trxn_extension_id,
4714: trx.legal_entity_id
4715: FROM ar_receipt_methods pm,
4716: ra_customer_trx trx
4717: WHERE trx.customer_trx_id = p_customer_trx_id
4718: AND trx.receipt_method_id = pm.receipt_method_id;
4719:
4720: c_grouping cur_typ;

Line 4736: l_invoice_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;

4732: l_lead_days AR_RECEIPT_METHODS.lead_days%TYPE;
4733: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;
4734: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
4735: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
4736: l_invoice_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;
4737: l_le_id RA_CUSTOMER_TRX.legal_entity_id%TYPE;
4738:
4739: -- bug 1808976 :
4740: l_customer_bank_account_id RA_CUSTOMER_TRX.customer_bank_account_id%TYPE;

Line 4737: l_le_id RA_CUSTOMER_TRX.legal_entity_id%TYPE;

4733: l_maturity_date_rule_code AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE;
4734: l_br_min_acctd_amount AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE;
4735: l_br_max_acctd_amount AR_RECEIPT_METHODS.br_max_acctd_amount%TYPE;
4736: l_invoice_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;
4737: l_le_id RA_CUSTOMER_TRX.legal_entity_id%TYPE;
4738:
4739: -- bug 1808976 :
4740: l_customer_bank_account_id RA_CUSTOMER_TRX.customer_bank_account_id%TYPE;
4741:

Line 4740: l_customer_bank_account_id RA_CUSTOMER_TRX.customer_bank_account_id%TYPE;

4736: l_invoice_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;
4737: l_le_id RA_CUSTOMER_TRX.legal_entity_id%TYPE;
4738:
4739: -- bug 1808976 :
4740: l_customer_bank_account_id RA_CUSTOMER_TRX.customer_bank_account_id%TYPE;
4741:
4742: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;
4743: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
4744: l_cust_trx_type_id AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE;

Line 4753: l_bill_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;

4749: l_trx_number AR_PAYMENT_SCHEDULES.trx_number%TYPE;
4750: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
4751: l_amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
4752:
4753: l_bill_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
4754: l_request_id NUMBER;
4755:
4756: BEGIN
4757:

Line 4824: ' ra_customer_trx trx,'||

4820: */
4821:
4822: l_suffixe_select_statement := ' FROM ar_payment_schedules ps,'||
4823: ' ra_cust_trx_types type,'||
4824: ' ra_customer_trx trx,'||
4825: ' ar_receipt_methods pm '||
4826: 'WHERE ps.cust_trx_type_id = type.cust_trx_type_id '||
4827: 'AND (type.type IN (''INV'',''DEP'',''CB'') OR '||
4828: ' (type.type IN (''CM'',''DM'') AND ps.term_id <> 5)) '||

Line 4833: 'ra_customer_trx_lines br_lines, '||

4829: 'AND ps.customer_trx_id = NVL(:p_customer_trx_id,ps.customer_trx_id) '||
4830: 'AND ps.payment_schedule_id NOT IN '||
4831: '(SELECT br_ref_payment_schedule_id '||
4832: ' from '||
4833: 'ra_customer_trx_lines br_lines, '||
4834: 'ar_transaction_history th '||
4835: 'where br_lines.br_ref_payment_schedule_id = ps.payment_schedule_id '||
4836: 'and br_lines.customer_trx_id = th.customer_trx_id '||
4837: 'and th.current_record_flag = ''Y'' '||