APPS.JAI_DF_DROP dependencies on FND_FLEX_VALUE_SETS

Line 12: lv_value_set_name fnd_flex_value_sets.flex_value_set_name%type;

8: lv_appl_short_name varchar2(10);
9: lv_flexfield_name varchar2(30);
10:
11: ln_application_id number;
12: lv_value_set_name fnd_flex_value_sets.flex_value_set_name%type;
13:
14: cursor cur_segment(cpn_application_id number, cpv_flex_name varchar2, cpv_context varchar2) is
15: select
16: end_user_column_name,

Line 25: from fnd_flex_value_sets

21: and application_id = cpn_application_id;
22:
23: cursor cur_value_set(cpn_value_set_id number) is
24: select flex_value_set_name
25: from fnd_flex_value_sets
26: where flex_value_set_id = cpn_value_set_id;
27:
28: cursor cur_appl_id(cpv_app_short_name varchar2) is
29: select application_id

Line 51: lv_value_set_inv_name fnd_flex_value_sets.flex_value_set_name%type;

47: lv_sql_string varchar2(2000);
48: ln_value_set_inv_id number;
49: ln_value_set_date_id number;
50: ln_value_set_rdate_id number;
51: lv_value_set_inv_name fnd_flex_value_sets.flex_value_set_name%type;
52: lv_value_set_date_name fnd_flex_value_sets.flex_value_set_name%type;
53: lv_value_set_rdate_name fnd_flex_value_sets.flex_value_set_name%type;
54: lv_flag VARCHAR2(1);
55:

Line 52: lv_value_set_date_name fnd_flex_value_sets.flex_value_set_name%type;

48: ln_value_set_inv_id number;
49: ln_value_set_date_id number;
50: ln_value_set_rdate_id number;
51: lv_value_set_inv_name fnd_flex_value_sets.flex_value_set_name%type;
52: lv_value_set_date_name fnd_flex_value_sets.flex_value_set_name%type;
53: lv_value_set_rdate_name fnd_flex_value_sets.flex_value_set_name%type;
54: lv_flag VARCHAR2(1);
55:
56: --Function added by Sanjikum, Bug#5443693

Line 53: lv_value_set_rdate_name fnd_flex_value_sets.flex_value_set_name%type;

49: ln_value_set_date_id number;
50: ln_value_set_rdate_id number;
51: lv_value_set_inv_name fnd_flex_value_sets.flex_value_set_name%type;
52: lv_value_set_date_name fnd_flex_value_sets.flex_value_set_name%type;
53: lv_value_set_rdate_name fnd_flex_value_sets.flex_value_set_name%type;
54: lv_flag VARCHAR2(1);
55:
56: --Function added by Sanjikum, Bug#5443693
57: FUNCTION check_before_delete_dff(pv_flexfield_name VARCHAR2,