[Home] [Help]
5:
6:
7: PROCEDURE validate_args_insert_manual(
8: p_row_id IN VARCHAR2,
9: p_batch_id IN ar_batches.batch_id%TYPE,
10: p_type IN ar_batches.type%TYPE,
11: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
12: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
13: p_name IN ar_batches.name%TYPE,
6:
7: PROCEDURE validate_args_insert_manual(
8: p_row_id IN VARCHAR2,
9: p_batch_id IN ar_batches.batch_id%TYPE,
10: p_type IN ar_batches.type%TYPE,
11: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
12: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
13: p_name IN ar_batches.name%TYPE,
14: p_currency_code IN ar_batches.currency_code%TYPE,
7: PROCEDURE validate_args_insert_manual(
8: p_row_id IN VARCHAR2,
9: p_batch_id IN ar_batches.batch_id%TYPE,
10: p_type IN ar_batches.type%TYPE,
11: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
12: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
13: p_name IN ar_batches.name%TYPE,
14: p_currency_code IN ar_batches.currency_code%TYPE,
15: p_gl_date IN ar_batches.gl_date%TYPE,
8: p_row_id IN VARCHAR2,
9: p_batch_id IN ar_batches.batch_id%TYPE,
10: p_type IN ar_batches.type%TYPE,
11: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
12: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
13: p_name IN ar_batches.name%TYPE,
14: p_currency_code IN ar_batches.currency_code%TYPE,
15: p_gl_date IN ar_batches.gl_date%TYPE,
16: p_batch_date IN ar_batches.batch_date%TYPE,
9: p_batch_id IN ar_batches.batch_id%TYPE,
10: p_type IN ar_batches.type%TYPE,
11: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
12: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
13: p_name IN ar_batches.name%TYPE,
14: p_currency_code IN ar_batches.currency_code%TYPE,
15: p_gl_date IN ar_batches.gl_date%TYPE,
16: p_batch_date IN ar_batches.batch_date%TYPE,
17: p_batch_applied_status IN ar_batches.batch_applied_status%TYPE,
10: p_type IN ar_batches.type%TYPE,
11: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
12: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
13: p_name IN ar_batches.name%TYPE,
14: p_currency_code IN ar_batches.currency_code%TYPE,
15: p_gl_date IN ar_batches.gl_date%TYPE,
16: p_batch_date IN ar_batches.batch_date%TYPE,
17: p_batch_applied_status IN ar_batches.batch_applied_status%TYPE,
18: p_auto_batch_numbering IN ar_batch_sources.auto_batch_numbering%TYPE);
11: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
12: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
13: p_name IN ar_batches.name%TYPE,
14: p_currency_code IN ar_batches.currency_code%TYPE,
15: p_gl_date IN ar_batches.gl_date%TYPE,
16: p_batch_date IN ar_batches.batch_date%TYPE,
17: p_batch_applied_status IN ar_batches.batch_applied_status%TYPE,
18: p_auto_batch_numbering IN ar_batch_sources.auto_batch_numbering%TYPE);
19: --
12: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
13: p_name IN ar_batches.name%TYPE,
14: p_currency_code IN ar_batches.currency_code%TYPE,
15: p_gl_date IN ar_batches.gl_date%TYPE,
16: p_batch_date IN ar_batches.batch_date%TYPE,
17: p_batch_applied_status IN ar_batches.batch_applied_status%TYPE,
18: p_auto_batch_numbering IN ar_batch_sources.auto_batch_numbering%TYPE);
19: --
20: PROCEDURE validate_args_insert_remit(
13: p_name IN ar_batches.name%TYPE,
14: p_currency_code IN ar_batches.currency_code%TYPE,
15: p_gl_date IN ar_batches.gl_date%TYPE,
16: p_batch_date IN ar_batches.batch_date%TYPE,
17: p_batch_applied_status IN ar_batches.batch_applied_status%TYPE,
18: p_auto_batch_numbering IN ar_batch_sources.auto_batch_numbering%TYPE);
19: --
20: PROCEDURE validate_args_insert_remit(
21: p_row_id IN VARCHAR2,
18: p_auto_batch_numbering IN ar_batch_sources.auto_batch_numbering%TYPE);
19: --
20: PROCEDURE validate_args_insert_remit(
21: p_row_id IN VARCHAR2,
22: p_batch_id IN ar_batches.batch_id%TYPE,
23: p_type IN ar_batches.type%TYPE,
24: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
25: p_currency_code IN ar_batches.currency_code%TYPE,
26: p_gl_date IN ar_batches.gl_date%TYPE,
19: --
20: PROCEDURE validate_args_insert_remit(
21: p_row_id IN VARCHAR2,
22: p_batch_id IN ar_batches.batch_id%TYPE,
23: p_type IN ar_batches.type%TYPE,
24: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
25: p_currency_code IN ar_batches.currency_code%TYPE,
26: p_gl_date IN ar_batches.gl_date%TYPE,
27: p_batch_date IN ar_batches.batch_date%TYPE,
20: PROCEDURE validate_args_insert_remit(
21: p_row_id IN VARCHAR2,
22: p_batch_id IN ar_batches.batch_id%TYPE,
23: p_type IN ar_batches.type%TYPE,
24: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
25: p_currency_code IN ar_batches.currency_code%TYPE,
26: p_gl_date IN ar_batches.gl_date%TYPE,
27: p_batch_date IN ar_batches.batch_date%TYPE,
28: p_remit_method_code IN ar_batches.remit_method_code%TYPE,
21: p_row_id IN VARCHAR2,
22: p_batch_id IN ar_batches.batch_id%TYPE,
23: p_type IN ar_batches.type%TYPE,
24: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
25: p_currency_code IN ar_batches.currency_code%TYPE,
26: p_gl_date IN ar_batches.gl_date%TYPE,
27: p_batch_date IN ar_batches.batch_date%TYPE,
28: p_remit_method_code IN ar_batches.remit_method_code%TYPE,
29: p_remittance_bank_branch_id IN
22: p_batch_id IN ar_batches.batch_id%TYPE,
23: p_type IN ar_batches.type%TYPE,
24: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
25: p_currency_code IN ar_batches.currency_code%TYPE,
26: p_gl_date IN ar_batches.gl_date%TYPE,
27: p_batch_date IN ar_batches.batch_date%TYPE,
28: p_remit_method_code IN ar_batches.remit_method_code%TYPE,
29: p_remittance_bank_branch_id IN
30: ar_batches.remittance_bank_branch_id%TYPE,
23: p_type IN ar_batches.type%TYPE,
24: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
25: p_currency_code IN ar_batches.currency_code%TYPE,
26: p_gl_date IN ar_batches.gl_date%TYPE,
27: p_batch_date IN ar_batches.batch_date%TYPE,
28: p_remit_method_code IN ar_batches.remit_method_code%TYPE,
29: p_remittance_bank_branch_id IN
30: ar_batches.remittance_bank_branch_id%TYPE,
31: p_batch_applied_status IN ar_batches.batch_applied_status%TYPE );
24: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
25: p_currency_code IN ar_batches.currency_code%TYPE,
26: p_gl_date IN ar_batches.gl_date%TYPE,
27: p_batch_date IN ar_batches.batch_date%TYPE,
28: p_remit_method_code IN ar_batches.remit_method_code%TYPE,
29: p_remittance_bank_branch_id IN
30: ar_batches.remittance_bank_branch_id%TYPE,
31: p_batch_applied_status IN ar_batches.batch_applied_status%TYPE );
32: --
26: p_gl_date IN ar_batches.gl_date%TYPE,
27: p_batch_date IN ar_batches.batch_date%TYPE,
28: p_remit_method_code IN ar_batches.remit_method_code%TYPE,
29: p_remittance_bank_branch_id IN
30: ar_batches.remittance_bank_branch_id%TYPE,
31: p_batch_applied_status IN ar_batches.batch_applied_status%TYPE );
32: --
33: PROCEDURE validate_args_insert_auto(
34: p_row_id IN VARCHAR2,
27: p_batch_date IN ar_batches.batch_date%TYPE,
28: p_remit_method_code IN ar_batches.remit_method_code%TYPE,
29: p_remittance_bank_branch_id IN
30: ar_batches.remittance_bank_branch_id%TYPE,
31: p_batch_applied_status IN ar_batches.batch_applied_status%TYPE );
32: --
33: PROCEDURE validate_args_insert_auto(
34: p_row_id IN VARCHAR2,
35: p_batch_id IN ar_batches.batch_id%TYPE,
31: p_batch_applied_status IN ar_batches.batch_applied_status%TYPE );
32: --
33: PROCEDURE validate_args_insert_auto(
34: p_row_id IN VARCHAR2,
35: p_batch_id IN ar_batches.batch_id%TYPE,
36: p_type IN ar_batches.type%TYPE,
37: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
38: p_name IN ar_batches.name%TYPE,
39: p_currency_code IN ar_batches.currency_code%TYPE,
32: --
33: PROCEDURE validate_args_insert_auto(
34: p_row_id IN VARCHAR2,
35: p_batch_id IN ar_batches.batch_id%TYPE,
36: p_type IN ar_batches.type%TYPE,
37: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
38: p_name IN ar_batches.name%TYPE,
39: p_currency_code IN ar_batches.currency_code%TYPE,
40: p_batch_date IN ar_batches.batch_date%TYPE,
33: PROCEDURE validate_args_insert_auto(
34: p_row_id IN VARCHAR2,
35: p_batch_id IN ar_batches.batch_id%TYPE,
36: p_type IN ar_batches.type%TYPE,
37: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
38: p_name IN ar_batches.name%TYPE,
39: p_currency_code IN ar_batches.currency_code%TYPE,
40: p_batch_date IN ar_batches.batch_date%TYPE,
41: p_receipt_class_id IN
34: p_row_id IN VARCHAR2,
35: p_batch_id IN ar_batches.batch_id%TYPE,
36: p_type IN ar_batches.type%TYPE,
37: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
38: p_name IN ar_batches.name%TYPE,
39: p_currency_code IN ar_batches.currency_code%TYPE,
40: p_batch_date IN ar_batches.batch_date%TYPE,
41: p_receipt_class_id IN
42: ar_batches.receipt_class_id%TYPE,
35: p_batch_id IN ar_batches.batch_id%TYPE,
36: p_type IN ar_batches.type%TYPE,
37: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
38: p_name IN ar_batches.name%TYPE,
39: p_currency_code IN ar_batches.currency_code%TYPE,
40: p_batch_date IN ar_batches.batch_date%TYPE,
41: p_receipt_class_id IN
42: ar_batches.receipt_class_id%TYPE,
43: p_receipt_method_id IN
36: p_type IN ar_batches.type%TYPE,
37: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
38: p_name IN ar_batches.name%TYPE,
39: p_currency_code IN ar_batches.currency_code%TYPE,
40: p_batch_date IN ar_batches.batch_date%TYPE,
41: p_receipt_class_id IN
42: ar_batches.receipt_class_id%TYPE,
43: p_receipt_method_id IN
44: ar_batches.receipt_method_id%TYPE,
38: p_name IN ar_batches.name%TYPE,
39: p_currency_code IN ar_batches.currency_code%TYPE,
40: p_batch_date IN ar_batches.batch_date%TYPE,
41: p_receipt_class_id IN
42: ar_batches.receipt_class_id%TYPE,
43: p_receipt_method_id IN
44: ar_batches.receipt_method_id%TYPE,
45: p_batch_applied_status IN ar_batches.batch_applied_status%TYPE );
46: --
40: p_batch_date IN ar_batches.batch_date%TYPE,
41: p_receipt_class_id IN
42: ar_batches.receipt_class_id%TYPE,
43: p_receipt_method_id IN
44: ar_batches.receipt_method_id%TYPE,
45: p_batch_applied_status IN ar_batches.batch_applied_status%TYPE );
46: --
47: /*===========================================================================+
48: | PROCEDURE |
41: p_receipt_class_id IN
42: ar_batches.receipt_class_id%TYPE,
43: p_receipt_method_id IN
44: ar_batches.receipt_method_id%TYPE,
45: p_batch_applied_status IN ar_batches.batch_applied_status%TYPE );
46: --
47: /*===========================================================================+
48: | PROCEDURE |
49: | insert_manual_batch - Insert a row AR_BATCHES table after checking for|
45: p_batch_applied_status IN ar_batches.batch_applied_status%TYPE );
46: --
47: /*===========================================================================+
48: | PROCEDURE |
49: | insert_manual_batch - Insert a row AR_BATCHES table after checking for|
50: | uniqueness |
51: | |
52: | DESCRIPTION |
53: | This function inserts a row in AR_BATCHES table after checking for |
49: | insert_manual_batch - Insert a row AR_BATCHES table after checking for|
50: | uniqueness |
51: | |
52: | DESCRIPTION |
53: | This function inserts a row in AR_BATCHES table after checking for |
54: | uniqueness for items such as NAME, MEDIA_REFERENCE, GL_DATE |
55: | |
56: | SCOPE - PUBLIC |
57: | |
77: +===========================================================================*/
78: PROCEDURE insert_manual_batch(
79: p_row_id IN OUT NOCOPY VARCHAR2,
80: p_batch_type IN VARCHAR2,
81: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
82: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
83: p_batch_date IN ar_batches.batch_date%TYPE,
84: p_currency_code IN ar_batches.currency_code%TYPE,
85: p_name IN OUT NOCOPY ar_batches.name%TYPE,
78: PROCEDURE insert_manual_batch(
79: p_row_id IN OUT NOCOPY VARCHAR2,
80: p_batch_type IN VARCHAR2,
81: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
82: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
83: p_batch_date IN ar_batches.batch_date%TYPE,
84: p_currency_code IN ar_batches.currency_code%TYPE,
85: p_name IN OUT NOCOPY ar_batches.name%TYPE,
86: p_comments IN ar_batches.comments%TYPE,
79: p_row_id IN OUT NOCOPY VARCHAR2,
80: p_batch_type IN VARCHAR2,
81: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
82: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
83: p_batch_date IN ar_batches.batch_date%TYPE,
84: p_currency_code IN ar_batches.currency_code%TYPE,
85: p_name IN OUT NOCOPY ar_batches.name%TYPE,
86: p_comments IN ar_batches.comments%TYPE,
87: p_control_amount IN ar_batches.control_amount%TYPE,
80: p_batch_type IN VARCHAR2,
81: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
82: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
83: p_batch_date IN ar_batches.batch_date%TYPE,
84: p_currency_code IN ar_batches.currency_code%TYPE,
85: p_name IN OUT NOCOPY ar_batches.name%TYPE,
86: p_comments IN ar_batches.comments%TYPE,
87: p_control_amount IN ar_batches.control_amount%TYPE,
88: p_control_count IN ar_batches.control_count%TYPE,
81: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
82: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
83: p_batch_date IN ar_batches.batch_date%TYPE,
84: p_currency_code IN ar_batches.currency_code%TYPE,
85: p_name IN OUT NOCOPY ar_batches.name%TYPE,
86: p_comments IN ar_batches.comments%TYPE,
87: p_control_amount IN ar_batches.control_amount%TYPE,
88: p_control_count IN ar_batches.control_count%TYPE,
89: p_deposit_date IN ar_batches.deposit_date%TYPE,
82: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
83: p_batch_date IN ar_batches.batch_date%TYPE,
84: p_currency_code IN ar_batches.currency_code%TYPE,
85: p_name IN OUT NOCOPY ar_batches.name%TYPE,
86: p_comments IN ar_batches.comments%TYPE,
87: p_control_amount IN ar_batches.control_amount%TYPE,
88: p_control_count IN ar_batches.control_count%TYPE,
89: p_deposit_date IN ar_batches.deposit_date%TYPE,
90: p_exchange_date IN ar_batches.exchange_date%TYPE,
83: p_batch_date IN ar_batches.batch_date%TYPE,
84: p_currency_code IN ar_batches.currency_code%TYPE,
85: p_name IN OUT NOCOPY ar_batches.name%TYPE,
86: p_comments IN ar_batches.comments%TYPE,
87: p_control_amount IN ar_batches.control_amount%TYPE,
88: p_control_count IN ar_batches.control_count%TYPE,
89: p_deposit_date IN ar_batches.deposit_date%TYPE,
90: p_exchange_date IN ar_batches.exchange_date%TYPE,
91: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
84: p_currency_code IN ar_batches.currency_code%TYPE,
85: p_name IN OUT NOCOPY ar_batches.name%TYPE,
86: p_comments IN ar_batches.comments%TYPE,
87: p_control_amount IN ar_batches.control_amount%TYPE,
88: p_control_count IN ar_batches.control_count%TYPE,
89: p_deposit_date IN ar_batches.deposit_date%TYPE,
90: p_exchange_date IN ar_batches.exchange_date%TYPE,
91: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
92: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
85: p_name IN OUT NOCOPY ar_batches.name%TYPE,
86: p_comments IN ar_batches.comments%TYPE,
87: p_control_amount IN ar_batches.control_amount%TYPE,
88: p_control_count IN ar_batches.control_count%TYPE,
89: p_deposit_date IN ar_batches.deposit_date%TYPE,
90: p_exchange_date IN ar_batches.exchange_date%TYPE,
91: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
92: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
93: p_gl_date IN ar_batches.gl_date%TYPE,
86: p_comments IN ar_batches.comments%TYPE,
87: p_control_amount IN ar_batches.control_amount%TYPE,
88: p_control_count IN ar_batches.control_count%TYPE,
89: p_deposit_date IN ar_batches.deposit_date%TYPE,
90: p_exchange_date IN ar_batches.exchange_date%TYPE,
91: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
92: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
93: p_gl_date IN ar_batches.gl_date%TYPE,
94: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
87: p_control_amount IN ar_batches.control_amount%TYPE,
88: p_control_count IN ar_batches.control_count%TYPE,
89: p_deposit_date IN ar_batches.deposit_date%TYPE,
90: p_exchange_date IN ar_batches.exchange_date%TYPE,
91: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
92: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
93: p_gl_date IN ar_batches.gl_date%TYPE,
94: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
95: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
88: p_control_count IN ar_batches.control_count%TYPE,
89: p_deposit_date IN ar_batches.deposit_date%TYPE,
90: p_exchange_date IN ar_batches.exchange_date%TYPE,
91: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
92: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
93: p_gl_date IN ar_batches.gl_date%TYPE,
94: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
95: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
96: p_remittance_bank_account_id
89: p_deposit_date IN ar_batches.deposit_date%TYPE,
90: p_exchange_date IN ar_batches.exchange_date%TYPE,
91: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
92: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
93: p_gl_date IN ar_batches.gl_date%TYPE,
94: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
95: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
96: p_remittance_bank_account_id
97: IN ar_batches.remit_bank_acct_use_id%TYPE,
90: p_exchange_date IN ar_batches.exchange_date%TYPE,
91: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
92: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
93: p_gl_date IN ar_batches.gl_date%TYPE,
94: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
95: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
96: p_remittance_bank_account_id
97: IN ar_batches.remit_bank_acct_use_id%TYPE,
98: p_remittance_bank_branch_id
91: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
92: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
93: p_gl_date IN ar_batches.gl_date%TYPE,
94: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
95: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
96: p_remittance_bank_account_id
97: IN ar_batches.remit_bank_acct_use_id%TYPE,
98: p_remittance_bank_branch_id
99: IN ar_batches.remittance_bank_branch_id%TYPE,
93: p_gl_date IN ar_batches.gl_date%TYPE,
94: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
95: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
96: p_remittance_bank_account_id
97: IN ar_batches.remit_bank_acct_use_id%TYPE,
98: p_remittance_bank_branch_id
99: IN ar_batches.remittance_bank_branch_id%TYPE,
100: p_attribute_category IN ar_batches.attribute_category%TYPE,
101: p_attribute1 IN ar_batches.attribute1%TYPE,
95: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
96: p_remittance_bank_account_id
97: IN ar_batches.remit_bank_acct_use_id%TYPE,
98: p_remittance_bank_branch_id
99: IN ar_batches.remittance_bank_branch_id%TYPE,
100: p_attribute_category IN ar_batches.attribute_category%TYPE,
101: p_attribute1 IN ar_batches.attribute1%TYPE,
102: p_attribute2 IN ar_batches.attribute2%TYPE,
103: p_attribute3 IN ar_batches.attribute3%TYPE,
96: p_remittance_bank_account_id
97: IN ar_batches.remit_bank_acct_use_id%TYPE,
98: p_remittance_bank_branch_id
99: IN ar_batches.remittance_bank_branch_id%TYPE,
100: p_attribute_category IN ar_batches.attribute_category%TYPE,
101: p_attribute1 IN ar_batches.attribute1%TYPE,
102: p_attribute2 IN ar_batches.attribute2%TYPE,
103: p_attribute3 IN ar_batches.attribute3%TYPE,
104: p_attribute4 IN ar_batches.attribute4%TYPE,
97: IN ar_batches.remit_bank_acct_use_id%TYPE,
98: p_remittance_bank_branch_id
99: IN ar_batches.remittance_bank_branch_id%TYPE,
100: p_attribute_category IN ar_batches.attribute_category%TYPE,
101: p_attribute1 IN ar_batches.attribute1%TYPE,
102: p_attribute2 IN ar_batches.attribute2%TYPE,
103: p_attribute3 IN ar_batches.attribute3%TYPE,
104: p_attribute4 IN ar_batches.attribute4%TYPE,
105: p_attribute5 IN ar_batches.attribute5%TYPE,
98: p_remittance_bank_branch_id
99: IN ar_batches.remittance_bank_branch_id%TYPE,
100: p_attribute_category IN ar_batches.attribute_category%TYPE,
101: p_attribute1 IN ar_batches.attribute1%TYPE,
102: p_attribute2 IN ar_batches.attribute2%TYPE,
103: p_attribute3 IN ar_batches.attribute3%TYPE,
104: p_attribute4 IN ar_batches.attribute4%TYPE,
105: p_attribute5 IN ar_batches.attribute5%TYPE,
106: p_attribute6 IN ar_batches.attribute6%TYPE,
99: IN ar_batches.remittance_bank_branch_id%TYPE,
100: p_attribute_category IN ar_batches.attribute_category%TYPE,
101: p_attribute1 IN ar_batches.attribute1%TYPE,
102: p_attribute2 IN ar_batches.attribute2%TYPE,
103: p_attribute3 IN ar_batches.attribute3%TYPE,
104: p_attribute4 IN ar_batches.attribute4%TYPE,
105: p_attribute5 IN ar_batches.attribute5%TYPE,
106: p_attribute6 IN ar_batches.attribute6%TYPE,
107: p_attribute7 IN ar_batches.attribute7%TYPE,
100: p_attribute_category IN ar_batches.attribute_category%TYPE,
101: p_attribute1 IN ar_batches.attribute1%TYPE,
102: p_attribute2 IN ar_batches.attribute2%TYPE,
103: p_attribute3 IN ar_batches.attribute3%TYPE,
104: p_attribute4 IN ar_batches.attribute4%TYPE,
105: p_attribute5 IN ar_batches.attribute5%TYPE,
106: p_attribute6 IN ar_batches.attribute6%TYPE,
107: p_attribute7 IN ar_batches.attribute7%TYPE,
108: p_attribute8 IN ar_batches.attribute8%TYPE,
101: p_attribute1 IN ar_batches.attribute1%TYPE,
102: p_attribute2 IN ar_batches.attribute2%TYPE,
103: p_attribute3 IN ar_batches.attribute3%TYPE,
104: p_attribute4 IN ar_batches.attribute4%TYPE,
105: p_attribute5 IN ar_batches.attribute5%TYPE,
106: p_attribute6 IN ar_batches.attribute6%TYPE,
107: p_attribute7 IN ar_batches.attribute7%TYPE,
108: p_attribute8 IN ar_batches.attribute8%TYPE,
109: p_attribute9 IN ar_batches.attribute9%TYPE,
102: p_attribute2 IN ar_batches.attribute2%TYPE,
103: p_attribute3 IN ar_batches.attribute3%TYPE,
104: p_attribute4 IN ar_batches.attribute4%TYPE,
105: p_attribute5 IN ar_batches.attribute5%TYPE,
106: p_attribute6 IN ar_batches.attribute6%TYPE,
107: p_attribute7 IN ar_batches.attribute7%TYPE,
108: p_attribute8 IN ar_batches.attribute8%TYPE,
109: p_attribute9 IN ar_batches.attribute9%TYPE,
110: p_attribute10 IN ar_batches.attribute10%TYPE,
103: p_attribute3 IN ar_batches.attribute3%TYPE,
104: p_attribute4 IN ar_batches.attribute4%TYPE,
105: p_attribute5 IN ar_batches.attribute5%TYPE,
106: p_attribute6 IN ar_batches.attribute6%TYPE,
107: p_attribute7 IN ar_batches.attribute7%TYPE,
108: p_attribute8 IN ar_batches.attribute8%TYPE,
109: p_attribute9 IN ar_batches.attribute9%TYPE,
110: p_attribute10 IN ar_batches.attribute10%TYPE,
111: p_attribute11 IN ar_batches.attribute11%TYPE,
104: p_attribute4 IN ar_batches.attribute4%TYPE,
105: p_attribute5 IN ar_batches.attribute5%TYPE,
106: p_attribute6 IN ar_batches.attribute6%TYPE,
107: p_attribute7 IN ar_batches.attribute7%TYPE,
108: p_attribute8 IN ar_batches.attribute8%TYPE,
109: p_attribute9 IN ar_batches.attribute9%TYPE,
110: p_attribute10 IN ar_batches.attribute10%TYPE,
111: p_attribute11 IN ar_batches.attribute11%TYPE,
112: p_attribute12 IN ar_batches.attribute12%TYPE,
105: p_attribute5 IN ar_batches.attribute5%TYPE,
106: p_attribute6 IN ar_batches.attribute6%TYPE,
107: p_attribute7 IN ar_batches.attribute7%TYPE,
108: p_attribute8 IN ar_batches.attribute8%TYPE,
109: p_attribute9 IN ar_batches.attribute9%TYPE,
110: p_attribute10 IN ar_batches.attribute10%TYPE,
111: p_attribute11 IN ar_batches.attribute11%TYPE,
112: p_attribute12 IN ar_batches.attribute12%TYPE,
113: p_attribute13 IN ar_batches.attribute13%TYPE,
106: p_attribute6 IN ar_batches.attribute6%TYPE,
107: p_attribute7 IN ar_batches.attribute7%TYPE,
108: p_attribute8 IN ar_batches.attribute8%TYPE,
109: p_attribute9 IN ar_batches.attribute9%TYPE,
110: p_attribute10 IN ar_batches.attribute10%TYPE,
111: p_attribute11 IN ar_batches.attribute11%TYPE,
112: p_attribute12 IN ar_batches.attribute12%TYPE,
113: p_attribute13 IN ar_batches.attribute13%TYPE,
114: p_attribute14 IN ar_batches.attribute14%TYPE,
107: p_attribute7 IN ar_batches.attribute7%TYPE,
108: p_attribute8 IN ar_batches.attribute8%TYPE,
109: p_attribute9 IN ar_batches.attribute9%TYPE,
110: p_attribute10 IN ar_batches.attribute10%TYPE,
111: p_attribute11 IN ar_batches.attribute11%TYPE,
112: p_attribute12 IN ar_batches.attribute12%TYPE,
113: p_attribute13 IN ar_batches.attribute13%TYPE,
114: p_attribute14 IN ar_batches.attribute14%TYPE,
115: p_attribute15 IN ar_batches.attribute15%TYPE,
108: p_attribute8 IN ar_batches.attribute8%TYPE,
109: p_attribute9 IN ar_batches.attribute9%TYPE,
110: p_attribute10 IN ar_batches.attribute10%TYPE,
111: p_attribute11 IN ar_batches.attribute11%TYPE,
112: p_attribute12 IN ar_batches.attribute12%TYPE,
113: p_attribute13 IN ar_batches.attribute13%TYPE,
114: p_attribute14 IN ar_batches.attribute14%TYPE,
115: p_attribute15 IN ar_batches.attribute15%TYPE,
116: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
109: p_attribute9 IN ar_batches.attribute9%TYPE,
110: p_attribute10 IN ar_batches.attribute10%TYPE,
111: p_attribute11 IN ar_batches.attribute11%TYPE,
112: p_attribute12 IN ar_batches.attribute12%TYPE,
113: p_attribute13 IN ar_batches.attribute13%TYPE,
114: p_attribute14 IN ar_batches.attribute14%TYPE,
115: p_attribute15 IN ar_batches.attribute15%TYPE,
116: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
117: p_module_name IN VARCHAR2,
110: p_attribute10 IN ar_batches.attribute10%TYPE,
111: p_attribute11 IN ar_batches.attribute11%TYPE,
112: p_attribute12 IN ar_batches.attribute12%TYPE,
113: p_attribute13 IN ar_batches.attribute13%TYPE,
114: p_attribute14 IN ar_batches.attribute14%TYPE,
115: p_attribute15 IN ar_batches.attribute15%TYPE,
116: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
117: p_module_name IN VARCHAR2,
118: p_module_version IN VARCHAR2 ) IS
111: p_attribute11 IN ar_batches.attribute11%TYPE,
112: p_attribute12 IN ar_batches.attribute12%TYPE,
113: p_attribute13 IN ar_batches.attribute13%TYPE,
114: p_attribute14 IN ar_batches.attribute14%TYPE,
115: p_attribute15 IN ar_batches.attribute15%TYPE,
116: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
117: p_module_name IN VARCHAR2,
118: p_module_version IN VARCHAR2 ) IS
119: --
112: p_attribute12 IN ar_batches.attribute12%TYPE,
113: p_attribute13 IN ar_batches.attribute13%TYPE,
114: p_attribute14 IN ar_batches.attribute14%TYPE,
115: p_attribute15 IN ar_batches.attribute15%TYPE,
116: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
117: p_module_name IN VARCHAR2,
118: p_module_version IN VARCHAR2 ) IS
119: --
120: l_batch_rec ar_batches%ROWTYPE;
116: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
117: p_module_name IN VARCHAR2,
118: p_module_version IN VARCHAR2 ) IS
119: --
120: l_batch_rec ar_batches%ROWTYPE;
121: l_auto_batch_numbering ar_batch_sources.auto_batch_numbering%TYPE;
122: l_request_id ar_batches.request_id%TYPE;
123: l_batch_applied_status ar_batches.batch_applied_status%TYPE;
124: --
118: p_module_version IN VARCHAR2 ) IS
119: --
120: l_batch_rec ar_batches%ROWTYPE;
121: l_auto_batch_numbering ar_batch_sources.auto_batch_numbering%TYPE;
122: l_request_id ar_batches.request_id%TYPE;
123: l_batch_applied_status ar_batches.batch_applied_status%TYPE;
124: --
125: BEGIN
126: IF PG_DEBUG in ('Y', 'C') THEN
119: --
120: l_batch_rec ar_batches%ROWTYPE;
121: l_auto_batch_numbering ar_batch_sources.auto_batch_numbering%TYPE;
122: l_request_id ar_batches.request_id%TYPE;
123: l_batch_applied_status ar_batches.batch_applied_status%TYPE;
124: --
125: BEGIN
126: IF PG_DEBUG in ('Y', 'C') THEN
127: arp_util.debug('validate_args_insert_manual: ' || 'arp_rw_batches_pkg.insert_manual_batch()+' );
287: | |
288: +===========================================================================*/
289: PROCEDURE validate_args_insert_manual(
290: p_row_id IN VARCHAR2,
291: p_batch_id IN ar_batches.batch_id%TYPE,
292: p_type IN ar_batches.type%TYPE,
293: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
294: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
295: p_name IN ar_batches.name%TYPE,
288: +===========================================================================*/
289: PROCEDURE validate_args_insert_manual(
290: p_row_id IN VARCHAR2,
291: p_batch_id IN ar_batches.batch_id%TYPE,
292: p_type IN ar_batches.type%TYPE,
293: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
294: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
295: p_name IN ar_batches.name%TYPE,
296: p_currency_code IN ar_batches.currency_code%TYPE,
289: PROCEDURE validate_args_insert_manual(
290: p_row_id IN VARCHAR2,
291: p_batch_id IN ar_batches.batch_id%TYPE,
292: p_type IN ar_batches.type%TYPE,
293: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
294: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
295: p_name IN ar_batches.name%TYPE,
296: p_currency_code IN ar_batches.currency_code%TYPE,
297: p_gl_date IN ar_batches.gl_date%TYPE,
290: p_row_id IN VARCHAR2,
291: p_batch_id IN ar_batches.batch_id%TYPE,
292: p_type IN ar_batches.type%TYPE,
293: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
294: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
295: p_name IN ar_batches.name%TYPE,
296: p_currency_code IN ar_batches.currency_code%TYPE,
297: p_gl_date IN ar_batches.gl_date%TYPE,
298: p_batch_date IN ar_batches.batch_date%TYPE,
291: p_batch_id IN ar_batches.batch_id%TYPE,
292: p_type IN ar_batches.type%TYPE,
293: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
294: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
295: p_name IN ar_batches.name%TYPE,
296: p_currency_code IN ar_batches.currency_code%TYPE,
297: p_gl_date IN ar_batches.gl_date%TYPE,
298: p_batch_date IN ar_batches.batch_date%TYPE,
299: p_batch_applied_status IN ar_batches.batch_applied_status%TYPE,
292: p_type IN ar_batches.type%TYPE,
293: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
294: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
295: p_name IN ar_batches.name%TYPE,
296: p_currency_code IN ar_batches.currency_code%TYPE,
297: p_gl_date IN ar_batches.gl_date%TYPE,
298: p_batch_date IN ar_batches.batch_date%TYPE,
299: p_batch_applied_status IN ar_batches.batch_applied_status%TYPE,
300: p_auto_batch_numbering IN ar_batch_sources.auto_batch_numbering%TYPE) IS
293: p_batch_source_id IN ar_batches.batch_source_id%TYPE,
294: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
295: p_name IN ar_batches.name%TYPE,
296: p_currency_code IN ar_batches.currency_code%TYPE,
297: p_gl_date IN ar_batches.gl_date%TYPE,
298: p_batch_date IN ar_batches.batch_date%TYPE,
299: p_batch_applied_status IN ar_batches.batch_applied_status%TYPE,
300: p_auto_batch_numbering IN ar_batch_sources.auto_batch_numbering%TYPE) IS
301: l_field VARCHAR2(30);
294: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
295: p_name IN ar_batches.name%TYPE,
296: p_currency_code IN ar_batches.currency_code%TYPE,
297: p_gl_date IN ar_batches.gl_date%TYPE,
298: p_batch_date IN ar_batches.batch_date%TYPE,
299: p_batch_applied_status IN ar_batches.batch_applied_status%TYPE,
300: p_auto_batch_numbering IN ar_batch_sources.auto_batch_numbering%TYPE) IS
301: l_field VARCHAR2(30);
302: BEGIN
295: p_name IN ar_batches.name%TYPE,
296: p_currency_code IN ar_batches.currency_code%TYPE,
297: p_gl_date IN ar_batches.gl_date%TYPE,
298: p_batch_date IN ar_batches.batch_date%TYPE,
299: p_batch_applied_status IN ar_batches.batch_applied_status%TYPE,
300: p_auto_batch_numbering IN ar_batch_sources.auto_batch_numbering%TYPE) IS
301: l_field VARCHAR2(30);
302: BEGIN
303: IF PG_DEBUG in ('Y', 'C') THEN
351: END validate_args_insert_manual;
352: --
353: /*===========================================================================+
354: | PROCEDURE |
355: | insert_auto_batch - Insert a row AR_BATCHES table after checking for|
356: | uniqueness |
357: | |
358: | DESCRIPTION |
359: | This function inserts a row in AR_BATCHES table after checking for |
355: | insert_auto_batch - Insert a row AR_BATCHES table after checking for|
356: | uniqueness |
357: | |
358: | DESCRIPTION |
359: | This function inserts a row in AR_BATCHES table after checking for |
360: | uniqueness for items such as NAME, MEDIA_REFERENCE, GL_DATE |
361: | |
362: | SCOPE - PUBLIC |
363: | |
386: | of the changes for bug 3167260 |
387: +===========================================================================*/
388: PROCEDURE insert_auto_batch(
389: p_row_id IN OUT NOCOPY VARCHAR2,
390: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
391: p_batch_date IN ar_batches.batch_date%TYPE,
392: p_currency_code IN ar_batches.currency_code%TYPE,
393: p_name IN OUT NOCOPY ar_batches.name%TYPE,
394: p_comments IN ar_batches.comments%TYPE,
387: +===========================================================================*/
388: PROCEDURE insert_auto_batch(
389: p_row_id IN OUT NOCOPY VARCHAR2,
390: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
391: p_batch_date IN ar_batches.batch_date%TYPE,
392: p_currency_code IN ar_batches.currency_code%TYPE,
393: p_name IN OUT NOCOPY ar_batches.name%TYPE,
394: p_comments IN ar_batches.comments%TYPE,
395: p_exchange_date IN ar_batches.exchange_date%TYPE,
388: PROCEDURE insert_auto_batch(
389: p_row_id IN OUT NOCOPY VARCHAR2,
390: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
391: p_batch_date IN ar_batches.batch_date%TYPE,
392: p_currency_code IN ar_batches.currency_code%TYPE,
393: p_name IN OUT NOCOPY ar_batches.name%TYPE,
394: p_comments IN ar_batches.comments%TYPE,
395: p_exchange_date IN ar_batches.exchange_date%TYPE,
396: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
389: p_row_id IN OUT NOCOPY VARCHAR2,
390: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
391: p_batch_date IN ar_batches.batch_date%TYPE,
392: p_currency_code IN ar_batches.currency_code%TYPE,
393: p_name IN OUT NOCOPY ar_batches.name%TYPE,
394: p_comments IN ar_batches.comments%TYPE,
395: p_exchange_date IN ar_batches.exchange_date%TYPE,
396: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
397: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
390: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
391: p_batch_date IN ar_batches.batch_date%TYPE,
392: p_currency_code IN ar_batches.currency_code%TYPE,
393: p_name IN OUT NOCOPY ar_batches.name%TYPE,
394: p_comments IN ar_batches.comments%TYPE,
395: p_exchange_date IN ar_batches.exchange_date%TYPE,
396: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
397: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
398: p_gl_date IN ar_batches.gl_date%TYPE,
391: p_batch_date IN ar_batches.batch_date%TYPE,
392: p_currency_code IN ar_batches.currency_code%TYPE,
393: p_name IN OUT NOCOPY ar_batches.name%TYPE,
394: p_comments IN ar_batches.comments%TYPE,
395: p_exchange_date IN ar_batches.exchange_date%TYPE,
396: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
397: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
398: p_gl_date IN ar_batches.gl_date%TYPE,
399: p_media_reference IN ar_batches.media_reference%TYPE,
392: p_currency_code IN ar_batches.currency_code%TYPE,
393: p_name IN OUT NOCOPY ar_batches.name%TYPE,
394: p_comments IN ar_batches.comments%TYPE,
395: p_exchange_date IN ar_batches.exchange_date%TYPE,
396: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
397: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
398: p_gl_date IN ar_batches.gl_date%TYPE,
399: p_media_reference IN ar_batches.media_reference%TYPE,
400: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
393: p_name IN OUT NOCOPY ar_batches.name%TYPE,
394: p_comments IN ar_batches.comments%TYPE,
395: p_exchange_date IN ar_batches.exchange_date%TYPE,
396: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
397: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
398: p_gl_date IN ar_batches.gl_date%TYPE,
399: p_media_reference IN ar_batches.media_reference%TYPE,
400: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
401: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
394: p_comments IN ar_batches.comments%TYPE,
395: p_exchange_date IN ar_batches.exchange_date%TYPE,
396: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
397: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
398: p_gl_date IN ar_batches.gl_date%TYPE,
399: p_media_reference IN ar_batches.media_reference%TYPE,
400: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
401: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
402: p_attribute_category IN ar_batches.attribute_category%TYPE,
395: p_exchange_date IN ar_batches.exchange_date%TYPE,
396: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
397: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
398: p_gl_date IN ar_batches.gl_date%TYPE,
399: p_media_reference IN ar_batches.media_reference%TYPE,
400: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
401: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
402: p_attribute_category IN ar_batches.attribute_category%TYPE,
403: p_attribute1 IN ar_batches.attribute1%TYPE,
396: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
397: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
398: p_gl_date IN ar_batches.gl_date%TYPE,
399: p_media_reference IN ar_batches.media_reference%TYPE,
400: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
401: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
402: p_attribute_category IN ar_batches.attribute_category%TYPE,
403: p_attribute1 IN ar_batches.attribute1%TYPE,
404: p_attribute2 IN ar_batches.attribute2%TYPE,
397: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
398: p_gl_date IN ar_batches.gl_date%TYPE,
399: p_media_reference IN ar_batches.media_reference%TYPE,
400: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
401: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
402: p_attribute_category IN ar_batches.attribute_category%TYPE,
403: p_attribute1 IN ar_batches.attribute1%TYPE,
404: p_attribute2 IN ar_batches.attribute2%TYPE,
405: p_attribute3 IN ar_batches.attribute3%TYPE,
398: p_gl_date IN ar_batches.gl_date%TYPE,
399: p_media_reference IN ar_batches.media_reference%TYPE,
400: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
401: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
402: p_attribute_category IN ar_batches.attribute_category%TYPE,
403: p_attribute1 IN ar_batches.attribute1%TYPE,
404: p_attribute2 IN ar_batches.attribute2%TYPE,
405: p_attribute3 IN ar_batches.attribute3%TYPE,
406: p_attribute4 IN ar_batches.attribute4%TYPE,
399: p_media_reference IN ar_batches.media_reference%TYPE,
400: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
401: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
402: p_attribute_category IN ar_batches.attribute_category%TYPE,
403: p_attribute1 IN ar_batches.attribute1%TYPE,
404: p_attribute2 IN ar_batches.attribute2%TYPE,
405: p_attribute3 IN ar_batches.attribute3%TYPE,
406: p_attribute4 IN ar_batches.attribute4%TYPE,
407: p_attribute5 IN ar_batches.attribute5%TYPE,
400: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
401: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
402: p_attribute_category IN ar_batches.attribute_category%TYPE,
403: p_attribute1 IN ar_batches.attribute1%TYPE,
404: p_attribute2 IN ar_batches.attribute2%TYPE,
405: p_attribute3 IN ar_batches.attribute3%TYPE,
406: p_attribute4 IN ar_batches.attribute4%TYPE,
407: p_attribute5 IN ar_batches.attribute5%TYPE,
408: p_attribute6 IN ar_batches.attribute6%TYPE,
401: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
402: p_attribute_category IN ar_batches.attribute_category%TYPE,
403: p_attribute1 IN ar_batches.attribute1%TYPE,
404: p_attribute2 IN ar_batches.attribute2%TYPE,
405: p_attribute3 IN ar_batches.attribute3%TYPE,
406: p_attribute4 IN ar_batches.attribute4%TYPE,
407: p_attribute5 IN ar_batches.attribute5%TYPE,
408: p_attribute6 IN ar_batches.attribute6%TYPE,
409: p_attribute7 IN ar_batches.attribute7%TYPE,
402: p_attribute_category IN ar_batches.attribute_category%TYPE,
403: p_attribute1 IN ar_batches.attribute1%TYPE,
404: p_attribute2 IN ar_batches.attribute2%TYPE,
405: p_attribute3 IN ar_batches.attribute3%TYPE,
406: p_attribute4 IN ar_batches.attribute4%TYPE,
407: p_attribute5 IN ar_batches.attribute5%TYPE,
408: p_attribute6 IN ar_batches.attribute6%TYPE,
409: p_attribute7 IN ar_batches.attribute7%TYPE,
410: p_attribute8 IN ar_batches.attribute8%TYPE,
403: p_attribute1 IN ar_batches.attribute1%TYPE,
404: p_attribute2 IN ar_batches.attribute2%TYPE,
405: p_attribute3 IN ar_batches.attribute3%TYPE,
406: p_attribute4 IN ar_batches.attribute4%TYPE,
407: p_attribute5 IN ar_batches.attribute5%TYPE,
408: p_attribute6 IN ar_batches.attribute6%TYPE,
409: p_attribute7 IN ar_batches.attribute7%TYPE,
410: p_attribute8 IN ar_batches.attribute8%TYPE,
411: p_attribute9 IN ar_batches.attribute9%TYPE,
404: p_attribute2 IN ar_batches.attribute2%TYPE,
405: p_attribute3 IN ar_batches.attribute3%TYPE,
406: p_attribute4 IN ar_batches.attribute4%TYPE,
407: p_attribute5 IN ar_batches.attribute5%TYPE,
408: p_attribute6 IN ar_batches.attribute6%TYPE,
409: p_attribute7 IN ar_batches.attribute7%TYPE,
410: p_attribute8 IN ar_batches.attribute8%TYPE,
411: p_attribute9 IN ar_batches.attribute9%TYPE,
412: p_attribute10 IN ar_batches.attribute10%TYPE,
405: p_attribute3 IN ar_batches.attribute3%TYPE,
406: p_attribute4 IN ar_batches.attribute4%TYPE,
407: p_attribute5 IN ar_batches.attribute5%TYPE,
408: p_attribute6 IN ar_batches.attribute6%TYPE,
409: p_attribute7 IN ar_batches.attribute7%TYPE,
410: p_attribute8 IN ar_batches.attribute8%TYPE,
411: p_attribute9 IN ar_batches.attribute9%TYPE,
412: p_attribute10 IN ar_batches.attribute10%TYPE,
413: p_attribute11 IN ar_batches.attribute11%TYPE,
406: p_attribute4 IN ar_batches.attribute4%TYPE,
407: p_attribute5 IN ar_batches.attribute5%TYPE,
408: p_attribute6 IN ar_batches.attribute6%TYPE,
409: p_attribute7 IN ar_batches.attribute7%TYPE,
410: p_attribute8 IN ar_batches.attribute8%TYPE,
411: p_attribute9 IN ar_batches.attribute9%TYPE,
412: p_attribute10 IN ar_batches.attribute10%TYPE,
413: p_attribute11 IN ar_batches.attribute11%TYPE,
414: p_attribute12 IN ar_batches.attribute12%TYPE,
407: p_attribute5 IN ar_batches.attribute5%TYPE,
408: p_attribute6 IN ar_batches.attribute6%TYPE,
409: p_attribute7 IN ar_batches.attribute7%TYPE,
410: p_attribute8 IN ar_batches.attribute8%TYPE,
411: p_attribute9 IN ar_batches.attribute9%TYPE,
412: p_attribute10 IN ar_batches.attribute10%TYPE,
413: p_attribute11 IN ar_batches.attribute11%TYPE,
414: p_attribute12 IN ar_batches.attribute12%TYPE,
415: p_attribute13 IN ar_batches.attribute13%TYPE,
408: p_attribute6 IN ar_batches.attribute6%TYPE,
409: p_attribute7 IN ar_batches.attribute7%TYPE,
410: p_attribute8 IN ar_batches.attribute8%TYPE,
411: p_attribute9 IN ar_batches.attribute9%TYPE,
412: p_attribute10 IN ar_batches.attribute10%TYPE,
413: p_attribute11 IN ar_batches.attribute11%TYPE,
414: p_attribute12 IN ar_batches.attribute12%TYPE,
415: p_attribute13 IN ar_batches.attribute13%TYPE,
416: p_attribute14 IN ar_batches.attribute14%TYPE,
409: p_attribute7 IN ar_batches.attribute7%TYPE,
410: p_attribute8 IN ar_batches.attribute8%TYPE,
411: p_attribute9 IN ar_batches.attribute9%TYPE,
412: p_attribute10 IN ar_batches.attribute10%TYPE,
413: p_attribute11 IN ar_batches.attribute11%TYPE,
414: p_attribute12 IN ar_batches.attribute12%TYPE,
415: p_attribute13 IN ar_batches.attribute13%TYPE,
416: p_attribute14 IN ar_batches.attribute14%TYPE,
417: p_attribute15 IN ar_batches.attribute15%TYPE,
410: p_attribute8 IN ar_batches.attribute8%TYPE,
411: p_attribute9 IN ar_batches.attribute9%TYPE,
412: p_attribute10 IN ar_batches.attribute10%TYPE,
413: p_attribute11 IN ar_batches.attribute11%TYPE,
414: p_attribute12 IN ar_batches.attribute12%TYPE,
415: p_attribute13 IN ar_batches.attribute13%TYPE,
416: p_attribute14 IN ar_batches.attribute14%TYPE,
417: p_attribute15 IN ar_batches.attribute15%TYPE,
418: p_call_conc_req IN VARCHAR2,
411: p_attribute9 IN ar_batches.attribute9%TYPE,
412: p_attribute10 IN ar_batches.attribute10%TYPE,
413: p_attribute11 IN ar_batches.attribute11%TYPE,
414: p_attribute12 IN ar_batches.attribute12%TYPE,
415: p_attribute13 IN ar_batches.attribute13%TYPE,
416: p_attribute14 IN ar_batches.attribute14%TYPE,
417: p_attribute15 IN ar_batches.attribute15%TYPE,
418: p_call_conc_req IN VARCHAR2,
419: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
412: p_attribute10 IN ar_batches.attribute10%TYPE,
413: p_attribute11 IN ar_batches.attribute11%TYPE,
414: p_attribute12 IN ar_batches.attribute12%TYPE,
415: p_attribute13 IN ar_batches.attribute13%TYPE,
416: p_attribute14 IN ar_batches.attribute14%TYPE,
417: p_attribute15 IN ar_batches.attribute15%TYPE,
418: p_call_conc_req IN VARCHAR2,
419: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
420: p_request_id OUT NOCOPY ar_batches.request_id%TYPE,
413: p_attribute11 IN ar_batches.attribute11%TYPE,
414: p_attribute12 IN ar_batches.attribute12%TYPE,
415: p_attribute13 IN ar_batches.attribute13%TYPE,
416: p_attribute14 IN ar_batches.attribute14%TYPE,
417: p_attribute15 IN ar_batches.attribute15%TYPE,
418: p_call_conc_req IN VARCHAR2,
419: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
420: p_request_id OUT NOCOPY ar_batches.request_id%TYPE,
421: p_module_name IN VARCHAR2,
415: p_attribute13 IN ar_batches.attribute13%TYPE,
416: p_attribute14 IN ar_batches.attribute14%TYPE,
417: p_attribute15 IN ar_batches.attribute15%TYPE,
418: p_call_conc_req IN VARCHAR2,
419: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
420: p_request_id OUT NOCOPY ar_batches.request_id%TYPE,
421: p_module_name IN VARCHAR2,
422: p_module_version IN VARCHAR2,
423: p_bank_account_low IN VARCHAR2,
416: p_attribute14 IN ar_batches.attribute14%TYPE,
417: p_attribute15 IN ar_batches.attribute15%TYPE,
418: p_call_conc_req IN VARCHAR2,
419: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
420: p_request_id OUT NOCOPY ar_batches.request_id%TYPE,
421: p_module_name IN VARCHAR2,
422: p_module_version IN VARCHAR2,
423: p_bank_account_low IN VARCHAR2,
424: p_bank_account_high IN VARCHAR2 ) IS
422: p_module_version IN VARCHAR2,
423: p_bank_account_low IN VARCHAR2,
424: p_bank_account_high IN VARCHAR2 ) IS
425: --
426: l_batch_rec ar_batches%ROWTYPE;
427: l_batch_applied_status ar_batches.batch_applied_status%TYPE;
428: l_request_id ar_batches.request_id%TYPE;
429: l_confirm_required VARCHAR2(1);
430: CURSOR c_receipt_class IS
423: p_bank_account_low IN VARCHAR2,
424: p_bank_account_high IN VARCHAR2 ) IS
425: --
426: l_batch_rec ar_batches%ROWTYPE;
427: l_batch_applied_status ar_batches.batch_applied_status%TYPE;
428: l_request_id ar_batches.request_id%TYPE;
429: l_confirm_required VARCHAR2(1);
430: CURSOR c_receipt_class IS
431: SELECT confirm_flag
424: p_bank_account_high IN VARCHAR2 ) IS
425: --
426: l_batch_rec ar_batches%ROWTYPE;
427: l_batch_applied_status ar_batches.batch_applied_status%TYPE;
428: l_request_id ar_batches.request_id%TYPE;
429: l_confirm_required VARCHAR2(1);
430: CURSOR c_receipt_class IS
431: SELECT confirm_flag
432: FROM ar_receipt_classes
715: | |
716: +===========================================================================*/
717: PROCEDURE validate_args_insert_auto(
718: p_row_id IN VARCHAR2,
719: p_batch_id IN ar_batches.batch_id%TYPE,
720: p_type IN ar_batches.type%TYPE,
721: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
722: p_name IN ar_batches.name%TYPE,
723: p_currency_code IN ar_batches.currency_code%TYPE,
716: +===========================================================================*/
717: PROCEDURE validate_args_insert_auto(
718: p_row_id IN VARCHAR2,
719: p_batch_id IN ar_batches.batch_id%TYPE,
720: p_type IN ar_batches.type%TYPE,
721: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
722: p_name IN ar_batches.name%TYPE,
723: p_currency_code IN ar_batches.currency_code%TYPE,
724: p_batch_date IN ar_batches.batch_date%TYPE,
717: PROCEDURE validate_args_insert_auto(
718: p_row_id IN VARCHAR2,
719: p_batch_id IN ar_batches.batch_id%TYPE,
720: p_type IN ar_batches.type%TYPE,
721: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
722: p_name IN ar_batches.name%TYPE,
723: p_currency_code IN ar_batches.currency_code%TYPE,
724: p_batch_date IN ar_batches.batch_date%TYPE,
725: p_receipt_class_id IN
718: p_row_id IN VARCHAR2,
719: p_batch_id IN ar_batches.batch_id%TYPE,
720: p_type IN ar_batches.type%TYPE,
721: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
722: p_name IN ar_batches.name%TYPE,
723: p_currency_code IN ar_batches.currency_code%TYPE,
724: p_batch_date IN ar_batches.batch_date%TYPE,
725: p_receipt_class_id IN
726: ar_batches.receipt_class_id%TYPE,
719: p_batch_id IN ar_batches.batch_id%TYPE,
720: p_type IN ar_batches.type%TYPE,
721: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
722: p_name IN ar_batches.name%TYPE,
723: p_currency_code IN ar_batches.currency_code%TYPE,
724: p_batch_date IN ar_batches.batch_date%TYPE,
725: p_receipt_class_id IN
726: ar_batches.receipt_class_id%TYPE,
727: p_receipt_method_id IN
720: p_type IN ar_batches.type%TYPE,
721: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
722: p_name IN ar_batches.name%TYPE,
723: p_currency_code IN ar_batches.currency_code%TYPE,
724: p_batch_date IN ar_batches.batch_date%TYPE,
725: p_receipt_class_id IN
726: ar_batches.receipt_class_id%TYPE,
727: p_receipt_method_id IN
728: ar_batches.receipt_method_id%TYPE,
722: p_name IN ar_batches.name%TYPE,
723: p_currency_code IN ar_batches.currency_code%TYPE,
724: p_batch_date IN ar_batches.batch_date%TYPE,
725: p_receipt_class_id IN
726: ar_batches.receipt_class_id%TYPE,
727: p_receipt_method_id IN
728: ar_batches.receipt_method_id%TYPE,
729: p_batch_applied_status IN ar_batches.batch_applied_status%TYPE ) IS
730: l_field VARCHAR2(30);
724: p_batch_date IN ar_batches.batch_date%TYPE,
725: p_receipt_class_id IN
726: ar_batches.receipt_class_id%TYPE,
727: p_receipt_method_id IN
728: ar_batches.receipt_method_id%TYPE,
729: p_batch_applied_status IN ar_batches.batch_applied_status%TYPE ) IS
730: l_field VARCHAR2(30);
731: BEGIN
732: IF PG_DEBUG in ('Y', 'C') THEN
725: p_receipt_class_id IN
726: ar_batches.receipt_class_id%TYPE,
727: p_receipt_method_id IN
728: ar_batches.receipt_method_id%TYPE,
729: p_batch_applied_status IN ar_batches.batch_applied_status%TYPE ) IS
730: l_field VARCHAR2(30);
731: BEGIN
732: IF PG_DEBUG in ('Y', 'C') THEN
733: arp_util.debug( 'arp_rw_batches_pkg.validate_args_insert_auto()+' );
776: END validate_args_insert_auto;
777: --
778: /*===========================================================================+
779: | PROCEDURE |
780: | insert_remit_batch - Insert a row AR_BATCHES table after checking for|
781: | uniqueness |
782: | |
783: | DESCRIPTION |
784: | This function inserts a row in AR_BATCHES table after checking for |
780: | insert_remit_batch - Insert a row AR_BATCHES table after checking for|
781: | uniqueness |
782: | |
783: | DESCRIPTION |
784: | This function inserts a row in AR_BATCHES table after checking for |
785: | uniqueness for items such as NAME, MEDIA_REFERENCE, GL_DATE |
786: | |
787: | SCOPE - PUBLIC |
788: | |
815: | consolidated bank accounts changes |
816: +===========================================================================*/
817: PROCEDURE insert_remit_batch(
818: p_row_id IN OUT NOCOPY VARCHAR2,
819: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
820: p_batch_date IN ar_batches.batch_date%TYPE,
821: p_currency_code IN ar_batches.currency_code%TYPE,
822: p_name IN OUT NOCOPY ar_batches.name%TYPE,
823: p_comments IN ar_batches.comments%TYPE,
816: +===========================================================================*/
817: PROCEDURE insert_remit_batch(
818: p_row_id IN OUT NOCOPY VARCHAR2,
819: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
820: p_batch_date IN ar_batches.batch_date%TYPE,
821: p_currency_code IN ar_batches.currency_code%TYPE,
822: p_name IN OUT NOCOPY ar_batches.name%TYPE,
823: p_comments IN ar_batches.comments%TYPE,
824: p_exchange_date IN ar_batches.exchange_date%TYPE,
817: PROCEDURE insert_remit_batch(
818: p_row_id IN OUT NOCOPY VARCHAR2,
819: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
820: p_batch_date IN ar_batches.batch_date%TYPE,
821: p_currency_code IN ar_batches.currency_code%TYPE,
822: p_name IN OUT NOCOPY ar_batches.name%TYPE,
823: p_comments IN ar_batches.comments%TYPE,
824: p_exchange_date IN ar_batches.exchange_date%TYPE,
825: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
818: p_row_id IN OUT NOCOPY VARCHAR2,
819: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
820: p_batch_date IN ar_batches.batch_date%TYPE,
821: p_currency_code IN ar_batches.currency_code%TYPE,
822: p_name IN OUT NOCOPY ar_batches.name%TYPE,
823: p_comments IN ar_batches.comments%TYPE,
824: p_exchange_date IN ar_batches.exchange_date%TYPE,
825: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
826: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
819: p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
820: p_batch_date IN ar_batches.batch_date%TYPE,
821: p_currency_code IN ar_batches.currency_code%TYPE,
822: p_name IN OUT NOCOPY ar_batches.name%TYPE,
823: p_comments IN ar_batches.comments%TYPE,
824: p_exchange_date IN ar_batches.exchange_date%TYPE,
825: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
826: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
827: p_gl_date IN ar_batches.gl_date%TYPE,
820: p_batch_date IN ar_batches.batch_date%TYPE,
821: p_currency_code IN ar_batches.currency_code%TYPE,
822: p_name IN OUT NOCOPY ar_batches.name%TYPE,
823: p_comments IN ar_batches.comments%TYPE,
824: p_exchange_date IN ar_batches.exchange_date%TYPE,
825: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
826: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
827: p_gl_date IN ar_batches.gl_date%TYPE,
828: p_media_reference IN ar_batches.media_reference%TYPE,
821: p_currency_code IN ar_batches.currency_code%TYPE,
822: p_name IN OUT NOCOPY ar_batches.name%TYPE,
823: p_comments IN ar_batches.comments%TYPE,
824: p_exchange_date IN ar_batches.exchange_date%TYPE,
825: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
826: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
827: p_gl_date IN ar_batches.gl_date%TYPE,
828: p_media_reference IN ar_batches.media_reference%TYPE,
829: p_remit_method_code IN ar_batches.remit_method_code%TYPE,
822: p_name IN OUT NOCOPY ar_batches.name%TYPE,
823: p_comments IN ar_batches.comments%TYPE,
824: p_exchange_date IN ar_batches.exchange_date%TYPE,
825: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
826: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
827: p_gl_date IN ar_batches.gl_date%TYPE,
828: p_media_reference IN ar_batches.media_reference%TYPE,
829: p_remit_method_code IN ar_batches.remit_method_code%TYPE,
830: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
823: p_comments IN ar_batches.comments%TYPE,
824: p_exchange_date IN ar_batches.exchange_date%TYPE,
825: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
826: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
827: p_gl_date IN ar_batches.gl_date%TYPE,
828: p_media_reference IN ar_batches.media_reference%TYPE,
829: p_remit_method_code IN ar_batches.remit_method_code%TYPE,
830: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
831: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
824: p_exchange_date IN ar_batches.exchange_date%TYPE,
825: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
826: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
827: p_gl_date IN ar_batches.gl_date%TYPE,
828: p_media_reference IN ar_batches.media_reference%TYPE,
829: p_remit_method_code IN ar_batches.remit_method_code%TYPE,
830: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
831: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
832: p_remittance_bank_account_id
825: p_exchange_rate IN ar_batches.exchange_rate%TYPE,
826: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
827: p_gl_date IN ar_batches.gl_date%TYPE,
828: p_media_reference IN ar_batches.media_reference%TYPE,
829: p_remit_method_code IN ar_batches.remit_method_code%TYPE,
830: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
831: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
832: p_remittance_bank_account_id
833: IN ar_batches.remit_bank_acct_use_id%TYPE,
826: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
827: p_gl_date IN ar_batches.gl_date%TYPE,
828: p_media_reference IN ar_batches.media_reference%TYPE,
829: p_remit_method_code IN ar_batches.remit_method_code%TYPE,
830: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
831: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
832: p_remittance_bank_account_id
833: IN ar_batches.remit_bank_acct_use_id%TYPE,
834: p_remittance_bank_branch_id
827: p_gl_date IN ar_batches.gl_date%TYPE,
828: p_media_reference IN ar_batches.media_reference%TYPE,
829: p_remit_method_code IN ar_batches.remit_method_code%TYPE,
830: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
831: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
832: p_remittance_bank_account_id
833: IN ar_batches.remit_bank_acct_use_id%TYPE,
834: p_remittance_bank_branch_id
835: IN ar_batches.remittance_bank_branch_id%TYPE,
829: p_remit_method_code IN ar_batches.remit_method_code%TYPE,
830: p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
831: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
832: p_remittance_bank_account_id
833: IN ar_batches.remit_bank_acct_use_id%TYPE,
834: p_remittance_bank_branch_id
835: IN ar_batches.remittance_bank_branch_id%TYPE,
836: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
837: p_attribute_category IN ar_batches.attribute_category%TYPE,
831: p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
832: p_remittance_bank_account_id
833: IN ar_batches.remit_bank_acct_use_id%TYPE,
834: p_remittance_bank_branch_id
835: IN ar_batches.remittance_bank_branch_id%TYPE,
836: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
837: p_attribute_category IN ar_batches.attribute_category%TYPE,
838: p_attribute1 IN ar_batches.attribute1%TYPE,
839: p_attribute2 IN ar_batches.attribute2%TYPE,
832: p_remittance_bank_account_id
833: IN ar_batches.remit_bank_acct_use_id%TYPE,
834: p_remittance_bank_branch_id
835: IN ar_batches.remittance_bank_branch_id%TYPE,
836: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
837: p_attribute_category IN ar_batches.attribute_category%TYPE,
838: p_attribute1 IN ar_batches.attribute1%TYPE,
839: p_attribute2 IN ar_batches.attribute2%TYPE,
840: p_attribute3 IN ar_batches.attribute3%TYPE,
833: IN ar_batches.remit_bank_acct_use_id%TYPE,
834: p_remittance_bank_branch_id
835: IN ar_batches.remittance_bank_branch_id%TYPE,
836: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
837: p_attribute_category IN ar_batches.attribute_category%TYPE,
838: p_attribute1 IN ar_batches.attribute1%TYPE,
839: p_attribute2 IN ar_batches.attribute2%TYPE,
840: p_attribute3 IN ar_batches.attribute3%TYPE,
841: p_attribute4 IN ar_batches.attribute4%TYPE,
834: p_remittance_bank_branch_id
835: IN ar_batches.remittance_bank_branch_id%TYPE,
836: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
837: p_attribute_category IN ar_batches.attribute_category%TYPE,
838: p_attribute1 IN ar_batches.attribute1%TYPE,
839: p_attribute2 IN ar_batches.attribute2%TYPE,
840: p_attribute3 IN ar_batches.attribute3%TYPE,
841: p_attribute4 IN ar_batches.attribute4%TYPE,
842: p_attribute5 IN ar_batches.attribute5%TYPE,
835: IN ar_batches.remittance_bank_branch_id%TYPE,
836: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
837: p_attribute_category IN ar_batches.attribute_category%TYPE,
838: p_attribute1 IN ar_batches.attribute1%TYPE,
839: p_attribute2 IN ar_batches.attribute2%TYPE,
840: p_attribute3 IN ar_batches.attribute3%TYPE,
841: p_attribute4 IN ar_batches.attribute4%TYPE,
842: p_attribute5 IN ar_batches.attribute5%TYPE,
843: p_attribute6 IN ar_batches.attribute6%TYPE,
836: p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
837: p_attribute_category IN ar_batches.attribute_category%TYPE,
838: p_attribute1 IN ar_batches.attribute1%TYPE,
839: p_attribute2 IN ar_batches.attribute2%TYPE,
840: p_attribute3 IN ar_batches.attribute3%TYPE,
841: p_attribute4 IN ar_batches.attribute4%TYPE,
842: p_attribute5 IN ar_batches.attribute5%TYPE,
843: p_attribute6 IN ar_batches.attribute6%TYPE,
844: p_attribute7 IN ar_batches.attribute7%TYPE,
837: p_attribute_category IN ar_batches.attribute_category%TYPE,
838: p_attribute1 IN ar_batches.attribute1%TYPE,
839: p_attribute2 IN ar_batches.attribute2%TYPE,
840: p_attribute3 IN ar_batches.attribute3%TYPE,
841: p_attribute4 IN ar_batches.attribute4%TYPE,
842: p_attribute5 IN ar_batches.attribute5%TYPE,
843: p_attribute6 IN ar_batches.attribute6%TYPE,
844: p_attribute7 IN ar_batches.attribute7%TYPE,
845: p_attribute8 IN ar_batches.attribute8%TYPE,
838: p_attribute1 IN ar_batches.attribute1%TYPE,
839: p_attribute2 IN ar_batches.attribute2%TYPE,
840: p_attribute3 IN ar_batches.attribute3%TYPE,
841: p_attribute4 IN ar_batches.attribute4%TYPE,
842: p_attribute5 IN ar_batches.attribute5%TYPE,
843: p_attribute6 IN ar_batches.attribute6%TYPE,
844: p_attribute7 IN ar_batches.attribute7%TYPE,
845: p_attribute8 IN ar_batches.attribute8%TYPE,
846: p_attribute9 IN ar_batches.attribute9%TYPE,
839: p_attribute2 IN ar_batches.attribute2%TYPE,
840: p_attribute3 IN ar_batches.attribute3%TYPE,
841: p_attribute4 IN ar_batches.attribute4%TYPE,
842: p_attribute5 IN ar_batches.attribute5%TYPE,
843: p_attribute6 IN ar_batches.attribute6%TYPE,
844: p_attribute7 IN ar_batches.attribute7%TYPE,
845: p_attribute8 IN ar_batches.attribute8%TYPE,
846: p_attribute9 IN ar_batches.attribute9%TYPE,
847: p_attribute10 IN ar_batches.attribute10%TYPE,
840: p_attribute3 IN ar_batches.attribute3%TYPE,
841: p_attribute4 IN ar_batches.attribute4%TYPE,
842: p_attribute5 IN ar_batches.attribute5%TYPE,
843: p_attribute6 IN ar_batches.attribute6%TYPE,
844: p_attribute7 IN ar_batches.attribute7%TYPE,
845: p_attribute8 IN ar_batches.attribute8%TYPE,
846: p_attribute9 IN ar_batches.attribute9%TYPE,
847: p_attribute10 IN ar_batches.attribute10%TYPE,
848: p_attribute11 IN ar_batches.attribute11%TYPE,
841: p_attribute4 IN ar_batches.attribute4%TYPE,
842: p_attribute5 IN ar_batches.attribute5%TYPE,
843: p_attribute6 IN ar_batches.attribute6%TYPE,
844: p_attribute7 IN ar_batches.attribute7%TYPE,
845: p_attribute8 IN ar_batches.attribute8%TYPE,
846: p_attribute9 IN ar_batches.attribute9%TYPE,
847: p_attribute10 IN ar_batches.attribute10%TYPE,
848: p_attribute11 IN ar_batches.attribute11%TYPE,
849: p_attribute12 IN ar_batches.attribute12%TYPE,
842: p_attribute5 IN ar_batches.attribute5%TYPE,
843: p_attribute6 IN ar_batches.attribute6%TYPE,
844: p_attribute7 IN ar_batches.attribute7%TYPE,
845: p_attribute8 IN ar_batches.attribute8%TYPE,
846: p_attribute9 IN ar_batches.attribute9%TYPE,
847: p_attribute10 IN ar_batches.attribute10%TYPE,
848: p_attribute11 IN ar_batches.attribute11%TYPE,
849: p_attribute12 IN ar_batches.attribute12%TYPE,
850: p_attribute13 IN ar_batches.attribute13%TYPE,
843: p_attribute6 IN ar_batches.attribute6%TYPE,
844: p_attribute7 IN ar_batches.attribute7%TYPE,
845: p_attribute8 IN ar_batches.attribute8%TYPE,
846: p_attribute9 IN ar_batches.attribute9%TYPE,
847: p_attribute10 IN ar_batches.attribute10%TYPE,
848: p_attribute11 IN ar_batches.attribute11%TYPE,
849: p_attribute12 IN ar_batches.attribute12%TYPE,
850: p_attribute13 IN ar_batches.attribute13%TYPE,
851: p_attribute14 IN ar_batches.attribute14%TYPE,
844: p_attribute7 IN ar_batches.attribute7%TYPE,
845: p_attribute8 IN ar_batches.attribute8%TYPE,
846: p_attribute9 IN ar_batches.attribute9%TYPE,
847: p_attribute10 IN ar_batches.attribute10%TYPE,
848: p_attribute11 IN ar_batches.attribute11%TYPE,
849: p_attribute12 IN ar_batches.attribute12%TYPE,
850: p_attribute13 IN ar_batches.attribute13%TYPE,
851: p_attribute14 IN ar_batches.attribute14%TYPE,
852: p_attribute15 IN ar_batches.attribute15%TYPE,
845: p_attribute8 IN ar_batches.attribute8%TYPE,
846: p_attribute9 IN ar_batches.attribute9%TYPE,
847: p_attribute10 IN ar_batches.attribute10%TYPE,
848: p_attribute11 IN ar_batches.attribute11%TYPE,
849: p_attribute12 IN ar_batches.attribute12%TYPE,
850: p_attribute13 IN ar_batches.attribute13%TYPE,
851: p_attribute14 IN ar_batches.attribute14%TYPE,
852: p_attribute15 IN ar_batches.attribute15%TYPE,
853: p_auto_creation IN VARCHAR2,
846: p_attribute9 IN ar_batches.attribute9%TYPE,
847: p_attribute10 IN ar_batches.attribute10%TYPE,
848: p_attribute11 IN ar_batches.attribute11%TYPE,
849: p_attribute12 IN ar_batches.attribute12%TYPE,
850: p_attribute13 IN ar_batches.attribute13%TYPE,
851: p_attribute14 IN ar_batches.attribute14%TYPE,
852: p_attribute15 IN ar_batches.attribute15%TYPE,
853: p_auto_creation IN VARCHAR2,
854: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
847: p_attribute10 IN ar_batches.attribute10%TYPE,
848: p_attribute11 IN ar_batches.attribute11%TYPE,
849: p_attribute12 IN ar_batches.attribute12%TYPE,
850: p_attribute13 IN ar_batches.attribute13%TYPE,
851: p_attribute14 IN ar_batches.attribute14%TYPE,
852: p_attribute15 IN ar_batches.attribute15%TYPE,
853: p_auto_creation IN VARCHAR2,
854: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
855: p_module_name IN VARCHAR2,
848: p_attribute11 IN ar_batches.attribute11%TYPE,
849: p_attribute12 IN ar_batches.attribute12%TYPE,
850: p_attribute13 IN ar_batches.attribute13%TYPE,
851: p_attribute14 IN ar_batches.attribute14%TYPE,
852: p_attribute15 IN ar_batches.attribute15%TYPE,
853: p_auto_creation IN VARCHAR2,
854: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
855: p_module_name IN VARCHAR2,
856: p_module_version IN VARCHAR2 ) IS
850: p_attribute13 IN ar_batches.attribute13%TYPE,
851: p_attribute14 IN ar_batches.attribute14%TYPE,
852: p_attribute15 IN ar_batches.attribute15%TYPE,
853: p_auto_creation IN VARCHAR2,
854: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
855: p_module_name IN VARCHAR2,
856: p_module_version IN VARCHAR2 ) IS
857: --
858: l_batch_rec ar_batches%ROWTYPE;
854: p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
855: p_module_name IN VARCHAR2,
856: p_module_version IN VARCHAR2 ) IS
857: --
858: l_batch_rec ar_batches%ROWTYPE;
859: l_institution_type VARCHAR2(30);
860: CURSOR c_bank_branches IS
861: SELECT bank_institution_type
862: FROM ce_bank_branches_v
1176: | |
1177: +===========================================================================*/
1178: PROCEDURE validate_args_insert_remit(
1179: p_row_id IN VARCHAR2,
1180: p_batch_id IN ar_batches.batch_id%TYPE,
1181: p_type IN ar_batches.type%TYPE,
1182: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
1183: p_currency_code IN ar_batches.currency_code%TYPE,
1184: p_gl_date IN ar_batches.gl_date%TYPE,
1177: +===========================================================================*/
1178: PROCEDURE validate_args_insert_remit(
1179: p_row_id IN VARCHAR2,
1180: p_batch_id IN ar_batches.batch_id%TYPE,
1181: p_type IN ar_batches.type%TYPE,
1182: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
1183: p_currency_code IN ar_batches.currency_code%TYPE,
1184: p_gl_date IN ar_batches.gl_date%TYPE,
1185: p_batch_date IN ar_batches.batch_date%TYPE,
1178: PROCEDURE validate_args_insert_remit(
1179: p_row_id IN VARCHAR2,
1180: p_batch_id IN ar_batches.batch_id%TYPE,
1181: p_type IN ar_batches.type%TYPE,
1182: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
1183: p_currency_code IN ar_batches.currency_code%TYPE,
1184: p_gl_date IN ar_batches.gl_date%TYPE,
1185: p_batch_date IN ar_batches.batch_date%TYPE,
1186: p_remit_method_code IN ar_batches.remit_method_code%TYPE,
1179: p_row_id IN VARCHAR2,
1180: p_batch_id IN ar_batches.batch_id%TYPE,
1181: p_type IN ar_batches.type%TYPE,
1182: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
1183: p_currency_code IN ar_batches.currency_code%TYPE,
1184: p_gl_date IN ar_batches.gl_date%TYPE,
1185: p_batch_date IN ar_batches.batch_date%TYPE,
1186: p_remit_method_code IN ar_batches.remit_method_code%TYPE,
1187: p_remittance_bank_branch_id IN
1180: p_batch_id IN ar_batches.batch_id%TYPE,
1181: p_type IN ar_batches.type%TYPE,
1182: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
1183: p_currency_code IN ar_batches.currency_code%TYPE,
1184: p_gl_date IN ar_batches.gl_date%TYPE,
1185: p_batch_date IN ar_batches.batch_date%TYPE,
1186: p_remit_method_code IN ar_batches.remit_method_code%TYPE,
1187: p_remittance_bank_branch_id IN
1188: ar_batches.remittance_bank_branch_id%TYPE,
1181: p_type IN ar_batches.type%TYPE,
1182: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
1183: p_currency_code IN ar_batches.currency_code%TYPE,
1184: p_gl_date IN ar_batches.gl_date%TYPE,
1185: p_batch_date IN ar_batches.batch_date%TYPE,
1186: p_remit_method_code IN ar_batches.remit_method_code%TYPE,
1187: p_remittance_bank_branch_id IN
1188: ar_batches.remittance_bank_branch_id%TYPE,
1189: p_batch_applied_status IN ar_batches.batch_applied_status%TYPE ) IS
1182: p_set_of_books_id IN ar_batches.set_of_books_id%TYPE,
1183: p_currency_code IN ar_batches.currency_code%TYPE,
1184: p_gl_date IN ar_batches.gl_date%TYPE,
1185: p_batch_date IN ar_batches.batch_date%TYPE,
1186: p_remit_method_code IN ar_batches.remit_method_code%TYPE,
1187: p_remittance_bank_branch_id IN
1188: ar_batches.remittance_bank_branch_id%TYPE,
1189: p_batch_applied_status IN ar_batches.batch_applied_status%TYPE ) IS
1190: l_field VARCHAR2(30);
1184: p_gl_date IN ar_batches.gl_date%TYPE,
1185: p_batch_date IN ar_batches.batch_date%TYPE,
1186: p_remit_method_code IN ar_batches.remit_method_code%TYPE,
1187: p_remittance_bank_branch_id IN
1188: ar_batches.remittance_bank_branch_id%TYPE,
1189: p_batch_applied_status IN ar_batches.batch_applied_status%TYPE ) IS
1190: l_field VARCHAR2(30);
1191: BEGIN
1192: IF PG_DEBUG in ('Y', 'C') THEN
1185: p_batch_date IN ar_batches.batch_date%TYPE,
1186: p_remit_method_code IN ar_batches.remit_method_code%TYPE,
1187: p_remittance_bank_branch_id IN
1188: ar_batches.remittance_bank_branch_id%TYPE,
1189: p_batch_applied_status IN ar_batches.batch_applied_status%TYPE ) IS
1190: l_field VARCHAR2(30);
1191: BEGIN
1192: IF PG_DEBUG in ('Y', 'C') THEN
1193: arp_util.debug( 'arp_rw_batches_pkg.validate_args_insert_remit()+' );
1240: END IF;
1241: RAISE;
1242: END validate_args_insert_remit;
1243: --
1244: PROCEDURE delete_batch( p_batch_id IN ar_batches.batch_id%TYPE ) IS
1245: l_id NUMBER;
1246: BEGIN
1247: -- lock the records.
1248: SELECT batch_id
1246: BEGIN
1247: -- lock the records.
1248: SELECT batch_id
1249: INTO l_id
1250: FROM ar_batches
1251: WHERE batch_id = p_batch_id
1252: FOR UPDATE;
1253:
1254: -- detach the transactions assoicated with the batch and delete the batch.
1255: UPDATE ar_payment_schedules
1256: SET selected_for_receipt_batch_id = NULL
1257: WHERE selected_for_receipt_batch_id = p_batch_id;
1258:
1259: -- Call the table handler for ar_batches instead of doing delete here
1260: -- Bug: 2028370
1261: ARP_CR_BATCHES_PKG.delete_p(p_batch_id);
1262:
1263: -- DELETE ar_batches
1259: -- Call the table handler for ar_batches instead of doing delete here
1260: -- Bug: 2028370
1261: ARP_CR_BATCHES_PKG.delete_p(p_batch_id);
1262:
1263: -- DELETE ar_batches
1264: -- WHERE batch_id = p_batch_id;
1265:
1266: EXCEPTION
1267: WHEN OTHERS THEN