APPS.JAI_DF_DROP dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 18: from fnd_descr_flex_column_usages cu

14: cursor cur_segment(cpn_application_id number, cpv_flex_name varchar2, cpv_context varchar2) is
15: select
16: end_user_column_name,
17: flex_value_set_id
18: from fnd_descr_flex_column_usages cu
19: where cu.descriptive_flexfield_name = cpv_flex_name
20: and cu.descriptive_flex_context_code = cpv_context
21: and application_id = cpn_application_id;
22:

Line 38: from fnd_descr_flex_column_usages

34: cursor c_get_dff_details (cpn_application_id number, p_segment_name varchar2) is
35: select descriptive_flex_context_code,
36: application_column_name,
37: flex_value_set_id
38: from fnd_descr_flex_column_usages
39: where application_id = cpn_application_id
40: and descriptive_flexfield_name = 'AP_INVOICES'
41: and end_user_column_name = p_segment_name;
42:

Line 43: lv_context fnd_descr_flex_column_usages.descriptive_flex_context_code%type;

39: where application_id = cpn_application_id
40: and descriptive_flexfield_name = 'AP_INVOICES'
41: and end_user_column_name = p_segment_name;
42:
43: lv_context fnd_descr_flex_column_usages.descriptive_flex_context_code%type;
44: lv_attribute_vat_invoice fnd_descr_flex_column_usages.application_column_name%type;
45: lv_attribute_vat_date fnd_descr_flex_column_usages.application_column_name%type;
46: lv_attribute_vat_receipt_date fnd_descr_flex_column_usages.application_column_name%type;
47: lv_sql_string varchar2(2000);

Line 44: lv_attribute_vat_invoice fnd_descr_flex_column_usages.application_column_name%type;

40: and descriptive_flexfield_name = 'AP_INVOICES'
41: and end_user_column_name = p_segment_name;
42:
43: lv_context fnd_descr_flex_column_usages.descriptive_flex_context_code%type;
44: lv_attribute_vat_invoice fnd_descr_flex_column_usages.application_column_name%type;
45: lv_attribute_vat_date fnd_descr_flex_column_usages.application_column_name%type;
46: lv_attribute_vat_receipt_date fnd_descr_flex_column_usages.application_column_name%type;
47: lv_sql_string varchar2(2000);
48: ln_value_set_inv_id number;

Line 45: lv_attribute_vat_date fnd_descr_flex_column_usages.application_column_name%type;

41: and end_user_column_name = p_segment_name;
42:
43: lv_context fnd_descr_flex_column_usages.descriptive_flex_context_code%type;
44: lv_attribute_vat_invoice fnd_descr_flex_column_usages.application_column_name%type;
45: lv_attribute_vat_date fnd_descr_flex_column_usages.application_column_name%type;
46: lv_attribute_vat_receipt_date fnd_descr_flex_column_usages.application_column_name%type;
47: lv_sql_string varchar2(2000);
48: ln_value_set_inv_id number;
49: ln_value_set_date_id number;

Line 46: lv_attribute_vat_receipt_date fnd_descr_flex_column_usages.application_column_name%type;

42:
43: lv_context fnd_descr_flex_column_usages.descriptive_flex_context_code%type;
44: lv_attribute_vat_invoice fnd_descr_flex_column_usages.application_column_name%type;
45: lv_attribute_vat_date fnd_descr_flex_column_usages.application_column_name%type;
46: lv_attribute_vat_receipt_date fnd_descr_flex_column_usages.application_column_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;