DBA Data[Home] [Help]

APPS.HZ_CUST_ACCT_SITE_BO_PUB dependencies on HZ_CUST_ACCT_SITE_BO

Line 1: PACKAGE BODY hz_cust_acct_site_bo_pub AS

1: PACKAGE BODY hz_cust_acct_site_bo_pub AS
2: /*$Header: ARHBCSBB.pls 120.15.12010000.2 2008/10/16 22:27:31 awu ship $ */
3:
4: -- PRIVATE PROCEDURE assign_cust_acct_site_rec
5: --

Line 31: p_cust_acct_site_obj IN HZ_CUST_ACCT_SITE_BO,

27: -- 14-DEC-2004 Arnold Ng Created.
28: --
29:
30: PROCEDURE assign_cust_acct_site_rec(
31: p_cust_acct_site_obj IN HZ_CUST_ACCT_SITE_BO,
32: p_party_site_id IN NUMBER,
33: p_cust_acct_id IN NUMBER,
34: p_cust_acct_site_id IN NUMBER,
35: p_cust_acct_site_os IN VARCHAR2,

Line 68: p_cust_acct_site_obj IN HZ_CUST_ACCT_SITE_BO,

64: -- 14-DEC-2004 Arnold Ng Created.
65: --
66:
67: PROCEDURE assign_cust_acct_site_rec(
68: p_cust_acct_site_obj IN HZ_CUST_ACCT_SITE_BO,
69: p_party_site_id IN NUMBER,
70: p_cust_acct_id IN NUMBER,
71: p_cust_acct_site_id IN NUMBER,
72: p_cust_acct_site_os IN VARCHAR2,

Line 151: p_cust_acct_site_obj IN OUT NOCOPY HZ_CUST_ACCT_SITE_BO,

147: -- Create customer account site business object.
148: PROCEDURE do_create_cust_acct_site_bo(
149: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
150: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
151: p_cust_acct_site_obj IN OUT NOCOPY HZ_CUST_ACCT_SITE_BO,
152: p_created_by_module IN VARCHAR2,
153: p_obj_source IN VARCHAR2 := null,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,

Line 230: p_cas_objs => HZ_CUST_ACCT_SITE_BO_TBL(p_cust_acct_site_obj),

226: p_bus_object_code => 'CUST_ACCT_SITE',
227: x_bus_object => l_bus_object
228: );
229: l_valid_obj := HZ_REGISTRY_VALIDATE_BO_PVT.is_cas_bo_comp(
230: p_cas_objs => HZ_CUST_ACCT_SITE_BO_TBL(p_cust_acct_site_obj),
231: p_bus_object => l_bus_object
232: );
233: IF NOT(l_valid_obj) THEN
234: RAISE fnd_api.g_exc_error;

Line 363: HZ_CUST_ACCT_SITE_BO_PVT.create_cust_site_uses(

359: -- create cust account site uses will include cust acct site use plus site use profile
360: -- need to put customer account id and customer account site id
361: IF((p_cust_acct_site_obj.cust_acct_site_use_objs IS NOT NULL) AND
362: (p_cust_acct_site_obj.cust_acct_site_use_objs.COUNT > 0)) THEN
363: HZ_CUST_ACCT_SITE_BO_PVT.create_cust_site_uses(
364: p_casu_objs => p_cust_acct_site_obj.cust_acct_site_use_objs,
365: p_ca_id => px_parent_acct_id,
366: p_cas_id => x_cust_acct_site_id,
367: p_parent_os => x_cust_acct_site_os,

Line 494: p_cust_acct_site_obj IN HZ_CUST_ACCT_SITE_BO,

490:
491: PROCEDURE create_cust_acct_site_bo(
492: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
493: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
494: p_cust_acct_site_obj IN HZ_CUST_ACCT_SITE_BO,
495: p_created_by_module IN VARCHAR2,
496: x_return_status OUT NOCOPY VARCHAR2,
497: x_msg_count OUT NOCOPY NUMBER,
498: x_msg_data OUT NOCOPY VARCHAR2,

Line 506: l_cas_obj HZ_CUST_ACCT_SITE_BO;

502: px_parent_acct_id IN OUT NOCOPY NUMBER,
503: px_parent_acct_os IN OUT NOCOPY VARCHAR2,
504: px_parent_acct_osr IN OUT NOCOPY VARCHAR2
505: ) IS
506: l_cas_obj HZ_CUST_ACCT_SITE_BO;
507: BEGIN
508: l_cas_obj := p_cust_acct_site_obj;
509: do_create_cust_acct_site_bo(
510: p_init_msg_list => p_init_msg_list,

Line 529: p_cust_acct_site_obj IN HZ_CUST_ACCT_SITE_BO,

525: END create_cust_acct_site_bo;
526:
527: PROCEDURE create_cust_acct_site_bo(
528: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
529: p_cust_acct_site_obj IN HZ_CUST_ACCT_SITE_BO,
530: p_created_by_module IN VARCHAR2,
531: p_obj_source IN VARCHAR2 := null,
532: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
533: x_return_status OUT NOCOPY VARCHAR2,

Line 535: x_return_obj OUT NOCOPY HZ_CUST_ACCT_SITE_BO,

531: p_obj_source IN VARCHAR2 := null,
532: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
533: x_return_status OUT NOCOPY VARCHAR2,
534: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
535: x_return_obj OUT NOCOPY HZ_CUST_ACCT_SITE_BO,
536: x_cust_acct_site_id OUT NOCOPY NUMBER,
537: x_cust_acct_site_os OUT NOCOPY VARCHAR2,
538: x_cust_acct_site_osr OUT NOCOPY VARCHAR2,
539: px_parent_acct_id IN OUT NOCOPY NUMBER,

Line 545: l_cas_obj HZ_CUST_ACCT_SITE_BO;

541: px_parent_acct_osr IN OUT NOCOPY VARCHAR2
542: ) IS
543: l_msg_data VARCHAR2(2000);
544: l_msg_count NUMBER;
545: l_cas_obj HZ_CUST_ACCT_SITE_BO;
546: BEGIN
547: l_cas_obj := p_cust_acct_site_obj;
548: do_create_cust_acct_site_bo(
549: p_init_msg_list => fnd_api.g_true,

Line 579: p_cust_acct_site_obj IN HZ_CUST_ACCT_SITE_BO,

575: -- DESCRIPTION
576: -- Update customer account site business object.
577: PROCEDURE update_cust_acct_site_bo(
578: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
579: p_cust_acct_site_obj IN HZ_CUST_ACCT_SITE_BO,
580: p_created_by_module IN VARCHAR2,
581: x_return_status OUT NOCOPY VARCHAR2,
582: x_msg_count OUT NOCOPY NUMBER,
583: x_msg_data OUT NOCOPY VARCHAR2,

Line 588: l_cas_obj HZ_CUST_ACCT_SITE_BO;

584: x_cust_acct_site_id OUT NOCOPY NUMBER,
585: x_cust_acct_site_os OUT NOCOPY VARCHAR2,
586: x_cust_acct_site_osr OUT NOCOPY VARCHAR2
587: )IS
588: l_cas_obj HZ_CUST_ACCT_SITE_BO;
589: BEGIN
590: l_cas_obj := p_cust_acct_site_obj;
591: do_update_cust_acct_site_bo(
592: p_init_msg_list => p_init_msg_list,

Line 607: p_cust_acct_site_obj IN HZ_CUST_ACCT_SITE_BO,

603: );
604: END update_cust_acct_site_bo;
605:
606: PROCEDURE update_cust_acct_site_bo(
607: p_cust_acct_site_obj IN HZ_CUST_ACCT_SITE_BO,
608: p_created_by_module IN VARCHAR2,
609: p_obj_source IN VARCHAR2 := null,
610: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
611: x_return_status OUT NOCOPY VARCHAR2,

Line 613: x_return_obj OUT NOCOPY HZ_CUST_ACCT_SITE_BO,

609: p_obj_source IN VARCHAR2 := null,
610: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
611: x_return_status OUT NOCOPY VARCHAR2,
612: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
613: x_return_obj OUT NOCOPY HZ_CUST_ACCT_SITE_BO,
614: x_cust_acct_site_id OUT NOCOPY NUMBER,
615: x_cust_acct_site_os OUT NOCOPY VARCHAR2,
616: x_cust_acct_site_osr OUT NOCOPY VARCHAR2
617: )IS

Line 620: l_cas_obj HZ_CUST_ACCT_SITE_BO;

616: x_cust_acct_site_osr OUT NOCOPY VARCHAR2
617: )IS
618: l_msg_data VARCHAR2(2000);
619: l_msg_count NUMBER;
620: l_cas_obj HZ_CUST_ACCT_SITE_BO;
621: BEGIN
622: l_cas_obj := p_cust_acct_site_obj;
623: do_update_cust_acct_site_bo(
624: p_init_msg_list => fnd_api.g_true,

Line 652: p_cust_acct_site_obj IN OUT NOCOPY HZ_CUST_ACCT_SITE_BO,

648: -- Update customer account site business object.
649: PROCEDURE do_update_cust_acct_site_bo(
650: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
651: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
652: p_cust_acct_site_obj IN OUT NOCOPY HZ_CUST_ACCT_SITE_BO,
653: p_created_by_module IN VARCHAR2,
654: p_obj_source IN VARCHAR2 := null,
655: x_return_status OUT NOCOPY VARCHAR2,
656: x_msg_count OUT NOCOPY NUMBER,

Line 791: HZ_CUST_ACCT_SITE_BO_PVT.save_cust_site_uses(

787: -- For cust account site use
788: ----------------------------
789: IF((p_cust_acct_site_obj.cust_acct_site_use_objs IS NOT NULL) AND
790: (p_cust_acct_site_obj.cust_acct_site_use_objs.COUNT > 0)) THEN
791: HZ_CUST_ACCT_SITE_BO_PVT.save_cust_site_uses(
792: p_casu_objs => p_cust_acct_site_obj.cust_acct_site_use_objs,
793: p_ca_id => l_ca_id,
794: p_cas_id => x_cust_acct_site_id,
795: p_parent_os => x_cust_acct_site_os,

Line 925: p_cust_acct_site_obj IN OUT NOCOPY HZ_CUST_ACCT_SITE_BO,

921: -- Create or update customer account site business object.
922: PROCEDURE do_save_cust_acct_site_bo(
923: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
924: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
925: p_cust_acct_site_obj IN OUT NOCOPY HZ_CUST_ACCT_SITE_BO,
926: p_created_by_module IN VARCHAR2,
927: p_obj_source IN VARCHAR2 := null,
928: x_return_status OUT NOCOPY VARCHAR2,
929: x_msg_count OUT NOCOPY NUMBER,

Line 1120: p_cust_acct_site_obj IN HZ_CUST_ACCT_SITE_BO,

1116:
1117: PROCEDURE save_cust_acct_site_bo(
1118: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1119: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1120: p_cust_acct_site_obj IN HZ_CUST_ACCT_SITE_BO,
1121: p_created_by_module IN VARCHAR2,
1122: x_return_status OUT NOCOPY VARCHAR2,
1123: x_msg_count OUT NOCOPY NUMBER,
1124: x_msg_data OUT NOCOPY VARCHAR2,

Line 1132: l_cas_obj HZ_CUST_ACCT_SITE_BO;

1128: px_parent_acct_id IN OUT NOCOPY NUMBER,
1129: px_parent_acct_os IN OUT NOCOPY VARCHAR2,
1130: px_parent_acct_osr IN OUT NOCOPY VARCHAR2
1131: ) IS
1132: l_cas_obj HZ_CUST_ACCT_SITE_BO;
1133: BEGIN
1134: l_cas_obj := p_cust_acct_site_obj;
1135: do_save_cust_acct_site_bo(
1136: p_init_msg_list => p_init_msg_list,

Line 1155: p_cust_acct_site_obj IN HZ_CUST_ACCT_SITE_BO,

1151: END save_cust_acct_site_bo;
1152:
1153: PROCEDURE save_cust_acct_site_bo(
1154: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1155: p_cust_acct_site_obj IN HZ_CUST_ACCT_SITE_BO,
1156: p_created_by_module IN VARCHAR2,
1157: p_obj_source IN VARCHAR2 := null,
1158: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1159: x_return_status OUT NOCOPY VARCHAR2,

Line 1161: x_return_obj OUT NOCOPY HZ_CUST_ACCT_SITE_BO,

1157: p_obj_source IN VARCHAR2 := null,
1158: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1159: x_return_status OUT NOCOPY VARCHAR2,
1160: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
1161: x_return_obj OUT NOCOPY HZ_CUST_ACCT_SITE_BO,
1162: x_cust_acct_site_id OUT NOCOPY NUMBER,
1163: x_cust_acct_site_os OUT NOCOPY VARCHAR2,
1164: x_cust_acct_site_osr OUT NOCOPY VARCHAR2,
1165: px_parent_acct_id IN OUT NOCOPY NUMBER,

Line 1171: l_cas_obj HZ_CUST_ACCT_SITE_BO;

1167: px_parent_acct_osr IN OUT NOCOPY VARCHAR2
1168: ) IS
1169: l_msg_data VARCHAR2(2000);
1170: l_msg_count NUMBER;
1171: l_cas_obj HZ_CUST_ACCT_SITE_BO;
1172: BEGIN
1173: l_cas_obj := p_cust_acct_site_obj;
1174: do_save_cust_acct_site_bo(
1175: p_init_msg_list => fnd_api.g_true,

Line 1266: x_cust_acct_site_obj OUT NOCOPY HZ_CUST_ACCT_SITE_BO,

1262: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1263: p_cust_acct_site_id IN NUMBER,
1264: p_cust_acct_site_os IN VARCHAR2,
1265: p_cust_acct_site_osr IN VARCHAR2,
1266: x_cust_acct_site_obj OUT NOCOPY HZ_CUST_ACCT_SITE_BO,
1267: x_return_status OUT NOCOPY VARCHAR2,
1268: x_msg_count OUT NOCOPY NUMBER,
1269: x_msg_data OUT NOCOPY VARCHAR2
1270: ) is

Line 1276: l_cust_acct_site_objs HZ_CUST_ACCT_SITE_BO_TBL;

1272:
1273: l_cust_acct_site_id number;
1274: l_cust_acct_site_os varchar2(30);
1275: l_cust_acct_site_osr varchar2(255);
1276: l_cust_acct_site_objs HZ_CUST_ACCT_SITE_BO_TBL;
1277: BEGIN
1278:
1279: -- initialize API return status to success.
1280: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1290: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo(+)',

1286:
1287:
1288: -- Debug info.
1289: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1290: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo(+)',
1291: p_prefix=>l_debug_prefix,
1292: p_msg_level=>fnd_log.level_procedure);
1293: END IF;
1294:

Line 1342: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo (-)',

1338: END IF;
1339:
1340: -- Debug info.
1341: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1342: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo (-)',
1343: p_prefix=>l_debug_prefix,
1344: p_msg_level=>fnd_log.level_procedure);
1345: END IF;
1346:

Line 1365: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo (-)',

1361: p_msg_type=>'ERROR',
1362: p_msg_level=>fnd_log.level_error);
1363: END IF;
1364: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1365: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo (-)',
1366: p_prefix=>l_debug_prefix,
1367: p_msg_level=>fnd_log.level_procedure);
1368: END IF;
1369: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1384: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo (-)',

1380: p_msg_type=>'UNEXPECTED ERROR',
1381: p_msg_level=>fnd_log.level_error);
1382: END IF;
1383: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1384: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo (-)',
1385: p_prefix=>l_debug_prefix,
1386: p_msg_level=>fnd_log.level_procedure);
1387: END IF;
1388: WHEN OTHERS THEN

Line 1407: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo (-)',

1403: p_msg_type=>'SQL ERROR',
1404: p_msg_level=>fnd_log.level_error);
1405: END IF;
1406: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1407: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo (-)',
1408: p_prefix=>l_debug_prefix,
1409: p_msg_level=>fnd_log.level_procedure);
1410: END IF;
1411:

Line 1418: x_cust_acct_site_obj OUT NOCOPY HZ_CUST_ACCT_SITE_BO,

1414: PROCEDURE get_cust_acct_site_bo (
1415: p_cust_acct_site_id IN NUMBER,
1416: p_cust_acct_site_os IN VARCHAR2,
1417: p_cust_acct_site_osr IN VARCHAR2,
1418: x_cust_acct_site_obj OUT NOCOPY HZ_CUST_ACCT_SITE_BO,
1419: x_return_status OUT NOCOPY VARCHAR2,
1420: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
1421: ) IS
1422: l_msg_data VARCHAR2(2000);

Line 1800: HZ_CUST_ACCT_SITE_BO_PVT.create_cust_site_v2_uses(

1796: -- create cust account site uses will include cust acct site use plus site use profile
1797: -- need to put customer account id and customer account site id
1798: IF((p_cust_acct_site_v2_obj.cust_acct_site_use_objs IS NOT NULL) AND
1799: (p_cust_acct_site_v2_obj.cust_acct_site_use_objs.COUNT > 0)) THEN
1800: HZ_CUST_ACCT_SITE_BO_PVT.create_cust_site_v2_uses(
1801: p_casu_v2_objs => p_cust_acct_site_v2_obj.cust_acct_site_use_objs,
1802: p_ca_id => px_parent_acct_id,
1803: p_cas_id => x_cust_acct_site_id,
1804: p_parent_os => x_cust_acct_site_os,

Line 2121: HZ_CUST_ACCT_SITE_BO_PVT.save_cust_site_v2_uses(

2117: -- For cust account site use
2118: ----------------------------
2119: IF((p_cust_acct_site_v2_obj.cust_acct_site_use_objs IS NOT NULL) AND
2120: (p_cust_acct_site_v2_obj.cust_acct_site_use_objs.COUNT > 0)) THEN
2121: HZ_CUST_ACCT_SITE_BO_PVT.save_cust_site_v2_uses(
2122: p_casu_v2_objs => p_cust_acct_site_v2_obj.cust_acct_site_use_objs,
2123: p_ca_id => l_ca_id,
2124: p_cas_id => x_cust_acct_site_id,
2125: p_parent_os => x_cust_acct_site_os,

Line 2598: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo(+)',

2594:
2595:
2596: -- Debug info.
2597: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2598: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo(+)',
2599: p_prefix=>l_debug_prefix,
2600: p_msg_level=>fnd_log.level_procedure);
2601: END IF;
2602:

Line 2650: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_v2_bo (-)',

2646: END IF;
2647:
2648: -- Debug info.
2649: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2650: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_v2_bo (-)',
2651: p_prefix=>l_debug_prefix,
2652: p_msg_level=>fnd_log.level_procedure);
2653: END IF;
2654:

Line 2673: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_v2_bo (-)',

2669: p_msg_type=>'ERROR',
2670: p_msg_level=>fnd_log.level_error);
2671: END IF;
2672: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2673: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_v2_bo (-)',
2674: p_prefix=>l_debug_prefix,
2675: p_msg_level=>fnd_log.level_procedure);
2676: END IF;
2677: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2692: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_v2_bo (-)',

2688: p_msg_type=>'UNEXPECTED ERROR',
2689: p_msg_level=>fnd_log.level_error);
2690: END IF;
2691: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2692: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_v2_bo (-)',
2693: p_prefix=>l_debug_prefix,
2694: p_msg_level=>fnd_log.level_procedure);
2695: END IF;
2696: WHEN OTHERS THEN

Line 2715: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_v2_bo (-)',

2711: p_msg_type=>'SQL ERROR',
2712: p_msg_level=>fnd_log.level_error);
2713: END IF;
2714: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2715: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_v2_bo (-)',
2716: p_prefix=>l_debug_prefix,
2717: p_msg_level=>fnd_log.level_procedure);
2718: END IF;
2719:

Line 2749: END hz_cust_acct_site_bo_pub;

2745: x_msg_count => l_msg_count,
2746: x_msg_data => l_msg_data);
2747: END get_cust_acct_site_v2_bo;
2748:
2749: END hz_cust_acct_site_bo_pub;