[Home] [Help]
PACKAGE: APPS.OKL_LA_ASSET_PVT_W
Source
1 package okl_la_asset_pvt_w AUTHID CURRENT_USER as
2 /* $Header: OKLELAAS.pls 120.5.12010000.2 2010/04/29 16:34:23 rpillay ship $ */
3 procedure rosetta_table_copy_in_p2(t out nocopy okl_la_asset_pvt.fin_adj_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_100
5 , a2 JTF_VARCHAR2_TABLE_100
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_VARCHAR2_TABLE_100
11 , a8 JTF_VARCHAR2_TABLE_100
12 );
13 procedure rosetta_table_copy_out_p2(t okl_la_asset_pvt.fin_adj_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14 , a1 out nocopy JTF_VARCHAR2_TABLE_100
15 , a2 out nocopy JTF_VARCHAR2_TABLE_100
16 , a3 out nocopy JTF_NUMBER_TABLE
17 , a4 out nocopy JTF_NUMBER_TABLE
18 , a5 out nocopy JTF_NUMBER_TABLE
19 , a6 out nocopy JTF_NUMBER_TABLE
20 , a7 out nocopy JTF_VARCHAR2_TABLE_100
21 , a8 out nocopy JTF_VARCHAR2_TABLE_100
22 );
23
24 procedure rosetta_table_copy_in_p3(t out nocopy okl_la_asset_pvt.las_tbl_type, a0 JTF_VARCHAR2_TABLE_100
25 , a1 JTF_NUMBER_TABLE
26 , a2 JTF_VARCHAR2_TABLE_400
27 , a3 JTF_VARCHAR2_TABLE_100
28 , a4 JTF_NUMBER_TABLE
29 , a5 JTF_NUMBER_TABLE
30 , a6 JTF_NUMBER_TABLE
31 , a7 JTF_VARCHAR2_TABLE_300
32 , a8 JTF_NUMBER_TABLE
33 , a9 JTF_NUMBER_TABLE
34 , a10 JTF_DATE_TABLE
35 , a11 JTF_DATE_TABLE
36 , a12 JTF_DATE_TABLE
37 , a13 JTF_DATE_TABLE
38 , a14 JTF_DATE_TABLE
39 , a15 JTF_DATE_TABLE
40 , a16 JTF_VARCHAR2_TABLE_100
41 , a17 JTF_VARCHAR2_TABLE_2000
42 , a18 JTF_NUMBER_TABLE
43 , a19 JTF_NUMBER_TABLE
44 , a20 JTF_VARCHAR2_TABLE_100
45 , a21 JTF_VARCHAR2_TABLE_100
46 , a22 JTF_VARCHAR2_TABLE_100
47 );
48 procedure rosetta_table_copy_out_p3(t okl_la_asset_pvt.las_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
49 , a1 out nocopy JTF_NUMBER_TABLE
50 , a2 out nocopy JTF_VARCHAR2_TABLE_400
51 , a3 out nocopy JTF_VARCHAR2_TABLE_100
52 , a4 out nocopy JTF_NUMBER_TABLE
53 , a5 out nocopy JTF_NUMBER_TABLE
54 , a6 out nocopy JTF_NUMBER_TABLE
55 , a7 out nocopy JTF_VARCHAR2_TABLE_300
56 , a8 out nocopy JTF_NUMBER_TABLE
57 , a9 out nocopy JTF_NUMBER_TABLE
58 , a10 out nocopy JTF_DATE_TABLE
59 , a11 out nocopy JTF_DATE_TABLE
60 , a12 out nocopy JTF_DATE_TABLE
61 , a13 out nocopy JTF_DATE_TABLE
62 , a14 out nocopy JTF_DATE_TABLE
63 , a15 out nocopy JTF_DATE_TABLE
64 , a16 out nocopy JTF_VARCHAR2_TABLE_100
65 , a17 out nocopy JTF_VARCHAR2_TABLE_2000
66 , a18 out nocopy JTF_NUMBER_TABLE
67 , a19 out nocopy JTF_NUMBER_TABLE
68 , a20 out nocopy JTF_VARCHAR2_TABLE_100
69 , a21 out nocopy JTF_VARCHAR2_TABLE_100
70 , a22 out nocopy JTF_VARCHAR2_TABLE_100
71 );
72
73 procedure generate_asset_summary(p_api_version NUMBER
74 , p_init_msg_list VARCHAR2
75 , x_return_status out nocopy VARCHAR2
76 , x_msg_count out nocopy NUMBER
77 , x_msg_data out nocopy VARCHAR2
78 , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
79 , p6_a1 out nocopy JTF_NUMBER_TABLE
80 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_400
81 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
82 , p6_a4 out nocopy JTF_NUMBER_TABLE
83 , p6_a5 out nocopy JTF_NUMBER_TABLE
84 , p6_a6 out nocopy JTF_NUMBER_TABLE
85 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
86 , p6_a8 out nocopy JTF_NUMBER_TABLE
87 , p6_a9 out nocopy JTF_NUMBER_TABLE
88 , p6_a10 out nocopy JTF_DATE_TABLE
89 , p6_a11 out nocopy JTF_DATE_TABLE
90 , p6_a12 out nocopy JTF_DATE_TABLE
91 , p6_a13 out nocopy JTF_DATE_TABLE
92 , p6_a14 out nocopy JTF_DATE_TABLE
93 , p6_a15 out nocopy JTF_DATE_TABLE
94 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
95 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_2000
96 , p6_a18 out nocopy JTF_NUMBER_TABLE
97 , p6_a19 out nocopy JTF_NUMBER_TABLE
98 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
99 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
100 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
101 , p5_a0 VARCHAR2 := fnd_api.g_miss_char
102 , p5_a1 NUMBER := 0-1962.0724
103 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
104 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
105 , p5_a4 NUMBER := 0-1962.0724
106 , p5_a5 NUMBER := 0-1962.0724
107 , p5_a6 NUMBER := 0-1962.0724
108 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
109 , p5_a8 NUMBER := 0-1962.0724
110 , p5_a9 NUMBER := 0-1962.0724
111 , p5_a10 DATE := fnd_api.g_miss_date
112 , p5_a11 DATE := fnd_api.g_miss_date
113 , p5_a12 DATE := fnd_api.g_miss_date
114 , p5_a13 DATE := fnd_api.g_miss_date
115 , p5_a14 DATE := fnd_api.g_miss_date
116 , p5_a15 DATE := fnd_api.g_miss_date
117 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
118 , p5_a17 VARCHAR := fnd_api.g_miss_char
119 , p5_a18 NUMBER := 0-1962.0724
120 , p5_a19 NUMBER := 0-1962.0724
121 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
122 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
123 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
124 );
125 procedure update_contract_line(p_api_version NUMBER
126 , p_init_msg_list VARCHAR2
127 , x_return_status out nocopy VARCHAR2
128 , x_msg_count out nocopy NUMBER
129 , x_msg_data out nocopy VARCHAR2
130 , p_id NUMBER
131 , p_date_delivery_expected date
132 , p_date_funding_expected date
133 , p_org_id NUMBER
134 , p_organization_id NUMBER
135 );
136 procedure update_fin_cap_cost(p_api_version NUMBER
137 , p_init_msg_list VARCHAR2
138 , x_return_status out nocopy VARCHAR2
139 , x_msg_count out nocopy NUMBER
140 , x_msg_data out nocopy VARCHAR2
141 , p5_a0 JTF_NUMBER_TABLE
142 , p5_a1 JTF_VARCHAR2_TABLE_100
143 , p5_a2 JTF_VARCHAR2_TABLE_100
144 , p5_a3 JTF_NUMBER_TABLE
145 , p5_a4 JTF_NUMBER_TABLE
146 , p5_a5 JTF_NUMBER_TABLE
147 , p5_a6 JTF_NUMBER_TABLE
148 , p5_a7 JTF_VARCHAR2_TABLE_100
149 , p5_a8 JTF_VARCHAR2_TABLE_100
150 );
151 procedure iscontractactive(p_dnz_chr_id NUMBER
152 , p_deal_type VARCHAR2
153 , p_sts_code VARCHAR2
154 , ddrosetta_retval_bool OUT NOCOPY NUMBER
155 );
156 end okl_la_asset_pvt_w;