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