APPS.CSI_TRANSACTIONS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package csi_transactions_pvt_w as
2: /* $Header: csivtxws.pls 120.12 2008/01/15 03:31:55 devijay ship $ */
3: procedure rosetta_table_copy_in_p4(t out nocopy csi_transactions_pvt.util_order_by_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: );
6: procedure rosetta_table_copy_out_p4(t csi_transactions_pvt.util_order_by_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
7: , a1 out nocopy JTF_VARCHAR2_TABLE_100
8: );

Line 7: , a1 out nocopy JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p4(t out nocopy csi_transactions_pvt.util_order_by_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: );
6: procedure rosetta_table_copy_out_p4(t csi_transactions_pvt.util_order_by_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
7: , a1 out nocopy JTF_VARCHAR2_TABLE_100
8: );
9:
10: procedure get_transactions(p_api_version_number NUMBER
11: , p_init_msg_list VARCHAR2

Line 26: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100

22: , p12_a2 out nocopy JTF_DATE_TABLE
23: , p12_a3 out nocopy JTF_NUMBER_TABLE
24: , p12_a4 out nocopy JTF_NUMBER_TABLE
25: , p12_a5 out nocopy JTF_NUMBER_TABLE
26: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
27: , p12_a7 out nocopy JTF_NUMBER_TABLE
28: , p12_a8 out nocopy JTF_VARCHAR2_TABLE_100
29: , p12_a9 out nocopy JTF_NUMBER_TABLE
30: , p12_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 28: , p12_a8 out nocopy JTF_VARCHAR2_TABLE_100

24: , p12_a4 out nocopy JTF_NUMBER_TABLE
25: , p12_a5 out nocopy JTF_NUMBER_TABLE
26: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
27: , p12_a7 out nocopy JTF_NUMBER_TABLE
28: , p12_a8 out nocopy JTF_VARCHAR2_TABLE_100
29: , p12_a9 out nocopy JTF_NUMBER_TABLE
30: , p12_a10 out nocopy JTF_VARCHAR2_TABLE_100
31: , p12_a11 out nocopy JTF_NUMBER_TABLE
32: , p12_a12 out nocopy JTF_NUMBER_TABLE

Line 30: , p12_a10 out nocopy JTF_VARCHAR2_TABLE_100

26: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
27: , p12_a7 out nocopy JTF_NUMBER_TABLE
28: , p12_a8 out nocopy JTF_VARCHAR2_TABLE_100
29: , p12_a9 out nocopy JTF_NUMBER_TABLE
30: , p12_a10 out nocopy JTF_VARCHAR2_TABLE_100
31: , p12_a11 out nocopy JTF_NUMBER_TABLE
32: , p12_a12 out nocopy JTF_NUMBER_TABLE
33: , p12_a13 out nocopy JTF_NUMBER_TABLE
34: , p12_a14 out nocopy JTF_NUMBER_TABLE

Line 35: , p12_a15 out nocopy JTF_VARCHAR2_TABLE_100

31: , p12_a11 out nocopy JTF_NUMBER_TABLE
32: , p12_a12 out nocopy JTF_NUMBER_TABLE
33: , p12_a13 out nocopy JTF_NUMBER_TABLE
34: , p12_a14 out nocopy JTF_NUMBER_TABLE
35: , p12_a15 out nocopy JTF_VARCHAR2_TABLE_100
36: , p12_a16 out nocopy JTF_NUMBER_TABLE
37: , p12_a17 out nocopy JTF_VARCHAR2_TABLE_100
38: , p12_a18 out nocopy JTF_VARCHAR2_TABLE_100
39: , p12_a19 out nocopy JTF_NUMBER_TABLE

Line 37: , p12_a17 out nocopy JTF_VARCHAR2_TABLE_100

33: , p12_a13 out nocopy JTF_NUMBER_TABLE
34: , p12_a14 out nocopy JTF_NUMBER_TABLE
35: , p12_a15 out nocopy JTF_VARCHAR2_TABLE_100
36: , p12_a16 out nocopy JTF_NUMBER_TABLE
37: , p12_a17 out nocopy JTF_VARCHAR2_TABLE_100
38: , p12_a18 out nocopy JTF_VARCHAR2_TABLE_100
39: , p12_a19 out nocopy JTF_NUMBER_TABLE
40: , p12_a20 out nocopy JTF_VARCHAR2_TABLE_100
41: , p12_a21 out nocopy JTF_VARCHAR2_TABLE_200

Line 38: , p12_a18 out nocopy JTF_VARCHAR2_TABLE_100

34: , p12_a14 out nocopy JTF_NUMBER_TABLE
35: , p12_a15 out nocopy JTF_VARCHAR2_TABLE_100
36: , p12_a16 out nocopy JTF_NUMBER_TABLE
37: , p12_a17 out nocopy JTF_VARCHAR2_TABLE_100
38: , p12_a18 out nocopy JTF_VARCHAR2_TABLE_100
39: , p12_a19 out nocopy JTF_NUMBER_TABLE
40: , p12_a20 out nocopy JTF_VARCHAR2_TABLE_100
41: , p12_a21 out nocopy JTF_VARCHAR2_TABLE_200
42: , p12_a22 out nocopy JTF_VARCHAR2_TABLE_200

Line 40: , p12_a20 out nocopy JTF_VARCHAR2_TABLE_100

36: , p12_a16 out nocopy JTF_NUMBER_TABLE
37: , p12_a17 out nocopy JTF_VARCHAR2_TABLE_100
38: , p12_a18 out nocopy JTF_VARCHAR2_TABLE_100
39: , p12_a19 out nocopy JTF_NUMBER_TABLE
40: , p12_a20 out nocopy JTF_VARCHAR2_TABLE_100
41: , p12_a21 out nocopy JTF_VARCHAR2_TABLE_200
42: , p12_a22 out nocopy JTF_VARCHAR2_TABLE_200
43: , p12_a23 out nocopy JTF_VARCHAR2_TABLE_200
44: , p12_a24 out nocopy JTF_VARCHAR2_TABLE_200

Line 57: , p12_a37 out nocopy JTF_VARCHAR2_TABLE_100

53: , p12_a33 out nocopy JTF_VARCHAR2_TABLE_200
54: , p12_a34 out nocopy JTF_VARCHAR2_TABLE_200
55: , p12_a35 out nocopy JTF_VARCHAR2_TABLE_200
56: , p12_a36 out nocopy JTF_NUMBER_TABLE
57: , p12_a37 out nocopy JTF_VARCHAR2_TABLE_100
58: , p12_a38 out nocopy JTF_NUMBER_TABLE
59: , p12_a39 out nocopy JTF_VARCHAR2_TABLE_100
60: , p12_a40 out nocopy JTF_VARCHAR2_TABLE_100
61: , p12_a41 out nocopy JTF_VARCHAR2_TABLE_100

Line 59: , p12_a39 out nocopy JTF_VARCHAR2_TABLE_100

55: , p12_a35 out nocopy JTF_VARCHAR2_TABLE_200
56: , p12_a36 out nocopy JTF_NUMBER_TABLE
57: , p12_a37 out nocopy JTF_VARCHAR2_TABLE_100
58: , p12_a38 out nocopy JTF_NUMBER_TABLE
59: , p12_a39 out nocopy JTF_VARCHAR2_TABLE_100
60: , p12_a40 out nocopy JTF_VARCHAR2_TABLE_100
61: , p12_a41 out nocopy JTF_VARCHAR2_TABLE_100
62: , p12_a42 out nocopy JTF_VARCHAR2_TABLE_300
63: , p12_a43 out nocopy JTF_VARCHAR2_TABLE_100

Line 60: , p12_a40 out nocopy JTF_VARCHAR2_TABLE_100

56: , p12_a36 out nocopy JTF_NUMBER_TABLE
57: , p12_a37 out nocopy JTF_VARCHAR2_TABLE_100
58: , p12_a38 out nocopy JTF_NUMBER_TABLE
59: , p12_a39 out nocopy JTF_VARCHAR2_TABLE_100
60: , p12_a40 out nocopy JTF_VARCHAR2_TABLE_100
61: , p12_a41 out nocopy JTF_VARCHAR2_TABLE_100
62: , p12_a42 out nocopy JTF_VARCHAR2_TABLE_300
63: , p12_a43 out nocopy JTF_VARCHAR2_TABLE_100
64: , x_returned_rec_count out nocopy NUMBER

Line 61: , p12_a41 out nocopy JTF_VARCHAR2_TABLE_100

57: , p12_a37 out nocopy JTF_VARCHAR2_TABLE_100
58: , p12_a38 out nocopy JTF_NUMBER_TABLE
59: , p12_a39 out nocopy JTF_VARCHAR2_TABLE_100
60: , p12_a40 out nocopy JTF_VARCHAR2_TABLE_100
61: , p12_a41 out nocopy JTF_VARCHAR2_TABLE_100
62: , p12_a42 out nocopy JTF_VARCHAR2_TABLE_300
63: , p12_a43 out nocopy JTF_VARCHAR2_TABLE_100
64: , x_returned_rec_count out nocopy NUMBER
65: , x_next_rec_ptr out nocopy NUMBER

Line 63: , p12_a43 out nocopy JTF_VARCHAR2_TABLE_100

59: , p12_a39 out nocopy JTF_VARCHAR2_TABLE_100
60: , p12_a40 out nocopy JTF_VARCHAR2_TABLE_100
61: , p12_a41 out nocopy JTF_VARCHAR2_TABLE_100
62: , p12_a42 out nocopy JTF_VARCHAR2_TABLE_300
63: , p12_a43 out nocopy JTF_VARCHAR2_TABLE_100
64: , x_returned_rec_count out nocopy NUMBER
65: , x_next_rec_ptr out nocopy NUMBER
66: , x_tot_rec_count out nocopy NUMBER
67: , p4_a0 NUMBER := 0-1962.0724