APPS.HZ_LOCATION_V2PUB_JW dependencies on HZ_LOCATION_V2PUB

Line 1: package body hz_location_v2pub_jw as

1: package body hz_location_v2pub_jw as
2: /* $Header: ARH2LOJB.pls 120.5 2005/10/07 16:41:11 baianand 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 94: ddp_location_rec hz_location_v2pub.location_rec_type;

90: , p1_a63 VARCHAR2 := null
91: , p1_a64 VARCHAR2 := null
92: )
93: as
94: ddp_location_rec hz_location_v2pub.location_rec_type;
95: ddindx binary_integer; indx binary_integer;
96: begin
97:
98: -- copy data to the local IN or IN-OUT args, if any

Line 171: hz_location_v2pub.create_location(p_init_msg_list,

167:
168:
169:
170: -- here's the delegated call to the old PL/SQL routine
171: hz_location_v2pub.create_location(p_init_msg_list,
172: ddp_location_rec,
173: x_location_id,
174: x_return_status,
175: x_msg_count,

Line 261: ddp_location_rec hz_location_v2pub.location_rec_type;

257: , p1_a63 VARCHAR2 := null
258: , p1_a64 VARCHAR2 := null
259: )
260: as
261: ddp_location_rec hz_location_v2pub.location_rec_type;
262: ddindx binary_integer; indx binary_integer;
263: begin
264:
265: -- copy data to the local IN or IN-OUT args, if any

Line 341: hz_location_v2pub.create_location(p_init_msg_list,

337:
338:
339:
340: -- here's the delegated call to the old PL/SQL routine
341: hz_location_v2pub.create_location(p_init_msg_list,
342: ddp_location_rec,
343: p_do_addr_val,
344: x_location_id,
345: x_addr_val_status,

Line 434: ddp_location_rec hz_location_v2pub.location_rec_type;

430: , p1_a63 VARCHAR2 := null
431: , p1_a64 VARCHAR2 := null
432: )
433: as
434: ddp_location_rec hz_location_v2pub.location_rec_type;
435: ddindx binary_integer; indx binary_integer;
436: begin
437:
438: -- copy data to the local IN or IN-OUT args, if any

Line 511: hz_location_v2pub.update_location(p_init_msg_list,

507:
508:
509:
510: -- here's the delegated call to the old PL/SQL routine
511: hz_location_v2pub.update_location(p_init_msg_list,
512: ddp_location_rec,
513: p_object_version_number,
514: x_return_status,
515: x_msg_count,

Line 601: ddp_location_rec hz_location_v2pub.location_rec_type;

597: , p1_a63 VARCHAR2 := null
598: , p1_a64 VARCHAR2 := null
599: )
600: as
601: ddp_location_rec hz_location_v2pub.location_rec_type;
602: ddindx binary_integer; indx binary_integer;
603: begin
604:
605: -- copy data to the local IN or IN-OUT args, if any

Line 681: hz_location_v2pub.update_location(p_init_msg_list,

677:
678:
679:
680: -- here's the delegated call to the old PL/SQL routine
681: hz_location_v2pub.update_location(p_init_msg_list,
682: ddp_location_rec,
683: p_do_addr_val,
684: p_object_version_number,
685: x_addr_val_status,

Line 774: ddx_location_rec hz_location_v2pub.location_rec_type;

770: , x_msg_count out nocopy NUMBER
771: , x_msg_data out nocopy VARCHAR2
772: )
773: as
774: ddx_location_rec hz_location_v2pub.location_rec_type;
775: ddindx binary_integer; indx binary_integer;
776: begin
777:
778: -- copy data to the local IN or IN-OUT args, if any

Line 786: hz_location_v2pub.get_location_rec(p_init_msg_list,

782:
783:
784:
785: -- here's the delegated call to the old PL/SQL routine
786: hz_location_v2pub.get_location_rec(p_init_msg_list,
787: p_location_id,
788: ddx_location_rec,
789: x_return_status,
790: x_msg_count,

Line 866: end hz_location_v2pub_jw;

862:
863:
864: end;
865:
866: end hz_location_v2pub_jw;