DBA Data[Home] [Help]

APPS.HZ_GEOGRAPHY_PUB_UIW_JW dependencies on JTF_VARCHAR2_TABLE_100

Line 74: , a3 JTF_VARCHAR2_TABLE_100

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
76: , a5 JTF_DATE_TABLE
77: , a6 JTF_DATE_TABLE
78: ) as

Line 75: , a4 JTF_VARCHAR2_TABLE_100

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
76: , a5 JTF_DATE_TABLE
77: , a6 JTF_DATE_TABLE
78: ) as
79: ddindx binary_integer; indx binary_integer;

Line 109: , a3 out nocopy JTF_VARCHAR2_TABLE_100

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
111: , a5 out nocopy JTF_DATE_TABLE
112: , a6 out nocopy JTF_DATE_TABLE
113: ) as

Line 110: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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
111: , a5 out nocopy JTF_DATE_TABLE
112: , a6 out nocopy JTF_DATE_TABLE
113: ) as
114: ddindx binary_integer; indx binary_integer;

Line 128: a3 := JTF_VARCHAR2_TABLE_100();

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();
130: a5 := JTF_DATE_TABLE();
131: a6 := JTF_DATE_TABLE();
132: else

Line 129: a4 := JTF_VARCHAR2_TABLE_100();

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();
130: a5 := JTF_DATE_TABLE();
131: a6 := JTF_DATE_TABLE();
132: else
133: a0 := JTF_NUMBER_TABLE();

Line 136: a3 := JTF_VARCHAR2_TABLE_100();

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();
138: a5 := JTF_DATE_TABLE();
139: a6 := JTF_DATE_TABLE();
140: if t.count > 0 then

Line 137: a4 := JTF_VARCHAR2_TABLE_100();

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();
138: a5 := JTF_DATE_TABLE();
139: a6 := JTF_DATE_TABLE();
140: if t.count > 0 then
141: a0.extend(t.count);

Line 537: , p2_a3 JTF_VARCHAR2_TABLE_100

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
539: , p2_a5 JTF_DATE_TABLE
540: , p2_a6 JTF_DATE_TABLE
541: , p_created_by_module VARCHAR2

Line 538: , p2_a4 JTF_VARCHAR2_TABLE_100

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
539: , p2_a5 JTF_DATE_TABLE
540: , p2_a6 JTF_DATE_TABLE
541: , p_created_by_module VARCHAR2
542: , p_application_id NUMBER

Line 601: , p9_a3 JTF_VARCHAR2_TABLE_100

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
603: , p9_a5 JTF_DATE_TABLE
604: , p9_a6 JTF_DATE_TABLE
605: , p_timezone_code VARCHAR2

Line 602: , p9_a4 JTF_VARCHAR2_TABLE_100

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
603: , p9_a5 JTF_DATE_TABLE
604: , p9_a6 JTF_DATE_TABLE
605: , p_timezone_code VARCHAR2
606: , x_geography_id out nocopy NUMBER