DBA Data[Home] [Help]

APPS.CSP_EXCESS_LISTS_PKG_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy csp_excess_lists_pkg.excess_tbl_type, a0 JTF_NUMBER_TABLE

1: package csp_excess_lists_pkg_w AUTHID CURRENT_USER as
2: /* $Header: csptexcws.pls 120.1 2011/04/09 18:12:35 htank noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy csp_excess_lists_pkg.excess_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_NUMBER_TABLE

1: package csp_excess_lists_pkg_w AUTHID CURRENT_USER as
2: /* $Header: csptexcws.pls 120.1 2011/04/09 18:12:35 htank noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy csp_excess_lists_pkg.excess_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE

Line 5: , a2 JTF_NUMBER_TABLE

1: package csp_excess_lists_pkg_w AUTHID CURRENT_USER as
2: /* $Header: csptexcws.pls 120.1 2011/04/09 18:12:35 htank noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy csp_excess_lists_pkg.excess_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: csptexcws.pls 120.1 2011/04/09 18:12:35 htank noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy csp_excess_lists_pkg.excess_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE

Line 8: , a5 JTF_NUMBER_TABLE

4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE

Line 10: , a7 JTF_NUMBER_TABLE

6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE

Line 12: , a9 JTF_NUMBER_TABLE

8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE

Line 14: , a11 JTF_NUMBER_TABLE

10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100

Line 15: , a12 JTF_NUMBER_TABLE

11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_200

Line 16: , a13 JTF_NUMBER_TABLE

12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_200
20: , a17 JTF_VARCHAR2_TABLE_200

Line 34: , a31 JTF_NUMBER_TABLE

30: , a27 JTF_VARCHAR2_TABLE_200
31: , a28 JTF_VARCHAR2_TABLE_200
32: , a29 JTF_VARCHAR2_TABLE_200
33: , a30 JTF_VARCHAR2_TABLE_200
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_VARCHAR2_TABLE_300
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_VARCHAR2_TABLE_100
38: );

Line 36: , a33 JTF_NUMBER_TABLE

32: , a29 JTF_VARCHAR2_TABLE_200
33: , a30 JTF_VARCHAR2_TABLE_200
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_VARCHAR2_TABLE_300
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_VARCHAR2_TABLE_100
38: );
39: procedure rosetta_table_copy_out_p2(t csp_excess_lists_pkg.excess_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
40: , a1 out nocopy JTF_NUMBER_TABLE

Line 39: procedure rosetta_table_copy_out_p2(t csp_excess_lists_pkg.excess_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

35: , a32 JTF_VARCHAR2_TABLE_300
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_VARCHAR2_TABLE_100
38: );
39: procedure rosetta_table_copy_out_p2(t csp_excess_lists_pkg.excess_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
40: , a1 out nocopy JTF_NUMBER_TABLE
41: , a2 out nocopy JTF_NUMBER_TABLE
42: , a3 out nocopy JTF_NUMBER_TABLE
43: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 40: , a1 out nocopy JTF_NUMBER_TABLE

36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_VARCHAR2_TABLE_100
38: );
39: procedure rosetta_table_copy_out_p2(t csp_excess_lists_pkg.excess_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
40: , a1 out nocopy JTF_NUMBER_TABLE
41: , a2 out nocopy JTF_NUMBER_TABLE
42: , a3 out nocopy JTF_NUMBER_TABLE
43: , a4 out nocopy JTF_VARCHAR2_TABLE_100
44: , a5 out nocopy JTF_NUMBER_TABLE

Line 41: , a2 out nocopy JTF_NUMBER_TABLE

37: , a34 JTF_VARCHAR2_TABLE_100
38: );
39: procedure rosetta_table_copy_out_p2(t csp_excess_lists_pkg.excess_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
40: , a1 out nocopy JTF_NUMBER_TABLE
41: , a2 out nocopy JTF_NUMBER_TABLE
42: , a3 out nocopy JTF_NUMBER_TABLE
43: , a4 out nocopy JTF_VARCHAR2_TABLE_100
44: , a5 out nocopy JTF_NUMBER_TABLE
45: , a6 out nocopy JTF_DATE_TABLE

Line 42: , a3 out nocopy JTF_NUMBER_TABLE

38: );
39: procedure rosetta_table_copy_out_p2(t csp_excess_lists_pkg.excess_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
40: , a1 out nocopy JTF_NUMBER_TABLE
41: , a2 out nocopy JTF_NUMBER_TABLE
42: , a3 out nocopy JTF_NUMBER_TABLE
43: , a4 out nocopy JTF_VARCHAR2_TABLE_100
44: , a5 out nocopy JTF_NUMBER_TABLE
45: , a6 out nocopy JTF_DATE_TABLE
46: , a7 out nocopy JTF_NUMBER_TABLE

Line 44: , a5 out nocopy JTF_NUMBER_TABLE

40: , a1 out nocopy JTF_NUMBER_TABLE
41: , a2 out nocopy JTF_NUMBER_TABLE
42: , a3 out nocopy JTF_NUMBER_TABLE
43: , a4 out nocopy JTF_VARCHAR2_TABLE_100
44: , a5 out nocopy JTF_NUMBER_TABLE
45: , a6 out nocopy JTF_DATE_TABLE
46: , a7 out nocopy JTF_NUMBER_TABLE
47: , a8 out nocopy JTF_DATE_TABLE
48: , a9 out nocopy JTF_NUMBER_TABLE

Line 46: , a7 out nocopy JTF_NUMBER_TABLE

42: , a3 out nocopy JTF_NUMBER_TABLE
43: , a4 out nocopy JTF_VARCHAR2_TABLE_100
44: , a5 out nocopy JTF_NUMBER_TABLE
45: , a6 out nocopy JTF_DATE_TABLE
46: , a7 out nocopy JTF_NUMBER_TABLE
47: , a8 out nocopy JTF_DATE_TABLE
48: , a9 out nocopy JTF_NUMBER_TABLE
49: , a10 out nocopy JTF_VARCHAR2_TABLE_100
50: , a11 out nocopy JTF_NUMBER_TABLE

Line 48: , a9 out nocopy JTF_NUMBER_TABLE

44: , a5 out nocopy JTF_NUMBER_TABLE
45: , a6 out nocopy JTF_DATE_TABLE
46: , a7 out nocopy JTF_NUMBER_TABLE
47: , a8 out nocopy JTF_DATE_TABLE
48: , a9 out nocopy JTF_NUMBER_TABLE
49: , a10 out nocopy JTF_VARCHAR2_TABLE_100
50: , a11 out nocopy JTF_NUMBER_TABLE
51: , a12 out nocopy JTF_NUMBER_TABLE
52: , a13 out nocopy JTF_NUMBER_TABLE

Line 50: , a11 out nocopy JTF_NUMBER_TABLE

46: , a7 out nocopy JTF_NUMBER_TABLE
47: , a8 out nocopy JTF_DATE_TABLE
48: , a9 out nocopy JTF_NUMBER_TABLE
49: , a10 out nocopy JTF_VARCHAR2_TABLE_100
50: , a11 out nocopy JTF_NUMBER_TABLE
51: , a12 out nocopy JTF_NUMBER_TABLE
52: , a13 out nocopy JTF_NUMBER_TABLE
53: , a14 out nocopy JTF_VARCHAR2_TABLE_100
54: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 51: , a12 out nocopy JTF_NUMBER_TABLE

47: , a8 out nocopy JTF_DATE_TABLE
48: , a9 out nocopy JTF_NUMBER_TABLE
49: , a10 out nocopy JTF_VARCHAR2_TABLE_100
50: , a11 out nocopy JTF_NUMBER_TABLE
51: , a12 out nocopy JTF_NUMBER_TABLE
52: , a13 out nocopy JTF_NUMBER_TABLE
53: , a14 out nocopy JTF_VARCHAR2_TABLE_100
54: , a15 out nocopy JTF_VARCHAR2_TABLE_100
55: , a16 out nocopy JTF_VARCHAR2_TABLE_200

Line 52: , a13 out nocopy JTF_NUMBER_TABLE

48: , a9 out nocopy JTF_NUMBER_TABLE
49: , a10 out nocopy JTF_VARCHAR2_TABLE_100
50: , a11 out nocopy JTF_NUMBER_TABLE
51: , a12 out nocopy JTF_NUMBER_TABLE
52: , a13 out nocopy JTF_NUMBER_TABLE
53: , a14 out nocopy JTF_VARCHAR2_TABLE_100
54: , a15 out nocopy JTF_VARCHAR2_TABLE_100
55: , a16 out nocopy JTF_VARCHAR2_TABLE_200
56: , a17 out nocopy JTF_VARCHAR2_TABLE_200

Line 70: , a31 out nocopy JTF_NUMBER_TABLE

66: , a27 out nocopy JTF_VARCHAR2_TABLE_200
67: , a28 out nocopy JTF_VARCHAR2_TABLE_200
68: , a29 out nocopy JTF_VARCHAR2_TABLE_200
69: , a30 out nocopy JTF_VARCHAR2_TABLE_200
70: , a31 out nocopy JTF_NUMBER_TABLE
71: , a32 out nocopy JTF_VARCHAR2_TABLE_300
72: , a33 out nocopy JTF_NUMBER_TABLE
73: , a34 out nocopy JTF_VARCHAR2_TABLE_100
74: );

Line 72: , a33 out nocopy JTF_NUMBER_TABLE

68: , a29 out nocopy JTF_VARCHAR2_TABLE_200
69: , a30 out nocopy JTF_VARCHAR2_TABLE_200
70: , a31 out nocopy JTF_NUMBER_TABLE
71: , a32 out nocopy JTF_VARCHAR2_TABLE_300
72: , a33 out nocopy JTF_NUMBER_TABLE
73: , a34 out nocopy JTF_VARCHAR2_TABLE_100
74: );
75:
76: procedure insert_row(px_excess_line_id in out nocopy NUMBER