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_PROCESS_BR_BATCHES dependencies on RA_BATCHES

Line 8: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,

4:
5: PROCEDURE insert_batch (
6: p_form_name IN varchar2 ,
7: p_form_version IN number ,
8: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
9: p_batch_date IN ra_batches.batch_date%TYPE ,
10: p_gl_date IN ra_batches.gl_date%TYPE ,
11: p_TYPE IN ra_batches.TYPE%TYPE ,
12: p_currency_code IN ra_batches.currency_code%TYPE ,

Line 9: p_batch_date IN ra_batches.batch_date%TYPE ,

5: PROCEDURE insert_batch (
6: p_form_name IN varchar2 ,
7: p_form_version IN number ,
8: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
9: p_batch_date IN ra_batches.batch_date%TYPE ,
10: p_gl_date IN ra_batches.gl_date%TYPE ,
11: p_TYPE IN ra_batches.TYPE%TYPE ,
12: p_currency_code IN ra_batches.currency_code%TYPE ,
13: p_comments IN ra_batches.comments%TYPE ,

Line 10: p_gl_date IN ra_batches.gl_date%TYPE ,

6: p_form_name IN varchar2 ,
7: p_form_version IN number ,
8: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
9: p_batch_date IN ra_batches.batch_date%TYPE ,
10: p_gl_date IN ra_batches.gl_date%TYPE ,
11: p_TYPE IN ra_batches.TYPE%TYPE ,
12: p_currency_code IN ra_batches.currency_code%TYPE ,
13: p_comments IN ra_batches.comments%TYPE ,
14: p_attribute_category IN ra_batches.attribute_category%TYPE ,

Line 11: p_TYPE IN ra_batches.TYPE%TYPE ,

7: p_form_version IN number ,
8: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
9: p_batch_date IN ra_batches.batch_date%TYPE ,
10: p_gl_date IN ra_batches.gl_date%TYPE ,
11: p_TYPE IN ra_batches.TYPE%TYPE ,
12: p_currency_code IN ra_batches.currency_code%TYPE ,
13: p_comments IN ra_batches.comments%TYPE ,
14: p_attribute_category IN ra_batches.attribute_category%TYPE ,
15: p_attribute1 IN ra_batches.attribute1%TYPE ,

Line 12: p_currency_code IN ra_batches.currency_code%TYPE ,

8: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
9: p_batch_date IN ra_batches.batch_date%TYPE ,
10: p_gl_date IN ra_batches.gl_date%TYPE ,
11: p_TYPE IN ra_batches.TYPE%TYPE ,
12: p_currency_code IN ra_batches.currency_code%TYPE ,
13: p_comments IN ra_batches.comments%TYPE ,
14: p_attribute_category IN ra_batches.attribute_category%TYPE ,
15: p_attribute1 IN ra_batches.attribute1%TYPE ,
16: p_attribute2 IN ra_batches.attribute2%TYPE ,

Line 13: p_comments IN ra_batches.comments%TYPE ,

9: p_batch_date IN ra_batches.batch_date%TYPE ,
10: p_gl_date IN ra_batches.gl_date%TYPE ,
11: p_TYPE IN ra_batches.TYPE%TYPE ,
12: p_currency_code IN ra_batches.currency_code%TYPE ,
13: p_comments IN ra_batches.comments%TYPE ,
14: p_attribute_category IN ra_batches.attribute_category%TYPE ,
15: p_attribute1 IN ra_batches.attribute1%TYPE ,
16: p_attribute2 IN ra_batches.attribute2%TYPE ,
17: p_attribute3 IN ra_batches.attribute3%TYPE ,

Line 14: p_attribute_category IN ra_batches.attribute_category%TYPE ,

10: p_gl_date IN ra_batches.gl_date%TYPE ,
11: p_TYPE IN ra_batches.TYPE%TYPE ,
12: p_currency_code IN ra_batches.currency_code%TYPE ,
13: p_comments IN ra_batches.comments%TYPE ,
14: p_attribute_category IN ra_batches.attribute_category%TYPE ,
15: p_attribute1 IN ra_batches.attribute1%TYPE ,
16: p_attribute2 IN ra_batches.attribute2%TYPE ,
17: p_attribute3 IN ra_batches.attribute3%TYPE ,
18: p_attribute4 IN ra_batches.attribute4%TYPE ,

Line 15: p_attribute1 IN ra_batches.attribute1%TYPE ,

11: p_TYPE IN ra_batches.TYPE%TYPE ,
12: p_currency_code IN ra_batches.currency_code%TYPE ,
13: p_comments IN ra_batches.comments%TYPE ,
14: p_attribute_category IN ra_batches.attribute_category%TYPE ,
15: p_attribute1 IN ra_batches.attribute1%TYPE ,
16: p_attribute2 IN ra_batches.attribute2%TYPE ,
17: p_attribute3 IN ra_batches.attribute3%TYPE ,
18: p_attribute4 IN ra_batches.attribute4%TYPE ,
19: p_attribute5 IN ra_batches.attribute5%TYPE ,

Line 16: p_attribute2 IN ra_batches.attribute2%TYPE ,

12: p_currency_code IN ra_batches.currency_code%TYPE ,
13: p_comments IN ra_batches.comments%TYPE ,
14: p_attribute_category IN ra_batches.attribute_category%TYPE ,
15: p_attribute1 IN ra_batches.attribute1%TYPE ,
16: p_attribute2 IN ra_batches.attribute2%TYPE ,
17: p_attribute3 IN ra_batches.attribute3%TYPE ,
18: p_attribute4 IN ra_batches.attribute4%TYPE ,
19: p_attribute5 IN ra_batches.attribute5%TYPE ,
20: p_attribute6 IN ra_batches.attribute6%TYPE ,

Line 17: p_attribute3 IN ra_batches.attribute3%TYPE ,

13: p_comments IN ra_batches.comments%TYPE ,
14: p_attribute_category IN ra_batches.attribute_category%TYPE ,
15: p_attribute1 IN ra_batches.attribute1%TYPE ,
16: p_attribute2 IN ra_batches.attribute2%TYPE ,
17: p_attribute3 IN ra_batches.attribute3%TYPE ,
18: p_attribute4 IN ra_batches.attribute4%TYPE ,
19: p_attribute5 IN ra_batches.attribute5%TYPE ,
20: p_attribute6 IN ra_batches.attribute6%TYPE ,
21: p_attribute7 IN ra_batches.attribute7%TYPE ,

Line 18: p_attribute4 IN ra_batches.attribute4%TYPE ,

14: p_attribute_category IN ra_batches.attribute_category%TYPE ,
15: p_attribute1 IN ra_batches.attribute1%TYPE ,
16: p_attribute2 IN ra_batches.attribute2%TYPE ,
17: p_attribute3 IN ra_batches.attribute3%TYPE ,
18: p_attribute4 IN ra_batches.attribute4%TYPE ,
19: p_attribute5 IN ra_batches.attribute5%TYPE ,
20: p_attribute6 IN ra_batches.attribute6%TYPE ,
21: p_attribute7 IN ra_batches.attribute7%TYPE ,
22: p_attribute8 IN ra_batches.attribute8%TYPE ,

Line 19: p_attribute5 IN ra_batches.attribute5%TYPE ,

15: p_attribute1 IN ra_batches.attribute1%TYPE ,
16: p_attribute2 IN ra_batches.attribute2%TYPE ,
17: p_attribute3 IN ra_batches.attribute3%TYPE ,
18: p_attribute4 IN ra_batches.attribute4%TYPE ,
19: p_attribute5 IN ra_batches.attribute5%TYPE ,
20: p_attribute6 IN ra_batches.attribute6%TYPE ,
21: p_attribute7 IN ra_batches.attribute7%TYPE ,
22: p_attribute8 IN ra_batches.attribute8%TYPE ,
23: p_attribute9 IN ra_batches.attribute9%TYPE ,

Line 20: p_attribute6 IN ra_batches.attribute6%TYPE ,

16: p_attribute2 IN ra_batches.attribute2%TYPE ,
17: p_attribute3 IN ra_batches.attribute3%TYPE ,
18: p_attribute4 IN ra_batches.attribute4%TYPE ,
19: p_attribute5 IN ra_batches.attribute5%TYPE ,
20: p_attribute6 IN ra_batches.attribute6%TYPE ,
21: p_attribute7 IN ra_batches.attribute7%TYPE ,
22: p_attribute8 IN ra_batches.attribute8%TYPE ,
23: p_attribute9 IN ra_batches.attribute9%TYPE ,
24: p_attribute10 IN ra_batches.attribute10%TYPE ,

Line 21: p_attribute7 IN ra_batches.attribute7%TYPE ,

17: p_attribute3 IN ra_batches.attribute3%TYPE ,
18: p_attribute4 IN ra_batches.attribute4%TYPE ,
19: p_attribute5 IN ra_batches.attribute5%TYPE ,
20: p_attribute6 IN ra_batches.attribute6%TYPE ,
21: p_attribute7 IN ra_batches.attribute7%TYPE ,
22: p_attribute8 IN ra_batches.attribute8%TYPE ,
23: p_attribute9 IN ra_batches.attribute9%TYPE ,
24: p_attribute10 IN ra_batches.attribute10%TYPE ,
25: p_attribute11 IN ra_batches.attribute11%TYPE ,

Line 22: p_attribute8 IN ra_batches.attribute8%TYPE ,

18: p_attribute4 IN ra_batches.attribute4%TYPE ,
19: p_attribute5 IN ra_batches.attribute5%TYPE ,
20: p_attribute6 IN ra_batches.attribute6%TYPE ,
21: p_attribute7 IN ra_batches.attribute7%TYPE ,
22: p_attribute8 IN ra_batches.attribute8%TYPE ,
23: p_attribute9 IN ra_batches.attribute9%TYPE ,
24: p_attribute10 IN ra_batches.attribute10%TYPE ,
25: p_attribute11 IN ra_batches.attribute11%TYPE ,
26: p_attribute12 IN ra_batches.attribute12%TYPE ,

Line 23: p_attribute9 IN ra_batches.attribute9%TYPE ,

19: p_attribute5 IN ra_batches.attribute5%TYPE ,
20: p_attribute6 IN ra_batches.attribute6%TYPE ,
21: p_attribute7 IN ra_batches.attribute7%TYPE ,
22: p_attribute8 IN ra_batches.attribute8%TYPE ,
23: p_attribute9 IN ra_batches.attribute9%TYPE ,
24: p_attribute10 IN ra_batches.attribute10%TYPE ,
25: p_attribute11 IN ra_batches.attribute11%TYPE ,
26: p_attribute12 IN ra_batches.attribute12%TYPE ,
27: p_attribute13 IN ra_batches.attribute13%TYPE ,

Line 24: p_attribute10 IN ra_batches.attribute10%TYPE ,

20: p_attribute6 IN ra_batches.attribute6%TYPE ,
21: p_attribute7 IN ra_batches.attribute7%TYPE ,
22: p_attribute8 IN ra_batches.attribute8%TYPE ,
23: p_attribute9 IN ra_batches.attribute9%TYPE ,
24: p_attribute10 IN ra_batches.attribute10%TYPE ,
25: p_attribute11 IN ra_batches.attribute11%TYPE ,
26: p_attribute12 IN ra_batches.attribute12%TYPE ,
27: p_attribute13 IN ra_batches.attribute13%TYPE ,
28: p_attribute14 IN ra_batches.attribute14%TYPE ,

Line 25: p_attribute11 IN ra_batches.attribute11%TYPE ,

21: p_attribute7 IN ra_batches.attribute7%TYPE ,
22: p_attribute8 IN ra_batches.attribute8%TYPE ,
23: p_attribute9 IN ra_batches.attribute9%TYPE ,
24: p_attribute10 IN ra_batches.attribute10%TYPE ,
25: p_attribute11 IN ra_batches.attribute11%TYPE ,
26: p_attribute12 IN ra_batches.attribute12%TYPE ,
27: p_attribute13 IN ra_batches.attribute13%TYPE ,
28: p_attribute14 IN ra_batches.attribute14%TYPE ,
29: p_attribute15 IN ra_batches.attribute15%TYPE ,

Line 26: p_attribute12 IN ra_batches.attribute12%TYPE ,

22: p_attribute8 IN ra_batches.attribute8%TYPE ,
23: p_attribute9 IN ra_batches.attribute9%TYPE ,
24: p_attribute10 IN ra_batches.attribute10%TYPE ,
25: p_attribute11 IN ra_batches.attribute11%TYPE ,
26: p_attribute12 IN ra_batches.attribute12%TYPE ,
27: p_attribute13 IN ra_batches.attribute13%TYPE ,
28: p_attribute14 IN ra_batches.attribute14%TYPE ,
29: p_attribute15 IN ra_batches.attribute15%TYPE ,
30: p_issue_date IN ra_batches.issue_date%TYPE ,

Line 27: p_attribute13 IN ra_batches.attribute13%TYPE ,

23: p_attribute9 IN ra_batches.attribute9%TYPE ,
24: p_attribute10 IN ra_batches.attribute10%TYPE ,
25: p_attribute11 IN ra_batches.attribute11%TYPE ,
26: p_attribute12 IN ra_batches.attribute12%TYPE ,
27: p_attribute13 IN ra_batches.attribute13%TYPE ,
28: p_attribute14 IN ra_batches.attribute14%TYPE ,
29: p_attribute15 IN ra_batches.attribute15%TYPE ,
30: p_issue_date IN ra_batches.issue_date%TYPE ,
31: p_maturity_date IN ra_batches.maturity_date%TYPE ,

Line 28: p_attribute14 IN ra_batches.attribute14%TYPE ,

24: p_attribute10 IN ra_batches.attribute10%TYPE ,
25: p_attribute11 IN ra_batches.attribute11%TYPE ,
26: p_attribute12 IN ra_batches.attribute12%TYPE ,
27: p_attribute13 IN ra_batches.attribute13%TYPE ,
28: p_attribute14 IN ra_batches.attribute14%TYPE ,
29: p_attribute15 IN ra_batches.attribute15%TYPE ,
30: p_issue_date IN ra_batches.issue_date%TYPE ,
31: p_maturity_date IN ra_batches.maturity_date%TYPE ,
32: p_special_instructions IN ra_batches.special_instructions%TYPE ,

Line 29: p_attribute15 IN ra_batches.attribute15%TYPE ,

25: p_attribute11 IN ra_batches.attribute11%TYPE ,
26: p_attribute12 IN ra_batches.attribute12%TYPE ,
27: p_attribute13 IN ra_batches.attribute13%TYPE ,
28: p_attribute14 IN ra_batches.attribute14%TYPE ,
29: p_attribute15 IN ra_batches.attribute15%TYPE ,
30: p_issue_date IN ra_batches.issue_date%TYPE ,
31: p_maturity_date IN ra_batches.maturity_date%TYPE ,
32: p_special_instructions IN ra_batches.special_instructions%TYPE ,
33: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,

Line 30: p_issue_date IN ra_batches.issue_date%TYPE ,

26: p_attribute12 IN ra_batches.attribute12%TYPE ,
27: p_attribute13 IN ra_batches.attribute13%TYPE ,
28: p_attribute14 IN ra_batches.attribute14%TYPE ,
29: p_attribute15 IN ra_batches.attribute15%TYPE ,
30: p_issue_date IN ra_batches.issue_date%TYPE ,
31: p_maturity_date IN ra_batches.maturity_date%TYPE ,
32: p_special_instructions IN ra_batches.special_instructions%TYPE ,
33: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
34: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,

Line 31: p_maturity_date IN ra_batches.maturity_date%TYPE ,

27: p_attribute13 IN ra_batches.attribute13%TYPE ,
28: p_attribute14 IN ra_batches.attribute14%TYPE ,
29: p_attribute15 IN ra_batches.attribute15%TYPE ,
30: p_issue_date IN ra_batches.issue_date%TYPE ,
31: p_maturity_date IN ra_batches.maturity_date%TYPE ,
32: p_special_instructions IN ra_batches.special_instructions%TYPE ,
33: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
34: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
35: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE,

Line 32: p_special_instructions IN ra_batches.special_instructions%TYPE ,

28: p_attribute14 IN ra_batches.attribute14%TYPE ,
29: p_attribute15 IN ra_batches.attribute15%TYPE ,
30: p_issue_date IN ra_batches.issue_date%TYPE ,
31: p_maturity_date IN ra_batches.maturity_date%TYPE ,
32: p_special_instructions IN ra_batches.special_instructions%TYPE ,
33: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
34: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
35: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE,
36: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,

Line 33: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,

29: p_attribute15 IN ra_batches.attribute15%TYPE ,
30: p_issue_date IN ra_batches.issue_date%TYPE ,
31: p_maturity_date IN ra_batches.maturity_date%TYPE ,
32: p_special_instructions IN ra_batches.special_instructions%TYPE ,
33: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
34: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
35: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE,
36: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,
37: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE,

Line 47: p_selection_criteria_id OUT NOCOPY ra_batches.selection_criteria_id%TYPE ,

43: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
44: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
45: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
46: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE ,
47: p_selection_criteria_id OUT NOCOPY ra_batches.selection_criteria_id%TYPE ,
48: p_batch_id OUT NOCOPY ra_batches.batch_id%TYPE ,
49: p_name IN OUT NOCOPY ra_batches.name%TYPE );
50:
51:

Line 48: p_batch_id OUT NOCOPY ra_batches.batch_id%TYPE ,

44: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
45: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
46: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE ,
47: p_selection_criteria_id OUT NOCOPY ra_batches.selection_criteria_id%TYPE ,
48: p_batch_id OUT NOCOPY ra_batches.batch_id%TYPE ,
49: p_name IN OUT NOCOPY ra_batches.name%TYPE );
50:
51:
52:

Line 49: p_name IN OUT NOCOPY ra_batches.name%TYPE );

45: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
46: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE ,
47: p_selection_criteria_id OUT NOCOPY ra_batches.selection_criteria_id%TYPE ,
48: p_batch_id OUT NOCOPY ra_batches.batch_id%TYPE ,
49: p_name IN OUT NOCOPY ra_batches.name%TYPE );
50:
51:
52:
53:

Line 57: p_batch_id IN ra_batches.batch_id%TYPE ,

53:
54: PROCEDURE update_batch (
55: p_form_name IN varchar2 ,
56: p_form_version IN number ,
57: p_batch_id IN ra_batches.batch_id%TYPE ,
58: p_name IN ra_batches.name%TYPE ,
59: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
60: p_batch_date IN ra_batches.batch_date%TYPE ,
61: p_gl_date IN ra_batches.gl_date%TYPE ,

Line 58: p_name IN ra_batches.name%TYPE ,

54: PROCEDURE update_batch (
55: p_form_name IN varchar2 ,
56: p_form_version IN number ,
57: p_batch_id IN ra_batches.batch_id%TYPE ,
58: p_name IN ra_batches.name%TYPE ,
59: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
60: p_batch_date IN ra_batches.batch_date%TYPE ,
61: p_gl_date IN ra_batches.gl_date%TYPE ,
62: p_TYPE IN ra_batches.TYPE%TYPE ,

Line 59: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,

55: p_form_name IN varchar2 ,
56: p_form_version IN number ,
57: p_batch_id IN ra_batches.batch_id%TYPE ,
58: p_name IN ra_batches.name%TYPE ,
59: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
60: p_batch_date IN ra_batches.batch_date%TYPE ,
61: p_gl_date IN ra_batches.gl_date%TYPE ,
62: p_TYPE IN ra_batches.TYPE%TYPE ,
63: p_currency_code IN ra_batches.currency_code%TYPE ,

Line 60: p_batch_date IN ra_batches.batch_date%TYPE ,

56: p_form_version IN number ,
57: p_batch_id IN ra_batches.batch_id%TYPE ,
58: p_name IN ra_batches.name%TYPE ,
59: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
60: p_batch_date IN ra_batches.batch_date%TYPE ,
61: p_gl_date IN ra_batches.gl_date%TYPE ,
62: p_TYPE IN ra_batches.TYPE%TYPE ,
63: p_currency_code IN ra_batches.currency_code%TYPE ,
64: p_comments IN ra_batches.comments%TYPE ,

Line 61: p_gl_date IN ra_batches.gl_date%TYPE ,

57: p_batch_id IN ra_batches.batch_id%TYPE ,
58: p_name IN ra_batches.name%TYPE ,
59: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
60: p_batch_date IN ra_batches.batch_date%TYPE ,
61: p_gl_date IN ra_batches.gl_date%TYPE ,
62: p_TYPE IN ra_batches.TYPE%TYPE ,
63: p_currency_code IN ra_batches.currency_code%TYPE ,
64: p_comments IN ra_batches.comments%TYPE ,
65: p_attribute_category IN ra_batches.attribute_category%TYPE ,

Line 62: p_TYPE IN ra_batches.TYPE%TYPE ,

58: p_name IN ra_batches.name%TYPE ,
59: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
60: p_batch_date IN ra_batches.batch_date%TYPE ,
61: p_gl_date IN ra_batches.gl_date%TYPE ,
62: p_TYPE IN ra_batches.TYPE%TYPE ,
63: p_currency_code IN ra_batches.currency_code%TYPE ,
64: p_comments IN ra_batches.comments%TYPE ,
65: p_attribute_category IN ra_batches.attribute_category%TYPE ,
66: p_attribute1 IN ra_batches.attribute1%TYPE ,

Line 63: p_currency_code IN ra_batches.currency_code%TYPE ,

59: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
60: p_batch_date IN ra_batches.batch_date%TYPE ,
61: p_gl_date IN ra_batches.gl_date%TYPE ,
62: p_TYPE IN ra_batches.TYPE%TYPE ,
63: p_currency_code IN ra_batches.currency_code%TYPE ,
64: p_comments IN ra_batches.comments%TYPE ,
65: p_attribute_category IN ra_batches.attribute_category%TYPE ,
66: p_attribute1 IN ra_batches.attribute1%TYPE ,
67: p_attribute2 IN ra_batches.attribute2%TYPE ,

Line 64: p_comments IN ra_batches.comments%TYPE ,

60: p_batch_date IN ra_batches.batch_date%TYPE ,
61: p_gl_date IN ra_batches.gl_date%TYPE ,
62: p_TYPE IN ra_batches.TYPE%TYPE ,
63: p_currency_code IN ra_batches.currency_code%TYPE ,
64: p_comments IN ra_batches.comments%TYPE ,
65: p_attribute_category IN ra_batches.attribute_category%TYPE ,
66: p_attribute1 IN ra_batches.attribute1%TYPE ,
67: p_attribute2 IN ra_batches.attribute2%TYPE ,
68: p_attribute3 IN ra_batches.attribute3%TYPE ,

Line 65: p_attribute_category IN ra_batches.attribute_category%TYPE ,

61: p_gl_date IN ra_batches.gl_date%TYPE ,
62: p_TYPE IN ra_batches.TYPE%TYPE ,
63: p_currency_code IN ra_batches.currency_code%TYPE ,
64: p_comments IN ra_batches.comments%TYPE ,
65: p_attribute_category IN ra_batches.attribute_category%TYPE ,
66: p_attribute1 IN ra_batches.attribute1%TYPE ,
67: p_attribute2 IN ra_batches.attribute2%TYPE ,
68: p_attribute3 IN ra_batches.attribute3%TYPE ,
69: p_attribute4 IN ra_batches.attribute4%TYPE ,

Line 66: p_attribute1 IN ra_batches.attribute1%TYPE ,

62: p_TYPE IN ra_batches.TYPE%TYPE ,
63: p_currency_code IN ra_batches.currency_code%TYPE ,
64: p_comments IN ra_batches.comments%TYPE ,
65: p_attribute_category IN ra_batches.attribute_category%TYPE ,
66: p_attribute1 IN ra_batches.attribute1%TYPE ,
67: p_attribute2 IN ra_batches.attribute2%TYPE ,
68: p_attribute3 IN ra_batches.attribute3%TYPE ,
69: p_attribute4 IN ra_batches.attribute4%TYPE ,
70: p_attribute5 IN ra_batches.attribute5%TYPE ,

Line 67: p_attribute2 IN ra_batches.attribute2%TYPE ,

63: p_currency_code IN ra_batches.currency_code%TYPE ,
64: p_comments IN ra_batches.comments%TYPE ,
65: p_attribute_category IN ra_batches.attribute_category%TYPE ,
66: p_attribute1 IN ra_batches.attribute1%TYPE ,
67: p_attribute2 IN ra_batches.attribute2%TYPE ,
68: p_attribute3 IN ra_batches.attribute3%TYPE ,
69: p_attribute4 IN ra_batches.attribute4%TYPE ,
70: p_attribute5 IN ra_batches.attribute5%TYPE ,
71: p_attribute6 IN ra_batches.attribute6%TYPE ,

Line 68: p_attribute3 IN ra_batches.attribute3%TYPE ,

64: p_comments IN ra_batches.comments%TYPE ,
65: p_attribute_category IN ra_batches.attribute_category%TYPE ,
66: p_attribute1 IN ra_batches.attribute1%TYPE ,
67: p_attribute2 IN ra_batches.attribute2%TYPE ,
68: p_attribute3 IN ra_batches.attribute3%TYPE ,
69: p_attribute4 IN ra_batches.attribute4%TYPE ,
70: p_attribute5 IN ra_batches.attribute5%TYPE ,
71: p_attribute6 IN ra_batches.attribute6%TYPE ,
72: p_attribute7 IN ra_batches.attribute7%TYPE ,

Line 69: p_attribute4 IN ra_batches.attribute4%TYPE ,

65: p_attribute_category IN ra_batches.attribute_category%TYPE ,
66: p_attribute1 IN ra_batches.attribute1%TYPE ,
67: p_attribute2 IN ra_batches.attribute2%TYPE ,
68: p_attribute3 IN ra_batches.attribute3%TYPE ,
69: p_attribute4 IN ra_batches.attribute4%TYPE ,
70: p_attribute5 IN ra_batches.attribute5%TYPE ,
71: p_attribute6 IN ra_batches.attribute6%TYPE ,
72: p_attribute7 IN ra_batches.attribute7%TYPE ,
73: p_attribute8 IN ra_batches.attribute8%TYPE ,

Line 70: p_attribute5 IN ra_batches.attribute5%TYPE ,

66: p_attribute1 IN ra_batches.attribute1%TYPE ,
67: p_attribute2 IN ra_batches.attribute2%TYPE ,
68: p_attribute3 IN ra_batches.attribute3%TYPE ,
69: p_attribute4 IN ra_batches.attribute4%TYPE ,
70: p_attribute5 IN ra_batches.attribute5%TYPE ,
71: p_attribute6 IN ra_batches.attribute6%TYPE ,
72: p_attribute7 IN ra_batches.attribute7%TYPE ,
73: p_attribute8 IN ra_batches.attribute8%TYPE ,
74: p_attribute9 IN ra_batches.attribute9%TYPE ,

Line 71: p_attribute6 IN ra_batches.attribute6%TYPE ,

67: p_attribute2 IN ra_batches.attribute2%TYPE ,
68: p_attribute3 IN ra_batches.attribute3%TYPE ,
69: p_attribute4 IN ra_batches.attribute4%TYPE ,
70: p_attribute5 IN ra_batches.attribute5%TYPE ,
71: p_attribute6 IN ra_batches.attribute6%TYPE ,
72: p_attribute7 IN ra_batches.attribute7%TYPE ,
73: p_attribute8 IN ra_batches.attribute8%TYPE ,
74: p_attribute9 IN ra_batches.attribute9%TYPE ,
75: p_attribute10 IN ra_batches.attribute10%TYPE ,

Line 72: p_attribute7 IN ra_batches.attribute7%TYPE ,

68: p_attribute3 IN ra_batches.attribute3%TYPE ,
69: p_attribute4 IN ra_batches.attribute4%TYPE ,
70: p_attribute5 IN ra_batches.attribute5%TYPE ,
71: p_attribute6 IN ra_batches.attribute6%TYPE ,
72: p_attribute7 IN ra_batches.attribute7%TYPE ,
73: p_attribute8 IN ra_batches.attribute8%TYPE ,
74: p_attribute9 IN ra_batches.attribute9%TYPE ,
75: p_attribute10 IN ra_batches.attribute10%TYPE ,
76: p_attribute11 IN ra_batches.attribute11%TYPE ,

Line 73: p_attribute8 IN ra_batches.attribute8%TYPE ,

69: p_attribute4 IN ra_batches.attribute4%TYPE ,
70: p_attribute5 IN ra_batches.attribute5%TYPE ,
71: p_attribute6 IN ra_batches.attribute6%TYPE ,
72: p_attribute7 IN ra_batches.attribute7%TYPE ,
73: p_attribute8 IN ra_batches.attribute8%TYPE ,
74: p_attribute9 IN ra_batches.attribute9%TYPE ,
75: p_attribute10 IN ra_batches.attribute10%TYPE ,
76: p_attribute11 IN ra_batches.attribute11%TYPE ,
77: p_attribute12 IN ra_batches.attribute12%TYPE ,

Line 74: p_attribute9 IN ra_batches.attribute9%TYPE ,

70: p_attribute5 IN ra_batches.attribute5%TYPE ,
71: p_attribute6 IN ra_batches.attribute6%TYPE ,
72: p_attribute7 IN ra_batches.attribute7%TYPE ,
73: p_attribute8 IN ra_batches.attribute8%TYPE ,
74: p_attribute9 IN ra_batches.attribute9%TYPE ,
75: p_attribute10 IN ra_batches.attribute10%TYPE ,
76: p_attribute11 IN ra_batches.attribute11%TYPE ,
77: p_attribute12 IN ra_batches.attribute12%TYPE ,
78: p_attribute13 IN ra_batches.attribute13%TYPE ,

Line 75: p_attribute10 IN ra_batches.attribute10%TYPE ,

71: p_attribute6 IN ra_batches.attribute6%TYPE ,
72: p_attribute7 IN ra_batches.attribute7%TYPE ,
73: p_attribute8 IN ra_batches.attribute8%TYPE ,
74: p_attribute9 IN ra_batches.attribute9%TYPE ,
75: p_attribute10 IN ra_batches.attribute10%TYPE ,
76: p_attribute11 IN ra_batches.attribute11%TYPE ,
77: p_attribute12 IN ra_batches.attribute12%TYPE ,
78: p_attribute13 IN ra_batches.attribute13%TYPE ,
79: p_attribute14 IN ra_batches.attribute14%TYPE ,

Line 76: p_attribute11 IN ra_batches.attribute11%TYPE ,

72: p_attribute7 IN ra_batches.attribute7%TYPE ,
73: p_attribute8 IN ra_batches.attribute8%TYPE ,
74: p_attribute9 IN ra_batches.attribute9%TYPE ,
75: p_attribute10 IN ra_batches.attribute10%TYPE ,
76: p_attribute11 IN ra_batches.attribute11%TYPE ,
77: p_attribute12 IN ra_batches.attribute12%TYPE ,
78: p_attribute13 IN ra_batches.attribute13%TYPE ,
79: p_attribute14 IN ra_batches.attribute14%TYPE ,
80: p_attribute15 IN ra_batches.attribute15%TYPE ,

Line 77: p_attribute12 IN ra_batches.attribute12%TYPE ,

73: p_attribute8 IN ra_batches.attribute8%TYPE ,
74: p_attribute9 IN ra_batches.attribute9%TYPE ,
75: p_attribute10 IN ra_batches.attribute10%TYPE ,
76: p_attribute11 IN ra_batches.attribute11%TYPE ,
77: p_attribute12 IN ra_batches.attribute12%TYPE ,
78: p_attribute13 IN ra_batches.attribute13%TYPE ,
79: p_attribute14 IN ra_batches.attribute14%TYPE ,
80: p_attribute15 IN ra_batches.attribute15%TYPE ,
81: p_issue_date IN ra_batches.issue_date%TYPE ,

Line 78: p_attribute13 IN ra_batches.attribute13%TYPE ,

74: p_attribute9 IN ra_batches.attribute9%TYPE ,
75: p_attribute10 IN ra_batches.attribute10%TYPE ,
76: p_attribute11 IN ra_batches.attribute11%TYPE ,
77: p_attribute12 IN ra_batches.attribute12%TYPE ,
78: p_attribute13 IN ra_batches.attribute13%TYPE ,
79: p_attribute14 IN ra_batches.attribute14%TYPE ,
80: p_attribute15 IN ra_batches.attribute15%TYPE ,
81: p_issue_date IN ra_batches.issue_date%TYPE ,
82: p_maturity_date IN ra_batches.maturity_date%TYPE ,

Line 79: p_attribute14 IN ra_batches.attribute14%TYPE ,

75: p_attribute10 IN ra_batches.attribute10%TYPE ,
76: p_attribute11 IN ra_batches.attribute11%TYPE ,
77: p_attribute12 IN ra_batches.attribute12%TYPE ,
78: p_attribute13 IN ra_batches.attribute13%TYPE ,
79: p_attribute14 IN ra_batches.attribute14%TYPE ,
80: p_attribute15 IN ra_batches.attribute15%TYPE ,
81: p_issue_date IN ra_batches.issue_date%TYPE ,
82: p_maturity_date IN ra_batches.maturity_date%TYPE ,
83: p_special_instructions IN ra_batches.special_instructions%TYPE ,

Line 80: p_attribute15 IN ra_batches.attribute15%TYPE ,

76: p_attribute11 IN ra_batches.attribute11%TYPE ,
77: p_attribute12 IN ra_batches.attribute12%TYPE ,
78: p_attribute13 IN ra_batches.attribute13%TYPE ,
79: p_attribute14 IN ra_batches.attribute14%TYPE ,
80: p_attribute15 IN ra_batches.attribute15%TYPE ,
81: p_issue_date IN ra_batches.issue_date%TYPE ,
82: p_maturity_date IN ra_batches.maturity_date%TYPE ,
83: p_special_instructions IN ra_batches.special_instructions%TYPE ,
84: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,

Line 81: p_issue_date IN ra_batches.issue_date%TYPE ,

77: p_attribute12 IN ra_batches.attribute12%TYPE ,
78: p_attribute13 IN ra_batches.attribute13%TYPE ,
79: p_attribute14 IN ra_batches.attribute14%TYPE ,
80: p_attribute15 IN ra_batches.attribute15%TYPE ,
81: p_issue_date IN ra_batches.issue_date%TYPE ,
82: p_maturity_date IN ra_batches.maturity_date%TYPE ,
83: p_special_instructions IN ra_batches.special_instructions%TYPE ,
84: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
85: p_request_id IN ra_batches.request_id%TYPE ,

Line 82: p_maturity_date IN ra_batches.maturity_date%TYPE ,

78: p_attribute13 IN ra_batches.attribute13%TYPE ,
79: p_attribute14 IN ra_batches.attribute14%TYPE ,
80: p_attribute15 IN ra_batches.attribute15%TYPE ,
81: p_issue_date IN ra_batches.issue_date%TYPE ,
82: p_maturity_date IN ra_batches.maturity_date%TYPE ,
83: p_special_instructions IN ra_batches.special_instructions%TYPE ,
84: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
85: p_request_id IN ra_batches.request_id%TYPE ,
86: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,

Line 83: p_special_instructions IN ra_batches.special_instructions%TYPE ,

79: p_attribute14 IN ra_batches.attribute14%TYPE ,
80: p_attribute15 IN ra_batches.attribute15%TYPE ,
81: p_issue_date IN ra_batches.issue_date%TYPE ,
82: p_maturity_date IN ra_batches.maturity_date%TYPE ,
83: p_special_instructions IN ra_batches.special_instructions%TYPE ,
84: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
85: p_request_id IN ra_batches.request_id%TYPE ,
86: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
87: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE,

Line 84: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,

80: p_attribute15 IN ra_batches.attribute15%TYPE ,
81: p_issue_date IN ra_batches.issue_date%TYPE ,
82: p_maturity_date IN ra_batches.maturity_date%TYPE ,
83: p_special_instructions IN ra_batches.special_instructions%TYPE ,
84: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
85: p_request_id IN ra_batches.request_id%TYPE ,
86: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
87: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE,
88: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,

Line 85: p_request_id IN ra_batches.request_id%TYPE ,

81: p_issue_date IN ra_batches.issue_date%TYPE ,
82: p_maturity_date IN ra_batches.maturity_date%TYPE ,
83: p_special_instructions IN ra_batches.special_instructions%TYPE ,
84: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
85: p_request_id IN ra_batches.request_id%TYPE ,
86: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
87: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE,
88: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,
89: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE,

Line 106: p_batch_id IN ra_batches.batch_id%TYPE ,

102:
103: PROCEDURE delete_batch (
104: p_form_name IN varchar2 ,
105: p_form_version IN number ,
106: p_batch_id IN ra_batches.batch_id%TYPE ,
107: p_selection_criteria_id IN ar_selection_criteria.selection_criteria_id%TYPE);
108:
109:
110:

Line 114: p_batch_id IN ra_batches.batch_id%TYPE ,

110:
111: PROCEDURE lock_compare_batch (
112: p_form_name IN varchar2 ,
113: p_form_version IN number ,
114: p_batch_id IN ra_batches.batch_id%TYPE ,
115: p_name IN ra_batches.name%TYPE ,
116: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
117: p_batch_date IN ra_batches.batch_date%TYPE ,
118: p_gl_date IN ra_batches.gl_date%TYPE ,

Line 115: p_name IN ra_batches.name%TYPE ,

111: PROCEDURE lock_compare_batch (
112: p_form_name IN varchar2 ,
113: p_form_version IN number ,
114: p_batch_id IN ra_batches.batch_id%TYPE ,
115: p_name IN ra_batches.name%TYPE ,
116: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
117: p_batch_date IN ra_batches.batch_date%TYPE ,
118: p_gl_date IN ra_batches.gl_date%TYPE ,
119: p_TYPE IN ra_batches.TYPE%TYPE ,

Line 116: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,

112: p_form_name IN varchar2 ,
113: p_form_version IN number ,
114: p_batch_id IN ra_batches.batch_id%TYPE ,
115: p_name IN ra_batches.name%TYPE ,
116: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
117: p_batch_date IN ra_batches.batch_date%TYPE ,
118: p_gl_date IN ra_batches.gl_date%TYPE ,
119: p_TYPE IN ra_batches.TYPE%TYPE ,
120: p_currency_code IN ra_batches.currency_code%TYPE ,

Line 117: p_batch_date IN ra_batches.batch_date%TYPE ,

113: p_form_version IN number ,
114: p_batch_id IN ra_batches.batch_id%TYPE ,
115: p_name IN ra_batches.name%TYPE ,
116: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
117: p_batch_date IN ra_batches.batch_date%TYPE ,
118: p_gl_date IN ra_batches.gl_date%TYPE ,
119: p_TYPE IN ra_batches.TYPE%TYPE ,
120: p_currency_code IN ra_batches.currency_code%TYPE ,
121: p_comments IN ra_batches.comments%TYPE ,

Line 118: p_gl_date IN ra_batches.gl_date%TYPE ,

114: p_batch_id IN ra_batches.batch_id%TYPE ,
115: p_name IN ra_batches.name%TYPE ,
116: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
117: p_batch_date IN ra_batches.batch_date%TYPE ,
118: p_gl_date IN ra_batches.gl_date%TYPE ,
119: p_TYPE IN ra_batches.TYPE%TYPE ,
120: p_currency_code IN ra_batches.currency_code%TYPE ,
121: p_comments IN ra_batches.comments%TYPE ,
122: p_attribute_category IN ra_batches.attribute_category%TYPE,

Line 119: p_TYPE IN ra_batches.TYPE%TYPE ,

115: p_name IN ra_batches.name%TYPE ,
116: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
117: p_batch_date IN ra_batches.batch_date%TYPE ,
118: p_gl_date IN ra_batches.gl_date%TYPE ,
119: p_TYPE IN ra_batches.TYPE%TYPE ,
120: p_currency_code IN ra_batches.currency_code%TYPE ,
121: p_comments IN ra_batches.comments%TYPE ,
122: p_attribute_category IN ra_batches.attribute_category%TYPE,
123: p_attribute1 IN ra_batches.attribute1%TYPE ,

Line 120: p_currency_code IN ra_batches.currency_code%TYPE ,

116: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
117: p_batch_date IN ra_batches.batch_date%TYPE ,
118: p_gl_date IN ra_batches.gl_date%TYPE ,
119: p_TYPE IN ra_batches.TYPE%TYPE ,
120: p_currency_code IN ra_batches.currency_code%TYPE ,
121: p_comments IN ra_batches.comments%TYPE ,
122: p_attribute_category IN ra_batches.attribute_category%TYPE,
123: p_attribute1 IN ra_batches.attribute1%TYPE ,
124: p_attribute2 IN ra_batches.attribute2%TYPE ,

Line 121: p_comments IN ra_batches.comments%TYPE ,

117: p_batch_date IN ra_batches.batch_date%TYPE ,
118: p_gl_date IN ra_batches.gl_date%TYPE ,
119: p_TYPE IN ra_batches.TYPE%TYPE ,
120: p_currency_code IN ra_batches.currency_code%TYPE ,
121: p_comments IN ra_batches.comments%TYPE ,
122: p_attribute_category IN ra_batches.attribute_category%TYPE,
123: p_attribute1 IN ra_batches.attribute1%TYPE ,
124: p_attribute2 IN ra_batches.attribute2%TYPE ,
125: p_attribute3 IN ra_batches.attribute3%TYPE ,

Line 122: p_attribute_category IN ra_batches.attribute_category%TYPE,

118: p_gl_date IN ra_batches.gl_date%TYPE ,
119: p_TYPE IN ra_batches.TYPE%TYPE ,
120: p_currency_code IN ra_batches.currency_code%TYPE ,
121: p_comments IN ra_batches.comments%TYPE ,
122: p_attribute_category IN ra_batches.attribute_category%TYPE,
123: p_attribute1 IN ra_batches.attribute1%TYPE ,
124: p_attribute2 IN ra_batches.attribute2%TYPE ,
125: p_attribute3 IN ra_batches.attribute3%TYPE ,
126: p_attribute4 IN ra_batches.attribute4%TYPE ,

Line 123: p_attribute1 IN ra_batches.attribute1%TYPE ,

119: p_TYPE IN ra_batches.TYPE%TYPE ,
120: p_currency_code IN ra_batches.currency_code%TYPE ,
121: p_comments IN ra_batches.comments%TYPE ,
122: p_attribute_category IN ra_batches.attribute_category%TYPE,
123: p_attribute1 IN ra_batches.attribute1%TYPE ,
124: p_attribute2 IN ra_batches.attribute2%TYPE ,
125: p_attribute3 IN ra_batches.attribute3%TYPE ,
126: p_attribute4 IN ra_batches.attribute4%TYPE ,
127: p_attribute5 IN ra_batches.attribute5%TYPE ,

Line 124: p_attribute2 IN ra_batches.attribute2%TYPE ,

120: p_currency_code IN ra_batches.currency_code%TYPE ,
121: p_comments IN ra_batches.comments%TYPE ,
122: p_attribute_category IN ra_batches.attribute_category%TYPE,
123: p_attribute1 IN ra_batches.attribute1%TYPE ,
124: p_attribute2 IN ra_batches.attribute2%TYPE ,
125: p_attribute3 IN ra_batches.attribute3%TYPE ,
126: p_attribute4 IN ra_batches.attribute4%TYPE ,
127: p_attribute5 IN ra_batches.attribute5%TYPE ,
128: p_attribute6 IN ra_batches.attribute6%TYPE ,

Line 125: p_attribute3 IN ra_batches.attribute3%TYPE ,

121: p_comments IN ra_batches.comments%TYPE ,
122: p_attribute_category IN ra_batches.attribute_category%TYPE,
123: p_attribute1 IN ra_batches.attribute1%TYPE ,
124: p_attribute2 IN ra_batches.attribute2%TYPE ,
125: p_attribute3 IN ra_batches.attribute3%TYPE ,
126: p_attribute4 IN ra_batches.attribute4%TYPE ,
127: p_attribute5 IN ra_batches.attribute5%TYPE ,
128: p_attribute6 IN ra_batches.attribute6%TYPE ,
129: p_attribute7 IN ra_batches.attribute7%TYPE ,

Line 126: p_attribute4 IN ra_batches.attribute4%TYPE ,

122: p_attribute_category IN ra_batches.attribute_category%TYPE,
123: p_attribute1 IN ra_batches.attribute1%TYPE ,
124: p_attribute2 IN ra_batches.attribute2%TYPE ,
125: p_attribute3 IN ra_batches.attribute3%TYPE ,
126: p_attribute4 IN ra_batches.attribute4%TYPE ,
127: p_attribute5 IN ra_batches.attribute5%TYPE ,
128: p_attribute6 IN ra_batches.attribute6%TYPE ,
129: p_attribute7 IN ra_batches.attribute7%TYPE ,
130: p_attribute8 IN ra_batches.attribute8%TYPE ,

Line 127: p_attribute5 IN ra_batches.attribute5%TYPE ,

123: p_attribute1 IN ra_batches.attribute1%TYPE ,
124: p_attribute2 IN ra_batches.attribute2%TYPE ,
125: p_attribute3 IN ra_batches.attribute3%TYPE ,
126: p_attribute4 IN ra_batches.attribute4%TYPE ,
127: p_attribute5 IN ra_batches.attribute5%TYPE ,
128: p_attribute6 IN ra_batches.attribute6%TYPE ,
129: p_attribute7 IN ra_batches.attribute7%TYPE ,
130: p_attribute8 IN ra_batches.attribute8%TYPE ,
131: p_attribute9 IN ra_batches.attribute9%TYPE ,

Line 128: p_attribute6 IN ra_batches.attribute6%TYPE ,

124: p_attribute2 IN ra_batches.attribute2%TYPE ,
125: p_attribute3 IN ra_batches.attribute3%TYPE ,
126: p_attribute4 IN ra_batches.attribute4%TYPE ,
127: p_attribute5 IN ra_batches.attribute5%TYPE ,
128: p_attribute6 IN ra_batches.attribute6%TYPE ,
129: p_attribute7 IN ra_batches.attribute7%TYPE ,
130: p_attribute8 IN ra_batches.attribute8%TYPE ,
131: p_attribute9 IN ra_batches.attribute9%TYPE ,
132: p_attribute10 IN ra_batches.attribute10%TYPE ,

Line 129: p_attribute7 IN ra_batches.attribute7%TYPE ,

125: p_attribute3 IN ra_batches.attribute3%TYPE ,
126: p_attribute4 IN ra_batches.attribute4%TYPE ,
127: p_attribute5 IN ra_batches.attribute5%TYPE ,
128: p_attribute6 IN ra_batches.attribute6%TYPE ,
129: p_attribute7 IN ra_batches.attribute7%TYPE ,
130: p_attribute8 IN ra_batches.attribute8%TYPE ,
131: p_attribute9 IN ra_batches.attribute9%TYPE ,
132: p_attribute10 IN ra_batches.attribute10%TYPE ,
133: p_attribute11 IN ra_batches.attribute11%TYPE ,

Line 130: p_attribute8 IN ra_batches.attribute8%TYPE ,

126: p_attribute4 IN ra_batches.attribute4%TYPE ,
127: p_attribute5 IN ra_batches.attribute5%TYPE ,
128: p_attribute6 IN ra_batches.attribute6%TYPE ,
129: p_attribute7 IN ra_batches.attribute7%TYPE ,
130: p_attribute8 IN ra_batches.attribute8%TYPE ,
131: p_attribute9 IN ra_batches.attribute9%TYPE ,
132: p_attribute10 IN ra_batches.attribute10%TYPE ,
133: p_attribute11 IN ra_batches.attribute11%TYPE ,
134: p_attribute12 IN ra_batches.attribute12%TYPE ,

Line 131: p_attribute9 IN ra_batches.attribute9%TYPE ,

127: p_attribute5 IN ra_batches.attribute5%TYPE ,
128: p_attribute6 IN ra_batches.attribute6%TYPE ,
129: p_attribute7 IN ra_batches.attribute7%TYPE ,
130: p_attribute8 IN ra_batches.attribute8%TYPE ,
131: p_attribute9 IN ra_batches.attribute9%TYPE ,
132: p_attribute10 IN ra_batches.attribute10%TYPE ,
133: p_attribute11 IN ra_batches.attribute11%TYPE ,
134: p_attribute12 IN ra_batches.attribute12%TYPE ,
135: p_attribute13 IN ra_batches.attribute13%TYPE ,

Line 132: p_attribute10 IN ra_batches.attribute10%TYPE ,

128: p_attribute6 IN ra_batches.attribute6%TYPE ,
129: p_attribute7 IN ra_batches.attribute7%TYPE ,
130: p_attribute8 IN ra_batches.attribute8%TYPE ,
131: p_attribute9 IN ra_batches.attribute9%TYPE ,
132: p_attribute10 IN ra_batches.attribute10%TYPE ,
133: p_attribute11 IN ra_batches.attribute11%TYPE ,
134: p_attribute12 IN ra_batches.attribute12%TYPE ,
135: p_attribute13 IN ra_batches.attribute13%TYPE ,
136: p_attribute14 IN ra_batches.attribute14%TYPE ,

Line 133: p_attribute11 IN ra_batches.attribute11%TYPE ,

129: p_attribute7 IN ra_batches.attribute7%TYPE ,
130: p_attribute8 IN ra_batches.attribute8%TYPE ,
131: p_attribute9 IN ra_batches.attribute9%TYPE ,
132: p_attribute10 IN ra_batches.attribute10%TYPE ,
133: p_attribute11 IN ra_batches.attribute11%TYPE ,
134: p_attribute12 IN ra_batches.attribute12%TYPE ,
135: p_attribute13 IN ra_batches.attribute13%TYPE ,
136: p_attribute14 IN ra_batches.attribute14%TYPE ,
137: p_attribute15 IN ra_batches.attribute15%TYPE ,

Line 134: p_attribute12 IN ra_batches.attribute12%TYPE ,

130: p_attribute8 IN ra_batches.attribute8%TYPE ,
131: p_attribute9 IN ra_batches.attribute9%TYPE ,
132: p_attribute10 IN ra_batches.attribute10%TYPE ,
133: p_attribute11 IN ra_batches.attribute11%TYPE ,
134: p_attribute12 IN ra_batches.attribute12%TYPE ,
135: p_attribute13 IN ra_batches.attribute13%TYPE ,
136: p_attribute14 IN ra_batches.attribute14%TYPE ,
137: p_attribute15 IN ra_batches.attribute15%TYPE ,
138: p_issue_date IN ra_batches.issue_date%TYPE ,

Line 135: p_attribute13 IN ra_batches.attribute13%TYPE ,

131: p_attribute9 IN ra_batches.attribute9%TYPE ,
132: p_attribute10 IN ra_batches.attribute10%TYPE ,
133: p_attribute11 IN ra_batches.attribute11%TYPE ,
134: p_attribute12 IN ra_batches.attribute12%TYPE ,
135: p_attribute13 IN ra_batches.attribute13%TYPE ,
136: p_attribute14 IN ra_batches.attribute14%TYPE ,
137: p_attribute15 IN ra_batches.attribute15%TYPE ,
138: p_issue_date IN ra_batches.issue_date%TYPE ,
139: p_maturity_date IN ra_batches.maturity_date%TYPE ,

Line 136: p_attribute14 IN ra_batches.attribute14%TYPE ,

132: p_attribute10 IN ra_batches.attribute10%TYPE ,
133: p_attribute11 IN ra_batches.attribute11%TYPE ,
134: p_attribute12 IN ra_batches.attribute12%TYPE ,
135: p_attribute13 IN ra_batches.attribute13%TYPE ,
136: p_attribute14 IN ra_batches.attribute14%TYPE ,
137: p_attribute15 IN ra_batches.attribute15%TYPE ,
138: p_issue_date IN ra_batches.issue_date%TYPE ,
139: p_maturity_date IN ra_batches.maturity_date%TYPE ,
140: p_special_instructions IN ra_batches.special_instructions%TYPE ,

Line 137: p_attribute15 IN ra_batches.attribute15%TYPE ,

133: p_attribute11 IN ra_batches.attribute11%TYPE ,
134: p_attribute12 IN ra_batches.attribute12%TYPE ,
135: p_attribute13 IN ra_batches.attribute13%TYPE ,
136: p_attribute14 IN ra_batches.attribute14%TYPE ,
137: p_attribute15 IN ra_batches.attribute15%TYPE ,
138: p_issue_date IN ra_batches.issue_date%TYPE ,
139: p_maturity_date IN ra_batches.maturity_date%TYPE ,
140: p_special_instructions IN ra_batches.special_instructions%TYPE ,
141: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,

Line 138: p_issue_date IN ra_batches.issue_date%TYPE ,

134: p_attribute12 IN ra_batches.attribute12%TYPE ,
135: p_attribute13 IN ra_batches.attribute13%TYPE ,
136: p_attribute14 IN ra_batches.attribute14%TYPE ,
137: p_attribute15 IN ra_batches.attribute15%TYPE ,
138: p_issue_date IN ra_batches.issue_date%TYPE ,
139: p_maturity_date IN ra_batches.maturity_date%TYPE ,
140: p_special_instructions IN ra_batches.special_instructions%TYPE ,
141: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
142: p_selection_criteria_id IN ar_selection_criteria.selection_criteria_id%TYPE,

Line 139: p_maturity_date IN ra_batches.maturity_date%TYPE ,

135: p_attribute13 IN ra_batches.attribute13%TYPE ,
136: p_attribute14 IN ra_batches.attribute14%TYPE ,
137: p_attribute15 IN ra_batches.attribute15%TYPE ,
138: p_issue_date IN ra_batches.issue_date%TYPE ,
139: p_maturity_date IN ra_batches.maturity_date%TYPE ,
140: p_special_instructions IN ra_batches.special_instructions%TYPE ,
141: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
142: p_selection_criteria_id IN ar_selection_criteria.selection_criteria_id%TYPE,
143: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,

Line 140: p_special_instructions IN ra_batches.special_instructions%TYPE ,

136: p_attribute14 IN ra_batches.attribute14%TYPE ,
137: p_attribute15 IN ra_batches.attribute15%TYPE ,
138: p_issue_date IN ra_batches.issue_date%TYPE ,
139: p_maturity_date IN ra_batches.maturity_date%TYPE ,
140: p_special_instructions IN ra_batches.special_instructions%TYPE ,
141: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
142: p_selection_criteria_id IN ar_selection_criteria.selection_criteria_id%TYPE,
143: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
144: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE ,

Line 141: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,

137: p_attribute15 IN ra_batches.attribute15%TYPE ,
138: p_issue_date IN ra_batches.issue_date%TYPE ,
139: p_maturity_date IN ra_batches.maturity_date%TYPE ,
140: p_special_instructions IN ra_batches.special_instructions%TYPE ,
141: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
142: p_selection_criteria_id IN ar_selection_criteria.selection_criteria_id%TYPE,
143: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
144: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE ,
145: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,

Line 168: p_batch_id IN RA_BATCHES.batch_id%TYPE ,

164: PROCEDURE br_create(
165: p_call IN NUMBER ,
166: p_draft_mode IN VARCHAR2 ,
167: p_print_flag IN VARCHAR2 ,
168: p_batch_id IN RA_BATCHES.batch_id%TYPE ,
169: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE ,
170: p_batch_date IN RA_BATCHES.batch_date%TYPE ,
171: p_gl_date IN RA_BATCHES.gl_date%TYPE ,
172: p_issue_date IN RA_BATCHES.issue_date%TYPE ,

Line 169: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE ,

165: p_call IN NUMBER ,
166: p_draft_mode IN VARCHAR2 ,
167: p_print_flag IN VARCHAR2 ,
168: p_batch_id IN RA_BATCHES.batch_id%TYPE ,
169: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE ,
170: p_batch_date IN RA_BATCHES.batch_date%TYPE ,
171: p_gl_date IN RA_BATCHES.gl_date%TYPE ,
172: p_issue_date IN RA_BATCHES.issue_date%TYPE ,
173: p_maturity_date IN RA_BATCHES.maturity_date%TYPE ,

Line 170: p_batch_date IN RA_BATCHES.batch_date%TYPE ,

166: p_draft_mode IN VARCHAR2 ,
167: p_print_flag IN VARCHAR2 ,
168: p_batch_id IN RA_BATCHES.batch_id%TYPE ,
169: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE ,
170: p_batch_date IN RA_BATCHES.batch_date%TYPE ,
171: p_gl_date IN RA_BATCHES.gl_date%TYPE ,
172: p_issue_date IN RA_BATCHES.issue_date%TYPE ,
173: p_maturity_date IN RA_BATCHES.maturity_date%TYPE ,
174: p_currency_code IN RA_BATCHES.currency_code%TYPE ,

Line 171: p_gl_date IN RA_BATCHES.gl_date%TYPE ,

167: p_print_flag IN VARCHAR2 ,
168: p_batch_id IN RA_BATCHES.batch_id%TYPE ,
169: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE ,
170: p_batch_date IN RA_BATCHES.batch_date%TYPE ,
171: p_gl_date IN RA_BATCHES.gl_date%TYPE ,
172: p_issue_date IN RA_BATCHES.issue_date%TYPE ,
173: p_maturity_date IN RA_BATCHES.maturity_date%TYPE ,
174: p_currency_code IN RA_BATCHES.currency_code%TYPE ,
175: p_comments IN RA_BATCHES.comments%TYPE ,

Line 172: p_issue_date IN RA_BATCHES.issue_date%TYPE ,

168: p_batch_id IN RA_BATCHES.batch_id%TYPE ,
169: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE ,
170: p_batch_date IN RA_BATCHES.batch_date%TYPE ,
171: p_gl_date IN RA_BATCHES.gl_date%TYPE ,
172: p_issue_date IN RA_BATCHES.issue_date%TYPE ,
173: p_maturity_date IN RA_BATCHES.maturity_date%TYPE ,
174: p_currency_code IN RA_BATCHES.currency_code%TYPE ,
175: p_comments IN RA_BATCHES.comments%TYPE ,
176: p_special_instructions IN RA_BATCHES.special_instructions%TYPE ,

Line 173: p_maturity_date IN RA_BATCHES.maturity_date%TYPE ,

169: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE ,
170: p_batch_date IN RA_BATCHES.batch_date%TYPE ,
171: p_gl_date IN RA_BATCHES.gl_date%TYPE ,
172: p_issue_date IN RA_BATCHES.issue_date%TYPE ,
173: p_maturity_date IN RA_BATCHES.maturity_date%TYPE ,
174: p_currency_code IN RA_BATCHES.currency_code%TYPE ,
175: p_comments IN RA_BATCHES.comments%TYPE ,
176: p_special_instructions IN RA_BATCHES.special_instructions%TYPE ,
177: p_attribute_category IN RA_BATCHES.attribute_category%TYPE ,

Line 174: p_currency_code IN RA_BATCHES.currency_code%TYPE ,

170: p_batch_date IN RA_BATCHES.batch_date%TYPE ,
171: p_gl_date IN RA_BATCHES.gl_date%TYPE ,
172: p_issue_date IN RA_BATCHES.issue_date%TYPE ,
173: p_maturity_date IN RA_BATCHES.maturity_date%TYPE ,
174: p_currency_code IN RA_BATCHES.currency_code%TYPE ,
175: p_comments IN RA_BATCHES.comments%TYPE ,
176: p_special_instructions IN RA_BATCHES.special_instructions%TYPE ,
177: p_attribute_category IN RA_BATCHES.attribute_category%TYPE ,
178: p_attribute1 IN VARCHAR2 ,

Line 175: p_comments IN RA_BATCHES.comments%TYPE ,

171: p_gl_date IN RA_BATCHES.gl_date%TYPE ,
172: p_issue_date IN RA_BATCHES.issue_date%TYPE ,
173: p_maturity_date IN RA_BATCHES.maturity_date%TYPE ,
174: p_currency_code IN RA_BATCHES.currency_code%TYPE ,
175: p_comments IN RA_BATCHES.comments%TYPE ,
176: p_special_instructions IN RA_BATCHES.special_instructions%TYPE ,
177: p_attribute_category IN RA_BATCHES.attribute_category%TYPE ,
178: p_attribute1 IN VARCHAR2 ,
179: p_attribute2 IN VARCHAR2 ,

Line 176: p_special_instructions IN RA_BATCHES.special_instructions%TYPE ,

172: p_issue_date IN RA_BATCHES.issue_date%TYPE ,
173: p_maturity_date IN RA_BATCHES.maturity_date%TYPE ,
174: p_currency_code IN RA_BATCHES.currency_code%TYPE ,
175: p_comments IN RA_BATCHES.comments%TYPE ,
176: p_special_instructions IN RA_BATCHES.special_instructions%TYPE ,
177: p_attribute_category IN RA_BATCHES.attribute_category%TYPE ,
178: p_attribute1 IN VARCHAR2 ,
179: p_attribute2 IN VARCHAR2 ,
180: p_attribute3 IN VARCHAR2 ,

Line 177: p_attribute_category IN RA_BATCHES.attribute_category%TYPE ,

173: p_maturity_date IN RA_BATCHES.maturity_date%TYPE ,
174: p_currency_code IN RA_BATCHES.currency_code%TYPE ,
175: p_comments IN RA_BATCHES.comments%TYPE ,
176: p_special_instructions IN RA_BATCHES.special_instructions%TYPE ,
177: p_attribute_category IN RA_BATCHES.attribute_category%TYPE ,
178: p_attribute1 IN VARCHAR2 ,
179: p_attribute2 IN VARCHAR2 ,
180: p_attribute3 IN VARCHAR2 ,
181: p_attribute4 IN VARCHAR2 ,