APPS.IEX_STATUS_RULE_PUB_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy iex_status_rule_pub.status_rule_tbl_type, a0 JTF_NUMBER_TABLE

1: package iex_status_rule_pub_w as
2: /* $Header: iexwcsts.pls 120.1 2005/07/06 14:10:27 schekuri noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy iex_status_rule_pub.status_rule_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE

Line 9: , a6 JTF_NUMBER_TABLE

5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE

Line 11: , a8 JTF_NUMBER_TABLE

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

Line 12: , a9 JTF_NUMBER_TABLE

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

Line 13: , a10 JTF_NUMBER_TABLE

9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: );
17: procedure rosetta_table_copy_out_p1(t iex_status_rule_pub.status_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 14: , a11 JTF_NUMBER_TABLE

10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: );
17: procedure rosetta_table_copy_out_p1(t iex_status_rule_pub.status_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
18: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 15: , a12 JTF_NUMBER_TABLE

11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: );
17: procedure rosetta_table_copy_out_p1(t iex_status_rule_pub.status_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
18: , a1 out nocopy JTF_VARCHAR2_TABLE_100
19: , a2 out nocopy JTF_VARCHAR2_TABLE_200

Line 17: procedure rosetta_table_copy_out_p1(t iex_status_rule_pub.status_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: );
17: procedure rosetta_table_copy_out_p1(t iex_status_rule_pub.status_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
18: , a1 out nocopy JTF_VARCHAR2_TABLE_100
19: , a2 out nocopy JTF_VARCHAR2_TABLE_200
20: , a3 out nocopy JTF_DATE_TABLE
21: , a4 out nocopy JTF_DATE_TABLE

Line 23: , a6 out nocopy JTF_NUMBER_TABLE

19: , a2 out nocopy JTF_VARCHAR2_TABLE_200
20: , a3 out nocopy JTF_DATE_TABLE
21: , a4 out nocopy JTF_DATE_TABLE
22: , a5 out nocopy JTF_DATE_TABLE
23: , a6 out nocopy JTF_NUMBER_TABLE
24: , a7 out nocopy JTF_DATE_TABLE
25: , a8 out nocopy JTF_NUMBER_TABLE
26: , a9 out nocopy JTF_NUMBER_TABLE
27: , a10 out nocopy JTF_NUMBER_TABLE

Line 25: , a8 out nocopy JTF_NUMBER_TABLE

21: , a4 out nocopy JTF_DATE_TABLE
22: , a5 out nocopy JTF_DATE_TABLE
23: , a6 out nocopy JTF_NUMBER_TABLE
24: , a7 out nocopy JTF_DATE_TABLE
25: , a8 out nocopy JTF_NUMBER_TABLE
26: , a9 out nocopy JTF_NUMBER_TABLE
27: , a10 out nocopy JTF_NUMBER_TABLE
28: , a11 out nocopy JTF_NUMBER_TABLE
29: , a12 out nocopy JTF_NUMBER_TABLE

Line 26: , a9 out nocopy JTF_NUMBER_TABLE

22: , a5 out nocopy JTF_DATE_TABLE
23: , a6 out nocopy JTF_NUMBER_TABLE
24: , a7 out nocopy JTF_DATE_TABLE
25: , a8 out nocopy JTF_NUMBER_TABLE
26: , a9 out nocopy JTF_NUMBER_TABLE
27: , a10 out nocopy JTF_NUMBER_TABLE
28: , a11 out nocopy JTF_NUMBER_TABLE
29: , a12 out nocopy JTF_NUMBER_TABLE
30: );

Line 27: , a10 out nocopy JTF_NUMBER_TABLE

23: , a6 out nocopy JTF_NUMBER_TABLE
24: , a7 out nocopy JTF_DATE_TABLE
25: , a8 out nocopy JTF_NUMBER_TABLE
26: , a9 out nocopy JTF_NUMBER_TABLE
27: , a10 out nocopy JTF_NUMBER_TABLE
28: , a11 out nocopy JTF_NUMBER_TABLE
29: , a12 out nocopy JTF_NUMBER_TABLE
30: );
31:

Line 28: , a11 out nocopy JTF_NUMBER_TABLE

24: , a7 out nocopy JTF_DATE_TABLE
25: , a8 out nocopy JTF_NUMBER_TABLE
26: , a9 out nocopy JTF_NUMBER_TABLE
27: , a10 out nocopy JTF_NUMBER_TABLE
28: , a11 out nocopy JTF_NUMBER_TABLE
29: , a12 out nocopy JTF_NUMBER_TABLE
30: );
31:
32: procedure rosetta_table_copy_in_p3(t out nocopy iex_status_rule_pub.status_rule_line_tbl_type, a0 JTF_NUMBER_TABLE

Line 29: , a12 out nocopy JTF_NUMBER_TABLE

25: , a8 out nocopy JTF_NUMBER_TABLE
26: , a9 out nocopy JTF_NUMBER_TABLE
27: , a10 out nocopy JTF_NUMBER_TABLE
28: , a11 out nocopy JTF_NUMBER_TABLE
29: , a12 out nocopy JTF_NUMBER_TABLE
30: );
31:
32: procedure rosetta_table_copy_in_p3(t out nocopy iex_status_rule_pub.status_rule_line_tbl_type, a0 JTF_NUMBER_TABLE
33: , a1 JTF_VARCHAR2_TABLE_100

Line 32: procedure rosetta_table_copy_in_p3(t out nocopy iex_status_rule_pub.status_rule_line_tbl_type, a0 JTF_NUMBER_TABLE

28: , a11 out nocopy JTF_NUMBER_TABLE
29: , a12 out nocopy JTF_NUMBER_TABLE
30: );
31:
32: procedure rosetta_table_copy_in_p3(t out nocopy iex_status_rule_pub.status_rule_line_tbl_type, a0 JTF_NUMBER_TABLE
33: , a1 JTF_VARCHAR2_TABLE_100
34: , a2 JTF_NUMBER_TABLE
35: , a3 JTF_VARCHAR2_TABLE_100
36: , a4 JTF_NUMBER_TABLE

Line 34: , a2 JTF_NUMBER_TABLE

30: );
31:
32: procedure rosetta_table_copy_in_p3(t out nocopy iex_status_rule_pub.status_rule_line_tbl_type, a0 JTF_NUMBER_TABLE
33: , a1 JTF_VARCHAR2_TABLE_100
34: , a2 JTF_NUMBER_TABLE
35: , a3 JTF_VARCHAR2_TABLE_100
36: , a4 JTF_NUMBER_TABLE
37: , a5 JTF_DATE_TABLE
38: , a6 JTF_NUMBER_TABLE

Line 36: , a4 JTF_NUMBER_TABLE

32: procedure rosetta_table_copy_in_p3(t out nocopy iex_status_rule_pub.status_rule_line_tbl_type, a0 JTF_NUMBER_TABLE
33: , a1 JTF_VARCHAR2_TABLE_100
34: , a2 JTF_NUMBER_TABLE
35: , a3 JTF_VARCHAR2_TABLE_100
36: , a4 JTF_NUMBER_TABLE
37: , a5 JTF_DATE_TABLE
38: , a6 JTF_NUMBER_TABLE
39: , a7 JTF_DATE_TABLE
40: , a8 JTF_NUMBER_TABLE

Line 38: , a6 JTF_NUMBER_TABLE

34: , a2 JTF_NUMBER_TABLE
35: , a3 JTF_VARCHAR2_TABLE_100
36: , a4 JTF_NUMBER_TABLE
37: , a5 JTF_DATE_TABLE
38: , a6 JTF_NUMBER_TABLE
39: , a7 JTF_DATE_TABLE
40: , a8 JTF_NUMBER_TABLE
41: , a9 JTF_NUMBER_TABLE
42: , a10 JTF_NUMBER_TABLE

Line 40: , a8 JTF_NUMBER_TABLE

36: , a4 JTF_NUMBER_TABLE
37: , a5 JTF_DATE_TABLE
38: , a6 JTF_NUMBER_TABLE
39: , a7 JTF_DATE_TABLE
40: , a8 JTF_NUMBER_TABLE
41: , a9 JTF_NUMBER_TABLE
42: , a10 JTF_NUMBER_TABLE
43: , a11 JTF_NUMBER_TABLE
44: , a12 JTF_NUMBER_TABLE

Line 41: , a9 JTF_NUMBER_TABLE

37: , a5 JTF_DATE_TABLE
38: , a6 JTF_NUMBER_TABLE
39: , a7 JTF_DATE_TABLE
40: , a8 JTF_NUMBER_TABLE
41: , a9 JTF_NUMBER_TABLE
42: , a10 JTF_NUMBER_TABLE
43: , a11 JTF_NUMBER_TABLE
44: , a12 JTF_NUMBER_TABLE
45: );

Line 42: , a10 JTF_NUMBER_TABLE

38: , a6 JTF_NUMBER_TABLE
39: , a7 JTF_DATE_TABLE
40: , a8 JTF_NUMBER_TABLE
41: , a9 JTF_NUMBER_TABLE
42: , a10 JTF_NUMBER_TABLE
43: , a11 JTF_NUMBER_TABLE
44: , a12 JTF_NUMBER_TABLE
45: );
46: procedure rosetta_table_copy_out_p3(t iex_status_rule_pub.status_rule_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 43: , a11 JTF_NUMBER_TABLE

39: , a7 JTF_DATE_TABLE
40: , a8 JTF_NUMBER_TABLE
41: , a9 JTF_NUMBER_TABLE
42: , a10 JTF_NUMBER_TABLE
43: , a11 JTF_NUMBER_TABLE
44: , a12 JTF_NUMBER_TABLE
45: );
46: procedure rosetta_table_copy_out_p3(t iex_status_rule_pub.status_rule_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
47: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 44: , a12 JTF_NUMBER_TABLE

40: , a8 JTF_NUMBER_TABLE
41: , a9 JTF_NUMBER_TABLE
42: , a10 JTF_NUMBER_TABLE
43: , a11 JTF_NUMBER_TABLE
44: , a12 JTF_NUMBER_TABLE
45: );
46: procedure rosetta_table_copy_out_p3(t iex_status_rule_pub.status_rule_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
47: , a1 out nocopy JTF_VARCHAR2_TABLE_100
48: , a2 out nocopy JTF_NUMBER_TABLE

Line 46: procedure rosetta_table_copy_out_p3(t iex_status_rule_pub.status_rule_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

42: , a10 JTF_NUMBER_TABLE
43: , a11 JTF_NUMBER_TABLE
44: , a12 JTF_NUMBER_TABLE
45: );
46: procedure rosetta_table_copy_out_p3(t iex_status_rule_pub.status_rule_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
47: , a1 out nocopy JTF_VARCHAR2_TABLE_100
48: , a2 out nocopy JTF_NUMBER_TABLE
49: , a3 out nocopy JTF_VARCHAR2_TABLE_100
50: , a4 out nocopy JTF_NUMBER_TABLE

Line 48: , a2 out nocopy JTF_NUMBER_TABLE

44: , a12 JTF_NUMBER_TABLE
45: );
46: procedure rosetta_table_copy_out_p3(t iex_status_rule_pub.status_rule_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
47: , a1 out nocopy JTF_VARCHAR2_TABLE_100
48: , a2 out nocopy JTF_NUMBER_TABLE
49: , a3 out nocopy JTF_VARCHAR2_TABLE_100
50: , a4 out nocopy JTF_NUMBER_TABLE
51: , a5 out nocopy JTF_DATE_TABLE
52: , a6 out nocopy JTF_NUMBER_TABLE

Line 50: , a4 out nocopy JTF_NUMBER_TABLE

46: procedure rosetta_table_copy_out_p3(t iex_status_rule_pub.status_rule_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
47: , a1 out nocopy JTF_VARCHAR2_TABLE_100
48: , a2 out nocopy JTF_NUMBER_TABLE
49: , a3 out nocopy JTF_VARCHAR2_TABLE_100
50: , a4 out nocopy JTF_NUMBER_TABLE
51: , a5 out nocopy JTF_DATE_TABLE
52: , a6 out nocopy JTF_NUMBER_TABLE
53: , a7 out nocopy JTF_DATE_TABLE
54: , a8 out nocopy JTF_NUMBER_TABLE

Line 52: , a6 out nocopy JTF_NUMBER_TABLE

48: , a2 out nocopy JTF_NUMBER_TABLE
49: , a3 out nocopy JTF_VARCHAR2_TABLE_100
50: , a4 out nocopy JTF_NUMBER_TABLE
51: , a5 out nocopy JTF_DATE_TABLE
52: , a6 out nocopy JTF_NUMBER_TABLE
53: , a7 out nocopy JTF_DATE_TABLE
54: , a8 out nocopy JTF_NUMBER_TABLE
55: , a9 out nocopy JTF_NUMBER_TABLE
56: , a10 out nocopy JTF_NUMBER_TABLE

Line 54: , a8 out nocopy JTF_NUMBER_TABLE

50: , a4 out nocopy JTF_NUMBER_TABLE
51: , a5 out nocopy JTF_DATE_TABLE
52: , a6 out nocopy JTF_NUMBER_TABLE
53: , a7 out nocopy JTF_DATE_TABLE
54: , a8 out nocopy JTF_NUMBER_TABLE
55: , a9 out nocopy JTF_NUMBER_TABLE
56: , a10 out nocopy JTF_NUMBER_TABLE
57: , a11 out nocopy JTF_NUMBER_TABLE
58: , a12 out nocopy JTF_NUMBER_TABLE

Line 55: , a9 out nocopy JTF_NUMBER_TABLE

51: , a5 out nocopy JTF_DATE_TABLE
52: , a6 out nocopy JTF_NUMBER_TABLE
53: , a7 out nocopy JTF_DATE_TABLE
54: , a8 out nocopy JTF_NUMBER_TABLE
55: , a9 out nocopy JTF_NUMBER_TABLE
56: , a10 out nocopy JTF_NUMBER_TABLE
57: , a11 out nocopy JTF_NUMBER_TABLE
58: , a12 out nocopy JTF_NUMBER_TABLE
59: );

Line 56: , a10 out nocopy JTF_NUMBER_TABLE

52: , a6 out nocopy JTF_NUMBER_TABLE
53: , a7 out nocopy JTF_DATE_TABLE
54: , a8 out nocopy JTF_NUMBER_TABLE
55: , a9 out nocopy JTF_NUMBER_TABLE
56: , a10 out nocopy JTF_NUMBER_TABLE
57: , a11 out nocopy JTF_NUMBER_TABLE
58: , a12 out nocopy JTF_NUMBER_TABLE
59: );
60:

Line 57: , a11 out nocopy JTF_NUMBER_TABLE

53: , a7 out nocopy JTF_DATE_TABLE
54: , a8 out nocopy JTF_NUMBER_TABLE
55: , a9 out nocopy JTF_NUMBER_TABLE
56: , a10 out nocopy JTF_NUMBER_TABLE
57: , a11 out nocopy JTF_NUMBER_TABLE
58: , a12 out nocopy JTF_NUMBER_TABLE
59: );
60:
61: procedure rosetta_table_copy_in_p4(t out nocopy iex_status_rule_pub.status_rule_id_tbl_type, a0 JTF_NUMBER_TABLE);

Line 58: , a12 out nocopy JTF_NUMBER_TABLE

54: , a8 out nocopy JTF_NUMBER_TABLE
55: , a9 out nocopy JTF_NUMBER_TABLE
56: , a10 out nocopy JTF_NUMBER_TABLE
57: , a11 out nocopy JTF_NUMBER_TABLE
58: , a12 out nocopy JTF_NUMBER_TABLE
59: );
60:
61: procedure rosetta_table_copy_in_p4(t out nocopy iex_status_rule_pub.status_rule_id_tbl_type, a0 JTF_NUMBER_TABLE);
62: procedure rosetta_table_copy_out_p4(t iex_status_rule_pub.status_rule_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);

Line 61: procedure rosetta_table_copy_in_p4(t out nocopy iex_status_rule_pub.status_rule_id_tbl_type, a0 JTF_NUMBER_TABLE);

57: , a11 out nocopy JTF_NUMBER_TABLE
58: , a12 out nocopy JTF_NUMBER_TABLE
59: );
60:
61: procedure rosetta_table_copy_in_p4(t out nocopy iex_status_rule_pub.status_rule_id_tbl_type, a0 JTF_NUMBER_TABLE);
62: procedure rosetta_table_copy_out_p4(t iex_status_rule_pub.status_rule_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
63:
64: procedure rosetta_table_copy_in_p5(t out nocopy iex_status_rule_pub.status_rule_line_id_tbl_type, a0 JTF_NUMBER_TABLE);
65: procedure rosetta_table_copy_out_p5(t iex_status_rule_pub.status_rule_line_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);

Line 62: procedure rosetta_table_copy_out_p4(t iex_status_rule_pub.status_rule_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);

58: , a12 out nocopy JTF_NUMBER_TABLE
59: );
60:
61: procedure rosetta_table_copy_in_p4(t out nocopy iex_status_rule_pub.status_rule_id_tbl_type, a0 JTF_NUMBER_TABLE);
62: procedure rosetta_table_copy_out_p4(t iex_status_rule_pub.status_rule_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
63:
64: procedure rosetta_table_copy_in_p5(t out nocopy iex_status_rule_pub.status_rule_line_id_tbl_type, a0 JTF_NUMBER_TABLE);
65: procedure rosetta_table_copy_out_p5(t iex_status_rule_pub.status_rule_line_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
66:

Line 64: procedure rosetta_table_copy_in_p5(t out nocopy iex_status_rule_pub.status_rule_line_id_tbl_type, a0 JTF_NUMBER_TABLE);

60:
61: procedure rosetta_table_copy_in_p4(t out nocopy iex_status_rule_pub.status_rule_id_tbl_type, a0 JTF_NUMBER_TABLE);
62: procedure rosetta_table_copy_out_p4(t iex_status_rule_pub.status_rule_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
63:
64: procedure rosetta_table_copy_in_p5(t out nocopy iex_status_rule_pub.status_rule_line_id_tbl_type, a0 JTF_NUMBER_TABLE);
65: procedure rosetta_table_copy_out_p5(t iex_status_rule_pub.status_rule_line_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
66:
67: procedure create_status_rule(p_api_version NUMBER
68: , p_init_msg_list VARCHAR2

Line 65: procedure rosetta_table_copy_out_p5(t iex_status_rule_pub.status_rule_line_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);

61: procedure rosetta_table_copy_in_p4(t out nocopy iex_status_rule_pub.status_rule_id_tbl_type, a0 JTF_NUMBER_TABLE);
62: procedure rosetta_table_copy_out_p4(t iex_status_rule_pub.status_rule_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
63:
64: procedure rosetta_table_copy_in_p5(t out nocopy iex_status_rule_pub.status_rule_line_id_tbl_type, a0 JTF_NUMBER_TABLE);
65: procedure rosetta_table_copy_out_p5(t iex_status_rule_pub.status_rule_line_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
66:
67: procedure create_status_rule(p_api_version NUMBER
68: , p_init_msg_list VARCHAR2
69: , p_commit VARCHAR2

Line 92: , p3_a0 JTF_NUMBER_TABLE

88: );
89: procedure update_status_rule(p_api_version NUMBER
90: , p_init_msg_list VARCHAR2
91: , p_commit VARCHAR2
92: , p3_a0 JTF_NUMBER_TABLE
93: , p3_a1 JTF_VARCHAR2_TABLE_100
94: , p3_a2 JTF_VARCHAR2_TABLE_200
95: , p3_a3 JTF_DATE_TABLE
96: , p3_a4 JTF_DATE_TABLE

Line 98: , p3_a6 JTF_NUMBER_TABLE

94: , p3_a2 JTF_VARCHAR2_TABLE_200
95: , p3_a3 JTF_DATE_TABLE
96: , p3_a4 JTF_DATE_TABLE
97: , p3_a5 JTF_DATE_TABLE
98: , p3_a6 JTF_NUMBER_TABLE
99: , p3_a7 JTF_DATE_TABLE
100: , p3_a8 JTF_NUMBER_TABLE
101: , p3_a9 JTF_NUMBER_TABLE
102: , p3_a10 JTF_NUMBER_TABLE

Line 100: , p3_a8 JTF_NUMBER_TABLE

96: , p3_a4 JTF_DATE_TABLE
97: , p3_a5 JTF_DATE_TABLE
98: , p3_a6 JTF_NUMBER_TABLE
99: , p3_a7 JTF_DATE_TABLE
100: , p3_a8 JTF_NUMBER_TABLE
101: , p3_a9 JTF_NUMBER_TABLE
102: , p3_a10 JTF_NUMBER_TABLE
103: , p3_a11 JTF_NUMBER_TABLE
104: , p3_a12 JTF_NUMBER_TABLE

Line 101: , p3_a9 JTF_NUMBER_TABLE

97: , p3_a5 JTF_DATE_TABLE
98: , p3_a6 JTF_NUMBER_TABLE
99: , p3_a7 JTF_DATE_TABLE
100: , p3_a8 JTF_NUMBER_TABLE
101: , p3_a9 JTF_NUMBER_TABLE
102: , p3_a10 JTF_NUMBER_TABLE
103: , p3_a11 JTF_NUMBER_TABLE
104: , p3_a12 JTF_NUMBER_TABLE
105: , x_dup_status out nocopy VARCHAR2

Line 102: , p3_a10 JTF_NUMBER_TABLE

98: , p3_a6 JTF_NUMBER_TABLE
99: , p3_a7 JTF_DATE_TABLE
100: , p3_a8 JTF_NUMBER_TABLE
101: , p3_a9 JTF_NUMBER_TABLE
102: , p3_a10 JTF_NUMBER_TABLE
103: , p3_a11 JTF_NUMBER_TABLE
104: , p3_a12 JTF_NUMBER_TABLE
105: , x_dup_status out nocopy VARCHAR2
106: , x_return_status out nocopy VARCHAR2

Line 103: , p3_a11 JTF_NUMBER_TABLE

99: , p3_a7 JTF_DATE_TABLE
100: , p3_a8 JTF_NUMBER_TABLE
101: , p3_a9 JTF_NUMBER_TABLE
102: , p3_a10 JTF_NUMBER_TABLE
103: , p3_a11 JTF_NUMBER_TABLE
104: , p3_a12 JTF_NUMBER_TABLE
105: , x_dup_status out nocopy VARCHAR2
106: , x_return_status out nocopy VARCHAR2
107: , x_msg_count out nocopy NUMBER

Line 104: , p3_a12 JTF_NUMBER_TABLE

100: , p3_a8 JTF_NUMBER_TABLE
101: , p3_a9 JTF_NUMBER_TABLE
102: , p3_a10 JTF_NUMBER_TABLE
103: , p3_a11 JTF_NUMBER_TABLE
104: , p3_a12 JTF_NUMBER_TABLE
105: , x_dup_status out nocopy VARCHAR2
106: , x_return_status out nocopy VARCHAR2
107: , x_msg_count out nocopy NUMBER
108: , x_msg_data out nocopy VARCHAR2

Line 113: , p_status_rule_id_tbl JTF_NUMBER_TABLE

109: );
110: procedure delete_status_rule(p_api_version NUMBER
111: , p_init_msg_list VARCHAR2
112: , p_commit VARCHAR2
113: , p_status_rule_id_tbl JTF_NUMBER_TABLE
114: , x_return_status out nocopy VARCHAR2
115: , x_msg_count out nocopy NUMBER
116: , x_msg_data out nocopy VARCHAR2
117: );

Line 141: , p3_a0 JTF_NUMBER_TABLE

137: );
138: procedure update_status_rule_line(p_api_version NUMBER
139: , p_init_msg_list VARCHAR2
140: , p_commit VARCHAR2
141: , p3_a0 JTF_NUMBER_TABLE
142: , p3_a1 JTF_VARCHAR2_TABLE_100
143: , p3_a2 JTF_NUMBER_TABLE
144: , p3_a3 JTF_VARCHAR2_TABLE_100
145: , p3_a4 JTF_NUMBER_TABLE

Line 143: , p3_a2 JTF_NUMBER_TABLE

139: , p_init_msg_list VARCHAR2
140: , p_commit VARCHAR2
141: , p3_a0 JTF_NUMBER_TABLE
142: , p3_a1 JTF_VARCHAR2_TABLE_100
143: , p3_a2 JTF_NUMBER_TABLE
144: , p3_a3 JTF_VARCHAR2_TABLE_100
145: , p3_a4 JTF_NUMBER_TABLE
146: , p3_a5 JTF_DATE_TABLE
147: , p3_a6 JTF_NUMBER_TABLE

Line 145: , p3_a4 JTF_NUMBER_TABLE

141: , p3_a0 JTF_NUMBER_TABLE
142: , p3_a1 JTF_VARCHAR2_TABLE_100
143: , p3_a2 JTF_NUMBER_TABLE
144: , p3_a3 JTF_VARCHAR2_TABLE_100
145: , p3_a4 JTF_NUMBER_TABLE
146: , p3_a5 JTF_DATE_TABLE
147: , p3_a6 JTF_NUMBER_TABLE
148: , p3_a7 JTF_DATE_TABLE
149: , p3_a8 JTF_NUMBER_TABLE

Line 147: , p3_a6 JTF_NUMBER_TABLE

143: , p3_a2 JTF_NUMBER_TABLE
144: , p3_a3 JTF_VARCHAR2_TABLE_100
145: , p3_a4 JTF_NUMBER_TABLE
146: , p3_a5 JTF_DATE_TABLE
147: , p3_a6 JTF_NUMBER_TABLE
148: , p3_a7 JTF_DATE_TABLE
149: , p3_a8 JTF_NUMBER_TABLE
150: , p3_a9 JTF_NUMBER_TABLE
151: , p3_a10 JTF_NUMBER_TABLE

Line 149: , p3_a8 JTF_NUMBER_TABLE

145: , p3_a4 JTF_NUMBER_TABLE
146: , p3_a5 JTF_DATE_TABLE
147: , p3_a6 JTF_NUMBER_TABLE
148: , p3_a7 JTF_DATE_TABLE
149: , p3_a8 JTF_NUMBER_TABLE
150: , p3_a9 JTF_NUMBER_TABLE
151: , p3_a10 JTF_NUMBER_TABLE
152: , p3_a11 JTF_NUMBER_TABLE
153: , p3_a12 JTF_NUMBER_TABLE

Line 150: , p3_a9 JTF_NUMBER_TABLE

146: , p3_a5 JTF_DATE_TABLE
147: , p3_a6 JTF_NUMBER_TABLE
148: , p3_a7 JTF_DATE_TABLE
149: , p3_a8 JTF_NUMBER_TABLE
150: , p3_a9 JTF_NUMBER_TABLE
151: , p3_a10 JTF_NUMBER_TABLE
152: , p3_a11 JTF_NUMBER_TABLE
153: , p3_a12 JTF_NUMBER_TABLE
154: , x_dup_status out nocopy VARCHAR2

Line 151: , p3_a10 JTF_NUMBER_TABLE

147: , p3_a6 JTF_NUMBER_TABLE
148: , p3_a7 JTF_DATE_TABLE
149: , p3_a8 JTF_NUMBER_TABLE
150: , p3_a9 JTF_NUMBER_TABLE
151: , p3_a10 JTF_NUMBER_TABLE
152: , p3_a11 JTF_NUMBER_TABLE
153: , p3_a12 JTF_NUMBER_TABLE
154: , x_dup_status out nocopy VARCHAR2
155: , x_return_status out nocopy VARCHAR2

Line 152: , p3_a11 JTF_NUMBER_TABLE

148: , p3_a7 JTF_DATE_TABLE
149: , p3_a8 JTF_NUMBER_TABLE
150: , p3_a9 JTF_NUMBER_TABLE
151: , p3_a10 JTF_NUMBER_TABLE
152: , p3_a11 JTF_NUMBER_TABLE
153: , p3_a12 JTF_NUMBER_TABLE
154: , x_dup_status out nocopy VARCHAR2
155: , x_return_status out nocopy VARCHAR2
156: , x_msg_count out nocopy NUMBER

Line 153: , p3_a12 JTF_NUMBER_TABLE

149: , p3_a8 JTF_NUMBER_TABLE
150: , p3_a9 JTF_NUMBER_TABLE
151: , p3_a10 JTF_NUMBER_TABLE
152: , p3_a11 JTF_NUMBER_TABLE
153: , p3_a12 JTF_NUMBER_TABLE
154: , x_dup_status out nocopy VARCHAR2
155: , x_return_status out nocopy VARCHAR2
156: , x_msg_count out nocopy NUMBER
157: , x_msg_data out nocopy VARCHAR2

Line 163: , p_status_rule_line_id_tbl JTF_NUMBER_TABLE

159: procedure delete_status_rule_line(p_api_version NUMBER
160: , p_init_msg_list VARCHAR2
161: , p_commit VARCHAR2
162: , p_status_rule_id NUMBER
163: , p_status_rule_line_id_tbl JTF_NUMBER_TABLE
164: , x_return_status out nocopy VARCHAR2
165: , x_msg_count out nocopy NUMBER
166: , x_msg_data out nocopy VARCHAR2
167: );