PACKAGE: APPS.PQH_ROLE_INFO_TYPES_PKG

Source

1 PACKAGE PQH_ROLE_INFO_TYPES_PKG as
2 /* $Header: pqhrlsit.pkh 120.2 2005/10/12 20:18:45 srajakum noship $ */
3 
4 PROCEDURE UNIQUENESS_CHECK(P_INFORMATION_TYPE           VARCHAR2,
5                            P_ACTIVE_INACTIVE_FLAG       VARCHAR2,
6                            P_LEGISLATION_CODE           VARCHAR2,
7                            P_ROWID                      VARCHAR2,
8                            P_DESCRIPTION                VARCHAR2);
9 
10 procedure INSERT_ROW (
11   X_ROWID in out nocopy VARCHAR2,
12   X_INFORMATION_TYPE in VARCHAR2,
13   X_ACTIVE_INACTIVE_FLAG in VARCHAR2,
14   X_MULTIPLE_OCCURENCES_FLAG in VARCHAR2,
15   X_LEGISLATION_CODE in VARCHAR2,
16   X_REQUEST_ID in NUMBER,
17   X_OBJECT_VERSION_NUMBER in NUMBER,
18   X_DESCRIPTION in VARCHAR2,
19   X_CREATION_DATE in DATE,
20   X_CREATED_BY in NUMBER,
21   X_LAST_UPDATE_DATE in DATE,
22   X_LAST_UPDATED_BY in NUMBER,
23   X_LAST_UPDATE_LOGIN in NUMBER);
24 
25 procedure LOCK_ROW (
26   X_INFORMATION_TYPE in VARCHAR2,
27   X_ACTIVE_INACTIVE_FLAG in VARCHAR2,
28   X_MULTIPLE_OCCURENCES_FLAG in VARCHAR2,
29   X_LEGISLATION_CODE in VARCHAR2,
30   X_REQUEST_ID in NUMBER,
31   X_OBJECT_VERSION_NUMBER in NUMBER,
32   X_DESCRIPTION in VARCHAR2
33 );
34 
35 procedure UPDATE_ROW (
36   X_INFORMATION_TYPE in VARCHAR2,
37   X_ACTIVE_INACTIVE_FLAG in VARCHAR2,
38   X_MULTIPLE_OCCURENCES_FLAG in VARCHAR2,
39   X_LEGISLATION_CODE in VARCHAR2,
40   X_REQUEST_ID in NUMBER,
41   X_OBJECT_VERSION_NUMBER in NUMBER,
42   X_DESCRIPTION in VARCHAR2,
43   X_LAST_UPDATE_DATE in DATE,
44   X_LAST_UPDATED_BY in NUMBER,
45   X_LAST_UPDATE_LOGIN in NUMBER
46 );
47 
48 procedure DELETE_ROW (
49   X_INFORMATION_TYPE in VARCHAR2
50 );
51 
52 procedure LOAD_ROW (
53   X_INFORMATION_TYPE in VARCHAR2,
54   X_ACTIVE_INACTIVE_FLAG in VARCHAR2,
55   X_MULTIPLE_OCCURENCES_FLAG in VARCHAR2,
56   X_DESCRIPTION in VARCHAR2,
57   X_LEGISLATION_CODE in VARCHAR2,
58   X_OBJECT_VERSION_NUMBER in NUMBER,
59   X_OWNER in VARCHAR2
60   ,X_LAST_UPDATE_DATE         in varchar2
61 );
62 
63 procedure TRANSLATE_ROW
64   (X_INFORMATION_TYPE in varchar2
65   ,X_DESCRIPTION      in varchar2
66   ,X_OWNER            in varchar2
67   );
68 
69 procedure LOAD_SEED_ROW
70   (X_UPLOAD_MODE              in varchar2
71   ,X_INFORMATION_TYPE         in varchar2
72   ,X_ACTIVE_INACTIVE_FLAG     in varchar2
73   ,X_MULTIPLE_OCCURENCES_FLAG in varchar2
74   ,X_DESCRIPTION              in varchar2
75   ,X_LEGISLATION_CODE         in varchar2
76   ,X_OBJECT_VERSION_NUMBER    in number
77   ,X_OWNER                    in varchar2
78   ,X_LAST_UPDATE_DATE         in varchar2
79   );
80 
81 END PQH_ROLE_INFO_TYPES_PKG;