APPS.HR_DESCR_FLEX_CONTEXT_INFO dependencies on FND_APPLICATION

Line 25: g_application_short_name3 fnd_application.application_short_name%TYPE;

21: g_descriptive_flexfield_name2 fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE;
22: g_descr_flex_context_code2 fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
23: g_effective_date2 DATE;
24: g_segments2 t_segments := t_segments();
25: g_application_short_name3 fnd_application.application_short_name%TYPE;
26: g_application_id3 fnd_application.application_id%TYPE;
27: --
28: g_segment_headers t_segment_headers := t_segment_headers();
29: g_segments t_segments := t_segments();

Line 26: g_application_id3 fnd_application.application_id%TYPE;

22: g_descr_flex_context_code2 fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
23: g_effective_date2 DATE;
24: g_segments2 t_segments := t_segments();
25: g_application_short_name3 fnd_application.application_short_name%TYPE;
26: g_application_id3 fnd_application.application_id%TYPE;
27: --
28: g_segment_headers t_segment_headers := t_segment_headers();
29: g_segments t_segments := t_segments();
30: --

Line 439: (p_application_short_name IN fnd_application.application_short_name%TYPE

435: -- -----------------------------------------------------------------------------
436: -- |------------------------------< segments_pst >-----------------------------|
437: -- -----------------------------------------------------------------------------
438: FUNCTION segments_pst
439: (p_application_short_name IN fnd_application.application_short_name%TYPE
440: ,p_descriptive_flexfield_name IN fnd_descr_flex_contexts.descriptive_flexfield_name%TYPE
441: ,p_descr_flex_context_code IN fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE
442: ,p_effective_date IN DATE
443: )

Line 450: (p_application_short_name IN fnd_application.application_short_name%TYPE

446: --
447: --
448: --
449: CURSOR csr_applications
450: (p_application_short_name IN fnd_application.application_short_name%TYPE
451: )
452: IS
453: SELECT app.application_id
454: FROM fnd_application app

Line 454: FROM fnd_application app

450: (p_application_short_name IN fnd_application.application_short_name%TYPE
451: )
452: IS
453: SELECT app.application_id
454: FROM fnd_application app
455: WHERE app.application_short_name = p_application_short_name;
456: --
457: -- Local variables
458: --

Line 460: l_application_id fnd_application.application_id%TYPE;

456: --
457: -- Local variables
458: --
459: l_segments_pst t_segments_pst;
460: l_application_id fnd_application.application_id%TYPE;
461: l_segments t_segments := t_segments();
462: l_index_number NUMBER;
463: --
464: BEGIN