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

Line 891: -- nullify denorm column in hz_organization_profiles

887: sic_code_type = decode(l_error_class_category(i), 'SIC', null, sic_code_type),
888: sic_code = decode(l_error_class_category(i), 'SIC', null, sic_code)
889: where hz_pty.party_id = l_error_party_id(i);
890:
891: -- nullify denorm column in hz_organization_profiles
892: /* Bug 409189: when checking hz_organization_profiles.actual_content_source,
893: there are three cases to consider:
894: 1. ACS is third party. Update org profile where ACS = ''
895: 2. ACS is USER_ENTERED and party has third party profile.

Line 892: /* Bug 409189: when checking hz_organization_profiles.actual_content_source,

888: sic_code = decode(l_error_class_category(i), 'SIC', null, sic_code)
889: where hz_pty.party_id = l_error_party_id(i);
890:
891: -- nullify denorm column in hz_organization_profiles
892: /* Bug 409189: when checking hz_organization_profiles.actual_content_source,
893: there are three cases to consider:
894: 1. ACS is third party. Update org profile where ACS = ''
895: 2. ACS is USER_ENTERED and party has third party profile.
896: Update org profile where ACS = 'USER_ENTERED'

Line 903: update hz_organization_profiles org

899: */
900:
901: /* Take care of cases 1 and 2 */
902: forall i in 1..l_error_party_id.count
903: update hz_organization_profiles org
904: set
905: local_activity_code = decode(l_error_class_category(i), 'NACE', null, local_activity_code),
906: sic_code_type = decode(l_error_class_category(i), 'SIC',null, sic_code_type),
907: sic_code = decode(l_error_class_category(i), 'SIC', null, sic_code)

Line 916: update hz_organization_profiles org

912: /* Take care of case 3.
913: Even though this will update SST record for case 2 as well, since
914: we will rerun mix-n-match to derive SST, it'll be ok to update here */
915: forall i in 1..l_error_party_id.count
916: update hz_organization_profiles org
917: set
918: local_activity_code = decode(l_error_class_category(i), 'NACE', null, local_activity_code),
919: sic_code_type = decode(l_error_class_category(i), 'SIC',null, sic_code_type),
920: sic_code = decode(l_error_class_category(i), 'SIC', null, sic_code)

Line 999: -- de-norm to hz_organization_profiles

995: sic_code_type = decode(l_update_class_category(i), 'SIC', l_update_int_class_category(i), sic_code_type),
996: sic_code = decode(l_update_class_category(i), 'SIC', l_update_class_code(i), sic_code)
997: where hz_pty.party_id = l_update_party_id(i);
998:
999: -- de-norm to hz_organization_profiles
1000: /* Bug 409189: when checking hz_organization_profiles.actual_content_source,
1001: there are three cases to consider:
1002: 1. ACS is third party. Update org profile where ACS = ''
1003: 2. ACS is USER_ENTERED and party has third party profile.

Line 1000: /* Bug 409189: when checking hz_organization_profiles.actual_content_source,

996: sic_code = decode(l_update_class_category(i), 'SIC', l_update_class_code(i), sic_code)
997: where hz_pty.party_id = l_update_party_id(i);
998:
999: -- de-norm to hz_organization_profiles
1000: /* Bug 409189: when checking hz_organization_profiles.actual_content_source,
1001: there are three cases to consider:
1002: 1. ACS is third party. Update org profile where ACS = ''
1003: 2. ACS is USER_ENTERED and party has third party profile.
1004: Update org profile where ACS = 'USER_ENTERED'

Line 1011: update hz_organization_profiles org

1007: */
1008:
1009: /* Take care of cases 1 and 2 */
1010: forall i in 1..l_update_party_id.count
1011: update hz_organization_profiles org
1012: set local_activity_code = decode(l_update_class_category(i), 'NACE', l_update_class_code(i), local_activity_code),
1013: sic_code_type = decode(l_update_class_category(i), 'SIC', l_update_int_class_category(i), sic_code_type),
1014: sic_code = decode(l_update_class_category(i), 'SIC', l_update_class_code(i), sic_code)
1015: where org.party_id = l_update_party_id(i)

Line 1021: update hz_organization_profiles org

1017: and actual_content_source = P_DML_RECORD.actual_content_src;
1018:
1019: /* Take care of cases 3 */
1020: forall i in 1..l_update_party_id.count
1021: update hz_organization_profiles org
1022: set local_activity_code = decode(l_update_class_category(i), 'NACE', l_update_class_code(i), local_activity_code),
1023: sic_code_type = decode(l_update_class_category(i), 'SIC', l_update_int_class_category(i), sic_code_type),
1024: sic_code = decode(l_update_class_category(i), 'SIC', l_update_class_code(i), sic_code)
1025: where org.party_id = l_update_party_id(i)

Line 1033: HZ_MIXNM_UTILITY.isMixNMatchEnabled('HZ_ORGANIZATION_PROFILES',l_entity_attr_id) = 'Y' THEN

1029:
1030: /* Run mix-n-match after updating org profiles if
1031: mix-n-match is enabled */
1032: IF l_update_party_id.count > 0 AND
1033: HZ_MIXNM_UTILITY.isMixNMatchEnabled('HZ_ORGANIZATION_PROFILES',l_entity_attr_id) = 'Y' THEN
1034: HZ_MIXNM_CONC_DYNAMIC_PKG.ImportUpdateOrgSST(P_DML_RECORD.actual_content_src,P_DML_RECORD.FROM_OSR,P_DML_RECORD.TO_OSR,P_DML_RECORD.BATCH_ID,P_DML_RECORD.request_id,P_DML_RECORD.program_id,P_DML_RECORD.program_application_id);
1035: END IF;
1036:
1037: FND_FILE.PUT_LINE(FND_FILE.LOG, 'process_insert_code_assignment (-)');