DBA Data[Home] [Help]

APPS.CSI_GIS_INSTANCE_LOC_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 26: , a1 JTF_VARCHAR2_TABLE_100

22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p1(t out nocopy csi_gis_instance_loc_pub.csi_instance_geoloc_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_100
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_VARCHAR2_TABLE_100
29: , a4 JTF_VARCHAR2_TABLE_100
30: ) as

Line 27: , a2 JTF_VARCHAR2_TABLE_100

23: end;
24:
25: procedure rosetta_table_copy_in_p1(t out nocopy csi_gis_instance_loc_pub.csi_instance_geoloc_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_100
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_VARCHAR2_TABLE_100
29: , a4 JTF_VARCHAR2_TABLE_100
30: ) as
31: ddindx binary_integer; indx binary_integer;

Line 28: , a3 JTF_VARCHAR2_TABLE_100

24:
25: procedure rosetta_table_copy_in_p1(t out nocopy csi_gis_instance_loc_pub.csi_instance_geoloc_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_100
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_VARCHAR2_TABLE_100
29: , a4 JTF_VARCHAR2_TABLE_100
30: ) as
31: ddindx binary_integer; indx binary_integer;
32: begin

Line 29: , a4 JTF_VARCHAR2_TABLE_100

25: procedure rosetta_table_copy_in_p1(t out nocopy csi_gis_instance_loc_pub.csi_instance_geoloc_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_100
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_VARCHAR2_TABLE_100
29: , a4 JTF_VARCHAR2_TABLE_100
30: ) as
31: ddindx binary_integer; indx binary_integer;
32: begin
33: if a0 is not null and a0.count > 0 then

Line 53: , a1 out nocopy JTF_VARCHAR2_TABLE_100

49: end if;
50: end if;
51: end rosetta_table_copy_in_p1;
52: procedure rosetta_table_copy_out_p1(t csi_gis_instance_loc_pub.csi_instance_geoloc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
53: , a1 out nocopy JTF_VARCHAR2_TABLE_100
54: , a2 out nocopy JTF_VARCHAR2_TABLE_100
55: , a3 out nocopy JTF_VARCHAR2_TABLE_100
56: , a4 out nocopy JTF_VARCHAR2_TABLE_100
57: ) as

Line 54: , a2 out nocopy JTF_VARCHAR2_TABLE_100

50: end if;
51: end rosetta_table_copy_in_p1;
52: procedure rosetta_table_copy_out_p1(t csi_gis_instance_loc_pub.csi_instance_geoloc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
53: , a1 out nocopy JTF_VARCHAR2_TABLE_100
54: , a2 out nocopy JTF_VARCHAR2_TABLE_100
55: , a3 out nocopy JTF_VARCHAR2_TABLE_100
56: , a4 out nocopy JTF_VARCHAR2_TABLE_100
57: ) as
58: ddindx binary_integer; indx binary_integer;

Line 55: , a3 out nocopy JTF_VARCHAR2_TABLE_100

51: end rosetta_table_copy_in_p1;
52: procedure rosetta_table_copy_out_p1(t csi_gis_instance_loc_pub.csi_instance_geoloc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
53: , a1 out nocopy JTF_VARCHAR2_TABLE_100
54: , a2 out nocopy JTF_VARCHAR2_TABLE_100
55: , a3 out nocopy JTF_VARCHAR2_TABLE_100
56: , a4 out nocopy JTF_VARCHAR2_TABLE_100
57: ) as
58: ddindx binary_integer; indx binary_integer;
59: begin

Line 56: , a4 out nocopy JTF_VARCHAR2_TABLE_100

52: procedure rosetta_table_copy_out_p1(t csi_gis_instance_loc_pub.csi_instance_geoloc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
53: , a1 out nocopy JTF_VARCHAR2_TABLE_100
54: , a2 out nocopy JTF_VARCHAR2_TABLE_100
55: , a3 out nocopy JTF_VARCHAR2_TABLE_100
56: , a4 out nocopy JTF_VARCHAR2_TABLE_100
57: ) as
58: ddindx binary_integer; indx binary_integer;
59: begin
60: if t is null or t.count = 0 then

Line 62: a1 := JTF_VARCHAR2_TABLE_100();

58: ddindx binary_integer; indx binary_integer;
59: begin
60: if t is null or t.count = 0 then
61: a0 := JTF_NUMBER_TABLE();
62: a1 := JTF_VARCHAR2_TABLE_100();
63: a2 := JTF_VARCHAR2_TABLE_100();
64: a3 := JTF_VARCHAR2_TABLE_100();
65: a4 := JTF_VARCHAR2_TABLE_100();
66: else

Line 63: a2 := JTF_VARCHAR2_TABLE_100();

59: begin
60: if t is null or t.count = 0 then
61: a0 := JTF_NUMBER_TABLE();
62: a1 := JTF_VARCHAR2_TABLE_100();
63: a2 := JTF_VARCHAR2_TABLE_100();
64: a3 := JTF_VARCHAR2_TABLE_100();
65: a4 := JTF_VARCHAR2_TABLE_100();
66: else
67: a0 := JTF_NUMBER_TABLE();

Line 64: a3 := JTF_VARCHAR2_TABLE_100();

60: if t is null or t.count = 0 then
61: a0 := JTF_NUMBER_TABLE();
62: a1 := JTF_VARCHAR2_TABLE_100();
63: a2 := JTF_VARCHAR2_TABLE_100();
64: a3 := JTF_VARCHAR2_TABLE_100();
65: a4 := JTF_VARCHAR2_TABLE_100();
66: else
67: a0 := JTF_NUMBER_TABLE();
68: a1 := JTF_VARCHAR2_TABLE_100();

Line 65: a4 := JTF_VARCHAR2_TABLE_100();

61: a0 := JTF_NUMBER_TABLE();
62: a1 := JTF_VARCHAR2_TABLE_100();
63: a2 := JTF_VARCHAR2_TABLE_100();
64: a3 := JTF_VARCHAR2_TABLE_100();
65: a4 := JTF_VARCHAR2_TABLE_100();
66: else
67: a0 := JTF_NUMBER_TABLE();
68: a1 := JTF_VARCHAR2_TABLE_100();
69: a2 := JTF_VARCHAR2_TABLE_100();

Line 68: a1 := JTF_VARCHAR2_TABLE_100();

64: a3 := JTF_VARCHAR2_TABLE_100();
65: a4 := JTF_VARCHAR2_TABLE_100();
66: else
67: a0 := JTF_NUMBER_TABLE();
68: a1 := JTF_VARCHAR2_TABLE_100();
69: a2 := JTF_VARCHAR2_TABLE_100();
70: a3 := JTF_VARCHAR2_TABLE_100();
71: a4 := JTF_VARCHAR2_TABLE_100();
72: if t.count > 0 then

Line 69: a2 := JTF_VARCHAR2_TABLE_100();

65: a4 := JTF_VARCHAR2_TABLE_100();
66: else
67: a0 := JTF_NUMBER_TABLE();
68: a1 := JTF_VARCHAR2_TABLE_100();
69: a2 := JTF_VARCHAR2_TABLE_100();
70: a3 := JTF_VARCHAR2_TABLE_100();
71: a4 := JTF_VARCHAR2_TABLE_100();
72: if t.count > 0 then
73: a0.extend(t.count);

Line 70: a3 := JTF_VARCHAR2_TABLE_100();

66: else
67: a0 := JTF_NUMBER_TABLE();
68: a1 := JTF_VARCHAR2_TABLE_100();
69: a2 := JTF_VARCHAR2_TABLE_100();
70: a3 := JTF_VARCHAR2_TABLE_100();
71: a4 := JTF_VARCHAR2_TABLE_100();
72: if t.count > 0 then
73: a0.extend(t.count);
74: a1.extend(t.count);

Line 71: a4 := JTF_VARCHAR2_TABLE_100();

67: a0 := JTF_NUMBER_TABLE();
68: a1 := JTF_VARCHAR2_TABLE_100();
69: a2 := JTF_VARCHAR2_TABLE_100();
70: a3 := JTF_VARCHAR2_TABLE_100();
71: a4 := JTF_VARCHAR2_TABLE_100();
72: if t.count > 0 then
73: a0.extend(t.count);
74: a1.extend(t.count);
75: a2.extend(t.count);

Line 99: , p2_a1 JTF_VARCHAR2_TABLE_100

95:
96: procedure createupdate_inst_geoloc_info(p_api_version NUMBER
97: , p_commit VARCHAR2
98: , p2_a0 JTF_NUMBER_TABLE
99: , p2_a1 JTF_VARCHAR2_TABLE_100
100: , p2_a2 JTF_VARCHAR2_TABLE_100
101: , p2_a3 JTF_VARCHAR2_TABLE_100
102: , p2_a4 JTF_VARCHAR2_TABLE_100
103: , p_asset_context VARCHAR2

Line 100: , p2_a2 JTF_VARCHAR2_TABLE_100

96: procedure createupdate_inst_geoloc_info(p_api_version NUMBER
97: , p_commit VARCHAR2
98: , p2_a0 JTF_NUMBER_TABLE
99: , p2_a1 JTF_VARCHAR2_TABLE_100
100: , p2_a2 JTF_VARCHAR2_TABLE_100
101: , p2_a3 JTF_VARCHAR2_TABLE_100
102: , p2_a4 JTF_VARCHAR2_TABLE_100
103: , p_asset_context VARCHAR2
104: , x_return_status out nocopy VARCHAR2

Line 101: , p2_a3 JTF_VARCHAR2_TABLE_100

97: , p_commit VARCHAR2
98: , p2_a0 JTF_NUMBER_TABLE
99: , p2_a1 JTF_VARCHAR2_TABLE_100
100: , p2_a2 JTF_VARCHAR2_TABLE_100
101: , p2_a3 JTF_VARCHAR2_TABLE_100
102: , p2_a4 JTF_VARCHAR2_TABLE_100
103: , p_asset_context VARCHAR2
104: , x_return_status out nocopy VARCHAR2
105: , x_msg_count out nocopy NUMBER

Line 102: , p2_a4 JTF_VARCHAR2_TABLE_100

98: , p2_a0 JTF_NUMBER_TABLE
99: , p2_a1 JTF_VARCHAR2_TABLE_100
100: , p2_a2 JTF_VARCHAR2_TABLE_100
101: , p2_a3 JTF_VARCHAR2_TABLE_100
102: , p2_a4 JTF_VARCHAR2_TABLE_100
103: , p_asset_context VARCHAR2
104: , x_return_status out nocopy VARCHAR2
105: , x_msg_count out nocopy NUMBER
106: , x_msg_data out nocopy VARCHAR2