APPS.JTF_UM_APPROVAL_REQUESTS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 23: , a1 JTF_VARCHAR2_TABLE_100

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

Line 25: , a3 JTF_VARCHAR2_TABLE_100

21:
22: procedure rosetta_table_copy_in_p1(t out nocopy jtf_um_approval_requests_pvt.approval_request_table_type, a0 JTF_DATE_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_400
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_1000
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100

Line 26: , a4 JTF_VARCHAR2_TABLE_1000

22: procedure rosetta_table_copy_in_p1(t out nocopy jtf_um_approval_requests_pvt.approval_request_table_type, a0 JTF_DATE_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_400
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_1000
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: ) as

Line 27: , a5 JTF_VARCHAR2_TABLE_100

23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_400
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_1000
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: ) as
31: ddindx binary_integer; indx binary_integer;

Line 29: , a7 JTF_VARCHAR2_TABLE_100

25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_1000
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: ) as
31: ddindx binary_integer; indx binary_integer;
32: begin
33: if a0 is not null and a0.count > 0 then

Line 56: , a1 out nocopy JTF_VARCHAR2_TABLE_100

52: end if;
53: end if;
54: end rosetta_table_copy_in_p1;
55: procedure rosetta_table_copy_out_p1(t jtf_um_approval_requests_pvt.approval_request_table_type, a0 out nocopy JTF_DATE_TABLE
56: , a1 out nocopy JTF_VARCHAR2_TABLE_100
57: , a2 out nocopy JTF_VARCHAR2_TABLE_400
58: , a3 out nocopy JTF_VARCHAR2_TABLE_100
59: , a4 out nocopy JTF_VARCHAR2_TABLE_1000
60: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 58: , a3 out nocopy JTF_VARCHAR2_TABLE_100

54: end rosetta_table_copy_in_p1;
55: procedure rosetta_table_copy_out_p1(t jtf_um_approval_requests_pvt.approval_request_table_type, a0 out nocopy JTF_DATE_TABLE
56: , a1 out nocopy JTF_VARCHAR2_TABLE_100
57: , a2 out nocopy JTF_VARCHAR2_TABLE_400
58: , a3 out nocopy JTF_VARCHAR2_TABLE_100
59: , a4 out nocopy JTF_VARCHAR2_TABLE_1000
60: , a5 out nocopy JTF_VARCHAR2_TABLE_100
61: , a6 out nocopy JTF_NUMBER_TABLE
62: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 59: , a4 out nocopy JTF_VARCHAR2_TABLE_1000

55: procedure rosetta_table_copy_out_p1(t jtf_um_approval_requests_pvt.approval_request_table_type, a0 out nocopy JTF_DATE_TABLE
56: , a1 out nocopy JTF_VARCHAR2_TABLE_100
57: , a2 out nocopy JTF_VARCHAR2_TABLE_400
58: , a3 out nocopy JTF_VARCHAR2_TABLE_100
59: , a4 out nocopy JTF_VARCHAR2_TABLE_1000
60: , a5 out nocopy JTF_VARCHAR2_TABLE_100
61: , a6 out nocopy JTF_NUMBER_TABLE
62: , a7 out nocopy JTF_VARCHAR2_TABLE_100
63: ) as

Line 60: , a5 out nocopy JTF_VARCHAR2_TABLE_100

56: , a1 out nocopy JTF_VARCHAR2_TABLE_100
57: , a2 out nocopy JTF_VARCHAR2_TABLE_400
58: , a3 out nocopy JTF_VARCHAR2_TABLE_100
59: , a4 out nocopy JTF_VARCHAR2_TABLE_1000
60: , a5 out nocopy JTF_VARCHAR2_TABLE_100
61: , a6 out nocopy JTF_NUMBER_TABLE
62: , a7 out nocopy JTF_VARCHAR2_TABLE_100
63: ) as
64: ddindx binary_integer; indx binary_integer;

Line 62: , a7 out nocopy JTF_VARCHAR2_TABLE_100

58: , a3 out nocopy JTF_VARCHAR2_TABLE_100
59: , a4 out nocopy JTF_VARCHAR2_TABLE_1000
60: , a5 out nocopy JTF_VARCHAR2_TABLE_100
61: , a6 out nocopy JTF_NUMBER_TABLE
62: , a7 out nocopy JTF_VARCHAR2_TABLE_100
63: ) as
64: ddindx binary_integer; indx binary_integer;
65: begin
66: if t is null or t.count = 0 then

Line 68: a1 := JTF_VARCHAR2_TABLE_100();

64: ddindx binary_integer; indx binary_integer;
65: begin
66: if t is null or t.count = 0 then
67: a0 := JTF_DATE_TABLE();
68: a1 := JTF_VARCHAR2_TABLE_100();
69: a2 := JTF_VARCHAR2_TABLE_400();
70: a3 := JTF_VARCHAR2_TABLE_100();
71: a4 := JTF_VARCHAR2_TABLE_1000();
72: a5 := JTF_VARCHAR2_TABLE_100();

Line 70: a3 := JTF_VARCHAR2_TABLE_100();

66: if t is null or t.count = 0 then
67: a0 := JTF_DATE_TABLE();
68: a1 := JTF_VARCHAR2_TABLE_100();
69: a2 := JTF_VARCHAR2_TABLE_400();
70: a3 := JTF_VARCHAR2_TABLE_100();
71: a4 := JTF_VARCHAR2_TABLE_1000();
72: a5 := JTF_VARCHAR2_TABLE_100();
73: a6 := JTF_NUMBER_TABLE();
74: a7 := JTF_VARCHAR2_TABLE_100();

Line 71: a4 := JTF_VARCHAR2_TABLE_1000();

67: a0 := JTF_DATE_TABLE();
68: a1 := JTF_VARCHAR2_TABLE_100();
69: a2 := JTF_VARCHAR2_TABLE_400();
70: a3 := JTF_VARCHAR2_TABLE_100();
71: a4 := JTF_VARCHAR2_TABLE_1000();
72: a5 := JTF_VARCHAR2_TABLE_100();
73: a6 := JTF_NUMBER_TABLE();
74: a7 := JTF_VARCHAR2_TABLE_100();
75: else

Line 72: a5 := JTF_VARCHAR2_TABLE_100();

68: a1 := JTF_VARCHAR2_TABLE_100();
69: a2 := JTF_VARCHAR2_TABLE_400();
70: a3 := JTF_VARCHAR2_TABLE_100();
71: a4 := JTF_VARCHAR2_TABLE_1000();
72: a5 := JTF_VARCHAR2_TABLE_100();
73: a6 := JTF_NUMBER_TABLE();
74: a7 := JTF_VARCHAR2_TABLE_100();
75: else
76: a0 := JTF_DATE_TABLE();

Line 74: a7 := JTF_VARCHAR2_TABLE_100();

70: a3 := JTF_VARCHAR2_TABLE_100();
71: a4 := JTF_VARCHAR2_TABLE_1000();
72: a5 := JTF_VARCHAR2_TABLE_100();
73: a6 := JTF_NUMBER_TABLE();
74: a7 := JTF_VARCHAR2_TABLE_100();
75: else
76: a0 := JTF_DATE_TABLE();
77: a1 := JTF_VARCHAR2_TABLE_100();
78: a2 := JTF_VARCHAR2_TABLE_400();

Line 77: a1 := JTF_VARCHAR2_TABLE_100();

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

Line 79: a3 := JTF_VARCHAR2_TABLE_100();

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

Line 80: a4 := JTF_VARCHAR2_TABLE_1000();

76: a0 := JTF_DATE_TABLE();
77: a1 := JTF_VARCHAR2_TABLE_100();
78: a2 := JTF_VARCHAR2_TABLE_400();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_VARCHAR2_TABLE_1000();
81: a5 := JTF_VARCHAR2_TABLE_100();
82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_VARCHAR2_TABLE_100();
84: if t.count > 0 then

Line 81: a5 := JTF_VARCHAR2_TABLE_100();

77: a1 := JTF_VARCHAR2_TABLE_100();
78: a2 := JTF_VARCHAR2_TABLE_400();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_VARCHAR2_TABLE_1000();
81: a5 := JTF_VARCHAR2_TABLE_100();
82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_VARCHAR2_TABLE_100();
84: if t.count > 0 then
85: a0.extend(t.count);

Line 83: a7 := JTF_VARCHAR2_TABLE_100();

79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_VARCHAR2_TABLE_1000();
81: a5 := JTF_VARCHAR2_TABLE_100();
82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_VARCHAR2_TABLE_100();
84: if t.count > 0 then
85: a0.extend(t.count);
86: a1.extend(t.count);
87: a2.extend(t.count);

Line 117: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100

113:
114: procedure pending_approval_sysadmin(p_sort_order VARCHAR2
115: , p_number_of_records NUMBER
116: , p2_a0 out nocopy JTF_DATE_TABLE
117: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
118: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_400
119: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
120: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_1000
121: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 119: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100

115: , p_number_of_records NUMBER
116: , p2_a0 out nocopy JTF_DATE_TABLE
117: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
118: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_400
119: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
120: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_1000
121: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
122: , p2_a6 out nocopy JTF_NUMBER_TABLE
123: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 120: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_1000

116: , p2_a0 out nocopy JTF_DATE_TABLE
117: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
118: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_400
119: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
120: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_1000
121: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
122: , p2_a6 out nocopy JTF_NUMBER_TABLE
123: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_100
124: )

Line 121: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100

117: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
118: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_400
119: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
120: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_1000
121: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
122: , p2_a6 out nocopy JTF_NUMBER_TABLE
123: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_100
124: )
125:

Line 123: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_100

119: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
120: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_1000
121: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
122: , p2_a6 out nocopy JTF_NUMBER_TABLE
123: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_100
124: )
125:
126: as
127: ddx_result jtf_um_approval_requests_pvt.approval_request_table_type;

Line 158: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100

154: procedure pending_approval_primary(p_sort_order VARCHAR2
155: , p_number_of_records NUMBER
156: , p_approver_user_id NUMBER
157: , p3_a0 out nocopy JTF_DATE_TABLE
158: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
159: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_400
160: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
161: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000
162: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 160: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100

156: , p_approver_user_id NUMBER
157: , p3_a0 out nocopy JTF_DATE_TABLE
158: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
159: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_400
160: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
161: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000
162: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
163: , p3_a6 out nocopy JTF_NUMBER_TABLE
164: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 161: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000

157: , p3_a0 out nocopy JTF_DATE_TABLE
158: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
159: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_400
160: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
161: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000
162: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
163: , p3_a6 out nocopy JTF_NUMBER_TABLE
164: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
165: )

Line 162: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100

158: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
159: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_400
160: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
161: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000
162: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
163: , p3_a6 out nocopy JTF_NUMBER_TABLE
164: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
165: )
166:

Line 164: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100

160: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
161: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000
162: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
163: , p3_a6 out nocopy JTF_NUMBER_TABLE
164: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
165: )
166:
167: as
168: ddx_result jtf_um_approval_requests_pvt.approval_request_table_type;

Line 202: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100

198: procedure pending_approval_owner(p_sort_order VARCHAR2
199: , p_number_of_records NUMBER
200: , p_approver_user_id NUMBER
201: , p3_a0 out nocopy JTF_DATE_TABLE
202: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
203: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_400
204: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
205: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000
206: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 204: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100

200: , p_approver_user_id NUMBER
201: , p3_a0 out nocopy JTF_DATE_TABLE
202: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
203: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_400
204: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
205: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000
206: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
207: , p3_a6 out nocopy JTF_NUMBER_TABLE
208: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 205: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000

201: , p3_a0 out nocopy JTF_DATE_TABLE
202: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
203: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_400
204: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
205: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000
206: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
207: , p3_a6 out nocopy JTF_NUMBER_TABLE
208: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
209: )

Line 206: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100

202: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
203: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_400
204: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
205: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000
206: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
207: , p3_a6 out nocopy JTF_NUMBER_TABLE
208: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
209: )
210:

Line 208: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100

204: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
205: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_1000
206: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
207: , p3_a6 out nocopy JTF_NUMBER_TABLE
208: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
209: )
210:
211: as
212: ddx_result jtf_um_approval_requests_pvt.approval_request_table_type;