[Home] [Help]
PACKAGE: APPS.CN_IMP_MAPS_PVT_W
Source
1 package cn_imp_maps_pvt_w AUTHID CURRENT_USER as
2 /* $Header: cnwimmps.pls 120.4 2006/03/23 00:42 hanaraya noship $ */
3 procedure rosetta_table_copy_in_p0(t out nocopy cn_imp_maps_pvt.v_tbl_type, a0 JTF_VARCHAR2_TABLE_200);
4 procedure rosetta_table_copy_out_p0(t cn_imp_maps_pvt.v_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200);
5
6 procedure rosetta_table_copy_in_p6(t out nocopy cn_imp_maps_pvt.map_field_tbl_type, a0 JTF_VARCHAR2_TABLE_200
7 , a1 JTF_VARCHAR2_TABLE_200
8 , a2 JTF_VARCHAR2_TABLE_200
9 );
10 procedure rosetta_table_copy_out_p6(t cn_imp_maps_pvt.map_field_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
11 , a1 out nocopy JTF_VARCHAR2_TABLE_200
12 , a2 out nocopy JTF_VARCHAR2_TABLE_200
13 );
14
15 procedure create_mapping(p_api_version NUMBER
16 , p_init_msg_list VARCHAR2
17 , p_commit VARCHAR2
18 , p_validation_level NUMBER
19 , x_return_status out nocopy VARCHAR2
20 , x_msg_count out nocopy NUMBER
21 , x_msg_data out nocopy VARCHAR2
22 , p_imp_header_id NUMBER
23 , p_src_column_num NUMBER
24 , p9_a0 NUMBER
25 , p9_a1 VARCHAR2
26 , p9_a2 VARCHAR2
27 , p9_a3 NUMBER
28 , p9_a4 VARCHAR2
29 , p9_a5 VARCHAR2
30 , p9_a6 VARCHAR2
31 , p9_a7 VARCHAR2
32 , p9_a8 VARCHAR2
33 , p9_a9 VARCHAR2
34 , p9_a10 VARCHAR2
35 , p9_a11 VARCHAR2
36 , p9_a12 VARCHAR2
37 , p9_a13 VARCHAR2
38 , p9_a14 VARCHAR2
39 , p9_a15 VARCHAR2
40 , p9_a16 VARCHAR2
41 , p9_a17 VARCHAR2
42 , p9_a18 VARCHAR2
43 , p9_a19 VARCHAR2
44 , p9_a20 DATE
45 , p9_a21 NUMBER
46 , p9_a22 DATE
47 , p9_a23 NUMBER
48 , p9_a24 NUMBER
49 , p10_a0 JTF_VARCHAR2_TABLE_200
50 , p10_a1 JTF_VARCHAR2_TABLE_200
51 , p10_a2 JTF_VARCHAR2_TABLE_200
52 , p_target_fields JTF_VARCHAR2_TABLE_200
53 , x_imp_map_id out nocopy NUMBER
54 , p_org_id NUMBER
55 );
56 procedure retrieve_fields(p_api_version NUMBER
57 , p_init_msg_list VARCHAR2
58 , p_commit VARCHAR2
59 , p_validation_level NUMBER
60 , x_return_status out nocopy VARCHAR2
61 , x_msg_count out nocopy NUMBER
62 , x_msg_data out nocopy VARCHAR2
63 , p_imp_map_id NUMBER
64 , p_import_type_code VARCHAR2
65 , p9_a0 out nocopy JTF_VARCHAR2_TABLE_200
66 , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
67 , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
68 , p10_a0 out nocopy JTF_VARCHAR2_TABLE_200
69 , p10_a1 out nocopy JTF_VARCHAR2_TABLE_200
70 , p10_a2 out nocopy JTF_VARCHAR2_TABLE_200
71 , p11_a0 out nocopy JTF_VARCHAR2_TABLE_200
72 , p11_a1 out nocopy JTF_VARCHAR2_TABLE_200
73 , p11_a2 out nocopy JTF_VARCHAR2_TABLE_200
74 , x_map_obj_num out nocopy NUMBER
75 , p_org_id NUMBER
76 );
77 procedure create_imp_map(p_api_version NUMBER
78 , p_init_msg_list VARCHAR2
79 , p_commit VARCHAR2
80 , p_validation_level NUMBER
81 , x_return_status out nocopy VARCHAR2
82 , x_msg_count out nocopy NUMBER
83 , x_msg_data out nocopy VARCHAR2
84 , p7_a0 NUMBER
85 , p7_a1 VARCHAR2
86 , p7_a2 VARCHAR2
87 , p7_a3 NUMBER
88 , p7_a4 VARCHAR2
89 , p7_a5 VARCHAR2
90 , p7_a6 VARCHAR2
91 , p7_a7 VARCHAR2
92 , p7_a8 VARCHAR2
93 , p7_a9 VARCHAR2
94 , p7_a10 VARCHAR2
95 , p7_a11 VARCHAR2
96 , p7_a12 VARCHAR2
97 , p7_a13 VARCHAR2
98 , p7_a14 VARCHAR2
99 , p7_a15 VARCHAR2
100 , p7_a16 VARCHAR2
101 , p7_a17 VARCHAR2
102 , p7_a18 VARCHAR2
103 , p7_a19 VARCHAR2
104 , p7_a20 DATE
105 , p7_a21 NUMBER
106 , p7_a22 DATE
107 , p7_a23 NUMBER
108 , p7_a24 NUMBER
109 , x_imp_map_id out nocopy NUMBER
110 );
111 procedure delete_imp_map(p_api_version NUMBER
112 , p_init_msg_list VARCHAR2
113 , p_commit VARCHAR2
114 , p_validation_level NUMBER
115 , x_return_status out nocopy VARCHAR2
116 , x_msg_count out nocopy NUMBER
117 , x_msg_data out nocopy VARCHAR2
118 , p7_a0 NUMBER
119 , p7_a1 VARCHAR2
120 , p7_a2 VARCHAR2
121 , p7_a3 NUMBER
122 , p7_a4 VARCHAR2
123 , p7_a5 VARCHAR2
124 , p7_a6 VARCHAR2
125 , p7_a7 VARCHAR2
126 , p7_a8 VARCHAR2
127 , p7_a9 VARCHAR2
128 , p7_a10 VARCHAR2
129 , p7_a11 VARCHAR2
130 , p7_a12 VARCHAR2
131 , p7_a13 VARCHAR2
132 , p7_a14 VARCHAR2
133 , p7_a15 VARCHAR2
134 , p7_a16 VARCHAR2
135 , p7_a17 VARCHAR2
136 , p7_a18 VARCHAR2
137 , p7_a19 VARCHAR2
138 , p7_a20 DATE
139 , p7_a21 NUMBER
140 , p7_a22 DATE
141 , p7_a23 NUMBER
142 , p7_a24 NUMBER
143 );
144 end cn_imp_maps_pvt_w;