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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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:
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
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
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
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
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
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
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
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
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
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
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
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