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

557: CURSOR c_site (l_cust_acct_id VARCHAR2) IS
558: SELECT su.site_use_id,su.cust_acct_site_id
559: FROM hz_cust_accounts a,
560: hz_cust_acct_sites_all cas,
561: hz_cust_site_uses_all su
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 590: hz_cust_site_uses_all su -- Bug 3456489

586: SELECT su.site_use_id,su.cust_acct_site_id
587: INTO l_site_use_id,l_cust_acct_site_id
588: FROM hz_cust_accounts a,
589: hz_cust_acct_sites_all cas, -- Bug 3456489
590: hz_cust_site_uses_all su -- Bug 3456489
591: WHERE a.cust_account_id = l_cust_acct_id
592: AND l_cust_acct_id = cas.cust_account_id
593: AND cas.cust_acct_site_id = su.cust_acct_site_id
594: AND su.site_use_code = p_site_use_code

Line 600: UPDATE hz_cust_site_uses_all -- Bug 3456489

596: AND su.primary_flag = 'Y'
597: AND cas.org_id = p_org_id -- TCA SSA Uptake (Bug 3456489)
598: AND su.org_id = p_org_id; -- TCA SSA Uptake (Bug 3456489)
599:
600: UPDATE hz_cust_site_uses_all -- Bug 3456489
601: SET primary_flag = 'N',
602: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
603: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
604: WHERE site_use_id =l_site_use_id;

Line 642: UPDATE hz_cust_site_uses_all -- Bug 3456489

638: p_msg_level=>fnd_log.level_procedure);
639: END IF;
640:
641:
642: UPDATE hz_cust_site_uses_all -- Bug 3456489
643: SET primary_flag = 'N',
644: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
645: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
646: WHERE site_use_id =r_site.site_use_id;

Line 987: * HZ_CUST_SITE_USES_PKG.Insert_Row

983: * Private procedure to create customer account site use.
984: *
985: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
986: * HZ_ACCOUNT_VALIDATE_V2PUB.validate_cust_site_use
987: * HZ_CUST_SITE_USES_PKG.Insert_Row
988: *
989: * ARGUMENTS
990: * IN:
991: * p_create_profile If it is set to FND_API.G_TRUE, API create customer

Line 1055: hz_cust_site_uses_all hcsu

1051: -- if record already exists for this site with 'DUNNING' or 'STATEMENTS' site_use_id
1052: CURSOR c_check_site_use_id IS
1053: SELECT hcp.cust_account_profile_id
1054: FROM hz_customer_profiles hcp,
1055: hz_cust_site_uses_all hcsu
1056: WHERE hcsu.cust_acct_site_id = p_cust_site_use_rec.cust_acct_site_id
1057: AND hcp.site_use_id = hcsu.site_use_id
1058: AND hcsu.site_use_code IN ('DUN','STMTS');
1059:

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

1167: END IF;
1168:
1169: -- Debug info.
1170: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1171: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (+)',
1172: p_prefix=>l_debug_prefix,
1173: p_msg_level=>fnd_log.level_procedure);
1174: END IF;
1175:

Line 1209: hz_cust_site_uses_all su

1205: -- New Query Below
1206: SELECT count(*) into l_cnt
1207: FROM hz_cust_accounts a,
1208: hz_cust_acct_sites_all cas,
1209: hz_cust_site_uses_all su
1210: WHERE
1211: a.cust_account_id = l_cust_acct_id
1212: and a.cust_account_id = cas.cust_account_id
1213: and cas.cust_acct_site_id = su.cust_acct_site_id

Line 1222: hz_cust_site_uses_all su

1218: and su.org_id = p_cust_site_use_rec.org_id; -- TCA SSA Uptake (Bug 3456489) */
1219:
1220: SELECT count(*) into l_cnt
1221: FROM hz_cust_acct_sites_all cas,
1222: hz_cust_site_uses_all su
1223: WHERE
1224: cas.cust_account_id = l_cust_acct_id
1225: and cas.status = 'A'
1226: and cas.cust_acct_site_id = su.cust_acct_site_id

Line 1246: HZ_CUST_SITE_USES_PKG.Insert_Row (

1242: END IF;
1243: END IF;
1244:
1245: -- Call table-handler.
1246: HZ_CUST_SITE_USES_PKG.Insert_Row (
1247: X_SITE_USE_ID => p_cust_site_use_rec.site_use_id,
1248: X_CUST_ACCT_SITE_ID => p_cust_site_use_rec.cust_acct_site_id,
1249: X_SITE_USE_CODE => p_cust_site_use_rec.site_use_code,
1250: X_PRIMARY_FLAG => p_cust_site_use_rec.primary_flag,

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

1350: );
1351:
1352: -- Debug info.
1353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1354: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (-) ' ||
1355: 'x_site_use_id = ' || p_cust_site_use_rec.site_use_id,
1356: p_prefix=>l_debug_prefix,
1357: p_msg_level=>fnd_log.level_procedure);
1358: END IF;

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

1407: 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
1408:
1409: l_orig_sys_reference_rec.orig_system := p_cust_site_use_rec.orig_system;
1410: l_orig_sys_reference_rec.orig_system_reference := p_cust_site_use_rec.orig_system_reference;
1411: l_orig_sys_reference_rec.owner_table_name := 'HZ_CUST_SITE_USES_ALL';
1412: l_orig_sys_reference_rec.owner_table_id := p_cust_site_use_rec.site_use_id;
1413: l_orig_sys_reference_rec.created_by_module := p_cust_site_use_rec.created_by_module;
1414: hz_orig_system_ref_pub.create_orig_system_reference(
1415: FND_API.G_FALSE,

Line 1500: * HZ_CUST_SITE_USES_PKG.Update_Row

1496: * Private procedure to update customer account site use.
1497: *
1498: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1499: * HZ_ACCOUNT_VALIDATE_V2PUB.validate_cust_site_use
1500: * HZ_CUST_SITE_USES_PKG.Update_Row
1501: *
1502: * ARGUMENTS
1503: * IN/OUT:
1504: * p_cust_site_use_rec Customer account site use record.

Line 1538: l_site_use_code HZ_CUST_SITE_USES.site_use_code%TYPE;

1534: l_object_version_number NUMBER;
1535: l_flag VARCHAR2(1);
1536: l_denormalize BOOLEAN := FALSE;
1537:
1538: l_site_use_code HZ_CUST_SITE_USES.site_use_code%TYPE;
1539: l_cust_acct_site_id NUMBER;
1540: l_primary_flag HZ_CUST_SITE_USES.primary_flag%TYPE;
1541: l_status HZ_CUST_SITE_USES.status%TYPE;
1542: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

Line 1540: l_primary_flag HZ_CUST_SITE_USES.primary_flag%TYPE;

1536: l_denormalize BOOLEAN := FALSE;
1537:
1538: l_site_use_code HZ_CUST_SITE_USES.site_use_code%TYPE;
1539: l_cust_acct_site_id NUMBER;
1540: l_primary_flag HZ_CUST_SITE_USES.primary_flag%TYPE;
1541: l_status HZ_CUST_SITE_USES.status%TYPE;
1542: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
1543:
1544: /* Bug Fix:5036975 */

Line 1541: l_status HZ_CUST_SITE_USES.status%TYPE;

1537:
1538: l_site_use_code HZ_CUST_SITE_USES.site_use_code%TYPE;
1539: l_cust_acct_site_id NUMBER;
1540: l_primary_flag HZ_CUST_SITE_USES.primary_flag%TYPE;
1541: l_status HZ_CUST_SITE_USES.status%TYPE;
1542: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
1543:
1544: /* Bug Fix:5036975 */
1545: l_party_site_use_id HZ_PARTY_SITE_USES.party_site_use_id%TYPE;

Line 1547: l_created_by_module HZ_CUST_SITE_USES.created_by_module%TYPE;

1543:
1544: /* Bug Fix:5036975 */
1545: l_party_site_use_id HZ_PARTY_SITE_USES.party_site_use_id%TYPE;
1546: l_party_site_use_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE;
1547: l_created_by_module HZ_CUST_SITE_USES.created_by_module%TYPE;
1548: l_application_id HZ_CUST_SITE_USES.application_id%TYPE;
1549: l_message_count NUMBER;
1550: l_party_site_id NUMBER;
1551: l_dummy VARCHAR2(1);

Line 1548: l_application_id HZ_CUST_SITE_USES.application_id%TYPE;

1544: /* Bug Fix:5036975 */
1545: l_party_site_use_id HZ_PARTY_SITE_USES.party_site_use_id%TYPE;
1546: l_party_site_use_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE;
1547: l_created_by_module HZ_CUST_SITE_USES.created_by_module%TYPE;
1548: l_application_id HZ_CUST_SITE_USES.application_id%TYPE;
1549: l_message_count NUMBER;
1550: l_party_site_id NUMBER;
1551: l_dummy VARCHAR2(1);
1552: l_msg_count NUMBER;

Line 1582: FROM HZ_CUST_SITE_USES

1578: SITE_USE_CODE, PRIMARY_FLAG, STATUS, ORG_ID,CREATED_BY_MODULE,APPLICATION_ID
1579: INTO l_rowid, l_object_version_number,
1580: l_cust_acct_site_id, l_site_use_code, l_primary_flag, l_status,
1581: p_cust_site_use_rec.org_id,l_created_by_module,l_application_id
1582: FROM HZ_CUST_SITE_USES
1583: WHERE SITE_USE_ID = p_cust_site_use_rec.site_use_id
1584: FOR UPDATE NOWAIT;
1585:
1586: IF NOT (

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

1590: l_object_version_number IS NOT NULL AND
1591: p_object_version_number = l_object_version_number ) )
1592: THEN
1593: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
1594: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_site_uses' );
1595: FND_MSG_PUB.ADD;
1596: RAISE FND_API.G_EXC_ERROR;
1597: END IF;
1598:

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

1681: END IF;
1682:
1683: -- Debug info.
1684: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1685: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (+)',
1686: p_prefix=>l_debug_prefix,
1687: p_msg_level=>fnd_log.level_procedure);
1688: END IF;
1689: --Bug Fix:5036975

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

1699: end if;
1700:
1701: -- Debug info.
1702: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1703: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Update_Row (+)',
1704: p_prefix=>l_debug_prefix,
1705: p_msg_level=>fnd_log.level_procedure);
1706: END IF;
1707:

Line 1753: hz_cust_site_uses_all su

1749: -- New Query Below
1750: SELECT count(*) into l_cnt
1751: FROM hz_cust_accounts a,
1752: hz_cust_acct_sites_all cas,
1753: hz_cust_site_uses_all su
1754: WHERE
1755: a.cust_account_id = l_cust_acct_id
1756: and a.cust_account_id = cas.cust_account_id
1757: and cas.cust_acct_site_id = su.cust_acct_site_id

Line 1767: hz_cust_site_uses_all su

1763: and su.org_id = p_cust_site_use_rec.org_id; -- TCA SSA Uptake (Bug 3456489) */
1764:
1765: SELECT count(*) into l_cnt
1766: FROM hz_cust_acct_sites_all cas,
1767: hz_cust_site_uses_all su
1768: WHERE
1769: cas.cust_account_id = l_cust_acct_id
1770: and cas.status = 'A'
1771: and cas.cust_acct_site_id = su.cust_acct_site_id

Line 1809: hz_cust_site_uses_all su -- Bug 3456489

1805: BEGIN
1806: SELECT min(su.rowid),count(*) into l_minrowid,l_cnt
1807: FROM hz_cust_accounts a,
1808: hz_cust_acct_sites_all cas, -- Bug 3456489
1809: hz_cust_site_uses_all su -- Bug 3456489
1810: WHERE
1811: a.cust_account_id = l_cust_acct_id
1812: and a.cust_account_id = cas.cust_account_id
1813: and cas.cust_acct_site_id = su.cust_acct_site_id

Line 1824: UPDATE hz_cust_site_uses_all -- Bug 3456489

1820: END;
1821:
1822: IF l_cnt > 0 THEN
1823: BEGIN
1824: UPDATE hz_cust_site_uses_all -- Bug 3456489
1825: SET primary_flag = 'Y',
1826: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
1827: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
1828: WHERE rowid = l_minrowid;

Line 1832: from hz_cust_site_uses_all -- Bug 3456489

1828: WHERE rowid = l_minrowid;
1829: -- Bug 3294182.
1830: select cust_acct_site_id
1831: into l_casid
1832: from hz_cust_site_uses_all -- Bug 3456489
1833: where rowid=l_minrowid;
1834: denormalize_site_use_flag(
1835: l_casid,
1836: nvl(p_cust_site_use_rec.site_use_code,l_site_use_code),

Line 1846: HZ_CUST_SITE_USES_PKG.Update_Row (

1842: END IF;
1843: END IF;
1844:
1845: -- Call table-handler.
1846: HZ_CUST_SITE_USES_PKG.Update_Row (
1847: X_Rowid => l_rowid,
1848: X_SITE_USE_ID => p_cust_site_use_rec.site_use_id,
1849: X_CUST_ACCT_SITE_ID => p_cust_site_use_rec.cust_acct_site_id,
1850: X_SITE_USE_CODE => p_cust_site_use_rec.site_use_code,

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

1950: );
1951:
1952: -- Debug info.
1953: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1954: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Update_Row (-)',
1955: p_prefix=>l_debug_prefix,
1956: p_msg_level=>fnd_log.level_procedure);
1957: END IF;
1958:

Line 2899: HZ_POPULATE_BOT_PKG.pop_hz_cust_site_uses_all(

2895: END IF;
2896:
2897: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2898: -- populate function for integration service
2899: HZ_POPULATE_BOT_PKG.pop_hz_cust_site_uses_all(
2900: p_operation => 'I',
2901: p_site_use_id => x_site_use_id );
2902: END IF;
2903: END IF;

Line 3083: p_owner_table_name => 'HZ_CUST_SITE_USES_ALL',

3079: 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
3080: hz_orig_system_ref_pub.get_owner_table_id
3081: (p_orig_system => p_cust_site_use_rec.orig_system,
3082: p_orig_system_reference => p_cust_site_use_rec.orig_system_reference,
3083: p_owner_table_name => 'HZ_CUST_SITE_USES_ALL',
3084: x_owner_table_id => l_cust_site_use_rec.site_use_id ,
3085: x_return_status => x_return_status);
3086: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3087: RAISE FND_API.G_EXC_ERROR;

Line 3123: HZ_POPULATE_BOT_PKG.pop_hz_cust_site_uses_all(

3119: END IF;
3120:
3121: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
3122: -- populate function for integration service
3123: HZ_POPULATE_BOT_PKG.pop_hz_cust_site_uses_all(
3124: p_operation => 'U',
3125: p_site_use_id => l_cust_site_use_rec.site_use_id );
3126: END IF;
3127: END IF;

Line 3240: * HZ_CUST_SITE_USES_PKG.Select_Row

3236: * DESCRIPTION
3237: * Gets customer account site use record
3238: *
3239: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
3240: * HZ_CUST_SITE_USES_PKG.Select_Row
3241: *
3242: * ARGUMENTS
3243: * IN:
3244: * p_init_msg_list Initialize message stack if it is set to

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

3308: x_cust_site_use_rec.site_use_id := p_site_use_id;
3309:
3310: -- Debug info.
3311: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3312: hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Select_Row (+)',
3313: p_prefix=>l_debug_prefix,
3314: p_msg_level=>fnd_log.level_procedure);
3315: END IF;
3316:

Line 3318: HZ_CUST_SITE_USES_PKG.Select_Row (

3314: p_msg_level=>fnd_log.level_procedure);
3315: END IF;
3316:
3317: -- Call table-handler.
3318: HZ_CUST_SITE_USES_PKG.Select_Row (
3319: X_SITE_USE_ID => x_cust_site_use_rec.site_use_id,
3320: X_CUST_ACCT_SITE_ID => x_cust_site_use_rec.cust_acct_site_id,
3321: X_SITE_USE_CODE => x_cust_site_use_rec.site_use_code,
3322: X_PRIMARY_FLAG => x_cust_site_use_rec.primary_flag,

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

3420: );
3421:
3422: -- Debug info.
3423: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3424: hz_utility_v2pub.debug(p_message=> 'HZ_CUST_SITE_USES_PKG.Select_Row (-)',
3425: p_prefix=>l_debug_prefix,
3426: p_msg_level=>fnd_log.level_procedure);
3427: END IF;
3428: