1 package okl_lease_quote_cashflow_pvt_w AUTHID CURRENT_USER as
2 /* $Header: OKLEQUCS.pls 120.5 2006/02/10 07:41:36 asawanka noship $ */
3 procedure rosetta_table_copy_in_p21(t out nocopy okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_DATE_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_VARCHAR2_TABLE_100
12 , a9 JTF_VARCHAR2_TABLE_100
13 );
14 procedure rosetta_table_copy_out_p21(t okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15 , a1 out nocopy JTF_DATE_TABLE
16 , a2 out nocopy JTF_NUMBER_TABLE
17 , a3 out nocopy JTF_NUMBER_TABLE
18 , a4 out nocopy JTF_NUMBER_TABLE
19 , a5 out nocopy JTF_NUMBER_TABLE
20 , a6 out nocopy JTF_NUMBER_TABLE
21 , a7 out nocopy JTF_NUMBER_TABLE
22 , a8 out nocopy JTF_VARCHAR2_TABLE_100
23 , a9 out nocopy JTF_VARCHAR2_TABLE_100
24 );
25
26 procedure create_cashflow(p_api_version NUMBER
27 , p_init_msg_list VARCHAR2
28 , p_transaction_control VARCHAR2
29 , p3_a0 in out nocopy VARCHAR2
30 , p3_a1 in out nocopy NUMBER
31 , p3_a2 in out nocopy VARCHAR2
32 , p3_a3 in out nocopy VARCHAR2
33 , p3_a4 in out nocopy VARCHAR2
34 , p3_a5 in out nocopy VARCHAR2
35 , p3_a6 in out nocopy VARCHAR2
36 , p3_a7 in out nocopy VARCHAR2
37 , p3_a8 in out nocopy NUMBER
38 , p3_a9 in out nocopy VARCHAR2
39 , p3_a10 in out nocopy NUMBER
40 , p3_a11 in out nocopy NUMBER
41 , p3_a12 in out nocopy NUMBER
42 , p3_a13 in out nocopy NUMBER
43 , p4_a0 in out nocopy JTF_NUMBER_TABLE
44 , p4_a1 in out nocopy JTF_DATE_TABLE
45 , p4_a2 in out nocopy JTF_NUMBER_TABLE
46 , p4_a3 in out nocopy JTF_NUMBER_TABLE
47 , p4_a4 in out nocopy JTF_NUMBER_TABLE
48 , p4_a5 in out nocopy JTF_NUMBER_TABLE
49 , p4_a6 in out nocopy JTF_NUMBER_TABLE
50 , p4_a7 in out nocopy JTF_NUMBER_TABLE
51 , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
52 , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
53 , x_return_status out nocopy VARCHAR2
54 , x_msg_count out nocopy NUMBER
55 , x_msg_data out nocopy VARCHAR2
56 );
57 procedure update_cashflow(p_api_version NUMBER
58 , p_init_msg_list VARCHAR2
59 , p_transaction_control VARCHAR2
60 , p3_a0 in out nocopy VARCHAR2
61 , p3_a1 in out nocopy NUMBER
62 , p3_a2 in out nocopy VARCHAR2
63 , p3_a3 in out nocopy VARCHAR2
64 , p3_a4 in out nocopy VARCHAR2
65 , p3_a5 in out nocopy VARCHAR2
66 , p3_a6 in out nocopy VARCHAR2
67 , p3_a7 in out nocopy VARCHAR2
68 , p3_a8 in out nocopy NUMBER
69 , p3_a9 in out nocopy VARCHAR2
70 , p3_a10 in out nocopy NUMBER
71 , p3_a11 in out nocopy NUMBER
72 , p3_a12 in out nocopy NUMBER
73 , p3_a13 in out nocopy NUMBER
74 , p4_a0 in out nocopy JTF_NUMBER_TABLE
75 , p4_a1 in out nocopy JTF_DATE_TABLE
76 , p4_a2 in out nocopy JTF_NUMBER_TABLE
77 , p4_a3 in out nocopy JTF_NUMBER_TABLE
78 , p4_a4 in out nocopy JTF_NUMBER_TABLE
79 , p4_a5 in out nocopy JTF_NUMBER_TABLE
80 , p4_a6 in out nocopy JTF_NUMBER_TABLE
81 , p4_a7 in out nocopy JTF_NUMBER_TABLE
82 , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
83 , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
84 , x_return_status out nocopy VARCHAR2
85 , x_msg_count out nocopy NUMBER
86 , x_msg_data out nocopy VARCHAR2
87 );
88 end okl_lease_quote_cashflow_pvt_w;
[Home] [Help]