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.AMV_PERSPECTIVE_PVT_W dependencies on AMV_PERSPECTIVE_PVT

Line 1: package body amv_perspective_pvt_w as

1: package body amv_perspective_pvt_w as
2: /* $Header: amvwpspb.pls 120.2 2005/06/30 08:30 appldev 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 amv_perspective_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE) as

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 amv_perspective_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE) as
23: ddindx binary_integer; indx binary_integer;
24: begin
25: if a0 is null then
26: t := null;

Line 28: t := amv_perspective_pvt.amv_number_varray_type();

24: begin
25: if a0 is null then
26: t := null;
27: elsif a0.count = 0 then
28: t := amv_perspective_pvt.amv_number_varray_type();
29: else
30: if a0.count > 0 then
31: t := amv_perspective_pvt.amv_number_varray_type();
32: t.extend(a0.count);

Line 31: t := amv_perspective_pvt.amv_number_varray_type();

27: elsif a0.count = 0 then
28: t := amv_perspective_pvt.amv_number_varray_type();
29: else
30: if a0.count > 0 then
31: t := amv_perspective_pvt.amv_number_varray_type();
32: t.extend(a0.count);
33: indx := a0.first;
34: ddindx := 1;
35: while true loop

Line 46: procedure rosetta_table_copy_out_p1(t amv_perspective_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE) as

42: end loop;
43: end if;
44: end if;
45: end rosetta_table_copy_in_p1;
46: procedure rosetta_table_copy_out_p1(t amv_perspective_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE) as
47: ddindx binary_integer; indx binary_integer;
48: begin
49: if t is null then
50: a0 := null;

Line 71: procedure rosetta_table_copy_in_p5(t out nocopy amv_perspective_pvt.amv_perspective_obj_varray, a0 JTF_NUMBER_TABLE

67: end if;
68: end if;
69: end rosetta_table_copy_out_p1;
70:
71: procedure rosetta_table_copy_in_p5(t out nocopy amv_perspective_pvt.amv_perspective_obj_varray, a0 JTF_NUMBER_TABLE
72: , a1 JTF_NUMBER_TABLE
73: , a2 JTF_VARCHAR2_TABLE_100
74: , a3 JTF_VARCHAR2_TABLE_2000
75: , a4 JTF_VARCHAR2_TABLE_100

Line 86: t := amv_perspective_pvt.amv_perspective_obj_varray();

82: ) as
83: ddindx binary_integer; indx binary_integer;
84: begin
85: if a0 is not null and a0.count=0 then
86: t := amv_perspective_pvt.amv_perspective_obj_varray();
87: elsif a0 is not null and a0.count > 0 then
88: if a0.count > 0 then
89: t := amv_perspective_pvt.amv_perspective_obj_varray();
90: t.extend(a0.count);

Line 89: t := amv_perspective_pvt.amv_perspective_obj_varray();

85: if a0 is not null and a0.count=0 then
86: t := amv_perspective_pvt.amv_perspective_obj_varray();
87: elsif a0 is not null and a0.count > 0 then
88: if a0.count > 0 then
89: t := amv_perspective_pvt.amv_perspective_obj_varray();
90: t.extend(a0.count);
91: indx := a0.first;
92: ddindx := 1;
93: while true loop

Line 114: procedure rosetta_table_copy_out_p5(t amv_perspective_pvt.amv_perspective_obj_varray, a0 out nocopy JTF_NUMBER_TABLE

110: end loop;
111: end if;
112: end if;
113: end rosetta_table_copy_in_p5;
114: procedure rosetta_table_copy_out_p5(t amv_perspective_pvt.amv_perspective_obj_varray, a0 out nocopy JTF_NUMBER_TABLE
115: , a1 out nocopy JTF_NUMBER_TABLE
116: , a2 out nocopy JTF_VARCHAR2_TABLE_100
117: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
118: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 223: ddx_perspective_obj amv_perspective_pvt.amv_perspective_obj_type;

219: , p9_a10 out nocopy NUMBER
220: )
221:
222: as
223: ddx_perspective_obj amv_perspective_pvt.amv_perspective_obj_type;
224: ddindx binary_integer; indx binary_integer;
225: begin
226:
227: -- copy data to the local IN or IN-OUT args, if any

Line 239: amv_perspective_pvt.get_perspective(p_api_version,

235:
236:
237:
238: -- here's the delegated call to the old PL/SQL routine
239: amv_perspective_pvt.get_perspective(p_api_version,
240: p_init_msg_list,
241: p_validation_level,
242: x_return_status,
243: x_msg_count,

Line 302: ddp_subset_request_obj amv_perspective_pvt.amv_request_obj_type;

298: , p9_a2 VARCHAR2 := fnd_api.g_miss_char
299: )
300:
301: as
302: ddp_subset_request_obj amv_perspective_pvt.amv_request_obj_type;
303: ddx_subset_return_obj amv_perspective_pvt.amv_return_obj_type;
304: ddx_perspective_obj_varray amv_perspective_pvt.amv_perspective_obj_varray;
305: ddindx binary_integer; indx binary_integer;
306: begin

Line 303: ddx_subset_return_obj amv_perspective_pvt.amv_return_obj_type;

299: )
300:
301: as
302: ddp_subset_request_obj amv_perspective_pvt.amv_request_obj_type;
303: ddx_subset_return_obj amv_perspective_pvt.amv_return_obj_type;
304: ddx_perspective_obj_varray amv_perspective_pvt.amv_perspective_obj_varray;
305: ddindx binary_integer; indx binary_integer;
306: begin
307:

Line 304: ddx_perspective_obj_varray amv_perspective_pvt.amv_perspective_obj_varray;

300:
301: as
302: ddp_subset_request_obj amv_perspective_pvt.amv_request_obj_type;
303: ddx_subset_return_obj amv_perspective_pvt.amv_return_obj_type;
304: ddx_perspective_obj_varray amv_perspective_pvt.amv_perspective_obj_varray;
305: ddindx binary_integer; indx binary_integer;
306: begin
307:
308: -- copy data to the local IN or IN-OUT args, if any

Line 325: amv_perspective_pvt.find_perspective(p_api_version,

321:
322:
323:
324: -- here's the delegated call to the old PL/SQL routine
325: amv_perspective_pvt.find_perspective(p_api_version,
326: p_init_msg_list,
327: p_validation_level,
328: x_return_status,
329: x_msg_count,

Line 353: amv_perspective_pvt_w.rosetta_table_copy_out_p5(ddx_perspective_obj_varray, p11_a0

349: p10_a0 := rosetta_g_miss_num_map(ddx_subset_return_obj.returned_record_count);
350: p10_a1 := rosetta_g_miss_num_map(ddx_subset_return_obj.next_record_position);
351: p10_a2 := rosetta_g_miss_num_map(ddx_subset_return_obj.total_record_count);
352:
353: amv_perspective_pvt_w.rosetta_table_copy_out_p5(ddx_perspective_obj_varray, p11_a0
354: , p11_a1
355: , p11_a2
356: , p11_a3
357: , p11_a4

Line 380: ddp_perspective_array amv_perspective_pvt.amv_number_varray_type;

376: , p_perspective_array JTF_NUMBER_TABLE
377: )
378:
379: as
380: ddp_perspective_array amv_perspective_pvt.amv_number_varray_type;
381: ddindx binary_integer; indx binary_integer;
382: begin
383:
384: -- copy data to the local IN or IN-OUT args, if any

Line 394: amv_perspective_pvt_w.rosetta_table_copy_in_p1(ddp_perspective_array, p_perspective_array);

390:
391:
392:
393:
394: amv_perspective_pvt_w.rosetta_table_copy_in_p1(ddp_perspective_array, p_perspective_array);
395:
396: -- here's the delegated call to the old PL/SQL routine
397: amv_perspective_pvt.add_itempersps(p_api_version,
398: p_init_msg_list,

Line 397: amv_perspective_pvt.add_itempersps(p_api_version,

393:
394: amv_perspective_pvt_w.rosetta_table_copy_in_p1(ddp_perspective_array, p_perspective_array);
395:
396: -- here's the delegated call to the old PL/SQL routine
397: amv_perspective_pvt.add_itempersps(p_api_version,
398: p_init_msg_list,
399: p_commit,
400: p_validation_level,
401: x_return_status,

Line 433: ddp_perspective_array amv_perspective_pvt.amv_number_varray_type;

429: , p_perspective_array JTF_NUMBER_TABLE
430: )
431:
432: as
433: ddp_perspective_array amv_perspective_pvt.amv_number_varray_type;
434: ddindx binary_integer; indx binary_integer;
435: begin
436:
437: -- copy data to the local IN or IN-OUT args, if any

Line 447: amv_perspective_pvt_w.rosetta_table_copy_in_p1(ddp_perspective_array, p_perspective_array);

443:
444:
445:
446:
447: amv_perspective_pvt_w.rosetta_table_copy_in_p1(ddp_perspective_array, p_perspective_array);
448:
449: -- here's the delegated call to the old PL/SQL routine
450: amv_perspective_pvt.delete_itempersps(p_api_version,
451: p_init_msg_list,

Line 450: amv_perspective_pvt.delete_itempersps(p_api_version,

446:
447: amv_perspective_pvt_w.rosetta_table_copy_in_p1(ddp_perspective_array, p_perspective_array);
448:
449: -- here's the delegated call to the old PL/SQL routine
450: amv_perspective_pvt.delete_itempersps(p_api_version,
451: p_init_msg_list,
452: p_commit,
453: p_validation_level,
454: x_return_status,

Line 486: ddp_perspective_array amv_perspective_pvt.amv_number_varray_type;

482: , p_perspective_array JTF_NUMBER_TABLE
483: )
484:
485: as
486: ddp_perspective_array amv_perspective_pvt.amv_number_varray_type;
487: ddindx binary_integer; indx binary_integer;
488: begin
489:
490: -- copy data to the local IN or IN-OUT args, if any

Line 500: amv_perspective_pvt_w.rosetta_table_copy_in_p1(ddp_perspective_array, p_perspective_array);

496:
497:
498:
499:
500: amv_perspective_pvt_w.rosetta_table_copy_in_p1(ddp_perspective_array, p_perspective_array);
501:
502: -- here's the delegated call to the old PL/SQL routine
503: amv_perspective_pvt.update_itempersps(p_api_version,
504: p_init_msg_list,

Line 503: amv_perspective_pvt.update_itempersps(p_api_version,

499:
500: amv_perspective_pvt_w.rosetta_table_copy_in_p1(ddp_perspective_array, p_perspective_array);
501:
502: -- here's the delegated call to the old PL/SQL routine
503: amv_perspective_pvt.update_itempersps(p_api_version,
504: p_init_msg_list,
505: p_commit,
506: p_validation_level,
507: x_return_status,

Line 548: ddx_perspective_obj_varray amv_perspective_pvt.amv_perspective_obj_varray;

544: , p8_a10 out nocopy JTF_NUMBER_TABLE
545: )
546:
547: as
548: ddx_perspective_obj_varray amv_perspective_pvt.amv_perspective_obj_varray;
549: ddindx binary_integer; indx binary_integer;
550: begin
551:
552: -- copy data to the local IN or IN-OUT args, if any

Line 563: amv_perspective_pvt.get_itempersps(p_api_version,

559:
560:
561:
562: -- here's the delegated call to the old PL/SQL routine
563: amv_perspective_pvt.get_itempersps(p_api_version,
564: p_init_msg_list,
565: p_validation_level,
566: x_return_status,
567: x_msg_count,

Line 582: amv_perspective_pvt_w.rosetta_table_copy_out_p5(ddx_perspective_obj_varray, p8_a0

578:
579:
580:
581:
582: amv_perspective_pvt_w.rosetta_table_copy_out_p5(ddx_perspective_obj_varray, p8_a0
583: , p8_a1
584: , p8_a2
585: , p8_a3
586: , p8_a4

Line 596: end amv_perspective_pvt_w;

592: , p8_a10
593: );
594: end;
595:
596: end amv_perspective_pvt_w;