DBA Data[Home] [Help]

APPS.AMS_PS_STRATS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 30: , a8 JTF_VARCHAR2_TABLE_100

26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_1000
34: , a12 JTF_VARCHAR2_TABLE_100

Line 31: , a9 JTF_VARCHAR2_TABLE_100

27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_1000
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_1000

Line 32: , a10 JTF_VARCHAR2_TABLE_100

28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_1000
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_1000
36: ) as

Line 33: , a11 JTF_VARCHAR2_TABLE_1000

29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_1000
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_1000
36: ) as
37: ddindx binary_integer; indx binary_integer;

Line 34: , a12 JTF_VARCHAR2_TABLE_100

30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_1000
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_1000
36: ) as
37: ddindx binary_integer; indx binary_integer;
38: begin

Line 35: , a13 JTF_VARCHAR2_TABLE_1000

31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_1000
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_1000
36: ) as
37: ddindx binary_integer; indx binary_integer;
38: begin
39: if a0 is not null and a0.count > 0 then

Line 75: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100

71: , a4 OUT NOCOPY JTF_NUMBER_TABLE
72: , a5 OUT NOCOPY JTF_NUMBER_TABLE
73: , a6 OUT NOCOPY JTF_NUMBER_TABLE
74: , a7 OUT NOCOPY JTF_NUMBER_TABLE
75: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
76: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
77: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
78: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_1000
79: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 76: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100

72: , a5 OUT NOCOPY JTF_NUMBER_TABLE
73: , a6 OUT NOCOPY JTF_NUMBER_TABLE
74: , a7 OUT NOCOPY JTF_NUMBER_TABLE
75: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
76: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
77: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
78: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_1000
79: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
80: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_1000

Line 77: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100

73: , a6 OUT NOCOPY JTF_NUMBER_TABLE
74: , a7 OUT NOCOPY JTF_NUMBER_TABLE
75: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
76: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
77: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
78: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_1000
79: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
80: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_1000
81: ) as

Line 78: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_1000

74: , a7 OUT NOCOPY JTF_NUMBER_TABLE
75: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
76: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
77: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
78: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_1000
79: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
80: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_1000
81: ) as
82: ddindx binary_integer; indx binary_integer;

Line 79: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100

75: , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
76: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
77: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
78: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_1000
79: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
80: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_1000
81: ) as
82: ddindx binary_integer; indx binary_integer;
83: begin

Line 80: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_1000

76: , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
77: , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
78: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_1000
79: , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
80: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_1000
81: ) as
82: ddindx binary_integer; indx binary_integer;
83: begin
84: if t is null or t.count = 0 then

Line 93: a8 := JTF_VARCHAR2_TABLE_100();

89: a4 := JTF_NUMBER_TABLE();
90: a5 := JTF_NUMBER_TABLE();
91: a6 := JTF_NUMBER_TABLE();
92: a7 := JTF_NUMBER_TABLE();
93: a8 := JTF_VARCHAR2_TABLE_100();
94: a9 := JTF_VARCHAR2_TABLE_100();
95: a10 := JTF_VARCHAR2_TABLE_100();
96: a11 := JTF_VARCHAR2_TABLE_1000();
97: a12 := JTF_VARCHAR2_TABLE_100();

Line 94: a9 := JTF_VARCHAR2_TABLE_100();

90: a5 := JTF_NUMBER_TABLE();
91: a6 := JTF_NUMBER_TABLE();
92: a7 := JTF_NUMBER_TABLE();
93: a8 := JTF_VARCHAR2_TABLE_100();
94: a9 := JTF_VARCHAR2_TABLE_100();
95: a10 := JTF_VARCHAR2_TABLE_100();
96: a11 := JTF_VARCHAR2_TABLE_1000();
97: a12 := JTF_VARCHAR2_TABLE_100();
98: a13 := JTF_VARCHAR2_TABLE_1000();

Line 95: a10 := JTF_VARCHAR2_TABLE_100();

91: a6 := JTF_NUMBER_TABLE();
92: a7 := JTF_NUMBER_TABLE();
93: a8 := JTF_VARCHAR2_TABLE_100();
94: a9 := JTF_VARCHAR2_TABLE_100();
95: a10 := JTF_VARCHAR2_TABLE_100();
96: a11 := JTF_VARCHAR2_TABLE_1000();
97: a12 := JTF_VARCHAR2_TABLE_100();
98: a13 := JTF_VARCHAR2_TABLE_1000();
99: else

Line 96: a11 := JTF_VARCHAR2_TABLE_1000();

92: a7 := JTF_NUMBER_TABLE();
93: a8 := JTF_VARCHAR2_TABLE_100();
94: a9 := JTF_VARCHAR2_TABLE_100();
95: a10 := JTF_VARCHAR2_TABLE_100();
96: a11 := JTF_VARCHAR2_TABLE_1000();
97: a12 := JTF_VARCHAR2_TABLE_100();
98: a13 := JTF_VARCHAR2_TABLE_1000();
99: else
100: a0 := JTF_NUMBER_TABLE();

Line 97: a12 := JTF_VARCHAR2_TABLE_100();

93: a8 := JTF_VARCHAR2_TABLE_100();
94: a9 := JTF_VARCHAR2_TABLE_100();
95: a10 := JTF_VARCHAR2_TABLE_100();
96: a11 := JTF_VARCHAR2_TABLE_1000();
97: a12 := JTF_VARCHAR2_TABLE_100();
98: a13 := JTF_VARCHAR2_TABLE_1000();
99: else
100: a0 := JTF_NUMBER_TABLE();
101: a1 := JTF_DATE_TABLE();

Line 98: a13 := JTF_VARCHAR2_TABLE_1000();

94: a9 := JTF_VARCHAR2_TABLE_100();
95: a10 := JTF_VARCHAR2_TABLE_100();
96: a11 := JTF_VARCHAR2_TABLE_1000();
97: a12 := JTF_VARCHAR2_TABLE_100();
98: a13 := JTF_VARCHAR2_TABLE_1000();
99: else
100: a0 := JTF_NUMBER_TABLE();
101: a1 := JTF_DATE_TABLE();
102: a2 := JTF_NUMBER_TABLE();

Line 108: a8 := JTF_VARCHAR2_TABLE_100();

104: a4 := JTF_NUMBER_TABLE();
105: a5 := JTF_NUMBER_TABLE();
106: a6 := JTF_NUMBER_TABLE();
107: a7 := JTF_NUMBER_TABLE();
108: a8 := JTF_VARCHAR2_TABLE_100();
109: a9 := JTF_VARCHAR2_TABLE_100();
110: a10 := JTF_VARCHAR2_TABLE_100();
111: a11 := JTF_VARCHAR2_TABLE_1000();
112: a12 := JTF_VARCHAR2_TABLE_100();

Line 109: a9 := JTF_VARCHAR2_TABLE_100();

105: a5 := JTF_NUMBER_TABLE();
106: a6 := JTF_NUMBER_TABLE();
107: a7 := JTF_NUMBER_TABLE();
108: a8 := JTF_VARCHAR2_TABLE_100();
109: a9 := JTF_VARCHAR2_TABLE_100();
110: a10 := JTF_VARCHAR2_TABLE_100();
111: a11 := JTF_VARCHAR2_TABLE_1000();
112: a12 := JTF_VARCHAR2_TABLE_100();
113: a13 := JTF_VARCHAR2_TABLE_1000();

Line 110: a10 := JTF_VARCHAR2_TABLE_100();

106: a6 := JTF_NUMBER_TABLE();
107: a7 := JTF_NUMBER_TABLE();
108: a8 := JTF_VARCHAR2_TABLE_100();
109: a9 := JTF_VARCHAR2_TABLE_100();
110: a10 := JTF_VARCHAR2_TABLE_100();
111: a11 := JTF_VARCHAR2_TABLE_1000();
112: a12 := JTF_VARCHAR2_TABLE_100();
113: a13 := JTF_VARCHAR2_TABLE_1000();
114: if t.count > 0 then

Line 111: a11 := JTF_VARCHAR2_TABLE_1000();

107: a7 := JTF_NUMBER_TABLE();
108: a8 := JTF_VARCHAR2_TABLE_100();
109: a9 := JTF_VARCHAR2_TABLE_100();
110: a10 := JTF_VARCHAR2_TABLE_100();
111: a11 := JTF_VARCHAR2_TABLE_1000();
112: a12 := JTF_VARCHAR2_TABLE_100();
113: a13 := JTF_VARCHAR2_TABLE_1000();
114: if t.count > 0 then
115: a0.extend(t.count);

Line 112: a12 := JTF_VARCHAR2_TABLE_100();

108: a8 := JTF_VARCHAR2_TABLE_100();
109: a9 := JTF_VARCHAR2_TABLE_100();
110: a10 := JTF_VARCHAR2_TABLE_100();
111: a11 := JTF_VARCHAR2_TABLE_1000();
112: a12 := JTF_VARCHAR2_TABLE_100();
113: a13 := JTF_VARCHAR2_TABLE_1000();
114: if t.count > 0 then
115: a0.extend(t.count);
116: a1.extend(t.count);

Line 113: a13 := JTF_VARCHAR2_TABLE_1000();

109: a9 := JTF_VARCHAR2_TABLE_100();
110: a10 := JTF_VARCHAR2_TABLE_100();
111: a11 := JTF_VARCHAR2_TABLE_1000();
112: a12 := JTF_VARCHAR2_TABLE_100();
113: a13 := JTF_VARCHAR2_TABLE_1000();
114: if t.count > 0 then
115: a0.extend(t.count);
116: a1.extend(t.count);
117: a2.extend(t.count);