DBA Data[Home] [Help]

APPS.HZ_CUST_ACCT_SITE_BO_PUB dependencies on HZ_CUST_ACCT_SITES

Line 280: p_obj_type => 'HZ_CUST_ACCT_SITES_ALL',

276: px_id => x_cust_acct_site_id,
277: px_os => x_cust_acct_site_os,
278: px_osr => x_cust_acct_site_osr,
279: p_org_id => p_cust_acct_site_obj.org_id,
280: p_obj_type => 'HZ_CUST_ACCT_SITES_ALL',
281: p_create_or_update => 'C',
282: x_return_status => x_return_status,
283: x_msg_count => x_msg_count,
284: x_msg_data => x_msg_data);

Line 676: FROM HZ_CUST_ACCT_SITES s

672: l_cbm VARCHAR2(30);
673:
674: CURSOR get_ovn(l_cas_id NUMBER) IS
675: SELECT s.object_version_number, s.cust_account_id, s.party_site_id
676: FROM HZ_CUST_ACCT_SITES s
677: WHERE s.cust_acct_site_id = l_cas_id;
678:
679: BEGIN
680: -- Standard start of API savepoint

Line 719: p_obj_type => 'HZ_CUST_ACCT_SITES_ALL',

715: px_id => x_cust_acct_site_id,
716: px_os => x_cust_acct_site_os,
717: px_osr => x_cust_acct_site_osr,
718: p_org_id => p_cust_acct_site_obj.org_id,
719: p_obj_type => 'HZ_CUST_ACCT_SITES_ALL',
720: p_create_or_update => 'U',
721: x_return_status => x_return_status,
722: x_msg_count => x_msg_count,
723: x_msg_data => x_msg_data);

Line 946: FROM HZ_CUST_ACCT_SITES_ALL

942: l_debug_prefix VARCHAR2(30) := '';
943:
944: CURSOR get_cas_id(l_ps_id NUMBER, l_ca_id NUMBER, l_org_id NUMBER) IS
945: SELECT cust_acct_site_id
946: FROM HZ_CUST_ACCT_SITES_ALL
947: WHERE cust_account_id = l_ca_id
948: AND party_site_id = l_ps_id
949: AND org_id = l_org_id
950: AND rownum = 1;

Line 994: p_entity_type => 'HZ_CUST_ACCT_SITES_ALL',

990: l_create_update_flag := HZ_REGISTRY_VALIDATE_BO_PVT.check_bo_op(
991: p_entity_id => x_cust_acct_site_id,
992: p_entity_os => x_cust_acct_site_os,
993: p_entity_osr => x_cust_acct_site_osr,
994: p_entity_type => 'HZ_CUST_ACCT_SITES_ALL',
995: p_parent_id => px_parent_acct_id,
996: p_parent_obj_type => 'CUST_ACCT'
997: );
998: IF(l_create_update_flag = 'E') THEN

Line 1306: p_obj_type => 'HZ_CUST_ACCT_SITES_ALL',

1302: HZ_EXTRACT_BO_UTIL_PVT.validate_ssm_id(
1303: px_id => l_cust_acct_site_id,
1304: px_os => l_cust_acct_site_os,
1305: px_osr => l_cust_acct_site_osr,
1306: p_obj_type => 'HZ_CUST_ACCT_SITES_ALL',
1307: x_return_status => x_return_status,
1308: x_msg_count => x_msg_count,
1309: x_msg_data => x_msg_data);
1310:

Line 1717: p_obj_type => 'HZ_CUST_ACCT_SITES_ALL',

1713: px_id => x_cust_acct_site_id,
1714: px_os => x_cust_acct_site_os,
1715: px_osr => x_cust_acct_site_osr,
1716: p_org_id => p_cust_acct_site_v2_obj.org_id,
1717: p_obj_type => 'HZ_CUST_ACCT_SITES_ALL',
1718: p_create_or_update => 'C',
1719: x_return_status => x_return_status,
1720: x_msg_count => x_msg_count,
1721: x_msg_data => x_msg_data);

Line 2006: FROM HZ_CUST_ACCT_SITES s

2002: l_cbm VARCHAR2(30);
2003:
2004: CURSOR get_ovn(l_cas_id NUMBER) IS
2005: SELECT s.object_version_number, s.cust_account_id, s.party_site_id
2006: FROM HZ_CUST_ACCT_SITES s
2007: WHERE s.cust_acct_site_id = l_cas_id;
2008:
2009: BEGIN
2010: -- Standard start of API savepoint

Line 2049: p_obj_type => 'HZ_CUST_ACCT_SITES_ALL',

2045: px_id => x_cust_acct_site_id,
2046: px_os => x_cust_acct_site_os,
2047: px_osr => x_cust_acct_site_osr,
2048: p_org_id => p_cust_acct_site_v2_obj.org_id,
2049: p_obj_type => 'HZ_CUST_ACCT_SITES_ALL',
2050: p_create_or_update => 'U',
2051: x_return_status => x_return_status,
2052: x_msg_count => x_msg_count,
2053: x_msg_data => x_msg_data);

Line 2338: p_entity_type => 'HZ_CUST_ACCT_SITES_ALL',

2334: l_create_update_flag := HZ_REGISTRY_VALIDATE_BO_PVT.check_bo_op(
2335: p_entity_id => x_cust_acct_site_id,
2336: p_entity_os => x_cust_acct_site_os,
2337: p_entity_osr => x_cust_acct_site_osr,
2338: p_entity_type => 'HZ_CUST_ACCT_SITES_ALL',
2339: p_parent_id => px_parent_acct_id,
2340: p_parent_obj_type => 'CUST_ACCT'
2341: );
2342: IF(l_create_update_flag = 'E') THEN

Line 2614: p_obj_type => 'HZ_CUST_ACCT_SITES_ALL',

2610: HZ_EXTRACT_BO_UTIL_PVT.validate_ssm_id(
2611: px_id => l_cust_acct_site_id,
2612: px_os => l_cust_acct_site_os,
2613: px_osr => l_cust_acct_site_osr,
2614: p_obj_type => 'HZ_CUST_ACCT_SITES_ALL',
2615: x_return_status => x_return_status,
2616: x_msg_count => x_msg_count,
2617: x_msg_data => x_msg_data);
2618: