1 package CS_PARTY_ROLES_PKG as
2 /* $Header: csxptyrs.pls 120.0 2005/08/18 19:25 aneemuch noship $ */
3
4 procedure INSERT_ROW (
5 PX_PARTY_ROLE_CODE in out NOCOPY VARCHAR2,
6 P_START_DATE_ACTIVE in DATE,
7 P_END_DATE_ACTIVE in DATE,
8 P_SEEDED_FLAG in VARCHAR2,
9 P_SORT_ORDER in NUMBER ,
10 P_NAME in VARCHAR2,
11 P_DESCRIPTION in VARCHAR2,
12 P_CREATION_DATE in DATE,
13 P_CREATED_BY in NUMBER,
14 P_LAST_UPDATE_DATE in DATE,
15 P_LAST_UPDATED_BY in NUMBER,
16 P_LAST_UPDATE_LOGIN in NUMBER,
17 X_OBJECT_VERSION_NUMBER out NOCOPY NUMBER
18 );
19
20 procedure UPDATE_ROW (
21 P_PARTY_ROLE_CODE in VARCHAR2,
22 P_START_DATE_ACTIVE in DATE,
23 P_END_DATE_ACTIVE in DATE,
24 P_SEEDED_FLAG in VARCHAR2,
25 P_SORT_ORDER in NUMBER,
26 P_NAME in VARCHAR2,
27 P_DESCRIPTION in VARCHAR2,
28 P_LAST_UPDATE_DATE in DATE,
29 P_LAST_UPDATED_BY in NUMBER,
30 P_LAST_UPDATE_LOGIN in NUMBER,
31 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER
32 );
33
34 procedure DELETE_ROW (
35 P_PARTY_ROLE_CODE in VARCHAR2
36 );
37
38 procedure ADD_LANGUAGE;
39
40 PROCEDURE LOAD_ROW (
41 P_PARTY_ROLE_CODE IN VARCHAR2,
42 P_START_DATE_ACTIVE IN VARCHAR2,
43 P_END_DATE_ACTIVE IN VARCHAR2,
44 P_SEEDED_FLAG IN VARCHAR2,
45 P_SORT_ORDER IN VARCHAR2,
46 P_NAME IN VARCHAR2,
47 P_DESCRIPTION IN VARCHAR2,
48 P_OWNER IN VARCHAR2,
49 P_CREATION_DATE IN VARCHAR2,
50 P_CREATED_BY IN NUMBER,
51 P_LAST_UPDATE_DATE IN VARCHAR2,
52 P_LAST_UPDATED_BY IN NUMBER,
53 P_LAST_UPDATE_LOGIN IN NUMBER,
54 P_OBJECT_VERSION_NUMBER IN NUMBER );
55
56 procedure TRANSLATE_ROW ( X_PARTY_ROLE_CODE in varchar2,
57 X_NAME in varchar2,
58 X_DESCRIPTION in varchar2,
59 X_LAST_UPDATE_DATE in date,
60 X_LAST_UPDATE_LOGIN in number,
61 X_OWNER in varchar2);
62
63 end CS_PARTY_ROLES_PKG;