APPS.AMS_IMPORTCLIENT_PVT_W dependencies on AMS_IMPORTCLIENT_PVT

Line 1: package body ams_importclient_pvt_w as

1: package body ams_importclient_pvt_w as
2: /* $Header: amswmicb.pls 115.9 2003/05/15 22:36:28 huili ship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:

Line 22: procedure rosetta_table_copy_in_p0(t OUT NOCOPY ams_importclient_pvt.char_data_set_type_w, a0 JTF_VARCHAR2_TABLE_4000) as

18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p0(t OUT NOCOPY ams_importclient_pvt.char_data_set_type_w, a0 JTF_VARCHAR2_TABLE_4000) as
23: ddindx binary_integer; indx binary_integer;
24: begin
25: if a0 is not null and a0.count > 0 then
26: if a0.count > 0 then

Line 40: procedure rosetta_table_copy_out_p0(t ams_importclient_pvt.char_data_set_type_w, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_4000) as

36: end loop;
37: end if;
38: end if;
39: end rosetta_table_copy_in_p0;
40: procedure rosetta_table_copy_out_p0(t ams_importclient_pvt.char_data_set_type_w, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_4000) as
41: ddindx binary_integer; indx binary_integer;
42: begin
43: if t is null or t.count = 0 then
44: a0 := JTF_VARCHAR2_TABLE_4000();

Line 63: procedure rosetta_table_copy_in_p1(t OUT NOCOPY ams_importclient_pvt.num_data_set_type_w, a0 JTF_NUMBER_TABLE) as

59: end if;
60: end if;
61: end rosetta_table_copy_out_p0;
62:
63: procedure rosetta_table_copy_in_p1(t OUT NOCOPY ams_importclient_pvt.num_data_set_type_w, a0 JTF_NUMBER_TABLE) as
64: ddindx binary_integer; indx binary_integer;
65: begin
66: if a0 is not null and a0.count > 0 then
67: if a0.count > 0 then

Line 81: procedure rosetta_table_copy_out_p1(t ams_importclient_pvt.num_data_set_type_w, a0 OUT NOCOPY JTF_NUMBER_TABLE) as

77: end loop;
78: end if;
79: end if;
80: end rosetta_table_copy_in_p1;
81: procedure rosetta_table_copy_out_p1(t ams_importclient_pvt.num_data_set_type_w, a0 OUT NOCOPY JTF_NUMBER_TABLE) as
82: ddindx binary_integer; indx binary_integer;
83: begin
84: if t is null or t.count = 0 then
85: a0 := JTF_NUMBER_TABLE();

Line 104: procedure rosetta_table_copy_in_p2(t OUT NOCOPY ams_importclient_pvt.varchar2_4000_set_type, a0 JTF_VARCHAR2_TABLE_4000) as

100: end if;
101: end if;
102: end rosetta_table_copy_out_p1;
103:
104: procedure rosetta_table_copy_in_p2(t OUT NOCOPY ams_importclient_pvt.varchar2_4000_set_type, a0 JTF_VARCHAR2_TABLE_4000) as
105: ddindx binary_integer; indx binary_integer;
106: begin
107: if a0 is not null and a0.count > 0 then
108: if a0.count > 0 then

Line 122: procedure rosetta_table_copy_out_p2(t ams_importclient_pvt.varchar2_4000_set_type, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_4000) as

118: end loop;
119: end if;
120: end if;
121: end rosetta_table_copy_in_p2;
122: procedure rosetta_table_copy_out_p2(t ams_importclient_pvt.varchar2_4000_set_type, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_4000) as
123: ddindx binary_integer; indx binary_integer;
124: begin
125: if t is null or t.count = 0 then
126: a0 := JTF_VARCHAR2_TABLE_4000();

Line 145: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_importclient_pvt.varchar2_150_set_type, a0 JTF_VARCHAR2_TABLE_200) as

141: end if;
142: end if;
143: end rosetta_table_copy_out_p2;
144:
145: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_importclient_pvt.varchar2_150_set_type, a0 JTF_VARCHAR2_TABLE_200) as
146: ddindx binary_integer; indx binary_integer;
147: begin
148: if a0 is not null and a0.count > 0 then
149: if a0.count > 0 then

Line 163: procedure rosetta_table_copy_out_p3(t ams_importclient_pvt.varchar2_150_set_type, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_200) as

159: end loop;
160: end if;
161: end if;
162: end rosetta_table_copy_in_p3;
163: procedure rosetta_table_copy_out_p3(t ams_importclient_pvt.varchar2_150_set_type, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_200) as
164: ddindx binary_integer; indx binary_integer;
165: begin
166: if t is null or t.count = 0 then
167: a0 := JTF_VARCHAR2_TABLE_200();

Line 199: ddp_data ams_importclient_pvt.char_data_set_type_w;

195: , x_msg_data OUT NOCOPY VARCHAR2
196: )
197:
198: as
199: ddp_data ams_importclient_pvt.char_data_set_type_w;
200: ddp_error_rows ams_importclient_pvt.num_data_set_type_w;
201: ddindx binary_integer; indx binary_integer;
202: begin
203:

Line 200: ddp_error_rows ams_importclient_pvt.num_data_set_type_w;

196: )
197:
198: as
199: ddp_data ams_importclient_pvt.char_data_set_type_w;
200: ddp_error_rows ams_importclient_pvt.num_data_set_type_w;
201: ddindx binary_integer; indx binary_integer;
202: begin
203:
204: -- copy data to the local IN or IN-OUT args, if any

Line 209: ams_importclient_pvt_w.rosetta_table_copy_in_p0(ddp_data, p_data);

205:
206:
207:
208:
209: ams_importclient_pvt_w.rosetta_table_copy_in_p0(ddp_data, p_data);
210:
211: ams_importclient_pvt_w.rosetta_table_copy_in_p1(ddp_error_rows, p_error_rows);
212:
213:

Line 211: ams_importclient_pvt_w.rosetta_table_copy_in_p1(ddp_error_rows, p_error_rows);

207:
208:
209: ams_importclient_pvt_w.rosetta_table_copy_in_p0(ddp_data, p_data);
210:
211: ams_importclient_pvt_w.rosetta_table_copy_in_p1(ddp_error_rows, p_error_rows);
212:
213:
214:
215:

Line 218: ams_importclient_pvt.insert_lead_data(p_api_version,

214:
215:
216:
217: -- here's the delegated call to the old PL/SQL routine
218: ams_importclient_pvt.insert_lead_data(p_api_version,
219: p_init_msg_list,
220: p_commit,
221: p_import_list_header_id,
222: ddp_data,

Line 254: ddp_data ams_importclient_pvt.char_data_set_type_w;

250: , x_msg_data OUT NOCOPY VARCHAR2
251: )
252:
253: as
254: ddp_data ams_importclient_pvt.char_data_set_type_w;
255: ddp_error_rows ams_importclient_pvt.num_data_set_type_w;
256: ddindx binary_integer; indx binary_integer;
257: begin
258:

Line 255: ddp_error_rows ams_importclient_pvt.num_data_set_type_w;

251: )
252:
253: as
254: ddp_data ams_importclient_pvt.char_data_set_type_w;
255: ddp_error_rows ams_importclient_pvt.num_data_set_type_w;
256: ddindx binary_integer; indx binary_integer;
257: begin
258:
259: -- copy data to the local IN or IN-OUT args, if any

Line 264: ams_importclient_pvt_w.rosetta_table_copy_in_p0(ddp_data, p_data);

260:
261:
262:
263:
264: ams_importclient_pvt_w.rosetta_table_copy_in_p0(ddp_data, p_data);
265:
266:
267: ams_importclient_pvt_w.rosetta_table_copy_in_p1(ddp_error_rows, p_error_rows);
268:

Line 267: ams_importclient_pvt_w.rosetta_table_copy_in_p1(ddp_error_rows, p_error_rows);

263:
264: ams_importclient_pvt_w.rosetta_table_copy_in_p0(ddp_data, p_data);
265:
266:
267: ams_importclient_pvt_w.rosetta_table_copy_in_p1(ddp_error_rows, p_error_rows);
268:
269:
270:
271:

Line 273: ams_importclient_pvt.insert_list_data(p_api_version,

269:
270:
271:
272: -- here's the delegated call to the old PL/SQL routine
273: ams_importclient_pvt.insert_list_data(p_api_version,
274: p_init_msg_list,
275: p_commit,
276: p_import_list_header_id,
277: ddp_data,

Line 296: end ams_importclient_pvt_w;

292:
293:
294: end;
295:
296: end ams_importclient_pvt_w;