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

Line 85: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

81: UNBALANCED_IND,
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_FINANCIAL_NUMBER_OBJ(
91: P_ACTION_TYPE,
92: NULL, -- COMMON_OBJ_ID

Line 103: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

99: PROJECTED_ACTUAL_FLAG,
100: STATUS,
101: PROGRAM_UPDATE_DATE,
102: CREATED_BY_MODULE,
103: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
104: CREATION_DATE,
105: LAST_UPDATE_DATE,
106: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
107: ACTUAL_CONTENT_SOURCE)

Line 106: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

102: CREATED_BY_MODULE,
103: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
104: CREATION_DATE,
105: LAST_UPDATE_DATE,
106: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
107: ACTUAL_CONTENT_SOURCE)
108: FROM HZ_FINANCIAL_NUMBERS
109: WHERE FINANCIAL_REPORT_ID = FR.FINANCIAL_REPORT_ID) AS HZ_FINANCIAL_NUMBER_OBJ_TBL))
110: FROM HZ_FINANCIAL_REPORTS FR

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

418: PRO.MAXIMUM_CREDIT_CURRENCY_CODE,
419: PRO.DISPLAYED_DUNS_PARTY_ID,
420: PRO.PROGRAM_UPDATE_DATE,
421: PRO.CREATED_BY_MODULE,
422: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(PRO.CREATED_BY),
423: PRO.CREATION_DATE,
424: PRO.LAST_UPDATE_DATE,
425: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(PRO.LAST_UPDATED_BY),
426: PRO.DO_NOT_CONFUSE_WITH,

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

421: PRO.CREATED_BY_MODULE,
422: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(PRO.CREATED_BY),
423: PRO.CREATION_DATE,
424: PRO.LAST_UPDATE_DATE,
425: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(PRO.LAST_UPDATED_BY),
426: PRO.DO_NOT_CONFUSE_WITH,
427: PRO.ACTUAL_CONTENT_SOURCE,
428: HZ_ORIG_SYS_REF_OBJ_TBL(),
429: HZ_EXT_ATTRIBUTE_OBJ_TBL(),

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

433: SELECT HZ_PARTY_PREF_OBJ(
434: P_ACTION_TYPE,
435: NULL, -- COMMON_OBJ_ID
436: PARTY_PREFERENCE_ID,
437: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',PARTY_ID),
438: PARTY_ID,
439: CATEGORY,
440: PREFERENCE_CODE,
441: VALUE_VARCHAR2,

Line 451: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

447: ADDITIONAL_VALUE2,
448: ADDITIONAL_VALUE3,
449: ADDITIONAL_VALUE4,
450: ADDITIONAL_VALUE5,
451: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
452: CREATION_DATE,
453: LAST_UPDATE_DATE,
454: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
455: FROM HZ_PARTY_PREFERENCES

Line 454: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))

450: ADDITIONAL_VALUE5,
451: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
452: CREATION_DATE,
453: LAST_UPDATE_DATE,
454: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
455: FROM HZ_PARTY_PREFERENCES
456: WHERE PARTY_ID = P_ORGANIZATION_ID) AS HZ_PARTY_PREF_OBJ_TBL),
457: HZ_PHONE_CP_BO_TBL(),
458: HZ_TELEX_CP_BO_TBL(),

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

465: SELECT HZ_CODE_ASSIGNMENT_OBJ(
466: P_ACTION_TYPE,
467: NULL, -- COMMON_OBJ_ID
468: CODE_ASSIGNMENT_ID,
469: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',OWNER_TABLE_ID),
470: OWNER_TABLE_ID,
471: CLASS_CATEGORY,
472: CLASS_CODE,
473: PRIMARY_FLAG,

Line 480: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

476: END_DATE_ACTIVE,
477: STATUS,
478: PROGRAM_UPDATE_DATE,
479: CREATED_BY_MODULE,
480: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
481: CREATION_DATE,
482: LAST_UPDATE_DATE,
483: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
484: RANK)

Line 483: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),

479: CREATED_BY_MODULE,
480: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
481: CREATION_DATE,
482: LAST_UPDATE_DATE,
483: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
484: RANK)
485: FROM HZ_CODE_ASSIGNMENTS
486: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
487: AND OWNER_TABLE_ID = P_ORGANIZATION_ID) AS HZ_CODE_ASSIGNMENT_OBJ_TBL),

Line 590: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

586: SPCL_EVNT_TXT,
587: ACTUAL_CONTENT_SOURCE,
588: PROGRAM_UPDATE_DATE,
589: CREATED_BY_MODULE,
590: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
591: CREATION_DATE,
592: LAST_UPDATE_DATE,
593: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
594: FROM HZ_CREDIT_RATINGS

Line 593: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))

589: CREATED_BY_MODULE,
590: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
591: CREATION_DATE,
592: LAST_UPDATE_DATE,
593: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
594: FROM HZ_CREDIT_RATINGS
595: WHERE PARTY_ID = P_ORGANIZATION_ID) AS HZ_CREDIT_RATING_OBJ_TBL),
596: CAST(MULTISET (
597: SELECT HZ_CERTIFICATION_OBJ(

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

598: P_ACTION_TYPE,
599: NULL, -- COMMON_OBJ_ID
600: CERTIFICATION_ID,
601: CERTIFICATION_NAME,
602: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',PARTY_ID),
603: PARTY_ID,
604: CURRENT_STATUS,
605: EXPIRES_ON_DATE,
606: GRADE,

Line 612: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

608: ISSUED_ON_DATE,
609: --WH_UPDATE_DATE,
610: STATUS,
611: PROGRAM_UPDATE_DATE,
612: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
613: CREATION_DATE,
614: LAST_UPDATE_DATE,
615: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
616: FROM HZ_CERTIFICATIONS

Line 615: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))

611: PROGRAM_UPDATE_DATE,
612: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
613: CREATION_DATE,
614: LAST_UPDATE_DATE,
615: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
616: FROM HZ_CERTIFICATIONS
617: WHERE PARTY_ID = P_ORGANIZATION_ID) AS HZ_CERTIFICATION_OBJ_TBL),
618: CAST(MULTISET (
619: SELECT HZ_FINANCIAL_PROF_OBJ(

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

627: FINANCIAL_ACCOUNT_NUMBER,
628: FINANCIAL_ACCOUNT_TYPE,
629: FINANCIAL_ORG_TYPE,
630: FINANCIAL_ORGANIZATION_NAME,
631: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',PARTY_ID),
632: PARTY_ID,
633: --WH_UPDATE_DATE,
634: STATUS,
635: PROGRAM_UPDATE_DATE,

Line 636: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),

632: PARTY_ID,
633: --WH_UPDATE_DATE,
634: STATUS,
635: PROGRAM_UPDATE_DATE,
636: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
637: CREATION_DATE,
638: LAST_UPDATE_DATE,
639: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
640: FROM HZ_FINANCIAL_PROFILE

Line 639: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))

635: PROGRAM_UPDATE_DATE,
636: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
637: CREATION_DATE,
638: LAST_UPDATE_DATE,
639: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
640: FROM HZ_FINANCIAL_PROFILE
641: WHERE PARTY_ID = P_ORGANIZATION_ID) AS HZ_FINANCIAL_PROF_OBJ_TBL),
642: HZ_CONTACT_PREF_OBJ_TBL(),
643: HZ_PARTY_USAGE_OBJ_TBL())

Line 1035: l_obj_root_ids HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL;

1031: x_return_status OUT NOCOPY VARCHAR2,
1032: x_msg_count OUT NOCOPY NUMBER,
1033: x_msg_data OUT NOCOPY VARCHAR2
1034: ) is
1035: l_obj_root_ids HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL;
1036: l_debug_prefix VARCHAR2(30) := '';
1037: begin
1038:
1039: -- initialize API return status to success.

Line 1056: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(

1052: p_msg_level=>fnd_log.level_procedure);
1053: END IF;
1054:
1055:
1056: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(
1057: p_init_msg_list => fnd_api.g_false,
1058: p_event_id => p_event_id,
1059: x_obj_root_ids => l_obj_root_ids,
1060: x_return_status => x_return_status,

Line 1223: l_obj_root_ids HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL;

1219: x_msg_count OUT NOCOPY NUMBER,
1220: x_msg_data OUT NOCOPY VARCHAR2
1221: ) is
1222:
1223: l_obj_root_ids HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL;
1224: l_debug_prefix VARCHAR2(30) := '';
1225:
1226: begin
1227:

Line 1245: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(

1241: p_msg_level=>fnd_log.level_procedure);
1242: END IF;
1243:
1244:
1245: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(
1246: p_init_msg_list => fnd_api.g_false,
1247: p_event_id => p_event_id,
1248: x_obj_root_ids => l_obj_root_ids,
1249: x_return_status => x_return_status,

Line 2062: l_obj_root_ids HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL;

2058: x_msg_count OUT NOCOPY NUMBER,
2059: x_msg_data OUT NOCOPY VARCHAR2
2060: ) is
2061:
2062: l_obj_root_ids HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL;
2063: l_debug_prefix VARCHAR2(30) := '';
2064: l_organization_obj HZ_ORGANIZATION_BO;
2065:
2066: begin

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

2080: p_prefix=>l_debug_prefix,
2081: p_msg_level=>fnd_log.level_procedure);
2082: END IF;
2083: /* moved to public api
2084: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
2085: p_party_id => p_organization_id,
2086: x_return_status => x_return_status);
2087:
2088: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN