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_PARTY_SITES

Line 12: TYPE T_PARTY_SITE_ID IS TABLE OF HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;

8: TYPE ROWID IS TABLE OF VARCHAR2(50);
9: TYPE OWNER_TABLE_ID IS TABLE OF HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID%TYPE;
10:
11: TYPE T_ORIG_SYS_REF_ID IS TABLE OF HZ_ORIG_SYS_REFERENCES.ORIG_SYSTEM_REF_ID%TYPE;
12: TYPE T_PARTY_SITE_ID IS TABLE OF HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;
13:
14: l_row_id ROWID;
15: l_row_id_new ROWID;
16: l_row_id_old ROWID;

Line 99: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_PARTY_SITES', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');

95: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_FINANCIAL_REPORTS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
96: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_FINANCIAL_NUMBERS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
97: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_CODE_ASSIGNMENTS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
98: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_ORGANIZATION_INDICATORS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
99: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_PARTY_SITES', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
100: */
101:
102:
103: -- Code added for Bug 4079902.

Line 574: execute immediate 'alter sequence ' || l_schema || '.hz_party_sites_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';
573: execute immediate 'alter sequence ' || l_schema || '.hz_party_number_s cache 20000';
574: execute immediate 'alter sequence ' || l_schema || '.hz_party_sites_s cache 20000';
575: execute immediate 'alter sequence ' || l_schema || '.hz_party_site_number_s cache 20000';
576: execute immediate 'alter sequence ' || l_schema || '.hz_party_site_uses_s cache 20000';
577: execute immediate 'alter sequence ' || l_schema || '.hz_person_profiles_s cache 20000';
578: execute immediate 'alter sequence ' || l_schema || '.hz_relationships_s cache 20000';

Line 611: execute immediate 'alter sequence ' || l_schema || '.hz_party_sites_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';
610: execute immediate 'alter sequence ' || l_schema || '.hz_party_number_s cache 20';
611: execute immediate 'alter sequence ' || l_schema || '.hz_party_sites_s cache 20';
612: execute immediate 'alter sequence ' || l_schema || '.hz_party_site_number_s cache 20';
613: execute immediate 'alter sequence ' || l_schema || '.hz_party_site_uses_s cache 20';
614: execute immediate 'alter sequence ' || l_schema || '.hz_person_profiles_s cache 20';
615: execute immediate 'alter sequence ' || l_schema || '.hz_relationships_s cache 20';

Line 745: AND psosr.owner_table_name = ''HZ_PARTY_SITES''

741: AND posr.owner_table_name = ''HZ_PARTIES''
742: AND psosr.orig_system = site_sg.site_orig_system
743: AND psosr.orig_system_reference = site_sg.site_orig_system_reference
744: AND psosr.status = ''A''
745: AND psosr.owner_table_name = ''HZ_PARTY_SITES''
746: AND psosr.owner_table_id = site_sg.party_site_id
747: AND psosr.party_id <> posr.owner_table_id
748: AND NOT EXISTS
749: (SELECT 1 FROM HZ_IMP_TMP_ERRORS err

Line 785: from hz_imp_addresses_sg has, hz_orig_sys_references hos, hz_party_sites hps_new,hz_party_sites hps_old

781:
782:
783: l_cleanup_ssm_add_dnb VARCHAR2(4000) :=
784: ' select hos.rowid, hps_old.identifying_Address_flag, hps_old.rowid,hps_new.rowid
785: from hz_imp_addresses_sg has, hz_orig_sys_references hos, hz_party_sites hps_new,hz_party_sites hps_old
786: where has.site_orig_system=''DNB''
787: and has.old_site_orig_system_ref=hos.orig_system_reference
788: and hos.orig_system=has.site_orig_system
789: and hos.owner_table_name=''HZ_PARTY_SITES''

Line 789: and hos.owner_table_name=''HZ_PARTY_SITES''

785: from hz_imp_addresses_sg has, hz_orig_sys_references hos, hz_party_sites hps_new,hz_party_sites hps_old
786: where has.site_orig_system=''DNB''
787: and has.old_site_orig_system_ref=hos.orig_system_reference
788: and hos.orig_system=has.site_orig_system
789: and hos.owner_table_name=''HZ_PARTY_SITES''
790: and hos.status=''A''
791: and has.old_site_orig_system_ref is not null
792: and has.old_site_orig_system_ref<> has.site_orig_system_reference
793: and has.site_orig_system_reference=hps_new.orig_system_reference

Line 920: UPDATE HZ_PARTY_SITES

916: SET status='I',end_date_active = sysdate
917: WHERE rowid = l_row_id(j);
918:
919: FORALL j IN l_row_id_old.FIRST.. l_row_id_old.LAST
920: UPDATE HZ_PARTY_SITES
921: SET status='I', identifying_address_flag = 'N'
922: WHERE rowid = l_row_id_old(j);
923:
924: FORALL j IN l_row_id_new.FIRST.. l_row_id_new.LAST

Line 925: UPDATE HZ_PARTY_SITES

921: SET status='I', identifying_address_flag = 'N'
922: WHERE rowid = l_row_id_old(j);
923:
924: FORALL j IN l_row_id_new.FIRST.. l_row_id_new.LAST
925: UPDATE HZ_PARTY_SITES
926: SET identifying_address_flag = l_primary_flag(j)
927: WHERE rowid = l_row_id_new(j);
928:
929: IF l_last_fetch = TRUE THEN

Line 1586: 'AR_RAPI_DESC_FLEX_INVALID', 'DEF_NAME', 'HZ_PARTY_SITES')

1582: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1583: token1_name, token1_value)
1584: values (
1585: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1586: 'AR_RAPI_DESC_FLEX_INVALID', 'DEF_NAME', 'HZ_PARTY_SITES')
1587: when (E7_FLAG is null) then
1588: into hz_imp_errors (
1589: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
1590: values (

Line 1601: 'OPER_NAME', 'UPDATE', 'OBJECT_NAME', 'HZ_PARTY_SITES')

1597: token3_value)
1598: values (
1599: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1600: 'HZ_DSS_SECURITY_FAIL', 'USER_NAME', USER_NAME,
1601: 'OPER_NAME', 'UPDATE', 'OBJECT_NAME', 'HZ_PARTY_SITES')
1602: when (DUP_VAL_IDX_EXCEP_FLAG = 'A') then
1603: into hz_imp_errors (
1604: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1605: token1_name, token1_value, token2_name,

Line 1609: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_PARTY_SITES_U1', 'ENTITY',

1605: token1_name, token1_value, token2_name,
1606: token2_value)
1607: values (
1608: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1609: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_PARTY_SITES_U1', 'ENTITY',
1610: 'HZ_PARTY_SITES')
1611: when (DUP_VAL_IDX_EXCEP_FLAG = 'B') then
1612: into hz_imp_errors (
1613: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,

Line 1610: 'HZ_PARTY_SITES')

1606: token2_value)
1607: values (
1608: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1609: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_PARTY_SITES_U1', 'ENTITY',
1610: 'HZ_PARTY_SITES')
1611: when (DUP_VAL_IDX_EXCEP_FLAG = 'B') then
1612: into hz_imp_errors (
1613: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1614: token1_name, token1_value, token2_name, token2_value)

Line 1617: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_PARTY_SITES_U2', 'ENTITY',

1613: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1614: token1_name, token1_value, token2_name, token2_value)
1615: values (
1616: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1617: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_PARTY_SITES_U2', 'ENTITY',
1618: 'HZ_PARTY_SITES')
1619: when (DUP_VAL_IDX_EXCEP_FLAG = 'C') then
1620: into hz_imp_errors (
1621: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,

Line 1618: 'HZ_PARTY_SITES')

1614: token1_name, token1_value, token2_name, token2_value)
1615: values (
1616: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSES_INT',
1617: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_PARTY_SITES_U2', 'ENTITY',
1618: 'HZ_PARTY_SITES')
1619: when (DUP_VAL_IDX_EXCEP_FLAG = 'C') then
1620: into hz_imp_errors (
1621: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
1622: token1_name, token1_value, token2_name, token2_value)