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.JTF_UM_USERTYPES_PKG dependencies on JTF_UM_USERTYPE_TMPL

Line 437: CURSOR C IS SELECT USERTYPE_ID FROM JTF_UM_USERTYPE_TMPL WHERE USERTYPE_ID = X_USERTYPE_ID AND TEMPLATE_ID = X_TEMPLATE_ID AND (EFFECTIVE_END_DATE IS NULL OR EFFECTIVE_END_DATE > SYSDATE);

433: end LOAD_ROW;
434:
435: FUNCTION IS_TEMPLATE_ASSIGNED(X_USERTYPE_ID NUMBER, X_TEMPLATE_ID NUMBER) RETURN BOOLEAN IS
436: l_dummy NUMBER;
437: CURSOR C IS SELECT USERTYPE_ID FROM JTF_UM_USERTYPE_TMPL WHERE USERTYPE_ID = X_USERTYPE_ID AND TEMPLATE_ID = X_TEMPLATE_ID AND (EFFECTIVE_END_DATE IS NULL OR EFFECTIVE_END_DATE > SYSDATE);
438: begin
439: open c;
440: fetch c into l_dummy;
441: if(c%NOTFOUND) then

Line 455: UPDATE JTF_UM_USERTYPE_TMPL SET

451: X_USERTYPE_ID IN NUMBER
452: ) is
453: begin
454:
455: UPDATE JTF_UM_USERTYPE_TMPL SET
456: EFFECTIVE_END_DATE = SYSDATE,
457: LAST_UPDATED_BY=FND_GLOBAL.USER_ID,
458: LAST_UPDATE_DATE= SYSDATE
459: WHERE USERTYPE_ID = X_USERTYPE_ID;

Line 473: INSERT INTO JTF_UM_USERTYPE_TMPL(

469: X_LAST_UPDATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID
470: ) is
471: begin
472:
473: INSERT INTO JTF_UM_USERTYPE_TMPL(
474: USERTYPE_ID,
475: TEMPLATE_ID,
476: EFFECTIVE_START_DATE,
477: EFFECTIVE_END_DATE,

Line 517: update JTF_UM_USERTYPE_TMPL

513: X_LAST_UPDATED_BY IN NUMBER,
514: X_LAST_UPDATE_LOGIN IN NUMBER
515: ) is
516: begin
517: update JTF_UM_USERTYPE_TMPL
518: set EFFECTIVE_END_DATE=X_EFFECTIVE_END_DATE,
519: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
520: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
521: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 550: from jtf_UM_USERTYPE_TMPL

546: -- end if;
547:
548: select count(*)
549: into h_record_exists
550: from jtf_UM_USERTYPE_TMPL
551: where USERTYPE_ID = X_USERTYPE_ID
552: and TEMPLATE_ID = X_TEMPLATE_ID
553: and EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE;
554:

Line 580: FROM JTF_UM_USERTYPE_TMPL

576: -- there is a row for this app_id and this app_short_name
577: -- Exception is thrown otherwise.
578: select LAST_UPDATED_BY, LAST_UPDATE_DATE
579: into db_luby, db_ludate
580: FROM JTF_UM_USERTYPE_TMPL
581: where USERTYPE_ID = X_USERTYPE_ID
582: and TEMPLATE_ID = X_TEMPLATE_ID
583: and EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE;
584: