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_IMP_LOAD_WRAPPER dependencies on HZ_ORGANIZATION_PROFILES

Line 79: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_ORGANIZATION_PROFILES', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');

75: 1, l_aol_schema, l_apps_schema, l_apps_mls_schema);
76:
77: --Add policy functions
78: /*
79: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_ORGANIZATION_PROFILES', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
80: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_PERSON_PROFILES', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
81: */
82:
83: -- Bug 4079902

Line 84: DBMS_RLS.ADD_POLICY(l_ar_schema, 'HZ_ORGANIZATION_PROFILES', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');

80: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_PERSON_PROFILES', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
81: */
82:
83: -- Bug 4079902
84: DBMS_RLS.ADD_POLICY(l_ar_schema, 'HZ_ORGANIZATION_PROFILES', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
85: DBMS_RLS.ADD_POLICY(l_ar_schema, 'HZ_PERSON_PROFILES', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
86:
87:
88: /* Commented code for bug 4079902 */

Line 550: execute immediate 'alter sequence ' || l_schema || '.hz_organization_profiles_s increment by 3';

546: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_tmp,l_schema);
547:
548: IF P_OPERATION = 'I' THEN
549: /* Increase increment for muti-table insert for parties */
550: execute immediate 'alter sequence ' || l_schema || '.hz_organization_profiles_s increment by 3';
551: execute immediate 'alter sequence ' || l_schema || '.hz_person_profiles_s increment by 3';
552: execute immediate 'alter sequence ' || l_schema || '.hz_location_profiles_s increment by 2';
553: execute immediate 'alter sequence ' || l_schema || '.hz_party_usg_assignments_s increment by 2';
554:

Line 568: execute immediate 'alter sequence ' || l_schema || '.hz_organization_profiles_s cache 20000';

564: execute immediate 'alter sequence ' || l_schema || '.hz_financial_reports_s cache 20000';
565: execute immediate 'alter sequence ' || l_schema || '.hz_imp_errors_s cache 20000';
566: execute immediate 'alter sequence hr.hr_locations_s cache 20000';
567: execute immediate 'alter sequence ' || l_schema || '.hz_location_profiles_s cache 20000';
568: execute immediate 'alter sequence ' || l_schema || '.hz_organization_profiles_s cache 20000';
569: execute immediate 'alter sequence ' || l_schema || '.hz_org_contacts_s cache 20000';
570: execute immediate 'alter sequence ' || l_schema || '.hz_org_contact_roles_s cache 20000';
571: execute immediate 'alter sequence ' || l_schema || '.hz_orig_system_ref_s cache 20000';
572: execute immediate 'alter sequence ' || l_schema || '.hz_parties_s cache 20000';

Line 587: execute immediate 'alter sequence ' || l_schema || '.hz_organization_profiles_s increment by 1';

583: /* Check if any outstanding data load concurrent req. If so, do not reset */
584: open c_running_dl_wrapper;
585: fetch c_running_dl_wrapper into l_running_dl_wrapper;
586: IF l_running_dl_wrapper is null THEN
587: execute immediate 'alter sequence ' || l_schema || '.hz_organization_profiles_s increment by 1';
588: execute immediate 'alter sequence ' || l_schema || '.hz_person_profiles_s increment by 1';
589: execute immediate 'alter sequence ' || l_schema || '.hz_location_profiles_s increment by 1';
590: execute immediate 'alter sequence ' || l_schema || '.hz_party_usg_assignments_s increment by 1';
591: END IF;

Line 605: execute immediate 'alter sequence ' || l_schema || '.hz_organization_profiles_s cache 20';

601: execute immediate 'alter sequence ' || l_schema || '.hz_financial_reports_s cache 20';
602: execute immediate 'alter sequence ' || l_schema || '.hz_imp_errors_s cache 20';
603: execute immediate 'alter sequence hr.hr_locations_s cache 20';
604: execute immediate 'alter sequence ' || l_schema || '.hz_location_profiles_s cache 20';
605: execute immediate 'alter sequence ' || l_schema || '.hz_organization_profiles_s cache 20';
606: execute immediate 'alter sequence ' || l_schema || '.hz_org_contacts_s cache 20';
607: execute immediate 'alter sequence ' || l_schema || '.hz_org_contact_roles_s cache 20';
608: execute immediate 'alter sequence ' || l_schema || '.hz_orig_system_ref_s cache 20';
609: execute immediate 'alter sequence ' || l_schema || '.hz_parties_s cache 20';

Line 1242: update hz_organization_profiles

1238: FETCH c_displayed_duns BULK COLLECT INTO
1239: l_party_id, l_displayed_duns_party_id;
1240:
1241: ForAll j in 1..l_party_id.count
1242: update hz_organization_profiles
1243: set displayed_duns_party_id = l_displayed_duns_party_id(j)
1244: where party_id = l_party_id(j)
1245: and effective_end_date is null
1246: and actual_content_source = 'DNB';