eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_PROGRAM_GENERATE_BR dependencies on RA_BATCHES

Line 8: p_batch_id IN RA_BATCHES.batch_id%TYPE,

4: --------- Private Procedures
5: PROCEDURE from_automatic_batch_window(
6: p_draft_mode IN VARCHAR2,
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,

Line 26: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE,

22:
23:
24: PROCEDURE from_conc_request_window(
25: p_print_flag IN varchar2,
26: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE,
27: p_batch_date IN RA_BATCHES.batch_date%TYPE,
28: p_gl_date IN VARCHAR2,
29: p_issue_date IN VARCHAR2,
30: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,

Line 27: p_batch_date IN RA_BATCHES.batch_date%TYPE,

23:
24: PROCEDURE from_conc_request_window(
25: p_print_flag IN varchar2,
26: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE,
27: p_batch_date IN RA_BATCHES.batch_date%TYPE,
28: p_gl_date IN VARCHAR2,
29: p_issue_date IN VARCHAR2,
30: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
31: p_currency_code IN RA_BATCHES.currency_code%TYPE,

Line 30: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,

26: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE,
27: p_batch_date IN RA_BATCHES.batch_date%TYPE,
28: p_gl_date IN VARCHAR2,
29: p_issue_date IN VARCHAR2,
30: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
31: p_currency_code IN RA_BATCHES.currency_code%TYPE,
32: p_comments IN RA_BATCHES.comments%TYPE,
33: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,
34: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,

Line 31: p_currency_code IN RA_BATCHES.currency_code%TYPE,

27: p_batch_date IN RA_BATCHES.batch_date%TYPE,
28: p_gl_date IN VARCHAR2,
29: p_issue_date IN VARCHAR2,
30: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
31: p_currency_code IN RA_BATCHES.currency_code%TYPE,
32: p_comments IN RA_BATCHES.comments%TYPE,
33: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,
34: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,
35: p_attribute1 IN VARCHAR2,

Line 32: p_comments IN RA_BATCHES.comments%TYPE,

28: p_gl_date IN VARCHAR2,
29: p_issue_date IN VARCHAR2,
30: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
31: p_currency_code IN RA_BATCHES.currency_code%TYPE,
32: p_comments IN RA_BATCHES.comments%TYPE,
33: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,
34: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,
35: p_attribute1 IN VARCHAR2,
36: p_attribute2 IN VARCHAR2,

Line 33: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,

29: p_issue_date IN VARCHAR2,
30: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
31: p_currency_code IN RA_BATCHES.currency_code%TYPE,
32: p_comments IN RA_BATCHES.comments%TYPE,
33: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,
34: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,
35: p_attribute1 IN VARCHAR2,
36: p_attribute2 IN VARCHAR2,
37: p_attribute3 IN VARCHAR2,

Line 34: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,

30: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
31: p_currency_code IN RA_BATCHES.currency_code%TYPE,
32: p_comments IN RA_BATCHES.comments%TYPE,
33: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,
34: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,
35: p_attribute1 IN VARCHAR2,
36: p_attribute2 IN VARCHAR2,
37: p_attribute3 IN VARCHAR2,
38: p_attribute4 IN VARCHAR2,

Line 71: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE,

67: PROCEDURE drop_tmp_table;
68:
69:
70: PROCEDURE create_batch_header (
71: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE,
72: p_batch_date IN RA_BATCHES.batch_date%TYPE,
73: p_gl_date IN VARCHAR2, -- currently not used
74: p_issue_date IN VARCHAR2, -- currently not used
75: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,

Line 72: p_batch_date IN RA_BATCHES.batch_date%TYPE,

68:
69:
70: PROCEDURE create_batch_header (
71: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE,
72: p_batch_date IN RA_BATCHES.batch_date%TYPE,
73: p_gl_date IN VARCHAR2, -- currently not used
74: p_issue_date IN VARCHAR2, -- currently not used
75: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
76: p_currency_code IN RA_BATCHES.currency_code%TYPE,

Line 75: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,

71: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE,
72: p_batch_date IN RA_BATCHES.batch_date%TYPE,
73: p_gl_date IN VARCHAR2, -- currently not used
74: p_issue_date IN VARCHAR2, -- currently not used
75: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
76: p_currency_code IN RA_BATCHES.currency_code%TYPE,
77: p_comments IN RA_BATCHES.comments%TYPE,
78: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,
79: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,

Line 76: p_currency_code IN RA_BATCHES.currency_code%TYPE,

72: p_batch_date IN RA_BATCHES.batch_date%TYPE,
73: p_gl_date IN VARCHAR2, -- currently not used
74: p_issue_date IN VARCHAR2, -- currently not used
75: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
76: p_currency_code IN RA_BATCHES.currency_code%TYPE,
77: p_comments IN RA_BATCHES.comments%TYPE,
78: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,
79: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,
80: p_attribute1 IN VARCHAR2,

Line 77: p_comments IN RA_BATCHES.comments%TYPE,

73: p_gl_date IN VARCHAR2, -- currently not used
74: p_issue_date IN VARCHAR2, -- currently not used
75: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
76: p_currency_code IN RA_BATCHES.currency_code%TYPE,
77: p_comments IN RA_BATCHES.comments%TYPE,
78: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,
79: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,
80: p_attribute1 IN VARCHAR2,
81: p_attribute2 IN VARCHAR2,

Line 78: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,

74: p_issue_date IN VARCHAR2, -- currently not used
75: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
76: p_currency_code IN RA_BATCHES.currency_code%TYPE,
77: p_comments IN RA_BATCHES.comments%TYPE,
78: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,
79: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,
80: p_attribute1 IN VARCHAR2,
81: p_attribute2 IN VARCHAR2,
82: p_attribute3 IN VARCHAR2,

Line 79: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,

75: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
76: p_currency_code IN RA_BATCHES.currency_code%TYPE,
77: p_comments IN RA_BATCHES.comments%TYPE,
78: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,
79: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,
80: p_attribute1 IN VARCHAR2,
81: p_attribute2 IN VARCHAR2,
82: p_attribute3 IN VARCHAR2,
83: p_attribute4 IN VARCHAR2,

Line 108: p_batch_id OUT NOCOPY RA_BATCHES.batch_id%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,
108: p_batch_id OUT NOCOPY RA_BATCHES.batch_id%TYPE,
109: p_selection_criteria_id OUT NOCOPY RA_BATCHES.selection_criteria_id%TYPE);
110:
111:
112: PROCEDURE update_batch_status(

Line 109: p_selection_criteria_id OUT NOCOPY RA_BATCHES.selection_criteria_id%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,
108: p_batch_id OUT NOCOPY RA_BATCHES.batch_id%TYPE,
109: p_selection_criteria_id OUT NOCOPY RA_BATCHES.selection_criteria_id%TYPE);
110:
111:
112: PROCEDURE update_batch_status(
113: p_draft_mode IN VARCHAR2,

Line 114: p_batch_id IN RA_BATCHES.batch_id%TYPE);

110:
111:
112: PROCEDURE update_batch_status(
113: p_draft_mode IN VARCHAR2,
114: p_batch_id IN RA_BATCHES.batch_id%TYPE);
115:
116:
117: PROCEDURE select_trx_and_create_BR(
118: p_draft_mode IN VARCHAR2,

Line 120: p_batch_id IN RA_BATCHES.batch_id%TYPE,

116:
117: PROCEDURE select_trx_and_create_BR(
118: p_draft_mode IN VARCHAR2,
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,

Line 174: p_batch_id IN RA_BATCHES.batch_id%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,
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);

Line 196: p_batch_id IN RA_BATCHES.batch_id%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,
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,

Line 207: p_batch_id IN RA_BATCHES.batch_id%TYPE,

203:
204: PROCEDURE create_BR(
205: p_draft_mode IN VARCHAR2,
206: p_call IN NUMBER,
207: p_batch_id IN RA_BATCHES.batch_id%TYPE,
208: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
209: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
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,

Line 213: p_currency_code IN RA_BATCHES.currency_code%TYPE,

209: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
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);

Line 223: p_batch_id IN RA_BATCHES.batch_id%TYPE,

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,
227: p_br_currency IN RA_BATCHES.currency_code%TYPE,

Line 227: p_br_currency IN RA_BATCHES.currency_code%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,
230: p_drawee_id IN RA_CUSTOMER_TRX.drawee_id%TYPE,
231: p_drawee_contact_id IN RA_CUSTOMER_TRX.drawee_contact_id%TYPE,

Line 228: p_batch_status IN RA_BATCHES.status%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,
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,

Line 229: p_maturity_date IN RA_BATCHES.maturity_date%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,
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,

Line 239: p_batch_id IN RA_BATCHES.batch_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);
240:
241:
242: PROCEDURE print_BR_pvt(
243: p_object_id IN RA_BATCHES.batch_id%TYPE,

Line 243: p_object_id IN RA_BATCHES.batch_id%TYPE,

239: p_batch_id IN RA_BATCHES.batch_id%TYPE);
240:
241:
242: PROCEDURE print_BR_pvt(
243: p_object_id IN RA_BATCHES.batch_id%TYPE,
244: p_call IN NUMBER,
245: p_request_id OUT NOCOPY NUMBER);
246:
247:

Line 355: p_batch_id IN RA_BATCHES.batch_id%TYPE DEFAULT NULL,

351: retcode OUT NOCOPY VARCHAR2,
352: p_call IN NUMBER,
353: p_draft_mode IN VARCHAR2,
354: p_print_flag IN VARCHAR2,
355: p_batch_id IN RA_BATCHES.batch_id%TYPE DEFAULT NULL,
356: p_batch_source_id IN RA_BATCH_SOURCES.batch_source_id%TYPE,
357: p_batch_date IN VARCHAR2,
358: p_gl_date IN VARCHAR2 DEFAULT NULL,
359: p_issue_date IN VARCHAR2 DEFAULT NULL,

Line 361: p_currency_code IN RA_BATCHES.currency_code%TYPE DEFAULT NULL,

357: p_batch_date IN VARCHAR2,
358: p_gl_date IN VARCHAR2 DEFAULT NULL,
359: p_issue_date IN VARCHAR2 DEFAULT NULL,
360: p_maturity_date IN VARCHAR2 DEFAULT NULL,
361: p_currency_code IN RA_BATCHES.currency_code%TYPE DEFAULT NULL,
362: p_comments IN RA_BATCHES.comments%TYPE DEFAULT NULL,
363: p_special_instructions IN RA_BATCHES.special_instructions%TYPE DEFAULT NULL,
364: p_attribute_category IN RA_BATCHES.attribute_category%TYPE DEFAULT NULL,
365: p_attribute1 IN VARCHAR2 DEFAULT NULL,

Line 362: p_comments IN RA_BATCHES.comments%TYPE DEFAULT NULL,

358: p_gl_date IN VARCHAR2 DEFAULT NULL,
359: p_issue_date IN VARCHAR2 DEFAULT NULL,
360: p_maturity_date IN VARCHAR2 DEFAULT NULL,
361: p_currency_code IN RA_BATCHES.currency_code%TYPE DEFAULT NULL,
362: p_comments IN RA_BATCHES.comments%TYPE DEFAULT NULL,
363: p_special_instructions IN RA_BATCHES.special_instructions%TYPE DEFAULT NULL,
364: p_attribute_category IN RA_BATCHES.attribute_category%TYPE DEFAULT NULL,
365: p_attribute1 IN VARCHAR2 DEFAULT NULL,
366: p_attribute2 IN VARCHAR2 DEFAULT NULL,

Line 363: p_special_instructions IN RA_BATCHES.special_instructions%TYPE DEFAULT NULL,

359: p_issue_date IN VARCHAR2 DEFAULT NULL,
360: p_maturity_date IN VARCHAR2 DEFAULT NULL,
361: p_currency_code IN RA_BATCHES.currency_code%TYPE DEFAULT NULL,
362: p_comments IN RA_BATCHES.comments%TYPE DEFAULT NULL,
363: p_special_instructions IN RA_BATCHES.special_instructions%TYPE DEFAULT NULL,
364: p_attribute_category IN RA_BATCHES.attribute_category%TYPE DEFAULT NULL,
365: p_attribute1 IN VARCHAR2 DEFAULT NULL,
366: p_attribute2 IN VARCHAR2 DEFAULT NULL,
367: p_attribute3 IN VARCHAR2 DEFAULT NULL,

Line 364: p_attribute_category IN RA_BATCHES.attribute_category%TYPE DEFAULT NULL,

360: p_maturity_date IN VARCHAR2 DEFAULT NULL,
361: p_currency_code IN RA_BATCHES.currency_code%TYPE DEFAULT NULL,
362: p_comments IN RA_BATCHES.comments%TYPE DEFAULT NULL,
363: p_special_instructions IN RA_BATCHES.special_instructions%TYPE DEFAULT NULL,
364: p_attribute_category IN RA_BATCHES.attribute_category%TYPE DEFAULT NULL,
365: p_attribute1 IN VARCHAR2 DEFAULT NULL,
366: p_attribute2 IN VARCHAR2 DEFAULT NULL,
367: p_attribute3 IN VARCHAR2 DEFAULT NULL,
368: p_attribute4 IN VARCHAR2 DEFAULT NULL,

Line 404: l_batch_id RA_BATCHES.batch_id%TYPE;

400: l_due_date_high DATE := NULL;
401: l_trx_date_low DATE := NULL;
402: l_trx_date_high DATE := NULL;
403:
404: l_batch_id RA_BATCHES.batch_id%TYPE;
405:
406: BEGIN
407:
408: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.auto_create_br_program (+)');

Line 593: p_batch_id IN RA_BATCHES.batch_id%TYPE,

589: +===========================================================================*/
590: PROCEDURE from_automatic_batch_window(
591: p_draft_mode IN VARCHAR2,
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,

Line 688: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE,

684: | |
685: +===========================================================================*/
686: PROCEDURE from_conc_request_window(
687: p_print_flag IN varchar2,
688: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE,
689: p_batch_date IN RA_BATCHES.batch_date%TYPE,
690: p_gl_date IN VARCHAR2,
691: p_issue_date IN VARCHAR2,
692: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,

Line 689: p_batch_date IN RA_BATCHES.batch_date%TYPE,

685: +===========================================================================*/
686: PROCEDURE from_conc_request_window(
687: p_print_flag IN varchar2,
688: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE,
689: p_batch_date IN RA_BATCHES.batch_date%TYPE,
690: p_gl_date IN VARCHAR2,
691: p_issue_date IN VARCHAR2,
692: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
693: p_currency_code IN RA_BATCHES.currency_code%TYPE,

Line 692: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,

688: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE,
689: p_batch_date IN RA_BATCHES.batch_date%TYPE,
690: p_gl_date IN VARCHAR2,
691: p_issue_date IN VARCHAR2,
692: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
693: p_currency_code IN RA_BATCHES.currency_code%TYPE,
694: p_comments IN RA_BATCHES.comments%TYPE,
695: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,
696: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,

Line 693: p_currency_code IN RA_BATCHES.currency_code%TYPE,

689: p_batch_date IN RA_BATCHES.batch_date%TYPE,
690: p_gl_date IN VARCHAR2,
691: p_issue_date IN VARCHAR2,
692: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
693: p_currency_code IN RA_BATCHES.currency_code%TYPE,
694: p_comments IN RA_BATCHES.comments%TYPE,
695: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,
696: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,
697: p_attribute1 IN VARCHAR2,

Line 694: p_comments IN RA_BATCHES.comments%TYPE,

690: p_gl_date IN VARCHAR2,
691: p_issue_date IN VARCHAR2,
692: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
693: p_currency_code IN RA_BATCHES.currency_code%TYPE,
694: p_comments IN RA_BATCHES.comments%TYPE,
695: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,
696: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,
697: p_attribute1 IN VARCHAR2,
698: p_attribute2 IN VARCHAR2,

Line 695: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,

691: p_issue_date IN VARCHAR2,
692: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
693: p_currency_code IN RA_BATCHES.currency_code%TYPE,
694: p_comments IN RA_BATCHES.comments%TYPE,
695: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,
696: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,
697: p_attribute1 IN VARCHAR2,
698: p_attribute2 IN VARCHAR2,
699: p_attribute3 IN VARCHAR2,

Line 696: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,

692: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
693: p_currency_code IN RA_BATCHES.currency_code%TYPE,
694: p_comments IN RA_BATCHES.comments%TYPE,
695: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,
696: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,
697: p_attribute1 IN VARCHAR2,
698: p_attribute2 IN VARCHAR2,
699: p_attribute3 IN VARCHAR2,
700: p_attribute4 IN VARCHAR2,

Line 726: l_batch_id RA_BATCHES.batch_id%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
725:
726: l_batch_id RA_BATCHES.batch_id%TYPE;
727: l_selection_criteria_id RA_BATCHES.selection_criteria_id%TYPE;
728:
729: l_request_id NUMBER;
730:

Line 727: l_selection_criteria_id RA_BATCHES.selection_criteria_id%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
725:
726: l_batch_id RA_BATCHES.batch_id%TYPE;
727: l_selection_criteria_id RA_BATCHES.selection_criteria_id%TYPE;
728:
729: l_request_id NUMBER;
730:
731: BEGIN

Line 738: -- Insert the batch header in RA_BATCHES and the criteria in AR_SELECTION_CRITERIA

734:
735: -- Temporary table Creation
736: ARP_PROGRAM_GENERATE_BR.arbr_cr_tmp_table;
737:
738: -- Insert the batch header in RA_BATCHES and the criteria in AR_SELECTION_CRITERIA
739: ARP_PROGRAM_GENERATE_BR.create_batch_header(
740: p_batch_source_id,
741: p_batch_date,
742: p_gl_date,

Line 853: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE,

849: | MODIFICATION HISTORY - Created by Mireille Flahaut - 26/07/2000 |
850: | |
851: +===========================================================================*/
852: PROCEDURE create_batch_header (
853: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE,
854: p_batch_date IN RA_BATCHES.batch_date%TYPE,
855: p_gl_date IN VARCHAR2, -- currently not used
856: p_issue_date IN VARCHAR2, -- currently not used
857: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,

Line 854: p_batch_date IN RA_BATCHES.batch_date%TYPE,

850: | |
851: +===========================================================================*/
852: PROCEDURE create_batch_header (
853: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE,
854: p_batch_date IN RA_BATCHES.batch_date%TYPE,
855: p_gl_date IN VARCHAR2, -- currently not used
856: p_issue_date IN VARCHAR2, -- currently not used
857: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
858: p_currency_code IN RA_BATCHES.currency_code%TYPE,

Line 857: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,

853: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE,
854: p_batch_date IN RA_BATCHES.batch_date%TYPE,
855: p_gl_date IN VARCHAR2, -- currently not used
856: p_issue_date IN VARCHAR2, -- currently not used
857: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
858: p_currency_code IN RA_BATCHES.currency_code%TYPE,
859: p_comments IN RA_BATCHES.comments%TYPE,
860: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,
861: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,

Line 858: p_currency_code IN RA_BATCHES.currency_code%TYPE,

854: p_batch_date IN RA_BATCHES.batch_date%TYPE,
855: p_gl_date IN VARCHAR2, -- currently not used
856: p_issue_date IN VARCHAR2, -- currently not used
857: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
858: p_currency_code IN RA_BATCHES.currency_code%TYPE,
859: p_comments IN RA_BATCHES.comments%TYPE,
860: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,
861: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,
862: p_attribute1 IN VARCHAR2,

Line 859: p_comments IN RA_BATCHES.comments%TYPE,

855: p_gl_date IN VARCHAR2, -- currently not used
856: p_issue_date IN VARCHAR2, -- currently not used
857: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
858: p_currency_code IN RA_BATCHES.currency_code%TYPE,
859: p_comments IN RA_BATCHES.comments%TYPE,
860: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,
861: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,
862: p_attribute1 IN VARCHAR2,
863: p_attribute2 IN VARCHAR2,

Line 860: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,

856: p_issue_date IN VARCHAR2, -- currently not used
857: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
858: p_currency_code IN RA_BATCHES.currency_code%TYPE,
859: p_comments IN RA_BATCHES.comments%TYPE,
860: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,
861: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,
862: p_attribute1 IN VARCHAR2,
863: p_attribute2 IN VARCHAR2,
864: p_attribute3 IN VARCHAR2,

Line 861: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,

857: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
858: p_currency_code IN RA_BATCHES.currency_code%TYPE,
859: p_comments IN RA_BATCHES.comments%TYPE,
860: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,
861: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,
862: p_attribute1 IN VARCHAR2,
863: p_attribute2 IN VARCHAR2,
864: p_attribute3 IN VARCHAR2,
865: p_attribute4 IN VARCHAR2,

Line 890: p_batch_id OUT NOCOPY RA_BATCHES.batch_id%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,
890: p_batch_id OUT NOCOPY RA_BATCHES.batch_id%TYPE,
891: p_selection_criteria_id OUT NOCOPY
892: RA_BATCHES.selection_criteria_id%TYPE) IS
893: l_issue_date RA_BATCHES.issue_date%TYPE;
894: l_gl_date RA_BATCHES.gl_date%TYPE;

Line 892: RA_BATCHES.selection_criteria_id%TYPE) IS

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,
890: p_batch_id OUT NOCOPY RA_BATCHES.batch_id%TYPE,
891: p_selection_criteria_id OUT NOCOPY
892: RA_BATCHES.selection_criteria_id%TYPE) IS
893: l_issue_date RA_BATCHES.issue_date%TYPE;
894: l_gl_date RA_BATCHES.gl_date%TYPE;
895: l_default_rule_used VARCHAR2(30);
896: l_error_message VARCHAR2(30);

Line 893: l_issue_date RA_BATCHES.issue_date%TYPE;

889: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
890: p_batch_id OUT NOCOPY RA_BATCHES.batch_id%TYPE,
891: p_selection_criteria_id OUT NOCOPY
892: RA_BATCHES.selection_criteria_id%TYPE) IS
893: l_issue_date RA_BATCHES.issue_date%TYPE;
894: l_gl_date RA_BATCHES.gl_date%TYPE;
895: l_default_rule_used VARCHAR2(30);
896: l_error_message VARCHAR2(30);
897:

Line 894: l_gl_date RA_BATCHES.gl_date%TYPE;

890: p_batch_id OUT NOCOPY RA_BATCHES.batch_id%TYPE,
891: p_selection_criteria_id OUT NOCOPY
892: RA_BATCHES.selection_criteria_id%TYPE) IS
893: l_issue_date RA_BATCHES.issue_date%TYPE;
894: l_gl_date RA_BATCHES.gl_date%TYPE;
895: l_default_rule_used VARCHAR2(30);
896: l_error_message VARCHAR2(30);
897:
898: l_batch_id RA_BATCHES.batch_id%TYPE;

Line 898: l_batch_id RA_BATCHES.batch_id%TYPE;

894: l_gl_date RA_BATCHES.gl_date%TYPE;
895: l_default_rule_used VARCHAR2(30);
896: l_error_message VARCHAR2(30);
897:
898: l_batch_id RA_BATCHES.batch_id%TYPE;
899: l_selection_criteria_id RA_BATCHES.batch_id%TYPE;
900: l_name RA_BATCHES.name%TYPE;
901:
902: BEGIN

Line 899: l_selection_criteria_id RA_BATCHES.batch_id%TYPE;

895: l_default_rule_used VARCHAR2(30);
896: l_error_message VARCHAR2(30);
897:
898: l_batch_id RA_BATCHES.batch_id%TYPE;
899: l_selection_criteria_id RA_BATCHES.batch_id%TYPE;
900: l_name RA_BATCHES.name%TYPE;
901:
902: BEGIN
903:

Line 900: l_name RA_BATCHES.name%TYPE;

896: l_error_message VARCHAR2(30);
897:
898: l_batch_id RA_BATCHES.batch_id%TYPE;
899: l_selection_criteria_id RA_BATCHES.batch_id%TYPE;
900: l_name RA_BATCHES.name%TYPE;
901:
902: BEGIN
903:
904: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.create_batch_header (+)');

Line 938: -- Insert the batch header in RA_BATCHES and the criteria in AR_SELECTION_CRITERIA

934: FND_MESSAGE.set_token('GENERIC_TEXT',l_error_message);
935: APP_EXCEPTION.raise_exception;
936: END IF;
937:
938: -- Insert the batch header in RA_BATCHES and the criteria in AR_SELECTION_CRITERIA
939: arp_process_br_batches.insert_batch('FNDRSRUN', -- p_form_name
940: NULL, -- p_form_version
941: p_batch_source_id, -- p_batch_source_id
942: p_batch_date, -- p_batch_date

Line 1024: p_batch_id IN RA_BATCHES.batch_id%TYPE) IS

1020: | |
1021: +===========================================================================*/
1022: PROCEDURE update_batch_status(
1023: p_draft_mode IN VARCHAR2,
1024: p_batch_id IN RA_BATCHES.batch_id%TYPE) IS
1025:
1026: l_batch_rec RA_BATCHES%ROWTYPE;
1027: l_criteria_rec AR_SELECTION_CRITERIA%ROWTYPE;
1028:

Line 1026: l_batch_rec RA_BATCHES%ROWTYPE;

1022: PROCEDURE update_batch_status(
1023: p_draft_mode IN VARCHAR2,
1024: p_batch_id IN RA_BATCHES.batch_id%TYPE) IS
1025:
1026: l_batch_rec RA_BATCHES%ROWTYPE;
1027: l_criteria_rec AR_SELECTION_CRITERIA%ROWTYPE;
1028:
1029: l_selection_criteria_id RA_BATCHES.selection_criteria_id%TYPE;
1030: l_status RA_BATCHES.batch_process_status%TYPE;

Line 1029: l_selection_criteria_id RA_BATCHES.selection_criteria_id%TYPE;

1025:
1026: l_batch_rec RA_BATCHES%ROWTYPE;
1027: l_criteria_rec AR_SELECTION_CRITERIA%ROWTYPE;
1028:
1029: l_selection_criteria_id RA_BATCHES.selection_criteria_id%TYPE;
1030: l_status RA_BATCHES.batch_process_status%TYPE;
1031:
1032:
1033: BEGIN

Line 1030: l_status RA_BATCHES.batch_process_status%TYPE;

1026: l_batch_rec RA_BATCHES%ROWTYPE;
1027: l_criteria_rec AR_SELECTION_CRITERIA%ROWTYPE;
1028:
1029: l_selection_criteria_id RA_BATCHES.selection_criteria_id%TYPE;
1030: l_status RA_BATCHES.batch_process_status%TYPE;
1031:
1032:
1033: BEGIN
1034:

Line 1149: p_batch_id IN RA_BATCHES.batch_id%TYPE,

1145: +===========================================================================*/
1146: PROCEDURE select_trx_and_create_BR(
1147: p_draft_mode IN VARCHAR2,
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,

Line 1179: FROM ra_batches batch,

1175: pm.maturity_date_rule_code,
1176: DECODE(pm.br_min_acctd_amount,NULL,0.00000001,0,0.00000001,pm.br_min_acctd_amount),
1177: NVL(pm.br_max_acctd_amount,9999999999999999999999999999999999),
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,

Line 1216: FROM ra_batches batch,

1212: /* bug 4109513 : get distinct bank accounts using receipt method */
1213: CURSOR c_rm_bank (rm_id IN NUMBER, cust_id IN NUMBER) IS
1214: -- SELECT distinct trx.customer_bank_account_id 5051673
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,

Line 1911: 'FROM ra_batches batch,

1907: */
1908: /* Bug 4928711 - Removed the references to ap_bank_accounts */
1909:
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,

Line 2121: p_batch_id IN RA_BATCHES.batch_id%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,
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

Line 2369: p_batch_id IN RA_BATCHES.batch_id%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,
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,

Line 2610: p_batch_id IN RA_BATCHES.batch_id%TYPE,

2606: +===========================================================================*/
2607: PROCEDURE create_BR(
2608: p_draft_mode IN VARCHAR2,
2609: p_call IN NUMBER,
2610: p_batch_id IN RA_BATCHES.batch_id%TYPE,
2611: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
2612: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
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,

Line 2616: p_currency_code IN RA_BATCHES.currency_code%TYPE,

2612: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
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

Line 2654: l_batch_process_status RA_BATCHES.batch_process_status%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;
2655: l_batch_source_id RA_BATCHES.batch_source_id%TYPE;
2656: l_gl_date RA_BATCHES.gl_date%TYPE;
2657: l_issue_date RA_BATCHES.issue_date%TYPE;
2658: l_maturity_date RA_BATCHES.maturity_date%TYPE;

Line 2655: l_batch_source_id RA_BATCHES.batch_source_id%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;
2655: l_batch_source_id RA_BATCHES.batch_source_id%TYPE;
2656: l_gl_date RA_BATCHES.gl_date%TYPE;
2657: l_issue_date RA_BATCHES.issue_date%TYPE;
2658: l_maturity_date RA_BATCHES.maturity_date%TYPE;
2659: l_comments RA_BATCHES.comments%TYPE;

Line 2656: l_gl_date RA_BATCHES.gl_date%TYPE;

2652: l_request_id NUMBER;
2653:
2654: l_batch_process_status RA_BATCHES.batch_process_status%TYPE;
2655: l_batch_source_id RA_BATCHES.batch_source_id%TYPE;
2656: l_gl_date RA_BATCHES.gl_date%TYPE;
2657: l_issue_date RA_BATCHES.issue_date%TYPE;
2658: l_maturity_date RA_BATCHES.maturity_date%TYPE;
2659: l_comments RA_BATCHES.comments%TYPE;
2660: l_special_instructions RA_BATCHES.special_instructions%TYPE;

Line 2657: l_issue_date RA_BATCHES.issue_date%TYPE;

2653:
2654: l_batch_process_status RA_BATCHES.batch_process_status%TYPE;
2655: l_batch_source_id RA_BATCHES.batch_source_id%TYPE;
2656: l_gl_date RA_BATCHES.gl_date%TYPE;
2657: l_issue_date RA_BATCHES.issue_date%TYPE;
2658: l_maturity_date RA_BATCHES.maturity_date%TYPE;
2659: l_comments RA_BATCHES.comments%TYPE;
2660: l_special_instructions RA_BATCHES.special_instructions%TYPE;
2661: l_due_date_nimm RA_BATCHES.maturity_date%TYPE;

Line 2658: l_maturity_date RA_BATCHES.maturity_date%TYPE;

2654: l_batch_process_status RA_BATCHES.batch_process_status%TYPE;
2655: l_batch_source_id RA_BATCHES.batch_source_id%TYPE;
2656: l_gl_date RA_BATCHES.gl_date%TYPE;
2657: l_issue_date RA_BATCHES.issue_date%TYPE;
2658: l_maturity_date RA_BATCHES.maturity_date%TYPE;
2659: l_comments RA_BATCHES.comments%TYPE;
2660: l_special_instructions RA_BATCHES.special_instructions%TYPE;
2661: l_due_date_nimm RA_BATCHES.maturity_date%TYPE;
2662: l_due_date_imm RA_BATCHES.maturity_date%TYPE;

Line 2659: l_comments RA_BATCHES.comments%TYPE;

2655: l_batch_source_id RA_BATCHES.batch_source_id%TYPE;
2656: l_gl_date RA_BATCHES.gl_date%TYPE;
2657: l_issue_date RA_BATCHES.issue_date%TYPE;
2658: l_maturity_date RA_BATCHES.maturity_date%TYPE;
2659: l_comments RA_BATCHES.comments%TYPE;
2660: l_special_instructions RA_BATCHES.special_instructions%TYPE;
2661: l_due_date_nimm RA_BATCHES.maturity_date%TYPE;
2662: l_due_date_imm RA_BATCHES.maturity_date%TYPE;
2663:

Line 2660: l_special_instructions RA_BATCHES.special_instructions%TYPE;

2656: l_gl_date RA_BATCHES.gl_date%TYPE;
2657: l_issue_date RA_BATCHES.issue_date%TYPE;
2658: l_maturity_date RA_BATCHES.maturity_date%TYPE;
2659: l_comments RA_BATCHES.comments%TYPE;
2660: l_special_instructions RA_BATCHES.special_instructions%TYPE;
2661: l_due_date_nimm RA_BATCHES.maturity_date%TYPE;
2662: l_due_date_imm RA_BATCHES.maturity_date%TYPE;
2663:
2664: l_doc_sequence_id NUMBER;

Line 2661: l_due_date_nimm RA_BATCHES.maturity_date%TYPE;

2657: l_issue_date RA_BATCHES.issue_date%TYPE;
2658: l_maturity_date RA_BATCHES.maturity_date%TYPE;
2659: l_comments RA_BATCHES.comments%TYPE;
2660: l_special_instructions RA_BATCHES.special_instructions%TYPE;
2661: l_due_date_nimm RA_BATCHES.maturity_date%TYPE;
2662: l_due_date_imm RA_BATCHES.maturity_date%TYPE;
2663:
2664: l_doc_sequence_id NUMBER;
2665: l_doc_sequence_value NUMBER;

Line 2662: l_due_date_imm RA_BATCHES.maturity_date%TYPE;

2658: l_maturity_date RA_BATCHES.maturity_date%TYPE;
2659: l_comments RA_BATCHES.comments%TYPE;
2660: l_special_instructions RA_BATCHES.special_instructions%TYPE;
2661: l_due_date_nimm RA_BATCHES.maturity_date%TYPE;
2662: l_due_date_imm RA_BATCHES.maturity_date%TYPE;
2663:
2664: l_doc_sequence_id NUMBER;
2665: l_doc_sequence_value NUMBER;
2666: l_old_trx_number VARCHAR2(20);

Line 2932: FROM RA_BATCHES

2928: l_issue_date,
2929: l_maturity_date,
2930: l_comments,
2931: l_special_instructions
2932: FROM RA_BATCHES
2933: WHERE batch_id = p_batch_id;
2934:
2935: ELSE
2936:

Line 4023: p_batch_id IN RA_BATCHES.batch_id%TYPE,

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,
4027: p_br_currency IN RA_BATCHES.currency_code%TYPE,

Line 4027: p_br_currency IN RA_BATCHES.currency_code%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,
4030: p_drawee_id IN RA_CUSTOMER_TRX.drawee_id%TYPE,
4031: p_drawee_contact_id IN RA_CUSTOMER_TRX.drawee_contact_id%TYPE,

Line 4028: p_batch_status IN RA_BATCHES.status%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,
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,

Line 4029: p_maturity_date IN RA_BATCHES.maturity_date%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,
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,

Line 4490: p_batch_id IN RA_BATCHES.batch_id%TYPE) IS

4486: | MODIFICATION HISTORY - Created by Mireille Flahaut - 25/07/2000 |
4487: | |
4488: +===========================================================================*/
4489: PROCEDURE run_report_pvt(
4490: p_batch_id IN RA_BATCHES.batch_id%TYPE) IS
4491:
4492: l_request_id NUMBER;
4493: l_version VARCHAR2(30);
4494: l_meaning VARCHAR2(30);

Line 4584: p_object_id IN RA_BATCHES.batch_id%TYPE,

4580: | MODIFICATION HISTORY - Created by Mireille Flahaut - 25/07/2000 |
4581: | |
4582: +===========================================================================*/
4583: PROCEDURE print_BR_pvt(
4584: p_object_id IN RA_BATCHES.batch_id%TYPE,
4585: p_call IN NUMBER,
4586: p_request_id OUT NOCOPY NUMBER) IS
4587:
4588: l_request_id NUMBER;