1 PACKAGE HZ_EXTRACT_BO_UTIL_PVT AS
2 /*$Header: ARHEUTVS.pls 120.4 2006/04/25 22:03:26 awu noship $ */
3 /*
4 * @rep:scope public
5 * @rep:product HZ
6 * @rep:displayname Contact Point
7 * @rep:category BUSINESS_ENTITY
8 * @rep:lifecycle active
9 * @rep:doccd 115hztig.pdf Oracle Trading Community Architecture Technical Implementation Guide
10 */
11
12 TYPE BO_ID_TBL IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
13
14
15 procedure validate_event_id(p_event_id in number,
16 p_party_id in number,
17 p_event_type in varchar2,
18 p_bo_code in varchar2,
19 x_return_status out nocopy varchar2);
20
21 FUNCTION get_parent_object_type(
22 p_parent_table_name IN VARCHAR2,
23 p_parent_id IN NUMBER
24 ) RETURN VARCHAR2;
25
26 FUNCTION get_user_name(p_user_id in number) return varchar2;
27
28 -- Central procedure for getting root event id.
29
30 procedure get_bo_root_ids(
31 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
32 p_event_id IN NUMBER,
33 x_obj_root_ids OUT NOCOPY BO_ID_TBL,
34 x_return_status OUT NOCOPY VARCHAR2,
35 x_msg_count OUT NOCOPY NUMBER,
36 x_msg_data OUT NOCOPY VARCHAR2
37 );
38
39 PROCEDURE validate_ssm_id(
40 px_id IN OUT NOCOPY NUMBER,
41 px_os IN OUT NOCOPY VARCHAR2,
42 px_osr IN OUT NOCOPY VARCHAR2,
43 p_org_id IN NUMBER := NULL,
44 p_obj_type IN VARCHAR2,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2
48 );
49
50
51 END HZ_EXTRACT_BO_UTIL_PVT;