[Home] [Help]
PACKAGE: APPS.PER_PEOPLE_INFO_TYPES_SEC_PKG
Source
1 PACKAGE PER_PEOPLE_INFO_TYPES_SEC_PKG AUTHID CURRENT_USER as
2 /* $Header: perpeits.pkh 115.2 2002/12/06 14:11:11 eumenyio noship $ */
3 ------------------------------------------------------------------------------
4 /*
5 ==============================================================================
6
7 25-Sep-00 VTreiger Created.
8 ==============================================================================
9 */
10 ------------------------------------------------------------------------------
11 PROCEDURE UNIQUENESS_CHECK(P_APPLICATION_SHORT_NAME VARCHAR2,
12 P_RESPONSIBILITY_KEY VARCHAR2,
13 P_INFO_TYPE_TABLE_NAME VARCHAR2,
14 P_INFORMATION_TYPE VARCHAR2,
15 P_ROWID VARCHAR2);
16
17 procedure INSERT_ROW (
18 X_ROWID in out nocopy VARCHAR2,
19 X_APPLICATION_SHORT_NAME in VARCHAR2,
20 X_RESPONSIBILITY_KEY in VARCHAR2,
21 X_INFO_TYPE_TABLE_NAME in VARCHAR2,
22 X_INFORMATION_TYPE in VARCHAR2,
23 X_OBJECT_VERSION_NUMBER in NUMBER,
24 X_CREATION_DATE in DATE,
25 X_CREATED_BY in NUMBER,
26 X_LAST_UPDATE_DATE in DATE,
27 X_LAST_UPDATED_BY in NUMBER,
28 X_LAST_UPDATE_LOGIN in NUMBER);
29
30 procedure LOCK_ROW (
31 X_APPLICATION_SHORT_NAME in VARCHAR2,
32 X_RESPONSIBILITY_KEY in VARCHAR2,
33 X_INFO_TYPE_TABLE_NAME in VARCHAR2,
34 X_INFORMATION_TYPE in VARCHAR2,
35 X_OBJECT_VERSION_NUMBER in NUMBER
36 );
37
38 procedure UPDATE_ROW (
39 X_APPLICATION_SHORT_NAME in VARCHAR2,
40 X_RESPONSIBILITY_KEY in VARCHAR2,
41 X_INFO_TYPE_TABLE_NAME in VARCHAR2,
42 X_INFORMATION_TYPE in VARCHAR2,
43 X_INFORMATION_TYPE_NEW in VARCHAR2,
44 X_OBJECT_VERSION_NUMBER in NUMBER,
45 X_LAST_UPDATE_DATE in DATE,
46 X_LAST_UPDATED_BY in NUMBER,
47 X_LAST_UPDATE_LOGIN in NUMBER
48 );
49
50 procedure DELETE_ROW (
51 X_APPLICATION_SHORT_NAME in VARCHAR2,
52 X_RESPONSIBILITY_KEY in VARCHAR2,
53 X_INFO_TYPE_TABLE_NAME in VARCHAR2,
54 X_INFORMATION_TYPE in VARCHAR2
55 );
56
57 procedure LOAD_ROW (
58 X_APPLICATION_SHORT_NAME in VARCHAR2,
59 X_RESPONSIBILITY_KEY in VARCHAR2,
60 X_INFO_TYPE_TABLE_NAME in VARCHAR2,
61 X_INFORMATION_TYPE in VARCHAR2,
62 X_INFORMATION_TYPE_NEW in VARCHAR2,
63 X_OBJECT_VERSION_NUMBER in NUMBER,
64 X_OWNER in VARCHAR2
65 );
66
67 procedure TRANSLATE_ROW
68 (X_APPLICATION_SHORT_NAME in VARCHAR2
69 ,X_RESPONSIBILITY_KEY in VARCHAR2
70 ,X_INFO_TYPE_TABLE_NAME in VARCHAR2
71 ,X_INFORMATION_TYPE in varchar2
72 ,X_DESCRIPTION in varchar2
73 ,X_OWNER in varchar2
74 );
75
76 END PER_PEOPLE_INFO_TYPES_SEC_PKG;