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.CSM_UTIL_PKG dependencies on FND_USER

Line 397: FROM FND_USER_RESP_GROUPS

393: RULE_TABLE RULE_TABLE_TYPE;
394:
395: CURSOR C_USER_RESP ( p_user_id NUMBER ) IS
396: SELECT RESPONSIBILITY_ID
397: FROM FND_USER_RESP_GROUPS
398: WHERE NVL( START_DATE , SYSDATE) <= SYSDATE
399: AND NVL( END_DATE , SYSDATE) >= SYSDATE
400: AND USER_ID = p_user_id;
401:

Line 481: cursor l_rs_resource_extns_csr (p_user_id fnd_user.user_id%type) is

477: is
478: l_markdirty boolean;
479: l_resourcelist number;
480:
481: cursor l_rs_resource_extns_csr (p_user_id fnd_user.user_id%type) is
482: select resource_id
483: from jtf_rs_resource_extns
484: where user_id = p_user_id
485: AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE)

Line 512: cursor l_rs_resource_extns_csr (p_user_id fnd_user.user_id%type) is

508: is
509: l_markdirty boolean;
510: l_resourcelist asg_download.user_list;
511:
512: cursor l_rs_resource_extns_csr (p_user_id fnd_user.user_id%type) is
513: select resource_id
514: from jtf_rs_resource_extns
515: where user_id = p_user_id
516: AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE)

Line 553: cursor l_rs_resource_extns_csr (p_user_id fnd_user.user_id%type) is

549: is
550: l_markdirty boolean;
551: l_resourcelist asg_download.user_list;
552:
553: cursor l_rs_resource_extns_csr (p_user_id fnd_user.user_id%type) is
554: select resource_id
555: from jtf_rs_resource_extns
556: where user_id = p_user_id
557: AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE)

Line 595: cursor l_rs_resource_extns_csr (p_user_id fnd_user.user_id%type) is

591: IS
592: l_markdirty boolean;
593: l_resourcelist number;
594:
595: cursor l_rs_resource_extns_csr (p_user_id fnd_user.user_id%type) is
596: select resource_id
597: from jtf_rs_resource_extns
598: where user_id = p_user_id
599: AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE)

Line 737: select fnd_user_resp.user_id

733: AND usr.resource_id = p_resource_id;
734:
735: /*CURSOR l_is_palm_resource_csr(p_resource_id IN jtf_rs_resource_extns.resource_id%type)
736: IS
737: select fnd_user_resp.user_id
738: from asg_pub_responsibility asg_resp,
739: asg_pub,
740: fnd_user_resp_groups fnd_user_resp,
741: fnd_application fnd_app,

Line 740: fnd_user_resp_groups fnd_user_resp,

736: IS
737: select fnd_user_resp.user_id
738: from asg_pub_responsibility asg_resp,
739: asg_pub,
740: fnd_user_resp_groups fnd_user_resp,
741: fnd_application fnd_app,
742: jtf_rs_resource_extns res
743: where asg_resp.pub_id = asg_pub.pub_id
744: and asg_pub.name = 'SERVICEP'

Line 745: and asg_resp.responsibility_id = fnd_user_resp.responsibility_id

741: fnd_application fnd_app,
742: jtf_rs_resource_extns res
743: where asg_resp.pub_id = asg_pub.pub_id
744: and asg_pub.name = 'SERVICEP'
745: and asg_resp.responsibility_id = fnd_user_resp.responsibility_id
746: and fnd_app.application_id = fnd_user_resp.responsibility_application_id
747: and fnd_user_resp.user_id = res.user_id
748: AND SYSDATE BETWEEN nvl(fnd_user_resp.start_date, sysdate) AND nvl(fnd_user_resp.end_date, sysdate)
749: and fnd_app.application_short_name = 'CSM'

Line 746: and fnd_app.application_id = fnd_user_resp.responsibility_application_id

742: jtf_rs_resource_extns res
743: where asg_resp.pub_id = asg_pub.pub_id
744: and asg_pub.name = 'SERVICEP'
745: and asg_resp.responsibility_id = fnd_user_resp.responsibility_id
746: and fnd_app.application_id = fnd_user_resp.responsibility_application_id
747: and fnd_user_resp.user_id = res.user_id
748: AND SYSDATE BETWEEN nvl(fnd_user_resp.start_date, sysdate) AND nvl(fnd_user_resp.end_date, sysdate)
749: and fnd_app.application_short_name = 'CSM'
750: and res.resource_id = p_resource_id;

Line 747: and fnd_user_resp.user_id = res.user_id

743: where asg_resp.pub_id = asg_pub.pub_id
744: and asg_pub.name = 'SERVICEP'
745: and asg_resp.responsibility_id = fnd_user_resp.responsibility_id
746: and fnd_app.application_id = fnd_user_resp.responsibility_application_id
747: and fnd_user_resp.user_id = res.user_id
748: AND SYSDATE BETWEEN nvl(fnd_user_resp.start_date, sysdate) AND nvl(fnd_user_resp.end_date, sysdate)
749: and fnd_app.application_short_name = 'CSM'
750: and res.resource_id = p_resource_id;
751: */

Line 748: AND SYSDATE BETWEEN nvl(fnd_user_resp.start_date, sysdate) AND nvl(fnd_user_resp.end_date, sysdate)

744: and asg_pub.name = 'SERVICEP'
745: and asg_resp.responsibility_id = fnd_user_resp.responsibility_id
746: and fnd_app.application_id = fnd_user_resp.responsibility_application_id
747: and fnd_user_resp.user_id = res.user_id
748: AND SYSDATE BETWEEN nvl(fnd_user_resp.start_date, sysdate) AND nvl(fnd_user_resp.end_date, sysdate)
749: and fnd_app.application_short_name = 'CSM'
750: and res.resource_id = p_resource_id;
751: */
752: l_is_palm_resource_rec l_is_palm_resource_csr%ROWTYPE;

Line 787: select fnd_user_resp.user_id

783: AND usr.user_id = b_user_id;
784:
785:
786: /* cursor l_responsibilities_csr (b_user_id number) is
787: select fnd_user_resp.user_id
788: from asg_pub_responsibility asg_resp,
789: asg_pub,
790: fnd_user_resp_groups fnd_user_resp,
791: fnd_application fnd_app

Line 790: fnd_user_resp_groups fnd_user_resp,

786: /* cursor l_responsibilities_csr (b_user_id number) is
787: select fnd_user_resp.user_id
788: from asg_pub_responsibility asg_resp,
789: asg_pub,
790: fnd_user_resp_groups fnd_user_resp,
791: fnd_application fnd_app
792: where asg_resp.pub_id = asg_pub.pub_id
793: and asg_pub.name = 'SERVICEP'
794: and asg_resp.responsibility_id = fnd_user_resp.responsibility_id

Line 794: and asg_resp.responsibility_id = fnd_user_resp.responsibility_id

790: fnd_user_resp_groups fnd_user_resp,
791: fnd_application fnd_app
792: where asg_resp.pub_id = asg_pub.pub_id
793: and asg_pub.name = 'SERVICEP'
794: and asg_resp.responsibility_id = fnd_user_resp.responsibility_id
795: and fnd_app.application_id = fnd_user_resp.responsibility_application_id
796: and fnd_app.application_short_name = 'CSM'
797: and fnd_user_resp.user_id = p_user_id
798: AND SYSDATE BETWEEN nvl(fnd_user_resp.start_date, sysdate) AND nvl(fnd_user_resp.end_date, sysdate)

Line 795: and fnd_app.application_id = fnd_user_resp.responsibility_application_id

791: fnd_application fnd_app
792: where asg_resp.pub_id = asg_pub.pub_id
793: and asg_pub.name = 'SERVICEP'
794: and asg_resp.responsibility_id = fnd_user_resp.responsibility_id
795: and fnd_app.application_id = fnd_user_resp.responsibility_application_id
796: and fnd_app.application_short_name = 'CSM'
797: and fnd_user_resp.user_id = p_user_id
798: AND SYSDATE BETWEEN nvl(fnd_user_resp.start_date, sysdate) AND nvl(fnd_user_resp.end_date, sysdate)
799: ;

Line 797: and fnd_user_resp.user_id = p_user_id

793: and asg_pub.name = 'SERVICEP'
794: and asg_resp.responsibility_id = fnd_user_resp.responsibility_id
795: and fnd_app.application_id = fnd_user_resp.responsibility_application_id
796: and fnd_app.application_short_name = 'CSM'
797: and fnd_user_resp.user_id = p_user_id
798: AND SYSDATE BETWEEN nvl(fnd_user_resp.start_date, sysdate) AND nvl(fnd_user_resp.end_date, sysdate)
799: ;
800: */
801: l_responsibilities_rec l_responsibilities_csr%ROWTYPE;

Line 798: AND SYSDATE BETWEEN nvl(fnd_user_resp.start_date, sysdate) AND nvl(fnd_user_resp.end_date, sysdate)

794: and asg_resp.responsibility_id = fnd_user_resp.responsibility_id
795: and fnd_app.application_id = fnd_user_resp.responsibility_application_id
796: and fnd_app.application_short_name = 'CSM'
797: and fnd_user_resp.user_id = p_user_id
798: AND SYSDATE BETWEEN nvl(fnd_user_resp.start_date, sysdate) AND nvl(fnd_user_resp.end_date, sysdate)
799: ;
800: */
801: l_responsibilities_rec l_responsibilities_csr%ROWTYPE;
802: BEGIN

Line 2230: FUNCTION get_fnd_user_language( p_user_id fnd_user.user_id%TYPE)

2226: END IF;
2227: END set_task_audit;
2228:
2229: /* returns user langauge at user level/site level */
2230: FUNCTION get_fnd_user_language( p_user_id fnd_user.user_id%TYPE)
2231: RETURN VARCHAR2
2232: IS
2233: l_profile_option_value VARCHAR2(255) := NULL;
2234: l_profile_option_name VARCHAR2(255) := 'ICX_LANGUAGE';

Line 2282: END get_fnd_user_language;

2278:
2279: EXCEPTION
2280: WHEN OTHERS THEN
2281: RETURN NULL;
2282: END get_fnd_user_language;
2283:
2284: END CSM_UTIL_PKG;