APPS.AHL_PRD_SERN_CHANGE_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 17: , a1 JTF_VARCHAR2_TABLE_100

13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_sern_change_pvt.sernum_change_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_VARCHAR2_TABLE_100

Line 18: , a2 JTF_VARCHAR2_TABLE_100

14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_sern_change_pvt.sernum_change_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_NUMBER_TABLE

Line 19: , a3 JTF_VARCHAR2_TABLE_100

15:
16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_sern_change_pvt.sernum_change_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE

Line 20: , a4 JTF_VARCHAR2_TABLE_100

16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_sern_change_pvt.sernum_change_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_100

Line 21: , a5 JTF_VARCHAR2_TABLE_100

17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_100

Line 24: , a8 JTF_VARCHAR2_TABLE_100

20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_VARCHAR2_TABLE_100

Line 25: , a9 JTF_VARCHAR2_TABLE_100

21: , a5 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_VARCHAR2_TABLE_100
29: ) as

Line 26: , a10 JTF_VARCHAR2_TABLE_100

22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_VARCHAR2_TABLE_100
29: ) as
30: ddindx binary_integer; indx binary_integer;

Line 27: , a11 JTF_VARCHAR2_TABLE_100

23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_VARCHAR2_TABLE_100
29: ) as
30: ddindx binary_integer; indx binary_integer;
31: begin

Line 28: , a12 JTF_VARCHAR2_TABLE_100

24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_VARCHAR2_TABLE_100
29: ) as
30: ddindx binary_integer; indx binary_integer;
31: begin
32: if a0 is not null and a0.count > 0 then

Line 60: , a1 out nocopy JTF_VARCHAR2_TABLE_100

56: end if;
57: end if;
58: end rosetta_table_copy_in_p1;
59: procedure rosetta_table_copy_out_p1(t ahl_prd_sern_change_pvt.sernum_change_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
60: , a1 out nocopy JTF_VARCHAR2_TABLE_100
61: , a2 out nocopy JTF_VARCHAR2_TABLE_100
62: , a3 out nocopy JTF_VARCHAR2_TABLE_100
63: , a4 out nocopy JTF_VARCHAR2_TABLE_100
64: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 61: , a2 out nocopy JTF_VARCHAR2_TABLE_100

57: end if;
58: end rosetta_table_copy_in_p1;
59: procedure rosetta_table_copy_out_p1(t ahl_prd_sern_change_pvt.sernum_change_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
60: , a1 out nocopy JTF_VARCHAR2_TABLE_100
61: , a2 out nocopy JTF_VARCHAR2_TABLE_100
62: , a3 out nocopy JTF_VARCHAR2_TABLE_100
63: , a4 out nocopy JTF_VARCHAR2_TABLE_100
64: , a5 out nocopy JTF_VARCHAR2_TABLE_100
65: , a6 out nocopy JTF_NUMBER_TABLE

Line 62: , a3 out nocopy JTF_VARCHAR2_TABLE_100

58: end rosetta_table_copy_in_p1;
59: procedure rosetta_table_copy_out_p1(t ahl_prd_sern_change_pvt.sernum_change_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
60: , a1 out nocopy JTF_VARCHAR2_TABLE_100
61: , a2 out nocopy JTF_VARCHAR2_TABLE_100
62: , a3 out nocopy JTF_VARCHAR2_TABLE_100
63: , a4 out nocopy JTF_VARCHAR2_TABLE_100
64: , a5 out nocopy JTF_VARCHAR2_TABLE_100
65: , a6 out nocopy JTF_NUMBER_TABLE
66: , a7 out nocopy JTF_NUMBER_TABLE

Line 63: , a4 out nocopy JTF_VARCHAR2_TABLE_100

59: procedure rosetta_table_copy_out_p1(t ahl_prd_sern_change_pvt.sernum_change_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
60: , a1 out nocopy JTF_VARCHAR2_TABLE_100
61: , a2 out nocopy JTF_VARCHAR2_TABLE_100
62: , a3 out nocopy JTF_VARCHAR2_TABLE_100
63: , a4 out nocopy JTF_VARCHAR2_TABLE_100
64: , a5 out nocopy JTF_VARCHAR2_TABLE_100
65: , a6 out nocopy JTF_NUMBER_TABLE
66: , a7 out nocopy JTF_NUMBER_TABLE
67: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 64: , a5 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 67: , a8 out nocopy JTF_VARCHAR2_TABLE_100

63: , a4 out nocopy JTF_VARCHAR2_TABLE_100
64: , a5 out nocopy JTF_VARCHAR2_TABLE_100
65: , a6 out nocopy JTF_NUMBER_TABLE
66: , a7 out nocopy JTF_NUMBER_TABLE
67: , a8 out nocopy JTF_VARCHAR2_TABLE_100
68: , a9 out nocopy JTF_VARCHAR2_TABLE_100
69: , a10 out nocopy JTF_VARCHAR2_TABLE_100
70: , a11 out nocopy JTF_VARCHAR2_TABLE_100
71: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 68: , a9 out nocopy JTF_VARCHAR2_TABLE_100

64: , a5 out nocopy JTF_VARCHAR2_TABLE_100
65: , a6 out nocopy JTF_NUMBER_TABLE
66: , a7 out nocopy JTF_NUMBER_TABLE
67: , a8 out nocopy JTF_VARCHAR2_TABLE_100
68: , a9 out nocopy JTF_VARCHAR2_TABLE_100
69: , a10 out nocopy JTF_VARCHAR2_TABLE_100
70: , a11 out nocopy JTF_VARCHAR2_TABLE_100
71: , a12 out nocopy JTF_VARCHAR2_TABLE_100
72: ) as

Line 69: , a10 out nocopy JTF_VARCHAR2_TABLE_100

65: , a6 out nocopy JTF_NUMBER_TABLE
66: , a7 out nocopy JTF_NUMBER_TABLE
67: , a8 out nocopy JTF_VARCHAR2_TABLE_100
68: , a9 out nocopy JTF_VARCHAR2_TABLE_100
69: , a10 out nocopy JTF_VARCHAR2_TABLE_100
70: , a11 out nocopy JTF_VARCHAR2_TABLE_100
71: , a12 out nocopy JTF_VARCHAR2_TABLE_100
72: ) as
73: ddindx binary_integer; indx binary_integer;

Line 70: , a11 out nocopy JTF_VARCHAR2_TABLE_100

66: , a7 out nocopy JTF_NUMBER_TABLE
67: , a8 out nocopy JTF_VARCHAR2_TABLE_100
68: , a9 out nocopy JTF_VARCHAR2_TABLE_100
69: , a10 out nocopy JTF_VARCHAR2_TABLE_100
70: , a11 out nocopy JTF_VARCHAR2_TABLE_100
71: , a12 out nocopy JTF_VARCHAR2_TABLE_100
72: ) as
73: ddindx binary_integer; indx binary_integer;
74: begin

Line 71: , a12 out nocopy JTF_VARCHAR2_TABLE_100

67: , a8 out nocopy JTF_VARCHAR2_TABLE_100
68: , a9 out nocopy JTF_VARCHAR2_TABLE_100
69: , a10 out nocopy JTF_VARCHAR2_TABLE_100
70: , a11 out nocopy JTF_VARCHAR2_TABLE_100
71: , a12 out nocopy JTF_VARCHAR2_TABLE_100
72: ) as
73: ddindx binary_integer; indx binary_integer;
74: begin
75: if t is null or t.count = 0 then

Line 77: a1 := JTF_VARCHAR2_TABLE_100();

73: ddindx binary_integer; indx binary_integer;
74: begin
75: if t is null or t.count = 0 then
76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_VARCHAR2_TABLE_100();
78: a2 := JTF_VARCHAR2_TABLE_100();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_VARCHAR2_TABLE_100();
81: a5 := JTF_VARCHAR2_TABLE_100();

Line 78: a2 := JTF_VARCHAR2_TABLE_100();

74: begin
75: if t is null or t.count = 0 then
76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_VARCHAR2_TABLE_100();
78: a2 := JTF_VARCHAR2_TABLE_100();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_VARCHAR2_TABLE_100();
81: a5 := JTF_VARCHAR2_TABLE_100();
82: a6 := JTF_NUMBER_TABLE();

Line 79: a3 := JTF_VARCHAR2_TABLE_100();

75: if t is null or t.count = 0 then
76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_VARCHAR2_TABLE_100();
78: a2 := JTF_VARCHAR2_TABLE_100();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_VARCHAR2_TABLE_100();
81: a5 := JTF_VARCHAR2_TABLE_100();
82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_NUMBER_TABLE();

Line 80: a4 := JTF_VARCHAR2_TABLE_100();

76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_VARCHAR2_TABLE_100();
78: a2 := JTF_VARCHAR2_TABLE_100();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_VARCHAR2_TABLE_100();
81: a5 := JTF_VARCHAR2_TABLE_100();
82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_NUMBER_TABLE();
84: a8 := JTF_VARCHAR2_TABLE_100();

Line 81: a5 := JTF_VARCHAR2_TABLE_100();

77: a1 := JTF_VARCHAR2_TABLE_100();
78: a2 := JTF_VARCHAR2_TABLE_100();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_VARCHAR2_TABLE_100();
81: a5 := JTF_VARCHAR2_TABLE_100();
82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_NUMBER_TABLE();
84: a8 := JTF_VARCHAR2_TABLE_100();
85: a9 := JTF_VARCHAR2_TABLE_100();

Line 84: a8 := JTF_VARCHAR2_TABLE_100();

80: a4 := JTF_VARCHAR2_TABLE_100();
81: a5 := JTF_VARCHAR2_TABLE_100();
82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_NUMBER_TABLE();
84: a8 := JTF_VARCHAR2_TABLE_100();
85: a9 := JTF_VARCHAR2_TABLE_100();
86: a10 := JTF_VARCHAR2_TABLE_100();
87: a11 := JTF_VARCHAR2_TABLE_100();
88: a12 := JTF_VARCHAR2_TABLE_100();

Line 85: a9 := JTF_VARCHAR2_TABLE_100();

81: a5 := JTF_VARCHAR2_TABLE_100();
82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_NUMBER_TABLE();
84: a8 := JTF_VARCHAR2_TABLE_100();
85: a9 := JTF_VARCHAR2_TABLE_100();
86: a10 := JTF_VARCHAR2_TABLE_100();
87: a11 := JTF_VARCHAR2_TABLE_100();
88: a12 := JTF_VARCHAR2_TABLE_100();
89: else

Line 86: a10 := JTF_VARCHAR2_TABLE_100();

82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_NUMBER_TABLE();
84: a8 := JTF_VARCHAR2_TABLE_100();
85: a9 := JTF_VARCHAR2_TABLE_100();
86: a10 := JTF_VARCHAR2_TABLE_100();
87: a11 := JTF_VARCHAR2_TABLE_100();
88: a12 := JTF_VARCHAR2_TABLE_100();
89: else
90: a0 := JTF_NUMBER_TABLE();

Line 87: a11 := JTF_VARCHAR2_TABLE_100();

83: a7 := JTF_NUMBER_TABLE();
84: a8 := JTF_VARCHAR2_TABLE_100();
85: a9 := JTF_VARCHAR2_TABLE_100();
86: a10 := JTF_VARCHAR2_TABLE_100();
87: a11 := JTF_VARCHAR2_TABLE_100();
88: a12 := JTF_VARCHAR2_TABLE_100();
89: else
90: a0 := JTF_NUMBER_TABLE();
91: a1 := JTF_VARCHAR2_TABLE_100();

Line 88: a12 := JTF_VARCHAR2_TABLE_100();

84: a8 := JTF_VARCHAR2_TABLE_100();
85: a9 := JTF_VARCHAR2_TABLE_100();
86: a10 := JTF_VARCHAR2_TABLE_100();
87: a11 := JTF_VARCHAR2_TABLE_100();
88: a12 := JTF_VARCHAR2_TABLE_100();
89: else
90: a0 := JTF_NUMBER_TABLE();
91: a1 := JTF_VARCHAR2_TABLE_100();
92: a2 := JTF_VARCHAR2_TABLE_100();

Line 91: a1 := JTF_VARCHAR2_TABLE_100();

87: a11 := JTF_VARCHAR2_TABLE_100();
88: a12 := JTF_VARCHAR2_TABLE_100();
89: else
90: a0 := JTF_NUMBER_TABLE();
91: a1 := JTF_VARCHAR2_TABLE_100();
92: a2 := JTF_VARCHAR2_TABLE_100();
93: a3 := JTF_VARCHAR2_TABLE_100();
94: a4 := JTF_VARCHAR2_TABLE_100();
95: a5 := JTF_VARCHAR2_TABLE_100();

Line 92: a2 := JTF_VARCHAR2_TABLE_100();

88: a12 := JTF_VARCHAR2_TABLE_100();
89: else
90: a0 := JTF_NUMBER_TABLE();
91: a1 := JTF_VARCHAR2_TABLE_100();
92: a2 := JTF_VARCHAR2_TABLE_100();
93: a3 := JTF_VARCHAR2_TABLE_100();
94: a4 := JTF_VARCHAR2_TABLE_100();
95: a5 := JTF_VARCHAR2_TABLE_100();
96: a6 := JTF_NUMBER_TABLE();

Line 93: a3 := JTF_VARCHAR2_TABLE_100();

89: else
90: a0 := JTF_NUMBER_TABLE();
91: a1 := JTF_VARCHAR2_TABLE_100();
92: a2 := JTF_VARCHAR2_TABLE_100();
93: a3 := JTF_VARCHAR2_TABLE_100();
94: a4 := JTF_VARCHAR2_TABLE_100();
95: a5 := JTF_VARCHAR2_TABLE_100();
96: a6 := JTF_NUMBER_TABLE();
97: a7 := JTF_NUMBER_TABLE();

Line 94: a4 := JTF_VARCHAR2_TABLE_100();

90: a0 := JTF_NUMBER_TABLE();
91: a1 := JTF_VARCHAR2_TABLE_100();
92: a2 := JTF_VARCHAR2_TABLE_100();
93: a3 := JTF_VARCHAR2_TABLE_100();
94: a4 := JTF_VARCHAR2_TABLE_100();
95: a5 := JTF_VARCHAR2_TABLE_100();
96: a6 := JTF_NUMBER_TABLE();
97: a7 := JTF_NUMBER_TABLE();
98: a8 := JTF_VARCHAR2_TABLE_100();

Line 95: a5 := JTF_VARCHAR2_TABLE_100();

91: a1 := JTF_VARCHAR2_TABLE_100();
92: a2 := JTF_VARCHAR2_TABLE_100();
93: a3 := JTF_VARCHAR2_TABLE_100();
94: a4 := JTF_VARCHAR2_TABLE_100();
95: a5 := JTF_VARCHAR2_TABLE_100();
96: a6 := JTF_NUMBER_TABLE();
97: a7 := JTF_NUMBER_TABLE();
98: a8 := JTF_VARCHAR2_TABLE_100();
99: a9 := JTF_VARCHAR2_TABLE_100();

Line 98: a8 := JTF_VARCHAR2_TABLE_100();

94: a4 := JTF_VARCHAR2_TABLE_100();
95: a5 := JTF_VARCHAR2_TABLE_100();
96: a6 := JTF_NUMBER_TABLE();
97: a7 := JTF_NUMBER_TABLE();
98: a8 := JTF_VARCHAR2_TABLE_100();
99: a9 := JTF_VARCHAR2_TABLE_100();
100: a10 := JTF_VARCHAR2_TABLE_100();
101: a11 := JTF_VARCHAR2_TABLE_100();
102: a12 := JTF_VARCHAR2_TABLE_100();

Line 99: a9 := JTF_VARCHAR2_TABLE_100();

95: a5 := JTF_VARCHAR2_TABLE_100();
96: a6 := JTF_NUMBER_TABLE();
97: a7 := JTF_NUMBER_TABLE();
98: a8 := JTF_VARCHAR2_TABLE_100();
99: a9 := JTF_VARCHAR2_TABLE_100();
100: a10 := JTF_VARCHAR2_TABLE_100();
101: a11 := JTF_VARCHAR2_TABLE_100();
102: a12 := JTF_VARCHAR2_TABLE_100();
103: if t.count > 0 then

Line 100: a10 := JTF_VARCHAR2_TABLE_100();

96: a6 := JTF_NUMBER_TABLE();
97: a7 := JTF_NUMBER_TABLE();
98: a8 := JTF_VARCHAR2_TABLE_100();
99: a9 := JTF_VARCHAR2_TABLE_100();
100: a10 := JTF_VARCHAR2_TABLE_100();
101: a11 := JTF_VARCHAR2_TABLE_100();
102: a12 := JTF_VARCHAR2_TABLE_100();
103: if t.count > 0 then
104: a0.extend(t.count);

Line 101: a11 := JTF_VARCHAR2_TABLE_100();

97: a7 := JTF_NUMBER_TABLE();
98: a8 := JTF_VARCHAR2_TABLE_100();
99: a9 := JTF_VARCHAR2_TABLE_100();
100: a10 := JTF_VARCHAR2_TABLE_100();
101: a11 := JTF_VARCHAR2_TABLE_100();
102: a12 := JTF_VARCHAR2_TABLE_100();
103: if t.count > 0 then
104: a0.extend(t.count);
105: a1.extend(t.count);

Line 102: a12 := JTF_VARCHAR2_TABLE_100();

98: a8 := JTF_VARCHAR2_TABLE_100();
99: a9 := JTF_VARCHAR2_TABLE_100();
100: a10 := JTF_VARCHAR2_TABLE_100();
101: a11 := JTF_VARCHAR2_TABLE_100();
102: a12 := JTF_VARCHAR2_TABLE_100();
103: if t.count > 0 then
104: a0.extend(t.count);
105: a1.extend(t.count);
106: a2.extend(t.count);