DBA Data[Home] [Help]

APPS.AMS_PS_CNDCLSES_PVT_W dependencies on AMS_PS_CNDCLSES_PVT

Line 1: package body ams_ps_cndclses_pvt_w as

1: package body ams_ps_cndclses_pvt_w as
2: /* $Header: amswcclb.pls 120.0 2005/06/01 01:05:48 appldev noship $ */
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_ps_cndclses_pvt.ps_cndclses_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_ps_cndclses_pvt.ps_cndclses_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_ps_cndclses_pvt.ps_cndclses_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_ps_cndclses_pvt.ps_cndclses_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 172: ddp_ps_cndclses_rec ams_ps_cndclses_pvt.ps_cndclses_rec_type;

168: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
169: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
170: )
171: as
172: ddp_ps_cndclses_rec ams_ps_cndclses_pvt.ps_cndclses_rec_type;
173: ddindx binary_integer; indx binary_integer;
174: begin
175:
176: -- copy data to the local IN or IN-OUT args, if any

Line 200: ams_ps_cndclses_pvt.create_ps_cndclses(p_api_version_number,

196: ddp_ps_cndclses_rec.cnd_clause_description := p7_a12;
197:
198:
199: -- here's the delegated call to the old PL/SQL routine
200: ams_ps_cndclses_pvt.create_ps_cndclses(p_api_version_number,
201: p_init_msg_list,
202: p_commit,
203: p_validation_level,
204: x_return_status,

Line 244: ddp_ps_cndclses_rec ams_ps_cndclses_pvt.ps_cndclses_rec_type;

240: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
241: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
242: )
243: as
244: ddp_ps_cndclses_rec ams_ps_cndclses_pvt.ps_cndclses_rec_type;
245: ddindx binary_integer; indx binary_integer;
246: begin
247:
248: -- copy data to the local IN or IN-OUT args, if any

Line 272: ams_ps_cndclses_pvt.update_ps_cndclses(p_api_version_number,

268: ddp_ps_cndclses_rec.cnd_clause_description := p7_a12;
269:
270:
271: -- here's the delegated call to the old PL/SQL routine
272: ams_ps_cndclses_pvt.update_ps_cndclses(p_api_version_number,
273: p_init_msg_list,
274: p_commit,
275: p_validation_level,
276: x_return_status,

Line 314: ddp_ps_cndclses_rec ams_ps_cndclses_pvt.ps_cndclses_rec_type;

310: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
311: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
312: )
313: as
314: ddp_ps_cndclses_rec ams_ps_cndclses_pvt.ps_cndclses_rec_type;
315: ddindx binary_integer; indx binary_integer;
316: begin
317:
318: -- copy data to the local IN or IN-OUT args, if any

Line 340: ams_ps_cndclses_pvt.validate_ps_cndclses(p_api_version_number,

336:
337:
338:
339: -- here's the delegated call to the old PL/SQL routine
340: ams_ps_cndclses_pvt.validate_ps_cndclses(p_api_version_number,
341: p_init_msg_list,
342: p_validation_level,
343: ddp_ps_cndclses_rec,
344: x_return_status,

Line 374: ddp_ps_cndclses_rec ams_ps_cndclses_pvt.ps_cndclses_rec_type;

370: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
371: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
372: )
373: as
374: ddp_ps_cndclses_rec ams_ps_cndclses_pvt.ps_cndclses_rec_type;
375: ddindx binary_integer; indx binary_integer;
376: begin
377:
378: -- copy data to the local IN or IN-OUT args, if any

Line 396: ams_ps_cndclses_pvt.check_ps_cndclses_items(ddp_ps_cndclses_rec,

392:
393:
394:
395: -- here's the delegated call to the old PL/SQL routine
396: ams_ps_cndclses_pvt.check_ps_cndclses_items(ddp_ps_cndclses_rec,
397: p_validation_mode,
398: x_return_status);
399:
400: -- copy data back from the local OUT or IN-OUT args, if any

Line 425: ddp_ps_cndclses_rec ams_ps_cndclses_pvt.ps_cndclses_rec_type;

421: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
422: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
423: )
424: as
425: ddp_ps_cndclses_rec ams_ps_cndclses_pvt.ps_cndclses_rec_type;
426: ddindx binary_integer; indx binary_integer;
427: begin
428:
429: -- copy data to the local IN or IN-OUT args, if any

Line 450: ams_ps_cndclses_pvt.validate_ps_cndclses_rec(p_api_version_number,

446: ddp_ps_cndclses_rec.cnd_clause_name := p5_a11;
447: ddp_ps_cndclses_rec.cnd_clause_description := p5_a12;
448:
449: -- here's the delegated call to the old PL/SQL routine
450: ams_ps_cndclses_pvt.validate_ps_cndclses_rec(p_api_version_number,
451: p_init_msg_list,
452: x_return_status,
453: x_msg_count,
454: x_msg_data,

Line 465: end ams_ps_cndclses_pvt_w;

461:
462:
463: end;
464:
465: end ams_ps_cndclses_pvt_w;