PACKAGE: APPS.WSH_SITE_CONTACT_INFO_PKG

Source

1 PACKAGE WSH_SITE_CONTACT_INFO_PKG AUTHID CURRENT_USER as
2 /* $Header: WSHSITHS.pls 115.1 2002/11/12 01:51:49 nparikh noship $ */
3 
4 
5 PROCEDURE CREATE_CONTACTINFO
6  (
7     P_RELATIONSHIP_PARTY_ID     IN  NUMBER,
8     P_COUNTRY_CODE              IN  VARCHAR2,
9     P_AREA_CODE                 IN  VARCHAR2,
10     P_PHONE_NUMBER              IN  VARCHAR2 DEFAULT NULL,
11     P_EXTENSION                 IN  VARCHAR2,
12     P_PHONE_LINE_TYPE           IN  VARCHAR2,
13     X_CONTACT_POINT_ID          OUT NOCOPY  NUMBER,
14     X_RETURN_STATUS             OUT NOCOPY  VARCHAR2,
15     X_EXCEPTION_MSG             OUT NOCOPY  VARCHAR2,
16     X_SQLERR                    OUT NOCOPY  VARCHAR2,
17     X_SQL_CODE                  OUT NOCOPY  VARCHAR2,
18     X_POSITION                  OUT NOCOPY  NUMBER,
19     X_PROCEDURE                 OUT NOCOPY  VARCHAR2
20   );
21 
22 
23 PROCEDURE UPDATE_CONTACTINFO(
24     P_CONTACT_POINT_ID          IN  NUMBER,
25     P_COUNTRY_CODE              IN  VARCHAR2,
26     P_AREA_CODE                 IN  VARCHAR2,
27     P_PHONE_NUMBER              IN  VARCHAR2 DEFAULT NULL,
28     P_EXTENSION                 IN  VARCHAR2,
29     P_PHONE_LINE_TYPE           IN  VARCHAR2,
30     X_RETURN_STATUS             OUT NOCOPY  VARCHAR2,
31     X_EXCEPTION_MSG             OUT NOCOPY  VARCHAR2,
32     X_POSITION                  OUT NOCOPY  NUMBER,
33     X_PROCEDURE                 OUT NOCOPY  VARCHAR2,
34     X_SQLERR                    OUT NOCOPY  VARCHAR2,
35     X_SQL_CODE                  OUT NOCOPY  VARCHAR2
36 );
37 
38 END WSH_SITE_CONTACT_INFO_PKG;