APPS.CSM_UTIL_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 483: from jtf_rs_resource_extns

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)
486: AND NVL(end_date_active, SYSDATE)
487: ;

Line 514: from jtf_rs_resource_extns

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)
517: AND NVL(end_date_active, SYSDATE)
518: ;

Line 555: from jtf_rs_resource_extns

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)
558: AND NVL(end_date_active, SYSDATE)
559: ;

Line 597: from jtf_rs_resource_extns

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)
600: AND NVL(end_date_active, SYSDATE);
601:

Line 725: CURSOR l_is_palm_resource_csr(p_resource_id IN jtf_rs_resource_extns.resource_id%TYPE)

721:
722: FUNCTION is_palm_resource(p_resource_id IN NUMBER)
723: RETURN BOOLEAN
724: IS
725: CURSOR l_is_palm_resource_csr(p_resource_id IN jtf_rs_resource_extns.resource_id%TYPE)
726: IS--R12 on multiple responsibility
727: SELECT 1
728: FROM asg_user_pub_resps pubresp
729: , asg_user usr

Line 735: /*CURSOR l_is_palm_resource_csr(p_resource_id IN jtf_rs_resource_extns.resource_id%type)

731: AND pubresp.user_name = usr.user_name
732: AND pubresp.pub_name = 'SERVICEP'
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,

Line 742: jtf_rs_resource_extns res

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'
745: and asg_resp.responsibility_id = fnd_user_resp.responsibility_id
746: and fnd_app.application_id = fnd_user_resp.responsibility_application_id

Line 1895: FROM JTF_RS_RESOURCE_EXTNS RES,

1891: AND TL.LANGUAGE=b_lang;
1892:
1893: CURSOR c_owner_name(b_owner_id NUMBER) IS
1894: SELECT PF.FULL_NAME
1895: FROM JTF_RS_RESOURCE_EXTNS RES,
1896: PER_ALL_PEOPLE_F PF
1897: WHERE RES.resource_id = b_owner_id
1898: AND RES.SOURCE_ID=PF.PERSON_ID;
1899:

Line 1900: l_name JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE := NULL;

1896: PER_ALL_PEOPLE_F PF
1897: WHERE RES.resource_id = b_owner_id
1898: AND RES.SOURCE_ID=PF.PERSON_ID;
1899:
1900: l_name JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE := NULL;
1901:
1902: BEGIN
1903: IF NVL(p_owner_type_code,'NULL')='RS_GROUP' THEN
1904: OPEN c_grp_name(p_owner_id,p_language);