[Home] [Help]
1 PACKAGE HZ_EXTRACT_BO_UTIL_PVT AUTHID CURRENT_USER AS
2 /*$Header: ARHEUTVS.pls 120.4.12010000.2 2009/06/25 06:00:24 vsegu ship $ */
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 G_RETURN_USER_NAME CONSTANT VARCHAR2(255) := NVL(FND_PROFILE.VALUE('HZ_RETURN_USER_NAME'), 'Y'); --8529267
14
15
16 procedure validate_event_id(p_event_id in number,
17 p_party_id in number,
18 p_event_type in varchar2,
19 p_bo_code in varchar2,
20 x_return_status out nocopy varchar2);
21
22 FUNCTION get_parent_object_type(
23 p_parent_table_name IN VARCHAR2,
24 p_parent_id IN NUMBER
25 ) RETURN VARCHAR2;
26
27 FUNCTION get_user_name(p_user_id in number) return varchar2;
28
29 -- Central procedure for getting root event id.
30
31 procedure get_bo_root_ids(
32 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
33 p_event_id IN NUMBER,
34 x_obj_root_ids OUT NOCOPY BO_ID_TBL,
35 x_return_status OUT NOCOPY VARCHAR2,
36 x_msg_count OUT NOCOPY NUMBER,
37 x_msg_data OUT NOCOPY VARCHAR2
38 );
39
40 PROCEDURE validate_ssm_id(
41 px_id IN OUT NOCOPY NUMBER,
42 px_os IN OUT NOCOPY VARCHAR2,
43 px_osr IN OUT NOCOPY VARCHAR2,
44 p_org_id IN NUMBER := NULL,
45 p_obj_type IN VARCHAR2,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_msg_count OUT NOCOPY NUMBER,
48 x_msg_data OUT NOCOPY VARCHAR2
49 );
50
51
52 END HZ_EXTRACT_BO_UTIL_PVT;
|
|
|
|