DBA Data[Home] [Help]

APPS.AHL_QA_RESULTS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_qa_results_pvt.qa_results_tbl_type, 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_qa_results_pvt.qa_results_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_2000
15: , a2 JTF_NUMBER_TABLE
16: ) as
17: ddindx binary_integer; indx binary_integer;

Line 15: , a2 JTF_NUMBER_TABLE

11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_qa_results_pvt.qa_results_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_2000
15: , a2 JTF_NUMBER_TABLE
16: ) as
17: ddindx binary_integer; indx binary_integer;
18: begin
19: if a0 is not null and a0.count > 0 then

Line 36: procedure rosetta_table_copy_out_p1(t ahl_qa_results_pvt.qa_results_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

32: end loop;
33: end if;
34: end if;
35: end rosetta_table_copy_in_p1;
36: procedure rosetta_table_copy_out_p1(t ahl_qa_results_pvt.qa_results_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
38: , a2 out nocopy JTF_NUMBER_TABLE
39: ) as
40: ddindx binary_integer; indx binary_integer;

Line 38: , a2 out nocopy JTF_NUMBER_TABLE

34: end if;
35: end rosetta_table_copy_in_p1;
36: procedure rosetta_table_copy_out_p1(t ahl_qa_results_pvt.qa_results_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
38: , a2 out nocopy JTF_NUMBER_TABLE
39: ) as
40: ddindx binary_integer; indx binary_integer;
41: begin
42: if t is null or t.count = 0 then

Line 43: a0 := JTF_NUMBER_TABLE();

39: ) as
40: ddindx binary_integer; indx binary_integer;
41: begin
42: if t is null or t.count = 0 then
43: a0 := JTF_NUMBER_TABLE();
44: a1 := JTF_VARCHAR2_TABLE_2000();
45: a2 := JTF_NUMBER_TABLE();
46: else
47: a0 := JTF_NUMBER_TABLE();

Line 45: a2 := JTF_NUMBER_TABLE();

41: begin
42: if t is null or t.count = 0 then
43: a0 := JTF_NUMBER_TABLE();
44: a1 := JTF_VARCHAR2_TABLE_2000();
45: a2 := JTF_NUMBER_TABLE();
46: else
47: a0 := JTF_NUMBER_TABLE();
48: a1 := JTF_VARCHAR2_TABLE_2000();
49: a2 := JTF_NUMBER_TABLE();

Line 47: a0 := JTF_NUMBER_TABLE();

43: a0 := JTF_NUMBER_TABLE();
44: a1 := JTF_VARCHAR2_TABLE_2000();
45: a2 := JTF_NUMBER_TABLE();
46: else
47: a0 := JTF_NUMBER_TABLE();
48: a1 := JTF_VARCHAR2_TABLE_2000();
49: a2 := JTF_NUMBER_TABLE();
50: if t.count > 0 then
51: a0.extend(t.count);

Line 49: a2 := JTF_NUMBER_TABLE();

45: a2 := JTF_NUMBER_TABLE();
46: else
47: a0 := JTF_NUMBER_TABLE();
48: a1 := JTF_VARCHAR2_TABLE_2000();
49: a2 := JTF_NUMBER_TABLE();
50: if t.count > 0 then
51: a0.extend(t.count);
52: a1.extend(t.count);
53: a2.extend(t.count);

Line 70: procedure rosetta_table_copy_in_p3(t out nocopy ahl_qa_results_pvt.occurrence_tbl_type, a0 JTF_NUMBER_TABLE

66: end if;
67: end if;
68: end rosetta_table_copy_out_p1;
69:
70: procedure rosetta_table_copy_in_p3(t out nocopy ahl_qa_results_pvt.occurrence_tbl_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_NUMBER_TABLE
72: ) as
73: ddindx binary_integer; indx binary_integer;
74: begin

Line 71: , a1 JTF_NUMBER_TABLE

67: end if;
68: end rosetta_table_copy_out_p1;
69:
70: procedure rosetta_table_copy_in_p3(t out nocopy ahl_qa_results_pvt.occurrence_tbl_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_NUMBER_TABLE
72: ) as
73: ddindx binary_integer; indx binary_integer;
74: begin
75: if a0 is not null and a0.count > 0 then

Line 91: procedure rosetta_table_copy_out_p3(t ahl_qa_results_pvt.occurrence_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

87: end loop;
88: end if;
89: end if;
90: end rosetta_table_copy_in_p3;
91: procedure rosetta_table_copy_out_p3(t ahl_qa_results_pvt.occurrence_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: ) as
94: ddindx binary_integer; indx binary_integer;
95: begin

Line 92: , a1 out nocopy JTF_NUMBER_TABLE

88: end if;
89: end if;
90: end rosetta_table_copy_in_p3;
91: procedure rosetta_table_copy_out_p3(t ahl_qa_results_pvt.occurrence_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: ) as
94: ddindx binary_integer; indx binary_integer;
95: begin
96: if t is null or t.count = 0 then

Line 97: a0 := JTF_NUMBER_TABLE();

93: ) as
94: ddindx binary_integer; indx binary_integer;
95: begin
96: if t is null or t.count = 0 then
97: a0 := JTF_NUMBER_TABLE();
98: a1 := JTF_NUMBER_TABLE();
99: else
100: a0 := JTF_NUMBER_TABLE();
101: a1 := JTF_NUMBER_TABLE();

Line 98: a1 := JTF_NUMBER_TABLE();

94: ddindx binary_integer; indx binary_integer;
95: begin
96: if t is null or t.count = 0 then
97: a0 := JTF_NUMBER_TABLE();
98: a1 := JTF_NUMBER_TABLE();
99: else
100: a0 := JTF_NUMBER_TABLE();
101: a1 := JTF_NUMBER_TABLE();
102: if t.count > 0 then

Line 100: a0 := JTF_NUMBER_TABLE();

96: if t is null or t.count = 0 then
97: a0 := JTF_NUMBER_TABLE();
98: a1 := JTF_NUMBER_TABLE();
99: else
100: a0 := JTF_NUMBER_TABLE();
101: a1 := JTF_NUMBER_TABLE();
102: if t.count > 0 then
103: a0.extend(t.count);
104: a1.extend(t.count);

Line 101: a1 := JTF_NUMBER_TABLE();

97: a0 := JTF_NUMBER_TABLE();
98: a1 := JTF_NUMBER_TABLE();
99: else
100: a0 := JTF_NUMBER_TABLE();
101: a1 := JTF_NUMBER_TABLE();
102: if t.count > 0 then
103: a0.extend(t.count);
104: a1.extend(t.count);
105: ddindx := t.first;

Line 183: , p13_a0 JTF_NUMBER_TABLE

179: , p_plan_id NUMBER
180: , p_organization_id NUMBER
181: , p_transaction_no NUMBER
182: , p_specification_id NUMBER
183: , p13_a0 JTF_NUMBER_TABLE
184: , p13_a1 JTF_VARCHAR2_TABLE_2000
185: , p13_a2 JTF_NUMBER_TABLE
186: , p14_a0 JTF_NUMBER_TABLE
187: , p14_a1 JTF_VARCHAR2_TABLE_2000

Line 185: , p13_a2 JTF_NUMBER_TABLE

181: , p_transaction_no NUMBER
182: , p_specification_id NUMBER
183: , p13_a0 JTF_NUMBER_TABLE
184: , p13_a1 JTF_VARCHAR2_TABLE_2000
185: , p13_a2 JTF_NUMBER_TABLE
186: , p14_a0 JTF_NUMBER_TABLE
187: , p14_a1 JTF_VARCHAR2_TABLE_2000
188: , p14_a2 JTF_NUMBER_TABLE
189: , p15_a0 JTF_VARCHAR2_TABLE_100

Line 186: , p14_a0 JTF_NUMBER_TABLE

182: , p_specification_id NUMBER
183: , p13_a0 JTF_NUMBER_TABLE
184: , p13_a1 JTF_VARCHAR2_TABLE_2000
185: , p13_a2 JTF_NUMBER_TABLE
186: , p14_a0 JTF_NUMBER_TABLE
187: , p14_a1 JTF_VARCHAR2_TABLE_2000
188: , p14_a2 JTF_NUMBER_TABLE
189: , p15_a0 JTF_VARCHAR2_TABLE_100
190: , p15_a1 JTF_VARCHAR2_TABLE_2000

Line 188: , p14_a2 JTF_NUMBER_TABLE

184: , p13_a1 JTF_VARCHAR2_TABLE_2000
185: , p13_a2 JTF_NUMBER_TABLE
186: , p14_a0 JTF_NUMBER_TABLE
187: , p14_a1 JTF_VARCHAR2_TABLE_2000
188: , p14_a2 JTF_NUMBER_TABLE
189: , p15_a0 JTF_VARCHAR2_TABLE_100
190: , p15_a1 JTF_VARCHAR2_TABLE_2000
191: , p_result_commit_flag NUMBER
192: , p_id_or_value VARCHAR2

Line 194: , p19_a0 in out nocopy JTF_NUMBER_TABLE

190: , p15_a1 JTF_VARCHAR2_TABLE_2000
191: , p_result_commit_flag NUMBER
192: , p_id_or_value VARCHAR2
193: , p_x_collection_id in out nocopy NUMBER
194: , p19_a0 in out nocopy JTF_NUMBER_TABLE
195: , p19_a1 in out nocopy JTF_NUMBER_TABLE
196: )
197:
198: as

Line 195: , p19_a1 in out nocopy JTF_NUMBER_TABLE

191: , p_result_commit_flag NUMBER
192: , p_id_or_value VARCHAR2
193: , p_x_collection_id in out nocopy NUMBER
194: , p19_a0 in out nocopy JTF_NUMBER_TABLE
195: , p19_a1 in out nocopy JTF_NUMBER_TABLE
196: )
197:
198: as
199: ddp_results_tbl ahl_qa_results_pvt.qa_results_tbl_type;