APPS.JTF_UM_APPROVAL_REQUESTS_PVT_W dependencies on JTF_DATE_TABLE

Line 25: procedure rosetta_table_copy_in_p1(t out nocopy jtf_um_approval_requests_pvt.approval_request_table_type, a0 JTF_DATE_TABLE

21: if n=b then return a; end if;
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

Line 60: procedure rosetta_table_copy_out_p1(t jtf_um_approval_requests_pvt.approval_request_table_type, a0 out nocopy JTF_DATE_TABLE

56: end loop;
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

Line 73: a0 := JTF_DATE_TABLE();

69: ) as
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();

Line 83: a0 := JTF_DATE_TABLE();

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

Line 126: , p2_a0 out nocopy JTF_DATE_TABLE

122: end rosetta_table_copy_out_p1;
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

Line 169: , p3_a0 out nocopy JTF_DATE_TABLE

165:
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

Line 215: , p3_a0 out nocopy JTF_DATE_TABLE

211:
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