[Home] [Help]
PACKAGE: APPS.EAM_CONSTRUCTION_UNIT_PUB_W
Source
1 package eam_construction_unit_pub_w AUTHID CURRENT_USER as
2 /* $Header: EAMPCUWS.pls 120.0.12010000.2 2008/11/20 04:31:20 dsingire noship $ */
3 procedure rosetta_table_copy_in_p2(t out nocopy eam_construction_unit_pub.cu_activity_tbl, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_VARCHAR2_TABLE_100
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_DATE_TABLE
9 , a6 JTF_DATE_TABLE
10 , a7 JTF_VARCHAR2_TABLE_100
11 );
12 procedure rosetta_table_copy_out_p2(t eam_construction_unit_pub.cu_activity_tbl, a0 out nocopy JTF_NUMBER_TABLE
13 , a1 out nocopy JTF_NUMBER_TABLE
14 , a2 out nocopy JTF_VARCHAR2_TABLE_100
15 , a3 out nocopy JTF_NUMBER_TABLE
16 , a4 out nocopy JTF_NUMBER_TABLE
17 , a5 out nocopy JTF_DATE_TABLE
18 , a6 out nocopy JTF_DATE_TABLE
19 , a7 out nocopy JTF_VARCHAR2_TABLE_100
20 );
21
22 procedure rosetta_table_copy_in_p4(t out nocopy eam_construction_unit_pub.cu_id_tbl, a0 JTF_NUMBER_TABLE
23 );
24 procedure rosetta_table_copy_out_p4(t eam_construction_unit_pub.cu_id_tbl, a0 out nocopy JTF_NUMBER_TABLE
25 );
26
27 procedure create_construction_unit(p_api_version NUMBER
28 , p_commit VARCHAR2
29 , p3_a0 JTF_NUMBER_TABLE
30 , p3_a1 JTF_NUMBER_TABLE
31 , p3_a2 JTF_VARCHAR2_TABLE_100
32 , p3_a3 JTF_NUMBER_TABLE
33 , p3_a4 JTF_NUMBER_TABLE
34 , p3_a5 JTF_DATE_TABLE
35 , p3_a6 JTF_DATE_TABLE
36 , p3_a7 JTF_VARCHAR2_TABLE_100
37 , x_cu_id out nocopy NUMBER
38 , x_return_status out nocopy VARCHAR2
39 , x_msg_count out nocopy NUMBER
40 , x_msg_data out nocopy VARCHAR2
41 , p2_a0 NUMBER := 0-1962.0724
42 , p2_a1 VARCHAR2 := fnd_api.g_miss_char
43 , p2_a2 VARCHAR2 := fnd_api.g_miss_char
44 , p2_a3 NUMBER := 0-1962.0724
45 , p2_a4 DATE := fnd_api.g_miss_date
46 , p2_a5 DATE := fnd_api.g_miss_date
47 , p2_a6 VARCHAR2 := fnd_api.g_miss_char
48 , p2_a7 VARCHAR2 := fnd_api.g_miss_char
49 , p2_a8 VARCHAR2 := fnd_api.g_miss_char
50 , p2_a9 VARCHAR2 := fnd_api.g_miss_char
51 , p2_a10 VARCHAR2 := fnd_api.g_miss_char
52 , p2_a11 VARCHAR2 := fnd_api.g_miss_char
53 , p2_a12 VARCHAR2 := fnd_api.g_miss_char
54 , p2_a13 VARCHAR2 := fnd_api.g_miss_char
55 , p2_a14 VARCHAR2 := fnd_api.g_miss_char
56 , p2_a15 VARCHAR2 := fnd_api.g_miss_char
57 , p2_a16 VARCHAR2 := fnd_api.g_miss_char
58 , p2_a17 VARCHAR2 := fnd_api.g_miss_char
59 , p2_a18 VARCHAR2 := fnd_api.g_miss_char
60 , p2_a19 VARCHAR2 := fnd_api.g_miss_char
61 , p2_a20 VARCHAR2 := fnd_api.g_miss_char
62 , p2_a21 VARCHAR2 := fnd_api.g_miss_char
63 );
64 procedure update_construction_unit(p_api_version NUMBER
65 , p_commit VARCHAR2
66 , p3_a0 JTF_NUMBER_TABLE
67 , p3_a1 JTF_NUMBER_TABLE
68 , p3_a2 JTF_VARCHAR2_TABLE_100
69 , p3_a3 JTF_NUMBER_TABLE
70 , p3_a4 JTF_NUMBER_TABLE
71 , p3_a5 JTF_DATE_TABLE
72 , p3_a6 JTF_DATE_TABLE
73 , p3_a7 JTF_VARCHAR2_TABLE_100
74 , x_cu_id out nocopy NUMBER
75 , x_return_status out nocopy VARCHAR2
76 , x_msg_count out nocopy NUMBER
77 , x_msg_data out nocopy VARCHAR2
78 , p2_a0 NUMBER := 0-1962.0724
79 , p2_a1 VARCHAR2 := fnd_api.g_miss_char
80 , p2_a2 VARCHAR2 := fnd_api.g_miss_char
81 , p2_a3 NUMBER := 0-1962.0724
82 , p2_a4 DATE := fnd_api.g_miss_date
83 , p2_a5 DATE := fnd_api.g_miss_date
84 , p2_a6 VARCHAR2 := fnd_api.g_miss_char
85 , p2_a7 VARCHAR2 := fnd_api.g_miss_char
86 , p2_a8 VARCHAR2 := fnd_api.g_miss_char
87 , p2_a9 VARCHAR2 := fnd_api.g_miss_char
88 , p2_a10 VARCHAR2 := fnd_api.g_miss_char
89 , p2_a11 VARCHAR2 := fnd_api.g_miss_char
90 , p2_a12 VARCHAR2 := fnd_api.g_miss_char
91 , p2_a13 VARCHAR2 := fnd_api.g_miss_char
92 , p2_a14 VARCHAR2 := fnd_api.g_miss_char
93 , p2_a15 VARCHAR2 := fnd_api.g_miss_char
94 , p2_a16 VARCHAR2 := fnd_api.g_miss_char
95 , p2_a17 VARCHAR2 := fnd_api.g_miss_char
96 , p2_a18 VARCHAR2 := fnd_api.g_miss_char
97 , p2_a19 VARCHAR2 := fnd_api.g_miss_char
98 , p2_a20 VARCHAR2 := fnd_api.g_miss_char
99 , p2_a21 VARCHAR2 := fnd_api.g_miss_char
100 );
101 procedure copy_construction_unit(p_api_version NUMBER
102 , p_commit VARCHAR2
103 , p3_a0 JTF_NUMBER_TABLE
104 , p3_a1 JTF_NUMBER_TABLE
105 , p3_a2 JTF_VARCHAR2_TABLE_100
106 , p3_a3 JTF_NUMBER_TABLE
107 , p3_a4 JTF_NUMBER_TABLE
108 , p3_a5 JTF_DATE_TABLE
109 , p3_a6 JTF_DATE_TABLE
110 , p3_a7 JTF_VARCHAR2_TABLE_100
111 , p4_a0 JTF_NUMBER_TABLE
112 , x_cu_id out nocopy NUMBER
113 , x_return_status out nocopy VARCHAR2
114 , x_msg_count out nocopy NUMBER
115 , x_msg_data out nocopy VARCHAR2
116 , p2_a0 NUMBER := 0-1962.0724
117 , p2_a1 VARCHAR2 := fnd_api.g_miss_char
118 , p2_a2 VARCHAR2 := fnd_api.g_miss_char
119 , p2_a3 NUMBER := 0-1962.0724
120 , p2_a4 DATE := fnd_api.g_miss_date
121 , p2_a5 DATE := fnd_api.g_miss_date
122 , p2_a6 VARCHAR2 := fnd_api.g_miss_char
123 , p2_a7 VARCHAR2 := fnd_api.g_miss_char
124 , p2_a8 VARCHAR2 := fnd_api.g_miss_char
125 , p2_a9 VARCHAR2 := fnd_api.g_miss_char
126 , p2_a10 VARCHAR2 := fnd_api.g_miss_char
127 , p2_a11 VARCHAR2 := fnd_api.g_miss_char
128 , p2_a12 VARCHAR2 := fnd_api.g_miss_char
129 , p2_a13 VARCHAR2 := fnd_api.g_miss_char
130 , p2_a14 VARCHAR2 := fnd_api.g_miss_char
131 , p2_a15 VARCHAR2 := fnd_api.g_miss_char
132 , p2_a16 VARCHAR2 := fnd_api.g_miss_char
133 , p2_a17 VARCHAR2 := fnd_api.g_miss_char
134 , p2_a18 VARCHAR2 := fnd_api.g_miss_char
135 , p2_a19 VARCHAR2 := fnd_api.g_miss_char
136 , p2_a20 VARCHAR2 := fnd_api.g_miss_char
137 , p2_a21 VARCHAR2 := fnd_api.g_miss_char
138 );
139 end eam_construction_unit_pub_w;