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_UTILITY_PUB

Line 602: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,

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;
605:
606: denormalize_site_use_flag(l_cust_acct_site_id,p_site_use_code,'Y');

Line 603: last_update_date = hz_utility_pub.LAST_UPDATE_DATE

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;
605:
606: denormalize_site_use_flag(l_cust_acct_site_id,p_site_use_code,'Y');
607:

Line 644: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,

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;
647:
648: denormalize_site_use_flag(r_site.cust_acct_site_id,p_site_use_code,'Y');

Line 645: last_update_date = hz_utility_pub.LAST_UPDATE_DATE

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;
647:
648: denormalize_site_use_flag(r_site.cust_acct_site_id,p_site_use_code,'Y');
649: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1826: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,

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;
1829: -- Bug 3294182.
1830: select cust_acct_site_id

Line 1827: last_update_date = hz_utility_pub.LAST_UPDATE_DATE

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;
1829: -- Bug 3294182.
1830: select cust_acct_site_id
1831: into l_casid

Line 2075: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,

2071:
2072: IF p_site_use_code = 'BILL_TO' THEN
2073: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
2074: SET BILL_TO_FLAG = p_flag,
2075: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
2076: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
2077: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
2078: ELSIF p_site_use_code = 'SHIP_TO' THEN
2079: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489

Line 2076: last_update_date = hz_utility_pub.LAST_UPDATE_DATE

2072: IF p_site_use_code = 'BILL_TO' THEN
2073: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
2074: SET BILL_TO_FLAG = p_flag,
2075: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
2076: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
2077: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
2078: ELSIF p_site_use_code = 'SHIP_TO' THEN
2079: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
2080: SET SHIP_TO_FLAG = p_flag,

Line 2081: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,

2077: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
2078: ELSIF p_site_use_code = 'SHIP_TO' THEN
2079: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
2080: SET SHIP_TO_FLAG = p_flag,
2081: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
2082: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
2083: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
2084: ELSIF p_site_use_code = 'MARKET' THEN
2085: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489

Line 2082: last_update_date = hz_utility_pub.LAST_UPDATE_DATE

2078: ELSIF p_site_use_code = 'SHIP_TO' THEN
2079: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
2080: SET SHIP_TO_FLAG = p_flag,
2081: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
2082: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
2083: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
2084: ELSIF p_site_use_code = 'MARKET' THEN
2085: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
2086: SET MARKET_FLAG = p_flag,

Line 2087: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,

2083: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
2084: ELSIF p_site_use_code = 'MARKET' THEN
2085: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
2086: SET MARKET_FLAG = p_flag,
2087: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
2088: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
2089: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
2090: END IF;
2091:

Line 2088: last_update_date = hz_utility_pub.LAST_UPDATE_DATE

2084: ELSIF p_site_use_code = 'MARKET' THEN
2085: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
2086: SET MARKET_FLAG = p_flag,
2087: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
2088: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
2089: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
2090: END IF;
2091:
2092: -- Debug info.