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.PER_UPLOAD_USER_TABLE dependencies on FND_LOOKUP_VALUES

Line 464: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,

460: END enter_user_table_values;
461:
462:
463: PROCEDURE lookup_insert_row
464: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
465: p_meaning IN fnd_lookup_values.meaning%type,
466: p_description IN fnd_lookup_values.description%type,
467: p_security_group_id IN NUMBER,
468: p_effective_date IN DATE,

Line 465: p_meaning IN fnd_lookup_values.meaning%type,

461:
462:
463: PROCEDURE lookup_insert_row
464: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
465: p_meaning IN fnd_lookup_values.meaning%type,
466: p_description IN fnd_lookup_values.description%type,
467: p_security_group_id IN NUMBER,
468: p_effective_date IN DATE,
469: p_lookup_type IN VARCHAR2)

Line 466: p_description IN fnd_lookup_values.description%type,

462:
463: PROCEDURE lookup_insert_row
464: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
465: p_meaning IN fnd_lookup_values.meaning%type,
466: p_description IN fnd_lookup_values.description%type,
467: p_security_group_id IN NUMBER,
468: p_effective_date IN DATE,
469: p_lookup_type IN VARCHAR2)
470:

Line 478: FND_LOOKUP_VALUES_PKG.INSERT_ROW(

474: l_rowid VARCHAR2(30);
475:
476: begin
477:
478: FND_LOOKUP_VALUES_PKG.INSERT_ROW(
479: X_ROWID => l_rowid,
480: X_LOOKUP_TYPE => p_lookup_type,
481: X_SECURITY_GROUP_ID => p_security_group_id,
482: X_VIEW_APPLICATION_ID => 3,

Line 518: -- Procedure to update a row in fnd_lookup_values table

514: hr_utility.set_location ('insert row', 30);
515:
516: end lookup_insert_row;
517:
518: -- Procedure to update a row in fnd_lookup_values table
519:
520: PROCEDURE lookup_update_row
521: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
522: p_meaning IN fnd_lookup_values.meaning%type,

Line 521: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,

517:
518: -- Procedure to update a row in fnd_lookup_values table
519:
520: PROCEDURE lookup_update_row
521: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
522: p_meaning IN fnd_lookup_values.meaning%type,
523: p_description IN fnd_lookup_values.description%type,
524: p_security_group_id IN NUMBER,
525: p_effective_date IN DATE,

Line 522: p_meaning IN fnd_lookup_values.meaning%type,

518: -- Procedure to update a row in fnd_lookup_values table
519:
520: PROCEDURE lookup_update_row
521: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
522: p_meaning IN fnd_lookup_values.meaning%type,
523: p_description IN fnd_lookup_values.description%type,
524: p_security_group_id IN NUMBER,
525: p_effective_date IN DATE,
526: p_lookup_type IN VARCHAR2)

Line 523: p_description IN fnd_lookup_values.description%type,

519:
520: PROCEDURE lookup_update_row
521: ( p_lookup_code IN fnd_lookup_values.lookup_code%type,
522: p_meaning IN fnd_lookup_values.meaning%type,
523: p_description IN fnd_lookup_values.description%type,
524: p_security_group_id IN NUMBER,
525: p_effective_date IN DATE,
526: p_lookup_type IN VARCHAR2)
527:

Line 534: FND_LOOKUP_VALUES_PKG.UPDATE_ROW(

530: --l_lookup_type CONSTANT VARCHAR2(50):='RO_COR_VALUE_LIST';
531:
532: begin
533:
534: FND_LOOKUP_VALUES_PKG.UPDATE_ROW(
535: X_LOOKUP_TYPE => p_lookup_type,
536: X_SECURITY_GROUP_ID => p_security_group_id,
537: X_VIEW_APPLICATION_ID => 3,
538: X_LOOKUP_CODE => p_lookup_code,

Line 585: l_lookup_code FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE default null;

581: l_delim_postn NUMBER := 0;
582: l_start_postn NUMBER := 0;
583: l_delim_count NUMBER := 1;
584:
585: l_lookup_code FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE default null;
586: l_description FND_LOOKUP_VALUES.DESCRIPTION%TYPE default null;
587:
588: l_security_group_id NUMBER;
589: l_update_flag VARCHAR2(1) := 'N';

Line 586: l_description FND_LOOKUP_VALUES.DESCRIPTION%TYPE default null;

582: l_start_postn NUMBER := 0;
583: l_delim_count NUMBER := 1;
584:
585: l_lookup_code FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE default null;
586: l_description FND_LOOKUP_VALUES.DESCRIPTION%TYPE default null;
587:
588: l_security_group_id NUMBER;
589: l_update_flag VARCHAR2(1) := 'N';
590: l_effective_date DATE;

Line 670: from fnd_lookup_values

666:
667: BEGIN
668: select 'Y'
669: into l_update_flag
670: from fnd_lookup_values
671: where lookup_type= 'RO_COR_VALUE_LIST'
672: and lookup_code= l_lookup_code
673: and security_group_id = l_security_group_id
674: and language = userenv('LANG');

Line 698: -- procedure to populate the fnd_lookup_values with Locality and County

694: hr_utility.trace('Closing file');
695: -- hr_utility.trace_off();
696: END enter_lookup_values;
697:
698: -- procedure to populate the fnd_lookup_values with Locality and County
699:
700: procedure populate_locality_county_lov
701: (p_business_group_id IN NUMBER)
702: IS

Line 816: FROM fnd_lookup_values

812:
813: -- block to select the maximum lookup code
814: begin
815: select NVL(MAX(TO_NUMBER(SUBSTR(LOOKUP_CODE,4))),0) into l_code_postfix
816: FROM fnd_lookup_values
817: WHERE LOOKUP_TYPE = 'PER_RO_LOCALITY';
818: hr_utility.set_location('l_code_postfix '||l_code_postfix,12);
819: Exception
820: when NO_DATA_FOUND then

Line 838: from fnd_lookup_values

834: l_exist_flag := 'N';
835: BEGIN
836: select 'Y'
837: into l_exist_flag
838: from fnd_lookup_values
839: where lookup_type= 'PER_RO_LOCALITY'
840: and meaning= l_meaning
841: and description = l_description
842: --and security_group_id = l_security_group_id