[Home] [Help]
64: PROCEDURE get_person_cust_bo(
65: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
66: p_person_id IN NUMBER,
67: p_action_type IN VARCHAR2 := NULL,
68: x_person_cust_obj OUT NOCOPY HZ_PERSON_CUST_BO,
69: x_return_status OUT NOCOPY VARCHAR2,
70: x_msg_count OUT NOCOPY NUMBER,
71: x_msg_data OUT NOCOPY VARCHAR2
72: ) is
89: p_prefix=>l_debug_prefix,
90: p_msg_level=>fnd_log.level_procedure);
91: END IF;
92:
93: x_person_cust_obj := HZ_PERSON_CUST_BO(p_action_type, NULL, NULL);
94:
95: HZ_EXTRACT_PERSON_BO_PVT.get_person_bo(
96: p_init_msg_list => fnd_api.g_false,
97: p_person_id => p_person_id,
274:
275: PROCEDURE get_person_custs_created(
276: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
277: p_event_id IN NUMBER,
278: x_person_cust_objs OUT NOCOPY HZ_PERSON_CUST_BO_TBL,
279: x_return_status OUT NOCOPY VARCHAR2,
280: x_msg_count OUT NOCOPY NUMBER,
281: x_msg_data OUT NOCOPY VARCHAR2
282: ) is
316: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
317: RAISE FND_API.G_EXC_ERROR;
318: END IF;
319:
320: x_person_cust_objs := HZ_PERSON_CUST_BO_TBL();
321: l_child_operation_flag:= get_person_operation_type(p_event_id);
322:
323: if L_CHILD_OPERATION_FLAG = 'I'
324: then
330: for i in 1..l_obj_root_ids.count loop
331:
332: x_person_cust_objs.extend;
333:
334: x_person_cust_objs(i) := HZ_PERSON_CUST_BO('UNCHANGED', NULL, NULL);
335: HZ_EXTRACT_PERSON_BO_PVT.get_person_bo(
336: p_init_msg_list => fnd_api.g_false,
337: p_person_id => l_obj_root_ids(i),
338: p_action_type => l_action_type,
463: -- PROCEDURE get_person_custs_updated
464: --
465: -- DESCRIPTION
466: --The caller provides an identifier for the Person Customers update business event and
467: --the procedure returns database objects of the type HZ_PERSON_CUST_BO for all of
468: --the Person Customer business objects from the business event.
469:
470: --
471: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
497: The Get Person Customers Updated procedure is a service to retrieve all of the Person Customer business objects
498: whose updates have been captured by the logical business event. Each Person Customers Updated business event signifies
499: that one or more Person Customer business objects have been updated.
500: The caller provides an identifier for the Person Customers Update business event and the procedure returns database
501: objects of the type HZ_PERSON_CUST_BO for all of the Person Customer business objects from the business event.
502: Gathering all of the returned database objects from those API calls, the procedure packages them in a table structure
503: and returns them to the caller.
504: */
505:
505:
506: PROCEDURE get_person_custs_updated(
507: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
508: p_event_id IN NUMBER,
509: x_person_cust_objs OUT NOCOPY HZ_PERSON_CUST_BO_TBL,
510: x_return_status OUT NOCOPY VARCHAR2,
511: x_msg_count OUT NOCOPY NUMBER,
512: x_msg_data OUT NOCOPY VARCHAR2
513: ) is
547: END IF;
548:
549: -- call event API get_person_cust_updated for each id.
550:
551: x_person_cust_objs := HZ_PERSON_CUST_BO_TBL();
552:
553: for i in 1..l_obj_root_ids.count loop
554:
555: x_person_cust_objs.extend;
859: end set_per_acct_bo_action_type;
860:
861: procedure set_person_cust_bo_action_type(p_event_id IN NUMBER,
862: p_root_id IN NUMBER,
863: px_person_cust_obj IN OUT NOCOPY HZ_PERSON_CUST_BO,
864: x_return_status OUT NOCOPY VARCHAR2) is
865: cursor c1 is
866:
867: SELECT
995: -- PROCEDURE get_person_cust_updated
996: --
997: -- DESCRIPTION
998: --The caller provides an identifier for the Person customer update business event and person id
999: --the procedure returns one database object of the type HZ_PERSON_CUST_BO
1000: --
1001: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1002: --
1003: -- ARGUMENTS
1025: PROCEDURE get_person_cust_updated(
1026: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1027: p_event_id IN NUMBER,
1028: p_person_cust_id IN NUMBER,
1029: x_person_cust_obj OUT NOCOPY HZ_PERSON_CUST_BO,
1030: x_return_status OUT NOCOPY VARCHAR2,
1031: x_msg_count OUT NOCOPY NUMBER,
1032: x_msg_data OUT NOCOPY VARCHAR2
1033: ) is
1033: ) is
1034:
1035: l_obj_root_ids HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL;
1036: l_debug_prefix VARCHAR2(30) := '';
1037: l_person_cust_obj HZ_PERSON_CUST_BO;
1038: begin
1039:
1040: -- initialize API return status to success.
1041: x_return_status := FND_API.G_RET_STS_SUCCESS;