APPS.HR_ID_FLEX_STRUCTURE_INFO dependencies on FND_APPLICATION

Line 25: g_application_short_name3 fnd_application.application_short_name%TYPE;

21: g_id_flex_code2 fnd_id_flex_structures.id_flex_code%TYPE;
22: g_id_flex_num2 fnd_id_flex_structures.id_flex_num%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_id_flex_num2 fnd_id_flex_structures.id_flex_num%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 402: (p_application_short_name IN fnd_application.application_short_name%TYPE

398: -- -----------------------------------------------------------------------------
399: -- |------------------------------< segments_pst >-----------------------------|
400: -- -----------------------------------------------------------------------------
401: FUNCTION segments_pst
402: (p_application_short_name IN fnd_application.application_short_name%TYPE
403: ,p_id_flex_code IN fnd_id_flex_structures.id_flex_code%TYPE
404: ,p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE
405: ,p_effective_date IN DATE
406: )

Line 413: (p_application_short_name IN fnd_application.application_short_name%TYPE

409: --
410: -- Local cursors
411: --
412: CURSOR csr_applications
413: (p_application_short_name IN fnd_application.application_short_name%TYPE
414: )
415: IS
416: SELECT app.application_id
417: FROM fnd_application app

Line 417: FROM fnd_application app

413: (p_application_short_name IN fnd_application.application_short_name%TYPE
414: )
415: IS
416: SELECT app.application_id
417: FROM fnd_application app
418: WHERE app.application_short_name = p_application_short_name;
419: --
420: -- Local variables
421: --

Line 423: l_application_id fnd_application.application_id%TYPE;

419: --
420: -- Local variables
421: --
422: l_segments_pst t_segments_pst;
423: l_application_id fnd_application.application_id%TYPE;
424: l_segments t_segments := t_segments();
425: l_index_number NUMBER;
426: --
427: BEGIN