DBA Data[Home] [Help]

APPS.HZ_PARTY_SITE_BO_PUB dependencies on HZ_PARTY_SITE_BO

Line 1: PACKAGE BODY hz_party_site_bo_pub AS

1: PACKAGE BODY hz_party_site_bo_pub AS
2: /*$Header: ARHBPSBB.pls 120.19 2006/05/18 22:27:56 acng noship $ */
3:
4: -- PRIVATE PROCEDURE assign_party_site_rec
5: --

Line 31: p_party_site_obj IN HZ_PARTY_SITE_BO,

27: -- 14-DEC-2004 Arnold Ng Created.
28: --
29:
30: PROCEDURE assign_party_site_rec(
31: p_party_site_obj IN HZ_PARTY_SITE_BO,
32: p_party_id IN NUMBER,
33: p_location_id IN NUMBER,
34: p_ps_id IN NUMBER,
35: p_ps_os IN VARCHAR2,

Line 68: p_party_site_obj IN HZ_PARTY_SITE_BO,

64: -- 14-DEC-2004 Arnold Ng Created.
65: --
66:
67: PROCEDURE assign_party_site_rec(
68: p_party_site_obj IN HZ_PARTY_SITE_BO,
69: p_party_id IN NUMBER,
70: p_location_id IN NUMBER,
71: p_ps_id IN NUMBER,
72: p_ps_os IN VARCHAR2,

Line 128: p_party_site_obj IN OUT NOCOPY HZ_PARTY_SITE_BO,

124: -- Create a party site business object.
125: PROCEDURE do_create_party_site_bo(
126: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
127: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
128: p_party_site_obj IN OUT NOCOPY HZ_PARTY_SITE_BO,
129: p_created_by_module IN VARCHAR2,
130: p_obj_source IN VARCHAR2 := null,
131: x_return_status OUT NOCOPY VARCHAR2,
132: x_msg_count OUT NOCOPY NUMBER,

Line 191: p_ps_objs => HZ_PARTY_SITE_BO_TBL(p_party_site_obj),

187: x_bus_object => l_bus_object
188: );
189:
190: l_valid_obj := HZ_REGISTRY_VALIDATE_BO_PVT.is_ps_bo_comp(
191: p_ps_objs => HZ_PARTY_SITE_BO_TBL(p_party_site_obj),
192: p_bus_object => l_bus_object
193: );
194: IF NOT(l_valid_obj) THEN
195: RAISE fnd_api.g_exc_error;

Line 341: HZ_PARTY_SITE_BO_PVT.create_party_site_uses(

337: -- For party site use
338: ------------------------
339: IF((p_party_site_obj.party_site_use_objs IS NOT NULL) AND
340: (p_party_site_obj.party_site_use_objs.COUNT > 0)) THEN
341: HZ_PARTY_SITE_BO_PVT.create_party_site_uses(
342: p_psu_objs => p_party_site_obj.party_site_use_objs,
343: p_ps_id => x_party_site_id,
344: x_return_status => x_return_status,
345: x_msg_count => x_msg_count,

Line 524: p_party_site_obj IN HZ_PARTY_SITE_BO,

520:
521: PROCEDURE create_party_site_bo(
522: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
523: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
524: p_party_site_obj IN HZ_PARTY_SITE_BO,
525: p_created_by_module IN VARCHAR2,
526: x_return_status OUT NOCOPY VARCHAR2,
527: x_msg_count OUT NOCOPY NUMBER,
528: x_msg_data OUT NOCOPY VARCHAR2,

Line 537: l_ps_obj HZ_PARTY_SITE_BO;

533: px_parent_os IN OUT NOCOPY VARCHAR2,
534: px_parent_osr IN OUT NOCOPY VARCHAR2,
535: px_parent_obj_type IN OUT NOCOPY VARCHAR2
536: ) IS
537: l_ps_obj HZ_PARTY_SITE_BO;
538: BEGIN
539: l_ps_obj := p_party_site_obj;
540: do_create_party_site_bo(
541: p_init_msg_list => p_init_msg_list,

Line 561: p_party_site_obj IN HZ_PARTY_SITE_BO,

557: END create_party_site_bo;
558:
559: PROCEDURE create_party_site_bo(
560: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
561: p_party_site_obj IN HZ_PARTY_SITE_BO,
562: p_created_by_module IN VARCHAR2,
563: p_obj_source IN VARCHAR2 := null,
564: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
565: x_return_status OUT NOCOPY VARCHAR2,

Line 567: x_return_obj OUT NOCOPY HZ_PARTY_SITE_BO,

563: p_obj_source IN VARCHAR2 := null,
564: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
565: x_return_status OUT NOCOPY VARCHAR2,
566: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
567: x_return_obj OUT NOCOPY HZ_PARTY_SITE_BO,
568: x_party_site_id OUT NOCOPY NUMBER,
569: x_party_site_os OUT NOCOPY VARCHAR2,
570: x_party_site_osr OUT NOCOPY VARCHAR2,
571: px_parent_id IN OUT NOCOPY NUMBER,

Line 578: l_ps_obj HZ_PARTY_SITE_BO;

574: px_parent_obj_type IN OUT NOCOPY VARCHAR2
575: ) IS
576: l_msg_count NUMBER;
577: l_msg_data VARCHAR2(2000);
578: l_ps_obj HZ_PARTY_SITE_BO;
579: BEGIN
580: l_ps_obj := p_party_site_obj;
581: do_create_party_site_bo(
582: p_init_msg_list => fnd_api.g_true,

Line 640: p_party_site_obj IN HZ_PARTY_SITE_BO,

636: --
637:
638: PROCEDURE update_party_site_bo(
639: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
640: p_party_site_obj IN HZ_PARTY_SITE_BO,
641: p_created_by_module IN VARCHAR2,
642: x_return_status OUT NOCOPY VARCHAR2,
643: x_msg_count OUT NOCOPY NUMBER,
644: x_msg_data OUT NOCOPY VARCHAR2,

Line 649: l_ps_obj HZ_PARTY_SITE_BO;

645: x_party_site_id OUT NOCOPY NUMBER,
646: x_party_site_os OUT NOCOPY VARCHAR2,
647: x_party_site_osr OUT NOCOPY VARCHAR2
648: )IS
649: l_ps_obj HZ_PARTY_SITE_BO;
650: BEGIN
651: l_ps_obj := p_party_site_obj;
652: do_update_party_site_bo(
653: p_init_msg_list => p_init_msg_list,

Line 667: p_party_site_obj IN HZ_PARTY_SITE_BO,

663: p_parent_os => NULL );
664: END update_party_site_bo;
665:
666: PROCEDURE update_party_site_bo(
667: p_party_site_obj IN HZ_PARTY_SITE_BO,
668: p_created_by_module IN VARCHAR2,
669: p_obj_source IN VARCHAR2 := null,
670: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
671: x_return_status OUT NOCOPY VARCHAR2,

Line 673: x_return_obj OUT NOCOPY HZ_PARTY_SITE_BO,

669: p_obj_source IN VARCHAR2 := null,
670: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
671: x_return_status OUT NOCOPY VARCHAR2,
672: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
673: x_return_obj OUT NOCOPY HZ_PARTY_SITE_BO,
674: x_party_site_id OUT NOCOPY NUMBER,
675: x_party_site_os OUT NOCOPY VARCHAR2,
676: x_party_site_osr OUT NOCOPY VARCHAR2
677: )IS

Line 680: l_ps_obj HZ_PARTY_SITE_BO;

676: x_party_site_osr OUT NOCOPY VARCHAR2
677: )IS
678: l_msg_count NUMBER;
679: l_msg_data VARCHAR2(2000);
680: l_ps_obj HZ_PARTY_SITE_BO;
681: BEGIN
682: l_ps_obj := p_party_site_obj;
683: do_update_party_site_bo(
684: p_init_msg_list => fnd_api.g_true,

Line 711: p_party_site_obj IN OUT NOCOPY HZ_PARTY_SITE_BO,

707: -- DESCRIPTION
708: -- Update party site business object.
709: PROCEDURE do_update_party_site_bo(
710: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
711: p_party_site_obj IN OUT NOCOPY HZ_PARTY_SITE_BO,
712: p_created_by_module IN VARCHAR2,
713: p_obj_source IN VARCHAR2 := null,
714: x_return_status OUT NOCOPY VARCHAR2,
715: x_msg_count OUT NOCOPY NUMBER,

Line 906: HZ_PARTY_SITE_BO_PVT.save_party_site_uses(

902: -- For Party Site Use
903: ---------------------
904: IF((p_party_site_obj.party_site_use_objs IS NOT NULL) AND
905: (p_party_site_obj.party_site_use_objs.COUNT > 0)) THEN
906: HZ_PARTY_SITE_BO_PVT.save_party_site_uses(
907: p_psu_objs => p_party_site_obj.party_site_use_objs,
908: p_ps_id => x_party_site_id,
909: x_return_status => x_return_status,
910: x_msg_count => x_msg_count,

Line 1093: p_party_site_obj IN OUT NOCOPY HZ_PARTY_SITE_BO,

1089: -- Create or update a party site business object.
1090: PROCEDURE do_save_party_site_bo(
1091: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1092: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1093: p_party_site_obj IN OUT NOCOPY HZ_PARTY_SITE_BO,
1094: p_created_by_module IN VARCHAR2,
1095: p_obj_source IN VARCHAR2 := null,
1096: x_return_status OUT NOCOPY VARCHAR2,
1097: x_msg_count OUT NOCOPY NUMBER,

Line 1265: p_party_site_obj IN HZ_PARTY_SITE_BO,

1261:
1262: PROCEDURE save_party_site_bo(
1263: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1264: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1265: p_party_site_obj IN HZ_PARTY_SITE_BO,
1266: p_created_by_module IN VARCHAR2,
1267: x_return_status OUT NOCOPY VARCHAR2,
1268: x_msg_count OUT NOCOPY NUMBER,
1269: x_msg_data OUT NOCOPY VARCHAR2,

Line 1278: l_ps_obj HZ_PARTY_SITE_BO;

1274: px_parent_os IN OUT NOCOPY VARCHAR2,
1275: px_parent_osr IN OUT NOCOPY VARCHAR2,
1276: px_parent_obj_type IN OUT NOCOPY VARCHAR2
1277: ) IS
1278: l_ps_obj HZ_PARTY_SITE_BO;
1279: BEGIN
1280: l_ps_obj := p_party_site_obj;
1281: do_save_party_site_bo(
1282: p_init_msg_list => p_init_msg_list,

Line 1302: p_party_site_obj IN HZ_PARTY_SITE_BO,

1298: END save_party_site_bo;
1299:
1300: PROCEDURE save_party_site_bo(
1301: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
1302: p_party_site_obj IN HZ_PARTY_SITE_BO,
1303: p_created_by_module IN VARCHAR2,
1304: p_obj_source IN VARCHAR2 := null,
1305: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1306: x_return_status OUT NOCOPY VARCHAR2,

Line 1308: x_return_obj OUT NOCOPY HZ_PARTY_SITE_BO,

1304: p_obj_source IN VARCHAR2 := null,
1305: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
1306: x_return_status OUT NOCOPY VARCHAR2,
1307: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
1308: x_return_obj OUT NOCOPY HZ_PARTY_SITE_BO,
1309: x_party_site_id OUT NOCOPY NUMBER,
1310: x_party_site_os OUT NOCOPY VARCHAR2,
1311: x_party_site_osr OUT NOCOPY VARCHAR2,
1312: px_parent_id IN OUT NOCOPY NUMBER,

Line 1319: l_ps_obj HZ_PARTY_SITE_BO;

1315: px_parent_obj_type IN OUT NOCOPY VARCHAR2
1316: ) IS
1317: l_msg_count NUMBER;
1318: l_msg_data VARCHAR2(2000);
1319: l_ps_obj HZ_PARTY_SITE_BO;
1320: BEGIN
1321: l_ps_obj := p_party_site_obj;
1322: do_save_party_site_bo(
1323: p_init_msg_list => fnd_api.g_true,

Line 1415: x_party_site_obj OUT NOCOPY HZ_PARTY_SITE_BO,

1411: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1412: p_party_site_id IN NUMBER,
1413: p_party_site_os IN VARCHAR2,
1414: p_party_site_osr IN VARCHAR2,
1415: x_party_site_obj OUT NOCOPY HZ_PARTY_SITE_BO,
1416: x_return_status OUT NOCOPY VARCHAR2,
1417: x_msg_count OUT NOCOPY NUMBER,
1418: x_msg_data OUT NOCOPY VARCHAR2
1419: ) is

Line 1425: l_party_site_objs HZ_PARTY_SITE_BO_TBL;

1421:
1422: l_party_site_id number;
1423: l_party_site_os varchar2(30);
1424: l_party_site_osr varchar2(255);
1425: l_party_site_objs HZ_PARTY_SITE_BO_TBL;
1426: BEGIN
1427:
1428: -- initialize API return status to success.
1429: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1439: hz_utility_v2pub.debug(p_message=>'hz_party_site_bo_pub.get_party_site_bo(+)',

1435:
1436:
1437: -- Debug info.
1438: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1439: hz_utility_v2pub.debug(p_message=>'hz_party_site_bo_pub.get_party_site_bo(+)',
1440: p_prefix=>l_debug_prefix,
1441: p_msg_level=>fnd_log.level_procedure);
1442: END IF;
1443:

Line 1491: hz_utility_v2pub.debug(p_message=>'hz_party_site_bo_pub.get_party_site_bo (-)',

1487: END IF;
1488:
1489: -- Debug info.
1490: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1491: hz_utility_v2pub.debug(p_message=>'hz_party_site_bo_pub.get_party_site_bo (-)',
1492: p_prefix=>l_debug_prefix,
1493: p_msg_level=>fnd_log.level_procedure);
1494: END IF;
1495:

Line 1514: hz_utility_v2pub.debug(p_message=>'hz_party_site_bo_pub.get_party_site_bo (-)',

1510: p_msg_type=>'ERROR',
1511: p_msg_level=>fnd_log.level_error);
1512: END IF;
1513: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1514: hz_utility_v2pub.debug(p_message=>'hz_party_site_bo_pub.get_party_site_bo (-)',
1515: p_prefix=>l_debug_prefix,
1516: p_msg_level=>fnd_log.level_procedure);
1517: END IF;
1518: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1533: hz_utility_v2pub.debug(p_message=>'hz_party_site_bo_pub.get_party_site_bo (-)',

1529: p_msg_type=>'UNEXPECTED ERROR',
1530: p_msg_level=>fnd_log.level_error);
1531: END IF;
1532: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1533: hz_utility_v2pub.debug(p_message=>'hz_party_site_bo_pub.get_party_site_bo (-)',
1534: p_prefix=>l_debug_prefix,
1535: p_msg_level=>fnd_log.level_procedure);
1536: END IF;
1537: WHEN OTHERS THEN

Line 1556: hz_utility_v2pub.debug(p_message=>'hz_party_site_bo_pub.get_party_site_bo (-)',

1552: p_msg_type=>'SQL ERROR',
1553: p_msg_level=>fnd_log.level_error);
1554: END IF;
1555: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1556: hz_utility_v2pub.debug(p_message=>'hz_party_site_bo_pub.get_party_site_bo (-)',
1557: p_prefix=>l_debug_prefix,
1558: p_msg_level=>fnd_log.level_procedure);
1559: END IF;
1560:

Line 1567: x_party_site_obj OUT NOCOPY HZ_PARTY_SITE_BO,

1563: PROCEDURE get_party_site_bo (
1564: p_party_site_id IN NUMBER,
1565: p_party_site_os IN VARCHAR2,
1566: p_party_site_osr IN VARCHAR2,
1567: x_party_site_obj OUT NOCOPY HZ_PARTY_SITE_BO,
1568: x_return_status OUT NOCOPY VARCHAR2,
1569: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
1570: ) IS
1571: l_msg_data VARCHAR2(2000);

Line 1590: END hz_party_site_bo_pub;

1586: x_msg_count => l_msg_count,
1587: x_msg_data => l_msg_data);
1588: END get_party_site_bo;
1589:
1590: END hz_party_site_bo_pub;