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_CUST_ACCOUNT_SITE_V2PUB dependencies on HZ_CUST_SITE_USES

Line 561: hz_cust_site_uses_all su -- Bug 3456489

557: SELECT su.site_use_id,su.cust_acct_site_id
558: INTO l_site_use_id,l_cust_acct_site_id
559: FROM hz_cust_accounts a,
560: hz_cust_acct_sites_all cas, -- Bug 3456489
561: hz_cust_site_uses_all su -- Bug 3456489
562: WHERE a.cust_account_id = l_cust_acct_id
563: AND l_cust_acct_id = cas.cust_account_id
564: AND cas.cust_acct_site_id = su.cust_acct_site_id
565: AND su.site_use_code = p_site_use_code

Line 571: UPDATE hz_cust_site_uses_all -- Bug 3456489

567: AND su.primary_flag = 'Y'
568: AND cas.org_id = p_org_id -- TCA SSA Uptake (Bug 3456489)
569: AND su.org_id = p_org_id; -- TCA SSA Uptake (Bug 3456489)
570:
571: UPDATE hz_cust_site_uses_all -- Bug 3456489
572: SET primary_flag = 'N'
573: WHERE site_use_id =l_site_use_id;
574:
575: denormalize_site_use_flag(l_cust_acct_site_id,p_site_use_code,'Y');

Line 905: * HZ_CUST_SITE_USES_PKG.Insert_Row

901: * Private procedure to create customer account site use.
902: *
903: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
904: * HZ_ACCOUNT_VALIDATE_V2PUB.validate_cust_site_use
905: * HZ_CUST_SITE_USES_PKG.Insert_Row
906: *
907: * ARGUMENTS
908: * IN:
909: * p_create_profile If it is set to FND_API.G_TRUE, API create customer

Line 1079: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (+)',

1075: END IF;
1076:
1077: -- Debug info.
1078: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1079: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (+)',
1080: p_prefix=>l_debug_prefix,
1081: p_msg_level=>fnd_log.level_procedure);
1082: END IF;
1083:

Line 1117: hz_cust_site_uses_all su

1113: -- New Query Below
1114: SELECT count(*) into l_cnt
1115: FROM hz_cust_accounts a,
1116: hz_cust_acct_sites_all cas,
1117: hz_cust_site_uses_all su
1118: WHERE
1119: a.cust_account_id = l_cust_acct_id
1120: and a.cust_account_id = cas.cust_account_id
1121: and cas.cust_acct_site_id = su.cust_acct_site_id

Line 1130: hz_cust_site_uses_all su

1126: and su.org_id = p_cust_site_use_rec.org_id; -- TCA SSA Uptake (Bug 3456489) */
1127:
1128: SELECT count(*) into l_cnt
1129: FROM hz_cust_acct_sites_all cas,
1130: hz_cust_site_uses_all su
1131: WHERE
1132: cas.cust_account_id = l_cust_acct_id
1133: and cas.status = 'A'
1134: and cas.cust_acct_site_id = su.cust_acct_site_id

Line 1154: HZ_CUST_SITE_USES_PKG.Insert_Row (

1150: END IF;
1151: END IF;
1152:
1153: -- Call table-handler.
1154: HZ_CUST_SITE_USES_PKG.Insert_Row (
1155: X_SITE_USE_ID => p_cust_site_use_rec.site_use_id,
1156: X_CUST_ACCT_SITE_ID => p_cust_site_use_rec.cust_acct_site_id,
1157: X_SITE_USE_CODE => p_cust_site_use_rec.site_use_code,
1158: X_PRIMARY_FLAG => p_cust_site_use_rec.primary_flag,

Line 1262: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (-) ' ||

1258: );
1259:
1260: -- Debug info.
1261: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1262: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (-) ' ||
1263: 'x_site_use_id = ' || p_cust_site_use_rec.site_use_id,
1264: p_prefix=>l_debug_prefix,
1265: p_msg_level=>fnd_log.level_procedure);
1266: END IF;

Line 1280: l_orig_sys_reference_rec.owner_table_name := 'HZ_CUST_SITE_USES_ALL';

1276: if (p_cust_site_use_rec.orig_system is not null and p_cust_site_use_rec.orig_system<>fnd_api.g_miss_char ) then
1277:
1278: l_orig_sys_reference_rec.orig_system := p_cust_site_use_rec.orig_system;
1279: l_orig_sys_reference_rec.orig_system_reference := p_cust_site_use_rec.orig_system_reference;
1280: l_orig_sys_reference_rec.owner_table_name := 'HZ_CUST_SITE_USES_ALL';
1281: l_orig_sys_reference_rec.owner_table_id := p_cust_site_use_rec.site_use_id;
1282: l_orig_sys_reference_rec.created_by_module := p_cust_site_use_rec.created_by_module;
1283: hz_orig_system_ref_pub.create_orig_system_reference(
1284: FND_API.G_FALSE,

Line 1369: * HZ_CUST_SITE_USES_PKG.Update_Row

1365: * Private procedure to update customer account site use.
1366: *
1367: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1368: * HZ_ACCOUNT_VALIDATE_V2PUB.validate_cust_site_use
1369: * HZ_CUST_SITE_USES_PKG.Update_Row
1370: *
1371: * ARGUMENTS
1372: * IN/OUT:
1373: * p_cust_site_use_rec Customer account site use record.

Line 1407: l_site_use_code HZ_CUST_SITE_USES.site_use_code%TYPE;

1403: l_object_version_number NUMBER;
1404: l_flag VARCHAR2(1);
1405: l_denormalize BOOLEAN := FALSE;
1406:
1407: l_site_use_code HZ_CUST_SITE_USES.site_use_code%TYPE;
1408: l_cust_acct_site_id NUMBER;
1409: l_primary_flag HZ_CUST_SITE_USES.primary_flag%TYPE;
1410: l_status HZ_CUST_SITE_USES.status%TYPE;
1411: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

Line 1409: l_primary_flag HZ_CUST_SITE_USES.primary_flag%TYPE;

1405: l_denormalize BOOLEAN := FALSE;
1406:
1407: l_site_use_code HZ_CUST_SITE_USES.site_use_code%TYPE;
1408: l_cust_acct_site_id NUMBER;
1409: l_primary_flag HZ_CUST_SITE_USES.primary_flag%TYPE;
1410: l_status HZ_CUST_SITE_USES.status%TYPE;
1411: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
1412:
1413: /* Bug Fix:5036975 */

Line 1410: l_status HZ_CUST_SITE_USES.status%TYPE;

1406:
1407: l_site_use_code HZ_CUST_SITE_USES.site_use_code%TYPE;
1408: l_cust_acct_site_id NUMBER;
1409: l_primary_flag HZ_CUST_SITE_USES.primary_flag%TYPE;
1410: l_status HZ_CUST_SITE_USES.status%TYPE;
1411: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
1412:
1413: /* Bug Fix:5036975 */
1414: l_party_site_use_id HZ_PARTY_SITE_USES.party_site_use_id%TYPE;

Line 1416: l_created_by_module HZ_CUST_SITE_USES.created_by_module%TYPE;

1412:
1413: /* Bug Fix:5036975 */
1414: l_party_site_use_id HZ_PARTY_SITE_USES.party_site_use_id%TYPE;
1415: l_party_site_use_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE;
1416: l_created_by_module HZ_CUST_SITE_USES.created_by_module%TYPE;
1417: l_application_id HZ_CUST_SITE_USES.application_id%TYPE;
1418: l_message_count NUMBER;
1419: l_party_site_id NUMBER;
1420: l_dummy VARCHAR2(1);

Line 1417: l_application_id HZ_CUST_SITE_USES.application_id%TYPE;

1413: /* Bug Fix:5036975 */
1414: l_party_site_use_id HZ_PARTY_SITE_USES.party_site_use_id%TYPE;
1415: l_party_site_use_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE;
1416: l_created_by_module HZ_CUST_SITE_USES.created_by_module%TYPE;
1417: l_application_id HZ_CUST_SITE_USES.application_id%TYPE;
1418: l_message_count NUMBER;
1419: l_party_site_id NUMBER;
1420: l_dummy VARCHAR2(1);
1421: l_msg_count NUMBER;

Line 1451: FROM HZ_CUST_SITE_USES

1447: SITE_USE_CODE, PRIMARY_FLAG, STATUS, ORG_ID,CREATED_BY_MODULE,APPLICATION_ID
1448: INTO l_rowid, l_object_version_number,
1449: l_cust_acct_site_id, l_site_use_code, l_primary_flag, l_status,
1450: p_cust_site_use_rec.org_id,l_created_by_module,l_application_id
1451: FROM HZ_CUST_SITE_USES
1452: WHERE SITE_USE_ID = p_cust_site_use_rec.site_use_id
1453: FOR UPDATE NOWAIT;
1454:
1455: IF NOT (

Line 1463: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_site_uses' );

1459: l_object_version_number IS NOT NULL AND
1460: p_object_version_number = l_object_version_number ) )
1461: THEN
1462: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
1463: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_site_uses' );
1464: FND_MSG_PUB.ADD;
1465: RAISE FND_API.G_EXC_ERROR;
1466: END IF;
1467:

Line 1554: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (+)',

1550: END IF;
1551:
1552: -- Debug info.
1553: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1554: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (+)',
1555: p_prefix=>l_debug_prefix,
1556: p_msg_level=>fnd_log.level_procedure);
1557: END IF;
1558: --Bug Fix:5036975

Line 1572: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Update_Row (+)',

1568: end if;
1569:
1570: -- Debug info.
1571: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1572: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Update_Row (+)',
1573: p_prefix=>l_debug_prefix,
1574: p_msg_level=>fnd_log.level_procedure);
1575: END IF;
1576:

Line 1622: hz_cust_site_uses_all su

1618: -- New Query Below
1619: SELECT count(*) into l_cnt
1620: FROM hz_cust_accounts a,
1621: hz_cust_acct_sites_all cas,
1622: hz_cust_site_uses_all su
1623: WHERE
1624: a.cust_account_id = l_cust_acct_id
1625: and a.cust_account_id = cas.cust_account_id
1626: and cas.cust_acct_site_id = su.cust_acct_site_id

Line 1636: hz_cust_site_uses_all su

1632: and su.org_id = p_cust_site_use_rec.org_id; -- TCA SSA Uptake (Bug 3456489) */
1633:
1634: SELECT count(*) into l_cnt
1635: FROM hz_cust_acct_sites_all cas,
1636: hz_cust_site_uses_all su
1637: WHERE
1638: cas.cust_account_id = l_cust_acct_id
1639: and cas.status = 'A'
1640: and cas.cust_acct_site_id = su.cust_acct_site_id

Line 1678: hz_cust_site_uses_all su -- Bug 3456489

1674: BEGIN
1675: SELECT min(su.rowid),count(*) into l_minrowid,l_cnt
1676: FROM hz_cust_accounts a,
1677: hz_cust_acct_sites_all cas, -- Bug 3456489
1678: hz_cust_site_uses_all su -- Bug 3456489
1679: WHERE
1680: a.cust_account_id = l_cust_acct_id
1681: and a.cust_account_id = cas.cust_account_id
1682: and cas.cust_acct_site_id = su.cust_acct_site_id

Line 1693: UPDATE hz_cust_site_uses_all -- Bug 3456489

1689: END;
1690:
1691: IF l_cnt > 0 THEN
1692: BEGIN
1693: UPDATE hz_cust_site_uses_all -- Bug 3456489
1694: SET primary_flag = 'Y'
1695: WHERE rowid = l_minrowid;
1696: -- Bug 3294182.
1697: select cust_acct_site_id

Line 1699: from hz_cust_site_uses_all -- Bug 3456489

1695: WHERE rowid = l_minrowid;
1696: -- Bug 3294182.
1697: select cust_acct_site_id
1698: into l_casid
1699: from hz_cust_site_uses_all -- Bug 3456489
1700: where rowid=l_minrowid;
1701: denormalize_site_use_flag(
1702: l_casid,
1703: nvl(p_cust_site_use_rec.site_use_code,l_site_use_code),

Line 1713: HZ_CUST_SITE_USES_PKG.Update_Row (

1709: END IF;
1710: END IF;
1711:
1712: -- Call table-handler.
1713: HZ_CUST_SITE_USES_PKG.Update_Row (
1714: X_Rowid => l_rowid,
1715: X_SITE_USE_ID => p_cust_site_use_rec.site_use_id,
1716: X_CUST_ACCT_SITE_ID => p_cust_site_use_rec.cust_acct_site_id,
1717: X_SITE_USE_CODE => p_cust_site_use_rec.site_use_code,

Line 1821: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Update_Row (-)',

1817: );
1818:
1819: -- Debug info.
1820: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1821: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Update_Row (-)',
1822: p_prefix=>l_debug_prefix,
1823: p_msg_level=>fnd_log.level_procedure);
1824: END IF;
1825:

Line 2760: HZ_POPULATE_BOT_PKG.pop_hz_cust_site_uses_all(

2756: END IF;
2757:
2758: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2759: -- populate function for integration service
2760: HZ_POPULATE_BOT_PKG.pop_hz_cust_site_uses_all(
2761: p_operation => 'I',
2762: p_site_use_id => x_site_use_id );
2763: END IF;
2764: END IF;

Line 2944: p_owner_table_name => 'HZ_CUST_SITE_USES_ALL',

2940: and (p_cust_site_use_rec.site_use_id = FND_API.G_MISS_NUM or p_cust_site_use_rec.site_use_id is null) THEN
2941: hz_orig_system_ref_pub.get_owner_table_id
2942: (p_orig_system => p_cust_site_use_rec.orig_system,
2943: p_orig_system_reference => p_cust_site_use_rec.orig_system_reference,
2944: p_owner_table_name => 'HZ_CUST_SITE_USES_ALL',
2945: x_owner_table_id => l_cust_site_use_rec.site_use_id ,
2946: x_return_status => x_return_status);
2947: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2948: RAISE FND_API.G_EXC_ERROR;

Line 2984: HZ_POPULATE_BOT_PKG.pop_hz_cust_site_uses_all(

2980: END IF;
2981:
2982: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2983: -- populate function for integration service
2984: HZ_POPULATE_BOT_PKG.pop_hz_cust_site_uses_all(
2985: p_operation => 'U',
2986: p_site_use_id => l_cust_site_use_rec.site_use_id );
2987: END IF;
2988: END IF;

Line 3101: * HZ_CUST_SITE_USES_PKG.Select_Row

3097: * DESCRIPTION
3098: * Gets customer account site use record
3099: *
3100: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
3101: * HZ_CUST_SITE_USES_PKG.Select_Row
3102: *
3103: * ARGUMENTS
3104: * IN:
3105: * p_init_msg_list Initialize message stack if it is set to

Line 3173: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Select_Row (+)',

3169: x_cust_site_use_rec.site_use_id := p_site_use_id;
3170:
3171: -- Debug info.
3172: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3173: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Select_Row (+)',
3174: p_prefix=>l_debug_prefix,
3175: p_msg_level=>fnd_log.level_procedure);
3176: END IF;
3177:

Line 3179: HZ_CUST_SITE_USES_PKG.Select_Row (

3175: p_msg_level=>fnd_log.level_procedure);
3176: END IF;
3177:
3178: -- Call table-handler.
3179: HZ_CUST_SITE_USES_PKG.Select_Row (
3180: X_SITE_USE_ID => x_cust_site_use_rec.site_use_id,
3181: X_CUST_ACCT_SITE_ID => x_cust_site_use_rec.cust_acct_site_id,
3182: X_SITE_USE_CODE => x_cust_site_use_rec.site_use_code,
3183: X_PRIMARY_FLAG => x_cust_site_use_rec.primary_flag,

Line 3285: hz_utility_v2pub.debug(p_message=> 'HZ_CUST_SITE_USES_PKG.Select_Row (-)',

3281: );
3282:
3283: -- Debug info.
3284: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3285: hz_utility_v2pub.debug(p_message=> 'HZ_CUST_SITE_USES_PKG.Select_Row (-)',
3286: p_prefix=>l_debug_prefix,
3287: p_msg_level=>fnd_log.level_procedure);
3288: END IF;
3289: