[Home] [Help]
PACKAGE: APPS.WSH_SITE_CONTACT_PERSON_PKG
Source
1 PACKAGE WSH_SITE_CONTACT_PERSON_PKG AUTHID CURRENT_USER as
2 /* $Header: WSHSPTHS.pls 120.0.12010000.1 2008/07/29 06:18:37 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 P_CARRIER_SITE_ID IN NUMBER,
11 P_CONTACT_NUMBER IN VARCHAR2,
12 P_LOAD_TENDER_FLAG IN VARCHAR2,
13 P_JOB_TITLE IN VARCHAR2,
14 P_EMAIL_ADDRESS IN VARCHAR2,
15 X_ORG_CONTACT_ID OUT NOCOPY NUMBER,
16 X_PERSON_ID OUT NOCOPY NUMBER,
17 X_RELATIONSHIP_ID OUT NOCOPY NUMBER,
18 X_CONTACT_POINT_ID OUT NOCOPY NUMBER,
19 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
20 X_EXCEPTION_MSG OUT NOCOPY VARCHAR2,
21 X_POSITION OUT NOCOPY NUMBER,
22 X_PROCEDURE OUT NOCOPY VARCHAR2,
23 X_SQLERR OUT NOCOPY VARCHAR2,
24 X_SQL_CODE OUT NOCOPY VARCHAR2
25 );
26
27
28
29 PROCEDURE UPDATE_CONTACTPERSON(
30 P_PERSON_PARTY_ID IN NUMBER,
31 P_PERSON_NAME_PRE_ADJUNCT IN VARCHAR2,
32 P_PERSON_FIRST_NAME IN VARCHAR2,
33 P_PERSON_LAST_NAME IN VARCHAR2,
34 P_CONTACT_NUMBER IN VARCHAR2,
35 P_JOB_TITLE IN VARCHAR2,
36 P_EMAIL_ADDRESS IN VARCHAR2,
37 P_STATUS IN VARCHAR2,
38 P_LOAD_TENDER_FLAG IN VARCHAR2,
39 P_ORG_CONTACT_ID IN NUMBER,
40 P_CONTACT_POINT_ID IN NUMBER,
41 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
42 X_EXCEPTION_MSG OUT NOCOPY VARCHAR2,
43 X_POSITION OUT NOCOPY NUMBER,
44 X_PROCEDURE OUT NOCOPY VARCHAR2,
45 X_SQLERR OUT NOCOPY VARCHAR2,
46 X_SQL_CODE OUT NOCOPY VARCHAR2 );
47
48
49 END WSH_SITE_CONTACT_PERSON_PKG;