1 PACKAGE arh_dqm_tree_helper AUTHID CURRENT_USER AS
2 /*$Header: ARHDQMBS.pls 120.1 2005/06/16 21:10:57 jhuang noship $*/
3
4 FUNCTION ctxmax
5 RETURN NUMBER ;
6
7 FUNCTION cpt_in_match
8 (p_party_id IN NUMBER,
9 p_ctx_id IN NUMBER,
10 p_cpt_id IN NUMBER)
11 RETURN VARCHAR2;
12
13 FUNCTION contact_in_match
14 (p_party_id IN NUMBER,
15 p_ctx_id IN NUMBER,
16 p_contact_id IN NUMBER)
17 RETURN VARCHAR2;
18
19 FUNCTION party_site_in_match
20 (p_party_id IN NUMBER,
21 p_ctx_id IN NUMBER,
22 p_ps_id IN NUMBER)
23 RETURN VARCHAR2;
24
25 FUNCTION party_in_match
26 (p_party_id IN NUMBER,
27 p_ctx_id IN NUMBER)
28 RETURN VARCHAR2;
29
30 --------------
31
32 PROCEDURE insert_add_party_site
33 (p_party_id IN NUMBER,
34 p_ctx_id IN NUMBER,
35 p_ps_id IN NUMBER);
36
37 PROCEDURE insert_add_contact
38 (p_party_id IN NUMBER,
39 p_ctx_id IN NUMBER,
40 p_contact_id IN NUMBER);
41
42 PROCEDURE insert_add_cpt
43 (p_party_id IN NUMBER,
44 p_ctx_id IN NUMBER,
45 p_cpt_id IN NUMBER);
46
47 -----------------------------
48
49 FUNCTION contact_id_from_rel_id
50 -------------------------------------------------------
51 -- RETURN org_contact_id from a relationship_id
52 -- + x_party_site_id will return the site_id if the contact is at the site level
53 -- I x_party_site_id = -9999 otherwise
54 -- RETURN -9999 if the org_contact_id coud not be found
55 -------------------------------------------------------
56 ( p_rel_id IN NUMBER ,
57 x_ps_id IN OUT NOCOPY NUMBER )
58 RETURN NUMBER;
59
60 FUNCTION party_or_site_from_cpt
61 ---------------------------------------------------------------------------------------
62 -- RETURN party_site_id if contact_point at PS
63 -- + flag x_type to 'PARTY_SITE'
64 -- RETURN party_id if contact_point at PARTY
65 -- + flag x_type to 'ORGANIZATION' if the party is type 'ORGANIZATION'
66 -- flag x_type to 'PARTY_RELATIONSHIP' if the party is type 'PARTY_RELATIONSHIP'
67 -- RETURN -9999 if contact_point not found
68 ---------------------------------------------------------------------------------------
69 (p_contact_point_id IN NUMBER,
70 x_type IN OUT NOCOPY VARCHAR2)
71 RETURN NUMBER;
72
73 FUNCTION rel_id_betw_per_to_org
74 ----------------------------------------------------------------------
75 -- RETURN Relationship_id if the per_id is in relation with a party_id
76 -- + x_rel_code contains REL_CODE
77 -- RETURN -9999 otherwise
78 ----------------------------------------------------------------------
79 ( p_party_id IN NUMBER,
80 p_pers_id IN NUMBER,
81 x_rel_code IN OUT NOCOPY VARCHAR2)
82 RETURN NUMBER;
83
84 FUNCTION is_pty_object_of_rel
85 (p_party_id IN NUMBER,
86 p_rel_id IN NUMBER)
87 RETURN VARCHAR2;
88
89 FUNCTION is_site_of_pty
90 (p_party_id IN NUMBER,
91 p_ps_id IN NUMBER)
92 RETURN VARCHAR2;
93
94 PROCEDURE relationship_treatment
95 (p_rel_id IN NUMBER,
96 p_pty_id IN NUMBER,
97 p_ctx_id IN NUMBER,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2);
101
102 PROCEDURE treatment_party_site
103 (p_ps_id IN NUMBER,
104 p_pty_id IN NUMBER,
105 p_ctx_id IN NUMBER,
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2);
109
110 PROCEDURE cpt_treatment
111 (p_cpt_id IN NUMBER,
112 p_pty_id IN NUMBER,
113 p_ctx_id IN NUMBER,
114 x_return_status OUT NOCOPY VARCHAR2,
115 x_msg_count OUT NOCOPY NUMBER,
116 x_msg_data OUT NOCOPY VARCHAR2);
117
118 PROCEDURE contact_treatment
119 (p_contact_id IN NUMBER,
120 p_pty_id IN NUMBER,
121 p_ctx_id IN NUMBER,
122 x_return_status OUT NOCOPY VARCHAR2,
123 x_msg_count OUT NOCOPY NUMBER,
124 x_msg_data OUT NOCOPY VARCHAR2);
125
126 END;