APPS.JTF_UM_APPROVAL_REQUESTS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 26: , a1 JTF_VARCHAR2_TABLE_100

22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p1(t out nocopy jtf_um_approval_requests_pvt.approval_request_table_type, a0 JTF_DATE_TABLE
26: , a1 JTF_VARCHAR2_TABLE_100
27: , a2 JTF_VARCHAR2_TABLE_400
28: , a3 JTF_VARCHAR2_TABLE_100
29: , a4 JTF_VARCHAR2_TABLE_1000
30: , a5 JTF_VARCHAR2_TABLE_100

Line 28: , a3 JTF_VARCHAR2_TABLE_100

24:
25: procedure rosetta_table_copy_in_p1(t out nocopy jtf_um_approval_requests_pvt.approval_request_table_type, a0 JTF_DATE_TABLE
26: , a1 JTF_VARCHAR2_TABLE_100
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

Line 29: , a4 JTF_VARCHAR2_TABLE_1000

25: procedure rosetta_table_copy_in_p1(t out nocopy jtf_um_approval_requests_pvt.approval_request_table_type, a0 JTF_DATE_TABLE
26: , a1 JTF_VARCHAR2_TABLE_100
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

Line 30: , a5 JTF_VARCHAR2_TABLE_100

26: , a1 JTF_VARCHAR2_TABLE_100
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

Line 32: , a7 JTF_VARCHAR2_TABLE_100

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;
36: begin

Line 61: , a1 out nocopy JTF_VARCHAR2_TABLE_100

57: end if;
58: end if;
59: end rosetta_table_copy_in_p1;
60: procedure rosetta_table_copy_out_p1(t jtf_um_approval_requests_pvt.approval_request_table_type, a0 out nocopy JTF_DATE_TABLE
61: , a1 out nocopy JTF_VARCHAR2_TABLE_100
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

Line 63: , a3 out nocopy JTF_VARCHAR2_TABLE_100

59: end rosetta_table_copy_in_p1;
60: procedure rosetta_table_copy_out_p1(t jtf_um_approval_requests_pvt.approval_request_table_type, a0 out nocopy JTF_DATE_TABLE
61: , a1 out nocopy JTF_VARCHAR2_TABLE_100
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

Line 64: , a4 out nocopy JTF_VARCHAR2_TABLE_1000

60: procedure rosetta_table_copy_out_p1(t jtf_um_approval_requests_pvt.approval_request_table_type, a0 out nocopy JTF_DATE_TABLE
61: , a1 out nocopy JTF_VARCHAR2_TABLE_100
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

Line 65: , a5 out nocopy JTF_VARCHAR2_TABLE_100

61: , a1 out nocopy JTF_VARCHAR2_TABLE_100
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

Line 67: , a7 out nocopy JTF_VARCHAR2_TABLE_100

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;
71: begin

Line 74: a1 := JTF_VARCHAR2_TABLE_100();

70: ddindx binary_integer; indx binary_integer;
71: begin
72: if t is null or t.count = 0 then
73: a0 := JTF_DATE_TABLE();
74: a1 := JTF_VARCHAR2_TABLE_100();
75: a2 := JTF_VARCHAR2_TABLE_400();
76: a3 := JTF_VARCHAR2_TABLE_100();
77: a4 := JTF_VARCHAR2_TABLE_1000();
78: a5 := JTF_VARCHAR2_TABLE_100();

Line 76: a3 := JTF_VARCHAR2_TABLE_100();

72: if t is null or t.count = 0 then
73: a0 := JTF_DATE_TABLE();
74: a1 := JTF_VARCHAR2_TABLE_100();
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();

Line 77: a4 := JTF_VARCHAR2_TABLE_1000();

73: a0 := JTF_DATE_TABLE();
74: a1 := JTF_VARCHAR2_TABLE_100();
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();

Line 78: a5 := JTF_VARCHAR2_TABLE_100();

74: a1 := JTF_VARCHAR2_TABLE_100();
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

Line 80: a7 := JTF_VARCHAR2_TABLE_100();

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();
84: a1 := JTF_VARCHAR2_TABLE_100();

Line 84: a1 := JTF_VARCHAR2_TABLE_100();

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();
86: a3 := JTF_VARCHAR2_TABLE_100();
87: a4 := JTF_VARCHAR2_TABLE_1000();
88: a5 := JTF_VARCHAR2_TABLE_100();

Line 86: a3 := JTF_VARCHAR2_TABLE_100();

82: else
83: a0 := JTF_DATE_TABLE();
84: a1 := JTF_VARCHAR2_TABLE_100();
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();

Line 87: a4 := JTF_VARCHAR2_TABLE_1000();

83: a0 := JTF_DATE_TABLE();
84: a1 := JTF_VARCHAR2_TABLE_100();
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();

Line 88: a5 := JTF_VARCHAR2_TABLE_100();

84: a1 := JTF_VARCHAR2_TABLE_100();
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

Line 90: a7 := JTF_VARCHAR2_TABLE_100();

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);
94: a1.extend(t.count);

Line 127: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100

123:
124: procedure pending_approval_sysadmin(p_sort_order VARCHAR2
125: , p_number_of_records NUMBER
126: , p2_a0 out nocopy JTF_DATE_TABLE
127: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
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

Line 129: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100

125: , p_number_of_records NUMBER
126: , p2_a0 out nocopy JTF_DATE_TABLE
127: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
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

Line 130: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_1000

126: , p2_a0 out nocopy JTF_DATE_TABLE
127: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
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

Line 131: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100

127: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
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: )

Line 133: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_100

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:
137: as

Line 170: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100

166: procedure pending_approval_primary(p_sort_order VARCHAR2
167: , p_number_of_records NUMBER
168: , p_approver_user_id NUMBER
169: , p3_a0 out nocopy JTF_DATE_TABLE
170: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
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

Line 172: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100

168: , p_approver_user_id NUMBER
169: , p3_a0 out nocopy JTF_DATE_TABLE
170: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
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

Line 173: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000

169: , p3_a0 out nocopy JTF_DATE_TABLE
170: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
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

Line 174: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100

170: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
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: )

Line 176: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100

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:
180: as

Line 216: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100

212: procedure pending_approval_owner(p_sort_order VARCHAR2
213: , p_number_of_records NUMBER
214: , p_approver_user_id NUMBER
215: , p3_a0 out nocopy JTF_DATE_TABLE
216: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
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

Line 218: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100

214: , p_approver_user_id NUMBER
215: , p3_a0 out nocopy JTF_DATE_TABLE
216: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
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

Line 219: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000

215: , p3_a0 out nocopy JTF_DATE_TABLE
216: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
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

Line 220: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100

216: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
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: )

Line 222: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100

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:
226: as