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.IEM_CLASSIFICATIONS_PVT dependencies on FND_PROFILE

Line 366: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;

362:
363: l_api_name VARCHAR2(255):='update_item';
364: l_api_version_number NUMBER:=1.0;
365:
366: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
367: l_LAST_UPDATE_DATE DATE:=SYSDATE;
368: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
369:
370: IEM_DUPLICATE_CLASS EXCEPTION;

Line 368: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;

364: l_api_version_number NUMBER:=1.0;
365:
366: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
367: l_LAST_UPDATE_DATE DATE:=SYSDATE;
368: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
369:
370: IEM_DUPLICATE_CLASS EXCEPTION;
371: PRAGMA EXCEPTION_INIT(IEM_DUPLICATE_CLASS, -00001);
372:

Line 480: l_CREATED_BY NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

476: )is
477: l_api_name VARCHAR2(255):='create_item';
478: l_api_version_number NUMBER:=1.0;
479: l_cnt number;
480: l_CREATED_BY NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
481: l_creation_date date := SYSDATE;
482: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
483: l_LAST_UPDATE_DATE DATE:=SYSDATE;
484: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;

Line 482: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;

478: l_api_version_number NUMBER:=1.0;
479: l_cnt number;
480: l_CREATED_BY NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
481: l_creation_date date := SYSDATE;
482: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
483: l_LAST_UPDATE_DATE DATE:=SYSDATE;
484: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
485: l_classification VARCHAR2(100);
486: l_classification2 VARCHAR2(100);

Line 484: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;

480: l_CREATED_BY NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
481: l_creation_date date := SYSDATE;
482: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
483: l_LAST_UPDATE_DATE DATE:=SYSDATE;
484: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
485: l_classification VARCHAR2(100);
486: l_classification2 VARCHAR2(100);
487: IEM_DUP_CLASS EXCEPTION;
488:

Line 533: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),

529: p_init_msg_list => p_init_msg_list,
530: p_commit => p_commit,
531: p_email_account_id =>p_email_account_id,
532: p_classification => l_classification,
533: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
534: p_CREATION_DATE =>SYSDATE,
535: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
536: p_LAST_UPDATE_DATE =>SYSDATE,
537: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,

Line 535: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),

531: p_email_account_id =>p_email_account_id,
532: p_classification => l_classification,
533: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
534: p_CREATION_DATE =>SYSDATE,
535: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
536: p_LAST_UPDATE_DATE =>SYSDATE,
537: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
538: p_ATTRIBUTE1 =>null,
539: p_ATTRIBUTE2 =>null,

Line 537: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,

533: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
534: p_CREATION_DATE =>SYSDATE,
535: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
536: p_LAST_UPDATE_DATE =>SYSDATE,
537: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
538: p_ATTRIBUTE1 =>null,
539: p_ATTRIBUTE2 =>null,
540: p_ATTRIBUTE3 =>null,
541: p_ATTRIBUTE4 =>null,

Line 619: l_CREATED_BY NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

615: )is
616: l_api_name VARCHAR2(255):='create_item';
617: l_api_version_number NUMBER:=1.0;
618: l_cnt number;
619: l_CREATED_BY NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
620: l_creation_date date := SYSDATE;
621: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
622: l_LAST_UPDATE_DATE DATE:=SYSDATE;
623: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;

Line 621: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;

617: l_api_version_number NUMBER:=1.0;
618: l_cnt number;
619: l_CREATED_BY NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
620: l_creation_date date := SYSDATE;
621: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
622: l_LAST_UPDATE_DATE DATE:=SYSDATE;
623: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
624: l_classification VARCHAR2(100);
625: l_classification2 VARCHAR2(100);

Line 623: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;

619: l_CREATED_BY NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
620: l_creation_date date := SYSDATE;
621: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
622: l_LAST_UPDATE_DATE DATE:=SYSDATE;
623: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
624: l_classification VARCHAR2(100);
625: l_classification2 VARCHAR2(100);
626: IEM_DUP_CLASS EXCEPTION;
627:

Line 672: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),

668: p_init_msg_list => p_init_msg_list,
669: p_commit => p_commit,
670: p_email_account_id =>p_email_account_id,
671: p_classification => l_classification,
672: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
673: p_CREATION_DATE =>SYSDATE,
674: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
675: p_LAST_UPDATE_DATE =>SYSDATE,
676: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,

Line 674: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),

670: p_email_account_id =>p_email_account_id,
671: p_classification => l_classification,
672: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
673: p_CREATION_DATE =>SYSDATE,
674: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
675: p_LAST_UPDATE_DATE =>SYSDATE,
676: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
677: p_ATTRIBUTE1 =>null,
678: p_ATTRIBUTE2 =>null,

Line 676: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,

672: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
673: p_CREATION_DATE =>SYSDATE,
674: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
675: p_LAST_UPDATE_DATE =>SYSDATE,
676: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
677: p_ATTRIBUTE1 =>null,
678: p_ATTRIBUTE2 =>null,
679: p_ATTRIBUTE3 =>null,
680: p_ATTRIBUTE4 =>null,

Line 961: l_CREATED_BY NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

957: x_msg_data OUT NOCOPY VARCHAR2
958: )is
959: l_api_name VARCHAR2(255):='update_item';
960: l_api_version_number NUMBER:=1.0;
961: l_CREATED_BY NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
962: l_creation_date date := SYSDATE;
963: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
964: l_LAST_UPDATE_DATE DATE:=SYSDATE;
965: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;

Line 963: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;

959: l_api_name VARCHAR2(255):='update_item';
960: l_api_version_number NUMBER:=1.0;
961: l_CREATED_BY NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
962: l_creation_date date := SYSDATE;
963: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
964: l_LAST_UPDATE_DATE DATE:=SYSDATE;
965: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
966: l_classification VARCHAR2(100);
967: l_classification2 VARCHAR2(100);

Line 965: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;

961: l_CREATED_BY NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
962: l_creation_date date := SYSDATE;
963: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
964: l_LAST_UPDATE_DATE DATE:=SYSDATE;
965: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
966: l_classification VARCHAR2(100);
967: l_classification2 VARCHAR2(100);
968: l_cnt NUMBER := 0;
969:

Line 1083: l_CREATED_BY NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

1079: x_msg_data OUT NOCOPY VARCHAR2
1080: )is
1081: l_api_name VARCHAR2(255):='update_item';
1082: l_api_version_number NUMBER:=1.0;
1083: l_CREATED_BY NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
1084: l_creation_date date := SYSDATE;
1085: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
1086: l_LAST_UPDATE_DATE DATE:=SYSDATE;
1087: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;

Line 1085: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;

1081: l_api_name VARCHAR2(255):='update_item';
1082: l_api_version_number NUMBER:=1.0;
1083: l_CREATED_BY NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
1084: l_creation_date date := SYSDATE;
1085: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
1086: l_LAST_UPDATE_DATE DATE:=SYSDATE;
1087: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
1088: l_classification VARCHAR2(100);
1089: l_classification2 VARCHAR2(100);

Line 1087: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;

1083: l_CREATED_BY NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
1084: l_creation_date date := SYSDATE;
1085: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
1086: l_LAST_UPDATE_DATE DATE:=SYSDATE;
1087: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
1088: l_classification VARCHAR2(100);
1089: l_classification2 VARCHAR2(100);
1090: l_status varchar2(10);
1091: l_cnt NUMBER := 0;