PACKAGE: APPS.WSH_CONTACT_PERSON_PKG

Source

1 PACKAGE WSH_CONTACT_PERSON_PKG as
2 /* $Header: WSHCPTHS.pls 120.0.12010000.1 2008/07/29 05:59:04 appldev ship $ */
3 
4 PROCEDURE CREATE_CONTACTPERSON(
5   P_CARRIER_PARTY_ID          IN  NUMBER,
6   P_STATUS                    IN  VARCHAR2,
7   P_PERSON_NAME_PRE_ADJUNCT   IN  VARCHAR2,
8   P_PERSON_FIRST_NAME         IN  VARCHAR2 DEFAULT NULL,
9   P_PERSON_LAST_NAME          IN  VARCHAR2 ,
10   X_RELATIONSHIP_PARTY_ID     OUT NOCOPY  NUMBER,
11   X_PERSON_PARTY_ID           OUT NOCOPY  NUMBER,
12   X_RETURN_STATUS             OUT NOCOPY  VARCHAR2,
13   X_EXCEPTION_MSG             OUT NOCOPY  VARCHAR2,
14   X_POSITION                  OUT NOCOPY  NUMBER,
15   X_PROCEDURE                 OUT NOCOPY  VARCHAR2,
16   X_SQLERR                    OUT NOCOPY  VARCHAR2,
17   X_SQL_CODE                  OUT NOCOPY  VARCHAR2  );
18 
19 PROCEDURE UPDATE_CONTACTPERSON(
20   P_CARRIER_PARTY_ID        IN  NUMBER,
21   P_PERSON_PARTY_ID IN      OUT NOCOPY  NUMBER,
22   P_PERSON_NAME_PRE_ADJUNCT IN  VARCHAR2,
23   P_PERSON_FIRST_NAME       IN  VARCHAR2,
24   P_PERSON_LAST_NAME        IN  VARCHAR2,
25   P_STATUS                  IN  VARCHAR2,
26   P_CONTACT_POINT_ID        IN OUT NOCOPY  NUMBER,
27   X_RETURN_STATUS              OUT NOCOPY  VARCHAR2,
28   X_EXCEPTION_MSG              OUT NOCOPY  VARCHAR2,
29   X_POSITION                   OUT NOCOPY  NUMBER,
30   X_PROCEDURE                  OUT NOCOPY  VARCHAR2,
31   X_SQLERR                     OUT NOCOPY  VARCHAR2,
32   X_SQL_CODE                   OUT NOCOPY  VARCHAR2  );
33 
34 END WSH_CONTACT_PERSON_PKG;