APPS.FND_FLEX_TRIGGER dependencies on FND_FLEX_INCLUDE_RULE_LINES

Line 164: insert into FND_FLEX_INCLUDE_RULE_LINES

160:
161: if(incl_excl = 'I') then
162: new_include_lines := 1;
163: new_exclude_lines := 0;
164: insert into FND_FLEX_INCLUDE_RULE_LINES
165: (RULE_LINE_ID, APPLICATION_ID, ID_FLEX_CODE, ID_FLEX_NUM,
166: FLEX_VALIDATION_RULE_NAME, ENABLED_FLAG, CREATED_BY, CREATION_DATE,
167: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
168: SEGMENT1_LOW, SEGMENT1_HIGH, SEGMENT2_LOW, SEGMENT2_HIGH,

Line 259: DELETE FROM fnd_flex_include_rule_lines

255: BEGIN
256: if(incl_excl = 'I') then
257: new_include_lines := -1;
258: new_exclude_lines := 0;
259: DELETE FROM fnd_flex_include_rule_lines
260: WHERE rule_line_id = ruleline_id;
261: else
262: new_include_lines := 0;
263: new_exclude_lines := -1;

Line 315: FROM fnd_flex_include_rule_lines

311: -- or to 'E' if exclude changed to exclude.
312: --
313: if(incl_excl = 'I') then
314: SELECT count(*) INTO nlines
315: FROM fnd_flex_include_rule_lines
316: WHERE rule_line_id = ruleline_id;
317: if(nlines = 0) then
318: not_incl_excl := 'E';
319: end if;

Line 352: UPDATE fnd_flex_include_rule_lines

348: return(FALSE);
349: end if;
350:
351: if(incl_excl = 'I') then
352: UPDATE fnd_flex_include_rule_lines
353: SET application_id = appid, id_flex_code = flex_code,
354: id_flex_num = flex_num, flex_validation_rule_name = rule_name,
355: enabled_flag = enab_flag, created_by = create_by,
356: creation_date = create_date, last_update_date = update_date,