DBA Data[Home] [Help]

PACKAGE: APPS.PER_CUSTOMIZED_RESTR_PKG

Source


1 PACKAGE PER_CUSTOMIZED_RESTR_PKG AUTHID CURRENT_USER as
2 /* $Header: perpepcr.pkh 115.3 2003/07/03 13:21:50 tvankayl noship $ */
3 ------------------------------------------------------------------------------
4 /*
5 ==============================================================================
6 
7          25-Sep-00      VTreiger       Created.
8 	 01-JUL-03      tvankayl       Modified table handles Insert_row,
9 				       Update_Row , Lock_ Row , Delete_row
10 
11 				       1. prototypes were changed to follow
12 					  AOL standards.
13 				       2. DML operations were applied on
14 				          Translation table also.
15 
16 					  Load_row and Translate_row were
17 				          modified to compensate for changes in
18 					  insert_row and update_row
19 115.3     03-JUL-03      tvankayl       removed the unnecessary comments.
20 
21 ==============================================================================
22                                                                             */
23 ------------------------------------------------------------------------------
24 
25 PROCEDURE UNIQUENESS_CHECK(P_APPLICATION_SHORT_NAME VARCHAR2,
26                            P_FORM_NAME              VARCHAR2,
27                            P_NAME                   VARCHAR2,
28                            P_BUSINESS_GROUP_NAME    VARCHAR2,
29                            P_LEGISLATION_CODE       VARCHAR2,
30                            P_ROWID                  VARCHAR2);
31 
32 procedure INSERT_ROW (
33   X_ROWID in out nocopy VARCHAR2,
34   X_CUSTOMIZED_RESTRICTION_ID in out nocopy NUMBER,
35   X_BUSINESS_GROUP_ID in NUMBER,
36   X_LEGISLATION_CODE in VARCHAR2,
37   X_APPLICATION_ID in NUMBER,
38   X_FORM_NAME in VARCHAR2,
39   X_ENABLED_FLAG in VARCHAR2,
40   X_NAME in VARCHAR2,
41   X_COMMENTS in LONG,
42   X_LEGISLATION_SUBGROUP in VARCHAR2,
43   X_QUERY_FORM_TITLE in VARCHAR2,
44   X_STANDARD_FORM_TITLE in VARCHAR2,
45   X_CREATION_DATE in DATE,
46   X_CREATED_BY in NUMBER,
47   X_LAST_UPDATE_DATE in DATE,
48   X_LAST_UPDATED_BY in NUMBER,
49   X_LAST_UPDATE_LOGIN in NUMBER
50 );
51 
52 procedure LOCK_ROW (
53   X_CUSTOMIZED_RESTRICTION_ID in NUMBER,
54   X_BUSINESS_GROUP_ID in NUMBER,
55   X_LEGISLATION_CODE in VARCHAR2,
56   X_APPLICATION_ID in NUMBER,
57   X_FORM_NAME in VARCHAR2,
58   X_ENABLED_FLAG in VARCHAR2,
59   X_NAME in VARCHAR2,
60   X_COMMENTS in LONG,
61   X_LEGISLATION_SUBGROUP in VARCHAR2,
62   X_QUERY_FORM_TITLE in VARCHAR2,
63   X_STANDARD_FORM_TITLE in VARCHAR2
64 );
65 
66 
67 procedure UPDATE_ROW (
68   X_CUSTOMIZED_RESTRICTION_ID in NUMBER,
69   X_BUSINESS_GROUP_ID in NUMBER,
70   X_LEGISLATION_CODE in VARCHAR2,
71   X_APPLICATION_ID in NUMBER,
72   X_FORM_NAME in VARCHAR2,
73   X_ENABLED_FLAG in VARCHAR2,
74   X_NAME in VARCHAR2,
75   X_COMMENTS in LONG,
76   X_LEGISLATION_SUBGROUP in VARCHAR2,
77   X_QUERY_FORM_TITLE in VARCHAR2,
78   X_STANDARD_FORM_TITLE in VARCHAR2,
79   X_LAST_UPDATE_DATE in DATE,
80   X_LAST_UPDATED_BY in NUMBER,
81   X_LAST_UPDATE_LOGIN in NUMBER
82 );
83 
84 
85 procedure DELETE_ROW (
86   X_CUSTOMIZED_RESTRICTION_ID in NUMBER
87 );
88 
89 
90 procedure LOAD_ROW
91   (X_APPLICATION_SHORT_NAME   in varchar2,
92   X_FORM_NAME in VARCHAR2,
93   X_NAME in VARCHAR2,
94   X_BUSINESS_GROUP_NAME in VARCHAR2,
95   X_LEGISLATION_CODE in VARCHAR2,
96   X_ENABLED_FLAG in VARCHAR2,
97   X_QUERY_FORM_TITLE in VARCHAR2,
98   X_STANDARD_FORM_TITLE in VARCHAR2,
99   X_LEGISLATION_SUBGROUP in VARCHAR2,
100   X_OWNER in VARCHAR2
101   );
102 
103 
104 procedure TRANSLATE_ROW
105   (X_APPLICATION_SHORT_NAME in varchar2,
106   X_FORM_NAME in VARCHAR2,
107   X_NAME in VARCHAR2,
108   X_BUSINESS_GROUP_NAME in VARCHAR2,
109   X_LEGISLATION_CODE in VARCHAR2,
110   X_QUERY_FORM_TITLE in VARCHAR2,
111   X_STANDARD_FORM_TITLE in VARCHAR2,
112   X_OWNER            in varchar2
113   );
114 
115 
116 procedure ADD_LANGUAGE;
117 
118 END PER_CUSTOMIZED_RESTR_PKG;