[Home] [Help]
PACKAGE: APPS.LNS_DISTRIBUTIONS_PUB_W
Source
1 package lns_distributions_pub_w as
2 /* $Header: LNS_DIST_PUBJ_S.pls 120.4 2005/09/01 08:34 raverma noship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy lns_distributions_pub.distribution_tbl, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_VARCHAR2_TABLE_100
6 , a3 JTF_VARCHAR2_TABLE_100
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_VARCHAR2_TABLE_100
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_VARCHAR2_TABLE_100
12 , a9 JTF_VARCHAR2_TABLE_100
13 , a10 JTF_NUMBER_TABLE
14 , a11 JTF_NUMBER_TABLE
15 );
16 procedure rosetta_table_copy_out_p1(t lns_distributions_pub.distribution_tbl, a0 out nocopy JTF_NUMBER_TABLE
17 , a1 out nocopy JTF_NUMBER_TABLE
18 , a2 out nocopy JTF_VARCHAR2_TABLE_100
19 , a3 out nocopy JTF_VARCHAR2_TABLE_100
20 , a4 out nocopy JTF_NUMBER_TABLE
21 , a5 out nocopy JTF_VARCHAR2_TABLE_100
22 , a6 out nocopy JTF_NUMBER_TABLE
23 , a7 out nocopy JTF_NUMBER_TABLE
24 , a8 out nocopy JTF_VARCHAR2_TABLE_100
25 , a9 out nocopy JTF_VARCHAR2_TABLE_100
26 , a10 out nocopy JTF_NUMBER_TABLE
27 , a11 out nocopy JTF_NUMBER_TABLE
28 );
29
30 procedure rosetta_table_copy_in_p3(t out nocopy lns_distributions_pub.default_distributions_tbl, a0 JTF_VARCHAR2_TABLE_100
31 , a1 JTF_VARCHAR2_TABLE_100
32 , a2 JTF_VARCHAR2_TABLE_100
33 , a3 JTF_VARCHAR2_TABLE_100
34 , a4 JTF_NUMBER_TABLE
35 , a5 JTF_VARCHAR2_TABLE_100
36 , a6 JTF_NUMBER_TABLE
37 , a7 JTF_VARCHAR2_TABLE_100
38 , a8 JTF_NUMBER_TABLE
39 , a9 JTF_NUMBER_TABLE
40 , a10 JTF_VARCHAR2_TABLE_100
41 , a11 JTF_VARCHAR2_TABLE_100
42 , a12 JTF_VARCHAR2_TABLE_100
43 );
44 procedure rosetta_table_copy_out_p3(t lns_distributions_pub.default_distributions_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
45 , a1 out nocopy JTF_VARCHAR2_TABLE_100
46 , a2 out nocopy JTF_VARCHAR2_TABLE_100
47 , a3 out nocopy JTF_VARCHAR2_TABLE_100
48 , a4 out nocopy JTF_NUMBER_TABLE
49 , a5 out nocopy JTF_VARCHAR2_TABLE_100
50 , a6 out nocopy JTF_NUMBER_TABLE
51 , a7 out nocopy JTF_VARCHAR2_TABLE_100
52 , a8 out nocopy JTF_NUMBER_TABLE
53 , a9 out nocopy JTF_NUMBER_TABLE
54 , a10 out nocopy JTF_VARCHAR2_TABLE_100
55 , a11 out nocopy JTF_VARCHAR2_TABLE_100
56 , a12 out nocopy JTF_VARCHAR2_TABLE_100
57 );
58
59 procedure rosetta_table_copy_in_p5(t out nocopy lns_distributions_pub.acc_event_tbl, a0 JTF_NUMBER_TABLE
60 , a1 JTF_VARCHAR2_TABLE_100
61 , a2 JTF_DATE_TABLE
62 , a3 JTF_VARCHAR2_TABLE_100
63 , a4 JTF_NUMBER_TABLE
64 );
65 procedure rosetta_table_copy_out_p5(t lns_distributions_pub.acc_event_tbl, a0 out nocopy JTF_NUMBER_TABLE
66 , a1 out nocopy JTF_VARCHAR2_TABLE_100
67 , a2 out nocopy JTF_DATE_TABLE
68 , a3 out nocopy JTF_VARCHAR2_TABLE_100
69 , a4 out nocopy JTF_NUMBER_TABLE
70 );
71
72 procedure rosetta_table_copy_in_p6(t out nocopy lns_distributions_pub.g_number_tbl, a0 JTF_NUMBER_TABLE);
73 procedure rosetta_table_copy_out_p6(t lns_distributions_pub.g_number_tbl, a0 out nocopy JTF_NUMBER_TABLE);
74
75 procedure create_event(p0_a0 JTF_NUMBER_TABLE
76 , p0_a1 JTF_VARCHAR2_TABLE_100
77 , p0_a2 JTF_DATE_TABLE
78 , p0_a3 JTF_VARCHAR2_TABLE_100
79 , p0_a4 JTF_NUMBER_TABLE
80 , p_init_msg_list VARCHAR2
81 , p_commit VARCHAR2
82 , x_return_status out nocopy VARCHAR2
83 , x_msg_count out nocopy NUMBER
84 , x_msg_data out nocopy VARCHAR2
85 );
86 procedure defaultdistributionscatch(p_api_version NUMBER
87 , p_init_msg_list VARCHAR2
88 , p_commit VARCHAR2
89 , p_loan_id NUMBER
90 , p_disb_header_id NUMBER
91 , p_include_loan_receivables VARCHAR2
92 , p_distribution_type VARCHAR2
93 , p7_a0 out nocopy JTF_NUMBER_TABLE
94 , p7_a1 out nocopy JTF_NUMBER_TABLE
95 , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
96 , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
97 , p7_a4 out nocopy JTF_NUMBER_TABLE
98 , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
99 , p7_a6 out nocopy JTF_NUMBER_TABLE
100 , p7_a7 out nocopy JTF_NUMBER_TABLE
101 , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
102 , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
103 , p7_a10 out nocopy JTF_NUMBER_TABLE
104 , p7_a11 out nocopy JTF_NUMBER_TABLE
105 , x_return_status out nocopy VARCHAR2
106 , x_msg_count out nocopy NUMBER
107 , x_msg_data out nocopy VARCHAR2
108 );
109 procedure validateloanlines(p_init_msg_list VARCHAR2
110 , p_loan_id NUMBER
111 , x_mfar out nocopy number
112 , x_return_status out nocopy VARCHAR2
113 , x_msg_count out nocopy NUMBER
114 , x_msg_data out nocopy VARCHAR2
115 );
116 end lns_distributions_pub_w;