DBA Data[Home] [Help]

PACKAGE: APPS.OKL_SECURITIZATION_PVT_W

Source


1 package okl_securitization_pvt_w AUTHID CURRENT_USER as
2   /* $Header: OKLESZSS.pls 115.2 2003/10/10 21:24:35 mvasudev noship $ */
3   procedure rosetta_table_copy_in_p29(t out nocopy okl_securitization_pvt.inv_agmt_chr_id_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_VARCHAR2_TABLE_500
5     );
6   procedure rosetta_table_copy_out_p29(t okl_securitization_pvt.inv_agmt_chr_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
7     , a1 out nocopy JTF_VARCHAR2_TABLE_500
8     );
9 
10   procedure check_khr_securitized(p_api_version  NUMBER
11     , p_init_msg_list  VARCHAR2
12     , x_return_status out nocopy  VARCHAR2
13     , x_msg_count out nocopy  NUMBER
14     , x_msg_data out nocopy  VARCHAR2
15     , p_khr_id  NUMBER
16     , p_effective_date  date
17     , p_effective_date_operator  VARCHAR2
18     , p_stream_type_subclass  VARCHAR2
19     , x_value out nocopy  VARCHAR2
20     , p10_a0 out nocopy JTF_NUMBER_TABLE
21     , p10_a1 out nocopy JTF_VARCHAR2_TABLE_500
22   );
23   procedure check_kle_securitized(p_api_version  NUMBER
24     , p_init_msg_list  VARCHAR2
25     , x_return_status out nocopy  VARCHAR2
26     , x_msg_count out nocopy  NUMBER
27     , x_msg_data out nocopy  VARCHAR2
28     , p_kle_id  NUMBER
29     , p_effective_date  date
30     , p_effective_date_operator  VARCHAR2
31     , p_stream_type_subclass  VARCHAR2
32     , x_value out nocopy  VARCHAR2
33     , p10_a0 out nocopy JTF_NUMBER_TABLE
34     , p10_a1 out nocopy JTF_VARCHAR2_TABLE_500
35   );
36   procedure check_sty_securitized(p_api_version  NUMBER
37     , p_init_msg_list  VARCHAR2
38     , x_return_status out nocopy  VARCHAR2
39     , x_msg_count out nocopy  NUMBER
40     , x_msg_data out nocopy  VARCHAR2
41     , p_khr_id  NUMBER
42     , p_effective_date  date
43     , p_effective_date_operator  VARCHAR2
44     , p_sty_id  NUMBER
45     , x_value out nocopy  VARCHAR2
46     , x_inv_agmt_chr_id out nocopy  NUMBER
47   );
48   procedure check_stm_securitized(p_api_version  NUMBER
49     , p_init_msg_list  VARCHAR2
50     , x_return_status out nocopy  VARCHAR2
51     , x_msg_count out nocopy  NUMBER
52     , x_msg_data out nocopy  VARCHAR2
53     , p_stm_id  NUMBER
54     , p_effective_date  date
55     , x_value out nocopy  VARCHAR2
56   );
57   procedure check_sel_securitized(p_api_version  NUMBER
58     , p_init_msg_list  VARCHAR2
59     , x_return_status out nocopy  VARCHAR2
60     , x_msg_count out nocopy  NUMBER
61     , x_msg_data out nocopy  VARCHAR2
62     , p_sel_id  NUMBER
63     , p_effective_date  date
64     , x_value out nocopy  VARCHAR2
65   );
66   procedure buyback_asset(p_api_version  NUMBER
67     , p_init_msg_list  VARCHAR2
68     , x_return_status out nocopy  VARCHAR2
69     , x_msg_count out nocopy  NUMBER
70     , x_msg_data out nocopy  VARCHAR2
71     , p_kle_id  NUMBER
72     , p_effective_date  date
73   );
74   procedure buyback_contract(p_api_version  NUMBER
75     , p_init_msg_list  VARCHAR2
76     , x_return_status out nocopy  VARCHAR2
77     , x_msg_count out nocopy  NUMBER
78     , x_msg_data out nocopy  VARCHAR2
79     , p_khr_id  NUMBER
80     , p_effective_date  date
81   );
82   procedure process_khr_investor_rules(p_api_version  NUMBER
83     , p_init_msg_list  VARCHAR2
84     , x_return_status out nocopy  VARCHAR2
85     , x_msg_count out nocopy  NUMBER
86     , x_msg_data out nocopy  VARCHAR2
87     , p_khr_id  NUMBER
88     , p_effective_date  date
89     , p_rgd_code  VARCHAR2
90     , p_rdf_code  VARCHAR2
91     , x_process_code out nocopy  VARCHAR2
92     , p10_a0 out nocopy JTF_NUMBER_TABLE
93     , p10_a1 out nocopy JTF_VARCHAR2_TABLE_500
94   );
95   procedure process_kle_investor_rules(p_api_version  NUMBER
96     , p_init_msg_list  VARCHAR2
97     , x_return_status out nocopy  VARCHAR2
98     , x_msg_count out nocopy  NUMBER
99     , x_msg_data out nocopy  VARCHAR2
100     , p_kle_id  NUMBER
101     , p_effective_date  date
102     , p_rgd_code  VARCHAR2
103     , p_rdf_code  VARCHAR2
104     , x_process_code out nocopy  VARCHAR2
105     , p10_a0 out nocopy JTF_NUMBER_TABLE
106     , p10_a1 out nocopy JTF_VARCHAR2_TABLE_500
107   );
108   procedure buyback_pool_contents(p_api_version  NUMBER
109     , p_init_msg_list  VARCHAR2
110     , p_khr_id  NUMBER
111     , p_pol_id  NUMBER
112     , p_stream_type_subclass  VARCHAR2
113     , p_effective_date  date
114     , x_return_status out nocopy  VARCHAR2
115     , x_msg_count out nocopy  NUMBER
116     , x_msg_data out nocopy  VARCHAR2
117   );
118   procedure modify_pool_contents(p_api_version  NUMBER
119     , p_init_msg_list  VARCHAR2
120     , p_transaction_reason  VARCHAR2
121     , p_khr_id  NUMBER
122     , p_kle_id  NUMBER
123     , p_stream_type_subclass  VARCHAR2
124     , p_transaction_date  date
125     , p_effective_date  date
126     , x_return_status out nocopy  VARCHAR2
127     , x_msg_count out nocopy  NUMBER
128     , x_msg_data out nocopy  VARCHAR2
129   );
130   procedure modify_pool_contents(p_api_version  NUMBER
131     , p_init_msg_list  VARCHAR2
132     , p_transaction_reason  VARCHAR2
133     , p_khr_id  NUMBER
134     , p_kle_id  NUMBER
135     , p5_a0 JTF_NUMBER_TABLE
136     , p_transaction_date  date
137     , p_effective_date  date
138     , x_return_status out nocopy  VARCHAR2
139     , x_msg_count out nocopy  NUMBER
140     , x_msg_data out nocopy  VARCHAR2
141   );
142 end okl_securitization_pvt_w;