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 367: p_batch_id IN RA_BATCHES.batch_id%TYPE DEFAULT NULL,

363: retcode OUT NOCOPY VARCHAR2,
364: p_call IN NUMBER,
365: p_draft_mode IN VARCHAR2,
366: p_print_flag IN VARCHAR2,
367: p_batch_id IN RA_BATCHES.batch_id%TYPE DEFAULT NULL,
368: p_batch_source_id IN RA_BATCH_SOURCES.batch_source_id%TYPE,
369: p_batch_date IN VARCHAR2,
370: p_gl_date IN VARCHAR2 DEFAULT NULL,
371: p_issue_date IN VARCHAR2 DEFAULT NULL,

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

369: p_batch_date IN VARCHAR2,
370: p_gl_date IN VARCHAR2 DEFAULT NULL,
371: p_issue_date IN VARCHAR2 DEFAULT NULL,
372: p_maturity_date IN VARCHAR2 DEFAULT NULL,
373: p_currency_code IN RA_BATCHES.currency_code%TYPE DEFAULT NULL,
374: p_comments IN RA_BATCHES.comments%TYPE DEFAULT NULL,
375: p_special_instructions IN RA_BATCHES.special_instructions%TYPE DEFAULT NULL,
376: p_attribute_category IN RA_BATCHES.attribute_category%TYPE DEFAULT NULL,
377: p_attribute1 IN VARCHAR2 DEFAULT NULL,

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

370: p_gl_date IN VARCHAR2 DEFAULT NULL,
371: p_issue_date IN VARCHAR2 DEFAULT NULL,
372: p_maturity_date IN VARCHAR2 DEFAULT NULL,
373: p_currency_code IN RA_BATCHES.currency_code%TYPE DEFAULT NULL,
374: p_comments IN RA_BATCHES.comments%TYPE DEFAULT NULL,
375: p_special_instructions IN RA_BATCHES.special_instructions%TYPE DEFAULT NULL,
376: p_attribute_category IN RA_BATCHES.attribute_category%TYPE DEFAULT NULL,
377: p_attribute1 IN VARCHAR2 DEFAULT NULL,
378: p_attribute2 IN VARCHAR2 DEFAULT NULL,

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

371: p_issue_date IN VARCHAR2 DEFAULT NULL,
372: p_maturity_date IN VARCHAR2 DEFAULT NULL,
373: p_currency_code IN RA_BATCHES.currency_code%TYPE DEFAULT NULL,
374: p_comments IN RA_BATCHES.comments%TYPE DEFAULT NULL,
375: p_special_instructions IN RA_BATCHES.special_instructions%TYPE DEFAULT NULL,
376: p_attribute_category IN RA_BATCHES.attribute_category%TYPE DEFAULT NULL,
377: p_attribute1 IN VARCHAR2 DEFAULT NULL,
378: p_attribute2 IN VARCHAR2 DEFAULT NULL,
379: p_attribute3 IN VARCHAR2 DEFAULT NULL,

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

372: p_maturity_date IN VARCHAR2 DEFAULT NULL,
373: p_currency_code IN RA_BATCHES.currency_code%TYPE DEFAULT NULL,
374: p_comments IN RA_BATCHES.comments%TYPE DEFAULT NULL,
375: p_special_instructions IN RA_BATCHES.special_instructions%TYPE DEFAULT NULL,
376: p_attribute_category IN RA_BATCHES.attribute_category%TYPE DEFAULT NULL,
377: p_attribute1 IN VARCHAR2 DEFAULT NULL,
378: p_attribute2 IN VARCHAR2 DEFAULT NULL,
379: p_attribute3 IN VARCHAR2 DEFAULT NULL,
380: p_attribute4 IN VARCHAR2 DEFAULT NULL,

Line 416: l_batch_id RA_BATCHES.batch_id%TYPE;

412: l_due_date_high DATE := NULL;
413: l_trx_date_low DATE := NULL;
414: l_trx_date_high DATE := NULL;
415:
416: l_batch_id RA_BATCHES.batch_id%TYPE;
417:
418: BEGIN
419:
420: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.auto_create_br_program (+)');

Line 613: p_batch_id IN RA_BATCHES.batch_id%TYPE,

609: +===========================================================================*/
610: PROCEDURE from_automatic_batch_window(
611: p_draft_mode IN VARCHAR2,
612: p_print_flag IN VARCHAR2,
613: p_batch_id IN RA_BATCHES.batch_id%TYPE,
614: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
615: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
616: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
617: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,

Line 708: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE,

704: | |
705: +===========================================================================*/
706: PROCEDURE from_conc_request_window(
707: p_print_flag IN varchar2,
708: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE,
709: p_batch_date IN RA_BATCHES.batch_date%TYPE,
710: p_gl_date IN VARCHAR2,
711: p_issue_date IN VARCHAR2,
712: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,

Line 709: p_batch_date IN RA_BATCHES.batch_date%TYPE,

705: +===========================================================================*/
706: PROCEDURE from_conc_request_window(
707: p_print_flag IN varchar2,
708: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE,
709: p_batch_date IN RA_BATCHES.batch_date%TYPE,
710: p_gl_date IN VARCHAR2,
711: p_issue_date IN VARCHAR2,
712: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
713: p_currency_code IN RA_BATCHES.currency_code%TYPE,

Line 712: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,

708: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE,
709: p_batch_date IN RA_BATCHES.batch_date%TYPE,
710: p_gl_date IN VARCHAR2,
711: p_issue_date IN VARCHAR2,
712: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
713: p_currency_code IN RA_BATCHES.currency_code%TYPE,
714: p_comments IN RA_BATCHES.comments%TYPE,
715: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,
716: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,

Line 713: p_currency_code IN RA_BATCHES.currency_code%TYPE,

709: p_batch_date IN RA_BATCHES.batch_date%TYPE,
710: p_gl_date IN VARCHAR2,
711: p_issue_date IN VARCHAR2,
712: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
713: p_currency_code IN RA_BATCHES.currency_code%TYPE,
714: p_comments IN RA_BATCHES.comments%TYPE,
715: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,
716: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,
717: p_attribute1 IN VARCHAR2,

Line 714: p_comments IN RA_BATCHES.comments%TYPE,

710: p_gl_date IN VARCHAR2,
711: p_issue_date IN VARCHAR2,
712: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
713: p_currency_code IN RA_BATCHES.currency_code%TYPE,
714: p_comments IN RA_BATCHES.comments%TYPE,
715: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,
716: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,
717: p_attribute1 IN VARCHAR2,
718: p_attribute2 IN VARCHAR2,

Line 715: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,

711: p_issue_date IN VARCHAR2,
712: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
713: p_currency_code IN RA_BATCHES.currency_code%TYPE,
714: p_comments IN RA_BATCHES.comments%TYPE,
715: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,
716: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,
717: p_attribute1 IN VARCHAR2,
718: p_attribute2 IN VARCHAR2,
719: p_attribute3 IN VARCHAR2,

Line 716: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,

712: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
713: p_currency_code IN RA_BATCHES.currency_code%TYPE,
714: p_comments IN RA_BATCHES.comments%TYPE,
715: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,
716: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,
717: p_attribute1 IN VARCHAR2,
718: p_attribute2 IN VARCHAR2,
719: p_attribute3 IN VARCHAR2,
720: p_attribute4 IN VARCHAR2,

Line 746: l_batch_id RA_BATCHES.batch_id%TYPE;

742: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
743: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
744: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE) IS
745:
746: l_batch_id RA_BATCHES.batch_id%TYPE;
747: l_selection_criteria_id RA_BATCHES.selection_criteria_id%TYPE;
748:
749: l_request_id NUMBER;
750:

Line 747: l_selection_criteria_id RA_BATCHES.selection_criteria_id%TYPE;

743: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
744: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE) IS
745:
746: l_batch_id RA_BATCHES.batch_id%TYPE;
747: l_selection_criteria_id RA_BATCHES.selection_criteria_id%TYPE;
748:
749: l_request_id NUMBER;
750:
751: BEGIN

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

754:
755: -- Temporary table Creation
756: ARP_PROGRAM_GENERATE_BR.arbr_cr_tmp_table;
757:
758: -- Insert the batch header in RA_BATCHES and the criteria in AR_SELECTION_CRITERIA
759: ARP_PROGRAM_GENERATE_BR.create_batch_header(
760: p_batch_source_id,
761: p_batch_date,
762: p_gl_date,

Line 873: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE,

869: | MODIFICATION HISTORY - Created by Mireille Flahaut - 26/07/2000 |
870: | |
871: +===========================================================================*/
872: PROCEDURE create_batch_header (
873: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE,
874: p_batch_date IN RA_BATCHES.batch_date%TYPE,
875: p_gl_date IN VARCHAR2, -- currently not used
876: p_issue_date IN VARCHAR2, -- currently not used
877: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,

Line 874: p_batch_date IN RA_BATCHES.batch_date%TYPE,

870: | |
871: +===========================================================================*/
872: PROCEDURE create_batch_header (
873: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE,
874: p_batch_date IN RA_BATCHES.batch_date%TYPE,
875: p_gl_date IN VARCHAR2, -- currently not used
876: p_issue_date IN VARCHAR2, -- currently not used
877: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
878: p_currency_code IN RA_BATCHES.currency_code%TYPE,

Line 877: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,

873: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE,
874: p_batch_date IN RA_BATCHES.batch_date%TYPE,
875: p_gl_date IN VARCHAR2, -- currently not used
876: p_issue_date IN VARCHAR2, -- currently not used
877: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
878: p_currency_code IN RA_BATCHES.currency_code%TYPE,
879: p_comments IN RA_BATCHES.comments%TYPE,
880: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,
881: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,

Line 878: p_currency_code IN RA_BATCHES.currency_code%TYPE,

874: p_batch_date IN RA_BATCHES.batch_date%TYPE,
875: p_gl_date IN VARCHAR2, -- currently not used
876: p_issue_date IN VARCHAR2, -- currently not used
877: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
878: p_currency_code IN RA_BATCHES.currency_code%TYPE,
879: p_comments IN RA_BATCHES.comments%TYPE,
880: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,
881: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,
882: p_attribute1 IN VARCHAR2,

Line 879: p_comments IN RA_BATCHES.comments%TYPE,

875: p_gl_date IN VARCHAR2, -- currently not used
876: p_issue_date IN VARCHAR2, -- currently not used
877: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
878: p_currency_code IN RA_BATCHES.currency_code%TYPE,
879: p_comments IN RA_BATCHES.comments%TYPE,
880: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,
881: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,
882: p_attribute1 IN VARCHAR2,
883: p_attribute2 IN VARCHAR2,

Line 880: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,

876: p_issue_date IN VARCHAR2, -- currently not used
877: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
878: p_currency_code IN RA_BATCHES.currency_code%TYPE,
879: p_comments IN RA_BATCHES.comments%TYPE,
880: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,
881: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,
882: p_attribute1 IN VARCHAR2,
883: p_attribute2 IN VARCHAR2,
884: p_attribute3 IN VARCHAR2,

Line 881: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,

877: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
878: p_currency_code IN RA_BATCHES.currency_code%TYPE,
879: p_comments IN RA_BATCHES.comments%TYPE,
880: p_special_instructions IN RA_BATCHES.special_instructions%TYPE,
881: p_attribute_category IN RA_BATCHES.attribute_category%TYPE,
882: p_attribute1 IN VARCHAR2,
883: p_attribute2 IN VARCHAR2,
884: p_attribute3 IN VARCHAR2,
885: p_attribute4 IN VARCHAR2,

Line 910: p_batch_id OUT NOCOPY RA_BATCHES.batch_id%TYPE,

906: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
907: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
908: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
909: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
910: p_batch_id OUT NOCOPY RA_BATCHES.batch_id%TYPE,
911: p_selection_criteria_id OUT NOCOPY
912: RA_BATCHES.selection_criteria_id%TYPE) IS
913: l_issue_date RA_BATCHES.issue_date%TYPE;
914: l_gl_date RA_BATCHES.gl_date%TYPE;

Line 912: RA_BATCHES.selection_criteria_id%TYPE) IS

908: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
909: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
910: p_batch_id OUT NOCOPY RA_BATCHES.batch_id%TYPE,
911: p_selection_criteria_id OUT NOCOPY
912: RA_BATCHES.selection_criteria_id%TYPE) IS
913: l_issue_date RA_BATCHES.issue_date%TYPE;
914: l_gl_date RA_BATCHES.gl_date%TYPE;
915: l_default_rule_used VARCHAR2(30);
916: l_error_message VARCHAR2(30);

Line 913: l_issue_date RA_BATCHES.issue_date%TYPE;

909: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
910: p_batch_id OUT NOCOPY RA_BATCHES.batch_id%TYPE,
911: p_selection_criteria_id OUT NOCOPY
912: RA_BATCHES.selection_criteria_id%TYPE) IS
913: l_issue_date RA_BATCHES.issue_date%TYPE;
914: l_gl_date RA_BATCHES.gl_date%TYPE;
915: l_default_rule_used VARCHAR2(30);
916: l_error_message VARCHAR2(30);
917:

Line 914: l_gl_date RA_BATCHES.gl_date%TYPE;

910: p_batch_id OUT NOCOPY RA_BATCHES.batch_id%TYPE,
911: p_selection_criteria_id OUT NOCOPY
912: RA_BATCHES.selection_criteria_id%TYPE) IS
913: l_issue_date RA_BATCHES.issue_date%TYPE;
914: l_gl_date RA_BATCHES.gl_date%TYPE;
915: l_default_rule_used VARCHAR2(30);
916: l_error_message VARCHAR2(30);
917:
918: l_batch_id RA_BATCHES.batch_id%TYPE;

Line 918: l_batch_id RA_BATCHES.batch_id%TYPE;

914: l_gl_date RA_BATCHES.gl_date%TYPE;
915: l_default_rule_used VARCHAR2(30);
916: l_error_message VARCHAR2(30);
917:
918: l_batch_id RA_BATCHES.batch_id%TYPE;
919: l_selection_criteria_id RA_BATCHES.batch_id%TYPE;
920: l_name RA_BATCHES.name%TYPE;
921:
922: BEGIN

Line 919: l_selection_criteria_id RA_BATCHES.batch_id%TYPE;

915: l_default_rule_used VARCHAR2(30);
916: l_error_message VARCHAR2(30);
917:
918: l_batch_id RA_BATCHES.batch_id%TYPE;
919: l_selection_criteria_id RA_BATCHES.batch_id%TYPE;
920: l_name RA_BATCHES.name%TYPE;
921:
922: BEGIN
923:

Line 920: l_name RA_BATCHES.name%TYPE;

916: l_error_message VARCHAR2(30);
917:
918: l_batch_id RA_BATCHES.batch_id%TYPE;
919: l_selection_criteria_id RA_BATCHES.batch_id%TYPE;
920: l_name RA_BATCHES.name%TYPE;
921:
922: BEGIN
923:
924: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.create_batch_header (+)');

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

953: FND_MESSAGE.set_token('GENERIC_TEXT',l_error_message);
954: APP_EXCEPTION.raise_exception;
955: END IF;
956:
957: -- Insert the batch header in RA_BATCHES and the criteria in AR_SELECTION_CRITERIA
958: arp_process_br_batches.insert_batch('FNDRSRUN', -- p_form_name
959: NULL, -- p_form_version
960: p_batch_source_id, -- p_batch_source_id
961: p_batch_date, -- p_batch_date

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

1039: | |
1040: +===========================================================================*/
1041: PROCEDURE update_batch_status(
1042: p_draft_mode IN VARCHAR2,
1043: p_batch_id IN RA_BATCHES.batch_id%TYPE) IS
1044:
1045: l_batch_rec RA_BATCHES%ROWTYPE;
1046: l_criteria_rec AR_SELECTION_CRITERIA%ROWTYPE;
1047:

Line 1045: l_batch_rec RA_BATCHES%ROWTYPE;

1041: PROCEDURE update_batch_status(
1042: p_draft_mode IN VARCHAR2,
1043: p_batch_id IN RA_BATCHES.batch_id%TYPE) IS
1044:
1045: l_batch_rec RA_BATCHES%ROWTYPE;
1046: l_criteria_rec AR_SELECTION_CRITERIA%ROWTYPE;
1047:
1048: l_selection_criteria_id RA_BATCHES.selection_criteria_id%TYPE;
1049: l_status RA_BATCHES.batch_process_status%TYPE;

Line 1048: l_selection_criteria_id RA_BATCHES.selection_criteria_id%TYPE;

1044:
1045: l_batch_rec RA_BATCHES%ROWTYPE;
1046: l_criteria_rec AR_SELECTION_CRITERIA%ROWTYPE;
1047:
1048: l_selection_criteria_id RA_BATCHES.selection_criteria_id%TYPE;
1049: l_status RA_BATCHES.batch_process_status%TYPE;
1050:
1051:
1052: BEGIN

Line 1049: l_status RA_BATCHES.batch_process_status%TYPE;

1045: l_batch_rec RA_BATCHES%ROWTYPE;
1046: l_criteria_rec AR_SELECTION_CRITERIA%ROWTYPE;
1047:
1048: l_selection_criteria_id RA_BATCHES.selection_criteria_id%TYPE;
1049: l_status RA_BATCHES.batch_process_status%TYPE;
1050:
1051:
1052: BEGIN
1053:

Line 1168: p_batch_id IN RA_BATCHES.batch_id%TYPE,

1164: +===========================================================================*/
1165: PROCEDURE select_trx_and_create_BR(
1166: p_draft_mode IN VARCHAR2,
1167: p_call IN NUMBER,
1168: p_batch_id IN RA_BATCHES.batch_id%TYPE,
1169: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1170: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1171: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
1172: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,

Line 1201: FROM ra_batches batch,

1197: pm.maturity_date_rule_code,
1198: DECODE(pm.br_min_acctd_amount,NULL,0.00000001,0,0.00000001,pm.br_min_acctd_amount),
1199: NVL(pm.br_max_acctd_amount,9999999999999999999999999999999999),
1200: trx.invoice_currency_code, trx.exchange_rate, trx.legal_entity_id
1201: FROM ra_batches batch,
1202: ar_receipt_classes class,
1203: ar_receipt_methods pm,
1204: ra_customer_trx trx,
1205: ra_cust_trx_types type,

Line 1237: FROM ra_batches batch,

1233: date is with in the date range of transaction type of invoice */
1234: CURSOR c_rm_bank (rm_id IN NUMBER, cust_id IN NUMBER) IS
1235: -- SELECT distinct trx.customer_bank_account_id 5051673
1236: SELECT distinct instrument_id customer_bank_account_id
1237: FROM ra_batches batch,
1238: ar_receipt_classes class,
1239: ar_receipt_methods pm,
1240: ra_customer_trx trx,
1241: ra_cust_trx_types type,

Line 2060: 'FROM ra_batches batch,

2056: */
2057: /* Bug 4928711 - Removed the references to ap_bank_accounts */
2058:
2059: l_trx_select_statement :=
2060: 'FROM ra_batches batch,
2061: ar_receipt_methods pm,
2062: ar_payment_schedules ps,
2063: ra_customer_trx trx,
2064: ra_cust_trx_types type,

Line 2262: p_batch_id IN RA_BATCHES.batch_id%TYPE,

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

Line 2510: p_batch_id IN RA_BATCHES.batch_id%TYPE,

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

Line 2751: p_batch_id IN RA_BATCHES.batch_id%TYPE,

2747: +===========================================================================*/
2748: PROCEDURE create_BR(
2749: p_draft_mode IN VARCHAR2,
2750: p_call IN NUMBER,
2751: p_batch_id IN RA_BATCHES.batch_id%TYPE,
2752: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
2753: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
2754: p_maturity_date_rule_code IN AR_RECEIPT_METHODS.maturity_date_rule_code%TYPE,
2755: p_br_min_acctd_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,

Line 2757: p_currency_code IN RA_BATCHES.currency_code%TYPE,

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

Line 2795: l_batch_process_status RA_BATCHES.batch_process_status%TYPE;

2791: l_bill_number RA_CUSTOMER_TRX.trx_number%TYPE;
2792: l_bill_status AR_TRANSACTION_HISTORY.status%TYPE;
2793: l_request_id NUMBER;
2794:
2795: l_batch_process_status RA_BATCHES.batch_process_status%TYPE;
2796: l_batch_source_id RA_BATCHES.batch_source_id%TYPE;
2797: l_gl_date RA_BATCHES.gl_date%TYPE;
2798: l_issue_date RA_BATCHES.issue_date%TYPE;
2799: l_maturity_date RA_BATCHES.maturity_date%TYPE;

Line 2796: l_batch_source_id RA_BATCHES.batch_source_id%TYPE;

2792: l_bill_status AR_TRANSACTION_HISTORY.status%TYPE;
2793: l_request_id NUMBER;
2794:
2795: l_batch_process_status RA_BATCHES.batch_process_status%TYPE;
2796: l_batch_source_id RA_BATCHES.batch_source_id%TYPE;
2797: l_gl_date RA_BATCHES.gl_date%TYPE;
2798: l_issue_date RA_BATCHES.issue_date%TYPE;
2799: l_maturity_date RA_BATCHES.maturity_date%TYPE;
2800: l_comments RA_BATCHES.comments%TYPE;

Line 2797: l_gl_date RA_BATCHES.gl_date%TYPE;

2793: l_request_id NUMBER;
2794:
2795: l_batch_process_status RA_BATCHES.batch_process_status%TYPE;
2796: l_batch_source_id RA_BATCHES.batch_source_id%TYPE;
2797: l_gl_date RA_BATCHES.gl_date%TYPE;
2798: l_issue_date RA_BATCHES.issue_date%TYPE;
2799: l_maturity_date RA_BATCHES.maturity_date%TYPE;
2800: l_comments RA_BATCHES.comments%TYPE;
2801: l_special_instructions RA_BATCHES.special_instructions%TYPE;

Line 2798: l_issue_date RA_BATCHES.issue_date%TYPE;

2794:
2795: l_batch_process_status RA_BATCHES.batch_process_status%TYPE;
2796: l_batch_source_id RA_BATCHES.batch_source_id%TYPE;
2797: l_gl_date RA_BATCHES.gl_date%TYPE;
2798: l_issue_date RA_BATCHES.issue_date%TYPE;
2799: l_maturity_date RA_BATCHES.maturity_date%TYPE;
2800: l_comments RA_BATCHES.comments%TYPE;
2801: l_special_instructions RA_BATCHES.special_instructions%TYPE;
2802: l_due_date_nimm RA_BATCHES.maturity_date%TYPE;

Line 2799: l_maturity_date RA_BATCHES.maturity_date%TYPE;

2795: l_batch_process_status RA_BATCHES.batch_process_status%TYPE;
2796: l_batch_source_id RA_BATCHES.batch_source_id%TYPE;
2797: l_gl_date RA_BATCHES.gl_date%TYPE;
2798: l_issue_date RA_BATCHES.issue_date%TYPE;
2799: l_maturity_date RA_BATCHES.maturity_date%TYPE;
2800: l_comments RA_BATCHES.comments%TYPE;
2801: l_special_instructions RA_BATCHES.special_instructions%TYPE;
2802: l_due_date_nimm RA_BATCHES.maturity_date%TYPE;
2803: l_due_date_imm RA_BATCHES.maturity_date%TYPE;

Line 2800: l_comments RA_BATCHES.comments%TYPE;

2796: l_batch_source_id RA_BATCHES.batch_source_id%TYPE;
2797: l_gl_date RA_BATCHES.gl_date%TYPE;
2798: l_issue_date RA_BATCHES.issue_date%TYPE;
2799: l_maturity_date RA_BATCHES.maturity_date%TYPE;
2800: l_comments RA_BATCHES.comments%TYPE;
2801: l_special_instructions RA_BATCHES.special_instructions%TYPE;
2802: l_due_date_nimm RA_BATCHES.maturity_date%TYPE;
2803: l_due_date_imm RA_BATCHES.maturity_date%TYPE;
2804:

Line 2801: l_special_instructions RA_BATCHES.special_instructions%TYPE;

2797: l_gl_date RA_BATCHES.gl_date%TYPE;
2798: l_issue_date RA_BATCHES.issue_date%TYPE;
2799: l_maturity_date RA_BATCHES.maturity_date%TYPE;
2800: l_comments RA_BATCHES.comments%TYPE;
2801: l_special_instructions RA_BATCHES.special_instructions%TYPE;
2802: l_due_date_nimm RA_BATCHES.maturity_date%TYPE;
2803: l_due_date_imm RA_BATCHES.maturity_date%TYPE;
2804:
2805: l_doc_sequence_id NUMBER;

Line 2802: l_due_date_nimm RA_BATCHES.maturity_date%TYPE;

2798: l_issue_date RA_BATCHES.issue_date%TYPE;
2799: l_maturity_date RA_BATCHES.maturity_date%TYPE;
2800: l_comments RA_BATCHES.comments%TYPE;
2801: l_special_instructions RA_BATCHES.special_instructions%TYPE;
2802: l_due_date_nimm RA_BATCHES.maturity_date%TYPE;
2803: l_due_date_imm RA_BATCHES.maturity_date%TYPE;
2804:
2805: l_doc_sequence_id NUMBER;
2806: l_doc_sequence_value NUMBER;

Line 2803: l_due_date_imm RA_BATCHES.maturity_date%TYPE;

2799: l_maturity_date RA_BATCHES.maturity_date%TYPE;
2800: l_comments RA_BATCHES.comments%TYPE;
2801: l_special_instructions RA_BATCHES.special_instructions%TYPE;
2802: l_due_date_nimm RA_BATCHES.maturity_date%TYPE;
2803: l_due_date_imm RA_BATCHES.maturity_date%TYPE;
2804:
2805: l_doc_sequence_id NUMBER;
2806: l_doc_sequence_value NUMBER;
2807: l_old_trx_number VARCHAR2(20);

Line 3074: FROM RA_BATCHES

3070: l_issue_date,
3071: l_maturity_date,
3072: l_comments,
3073: l_special_instructions
3074: FROM RA_BATCHES
3075: WHERE batch_id = p_batch_id;
3076:
3077: ELSE
3078:

Line 4182: p_batch_id IN RA_BATCHES.batch_id%TYPE,

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

Line 4186: p_br_currency IN RA_BATCHES.currency_code%TYPE,

4182: p_batch_id IN RA_BATCHES.batch_id%TYPE,
4183: p_br_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
4184: p_bill_number IN RA_CUSTOMER_TRX.trx_number%TYPE,
4185: p_br_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
4186: p_br_currency IN RA_BATCHES.currency_code%TYPE,
4187: p_batch_status IN RA_BATCHES.status%TYPE,
4188: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
4189: p_drawee_id IN RA_CUSTOMER_TRX.drawee_id%TYPE,
4190: p_drawee_contact_id IN RA_CUSTOMER_TRX.drawee_contact_id%TYPE,

Line 4187: p_batch_status IN RA_BATCHES.status%TYPE,

4183: p_br_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,
4184: p_bill_number IN RA_CUSTOMER_TRX.trx_number%TYPE,
4185: p_br_amount IN AR_RECEIPT_METHODS.br_min_acctd_amount%TYPE,
4186: p_br_currency IN RA_BATCHES.currency_code%TYPE,
4187: p_batch_status IN RA_BATCHES.status%TYPE,
4188: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,
4189: p_drawee_id IN RA_CUSTOMER_TRX.drawee_id%TYPE,
4190: p_drawee_contact_id IN RA_CUSTOMER_TRX.drawee_contact_id%TYPE,
4191: p_drawee_site_use_id IN RA_CUSTOMER_TRX.drawee_site_use_id%TYPE,

Line 4188: p_maturity_date IN RA_BATCHES.maturity_date%TYPE,

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

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

4645: | MODIFICATION HISTORY - Created by Mireille Flahaut - 25/07/2000 |
4646: | |
4647: +===========================================================================*/
4648: PROCEDURE run_report_pvt(
4649: p_batch_id IN RA_BATCHES.batch_id%TYPE) IS
4650:
4651: l_request_id NUMBER;
4652: l_version VARCHAR2(30);
4653: l_meaning VARCHAR2(30);

Line 4743: p_object_id IN RA_BATCHES.batch_id%TYPE,

4739: | MODIFICATION HISTORY - Created by Mireille Flahaut - 25/07/2000 |
4740: | |
4741: +===========================================================================*/
4742: PROCEDURE print_BR_pvt(
4743: p_object_id IN RA_BATCHES.batch_id%TYPE,
4744: p_call IN NUMBER,
4745: p_request_id OUT NOCOPY NUMBER) IS
4746:
4747: l_request_id NUMBER;