DBA Data[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;