eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_GEOGRAPHY_PUB_UIW_JW dependencies on HZ_GEOGRAPHY_PUB_UIW

Line 1: package body hz_geography_pub_uiw_jw as

1: package body hz_geography_pub_uiw_jw as
2: /* $Header: ARHGEOJS.pls 120.2 2006/02/17 09:08:50 idali 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_p2(t out nocopy hz_geography_pub_uiw.parent_geography_tbl_type, a0 JTF_NUMBER_TABLE) 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_p2(t out nocopy hz_geography_pub_uiw.parent_geography_tbl_type, a0 JTF_NUMBER_TABLE) as
23: ddindx binary_integer; indx binary_integer;
24: begin
25: if a0 is null then
26: t := null;

Line 28: t := hz_geography_pub_uiw.parent_geography_tbl_type();

24: begin
25: if a0 is null then
26: t := null;
27: elsif a0.count = 0 then
28: t := hz_geography_pub_uiw.parent_geography_tbl_type();
29: else
30: if a0.count > 0 then
31: t := hz_geography_pub_uiw.parent_geography_tbl_type();
32: t.extend(a0.count);

Line 31: t := hz_geography_pub_uiw.parent_geography_tbl_type();

27: elsif a0.count = 0 then
28: t := hz_geography_pub_uiw.parent_geography_tbl_type();
29: else
30: if a0.count > 0 then
31: t := hz_geography_pub_uiw.parent_geography_tbl_type();
32: t.extend(a0.count);
33: indx := a0.first;
34: ddindx := 1;
35: while true loop

Line 46: procedure rosetta_table_copy_out_p2(t hz_geography_pub_uiw.parent_geography_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

42: end loop;
43: end if;
44: end if;
45: end rosetta_table_copy_in_p2;
46: procedure rosetta_table_copy_out_p2(t hz_geography_pub_uiw.parent_geography_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
47: ddindx binary_integer; indx binary_integer;
48: begin
49: if t is null then
50: a0 := null;

Line 71: procedure rosetta_table_copy_in_p6(t out nocopy hz_geography_pub_uiw.zone_relation_tbl_type, a0 JTF_NUMBER_TABLE

67: end if;
68: end if;
69: end rosetta_table_copy_out_p2;
70:
71: procedure rosetta_table_copy_in_p6(t out nocopy hz_geography_pub_uiw.zone_relation_tbl_type, a0 JTF_NUMBER_TABLE
72: , a1 JTF_VARCHAR2_TABLE_400
73: , a2 JTF_VARCHAR2_TABLE_400
74: , a3 JTF_VARCHAR2_TABLE_100
75: , a4 JTF_VARCHAR2_TABLE_100

Line 82: t := hz_geography_pub_uiw.zone_relation_tbl_type();

78: ) as
79: ddindx binary_integer; indx binary_integer;
80: begin
81: if a0 is not null and a0.count=0 then
82: t := hz_geography_pub_uiw.zone_relation_tbl_type();
83: elsif a0 is not null and a0.count > 0 then
84: if a0.count > 0 then
85: t := hz_geography_pub_uiw.zone_relation_tbl_type();
86: t.extend(a0.count);

Line 85: t := hz_geography_pub_uiw.zone_relation_tbl_type();

81: if a0 is not null and a0.count=0 then
82: t := hz_geography_pub_uiw.zone_relation_tbl_type();
83: elsif a0 is not null and a0.count > 0 then
84: if a0.count > 0 then
85: t := hz_geography_pub_uiw.zone_relation_tbl_type();
86: t.extend(a0.count);
87: indx := a0.first;
88: ddindx := 1;
89: while true loop

Line 106: procedure rosetta_table_copy_out_p6(t hz_geography_pub_uiw.zone_relation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

102: end loop;
103: end if;
104: end if;
105: end rosetta_table_copy_in_p6;
106: procedure rosetta_table_copy_out_p6(t hz_geography_pub_uiw.zone_relation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
107: , a1 out nocopy JTF_VARCHAR2_TABLE_400
108: , a2 out nocopy JTF_VARCHAR2_TABLE_400
109: , a3 out nocopy JTF_VARCHAR2_TABLE_100
110: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 181: ddp_master_relation_rec hz_geography_pub_uiw.master_relation_rec_type;

177: , p1_a4 VARCHAR2 := null
178: , p1_a5 NUMBER := null
179: )
180: as
181: ddp_master_relation_rec hz_geography_pub_uiw.master_relation_rec_type;
182: ddindx binary_integer; indx binary_integer;
183: begin
184:
185: -- copy data to the local IN or IN-OUT args, if any

Line 199: hz_geography_pub_uiw.create_master_relation(p_init_msg_list,

195:
196:
197:
198: -- here's the delegated call to the old PL/SQL routine
199: hz_geography_pub_uiw.create_master_relation(p_init_msg_list,
200: ddp_master_relation_rec,
201: x_relationship_id,
202: x_return_status,
203: x_msg_count,

Line 231: ddp_geo_identifier_rec hz_geography_pub_uiw.geo_identifier_rec_type;

227: , p1_a9 VARCHAR2 := null
228: , p1_a10 VARCHAR2 := null
229: )
230: as
231: ddp_geo_identifier_rec hz_geography_pub_uiw.geo_identifier_rec_type;
232: ddindx binary_integer; indx binary_integer;
233: begin
234:
235: -- copy data to the local IN or IN-OUT args, if any

Line 253: hz_geography_pub_uiw.create_geo_identifier(p_init_msg_list,

249:
250:
251:
252: -- here's the delegated call to the old PL/SQL routine
253: hz_geography_pub_uiw.create_geo_identifier(p_init_msg_list,
254: ddp_geo_identifier_rec,
255: x_return_status,
256: x_msg_count,
257: x_msg_data);

Line 285: ddp_geo_identifier_rec hz_geography_pub_uiw.geo_identifier_rec_type;

281: , p1_a9 VARCHAR2 := null
282: , p1_a10 VARCHAR2 := null
283: )
284: as
285: ddp_geo_identifier_rec hz_geography_pub_uiw.geo_identifier_rec_type;
286: ddindx binary_integer; indx binary_integer;
287: begin
288:
289: -- copy data to the local IN or IN-OUT args, if any

Line 309: hz_geography_pub_uiw.update_geo_identifier(p_init_msg_list,

305:
306:
307:
308: -- here's the delegated call to the old PL/SQL routine
309: hz_geography_pub_uiw.update_geo_identifier(p_init_msg_list,
310: ddp_geo_identifier_rec,
311: p_object_version_number,
312: x_cp_request_id,
313: x_return_status,

Line 345: ddp_master_geography_rec hz_geography_pub_uiw.master_geography_rec_type;

341: , p1_a9 VARCHAR2 := null
342: , p1_a10 NUMBER := null
343: )
344: as
345: ddp_master_geography_rec hz_geography_pub_uiw.master_geography_rec_type;
346: ddp_parent_geography_id hz_geography_pub_uiw.parent_geography_tbl_type;
347: ddindx binary_integer; indx binary_integer;
348: begin
349:

Line 346: ddp_parent_geography_id hz_geography_pub_uiw.parent_geography_tbl_type;

342: , p1_a10 NUMBER := null
343: )
344: as
345: ddp_master_geography_rec hz_geography_pub_uiw.master_geography_rec_type;
346: ddp_parent_geography_id hz_geography_pub_uiw.parent_geography_tbl_type;
347: ddindx binary_integer; indx binary_integer;
348: begin
349:
350: -- copy data to the local IN or IN-OUT args, if any

Line 364: hz_geography_pub_uiw_jw.rosetta_table_copy_in_p2(ddp_parent_geography_id, p_parent_geography_id);

360: ddp_master_geography_rec.timezone_code := p1_a8;
361: ddp_master_geography_rec.created_by_module := p1_a9;
362: ddp_master_geography_rec.application_id := rosetta_g_miss_num_map(p1_a10);
363:
364: hz_geography_pub_uiw_jw.rosetta_table_copy_in_p2(ddp_parent_geography_id, p_parent_geography_id);
365:
366:
367:
368:

Line 371: hz_geography_pub_uiw.create_master_geography(p_init_msg_list,

367:
368:
369:
370: -- here's the delegated call to the old PL/SQL routine
371: hz_geography_pub_uiw.create_master_geography(p_init_msg_list,
372: ddp_master_geography_rec,
373: ddp_parent_geography_id,
374: x_geography_id,
375: x_return_status,

Line 413: hz_geography_pub_uiw.update_geography(p_init_msg_list,

409:
410:
411:
412: -- here's the delegated call to the old PL/SQL routine
413: hz_geography_pub_uiw.update_geography(p_init_msg_list,
414: p_geography_id,
415: ddp_end_date,
416: p_timezone_code,
417: p_object_version_number,

Line 448: ddp_geography_range_rec hz_geography_pub_uiw.geography_range_rec_type;

444: , p1_a8 VARCHAR2 := null
445: , p1_a9 NUMBER := null
446: )
447: as
448: ddp_geography_range_rec hz_geography_pub_uiw.geography_range_rec_type;
449: ddindx binary_integer; indx binary_integer;
450: begin
451:
452: -- copy data to the local IN or IN-OUT args, if any

Line 469: hz_geography_pub_uiw.create_geography_range(p_init_msg_list,

465:
466:
467:
468: -- here's the delegated call to the old PL/SQL routine
469: hz_geography_pub_uiw.create_geography_range(p_init_msg_list,
470: ddp_geography_range_rec,
471: x_return_status,
472: x_msg_count,
473: x_msg_data);

Line 511: hz_geography_pub_uiw.update_geography_range(p_init_msg_list,

507:
508:
509:
510: -- here's the delegated call to the old PL/SQL routine
511: hz_geography_pub_uiw.update_geography_range(p_init_msg_list,
512: p_geography_id,
513: p_geography_from,
514: ddp_start_date,
515: ddp_end_date,

Line 548: ddp_zone_relation_tbl hz_geography_pub_uiw.zone_relation_tbl_type;

544: , x_msg_count out nocopy NUMBER
545: , x_msg_data out nocopy VARCHAR2
546: )
547: as
548: ddp_zone_relation_tbl hz_geography_pub_uiw.zone_relation_tbl_type;
549: ddindx binary_integer; indx binary_integer;
550: begin
551:
552: -- copy data to the local IN or IN-OUT args, if any

Line 555: hz_geography_pub_uiw_jw.rosetta_table_copy_in_p6(ddp_zone_relation_tbl, p2_a0

551:
552: -- copy data to the local IN or IN-OUT args, if any
553:
554:
555: hz_geography_pub_uiw_jw.rosetta_table_copy_in_p6(ddp_zone_relation_tbl, p2_a0
556: , p2_a1
557: , p2_a2
558: , p2_a3
559: , p2_a4

Line 570: hz_geography_pub_uiw.create_zone_relation(p_init_msg_list,

566:
567:
568:
569: -- here's the delegated call to the old PL/SQL routine
570: hz_geography_pub_uiw.create_zone_relation(p_init_msg_list,
571: p_geography_id,
572: ddp_zone_relation_tbl,
573: p_created_by_module,
574: p_application_id,

Line 616: ddp_zone_relation_tbl hz_geography_pub_uiw.zone_relation_tbl_type;

612: )
613: as
614: ddp_start_date date;
615: ddp_end_date date;
616: ddp_zone_relation_tbl hz_geography_pub_uiw.zone_relation_tbl_type;
617: ddindx binary_integer; indx binary_integer;
618: begin
619:
620: -- copy data to the local IN or IN-OUT args, if any

Line 632: hz_geography_pub_uiw_jw.rosetta_table_copy_in_p6(ddp_zone_relation_tbl, p9_a0

628: ddp_end_date := rosetta_g_miss_date_in_map(p_end_date);
629:
630:
631:
632: hz_geography_pub_uiw_jw.rosetta_table_copy_in_p6(ddp_zone_relation_tbl, p9_a0
633: , p9_a1
634: , p9_a2
635: , p9_a3
636: , p9_a4

Line 649: hz_geography_pub_uiw.create_zone(p_init_msg_list,

645:
646:
647:
648: -- here's the delegated call to the old PL/SQL routine
649: hz_geography_pub_uiw.create_zone(p_init_msg_list,
650: p_zone_type,
651: p_zone_name,
652: p_zone_code,
653: p_zone_code_type,

Line 686: end hz_geography_pub_uiw_jw;

682:
683:
684: end;
685:
686: end hz_geography_pub_uiw_jw;