DBA Data[Home] [Help]

APPS.JTF_UM_APPROVAL_REQUESTS_PVT_W dependencies on JTF_VARCHAR2_TABLE_400

Line 27: , a2 JTF_VARCHAR2_TABLE_400

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
31: , a6 JTF_NUMBER_TABLE

Line 62: , a2 out nocopy JTF_VARCHAR2_TABLE_400

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
66: , a6 out nocopy JTF_NUMBER_TABLE

Line 75: a2 := JTF_VARCHAR2_TABLE_400();

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();
79: a6 := JTF_NUMBER_TABLE();

Line 85: a2 := JTF_VARCHAR2_TABLE_400();

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();
89: a6 := JTF_NUMBER_TABLE();

Line 128: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_400

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
132: , p2_a6 out nocopy JTF_NUMBER_TABLE

Line 171: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_400

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
175: , p3_a6 out nocopy JTF_NUMBER_TABLE

Line 217: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_400

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
221: , p3_a6 out nocopy JTF_NUMBER_TABLE