DBA Data[Home] [Help]

APPS.AHL_STATUS_ORDER_RULES_PVT_W dependencies on JTF_NUMBER_TABLE

Line 13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_status_order_rules_pvt.status_order_rules_tbl, a0 JTF_NUMBER_TABLE

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_status_order_rules_pvt.status_order_rules_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_DATE_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_DATE_TABLE

Line 14: , a1 JTF_NUMBER_TABLE

10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_status_order_rules_pvt.status_order_rules_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_DATE_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_NUMBER_TABLE

Line 16: , a3 JTF_NUMBER_TABLE

12:
13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_status_order_rules_pvt.status_order_rules_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_DATE_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100

Line 18: , a5 JTF_NUMBER_TABLE

14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_DATE_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100

Line 19: , a6 JTF_NUMBER_TABLE

15: , a2 JTF_DATE_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_VARCHAR2_TABLE_100

Line 24: , a11 JTF_NUMBER_TABLE

20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_NUMBER_TABLE
25: ) as
26: ddindx binary_integer; indx binary_integer;
27: begin
28: if a0 is not null and a0.count > 0 then

Line 54: procedure rosetta_table_copy_out_p1(t ahl_status_order_rules_pvt.status_order_rules_tbl, a0 out nocopy JTF_NUMBER_TABLE

50: end loop;
51: end if;
52: end if;
53: end rosetta_table_copy_in_p1;
54: procedure rosetta_table_copy_out_p1(t ahl_status_order_rules_pvt.status_order_rules_tbl, a0 out nocopy JTF_NUMBER_TABLE
55: , a1 out nocopy JTF_NUMBER_TABLE
56: , a2 out nocopy JTF_DATE_TABLE
57: , a3 out nocopy JTF_NUMBER_TABLE
58: , a4 out nocopy JTF_DATE_TABLE

Line 55: , a1 out nocopy JTF_NUMBER_TABLE

51: end if;
52: end if;
53: end rosetta_table_copy_in_p1;
54: procedure rosetta_table_copy_out_p1(t ahl_status_order_rules_pvt.status_order_rules_tbl, a0 out nocopy JTF_NUMBER_TABLE
55: , a1 out nocopy JTF_NUMBER_TABLE
56: , a2 out nocopy JTF_DATE_TABLE
57: , a3 out nocopy JTF_NUMBER_TABLE
58: , a4 out nocopy JTF_DATE_TABLE
59: , a5 out nocopy JTF_NUMBER_TABLE

Line 57: , a3 out nocopy JTF_NUMBER_TABLE

53: end rosetta_table_copy_in_p1;
54: procedure rosetta_table_copy_out_p1(t ahl_status_order_rules_pvt.status_order_rules_tbl, a0 out nocopy JTF_NUMBER_TABLE
55: , a1 out nocopy JTF_NUMBER_TABLE
56: , a2 out nocopy JTF_DATE_TABLE
57: , a3 out nocopy JTF_NUMBER_TABLE
58: , a4 out nocopy JTF_DATE_TABLE
59: , a5 out nocopy JTF_NUMBER_TABLE
60: , a6 out nocopy JTF_NUMBER_TABLE
61: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 59: , a5 out nocopy JTF_NUMBER_TABLE

55: , a1 out nocopy JTF_NUMBER_TABLE
56: , a2 out nocopy JTF_DATE_TABLE
57: , a3 out nocopy JTF_NUMBER_TABLE
58: , a4 out nocopy JTF_DATE_TABLE
59: , a5 out nocopy JTF_NUMBER_TABLE
60: , a6 out nocopy JTF_NUMBER_TABLE
61: , a7 out nocopy JTF_VARCHAR2_TABLE_100
62: , a8 out nocopy JTF_VARCHAR2_TABLE_100
63: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 60: , a6 out nocopy JTF_NUMBER_TABLE

56: , a2 out nocopy JTF_DATE_TABLE
57: , a3 out nocopy JTF_NUMBER_TABLE
58: , a4 out nocopy JTF_DATE_TABLE
59: , a5 out nocopy JTF_NUMBER_TABLE
60: , a6 out nocopy JTF_NUMBER_TABLE
61: , a7 out nocopy JTF_VARCHAR2_TABLE_100
62: , a8 out nocopy JTF_VARCHAR2_TABLE_100
63: , a9 out nocopy JTF_VARCHAR2_TABLE_100
64: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 65: , a11 out nocopy JTF_NUMBER_TABLE

61: , a7 out nocopy JTF_VARCHAR2_TABLE_100
62: , a8 out nocopy JTF_VARCHAR2_TABLE_100
63: , a9 out nocopy JTF_VARCHAR2_TABLE_100
64: , a10 out nocopy JTF_VARCHAR2_TABLE_100
65: , a11 out nocopy JTF_NUMBER_TABLE
66: ) as
67: ddindx binary_integer; indx binary_integer;
68: begin
69: if t is null or t.count = 0 then

Line 70: a0 := JTF_NUMBER_TABLE();

66: ) as
67: ddindx binary_integer; indx binary_integer;
68: begin
69: if t is null or t.count = 0 then
70: a0 := JTF_NUMBER_TABLE();
71: a1 := JTF_NUMBER_TABLE();
72: a2 := JTF_DATE_TABLE();
73: a3 := JTF_NUMBER_TABLE();
74: a4 := JTF_DATE_TABLE();

Line 71: a1 := JTF_NUMBER_TABLE();

67: ddindx binary_integer; indx binary_integer;
68: begin
69: if t is null or t.count = 0 then
70: a0 := JTF_NUMBER_TABLE();
71: a1 := JTF_NUMBER_TABLE();
72: a2 := JTF_DATE_TABLE();
73: a3 := JTF_NUMBER_TABLE();
74: a4 := JTF_DATE_TABLE();
75: a5 := JTF_NUMBER_TABLE();

Line 73: a3 := JTF_NUMBER_TABLE();

69: if t is null or t.count = 0 then
70: a0 := JTF_NUMBER_TABLE();
71: a1 := JTF_NUMBER_TABLE();
72: a2 := JTF_DATE_TABLE();
73: a3 := JTF_NUMBER_TABLE();
74: a4 := JTF_DATE_TABLE();
75: a5 := JTF_NUMBER_TABLE();
76: a6 := JTF_NUMBER_TABLE();
77: a7 := JTF_VARCHAR2_TABLE_100();

Line 75: a5 := JTF_NUMBER_TABLE();

71: a1 := JTF_NUMBER_TABLE();
72: a2 := JTF_DATE_TABLE();
73: a3 := JTF_NUMBER_TABLE();
74: a4 := JTF_DATE_TABLE();
75: a5 := JTF_NUMBER_TABLE();
76: a6 := JTF_NUMBER_TABLE();
77: a7 := JTF_VARCHAR2_TABLE_100();
78: a8 := JTF_VARCHAR2_TABLE_100();
79: a9 := JTF_VARCHAR2_TABLE_100();

Line 76: a6 := JTF_NUMBER_TABLE();

72: a2 := JTF_DATE_TABLE();
73: a3 := JTF_NUMBER_TABLE();
74: a4 := JTF_DATE_TABLE();
75: a5 := JTF_NUMBER_TABLE();
76: a6 := JTF_NUMBER_TABLE();
77: a7 := JTF_VARCHAR2_TABLE_100();
78: a8 := JTF_VARCHAR2_TABLE_100();
79: a9 := JTF_VARCHAR2_TABLE_100();
80: a10 := JTF_VARCHAR2_TABLE_100();

Line 81: a11 := JTF_NUMBER_TABLE();

77: a7 := JTF_VARCHAR2_TABLE_100();
78: a8 := JTF_VARCHAR2_TABLE_100();
79: a9 := JTF_VARCHAR2_TABLE_100();
80: a10 := JTF_VARCHAR2_TABLE_100();
81: a11 := JTF_NUMBER_TABLE();
82: else
83: a0 := JTF_NUMBER_TABLE();
84: a1 := JTF_NUMBER_TABLE();
85: a2 := JTF_DATE_TABLE();

Line 83: a0 := JTF_NUMBER_TABLE();

79: a9 := JTF_VARCHAR2_TABLE_100();
80: a10 := JTF_VARCHAR2_TABLE_100();
81: a11 := JTF_NUMBER_TABLE();
82: else
83: a0 := JTF_NUMBER_TABLE();
84: a1 := JTF_NUMBER_TABLE();
85: a2 := JTF_DATE_TABLE();
86: a3 := JTF_NUMBER_TABLE();
87: a4 := JTF_DATE_TABLE();

Line 84: a1 := JTF_NUMBER_TABLE();

80: a10 := JTF_VARCHAR2_TABLE_100();
81: a11 := JTF_NUMBER_TABLE();
82: else
83: a0 := JTF_NUMBER_TABLE();
84: a1 := JTF_NUMBER_TABLE();
85: a2 := JTF_DATE_TABLE();
86: a3 := JTF_NUMBER_TABLE();
87: a4 := JTF_DATE_TABLE();
88: a5 := JTF_NUMBER_TABLE();

Line 86: a3 := JTF_NUMBER_TABLE();

82: else
83: a0 := JTF_NUMBER_TABLE();
84: a1 := JTF_NUMBER_TABLE();
85: a2 := JTF_DATE_TABLE();
86: a3 := JTF_NUMBER_TABLE();
87: a4 := JTF_DATE_TABLE();
88: a5 := JTF_NUMBER_TABLE();
89: a6 := JTF_NUMBER_TABLE();
90: a7 := JTF_VARCHAR2_TABLE_100();

Line 88: a5 := JTF_NUMBER_TABLE();

84: a1 := JTF_NUMBER_TABLE();
85: a2 := JTF_DATE_TABLE();
86: a3 := JTF_NUMBER_TABLE();
87: a4 := JTF_DATE_TABLE();
88: a5 := JTF_NUMBER_TABLE();
89: a6 := JTF_NUMBER_TABLE();
90: a7 := JTF_VARCHAR2_TABLE_100();
91: a8 := JTF_VARCHAR2_TABLE_100();
92: a9 := JTF_VARCHAR2_TABLE_100();

Line 89: a6 := JTF_NUMBER_TABLE();

85: a2 := JTF_DATE_TABLE();
86: a3 := JTF_NUMBER_TABLE();
87: a4 := JTF_DATE_TABLE();
88: a5 := JTF_NUMBER_TABLE();
89: a6 := JTF_NUMBER_TABLE();
90: a7 := JTF_VARCHAR2_TABLE_100();
91: a8 := JTF_VARCHAR2_TABLE_100();
92: a9 := JTF_VARCHAR2_TABLE_100();
93: a10 := JTF_VARCHAR2_TABLE_100();

Line 94: a11 := JTF_NUMBER_TABLE();

90: a7 := JTF_VARCHAR2_TABLE_100();
91: a8 := JTF_VARCHAR2_TABLE_100();
92: a9 := JTF_VARCHAR2_TABLE_100();
93: a10 := JTF_VARCHAR2_TABLE_100();
94: a11 := JTF_NUMBER_TABLE();
95: if t.count > 0 then
96: a0.extend(t.count);
97: a1.extend(t.count);
98: a2.extend(t.count);

Line 139: , p6_a0 out nocopy JTF_NUMBER_TABLE

135: , p_validation_level NUMBER
136: , p_module_type VARCHAR2
137: , p_current_status_code VARCHAR2
138: , p_system_status_type VARCHAR2
139: , p6_a0 out nocopy JTF_NUMBER_TABLE
140: , p6_a1 out nocopy JTF_NUMBER_TABLE
141: , p6_a2 out nocopy JTF_DATE_TABLE
142: , p6_a3 out nocopy JTF_NUMBER_TABLE
143: , p6_a4 out nocopy JTF_DATE_TABLE

Line 140: , p6_a1 out nocopy JTF_NUMBER_TABLE

136: , p_module_type VARCHAR2
137: , p_current_status_code VARCHAR2
138: , p_system_status_type VARCHAR2
139: , p6_a0 out nocopy JTF_NUMBER_TABLE
140: , p6_a1 out nocopy JTF_NUMBER_TABLE
141: , p6_a2 out nocopy JTF_DATE_TABLE
142: , p6_a3 out nocopy JTF_NUMBER_TABLE
143: , p6_a4 out nocopy JTF_DATE_TABLE
144: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 142: , p6_a3 out nocopy JTF_NUMBER_TABLE

138: , p_system_status_type VARCHAR2
139: , p6_a0 out nocopy JTF_NUMBER_TABLE
140: , p6_a1 out nocopy JTF_NUMBER_TABLE
141: , p6_a2 out nocopy JTF_DATE_TABLE
142: , p6_a3 out nocopy JTF_NUMBER_TABLE
143: , p6_a4 out nocopy JTF_DATE_TABLE
144: , p6_a5 out nocopy JTF_NUMBER_TABLE
145: , p6_a6 out nocopy JTF_NUMBER_TABLE
146: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 144: , p6_a5 out nocopy JTF_NUMBER_TABLE

140: , p6_a1 out nocopy JTF_NUMBER_TABLE
141: , p6_a2 out nocopy JTF_DATE_TABLE
142: , p6_a3 out nocopy JTF_NUMBER_TABLE
143: , p6_a4 out nocopy JTF_DATE_TABLE
144: , p6_a5 out nocopy JTF_NUMBER_TABLE
145: , p6_a6 out nocopy JTF_NUMBER_TABLE
146: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
147: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
148: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 145: , p6_a6 out nocopy JTF_NUMBER_TABLE

141: , p6_a2 out nocopy JTF_DATE_TABLE
142: , p6_a3 out nocopy JTF_NUMBER_TABLE
143: , p6_a4 out nocopy JTF_DATE_TABLE
144: , p6_a5 out nocopy JTF_NUMBER_TABLE
145: , p6_a6 out nocopy JTF_NUMBER_TABLE
146: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
147: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
148: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
149: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 150: , p6_a11 out nocopy JTF_NUMBER_TABLE

146: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
147: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
148: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
149: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
150: , p6_a11 out nocopy JTF_NUMBER_TABLE
151: , x_return_status out nocopy VARCHAR2
152: , x_msg_count out nocopy NUMBER
153: , x_msg_data out nocopy VARCHAR2
154: )