PACKAGE: APPS.EDW_FLEX_SEG_MAPPING_LINES_PKG

Source

1 package EDW_FLEX_SEG_MAPPING_LINES_PKG AUTHID CURRENT_USER as
2 /* $Header: EDWFMLIS.pls 115.1 99/07/17 16:18:40 porting ship  $ */
3 procedure INSERT_ROW (
4   X_ROWID in out VARCHAR2,
5   X_SEG_MAPPING_LINE_ID in NUMBER,
6   X_INSTANCE_CODE in VARCHAR2,
7   X_STRUCTURE_NUM in NUMBER,
8   X_STRUCTURE_NAME in VARCHAR2,
9   X_VALUE_SET_ID in NUMBER,
10   X_SEGMENT_NAME in VARCHAR2,
11   X_APPLICATION_ID in NUMBER,
12   X_ID_FLEX_CODE in VARCHAR2,
13   X_APPLICATION_COLUMN_NAME in VARCHAR2,
14   X_DIMENSION_ID in NUMBER,
15   X_LEVEL_ID  in NUMBER,
16   X_WH_DIMENSION_NAME in VARCHAR2,
17   X_CREATION_DATE in DATE,
18   X_CREATED_BY in NUMBER,
19   X_LAST_UPDATE_DATE in DATE,
20   X_LAST_UPDATED_BY in NUMBER,
21   X_LAST_UPDATE_LOGIN in NUMBER);
22 
23 
24 procedure LOCK_ROW (
25   X_SEG_MAPPING_LINE_ID in NUMBER,
26   X_INSTANCE_CODE in VARCHAR2,
27   X_STRUCTURE_NUM in NUMBER,
28   X_STRUCTURE_NAME in VARCHAR2,
29   X_VALUE_SET_ID in NUMBER,
30   X_SEGMENT_NAME in VARCHAR2,
31   X_APPLICATION_ID in NUMBER,
32   X_ID_FLEX_CODE in VARCHAR2,
33   X_APPLICATION_COLUMN_NAME in VARCHAR2,
34   X_DIMENSION_ID in NUMBER,
35   X_LEVEL_ID  in NUMBER,
36   X_WH_DIMENSION_NAME in VARCHAR2
37 );
38 
39 
40 
41 procedure UPDATE_ROW (
42   X_SEG_MAPPING_LINE_ID in NUMBER,
43   X_INSTANCE_CODE in VARCHAR2,
44   X_STRUCTURE_NUM in NUMBER,
45   X_STRUCTURE_NAME in VARCHAR2,
46   X_VALUE_SET_ID in NUMBER,
47   X_SEGMENT_NAME in VARCHAR2,
48   X_APPLICATION_ID in NUMBER,
49   X_ID_FLEX_CODE in VARCHAR2,
50   X_APPLICATION_COLUMN_NAME in VARCHAR2,
51   X_DIMENSION_ID in NUMBER,
52   X_LEVEL_ID  in NUMBER,
53   X_WH_DIMENSION_NAME in VARCHAR2,
54   X_LAST_UPDATE_DATE in DATE,
55   X_LAST_UPDATED_BY in NUMBER,
56   X_LAST_UPDATE_LOGIN in NUMBER
57 );
58 
59 
60 
61 procedure DELETE_ROW (
62   X_SEG_MAPPING_LINE_ID in NUMBER
63 );
64 
65 
66 end EDW_FLEX_SEG_MAPPING_LINES_PKG;