DBA Data[Home] [Help]

PACKAGE: APPS.WMS_PAGE_FIELDS_PKG

Source


1 package WMS_PAGE_FIELDS_PKG AUTHID CURRENT_USER as
2 /* $Header: WMSPFTHS.pls 115.1 2004/07/01 06:15:32 vsunkesh noship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_PAGE_ID in NUMBER,
7   X_FIELD_ID in NUMBER,
8   X_FIELD_NAME in VARCHAR2,
9   X_FIELD_DISP_SEQUENCE_NUMBER in NUMBER,
10   X_FIELD_PROMPT in VARCHAR2,
11   X_FIELD_TYPE in VARCHAR2,
12   X_FIELD_CONSTRUCTOR_PARAM in VARCHAR2,
13   X_FIELD_CATEGORY in VARCHAR2,
14   X_FIELD_IS_CONFIGURABLE in VARCHAR2,
15   X_FIELD_IS_VISIBLE in VARCHAR2,
16   X_FIELD_PROPERTY1_DEFAULT_VALU in NUMBER,
17   X_FIELD_PROPERTY2_DEFAULT_VALU in NUMBER,
18   X_FIELD_USER_NAME 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_PAGE_ID in NUMBER,
27   X_FIELD_ID in NUMBER,
28   X_FIELD_NAME in VARCHAR2,
29   X_FIELD_DISP_SEQUENCE_NUMBER in NUMBER,
30   X_FIELD_PROMPT in VARCHAR2,
31   X_FIELD_TYPE in VARCHAR2,
32   X_FIELD_CONSTRUCTOR_PARAM in VARCHAR2,
33   X_FIELD_CATEGORY in VARCHAR2,
34   X_FIELD_IS_CONFIGURABLE in VARCHAR2,
35   X_FIELD_IS_VISIBLE in VARCHAR2,
36   X_FIELD_PROPERTY1_DEFAULT_VALU in NUMBER,
37   X_FIELD_PROPERTY2_DEFAULT_VALU in NUMBER,
38   X_FIELD_USER_NAME in VARCHAR2
39 );
40 
41 procedure UPDATE_ROW (
42   X_PAGE_ID in NUMBER,
43   X_FIELD_ID in NUMBER,
44   X_FIELD_NAME in VARCHAR2,
45   X_FIELD_DISP_SEQUENCE_NUMBER in NUMBER,
46   X_FIELD_PROMPT in VARCHAR2,
47   X_FIELD_TYPE in VARCHAR2,
48   X_FIELD_CONSTRUCTOR_PARAM in VARCHAR2,
49   X_FIELD_CATEGORY in VARCHAR2,
50   X_FIELD_IS_CONFIGURABLE in VARCHAR2,
51   X_FIELD_IS_VISIBLE in VARCHAR2,
52   X_FIELD_PROPERTY1_DEFAULT_VALU in NUMBER,
53   X_FIELD_PROPERTY2_DEFAULT_VALU in NUMBER,
54   X_FIELD_USER_NAME 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 TRANSLATE_ROW (
61   X_PAGE_ID in NUMBER,
62   X_FIELD_NAME in VARCHAR2,
63   X_OWNER in VARCHAR2,
64   X_LAST_UPDATE_DATE in DATE,
65   X_FIELD_USER_NAME in VARCHAR2);
66 
67 procedure LOAD_ROW (
68   X_PAGE_ID in NUMBER,
69   X_FIELD_NAME in VARCHAR2,
70   X_OWNER in VARCHAR2,
71   X_LAST_UPDATE_DATE in DATE,
72   X_FIELD_DISP_SEQUENCE_NUMBER in NUMBER,
73   X_FIELD_PROMPT in VARCHAR2,
74   X_FIELD_TYPE in VARCHAR2,
75   X_FIELD_CONSTRUCTOR_PARAM in VARCHAR2,
76   X_FIELD_CATEGORY in VARCHAR2,
77   X_FIELD_IS_CONFIGURABLE in VARCHAR2,
78   X_FIELD_IS_VISIBLE in VARCHAR2,
79   X_FIELD_PROPERTY1_DEFAULT_VALU in NUMBER,
80   X_FIELD_PROPERTY2_DEFAULT_VALU in NUMBER,
81   X_FIELD_USER_NAME in VARCHAR2);
82 
83 
84 
85 
86 procedure DELETE_ROW (
87   X_PAGE_ID in NUMBER,
88   X_FIELD_ID in NUMBER
89 );
90 
91 procedure ADD_LANGUAGE;
92 
93 end WMS_PAGE_FIELDS_PKG;