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 812: FROM hz_organization_profiles

808: ) RETURN VARCHAR2 IS
809:
810: CURSOR c_org_profile_exists IS
811: SELECT 'Y'
812: FROM hz_organization_profiles
813: WHERE party_id = p_party_id
814: AND actual_content_source = p_data_source_type
815: AND effective_end_date IS NULL;
816:

Line 928: UPDATE hz_organization_profiles

924: AND effective_end_date IS NULL );
925:
926: ELSIF p_party_type = 'ORGANIZATION' THEN
927:
928: UPDATE hz_organization_profiles
929: SET actual_content_source = G_MISS_CONTENT_SOURCE_TYPE
930: WHERE party_id = p_party_id
931: AND actual_content_source = G_SST_SOURCE_TYPE
932: AND effective_end_date IS NULL

Line 935: FROM hz_organization_profiles

931: AND actual_content_source = G_SST_SOURCE_TYPE
932: AND effective_end_date IS NULL
933: AND NOT EXISTS (
934: SELECT 'Y'
935: FROM hz_organization_profiles
936: WHERE party_id = p_party_id
937: AND actual_content_source = G_MISS_CONTENT_SOURCE_TYPE
938: AND effective_end_date IS NULL );
939:

Line 1738: * hz_organization_profiles_pkg.Insert_Row

1734: * DESCRIPTION
1735: * Creates organization profile.
1736: *
1737: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1738: * hz_organization_profiles_pkg.Insert_Row
1739: *
1740: * ARGUMENTS
1741: * IN:
1742: * p_party_id

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

1780: END IF;
1781:
1782: -- Debug info.
1783: /*IF g_debug THEN
1784: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'hz_organization_profiles_pkg.Insert_Row (+)',
1785: l_debug_prefix);
1786: END IF;
1787: */
1788: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1785: l_debug_prefix);
1786: END IF;
1787: */
1788: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1789: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_organization_profiles_pkg.Insert_Row (+)',
1790: p_msg_level=>fnd_log.level_procedure);
1791: END IF;
1792:
1793: -- call table-handler.

Line 1794: HZ_organization_profiles_pkg.insert_row(

1790: p_msg_level=>fnd_log.level_procedure);
1791: END IF;
1792:
1793: -- call table-handler.
1794: HZ_organization_profiles_pkg.insert_row(
1795: x_rowid => l_rowid,
1796: x_organization_profile_id => l_organization_profile_id,
1797: x_party_id => p_party_id,
1798: x_organization_name => p_organization_rec.organization_name,

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

1948:
1949:
1950: -- Debug info.
1951: /*IF g_debug THEN
1952: hz_utility_v2pub.debug ('hz_organization_profiles_pkg.Insert_Row (-) ',
1953: l_debug_prefix);
1954: END IF;
1955: */
1956: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1953: l_debug_prefix);
1954: END IF;
1955: */
1956: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1957: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_organization_profiles_pkg.Insert_Row (-) ',
1958: p_msg_level=>fnd_log.level_procedure);
1959: END IF;
1960:
1961: -- Debug info.

Line 1980: * hz_organization_profiles_pkg.Update_Row

1976: * DESCRIPTION
1977: * Updates organization profile.
1978: *
1979: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1980: * hz_organization_profiles_pkg.Update_Row
1981: *
1982: * ARGUMENTS
1983: * IN:
1984: * p_party_id

Line 2018: FROM hz_organization_profiles

2014:
2015: CURSOR c_org IS
2016: SELECT rowid, organization_profile_id,object_version_number,
2017: version_number,effective_start_date
2018: FROM hz_organization_profiles
2019: WHERE party_id = p_organization_rec.party_rec.party_id
2020: AND actual_content_source = p_data_source_type
2021: AND effective_end_date is null
2022: FOR UPDATE NOWAIT;

Line 2078: UPDATE hz_organization_profiles

2074: -- Always End date the existing profile and create a new profile
2075: --l_object_version_number := NVL(l_object_version_number, 1) + 1;
2076: l_version_number := nvl(l_version_number,1)+1;
2077:
2078: UPDATE hz_organization_profiles
2079: SET effective_end_date = decode(trunc(effective_start_date),trunc(sysdate),trunc(sysdate),TRUNC (SYSDATE-1)),
2080: object_version_number = NVL(l_object_version_number, 1) + 1
2081: --,version_number = NVL(version_number,1)+1
2082: WHERE rowid = l_rowid;

Line 2087: FROM hz_organization_profiles

2083:
2084: -- Bug 3560323 : Get business report from previous org profile to copy to new org profile
2085: BEGIN
2086: SELECT business_report INTO l_business_report
2087: FROM hz_organization_profiles
2088: WHERE rowid = l_rowid;
2089: EXCEPTION
2090: WHEN NO_DATA_FOUND THEN
2091: NULL;

Line 2107: UPDATE hz_organization_profiles

2103:
2104: l_object_version_number := 2;
2105:
2106: -- Bug 3560323 : Update the new org profile with previous business report
2107: UPDATE hz_organization_profiles
2108: SET business_report = l_business_report
2109: WHERE organization_profile_id = x_profile_id;
2110:
2111: --

Line 2134: UPDATE hz_organization_profiles

2130: END IF;
2131:
2132: /*
2133: IF TRUNC(l_effective_start_date) < TRUNC(SYSDATE) THEN
2134: UPDATE hz_organization_profiles
2135: SET effective_end_date = TRUNC(SYSDATE-1),
2136: object_version_number = NVL(object_version_number, 1) + 1
2137: WHERE rowid = l_rowid;
2138:

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

2151: */
2152: -- Debug info.
2153: /*IF g_debug THEN
2154: hz_utility_v2pub.debug ('profile_id = '||x_profile_id, l_debug_prefix);
2155: hz_utility_v2pub.debug ('hz_organization_profiles_pkg.Update_Row (+) ',
2156: l_debug_prefix);
2157: END IF;
2158: */
2159: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

2156: l_debug_prefix);
2157: END IF;
2158: */
2159: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2160: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_organization_profiles_pkg.Update_Row (+) ',
2161: p_msg_level=>fnd_log.level_procedure);
2162: END IF;
2163: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2164: hz_utility_v2pub.debug(p_message=>'profile_id = '||x_profile_id,

Line 2170: HZ_organization_profiles_pkg.update_row (

2166: p_msg_level=>fnd_log.level_statement);
2167: END IF;
2168:
2169: -- call table-handler.
2170: HZ_organization_profiles_pkg.update_row (
2171: x_rowid => l_rowid,
2172: x_organization_profile_id => x_profile_id,
2173: x_party_id => NULL,
2174: x_organization_name => p_organization_rec.organization_name,

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

2317: );
2318:
2319: -- Debug info.
2320: /*IF g_debug THEN
2321: hz_utility_v2pub.debug ('hz_organization_profiles_pkg.Update_Row (-) ',
2322: l_debug_prefix);
2323: END IF;
2324: */
2325: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

2322: l_debug_prefix);
2323: END IF;
2324: */
2325: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2326: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_organization_profiles_pkg.Update_Row (-) ',
2327: p_msg_level=>fnd_log.level_procedure);
2328: END IF;
2329:
2330: -- Debug info.

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

2339:
2340: EXCEPTION
2341: WHEN g_resource_busy THEN
2342: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
2343: fnd_message.set_token('TABLE', 'HZ_ORGANIZATION_PROFILES');
2344: fnd_msg_pub.add;
2345: RAISE fnd_api.g_exc_error;
2346:
2347: END do_update_org_profile;

Line 4147: HZ_POPULATE_BOT_PKG.pop_hz_organization_profiles(

4143: END IF;
4144:
4145: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
4146: -- populate function for integration service
4147: HZ_POPULATE_BOT_PKG.pop_hz_organization_profiles(
4148: p_operation => 'I',
4149: p_organization_profile_id => x_profile_id);
4150: END IF;
4151: ELSE

Line 4161: HZ_POPULATE_BOT_PKG.pop_hz_organization_profiles(

4157: END IF;
4158:
4159: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
4160: -- populate function for integration service
4161: HZ_POPULATE_BOT_PKG.pop_hz_organization_profiles(
4162: p_operation => 'U',
4163: p_organization_profile_id => x_profile_id);
4164: END IF;
4165: END IF;

Line 4771: HZ_POPULATE_BOT_PKG.pop_hz_organization_profiles(

4767: END IF;
4768:
4769: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
4770: -- populate function for integration service
4771: HZ_POPULATE_BOT_PKG.pop_hz_organization_profiles(
4772: p_operation => 'U',
4773: p_organization_profile_id => x_profile_id);
4774: END IF;
4775:

Line 6241: 'HZ_ORGANIZATION_PROFILES', g_org_entity_attr_id,

6237: -- cache if mix-n-match is enabled
6238:
6239: -- IF g_org_mixnmatch_enabled IS NULL THEN
6240: HZ_MIXNM_UTILITY.LoadDataSources(
6241: 'HZ_ORGANIZATION_PROFILES', g_org_entity_attr_id,
6242: g_org_mixnmatch_enabled, g_org_selected_datasources);
6243: -- END IF;
6244:
6245: -- Debug info.

Line 6668: 'HZ_ORGANIZATION_PROFILES', g_org_entity_attr_id,

6664: -- cache if mix-n-match is enabled
6665:
6666: -- IF g_org_mixnmatch_enabled IS NULL THEN
6667: HZ_MIXNM_UTILITY.LoadDataSources(
6668: 'HZ_ORGANIZATION_PROFILES', g_org_entity_attr_id,
6669: g_org_mixnmatch_enabled, g_org_selected_datasources);
6670: -- END IF;
6671:
6672: -- Get old records. Will be used by business event system.

Line 6939: * hz_organization_profiles_pkg.Select_Row

6935: * DESCRIPTION
6936: * Gets organization record.
6937: *
6938: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
6939: * hz_organization_profiles_pkg.Select_Row
6940: *
6941: * ARGUMENTS
6942: * IN:
6943: * p_init_msg_list Initialize message stack if it is set to

Line 6996: hz_organization_profiles org1,

6992:
6993: CURSOR c_org_ue IS
6994: SELECT NVL(org2.organization_profile_id,org1.organization_profile_id)
6995: FROM
6996: hz_organization_profiles org1,
6997: (SELECT organization_profile_id, party_id
6998: FROM hz_organization_profiles
6999: WHERE party_id = p_party_id
7000: AND actual_content_source = G_MISS_CONTENT_SOURCE_TYPE

Line 6998: FROM hz_organization_profiles

6994: SELECT NVL(org2.organization_profile_id,org1.organization_profile_id)
6995: FROM
6996: hz_organization_profiles org1,
6997: (SELECT organization_profile_id, party_id
6998: FROM hz_organization_profiles
6999: WHERE party_id = p_party_id
7000: AND actual_content_source = G_MISS_CONTENT_SOURCE_TYPE
7001: AND effective_end_date IS NULL) org2
7002: WHERE org1.party_id = p_party_id

Line 7009: FROM hz_organization_profiles

7005: AND org1.party_id = org2.party_id (+);
7006:
7007: CURSOR c_org IS
7008: SELECT organization_profile_id
7009: FROM hz_organization_profiles
7010: WHERE party_id = p_party_id
7011: AND actual_content_source = p_content_source_type
7012: AND effective_end_date IS NULL;
7013:

Line 7079: hz_organization_profiles_pkg.Select_Row (

7075: fnd_msg_pub.add;
7076: RAISE fnd_api.g_exc_error;
7077: END IF;
7078:
7079: hz_organization_profiles_pkg.Select_Row (
7080: x_organization_profile_id => l_profile_id,
7081: x_party_id => l_party_id,
7082: x_organization_name => x_organization_rec.organization_name,
7083: x_attribute_category => x_organization_rec.attribute_category,