1 package CS_PARTY_ROLE_GROUP_MAPS_PKG as
2 /* $Header: csptyrgs.pls 120.0 2005/08/18 19:23:29 aneemuch noship $ */
3 procedure INSERT_ROW (
4 PX_PARTY_ROLE_GROUP_MAPPING_ID in out NOCOPY NUMBER,
5 PX_PARTY_ROLE_GROUP_CODE in out NOCOPY VARCHAR2,
6 PX_PARTY_ROLE_CODE in out NOCOPY VARCHAR2,
7 P_SEEDED_FLAG in VARCHAR2,
8 P_START_DATE_ACTIVE in DATE,
9 P_END_DATE_ACTIVE in DATE,
10 P_CREATION_DATE in DATE,
11 P_CREATED_BY in NUMBER,
12 P_LAST_UPDATE_DATE in DATE,
13 P_LAST_UPDATED_BY in NUMBER,
14 P_LAST_UPDATE_LOGIN in NUMBER,
15 X_OBJECT_VERSION_NUMBER out NOCOPY NUMBER
16 );
17
18 procedure UPDATE_ROW (
19 P_PARTY_ROLE_GROUP_MAPPING_ID in NUMBER,
20 P_PARTY_ROLE_GROUP_CODE in VARCHAR2,
21 P_PARTY_ROLE_CODE in VARCHAR2,
22 P_SEEDED_FLAG in VARCHAR2,
23 P_START_DATE_ACTIVE in DATE,
24 P_END_DATE_ACTIVE in DATE,
25 P_LAST_UPDATE_DATE in DATE,
26 P_LAST_UPDATED_BY in NUMBER,
27 P_LAST_UPDATE_LOGIN in NUMBER,
28 X_OBJECT_VERSION_NUMBER out NOCOPY NUMBER
29 );
30
31 procedure DELETE_ROW (
32 P_PARTY_ROLE_GROUP_CODE in VARCHAR2,
33 P_PARTY_ROLE_CODE in VARCHAR2
34 );
35
36 PROCEDURE LOAD_ROW (
37 P_PARTY_ROLE_GROUP_MAPPING_ID IN NUMBER,
38 P_PARTY_ROLE_GROUP_CODE IN VARCHAR2,
39 P_PARTY_ROLE_CODE IN VARCHAR2,
40 P_SEEDED_FLAG IN VARCHAR2,
41 P_START_DATE_ACTIVE IN VARCHAR2,
42 P_END_DATE_ACTIVE IN VARCHAR2,
43 P_OWNER IN VARCHAR2,
44 P_CREATION_DATE IN VARCHAR2,
45 P_CREATED_BY IN NUMBER,
46 P_LAST_UPDATE_DATE IN VARCHAR2,
47 P_LAST_UPDATED_BY IN NUMBER,
48 P_LAST_UPDATE_LOGIN IN NUMBER,
49 P_OBJECT_VERSION_NUMBER IN NUMBER );
50
51 end CS_PARTY_ROLE_GROUP_MAPS_PKG;
[Home] [Help]