PACKAGE: APPS.WSH_CARRIER_CONTACT_INFO_PKG

Source

1 PACKAGE WSH_CARRIER_CONTACT_INFO_PKG AUTHID CURRENT_USER as
2 /* $Header: WSHCITHS.pls 120.1 2006/06/09 09:11:43 jnpinto 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_PRIMARY                   IN  VARCHAR2,
13     P_STATUS                    IN  VARCHAR2,
14     P_CONTACT_TYPE              IN  VARCHAR2,
15     X_CONTACT_POINT_ID          OUT NOCOPY  NUMBER,
16     X_RETURN_STATUS             OUT NOCOPY  VARCHAR2,
17     X_EXCEPTION_MSG             OUT NOCOPY  VARCHAR2,
18     X_SQLERR                    OUT NOCOPY  VARCHAR2,
19     X_SQL_CODE                  OUT NOCOPY  VARCHAR2,
20     X_POSITION                  OUT NOCOPY  NUMBER,
21     X_PROCEDURE                 OUT NOCOPY  VARCHAR2
22   );
23 
24 
25 PROCEDURE UPDATE_CONTACTINFO(
26     P_CARRIER_PARTY_ID          IN NUMBER,
27     P_CONTACT_POINT_ID          IN NUMBER,
28     P_COUNTRY_CODE              IN  VARCHAR2,
29     P_AREA_CODE                 IN  VARCHAR2,
30     P_PHONE_NUMBER              IN  VARCHAR2 DEFAULT NULL,
31     P_EXTENSION                 IN  VARCHAR2,
32     P_PRIMARY                   IN  VARCHAR2,
33     P_STATUS                    IN  VARCHAR2,
34     P_CONTACT_TYPE              IN  VARCHAR2,        -- Added parameter for conatct type - Bug 5298638
35     X_RETURN_STATUS             OUT NOCOPY  VARCHAR2,
36     X_EXCEPTION_MSG             OUT NOCOPY  VARCHAR2,
37     X_POSITION                  OUT NOCOPY  NUMBER,
38     X_PROCEDURE                 OUT NOCOPY  VARCHAR2,
39     X_SQLERR                    OUT NOCOPY  VARCHAR2,
40     X_SQL_CODE                  OUT NOCOPY  VARCHAR2
41 
42 );
43 
44 END WSH_CARRIER_CONTACT_INFO_PKG;