APPS.JTF_UM_APPROVAL_REQUESTS_PVT_W dependencies on JTF_DATE_TABLE

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

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

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

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

Line 67: a0 := JTF_DATE_TABLE();

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

Line 76: a0 := JTF_DATE_TABLE();

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

Line 116: , p2_a0 out nocopy JTF_DATE_TABLE

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

Line 157: , p3_a0 out nocopy JTF_DATE_TABLE

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

Line 201: , p3_a0 out nocopy JTF_DATE_TABLE

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