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_POSTAL_CODES_PVT_W dependencies on JTF_LOC_POSTAL_CODES_PVT

Line 1: package body jtf_loc_postal_codes_pvt_w as

1: package body jtf_loc_postal_codes_pvt_w as
2: /* $Header: jtfwlopb.pls 120.2 2005/08/18 22:56:01 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 46: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;

42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: )
45: as
46: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;
47: ddindx binary_integer; indx binary_integer;
48: begin
49:
50: -- copy data to the local IN or IN-OUT args, if any

Line 75: jtf_loc_postal_codes_pvt.create_postal_code(p_api_version,

71: ddp_postal_code_rec.postal_code_end := p7_a13;
72:
73:
74: -- here's the delegated call to the old PL/SQL routine
75: jtf_loc_postal_codes_pvt.create_postal_code(p_api_version,
76: p_init_msg_list,
77: p_commit,
78: p_validation_level,
79: x_return_status,

Line 120: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;

116: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
117: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
118: )
119: as
120: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;
121: ddindx binary_integer; indx binary_integer;
122: begin
123:
124: -- copy data to the local IN or IN-OUT args, if any

Line 149: jtf_loc_postal_codes_pvt.update_postal_code(p_api_version,

145: ddp_postal_code_rec.postal_code_end := p7_a13;
146:
147:
148: -- here's the delegated call to the old PL/SQL routine
149: jtf_loc_postal_codes_pvt.update_postal_code(p_api_version,
150: p_init_msg_list,
151: p_commit,
152: p_validation_level,
153: x_return_status,

Line 192: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;

188: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
189: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
190: )
191: as
192: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;
193: ddindx binary_integer; indx binary_integer;
194: begin
195:
196: -- copy data to the local IN or IN-OUT args, if any

Line 219: jtf_loc_postal_codes_pvt.validate_postal_code(p_api_version,

215: ddp_postal_code_rec.postal_code_start := p6_a12;
216: ddp_postal_code_rec.postal_code_end := p6_a13;
217:
218: -- here's the delegated call to the old PL/SQL routine
219: jtf_loc_postal_codes_pvt.validate_postal_code(p_api_version,
220: p_init_msg_list,
221: p_validation_level,
222: x_return_status,
223: x_msg_count,

Line 254: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;

250: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
251: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
252: )
253: as
254: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;
255: ddindx binary_integer; indx binary_integer;
256: begin
257:
258: -- copy data to the local IN or IN-OUT args, if any

Line 277: jtf_loc_postal_codes_pvt.check_items(p_validation_mode,

273: ddp_postal_code_rec.postal_code_start := p2_a12;
274: ddp_postal_code_rec.postal_code_end := p2_a13;
275:
276: -- here's the delegated call to the old PL/SQL routine
277: jtf_loc_postal_codes_pvt.check_items(p_validation_mode,
278: x_return_status,
279: ddp_postal_code_rec);
280:
281: -- copy data back from the local OUT NOCOPY /* file.sql.39 change */ or IN-OUT args, if any

Line 304: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;

300: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
301: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
302: )
303: as
304: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;
305: ddindx binary_integer; indx binary_integer;
306: begin
307:
308: -- copy data to the local IN or IN-OUT args, if any

Line 327: jtf_loc_postal_codes_pvt.check_req_items(p_validation_mode,

323: ddp_postal_code_rec.postal_code_end := p1_a13;
324:
325:
326: -- here's the delegated call to the old PL/SQL routine
327: jtf_loc_postal_codes_pvt.check_req_items(p_validation_mode,
328: ddp_postal_code_rec,
329: x_return_status);
330:
331: -- copy data back from the local OUT NOCOPY /* file.sql.39 change */ or IN-OUT args, if any

Line 353: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;

349: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
350: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
351: )
352: as
353: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_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 375: jtf_loc_postal_codes_pvt.check_fk_items(ddp_postal_code_rec,

371: ddp_postal_code_rec.postal_code_end := p0_a13;
372:
373:
374: -- here's the delegated call to the old PL/SQL routine
375: jtf_loc_postal_codes_pvt.check_fk_items(ddp_postal_code_rec,
376: x_return_status);
377:
378: -- copy data back from the local OUT NOCOPY /* file.sql.39 change */ or IN-OUT args, if any
379:

Line 413: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;

409: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
410: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
411: )
412: as
413: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;
414: ddp_complete_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;
415: ddindx binary_integer; indx binary_integer;
416: begin
417:

Line 414: ddp_complete_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;

410: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
411: )
412: as
413: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;
414: ddp_complete_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;
415: ddindx binary_integer; indx binary_integer;
416: begin
417:
418: -- copy data to the local IN or IN-OUT args, if any

Line 451: jtf_loc_postal_codes_pvt.check_record(ddp_postal_code_rec,

447: ddp_complete_rec.postal_code_end := p1_a13;
448:
449:
450: -- here's the delegated call to the old PL/SQL routine
451: jtf_loc_postal_codes_pvt.check_record(ddp_postal_code_rec,
452: ddp_complete_rec,
453: x_return_status);
454:
455: -- copy data back from the local OUT NOCOPY /* file.sql.39 change */ or IN-OUT args, if any

Line 490: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;

486: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
487: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
488: )
489: as
490: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;
491: ddx_complete_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;
492: ddindx binary_integer; indx binary_integer;
493: begin
494:

Line 491: ddx_complete_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;

487: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
488: )
489: as
490: ddp_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;
491: ddx_complete_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;
492: ddindx binary_integer; indx binary_integer;
493: begin
494:
495: -- copy data to the local IN or IN-OUT args, if any

Line 513: jtf_loc_postal_codes_pvt.complete_rec(ddp_postal_code_rec,

509: ddp_postal_code_rec.postal_code_end := p0_a13;
510:
511:
512: -- here's the delegated call to the old PL/SQL routine
513: jtf_loc_postal_codes_pvt.complete_rec(ddp_postal_code_rec,
514: ddx_complete_rec);
515:
516: -- copy data back from the local OUT NOCOPY /* file.sql.39 change */ or IN-OUT args, if any
517:

Line 550: ddx_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;

546: , p0_a12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
547: , p0_a13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
548: )
549: as
550: ddx_postal_code_rec jtf_loc_postal_codes_pvt.postal_code_rec_type;
551: ddindx binary_integer; indx binary_integer;
552: begin
553:
554: -- copy data to the local IN or IN-OUT args, if any

Line 557: jtf_loc_postal_codes_pvt.init_rec(ddx_postal_code_rec);

553:
554: -- copy data to the local IN or IN-OUT args, if any
555:
556: -- here's the delegated call to the old PL/SQL routine
557: jtf_loc_postal_codes_pvt.init_rec(ddx_postal_code_rec);
558:
559: -- copy data back from the local OUT NOCOPY /* file.sql.39 change */ or IN-OUT args, if any
560: p0_a0 := rosetta_g_miss_num_map(ddx_postal_code_rec.location_postal_code_id);
561: p0_a1 := ddx_postal_code_rec.last_update_date;

Line 576: end jtf_loc_postal_codes_pvt_w;

572: p0_a12 := ddx_postal_code_rec.postal_code_start;
573: p0_a13 := ddx_postal_code_rec.postal_code_end;
574: end;
575:
576: end jtf_loc_postal_codes_pvt_w;