APPS.ITG_SYNCCOAINBOUND_PVT dependencies on FND_FLEX_VALUES

Line 13: flex_value_id fnd_flex_values.flex_value_id%TYPE,

9:
10: /* SEE AFQUTILB.pls: FND_IP_UTIL_PKG.processFlexValue() */
11:
12: TYPE flex_val_rec_type IS RECORD (
13: flex_value_id fnd_flex_values.flex_value_id%TYPE,
14: enabled_flag fnd_flex_values.enabled_flag%TYPE
15: );
16:
17: TYPE flex_val_tbl_type IS TABLE OF flex_val_rec_type INDEX BY BINARY_INTEGER;

Line 14: enabled_flag fnd_flex_values.enabled_flag%TYPE

10: /* SEE AFQUTILB.pls: FND_IP_UTIL_PKG.processFlexValue() */
11:
12: TYPE flex_val_rec_type IS RECORD (
13: flex_value_id fnd_flex_values.flex_value_id%TYPE,
14: enabled_flag fnd_flex_values.enabled_flag%TYPE
15: );
16:
17: TYPE flex_val_tbl_type IS TABLE OF flex_val_rec_type INDEX BY BINARY_INTEGER;
18:

Line 29: FROM fnd_flex_values

25: IS
26: CURSOR flex_data_csr IS
27: SELECT flex_value_id,
28: enabled_flag
29: FROM fnd_flex_values
30: WHERE flex_value = p_flex_value
31: AND flex_value_set_id = p_vset_id;
32:
33: l_found BOOLEAN := FALSE;

Line 129: l_comp_attrs FND_FLEX_VALUES.compiled_value_attributes%TYPE;

125: IS
126: l_api_name CONSTANT VARCHAR2(30) := 'Add_FlexValue';
127: l_api_version CONSTANT NUMBER := 1.0;
128: l_flex_val_tbl flex_val_tbl_type;
129: l_comp_attrs FND_FLEX_VALUES.compiled_value_attributes%TYPE;
130: l_next_id NUMBER;
131: l_rowid VARCHAR2(100);
132: l_creation_date DATE;
133:

Line 223: SELECT fnd_flex_values_s.nextval

219: l_comp_attrs := 'Y'||fnd_global.local_chr(10)||'Y';
220: END IF;
221:
222: /* next flex value id. */
223: SELECT fnd_flex_values_s.nextval
224: INTO l_next_id
225: FROM dual;
226:
227: l_creation_date := nvl(p_creation_date, SYSDATE);

Line 235: FND_FLEX_VALUES_PKG.insert_row(

231: itg_debug_pub.Add('Inserting flex value row.' ,1);
232: END IF;
233:
234: g_action := 'Flex-value insert';
235: FND_FLEX_VALUES_PKG.insert_row(
236: x_rowid => l_rowid,
237: x_flex_value_id => l_next_id,
238: x_flex_value_set_id => p_vset_id,
239: x_flex_value => p_flex_value,

Line 381: UPDATE fnd_flex_values

377:
378: WHILE l_next_id IS NOT NULL LOOP
379: l_value_id := l_flex_val_tbl(l_next_id).flex_value_id;
380: /* Do the flex_value... */
381: UPDATE fnd_flex_values
382: SET start_date_active = nvl(p_effective_date, start_date_active),
383: end_date_active = nvl(p_expiration_date, end_date_active),
384: enabled_flag = p_enabled_flag,
385: last_update_date = l_update_date,

Line 395: UPDATE fnd_flex_values_tl

391: RAISE FND_API.G_EXC_ERROR;
392: END IF;
393:
394: /* ...and the translated description */
395: UPDATE fnd_flex_values_tl
396: SET description = p_flex_desc,
397: last_update_date = l_update_date,
398: last_updated_by = FND_GLOBAL.user_id
399: WHERE flex_value_id = l_value_id