[Home] [Help]
PACKAGE: APPS.PER_RESTR_VALUES_PKG
Source
1 PACKAGE PER_RESTR_VALUES_PKG AUTHID CURRENT_USER as
2 /* $Header: perpeprv.pkh 115.1 2002/12/06 14:46:14 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_FORM_NAME VARCHAR2,
13 P_NAME VARCHAR2,
14 P_BUSINESS_GROUP_NAME VARCHAR2,
15 P_LEGISLATION_CODE VARCHAR2,
16 P_RESTRICTION_CODE VARCHAR2,
17 P_VALUE VARCHAR2,
18 P_ROWID VARCHAR2);
19
20 procedure INSERT_ROW (
21 X_ROWID in out nocopy VARCHAR2,
22 X_APPLICATION_SHORT_NAME in VARCHAR2,
23 X_FORM_NAME in VARCHAR2,
24 X_NAME in VARCHAR2,
25 X_BUSINESS_GROUP_NAME in VARCHAR2,
26 X_LEGISLATION_CODE in VARCHAR2,
27 X_RESTRICTION_CODE in VARCHAR2,
28 X_VALUE in VARCHAR2,
29 X_CREATION_DATE in DATE,
30 X_CREATED_BY in NUMBER,
31 X_LAST_UPDATE_DATE in DATE,
32 X_LAST_UPDATED_BY in NUMBER,
33 X_LAST_UPDATE_LOGIN in NUMBER);
34
35 procedure LOCK_ROW (
36 X_APPLICATION_SHORT_NAME in VARCHAR2,
37 X_FORM_NAME in VARCHAR2,
38 X_NAME in VARCHAR2,
39 X_BUSINESS_GROUP_NAME in VARCHAR2,
40 X_LEGISLATION_CODE in VARCHAR2,
41 X_RESTRICTION_CODE in VARCHAR2,
42 X_VALUE in VARCHAR2
43 );
44
45 procedure UPDATE_ROW (
46 X_APPLICATION_SHORT_NAME in VARCHAR2,
47 X_FORM_NAME in VARCHAR2,
48 X_NAME in VARCHAR2,
49 X_BUSINESS_GROUP_NAME in VARCHAR2,
50 X_LEGISLATION_CODE in VARCHAR2,
51 X_RESTRICTION_CODE in VARCHAR2,
52 X_VALUE in VARCHAR2,
53 X_RESTRICTION_CODE_NEW in VARCHAR2,
54 X_VALUE_NEW in VARCHAR2,
55 X_LAST_UPDATE_DATE in DATE,
56 X_LAST_UPDATED_BY in NUMBER,
57 X_LAST_UPDATE_LOGIN in NUMBER
58 );
59
60 procedure DELETE_ROW (
61 X_APPLICATION_SHORT_NAME in VARCHAR2,
62 X_FORM_NAME in VARCHAR2,
63 X_NAME in VARCHAR2,
64 X_BUSINESS_GROUP_NAME in VARCHAR2,
65 X_LEGISLATION_CODE in VARCHAR2,
66 X_RESTRICTION_CODE in VARCHAR2,
67 X_VALUE in VARCHAR2
68 );
69
70 procedure LOAD_ROW (
71 X_APPLICATION_SHORT_NAME in VARCHAR2,
72 X_FORM_NAME in VARCHAR2,
73 X_NAME in VARCHAR2,
74 X_BUSINESS_GROUP_NAME in VARCHAR2,
75 X_LEGISLATION_CODE in VARCHAR2,
76 X_RESTRICTION_CODE in VARCHAR2,
77 X_VALUE in VARCHAR2,
78 X_OWNER in VARCHAR2
79 );
80
81 procedure TRANSLATE_ROW (
82 X_APPLICATION_SHORT_NAME in VARCHAR2,
83 X_FORM_NAME in VARCHAR2,
84 X_NAME in VARCHAR2,
85 X_BUSINESS_GROUP_NAME in VARCHAR2,
86 X_LEGISLATION_CODE in VARCHAR2,
87 X_RESTRICTION_CODE in VARCHAR2,
88 X_VALUE in VARCHAR2,
89 X_OWNER in varchar2
90 );
91
92 END PER_RESTR_VALUES_PKG;