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.CSI_CTR_DATASTRUCTURES_PUB_W dependencies on CSI_CTR_DATASTRUCTURES_PUB

Line 1: package body csi_ctr_datastructures_pub_w as

1: package body csi_ctr_datastructures_pub_w as
2: /* $Header: csitcdwb.pls 120.10 2008/03/26 09:11:52 ngoutam ship $ */
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_p4(t out nocopy csi_ctr_datastructures_pub.counter_groups_tbl, 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_p4(t out nocopy csi_ctr_datastructures_pub.counter_groups_tbl, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_100
27: , a2 JTF_VARCHAR2_TABLE_300
28: , a3 JTF_VARCHAR2_TABLE_100
29: , a4 JTF_DATE_TABLE

Line 112: procedure rosetta_table_copy_out_p4(t csi_ctr_datastructures_pub.counter_groups_tbl, a0 out nocopy JTF_NUMBER_TABLE

108: end loop;
109: end if;
110: end if;
111: end rosetta_table_copy_in_p4;
112: procedure rosetta_table_copy_out_p4(t csi_ctr_datastructures_pub.counter_groups_tbl, a0 out nocopy JTF_NUMBER_TABLE
113: , a1 out nocopy JTF_VARCHAR2_TABLE_100
114: , a2 out nocopy JTF_VARCHAR2_TABLE_300
115: , a3 out nocopy JTF_VARCHAR2_TABLE_100
116: , a4 out nocopy JTF_DATE_TABLE

Line 306: procedure rosetta_table_copy_in_p6(t out nocopy csi_ctr_datastructures_pub.counter_template_tbl, a0 JTF_NUMBER_TABLE

302: end if;
303: end if;
304: end rosetta_table_copy_out_p4;
305:
306: procedure rosetta_table_copy_in_p6(t out nocopy csi_ctr_datastructures_pub.counter_template_tbl, a0 JTF_NUMBER_TABLE
307: , a1 JTF_NUMBER_TABLE
308: , a2 JTF_VARCHAR2_TABLE_100
309: , a3 JTF_NUMBER_TABLE
310: , a4 JTF_DATE_TABLE

Line 479: procedure rosetta_table_copy_out_p6(t csi_ctr_datastructures_pub.counter_template_tbl, a0 out nocopy JTF_NUMBER_TABLE

475: end loop;
476: end if;
477: end if;
478: end rosetta_table_copy_in_p6;
479: procedure rosetta_table_copy_out_p6(t csi_ctr_datastructures_pub.counter_template_tbl, a0 out nocopy JTF_NUMBER_TABLE
480: , a1 out nocopy JTF_NUMBER_TABLE
481: , a2 out nocopy JTF_VARCHAR2_TABLE_100
482: , a3 out nocopy JTF_NUMBER_TABLE
483: , a4 out nocopy JTF_DATE_TABLE

Line 888: procedure rosetta_table_copy_in_p8(t out nocopy csi_ctr_datastructures_pub.ctr_item_associations_tbl, a0 JTF_NUMBER_TABLE

884: end if;
885: end if;
886: end rosetta_table_copy_out_p6;
887:
888: procedure rosetta_table_copy_in_p8(t out nocopy csi_ctr_datastructures_pub.ctr_item_associations_tbl, a0 JTF_NUMBER_TABLE
889: , a1 JTF_NUMBER_TABLE
890: , a2 JTF_NUMBER_TABLE
891: , a3 JTF_NUMBER_TABLE
892: , a4 JTF_DATE_TABLE

Line 975: procedure rosetta_table_copy_out_p8(t csi_ctr_datastructures_pub.ctr_item_associations_tbl, a0 out nocopy JTF_NUMBER_TABLE

971: end loop;
972: end if;
973: end if;
974: end rosetta_table_copy_in_p8;
975: procedure rosetta_table_copy_out_p8(t csi_ctr_datastructures_pub.ctr_item_associations_tbl, a0 out nocopy JTF_NUMBER_TABLE
976: , a1 out nocopy JTF_NUMBER_TABLE
977: , a2 out nocopy JTF_NUMBER_TABLE
978: , a3 out nocopy JTF_NUMBER_TABLE
979: , a4 out nocopy JTF_DATE_TABLE

Line 1169: procedure rosetta_table_copy_in_p10(t out nocopy csi_ctr_datastructures_pub.counter_relationships_tbl, a0 JTF_NUMBER_TABLE

1165: end if;
1166: end if;
1167: end rosetta_table_copy_out_p8;
1168:
1169: procedure rosetta_table_copy_in_p10(t out nocopy csi_ctr_datastructures_pub.counter_relationships_tbl, a0 JTF_NUMBER_TABLE
1170: , a1 JTF_NUMBER_TABLE
1171: , a2 JTF_VARCHAR2_TABLE_100
1172: , a3 JTF_NUMBER_TABLE
1173: , a4 JTF_NUMBER_TABLE

Line 1252: procedure rosetta_table_copy_out_p10(t csi_ctr_datastructures_pub.counter_relationships_tbl, a0 out nocopy JTF_NUMBER_TABLE

1248: end loop;
1249: end if;
1250: end if;
1251: end rosetta_table_copy_in_p10;
1252: procedure rosetta_table_copy_out_p10(t csi_ctr_datastructures_pub.counter_relationships_tbl, a0 out nocopy JTF_NUMBER_TABLE
1253: , a1 out nocopy JTF_NUMBER_TABLE
1254: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1255: , a3 out nocopy JTF_NUMBER_TABLE
1256: , a4 out nocopy JTF_NUMBER_TABLE

Line 1436: procedure rosetta_table_copy_in_p12(t out nocopy csi_ctr_datastructures_pub.ctr_property_template_tbl, a0 JTF_NUMBER_TABLE

1432: end if;
1433: end if;
1434: end rosetta_table_copy_out_p10;
1435:
1436: procedure rosetta_table_copy_in_p12(t out nocopy csi_ctr_datastructures_pub.ctr_property_template_tbl, a0 JTF_NUMBER_TABLE
1437: , a1 JTF_NUMBER_TABLE
1438: , a2 JTF_VARCHAR2_TABLE_100
1439: , a3 JTF_VARCHAR2_TABLE_100
1440: , a4 JTF_VARCHAR2_TABLE_300

Line 1527: procedure rosetta_table_copy_out_p12(t csi_ctr_datastructures_pub.ctr_property_template_tbl, a0 out nocopy JTF_NUMBER_TABLE

1523: end loop;
1524: end if;
1525: end if;
1526: end rosetta_table_copy_in_p12;
1527: procedure rosetta_table_copy_out_p12(t csi_ctr_datastructures_pub.ctr_property_template_tbl, a0 out nocopy JTF_NUMBER_TABLE
1528: , a1 out nocopy JTF_NUMBER_TABLE
1529: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1530: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1531: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 1731: procedure rosetta_table_copy_in_p14(t out nocopy csi_ctr_datastructures_pub.ctr_estimation_methods_tbl, a0 JTF_NUMBER_TABLE

1727: end if;
1728: end if;
1729: end rosetta_table_copy_out_p12;
1730:
1731: procedure rosetta_table_copy_in_p14(t out nocopy csi_ctr_datastructures_pub.ctr_estimation_methods_tbl, a0 JTF_NUMBER_TABLE
1732: , a1 JTF_VARCHAR2_TABLE_100
1733: , a2 JTF_NUMBER_TABLE
1734: , a3 JTF_NUMBER_TABLE
1735: , a4 JTF_NUMBER_TABLE

Line 1814: procedure rosetta_table_copy_out_p14(t csi_ctr_datastructures_pub.ctr_estimation_methods_tbl, a0 out nocopy JTF_NUMBER_TABLE

1810: end loop;
1811: end if;
1812: end if;
1813: end rosetta_table_copy_in_p14;
1814: procedure rosetta_table_copy_out_p14(t csi_ctr_datastructures_pub.ctr_estimation_methods_tbl, a0 out nocopy JTF_NUMBER_TABLE
1815: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1816: , a2 out nocopy JTF_NUMBER_TABLE
1817: , a3 out nocopy JTF_NUMBER_TABLE
1818: , a4 out nocopy JTF_NUMBER_TABLE

Line 1998: procedure rosetta_table_copy_in_p16(t out nocopy csi_ctr_datastructures_pub.ctr_derived_filters_tbl, a0 JTF_NUMBER_TABLE

1994: end if;
1995: end if;
1996: end rosetta_table_copy_out_p14;
1997:
1998: procedure rosetta_table_copy_in_p16(t out nocopy csi_ctr_datastructures_pub.ctr_derived_filters_tbl, a0 JTF_NUMBER_TABLE
1999: , a1 JTF_NUMBER_TABLE
2000: , a2 JTF_NUMBER_TABLE
2001: , a3 JTF_VARCHAR2_TABLE_100
2002: , a4 JTF_NUMBER_TABLE

Line 2085: procedure rosetta_table_copy_out_p16(t csi_ctr_datastructures_pub.ctr_derived_filters_tbl, a0 out nocopy JTF_NUMBER_TABLE

2081: end loop;
2082: end if;
2083: end if;
2084: end rosetta_table_copy_in_p16;
2085: procedure rosetta_table_copy_out_p16(t csi_ctr_datastructures_pub.ctr_derived_filters_tbl, a0 out nocopy JTF_NUMBER_TABLE
2086: , a1 out nocopy JTF_NUMBER_TABLE
2087: , a2 out nocopy JTF_NUMBER_TABLE
2088: , a3 out nocopy JTF_VARCHAR2_TABLE_100
2089: , a4 out nocopy JTF_NUMBER_TABLE

Line 2279: procedure rosetta_table_copy_in_p18(t out nocopy csi_ctr_datastructures_pub.counter_instance_tbl, a0 JTF_NUMBER_TABLE

2275: end if;
2276: end if;
2277: end rosetta_table_copy_out_p16;
2278:
2279: procedure rosetta_table_copy_in_p18(t out nocopy csi_ctr_datastructures_pub.counter_instance_tbl, a0 JTF_NUMBER_TABLE
2280: , a1 JTF_NUMBER_TABLE
2281: , a2 JTF_VARCHAR2_TABLE_100
2282: , a3 JTF_NUMBER_TABLE
2283: , a4 JTF_DATE_TABLE

Line 2452: procedure rosetta_table_copy_out_p18(t csi_ctr_datastructures_pub.counter_instance_tbl, a0 out nocopy JTF_NUMBER_TABLE

2448: end loop;
2449: end if;
2450: end if;
2451: end rosetta_table_copy_in_p18;
2452: procedure rosetta_table_copy_out_p18(t csi_ctr_datastructures_pub.counter_instance_tbl, a0 out nocopy JTF_NUMBER_TABLE
2453: , a1 out nocopy JTF_NUMBER_TABLE
2454: , a2 out nocopy JTF_VARCHAR2_TABLE_100
2455: , a3 out nocopy JTF_NUMBER_TABLE
2456: , a4 out nocopy JTF_DATE_TABLE

Line 2861: procedure rosetta_table_copy_in_p20(t out nocopy csi_ctr_datastructures_pub.ctr_properties_tbl, a0 JTF_NUMBER_TABLE

2857: end if;
2858: end if;
2859: end rosetta_table_copy_out_p18;
2860:
2861: procedure rosetta_table_copy_in_p20(t out nocopy csi_ctr_datastructures_pub.ctr_properties_tbl, a0 JTF_NUMBER_TABLE
2862: , a1 JTF_NUMBER_TABLE
2863: , a2 JTF_VARCHAR2_TABLE_100
2864: , a3 JTF_VARCHAR2_TABLE_100
2865: , a4 JTF_VARCHAR2_TABLE_300

Line 2954: procedure rosetta_table_copy_out_p20(t csi_ctr_datastructures_pub.ctr_properties_tbl, a0 out nocopy JTF_NUMBER_TABLE

2950: end loop;
2951: end if;
2952: end if;
2953: end rosetta_table_copy_in_p20;
2954: procedure rosetta_table_copy_out_p20(t csi_ctr_datastructures_pub.ctr_properties_tbl, a0 out nocopy JTF_NUMBER_TABLE
2955: , a1 out nocopy JTF_NUMBER_TABLE
2956: , a2 out nocopy JTF_VARCHAR2_TABLE_100
2957: , a3 out nocopy JTF_VARCHAR2_TABLE_100
2958: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 3163: procedure rosetta_table_copy_in_p22(t out nocopy csi_ctr_datastructures_pub.counter_associations_tbl, a0 JTF_NUMBER_TABLE

3159: end if;
3160: end if;
3161: end rosetta_table_copy_out_p20;
3162:
3163: procedure rosetta_table_copy_in_p22(t out nocopy csi_ctr_datastructures_pub.counter_associations_tbl, a0 JTF_NUMBER_TABLE
3164: , a1 JTF_VARCHAR2_TABLE_100
3165: , a2 JTF_NUMBER_TABLE
3166: , a3 JTF_NUMBER_TABLE
3167: , a4 JTF_DATE_TABLE

Line 3244: procedure rosetta_table_copy_out_p22(t csi_ctr_datastructures_pub.counter_associations_tbl, a0 out nocopy JTF_NUMBER_TABLE

3240: end loop;
3241: end if;
3242: end if;
3243: end rosetta_table_copy_in_p22;
3244: procedure rosetta_table_copy_out_p22(t csi_ctr_datastructures_pub.counter_associations_tbl, a0 out nocopy JTF_NUMBER_TABLE
3245: , a1 out nocopy JTF_VARCHAR2_TABLE_100
3246: , a2 out nocopy JTF_NUMBER_TABLE
3247: , a3 out nocopy JTF_NUMBER_TABLE
3248: , a4 out nocopy JTF_DATE_TABLE

Line 3423: procedure rosetta_table_copy_in_p24(t out nocopy csi_ctr_datastructures_pub.counter_readings_tbl, a0 JTF_NUMBER_TABLE

3419: end if;
3420: end if;
3421: end rosetta_table_copy_out_p22;
3422:
3423: procedure rosetta_table_copy_in_p24(t out nocopy csi_ctr_datastructures_pub.counter_readings_tbl, a0 JTF_NUMBER_TABLE
3424: , a1 JTF_NUMBER_TABLE
3425: , a2 JTF_DATE_TABLE
3426: , a3 JTF_NUMBER_TABLE
3427: , a4 JTF_VARCHAR2_TABLE_100

Line 3560: procedure rosetta_table_copy_out_p24(t csi_ctr_datastructures_pub.counter_readings_tbl, a0 out nocopy JTF_NUMBER_TABLE

3556: end loop;
3557: end if;
3558: end if;
3559: end rosetta_table_copy_in_p24;
3560: procedure rosetta_table_copy_out_p24(t csi_ctr_datastructures_pub.counter_readings_tbl, a0 out nocopy JTF_NUMBER_TABLE
3561: , a1 out nocopy JTF_NUMBER_TABLE
3562: , a2 out nocopy JTF_DATE_TABLE
3563: , a3 out nocopy JTF_NUMBER_TABLE
3564: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 3879: procedure rosetta_table_copy_in_p26(t out nocopy csi_ctr_datastructures_pub.ctr_property_readings_tbl, a0 JTF_NUMBER_TABLE

3875: end if;
3876: end if;
3877: end rosetta_table_copy_out_p24;
3878:
3879: procedure rosetta_table_copy_in_p26(t out nocopy csi_ctr_datastructures_pub.ctr_property_readings_tbl, a0 JTF_NUMBER_TABLE
3880: , a1 JTF_NUMBER_TABLE
3881: , a2 JTF_NUMBER_TABLE
3882: , a3 JTF_VARCHAR2_TABLE_300
3883: , a4 JTF_DATE_TABLE

Line 3956: procedure rosetta_table_copy_out_p26(t csi_ctr_datastructures_pub.ctr_property_readings_tbl, a0 out nocopy JTF_NUMBER_TABLE

3952: end loop;
3953: end if;
3954: end if;
3955: end rosetta_table_copy_in_p26;
3956: procedure rosetta_table_copy_out_p26(t csi_ctr_datastructures_pub.ctr_property_readings_tbl, a0 out nocopy JTF_NUMBER_TABLE
3957: , a1 out nocopy JTF_NUMBER_TABLE
3958: , a2 out nocopy JTF_NUMBER_TABLE
3959: , a3 out nocopy JTF_VARCHAR2_TABLE_300
3960: , a4 out nocopy JTF_DATE_TABLE

Line 4125: procedure rosetta_table_copy_in_p28(t out nocopy csi_ctr_datastructures_pub.ctr_usage_forecast_tbl, a0 JTF_NUMBER_TABLE

4121: end if;
4122: end if;
4123: end rosetta_table_copy_out_p26;
4124:
4125: procedure rosetta_table_copy_in_p28(t out nocopy csi_ctr_datastructures_pub.ctr_usage_forecast_tbl, a0 JTF_NUMBER_TABLE
4126: , a1 JTF_NUMBER_TABLE
4127: , a2 JTF_NUMBER_TABLE
4128: , a3 JTF_NUMBER_TABLE
4129: , a4 JTF_DATE_TABLE

Line 4166: procedure rosetta_table_copy_out_p28(t csi_ctr_datastructures_pub.ctr_usage_forecast_tbl, a0 out nocopy JTF_NUMBER_TABLE

4162: end loop;
4163: end if;
4164: end if;
4165: end rosetta_table_copy_in_p28;
4166: procedure rosetta_table_copy_out_p28(t csi_ctr_datastructures_pub.ctr_usage_forecast_tbl, a0 out nocopy JTF_NUMBER_TABLE
4167: , a1 out nocopy JTF_NUMBER_TABLE
4168: , a2 out nocopy JTF_NUMBER_TABLE
4169: , a3 out nocopy JTF_NUMBER_TABLE
4170: , a4 out nocopy JTF_DATE_TABLE

Line 4245: procedure rosetta_table_copy_in_p30(t out nocopy csi_ctr_datastructures_pub.ctr_reading_lock_tbl, a0 JTF_NUMBER_TABLE

4241: end if;
4242: end if;
4243: end rosetta_table_copy_out_p28;
4244:
4245: procedure rosetta_table_copy_in_p30(t out nocopy csi_ctr_datastructures_pub.ctr_reading_lock_tbl, a0 JTF_NUMBER_TABLE
4246: , a1 JTF_NUMBER_TABLE
4247: , a2 JTF_DATE_TABLE
4248: , a3 JTF_DATE_TABLE
4249: , a4 JTF_DATE_TABLE

Line 4300: procedure rosetta_table_copy_out_p30(t csi_ctr_datastructures_pub.ctr_reading_lock_tbl, a0 out nocopy JTF_NUMBER_TABLE

4296: end loop;
4297: end if;
4298: end if;
4299: end rosetta_table_copy_in_p30;
4300: procedure rosetta_table_copy_out_p30(t csi_ctr_datastructures_pub.ctr_reading_lock_tbl, a0 out nocopy JTF_NUMBER_TABLE
4301: , a1 out nocopy JTF_NUMBER_TABLE
4302: , a2 out nocopy JTF_DATE_TABLE
4303: , a3 out nocopy JTF_DATE_TABLE
4304: , a4 out nocopy JTF_DATE_TABLE

Line 4414: procedure rosetta_table_copy_in_p32(t out nocopy csi_ctr_datastructures_pub.ctr_estimated_readings_tbl, a0 JTF_NUMBER_TABLE

4410: end if;
4411: end if;
4412: end rosetta_table_copy_out_p30;
4413:
4414: procedure rosetta_table_copy_in_p32(t out nocopy csi_ctr_datastructures_pub.ctr_estimated_readings_tbl, a0 JTF_NUMBER_TABLE
4415: , a1 JTF_NUMBER_TABLE
4416: , a2 JTF_NUMBER_TABLE
4417: , a3 JTF_DATE_TABLE
4418: , a4 JTF_NUMBER_TABLE

Line 4497: procedure rosetta_table_copy_out_p32(t csi_ctr_datastructures_pub.ctr_estimated_readings_tbl, a0 out nocopy JTF_NUMBER_TABLE

4493: end loop;
4494: end if;
4495: end if;
4496: end rosetta_table_copy_in_p32;
4497: procedure rosetta_table_copy_out_p32(t csi_ctr_datastructures_pub.ctr_estimated_readings_tbl, a0 out nocopy JTF_NUMBER_TABLE
4498: , a1 out nocopy JTF_NUMBER_TABLE
4499: , a2 out nocopy JTF_NUMBER_TABLE
4500: , a3 out nocopy JTF_DATE_TABLE
4501: , a4 out nocopy JTF_NUMBER_TABLE

Line 4681: procedure rosetta_table_copy_in_p34(t out nocopy csi_ctr_datastructures_pub.ctr_readings_interface_tbl, a0 JTF_NUMBER_TABLE

4677: end if;
4678: end if;
4679: end rosetta_table_copy_out_p32;
4680:
4681: procedure rosetta_table_copy_in_p34(t out nocopy csi_ctr_datastructures_pub.ctr_readings_interface_tbl, a0 JTF_NUMBER_TABLE
4682: , a1 JTF_NUMBER_TABLE
4683: , a2 JTF_VARCHAR2_TABLE_100
4684: , a3 JTF_DATE_TABLE
4685: , a4 JTF_VARCHAR2_TABLE_100

Line 4828: procedure rosetta_table_copy_out_p34(t csi_ctr_datastructures_pub.ctr_readings_interface_tbl, a0 out nocopy JTF_NUMBER_TABLE

4824: end loop;
4825: end if;
4826: end if;
4827: end rosetta_table_copy_in_p34;
4828: procedure rosetta_table_copy_out_p34(t csi_ctr_datastructures_pub.ctr_readings_interface_tbl, a0 out nocopy JTF_NUMBER_TABLE
4829: , a1 out nocopy JTF_NUMBER_TABLE
4830: , a2 out nocopy JTF_VARCHAR2_TABLE_100
4831: , a3 out nocopy JTF_DATE_TABLE
4832: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 5172: procedure rosetta_table_copy_in_p36(t out nocopy csi_ctr_datastructures_pub.ctr_read_prop_interface_tbl, a0 JTF_NUMBER_TABLE

5168: end if;
5169: end if;
5170: end rosetta_table_copy_out_p34;
5171:
5172: procedure rosetta_table_copy_in_p36(t out nocopy csi_ctr_datastructures_pub.ctr_read_prop_interface_tbl, a0 JTF_NUMBER_TABLE
5173: , a1 JTF_NUMBER_TABLE
5174: , a2 JTF_VARCHAR2_TABLE_300
5175: , a3 JTF_NUMBER_TABLE
5176: , a4 JTF_NUMBER_TABLE

Line 5249: procedure rosetta_table_copy_out_p36(t csi_ctr_datastructures_pub.ctr_read_prop_interface_tbl, a0 out nocopy JTF_NUMBER_TABLE

5245: end loop;
5246: end if;
5247: end if;
5248: end rosetta_table_copy_in_p36;
5249: procedure rosetta_table_copy_out_p36(t csi_ctr_datastructures_pub.ctr_read_prop_interface_tbl, a0 out nocopy JTF_NUMBER_TABLE
5250: , a1 out nocopy JTF_NUMBER_TABLE
5251: , a2 out nocopy JTF_VARCHAR2_TABLE_300
5252: , a3 out nocopy JTF_NUMBER_TABLE
5253: , a4 out nocopy JTF_NUMBER_TABLE

Line 5418: end csi_ctr_datastructures_pub_w;

5414: end if;
5415: end if;
5416: end rosetta_table_copy_out_p36;
5417:
5418: end csi_ctr_datastructures_pub_w;