1 package AMS_CUSTOM_SETUP_ATTR_PKG AUTHID CURRENT_USER as
2 /* $Header: amslatts.pls 115.9 2004/04/08 22:50:57 asaha ship $ */
3 PROCEDURE INSERT_ROW (
4 X_ROWID IN OUT NOCOPY VARCHAR2,
5 X_SETUP_ATTRIBUTE_ID IN NUMBER,
6 X_OBJECT_VERSION_NUMBER IN NUMBER,
7 X_CUSTOM_SETUP_ID IN NUMBER,
8 X_DISPLAY_SEQUENCE_NO IN NUMBER,
9 X_OBJECT_ATTRIBUTE IN VARCHAR2,
10 X_ATTR_MANDATORY_FLAG IN VARCHAR2,
11 X_ATTR_AVAILABLE_FLAG IN VARCHAR2,
12 X_PARENT_FUNCTION_NAME in VARCHAR2,
13 X_FUNCTION_NAME in VARCHAR2,
14 X_PARENT_SETUP_ATTRIBUTE in VARCHAR2,
15 X_PARENT_DISPLAY_SEQUENCE in NUMBER,
16 X_SHOW_IN_REPORT in VARCHAR2,
17 X_SHOW_IN_CUE_CARD in VARCHAR2,
18 X_COPY_ALLOWED_FLAG in VARCHAR2,
19 X_RELATED_AK_ATTRIBUTE in VARCHAR2,
20 X_CREATION_DATE IN DATE,
21 X_CREATED_BY IN NUMBER,
22 X_LAST_UPDATE_DATE IN DATE,
23 X_LAST_UPDATED_BY IN NUMBER,
24 X_LAST_UPDATE_LOGIN IN NUMBER,
25 X_ESSENTIAL_SEQ_NUM IN NUMBER
26 );
27
28 PROCEDURE UPDATE_ROW (
29 X_SETUP_ATTRIBUTE_ID IN NUMBER,
30 X_OBJECT_VERSION_NUMBER IN NUMBER,
31 X_CUSTOM_SETUP_ID IN NUMBER,
32 X_DISPLAY_SEQUENCE_NO IN NUMBER,
33 X_OBJECT_ATTRIBUTE IN VARCHAR2,
34 X_ATTR_MANDATORY_FLAG IN VARCHAR2,
35 X_ATTR_AVAILABLE_FLAG IN VARCHAR2,
36 X_PARENT_FUNCTION_NAME in VARCHAR2,
37 X_FUNCTION_NAME in VARCHAR2,
38 X_PARENT_SETUP_ATTRIBUTE in VARCHAR2,
39 X_PARENT_DISPLAY_SEQUENCE in NUMBER,
40 X_SHOW_IN_REPORT in VARCHAR2,
41 X_SHOW_IN_CUE_CARD in VARCHAR2,
42 X_COPY_ALLOWED_FLAG in VARCHAR2,
43 X_RELATED_AK_ATTRIBUTE in VARCHAR2,
44 X_LAST_UPDATE_DATE IN DATE,
45 X_LAST_UPDATED_BY IN NUMBER,
46 X_LAST_UPDATE_LOGIN IN NUMBER,
47 X_ESSENTIAL_SEQ_NUM IN NUMBER
48 );
49
50 PROCEDURE DELETE_ROW (
51 X_SETUP_ATTRIBUTE_ID IN NUMBER
52 );
53
54 PROCEDURE LOAD_ROW(
55 X_SETUP_ATTRIBUTE_ID IN NUMBER,
56 X_CUSTOM_SETUP_ID IN NUMBER,
57 X_DISPLAY_SEQUENCE_NO IN NUMBER,
58 X_OBJECT_ATTRIBUTE IN VARCHAR2,
59 X_ATTR_MANDATORY_FLAG IN VARCHAR2,
60 X_ATTR_AVAILABLE_FLAG IN VARCHAR2,
61 X_PARENT_FUNCTION_NAME in VARCHAR2,
62 X_FUNCTION_NAME in VARCHAR2,
63 X_PARENT_SETUP_ATTRIBUTE in VARCHAR2,
64 X_PARENT_DISPLAY_SEQUENCE in NUMBER,
65 X_SHOW_IN_REPORT in VARCHAR2,
66 X_SHOW_IN_CUE_CARD in VARCHAR2,
67 X_COPY_ALLOWED_FLAG in VARCHAR2,
68 X_RELATED_AK_ATTRIBUTE in VARCHAR2,
69 X_ESSENTIAL_SEQ_NUM IN NUMBER,
70 X_OWNER IN VARCHAR2,
71 x_custom_mode IN VARCHAR2,
72 X_LAST_UPDATE_DATE in DATE
73 );
74
75 END AMS_CUSTOM_SETUP_ATTR_PKG;