DBA Data[Home] [Help]

APPS.JTF_UM_APPROVAL_REQUESTS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 31: , a6 JTF_NUMBER_TABLE

27: , a2 JTF_VARCHAR2_TABLE_400
28: , a3 JTF_VARCHAR2_TABLE_100
29: , a4 JTF_VARCHAR2_TABLE_1000
30: , a5 JTF_VARCHAR2_TABLE_100
31: , a6 JTF_NUMBER_TABLE
32: , a7 JTF_VARCHAR2_TABLE_100
33: , a8 JTF_NUMBER_TABLE
34: ) as
35: ddindx binary_integer; indx binary_integer;

Line 33: , a8 JTF_NUMBER_TABLE

29: , a4 JTF_VARCHAR2_TABLE_1000
30: , a5 JTF_VARCHAR2_TABLE_100
31: , a6 JTF_NUMBER_TABLE
32: , a7 JTF_VARCHAR2_TABLE_100
33: , a8 JTF_NUMBER_TABLE
34: ) as
35: ddindx binary_integer; indx binary_integer;
36: begin
37: if a0 is not null and a0.count > 0 then

Line 66: , a6 out nocopy JTF_NUMBER_TABLE

62: , a2 out nocopy JTF_VARCHAR2_TABLE_400
63: , a3 out nocopy JTF_VARCHAR2_TABLE_100
64: , a4 out nocopy JTF_VARCHAR2_TABLE_1000
65: , a5 out nocopy JTF_VARCHAR2_TABLE_100
66: , a6 out nocopy JTF_NUMBER_TABLE
67: , a7 out nocopy JTF_VARCHAR2_TABLE_100
68: , a8 out nocopy JTF_NUMBER_TABLE
69: ) as
70: ddindx binary_integer; indx binary_integer;

Line 68: , a8 out nocopy JTF_NUMBER_TABLE

64: , a4 out nocopy JTF_VARCHAR2_TABLE_1000
65: , a5 out nocopy JTF_VARCHAR2_TABLE_100
66: , a6 out nocopy JTF_NUMBER_TABLE
67: , a7 out nocopy JTF_VARCHAR2_TABLE_100
68: , a8 out nocopy JTF_NUMBER_TABLE
69: ) as
70: ddindx binary_integer; indx binary_integer;
71: begin
72: if t is null or t.count = 0 then

Line 79: a6 := JTF_NUMBER_TABLE();

75: a2 := JTF_VARCHAR2_TABLE_400();
76: a3 := JTF_VARCHAR2_TABLE_100();
77: a4 := JTF_VARCHAR2_TABLE_1000();
78: a5 := JTF_VARCHAR2_TABLE_100();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_VARCHAR2_TABLE_100();
81: a8 := JTF_NUMBER_TABLE();
82: else
83: a0 := JTF_DATE_TABLE();

Line 81: a8 := JTF_NUMBER_TABLE();

77: a4 := JTF_VARCHAR2_TABLE_1000();
78: a5 := JTF_VARCHAR2_TABLE_100();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_VARCHAR2_TABLE_100();
81: a8 := JTF_NUMBER_TABLE();
82: else
83: a0 := JTF_DATE_TABLE();
84: a1 := JTF_VARCHAR2_TABLE_100();
85: a2 := JTF_VARCHAR2_TABLE_400();

Line 89: a6 := JTF_NUMBER_TABLE();

85: a2 := JTF_VARCHAR2_TABLE_400();
86: a3 := JTF_VARCHAR2_TABLE_100();
87: a4 := JTF_VARCHAR2_TABLE_1000();
88: a5 := JTF_VARCHAR2_TABLE_100();
89: a6 := JTF_NUMBER_TABLE();
90: a7 := JTF_VARCHAR2_TABLE_100();
91: a8 := JTF_NUMBER_TABLE();
92: if t.count > 0 then
93: a0.extend(t.count);

Line 91: a8 := JTF_NUMBER_TABLE();

87: a4 := JTF_VARCHAR2_TABLE_1000();
88: a5 := JTF_VARCHAR2_TABLE_100();
89: a6 := JTF_NUMBER_TABLE();
90: a7 := JTF_VARCHAR2_TABLE_100();
91: a8 := JTF_NUMBER_TABLE();
92: if t.count > 0 then
93: a0.extend(t.count);
94: a1.extend(t.count);
95: a2.extend(t.count);

Line 132: , p2_a6 out nocopy JTF_NUMBER_TABLE

128: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_400
129: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
130: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_1000
131: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
132: , p2_a6 out nocopy JTF_NUMBER_TABLE
133: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_100
134: , p2_a8 out nocopy JTF_NUMBER_TABLE
135: )
136:

Line 134: , p2_a8 out nocopy JTF_NUMBER_TABLE

130: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_1000
131: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
132: , p2_a6 out nocopy JTF_NUMBER_TABLE
133: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_100
134: , p2_a8 out nocopy JTF_NUMBER_TABLE
135: )
136:
137: as
138: ddx_result jtf_um_approval_requests_pvt.approval_request_table_type;

Line 175: , p3_a6 out nocopy JTF_NUMBER_TABLE

171: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_400
172: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
173: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000
174: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
175: , p3_a6 out nocopy JTF_NUMBER_TABLE
176: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
177: , p3_a8 out nocopy JTF_NUMBER_TABLE
178: )
179:

Line 177: , p3_a8 out nocopy JTF_NUMBER_TABLE

173: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000
174: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
175: , p3_a6 out nocopy JTF_NUMBER_TABLE
176: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
177: , p3_a8 out nocopy JTF_NUMBER_TABLE
178: )
179:
180: as
181: ddx_result jtf_um_approval_requests_pvt.approval_request_table_type;

Line 221: , p3_a6 out nocopy JTF_NUMBER_TABLE

217: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_400
218: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
219: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000
220: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
221: , p3_a6 out nocopy JTF_NUMBER_TABLE
222: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
223: , p3_a8 out nocopy JTF_NUMBER_TABLE
224: )
225:

Line 223: , p3_a8 out nocopy JTF_NUMBER_TABLE

219: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000
220: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
221: , p3_a6 out nocopy JTF_NUMBER_TABLE
222: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
223: , p3_a8 out nocopy JTF_NUMBER_TABLE
224: )
225:
226: as
227: ddx_result jtf_um_approval_requests_pvt.approval_request_table_type;