DBA Data[Home] [Help]

APPS.HZ_CUST_ACCOUNT_SITE_V2PUB dependencies on HZ_CUST_ACCT_SITES_ALL

Line 199: select 'Y' from hz_cust_acct_sites_all

195: l_cust_acct_site_orig_sys VARCHAR2(255);
196:
197: /* 3456489 Added org_id for Shared Service Uptake */
198: CURSOR check_orig_sys_ref IS
199: select 'Y' from hz_cust_acct_sites_all
200: where orig_system_reference =
201: p_cust_acct_site_rec.orig_system_reference
202: and org_id = p_cust_acct_site_rec.org_id;
203:

Line 217: FROM hz_cust_acct_sites_all

213: p_cust_account_id NUMBER,
214: p_org_id NUMBER
215: ) IS
216: SELECT null
217: FROM hz_cust_acct_sites_all
218: WHERE cust_account_id = p_cust_account_id
219: AND org_id = p_org_id
220: AND status NOT IN ('M', 'D')
221: AND ROWNUM = 1;

Line 483: l_orig_sys_reference_rec.owner_table_name := 'HZ_CUST_ACCT_SITES_ALL';

479: if (p_cust_acct_site_rec.orig_system is not null and p_cust_acct_site_rec.orig_system <>fnd_api.g_miss_char)
480: then
481: l_orig_sys_reference_rec.orig_system := p_cust_acct_site_rec.orig_system;
482: l_orig_sys_reference_rec.orig_system_reference := l_orig_system_reference;
483: l_orig_sys_reference_rec.owner_table_name := 'HZ_CUST_ACCT_SITES_ALL';
484: l_orig_sys_reference_rec.owner_table_id := p_cust_acct_site_rec.cust_acct_site_id;
485: l_orig_sys_reference_rec.created_by_module := p_cust_acct_site_rec.created_by_module;
486:
487: hz_orig_system_ref_pub.create_orig_system_reference(

Line 505: HZ_CUST_ACCT_SITES_ALL ACCT_SITE -- Bug 3456489

501:
502: SELECT LOC.LOCATION_ID INTO l_location_id
503: FROM HZ_LOCATIONS LOC,
504: HZ_PARTY_SITES PARTY_SITE,
505: HZ_CUST_ACCT_SITES_ALL ACCT_SITE -- Bug 3456489
506: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = p_cust_acct_site_rec.cust_acct_site_id
507: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
508: AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID;
509:

Line 550: FROM hz_cust_acct_sites_all -- Bug 3456489

546: BEGIN
547:
548: BEGIN
549: SELECT cust_account_id into l_cust_acct_id
550: FROM hz_cust_acct_sites_all -- Bug 3456489
551: WHERE cust_acct_site_id = p_cust_acct_site_id;
552: END;
553:
554:

Line 560: hz_cust_acct_sites_all cas, -- Bug 3456489

556: -- Modified for fix 3294182.
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

Line 641: select 'Y' from hz_cust_acct_sites_all

637:
638: /* 3456489 Added org_id for Shared Service Uptake */
639:
640: CURSOR check_orig_sys_ref IS
641: select 'Y' from hz_cust_acct_sites_all
642: where orig_system_reference =
643: p_cust_acct_site_rec.orig_system_reference
644: and org_id = p_cust_acct_site_rec.org_id;
645:

Line 858: HZ_CUST_ACCT_SITES_ALL ACCT_SITE -- Bug 3456489

854: -- Bug Fix : 2230802.
855: SELECT LOC.LOCATION_ID INTO l_location_id
856: FROM HZ_LOCATIONS LOC,
857: HZ_PARTY_SITES PARTY_SITE,
858: HZ_CUST_ACCT_SITES_ALL ACCT_SITE -- Bug 3456489
859: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = p_cust_acct_site_rec.cust_acct_site_id
860: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
861: AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID;
862:

Line 984: FROM HZ_CUST_ACCT_SITES_ALL

980: p_cust_site_use_rec.org_id = fnd_api.g_miss_num) then
981: BEGIN
982: SELECT org_id
983: INTO p_cust_site_use_rec.org_id
984: FROM HZ_CUST_ACCT_SITES_ALL
985: WHERE cust_acct_site_id
986: = p_cust_site_use_rec.cust_acct_site_id;
987: EXCEPTION
988: WHEN NO_DATA_FOUND THEN

Line 1044: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489

1040: x_return_status := FND_API.G_RET_STS_SUCCESS;
1041: ELSE
1042: -- Create party site use
1043: SELECT PARTY_SITE_ID INTO l_party_site_id
1044: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
1045: WHERE CUST_ACCT_SITE_ID = p_cust_site_use_rec.cust_acct_site_id;
1046:
1047: BEGIN
1048: SELECT 'Y' INTO l_dummy

Line 1102: FROM hz_cust_acct_sites_all -- Bug 3456489

1098: ELSE
1099:
1100: BEGIN
1101: SELECT cust_account_id into l_cust_acct_id
1102: FROM hz_cust_acct_sites_all -- Bug 3456489
1103: WHERE cust_acct_site_id = p_cust_site_use_rec.cust_acct_site_id;
1104: EXCEPTION
1105: WHEN NO_DATA_FOUND THEN
1106: l_cnt := 0;

Line 1116: hz_cust_acct_sites_all cas,

1112: -- Bug 6315081 : FORWARD PORT BUG 6132727
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

Line 1129: FROM hz_cust_acct_sites_all cas,

1125: and cas.org_id = p_cust_site_use_rec.org_id -- TCA SSA Uptake (Bug 3456489)
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'

Line 1328: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489

1324: p_customer_profile_rec.created_by_module := p_cust_site_use_rec.created_by_module;
1325: p_customer_profile_rec.application_id := p_cust_site_use_rec.application_id;
1326:
1327: SELECT CUST_ACCOUNT_ID INTO p_customer_profile_rec.cust_account_id
1328: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
1329: WHERE CUST_ACCT_SITE_ID = p_cust_site_use_rec.cust_acct_site_id;
1330:
1331: HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile (
1332: p_customer_profile_rec => p_customer_profile_rec,

Line 1517: FROM HZ_CUST_ACCT_SITES_ALL

1513: ELSE
1514: -- Create party site use
1515:
1516: SELECT PARTY_SITE_ID INTO l_party_site_id
1517: FROM HZ_CUST_ACCT_SITES_ALL
1518: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
1519: BEGIN
1520: SELECT 'Y' INTO l_dummy
1521: FROM HZ_PARTY_SITE_USES

Line 1607: FROM hz_cust_acct_sites_all -- Bug 3456489

1603:
1604:
1605: BEGIN
1606: SELECT cust_account_id into l_cust_acct_id
1607: FROM hz_cust_acct_sites_all -- Bug 3456489
1608: WHERE cust_acct_site_id = l_cust_acct_site_id;
1609: EXCEPTION
1610: WHEN NO_DATA_FOUND THEN
1611: l_cnt := 0;

Line 1621: hz_cust_acct_sites_all cas,

1617: -- Bug 6315081 : FORWARD PORT BUG 6132727
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

Line 1635: FROM hz_cust_acct_sites_all cas,

1631: and cas.org_id = p_cust_site_use_rec.org_id -- TCA SSA Uptake (Bug 3456489)
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'

Line 1666: FROM hz_cust_acct_sites_all -- Bug 3456489

1662: p_cust_site_use_rec.primary_flag := 'N';
1663:
1664: BEGIN
1665: SELECT cust_account_id into l_cust_acct_id
1666: FROM hz_cust_acct_sites_all -- Bug 3456489
1667: WHERE cust_acct_site_id = l_cust_acct_site_id;
1668: EXCEPTION
1669: WHEN NO_DATA_FOUND THEN
1670: l_cnt := 0;

Line 1677: hz_cust_acct_sites_all cas, -- Bug 3456489

1673: IF l_cnt > 0 THEN
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

Line 1940: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489

1936: END IF;
1937:
1938:
1939: IF p_site_use_code = 'BILL_TO' THEN
1940: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
1941: SET BILL_TO_FLAG = p_flag
1942: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
1943: ELSIF p_site_use_code = 'SHIP_TO' THEN
1944: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489

Line 1944: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489

1940: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
1941: SET BILL_TO_FLAG = p_flag
1942: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
1943: ELSIF p_site_use_code = 'SHIP_TO' THEN
1944: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
1945: SET SHIP_TO_FLAG = p_flag
1946: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
1947: ELSIF p_site_use_code = 'MARKET' THEN
1948: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489

Line 1948: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489

1944: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
1945: SET SHIP_TO_FLAG = p_flag
1946: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
1947: ELSIF p_site_use_code = 'MARKET' THEN
1948: UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
1949: SET MARKET_FLAG = p_flag
1950: WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
1951: END IF;
1952:

Line 2061: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_sites_all(

2057: END IF;
2058:
2059: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2060: -- populate function for integration service
2061: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_sites_all(
2062: p_operation => 'I',
2063: p_cust_acct_site_id => x_cust_acct_site_id );
2064: END IF;
2065: END IF;

Line 2246: p_owner_table_name => 'HZ_CUST_ACCT_SITES_ALL',

2242:
2243: hz_orig_system_ref_pub.get_owner_table_id
2244: (p_orig_system => p_cust_acct_site_rec.orig_system,
2245: p_orig_system_reference => p_cust_acct_site_rec.orig_system_reference,
2246: p_owner_table_name => 'HZ_CUST_ACCT_SITES_ALL',
2247: x_owner_table_id => l_cust_acct_site_rec.cust_acct_site_id,
2248: x_return_status => x_return_status);
2249: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2250: RAISE FND_API.G_EXC_ERROR;

Line 2300: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_sites_all(

2296: END IF;
2297:
2298: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2299: -- populate function for integration service
2300: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_sites_all(
2301: p_operation => 'U',
2302: p_cust_acct_site_id => l_cust_acct_site_rec.cust_acct_site_id );
2303: END IF;
2304: END IF;