PACKAGE: APPS.HZ_MERGE_UTIL

Source

1 PACKAGE HZ_MERGE_UTIL AUTHID CURRENT_USER AS
2 /* $Header: ARHMUTLS.pls 120.2 2005/10/30 04:20:38 appldev noship $ */
3 
4 PROCEDURE insert_party_site_details (
5 	p_from_party_id	IN	NUMBER,
6 	p_to_party_id	IN	NUMBER,
7 	p_batch_party_id IN	NUMBER,
8         p_CREATED_BY    NUMBER,
9         p_CREATION_DATE    DATE,
10         p_LAST_UPDATE_LOGIN    NUMBER,
11         p_LAST_UPDATE_DATE    DATE,
12         p_LAST_UPDATED_BY    NUMBER);
13 
14 
15 PROCEDURE insert_party_reln_details (
16         p_from_party_id IN      NUMBER,
17         p_to_party_id   IN      NUMBER,
18         p_batch_party_id IN     NUMBER,
19         p_CREATED_BY    IN NUMBER,
20         p_CREATION_DATE   IN  DATE,
21         p_LAST_UPDATE_LOGIN IN    NUMBER,
22         p_LAST_UPDATE_DATE  IN   DATE,
23         p_LAST_UPDATED_BY  IN   NUMBER);
24 
25 FUNCTION get_party_site_description(
26         p_party_site_id IN      NUMBER)
27 RETURN VARCHAR2;
28 
29 FUNCTION get_party_reln_description(
30         p_party_reln_id IN      NUMBER)
31 RETURN VARCHAR2;
32 
33 FUNCTION get_org_contact_description(
34         p_org_contact_id IN      NUMBER)
35 RETURN VARCHAR2;
36 
37 FUNCTION get_org_contact_id(
38         p_party_relationship_id  IN NUMBER)
39 RETURN NUMBER;
40 
41 FUNCTION get_reln_party_id(
42         p_party_relationship_id  IN NUMBER)
43 RETURN NUMBER;
44 END HZ_MERGE_UTIL;