DBA Data[Home] [Help]

APPS.CN_WKSHT_GET_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 7: , a4 JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p1(t out nocopy cn_wksht_get_pub.wksht_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE

Line 15: , a12 JTF_VARCHAR2_TABLE_100

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

Line 16: , a13 JTF_VARCHAR2_TABLE_100

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

Line 17: , a14 JTF_VARCHAR2_TABLE_100

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

Line 19: , a16 JTF_VARCHAR2_TABLE_100

15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100

Line 20: , a17 JTF_VARCHAR2_TABLE_100

16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100

Line 21: , a18 JTF_VARCHAR2_TABLE_100

17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: );

Line 22: , a19 JTF_VARCHAR2_TABLE_100

18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: );
26: procedure rosetta_table_copy_out_p1(t cn_wksht_get_pub.wksht_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 23: , a20 JTF_VARCHAR2_TABLE_100

19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: );
26: procedure rosetta_table_copy_out_p1(t cn_wksht_get_pub.wksht_tbl, a0 out nocopy JTF_NUMBER_TABLE
27: , a1 out nocopy JTF_NUMBER_TABLE

Line 24: , a21 JTF_VARCHAR2_TABLE_100

20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: );
26: procedure rosetta_table_copy_out_p1(t cn_wksht_get_pub.wksht_tbl, a0 out nocopy JTF_NUMBER_TABLE
27: , a1 out nocopy JTF_NUMBER_TABLE
28: , a2 out nocopy JTF_VARCHAR2_TABLE_300

Line 30: , a4 out nocopy JTF_VARCHAR2_TABLE_100

26: procedure rosetta_table_copy_out_p1(t cn_wksht_get_pub.wksht_tbl, a0 out nocopy JTF_NUMBER_TABLE
27: , a1 out nocopy JTF_NUMBER_TABLE
28: , a2 out nocopy JTF_VARCHAR2_TABLE_300
29: , a3 out nocopy JTF_NUMBER_TABLE
30: , a4 out nocopy JTF_VARCHAR2_TABLE_100
31: , a5 out nocopy JTF_NUMBER_TABLE
32: , a6 out nocopy JTF_NUMBER_TABLE
33: , a7 out nocopy JTF_NUMBER_TABLE
34: , a8 out nocopy JTF_NUMBER_TABLE

Line 38: , a12 out nocopy JTF_VARCHAR2_TABLE_100

34: , a8 out nocopy JTF_NUMBER_TABLE
35: , a9 out nocopy JTF_NUMBER_TABLE
36: , a10 out nocopy JTF_NUMBER_TABLE
37: , a11 out nocopy JTF_NUMBER_TABLE
38: , a12 out nocopy JTF_VARCHAR2_TABLE_100
39: , a13 out nocopy JTF_VARCHAR2_TABLE_100
40: , a14 out nocopy JTF_VARCHAR2_TABLE_100
41: , a15 out nocopy JTF_NUMBER_TABLE
42: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 39: , a13 out nocopy JTF_VARCHAR2_TABLE_100

35: , a9 out nocopy JTF_NUMBER_TABLE
36: , a10 out nocopy JTF_NUMBER_TABLE
37: , a11 out nocopy JTF_NUMBER_TABLE
38: , a12 out nocopy JTF_VARCHAR2_TABLE_100
39: , a13 out nocopy JTF_VARCHAR2_TABLE_100
40: , a14 out nocopy JTF_VARCHAR2_TABLE_100
41: , a15 out nocopy JTF_NUMBER_TABLE
42: , a16 out nocopy JTF_VARCHAR2_TABLE_100
43: , a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 40: , a14 out nocopy JTF_VARCHAR2_TABLE_100

36: , a10 out nocopy JTF_NUMBER_TABLE
37: , a11 out nocopy JTF_NUMBER_TABLE
38: , a12 out nocopy JTF_VARCHAR2_TABLE_100
39: , a13 out nocopy JTF_VARCHAR2_TABLE_100
40: , a14 out nocopy JTF_VARCHAR2_TABLE_100
41: , a15 out nocopy JTF_NUMBER_TABLE
42: , a16 out nocopy JTF_VARCHAR2_TABLE_100
43: , a17 out nocopy JTF_VARCHAR2_TABLE_100
44: , a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 42: , a16 out nocopy JTF_VARCHAR2_TABLE_100

38: , a12 out nocopy JTF_VARCHAR2_TABLE_100
39: , a13 out nocopy JTF_VARCHAR2_TABLE_100
40: , a14 out nocopy JTF_VARCHAR2_TABLE_100
41: , a15 out nocopy JTF_NUMBER_TABLE
42: , a16 out nocopy JTF_VARCHAR2_TABLE_100
43: , a17 out nocopy JTF_VARCHAR2_TABLE_100
44: , a18 out nocopy JTF_VARCHAR2_TABLE_100
45: , a19 out nocopy JTF_VARCHAR2_TABLE_100
46: , a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 43: , a17 out nocopy JTF_VARCHAR2_TABLE_100

39: , a13 out nocopy JTF_VARCHAR2_TABLE_100
40: , a14 out nocopy JTF_VARCHAR2_TABLE_100
41: , a15 out nocopy JTF_NUMBER_TABLE
42: , a16 out nocopy JTF_VARCHAR2_TABLE_100
43: , a17 out nocopy JTF_VARCHAR2_TABLE_100
44: , a18 out nocopy JTF_VARCHAR2_TABLE_100
45: , a19 out nocopy JTF_VARCHAR2_TABLE_100
46: , a20 out nocopy JTF_VARCHAR2_TABLE_100
47: , a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 44: , a18 out nocopy JTF_VARCHAR2_TABLE_100

40: , a14 out nocopy JTF_VARCHAR2_TABLE_100
41: , a15 out nocopy JTF_NUMBER_TABLE
42: , a16 out nocopy JTF_VARCHAR2_TABLE_100
43: , a17 out nocopy JTF_VARCHAR2_TABLE_100
44: , a18 out nocopy JTF_VARCHAR2_TABLE_100
45: , a19 out nocopy JTF_VARCHAR2_TABLE_100
46: , a20 out nocopy JTF_VARCHAR2_TABLE_100
47: , a21 out nocopy JTF_VARCHAR2_TABLE_100
48: );

Line 45: , a19 out nocopy JTF_VARCHAR2_TABLE_100

41: , a15 out nocopy JTF_NUMBER_TABLE
42: , a16 out nocopy JTF_VARCHAR2_TABLE_100
43: , a17 out nocopy JTF_VARCHAR2_TABLE_100
44: , a18 out nocopy JTF_VARCHAR2_TABLE_100
45: , a19 out nocopy JTF_VARCHAR2_TABLE_100
46: , a20 out nocopy JTF_VARCHAR2_TABLE_100
47: , a21 out nocopy JTF_VARCHAR2_TABLE_100
48: );
49:

Line 46: , a20 out nocopy JTF_VARCHAR2_TABLE_100

42: , a16 out nocopy JTF_VARCHAR2_TABLE_100
43: , a17 out nocopy JTF_VARCHAR2_TABLE_100
44: , a18 out nocopy JTF_VARCHAR2_TABLE_100
45: , a19 out nocopy JTF_VARCHAR2_TABLE_100
46: , a20 out nocopy JTF_VARCHAR2_TABLE_100
47: , a21 out nocopy JTF_VARCHAR2_TABLE_100
48: );
49:
50: procedure get_srp_wksht(p_api_version NUMBER

Line 47: , a21 out nocopy JTF_VARCHAR2_TABLE_100

43: , a17 out nocopy JTF_VARCHAR2_TABLE_100
44: , a18 out nocopy JTF_VARCHAR2_TABLE_100
45: , a19 out nocopy JTF_VARCHAR2_TABLE_100
46: , a20 out nocopy JTF_VARCHAR2_TABLE_100
47: , a21 out nocopy JTF_VARCHAR2_TABLE_100
48: );
49:
50: procedure get_srp_wksht(p_api_version NUMBER
51: , p_init_msg_list VARCHAR2

Line 72: , p18_a4 out nocopy JTF_VARCHAR2_TABLE_100

68: , p18_a0 out nocopy JTF_NUMBER_TABLE
69: , p18_a1 out nocopy JTF_NUMBER_TABLE
70: , p18_a2 out nocopy JTF_VARCHAR2_TABLE_300
71: , p18_a3 out nocopy JTF_NUMBER_TABLE
72: , p18_a4 out nocopy JTF_VARCHAR2_TABLE_100
73: , p18_a5 out nocopy JTF_NUMBER_TABLE
74: , p18_a6 out nocopy JTF_NUMBER_TABLE
75: , p18_a7 out nocopy JTF_NUMBER_TABLE
76: , p18_a8 out nocopy JTF_NUMBER_TABLE

Line 80: , p18_a12 out nocopy JTF_VARCHAR2_TABLE_100

76: , p18_a8 out nocopy JTF_NUMBER_TABLE
77: , p18_a9 out nocopy JTF_NUMBER_TABLE
78: , p18_a10 out nocopy JTF_NUMBER_TABLE
79: , p18_a11 out nocopy JTF_NUMBER_TABLE
80: , p18_a12 out nocopy JTF_VARCHAR2_TABLE_100
81: , p18_a13 out nocopy JTF_VARCHAR2_TABLE_100
82: , p18_a14 out nocopy JTF_VARCHAR2_TABLE_100
83: , p18_a15 out nocopy JTF_NUMBER_TABLE
84: , p18_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 81: , p18_a13 out nocopy JTF_VARCHAR2_TABLE_100

77: , p18_a9 out nocopy JTF_NUMBER_TABLE
78: , p18_a10 out nocopy JTF_NUMBER_TABLE
79: , p18_a11 out nocopy JTF_NUMBER_TABLE
80: , p18_a12 out nocopy JTF_VARCHAR2_TABLE_100
81: , p18_a13 out nocopy JTF_VARCHAR2_TABLE_100
82: , p18_a14 out nocopy JTF_VARCHAR2_TABLE_100
83: , p18_a15 out nocopy JTF_NUMBER_TABLE
84: , p18_a16 out nocopy JTF_VARCHAR2_TABLE_100
85: , p18_a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 82: , p18_a14 out nocopy JTF_VARCHAR2_TABLE_100

78: , p18_a10 out nocopy JTF_NUMBER_TABLE
79: , p18_a11 out nocopy JTF_NUMBER_TABLE
80: , p18_a12 out nocopy JTF_VARCHAR2_TABLE_100
81: , p18_a13 out nocopy JTF_VARCHAR2_TABLE_100
82: , p18_a14 out nocopy JTF_VARCHAR2_TABLE_100
83: , p18_a15 out nocopy JTF_NUMBER_TABLE
84: , p18_a16 out nocopy JTF_VARCHAR2_TABLE_100
85: , p18_a17 out nocopy JTF_VARCHAR2_TABLE_100
86: , p18_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 84: , p18_a16 out nocopy JTF_VARCHAR2_TABLE_100

80: , p18_a12 out nocopy JTF_VARCHAR2_TABLE_100
81: , p18_a13 out nocopy JTF_VARCHAR2_TABLE_100
82: , p18_a14 out nocopy JTF_VARCHAR2_TABLE_100
83: , p18_a15 out nocopy JTF_NUMBER_TABLE
84: , p18_a16 out nocopy JTF_VARCHAR2_TABLE_100
85: , p18_a17 out nocopy JTF_VARCHAR2_TABLE_100
86: , p18_a18 out nocopy JTF_VARCHAR2_TABLE_100
87: , p18_a19 out nocopy JTF_VARCHAR2_TABLE_100
88: , p18_a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 85: , p18_a17 out nocopy JTF_VARCHAR2_TABLE_100

81: , p18_a13 out nocopy JTF_VARCHAR2_TABLE_100
82: , p18_a14 out nocopy JTF_VARCHAR2_TABLE_100
83: , p18_a15 out nocopy JTF_NUMBER_TABLE
84: , p18_a16 out nocopy JTF_VARCHAR2_TABLE_100
85: , p18_a17 out nocopy JTF_VARCHAR2_TABLE_100
86: , p18_a18 out nocopy JTF_VARCHAR2_TABLE_100
87: , p18_a19 out nocopy JTF_VARCHAR2_TABLE_100
88: , p18_a20 out nocopy JTF_VARCHAR2_TABLE_100
89: , p18_a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 86: , p18_a18 out nocopy JTF_VARCHAR2_TABLE_100

82: , p18_a14 out nocopy JTF_VARCHAR2_TABLE_100
83: , p18_a15 out nocopy JTF_NUMBER_TABLE
84: , p18_a16 out nocopy JTF_VARCHAR2_TABLE_100
85: , p18_a17 out nocopy JTF_VARCHAR2_TABLE_100
86: , p18_a18 out nocopy JTF_VARCHAR2_TABLE_100
87: , p18_a19 out nocopy JTF_VARCHAR2_TABLE_100
88: , p18_a20 out nocopy JTF_VARCHAR2_TABLE_100
89: , p18_a21 out nocopy JTF_VARCHAR2_TABLE_100
90: , x_tot_amount_earnings out nocopy NUMBER

Line 87: , p18_a19 out nocopy JTF_VARCHAR2_TABLE_100

83: , p18_a15 out nocopy JTF_NUMBER_TABLE
84: , p18_a16 out nocopy JTF_VARCHAR2_TABLE_100
85: , p18_a17 out nocopy JTF_VARCHAR2_TABLE_100
86: , p18_a18 out nocopy JTF_VARCHAR2_TABLE_100
87: , p18_a19 out nocopy JTF_VARCHAR2_TABLE_100
88: , p18_a20 out nocopy JTF_VARCHAR2_TABLE_100
89: , p18_a21 out nocopy JTF_VARCHAR2_TABLE_100
90: , x_tot_amount_earnings out nocopy NUMBER
91: , x_tot_amount_adj out nocopy NUMBER

Line 88: , p18_a20 out nocopy JTF_VARCHAR2_TABLE_100

84: , p18_a16 out nocopy JTF_VARCHAR2_TABLE_100
85: , p18_a17 out nocopy JTF_VARCHAR2_TABLE_100
86: , p18_a18 out nocopy JTF_VARCHAR2_TABLE_100
87: , p18_a19 out nocopy JTF_VARCHAR2_TABLE_100
88: , p18_a20 out nocopy JTF_VARCHAR2_TABLE_100
89: , p18_a21 out nocopy JTF_VARCHAR2_TABLE_100
90: , x_tot_amount_earnings out nocopy NUMBER
91: , x_tot_amount_adj out nocopy NUMBER
92: , x_tot_amount_adj_rec out nocopy NUMBER

Line 89: , p18_a21 out nocopy JTF_VARCHAR2_TABLE_100

85: , p18_a17 out nocopy JTF_VARCHAR2_TABLE_100
86: , p18_a18 out nocopy JTF_VARCHAR2_TABLE_100
87: , p18_a19 out nocopy JTF_VARCHAR2_TABLE_100
88: , p18_a20 out nocopy JTF_VARCHAR2_TABLE_100
89: , p18_a21 out nocopy JTF_VARCHAR2_TABLE_100
90: , x_tot_amount_earnings out nocopy NUMBER
91: , x_tot_amount_adj out nocopy NUMBER
92: , x_tot_amount_adj_rec out nocopy NUMBER
93: , x_tot_amount_total out nocopy NUMBER