APPS.HR_FLEXFIELD_INFO dependencies on FND_APPLICATION

Line 51: ,fnd_application fa

47:
48: select context_column_name,form_context_prompt,default_context_field_name,default_context_value
49: into p_column_name,p_column_name_prompt,p_dcontext_field,p_default_context_value
50: from fnd_descriptive_flexs_vl fdf
51: ,fnd_application fa
52: where descriptive_flexfield_name = p_flex_name
53: and fa.application_id = fdf.application_id
54: and fa.application_short_name = p_appl_short_name;
55:

Line 480: fnd_application.application_short_name%TYPE,

476: --
477:
478: PROCEDURE get_contexts
479: (p_appl_short_name IN
480: fnd_application.application_short_name%TYPE,
481: p_flexfield_name IN
482: fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE,
483: p_contexts OUT NOCOPY fnd_dflex.contexts_dr)
484: is

Line 531: fnd_application.application_short_name%TYPE,

527: --
528:
529: PROCEDURE get_concatenated_contexts
530: (p_appl_short_name IN
531: fnd_application.application_short_name%TYPE,
532: p_flexfield_name IN
533: fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE,
534: p_enabled_only IN BOOLEAN,
535: p_concatenation_chr IN VARCHAR2,

Line 1133: fnd_application.application_short_name%TYPE,

1129: -- ----------------------------------------------------------------------------
1130: --
1131: PROCEDURE get_segments
1132: (p_appl_short_name IN
1133: fnd_application.application_short_name%TYPE,
1134: p_flexfield_name IN
1135: fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE,
1136: p_context_code IN VARCHAR2,
1137: p_enabled_only IN BOOLEAN,

Line 1245: p_application_short_name IN fnd_application.application_short_name%TYPE,

1241: -- ----------------------------------------------------------------------------
1242: --
1243: PROCEDURE build_sql_text(
1244: p_sql_text IN OUT NOCOPY long,
1245: p_application_short_name IN fnd_application.application_short_name%TYPE,
1246: p_application_table_name IN fnd_tables.table_name%TYPE,
1247: p_segment_name_value IN segments) IS
1248:
1249:

Line 1322: fnd_application.application_short_name%TYPE,

1318:
1319: PROCEDURE build_sql_text
1320: (p_sql_text IN OUT NOCOPY long,
1321: p_application_short_name in
1322: fnd_application.application_short_name%TYPE,
1323: p_application_table_name in fnd_tables.table_name%TYPE,
1324: p_column_name1 IN VARCHAR2 default null,
1325: p_column_value1 IN VARCHAR2 default null,
1326: p_column_name2 IN VARCHAR2 default null,

Line 1447: from fnd_application a,

1443: -- a when no data found error.
1444: --
1445: BEGIN
1446: select c.column_type into l_column_type
1447: from fnd_application a,
1448: fnd_tables t,
1449: fnd_columns c
1450: where c.column_name = l_application_column_name
1451: and c.table_id = t.table_id

Line 1752: (p_appl_short_name IN fnd_application.application_short_name%TYPE

1748: -- ----------------------------------------------------------------------------
1749: -- |-------------------< get_kf_concatenated_structures >---------------------|
1750: -- ----------------------------------------------------------------------------
1751: PROCEDURE get_kf_concatenated_structures
1752: (p_appl_short_name IN fnd_application.application_short_name%TYPE
1753: ,p_id_flex_code IN fnd_id_flex_structures_vl.id_flex_code%TYPE
1754: ,p_enabled_only IN BOOLEAN
1755: ,p_concatenation_chr IN VARCHAR2
1756: ,p_structure_list OUT NOCOPY LONG

Line 1837: (p_appl_short_name IN fnd_application.application_short_name%TYPE

1833: -- |---------------------------< get_kf_segments >----------------------------|
1834: -- ----------------------------------------------------------------------------
1835: --
1836: PROCEDURE get_kf_segments
1837: (p_appl_short_name IN fnd_application.application_short_name%TYPE
1838: ,p_id_flex_code IN fnd_id_flex_structures_vl.id_flex_code%TYPE
1839: ,p_id_flex_structure_name IN
1840: fnd_id_flex_structures_vl.id_flex_structure_name%TYPE
1841: ,p_enabled_only IN BOOLEAN