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.2 2005/09/02 18:35:38 applrt 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:

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

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;
128: ddindx binary_integer; indx binary_integer;
129: begin
130:
131: -- copy data to the local IN or IN-OUT args, if any

Line 136: jtf_um_approval_requests_pvt.pending_approval_sysadmin(p_sort_order,

132:
133:
134:
135: -- here's the delegated call to the old PL/SQL routine
136: jtf_um_approval_requests_pvt.pending_approval_sysadmin(p_sort_order,
137: p_number_of_records,
138: ddx_result);
139:
140: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 143: jtf_um_approval_requests_pvt_w.rosetta_table_copy_out_p1(ddx_result, p2_a0

139:
140: -- copy data back from the local variables to OUT or IN-OUT args, if any
141:
142:
143: jtf_um_approval_requests_pvt_w.rosetta_table_copy_out_p1(ddx_result, p2_a0
144: , p2_a1
145: , p2_a2
146: , p2_a3
147: , p2_a4

Line 168: ddx_result jtf_um_approval_requests_pvt.approval_request_table_type;

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;
169: ddindx binary_integer; indx binary_integer;
170: begin
171:
172: -- copy data to the local IN or IN-OUT args, if any

Line 178: jtf_um_approval_requests_pvt.pending_approval_primary(p_sort_order,

174:
175:
176:
177: -- here's the delegated call to the old PL/SQL routine
178: jtf_um_approval_requests_pvt.pending_approval_primary(p_sort_order,
179: p_number_of_records,
180: p_approver_user_id,
181: ddx_result);
182:

Line 187: jtf_um_approval_requests_pvt_w.rosetta_table_copy_out_p1(ddx_result, p3_a0

183: -- copy data back from the local variables to OUT or IN-OUT args, if any
184:
185:
186:
187: jtf_um_approval_requests_pvt_w.rosetta_table_copy_out_p1(ddx_result, p3_a0
188: , p3_a1
189: , p3_a2
190: , p3_a3
191: , p3_a4

Line 212: ddx_result jtf_um_approval_requests_pvt.approval_request_table_type;

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;
213: ddindx binary_integer; indx binary_integer;
214: begin
215:
216: -- copy data to the local IN or IN-OUT args, if any

Line 222: jtf_um_approval_requests_pvt.pending_approval_owner(p_sort_order,

218:
219:
220:
221: -- here's the delegated call to the old PL/SQL routine
222: jtf_um_approval_requests_pvt.pending_approval_owner(p_sort_order,
223: p_number_of_records,
224: p_approver_user_id,
225: ddx_result);
226:

Line 231: jtf_um_approval_requests_pvt_w.rosetta_table_copy_out_p1(ddx_result, p3_a0

227: -- copy data back from the local variables to OUT or IN-OUT args, if any
228:
229:
230:
231: jtf_um_approval_requests_pvt_w.rosetta_table_copy_out_p1(ddx_result, p3_a0
232: , p3_a1
233: , p3_a2
234: , p3_a3
235: , p3_a4

Line 242: end jtf_um_approval_requests_pvt_w;

238: , p3_a7
239: );
240: end;
241:
242: end jtf_um_approval_requests_pvt_w;