DBA Data[Home] [Help]

APPS.HZ_GEOGRAPHY_PUB_UIW_JW dependencies on JTF_NUMBER_TABLE

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 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 52: a0 := JTF_NUMBER_TABLE();

48: begin
49: if t is null then
50: a0 := null;
51: elsif t.count = 0 then
52: a0 := JTF_NUMBER_TABLE();
53: else
54: a0 := JTF_NUMBER_TABLE();
55: if t.count > 0 then
56: a0.extend(t.count);

Line 54: a0 := JTF_NUMBER_TABLE();

50: a0 := null;
51: elsif t.count = 0 then
52: a0 := JTF_NUMBER_TABLE();
53: else
54: a0 := JTF_NUMBER_TABLE();
55: if t.count > 0 then
56: a0.extend(t.count);
57: ddindx := t.first;
58: indx := 1;

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 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 125: a0 := JTF_NUMBER_TABLE();

121: a4 := null;
122: a5 := null;
123: a6 := null;
124: elsif t.count = 0 then
125: a0 := JTF_NUMBER_TABLE();
126: a1 := JTF_VARCHAR2_TABLE_400();
127: a2 := JTF_VARCHAR2_TABLE_400();
128: a3 := JTF_VARCHAR2_TABLE_100();
129: a4 := JTF_VARCHAR2_TABLE_100();

Line 133: a0 := JTF_NUMBER_TABLE();

129: a4 := JTF_VARCHAR2_TABLE_100();
130: a5 := JTF_DATE_TABLE();
131: a6 := JTF_DATE_TABLE();
132: else
133: a0 := JTF_NUMBER_TABLE();
134: a1 := JTF_VARCHAR2_TABLE_400();
135: a2 := JTF_VARCHAR2_TABLE_400();
136: a3 := JTF_VARCHAR2_TABLE_100();
137: a4 := JTF_VARCHAR2_TABLE_100();

Line 327: , p_parent_geography_id JTF_NUMBER_TABLE

323:
324: end;
325:
326: procedure create_master_geography(p_init_msg_list VARCHAR2
327: , p_parent_geography_id JTF_NUMBER_TABLE
328: , x_geography_id out nocopy NUMBER
329: , x_return_status out nocopy VARCHAR2
330: , x_msg_count out nocopy NUMBER
331: , x_msg_data out nocopy VARCHAR2

Line 534: , p2_a0 JTF_NUMBER_TABLE

530: end;
531:
532: procedure create_zone_relation(p_init_msg_list VARCHAR2
533: , p_geography_id NUMBER
534: , p2_a0 JTF_NUMBER_TABLE
535: , p2_a1 JTF_VARCHAR2_TABLE_400
536: , p2_a2 JTF_VARCHAR2_TABLE_400
537: , p2_a3 JTF_VARCHAR2_TABLE_100
538: , p2_a4 JTF_VARCHAR2_TABLE_100

Line 598: , p9_a0 JTF_NUMBER_TABLE

594: , p_start_date date
595: , p_end_date date
596: , p_geo_data_provider VARCHAR2
597: , p_language_code VARCHAR2
598: , p9_a0 JTF_NUMBER_TABLE
599: , p9_a1 JTF_VARCHAR2_TABLE_400
600: , p9_a2 JTF_VARCHAR2_TABLE_400
601: , p9_a3 JTF_VARCHAR2_TABLE_100
602: , p9_a4 JTF_VARCHAR2_TABLE_100