DBA Data[Home] [Help]

APPS.JTM_CON_QUERY_REQUEST_PKG dependencies on FND_FLEX_VALUES

Line 82: from JTM_FND_FLEX_VALUES_ACC

78:
79: Cursor get_old_value_acc (
80: p_creation_date date, p_appl_id number, p_dff_name in varchar2) is
81: select access_id
82: from JTM_FND_FLEX_VALUES_ACC
83: where creation_date < p_creation_date
84: AND flex_value_id IN
85: (SELECT V.flex_value_id
86: FROM fnd_descr_flex_column_usages bas, FND_FLEX_VALUES V

Line 86: FROM fnd_descr_flex_column_usages bas, FND_FLEX_VALUES V

82: from JTM_FND_FLEX_VALUES_ACC
83: where creation_date < p_creation_date
84: AND flex_value_id IN
85: (SELECT V.flex_value_id
86: FROM fnd_descr_flex_column_usages bas, FND_FLEX_VALUES V
87: WHERE bas.application_id = p_appl_id
88: AND bas.descriptive_flexfield_name = p_dff_name
89: AND bas.FLEX_VALUE_SET_ID = V.FLEX_VALUE_SET_ID
90: );

Line 316: l_pub_item := 'FND_FLEX_VALUES';

312: l_tab_user := l_csm_tab_user;
313: l_pub_item := 'JTM_H_FLEX_VALUES';
314: ELSIF (c_seed_date.application_id = 868) THEN
315: l_tab_user := l_csl_tab_user;
316: l_pub_item := 'FND_FLEX_VALUES';
317: END IF;
318:
319: FOR i IN l_tab_user.FIRST..l_tab_user.LAST LOOP
320: l_dummy := asg_download.mark_dirty (

Line 328: Update JTM_FND_FLEX_VALUES_ACC

324: p_dml => 'I',
325: p_timestamp => sysdate );
326: END LOOP;
327:
328: Update JTM_FND_FLEX_VALUES_ACC
329: set creation_date = c_seed_date.creation_date
330: where access_id = c_old_value_acc.access_id;
331:
332: commit;