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.HZ_PERSON_INFO_V2PUB_JW dependencies on HZ_PERSON_INFO_V2PUB

Line 1: package body hz_person_info_v2pub_jw as

1: package body hz_person_info_v2pub_jw as
2: /* $Header: ARH2PIJB.pls 120.5 2005/06/18 04:29:06 jhuang 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 41: ddp_person_language_rec hz_person_info_v2pub.person_language_rec_type;

37: , p1_a10 VARCHAR2 := null
38: , p1_a11 NUMBER := null
39: )
40: as
41: ddp_person_language_rec hz_person_info_v2pub.person_language_rec_type;
42: ddindx binary_integer; indx binary_integer;
43: begin
44:
45: -- copy data to the local IN or IN-OUT args, if any

Line 65: hz_person_info_v2pub.create_person_language(p_init_msg_list,

61:
62:
63:
64: -- here's the delegated call to the old PL/SQL routine
65: hz_person_info_v2pub.create_person_language(p_init_msg_list,
66: ddp_person_language_rec,
67: x_language_use_reference_id,
68: x_return_status,
69: x_msg_count,

Line 99: ddp_person_language_rec hz_person_info_v2pub.person_language_rec_type;

95: , p1_a10 VARCHAR2 := null
96: , p1_a11 NUMBER := null
97: )
98: as
99: ddp_person_language_rec hz_person_info_v2pub.person_language_rec_type;
100: ddindx binary_integer; indx binary_integer;
101: begin
102:
103: -- copy data to the local IN or IN-OUT args, if any

Line 123: hz_person_info_v2pub.update_person_language(p_init_msg_list,

119:
120:
121:
122: -- here's the delegated call to the old PL/SQL routine
123: hz_person_info_v2pub.update_person_language(p_init_msg_list,
124: ddp_person_language_rec,
125: p_object_version_number,
126: x_return_status,
127: x_msg_count,

Line 157: ddp_person_language_rec hz_person_info_v2pub.person_language_rec_type;

153: , x_msg_count out nocopy NUMBER
154: , x_msg_data out nocopy VARCHAR2
155: )
156: as
157: ddp_person_language_rec hz_person_info_v2pub.person_language_rec_type;
158: ddindx binary_integer; indx binary_integer;
159: begin
160:
161: -- copy data to the local IN or IN-OUT args, if any

Line 169: hz_person_info_v2pub.get_person_language_rec(p_init_msg_list,

165:
166:
167:
168: -- here's the delegated call to the old PL/SQL routine
169: hz_person_info_v2pub.get_person_language_rec(p_init_msg_list,
170: p_language_use_reference_id,
171: ddp_person_language_rec,
172: x_return_status,
173: x_msg_count,

Line 215: ddp_citizenship_rec hz_person_info_v2pub.citizenship_rec_type;

211: , p1_a10 VARCHAR2 := null
212: , p1_a11 NUMBER := null
213: )
214: as
215: ddp_citizenship_rec hz_person_info_v2pub.citizenship_rec_type;
216: ddindx binary_integer; indx binary_integer;
217: begin
218:
219: -- copy data to the local IN or IN-OUT args, if any

Line 239: hz_person_info_v2pub.create_citizenship(p_init_msg_list,

235:
236:
237:
238: -- here's the delegated call to the old PL/SQL routine
239: hz_person_info_v2pub.create_citizenship(p_init_msg_list,
240: ddp_citizenship_rec,
241: x_citizenship_id,
242: x_return_status,
243: x_msg_count,

Line 273: ddp_citizenship_rec hz_person_info_v2pub.citizenship_rec_type;

269: , p1_a10 VARCHAR2 := null
270: , p1_a11 NUMBER := null
271: )
272: as
273: ddp_citizenship_rec hz_person_info_v2pub.citizenship_rec_type;
274: ddindx binary_integer; indx binary_integer;
275: begin
276:
277: -- copy data to the local IN or IN-OUT args, if any

Line 297: hz_person_info_v2pub.update_citizenship(p_init_msg_list,

293:
294:
295:
296: -- here's the delegated call to the old PL/SQL routine
297: hz_person_info_v2pub.update_citizenship(p_init_msg_list,
298: ddp_citizenship_rec,
299: p_object_version_number,
300: x_return_status,
301: x_msg_count,

Line 331: ddx_citizenship_rec hz_person_info_v2pub.citizenship_rec_type;

327: , x_msg_count out nocopy NUMBER
328: , x_msg_data out nocopy VARCHAR2
329: )
330: as
331: ddx_citizenship_rec hz_person_info_v2pub.citizenship_rec_type;
332: ddindx binary_integer; indx binary_integer;
333: begin
334:
335: -- copy data to the local IN or IN-OUT args, if any

Line 343: hz_person_info_v2pub.get_citizenship_rec(p_init_msg_list,

339:
340:
341:
342: -- here's the delegated call to the old PL/SQL routine
343: hz_person_info_v2pub.get_citizenship_rec(p_init_msg_list,
344: p_citizenship_id,
345: ddx_citizenship_rec,
346: x_return_status,
347: x_msg_count,

Line 389: ddp_education_rec hz_person_info_v2pub.education_rec_type;

385: , p1_a10 VARCHAR2 := null
386: , p1_a11 NUMBER := null
387: )
388: as
389: ddp_education_rec hz_person_info_v2pub.education_rec_type;
390: ddindx binary_integer; indx binary_integer;
391: begin
392:
393: -- copy data to the local IN or IN-OUT args, if any

Line 413: hz_person_info_v2pub.create_education(p_init_msg_list,

409:
410:
411:
412: -- here's the delegated call to the old PL/SQL routine
413: hz_person_info_v2pub.create_education(p_init_msg_list,
414: ddp_education_rec,
415: x_education_id,
416: x_return_status,
417: x_msg_count,

Line 447: ddp_education_rec hz_person_info_v2pub.education_rec_type;

443: , p1_a10 VARCHAR2 := null
444: , p1_a11 NUMBER := null
445: )
446: as
447: ddp_education_rec hz_person_info_v2pub.education_rec_type;
448: ddindx binary_integer; indx binary_integer;
449: begin
450:
451: -- copy data to the local IN or IN-OUT args, if any

Line 471: hz_person_info_v2pub.update_education(p_init_msg_list,

467:
468:
469:
470: -- here's the delegated call to the old PL/SQL routine
471: hz_person_info_v2pub.update_education(p_init_msg_list,
472: ddp_education_rec,
473: p_object_version_number,
474: x_return_status,
475: x_msg_count,

Line 505: ddx_education_rec hz_person_info_v2pub.education_rec_type;

501: , x_msg_count out nocopy NUMBER
502: , x_msg_data out nocopy VARCHAR2
503: )
504: as
505: ddx_education_rec hz_person_info_v2pub.education_rec_type;
506: ddindx binary_integer; indx binary_integer;
507: begin
508:
509: -- copy data to the local IN or IN-OUT args, if any

Line 517: hz_person_info_v2pub.get_education_rec(p_init_msg_list,

513:
514:
515:
516: -- here's the delegated call to the old PL/SQL routine
517: hz_person_info_v2pub.get_education_rec(p_init_msg_list,
518: p_education_id,
519: ddx_education_rec,
520: x_return_status,
521: x_msg_count,

Line 576: ddp_employment_history_rec hz_person_info_v2pub.employment_history_rec_type;

572: , p1_a23 VARCHAR2 := null
573: , p1_a24 NUMBER := null
574: )
575: as
576: ddp_employment_history_rec hz_person_info_v2pub.employment_history_rec_type;
577: ddindx binary_integer; indx binary_integer;
578: begin
579:
580: -- copy data to the local IN or IN-OUT args, if any

Line 613: hz_person_info_v2pub.create_employment_history(p_init_msg_list,

609:
610:
611:
612: -- here's the delegated call to the old PL/SQL routine
613: hz_person_info_v2pub.create_employment_history(p_init_msg_list,
614: ddp_employment_history_rec,
615: x_employment_history_id,
616: x_return_status,
617: x_msg_count,

Line 660: ddp_employment_history_rec hz_person_info_v2pub.employment_history_rec_type;

656: , p1_a23 VARCHAR2 := null
657: , p1_a24 NUMBER := null
658: )
659: as
660: ddp_employment_history_rec hz_person_info_v2pub.employment_history_rec_type;
661: ddindx binary_integer; indx binary_integer;
662: begin
663:
664: -- copy data to the local IN or IN-OUT args, if any

Line 697: hz_person_info_v2pub.update_employment_history(p_init_msg_list,

693:
694:
695:
696: -- here's the delegated call to the old PL/SQL routine
697: hz_person_info_v2pub.update_employment_history(p_init_msg_list,
698: ddp_employment_history_rec,
699: p_object_version_number,
700: x_return_status,
701: x_msg_count,

Line 744: ddx_employment_history_rec hz_person_info_v2pub.employment_history_rec_type;

740: , x_msg_count out nocopy NUMBER
741: , x_msg_data out nocopy VARCHAR2
742: )
743: as
744: ddx_employment_history_rec hz_person_info_v2pub.employment_history_rec_type;
745: ddindx binary_integer; indx binary_integer;
746: begin
747:
748: -- copy data to the local IN or IN-OUT args, if any

Line 756: hz_person_info_v2pub.get_employment_history_rec(p_init_msg_list,

752:
753:
754:
755: -- here's the delegated call to the old PL/SQL routine
756: hz_person_info_v2pub.get_employment_history_rec(p_init_msg_list,
757: p_employment_history_id,
758: ddx_employment_history_rec,
759: x_return_status,
760: x_msg_count,

Line 810: ddp_work_class_rec hz_person_info_v2pub.work_class_rec_type;

806: , p1_a5 VARCHAR2 := null
807: , p1_a6 NUMBER := null
808: )
809: as
810: ddp_work_class_rec hz_person_info_v2pub.work_class_rec_type;
811: ddindx binary_integer; indx binary_integer;
812: begin
813:
814: -- copy data to the local IN or IN-OUT args, if any

Line 829: hz_person_info_v2pub.create_work_class(p_init_msg_list,

825:
826:
827:
828: -- here's the delegated call to the old PL/SQL routine
829: hz_person_info_v2pub.create_work_class(p_init_msg_list,
830: ddp_work_class_rec,
831: x_work_class_id,
832: x_return_status,
833: x_msg_count,

Line 858: ddp_work_class_rec hz_person_info_v2pub.work_class_rec_type;

854: , p1_a5 VARCHAR2 := null
855: , p1_a6 NUMBER := null
856: )
857: as
858: ddp_work_class_rec hz_person_info_v2pub.work_class_rec_type;
859: ddindx binary_integer; indx binary_integer;
860: begin
861:
862: -- copy data to the local IN or IN-OUT args, if any

Line 877: hz_person_info_v2pub.update_work_class(p_init_msg_list,

873:
874:
875:
876: -- here's the delegated call to the old PL/SQL routine
877: hz_person_info_v2pub.update_work_class(p_init_msg_list,
878: ddp_work_class_rec,
879: p_object_version_number,
880: x_return_status,
881: x_msg_count,

Line 906: ddx_work_class_rec hz_person_info_v2pub.work_class_rec_type;

902: , x_msg_count out nocopy NUMBER
903: , x_msg_data out nocopy VARCHAR2
904: )
905: as
906: ddx_work_class_rec hz_person_info_v2pub.work_class_rec_type;
907: ddindx binary_integer; indx binary_integer;
908: begin
909:
910: -- copy data to the local IN or IN-OUT args, if any

Line 918: hz_person_info_v2pub.get_work_class_rec(p_init_msg_list,

914:
915:
916:
917: -- here's the delegated call to the old PL/SQL routine
918: hz_person_info_v2pub.get_work_class_rec(p_init_msg_list,
919: p_work_class_id,
920: ddx_work_class_rec,
921: x_return_status,
922: x_msg_count,

Line 961: ddp_person_interest_rec hz_person_info_v2pub.person_interest_rec_type;

957: , p1_a12 VARCHAR2 := null
958: , p1_a13 NUMBER := null
959: )
960: as
961: ddp_person_interest_rec hz_person_info_v2pub.person_interest_rec_type;
962: ddindx binary_integer; indx binary_integer;
963: begin
964:
965: -- copy data to the local IN or IN-OUT args, if any

Line 987: hz_person_info_v2pub.create_person_interest(p_init_msg_list,

983:
984:
985:
986: -- here's the delegated call to the old PL/SQL routine
987: hz_person_info_v2pub.create_person_interest(p_init_msg_list,
988: ddp_person_interest_rec,
989: x_person_interest_id,
990: x_return_status,
991: x_msg_count,

Line 1023: ddp_person_interest_rec hz_person_info_v2pub.person_interest_rec_type;

1019: , p1_a12 VARCHAR2 := null
1020: , p1_a13 NUMBER := null
1021: )
1022: as
1023: ddp_person_interest_rec hz_person_info_v2pub.person_interest_rec_type;
1024: ddindx binary_integer; indx binary_integer;
1025: begin
1026:
1027: -- copy data to the local IN or IN-OUT args, if any

Line 1049: hz_person_info_v2pub.update_person_interest(p_init_msg_list,

1045:
1046:
1047:
1048: -- here's the delegated call to the old PL/SQL routine
1049: hz_person_info_v2pub.update_person_interest(p_init_msg_list,
1050: ddp_person_interest_rec,
1051: p_object_version_number,
1052: x_return_status,
1053: x_msg_count,

Line 1085: ddx_person_interest_rec hz_person_info_v2pub.person_interest_rec_type;

1081: , x_msg_count out nocopy NUMBER
1082: , x_msg_data out nocopy VARCHAR2
1083: )
1084: as
1085: ddx_person_interest_rec hz_person_info_v2pub.person_interest_rec_type;
1086: ddindx binary_integer; indx binary_integer;
1087: begin
1088:
1089: -- copy data to the local IN or IN-OUT args, if any

Line 1097: hz_person_info_v2pub.get_person_interest_rec(p_init_msg_list,

1093:
1094:
1095:
1096: -- here's the delegated call to the old PL/SQL routine
1097: hz_person_info_v2pub.get_person_interest_rec(p_init_msg_list,
1098: p_person_interest_id,
1099: ddx_person_interest_rec,
1100: x_return_status,
1101: x_msg_count,

Line 1126: end hz_person_info_v2pub_jw;

1122:
1123:
1124: end;
1125:
1126: end hz_person_info_v2pub_jw;