1: package body ams_agendas_pvt_w as
2: /* $Header: amswagnb.pls 115.2 2002/11/16 00:48:41 dbiswas 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:
65: , p4_a35 VARCHAR2 := fnd_api.g_miss_char
66: , p4_a36 VARCHAR2 := fnd_api.g_miss_char
67: )
68: as
69: ddp_agenda_rec ams_agendas_pvt.agenda_rec_type;
70: ddindx binary_integer; indx binary_integer;
71: begin
72:
73: -- copy data to the local IN or IN-OUT args, if any
117:
118:
119:
120: -- here's the delegated call to the old PL/SQL routine
121: ams_agendas_pvt.create_agenda(p_api_version,
122: p_init_msg_list,
123: p_commit,
124: p_validation_level,
125: ddp_agenda_rec,
184: , p4_a35 VARCHAR2 := fnd_api.g_miss_char
185: , p4_a36 VARCHAR2 := fnd_api.g_miss_char
186: )
187: as
188: ddp_agenda_rec ams_agendas_pvt.agenda_rec_type;
189: ddindx binary_integer; indx binary_integer;
190: begin
191:
192: -- copy data to the local IN or IN-OUT args, if any
235:
236:
237:
238: -- here's the delegated call to the old PL/SQL routine
239: ams_agendas_pvt.update_agenda(p_api_version,
240: p_init_msg_list,
241: p_commit,
242: p_validation_level,
243: ddp_agenda_rec,
299: , p3_a35 VARCHAR2 := fnd_api.g_miss_char
300: , p3_a36 VARCHAR2 := fnd_api.g_miss_char
301: )
302: as
303: ddp_agenda_rec ams_agendas_pvt.agenda_rec_type;
304: ddindx binary_integer; indx binary_integer;
305: begin
306:
307: -- copy data to the local IN or IN-OUT args, if any
349:
350:
351:
352: -- here's the delegated call to the old PL/SQL routine
353: ams_agendas_pvt.validate_agenda(p_api_version,
354: p_init_msg_list,
355: p_validation_level,
356: ddp_agenda_rec,
357: x_return_status,
407: , p0_a35 VARCHAR2 := fnd_api.g_miss_char
408: , p0_a36 VARCHAR2 := fnd_api.g_miss_char
409: )
410: as
411: ddp_agenda_rec ams_agendas_pvt.agenda_rec_type;
412: ddindx binary_integer; indx binary_integer;
413: begin
414:
415: -- copy data to the local IN or IN-OUT args, if any
453:
454:
455:
456: -- here's the delegated call to the old PL/SQL routine
457: ams_agendas_pvt.validate_agenda_items(ddp_agenda_rec,
458: p_validation_mode,
459: x_return_status);
460:
461: -- copy data back from the local OUT or IN-OUT args, if any
539: , p1_a35 VARCHAR2 := fnd_api.g_miss_char
540: , p1_a36 VARCHAR2 := fnd_api.g_miss_char
541: )
542: as
543: ddp_agenda_rec ams_agendas_pvt.agenda_rec_type;
544: ddp_complete_rec ams_agendas_pvt.agenda_rec_type;
545: ddindx binary_integer; indx binary_integer;
546: begin
547:
540: , p1_a36 VARCHAR2 := fnd_api.g_miss_char
541: )
542: as
543: ddp_agenda_rec ams_agendas_pvt.agenda_rec_type;
544: ddp_complete_rec ams_agendas_pvt.agenda_rec_type;
545: ddindx binary_integer; indx binary_integer;
546: begin
547:
548: -- copy data to the local IN or IN-OUT args, if any
623: ddp_complete_rec.description := p1_a36;
624:
625:
626: -- here's the delegated call to the old PL/SQL routine
627: ams_agendas_pvt.validate_agenda_record(ddp_agenda_rec,
628: ddp_complete_rec,
629: x_return_status);
630:
631: -- copy data back from the local OUT or IN-OUT args, if any
708: , p0_a35 VARCHAR2 := fnd_api.g_miss_char
709: , p0_a36 VARCHAR2 := fnd_api.g_miss_char
710: )
711: as
712: ddp_agenda_rec ams_agendas_pvt.agenda_rec_type;
713: ddx_agenda_rec ams_agendas_pvt.agenda_rec_type;
714: ddindx binary_integer; indx binary_integer;
715: begin
716:
709: , p0_a36 VARCHAR2 := fnd_api.g_miss_char
710: )
711: as
712: ddp_agenda_rec ams_agendas_pvt.agenda_rec_type;
713: ddx_agenda_rec ams_agendas_pvt.agenda_rec_type;
714: ddindx binary_integer; indx binary_integer;
715: begin
716:
717: -- copy data to the local IN or IN-OUT args, if any
754: ddp_agenda_rec.description := p0_a36;
755:
756:
757: -- here's the delegated call to the old PL/SQL routine
758: ams_agendas_pvt.init_agenda_rec(ddp_agenda_rec,
759: ddx_agenda_rec);
760:
761: -- copy data back from the local OUT or IN-OUT args, if any
762:
874: , p0_a35 VARCHAR2 := fnd_api.g_miss_char
875: , p0_a36 VARCHAR2 := fnd_api.g_miss_char
876: )
877: as
878: ddp_agenda_rec ams_agendas_pvt.agenda_rec_type;
879: ddx_agenda_rec ams_agendas_pvt.agenda_rec_type;
880: ddindx binary_integer; indx binary_integer;
881: begin
882:
875: , p0_a36 VARCHAR2 := fnd_api.g_miss_char
876: )
877: as
878: ddp_agenda_rec ams_agendas_pvt.agenda_rec_type;
879: ddx_agenda_rec ams_agendas_pvt.agenda_rec_type;
880: ddindx binary_integer; indx binary_integer;
881: begin
882:
883: -- copy data to the local IN or IN-OUT args, if any
920: ddp_agenda_rec.description := p0_a36;
921:
922:
923: -- here's the delegated call to the old PL/SQL routine
924: ams_agendas_pvt.complete_agenda_rec(ddp_agenda_rec,
925: ddx_agenda_rec);
926:
927: -- copy data back from the local OUT or IN-OUT args, if any
928:
964: p1_a35 := ddx_agenda_rec.agenda_name;
965: p1_a36 := ddx_agenda_rec.description;
966: end;
967:
968: end ams_agendas_pvt_w;