APPS.EDW_FLEX_SEG_MAPPING_LINES_PKG dependencies on BIS_FLEX_SEG_MAPPING_LINES

Line 24: cursor C is select ROWID from BIS_FLEX_SEG_MAPPING_LINES

20: X_LAST_UPDATED_BY in NUMBER,
21: X_LAST_UPDATE_LOGIN in NUMBER
22: ) is
23:
24: cursor C is select ROWID from BIS_FLEX_SEG_MAPPING_LINES
25: where seg_mapping_line_id = X_seg_mapping_line_id;
26:
27:
28: begin

Line 29: insert into BIS_FLEX_SEG_MAPPING_LINES (

25: where seg_mapping_line_id = X_seg_mapping_line_id;
26:
27:
28: begin
29: insert into BIS_FLEX_SEG_MAPPING_LINES (
30: SEG_MAPPING_LINE_ID,
31: INSTANCE_CODE,
32: STRUCTURE_NUM,
33: STRUCTURE_NAME,

Line 104: from BIS_FLEX_SEG_MAPPING_LINES

100: ID_FLEX_CODE,
101: DIMENSION_ID,
102: LEVEL_ID,
103: WH_DIMENSION_NAME
104: from BIS_FLEX_SEG_MAPPING_LINES
105: where seg_mapping_line_id = X_seg_mapping_line_id
106: for update of SEG_MAPPING_LINE_ID nowait;
107: recinfo c%rowtype;
108:

Line 156: update BIS_FLEX_SEG_MAPPING_LINES set

152: X_LAST_UPDATED_BY in NUMBER,
153: X_LAST_UPDATE_LOGIN in NUMBER
154: ) is
155: begin
156: update BIS_FLEX_SEG_MAPPING_LINES set
157: INSTANCE_CODE = X_INSTANCE_CODE,
158: STRUCTURE_NUM = X_STRUCTURE_NUM,
159: STRUCTURE_NAME = X_STRUCTURE_NAME,
160: VALUE_SET_ID = X_VALUE_SET_ID,

Line 185: delete from BIS_FLEX_SEG_MAPPING_LINES

181: procedure DELETE_ROW (
182: X_SEG_MAPPING_LINE_ID in NUMBER
183: ) is
184: begin
185: delete from BIS_FLEX_SEG_MAPPING_LINES
186: where seg_mapping_line_id = X_seg_mapping_line_id;
187:
188:
189: if (sql%notfound) then