APPS.OZF_DENORM_QUERIES_PVT_W dependencies on OZF_DENORM_QUERIES_PVT

Line 1: package body ozf_denorm_queries_pvt_w as

1: package body ozf_denorm_queries_pvt_w as
2: /* $Header: ozfwofdb.pls 120.0 2005/06/01 02:50:08 appldev 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 22: procedure rosetta_table_copy_in_p1(t OUT NOCOPY ozf_denorm_queries_pvt.stringarray, a0 JTF_VARCHAR2_TABLE_4000) as

18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t OUT NOCOPY ozf_denorm_queries_pvt.stringarray, a0 JTF_VARCHAR2_TABLE_4000) as
23: ddindx binary_integer; indx binary_integer;
24: begin
25: if a0 is not null and a0.count > 0 then
26: if a0.count > 0 then

Line 40: procedure rosetta_table_copy_out_p1(t ozf_denorm_queries_pvt.stringarray, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_4000) as

36: end loop;
37: end if;
38: end if;
39: end rosetta_table_copy_in_p1;
40: procedure rosetta_table_copy_out_p1(t ozf_denorm_queries_pvt.stringarray, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_4000) as
41: ddindx binary_integer; indx binary_integer;
42: begin
43: if t is null or t.count = 0 then
44: a0 := JTF_VARCHAR2_TABLE_4000();

Line 88: ddp_denorm_queries_rec ozf_denorm_queries_pvt.denorm_queries_rec_type;

84: , p4_a13 NUMBER := 0-1962.0724
85: , p4_a14 NUMBER := 0-1962.0724
86: )
87: as
88: ddp_denorm_queries_rec ozf_denorm_queries_pvt.denorm_queries_rec_type;
89: ddindx binary_integer; indx binary_integer;
90: begin
91:
92: -- copy data to the local IN or IN-OUT args, if any

Line 118: ozf_denorm_queries_pvt.create_denorm_queries(p_api_version,

114:
115:
116:
117: -- here's the delegated call to the old PL/SQL routine
118: ozf_denorm_queries_pvt.create_denorm_queries(p_api_version,
119: p_init_msg_list,
120: p_commit,
121: p_validation_level,
122: ddp_denorm_queries_rec,

Line 163: ddp_denorm_queries_rec ozf_denorm_queries_pvt.denorm_queries_rec_type;

159: , p4_a13 NUMBER := 0-1962.0724
160: , p4_a14 NUMBER := 0-1962.0724
161: )
162: as
163: ddp_denorm_queries_rec ozf_denorm_queries_pvt.denorm_queries_rec_type;
164: ddindx binary_integer; indx binary_integer;
165: begin
166:
167: -- copy data to the local IN or IN-OUT args, if any

Line 192: ozf_denorm_queries_pvt.update_denorm_queries(p_api_version,

188:
189:
190:
191: -- here's the delegated call to the old PL/SQL routine
192: ozf_denorm_queries_pvt.update_denorm_queries(p_api_version,
193: p_init_msg_list,
194: p_commit,
195: p_validation_level,
196: ddp_denorm_queries_rec,

Line 235: ddp_denorm_queries_rec ozf_denorm_queries_pvt.denorm_queries_rec_type;

231: , p4_a13 NUMBER := 0-1962.0724
232: , p4_a14 NUMBER := 0-1962.0724
233: )
234: as
235: ddp_denorm_queries_rec ozf_denorm_queries_pvt.denorm_queries_rec_type;
236: ddindx binary_integer; indx binary_integer;
237: begin
238:
239: -- copy data to the local IN or IN-OUT args, if any

Line 264: ozf_denorm_queries_pvt.validate_denorm_queries(p_api_version,

260:
261:
262:
263: -- here's the delegated call to the old PL/SQL routine
264: ozf_denorm_queries_pvt.validate_denorm_queries(p_api_version,
265: p_init_msg_list,
266: p_validation_level,
267: p_validation_mode,
268: ddp_denorm_queries_rec,

Line 302: ddp_denorm_queries_rec ozf_denorm_queries_pvt.denorm_queries_rec_type;

298: , p0_a13 NUMBER := 0-1962.0724
299: , p0_a14 NUMBER := 0-1962.0724
300: )
301: as
302: ddp_denorm_queries_rec ozf_denorm_queries_pvt.denorm_queries_rec_type;
303: ddindx binary_integer; indx binary_integer;
304: begin
305:
306: -- copy data to the local IN or IN-OUT args, if any

Line 326: ozf_denorm_queries_pvt.check_denorm_queries_items(ddp_denorm_queries_rec,

322:
323:
324:
325: -- here's the delegated call to the old PL/SQL routine
326: ozf_denorm_queries_pvt.check_denorm_queries_items(ddp_denorm_queries_rec,
327: p_validation_mode,
328: x_return_status);
329:
330: -- copy data back from the local OUT or IN-OUT args, if any

Line 353: ddp_denorm_queries_rec ozf_denorm_queries_pvt.denorm_queries_rec_type;

349: , p0_a13 NUMBER := 0-1962.0724
350: , p0_a14 NUMBER := 0-1962.0724
351: )
352: as
353: ddp_denorm_queries_rec ozf_denorm_queries_pvt.denorm_queries_rec_type;
354: ddindx binary_integer; indx binary_integer;
355: begin
356:
357: -- copy data to the local IN or IN-OUT args, if any

Line 376: ozf_denorm_queries_pvt.check_denorm_queries_record(ddp_denorm_queries_rec,

372: ddp_denorm_queries_rec.security_group_id := rosetta_g_miss_num_map(p0_a14);
373:
374:
375: -- here's the delegated call to the old PL/SQL routine
376: ozf_denorm_queries_pvt.check_denorm_queries_record(ddp_denorm_queries_rec,
377: x_return_status);
378:
379: -- copy data back from the local OUT or IN-OUT args, if any
380:

Line 400: ddx_denorm_queries_rec ozf_denorm_queries_pvt.denorm_queries_rec_type;

396: , p0_a13 OUT NOCOPY NUMBER
397: , p0_a14 OUT NOCOPY NUMBER
398: )
399: as
400: ddx_denorm_queries_rec ozf_denorm_queries_pvt.denorm_queries_rec_type;
401: ddindx binary_integer; indx binary_integer;
402: begin
403:
404: -- copy data to the local IN or IN-OUT args, if any

Line 407: ozf_denorm_queries_pvt.init_denorm_queries_rec(ddx_denorm_queries_rec);

403:
404: -- copy data to the local IN or IN-OUT args, if any
405:
406: -- here's the delegated call to the old PL/SQL routine
407: ozf_denorm_queries_pvt.init_denorm_queries_rec(ddx_denorm_queries_rec);
408:
409: -- copy data back from the local OUT or IN-OUT args, if any
410: p0_a0 := rosetta_g_miss_num_map(ddx_denorm_queries_rec.denorm_query_id);
411: p0_a1 := ddx_denorm_queries_rec.query_for;

Line 459: ddp_denorm_queries_rec ozf_denorm_queries_pvt.denorm_queries_rec_type;

455: , p0_a13 NUMBER := 0-1962.0724
456: , p0_a14 NUMBER := 0-1962.0724
457: )
458: as
459: ddp_denorm_queries_rec ozf_denorm_queries_pvt.denorm_queries_rec_type;
460: ddx_complete_rec ozf_denorm_queries_pvt.denorm_queries_rec_type;
461: ddindx binary_integer; indx binary_integer;
462: begin
463:

Line 460: ddx_complete_rec ozf_denorm_queries_pvt.denorm_queries_rec_type;

456: , p0_a14 NUMBER := 0-1962.0724
457: )
458: as
459: ddp_denorm_queries_rec ozf_denorm_queries_pvt.denorm_queries_rec_type;
460: ddx_complete_rec ozf_denorm_queries_pvt.denorm_queries_rec_type;
461: ddindx binary_integer; indx binary_integer;
462: begin
463:
464: -- copy data to the local IN or IN-OUT args, if any

Line 483: ozf_denorm_queries_pvt.complete_denorm_queries_rec(ddp_denorm_queries_rec,

479: ddp_denorm_queries_rec.security_group_id := rosetta_g_miss_num_map(p0_a14);
480:
481:
482: -- here's the delegated call to the old PL/SQL routine
483: ozf_denorm_queries_pvt.complete_denorm_queries_rec(ddp_denorm_queries_rec,
484: ddx_complete_rec);
485:
486: -- copy data back from the local OUT or IN-OUT args, if any
487:

Line 509: ddsarray ozf_denorm_queries_pvt.stringarray;

505: procedure string_length_check(sqlst VARCHAR2
506: , sarray OUT NOCOPY JTF_VARCHAR2_TABLE_4000
507: )
508: as
509: ddsarray ozf_denorm_queries_pvt.stringarray;
510: ddindx binary_integer; indx binary_integer;
511: begin
512:
513: -- copy data to the local IN or IN-OUT args, if any

Line 517: ozf_denorm_queries_pvt.string_length_check(sqlst,

513: -- copy data to the local IN or IN-OUT args, if any
514:
515:
516: -- here's the delegated call to the old PL/SQL routine
517: ozf_denorm_queries_pvt.string_length_check(sqlst,
518: ddsarray);
519:
520: -- copy data back from the local OUT or IN-OUT args, if any
521:

Line 522: ozf_denorm_queries_pvt_w.rosetta_table_copy_out_p1(ddsarray, sarray);

518: ddsarray);
519:
520: -- copy data back from the local OUT or IN-OUT args, if any
521:
522: ozf_denorm_queries_pvt_w.rosetta_table_copy_out_p1(ddsarray, sarray);
523: end;
524:
525: end ozf_denorm_queries_pvt_w;

Line 525: end ozf_denorm_queries_pvt_w;

521:
522: ozf_denorm_queries_pvt_w.rosetta_table_copy_out_p1(ddsarray, sarray);
523: end;
524:
525: end ozf_denorm_queries_pvt_w;