DBA Data[Home] [Help]

APPS.CSI_GIS_INSTANCE_LOC_PUB_W dependencies on CSI_GIS_INSTANCE_LOC_PUB

Line 1: package body csi_gis_instance_loc_pub_w as

1: package body csi_gis_instance_loc_pub_w as
2: /* $Header: csiwgilb.pls 120.0.12010000.2 2008/11/13 11:28:51 somitra 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: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 25: procedure rosetta_table_copy_in_p1(t out nocopy csi_gis_instance_loc_pub.csi_instance_geoloc_tbl_type, a0 JTF_NUMBER_TABLE

21: if n=b then return a; end if;
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

Line 52: procedure rosetta_table_copy_out_p1(t csi_gis_instance_loc_pub.csi_instance_geoloc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

48: end loop;
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

Line 110: ddp_csi_instance_geoloc_tbl csi_gis_instance_loc_pub.csi_instance_geoloc_tbl_type;

106: , x_msg_data out nocopy VARCHAR2
107: )
108:
109: as
110: ddp_csi_instance_geoloc_tbl csi_gis_instance_loc_pub.csi_instance_geoloc_tbl_type;
111: ddindx binary_integer; indx binary_integer;
112: begin
113:
114: -- copy data to the local IN or IN-OUT args, if any

Line 117: csi_gis_instance_loc_pub_w.rosetta_table_copy_in_p1(ddp_csi_instance_geoloc_tbl, p2_a0

113:
114: -- copy data to the local IN or IN-OUT args, if any
115:
116:
117: csi_gis_instance_loc_pub_w.rosetta_table_copy_in_p1(ddp_csi_instance_geoloc_tbl, p2_a0
118: , p2_a1
119: , p2_a2
120: , p2_a3
121: , p2_a4

Line 129: csi_gis_instance_loc_pub.createupdate_inst_geoloc_info(p_api_version,

125:
126:
127:
128: -- here's the delegated call to the old PL/SQL routine
129: csi_gis_instance_loc_pub.createupdate_inst_geoloc_info(p_api_version,
130: p_commit,
131: ddp_csi_instance_geoloc_tbl,
132: p_asset_context,
133: x_return_status,

Line 146: end csi_gis_instance_loc_pub_w;

142:
143:
144: end;
145:
146: end csi_gis_instance_loc_pub_w;