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

Line 819: FROM hz_organization_profiles

815: ) RETURN VARCHAR2 IS
816:
817: CURSOR c_org_profile_exists IS
818: SELECT 'Y'
819: FROM hz_organization_profiles
820: WHERE party_id = p_party_id
821: AND actual_content_source = p_data_source_type
822: AND effective_end_date IS NULL;
823:

Line 935: UPDATE hz_organization_profiles

931: AND effective_end_date IS NULL );
932:
933: ELSIF p_party_type = 'ORGANIZATION' THEN
934:
935: UPDATE hz_organization_profiles
936: SET actual_content_source = G_MISS_CONTENT_SOURCE_TYPE
937: WHERE party_id = p_party_id
938: AND actual_content_source = G_SST_SOURCE_TYPE
939: AND effective_end_date IS NULL

Line 942: FROM hz_organization_profiles

938: AND actual_content_source = G_SST_SOURCE_TYPE
939: AND effective_end_date IS NULL
940: AND NOT EXISTS (
941: SELECT 'Y'
942: FROM hz_organization_profiles
943: WHERE party_id = p_party_id
944: AND actual_content_source = G_MISS_CONTENT_SOURCE_TYPE
945: AND effective_end_date IS NULL );
946:

Line 1745: * hz_organization_profiles_pkg.Insert_Row

1741: * DESCRIPTION
1742: * Creates organization profile.
1743: *
1744: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1745: * hz_organization_profiles_pkg.Insert_Row
1746: *
1747: * ARGUMENTS
1748: * IN:
1749: * p_party_id

Line 1793: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'hz_organization_profiles_pkg.Insert_Row (+)',

1789: END IF;
1790:
1791: -- Debug info.
1792: /*IF g_debug THEN
1793: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'hz_organization_profiles_pkg.Insert_Row (+)',
1794: l_debug_prefix);
1795: END IF;
1796: */
1797: --Bug9648645

Line 1830: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_organization_profiles_pkg.Insert_Row (+)',

1826:
1827:
1828:
1829: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1830: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_organization_profiles_pkg.Insert_Row (+)',
1831: p_msg_level=>fnd_log.level_procedure);
1832: END IF;
1833:
1834: -- call table-handler.

Line 1835: HZ_organization_profiles_pkg.insert_row(

1831: p_msg_level=>fnd_log.level_procedure);
1832: END IF;
1833:
1834: -- call table-handler.
1835: HZ_organization_profiles_pkg.insert_row(
1836: x_rowid => l_rowid,
1837: x_organization_profile_id => l_organization_profile_id,
1838: x_party_id => p_party_id,
1839: x_organization_name => p_organization_rec.organization_name,

Line 1993: hz_utility_v2pub.debug ('hz_organization_profiles_pkg.Insert_Row (-) ',

1989:
1990:
1991: -- Debug info.
1992: /*IF g_debug THEN
1993: hz_utility_v2pub.debug ('hz_organization_profiles_pkg.Insert_Row (-) ',
1994: l_debug_prefix);
1995: END IF;
1996: */
1997: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1998: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_organization_profiles_pkg.Insert_Row (-) ',

1994: l_debug_prefix);
1995: END IF;
1996: */
1997: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1998: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_organization_profiles_pkg.Insert_Row (-) ',
1999: p_msg_level=>fnd_log.level_procedure);
2000: END IF;
2001:
2002: -- Debug info.

Line 2021: * hz_organization_profiles_pkg.Update_Row

2017: * DESCRIPTION
2018: * Updates organization profile.
2019: *
2020: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2021: * hz_organization_profiles_pkg.Update_Row
2022: *
2023: * ARGUMENTS
2024: * IN:
2025: * p_party_id

Line 2059: FROM hz_organization_profiles

2055:
2056: CURSOR c_org IS
2057: SELECT rowid, organization_profile_id,object_version_number,
2058: version_number,effective_start_date
2059: FROM hz_organization_profiles
2060: WHERE party_id = p_organization_rec.party_rec.party_id
2061: AND actual_content_source = p_data_source_type
2062: AND effective_end_date is null
2063: FOR UPDATE NOWAIT;

Line 2119: UPDATE hz_organization_profiles

2115: -- Always End date the existing profile and create a new profile
2116: --l_object_version_number := NVL(l_object_version_number, 1) + 1;
2117: l_version_number := nvl(l_version_number,1)+1;
2118:
2119: UPDATE hz_organization_profiles
2120: SET effective_end_date = decode(trunc(effective_start_date),trunc(sysdate),trunc(sysdate),TRUNC (SYSDATE-1)),
2121: object_version_number = NVL(l_object_version_number, 1) + 1
2122: --,version_number = NVL(version_number,1)+1
2123: WHERE rowid = l_rowid;

Line 2128: FROM hz_organization_profiles

2124:
2125: -- Bug 3560323 : Get business report from previous org profile to copy to new org profile
2126: BEGIN
2127: SELECT business_report INTO l_business_report
2128: FROM hz_organization_profiles
2129: WHERE rowid = l_rowid;
2130: EXCEPTION
2131: WHEN NO_DATA_FOUND THEN
2132: NULL;

Line 2148: UPDATE hz_organization_profiles

2144:
2145: l_object_version_number := 2;
2146:
2147: -- Bug 3560323 : Update the new org profile with previous business report
2148: UPDATE hz_organization_profiles
2149: SET business_report = l_business_report
2150: WHERE organization_profile_id = x_profile_id;
2151:
2152: --

Line 2175: UPDATE hz_organization_profiles

2171: END IF;
2172:
2173: /*
2174: IF TRUNC(l_effective_start_date) < TRUNC(SYSDATE) THEN
2175: UPDATE hz_organization_profiles
2176: SET effective_end_date = TRUNC(SYSDATE-1),
2177: object_version_number = NVL(object_version_number, 1) + 1
2178: WHERE rowid = l_rowid;
2179:

Line 2196: hz_utility_v2pub.debug ('hz_organization_profiles_pkg.Update_Row (+) ',

2192: */
2193: -- Debug info.
2194: /*IF g_debug THEN
2195: hz_utility_v2pub.debug ('profile_id = '||x_profile_id, l_debug_prefix);
2196: hz_utility_v2pub.debug ('hz_organization_profiles_pkg.Update_Row (+) ',
2197: l_debug_prefix);
2198: END IF;
2199: */
2200: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 2201: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_organization_profiles_pkg.Update_Row (+) ',

2197: l_debug_prefix);
2198: END IF;
2199: */
2200: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2201: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_organization_profiles_pkg.Update_Row (+) ',
2202: p_msg_level=>fnd_log.level_procedure);
2203: END IF;
2204: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2205: hz_utility_v2pub.debug(p_message=>'profile_id = '||x_profile_id,

Line 2211: HZ_organization_profiles_pkg.update_row (

2207: p_msg_level=>fnd_log.level_statement);
2208: END IF;
2209:
2210: -- call table-handler.
2211: HZ_organization_profiles_pkg.update_row (
2212: x_rowid => l_rowid,
2213: x_organization_profile_id => x_profile_id,
2214: x_party_id => NULL,
2215: x_organization_name => p_organization_rec.organization_name,

Line 2362: hz_utility_v2pub.debug ('hz_organization_profiles_pkg.Update_Row (-) ',

2358: );
2359:
2360: -- Debug info.
2361: /*IF g_debug THEN
2362: hz_utility_v2pub.debug ('hz_organization_profiles_pkg.Update_Row (-) ',
2363: l_debug_prefix);
2364: END IF;
2365: */
2366: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 2367: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_organization_profiles_pkg.Update_Row (-) ',

2363: l_debug_prefix);
2364: END IF;
2365: */
2366: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2367: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_organization_profiles_pkg.Update_Row (-) ',
2368: p_msg_level=>fnd_log.level_procedure);
2369: END IF;
2370:
2371: -- Debug info.

Line 2384: fnd_message.set_token('TABLE', 'HZ_ORGANIZATION_PROFILES');

2380:
2381: EXCEPTION
2382: WHEN g_resource_busy THEN
2383: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
2384: fnd_message.set_token('TABLE', 'HZ_ORGANIZATION_PROFILES');
2385: fnd_msg_pub.add;
2386: RAISE fnd_api.g_exc_error;
2387:
2388: END do_update_org_profile;

Line 4206: HZ_POPULATE_BOT_PKG.pop_hz_organization_profiles(

4202: END IF;
4203:
4204: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
4205: -- populate function for integration service
4206: HZ_POPULATE_BOT_PKG.pop_hz_organization_profiles(
4207: p_operation => 'I',
4208: p_organization_profile_id => x_profile_id);
4209: END IF;
4210: ELSE

Line 4220: HZ_POPULATE_BOT_PKG.pop_hz_organization_profiles(

4216: END IF;
4217:
4218: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
4219: -- populate function for integration service
4220: HZ_POPULATE_BOT_PKG.pop_hz_organization_profiles(
4221: p_operation => 'U',
4222: p_organization_profile_id => x_profile_id);
4223: END IF;
4224: END IF;

Line 4831: HZ_POPULATE_BOT_PKG.pop_hz_organization_profiles(

4827: END IF;
4828:
4829: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
4830: -- populate function for integration service
4831: HZ_POPULATE_BOT_PKG.pop_hz_organization_profiles(
4832: p_operation => 'U',
4833: p_organization_profile_id => x_profile_id);
4834: END IF;
4835:

Line 6312: 'HZ_ORGANIZATION_PROFILES', g_org_entity_attr_id,

6308: -- cache if mix-n-match is enabled
6309:
6310: -- IF g_org_mixnmatch_enabled IS NULL THEN
6311: HZ_MIXNM_UTILITY.LoadDataSources(
6312: 'HZ_ORGANIZATION_PROFILES', g_org_entity_attr_id,
6313: g_org_mixnmatch_enabled, g_org_selected_datasources);
6314: -- END IF;
6315:
6316: -- Debug info.

Line 6749: 'HZ_ORGANIZATION_PROFILES', g_org_entity_attr_id,

6745: -- cache if mix-n-match is enabled
6746:
6747: -- IF g_org_mixnmatch_enabled IS NULL THEN
6748: HZ_MIXNM_UTILITY.LoadDataSources(
6749: 'HZ_ORGANIZATION_PROFILES', g_org_entity_attr_id,
6750: g_org_mixnmatch_enabled, g_org_selected_datasources);
6751: -- END IF;
6752:
6753: -- Get old records. Will be used by business event system.

Line 7020: * hz_organization_profiles_pkg.Select_Row

7016: * DESCRIPTION
7017: * Gets organization record.
7018: *
7019: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
7020: * hz_organization_profiles_pkg.Select_Row
7021: *
7022: * ARGUMENTS
7023: * IN:
7024: * p_init_msg_list Initialize message stack if it is set to

Line 7077: hz_organization_profiles org1,

7073:
7074: CURSOR c_org_ue IS
7075: SELECT NVL(org2.organization_profile_id,org1.organization_profile_id)
7076: FROM
7077: hz_organization_profiles org1,
7078: (SELECT organization_profile_id, party_id
7079: FROM hz_organization_profiles
7080: WHERE party_id = p_party_id
7081: AND actual_content_source = G_MISS_CONTENT_SOURCE_TYPE

Line 7079: FROM hz_organization_profiles

7075: SELECT NVL(org2.organization_profile_id,org1.organization_profile_id)
7076: FROM
7077: hz_organization_profiles org1,
7078: (SELECT organization_profile_id, party_id
7079: FROM hz_organization_profiles
7080: WHERE party_id = p_party_id
7081: AND actual_content_source = G_MISS_CONTENT_SOURCE_TYPE
7082: AND effective_end_date IS NULL) org2
7083: WHERE org1.party_id = p_party_id

Line 7090: FROM hz_organization_profiles

7086: AND org1.party_id = org2.party_id (+);
7087:
7088: CURSOR c_org IS
7089: SELECT organization_profile_id
7090: FROM hz_organization_profiles
7091: WHERE party_id = p_party_id
7092: AND actual_content_source = p_content_source_type
7093: AND effective_end_date IS NULL;
7094:

Line 7161: hz_organization_profiles_pkg.Select_Row (

7157: RAISE fnd_api.g_exc_error;
7158: END IF;
7159:
7160:
7161: hz_organization_profiles_pkg.Select_Row (
7162: x_organization_profile_id => l_profile_id,
7163: x_party_id => l_party_id,
7164: x_organization_name => x_organization_rec.organization_name,
7165: x_attribute_category => x_organization_rec.attribute_category,