DBA Data[Home] [Help]

APPS.CAC_VIEW_AVAIL_PVT_W dependencies on JTF_VARCHAR2_TABLE_400

Line 5: , a2 JTF_VARCHAR2_TABLE_400

1: package cac_view_avail_pvt_w AUTHID CURRENT_USER as
2: /* $Header: cacwavs.pls 115.0 2003/10/28 00:59:10 cjang noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cac_view_avail_pvt.rstab, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_400
6: );
7: procedure rosetta_table_copy_out_p1(t cac_view_avail_pvt.rstab, a0 out nocopy JTF_NUMBER_TABLE
8: , a1 out nocopy JTF_VARCHAR2_TABLE_100
9: , a2 out nocopy JTF_VARCHAR2_TABLE_400

Line 9: , a2 out nocopy JTF_VARCHAR2_TABLE_400

5: , a2 JTF_VARCHAR2_TABLE_400
6: );
7: procedure rosetta_table_copy_out_p1(t cac_view_avail_pvt.rstab, a0 out nocopy JTF_NUMBER_TABLE
8: , a1 out nocopy JTF_VARCHAR2_TABLE_100
9: , a2 out nocopy JTF_VARCHAR2_TABLE_400
10: );
11:
12: procedure rosetta_table_copy_in_p3(t out nocopy cac_view_avail_pvt.avlbltb, a0 JTF_NUMBER_TABLE
13: , a1 JTF_VARCHAR2_TABLE_100

Line 14: , a2 JTF_VARCHAR2_TABLE_400

10: );
11:
12: procedure rosetta_table_copy_in_p3(t out nocopy cac_view_avail_pvt.avlbltb, a0 JTF_NUMBER_TABLE
13: , a1 JTF_VARCHAR2_TABLE_100
14: , a2 JTF_VARCHAR2_TABLE_400
15: , a3 JTF_NUMBER_TABLE
16: , a4 JTF_NUMBER_TABLE
17: );
18: procedure rosetta_table_copy_out_p3(t cac_view_avail_pvt.avlbltb, a0 out nocopy JTF_NUMBER_TABLE

Line 20: , a2 out nocopy JTF_VARCHAR2_TABLE_400

16: , a4 JTF_NUMBER_TABLE
17: );
18: procedure rosetta_table_copy_out_p3(t cac_view_avail_pvt.avlbltb, a0 out nocopy JTF_NUMBER_TABLE
19: , a1 out nocopy JTF_VARCHAR2_TABLE_100
20: , a2 out nocopy JTF_VARCHAR2_TABLE_400
21: , a3 out nocopy JTF_NUMBER_TABLE
22: , a4 out nocopy JTF_NUMBER_TABLE
23: );
24:

Line 32: , p5_a2 JTF_VARCHAR2_TABLE_400

28: , x_msg_count out nocopy NUMBER
29: , x_msg_data out nocopy VARCHAR2
30: , p5_a0 JTF_NUMBER_TABLE
31: , p5_a1 JTF_VARCHAR2_TABLE_100
32: , p5_a2 JTF_VARCHAR2_TABLE_400
33: , p_startdatetime DATE
34: , p_enddatetime DATE
35: , p_slotsize NUMBER
36: , x_numberofslots out nocopy NUMBER

Line 39: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_400

35: , p_slotsize NUMBER
36: , x_numberofslots out nocopy NUMBER
37: , p10_a0 out nocopy JTF_NUMBER_TABLE
38: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
39: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_400
40: , p10_a3 out nocopy JTF_NUMBER_TABLE
41: , p10_a4 out nocopy JTF_NUMBER_TABLE
42: , p11_a0 out nocopy JTF_NUMBER_TABLE
43: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 44: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_400

40: , p10_a3 out nocopy JTF_NUMBER_TABLE
41: , p10_a4 out nocopy JTF_NUMBER_TABLE
42: , p11_a0 out nocopy JTF_NUMBER_TABLE
43: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
44: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_400
45: , p11_a3 out nocopy JTF_NUMBER_TABLE
46: , p11_a4 out nocopy JTF_NUMBER_TABLE
47: );
48: procedure check_availability(p_api_version NUMBER

Line 52: , p2_a2 JTF_VARCHAR2_TABLE_400

48: procedure check_availability(p_api_version NUMBER
49: , p_init_msg_list VARCHAR2
50: , p2_a0 JTF_NUMBER_TABLE
51: , p2_a1 JTF_VARCHAR2_TABLE_100
52: , p2_a2 JTF_VARCHAR2_TABLE_400
53: , p_startdatetime DATE
54: , p_enddatetime DATE
55: , p_slotsize NUMBER
56: , x_numberofslots out nocopy NUMBER

Line 59: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_400

55: , p_slotsize NUMBER
56: , x_numberofslots out nocopy NUMBER
57: , p7_a0 out nocopy JTF_NUMBER_TABLE
58: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
59: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_400
60: , p7_a3 out nocopy JTF_NUMBER_TABLE
61: , p7_a4 out nocopy JTF_NUMBER_TABLE
62: , p8_a0 out nocopy JTF_NUMBER_TABLE
63: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 64: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_400

60: , p7_a3 out nocopy JTF_NUMBER_TABLE
61: , p7_a4 out nocopy JTF_NUMBER_TABLE
62: , p8_a0 out nocopy JTF_NUMBER_TABLE
63: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
64: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_400
65: , p8_a3 out nocopy JTF_NUMBER_TABLE
66: , p8_a4 out nocopy JTF_NUMBER_TABLE
67: , x_return_status out nocopy VARCHAR2
68: , x_msg_count out nocopy NUMBER

Line 80: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_400

76: , p_slotsize NUMBER
77: , x_numberofslots out nocopy NUMBER
78: , p7_a0 out nocopy JTF_NUMBER_TABLE
79: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
80: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_400
81: , p7_a3 out nocopy JTF_NUMBER_TABLE
82: , p7_a4 out nocopy JTF_NUMBER_TABLE
83: , p8_a0 out nocopy JTF_NUMBER_TABLE
84: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 85: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_400

81: , p7_a3 out nocopy JTF_NUMBER_TABLE
82: , p7_a4 out nocopy JTF_NUMBER_TABLE
83: , p8_a0 out nocopy JTF_NUMBER_TABLE
84: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
85: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_400
86: , p8_a3 out nocopy JTF_NUMBER_TABLE
87: , p8_a4 out nocopy JTF_NUMBER_TABLE
88: , x_return_status out nocopy VARCHAR2
89: , x_msg_count out nocopy NUMBER