APPS.AMS_ST_ASSOC_PVT_W dependencies on AMS_ST_ASSOC_PVT

Line 1: package body ams_st_assoc_pvt_w as

1: package body ams_st_assoc_pvt_w as
2: /* $Header: amswstab.pls 115.7 2002/11/22 08:57:54 jieli 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_p3(t OUT NOCOPY ams_st_assoc_pvt.st_assoc_tbl_type, a0 JTF_NUMBER_TABLE

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_p3(t OUT NOCOPY ams_st_assoc_pvt.st_assoc_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_DATE_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 65: procedure rosetta_table_copy_out_p3(t ams_st_assoc_pvt.st_assoc_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE

61: end loop;
62: end if;
63: end if;
64: end rosetta_table_copy_in_p3;
65: procedure rosetta_table_copy_out_p3(t ams_st_assoc_pvt.st_assoc_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
66: , a1 OUT NOCOPY JTF_DATE_TABLE
67: , a2 OUT NOCOPY JTF_NUMBER_TABLE
68: , a3 OUT NOCOPY JTF_DATE_TABLE
69: , a4 OUT NOCOPY JTF_NUMBER_TABLE

Line 173: ddp_st_assoc_rec ams_st_assoc_pvt.st_assoc_rec_type;

169: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
170: )
171:
172: as
173: ddp_st_assoc_rec ams_st_assoc_pvt.st_assoc_rec_type;
174: ddindx binary_integer; indx binary_integer;
175: begin
176:
177: -- copy data to the local IN or IN-OUT args, if any

Line 201: ams_st_assoc_pvt.create_st_assoc(p_api_version_number,

197: ddp_st_assoc_rec.master_source_type_pk_column := p7_a12;
198:
199:
200: -- here's the delegated call to the old PL/SQL routine
201: ams_st_assoc_pvt.create_st_assoc(p_api_version_number,
202: p_init_msg_list,
203: p_commit,
204: p_validation_level,
205: x_return_status,

Line 246: ddp_st_assoc_rec ams_st_assoc_pvt.st_assoc_rec_type;

242: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
243: )
244:
245: as
246: ddp_st_assoc_rec ams_st_assoc_pvt.st_assoc_rec_type;
247: ddindx binary_integer; indx binary_integer;
248: begin
249:
250: -- copy data to the local IN or IN-OUT args, if any

Line 274: ams_st_assoc_pvt.update_st_assoc(p_api_version_number,

270: ddp_st_assoc_rec.master_source_type_pk_column := p7_a12;
271:
272:
273: -- here's the delegated call to the old PL/SQL routine
274: ams_st_assoc_pvt.update_st_assoc(p_api_version_number,
275: p_init_msg_list,
276: p_commit,
277: p_validation_level,
278: x_return_status,

Line 317: ddp_st_assoc_rec ams_st_assoc_pvt.st_assoc_rec_type;

313: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
314: )
315:
316: as
317: ddp_st_assoc_rec ams_st_assoc_pvt.st_assoc_rec_type;
318: ddindx binary_integer; indx binary_integer;
319: begin
320:
321: -- copy data to the local IN or IN-OUT args, if any

Line 343: ams_st_assoc_pvt.validate_st_assoc(p_api_version_number,

339:
340:
341:
342: -- here's the delegated call to the old PL/SQL routine
343: ams_st_assoc_pvt.validate_st_assoc(p_api_version_number,
344: p_init_msg_list,
345: p_validation_level,
346: ddp_st_assoc_rec,
347: x_return_status,

Line 378: ddp_st_assoc_rec ams_st_assoc_pvt.st_assoc_rec_type;

374: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
375: )
376:
377: as
378: ddp_st_assoc_rec ams_st_assoc_pvt.st_assoc_rec_type;
379: ddindx binary_integer; indx binary_integer;
380: begin
381:
382: -- copy data to the local IN or IN-OUT args, if any

Line 400: ams_st_assoc_pvt.check_st_assoc_items(ddp_st_assoc_rec,

396:
397:
398:
399: -- here's the delegated call to the old PL/SQL routine
400: ams_st_assoc_pvt.check_st_assoc_items(ddp_st_assoc_rec,
401: p_validation_mode,
402: x_return_status);
403:
404: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 430: ddp_st_assoc_rec ams_st_assoc_pvt.st_assoc_rec_type;

426: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
427: )
428:
429: as
430: ddp_st_assoc_rec ams_st_assoc_pvt.st_assoc_rec_type;
431: ddindx binary_integer; indx binary_integer;
432: begin
433:
434: -- copy data to the local IN or IN-OUT args, if any

Line 455: ams_st_assoc_pvt.validate_st_assoc_rec(p_api_version_number,

451: ddp_st_assoc_rec.description := p5_a11;
452: ddp_st_assoc_rec.master_source_type_pk_column := p5_a12;
453:
454: -- here's the delegated call to the old PL/SQL routine
455: ams_st_assoc_pvt.validate_st_assoc_rec(p_api_version_number,
456: p_init_msg_list,
457: x_return_status,
458: x_msg_count,
459: x_msg_data,

Line 470: end ams_st_assoc_pvt_w;

466:
467:
468: end;
469:
470: end ams_st_assoc_pvt_w;