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_EXTRACT_PERSON_BO_PVT dependencies on HZ_EXTRACT_BO_UTIL_PVT

Line 85: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

81: COMMENTS,
82: STATUS,
83: PROGRAM_UPDATE_DATE,
84: CREATED_BY_MODULE,
85: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
86: CREATION_DATE,
87: LAST_UPDATE_DATE,
88: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
89: CAST(MULTISET (

Line 88: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

84: CREATED_BY_MODULE,
85: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
86: CREATION_DATE,
87: LAST_UPDATE_DATE,
88: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
89: CAST(MULTISET (
90: SELECT HZ_WORK_CLASS_OBJ(
91: P_ACTION_TYPE,
92: NULL, -- COMMON_OBJ_ID

Line 100: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

96: EMPLOYMENT_HISTORY_ID,
97: STATUS,
98: PROGRAM_UPDATE_DATE,
99: CREATED_BY_MODULE,
100: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
101: CREATION_DATE,
102: LAST_UPDATE_DATE,
103: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
104: FROM HZ_WORK_CLASS

Line 103: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))

99: CREATED_BY_MODULE,
100: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
101: CREATION_DATE,
102: LAST_UPDATE_DATE,
103: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
104: FROM HZ_WORK_CLASS
105: WHERE WORK_CLASS_ID = P_PERSON_ID
106: AND WORK_CLASS_NAME = 'HZ_PARTIES') AS HZ_WORK_CLASS_OBJ_TBL))
107: FROM HZ_EMPLOYMENT_HISTORY

Line 344: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(PRO.CREATED_BY),

340: PRO.LAST_KNOWN_GPS,
341: PRO.INTERNAL_FLAG,
342: PRO.PROGRAM_UPDATE_DATE,
343: PRO.CREATED_BY_MODULE,
344: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(PRO.CREATED_BY),
345: PRO.CREATION_DATE,
346: PRO.LAST_UPDATE_DATE,
347: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(PRO.LAST_UPDATED_BY),
348: PRO.ACTUAL_CONTENT_SOURCE,

Line 347: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(PRO.LAST_UPDATED_BY),

343: PRO.CREATED_BY_MODULE,
344: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(PRO.CREATED_BY),
345: PRO.CREATION_DATE,
346: PRO.LAST_UPDATE_DATE,
347: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(PRO.LAST_UPDATED_BY),
348: PRO.ACTUAL_CONTENT_SOURCE,
349: HZ_ORIG_SYS_REF_OBJ_TBL(),
350: HZ_EXT_ATTRIBUTE_OBJ_TBL(),
351: HZ_PARTY_SITE_BO_TBL(),

Line 357: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',PARTY_ID),

353: SELECT HZ_PARTY_PREF_OBJ(
354: P_ACTION_TYPE,
355: NULL, -- COMMON_OBJ_ID
356: PARTY_PREFERENCE_ID,
357: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',PARTY_ID),
358: PARTY_ID,
359: CATEGORY,
360: PREFERENCE_CODE,
361: VALUE_VARCHAR2,

Line 371: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

367: ADDITIONAL_VALUE2,
368: ADDITIONAL_VALUE3,
369: ADDITIONAL_VALUE4,
370: ADDITIONAL_VALUE5,
371: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
372: CREATION_DATE,
373: LAST_UPDATE_DATE,
374: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
375: FROM HZ_PARTY_PREFERENCES

Line 374: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))

370: ADDITIONAL_VALUE5,
371: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
372: CREATION_DATE,
373: LAST_UPDATE_DATE,
374: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
375: FROM HZ_PARTY_PREFERENCES
376: WHERE PARTY_ID = P_PERSON_ID) AS HZ_PARTY_PREF_OBJ_TBL),
377: HZ_RELATIONSHIP_OBJ_TBL(),
378: HZ_PHONE_CP_BO_TBL(),

Line 387: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',OWNER_TABLE_ID),

383: SELECT HZ_CODE_ASSIGNMENT_OBJ(
384: P_ACTION_TYPE,
385: NULL, -- COMMON_OBJ_ID
386: CODE_ASSIGNMENT_ID,
387: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',OWNER_TABLE_ID),
388: OWNER_TABLE_ID,
389: CLASS_CATEGORY,
390: CLASS_CODE,
391: PRIMARY_FLAG,

Line 398: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

394: END_DATE_ACTIVE,
395: STATUS,
396: PROGRAM_UPDATE_DATE,
397: CREATED_BY_MODULE,
398: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
399: CREATION_DATE,
400: LAST_UPDATE_DATE,
401: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
402: RANK)

Line 401: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

397: CREATED_BY_MODULE,
398: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
399: CREATION_DATE,
400: LAST_UPDATE_DATE,
401: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
402: RANK)
403: FROM HZ_CODE_ASSIGNMENTS
404: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
405: AND OWNER_TABLE_ID = P_PERSON_ID) AS HZ_CODE_ASSIGNMENT_OBJ_TBL),

Line 422: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

418: SPOKEN_COMPREHENSION_LEVEL,
419: STATUS,
420: PROGRAM_UPDATE_DATE,
421: CREATED_BY_MODULE,
422: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
423: CREATION_DATE,
424: LAST_UPDATE_DATE,
425: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
426: FROM HZ_PERSON_LANGUAGE

Line 425: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))

421: CREATED_BY_MODULE,
422: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
423: CREATION_DATE,
424: LAST_UPDATE_DATE,
425: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
426: FROM HZ_PERSON_LANGUAGE
427: WHERE PARTY_ID = P_PERSON_ID) AS HZ_PERSON_LANG_OBJ_TBL),
428: CAST(MULTISET (
429: SELECT HZ_EDUCATION_OBJ(

Line 444: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

440: TYPE_OF_SCHOOL,
441: STATUS,
442: PROGRAM_UPDATE_DATE,
443: CREATED_BY_MODULE,
444: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
445: CREATION_DATE,
446: LAST_UPDATE_DATE,
447: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
448: FROM HZ_EDUCATION

Line 447: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))

443: CREATED_BY_MODULE,
444: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
445: CREATION_DATE,
446: LAST_UPDATE_DATE,
447: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
448: FROM HZ_EDUCATION
449: WHERE PARTY_ID = P_PERSON_ID) AS HZ_EDUCATION_OBJ_TBL),
450: CAST(MULTISET (
451: SELECT HZ_CITIZENSHIP_OBJ(

Line 466: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

462: DOCUMENT_REFERENCE,
463: STATUS,
464: PROGRAM_UPDATE_DATE,
465: CREATED_BY_MODULE,
466: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
467: CREATION_DATE,
468: LAST_UPDATE_DATE,
469: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
470: FROM HZ_CITIZENSHIP

Line 469: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))

465: CREATED_BY_MODULE,
466: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
467: CREATION_DATE,
468: LAST_UPDATE_DATE,
469: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
470: FROM HZ_CITIZENSHIP
471: WHERE PARTY_ID = P_PERSON_ID) AS HZ_CITIZENSHIP_OBJ_TBL),
472: HZ_EMPLOY_HIST_BO_TBL(),
473: CAST(MULTISET (

Line 491: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

487: SINCE,
488: STATUS,
489: PROGRAM_UPDATE_DATE,
490: CREATED_BY_MODULE,
491: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
492: CREATION_DATE,
493: LAST_UPDATE_DATE,
494: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
495: FROM HZ_PERSON_INTEREST

Line 494: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))

490: CREATED_BY_MODULE,
491: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
492: CREATION_DATE,
493: LAST_UPDATE_DATE,
494: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
495: FROM HZ_PERSON_INTEREST
496: WHERE PARTY_ID = P_PERSON_ID) AS HZ_PERSON_INTEREST_OBJ_TBL),
497: CAST(MULTISET (
498: SELECT HZ_CERTIFICATION_OBJ(

Line 503: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',PARTY_ID),

499: P_ACTION_TYPE,
500: NULL, -- COMMON_OBJ_ID
501: CERTIFICATION_ID,
502: CERTIFICATION_NAME,
503: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',PARTY_ID),
504: PARTY_ID,
505: CURRENT_STATUS,
506: EXPIRES_ON_DATE,
507: GRADE,

Line 513: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

509: ISSUED_ON_DATE,
510: --WH_UPDATE_DATE,
511: STATUS,
512: PROGRAM_UPDATE_DATE,
513: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
514: CREATION_DATE,
515: LAST_UPDATE_DATE,
516: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
517: FROM HZ_CERTIFICATIONS

Line 516: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))

512: PROGRAM_UPDATE_DATE,
513: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
514: CREATION_DATE,
515: LAST_UPDATE_DATE,
516: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
517: FROM HZ_CERTIFICATIONS
518: WHERE PARTY_ID = P_PERSON_ID) AS HZ_CERTIFICATION_OBJ_TBL),
519: CAST(MULTISET (
520: SELECT HZ_FINANCIAL_PROF_OBJ(

Line 532: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',PARTY_ID),

528: FINANCIAL_ACCOUNT_NUMBER,
529: FINANCIAL_ACCOUNT_TYPE,
530: FINANCIAL_ORG_TYPE,
531: FINANCIAL_ORGANIZATION_NAME,
532: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',PARTY_ID),
533: PARTY_ID,
534: --WH_UPDATE_DATE,
535: STATUS,
536: PROGRAM_UPDATE_DATE,

Line 537: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

533: PARTY_ID,
534: --WH_UPDATE_DATE,
535: STATUS,
536: PROGRAM_UPDATE_DATE,
537: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
538: CREATION_DATE,
539: LAST_UPDATE_DATE,
540: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
541: FROM HZ_FINANCIAL_PROFILE

Line 540: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))

536: PROGRAM_UPDATE_DATE,
537: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
538: CREATION_DATE,
539: LAST_UPDATE_DATE,
540: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
541: FROM HZ_FINANCIAL_PROFILE
542: WHERE PARTY_ID = P_PERSON_ID) AS HZ_FINANCIAL_PROF_OBJ_TBL),
543: HZ_CONTACT_PREF_OBJ_TBL(),
544: HZ_PARTY_USAGE_OBJ_TBL())

Line 882: l_obj_root_ids HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL;

878: x_msg_count OUT NOCOPY NUMBER,
879: x_msg_data OUT NOCOPY VARCHAR2
880: ) is
881:
882: l_obj_root_ids HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL;
883: l_debug_prefix VARCHAR2(30) := '';
884: begin
885:
886: -- initialize API return status to success.

Line 903: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(

899: p_msg_level=>fnd_log.level_procedure);
900: END IF;
901:
902:
903: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(
904: p_init_msg_list => fnd_api.g_false,
905: p_event_id => p_event_id,
906: x_obj_root_ids => l_obj_root_ids,
907: x_return_status => x_return_status,

Line 1073: l_obj_root_ids HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL;

1069: x_msg_count OUT NOCOPY NUMBER,
1070: x_msg_data OUT NOCOPY VARCHAR2
1071: ) is
1072:
1073: l_obj_root_ids HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL;
1074: l_debug_prefix VARCHAR2(30) := '';
1075:
1076: begin
1077:

Line 1095: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(

1091: p_msg_level=>fnd_log.level_procedure);
1092: END IF;
1093:
1094:
1095: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(
1096: p_init_msg_list => fnd_api.g_false,
1097: p_event_id => p_event_id,
1098: x_obj_root_ids => l_obj_root_ids,
1099: x_return_status => x_return_status,

Line 1669: l_obj_root_ids HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL;

1665: x_return_status OUT NOCOPY VARCHAR2,
1666: x_msg_count OUT NOCOPY NUMBER,
1667: x_msg_data OUT NOCOPY VARCHAR2
1668: ) is
1669: l_obj_root_ids HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL;
1670: l_debug_prefix VARCHAR2(30) := '';
1671: l_person_obj HZ_PERSON_BO;
1672:
1673: begin

Line 1691: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,

1687: p_prefix=>l_debug_prefix,
1688: p_msg_level=>fnd_log.level_procedure);
1689: END IF;
1690: /* moved to public api
1691: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
1692: p_party_id => p_person_id,
1693: x_return_status => x_return_status);
1694:
1695: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN