1 PACKAGE AME_APPROVER_TYPES_API AS
2 /* $Header: ameapapi.pkh 120.0 2005/07/26 05:53:20 mbocutt noship $ */
3
4 procedure INSERT_ROW (
5 X_APPROVER_TYPE_ID in NUMBER,
6 X_ORIG_SYSTEM in VARCHAR2,
7 X_QUERY_VARIABLE_1_LABEL in VARCHAR2,
8 X_QUERY_VARIABLE_2_LABEL in VARCHAR2,
9 X_QUERY_VARIABLE_3_LABEL in VARCHAR2,
10 X_QUERY_VARIABLE_4_LABEL in VARCHAR2,
11 X_QUERY_VARIABLE_5_LABEL in VARCHAR2,
12 X_VARIABLE_1_LOV_QUERY in VARCHAR2,
13 X_VARIABLE_2_LOV_QUERY in VARCHAR2,
14 X_VARIABLE_3_LOV_QUERY in VARCHAR2,
15 X_VARIABLE_4_LOV_QUERY in VARCHAR2,
16 X_VARIABLE_5_LOV_QUERY in VARCHAR2,
17 X_QUERY_PROCEDURE in VARCHAR2,
18 X_CREATED_BY in NUMBER,
19 X_CREATION_DATE in DATE,
20 X_LAST_UPDATED_BY in NUMBER,
21 X_LAST_UPDATE_DATE in DATE,
22 X_LAST_UPDATE_LOGIN in NUMBER,
23 X_START_DATE in DATE,
24 X_OBJECT_VERSION_NUMBER in NUMBER);
25
26 procedure UPDATE_ROW (
27 X_APPROVER_TYPE_ROWID in VARCHAR2,
28 X_END_DATE in DATE);
29
30 procedure DELETE_ROW (
31 X_APPROVER_TYPE_ID in NUMBER);
32
33 procedure LOAD_ROW (
34 X_ORIG_SYSTEM in VARCHAR2,
35 X_QUERY_VARIABLE_1_LABEL in VARCHAR2,
36 X_QUERY_VARIABLE_2_LABEL in VARCHAR2,
37 X_QUERY_VARIABLE_3_LABEL in VARCHAR2,
38 X_QUERY_VARIABLE_4_LABEL in VARCHAR2,
39 X_QUERY_VARIABLE_5_LABEL in VARCHAR2,
40 X_VARIABLE_1_LOV_QUERY in VARCHAR2,
41 X_VARIABLE_2_LOV_QUERY in VARCHAR2,
42 X_VARIABLE_3_LOV_QUERY in VARCHAR2,
43 X_VARIABLE_4_LOV_QUERY in VARCHAR2,
44 X_VARIABLE_5_LOV_QUERY in VARCHAR2,
45 X_QUERY_PROCEDURE in VARCHAR2,
46 X_OWNER in VARCHAR2,
47 X_LAST_UPDATE_DATE in VARCHAR2,
48 X_CUSTOM_MODE in VARCHAR2);
49
50 END AME_APPROVER_TYPES_API;