1 PACKAGE POS_HZ_RELATIONSHIPS_PKG AUTHID CURRENT_USER AS
2 /*$Header: POSHZPRS.pls 115.4 2002/11/16 01:07:39 jpasala ship $ */
3
4
5 procedure pos_hz_create_relationship(
6 p_subject_id IN NUMBER,
7 p_object_id IN NUMBER,
8 p_relationship_type IN VARCHAR2,
9 p_relationship_code IN VARCHAR2,
10 p_party_object_type IN VARCHAR2,
11 p_party_subject_type IN VARCHAR2,
12 p_subject_table_name IN VARCHAR2,
13 p_object_table_name IN VARCHAR2,
14 p_relationship_status IN VARCHAR2 :=null, -- can be null
15 p_relationship_start_date IN DATE := null, -- can be null
16 p_relationship_end_date IN DATE := null, -- can be null
17
18 x_party_relationship_id OUT NOCOPY NUMBER,
19 x_return_status OUT NOCOPY VARCHAR2,
20 x_exception_msg OUT NOCOPY VARCHAR2
21 );
22
23 procedure pos_create_relationship(
24 p_subject_id IN NUMBER,
25 p_object_id IN NUMBER,
26 p_relationship_type IN VARCHAR2,
27 p_relationship_code IN VARCHAR2,
28 x_party_relationship_id OUT NOCOPY NUMBER,
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_exception_msg OUT NOCOPY VARCHAR2);
31
32 procedure pos_hz_update_relationship(p_subject_id IN NUMBER,
33 p_object_id IN NUMBER,
34 p_relationship_type IN VARCHAR2,
35 p_relationship_code IN VARCHAR2,
36 p_party_object_type IN VARCHAR2,
37 p_party_subject_type IN VARCHAR2,
38 p_subject_table_name IN VARCHAR2,
39 p_object_table_name IN VARCHAR2,
40 -- p_relationship_status IN VARCHAR2, -- should not be updated
41 p_relationship_start_date IN DATE, -- can be null
42 p_relationship_end_date IN DATE, -- can be null
43
44 p_relationship_id IN NUMBER,
45 p_object_version_number in number,
46
47 p_rel_last_update_date IN OUT NOCOPY DATE,
48 p_party_last_update_date IN OUT NOCOPY DATE,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_exception_msg OUT NOCOPY VARCHAR2);
51
52 procedure pos_outdate_relationship(
53 p_subject_id IN NUMBER,
54 p_object_id IN NUMBER,
55 p_relationship_type IN VARCHAR2,
56 p_relationship_code IN VARCHAR2,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_exception_msg OUT NOCOPY VARCHAR2);
59
60 procedure pos_outdate_relationship(
61 p_relationship_id IN NUMBER,
62 p_object_version_num IN NUMBER,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_exception_msg OUT NOCOPY VARCHAR2);
65
66 procedure GET_RELATING_PARTY_ID(p_subject_id IN NUMBER,
67 p_relationship_type IN VARCHAR2,
68 p_relationship_code IN VARCHAR2,
69 x_object_id OUT NOCOPY NUMBER,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_exception_msg OUT NOCOPY VARCHAR2);
72
73 END POS_HZ_RELATIONSHIPS_PKG;