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_WF_PKG dependencies on JTF_RS_GROUP_MEMBERS

Line 1742: PROCEDURE JTF_RS_Group_Member_Post_Ins(p_group_member_id IN jtf_rs_group_members.group_member_id%TYPE,

1738: p_resource_id,
1739: x_return_status
1740: ----------------------------------------------------*/
1741:
1742: PROCEDURE JTF_RS_Group_Member_Post_Ins(p_group_member_id IN jtf_rs_group_members.group_member_id%TYPE,
1743: p_group_id IN jtf_rs_group_members.group_id%TYPE,
1744: p_resource_id IN jtf_rs_group_members.resource_id%TYPE,
1745: x_return_status OUT nocopy VARCHAR2)
1746: IS

Line 1743: p_group_id IN jtf_rs_group_members.group_id%TYPE,

1739: x_return_status
1740: ----------------------------------------------------*/
1741:
1742: PROCEDURE JTF_RS_Group_Member_Post_Ins(p_group_member_id IN jtf_rs_group_members.group_member_id%TYPE,
1743: p_group_id IN jtf_rs_group_members.group_id%TYPE,
1744: p_resource_id IN jtf_rs_group_members.resource_id%TYPE,
1745: x_return_status OUT nocopy VARCHAR2)
1746: IS
1747: l_sqlerrno VARCHAR2(20);

Line 1744: p_resource_id IN jtf_rs_group_members.resource_id%TYPE,

1740: ----------------------------------------------------*/
1741:
1742: PROCEDURE JTF_RS_Group_Member_Post_Ins(p_group_member_id IN jtf_rs_group_members.group_member_id%TYPE,
1743: p_group_id IN jtf_rs_group_members.group_id%TYPE,
1744: p_resource_id IN jtf_rs_group_members.resource_id%TYPE,
1745: x_return_status OUT nocopy VARCHAR2)
1746: IS
1747: l_sqlerrno VARCHAR2(20);
1748: l_sqlerrmsg VARCHAR2(2000);

Line 1771: p_jtf_rs_group_memb jtf_rs_group_members%rowtype)

1767: 'CSM_WF_PKG.JTF_RS_Group_Member_Post_Ins', FND_LOG.LEVEL_EXCEPTION);
1768: END JTF_RS_Group_Member_Post_Ins;
1769:
1770: Procedure JTF_RS_Group_Member_Pre_Upd(p_user_id in number,
1771: p_jtf_rs_group_memb jtf_rs_group_members%rowtype)
1772: IS
1773: BEGIN
1774: null;
1775: END;

Line 1778: p_jtf_rs_group_memb jtf_rs_group_members%rowtype)

1774: null;
1775: END;
1776: /*
1777: Procedure JTF_RS_Group_Member_Post_Del(p_user_id in number,
1778: p_jtf_rs_group_memb jtf_rs_group_members%rowtype)
1779: IS
1780: BEGIN
1781: null;
1782: END;

Line 1795: PROCEDURE JTF_RS_Group_Member_Pre_Del(p_group_id IN jtf_rs_group_members.group_id%TYPE,

1791: p_resource_id,
1792: x_return_status
1793: ----------------------------------------------------*/
1794:
1795: PROCEDURE JTF_RS_Group_Member_Pre_Del(p_group_id IN jtf_rs_group_members.group_id%TYPE,
1796: p_resource_id IN jtf_rs_group_members.resource_id%TYPE,
1797: x_return_status OUT nocopy VARCHAR2)
1798: IS
1799: l_sqlerrno VARCHAR2(20);

Line 1796: p_resource_id IN jtf_rs_group_members.resource_id%TYPE,

1792: x_return_status
1793: ----------------------------------------------------*/
1794:
1795: PROCEDURE JTF_RS_Group_Member_Pre_Del(p_group_id IN jtf_rs_group_members.group_id%TYPE,
1796: p_resource_id IN jtf_rs_group_members.resource_id%TYPE,
1797: x_return_status OUT nocopy VARCHAR2)
1798: IS
1799: l_sqlerrno VARCHAR2(20);
1800: l_sqlerrmsg VARCHAR2(2000);

Line 2411: (rcr.resource_type='RS_GROUP' AND rcr.resource_id IN (SELECT group_id FROM jtf_rs_group_members_vl WHERE category='EMPLOYEE' AND resource_id = au.resource_id)))

2407: AND cas.cust_account_id = rcr.customer_id
2408: AND cas.status = 'A' -- only active sites
2409: AND ((rcr.resource_type='RS_EMPLOYEE' AND au.resource_id = rcr.resource_id)
2410: OR
2411: (rcr.resource_type='RS_GROUP' AND rcr.resource_id IN (SELECT group_id FROM jtf_rs_group_members_vl WHERE category='EMPLOYEE' AND resource_id = au.resource_id)))
2412: AND au.enabled='Y'
2413: AND NOT EXISTS
2414: (SELECT 1
2415: FROM csm_po_loc_ass_all_acc acc