DBA Data[Home] [Help]

APPS.AHL_QA_RESULTS_PVT_W dependencies on AHL_QA_RESULTS_PVT

Line 1: package body ahl_qa_results_pvt_w as

1: package body ahl_qa_results_pvt_w as
2: /* $Header: AHLWQARB.pls 115.2 2002/11/14 23:06:22 shkalyan noship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:

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 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 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 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 120: procedure rosetta_table_copy_in_p5(t out nocopy ahl_qa_results_pvt.qa_context_tbl_type, a0 JTF_VARCHAR2_TABLE_100

116: end if;
117: end if;
118: end rosetta_table_copy_out_p3;
119:
120: procedure rosetta_table_copy_in_p5(t out nocopy ahl_qa_results_pvt.qa_context_tbl_type, a0 JTF_VARCHAR2_TABLE_100
121: , a1 JTF_VARCHAR2_TABLE_2000
122: ) as
123: ddindx binary_integer; indx binary_integer;
124: begin

Line 141: procedure rosetta_table_copy_out_p5(t ahl_qa_results_pvt.qa_context_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

137: end loop;
138: end if;
139: end if;
140: end rosetta_table_copy_in_p5;
141: procedure rosetta_table_copy_out_p5(t ahl_qa_results_pvt.qa_context_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
142: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
143: ) as
144: ddindx binary_integer; indx binary_integer;
145: begin

Line 199: ddp_results_tbl ahl_qa_results_pvt.qa_results_tbl_type;

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;
200: ddp_hidden_results_tbl ahl_qa_results_pvt.qa_results_tbl_type;
201: ddp_context_tbl ahl_qa_results_pvt.qa_context_tbl_type;
202: ddp_x_occurrence_tbl ahl_qa_results_pvt.occurrence_tbl_type;
203: ddindx binary_integer; indx binary_integer;

Line 200: ddp_hidden_results_tbl ahl_qa_results_pvt.qa_results_tbl_type;

196: )
197:
198: as
199: ddp_results_tbl ahl_qa_results_pvt.qa_results_tbl_type;
200: ddp_hidden_results_tbl ahl_qa_results_pvt.qa_results_tbl_type;
201: ddp_context_tbl ahl_qa_results_pvt.qa_context_tbl_type;
202: ddp_x_occurrence_tbl ahl_qa_results_pvt.occurrence_tbl_type;
203: ddindx binary_integer; indx binary_integer;
204: begin

Line 201: ddp_context_tbl ahl_qa_results_pvt.qa_context_tbl_type;

197:
198: as
199: ddp_results_tbl ahl_qa_results_pvt.qa_results_tbl_type;
200: ddp_hidden_results_tbl ahl_qa_results_pvt.qa_results_tbl_type;
201: ddp_context_tbl ahl_qa_results_pvt.qa_context_tbl_type;
202: ddp_x_occurrence_tbl ahl_qa_results_pvt.occurrence_tbl_type;
203: ddindx binary_integer; indx binary_integer;
204: begin
205:

Line 202: ddp_x_occurrence_tbl ahl_qa_results_pvt.occurrence_tbl_type;

198: as
199: ddp_results_tbl ahl_qa_results_pvt.qa_results_tbl_type;
200: ddp_hidden_results_tbl ahl_qa_results_pvt.qa_results_tbl_type;
201: ddp_context_tbl ahl_qa_results_pvt.qa_context_tbl_type;
202: ddp_x_occurrence_tbl ahl_qa_results_pvt.occurrence_tbl_type;
203: ddindx binary_integer; indx binary_integer;
204: begin
205:
206: -- copy data to the local IN or IN-OUT args, if any

Line 220: ahl_qa_results_pvt_w.rosetta_table_copy_in_p1(ddp_results_tbl, p13_a0

216:
217:
218:
219:
220: ahl_qa_results_pvt_w.rosetta_table_copy_in_p1(ddp_results_tbl, p13_a0
221: , p13_a1
222: , p13_a2
223: );
224:

Line 225: ahl_qa_results_pvt_w.rosetta_table_copy_in_p1(ddp_hidden_results_tbl, p14_a0

221: , p13_a1
222: , p13_a2
223: );
224:
225: ahl_qa_results_pvt_w.rosetta_table_copy_in_p1(ddp_hidden_results_tbl, p14_a0
226: , p14_a1
227: , p14_a2
228: );
229:

Line 230: ahl_qa_results_pvt_w.rosetta_table_copy_in_p5(ddp_context_tbl, p15_a0

226: , p14_a1
227: , p14_a2
228: );
229:
230: ahl_qa_results_pvt_w.rosetta_table_copy_in_p5(ddp_context_tbl, p15_a0
231: , p15_a1
232: );
233:
234:

Line 237: ahl_qa_results_pvt_w.rosetta_table_copy_in_p3(ddp_x_occurrence_tbl, p19_a0

233:
234:
235:
236:
237: ahl_qa_results_pvt_w.rosetta_table_copy_in_p3(ddp_x_occurrence_tbl, p19_a0
238: , p19_a1
239: );
240:
241: -- here's the delegated call to the old PL/SQL routine

Line 242: ahl_qa_results_pvt.submit_qa_results(p_api_version,

238: , p19_a1
239: );
240:
241: -- here's the delegated call to the old PL/SQL routine
242: ahl_qa_results_pvt.submit_qa_results(p_api_version,
243: p_init_msg_list,
244: p_commit,
245: p_validation_level,
246: p_default,

Line 283: ahl_qa_results_pvt_w.rosetta_table_copy_out_p3(ddp_x_occurrence_tbl, p19_a0

279:
280:
281:
282:
283: ahl_qa_results_pvt_w.rosetta_table_copy_out_p3(ddp_x_occurrence_tbl, p19_a0
284: , p19_a1
285: );
286: end;
287:

Line 288: end ahl_qa_results_pvt_w;

284: , p19_a1
285: );
286: end;
287:
288: end ahl_qa_results_pvt_w;