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.AHL_LTP_MTL_REQ_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_ltp_mtl_req_pvt.route_mtl_req_tbl_type, a0 JTF_NUMBER_TABLE

1: package body ahl_ltp_mtl_req_pvt_w as
2: /* $Header: AHLWLMRB.pls 120.0.12020000.2 2012/12/14 09:49:05 shnatu noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_ltp_mtl_req_pvt.route_mtl_req_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package body ahl_ltp_mtl_req_pvt_w as
2: /* $Header: AHLWLMRB.pls 120.0.12020000.2 2012/12/14 09:49:05 shnatu noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_ltp_mtl_req_pvt.route_mtl_req_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_NUMBER_TABLE

1: package body ahl_ltp_mtl_req_pvt_w as
2: /* $Header: AHLWLMRB.pls 120.0.12020000.2 2012/12/14 09:49:05 shnatu noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_ltp_mtl_req_pvt.route_mtl_req_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: AHLWLMRB.pls 120.0.12020000.2 2012/12/14 09:49:05 shnatu noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_ltp_mtl_req_pvt.route_mtl_req_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE

Line 7: , a4 JTF_NUMBER_TABLE

3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_ltp_mtl_req_pvt.route_mtl_req_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE

Line 9: , a6 JTF_NUMBER_TABLE

5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE

Line 10: , a7 JTF_NUMBER_TABLE

6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE

Line 11: , a8 JTF_NUMBER_TABLE

7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: ) as

Line 12: , a9 JTF_NUMBER_TABLE

8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: ) as
16: ddindx binary_integer; indx binary_integer;

Line 13: , a10 JTF_NUMBER_TABLE

9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: ) as
16: ddindx binary_integer; indx binary_integer;
17: begin

Line 14: , a11 JTF_NUMBER_TABLE

10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: ) as
16: ddindx binary_integer; indx binary_integer;
17: begin
18: if a0 is not null and a0.count > 0 then

Line 44: procedure rosetta_table_copy_out_p1(t ahl_ltp_mtl_req_pvt.route_mtl_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

40: end loop;
41: end if;
42: end if;
43: end rosetta_table_copy_in_p1;
44: procedure rosetta_table_copy_out_p1(t ahl_ltp_mtl_req_pvt.route_mtl_req_tbl_type, 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: , a4 out nocopy JTF_NUMBER_TABLE

Line 45: , a1 out nocopy JTF_NUMBER_TABLE

41: end if;
42: end if;
43: end rosetta_table_copy_in_p1;
44: procedure rosetta_table_copy_out_p1(t ahl_ltp_mtl_req_pvt.route_mtl_req_tbl_type, 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: , a4 out nocopy JTF_NUMBER_TABLE
49: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 46: , a2 out nocopy JTF_NUMBER_TABLE

42: end if;
43: end rosetta_table_copy_in_p1;
44: procedure rosetta_table_copy_out_p1(t ahl_ltp_mtl_req_pvt.route_mtl_req_tbl_type, 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: , a4 out nocopy JTF_NUMBER_TABLE
49: , a5 out nocopy JTF_VARCHAR2_TABLE_100
50: , a6 out nocopy JTF_NUMBER_TABLE

Line 47: , a3 out nocopy JTF_NUMBER_TABLE

43: end rosetta_table_copy_in_p1;
44: procedure rosetta_table_copy_out_p1(t ahl_ltp_mtl_req_pvt.route_mtl_req_tbl_type, 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: , a4 out nocopy JTF_NUMBER_TABLE
49: , a5 out nocopy JTF_VARCHAR2_TABLE_100
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_NUMBER_TABLE

Line 48: , a4 out nocopy JTF_NUMBER_TABLE

44: procedure rosetta_table_copy_out_p1(t ahl_ltp_mtl_req_pvt.route_mtl_req_tbl_type, 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: , a4 out nocopy JTF_NUMBER_TABLE
49: , a5 out nocopy JTF_VARCHAR2_TABLE_100
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_NUMBER_TABLE
52: , a8 out nocopy JTF_NUMBER_TABLE

Line 50: , a6 out nocopy JTF_NUMBER_TABLE

46: , a2 out nocopy JTF_NUMBER_TABLE
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_NUMBER_TABLE
49: , a5 out nocopy JTF_VARCHAR2_TABLE_100
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_NUMBER_TABLE
52: , a8 out nocopy JTF_NUMBER_TABLE
53: , a9 out nocopy JTF_NUMBER_TABLE
54: , a10 out nocopy JTF_NUMBER_TABLE

Line 51: , a7 out nocopy JTF_NUMBER_TABLE

47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_NUMBER_TABLE
49: , a5 out nocopy JTF_VARCHAR2_TABLE_100
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_NUMBER_TABLE
52: , a8 out nocopy JTF_NUMBER_TABLE
53: , a9 out nocopy JTF_NUMBER_TABLE
54: , a10 out nocopy JTF_NUMBER_TABLE
55: , a11 out nocopy JTF_NUMBER_TABLE

Line 52: , a8 out nocopy JTF_NUMBER_TABLE

48: , a4 out nocopy JTF_NUMBER_TABLE
49: , a5 out nocopy JTF_VARCHAR2_TABLE_100
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_NUMBER_TABLE
52: , a8 out nocopy JTF_NUMBER_TABLE
53: , a9 out nocopy JTF_NUMBER_TABLE
54: , a10 out nocopy JTF_NUMBER_TABLE
55: , a11 out nocopy JTF_NUMBER_TABLE
56: ) as

Line 53: , a9 out nocopy JTF_NUMBER_TABLE

49: , a5 out nocopy JTF_VARCHAR2_TABLE_100
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_NUMBER_TABLE
52: , a8 out nocopy JTF_NUMBER_TABLE
53: , a9 out nocopy JTF_NUMBER_TABLE
54: , a10 out nocopy JTF_NUMBER_TABLE
55: , a11 out nocopy JTF_NUMBER_TABLE
56: ) as
57: ddindx binary_integer; indx binary_integer;

Line 54: , a10 out nocopy JTF_NUMBER_TABLE

50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_NUMBER_TABLE
52: , a8 out nocopy JTF_NUMBER_TABLE
53: , a9 out nocopy JTF_NUMBER_TABLE
54: , a10 out nocopy JTF_NUMBER_TABLE
55: , a11 out nocopy JTF_NUMBER_TABLE
56: ) as
57: ddindx binary_integer; indx binary_integer;
58: begin

Line 55: , a11 out nocopy JTF_NUMBER_TABLE

51: , a7 out nocopy JTF_NUMBER_TABLE
52: , a8 out nocopy JTF_NUMBER_TABLE
53: , a9 out nocopy JTF_NUMBER_TABLE
54: , a10 out nocopy JTF_NUMBER_TABLE
55: , a11 out nocopy JTF_NUMBER_TABLE
56: ) as
57: ddindx binary_integer; indx binary_integer;
58: begin
59: if t is null or t.count = 0 then

Line 60: a0 := JTF_NUMBER_TABLE();

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

Line 61: a1 := JTF_NUMBER_TABLE();

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

Line 62: a2 := JTF_NUMBER_TABLE();

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

Line 63: a3 := JTF_NUMBER_TABLE();

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

Line 64: a4 := JTF_NUMBER_TABLE();

60: a0 := JTF_NUMBER_TABLE();
61: a1 := JTF_NUMBER_TABLE();
62: a2 := JTF_NUMBER_TABLE();
63: a3 := JTF_NUMBER_TABLE();
64: a4 := JTF_NUMBER_TABLE();
65: a5 := JTF_VARCHAR2_TABLE_100();
66: a6 := JTF_NUMBER_TABLE();
67: a7 := JTF_NUMBER_TABLE();
68: a8 := JTF_NUMBER_TABLE();

Line 66: a6 := JTF_NUMBER_TABLE();

62: a2 := JTF_NUMBER_TABLE();
63: a3 := JTF_NUMBER_TABLE();
64: a4 := JTF_NUMBER_TABLE();
65: a5 := JTF_VARCHAR2_TABLE_100();
66: a6 := JTF_NUMBER_TABLE();
67: a7 := JTF_NUMBER_TABLE();
68: a8 := JTF_NUMBER_TABLE();
69: a9 := JTF_NUMBER_TABLE();
70: a10 := JTF_NUMBER_TABLE();

Line 67: a7 := JTF_NUMBER_TABLE();

63: a3 := JTF_NUMBER_TABLE();
64: a4 := JTF_NUMBER_TABLE();
65: a5 := JTF_VARCHAR2_TABLE_100();
66: a6 := JTF_NUMBER_TABLE();
67: a7 := JTF_NUMBER_TABLE();
68: a8 := JTF_NUMBER_TABLE();
69: a9 := JTF_NUMBER_TABLE();
70: a10 := JTF_NUMBER_TABLE();
71: a11 := JTF_NUMBER_TABLE();

Line 68: a8 := JTF_NUMBER_TABLE();

64: a4 := JTF_NUMBER_TABLE();
65: a5 := JTF_VARCHAR2_TABLE_100();
66: a6 := JTF_NUMBER_TABLE();
67: a7 := JTF_NUMBER_TABLE();
68: a8 := JTF_NUMBER_TABLE();
69: a9 := JTF_NUMBER_TABLE();
70: a10 := JTF_NUMBER_TABLE();
71: a11 := JTF_NUMBER_TABLE();
72: else

Line 69: a9 := JTF_NUMBER_TABLE();

65: a5 := JTF_VARCHAR2_TABLE_100();
66: a6 := JTF_NUMBER_TABLE();
67: a7 := JTF_NUMBER_TABLE();
68: a8 := JTF_NUMBER_TABLE();
69: a9 := JTF_NUMBER_TABLE();
70: a10 := JTF_NUMBER_TABLE();
71: a11 := JTF_NUMBER_TABLE();
72: else
73: a0 := JTF_NUMBER_TABLE();

Line 70: a10 := JTF_NUMBER_TABLE();

66: a6 := JTF_NUMBER_TABLE();
67: a7 := JTF_NUMBER_TABLE();
68: a8 := JTF_NUMBER_TABLE();
69: a9 := JTF_NUMBER_TABLE();
70: a10 := JTF_NUMBER_TABLE();
71: a11 := JTF_NUMBER_TABLE();
72: else
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();

Line 71: a11 := JTF_NUMBER_TABLE();

67: a7 := JTF_NUMBER_TABLE();
68: a8 := JTF_NUMBER_TABLE();
69: a9 := JTF_NUMBER_TABLE();
70: a10 := JTF_NUMBER_TABLE();
71: a11 := JTF_NUMBER_TABLE();
72: else
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_NUMBER_TABLE();

Line 73: a0 := JTF_NUMBER_TABLE();

69: a9 := JTF_NUMBER_TABLE();
70: a10 := JTF_NUMBER_TABLE();
71: a11 := JTF_NUMBER_TABLE();
72: else
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_NUMBER_TABLE();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_NUMBER_TABLE();

Line 74: a1 := JTF_NUMBER_TABLE();

70: a10 := JTF_NUMBER_TABLE();
71: a11 := JTF_NUMBER_TABLE();
72: else
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_NUMBER_TABLE();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_NUMBER_TABLE();
78: a5 := JTF_VARCHAR2_TABLE_100();

Line 75: a2 := JTF_NUMBER_TABLE();

71: a11 := JTF_NUMBER_TABLE();
72: else
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_NUMBER_TABLE();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_NUMBER_TABLE();
78: a5 := JTF_VARCHAR2_TABLE_100();
79: a6 := JTF_NUMBER_TABLE();

Line 76: a3 := JTF_NUMBER_TABLE();

72: else
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_NUMBER_TABLE();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_NUMBER_TABLE();
78: a5 := JTF_VARCHAR2_TABLE_100();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_NUMBER_TABLE();

Line 77: a4 := JTF_NUMBER_TABLE();

73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_NUMBER_TABLE();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_NUMBER_TABLE();
78: a5 := JTF_VARCHAR2_TABLE_100();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_NUMBER_TABLE();

Line 79: a6 := JTF_NUMBER_TABLE();

75: a2 := JTF_NUMBER_TABLE();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_NUMBER_TABLE();
78: a5 := JTF_VARCHAR2_TABLE_100();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_NUMBER_TABLE();
82: a9 := JTF_NUMBER_TABLE();
83: a10 := JTF_NUMBER_TABLE();

Line 80: a7 := JTF_NUMBER_TABLE();

76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_NUMBER_TABLE();
78: a5 := JTF_VARCHAR2_TABLE_100();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_NUMBER_TABLE();
82: a9 := JTF_NUMBER_TABLE();
83: a10 := JTF_NUMBER_TABLE();
84: a11 := JTF_NUMBER_TABLE();

Line 81: a8 := JTF_NUMBER_TABLE();

77: a4 := JTF_NUMBER_TABLE();
78: a5 := JTF_VARCHAR2_TABLE_100();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_NUMBER_TABLE();
82: a9 := JTF_NUMBER_TABLE();
83: a10 := JTF_NUMBER_TABLE();
84: a11 := JTF_NUMBER_TABLE();
85: if t.count > 0 then

Line 82: a9 := JTF_NUMBER_TABLE();

78: a5 := JTF_VARCHAR2_TABLE_100();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_NUMBER_TABLE();
82: a9 := JTF_NUMBER_TABLE();
83: a10 := JTF_NUMBER_TABLE();
84: a11 := JTF_NUMBER_TABLE();
85: if t.count > 0 then
86: a0.extend(t.count);

Line 83: a10 := JTF_NUMBER_TABLE();

79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_NUMBER_TABLE();
82: a9 := JTF_NUMBER_TABLE();
83: a10 := JTF_NUMBER_TABLE();
84: a11 := JTF_NUMBER_TABLE();
85: if t.count > 0 then
86: a0.extend(t.count);
87: a1.extend(t.count);

Line 84: a11 := JTF_NUMBER_TABLE();

80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_NUMBER_TABLE();
82: a9 := JTF_NUMBER_TABLE();
83: a10 := JTF_NUMBER_TABLE();
84: a11 := JTF_NUMBER_TABLE();
85: if t.count > 0 then
86: a0.extend(t.count);
87: a1.extend(t.count);
88: a2.extend(t.count);

Line 123: procedure rosetta_table_copy_in_p2(t out nocopy ahl_ltp_mtl_req_pvt.alt_items_tbl_type, a0 JTF_NUMBER_TABLE) as

119: end if;
120: end if;
121: end rosetta_table_copy_out_p1;
122:
123: procedure rosetta_table_copy_in_p2(t out nocopy ahl_ltp_mtl_req_pvt.alt_items_tbl_type, a0 JTF_NUMBER_TABLE) as
124: ddindx binary_integer; indx binary_integer;
125: begin
126: if a0 is not null and a0.count > 0 then
127: if a0.count > 0 then

Line 141: procedure rosetta_table_copy_out_p2(t ahl_ltp_mtl_req_pvt.alt_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

137: end loop;
138: end if;
139: end if;
140: end rosetta_table_copy_in_p2;
141: procedure rosetta_table_copy_out_p2(t ahl_ltp_mtl_req_pvt.alt_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
142: ddindx binary_integer; indx binary_integer;
143: begin
144: if t is null or t.count = 0 then
145: a0 := JTF_NUMBER_TABLE();

Line 145: a0 := JTF_NUMBER_TABLE();

141: procedure rosetta_table_copy_out_p2(t ahl_ltp_mtl_req_pvt.alt_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
142: ddindx binary_integer; indx binary_integer;
143: begin
144: if t is null or t.count = 0 then
145: a0 := JTF_NUMBER_TABLE();
146: else
147: a0 := JTF_NUMBER_TABLE();
148: if t.count > 0 then
149: a0.extend(t.count);

Line 147: a0 := JTF_NUMBER_TABLE();

143: begin
144: if t is null or t.count = 0 then
145: a0 := JTF_NUMBER_TABLE();
146: else
147: a0 := JTF_NUMBER_TABLE();
148: if t.count > 0 then
149: a0.extend(t.count);
150: ddindx := t.first;
151: indx := 1;

Line 176: , p12_a0 out nocopy JTF_NUMBER_TABLE

172: , p_item_instance_id NUMBER
173: , p_visit_id NUMBER
174: , p_requirement_date DATE
175: , p_request_type VARCHAR2
176: , p12_a0 out nocopy JTF_NUMBER_TABLE
177: , p12_a1 out nocopy JTF_NUMBER_TABLE
178: , p12_a2 out nocopy JTF_NUMBER_TABLE
179: , p12_a3 out nocopy JTF_NUMBER_TABLE
180: , p12_a4 out nocopy JTF_NUMBER_TABLE

Line 177: , p12_a1 out nocopy JTF_NUMBER_TABLE

173: , p_visit_id NUMBER
174: , p_requirement_date DATE
175: , p_request_type VARCHAR2
176: , p12_a0 out nocopy JTF_NUMBER_TABLE
177: , p12_a1 out nocopy JTF_NUMBER_TABLE
178: , p12_a2 out nocopy JTF_NUMBER_TABLE
179: , p12_a3 out nocopy JTF_NUMBER_TABLE
180: , p12_a4 out nocopy JTF_NUMBER_TABLE
181: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 178: , p12_a2 out nocopy JTF_NUMBER_TABLE

174: , p_requirement_date DATE
175: , p_request_type VARCHAR2
176: , p12_a0 out nocopy JTF_NUMBER_TABLE
177: , p12_a1 out nocopy JTF_NUMBER_TABLE
178: , p12_a2 out nocopy JTF_NUMBER_TABLE
179: , p12_a3 out nocopy JTF_NUMBER_TABLE
180: , p12_a4 out nocopy JTF_NUMBER_TABLE
181: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
182: , p12_a6 out nocopy JTF_NUMBER_TABLE

Line 179: , p12_a3 out nocopy JTF_NUMBER_TABLE

175: , p_request_type VARCHAR2
176: , p12_a0 out nocopy JTF_NUMBER_TABLE
177: , p12_a1 out nocopy JTF_NUMBER_TABLE
178: , p12_a2 out nocopy JTF_NUMBER_TABLE
179: , p12_a3 out nocopy JTF_NUMBER_TABLE
180: , p12_a4 out nocopy JTF_NUMBER_TABLE
181: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
182: , p12_a6 out nocopy JTF_NUMBER_TABLE
183: , p12_a7 out nocopy JTF_NUMBER_TABLE

Line 180: , p12_a4 out nocopy JTF_NUMBER_TABLE

176: , p12_a0 out nocopy JTF_NUMBER_TABLE
177: , p12_a1 out nocopy JTF_NUMBER_TABLE
178: , p12_a2 out nocopy JTF_NUMBER_TABLE
179: , p12_a3 out nocopy JTF_NUMBER_TABLE
180: , p12_a4 out nocopy JTF_NUMBER_TABLE
181: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
182: , p12_a6 out nocopy JTF_NUMBER_TABLE
183: , p12_a7 out nocopy JTF_NUMBER_TABLE
184: , p12_a8 out nocopy JTF_NUMBER_TABLE

Line 182: , p12_a6 out nocopy JTF_NUMBER_TABLE

178: , p12_a2 out nocopy JTF_NUMBER_TABLE
179: , p12_a3 out nocopy JTF_NUMBER_TABLE
180: , p12_a4 out nocopy JTF_NUMBER_TABLE
181: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
182: , p12_a6 out nocopy JTF_NUMBER_TABLE
183: , p12_a7 out nocopy JTF_NUMBER_TABLE
184: , p12_a8 out nocopy JTF_NUMBER_TABLE
185: , p12_a9 out nocopy JTF_NUMBER_TABLE
186: , p12_a10 out nocopy JTF_NUMBER_TABLE

Line 183: , p12_a7 out nocopy JTF_NUMBER_TABLE

179: , p12_a3 out nocopy JTF_NUMBER_TABLE
180: , p12_a4 out nocopy JTF_NUMBER_TABLE
181: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
182: , p12_a6 out nocopy JTF_NUMBER_TABLE
183: , p12_a7 out nocopy JTF_NUMBER_TABLE
184: , p12_a8 out nocopy JTF_NUMBER_TABLE
185: , p12_a9 out nocopy JTF_NUMBER_TABLE
186: , p12_a10 out nocopy JTF_NUMBER_TABLE
187: , p12_a11 out nocopy JTF_NUMBER_TABLE

Line 184: , p12_a8 out nocopy JTF_NUMBER_TABLE

180: , p12_a4 out nocopy JTF_NUMBER_TABLE
181: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
182: , p12_a6 out nocopy JTF_NUMBER_TABLE
183: , p12_a7 out nocopy JTF_NUMBER_TABLE
184: , p12_a8 out nocopy JTF_NUMBER_TABLE
185: , p12_a9 out nocopy JTF_NUMBER_TABLE
186: , p12_a10 out nocopy JTF_NUMBER_TABLE
187: , p12_a11 out nocopy JTF_NUMBER_TABLE
188: )

Line 185: , p12_a9 out nocopy JTF_NUMBER_TABLE

181: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
182: , p12_a6 out nocopy JTF_NUMBER_TABLE
183: , p12_a7 out nocopy JTF_NUMBER_TABLE
184: , p12_a8 out nocopy JTF_NUMBER_TABLE
185: , p12_a9 out nocopy JTF_NUMBER_TABLE
186: , p12_a10 out nocopy JTF_NUMBER_TABLE
187: , p12_a11 out nocopy JTF_NUMBER_TABLE
188: )
189:

Line 186: , p12_a10 out nocopy JTF_NUMBER_TABLE

182: , p12_a6 out nocopy JTF_NUMBER_TABLE
183: , p12_a7 out nocopy JTF_NUMBER_TABLE
184: , p12_a8 out nocopy JTF_NUMBER_TABLE
185: , p12_a9 out nocopy JTF_NUMBER_TABLE
186: , p12_a10 out nocopy JTF_NUMBER_TABLE
187: , p12_a11 out nocopy JTF_NUMBER_TABLE
188: )
189:
190: as

Line 187: , p12_a11 out nocopy JTF_NUMBER_TABLE

183: , p12_a7 out nocopy JTF_NUMBER_TABLE
184: , p12_a8 out nocopy JTF_NUMBER_TABLE
185: , p12_a9 out nocopy JTF_NUMBER_TABLE
186: , p12_a10 out nocopy JTF_NUMBER_TABLE
187: , p12_a11 out nocopy JTF_NUMBER_TABLE
188: )
189:
190: as
191: ddx_route_mtl_req_tbl ahl_ltp_mtl_req_pvt.route_mtl_req_tbl_type;

Line 263: , p11_a0 in out nocopy JTF_NUMBER_TABLE

259: , p_visit_id NUMBER
260: , p_quantity NUMBER
261: , p_uom_code VARCHAR2
262: , p_x_index in out nocopy NUMBER
263: , p11_a0 in out nocopy JTF_NUMBER_TABLE
264: , p11_a1 in out nocopy JTF_NUMBER_TABLE
265: , p11_a2 in out nocopy JTF_NUMBER_TABLE
266: , p11_a3 in out nocopy JTF_NUMBER_TABLE
267: , p11_a4 in out nocopy JTF_NUMBER_TABLE

Line 264: , p11_a1 in out nocopy JTF_NUMBER_TABLE

260: , p_quantity NUMBER
261: , p_uom_code VARCHAR2
262: , p_x_index in out nocopy NUMBER
263: , p11_a0 in out nocopy JTF_NUMBER_TABLE
264: , p11_a1 in out nocopy JTF_NUMBER_TABLE
265: , p11_a2 in out nocopy JTF_NUMBER_TABLE
266: , p11_a3 in out nocopy JTF_NUMBER_TABLE
267: , p11_a4 in out nocopy JTF_NUMBER_TABLE
268: , p11_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 265: , p11_a2 in out nocopy JTF_NUMBER_TABLE

261: , p_uom_code VARCHAR2
262: , p_x_index in out nocopy NUMBER
263: , p11_a0 in out nocopy JTF_NUMBER_TABLE
264: , p11_a1 in out nocopy JTF_NUMBER_TABLE
265: , p11_a2 in out nocopy JTF_NUMBER_TABLE
266: , p11_a3 in out nocopy JTF_NUMBER_TABLE
267: , p11_a4 in out nocopy JTF_NUMBER_TABLE
268: , p11_a5 in out nocopy JTF_VARCHAR2_TABLE_100
269: , p11_a6 in out nocopy JTF_NUMBER_TABLE

Line 266: , p11_a3 in out nocopy JTF_NUMBER_TABLE

262: , p_x_index in out nocopy NUMBER
263: , p11_a0 in out nocopy JTF_NUMBER_TABLE
264: , p11_a1 in out nocopy JTF_NUMBER_TABLE
265: , p11_a2 in out nocopy JTF_NUMBER_TABLE
266: , p11_a3 in out nocopy JTF_NUMBER_TABLE
267: , p11_a4 in out nocopy JTF_NUMBER_TABLE
268: , p11_a5 in out nocopy JTF_VARCHAR2_TABLE_100
269: , p11_a6 in out nocopy JTF_NUMBER_TABLE
270: , p11_a7 in out nocopy JTF_NUMBER_TABLE

Line 267: , p11_a4 in out nocopy JTF_NUMBER_TABLE

263: , p11_a0 in out nocopy JTF_NUMBER_TABLE
264: , p11_a1 in out nocopy JTF_NUMBER_TABLE
265: , p11_a2 in out nocopy JTF_NUMBER_TABLE
266: , p11_a3 in out nocopy JTF_NUMBER_TABLE
267: , p11_a4 in out nocopy JTF_NUMBER_TABLE
268: , p11_a5 in out nocopy JTF_VARCHAR2_TABLE_100
269: , p11_a6 in out nocopy JTF_NUMBER_TABLE
270: , p11_a7 in out nocopy JTF_NUMBER_TABLE
271: , p11_a8 in out nocopy JTF_NUMBER_TABLE

Line 269: , p11_a6 in out nocopy JTF_NUMBER_TABLE

265: , p11_a2 in out nocopy JTF_NUMBER_TABLE
266: , p11_a3 in out nocopy JTF_NUMBER_TABLE
267: , p11_a4 in out nocopy JTF_NUMBER_TABLE
268: , p11_a5 in out nocopy JTF_VARCHAR2_TABLE_100
269: , p11_a6 in out nocopy JTF_NUMBER_TABLE
270: , p11_a7 in out nocopy JTF_NUMBER_TABLE
271: , p11_a8 in out nocopy JTF_NUMBER_TABLE
272: , p11_a9 in out nocopy JTF_NUMBER_TABLE
273: , p11_a10 in out nocopy JTF_NUMBER_TABLE

Line 270: , p11_a7 in out nocopy JTF_NUMBER_TABLE

266: , p11_a3 in out nocopy JTF_NUMBER_TABLE
267: , p11_a4 in out nocopy JTF_NUMBER_TABLE
268: , p11_a5 in out nocopy JTF_VARCHAR2_TABLE_100
269: , p11_a6 in out nocopy JTF_NUMBER_TABLE
270: , p11_a7 in out nocopy JTF_NUMBER_TABLE
271: , p11_a8 in out nocopy JTF_NUMBER_TABLE
272: , p11_a9 in out nocopy JTF_NUMBER_TABLE
273: , p11_a10 in out nocopy JTF_NUMBER_TABLE
274: , p11_a11 in out nocopy JTF_NUMBER_TABLE

Line 271: , p11_a8 in out nocopy JTF_NUMBER_TABLE

267: , p11_a4 in out nocopy JTF_NUMBER_TABLE
268: , p11_a5 in out nocopy JTF_VARCHAR2_TABLE_100
269: , p11_a6 in out nocopy JTF_NUMBER_TABLE
270: , p11_a7 in out nocopy JTF_NUMBER_TABLE
271: , p11_a8 in out nocopy JTF_NUMBER_TABLE
272: , p11_a9 in out nocopy JTF_NUMBER_TABLE
273: , p11_a10 in out nocopy JTF_NUMBER_TABLE
274: , p11_a11 in out nocopy JTF_NUMBER_TABLE
275: )

Line 272: , p11_a9 in out nocopy JTF_NUMBER_TABLE

268: , p11_a5 in out nocopy JTF_VARCHAR2_TABLE_100
269: , p11_a6 in out nocopy JTF_NUMBER_TABLE
270: , p11_a7 in out nocopy JTF_NUMBER_TABLE
271: , p11_a8 in out nocopy JTF_NUMBER_TABLE
272: , p11_a9 in out nocopy JTF_NUMBER_TABLE
273: , p11_a10 in out nocopy JTF_NUMBER_TABLE
274: , p11_a11 in out nocopy JTF_NUMBER_TABLE
275: )
276:

Line 273: , p11_a10 in out nocopy JTF_NUMBER_TABLE

269: , p11_a6 in out nocopy JTF_NUMBER_TABLE
270: , p11_a7 in out nocopy JTF_NUMBER_TABLE
271: , p11_a8 in out nocopy JTF_NUMBER_TABLE
272: , p11_a9 in out nocopy JTF_NUMBER_TABLE
273: , p11_a10 in out nocopy JTF_NUMBER_TABLE
274: , p11_a11 in out nocopy JTF_NUMBER_TABLE
275: )
276:
277: as

Line 274: , p11_a11 in out nocopy JTF_NUMBER_TABLE

270: , p11_a7 in out nocopy JTF_NUMBER_TABLE
271: , p11_a8 in out nocopy JTF_NUMBER_TABLE
272: , p11_a9 in out nocopy JTF_NUMBER_TABLE
273: , p11_a10 in out nocopy JTF_NUMBER_TABLE
274: , p11_a11 in out nocopy JTF_NUMBER_TABLE
275: )
276:
277: as
278: ddp_x_route_mtl_reqs ahl_ltp_mtl_req_pvt.route_mtl_req_tbl_type;

Line 354: , x_alt_items out nocopy JTF_NUMBER_TABLE

350: , p_init_msg_list VARCHAR2
351: , p_validation_level NUMBER
352: , p_schedule_material_id NUMBER
353: , p_curr_item_flag VARCHAR2
354: , x_alt_items out nocopy JTF_NUMBER_TABLE
355: , x_return_status out nocopy VARCHAR2
356: , x_msg_count out nocopy NUMBER
357: , x_msg_data out nocopy VARCHAR2
358: )