90: WHERE event_offer_id = p_activity_id ;
91:
92: CURSOR c_emp_dtl(l_res_id IN NUMBER) IS
93: SELECT employee_id
94: FROM ams_jtf_rs_emp_v
95: WHERE resource_id = l_res_id ;
96:
97: l_user_id NUMBER ;
98: l_emp_id NUMBER ;
2024: x_return_status OUT NOCOPY VARCHAR2)
2025: IS
2026: CURSOR c_resource IS
2027: SELECT employee_id source_id
2028: FROM ams_jtf_rs_emp_v
2029: WHERE resource_id = p_user_id ;
2030: l_person_id number;
2031: BEGIN
2032: x_return_status := FND_API.G_RET_STS_SUCCESS;
3351:
3352: -- anchaudh defining cursor for setting item owner along with bug fix for bug# 3799053
3353: CURSOR c_emp_dtl(l_res_id IN NUMBER) IS
3354: SELECT employee_id
3355: FROM ams_jtf_rs_emp_v
3356: WHERE resource_id = l_res_id ;
3357:
3358: CURSOR c_trig_det IS
3359: SELECT *