1 package FND_LOOKUP_ASSIGNMENTS_PKG AUTHID CURRENT_USER as
2 /* $Header: AFLVFLAS.pls 115.0 2004/08/04 21:03:20 stopiwal noship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out nocopy VARCHAR2,
5 X_LOOKUP_ASSIGNMENT_ID in NUMBER,
6 X_INSTANCE_PK1_VALUE in VARCHAR2,
7 X_OBJ_NAME in VARCHAR2,
8 X_INSTANCE_PK4_VALUE in VARCHAR2,
9 X_INSTANCE_PK5_VALUE in VARCHAR2,
10 X_DISPLAY_SEQUENCE in NUMBER,
11 X_LOOKUP_CODE in VARCHAR2,
12 X_LOOKUP_TYPE in VARCHAR2,
13 X_INSTANCE_PK2_VALUE in VARCHAR2,
14 X_INSTANCE_PK3_VALUE in VARCHAR2,
15 X_CREATION_DATE in DATE,
16 X_CREATED_BY in NUMBER,
17 X_LAST_UPDATE_DATE in DATE,
18 X_LAST_UPDATED_BY in NUMBER,
19 X_LAST_UPDATE_LOGIN in NUMBER);
20 procedure LOCK_ROW (
21 X_LOOKUP_ASSIGNMENT_ID in NUMBER,
22 X_INSTANCE_PK1_VALUE in VARCHAR2,
23 X_OBJ_NAME in VARCHAR2,
24 X_INSTANCE_PK4_VALUE in VARCHAR2,
25 X_INSTANCE_PK5_VALUE in VARCHAR2,
26 X_DISPLAY_SEQUENCE in NUMBER,
27 X_LOOKUP_CODE in VARCHAR2,
28 X_LOOKUP_TYPE in VARCHAR2,
29 X_INSTANCE_PK2_VALUE in VARCHAR2,
30 X_INSTANCE_PK3_VALUE in VARCHAR2
31 );
32 procedure UPDATE_ROW (
33 X_LOOKUP_ASSIGNMENT_ID in NUMBER,
34 X_INSTANCE_PK1_VALUE in VARCHAR2,
35 X_OBJ_NAME in VARCHAR2,
36 X_INSTANCE_PK4_VALUE in VARCHAR2,
37 X_INSTANCE_PK5_VALUE in VARCHAR2,
38 X_DISPLAY_SEQUENCE in NUMBER,
39 X_LOOKUP_CODE in VARCHAR2,
40 X_LOOKUP_TYPE in VARCHAR2,
41 X_INSTANCE_PK2_VALUE in VARCHAR2,
42 X_INSTANCE_PK3_VALUE in VARCHAR2,
43 X_LAST_UPDATE_DATE in DATE,
44 X_LAST_UPDATED_BY in NUMBER,
45 X_LAST_UPDATE_LOGIN in NUMBER
46 );
47 procedure DELETE_ROW (
48 X_LOOKUP_ASSIGNMENT_ID in NUMBER
49 );
50 procedure Load_Row (
51 x_lookup_type in varchar2,
52 x_lookup_code in varchar2,
53 x_obj_name in varchar2,
54 x_display_sequence in varchar2,
55 X_INSTANCE_PK1_VALUE in varchar2,
56 X_INSTANCE_PK2_VALUE in varchar2,
57 X_INSTANCE_PK3_VALUE in varchar2,
58 X_INSTANCE_PK4_VALUE in varchar2,
59 X_INSTANCE_PK5_VALUE in varchar2,
60 x_last_update_date in varchar2,
61 x_owner in varchar2,
62 x_custom_mode in varchar2
63 );
64 end FND_LOOKUP_ASSIGNMENTS_PKG;