1: Package FUN_WEBADI_PKG AUTHID CURRENT_USER As
2: -- $Header: funwadis.pls 120.2.12020000.2 2012/07/27 11:33:14 srampure ship $
3:
4: Procedure Upload_Batch(
5: p_batch_number In Fun_Interface_Batches.batch_number%type,
6: p_initiator_name In Fun_Interface_Batches.initiator_name%type,
7: p_currency_code In Fun_Interface_Batches.currency_code%type,
8: p_batch_date In Fun_Interface_Batches.batch_date%type,
9: p_gl_date In Fun_Interface_Batches.gl_date%type,
2: -- $Header: funwadis.pls 120.2.12020000.2 2012/07/27 11:33:14 srampure ship $
3:
4: Procedure Upload_Batch(
5: p_batch_number In Fun_Interface_Batches.batch_number%type,
6: p_initiator_name In Fun_Interface_Batches.initiator_name%type,
7: p_currency_code In Fun_Interface_Batches.currency_code%type,
8: p_batch_date In Fun_Interface_Batches.batch_date%type,
9: p_gl_date In Fun_Interface_Batches.gl_date%type,
10: p_trx_type_name In Fun_Interface_Batches.trx_type_name%type,
3:
4: Procedure Upload_Batch(
5: p_batch_number In Fun_Interface_Batches.batch_number%type,
6: p_initiator_name In Fun_Interface_Batches.initiator_name%type,
7: p_currency_code In Fun_Interface_Batches.currency_code%type,
8: p_batch_date In Fun_Interface_Batches.batch_date%type,
9: p_gl_date In Fun_Interface_Batches.gl_date%type,
10: p_trx_type_name In Fun_Interface_Batches.trx_type_name%type,
11: p_description In Fun_Interface_Batches.description%type,
4: Procedure Upload_Batch(
5: p_batch_number In Fun_Interface_Batches.batch_number%type,
6: p_initiator_name In Fun_Interface_Batches.initiator_name%type,
7: p_currency_code In Fun_Interface_Batches.currency_code%type,
8: p_batch_date In Fun_Interface_Batches.batch_date%type,
9: p_gl_date In Fun_Interface_Batches.gl_date%type,
10: p_trx_type_name In Fun_Interface_Batches.trx_type_name%type,
11: p_description In Fun_Interface_Batches.description%type,
12: p_note In Fun_Interface_Batches.note%type,
5: p_batch_number In Fun_Interface_Batches.batch_number%type,
6: p_initiator_name In Fun_Interface_Batches.initiator_name%type,
7: p_currency_code In Fun_Interface_Batches.currency_code%type,
8: p_batch_date In Fun_Interface_Batches.batch_date%type,
9: p_gl_date In Fun_Interface_Batches.gl_date%type,
10: p_trx_type_name In Fun_Interface_Batches.trx_type_name%type,
11: p_description In Fun_Interface_Batches.description%type,
12: p_note In Fun_Interface_Batches.note%type,
13: p_attribute1 In Fun_Interface_Batches.attribute1%type,
6: p_initiator_name In Fun_Interface_Batches.initiator_name%type,
7: p_currency_code In Fun_Interface_Batches.currency_code%type,
8: p_batch_date In Fun_Interface_Batches.batch_date%type,
9: p_gl_date In Fun_Interface_Batches.gl_date%type,
10: p_trx_type_name In Fun_Interface_Batches.trx_type_name%type,
11: p_description In Fun_Interface_Batches.description%type,
12: p_note In Fun_Interface_Batches.note%type,
13: p_attribute1 In Fun_Interface_Batches.attribute1%type,
14: p_attribute2 In Fun_Interface_Batches.attribute2%type,
7: p_currency_code In Fun_Interface_Batches.currency_code%type,
8: p_batch_date In Fun_Interface_Batches.batch_date%type,
9: p_gl_date In Fun_Interface_Batches.gl_date%type,
10: p_trx_type_name In Fun_Interface_Batches.trx_type_name%type,
11: p_description In Fun_Interface_Batches.description%type,
12: p_note In Fun_Interface_Batches.note%type,
13: p_attribute1 In Fun_Interface_Batches.attribute1%type,
14: p_attribute2 In Fun_Interface_Batches.attribute2%type,
15: p_attribute3 In Fun_Interface_Batches.attribute3%type,
8: p_batch_date In Fun_Interface_Batches.batch_date%type,
9: p_gl_date In Fun_Interface_Batches.gl_date%type,
10: p_trx_type_name In Fun_Interface_Batches.trx_type_name%type,
11: p_description In Fun_Interface_Batches.description%type,
12: p_note In Fun_Interface_Batches.note%type,
13: p_attribute1 In Fun_Interface_Batches.attribute1%type,
14: p_attribute2 In Fun_Interface_Batches.attribute2%type,
15: p_attribute3 In Fun_Interface_Batches.attribute3%type,
16: p_attribute4 In Fun_Interface_Batches.attribute4%type,
9: p_gl_date In Fun_Interface_Batches.gl_date%type,
10: p_trx_type_name In Fun_Interface_Batches.trx_type_name%type,
11: p_description In Fun_Interface_Batches.description%type,
12: p_note In Fun_Interface_Batches.note%type,
13: p_attribute1 In Fun_Interface_Batches.attribute1%type,
14: p_attribute2 In Fun_Interface_Batches.attribute2%type,
15: p_attribute3 In Fun_Interface_Batches.attribute3%type,
16: p_attribute4 In Fun_Interface_Batches.attribute4%type,
17: p_attribute5 In Fun_Interface_Batches.attribute5%type,
10: p_trx_type_name In Fun_Interface_Batches.trx_type_name%type,
11: p_description In Fun_Interface_Batches.description%type,
12: p_note In Fun_Interface_Batches.note%type,
13: p_attribute1 In Fun_Interface_Batches.attribute1%type,
14: p_attribute2 In Fun_Interface_Batches.attribute2%type,
15: p_attribute3 In Fun_Interface_Batches.attribute3%type,
16: p_attribute4 In Fun_Interface_Batches.attribute4%type,
17: p_attribute5 In Fun_Interface_Batches.attribute5%type,
18: p_attribute6 In Fun_Interface_Batches.attribute6%type,
11: p_description In Fun_Interface_Batches.description%type,
12: p_note In Fun_Interface_Batches.note%type,
13: p_attribute1 In Fun_Interface_Batches.attribute1%type,
14: p_attribute2 In Fun_Interface_Batches.attribute2%type,
15: p_attribute3 In Fun_Interface_Batches.attribute3%type,
16: p_attribute4 In Fun_Interface_Batches.attribute4%type,
17: p_attribute5 In Fun_Interface_Batches.attribute5%type,
18: p_attribute6 In Fun_Interface_Batches.attribute6%type,
19: p_attribute7 In Fun_Interface_Batches.attribute7%type,
12: p_note In Fun_Interface_Batches.note%type,
13: p_attribute1 In Fun_Interface_Batches.attribute1%type,
14: p_attribute2 In Fun_Interface_Batches.attribute2%type,
15: p_attribute3 In Fun_Interface_Batches.attribute3%type,
16: p_attribute4 In Fun_Interface_Batches.attribute4%type,
17: p_attribute5 In Fun_Interface_Batches.attribute5%type,
18: p_attribute6 In Fun_Interface_Batches.attribute6%type,
19: p_attribute7 In Fun_Interface_Batches.attribute7%type,
20: p_attribute8 In Fun_Interface_Batches.attribute8%type,
13: p_attribute1 In Fun_Interface_Batches.attribute1%type,
14: p_attribute2 In Fun_Interface_Batches.attribute2%type,
15: p_attribute3 In Fun_Interface_Batches.attribute3%type,
16: p_attribute4 In Fun_Interface_Batches.attribute4%type,
17: p_attribute5 In Fun_Interface_Batches.attribute5%type,
18: p_attribute6 In Fun_Interface_Batches.attribute6%type,
19: p_attribute7 In Fun_Interface_Batches.attribute7%type,
20: p_attribute8 In Fun_Interface_Batches.attribute8%type,
21: p_attribute9 In Fun_Interface_Batches.attribute9%type,
14: p_attribute2 In Fun_Interface_Batches.attribute2%type,
15: p_attribute3 In Fun_Interface_Batches.attribute3%type,
16: p_attribute4 In Fun_Interface_Batches.attribute4%type,
17: p_attribute5 In Fun_Interface_Batches.attribute5%type,
18: p_attribute6 In Fun_Interface_Batches.attribute6%type,
19: p_attribute7 In Fun_Interface_Batches.attribute7%type,
20: p_attribute8 In Fun_Interface_Batches.attribute8%type,
21: p_attribute9 In Fun_Interface_Batches.attribute9%type,
22: p_attribute10 In Fun_Interface_Batches.attribute10%type,
15: p_attribute3 In Fun_Interface_Batches.attribute3%type,
16: p_attribute4 In Fun_Interface_Batches.attribute4%type,
17: p_attribute5 In Fun_Interface_Batches.attribute5%type,
18: p_attribute6 In Fun_Interface_Batches.attribute6%type,
19: p_attribute7 In Fun_Interface_Batches.attribute7%type,
20: p_attribute8 In Fun_Interface_Batches.attribute8%type,
21: p_attribute9 In Fun_Interface_Batches.attribute9%type,
22: p_attribute10 In Fun_Interface_Batches.attribute10%type,
23: p_attribute11 In Fun_Interface_Batches.attribute11%type,
16: p_attribute4 In Fun_Interface_Batches.attribute4%type,
17: p_attribute5 In Fun_Interface_Batches.attribute5%type,
18: p_attribute6 In Fun_Interface_Batches.attribute6%type,
19: p_attribute7 In Fun_Interface_Batches.attribute7%type,
20: p_attribute8 In Fun_Interface_Batches.attribute8%type,
21: p_attribute9 In Fun_Interface_Batches.attribute9%type,
22: p_attribute10 In Fun_Interface_Batches.attribute10%type,
23: p_attribute11 In Fun_Interface_Batches.attribute11%type,
24: p_attribute12 In Fun_Interface_Batches.attribute12%type,
17: p_attribute5 In Fun_Interface_Batches.attribute5%type,
18: p_attribute6 In Fun_Interface_Batches.attribute6%type,
19: p_attribute7 In Fun_Interface_Batches.attribute7%type,
20: p_attribute8 In Fun_Interface_Batches.attribute8%type,
21: p_attribute9 In Fun_Interface_Batches.attribute9%type,
22: p_attribute10 In Fun_Interface_Batches.attribute10%type,
23: p_attribute11 In Fun_Interface_Batches.attribute11%type,
24: p_attribute12 In Fun_Interface_Batches.attribute12%type,
25: p_attribute13 In Fun_Interface_Batches.attribute13%type,
18: p_attribute6 In Fun_Interface_Batches.attribute6%type,
19: p_attribute7 In Fun_Interface_Batches.attribute7%type,
20: p_attribute8 In Fun_Interface_Batches.attribute8%type,
21: p_attribute9 In Fun_Interface_Batches.attribute9%type,
22: p_attribute10 In Fun_Interface_Batches.attribute10%type,
23: p_attribute11 In Fun_Interface_Batches.attribute11%type,
24: p_attribute12 In Fun_Interface_Batches.attribute12%type,
25: p_attribute13 In Fun_Interface_Batches.attribute13%type,
26: p_attribute14 In Fun_Interface_Batches.attribute14%type,
19: p_attribute7 In Fun_Interface_Batches.attribute7%type,
20: p_attribute8 In Fun_Interface_Batches.attribute8%type,
21: p_attribute9 In Fun_Interface_Batches.attribute9%type,
22: p_attribute10 In Fun_Interface_Batches.attribute10%type,
23: p_attribute11 In Fun_Interface_Batches.attribute11%type,
24: p_attribute12 In Fun_Interface_Batches.attribute12%type,
25: p_attribute13 In Fun_Interface_Batches.attribute13%type,
26: p_attribute14 In Fun_Interface_Batches.attribute14%type,
27: p_attribute15 In Fun_Interface_Batches.attribute15%type,
20: p_attribute8 In Fun_Interface_Batches.attribute8%type,
21: p_attribute9 In Fun_Interface_Batches.attribute9%type,
22: p_attribute10 In Fun_Interface_Batches.attribute10%type,
23: p_attribute11 In Fun_Interface_Batches.attribute11%type,
24: p_attribute12 In Fun_Interface_Batches.attribute12%type,
25: p_attribute13 In Fun_Interface_Batches.attribute13%type,
26: p_attribute14 In Fun_Interface_Batches.attribute14%type,
27: p_attribute15 In Fun_Interface_Batches.attribute15%type,
28: p_attribute_category In Fun_Interface_Batches.attribute_category%type,
21: p_attribute9 In Fun_Interface_Batches.attribute9%type,
22: p_attribute10 In Fun_Interface_Batches.attribute10%type,
23: p_attribute11 In Fun_Interface_Batches.attribute11%type,
24: p_attribute12 In Fun_Interface_Batches.attribute12%type,
25: p_attribute13 In Fun_Interface_Batches.attribute13%type,
26: p_attribute14 In Fun_Interface_Batches.attribute14%type,
27: p_attribute15 In Fun_Interface_Batches.attribute15%type,
28: p_attribute_category In Fun_Interface_Batches.attribute_category%type,
29: p_trx_number In Fun_Interface_Headers.trx_number%type,
22: p_attribute10 In Fun_Interface_Batches.attribute10%type,
23: p_attribute11 In Fun_Interface_Batches.attribute11%type,
24: p_attribute12 In Fun_Interface_Batches.attribute12%type,
25: p_attribute13 In Fun_Interface_Batches.attribute13%type,
26: p_attribute14 In Fun_Interface_Batches.attribute14%type,
27: p_attribute15 In Fun_Interface_Batches.attribute15%type,
28: p_attribute_category In Fun_Interface_Batches.attribute_category%type,
29: p_trx_number In Fun_Interface_Headers.trx_number%type,
30: p_recipient_name In Fun_Interface_Headers.recipient_name%type,
23: p_attribute11 In Fun_Interface_Batches.attribute11%type,
24: p_attribute12 In Fun_Interface_Batches.attribute12%type,
25: p_attribute13 In Fun_Interface_Batches.attribute13%type,
26: p_attribute14 In Fun_Interface_Batches.attribute14%type,
27: p_attribute15 In Fun_Interface_Batches.attribute15%type,
28: p_attribute_category In Fun_Interface_Batches.attribute_category%type,
29: p_trx_number In Fun_Interface_Headers.trx_number%type,
30: p_recipient_name In Fun_Interface_Headers.recipient_name%type,
31: p_init_amount_dr In Fun_Interface_Headers.init_amount_dr%type,
24: p_attribute12 In Fun_Interface_Batches.attribute12%type,
25: p_attribute13 In Fun_Interface_Batches.attribute13%type,
26: p_attribute14 In Fun_Interface_Batches.attribute14%type,
27: p_attribute15 In Fun_Interface_Batches.attribute15%type,
28: p_attribute_category In Fun_Interface_Batches.attribute_category%type,
29: p_trx_number In Fun_Interface_Headers.trx_number%type,
30: p_recipient_name In Fun_Interface_Headers.recipient_name%type,
31: p_init_amount_dr In Fun_Interface_Headers.init_amount_dr%type,
32: p_init_amount_cr In Fun_Interface_Headers.init_amount_cr%type,
77: /**
78: *Bug: 10095345. This procedure is called from importer.
79: */
80: Procedure Import_Batch(
81: p_batch_number In Fun_Interface_Batches.batch_number%type);
82:
83: --Bug: 10095345
84:
85: Procedure Delete_Batch(
82:
83: --Bug: 10095345
84:
85: Procedure Delete_Batch(
86: p_batch_number In Fun_Interface_Batches.batch_number%type);
87: End FUN_WEBADI_PKG;