1 PACKAGE ams_list_src_types_pkg AS
2 /* $Header: amsllsts.pls 120.1 2005/09/06 12:36:56 vbhandar noship $ */
3
4 PROCEDURE insert_row (
5 X_ROWID in OUT NOCOPY VARCHAR2,
6 X_LIST_SOURCE_TYPE_ID in NUMBER,
7 X_OBJECT_VERSION_NUMBER in NUMBER,
8 X_LIST_SOURCE_NAME in VARCHAR2,
9 X_LIST_SOURCE_TYPE in VARCHAR2,
10 X_SOURCE_TYPE_CODE in VARCHAR2,
11 X_SOURCE_OBJECT_NAME in VARCHAR2,
12 X_MASTER_SOURCE_TYPE_FLAG in VARCHAR2,
13 X_SOURCE_OBJECT_PK_FIELD in VARCHAR2,
14 X_ENABLED_FLAG in VARCHAR2,
15 X_DESCRIPTION in VARCHAR2,
16 X_JAVA_CLASS_NAME IN VARCHAR2,
17 x_view_application_id in number,
18 x_ARC_ACT_SRC_USED_BY in varchar2,
19 x_SOURCE_CATEGORY in varchar2,
20 x_import_type in varchar2,
21 X_CREATION_DATE in DATE,
22 X_CREATED_BY in NUMBER,
23 X_LAST_UPDATE_DATE in DATE,
24 X_LAST_UPDATED_BY in NUMBER,
25 X_LAST_UPDATE_LOGIN in NUMBER,
26 X_BASED_ON_TCA_FLAG IN varchar2
27 );
28
29 PROCEDURE lock_row (
30 X_LIST_SOURCE_TYPE_ID in NUMBER,
31 X_OBJECT_VERSION_NUMBER in NUMBER,
32 X_LIST_SOURCE_NAME in VARCHAR2,
33 X_LIST_SOURCE_TYPE in VARCHAR2,
34 X_SOURCE_TYPE_CODE in VARCHAR2,
35 X_SOURCE_OBJECT_NAME in VARCHAR2,
36 X_MASTER_SOURCE_TYPE_FLAG in VARCHAR2,
37 X_SOURCE_OBJECT_PK_FIELD in VARCHAR2,
38 X_ENABLED_FLAG in VARCHAR2,
39 X_DESCRIPTION in VARCHAR2,
40 X_JAVA_CLASS_NAME IN VARCHAR2,
41 x_view_application_id in number,
42 x_ARC_ACT_SRC_USED_BY in varchar2,
43 x_SOURCE_CATEGORY in varchar2,
44 x_IMPORT_TYPE in varchar2,
45 x_BASED_ON_TCA_FLAG IN varchar2
46 );
47
48 PROCEDURE update_row (
49 X_LIST_SOURCE_TYPE_ID in NUMBER,
50 X_OBJECT_VERSION_NUMBER in NUMBER,
51 X_LIST_SOURCE_NAME in VARCHAR2,
52 X_LIST_SOURCE_TYPE in VARCHAR2,
53 X_SOURCE_TYPE_CODE in VARCHAR2,
54 X_SOURCE_OBJECT_NAME in VARCHAR2,
55 X_MASTER_SOURCE_TYPE_FLAG in VARCHAR2,
56 X_SOURCE_OBJECT_PK_FIELD in VARCHAR2,
57 X_ENABLED_FLAG in VARCHAR2,
58 X_DESCRIPTION in VARCHAR2,
59 X_JAVA_CLASS_NAME IN VARCHAR2,
60 x_view_application_id in number,
61 x_ARC_ACT_SRC_USED_BY in varchar2,
62 x_SOURCE_CATEGORY in varchar2,
63 x_IMPORT_TYPE in varchar2,
64 X_LAST_UPDATE_DATE in DATE,
65 X_LAST_UPDATED_BY in NUMBER,
66 X_LAST_UPDATE_LOGIN in NUMBER,
67 x_BASED_ON_TCA_FLAG IN varchar2
68 );
69
70 PROCEDURE delete_row (
71 X_LIST_SOURCE_TYPE_ID in NUMBER
72 );
73
74 PROCEDURE load_row (
75 X_LIST_SOURCE_TYPE_ID in NUMBER,
76 X_LIST_SOURCE_NAME in VARCHAR2,
77 X_LIST_SOURCE_TYPE in VARCHAR2,
78 X_SOURCE_TYPE_CODE in VARCHAR2,
79 X_SOURCE_OBJECT_NAME in VARCHAR2,
80 X_MASTER_SOURCE_TYPE_FLAG in VARCHAR2,
81 X_SOURCE_OBJECT_PK_FIELD in VARCHAR2,
82 X_ENABLED_FLAG in VARCHAR2,
83 X_DESCRIPTION in VARCHAR2,
84 X_JAVA_CLASS_NAME IN VARCHAR2,
85 x_view_application_id in number,
86 x_ARC_ACT_SRC_USED_BY in varchar2,
87 x_SOURCE_CATEGORY in varchar2,
88 x_import_type in varchar2,
89 x_owner IN VARCHAR2,
90 x_custom_mode IN VARCHAR2,
91 x_BASED_ON_TCA_FLAG IN varchar2
92 );
93
94 procedure ADD_LANGUAGE;
95 procedure TRANSLATE_ROW(
96 X_LIST_SOURCE_TYPE_ID in NUMBER,
97 X_LIST_SOURCE_NAME in VARCHAR2,
98 X_DESCRIPTION in VARCHAR2,
99 x_owner in VARCHAR2,
100 x_custom_mode IN VARCHAR2
101 ) ;
102 END ams_list_src_types_pkg;