eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_HR_LOCATION dependencies on FND_DFLEX

Line 611: ** HR_LOCATIONS table is retrieved by using fnd_dflex package. fnd_dflex package is

607: ** This procedure is used to retriev the address values mapped to
608: ** HR_LOCATIONS or HZ_LOCATIONS.
609: **
610: ** The prompts and the columns names where the prompts are mapped to
611: ** HR_LOCATIONS table is retrieved by using fnd_dflex package. fnd_dflex package is
612: ** is having functions and procedures to retrieve prompts names and the column names
613: ** of HR_LOCATIONS where the address details are stored.
614: ** Note: Some look up codes are stored in HR_LOCATIONS table. Current procedure is not
615: ** retrieving the loop up values for these codes.

Line 647: /* Variables used in retreiving segments, prompts and column name from fnd_dflex*/

643: x_state_or_province OUT NOCOPY varchar2)
644:
645: IS
646:
647: /* Variables used in retreiving segments, prompts and column name from fnd_dflex*/
648:
649: flexfield fnd_dflex.dflex_r;
650: flexinfo fnd_dflex.dflex_dr;
651: lcontext fnd_dflex.context_r;

Line 649: flexfield fnd_dflex.dflex_r;

645: IS
646:
647: /* Variables used in retreiving segments, prompts and column name from fnd_dflex*/
648:
649: flexfield fnd_dflex.dflex_r;
650: flexinfo fnd_dflex.dflex_dr;
651: lcontext fnd_dflex.context_r;
652: i BINARY_INTEGER;
653: segments fnd_dflex.segments_dr;

Line 650: flexinfo fnd_dflex.dflex_dr;

646:
647: /* Variables used in retreiving segments, prompts and column name from fnd_dflex*/
648:
649: flexfield fnd_dflex.dflex_r;
650: flexinfo fnd_dflex.dflex_dr;
651: lcontext fnd_dflex.context_r;
652: i BINARY_INTEGER;
653: segments fnd_dflex.segments_dr;
654: l_addr_prompts_array vchar_array := vchar_array(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

Line 651: lcontext fnd_dflex.context_r;

647: /* Variables used in retreiving segments, prompts and column name from fnd_dflex*/
648:
649: flexfield fnd_dflex.dflex_r;
650: flexinfo fnd_dflex.dflex_dr;
651: lcontext fnd_dflex.context_r;
652: i BINARY_INTEGER;
653: segments fnd_dflex.segments_dr;
654: l_addr_prompts_array vchar_array := vchar_array(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
655: l_addr_col_names_array vchar_array := vchar_array('NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL');

Line 653: segments fnd_dflex.segments_dr;

649: flexfield fnd_dflex.dflex_r;
650: flexinfo fnd_dflex.dflex_dr;
651: lcontext fnd_dflex.context_r;
652: i BINARY_INTEGER;
653: segments fnd_dflex.segments_dr;
654: l_addr_prompts_array vchar_array := vchar_array(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
655: l_addr_col_names_array vchar_array := vchar_array('NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL');
656: l_addr_values_array vchar_array := vchar_array(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
657: l_count number := 0;

Line 800: 2. FND_DFLEX package is not called if location id exists.

796:
797: /*******************************************************************************************************
798: Logic used to improve performance.
799: 1. Check whether the given location id exists in g_address_details PL/SQL table.
800: 2. FND_DFLEX package is not called if location id exists.
801: 3. IF location id is not in PL/SQL table check whether the style code exists
802: in g_addr_prompt_query PL/SQL table.
803: 4. If the style code exists retrieve select query and prompts list from g_addr_prompt_query PL/SQL table,
804: else use FND_DFLEX package to retrieve the column names and prompts and add them to

Line 804: else use FND_DFLEX package to retrieve the column names and prompts and add them to

800: 2. FND_DFLEX package is not called if location id exists.
801: 3. IF location id is not in PL/SQL table check whether the style code exists
802: in g_addr_prompt_query PL/SQL table.
803: 4. If the style code exists retrieve select query and prompts list from g_addr_prompt_query PL/SQL table,
804: else use FND_DFLEX package to retrieve the column names and prompts and add them to
805: g_addr_prompt_query PL/SQL table.
806: *******************************************************************************************************/
807:
808: l_table_count := g_address_details.count; -- Number of rows in the PL/SQl table

Line 857: /* If style code not exists use FND_DFLEX package to retireve prompts and column names. */

853: EXIT ;
854: END IF;
855: END LOOP;
856:
857: /* If style code not exists use FND_DFLEX package to retireve prompts and column names. */
858:
859: IF l_style_code_exists <> 'Y' THEN
860:
861: fnd_dflex.get_flexfield('PER', 'Address Location', flexfield, flexinfo);

Line 861: fnd_dflex.get_flexfield('PER', 'Address Location', flexfield, flexinfo);

857: /* If style code not exists use FND_DFLEX package to retireve prompts and column names. */
858:
859: IF l_style_code_exists <> 'Y' THEN
860:
861: fnd_dflex.get_flexfield('PER', 'Address Location', flexfield, flexinfo);
862: lcontext.flexfield := flexfield;
863: lcontext.context_code := l_style_code;
864: fnd_dflex.get_segments(lcontext, segments);
865: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 864: fnd_dflex.get_segments(lcontext, segments);

860:
861: fnd_dflex.get_flexfield('PER', 'Address Location', flexfield, flexinfo);
862: lcontext.flexfield := flexfield;
863: lcontext.context_code := l_style_code;
864: fnd_dflex.get_segments(lcontext, segments);
865: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
866: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Retrieved Values from descriptive flex');
867: END IF;
868: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN