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_ITEM_PUB_W dependencies on JTF_VARCHAR2_TABLE_4000

Line 22: procedure rosetta_table_copy_in_p0(t out nocopy amv_item_pub.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_4000) as

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p0(t out nocopy amv_item_pub.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_4000) as
23: ddindx binary_integer; indx binary_integer;
24: begin
25: if a0 is null then
26: t := null;

Line 46: procedure rosetta_table_copy_out_p0(t amv_item_pub.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_4000) as

42: end loop;
43: end if;
44: end if;
45: end rosetta_table_copy_in_p0;
46: procedure rosetta_table_copy_out_p0(t amv_item_pub.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_4000) as
47: ddindx binary_integer; indx binary_integer;
48: begin
49: if t is null then
50: a0 := null;

Line 52: a0 := JTF_VARCHAR2_TABLE_4000();

48: begin
49: if t is null then
50: a0 := null;
51: elsif t.count = 0 then
52: a0 := JTF_VARCHAR2_TABLE_4000();
53: else
54: a0 := JTF_VARCHAR2_TABLE_4000();
55: if t.count > 0 then
56: a0.extend(t.count);

Line 54: a0 := JTF_VARCHAR2_TABLE_4000();

50: a0 := null;
51: elsif t.count = 0 then
52: a0 := JTF_VARCHAR2_TABLE_4000();
53: else
54: a0 := JTF_VARCHAR2_TABLE_4000();
55: if t.count > 0 then
56: a0.extend(t.count);
57: ddindx := t.first;
58: indx := 1;

Line 461: , p_author_array JTF_VARCHAR2_TABLE_4000

457: , p_channel_id_array JTF_NUMBER_TABLE
458: , p_file_array JTF_NUMBER_TABLE
459: , p10_a0 JTF_NUMBER_TABLE
460: , p10_a1 JTF_VARCHAR2_TABLE_300
461: , p_author_array JTF_VARCHAR2_TABLE_4000
462: , p_keyword_array JTF_VARCHAR2_TABLE_4000
463: , x_item_id out nocopy NUMBER
464: , p8_a0 NUMBER := 0-1962.0724
465: , p8_a1 NUMBER := 0-1962.0724

Line 462: , p_keyword_array JTF_VARCHAR2_TABLE_4000

458: , p_file_array JTF_NUMBER_TABLE
459: , p10_a0 JTF_NUMBER_TABLE
460: , p10_a1 JTF_VARCHAR2_TABLE_300
461: , p_author_array JTF_VARCHAR2_TABLE_4000
462: , p_keyword_array JTF_VARCHAR2_TABLE_4000
463: , x_item_id out nocopy NUMBER
464: , p8_a0 NUMBER := 0-1962.0724
465: , p8_a1 NUMBER := 0-1962.0724
466: , p8_a2 DATE := fnd_api.g_miss_date

Line 589: , p_author_array JTF_VARCHAR2_TABLE_4000

585: , p_channel_id_array JTF_NUMBER_TABLE
586: , p_file_array JTF_NUMBER_TABLE
587: , p10_a0 JTF_NUMBER_TABLE
588: , p10_a1 JTF_VARCHAR2_TABLE_300
589: , p_author_array JTF_VARCHAR2_TABLE_4000
590: , p_keyword_array JTF_VARCHAR2_TABLE_4000
591: , p8_a0 NUMBER := 0-1962.0724
592: , p8_a1 NUMBER := 0-1962.0724
593: , p8_a2 DATE := fnd_api.g_miss_date

Line 590: , p_keyword_array JTF_VARCHAR2_TABLE_4000

586: , p_file_array JTF_NUMBER_TABLE
587: , p10_a0 JTF_NUMBER_TABLE
588: , p10_a1 JTF_VARCHAR2_TABLE_300
589: , p_author_array JTF_VARCHAR2_TABLE_4000
590: , p_keyword_array JTF_VARCHAR2_TABLE_4000
591: , p8_a0 NUMBER := 0-1962.0724
592: , p8_a1 NUMBER := 0-1962.0724
593: , p8_a2 DATE := fnd_api.g_miss_date
594: , p8_a3 NUMBER := 0-1962.0724

Line 736: , x_author_array out nocopy JTF_VARCHAR2_TABLE_4000

732: , p7_a23 out nocopy VARCHAR2
733: , x_file_array out nocopy JTF_NUMBER_TABLE
734: , p9_a0 out nocopy JTF_NUMBER_TABLE
735: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_300
736: , x_author_array out nocopy JTF_VARCHAR2_TABLE_4000
737: , x_keyword_array out nocopy JTF_VARCHAR2_TABLE_4000
738: )
739:
740: as

Line 737: , x_keyword_array out nocopy JTF_VARCHAR2_TABLE_4000

733: , x_file_array out nocopy JTF_NUMBER_TABLE
734: , p9_a0 out nocopy JTF_NUMBER_TABLE
735: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_300
736: , x_author_array out nocopy JTF_VARCHAR2_TABLE_4000
737: , x_keyword_array out nocopy JTF_VARCHAR2_TABLE_4000
738: )
739:
740: as
741: ddx_item_obj amv_item_pub.amv_item_obj_type;

Line 958: , p_keyword_varray JTF_VARCHAR2_TABLE_4000

954: , x_msg_count out nocopy NUMBER
955: , x_msg_data out nocopy VARCHAR2
956: , p_check_login_user VARCHAR2
957: , p_item_id NUMBER
958: , p_keyword_varray JTF_VARCHAR2_TABLE_4000
959: )
960:
961: as
962: ddp_keyword_varray amv_item_pub.amv_char_varray_type;

Line 1007: , p_keyword_varray JTF_VARCHAR2_TABLE_4000

1003: , x_msg_count out nocopy NUMBER
1004: , x_msg_data out nocopy VARCHAR2
1005: , p_check_login_user VARCHAR2
1006: , p_item_id NUMBER
1007: , p_keyword_varray JTF_VARCHAR2_TABLE_4000
1008: )
1009:
1010: as
1011: ddp_keyword_varray amv_item_pub.amv_char_varray_type;

Line 1056: , p_keyword_varray JTF_VARCHAR2_TABLE_4000

1052: , x_msg_count out nocopy NUMBER
1053: , x_msg_data out nocopy VARCHAR2
1054: , p_check_login_user VARCHAR2
1055: , p_item_id NUMBER
1056: , p_keyword_varray JTF_VARCHAR2_TABLE_4000
1057: )
1058:
1059: as
1060: ddp_keyword_varray amv_item_pub.amv_char_varray_type;

Line 1104: , x_keyword_varray out nocopy JTF_VARCHAR2_TABLE_4000

1100: , x_msg_count out nocopy NUMBER
1101: , x_msg_data out nocopy VARCHAR2
1102: , p_check_login_user VARCHAR2
1103: , p_item_id NUMBER
1104: , x_keyword_varray out nocopy JTF_VARCHAR2_TABLE_4000
1105: )
1106:
1107: as
1108: ddx_keyword_varray amv_item_pub.amv_char_varray_type;

Line 1150: , p_author_varray JTF_VARCHAR2_TABLE_4000

1146: , x_msg_count out nocopy NUMBER
1147: , x_msg_data out nocopy VARCHAR2
1148: , p_check_login_user VARCHAR2
1149: , p_item_id NUMBER
1150: , p_author_varray JTF_VARCHAR2_TABLE_4000
1151: )
1152:
1153: as
1154: ddp_author_varray amv_item_pub.amv_char_varray_type;

Line 1199: , p_author_varray JTF_VARCHAR2_TABLE_4000

1195: , x_msg_count out nocopy NUMBER
1196: , x_msg_data out nocopy VARCHAR2
1197: , p_check_login_user VARCHAR2
1198: , p_item_id NUMBER
1199: , p_author_varray JTF_VARCHAR2_TABLE_4000
1200: )
1201:
1202: as
1203: ddp_author_varray amv_item_pub.amv_char_varray_type;

Line 1248: , p_author_varray JTF_VARCHAR2_TABLE_4000

1244: , x_msg_count out nocopy NUMBER
1245: , x_msg_data out nocopy VARCHAR2
1246: , p_check_login_user VARCHAR2
1247: , p_item_id NUMBER
1248: , p_author_varray JTF_VARCHAR2_TABLE_4000
1249: )
1250:
1251: as
1252: ddp_author_varray amv_item_pub.amv_char_varray_type;

Line 1296: , x_author_varray out nocopy JTF_VARCHAR2_TABLE_4000

1292: , x_msg_count out nocopy NUMBER
1293: , x_msg_data out nocopy VARCHAR2
1294: , p_check_login_user VARCHAR2
1295: , p_item_id NUMBER
1296: , x_author_varray out nocopy JTF_VARCHAR2_TABLE_4000
1297: )
1298:
1299: as
1300: ddx_author_varray amv_item_pub.amv_char_varray_type;

Line 1538: , x_message_varray out nocopy JTF_VARCHAR2_TABLE_4000

1534: , x_msg_data out nocopy VARCHAR2
1535: , p_check_login_user VARCHAR2
1536: , p_user_id NUMBER
1537: , x_item_id_varray out nocopy JTF_NUMBER_TABLE
1538: , x_message_varray out nocopy JTF_VARCHAR2_TABLE_4000
1539: )
1540:
1541: as
1542: ddx_item_id_varray amv_item_pub.amv_number_varray_type;