eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_APPROVAL_PVT_OAW dependencies on OZF_APPROVAL_PVT

Line 1: package body ozf_approval_pvt_oaw as

1: package body ozf_approval_pvt_oaw as
2: /* $Header: ozfaappb.pls 115.1 2003/12/10 16:03:42 feliu noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ozf_approval_pvt.action_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy ozf_approval_pvt.action_tbl_type, a0 JTF_VARCHAR2_TABLE_100

1: package body ozf_approval_pvt_oaw as
2: /* $Header: ozfaappb.pls 115.1 2003/12/10 16:03:42 feliu noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ozf_approval_pvt.action_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE

Line 12: t := ozf_approval_pvt.action_tbl_type();

8: ) as
9: ddindx binary_integer; indx binary_integer;
10: begin
11: if a0 is not null and a0.count=0 then
12: t := ozf_approval_pvt.action_tbl_type();
13: elsif a0 is not null and a0.count > 0 then
14: if a0.count > 0 then
15: t := ozf_approval_pvt.action_tbl_type();
16: t.extend(a0.count);

Line 15: t := ozf_approval_pvt.action_tbl_type();

11: if a0 is not null and a0.count=0 then
12: t := ozf_approval_pvt.action_tbl_type();
13: elsif a0 is not null and a0.count > 0 then
14: if a0.count > 0 then
15: t := ozf_approval_pvt.action_tbl_type();
16: t.extend(a0.count);
17: indx := a0.first;
18: ddindx := 1;
19: while true loop

Line 34: procedure rosetta_table_copy_out_p1(t ozf_approval_pvt.action_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

30: end loop;
31: end if;
32: end if;
33: end rosetta_table_copy_in_p1;
34: procedure rosetta_table_copy_out_p1(t ozf_approval_pvt.action_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_VARCHAR2_TABLE_100
37: , a3 out nocopy JTF_VARCHAR2_TABLE_100
38: , a4 out nocopy JTF_NUMBER_TABLE

Line 84: procedure rosetta_table_copy_in_p3(t out nocopy ozf_approval_pvt.approvers_tbl_type, a0 JTF_VARCHAR2_TABLE_100

80: end if;
81: end if;
82: end rosetta_table_copy_out_p1;
83:
84: procedure rosetta_table_copy_in_p3(t out nocopy ozf_approval_pvt.approvers_tbl_type, a0 JTF_VARCHAR2_TABLE_100
85: , a1 JTF_NUMBER_TABLE
86: , a2 JTF_NUMBER_TABLE
87: ) as
88: ddindx binary_integer; indx binary_integer;

Line 91: t := ozf_approval_pvt.approvers_tbl_type();

87: ) as
88: ddindx binary_integer; indx binary_integer;
89: begin
90: if a0 is not null and a0.count=0 then
91: t := ozf_approval_pvt.approvers_tbl_type();
92: elsif a0 is not null and a0.count > 0 then
93: if a0.count > 0 then
94: t := ozf_approval_pvt.approvers_tbl_type();
95: t.extend(a0.count);

Line 94: t := ozf_approval_pvt.approvers_tbl_type();

90: if a0 is not null and a0.count=0 then
91: t := ozf_approval_pvt.approvers_tbl_type();
92: elsif a0 is not null and a0.count > 0 then
93: if a0.count > 0 then
94: t := ozf_approval_pvt.approvers_tbl_type();
95: t.extend(a0.count);
96: indx := a0.first;
97: ddindx := 1;
98: while true loop

Line 111: procedure rosetta_table_copy_out_p3(t ozf_approval_pvt.approvers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

107: end loop;
108: end if;
109: end if;
110: end rosetta_table_copy_in_p3;
111: procedure rosetta_table_copy_out_p3(t ozf_approval_pvt.approvers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
112: , a1 out nocopy JTF_NUMBER_TABLE
113: , a2 out nocopy JTF_NUMBER_TABLE
114: ) as
115: ddindx binary_integer; indx binary_integer;

Line 163: ddp_approval_rec ozf_approval_pvt.approval_rec_type;

159: , p6_a4 NUMBER
160: )
161:
162: as
163: ddp_approval_rec ozf_approval_pvt.approval_rec_type;
164: ddindx binary_integer; indx binary_integer;
165: begin
166:
167: -- copy data to the local IN or IN-OUT args, if any

Line 181: ozf_approval_pvt.update_user_action(p_api_version,

177: ddp_approval_rec.action_code := p6_a3;
178: ddp_approval_rec.action_performed_by := p6_a4;
179:
180: -- here's the delegated call to the old PL/SQL routine
181: ozf_approval_pvt.update_user_action(p_api_version,
182: p_init_msg_list,
183: p_validation_level,
184: x_return_status,
185: x_msg_data,

Line 216: ddp_approval_rec ozf_approval_pvt.approval_rec_type;

212: , x_final_approval_flag out nocopy VARCHAR2
213: )
214:
215: as
216: ddp_approval_rec ozf_approval_pvt.approval_rec_type;
217: ddx_approvers ozf_approval_pvt.approvers_tbl_type;
218: ddindx binary_integer; indx binary_integer;
219: begin
220:

Line 217: ddx_approvers ozf_approval_pvt.approvers_tbl_type;

213: )
214:
215: as
216: ddp_approval_rec ozf_approval_pvt.approval_rec_type;
217: ddx_approvers ozf_approval_pvt.approvers_tbl_type;
218: ddindx binary_integer; indx binary_integer;
219: begin
220:
221: -- copy data to the local IN or IN-OUT args, if any

Line 237: ozf_approval_pvt.get_approvers(p_api_version,

233:
234:
235:
236: -- here's the delegated call to the old PL/SQL routine
237: ozf_approval_pvt.get_approvers(p_api_version,
238: p_init_msg_list,
239: p_validation_level,
240: x_return_status,
241: x_msg_data,

Line 255: ozf_approval_pvt_oaw.rosetta_table_copy_out_p3(ddx_approvers, p7_a0

251:
252:
253:
254:
255: ozf_approval_pvt_oaw.rosetta_table_copy_out_p3(ddx_approvers, p7_a0
256: , p7_a1
257: , p7_a2
258: );
259:

Line 280: ddp_approval_rec ozf_approval_pvt.approval_rec_type;

276: , p8_a2 JTF_NUMBER_TABLE
277: )
278:
279: as
280: ddp_approval_rec ozf_approval_pvt.approval_rec_type;
281: ddp_approvers ozf_approval_pvt.approvers_tbl_type;
282: ddindx binary_integer; indx binary_integer;
283: begin
284:

Line 281: ddp_approvers ozf_approval_pvt.approvers_tbl_type;

277: )
278:
279: as
280: ddp_approval_rec ozf_approval_pvt.approval_rec_type;
281: ddp_approvers ozf_approval_pvt.approvers_tbl_type;
282: ddindx binary_integer; indx binary_integer;
283: begin
284:
285: -- copy data to the local IN or IN-OUT args, if any

Line 299: ozf_approval_pvt_oaw.rosetta_table_copy_in_p3(ddp_approvers, p8_a0

295: ddp_approval_rec.status_code := p7_a2;
296: ddp_approval_rec.action_code := p7_a3;
297: ddp_approval_rec.action_performed_by := p7_a4;
298:
299: ozf_approval_pvt_oaw.rosetta_table_copy_in_p3(ddp_approvers, p8_a0
300: , p8_a1
301: , p8_a2
302: );
303:

Line 305: ozf_approval_pvt.add_access(p_api_version,

301: , p8_a2
302: );
303:
304: -- here's the delegated call to the old PL/SQL routine
305: ozf_approval_pvt.add_access(p_api_version,
306: p_init_msg_list,
307: p_commit,
308: p_validation_level,
309: x_msg_data,

Line 339: ddp_approval_rec ozf_approval_pvt.approval_rec_type;

335: , p5_a4 NUMBER
336: )
337:
338: as
339: ddp_approval_rec ozf_approval_pvt.approval_rec_type;
340: ddindx binary_integer; indx binary_integer;
341: begin
342:
343: -- copy data to the local IN or IN-OUT args, if any

Line 356: ozf_approval_pvt.raise_event(x_return_status,

352: ddp_approval_rec.action_code := p5_a3;
353: ddp_approval_rec.action_performed_by := p5_a4;
354:
355: -- here's the delegated call to the old PL/SQL routine
356: ozf_approval_pvt.raise_event(x_return_status,
357: x_msg_data,
358: x_msg_count,
359: p_event_name,
360: p_event_key,

Line 390: ddp_approval_rec ozf_approval_pvt.approval_rec_type;

386: , p11_a4 NUMBER
387: )
388:
389: as
390: ddp_approval_rec ozf_approval_pvt.approval_rec_type;
391: ddindx binary_integer; indx binary_integer;
392: begin
393:
394: -- copy data to the local IN or IN-OUT args, if any

Line 413: ozf_approval_pvt.send_notification(p_api_version,

409: ddp_approval_rec.action_code := p11_a3;
410: ddp_approval_rec.action_performed_by := p11_a4;
411:
412: -- here's the delegated call to the old PL/SQL routine
413: ozf_approval_pvt.send_notification(p_api_version,
414: p_init_msg_list,
415: p_commit,
416: p_validation_level,
417: x_return_status,

Line 457: ddp_approval_rec ozf_approval_pvt.approval_rec_type;

453: , x_final_approval_flag out nocopy VARCHAR2
454: )
455:
456: as
457: ddp_approval_rec ozf_approval_pvt.approval_rec_type;
458: ddindx binary_integer; indx binary_integer;
459: begin
460:
461: -- copy data to the local IN or IN-OUT args, if any

Line 478: ozf_approval_pvt.process_user_action(p_api_version,

474:
475:
476:
477: -- here's the delegated call to the old PL/SQL routine
478: ozf_approval_pvt.process_user_action(p_api_version,
479: p_init_msg_list,
480: p_commit,
481: p_validation_level,
482: x_return_status,

Line 501: end ozf_approval_pvt_oaw;

497:
498:
499: end;
500:
501: end ozf_approval_pvt_oaw;