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_STOCK_PVT_W dependencies on JTF_NUMBER_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package amv_stock_pvt_w as
2: /* $Header: amvwstks.pls 120.2 2005/06/30 08:26 appldev ship $ */
3: procedure rosetta_table_copy_in_p6(t out nocopy amv_stock_pvt.amv_tkr_varray_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: );
6: procedure rosetta_table_copy_out_p6(t amv_stock_pvt.amv_tkr_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
7: , a1 out nocopy JTF_NUMBER_TABLE
8: );

Line 7: , a1 out nocopy JTF_NUMBER_TABLE

3: procedure rosetta_table_copy_in_p6(t out nocopy amv_stock_pvt.amv_tkr_varray_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: );
6: procedure rosetta_table_copy_out_p6(t amv_stock_pvt.amv_tkr_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
7: , a1 out nocopy JTF_NUMBER_TABLE
8: );
9:
10: procedure rosetta_table_copy_in_p7(t out nocopy amv_stock_pvt.amv_sym_varray_type, a0 JTF_NUMBER_TABLE
11: , a1 JTF_VARCHAR2_TABLE_100

Line 10: procedure rosetta_table_copy_in_p7(t out nocopy amv_stock_pvt.amv_sym_varray_type, a0 JTF_NUMBER_TABLE

6: procedure rosetta_table_copy_out_p6(t amv_stock_pvt.amv_tkr_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
7: , a1 out nocopy JTF_NUMBER_TABLE
8: );
9:
10: procedure rosetta_table_copy_in_p7(t out nocopy amv_stock_pvt.amv_sym_varray_type, a0 JTF_NUMBER_TABLE
11: , a1 JTF_VARCHAR2_TABLE_100
12: , a2 JTF_VARCHAR2_TABLE_100
13: );
14: procedure rosetta_table_copy_out_p7(t amv_stock_pvt.amv_sym_varray_type, a0 out nocopy JTF_NUMBER_TABLE

Line 14: procedure rosetta_table_copy_out_p7(t amv_stock_pvt.amv_sym_varray_type, a0 out nocopy JTF_NUMBER_TABLE

10: procedure rosetta_table_copy_in_p7(t out nocopy amv_stock_pvt.amv_sym_varray_type, a0 JTF_NUMBER_TABLE
11: , a1 JTF_VARCHAR2_TABLE_100
12: , a2 JTF_VARCHAR2_TABLE_100
13: );
14: procedure rosetta_table_copy_out_p7(t amv_stock_pvt.amv_sym_varray_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_VARCHAR2_TABLE_100
16: , a2 out nocopy JTF_VARCHAR2_TABLE_100
17: );
18:

Line 19: procedure rosetta_table_copy_in_p8(t out nocopy amv_stock_pvt.amv_stk_varray_type, a0 JTF_NUMBER_TABLE

15: , a1 out nocopy JTF_VARCHAR2_TABLE_100
16: , a2 out nocopy JTF_VARCHAR2_TABLE_100
17: );
18:
19: procedure rosetta_table_copy_in_p8(t out nocopy amv_stock_pvt.amv_stk_varray_type, a0 JTF_NUMBER_TABLE
20: , a1 JTF_VARCHAR2_TABLE_100
21: , a2 JTF_VARCHAR2_TABLE_300
22: , a3 JTF_NUMBER_TABLE
23: , a4 JTF_NUMBER_TABLE

Line 22: , a3 JTF_NUMBER_TABLE

18:
19: procedure rosetta_table_copy_in_p8(t out nocopy amv_stock_pvt.amv_stk_varray_type, a0 JTF_NUMBER_TABLE
20: , a1 JTF_VARCHAR2_TABLE_100
21: , a2 JTF_VARCHAR2_TABLE_300
22: , a3 JTF_NUMBER_TABLE
23: , a4 JTF_NUMBER_TABLE
24: );
25: procedure rosetta_table_copy_out_p8(t amv_stock_pvt.amv_stk_varray_type, a0 out nocopy JTF_NUMBER_TABLE
26: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 23: , a4 JTF_NUMBER_TABLE

19: procedure rosetta_table_copy_in_p8(t out nocopy amv_stock_pvt.amv_stk_varray_type, a0 JTF_NUMBER_TABLE
20: , a1 JTF_VARCHAR2_TABLE_100
21: , a2 JTF_VARCHAR2_TABLE_300
22: , a3 JTF_NUMBER_TABLE
23: , a4 JTF_NUMBER_TABLE
24: );
25: procedure rosetta_table_copy_out_p8(t amv_stock_pvt.amv_stk_varray_type, a0 out nocopy JTF_NUMBER_TABLE
26: , a1 out nocopy JTF_VARCHAR2_TABLE_100
27: , a2 out nocopy JTF_VARCHAR2_TABLE_300

Line 25: procedure rosetta_table_copy_out_p8(t amv_stock_pvt.amv_stk_varray_type, a0 out nocopy JTF_NUMBER_TABLE

21: , a2 JTF_VARCHAR2_TABLE_300
22: , a3 JTF_NUMBER_TABLE
23: , a4 JTF_NUMBER_TABLE
24: );
25: procedure rosetta_table_copy_out_p8(t amv_stock_pvt.amv_stk_varray_type, a0 out nocopy JTF_NUMBER_TABLE
26: , a1 out nocopy JTF_VARCHAR2_TABLE_100
27: , a2 out nocopy JTF_VARCHAR2_TABLE_300
28: , a3 out nocopy JTF_NUMBER_TABLE
29: , a4 out nocopy JTF_NUMBER_TABLE

Line 28: , a3 out nocopy JTF_NUMBER_TABLE

24: );
25: procedure rosetta_table_copy_out_p8(t amv_stock_pvt.amv_stk_varray_type, a0 out nocopy JTF_NUMBER_TABLE
26: , a1 out nocopy JTF_VARCHAR2_TABLE_100
27: , a2 out nocopy JTF_VARCHAR2_TABLE_300
28: , a3 out nocopy JTF_NUMBER_TABLE
29: , a4 out nocopy JTF_NUMBER_TABLE
30: );
31:
32: procedure rosetta_table_copy_in_p9(t out nocopy amv_stock_pvt.amv_news_varray_type, a0 JTF_VARCHAR2_TABLE_100

Line 29: , a4 out nocopy JTF_NUMBER_TABLE

25: procedure rosetta_table_copy_out_p8(t amv_stock_pvt.amv_stk_varray_type, a0 out nocopy JTF_NUMBER_TABLE
26: , a1 out nocopy JTF_VARCHAR2_TABLE_100
27: , a2 out nocopy JTF_VARCHAR2_TABLE_300
28: , a3 out nocopy JTF_NUMBER_TABLE
29: , a4 out nocopy JTF_NUMBER_TABLE
30: );
31:
32: procedure rosetta_table_copy_in_p9(t out nocopy amv_stock_pvt.amv_news_varray_type, a0 JTF_VARCHAR2_TABLE_100
33: , a1 JTF_VARCHAR2_TABLE_2000

Line 48: procedure rosetta_table_copy_in_p11(t out nocopy amv_stock_pvt.amv_num_varray_type, a0 JTF_NUMBER_TABLE);

44:
45: procedure rosetta_table_copy_in_p10(t out nocopy amv_stock_pvt.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_400);
46: procedure rosetta_table_copy_out_p10(t amv_stock_pvt.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_400);
47:
48: procedure rosetta_table_copy_in_p11(t out nocopy amv_stock_pvt.amv_num_varray_type, a0 JTF_NUMBER_TABLE);
49: procedure rosetta_table_copy_out_p11(t amv_stock_pvt.amv_num_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
50:
51: procedure get_userticker(p_api_version NUMBER
52: , p_init_msg_list VARCHAR2

Line 49: procedure rosetta_table_copy_out_p11(t amv_stock_pvt.amv_num_varray_type, a0 out nocopy JTF_NUMBER_TABLE);

45: procedure rosetta_table_copy_in_p10(t out nocopy amv_stock_pvt.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_400);
46: procedure rosetta_table_copy_out_p10(t amv_stock_pvt.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_400);
47:
48: procedure rosetta_table_copy_in_p11(t out nocopy amv_stock_pvt.amv_num_varray_type, a0 JTF_NUMBER_TABLE);
49: procedure rosetta_table_copy_out_p11(t amv_stock_pvt.amv_num_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
50:
51: procedure get_userticker(p_api_version NUMBER
52: , p_init_msg_list VARCHAR2
53: , p_validation_level NUMBER

Line 60: , p9_a0 out nocopy JTF_NUMBER_TABLE

56: , x_msg_data out nocopy VARCHAR2
57: , p_user_id NUMBER
58: , p_distinct_stocks VARCHAR2
59: , p_sort_order VARCHAR2
60: , p9_a0 out nocopy JTF_NUMBER_TABLE
61: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
62: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
63: , p9_a3 out nocopy JTF_NUMBER_TABLE
64: , p9_a4 out nocopy JTF_NUMBER_TABLE

Line 63: , p9_a3 out nocopy JTF_NUMBER_TABLE

59: , p_sort_order VARCHAR2
60: , p9_a0 out nocopy JTF_NUMBER_TABLE
61: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
62: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
63: , p9_a3 out nocopy JTF_NUMBER_TABLE
64: , p9_a4 out nocopy JTF_NUMBER_TABLE
65: );
66: procedure get_stockdetails(p_api_version NUMBER
67: , p_init_msg_list VARCHAR2

Line 64: , p9_a4 out nocopy JTF_NUMBER_TABLE

60: , p9_a0 out nocopy JTF_NUMBER_TABLE
61: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
62: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
63: , p9_a3 out nocopy JTF_NUMBER_TABLE
64: , p9_a4 out nocopy JTF_NUMBER_TABLE
65: );
66: procedure get_stockdetails(p_api_version NUMBER
67: , p_init_msg_list VARCHAR2
68: , p_validation_level NUMBER

Line 73: , p7_a0 out nocopy JTF_NUMBER_TABLE

69: , x_return_status out nocopy VARCHAR2
70: , x_msg_count out nocopy NUMBER
71: , x_msg_data out nocopy VARCHAR2
72: , p_symbols VARCHAR2
73: , p7_a0 out nocopy JTF_NUMBER_TABLE
74: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
75: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
76: , p7_a3 out nocopy JTF_NUMBER_TABLE
77: , p7_a4 out nocopy JTF_NUMBER_TABLE

Line 76: , p7_a3 out nocopy JTF_NUMBER_TABLE

72: , p_symbols VARCHAR2
73: , p7_a0 out nocopy JTF_NUMBER_TABLE
74: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
75: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
76: , p7_a3 out nocopy JTF_NUMBER_TABLE
77: , p7_a4 out nocopy JTF_NUMBER_TABLE
78: );
79: procedure get_vendormissedstocks(p_api_version NUMBER
80: , p_init_msg_list VARCHAR2

Line 77: , p7_a4 out nocopy JTF_NUMBER_TABLE

73: , p7_a0 out nocopy JTF_NUMBER_TABLE
74: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
75: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
76: , p7_a3 out nocopy JTF_NUMBER_TABLE
77: , p7_a4 out nocopy JTF_NUMBER_TABLE
78: );
79: procedure get_vendormissedstocks(p_api_version NUMBER
80: , p_init_msg_list VARCHAR2
81: , p_validation_level NUMBER

Line 88: , p9_a0 out nocopy JTF_NUMBER_TABLE

84: , x_msg_data out nocopy VARCHAR2
85: , p_vendor_id NUMBER
86: , p_start_index NUMBER
87: , p_batch_size NUMBER
88: , p9_a0 out nocopy JTF_NUMBER_TABLE
89: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
90: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
91: );
92: procedure insert_stockvendorkeys(p_api_version NUMBER