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_ASSET_PVT_W dependencies on CSI_ASSET_PVT

Line 1: package body csi_asset_pvt_w as

1: package body csi_asset_pvt_w as
2: /* $Header: csivaswb.pls 120.10 2008/01/15 03:36:11 devijay 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_p1(t out nocopy csi_asset_pvt.lookup_tbl, a0 JTF_VARCHAR2_TABLE_100

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_asset_pvt.lookup_tbl, a0 JTF_VARCHAR2_TABLE_100
26: , a1 JTF_VARCHAR2_TABLE_100
27: ) as
28: ddindx binary_integer; indx binary_integer;
29: begin

Line 46: procedure rosetta_table_copy_out_p1(t csi_asset_pvt.lookup_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100

42: end loop;
43: end if;
44: end if;
45: end rosetta_table_copy_in_p1;
46: procedure rosetta_table_copy_out_p1(t csi_asset_pvt.lookup_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
47: , a1 out nocopy JTF_VARCHAR2_TABLE_100
48: ) as
49: ddindx binary_integer; indx binary_integer;
50: begin

Line 75: procedure rosetta_table_copy_in_p4(t out nocopy csi_asset_pvt.asset_id_tbl, a0 JTF_NUMBER_TABLE

71: end if;
72: end if;
73: end rosetta_table_copy_out_p1;
74:
75: procedure rosetta_table_copy_in_p4(t out nocopy csi_asset_pvt.asset_id_tbl, a0 JTF_NUMBER_TABLE
76: , a1 JTF_VARCHAR2_TABLE_100
77: , a2 JTF_VARCHAR2_TABLE_100
78: ) as
79: ddindx binary_integer; indx binary_integer;

Line 98: procedure rosetta_table_copy_out_p4(t csi_asset_pvt.asset_id_tbl, a0 out nocopy JTF_NUMBER_TABLE

94: end loop;
95: end if;
96: end if;
97: end rosetta_table_copy_in_p4;
98: procedure rosetta_table_copy_out_p4(t csi_asset_pvt.asset_id_tbl, a0 out nocopy JTF_NUMBER_TABLE
99: , a1 out nocopy JTF_VARCHAR2_TABLE_100
100: , a2 out nocopy JTF_VARCHAR2_TABLE_100
101: ) as
102: ddindx binary_integer; indx binary_integer;

Line 132: procedure rosetta_table_copy_in_p6(t out nocopy csi_asset_pvt.asset_loc_tbl, a0 JTF_NUMBER_TABLE

128: end if;
129: end if;
130: end rosetta_table_copy_out_p4;
131:
132: procedure rosetta_table_copy_in_p6(t out nocopy csi_asset_pvt.asset_loc_tbl, a0 JTF_NUMBER_TABLE
133: , a1 JTF_VARCHAR2_TABLE_100
134: ) as
135: ddindx binary_integer; indx binary_integer;
136: begin

Line 153: procedure rosetta_table_copy_out_p6(t csi_asset_pvt.asset_loc_tbl, a0 out nocopy JTF_NUMBER_TABLE

149: end loop;
150: end if;
151: end if;
152: end rosetta_table_copy_in_p6;
153: procedure rosetta_table_copy_out_p6(t csi_asset_pvt.asset_loc_tbl, a0 out nocopy JTF_NUMBER_TABLE
154: , a1 out nocopy JTF_VARCHAR2_TABLE_100
155: ) as
156: ddindx binary_integer; indx binary_integer;
157: begin

Line 182: procedure rosetta_table_copy_in_p8(t out nocopy csi_asset_pvt.instance_asset_sync_tbl, a0 JTF_NUMBER_TABLE

178: end if;
179: end if;
180: end rosetta_table_copy_out_p6;
181:
182: procedure rosetta_table_copy_in_p8(t out nocopy csi_asset_pvt.instance_asset_sync_tbl, a0 JTF_NUMBER_TABLE
183: , a1 JTF_NUMBER_TABLE
184: , a2 JTF_NUMBER_TABLE
185: , a3 JTF_NUMBER_TABLE
186: , a4 JTF_NUMBER_TABLE

Line 209: procedure rosetta_table_copy_out_p8(t csi_asset_pvt.instance_asset_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE

205: end loop;
206: end if;
207: end if;
208: end rosetta_table_copy_in_p8;
209: procedure rosetta_table_copy_out_p8(t csi_asset_pvt.instance_asset_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
210: , a1 out nocopy JTF_NUMBER_TABLE
211: , a2 out nocopy JTF_NUMBER_TABLE
212: , a3 out nocopy JTF_NUMBER_TABLE
213: , a4 out nocopy JTF_NUMBER_TABLE

Line 253: procedure rosetta_table_copy_in_p10(t out nocopy csi_asset_pvt.fa_asset_sync_tbl, a0 JTF_NUMBER_TABLE

249: end if;
250: end if;
251: end rosetta_table_copy_out_p8;
252:
253: procedure rosetta_table_copy_in_p10(t out nocopy csi_asset_pvt.fa_asset_sync_tbl, a0 JTF_NUMBER_TABLE
254: , a1 JTF_NUMBER_TABLE
255: , a2 JTF_NUMBER_TABLE
256: , a3 JTF_NUMBER_TABLE
257: ) as

Line 278: procedure rosetta_table_copy_out_p10(t csi_asset_pvt.fa_asset_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE

274: end loop;
275: end if;
276: end if;
277: end rosetta_table_copy_in_p10;
278: procedure rosetta_table_copy_out_p10(t csi_asset_pvt.fa_asset_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
279: , a1 out nocopy JTF_NUMBER_TABLE
280: , a2 out nocopy JTF_NUMBER_TABLE
281: , a3 out nocopy JTF_NUMBER_TABLE
282: ) as

Line 317: procedure rosetta_table_copy_in_p12(t out nocopy csi_asset_pvt.instance_sync_tbl, a0 JTF_NUMBER_TABLE

313: end if;
314: end if;
315: end rosetta_table_copy_out_p10;
316:
317: procedure rosetta_table_copy_in_p12(t out nocopy csi_asset_pvt.instance_sync_tbl, a0 JTF_NUMBER_TABLE
318: , a1 JTF_NUMBER_TABLE
319: , a2 JTF_NUMBER_TABLE
320: , a3 JTF_NUMBER_TABLE
321: , a4 JTF_VARCHAR2_TABLE_100

Line 350: procedure rosetta_table_copy_out_p12(t csi_asset_pvt.instance_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE

346: end loop;
347: end if;
348: end if;
349: end rosetta_table_copy_in_p12;
350: procedure rosetta_table_copy_out_p12(t csi_asset_pvt.instance_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
351: , a1 out nocopy JTF_NUMBER_TABLE
352: , a2 out nocopy JTF_NUMBER_TABLE
353: , a3 out nocopy JTF_NUMBER_TABLE
354: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 479: csi_asset_pvt.initialize_asset_rec(ddx_instance_asset_rec,

475:
476: ddx_nearest_full_dump := rosetta_g_miss_date_in_map(x_nearest_full_dump);
477:
478: -- here's the delegated call to the old PL/SQL routine
479: csi_asset_pvt.initialize_asset_rec(ddx_instance_asset_rec,
480: p_inst_asset_hist_id,
481: ddx_nearest_full_dump);
482:
483: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 585: csi_asset_pvt.construct_asset_from_hist(ddx_instance_asset_tbl,

581:
582: ddp_time_stamp := rosetta_g_miss_date_in_map(p_time_stamp);
583:
584: -- here's the delegated call to the old PL/SQL routine
585: csi_asset_pvt.construct_asset_from_hist(ddx_instance_asset_tbl,
586: ddp_time_stamp);
587:
588: -- copy data back from the local variables to OUT or IN-OUT args, if any
589: csi_datastructures_pub_w.rosetta_table_copy_out_p59(ddx_instance_asset_tbl, p0_a0

Line 659: csi_asset_pvt.get_asset_column_values(p_get_asset_cursor_id,

655: -- copy data to the local IN or IN-OUT args, if any
656:
657:
658: -- here's the delegated call to the old PL/SQL routine
659: csi_asset_pvt.get_asset_column_values(p_get_asset_cursor_id,
660: ddx_inst_asset_rec);
661:
662: -- copy data back from the local variables to OUT or IN-OUT args, if any
663:

Line 719: csi_asset_pvt.bind_asset_variable(ddp_inst_asset_query_rec,

715: ddp_inst_asset_query_rec.fa_mass_addition_id := rosetta_g_miss_num_map(p0_a6);
716:
717:
718: -- here's the delegated call to the old PL/SQL routine
719: csi_asset_pvt.bind_asset_variable(ddp_inst_asset_query_rec,
720: p_get_asset_cursor_id);
721:
722: -- copy data back from the local variables to OUT or IN-OUT args, if any
723:

Line 791: csi_asset_pvt.resolve_id_columns(ddp_asset_header_tbl);

787: , p0_a26
788: );
789:
790: -- here's the delegated call to the old PL/SQL routine
791: csi_asset_pvt.resolve_id_columns(ddp_asset_header_tbl);
792:
793: -- copy data back from the local variables to OUT or IN-OUT args, if any
794: csi_datastructures_pub_w.rosetta_table_copy_out_p59(ddp_asset_header_tbl, p0_a0
795: , p0_a1

Line 850: csi_asset_pvt.gen_asset_where_clause(ddp_inst_asset_query_rec,

846: ddp_inst_asset_query_rec.fa_mass_addition_id := rosetta_g_miss_num_map(p0_a6);
847:
848:
849: -- here's the delegated call to the old PL/SQL routine
850: csi_asset_pvt.gen_asset_where_clause(ddp_inst_asset_query_rec,
851: x_where_clause);
852:
853: -- copy data back from the local variables to OUT or IN-OUT args, if any
854:

Line 930: csi_asset_pvt.get_instance_assets(p_api_version,

926:
927:
928:
929: -- here's the delegated call to the old PL/SQL routine
930: csi_asset_pvt.get_instance_assets(p_api_version,
931: p_commit,
932: p_init_msg_list,
933: p_validation_level,
934: ddp_instance_asset_query_rec,

Line 1062: ddp_lookup_tbl csi_asset_pvt.lookup_tbl;

1058:
1059: as
1060: ddp_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
1061: ddp_txn_rec csi_datastructures_pub.transaction_rec;
1062: ddp_lookup_tbl csi_asset_pvt.lookup_tbl;
1063: ddp_asset_count_rec csi_asset_pvt.asset_count_rec;
1064: ddp_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1065: ddp_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1066: ddindx binary_integer; indx binary_integer;

Line 1063: ddp_asset_count_rec csi_asset_pvt.asset_count_rec;

1059: as
1060: ddp_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
1061: ddp_txn_rec csi_datastructures_pub.transaction_rec;
1062: ddp_lookup_tbl csi_asset_pvt.lookup_tbl;
1063: ddp_asset_count_rec csi_asset_pvt.asset_count_rec;
1064: ddp_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1065: ddp_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1066: ddindx binary_integer; indx binary_integer;
1067: begin

Line 1064: ddp_asset_id_tbl csi_asset_pvt.asset_id_tbl;

1060: ddp_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
1061: ddp_txn_rec csi_datastructures_pub.transaction_rec;
1062: ddp_lookup_tbl csi_asset_pvt.lookup_tbl;
1063: ddp_asset_count_rec csi_asset_pvt.asset_count_rec;
1064: ddp_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1065: ddp_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1066: ddindx binary_integer; indx binary_integer;
1067: begin
1068:

Line 1065: ddp_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

1061: ddp_txn_rec csi_datastructures_pub.transaction_rec;
1062: ddp_lookup_tbl csi_asset_pvt.lookup_tbl;
1063: ddp_asset_count_rec csi_asset_pvt.asset_count_rec;
1064: ddp_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1065: ddp_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1066: ddindx binary_integer; indx binary_integer;
1067: begin
1068:
1069: -- copy data to the local IN or IN-OUT args, if any

Line 1135: csi_asset_pvt_w.rosetta_table_copy_in_p1(ddp_lookup_tbl, p9_a0

1131:
1132:
1133:
1134:
1135: csi_asset_pvt_w.rosetta_table_copy_in_p1(ddp_lookup_tbl, p9_a0
1136: , p9_a1
1137: );
1138:
1139: ddp_asset_count_rec.asset_count := rosetta_g_miss_num_map(p10_a0);

Line 1143: csi_asset_pvt_w.rosetta_table_copy_in_p4(ddp_asset_id_tbl, p11_a0

1139: ddp_asset_count_rec.asset_count := rosetta_g_miss_num_map(p10_a0);
1140: ddp_asset_count_rec.lookup_count := rosetta_g_miss_num_map(p10_a1);
1141: ddp_asset_count_rec.loc_count := rosetta_g_miss_num_map(p10_a2);
1142:
1143: csi_asset_pvt_w.rosetta_table_copy_in_p4(ddp_asset_id_tbl, p11_a0
1144: , p11_a1
1145: , p11_a2
1146: );
1147:

Line 1148: csi_asset_pvt_w.rosetta_table_copy_in_p6(ddp_asset_loc_tbl, p12_a0

1144: , p11_a1
1145: , p11_a2
1146: );
1147:
1148: csi_asset_pvt_w.rosetta_table_copy_in_p6(ddp_asset_loc_tbl, p12_a0
1149: , p12_a1
1150: );
1151:
1152:

Line 1154: csi_asset_pvt.create_instance_asset(p_api_version,

1150: );
1151:
1152:
1153: -- here's the delegated call to the old PL/SQL routine
1154: csi_asset_pvt.create_instance_asset(p_api_version,
1155: p_commit,
1156: p_init_msg_list,
1157: p_validation_level,
1158: ddp_instance_asset_rec,

Line 1235: csi_asset_pvt_w.rosetta_table_copy_out_p1(ddp_lookup_tbl, p9_a0

1231:
1232:
1233:
1234:
1235: csi_asset_pvt_w.rosetta_table_copy_out_p1(ddp_lookup_tbl, p9_a0
1236: , p9_a1
1237: );
1238:
1239: p10_a0 := rosetta_g_miss_num_map(ddp_asset_count_rec.asset_count);

Line 1243: csi_asset_pvt_w.rosetta_table_copy_out_p4(ddp_asset_id_tbl, p11_a0

1239: p10_a0 := rosetta_g_miss_num_map(ddp_asset_count_rec.asset_count);
1240: p10_a1 := rosetta_g_miss_num_map(ddp_asset_count_rec.lookup_count);
1241: p10_a2 := rosetta_g_miss_num_map(ddp_asset_count_rec.loc_count);
1242:
1243: csi_asset_pvt_w.rosetta_table_copy_out_p4(ddp_asset_id_tbl, p11_a0
1244: , p11_a1
1245: , p11_a2
1246: );
1247:

Line 1248: csi_asset_pvt_w.rosetta_table_copy_out_p6(ddp_asset_loc_tbl, p12_a0

1244: , p11_a1
1245: , p11_a2
1246: );
1247:
1248: csi_asset_pvt_w.rosetta_table_copy_out_p6(ddp_asset_loc_tbl, p12_a0
1249: , p12_a1
1250: );
1251:
1252: end;

Line 1332: ddp_lookup_tbl csi_asset_pvt.lookup_tbl;

1328:
1329: as
1330: ddp_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
1331: ddp_txn_rec csi_datastructures_pub.transaction_rec;
1332: ddp_lookup_tbl csi_asset_pvt.lookup_tbl;
1333: ddp_asset_count_rec csi_asset_pvt.asset_count_rec;
1334: ddp_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1335: ddp_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1336: ddindx binary_integer; indx binary_integer;

Line 1333: ddp_asset_count_rec csi_asset_pvt.asset_count_rec;

1329: as
1330: ddp_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
1331: ddp_txn_rec csi_datastructures_pub.transaction_rec;
1332: ddp_lookup_tbl csi_asset_pvt.lookup_tbl;
1333: ddp_asset_count_rec csi_asset_pvt.asset_count_rec;
1334: ddp_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1335: ddp_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1336: ddindx binary_integer; indx binary_integer;
1337: begin

Line 1334: ddp_asset_id_tbl csi_asset_pvt.asset_id_tbl;

1330: ddp_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
1331: ddp_txn_rec csi_datastructures_pub.transaction_rec;
1332: ddp_lookup_tbl csi_asset_pvt.lookup_tbl;
1333: ddp_asset_count_rec csi_asset_pvt.asset_count_rec;
1334: ddp_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1335: ddp_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1336: ddindx binary_integer; indx binary_integer;
1337: begin
1338:

Line 1335: ddp_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

1331: ddp_txn_rec csi_datastructures_pub.transaction_rec;
1332: ddp_lookup_tbl csi_asset_pvt.lookup_tbl;
1333: ddp_asset_count_rec csi_asset_pvt.asset_count_rec;
1334: ddp_asset_id_tbl csi_asset_pvt.asset_id_tbl;
1335: ddp_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1336: ddindx binary_integer; indx binary_integer;
1337: begin
1338:
1339: -- copy data to the local IN or IN-OUT args, if any

Line 1405: csi_asset_pvt_w.rosetta_table_copy_in_p1(ddp_lookup_tbl, p9_a0

1401:
1402:
1403:
1404:
1405: csi_asset_pvt_w.rosetta_table_copy_in_p1(ddp_lookup_tbl, p9_a0
1406: , p9_a1
1407: );
1408:
1409: ddp_asset_count_rec.asset_count := rosetta_g_miss_num_map(p10_a0);

Line 1413: csi_asset_pvt_w.rosetta_table_copy_in_p4(ddp_asset_id_tbl, p11_a0

1409: ddp_asset_count_rec.asset_count := rosetta_g_miss_num_map(p10_a0);
1410: ddp_asset_count_rec.lookup_count := rosetta_g_miss_num_map(p10_a1);
1411: ddp_asset_count_rec.loc_count := rosetta_g_miss_num_map(p10_a2);
1412:
1413: csi_asset_pvt_w.rosetta_table_copy_in_p4(ddp_asset_id_tbl, p11_a0
1414: , p11_a1
1415: , p11_a2
1416: );
1417:

Line 1418: csi_asset_pvt_w.rosetta_table_copy_in_p6(ddp_asset_loc_tbl, p12_a0

1414: , p11_a1
1415: , p11_a2
1416: );
1417:
1418: csi_asset_pvt_w.rosetta_table_copy_in_p6(ddp_asset_loc_tbl, p12_a0
1419: , p12_a1
1420: );
1421:
1422: -- here's the delegated call to the old PL/SQL routine

Line 1423: csi_asset_pvt.update_instance_asset(p_api_version,

1419: , p12_a1
1420: );
1421:
1422: -- here's the delegated call to the old PL/SQL routine
1423: csi_asset_pvt.update_instance_asset(p_api_version,
1424: p_commit,
1425: p_init_msg_list,
1426: p_validation_level,
1427: ddp_instance_asset_rec,

Line 1503: csi_asset_pvt_w.rosetta_table_copy_out_p1(ddp_lookup_tbl, p9_a0

1499:
1500:
1501:
1502:
1503: csi_asset_pvt_w.rosetta_table_copy_out_p1(ddp_lookup_tbl, p9_a0
1504: , p9_a1
1505: );
1506:
1507: p10_a0 := rosetta_g_miss_num_map(ddp_asset_count_rec.asset_count);

Line 1511: csi_asset_pvt_w.rosetta_table_copy_out_p4(ddp_asset_id_tbl, p11_a0

1507: p10_a0 := rosetta_g_miss_num_map(ddp_asset_count_rec.asset_count);
1508: p10_a1 := rosetta_g_miss_num_map(ddp_asset_count_rec.lookup_count);
1509: p10_a2 := rosetta_g_miss_num_map(ddp_asset_count_rec.loc_count);
1510:
1511: csi_asset_pvt_w.rosetta_table_copy_out_p4(ddp_asset_id_tbl, p11_a0
1512: , p11_a1
1513: , p11_a2
1514: );
1515:

Line 1516: csi_asset_pvt_w.rosetta_table_copy_out_p6(ddp_asset_loc_tbl, p12_a0

1512: , p11_a1
1513: , p11_a2
1514: );
1515:
1516: csi_asset_pvt_w.rosetta_table_copy_out_p6(ddp_asset_loc_tbl, p12_a0
1517: , p12_a1
1518: );
1519: end;
1520:

Line 1603: csi_asset_pvt.get_instance_asset_hist(p_api_version,

1599:
1600:
1601:
1602: -- here's the delegated call to the old PL/SQL routine
1603: csi_asset_pvt.get_instance_asset_hist(p_api_version,
1604: p_commit,
1605: p_init_msg_list,
1606: p_validation_level,
1607: p_transaction_id,

Line 1703: ddpx_instance_sync_tbl csi_asset_pvt.instance_sync_tbl;

1699: , x_return_status out nocopy VARCHAR2
1700: )
1701:
1702: as
1703: ddpx_instance_sync_tbl csi_asset_pvt.instance_sync_tbl;
1704: ddpx_instance_asset_sync_tbl csi_asset_pvt.instance_asset_sync_tbl;
1705: ddpx_fa_asset_sync_tbl csi_asset_pvt.fa_asset_sync_tbl;
1706: ddindx binary_integer; indx binary_integer;
1707: begin

Line 1704: ddpx_instance_asset_sync_tbl csi_asset_pvt.instance_asset_sync_tbl;

1700: )
1701:
1702: as
1703: ddpx_instance_sync_tbl csi_asset_pvt.instance_sync_tbl;
1704: ddpx_instance_asset_sync_tbl csi_asset_pvt.instance_asset_sync_tbl;
1705: ddpx_fa_asset_sync_tbl csi_asset_pvt.fa_asset_sync_tbl;
1706: ddindx binary_integer; indx binary_integer;
1707: begin
1708:

Line 1705: ddpx_fa_asset_sync_tbl csi_asset_pvt.fa_asset_sync_tbl;

1701:
1702: as
1703: ddpx_instance_sync_tbl csi_asset_pvt.instance_sync_tbl;
1704: ddpx_instance_asset_sync_tbl csi_asset_pvt.instance_asset_sync_tbl;
1705: ddpx_fa_asset_sync_tbl csi_asset_pvt.fa_asset_sync_tbl;
1706: ddindx binary_integer; indx binary_integer;
1707: begin
1708:
1709: -- copy data to the local IN or IN-OUT args, if any

Line 1710: csi_asset_pvt_w.rosetta_table_copy_in_p12(ddpx_instance_sync_tbl, p0_a0

1706: ddindx binary_integer; indx binary_integer;
1707: begin
1708:
1709: -- copy data to the local IN or IN-OUT args, if any
1710: csi_asset_pvt_w.rosetta_table_copy_in_p12(ddpx_instance_sync_tbl, p0_a0
1711: , p0_a1
1712: , p0_a2
1713: , p0_a3
1714: , p0_a4

Line 1720: csi_asset_pvt_w.rosetta_table_copy_in_p8(ddpx_instance_asset_sync_tbl, p1_a0

1716: , p0_a6
1717: , p0_a7
1718: );
1719:
1720: csi_asset_pvt_w.rosetta_table_copy_in_p8(ddpx_instance_asset_sync_tbl, p1_a0
1721: , p1_a1
1722: , p1_a2
1723: , p1_a3
1724: , p1_a4

Line 1727: csi_asset_pvt_w.rosetta_table_copy_in_p10(ddpx_fa_asset_sync_tbl, p2_a0

1723: , p1_a3
1724: , p1_a4
1725: );
1726:
1727: csi_asset_pvt_w.rosetta_table_copy_in_p10(ddpx_fa_asset_sync_tbl, p2_a0
1728: , p2_a1
1729: , p2_a2
1730: , p2_a3
1731: );

Line 1736: csi_asset_pvt.asset_syncup_validation(ddpx_instance_sync_tbl,

1732:
1733:
1734:
1735: -- here's the delegated call to the old PL/SQL routine
1736: csi_asset_pvt.asset_syncup_validation(ddpx_instance_sync_tbl,
1737: ddpx_instance_asset_sync_tbl,
1738: ddpx_fa_asset_sync_tbl,
1739: x_error_msg,
1740: x_return_status);

Line 1743: csi_asset_pvt_w.rosetta_table_copy_out_p12(ddpx_instance_sync_tbl, p0_a0

1739: x_error_msg,
1740: x_return_status);
1741:
1742: -- copy data back from the local variables to OUT or IN-OUT args, if any
1743: csi_asset_pvt_w.rosetta_table_copy_out_p12(ddpx_instance_sync_tbl, p0_a0
1744: , p0_a1
1745: , p0_a2
1746: , p0_a3
1747: , p0_a4

Line 1753: csi_asset_pvt_w.rosetta_table_copy_out_p8(ddpx_instance_asset_sync_tbl, p1_a0

1749: , p0_a6
1750: , p0_a7
1751: );
1752:
1753: csi_asset_pvt_w.rosetta_table_copy_out_p8(ddpx_instance_asset_sync_tbl, p1_a0
1754: , p1_a1
1755: , p1_a2
1756: , p1_a3
1757: , p1_a4

Line 1760: csi_asset_pvt_w.rosetta_table_copy_out_p10(ddpx_fa_asset_sync_tbl, p2_a0

1756: , p1_a3
1757: , p1_a4
1758: );
1759:
1760: csi_asset_pvt_w.rosetta_table_copy_out_p10(ddpx_fa_asset_sync_tbl, p2_a0
1761: , p2_a1
1762: , p2_a2
1763: , p2_a3
1764: );

Line 1792: ddp_instance_asset_sync_tbl csi_asset_pvt.instance_asset_sync_tbl;

1788: , p_called_from_grp VARCHAR2
1789: )
1790:
1791: as
1792: ddp_instance_asset_sync_tbl csi_asset_pvt.instance_asset_sync_tbl;
1793: ddx_instance_sync_tbl csi_asset_pvt.instance_sync_tbl;
1794: ddindx binary_integer; indx binary_integer;
1795: begin
1796:

Line 1793: ddx_instance_sync_tbl csi_asset_pvt.instance_sync_tbl;

1789: )
1790:
1791: as
1792: ddp_instance_asset_sync_tbl csi_asset_pvt.instance_asset_sync_tbl;
1793: ddx_instance_sync_tbl csi_asset_pvt.instance_sync_tbl;
1794: ddindx binary_integer; indx binary_integer;
1795: begin
1796:
1797: -- copy data to the local IN or IN-OUT args, if any

Line 1800: csi_asset_pvt_w.rosetta_table_copy_in_p8(ddp_instance_asset_sync_tbl, p2_a0

1796:
1797: -- copy data to the local IN or IN-OUT args, if any
1798:
1799:
1800: csi_asset_pvt_w.rosetta_table_copy_in_p8(ddp_instance_asset_sync_tbl, p2_a0
1801: , p2_a1
1802: , p2_a2
1803: , p2_a3
1804: , p2_a4

Line 1814: csi_asset_pvt.get_attached_item_instances(p_api_version,

1810:
1811:
1812:
1813: -- here's the delegated call to the old PL/SQL routine
1814: csi_asset_pvt.get_attached_item_instances(p_api_version,
1815: p_init_msg_list,
1816: ddp_instance_asset_sync_tbl,
1817: ddx_instance_sync_tbl,
1818: x_return_status,

Line 1828: csi_asset_pvt_w.rosetta_table_copy_out_p12(ddx_instance_sync_tbl, p3_a0

1824: -- copy data back from the local variables to OUT or IN-OUT args, if any
1825:
1826:
1827:
1828: csi_asset_pvt_w.rosetta_table_copy_out_p12(ddx_instance_sync_tbl, p3_a0
1829: , p3_a1
1830: , p3_a2
1831: , p3_a3
1832: , p3_a4

Line 1867: ddp_instance_sync_tbl csi_asset_pvt.instance_sync_tbl;

1863: , p_called_from_grp VARCHAR2
1864: )
1865:
1866: as
1867: ddp_instance_sync_tbl csi_asset_pvt.instance_sync_tbl;
1868: ddx_instance_asset_sync_tbl csi_asset_pvt.instance_asset_sync_tbl;
1869: ddindx binary_integer; indx binary_integer;
1870: begin
1871:

Line 1868: ddx_instance_asset_sync_tbl csi_asset_pvt.instance_asset_sync_tbl;

1864: )
1865:
1866: as
1867: ddp_instance_sync_tbl csi_asset_pvt.instance_sync_tbl;
1868: ddx_instance_asset_sync_tbl csi_asset_pvt.instance_asset_sync_tbl;
1869: ddindx binary_integer; indx binary_integer;
1870: begin
1871:
1872: -- copy data to the local IN or IN-OUT args, if any

Line 1875: csi_asset_pvt_w.rosetta_table_copy_in_p12(ddp_instance_sync_tbl, p2_a0

1871:
1872: -- copy data to the local IN or IN-OUT args, if any
1873:
1874:
1875: csi_asset_pvt_w.rosetta_table_copy_in_p12(ddp_instance_sync_tbl, p2_a0
1876: , p2_a1
1877: , p2_a2
1878: , p2_a3
1879: , p2_a4

Line 1892: csi_asset_pvt.get_attached_asset_links(p_api_version,

1888:
1889:
1890:
1891: -- here's the delegated call to the old PL/SQL routine
1892: csi_asset_pvt.get_attached_asset_links(p_api_version,
1893: p_init_msg_list,
1894: ddp_instance_sync_tbl,
1895: ddx_instance_asset_sync_tbl,
1896: x_return_status,

Line 1906: csi_asset_pvt_w.rosetta_table_copy_out_p8(ddx_instance_asset_sync_tbl, p3_a0

1902: -- copy data back from the local variables to OUT or IN-OUT args, if any
1903:
1904:
1905:
1906: csi_asset_pvt_w.rosetta_table_copy_out_p8(ddx_instance_asset_sync_tbl, p3_a0
1907: , p3_a1
1908: , p3_a2
1909: , p3_a3
1910: , p3_a4

Line 1938: ddp_instance_asset_sync_tbl csi_asset_pvt.instance_asset_sync_tbl;

1934: , p_called_from_grp VARCHAR2
1935: )
1936:
1937: as
1938: ddp_instance_asset_sync_tbl csi_asset_pvt.instance_asset_sync_tbl;
1939: ddx_fa_asset_sync_tab csi_asset_pvt.fa_asset_sync_tbl;
1940: ddindx binary_integer; indx binary_integer;
1941: begin
1942:

Line 1939: ddx_fa_asset_sync_tab csi_asset_pvt.fa_asset_sync_tbl;

1935: )
1936:
1937: as
1938: ddp_instance_asset_sync_tbl csi_asset_pvt.instance_asset_sync_tbl;
1939: ddx_fa_asset_sync_tab csi_asset_pvt.fa_asset_sync_tbl;
1940: ddindx binary_integer; indx binary_integer;
1941: begin
1942:
1943: -- copy data to the local IN or IN-OUT args, if any

Line 1946: csi_asset_pvt_w.rosetta_table_copy_in_p8(ddp_instance_asset_sync_tbl, p2_a0

1942:
1943: -- copy data to the local IN or IN-OUT args, if any
1944:
1945:
1946: csi_asset_pvt_w.rosetta_table_copy_in_p8(ddp_instance_asset_sync_tbl, p2_a0
1947: , p2_a1
1948: , p2_a2
1949: , p2_a3
1950: , p2_a4

Line 1960: csi_asset_pvt.get_fa_asset_details(p_api_version,

1956:
1957:
1958:
1959: -- here's the delegated call to the old PL/SQL routine
1960: csi_asset_pvt.get_fa_asset_details(p_api_version,
1961: p_init_msg_list,
1962: ddp_instance_asset_sync_tbl,
1963: ddx_fa_asset_sync_tab,
1964: x_return_status,

Line 1974: csi_asset_pvt_w.rosetta_table_copy_out_p10(ddx_fa_asset_sync_tab, p3_a0

1970: -- copy data back from the local variables to OUT or IN-OUT args, if any
1971:
1972:
1973:
1974: csi_asset_pvt_w.rosetta_table_copy_out_p10(ddx_fa_asset_sync_tab, p3_a0
1975: , p3_a1
1976: , p3_a2
1977: , p3_a3
1978: );

Line 2010: ddpx_instance_sync_tbl csi_asset_pvt.instance_sync_tbl;

2006: , p_called_from_grp VARCHAR2
2007: )
2008:
2009: as
2010: ddpx_instance_sync_tbl csi_asset_pvt.instance_sync_tbl;
2011: ddpx_instance_asset_sync_tbl csi_asset_pvt.instance_asset_sync_tbl;
2012: ddx_fa_asset_sync_tbl csi_asset_pvt.fa_asset_sync_tbl;
2013: ddindx binary_integer; indx binary_integer;
2014: begin

Line 2011: ddpx_instance_asset_sync_tbl csi_asset_pvt.instance_asset_sync_tbl;

2007: )
2008:
2009: as
2010: ddpx_instance_sync_tbl csi_asset_pvt.instance_sync_tbl;
2011: ddpx_instance_asset_sync_tbl csi_asset_pvt.instance_asset_sync_tbl;
2012: ddx_fa_asset_sync_tbl csi_asset_pvt.fa_asset_sync_tbl;
2013: ddindx binary_integer; indx binary_integer;
2014: begin
2015:

Line 2012: ddx_fa_asset_sync_tbl csi_asset_pvt.fa_asset_sync_tbl;

2008:
2009: as
2010: ddpx_instance_sync_tbl csi_asset_pvt.instance_sync_tbl;
2011: ddpx_instance_asset_sync_tbl csi_asset_pvt.instance_asset_sync_tbl;
2012: ddx_fa_asset_sync_tbl csi_asset_pvt.fa_asset_sync_tbl;
2013: ddindx binary_integer; indx binary_integer;
2014: begin
2015:
2016: -- copy data to the local IN or IN-OUT args, if any

Line 2017: csi_asset_pvt_w.rosetta_table_copy_in_p12(ddpx_instance_sync_tbl, p0_a0

2013: ddindx binary_integer; indx binary_integer;
2014: begin
2015:
2016: -- copy data to the local IN or IN-OUT args, if any
2017: csi_asset_pvt_w.rosetta_table_copy_in_p12(ddpx_instance_sync_tbl, p0_a0
2018: , p0_a1
2019: , p0_a2
2020: , p0_a3
2021: , p0_a4

Line 2027: csi_asset_pvt_w.rosetta_table_copy_in_p8(ddpx_instance_asset_sync_tbl, p1_a0

2023: , p0_a6
2024: , p0_a7
2025: );
2026:
2027: csi_asset_pvt_w.rosetta_table_copy_in_p8(ddpx_instance_asset_sync_tbl, p1_a0
2028: , p1_a1
2029: , p1_a2
2030: , p1_a3
2031: , p1_a4

Line 2034: csi_asset_pvt_w.rosetta_table_copy_in_p10(ddx_fa_asset_sync_tbl, p2_a0

2030: , p1_a3
2031: , p1_a4
2032: );
2033:
2034: csi_asset_pvt_w.rosetta_table_copy_in_p10(ddx_fa_asset_sync_tbl, p2_a0
2035: , p2_a1
2036: , p2_a2
2037: , p2_a3
2038: );

Line 2045: csi_asset_pvt.get_syncup_tree(ddpx_instance_sync_tbl,

2041:
2042:
2043:
2044: -- here's the delegated call to the old PL/SQL routine
2045: csi_asset_pvt.get_syncup_tree(ddpx_instance_sync_tbl,
2046: ddpx_instance_asset_sync_tbl,
2047: ddx_fa_asset_sync_tbl,
2048: x_return_status,
2049: x_error_msg,

Line 2054: csi_asset_pvt_w.rosetta_table_copy_out_p12(ddpx_instance_sync_tbl, p0_a0

2050: p_source_system_name,
2051: p_called_from_grp);
2052:
2053: -- copy data back from the local variables to OUT or IN-OUT args, if any
2054: csi_asset_pvt_w.rosetta_table_copy_out_p12(ddpx_instance_sync_tbl, p0_a0
2055: , p0_a1
2056: , p0_a2
2057: , p0_a3
2058: , p0_a4

Line 2064: csi_asset_pvt_w.rosetta_table_copy_out_p8(ddpx_instance_asset_sync_tbl, p1_a0

2060: , p0_a6
2061: , p0_a7
2062: );
2063:
2064: csi_asset_pvt_w.rosetta_table_copy_out_p8(ddpx_instance_asset_sync_tbl, p1_a0
2065: , p1_a1
2066: , p1_a2
2067: , p1_a3
2068: , p1_a4

Line 2071: csi_asset_pvt_w.rosetta_table_copy_out_p10(ddx_fa_asset_sync_tbl, p2_a0

2067: , p1_a3
2068: , p1_a4
2069: );
2070:
2071: csi_asset_pvt_w.rosetta_table_copy_out_p10(ddx_fa_asset_sync_tbl, p2_a0
2072: , p2_a1
2073: , p2_a2
2074: , p2_a3
2075: );

Line 2160: ddp_lookup_tbl csi_asset_pvt.lookup_tbl;

2156:
2157: as
2158: ddp_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2159: ddp_txn_rec csi_datastructures_pub.transaction_rec;
2160: ddp_lookup_tbl csi_asset_pvt.lookup_tbl;
2161: ddp_asset_count_rec csi_asset_pvt.asset_count_rec;
2162: ddp_asset_id_tbl csi_asset_pvt.asset_id_tbl;
2163: ddp_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
2164: ddindx binary_integer; indx binary_integer;

Line 2161: ddp_asset_count_rec csi_asset_pvt.asset_count_rec;

2157: as
2158: ddp_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2159: ddp_txn_rec csi_datastructures_pub.transaction_rec;
2160: ddp_lookup_tbl csi_asset_pvt.lookup_tbl;
2161: ddp_asset_count_rec csi_asset_pvt.asset_count_rec;
2162: ddp_asset_id_tbl csi_asset_pvt.asset_id_tbl;
2163: ddp_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
2164: ddindx binary_integer; indx binary_integer;
2165: begin

Line 2162: ddp_asset_id_tbl csi_asset_pvt.asset_id_tbl;

2158: ddp_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2159: ddp_txn_rec csi_datastructures_pub.transaction_rec;
2160: ddp_lookup_tbl csi_asset_pvt.lookup_tbl;
2161: ddp_asset_count_rec csi_asset_pvt.asset_count_rec;
2162: ddp_asset_id_tbl csi_asset_pvt.asset_id_tbl;
2163: ddp_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
2164: ddindx binary_integer; indx binary_integer;
2165: begin
2166:

Line 2163: ddp_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

2159: ddp_txn_rec csi_datastructures_pub.transaction_rec;
2160: ddp_lookup_tbl csi_asset_pvt.lookup_tbl;
2161: ddp_asset_count_rec csi_asset_pvt.asset_count_rec;
2162: ddp_asset_id_tbl csi_asset_pvt.asset_id_tbl;
2163: ddp_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
2164: ddindx binary_integer; indx binary_integer;
2165: begin
2166:
2167: -- copy data to the local IN or IN-OUT args, if any

Line 2231: csi_asset_pvt_w.rosetta_table_copy_in_p1(ddp_lookup_tbl, p6_a0

2227: ddp_txn_rec.split_reason_code := p5_a37;
2228: ddp_txn_rec.src_txn_creation_date := rosetta_g_miss_date_in_map(p5_a38);
2229: ddp_txn_rec.gl_interface_status_code := rosetta_g_miss_num_map(p5_a39);
2230:
2231: csi_asset_pvt_w.rosetta_table_copy_in_p1(ddp_lookup_tbl, p6_a0
2232: , p6_a1
2233: );
2234:
2235: ddp_asset_count_rec.asset_count := rosetta_g_miss_num_map(p7_a0);

Line 2239: csi_asset_pvt_w.rosetta_table_copy_in_p4(ddp_asset_id_tbl, p8_a0

2235: ddp_asset_count_rec.asset_count := rosetta_g_miss_num_map(p7_a0);
2236: ddp_asset_count_rec.lookup_count := rosetta_g_miss_num_map(p7_a1);
2237: ddp_asset_count_rec.loc_count := rosetta_g_miss_num_map(p7_a2);
2238:
2239: csi_asset_pvt_w.rosetta_table_copy_in_p4(ddp_asset_id_tbl, p8_a0
2240: , p8_a1
2241: , p8_a2
2242: );
2243:

Line 2244: csi_asset_pvt_w.rosetta_table_copy_in_p6(ddp_asset_loc_tbl, p9_a0

2240: , p8_a1
2241: , p8_a2
2242: );
2243:
2244: csi_asset_pvt_w.rosetta_table_copy_in_p6(ddp_asset_loc_tbl, p9_a0
2245: , p9_a1
2246: );
2247:
2248:

Line 2252: csi_asset_pvt.create_instance_assets(p_api_version,

2248:
2249:
2250:
2251: -- here's the delegated call to the old PL/SQL routine
2252: csi_asset_pvt.create_instance_assets(p_api_version,
2253: p_commit,
2254: p_init_msg_list,
2255: p_validation_level,
2256: ddp_instance_asset_tbl,

Line 2330: csi_asset_pvt_w.rosetta_table_copy_out_p1(ddp_lookup_tbl, p6_a0

2326: p5_a37 := ddp_txn_rec.split_reason_code;
2327: p5_a38 := ddp_txn_rec.src_txn_creation_date;
2328: p5_a39 := rosetta_g_miss_num_map(ddp_txn_rec.gl_interface_status_code);
2329:
2330: csi_asset_pvt_w.rosetta_table_copy_out_p1(ddp_lookup_tbl, p6_a0
2331: , p6_a1
2332: );
2333:
2334: p7_a0 := rosetta_g_miss_num_map(ddp_asset_count_rec.asset_count);

Line 2338: csi_asset_pvt_w.rosetta_table_copy_out_p4(ddp_asset_id_tbl, p8_a0

2334: p7_a0 := rosetta_g_miss_num_map(ddp_asset_count_rec.asset_count);
2335: p7_a1 := rosetta_g_miss_num_map(ddp_asset_count_rec.lookup_count);
2336: p7_a2 := rosetta_g_miss_num_map(ddp_asset_count_rec.loc_count);
2337:
2338: csi_asset_pvt_w.rosetta_table_copy_out_p4(ddp_asset_id_tbl, p8_a0
2339: , p8_a1
2340: , p8_a2
2341: );
2342:

Line 2343: csi_asset_pvt_w.rosetta_table_copy_out_p6(ddp_asset_loc_tbl, p9_a0

2339: , p8_a1
2340: , p8_a2
2341: );
2342:
2343: csi_asset_pvt_w.rosetta_table_copy_out_p6(ddp_asset_loc_tbl, p9_a0
2344: , p9_a1
2345: );
2346:
2347:

Line 2399: csi_asset_pvt.set_fa_sync_flag(ddpx_instance_asset_rec,

2395:
2396:
2397:
2398: -- here's the delegated call to the old PL/SQL routine
2399: csi_asset_pvt.set_fa_sync_flag(ddpx_instance_asset_rec,
2400: p_location_id,
2401: x_return_status,
2402: x_error_msg);
2403:

Line 2426: end csi_asset_pvt_w;

2422:
2423:
2424: end;
2425:
2426: end csi_asset_pvt_w;