DBA Data[Home] [Help]

APPS.HZ_EXTRACT_PERSON_BO_PVT dependencies on HZ_PERSON_BO

Line 262: x_person_obj OUT NOCOPY HZ_PERSON_BO,

258: PROCEDURE get_person_bo(
259: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
260: p_person_id IN NUMBER,
261: p_action_type IN VARCHAR2 := NULL,
262: x_person_obj OUT NOCOPY HZ_PERSON_BO,
263: x_return_status OUT NOCOPY VARCHAR2,
264: x_msg_count OUT NOCOPY NUMBER,
265: x_msg_data OUT NOCOPY VARCHAR2
266: ) is

Line 269: SELECT HZ_PERSON_BO(

265: x_msg_data OUT NOCOPY VARCHAR2
266: ) is
267:
268: CURSOR C1 IS
269: SELECT HZ_PERSON_BO(
270: P_ACTION_TYPE,
271: NULL, -- COMMON_OBJ_ID
272: P.PARTY_ID,
273: NULL, --ORIG_SYSTEM,

Line 830: --the procedure returns database objects of the type HZ_PERSON_BO for all of

826: -- PROCEDURE get_persons_created
827: --
828: -- DESCRIPTION
829: --The caller provides an identifier for the Persons created business event and
830: --the procedure returns database objects of the type HZ_PERSON_BO for all of
831: --the Person business objects from the business event.
832:
833: --
834: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 866: HZ_PERSON_BO_PVT.get_person_bo

862: business event signifies that one or more Person business objects have been created.
863: The caller provides an identifier for the Persons Created business event and the procedure
864: returns all of the Person business objects from the business event. For each business object
865: creation captured in the business event, the procedure calls the generic Get operation:
866: HZ_PERSON_BO_PVT.get_person_bo
867:
868: Gathering all of the returned business objects from those API calls, the procedure packages
869: them in a table structure and returns them to the caller.
870: */

Line 876: x_person_objs OUT NOCOPY HZ_PERSON_BO_TBL,

872:
873: PROCEDURE get_persons_created(
874: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
875: p_event_id IN NUMBER,
876: x_person_objs OUT NOCOPY HZ_PERSON_BO_TBL,
877: x_return_status OUT NOCOPY VARCHAR2,
878: x_msg_count OUT NOCOPY NUMBER,
879: x_msg_data OUT NOCOPY VARCHAR2
880: ) is

Line 915: x_person_objs := HZ_PERSON_BO_TBL();

911: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
912: RAISE FND_API.G_EXC_ERROR;
913: END IF;
914:
915: x_person_objs := HZ_PERSON_BO_TBL();
916:
917: for i in 1..l_obj_root_ids.count loop
918:
919: x_person_objs.extend;

Line 1025: --the procedure returns database objects of the type HZ_PERSON_BO for all of

1021: -- PROCEDURE get_persons_updated
1022: --
1023: -- DESCRIPTION
1024: --The caller provides an identifier for the Persons update business event and
1025: --the procedure returns database objects of the type HZ_PERSON_BO for all of
1026: --the Person business objects from the business event.
1027:
1028: --
1029: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 1059: the type HZ_PERSON_BO for all of the Person business objects from the business event.

1055: The Get Persons Updated procedure is a service to retrieve all of the Person business objects whose updates have been
1056: captured by the logical business event. Each Persons Updated business event signifies that one or more Person business
1057: objects have been updated.
1058: The caller provides an identifier for the Persons Update business event and the procedure returns database objects of
1059: the type HZ_PERSON_BO for all of the Person business objects from the business event.
1060: Gathering all of the returned database objects from those API calls, the procedure packages them in a table structure
1061: and returns them to the caller.
1062: */
1063:

Line 1067: x_person_objs OUT NOCOPY HZ_PERSON_BO_TBL,

1063:
1064: PROCEDURE get_persons_updated(
1065: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1066: p_event_id IN NUMBER,
1067: x_person_objs OUT NOCOPY HZ_PERSON_BO_TBL,
1068: x_return_status OUT NOCOPY VARCHAR2,
1069: x_msg_count OUT NOCOPY NUMBER,
1070: x_msg_data OUT NOCOPY VARCHAR2
1071: ) is

Line 1110: x_person_objs := HZ_PERSON_BO_TBL();

1106:
1107:
1108: -- call event API get_organization_updated for each id.
1109:
1110: x_person_objs := HZ_PERSON_BO_TBL();
1111:
1112: for i in 1..l_obj_root_ids.count loop
1113:
1114: x_person_objs.extend;

Line 1218: px_person_obj IN OUT NOCOPY HZ_PERSON_BO,

1214:
1215: -- Based on BOT, for updated branch, set action_type = 'UPDATED'/'CREATED'
1216: procedure set_person_bo_action_type(p_event_id IN NUMBER,
1217: p_root_id IN NUMBER,
1218: px_person_obj IN OUT NOCOPY HZ_PERSON_BO,
1219: x_return_status OUT NOCOPY VARCHAR2) is
1220: cursor c1 is
1221:
1222: SELECT

Line 1629: --the procedure returns one database object of the type HZ_PERSON_BO

1625: -- PROCEDURE get_person_updated
1626: --
1627: -- DESCRIPTION
1628: --The caller provides an identifier for the Persons update business event and person_id
1629: --the procedure returns one database object of the type HZ_PERSON_BO
1630:
1631: --
1632: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1633: --

Line 1664: x_person_obj OUT NOCOPY HZ_PERSON_BO,

1660: PROCEDURE get_person_updated(
1661: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1662: p_event_id IN NUMBER,
1663: p_person_id IN NUMBER,
1664: x_person_obj OUT NOCOPY HZ_PERSON_BO,
1665: x_return_status OUT NOCOPY VARCHAR2,
1666: x_msg_count OUT NOCOPY NUMBER,
1667: x_msg_data OUT NOCOPY VARCHAR2
1668: ) is

Line 1671: l_person_obj HZ_PERSON_BO;

1667: x_msg_data OUT NOCOPY VARCHAR2
1668: ) is
1669: l_obj_root_ids HZ_EXTRACT_BO_UTIL_PVT.BO_ID_TBL;
1670: l_debug_prefix VARCHAR2(30) := '';
1671: l_person_obj HZ_PERSON_BO;
1672:
1673: begin
1674:
1675: -- initialize API return status to success.