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.JTF_AMV_ITEM_PUB_W dependencies on JTF_AMV_ITEM_PUB

Line 1: package body jtf_amv_item_pub_w as

1: package body jtf_amv_item_pub_w as
2: /* $Header: jtfpitwb.pls 120.3 2005/09/13 11:09:54 vimohan 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_amv_item_pub.number_tab_type, a0 JTF_NUMBER_TABLE) as

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_amv_item_pub.number_tab_type, a0 JTF_NUMBER_TABLE) as
26: ddindx binary_integer; indx binary_integer;
27: begin
28: if a0 is null then
29: t := null;

Line 31: t := jtf_amv_item_pub.number_tab_type();

27: begin
28: if a0 is null then
29: t := null;
30: elsif a0.count = 0 then
31: t := jtf_amv_item_pub.number_tab_type();
32: else
33: if a0.count > 0 then
34: t := jtf_amv_item_pub.number_tab_type();
35: t.extend(a0.count);

Line 34: t := jtf_amv_item_pub.number_tab_type();

30: elsif a0.count = 0 then
31: t := jtf_amv_item_pub.number_tab_type();
32: else
33: if a0.count > 0 then
34: t := jtf_amv_item_pub.number_tab_type();
35: t.extend(a0.count);
36: indx := a0.first;
37: ddindx := 1;
38: while true loop

Line 49: procedure rosetta_table_copy_out_p1(t jtf_amv_item_pub.number_tab_type, a0 out nocopy JTF_NUMBER_TABLE) as

45: end loop;
46: end if;
47: end if;
48: end rosetta_table_copy_in_p1;
49: procedure rosetta_table_copy_out_p1(t jtf_amv_item_pub.number_tab_type, a0 out nocopy JTF_NUMBER_TABLE) as
50: ddindx binary_integer; indx binary_integer;
51: begin
52: if t is null then
53: a0 := null;

Line 74: procedure rosetta_table_copy_in_p2(t out nocopy jtf_amv_item_pub.char_tab_type, a0 JTF_VARCHAR2_TABLE_200) as

70: end if;
71: end if;
72: end rosetta_table_copy_out_p1;
73:
74: procedure rosetta_table_copy_in_p2(t out nocopy jtf_amv_item_pub.char_tab_type, a0 JTF_VARCHAR2_TABLE_200) as
75: ddindx binary_integer; indx binary_integer;
76: begin
77: if a0 is null then
78: t := null;

Line 80: t := jtf_amv_item_pub.char_tab_type();

76: begin
77: if a0 is null then
78: t := null;
79: elsif a0.count = 0 then
80: t := jtf_amv_item_pub.char_tab_type();
81: else
82: if a0.count > 0 then
83: t := jtf_amv_item_pub.char_tab_type();
84: t.extend(a0.count);

Line 83: t := jtf_amv_item_pub.char_tab_type();

79: elsif a0.count = 0 then
80: t := jtf_amv_item_pub.char_tab_type();
81: else
82: if a0.count > 0 then
83: t := jtf_amv_item_pub.char_tab_type();
84: t.extend(a0.count);
85: indx := a0.first;
86: ddindx := 1;
87: while true loop

Line 98: procedure rosetta_table_copy_out_p2(t jtf_amv_item_pub.char_tab_type, a0 out nocopy JTF_VARCHAR2_TABLE_200) as

94: end loop;
95: end if;
96: end if;
97: end rosetta_table_copy_in_p2;
98: procedure rosetta_table_copy_out_p2(t jtf_amv_item_pub.char_tab_type, a0 out nocopy JTF_VARCHAR2_TABLE_200) as
99: ddindx binary_integer; indx binary_integer;
100: begin
101: if t is null then
102: a0 := null;

Line 160: ddp_item_rec jtf_amv_item_pub.item_rec_type;

156: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
157: )
158:
159: as
160: ddp_item_rec jtf_amv_item_pub.item_rec_type;
161: ddindx binary_integer; indx binary_integer;
162: begin
163:
164: -- copy data to the local IN or IN-OUT args, if any

Line 201: jtf_amv_item_pub.create_item(p_api_version,

197: ddp_item_rec.applicable_to_code := p6_a26;
198:
199:
200: -- here's the delegated call to the old PL/SQL routine
201: jtf_amv_item_pub.create_item(p_api_version,
202: p_init_msg_list,
203: p_commit,
204: x_return_status,
205: x_msg_count,

Line 256: ddp_item_rec jtf_amv_item_pub.item_rec_type;

252: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
253: )
254:
255: as
256: ddp_item_rec jtf_amv_item_pub.item_rec_type;
257: ddindx binary_integer; indx binary_integer;
258: begin
259:
260: -- copy data to the local IN or IN-OUT args, if any

Line 296: jtf_amv_item_pub.update_item(p_api_version,

292: ddp_item_rec.deliverable_type_code := p6_a25;
293: ddp_item_rec.applicable_to_code := p6_a26;
294:
295: -- here's the delegated call to the old PL/SQL routine
296: jtf_amv_item_pub.update_item(p_api_version,
297: p_init_msg_list,
298: p_commit,
299: x_return_status,
300: x_msg_count,

Line 349: ddx_item_rec jtf_amv_item_pub.item_rec_type;

345: , p6_a26 out nocopy VARCHAR2
346: )
347:
348: as
349: ddx_item_rec jtf_amv_item_pub.item_rec_type;
350: ddindx binary_integer; indx binary_integer;
351: begin
352:
353: -- copy data to the local IN or IN-OUT args, if any

Line 362: jtf_amv_item_pub.get_item(p_api_version,

358:
359:
360:
361: -- here's the delegated call to the old PL/SQL routine
362: jtf_amv_item_pub.get_item(p_api_version,
363: p_init_msg_list,
364: x_return_status,
365: x_msg_count,
366: x_msg_data,

Line 417: ddp_keyword_tab jtf_amv_item_pub.char_tab_type;

413: , p_keyword_tab JTF_VARCHAR2_TABLE_200
414: )
415:
416: as
417: ddp_keyword_tab jtf_amv_item_pub.char_tab_type;
418: ddindx binary_integer; indx binary_integer;
419: begin
420:
421: -- copy data to the local IN or IN-OUT args, if any

Line 429: jtf_amv_item_pub_w.rosetta_table_copy_in_p2(ddp_keyword_tab, p_keyword_tab);

425:
426:
427:
428:
429: jtf_amv_item_pub_w.rosetta_table_copy_in_p2(ddp_keyword_tab, p_keyword_tab);
430:
431: -- here's the delegated call to the old PL/SQL routine
432: jtf_amv_item_pub.add_itemkeyword(p_api_version,
433: p_init_msg_list,

Line 432: jtf_amv_item_pub.add_itemkeyword(p_api_version,

428:
429: jtf_amv_item_pub_w.rosetta_table_copy_in_p2(ddp_keyword_tab, p_keyword_tab);
430:
431: -- here's the delegated call to the old PL/SQL routine
432: jtf_amv_item_pub.add_itemkeyword(p_api_version,
433: p_init_msg_list,
434: p_commit,
435: x_return_status,
436: x_msg_count,

Line 462: ddp_keyword_tab jtf_amv_item_pub.char_tab_type;

458: , p_keyword_tab JTF_VARCHAR2_TABLE_200
459: )
460:
461: as
462: ddp_keyword_tab jtf_amv_item_pub.char_tab_type;
463: ddindx binary_integer; indx binary_integer;
464: begin
465:
466: -- copy data to the local IN or IN-OUT args, if any

Line 474: jtf_amv_item_pub_w.rosetta_table_copy_in_p2(ddp_keyword_tab, p_keyword_tab);

470:
471:
472:
473:
474: jtf_amv_item_pub_w.rosetta_table_copy_in_p2(ddp_keyword_tab, p_keyword_tab);
475:
476: -- here's the delegated call to the old PL/SQL routine
477: jtf_amv_item_pub.delete_itemkeyword(p_api_version,
478: p_init_msg_list,

Line 477: jtf_amv_item_pub.delete_itemkeyword(p_api_version,

473:
474: jtf_amv_item_pub_w.rosetta_table_copy_in_p2(ddp_keyword_tab, p_keyword_tab);
475:
476: -- here's the delegated call to the old PL/SQL routine
477: jtf_amv_item_pub.delete_itemkeyword(p_api_version,
478: p_init_msg_list,
479: p_commit,
480: x_return_status,
481: x_msg_count,

Line 507: ddp_keyword_tab jtf_amv_item_pub.char_tab_type;

503: , p_keyword_tab JTF_VARCHAR2_TABLE_200
504: )
505:
506: as
507: ddp_keyword_tab jtf_amv_item_pub.char_tab_type;
508: ddindx binary_integer; indx binary_integer;
509: begin
510:
511: -- copy data to the local IN or IN-OUT args, if any

Line 519: jtf_amv_item_pub_w.rosetta_table_copy_in_p2(ddp_keyword_tab, p_keyword_tab);

515:
516:
517:
518:
519: jtf_amv_item_pub_w.rosetta_table_copy_in_p2(ddp_keyword_tab, p_keyword_tab);
520:
521: -- here's the delegated call to the old PL/SQL routine
522: jtf_amv_item_pub.replace_itemkeyword(p_api_version,
523: p_init_msg_list,

Line 522: jtf_amv_item_pub.replace_itemkeyword(p_api_version,

518:
519: jtf_amv_item_pub_w.rosetta_table_copy_in_p2(ddp_keyword_tab, p_keyword_tab);
520:
521: -- here's the delegated call to the old PL/SQL routine
522: jtf_amv_item_pub.replace_itemkeyword(p_api_version,
523: p_init_msg_list,
524: p_commit,
525: x_return_status,
526: x_msg_count,

Line 551: ddx_keyword_tab jtf_amv_item_pub.char_tab_type;

547: , x_keyword_tab out nocopy JTF_VARCHAR2_TABLE_200
548: )
549:
550: as
551: ddx_keyword_tab jtf_amv_item_pub.char_tab_type;
552: ddindx binary_integer; indx binary_integer;
553: begin
554:
555: -- copy data to the local IN or IN-OUT args, if any

Line 564: jtf_amv_item_pub.get_itemkeyword(p_api_version,

560:
561:
562:
563: -- here's the delegated call to the old PL/SQL routine
564: jtf_amv_item_pub.get_itemkeyword(p_api_version,
565: p_init_msg_list,
566: x_return_status,
567: x_msg_count,
568: x_msg_data,

Line 579: jtf_amv_item_pub_w.rosetta_table_copy_out_p2(ddx_keyword_tab, x_keyword_tab);

575:
576:
577:
578:
579: jtf_amv_item_pub_w.rosetta_table_copy_out_p2(ddx_keyword_tab, x_keyword_tab);
580: end;
581:
582: procedure add_itemauthor(p_api_version NUMBER
583: , p_init_msg_list VARCHAR2

Line 593: ddp_author_tab jtf_amv_item_pub.char_tab_type;

589: , p_author_tab JTF_VARCHAR2_TABLE_200
590: )
591:
592: as
593: ddp_author_tab jtf_amv_item_pub.char_tab_type;
594: ddindx binary_integer; indx binary_integer;
595: begin
596:
597: -- copy data to the local IN or IN-OUT args, if any

Line 605: jtf_amv_item_pub_w.rosetta_table_copy_in_p2(ddp_author_tab, p_author_tab);

601:
602:
603:
604:
605: jtf_amv_item_pub_w.rosetta_table_copy_in_p2(ddp_author_tab, p_author_tab);
606:
607: -- here's the delegated call to the old PL/SQL routine
608: jtf_amv_item_pub.add_itemauthor(p_api_version,
609: p_init_msg_list,

Line 608: jtf_amv_item_pub.add_itemauthor(p_api_version,

604:
605: jtf_amv_item_pub_w.rosetta_table_copy_in_p2(ddp_author_tab, p_author_tab);
606:
607: -- here's the delegated call to the old PL/SQL routine
608: jtf_amv_item_pub.add_itemauthor(p_api_version,
609: p_init_msg_list,
610: p_commit,
611: x_return_status,
612: x_msg_count,

Line 638: ddp_author_tab jtf_amv_item_pub.char_tab_type;

634: , p_author_tab JTF_VARCHAR2_TABLE_200
635: )
636:
637: as
638: ddp_author_tab jtf_amv_item_pub.char_tab_type;
639: ddindx binary_integer; indx binary_integer;
640: begin
641:
642: -- copy data to the local IN or IN-OUT args, if any

Line 650: jtf_amv_item_pub_w.rosetta_table_copy_in_p2(ddp_author_tab, p_author_tab);

646:
647:
648:
649:
650: jtf_amv_item_pub_w.rosetta_table_copy_in_p2(ddp_author_tab, p_author_tab);
651:
652: -- here's the delegated call to the old PL/SQL routine
653: jtf_amv_item_pub.delete_itemauthor(p_api_version,
654: p_init_msg_list,

Line 653: jtf_amv_item_pub.delete_itemauthor(p_api_version,

649:
650: jtf_amv_item_pub_w.rosetta_table_copy_in_p2(ddp_author_tab, p_author_tab);
651:
652: -- here's the delegated call to the old PL/SQL routine
653: jtf_amv_item_pub.delete_itemauthor(p_api_version,
654: p_init_msg_list,
655: p_commit,
656: x_return_status,
657: x_msg_count,

Line 683: ddp_author_tab jtf_amv_item_pub.char_tab_type;

679: , p_author_tab JTF_VARCHAR2_TABLE_200
680: )
681:
682: as
683: ddp_author_tab jtf_amv_item_pub.char_tab_type;
684: ddindx binary_integer; indx binary_integer;
685: begin
686:
687: -- copy data to the local IN or IN-OUT args, if any

Line 695: jtf_amv_item_pub_w.rosetta_table_copy_in_p2(ddp_author_tab, p_author_tab);

691:
692:
693:
694:
695: jtf_amv_item_pub_w.rosetta_table_copy_in_p2(ddp_author_tab, p_author_tab);
696:
697: -- here's the delegated call to the old PL/SQL routine
698: jtf_amv_item_pub.replace_itemauthor(p_api_version,
699: p_init_msg_list,

Line 698: jtf_amv_item_pub.replace_itemauthor(p_api_version,

694:
695: jtf_amv_item_pub_w.rosetta_table_copy_in_p2(ddp_author_tab, p_author_tab);
696:
697: -- here's the delegated call to the old PL/SQL routine
698: jtf_amv_item_pub.replace_itemauthor(p_api_version,
699: p_init_msg_list,
700: p_commit,
701: x_return_status,
702: x_msg_count,

Line 727: ddx_author_tab jtf_amv_item_pub.char_tab_type;

723: , x_author_tab out nocopy JTF_VARCHAR2_TABLE_200
724: )
725:
726: as
727: ddx_author_tab jtf_amv_item_pub.char_tab_type;
728: ddindx binary_integer; indx binary_integer;
729: begin
730:
731: -- copy data to the local IN or IN-OUT args, if any

Line 740: jtf_amv_item_pub.get_itemauthor(p_api_version,

736:
737:
738:
739: -- here's the delegated call to the old PL/SQL routine
740: jtf_amv_item_pub.get_itemauthor(p_api_version,
741: p_init_msg_list,
742: x_return_status,
743: x_msg_count,
744: x_msg_data,

Line 755: jtf_amv_item_pub_w.rosetta_table_copy_out_p2(ddx_author_tab, x_author_tab);

751:
752:
753:
754:
755: jtf_amv_item_pub_w.rosetta_table_copy_out_p2(ddx_author_tab, x_author_tab);
756: end;
757:
758: end jtf_amv_item_pub_w;

Line 758: end jtf_amv_item_pub_w;

754:
755: jtf_amv_item_pub_w.rosetta_table_copy_out_p2(ddx_author_tab, x_author_tab);
756: end;
757:
758: end jtf_amv_item_pub_w;