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,
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,
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,
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,
33 p_h_attribute1 In Fun_Interface_Headers.attribute1%type,
34 p_h_attribute2 In Fun_Interface_Headers.attribute2%type,
35 p_h_attribute3 In Fun_Interface_Headers.attribute3%type,
36 p_h_attribute4 In Fun_Interface_Headers.attribute4%type,
37 p_h_attribute5 In Fun_Interface_Headers.attribute5%type,
38 p_h_attribute6 In Fun_Interface_Headers.attribute6%type,
39 p_h_attribute7 In Fun_Interface_Headers.attribute7%type,
40 p_h_attribute8 In Fun_Interface_Headers.attribute8%type,
41 p_h_attribute9 In Fun_Interface_Headers.attribute9%type,
42 p_h_attribute10 In Fun_Interface_Headers.attribute10%type,
43 p_h_attribute11 In Fun_Interface_Headers.attribute11%type,
44 p_h_attribute12 In Fun_Interface_Headers.attribute12%type,
45 p_h_attribute13 In Fun_Interface_Headers.attribute13%type,
46 p_h_attribute14 In Fun_Interface_Headers.attribute14%type,
47 p_h_attribute15 In Fun_Interface_Headers.attribute15%type,
48 p_h_attribute_category In Fun_Interface_Headers.attribute_category%type,
49 p_id_ccid In Fun_Interface_Dist_Lines.ccid%type,
50 p_id_amount_dr In Fun_Interface_Dist_Lines.amount_dr%type,
51 p_id_amount_cr In Fun_Interface_Dist_Lines.amount_cr%type,
52 p_id_description In Fun_Interface_Dist_Lines.description%type,
53 p_id_attribute1 In Fun_Interface_Dist_Lines.attribute1%type,
54 p_id_attribute2 In Fun_Interface_Dist_Lines.attribute2%type,
55 p_id_attribute3 In Fun_Interface_Dist_Lines.attribute3%type,
56 p_id_attribute4 In Fun_Interface_Dist_Lines.attribute4%type,
57 p_id_attribute5 In Fun_Interface_Dist_Lines.attribute5%type,
58 p_id_attribute6 In Fun_Interface_Dist_Lines.attribute6%type,
59 p_id_attribute7 In Fun_Interface_Dist_Lines.attribute7%type,
60 p_id_attribute8 In Fun_Interface_Dist_Lines.attribute8%type,
61 p_id_attribute9 In Fun_Interface_Dist_Lines.attribute9%type,
62 p_id_attribute10 In Fun_Interface_Dist_Lines.attribute10%type,
63 p_id_attribute11 In Fun_Interface_Dist_Lines.attribute11%type,
64 p_id_attribute12 In Fun_Interface_Dist_Lines.attribute12%type,
65 p_id_attribute13 In Fun_Interface_Dist_Lines.attribute13%type,
66 p_id_attribute14 In Fun_Interface_Dist_Lines.attribute14%type,
67 p_id_attribute15 In Fun_Interface_Dist_Lines.attribute15%type,
68 p_id_attribute_category In Fun_Interface_Dist_Lines.attribute_category%type,
69 p_rd_ccid_segments In Varchar2,
70 p_rd_ccid In Fun_Interface_Dist_Lines.ccid%type,
71 p_rd_amount_dr In Fun_Interface_Dist_Lines.amount_dr%type,
72 p_rd_amount_cr In Fun_Interface_Dist_Lines.amount_cr%type,
73 p_rd_description In Fun_Interface_Dist_Lines.description%type,
74
75 p_dist_number In Fun_Interface_Dist_Lines.dist_number%type);
76
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(
86 p_batch_number In Fun_Interface_Batches.batch_number%type);
87 End FUN_WEBADI_PKG;