APPS.FND_FLEX_TRIGGER dependencies on FND_FLEX_EXCLUDE_RULE_LINES

Line 197: insert into FND_FLEX_EXCLUDE_RULE_LINES

193: lo(29), hi(29), lo(30), hi(30));
194: else
195: new_include_lines := 0;
196: new_exclude_lines := 1;
197: insert into FND_FLEX_EXCLUDE_RULE_LINES
198: (RULE_LINE_ID, APPLICATION_ID, ID_FLEX_CODE, ID_FLEX_NUM,
199: FLEX_VALIDATION_RULE_NAME, ENABLED_FLAG, CREATED_BY, CREATION_DATE,
200: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
201: SEGMENT1_LOW, SEGMENT1_HIGH, SEGMENT2_LOW, SEGMENT2_HIGH,

Line 264: DELETE FROM fnd_flex_exclude_rule_lines

260: WHERE rule_line_id = ruleline_id;
261: else
262: new_include_lines := 0;
263: new_exclude_lines := -1;
264: DELETE FROM fnd_flex_exclude_rule_lines
265: WHERE rule_line_id = ruleline_id;
266: end if;
267:
268: return(update_cvr_stats(appid, flex_code, flex_num, 0,

Line 322: FROM fnd_flex_exclude_rule_lines

318: not_incl_excl := 'E';
319: end if;
320: else
321: SELECT count(*) INTO nlines
322: FROM fnd_flex_exclude_rule_lines
323: WHERE rule_line_id = ruleline_id;
324: if(nlines = 0) then
325: not_incl_excl := 'I';
326: end if;

Line 390: UPDATE fnd_flex_exclude_rule_lines

386: SEGMENT29_LOW = lo(29), SEGMENT29_HIGH = hi(29),
387: SEGMENT30_LOW = lo(30), SEGMENT30_HIGH = hi(30)
388: WHERE rule_line_id = ruleline_id;
389: else
390: UPDATE fnd_flex_exclude_rule_lines
391: SET application_id = appid, id_flex_code = flex_code,
392: id_flex_num = flex_num, flex_validation_rule_name = rule_name,
393: enabled_flag = enab_flag, created_by = create_by,
394: creation_date = create_date, last_update_date = update_date,