APPS.CSI_ASSET_PVT_W dependencies on JTF_NUMBER_TABLE

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

6: procedure rosetta_table_copy_out_p1(t csi_asset_pvt.lookup_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
7: , a1 out nocopy JTF_VARCHAR2_TABLE_100
8: );
9:
10: procedure rosetta_table_copy_in_p4(t out nocopy csi_asset_pvt.asset_id_tbl, a0 JTF_NUMBER_TABLE
11: , a1 JTF_VARCHAR2_TABLE_100
12: , a2 JTF_VARCHAR2_TABLE_100
13: );
14: procedure rosetta_table_copy_out_p4(t csi_asset_pvt.asset_id_tbl, a0 out nocopy JTF_NUMBER_TABLE

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

10: procedure rosetta_table_copy_in_p4(t out nocopy csi_asset_pvt.asset_id_tbl, a0 JTF_NUMBER_TABLE
11: , a1 JTF_VARCHAR2_TABLE_100
12: , a2 JTF_VARCHAR2_TABLE_100
13: );
14: procedure rosetta_table_copy_out_p4(t csi_asset_pvt.asset_id_tbl, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_VARCHAR2_TABLE_100
16: , a2 out nocopy JTF_VARCHAR2_TABLE_100
17: );
18:

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

15: , a1 out nocopy JTF_VARCHAR2_TABLE_100
16: , a2 out nocopy JTF_VARCHAR2_TABLE_100
17: );
18:
19: procedure rosetta_table_copy_in_p6(t out nocopy csi_asset_pvt.asset_loc_tbl, a0 JTF_NUMBER_TABLE
20: , a1 JTF_VARCHAR2_TABLE_100
21: );
22: procedure rosetta_table_copy_out_p6(t csi_asset_pvt.asset_loc_tbl, a0 out nocopy JTF_NUMBER_TABLE
23: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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

18:
19: procedure rosetta_table_copy_in_p6(t out nocopy csi_asset_pvt.asset_loc_tbl, a0 JTF_NUMBER_TABLE
20: , a1 JTF_VARCHAR2_TABLE_100
21: );
22: procedure rosetta_table_copy_out_p6(t csi_asset_pvt.asset_loc_tbl, a0 out nocopy JTF_NUMBER_TABLE
23: , a1 out nocopy JTF_VARCHAR2_TABLE_100
24: );
25:
26: procedure rosetta_table_copy_in_p8(t out nocopy csi_asset_pvt.instance_asset_sync_tbl, a0 JTF_NUMBER_TABLE

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

22: procedure rosetta_table_copy_out_p6(t csi_asset_pvt.asset_loc_tbl, a0 out nocopy JTF_NUMBER_TABLE
23: , a1 out nocopy JTF_VARCHAR2_TABLE_100
24: );
25:
26: procedure rosetta_table_copy_in_p8(t out nocopy csi_asset_pvt.instance_asset_sync_tbl, a0 JTF_NUMBER_TABLE
27: , a1 JTF_NUMBER_TABLE
28: , a2 JTF_NUMBER_TABLE
29: , a3 JTF_NUMBER_TABLE
30: , a4 JTF_NUMBER_TABLE

Line 27: , a1 JTF_NUMBER_TABLE

23: , a1 out nocopy JTF_VARCHAR2_TABLE_100
24: );
25:
26: procedure rosetta_table_copy_in_p8(t out nocopy csi_asset_pvt.instance_asset_sync_tbl, a0 JTF_NUMBER_TABLE
27: , a1 JTF_NUMBER_TABLE
28: , a2 JTF_NUMBER_TABLE
29: , a3 JTF_NUMBER_TABLE
30: , a4 JTF_NUMBER_TABLE
31: );

Line 28: , a2 JTF_NUMBER_TABLE

24: );
25:
26: procedure rosetta_table_copy_in_p8(t out nocopy csi_asset_pvt.instance_asset_sync_tbl, a0 JTF_NUMBER_TABLE
27: , a1 JTF_NUMBER_TABLE
28: , a2 JTF_NUMBER_TABLE
29: , a3 JTF_NUMBER_TABLE
30: , a4 JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p8(t csi_asset_pvt.instance_asset_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 29: , a3 JTF_NUMBER_TABLE

25:
26: procedure rosetta_table_copy_in_p8(t out nocopy csi_asset_pvt.instance_asset_sync_tbl, a0 JTF_NUMBER_TABLE
27: , a1 JTF_NUMBER_TABLE
28: , a2 JTF_NUMBER_TABLE
29: , a3 JTF_NUMBER_TABLE
30: , a4 JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p8(t csi_asset_pvt.instance_asset_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_NUMBER_TABLE

Line 30: , a4 JTF_NUMBER_TABLE

26: procedure rosetta_table_copy_in_p8(t out nocopy csi_asset_pvt.instance_asset_sync_tbl, a0 JTF_NUMBER_TABLE
27: , a1 JTF_NUMBER_TABLE
28: , a2 JTF_NUMBER_TABLE
29: , a3 JTF_NUMBER_TABLE
30: , a4 JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p8(t csi_asset_pvt.instance_asset_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_NUMBER_TABLE
34: , a2 out nocopy JTF_NUMBER_TABLE

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

28: , a2 JTF_NUMBER_TABLE
29: , a3 JTF_NUMBER_TABLE
30: , a4 JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p8(t csi_asset_pvt.instance_asset_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_NUMBER_TABLE
34: , a2 out nocopy JTF_NUMBER_TABLE
35: , a3 out nocopy JTF_NUMBER_TABLE
36: , a4 out nocopy JTF_NUMBER_TABLE

Line 33: , a1 out nocopy JTF_NUMBER_TABLE

29: , a3 JTF_NUMBER_TABLE
30: , a4 JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p8(t csi_asset_pvt.instance_asset_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_NUMBER_TABLE
34: , a2 out nocopy JTF_NUMBER_TABLE
35: , a3 out nocopy JTF_NUMBER_TABLE
36: , a4 out nocopy JTF_NUMBER_TABLE
37: );

Line 34: , a2 out nocopy JTF_NUMBER_TABLE

30: , a4 JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p8(t csi_asset_pvt.instance_asset_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_NUMBER_TABLE
34: , a2 out nocopy JTF_NUMBER_TABLE
35: , a3 out nocopy JTF_NUMBER_TABLE
36: , a4 out nocopy JTF_NUMBER_TABLE
37: );
38:

Line 35: , a3 out nocopy JTF_NUMBER_TABLE

31: );
32: procedure rosetta_table_copy_out_p8(t csi_asset_pvt.instance_asset_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_NUMBER_TABLE
34: , a2 out nocopy JTF_NUMBER_TABLE
35: , a3 out nocopy JTF_NUMBER_TABLE
36: , a4 out nocopy JTF_NUMBER_TABLE
37: );
38:
39: procedure rosetta_table_copy_in_p10(t out nocopy csi_asset_pvt.fa_asset_sync_tbl, a0 JTF_NUMBER_TABLE

Line 36: , a4 out nocopy JTF_NUMBER_TABLE

32: procedure rosetta_table_copy_out_p8(t csi_asset_pvt.instance_asset_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_NUMBER_TABLE
34: , a2 out nocopy JTF_NUMBER_TABLE
35: , a3 out nocopy JTF_NUMBER_TABLE
36: , a4 out nocopy JTF_NUMBER_TABLE
37: );
38:
39: procedure rosetta_table_copy_in_p10(t out nocopy csi_asset_pvt.fa_asset_sync_tbl, a0 JTF_NUMBER_TABLE
40: , a1 JTF_NUMBER_TABLE

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

35: , a3 out nocopy JTF_NUMBER_TABLE
36: , a4 out nocopy JTF_NUMBER_TABLE
37: );
38:
39: procedure rosetta_table_copy_in_p10(t out nocopy csi_asset_pvt.fa_asset_sync_tbl, a0 JTF_NUMBER_TABLE
40: , a1 JTF_NUMBER_TABLE
41: , a2 JTF_NUMBER_TABLE
42: , a3 JTF_NUMBER_TABLE
43: );

Line 40: , a1 JTF_NUMBER_TABLE

36: , a4 out nocopy JTF_NUMBER_TABLE
37: );
38:
39: procedure rosetta_table_copy_in_p10(t out nocopy csi_asset_pvt.fa_asset_sync_tbl, a0 JTF_NUMBER_TABLE
40: , a1 JTF_NUMBER_TABLE
41: , a2 JTF_NUMBER_TABLE
42: , a3 JTF_NUMBER_TABLE
43: );
44: procedure rosetta_table_copy_out_p10(t csi_asset_pvt.fa_asset_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 41: , a2 JTF_NUMBER_TABLE

37: );
38:
39: procedure rosetta_table_copy_in_p10(t out nocopy csi_asset_pvt.fa_asset_sync_tbl, a0 JTF_NUMBER_TABLE
40: , a1 JTF_NUMBER_TABLE
41: , a2 JTF_NUMBER_TABLE
42: , a3 JTF_NUMBER_TABLE
43: );
44: procedure rosetta_table_copy_out_p10(t csi_asset_pvt.fa_asset_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE

Line 42: , a3 JTF_NUMBER_TABLE

38:
39: procedure rosetta_table_copy_in_p10(t out nocopy csi_asset_pvt.fa_asset_sync_tbl, a0 JTF_NUMBER_TABLE
40: , a1 JTF_NUMBER_TABLE
41: , a2 JTF_NUMBER_TABLE
42: , a3 JTF_NUMBER_TABLE
43: );
44: procedure rosetta_table_copy_out_p10(t csi_asset_pvt.fa_asset_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_NUMBER_TABLE

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

40: , a1 JTF_NUMBER_TABLE
41: , a2 JTF_NUMBER_TABLE
42: , a3 JTF_NUMBER_TABLE
43: );
44: procedure rosetta_table_copy_out_p10(t csi_asset_pvt.fa_asset_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_NUMBER_TABLE
47: , a3 out nocopy JTF_NUMBER_TABLE
48: );

Line 45: , a1 out nocopy JTF_NUMBER_TABLE

41: , a2 JTF_NUMBER_TABLE
42: , a3 JTF_NUMBER_TABLE
43: );
44: procedure rosetta_table_copy_out_p10(t csi_asset_pvt.fa_asset_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_NUMBER_TABLE
47: , a3 out nocopy JTF_NUMBER_TABLE
48: );
49:

Line 46: , a2 out nocopy JTF_NUMBER_TABLE

42: , a3 JTF_NUMBER_TABLE
43: );
44: procedure rosetta_table_copy_out_p10(t csi_asset_pvt.fa_asset_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_NUMBER_TABLE
47: , a3 out nocopy JTF_NUMBER_TABLE
48: );
49:
50: procedure rosetta_table_copy_in_p12(t out nocopy csi_asset_pvt.instance_sync_tbl, a0 JTF_NUMBER_TABLE

Line 47: , a3 out nocopy JTF_NUMBER_TABLE

43: );
44: procedure rosetta_table_copy_out_p10(t csi_asset_pvt.fa_asset_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_NUMBER_TABLE
47: , a3 out nocopy JTF_NUMBER_TABLE
48: );
49:
50: procedure rosetta_table_copy_in_p12(t out nocopy csi_asset_pvt.instance_sync_tbl, a0 JTF_NUMBER_TABLE
51: , a1 JTF_NUMBER_TABLE

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

46: , a2 out nocopy JTF_NUMBER_TABLE
47: , a3 out nocopy JTF_NUMBER_TABLE
48: );
49:
50: procedure rosetta_table_copy_in_p12(t out nocopy csi_asset_pvt.instance_sync_tbl, a0 JTF_NUMBER_TABLE
51: , a1 JTF_NUMBER_TABLE
52: , a2 JTF_NUMBER_TABLE
53: , a3 JTF_NUMBER_TABLE
54: , a4 JTF_VARCHAR2_TABLE_100

Line 51: , a1 JTF_NUMBER_TABLE

47: , a3 out nocopy JTF_NUMBER_TABLE
48: );
49:
50: procedure rosetta_table_copy_in_p12(t out nocopy csi_asset_pvt.instance_sync_tbl, a0 JTF_NUMBER_TABLE
51: , a1 JTF_NUMBER_TABLE
52: , a2 JTF_NUMBER_TABLE
53: , a3 JTF_NUMBER_TABLE
54: , a4 JTF_VARCHAR2_TABLE_100
55: , a5 JTF_NUMBER_TABLE

Line 52: , a2 JTF_NUMBER_TABLE

48: );
49:
50: procedure rosetta_table_copy_in_p12(t out nocopy csi_asset_pvt.instance_sync_tbl, a0 JTF_NUMBER_TABLE
51: , a1 JTF_NUMBER_TABLE
52: , a2 JTF_NUMBER_TABLE
53: , a3 JTF_NUMBER_TABLE
54: , a4 JTF_VARCHAR2_TABLE_100
55: , a5 JTF_NUMBER_TABLE
56: , a6 JTF_NUMBER_TABLE

Line 53: , a3 JTF_NUMBER_TABLE

49:
50: procedure rosetta_table_copy_in_p12(t out nocopy csi_asset_pvt.instance_sync_tbl, a0 JTF_NUMBER_TABLE
51: , a1 JTF_NUMBER_TABLE
52: , a2 JTF_NUMBER_TABLE
53: , a3 JTF_NUMBER_TABLE
54: , a4 JTF_VARCHAR2_TABLE_100
55: , a5 JTF_NUMBER_TABLE
56: , a6 JTF_NUMBER_TABLE
57: , a7 JTF_VARCHAR2_TABLE_100

Line 55: , a5 JTF_NUMBER_TABLE

51: , a1 JTF_NUMBER_TABLE
52: , a2 JTF_NUMBER_TABLE
53: , a3 JTF_NUMBER_TABLE
54: , a4 JTF_VARCHAR2_TABLE_100
55: , a5 JTF_NUMBER_TABLE
56: , a6 JTF_NUMBER_TABLE
57: , a7 JTF_VARCHAR2_TABLE_100
58: );
59: procedure rosetta_table_copy_out_p12(t csi_asset_pvt.instance_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 56: , a6 JTF_NUMBER_TABLE

52: , a2 JTF_NUMBER_TABLE
53: , a3 JTF_NUMBER_TABLE
54: , a4 JTF_VARCHAR2_TABLE_100
55: , a5 JTF_NUMBER_TABLE
56: , a6 JTF_NUMBER_TABLE
57: , a7 JTF_VARCHAR2_TABLE_100
58: );
59: procedure rosetta_table_copy_out_p12(t csi_asset_pvt.instance_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
60: , a1 out nocopy JTF_NUMBER_TABLE

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

55: , a5 JTF_NUMBER_TABLE
56: , a6 JTF_NUMBER_TABLE
57: , a7 JTF_VARCHAR2_TABLE_100
58: );
59: procedure rosetta_table_copy_out_p12(t csi_asset_pvt.instance_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
60: , a1 out nocopy JTF_NUMBER_TABLE
61: , a2 out nocopy JTF_NUMBER_TABLE
62: , a3 out nocopy JTF_NUMBER_TABLE
63: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 60: , a1 out nocopy JTF_NUMBER_TABLE

56: , a6 JTF_NUMBER_TABLE
57: , a7 JTF_VARCHAR2_TABLE_100
58: );
59: procedure rosetta_table_copy_out_p12(t csi_asset_pvt.instance_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
60: , a1 out nocopy JTF_NUMBER_TABLE
61: , a2 out nocopy JTF_NUMBER_TABLE
62: , a3 out nocopy JTF_NUMBER_TABLE
63: , a4 out nocopy JTF_VARCHAR2_TABLE_100
64: , a5 out nocopy JTF_NUMBER_TABLE

Line 61: , a2 out nocopy JTF_NUMBER_TABLE

57: , a7 JTF_VARCHAR2_TABLE_100
58: );
59: procedure rosetta_table_copy_out_p12(t csi_asset_pvt.instance_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
60: , a1 out nocopy JTF_NUMBER_TABLE
61: , a2 out nocopy JTF_NUMBER_TABLE
62: , a3 out nocopy JTF_NUMBER_TABLE
63: , a4 out nocopy JTF_VARCHAR2_TABLE_100
64: , a5 out nocopy JTF_NUMBER_TABLE
65: , a6 out nocopy JTF_NUMBER_TABLE

Line 62: , a3 out nocopy JTF_NUMBER_TABLE

58: );
59: procedure rosetta_table_copy_out_p12(t csi_asset_pvt.instance_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
60: , a1 out nocopy JTF_NUMBER_TABLE
61: , a2 out nocopy JTF_NUMBER_TABLE
62: , a3 out nocopy JTF_NUMBER_TABLE
63: , a4 out nocopy JTF_VARCHAR2_TABLE_100
64: , a5 out nocopy JTF_NUMBER_TABLE
65: , a6 out nocopy JTF_NUMBER_TABLE
66: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 64: , a5 out nocopy JTF_NUMBER_TABLE

60: , a1 out nocopy JTF_NUMBER_TABLE
61: , a2 out nocopy JTF_NUMBER_TABLE
62: , a3 out nocopy JTF_NUMBER_TABLE
63: , a4 out nocopy JTF_VARCHAR2_TABLE_100
64: , a5 out nocopy JTF_NUMBER_TABLE
65: , a6 out nocopy JTF_NUMBER_TABLE
66: , a7 out nocopy JTF_VARCHAR2_TABLE_100
67: );
68:

Line 65: , a6 out nocopy JTF_NUMBER_TABLE

61: , a2 out nocopy JTF_NUMBER_TABLE
62: , a3 out nocopy JTF_NUMBER_TABLE
63: , a4 out nocopy JTF_VARCHAR2_TABLE_100
64: , a5 out nocopy JTF_NUMBER_TABLE
65: , a6 out nocopy JTF_NUMBER_TABLE
66: , a7 out nocopy JTF_VARCHAR2_TABLE_100
67: );
68:
69: procedure initialize_asset_rec(p0_a0 in out nocopy NUMBER

Line 99: procedure construct_asset_from_hist(p0_a0 in out nocopy JTF_NUMBER_TABLE

95: , p0_a26 in out nocopy VARCHAR2
96: , p_inst_asset_hist_id NUMBER
97: , x_nearest_full_dump in out nocopy date
98: );
99: procedure construct_asset_from_hist(p0_a0 in out nocopy JTF_NUMBER_TABLE
100: , p0_a1 in out nocopy JTF_NUMBER_TABLE
101: , p0_a2 in out nocopy JTF_NUMBER_TABLE
102: , p0_a3 in out nocopy JTF_VARCHAR2_TABLE_100
103: , p0_a4 in out nocopy JTF_NUMBER_TABLE

Line 100: , p0_a1 in out nocopy JTF_NUMBER_TABLE

96: , p_inst_asset_hist_id NUMBER
97: , x_nearest_full_dump in out nocopy date
98: );
99: procedure construct_asset_from_hist(p0_a0 in out nocopy JTF_NUMBER_TABLE
100: , p0_a1 in out nocopy JTF_NUMBER_TABLE
101: , p0_a2 in out nocopy JTF_NUMBER_TABLE
102: , p0_a3 in out nocopy JTF_VARCHAR2_TABLE_100
103: , p0_a4 in out nocopy JTF_NUMBER_TABLE
104: , p0_a5 in out nocopy JTF_NUMBER_TABLE

Line 101: , p0_a2 in out nocopy JTF_NUMBER_TABLE

97: , x_nearest_full_dump in out nocopy date
98: );
99: procedure construct_asset_from_hist(p0_a0 in out nocopy JTF_NUMBER_TABLE
100: , p0_a1 in out nocopy JTF_NUMBER_TABLE
101: , p0_a2 in out nocopy JTF_NUMBER_TABLE
102: , p0_a3 in out nocopy JTF_VARCHAR2_TABLE_100
103: , p0_a4 in out nocopy JTF_NUMBER_TABLE
104: , p0_a5 in out nocopy JTF_NUMBER_TABLE
105: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 103: , p0_a4 in out nocopy JTF_NUMBER_TABLE

99: procedure construct_asset_from_hist(p0_a0 in out nocopy JTF_NUMBER_TABLE
100: , p0_a1 in out nocopy JTF_NUMBER_TABLE
101: , p0_a2 in out nocopy JTF_NUMBER_TABLE
102: , p0_a3 in out nocopy JTF_VARCHAR2_TABLE_100
103: , p0_a4 in out nocopy JTF_NUMBER_TABLE
104: , p0_a5 in out nocopy JTF_NUMBER_TABLE
105: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
106: , p0_a7 in out nocopy JTF_DATE_TABLE
107: , p0_a8 in out nocopy JTF_DATE_TABLE

Line 104: , p0_a5 in out nocopy JTF_NUMBER_TABLE

100: , p0_a1 in out nocopy JTF_NUMBER_TABLE
101: , p0_a2 in out nocopy JTF_NUMBER_TABLE
102: , p0_a3 in out nocopy JTF_VARCHAR2_TABLE_100
103: , p0_a4 in out nocopy JTF_NUMBER_TABLE
104: , p0_a5 in out nocopy JTF_NUMBER_TABLE
105: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
106: , p0_a7 in out nocopy JTF_DATE_TABLE
107: , p0_a8 in out nocopy JTF_DATE_TABLE
108: , p0_a9 in out nocopy JTF_NUMBER_TABLE

Line 108: , p0_a9 in out nocopy JTF_NUMBER_TABLE

104: , p0_a5 in out nocopy JTF_NUMBER_TABLE
105: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
106: , p0_a7 in out nocopy JTF_DATE_TABLE
107: , p0_a8 in out nocopy JTF_DATE_TABLE
108: , p0_a9 in out nocopy JTF_NUMBER_TABLE
109: , p0_a10 in out nocopy JTF_VARCHAR2_TABLE_100
110: , p0_a11 in out nocopy JTF_VARCHAR2_TABLE_100
111: , p0_a12 in out nocopy JTF_VARCHAR2_TABLE_100
112: , p0_a13 in out nocopy JTF_VARCHAR2_TABLE_100

Line 124: , p0_a25 in out nocopy JTF_NUMBER_TABLE

120: , p0_a21 in out nocopy JTF_DATE_TABLE
121: , p0_a22 in out nocopy JTF_VARCHAR2_TABLE_100
122: , p0_a23 in out nocopy JTF_VARCHAR2_TABLE_300
123: , p0_a24 in out nocopy JTF_VARCHAR2_TABLE_100
124: , p0_a25 in out nocopy JTF_NUMBER_TABLE
125: , p0_a26 in out nocopy JTF_VARCHAR2_TABLE_100
126: , p_time_stamp date
127: );
128: procedure get_asset_column_values(p_get_asset_cursor_id NUMBER

Line 166: procedure resolve_id_columns(p0_a0 in out nocopy JTF_NUMBER_TABLE

162: , p0_a4 NUMBER := 0-1962.0724
163: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
164: , p0_a6 NUMBER := 0-1962.0724
165: );
166: procedure resolve_id_columns(p0_a0 in out nocopy JTF_NUMBER_TABLE
167: , p0_a1 in out nocopy JTF_NUMBER_TABLE
168: , p0_a2 in out nocopy JTF_NUMBER_TABLE
169: , p0_a3 in out nocopy JTF_VARCHAR2_TABLE_100
170: , p0_a4 in out nocopy JTF_NUMBER_TABLE

Line 167: , p0_a1 in out nocopy JTF_NUMBER_TABLE

163: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
164: , p0_a6 NUMBER := 0-1962.0724
165: );
166: procedure resolve_id_columns(p0_a0 in out nocopy JTF_NUMBER_TABLE
167: , p0_a1 in out nocopy JTF_NUMBER_TABLE
168: , p0_a2 in out nocopy JTF_NUMBER_TABLE
169: , p0_a3 in out nocopy JTF_VARCHAR2_TABLE_100
170: , p0_a4 in out nocopy JTF_NUMBER_TABLE
171: , p0_a5 in out nocopy JTF_NUMBER_TABLE

Line 168: , p0_a2 in out nocopy JTF_NUMBER_TABLE

164: , p0_a6 NUMBER := 0-1962.0724
165: );
166: procedure resolve_id_columns(p0_a0 in out nocopy JTF_NUMBER_TABLE
167: , p0_a1 in out nocopy JTF_NUMBER_TABLE
168: , p0_a2 in out nocopy JTF_NUMBER_TABLE
169: , p0_a3 in out nocopy JTF_VARCHAR2_TABLE_100
170: , p0_a4 in out nocopy JTF_NUMBER_TABLE
171: , p0_a5 in out nocopy JTF_NUMBER_TABLE
172: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 170: , p0_a4 in out nocopy JTF_NUMBER_TABLE

166: procedure resolve_id_columns(p0_a0 in out nocopy JTF_NUMBER_TABLE
167: , p0_a1 in out nocopy JTF_NUMBER_TABLE
168: , p0_a2 in out nocopy JTF_NUMBER_TABLE
169: , p0_a3 in out nocopy JTF_VARCHAR2_TABLE_100
170: , p0_a4 in out nocopy JTF_NUMBER_TABLE
171: , p0_a5 in out nocopy JTF_NUMBER_TABLE
172: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
173: , p0_a7 in out nocopy JTF_DATE_TABLE
174: , p0_a8 in out nocopy JTF_DATE_TABLE

Line 171: , p0_a5 in out nocopy JTF_NUMBER_TABLE

167: , p0_a1 in out nocopy JTF_NUMBER_TABLE
168: , p0_a2 in out nocopy JTF_NUMBER_TABLE
169: , p0_a3 in out nocopy JTF_VARCHAR2_TABLE_100
170: , p0_a4 in out nocopy JTF_NUMBER_TABLE
171: , p0_a5 in out nocopy JTF_NUMBER_TABLE
172: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
173: , p0_a7 in out nocopy JTF_DATE_TABLE
174: , p0_a8 in out nocopy JTF_DATE_TABLE
175: , p0_a9 in out nocopy JTF_NUMBER_TABLE

Line 175: , p0_a9 in out nocopy JTF_NUMBER_TABLE

171: , p0_a5 in out nocopy JTF_NUMBER_TABLE
172: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
173: , p0_a7 in out nocopy JTF_DATE_TABLE
174: , p0_a8 in out nocopy JTF_DATE_TABLE
175: , p0_a9 in out nocopy JTF_NUMBER_TABLE
176: , p0_a10 in out nocopy JTF_VARCHAR2_TABLE_100
177: , p0_a11 in out nocopy JTF_VARCHAR2_TABLE_100
178: , p0_a12 in out nocopy JTF_VARCHAR2_TABLE_100
179: , p0_a13 in out nocopy JTF_VARCHAR2_TABLE_100

Line 191: , p0_a25 in out nocopy JTF_NUMBER_TABLE

187: , p0_a21 in out nocopy JTF_DATE_TABLE
188: , p0_a22 in out nocopy JTF_VARCHAR2_TABLE_100
189: , p0_a23 in out nocopy JTF_VARCHAR2_TABLE_300
190: , p0_a24 in out nocopy JTF_VARCHAR2_TABLE_100
191: , p0_a25 in out nocopy JTF_NUMBER_TABLE
192: , p0_a26 in out nocopy JTF_VARCHAR2_TABLE_100
193: );
194: procedure gen_asset_where_clause(x_where_clause out nocopy VARCHAR2
195: , p0_a0 NUMBER := 0-1962.0724

Line 209: , p7_a0 out nocopy JTF_NUMBER_TABLE

205: , p_init_msg_list VARCHAR2
206: , p_validation_level NUMBER
207: , p_resolve_id_columns VARCHAR2
208: , p_time_stamp date
209: , p7_a0 out nocopy JTF_NUMBER_TABLE
210: , p7_a1 out nocopy JTF_NUMBER_TABLE
211: , p7_a2 out nocopy JTF_NUMBER_TABLE
212: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
213: , p7_a4 out nocopy JTF_NUMBER_TABLE

Line 210: , p7_a1 out nocopy JTF_NUMBER_TABLE

206: , p_validation_level NUMBER
207: , p_resolve_id_columns VARCHAR2
208: , p_time_stamp date
209: , p7_a0 out nocopy JTF_NUMBER_TABLE
210: , p7_a1 out nocopy JTF_NUMBER_TABLE
211: , p7_a2 out nocopy JTF_NUMBER_TABLE
212: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
213: , p7_a4 out nocopy JTF_NUMBER_TABLE
214: , p7_a5 out nocopy JTF_NUMBER_TABLE

Line 211: , p7_a2 out nocopy JTF_NUMBER_TABLE

207: , p_resolve_id_columns VARCHAR2
208: , p_time_stamp date
209: , p7_a0 out nocopy JTF_NUMBER_TABLE
210: , p7_a1 out nocopy JTF_NUMBER_TABLE
211: , p7_a2 out nocopy JTF_NUMBER_TABLE
212: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
213: , p7_a4 out nocopy JTF_NUMBER_TABLE
214: , p7_a5 out nocopy JTF_NUMBER_TABLE
215: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 213: , p7_a4 out nocopy JTF_NUMBER_TABLE

209: , p7_a0 out nocopy JTF_NUMBER_TABLE
210: , p7_a1 out nocopy JTF_NUMBER_TABLE
211: , p7_a2 out nocopy JTF_NUMBER_TABLE
212: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
213: , p7_a4 out nocopy JTF_NUMBER_TABLE
214: , p7_a5 out nocopy JTF_NUMBER_TABLE
215: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
216: , p7_a7 out nocopy JTF_DATE_TABLE
217: , p7_a8 out nocopy JTF_DATE_TABLE

Line 214: , p7_a5 out nocopy JTF_NUMBER_TABLE

210: , p7_a1 out nocopy JTF_NUMBER_TABLE
211: , p7_a2 out nocopy JTF_NUMBER_TABLE
212: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
213: , p7_a4 out nocopy JTF_NUMBER_TABLE
214: , p7_a5 out nocopy JTF_NUMBER_TABLE
215: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
216: , p7_a7 out nocopy JTF_DATE_TABLE
217: , p7_a8 out nocopy JTF_DATE_TABLE
218: , p7_a9 out nocopy JTF_NUMBER_TABLE

Line 218: , p7_a9 out nocopy JTF_NUMBER_TABLE

214: , p7_a5 out nocopy JTF_NUMBER_TABLE
215: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
216: , p7_a7 out nocopy JTF_DATE_TABLE
217: , p7_a8 out nocopy JTF_DATE_TABLE
218: , p7_a9 out nocopy JTF_NUMBER_TABLE
219: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
220: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
221: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
222: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 234: , p7_a25 out nocopy JTF_NUMBER_TABLE

230: , p7_a21 out nocopy JTF_DATE_TABLE
231: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
232: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_300
233: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100
234: , p7_a25 out nocopy JTF_NUMBER_TABLE
235: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100
236: , x_return_status out nocopy VARCHAR2
237: , x_msg_count out nocopy NUMBER
238: , x_msg_data out nocopy VARCHAR2

Line 315: , p11_a0 in out nocopy JTF_NUMBER_TABLE

311: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
312: , p10_a0 in out nocopy NUMBER
313: , p10_a1 in out nocopy NUMBER
314: , p10_a2 in out nocopy NUMBER
315: , p11_a0 in out nocopy JTF_NUMBER_TABLE
316: , p11_a1 in out nocopy JTF_VARCHAR2_TABLE_100
317: , p11_a2 in out nocopy JTF_VARCHAR2_TABLE_100
318: , p12_a0 in out nocopy JTF_NUMBER_TABLE
319: , p12_a1 in out nocopy JTF_VARCHAR2_TABLE_100

Line 318: , p12_a0 in out nocopy JTF_NUMBER_TABLE

314: , p10_a2 in out nocopy NUMBER
315: , p11_a0 in out nocopy JTF_NUMBER_TABLE
316: , p11_a1 in out nocopy JTF_VARCHAR2_TABLE_100
317: , p11_a2 in out nocopy JTF_VARCHAR2_TABLE_100
318: , p12_a0 in out nocopy JTF_NUMBER_TABLE
319: , p12_a1 in out nocopy JTF_VARCHAR2_TABLE_100
320: , p_called_from_grp VARCHAR2
321: );
322: procedure update_instance_asset(p_api_version NUMBER

Line 390: , p11_a0 in out nocopy JTF_NUMBER_TABLE

386: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
387: , p10_a0 in out nocopy NUMBER
388: , p10_a1 in out nocopy NUMBER
389: , p10_a2 in out nocopy NUMBER
390: , p11_a0 in out nocopy JTF_NUMBER_TABLE
391: , p11_a1 in out nocopy JTF_VARCHAR2_TABLE_100
392: , p11_a2 in out nocopy JTF_VARCHAR2_TABLE_100
393: , p12_a0 in out nocopy JTF_NUMBER_TABLE
394: , p12_a1 in out nocopy JTF_VARCHAR2_TABLE_100

Line 393: , p12_a0 in out nocopy JTF_NUMBER_TABLE

389: , p10_a2 in out nocopy NUMBER
390: , p11_a0 in out nocopy JTF_NUMBER_TABLE
391: , p11_a1 in out nocopy JTF_VARCHAR2_TABLE_100
392: , p11_a2 in out nocopy JTF_VARCHAR2_TABLE_100
393: , p12_a0 in out nocopy JTF_NUMBER_TABLE
394: , p12_a1 in out nocopy JTF_VARCHAR2_TABLE_100
395: );
396: procedure get_instance_asset_hist(p_api_version NUMBER
397: , p_commit VARCHAR2

Line 401: , p5_a0 out nocopy JTF_NUMBER_TABLE

397: , p_commit VARCHAR2
398: , p_init_msg_list VARCHAR2
399: , p_validation_level NUMBER
400: , p_transaction_id NUMBER
401: , p5_a0 out nocopy JTF_NUMBER_TABLE
402: , p5_a1 out nocopy JTF_NUMBER_TABLE
403: , p5_a2 out nocopy JTF_NUMBER_TABLE
404: , p5_a3 out nocopy JTF_NUMBER_TABLE
405: , p5_a4 out nocopy JTF_NUMBER_TABLE

Line 402: , p5_a1 out nocopy JTF_NUMBER_TABLE

398: , p_init_msg_list VARCHAR2
399: , p_validation_level NUMBER
400: , p_transaction_id NUMBER
401: , p5_a0 out nocopy JTF_NUMBER_TABLE
402: , p5_a1 out nocopy JTF_NUMBER_TABLE
403: , p5_a2 out nocopy JTF_NUMBER_TABLE
404: , p5_a3 out nocopy JTF_NUMBER_TABLE
405: , p5_a4 out nocopy JTF_NUMBER_TABLE
406: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 403: , p5_a2 out nocopy JTF_NUMBER_TABLE

399: , p_validation_level NUMBER
400: , p_transaction_id NUMBER
401: , p5_a0 out nocopy JTF_NUMBER_TABLE
402: , p5_a1 out nocopy JTF_NUMBER_TABLE
403: , p5_a2 out nocopy JTF_NUMBER_TABLE
404: , p5_a3 out nocopy JTF_NUMBER_TABLE
405: , p5_a4 out nocopy JTF_NUMBER_TABLE
406: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
407: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 404: , p5_a3 out nocopy JTF_NUMBER_TABLE

400: , p_transaction_id NUMBER
401: , p5_a0 out nocopy JTF_NUMBER_TABLE
402: , p5_a1 out nocopy JTF_NUMBER_TABLE
403: , p5_a2 out nocopy JTF_NUMBER_TABLE
404: , p5_a3 out nocopy JTF_NUMBER_TABLE
405: , p5_a4 out nocopy JTF_NUMBER_TABLE
406: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
407: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
408: , p5_a7 out nocopy JTF_NUMBER_TABLE

Line 405: , p5_a4 out nocopy JTF_NUMBER_TABLE

401: , p5_a0 out nocopy JTF_NUMBER_TABLE
402: , p5_a1 out nocopy JTF_NUMBER_TABLE
403: , p5_a2 out nocopy JTF_NUMBER_TABLE
404: , p5_a3 out nocopy JTF_NUMBER_TABLE
405: , p5_a4 out nocopy JTF_NUMBER_TABLE
406: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
407: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
408: , p5_a7 out nocopy JTF_NUMBER_TABLE
409: , p5_a8 out nocopy JTF_NUMBER_TABLE

Line 408: , p5_a7 out nocopy JTF_NUMBER_TABLE

404: , p5_a3 out nocopy JTF_NUMBER_TABLE
405: , p5_a4 out nocopy JTF_NUMBER_TABLE
406: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
407: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
408: , p5_a7 out nocopy JTF_NUMBER_TABLE
409: , p5_a8 out nocopy JTF_NUMBER_TABLE
410: , p5_a9 out nocopy JTF_NUMBER_TABLE
411: , p5_a10 out nocopy JTF_NUMBER_TABLE
412: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 409: , p5_a8 out nocopy JTF_NUMBER_TABLE

405: , p5_a4 out nocopy JTF_NUMBER_TABLE
406: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
407: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
408: , p5_a7 out nocopy JTF_NUMBER_TABLE
409: , p5_a8 out nocopy JTF_NUMBER_TABLE
410: , p5_a9 out nocopy JTF_NUMBER_TABLE
411: , p5_a10 out nocopy JTF_NUMBER_TABLE
412: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_100
413: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 410: , p5_a9 out nocopy JTF_NUMBER_TABLE

406: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
407: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
408: , p5_a7 out nocopy JTF_NUMBER_TABLE
409: , p5_a8 out nocopy JTF_NUMBER_TABLE
410: , p5_a9 out nocopy JTF_NUMBER_TABLE
411: , p5_a10 out nocopy JTF_NUMBER_TABLE
412: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_100
413: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
414: , p5_a13 out nocopy JTF_DATE_TABLE

Line 411: , p5_a10 out nocopy JTF_NUMBER_TABLE

407: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
408: , p5_a7 out nocopy JTF_NUMBER_TABLE
409: , p5_a8 out nocopy JTF_NUMBER_TABLE
410: , p5_a9 out nocopy JTF_NUMBER_TABLE
411: , p5_a10 out nocopy JTF_NUMBER_TABLE
412: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_100
413: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
414: , p5_a13 out nocopy JTF_DATE_TABLE
415: , p5_a14 out nocopy JTF_DATE_TABLE

Line 448: , p5_a47 out nocopy JTF_NUMBER_TABLE

444: , p5_a43 out nocopy JTF_VARCHAR2_TABLE_300
445: , p5_a44 out nocopy JTF_VARCHAR2_TABLE_300
446: , p5_a45 out nocopy JTF_VARCHAR2_TABLE_100
447: , p5_a46 out nocopy JTF_VARCHAR2_TABLE_100
448: , p5_a47 out nocopy JTF_NUMBER_TABLE
449: , p5_a48 out nocopy JTF_NUMBER_TABLE
450: , p5_a49 out nocopy JTF_NUMBER_TABLE
451: , p5_a50 out nocopy JTF_VARCHAR2_TABLE_100
452: , p5_a51 out nocopy JTF_VARCHAR2_TABLE_100

Line 449: , p5_a48 out nocopy JTF_NUMBER_TABLE

445: , p5_a44 out nocopy JTF_VARCHAR2_TABLE_300
446: , p5_a45 out nocopy JTF_VARCHAR2_TABLE_100
447: , p5_a46 out nocopy JTF_VARCHAR2_TABLE_100
448: , p5_a47 out nocopy JTF_NUMBER_TABLE
449: , p5_a48 out nocopy JTF_NUMBER_TABLE
450: , p5_a49 out nocopy JTF_NUMBER_TABLE
451: , p5_a50 out nocopy JTF_VARCHAR2_TABLE_100
452: , p5_a51 out nocopy JTF_VARCHAR2_TABLE_100
453: , p5_a52 out nocopy JTF_NUMBER_TABLE

Line 450: , p5_a49 out nocopy JTF_NUMBER_TABLE

446: , p5_a45 out nocopy JTF_VARCHAR2_TABLE_100
447: , p5_a46 out nocopy JTF_VARCHAR2_TABLE_100
448: , p5_a47 out nocopy JTF_NUMBER_TABLE
449: , p5_a48 out nocopy JTF_NUMBER_TABLE
450: , p5_a49 out nocopy JTF_NUMBER_TABLE
451: , p5_a50 out nocopy JTF_VARCHAR2_TABLE_100
452: , p5_a51 out nocopy JTF_VARCHAR2_TABLE_100
453: , p5_a52 out nocopy JTF_NUMBER_TABLE
454: , p5_a53 out nocopy JTF_NUMBER_TABLE

Line 453: , p5_a52 out nocopy JTF_NUMBER_TABLE

449: , p5_a48 out nocopy JTF_NUMBER_TABLE
450: , p5_a49 out nocopy JTF_NUMBER_TABLE
451: , p5_a50 out nocopy JTF_VARCHAR2_TABLE_100
452: , p5_a51 out nocopy JTF_VARCHAR2_TABLE_100
453: , p5_a52 out nocopy JTF_NUMBER_TABLE
454: , p5_a53 out nocopy JTF_NUMBER_TABLE
455: , p5_a54 out nocopy JTF_VARCHAR2_TABLE_100
456: , p5_a55 out nocopy JTF_VARCHAR2_TABLE_100
457: , x_return_status out nocopy VARCHAR2

Line 454: , p5_a53 out nocopy JTF_NUMBER_TABLE

450: , p5_a49 out nocopy JTF_NUMBER_TABLE
451: , p5_a50 out nocopy JTF_VARCHAR2_TABLE_100
452: , p5_a51 out nocopy JTF_VARCHAR2_TABLE_100
453: , p5_a52 out nocopy JTF_NUMBER_TABLE
454: , p5_a53 out nocopy JTF_NUMBER_TABLE
455: , p5_a54 out nocopy JTF_VARCHAR2_TABLE_100
456: , p5_a55 out nocopy JTF_VARCHAR2_TABLE_100
457: , x_return_status out nocopy VARCHAR2
458: , x_msg_count out nocopy NUMBER

Line 461: procedure asset_syncup_validation(p0_a0 in out nocopy JTF_NUMBER_TABLE

457: , x_return_status out nocopy VARCHAR2
458: , x_msg_count out nocopy NUMBER
459: , x_msg_data out nocopy VARCHAR2
460: );
461: procedure asset_syncup_validation(p0_a0 in out nocopy JTF_NUMBER_TABLE
462: , p0_a1 in out nocopy JTF_NUMBER_TABLE
463: , p0_a2 in out nocopy JTF_NUMBER_TABLE
464: , p0_a3 in out nocopy JTF_NUMBER_TABLE
465: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100

Line 462: , p0_a1 in out nocopy JTF_NUMBER_TABLE

458: , x_msg_count out nocopy NUMBER
459: , x_msg_data out nocopy VARCHAR2
460: );
461: procedure asset_syncup_validation(p0_a0 in out nocopy JTF_NUMBER_TABLE
462: , p0_a1 in out nocopy JTF_NUMBER_TABLE
463: , p0_a2 in out nocopy JTF_NUMBER_TABLE
464: , p0_a3 in out nocopy JTF_NUMBER_TABLE
465: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
466: , p0_a5 in out nocopy JTF_NUMBER_TABLE

Line 463: , p0_a2 in out nocopy JTF_NUMBER_TABLE

459: , x_msg_data out nocopy VARCHAR2
460: );
461: procedure asset_syncup_validation(p0_a0 in out nocopy JTF_NUMBER_TABLE
462: , p0_a1 in out nocopy JTF_NUMBER_TABLE
463: , p0_a2 in out nocopy JTF_NUMBER_TABLE
464: , p0_a3 in out nocopy JTF_NUMBER_TABLE
465: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
466: , p0_a5 in out nocopy JTF_NUMBER_TABLE
467: , p0_a6 in out nocopy JTF_NUMBER_TABLE

Line 464: , p0_a3 in out nocopy JTF_NUMBER_TABLE

460: );
461: procedure asset_syncup_validation(p0_a0 in out nocopy JTF_NUMBER_TABLE
462: , p0_a1 in out nocopy JTF_NUMBER_TABLE
463: , p0_a2 in out nocopy JTF_NUMBER_TABLE
464: , p0_a3 in out nocopy JTF_NUMBER_TABLE
465: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
466: , p0_a5 in out nocopy JTF_NUMBER_TABLE
467: , p0_a6 in out nocopy JTF_NUMBER_TABLE
468: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100

Line 466: , p0_a5 in out nocopy JTF_NUMBER_TABLE

462: , p0_a1 in out nocopy JTF_NUMBER_TABLE
463: , p0_a2 in out nocopy JTF_NUMBER_TABLE
464: , p0_a3 in out nocopy JTF_NUMBER_TABLE
465: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
466: , p0_a5 in out nocopy JTF_NUMBER_TABLE
467: , p0_a6 in out nocopy JTF_NUMBER_TABLE
468: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
469: , p1_a0 in out nocopy JTF_NUMBER_TABLE
470: , p1_a1 in out nocopy JTF_NUMBER_TABLE

Line 467: , p0_a6 in out nocopy JTF_NUMBER_TABLE

463: , p0_a2 in out nocopy JTF_NUMBER_TABLE
464: , p0_a3 in out nocopy JTF_NUMBER_TABLE
465: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
466: , p0_a5 in out nocopy JTF_NUMBER_TABLE
467: , p0_a6 in out nocopy JTF_NUMBER_TABLE
468: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
469: , p1_a0 in out nocopy JTF_NUMBER_TABLE
470: , p1_a1 in out nocopy JTF_NUMBER_TABLE
471: , p1_a2 in out nocopy JTF_NUMBER_TABLE

Line 469: , p1_a0 in out nocopy JTF_NUMBER_TABLE

465: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
466: , p0_a5 in out nocopy JTF_NUMBER_TABLE
467: , p0_a6 in out nocopy JTF_NUMBER_TABLE
468: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
469: , p1_a0 in out nocopy JTF_NUMBER_TABLE
470: , p1_a1 in out nocopy JTF_NUMBER_TABLE
471: , p1_a2 in out nocopy JTF_NUMBER_TABLE
472: , p1_a3 in out nocopy JTF_NUMBER_TABLE
473: , p1_a4 in out nocopy JTF_NUMBER_TABLE

Line 470: , p1_a1 in out nocopy JTF_NUMBER_TABLE

466: , p0_a5 in out nocopy JTF_NUMBER_TABLE
467: , p0_a6 in out nocopy JTF_NUMBER_TABLE
468: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
469: , p1_a0 in out nocopy JTF_NUMBER_TABLE
470: , p1_a1 in out nocopy JTF_NUMBER_TABLE
471: , p1_a2 in out nocopy JTF_NUMBER_TABLE
472: , p1_a3 in out nocopy JTF_NUMBER_TABLE
473: , p1_a4 in out nocopy JTF_NUMBER_TABLE
474: , p2_a0 in out nocopy JTF_NUMBER_TABLE

Line 471: , p1_a2 in out nocopy JTF_NUMBER_TABLE

467: , p0_a6 in out nocopy JTF_NUMBER_TABLE
468: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
469: , p1_a0 in out nocopy JTF_NUMBER_TABLE
470: , p1_a1 in out nocopy JTF_NUMBER_TABLE
471: , p1_a2 in out nocopy JTF_NUMBER_TABLE
472: , p1_a3 in out nocopy JTF_NUMBER_TABLE
473: , p1_a4 in out nocopy JTF_NUMBER_TABLE
474: , p2_a0 in out nocopy JTF_NUMBER_TABLE
475: , p2_a1 in out nocopy JTF_NUMBER_TABLE

Line 472: , p1_a3 in out nocopy JTF_NUMBER_TABLE

468: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
469: , p1_a0 in out nocopy JTF_NUMBER_TABLE
470: , p1_a1 in out nocopy JTF_NUMBER_TABLE
471: , p1_a2 in out nocopy JTF_NUMBER_TABLE
472: , p1_a3 in out nocopy JTF_NUMBER_TABLE
473: , p1_a4 in out nocopy JTF_NUMBER_TABLE
474: , p2_a0 in out nocopy JTF_NUMBER_TABLE
475: , p2_a1 in out nocopy JTF_NUMBER_TABLE
476: , p2_a2 in out nocopy JTF_NUMBER_TABLE

Line 473: , p1_a4 in out nocopy JTF_NUMBER_TABLE

469: , p1_a0 in out nocopy JTF_NUMBER_TABLE
470: , p1_a1 in out nocopy JTF_NUMBER_TABLE
471: , p1_a2 in out nocopy JTF_NUMBER_TABLE
472: , p1_a3 in out nocopy JTF_NUMBER_TABLE
473: , p1_a4 in out nocopy JTF_NUMBER_TABLE
474: , p2_a0 in out nocopy JTF_NUMBER_TABLE
475: , p2_a1 in out nocopy JTF_NUMBER_TABLE
476: , p2_a2 in out nocopy JTF_NUMBER_TABLE
477: , p2_a3 in out nocopy JTF_NUMBER_TABLE

Line 474: , p2_a0 in out nocopy JTF_NUMBER_TABLE

470: , p1_a1 in out nocopy JTF_NUMBER_TABLE
471: , p1_a2 in out nocopy JTF_NUMBER_TABLE
472: , p1_a3 in out nocopy JTF_NUMBER_TABLE
473: , p1_a4 in out nocopy JTF_NUMBER_TABLE
474: , p2_a0 in out nocopy JTF_NUMBER_TABLE
475: , p2_a1 in out nocopy JTF_NUMBER_TABLE
476: , p2_a2 in out nocopy JTF_NUMBER_TABLE
477: , p2_a3 in out nocopy JTF_NUMBER_TABLE
478: , x_error_msg out nocopy VARCHAR2

Line 475: , p2_a1 in out nocopy JTF_NUMBER_TABLE

471: , p1_a2 in out nocopy JTF_NUMBER_TABLE
472: , p1_a3 in out nocopy JTF_NUMBER_TABLE
473: , p1_a4 in out nocopy JTF_NUMBER_TABLE
474: , p2_a0 in out nocopy JTF_NUMBER_TABLE
475: , p2_a1 in out nocopy JTF_NUMBER_TABLE
476: , p2_a2 in out nocopy JTF_NUMBER_TABLE
477: , p2_a3 in out nocopy JTF_NUMBER_TABLE
478: , x_error_msg out nocopy VARCHAR2
479: , x_return_status out nocopy VARCHAR2

Line 476: , p2_a2 in out nocopy JTF_NUMBER_TABLE

472: , p1_a3 in out nocopy JTF_NUMBER_TABLE
473: , p1_a4 in out nocopy JTF_NUMBER_TABLE
474: , p2_a0 in out nocopy JTF_NUMBER_TABLE
475: , p2_a1 in out nocopy JTF_NUMBER_TABLE
476: , p2_a2 in out nocopy JTF_NUMBER_TABLE
477: , p2_a3 in out nocopy JTF_NUMBER_TABLE
478: , x_error_msg out nocopy VARCHAR2
479: , x_return_status out nocopy VARCHAR2
480: );

Line 477: , p2_a3 in out nocopy JTF_NUMBER_TABLE

473: , p1_a4 in out nocopy JTF_NUMBER_TABLE
474: , p2_a0 in out nocopy JTF_NUMBER_TABLE
475: , p2_a1 in out nocopy JTF_NUMBER_TABLE
476: , p2_a2 in out nocopy JTF_NUMBER_TABLE
477: , p2_a3 in out nocopy JTF_NUMBER_TABLE
478: , x_error_msg out nocopy VARCHAR2
479: , x_return_status out nocopy VARCHAR2
480: );
481: procedure get_attached_item_instances(p_api_version NUMBER

Line 483: , p2_a0 JTF_NUMBER_TABLE

479: , x_return_status out nocopy VARCHAR2
480: );
481: procedure get_attached_item_instances(p_api_version NUMBER
482: , p_init_msg_list VARCHAR2
483: , p2_a0 JTF_NUMBER_TABLE
484: , p2_a1 JTF_NUMBER_TABLE
485: , p2_a2 JTF_NUMBER_TABLE
486: , p2_a3 JTF_NUMBER_TABLE
487: , p2_a4 JTF_NUMBER_TABLE

Line 484: , p2_a1 JTF_NUMBER_TABLE

480: );
481: procedure get_attached_item_instances(p_api_version NUMBER
482: , p_init_msg_list VARCHAR2
483: , p2_a0 JTF_NUMBER_TABLE
484: , p2_a1 JTF_NUMBER_TABLE
485: , p2_a2 JTF_NUMBER_TABLE
486: , p2_a3 JTF_NUMBER_TABLE
487: , p2_a4 JTF_NUMBER_TABLE
488: , p3_a0 out nocopy JTF_NUMBER_TABLE

Line 485: , p2_a2 JTF_NUMBER_TABLE

481: procedure get_attached_item_instances(p_api_version NUMBER
482: , p_init_msg_list VARCHAR2
483: , p2_a0 JTF_NUMBER_TABLE
484: , p2_a1 JTF_NUMBER_TABLE
485: , p2_a2 JTF_NUMBER_TABLE
486: , p2_a3 JTF_NUMBER_TABLE
487: , p2_a4 JTF_NUMBER_TABLE
488: , p3_a0 out nocopy JTF_NUMBER_TABLE
489: , p3_a1 out nocopy JTF_NUMBER_TABLE

Line 486: , p2_a3 JTF_NUMBER_TABLE

482: , p_init_msg_list VARCHAR2
483: , p2_a0 JTF_NUMBER_TABLE
484: , p2_a1 JTF_NUMBER_TABLE
485: , p2_a2 JTF_NUMBER_TABLE
486: , p2_a3 JTF_NUMBER_TABLE
487: , p2_a4 JTF_NUMBER_TABLE
488: , p3_a0 out nocopy JTF_NUMBER_TABLE
489: , p3_a1 out nocopy JTF_NUMBER_TABLE
490: , p3_a2 out nocopy JTF_NUMBER_TABLE

Line 487: , p2_a4 JTF_NUMBER_TABLE

483: , p2_a0 JTF_NUMBER_TABLE
484: , p2_a1 JTF_NUMBER_TABLE
485: , p2_a2 JTF_NUMBER_TABLE
486: , p2_a3 JTF_NUMBER_TABLE
487: , p2_a4 JTF_NUMBER_TABLE
488: , p3_a0 out nocopy JTF_NUMBER_TABLE
489: , p3_a1 out nocopy JTF_NUMBER_TABLE
490: , p3_a2 out nocopy JTF_NUMBER_TABLE
491: , p3_a3 out nocopy JTF_NUMBER_TABLE

Line 488: , p3_a0 out nocopy JTF_NUMBER_TABLE

484: , p2_a1 JTF_NUMBER_TABLE
485: , p2_a2 JTF_NUMBER_TABLE
486: , p2_a3 JTF_NUMBER_TABLE
487: , p2_a4 JTF_NUMBER_TABLE
488: , p3_a0 out nocopy JTF_NUMBER_TABLE
489: , p3_a1 out nocopy JTF_NUMBER_TABLE
490: , p3_a2 out nocopy JTF_NUMBER_TABLE
491: , p3_a3 out nocopy JTF_NUMBER_TABLE
492: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 489: , p3_a1 out nocopy JTF_NUMBER_TABLE

485: , p2_a2 JTF_NUMBER_TABLE
486: , p2_a3 JTF_NUMBER_TABLE
487: , p2_a4 JTF_NUMBER_TABLE
488: , p3_a0 out nocopy JTF_NUMBER_TABLE
489: , p3_a1 out nocopy JTF_NUMBER_TABLE
490: , p3_a2 out nocopy JTF_NUMBER_TABLE
491: , p3_a3 out nocopy JTF_NUMBER_TABLE
492: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
493: , p3_a5 out nocopy JTF_NUMBER_TABLE

Line 490: , p3_a2 out nocopy JTF_NUMBER_TABLE

486: , p2_a3 JTF_NUMBER_TABLE
487: , p2_a4 JTF_NUMBER_TABLE
488: , p3_a0 out nocopy JTF_NUMBER_TABLE
489: , p3_a1 out nocopy JTF_NUMBER_TABLE
490: , p3_a2 out nocopy JTF_NUMBER_TABLE
491: , p3_a3 out nocopy JTF_NUMBER_TABLE
492: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
493: , p3_a5 out nocopy JTF_NUMBER_TABLE
494: , p3_a6 out nocopy JTF_NUMBER_TABLE

Line 491: , p3_a3 out nocopy JTF_NUMBER_TABLE

487: , p2_a4 JTF_NUMBER_TABLE
488: , p3_a0 out nocopy JTF_NUMBER_TABLE
489: , p3_a1 out nocopy JTF_NUMBER_TABLE
490: , p3_a2 out nocopy JTF_NUMBER_TABLE
491: , p3_a3 out nocopy JTF_NUMBER_TABLE
492: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
493: , p3_a5 out nocopy JTF_NUMBER_TABLE
494: , p3_a6 out nocopy JTF_NUMBER_TABLE
495: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 493: , p3_a5 out nocopy JTF_NUMBER_TABLE

489: , p3_a1 out nocopy JTF_NUMBER_TABLE
490: , p3_a2 out nocopy JTF_NUMBER_TABLE
491: , p3_a3 out nocopy JTF_NUMBER_TABLE
492: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
493: , p3_a5 out nocopy JTF_NUMBER_TABLE
494: , p3_a6 out nocopy JTF_NUMBER_TABLE
495: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
496: , x_return_status out nocopy VARCHAR2
497: , x_msg_count out nocopy NUMBER

Line 494: , p3_a6 out nocopy JTF_NUMBER_TABLE

490: , p3_a2 out nocopy JTF_NUMBER_TABLE
491: , p3_a3 out nocopy JTF_NUMBER_TABLE
492: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
493: , p3_a5 out nocopy JTF_NUMBER_TABLE
494: , p3_a6 out nocopy JTF_NUMBER_TABLE
495: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
496: , x_return_status out nocopy VARCHAR2
497: , x_msg_count out nocopy NUMBER
498: , x_msg_data out nocopy VARCHAR2

Line 504: , p2_a0 JTF_NUMBER_TABLE

500: , p_called_from_grp VARCHAR2
501: );
502: procedure get_attached_asset_links(p_api_version NUMBER
503: , p_init_msg_list VARCHAR2
504: , p2_a0 JTF_NUMBER_TABLE
505: , p2_a1 JTF_NUMBER_TABLE
506: , p2_a2 JTF_NUMBER_TABLE
507: , p2_a3 JTF_NUMBER_TABLE
508: , p2_a4 JTF_VARCHAR2_TABLE_100

Line 505: , p2_a1 JTF_NUMBER_TABLE

501: );
502: procedure get_attached_asset_links(p_api_version NUMBER
503: , p_init_msg_list VARCHAR2
504: , p2_a0 JTF_NUMBER_TABLE
505: , p2_a1 JTF_NUMBER_TABLE
506: , p2_a2 JTF_NUMBER_TABLE
507: , p2_a3 JTF_NUMBER_TABLE
508: , p2_a4 JTF_VARCHAR2_TABLE_100
509: , p2_a5 JTF_NUMBER_TABLE

Line 506: , p2_a2 JTF_NUMBER_TABLE

502: procedure get_attached_asset_links(p_api_version NUMBER
503: , p_init_msg_list VARCHAR2
504: , p2_a0 JTF_NUMBER_TABLE
505: , p2_a1 JTF_NUMBER_TABLE
506: , p2_a2 JTF_NUMBER_TABLE
507: , p2_a3 JTF_NUMBER_TABLE
508: , p2_a4 JTF_VARCHAR2_TABLE_100
509: , p2_a5 JTF_NUMBER_TABLE
510: , p2_a6 JTF_NUMBER_TABLE

Line 507: , p2_a3 JTF_NUMBER_TABLE

503: , p_init_msg_list VARCHAR2
504: , p2_a0 JTF_NUMBER_TABLE
505: , p2_a1 JTF_NUMBER_TABLE
506: , p2_a2 JTF_NUMBER_TABLE
507: , p2_a3 JTF_NUMBER_TABLE
508: , p2_a4 JTF_VARCHAR2_TABLE_100
509: , p2_a5 JTF_NUMBER_TABLE
510: , p2_a6 JTF_NUMBER_TABLE
511: , p2_a7 JTF_VARCHAR2_TABLE_100

Line 509: , p2_a5 JTF_NUMBER_TABLE

505: , p2_a1 JTF_NUMBER_TABLE
506: , p2_a2 JTF_NUMBER_TABLE
507: , p2_a3 JTF_NUMBER_TABLE
508: , p2_a4 JTF_VARCHAR2_TABLE_100
509: , p2_a5 JTF_NUMBER_TABLE
510: , p2_a6 JTF_NUMBER_TABLE
511: , p2_a7 JTF_VARCHAR2_TABLE_100
512: , p3_a0 out nocopy JTF_NUMBER_TABLE
513: , p3_a1 out nocopy JTF_NUMBER_TABLE

Line 510: , p2_a6 JTF_NUMBER_TABLE

506: , p2_a2 JTF_NUMBER_TABLE
507: , p2_a3 JTF_NUMBER_TABLE
508: , p2_a4 JTF_VARCHAR2_TABLE_100
509: , p2_a5 JTF_NUMBER_TABLE
510: , p2_a6 JTF_NUMBER_TABLE
511: , p2_a7 JTF_VARCHAR2_TABLE_100
512: , p3_a0 out nocopy JTF_NUMBER_TABLE
513: , p3_a1 out nocopy JTF_NUMBER_TABLE
514: , p3_a2 out nocopy JTF_NUMBER_TABLE

Line 512: , p3_a0 out nocopy JTF_NUMBER_TABLE

508: , p2_a4 JTF_VARCHAR2_TABLE_100
509: , p2_a5 JTF_NUMBER_TABLE
510: , p2_a6 JTF_NUMBER_TABLE
511: , p2_a7 JTF_VARCHAR2_TABLE_100
512: , p3_a0 out nocopy JTF_NUMBER_TABLE
513: , p3_a1 out nocopy JTF_NUMBER_TABLE
514: , p3_a2 out nocopy JTF_NUMBER_TABLE
515: , p3_a3 out nocopy JTF_NUMBER_TABLE
516: , p3_a4 out nocopy JTF_NUMBER_TABLE

Line 513: , p3_a1 out nocopy JTF_NUMBER_TABLE

509: , p2_a5 JTF_NUMBER_TABLE
510: , p2_a6 JTF_NUMBER_TABLE
511: , p2_a7 JTF_VARCHAR2_TABLE_100
512: , p3_a0 out nocopy JTF_NUMBER_TABLE
513: , p3_a1 out nocopy JTF_NUMBER_TABLE
514: , p3_a2 out nocopy JTF_NUMBER_TABLE
515: , p3_a3 out nocopy JTF_NUMBER_TABLE
516: , p3_a4 out nocopy JTF_NUMBER_TABLE
517: , x_return_status out nocopy VARCHAR2

Line 514: , p3_a2 out nocopy JTF_NUMBER_TABLE

510: , p2_a6 JTF_NUMBER_TABLE
511: , p2_a7 JTF_VARCHAR2_TABLE_100
512: , p3_a0 out nocopy JTF_NUMBER_TABLE
513: , p3_a1 out nocopy JTF_NUMBER_TABLE
514: , p3_a2 out nocopy JTF_NUMBER_TABLE
515: , p3_a3 out nocopy JTF_NUMBER_TABLE
516: , p3_a4 out nocopy JTF_NUMBER_TABLE
517: , x_return_status out nocopy VARCHAR2
518: , x_msg_count out nocopy NUMBER

Line 515: , p3_a3 out nocopy JTF_NUMBER_TABLE

511: , p2_a7 JTF_VARCHAR2_TABLE_100
512: , p3_a0 out nocopy JTF_NUMBER_TABLE
513: , p3_a1 out nocopy JTF_NUMBER_TABLE
514: , p3_a2 out nocopy JTF_NUMBER_TABLE
515: , p3_a3 out nocopy JTF_NUMBER_TABLE
516: , p3_a4 out nocopy JTF_NUMBER_TABLE
517: , x_return_status out nocopy VARCHAR2
518: , x_msg_count out nocopy NUMBER
519: , x_msg_data out nocopy VARCHAR2

Line 516: , p3_a4 out nocopy JTF_NUMBER_TABLE

512: , p3_a0 out nocopy JTF_NUMBER_TABLE
513: , p3_a1 out nocopy JTF_NUMBER_TABLE
514: , p3_a2 out nocopy JTF_NUMBER_TABLE
515: , p3_a3 out nocopy JTF_NUMBER_TABLE
516: , p3_a4 out nocopy JTF_NUMBER_TABLE
517: , x_return_status out nocopy VARCHAR2
518: , x_msg_count out nocopy NUMBER
519: , x_msg_data out nocopy VARCHAR2
520: , p_source_system_name VARCHAR2

Line 525: , p2_a0 JTF_NUMBER_TABLE

521: , p_called_from_grp VARCHAR2
522: );
523: procedure get_fa_asset_details(p_api_version NUMBER
524: , p_init_msg_list VARCHAR2
525: , p2_a0 JTF_NUMBER_TABLE
526: , p2_a1 JTF_NUMBER_TABLE
527: , p2_a2 JTF_NUMBER_TABLE
528: , p2_a3 JTF_NUMBER_TABLE
529: , p2_a4 JTF_NUMBER_TABLE

Line 526: , p2_a1 JTF_NUMBER_TABLE

522: );
523: procedure get_fa_asset_details(p_api_version NUMBER
524: , p_init_msg_list VARCHAR2
525: , p2_a0 JTF_NUMBER_TABLE
526: , p2_a1 JTF_NUMBER_TABLE
527: , p2_a2 JTF_NUMBER_TABLE
528: , p2_a3 JTF_NUMBER_TABLE
529: , p2_a4 JTF_NUMBER_TABLE
530: , p3_a0 out nocopy JTF_NUMBER_TABLE

Line 527: , p2_a2 JTF_NUMBER_TABLE

523: procedure get_fa_asset_details(p_api_version NUMBER
524: , p_init_msg_list VARCHAR2
525: , p2_a0 JTF_NUMBER_TABLE
526: , p2_a1 JTF_NUMBER_TABLE
527: , p2_a2 JTF_NUMBER_TABLE
528: , p2_a3 JTF_NUMBER_TABLE
529: , p2_a4 JTF_NUMBER_TABLE
530: , p3_a0 out nocopy JTF_NUMBER_TABLE
531: , p3_a1 out nocopy JTF_NUMBER_TABLE

Line 528: , p2_a3 JTF_NUMBER_TABLE

524: , p_init_msg_list VARCHAR2
525: , p2_a0 JTF_NUMBER_TABLE
526: , p2_a1 JTF_NUMBER_TABLE
527: , p2_a2 JTF_NUMBER_TABLE
528: , p2_a3 JTF_NUMBER_TABLE
529: , p2_a4 JTF_NUMBER_TABLE
530: , p3_a0 out nocopy JTF_NUMBER_TABLE
531: , p3_a1 out nocopy JTF_NUMBER_TABLE
532: , p3_a2 out nocopy JTF_NUMBER_TABLE

Line 529: , p2_a4 JTF_NUMBER_TABLE

525: , p2_a0 JTF_NUMBER_TABLE
526: , p2_a1 JTF_NUMBER_TABLE
527: , p2_a2 JTF_NUMBER_TABLE
528: , p2_a3 JTF_NUMBER_TABLE
529: , p2_a4 JTF_NUMBER_TABLE
530: , p3_a0 out nocopy JTF_NUMBER_TABLE
531: , p3_a1 out nocopy JTF_NUMBER_TABLE
532: , p3_a2 out nocopy JTF_NUMBER_TABLE
533: , p3_a3 out nocopy JTF_NUMBER_TABLE

Line 530: , p3_a0 out nocopy JTF_NUMBER_TABLE

526: , p2_a1 JTF_NUMBER_TABLE
527: , p2_a2 JTF_NUMBER_TABLE
528: , p2_a3 JTF_NUMBER_TABLE
529: , p2_a4 JTF_NUMBER_TABLE
530: , p3_a0 out nocopy JTF_NUMBER_TABLE
531: , p3_a1 out nocopy JTF_NUMBER_TABLE
532: , p3_a2 out nocopy JTF_NUMBER_TABLE
533: , p3_a3 out nocopy JTF_NUMBER_TABLE
534: , x_return_status out nocopy VARCHAR2

Line 531: , p3_a1 out nocopy JTF_NUMBER_TABLE

527: , p2_a2 JTF_NUMBER_TABLE
528: , p2_a3 JTF_NUMBER_TABLE
529: , p2_a4 JTF_NUMBER_TABLE
530: , p3_a0 out nocopy JTF_NUMBER_TABLE
531: , p3_a1 out nocopy JTF_NUMBER_TABLE
532: , p3_a2 out nocopy JTF_NUMBER_TABLE
533: , p3_a3 out nocopy JTF_NUMBER_TABLE
534: , x_return_status out nocopy VARCHAR2
535: , x_msg_count out nocopy NUMBER

Line 532: , p3_a2 out nocopy JTF_NUMBER_TABLE

528: , p2_a3 JTF_NUMBER_TABLE
529: , p2_a4 JTF_NUMBER_TABLE
530: , p3_a0 out nocopy JTF_NUMBER_TABLE
531: , p3_a1 out nocopy JTF_NUMBER_TABLE
532: , p3_a2 out nocopy JTF_NUMBER_TABLE
533: , p3_a3 out nocopy JTF_NUMBER_TABLE
534: , x_return_status out nocopy VARCHAR2
535: , x_msg_count out nocopy NUMBER
536: , x_msg_data out nocopy VARCHAR2

Line 533: , p3_a3 out nocopy JTF_NUMBER_TABLE

529: , p2_a4 JTF_NUMBER_TABLE
530: , p3_a0 out nocopy JTF_NUMBER_TABLE
531: , p3_a1 out nocopy JTF_NUMBER_TABLE
532: , p3_a2 out nocopy JTF_NUMBER_TABLE
533: , p3_a3 out nocopy JTF_NUMBER_TABLE
534: , x_return_status out nocopy VARCHAR2
535: , x_msg_count out nocopy NUMBER
536: , x_msg_data out nocopy VARCHAR2
537: , p_source_system_name VARCHAR2

Line 540: procedure get_syncup_tree(p0_a0 in out nocopy JTF_NUMBER_TABLE

536: , x_msg_data out nocopy VARCHAR2
537: , p_source_system_name VARCHAR2
538: , p_called_from_grp VARCHAR2
539: );
540: procedure get_syncup_tree(p0_a0 in out nocopy JTF_NUMBER_TABLE
541: , p0_a1 in out nocopy JTF_NUMBER_TABLE
542: , p0_a2 in out nocopy JTF_NUMBER_TABLE
543: , p0_a3 in out nocopy JTF_NUMBER_TABLE
544: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100

Line 541: , p0_a1 in out nocopy JTF_NUMBER_TABLE

537: , p_source_system_name VARCHAR2
538: , p_called_from_grp VARCHAR2
539: );
540: procedure get_syncup_tree(p0_a0 in out nocopy JTF_NUMBER_TABLE
541: , p0_a1 in out nocopy JTF_NUMBER_TABLE
542: , p0_a2 in out nocopy JTF_NUMBER_TABLE
543: , p0_a3 in out nocopy JTF_NUMBER_TABLE
544: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
545: , p0_a5 in out nocopy JTF_NUMBER_TABLE

Line 542: , p0_a2 in out nocopy JTF_NUMBER_TABLE

538: , p_called_from_grp VARCHAR2
539: );
540: procedure get_syncup_tree(p0_a0 in out nocopy JTF_NUMBER_TABLE
541: , p0_a1 in out nocopy JTF_NUMBER_TABLE
542: , p0_a2 in out nocopy JTF_NUMBER_TABLE
543: , p0_a3 in out nocopy JTF_NUMBER_TABLE
544: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
545: , p0_a5 in out nocopy JTF_NUMBER_TABLE
546: , p0_a6 in out nocopy JTF_NUMBER_TABLE

Line 543: , p0_a3 in out nocopy JTF_NUMBER_TABLE

539: );
540: procedure get_syncup_tree(p0_a0 in out nocopy JTF_NUMBER_TABLE
541: , p0_a1 in out nocopy JTF_NUMBER_TABLE
542: , p0_a2 in out nocopy JTF_NUMBER_TABLE
543: , p0_a3 in out nocopy JTF_NUMBER_TABLE
544: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
545: , p0_a5 in out nocopy JTF_NUMBER_TABLE
546: , p0_a6 in out nocopy JTF_NUMBER_TABLE
547: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100

Line 545: , p0_a5 in out nocopy JTF_NUMBER_TABLE

541: , p0_a1 in out nocopy JTF_NUMBER_TABLE
542: , p0_a2 in out nocopy JTF_NUMBER_TABLE
543: , p0_a3 in out nocopy JTF_NUMBER_TABLE
544: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
545: , p0_a5 in out nocopy JTF_NUMBER_TABLE
546: , p0_a6 in out nocopy JTF_NUMBER_TABLE
547: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
548: , p1_a0 in out nocopy JTF_NUMBER_TABLE
549: , p1_a1 in out nocopy JTF_NUMBER_TABLE

Line 546: , p0_a6 in out nocopy JTF_NUMBER_TABLE

542: , p0_a2 in out nocopy JTF_NUMBER_TABLE
543: , p0_a3 in out nocopy JTF_NUMBER_TABLE
544: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
545: , p0_a5 in out nocopy JTF_NUMBER_TABLE
546: , p0_a6 in out nocopy JTF_NUMBER_TABLE
547: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
548: , p1_a0 in out nocopy JTF_NUMBER_TABLE
549: , p1_a1 in out nocopy JTF_NUMBER_TABLE
550: , p1_a2 in out nocopy JTF_NUMBER_TABLE

Line 548: , p1_a0 in out nocopy JTF_NUMBER_TABLE

544: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
545: , p0_a5 in out nocopy JTF_NUMBER_TABLE
546: , p0_a6 in out nocopy JTF_NUMBER_TABLE
547: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
548: , p1_a0 in out nocopy JTF_NUMBER_TABLE
549: , p1_a1 in out nocopy JTF_NUMBER_TABLE
550: , p1_a2 in out nocopy JTF_NUMBER_TABLE
551: , p1_a3 in out nocopy JTF_NUMBER_TABLE
552: , p1_a4 in out nocopy JTF_NUMBER_TABLE

Line 549: , p1_a1 in out nocopy JTF_NUMBER_TABLE

545: , p0_a5 in out nocopy JTF_NUMBER_TABLE
546: , p0_a6 in out nocopy JTF_NUMBER_TABLE
547: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
548: , p1_a0 in out nocopy JTF_NUMBER_TABLE
549: , p1_a1 in out nocopy JTF_NUMBER_TABLE
550: , p1_a2 in out nocopy JTF_NUMBER_TABLE
551: , p1_a3 in out nocopy JTF_NUMBER_TABLE
552: , p1_a4 in out nocopy JTF_NUMBER_TABLE
553: , p2_a0 in out nocopy JTF_NUMBER_TABLE

Line 550: , p1_a2 in out nocopy JTF_NUMBER_TABLE

546: , p0_a6 in out nocopy JTF_NUMBER_TABLE
547: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
548: , p1_a0 in out nocopy JTF_NUMBER_TABLE
549: , p1_a1 in out nocopy JTF_NUMBER_TABLE
550: , p1_a2 in out nocopy JTF_NUMBER_TABLE
551: , p1_a3 in out nocopy JTF_NUMBER_TABLE
552: , p1_a4 in out nocopy JTF_NUMBER_TABLE
553: , p2_a0 in out nocopy JTF_NUMBER_TABLE
554: , p2_a1 in out nocopy JTF_NUMBER_TABLE

Line 551: , p1_a3 in out nocopy JTF_NUMBER_TABLE

547: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
548: , p1_a0 in out nocopy JTF_NUMBER_TABLE
549: , p1_a1 in out nocopy JTF_NUMBER_TABLE
550: , p1_a2 in out nocopy JTF_NUMBER_TABLE
551: , p1_a3 in out nocopy JTF_NUMBER_TABLE
552: , p1_a4 in out nocopy JTF_NUMBER_TABLE
553: , p2_a0 in out nocopy JTF_NUMBER_TABLE
554: , p2_a1 in out nocopy JTF_NUMBER_TABLE
555: , p2_a2 in out nocopy JTF_NUMBER_TABLE

Line 552: , p1_a4 in out nocopy JTF_NUMBER_TABLE

548: , p1_a0 in out nocopy JTF_NUMBER_TABLE
549: , p1_a1 in out nocopy JTF_NUMBER_TABLE
550: , p1_a2 in out nocopy JTF_NUMBER_TABLE
551: , p1_a3 in out nocopy JTF_NUMBER_TABLE
552: , p1_a4 in out nocopy JTF_NUMBER_TABLE
553: , p2_a0 in out nocopy JTF_NUMBER_TABLE
554: , p2_a1 in out nocopy JTF_NUMBER_TABLE
555: , p2_a2 in out nocopy JTF_NUMBER_TABLE
556: , p2_a3 in out nocopy JTF_NUMBER_TABLE

Line 553: , p2_a0 in out nocopy JTF_NUMBER_TABLE

549: , p1_a1 in out nocopy JTF_NUMBER_TABLE
550: , p1_a2 in out nocopy JTF_NUMBER_TABLE
551: , p1_a3 in out nocopy JTF_NUMBER_TABLE
552: , p1_a4 in out nocopy JTF_NUMBER_TABLE
553: , p2_a0 in out nocopy JTF_NUMBER_TABLE
554: , p2_a1 in out nocopy JTF_NUMBER_TABLE
555: , p2_a2 in out nocopy JTF_NUMBER_TABLE
556: , p2_a3 in out nocopy JTF_NUMBER_TABLE
557: , x_return_status out nocopy VARCHAR2

Line 554: , p2_a1 in out nocopy JTF_NUMBER_TABLE

550: , p1_a2 in out nocopy JTF_NUMBER_TABLE
551: , p1_a3 in out nocopy JTF_NUMBER_TABLE
552: , p1_a4 in out nocopy JTF_NUMBER_TABLE
553: , p2_a0 in out nocopy JTF_NUMBER_TABLE
554: , p2_a1 in out nocopy JTF_NUMBER_TABLE
555: , p2_a2 in out nocopy JTF_NUMBER_TABLE
556: , p2_a3 in out nocopy JTF_NUMBER_TABLE
557: , x_return_status out nocopy VARCHAR2
558: , x_error_msg out nocopy VARCHAR2

Line 555: , p2_a2 in out nocopy JTF_NUMBER_TABLE

551: , p1_a3 in out nocopy JTF_NUMBER_TABLE
552: , p1_a4 in out nocopy JTF_NUMBER_TABLE
553: , p2_a0 in out nocopy JTF_NUMBER_TABLE
554: , p2_a1 in out nocopy JTF_NUMBER_TABLE
555: , p2_a2 in out nocopy JTF_NUMBER_TABLE
556: , p2_a3 in out nocopy JTF_NUMBER_TABLE
557: , x_return_status out nocopy VARCHAR2
558: , x_error_msg out nocopy VARCHAR2
559: , p_source_system_name VARCHAR2

Line 556: , p2_a3 in out nocopy JTF_NUMBER_TABLE

552: , p1_a4 in out nocopy JTF_NUMBER_TABLE
553: , p2_a0 in out nocopy JTF_NUMBER_TABLE
554: , p2_a1 in out nocopy JTF_NUMBER_TABLE
555: , p2_a2 in out nocopy JTF_NUMBER_TABLE
556: , p2_a3 in out nocopy JTF_NUMBER_TABLE
557: , x_return_status out nocopy VARCHAR2
558: , x_error_msg out nocopy VARCHAR2
559: , p_source_system_name VARCHAR2
560: , p_called_from_grp VARCHAR2

Line 566: , p4_a0 in out nocopy JTF_NUMBER_TABLE

562: procedure create_instance_assets(p_api_version NUMBER
563: , p_commit VARCHAR2
564: , p_init_msg_list VARCHAR2
565: , p_validation_level NUMBER
566: , p4_a0 in out nocopy JTF_NUMBER_TABLE
567: , p4_a1 in out nocopy JTF_NUMBER_TABLE
568: , p4_a2 in out nocopy JTF_NUMBER_TABLE
569: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
570: , p4_a4 in out nocopy JTF_NUMBER_TABLE

Line 567: , p4_a1 in out nocopy JTF_NUMBER_TABLE

563: , p_commit VARCHAR2
564: , p_init_msg_list VARCHAR2
565: , p_validation_level NUMBER
566: , p4_a0 in out nocopy JTF_NUMBER_TABLE
567: , p4_a1 in out nocopy JTF_NUMBER_TABLE
568: , p4_a2 in out nocopy JTF_NUMBER_TABLE
569: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
570: , p4_a4 in out nocopy JTF_NUMBER_TABLE
571: , p4_a5 in out nocopy JTF_NUMBER_TABLE

Line 568: , p4_a2 in out nocopy JTF_NUMBER_TABLE

564: , p_init_msg_list VARCHAR2
565: , p_validation_level NUMBER
566: , p4_a0 in out nocopy JTF_NUMBER_TABLE
567: , p4_a1 in out nocopy JTF_NUMBER_TABLE
568: , p4_a2 in out nocopy JTF_NUMBER_TABLE
569: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
570: , p4_a4 in out nocopy JTF_NUMBER_TABLE
571: , p4_a5 in out nocopy JTF_NUMBER_TABLE
572: , p4_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 570: , p4_a4 in out nocopy JTF_NUMBER_TABLE

566: , p4_a0 in out nocopy JTF_NUMBER_TABLE
567: , p4_a1 in out nocopy JTF_NUMBER_TABLE
568: , p4_a2 in out nocopy JTF_NUMBER_TABLE
569: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
570: , p4_a4 in out nocopy JTF_NUMBER_TABLE
571: , p4_a5 in out nocopy JTF_NUMBER_TABLE
572: , p4_a6 in out nocopy JTF_VARCHAR2_TABLE_100
573: , p4_a7 in out nocopy JTF_DATE_TABLE
574: , p4_a8 in out nocopy JTF_DATE_TABLE

Line 571: , p4_a5 in out nocopy JTF_NUMBER_TABLE

567: , p4_a1 in out nocopy JTF_NUMBER_TABLE
568: , p4_a2 in out nocopy JTF_NUMBER_TABLE
569: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
570: , p4_a4 in out nocopy JTF_NUMBER_TABLE
571: , p4_a5 in out nocopy JTF_NUMBER_TABLE
572: , p4_a6 in out nocopy JTF_VARCHAR2_TABLE_100
573: , p4_a7 in out nocopy JTF_DATE_TABLE
574: , p4_a8 in out nocopy JTF_DATE_TABLE
575: , p4_a9 in out nocopy JTF_NUMBER_TABLE

Line 575: , p4_a9 in out nocopy JTF_NUMBER_TABLE

571: , p4_a5 in out nocopy JTF_NUMBER_TABLE
572: , p4_a6 in out nocopy JTF_VARCHAR2_TABLE_100
573: , p4_a7 in out nocopy JTF_DATE_TABLE
574: , p4_a8 in out nocopy JTF_DATE_TABLE
575: , p4_a9 in out nocopy JTF_NUMBER_TABLE
576: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
577: , p4_a11 in out nocopy JTF_NUMBER_TABLE
578: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
579: , p4_a13 in out nocopy JTF_NUMBER_TABLE

Line 577: , p4_a11 in out nocopy JTF_NUMBER_TABLE

573: , p4_a7 in out nocopy JTF_DATE_TABLE
574: , p4_a8 in out nocopy JTF_DATE_TABLE
575: , p4_a9 in out nocopy JTF_NUMBER_TABLE
576: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
577: , p4_a11 in out nocopy JTF_NUMBER_TABLE
578: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
579: , p4_a13 in out nocopy JTF_NUMBER_TABLE
580: , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_100
581: , p4_a15 in out nocopy JTF_VARCHAR2_TABLE_100

Line 579: , p4_a13 in out nocopy JTF_NUMBER_TABLE

575: , p4_a9 in out nocopy JTF_NUMBER_TABLE
576: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
577: , p4_a11 in out nocopy JTF_NUMBER_TABLE
578: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
579: , p4_a13 in out nocopy JTF_NUMBER_TABLE
580: , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_100
581: , p4_a15 in out nocopy JTF_VARCHAR2_TABLE_100
582: , p5_a0 in out nocopy NUMBER
583: , p5_a1 in out nocopy DATE

Line 627: , p8_a0 in out nocopy JTF_NUMBER_TABLE

623: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
624: , p7_a0 in out nocopy NUMBER
625: , p7_a1 in out nocopy NUMBER
626: , p7_a2 in out nocopy NUMBER
627: , p8_a0 in out nocopy JTF_NUMBER_TABLE
628: , p8_a1 in out nocopy JTF_VARCHAR2_TABLE_100
629: , p8_a2 in out nocopy JTF_VARCHAR2_TABLE_100
630: , p9_a0 in out nocopy JTF_NUMBER_TABLE
631: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100

Line 630: , p9_a0 in out nocopy JTF_NUMBER_TABLE

626: , p7_a2 in out nocopy NUMBER
627: , p8_a0 in out nocopy JTF_NUMBER_TABLE
628: , p8_a1 in out nocopy JTF_VARCHAR2_TABLE_100
629: , p8_a2 in out nocopy JTF_VARCHAR2_TABLE_100
630: , p9_a0 in out nocopy JTF_NUMBER_TABLE
631: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
632: , x_return_status out nocopy VARCHAR2
633: , x_msg_count out nocopy NUMBER
634: , x_msg_data out nocopy VARCHAR2