APPS.JTF_UM_APPROVAL_REQUESTS_PVT_W dependencies on JTF_UM_APPROVAL_REQUESTS_PVT

Line 1: PACKAGE BODY JTF_UM_APPROVAL_REQUESTS_PVT_W AS

1: PACKAGE BODY JTF_UM_APPROVAL_REQUESTS_PVT_W AS
2: /* $Header: JTFWAPRB.pls 120.4 2009/06/15 11:37:07 kkasibha ship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

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 138: ddx_result jtf_um_approval_requests_pvt.approval_request_table_type;

134: , p2_a8 out nocopy JTF_NUMBER_TABLE
135: )
136:
137: as
138: ddx_result jtf_um_approval_requests_pvt.approval_request_table_type;
139: ddindx binary_integer; indx binary_integer;
140: begin
141:
142: -- copy data to the local IN or IN-OUT args, if any

Line 147: jtf_um_approval_requests_pvt.pending_approval_sysadmin(p_sort_order,

143:
144:
145:
146: -- here's the delegated call to the old PL/SQL routine
147: jtf_um_approval_requests_pvt.pending_approval_sysadmin(p_sort_order,
148: p_number_of_records,
149: ddx_result);
150:
151: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 154: jtf_um_approval_requests_pvt_w.rosetta_table_copy_out_p1(ddx_result, p2_a0

150:
151: -- copy data back from the local variables to OUT or IN-OUT args, if any
152:
153:
154: jtf_um_approval_requests_pvt_w.rosetta_table_copy_out_p1(ddx_result, p2_a0
155: , p2_a1
156: , p2_a2
157: , p2_a3
158: , p2_a4

Line 181: ddx_result jtf_um_approval_requests_pvt.approval_request_table_type;

177: , p3_a8 out nocopy JTF_NUMBER_TABLE
178: )
179:
180: as
181: ddx_result jtf_um_approval_requests_pvt.approval_request_table_type;
182: ddindx binary_integer; indx binary_integer;
183: begin
184:
185: -- copy data to the local IN or IN-OUT args, if any

Line 191: jtf_um_approval_requests_pvt.pending_approval_primary(p_sort_order,

187:
188:
189:
190: -- here's the delegated call to the old PL/SQL routine
191: jtf_um_approval_requests_pvt.pending_approval_primary(p_sort_order,
192: p_number_of_records,
193: p_approver_user_id,
194: ddx_result);
195:

Line 200: jtf_um_approval_requests_pvt_w.rosetta_table_copy_out_p1(ddx_result, p3_a0

196: -- copy data back from the local variables to OUT or IN-OUT args, if any
197:
198:
199:
200: jtf_um_approval_requests_pvt_w.rosetta_table_copy_out_p1(ddx_result, p3_a0
201: , p3_a1
202: , p3_a2
203: , p3_a3
204: , p3_a4

Line 227: ddx_result jtf_um_approval_requests_pvt.approval_request_table_type;

223: , p3_a8 out nocopy JTF_NUMBER_TABLE
224: )
225:
226: as
227: ddx_result jtf_um_approval_requests_pvt.approval_request_table_type;
228: ddindx binary_integer; indx binary_integer;
229: begin
230:
231: -- copy data to the local IN or IN-OUT args, if any

Line 237: jtf_um_approval_requests_pvt.pending_approval_owner(p_sort_order,

233:
234:
235:
236: -- here's the delegated call to the old PL/SQL routine
237: jtf_um_approval_requests_pvt.pending_approval_owner(p_sort_order,
238: p_number_of_records,
239: p_approver_user_id,
240: ddx_result);
241:

Line 246: jtf_um_approval_requests_pvt_w.rosetta_table_copy_out_p1(ddx_result, p3_a0

242: -- copy data back from the local variables to OUT or IN-OUT args, if any
243:
244:
245:
246: jtf_um_approval_requests_pvt_w.rosetta_table_copy_out_p1(ddx_result, p3_a0
247: , p3_a1
248: , p3_a2
249: , p3_a3
250: , p3_a4

Line 258: end jtf_um_approval_requests_pvt_w;

254: , p3_a8
255: );
256: end;
257:
258: end jtf_um_approval_requests_pvt_w;