eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_LOC_AREAS_PVT_W dependencies on JTF_LOC_AREAS_PVT

Line 1: package body jtf_loc_areas_pvt_w as

1: package body jtf_loc_areas_pvt_w as
2: /* $Header: jtfwloab.pls 120.2 2005/08/18 22:55:53 stopiwal ship $ */
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 52: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;

48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50: )
51: as
52: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;
53: ddindx binary_integer; indx binary_integer;
54: begin
55:
56: -- copy data to the local IN or IN-OUT args, if any

Line 87: jtf_loc_areas_pvt.create_loc_area(p_api_version,

83: ddp_loc_area_rec.location_area_description := p7_a19;
84:
85:
86: -- here's the delegated call to the old PL/SQL routine
87: jtf_loc_areas_pvt.create_loc_area(p_api_version,
88: p_init_msg_list,
89: p_commit,
90: p_validation_level,
91: x_return_status,

Line 138: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;

134: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
135: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
136: )
137: as
138: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;
139: ddindx binary_integer; indx binary_integer;
140: begin
141:
142: -- copy data to the local IN or IN-OUT args, if any

Line 173: jtf_loc_areas_pvt.update_loc_area(p_api_version,

169: ddp_loc_area_rec.location_area_description := p7_a19;
170:
171:
172: -- here's the delegated call to the old PL/SQL routine
173: jtf_loc_areas_pvt.update_loc_area(p_api_version,
174: p_init_msg_list,
175: p_commit,
176: p_validation_level,
177: x_return_status,

Line 222: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;

218: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
219: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
220: )
221: as
222: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;
223: ddindx binary_integer; indx binary_integer;
224: begin
225:
226: -- copy data to the local IN or IN-OUT args, if any

Line 255: jtf_loc_areas_pvt.validate_loc_area(p_api_version,

251: ddp_loc_area_rec.location_area_name := p6_a18;
252: ddp_loc_area_rec.location_area_description := p6_a19;
253:
254: -- here's the delegated call to the old PL/SQL routine
255: jtf_loc_areas_pvt.validate_loc_area(p_api_version,
256: p_init_msg_list,
257: p_validation_level,
258: x_return_status,
259: x_msg_count,

Line 296: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;

292: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
293: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
294: )
295: as
296: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;
297: ddindx binary_integer; indx binary_integer;
298: begin
299:
300: -- copy data to the local IN or IN-OUT args, if any

Line 325: jtf_loc_areas_pvt.check_items(p_validation_mode,

321: ddp_loc_area_rec.location_area_name := p2_a18;
322: ddp_loc_area_rec.location_area_description := p2_a19;
323:
324: -- here's the delegated call to the old PL/SQL routine
325: jtf_loc_areas_pvt.check_items(p_validation_mode,
326: x_return_status,
327: ddp_loc_area_rec);
328:
329: -- copy data back from the local OUT NOCOPY /* file.sql.39 change */ or IN-OUT args, if any

Line 358: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;

354: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
355: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
356: )
357: as
358: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;
359: ddindx binary_integer; indx binary_integer;
360: begin
361:
362: -- copy data to the local IN or IN-OUT args, if any

Line 387: jtf_loc_areas_pvt.check_loc_area_req_items(p_validation_mode,

383: ddp_loc_area_rec.location_area_description := p1_a19;
384:
385:
386: -- here's the delegated call to the old PL/SQL routine
387: jtf_loc_areas_pvt.check_loc_area_req_items(p_validation_mode,
388: ddp_loc_area_rec,
389: x_return_status);
390:
391: -- copy data back from the local OUT NOCOPY /* file.sql.39 change */ or IN-OUT args, if any

Line 420: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;

416: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
417: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
418: )
419: as
420: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;
421: ddindx binary_integer; indx binary_integer;
422: begin
423:
424: -- copy data to the local IN or IN-OUT args, if any

Line 449: jtf_loc_areas_pvt.check_loc_area_uk_items(p_validation_mode,

445: ddp_loc_area_rec.location_area_description := p1_a19;
446:
447:
448: -- here's the delegated call to the old PL/SQL routine
449: jtf_loc_areas_pvt.check_loc_area_uk_items(p_validation_mode,
450: ddp_loc_area_rec,
451: x_return_status);
452:
453: -- copy data back from the local OUT NOCOPY /* file.sql.39 change */ or IN-OUT args, if any

Line 481: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;

477: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
478: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
479: )
480: as
481: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;
482: ddindx binary_integer; indx binary_integer;
483: begin
484:
485: -- copy data to the local IN or IN-OUT args, if any

Line 509: jtf_loc_areas_pvt.check_loc_area_fk_items(ddp_loc_area_rec,

505: ddp_loc_area_rec.location_area_description := p0_a19;
506:
507:
508: -- here's the delegated call to the old PL/SQL routine
509: jtf_loc_areas_pvt.check_loc_area_fk_items(ddp_loc_area_rec,
510: x_return_status);
511:
512: -- copy data back from the local OUT NOCOPY /* file.sql.39 change */ or IN-OUT args, if any
513:

Line 559: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;

555: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
556: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
557: )
558: as
559: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;
560: ddp_complete_rec jtf_loc_areas_pvt.loc_area_rec_type;
561: ddindx binary_integer; indx binary_integer;
562: begin
563:

Line 560: ddp_complete_rec jtf_loc_areas_pvt.loc_area_rec_type;

556: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
557: )
558: as
559: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;
560: ddp_complete_rec jtf_loc_areas_pvt.loc_area_rec_type;
561: ddindx binary_integer; indx binary_integer;
562: begin
563:
564: -- copy data to the local IN or IN-OUT args, if any

Line 609: jtf_loc_areas_pvt.check_record(ddp_loc_area_rec,

605: ddp_complete_rec.location_area_description := p1_a19;
606:
607:
608: -- here's the delegated call to the old PL/SQL routine
609: jtf_loc_areas_pvt.check_record(ddp_loc_area_rec,
610: ddp_complete_rec,
611: x_return_status);
612:
613: -- copy data back from the local OUT NOCOPY /* file.sql.39 change */ or IN-OUT args, if any

Line 660: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;

656: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
657: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
658: )
659: as
660: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;
661: ddx_complete_rec jtf_loc_areas_pvt.loc_area_rec_type;
662: ddindx binary_integer; indx binary_integer;
663: begin
664:

Line 661: ddx_complete_rec jtf_loc_areas_pvt.loc_area_rec_type;

657: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
658: )
659: as
660: ddp_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;
661: ddx_complete_rec jtf_loc_areas_pvt.loc_area_rec_type;
662: ddindx binary_integer; indx binary_integer;
663: begin
664:
665: -- copy data to the local IN or IN-OUT args, if any

Line 689: jtf_loc_areas_pvt.complete_loc_area_rec(ddp_loc_area_rec,

685: ddp_loc_area_rec.location_area_description := p0_a19;
686:
687:
688: -- here's the delegated call to the old PL/SQL routine
689: jtf_loc_areas_pvt.complete_loc_area_rec(ddp_loc_area_rec,
690: ddx_complete_rec);
691:
692: -- copy data back from the local OUT NOCOPY /* file.sql.39 change */ or IN-OUT args, if any
693:

Line 738: ddx_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;

734: , p0_a18 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
735: , p0_a19 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
736: )
737: as
738: ddx_loc_area_rec jtf_loc_areas_pvt.loc_area_rec_type;
739: ddindx binary_integer; indx binary_integer;
740: begin
741:
742: -- copy data to the local IN or IN-OUT args, if any

Line 745: jtf_loc_areas_pvt.init_rec(ddx_loc_area_rec);

741:
742: -- copy data to the local IN or IN-OUT args, if any
743:
744: -- here's the delegated call to the old PL/SQL routine
745: jtf_loc_areas_pvt.init_rec(ddx_loc_area_rec);
746:
747: -- copy data back from the local OUT NOCOPY /* file.sql.39 change */ or IN-OUT args, if any
748: p0_a0 := rosetta_g_miss_num_map(ddx_loc_area_rec.location_area_id);
749: p0_a1 := ddx_loc_area_rec.last_update_date;

Line 770: end jtf_loc_areas_pvt_w;

766: p0_a18 := ddx_loc_area_rec.location_area_name;
767: p0_a19 := ddx_loc_area_rec.location_area_description;
768: end;
769:
770: end jtf_loc_areas_pvt_w;