1908: PROCEDURE CSF_Debrief_Header_Post_Del(x_return_status OUT NOCOPY VARCHAR2)
1909: IS
1910: l_debrief_header_id csf_debrief_headers.debrief_header_id%TYPE;
1911: l_task_assignment_id csf_debrief_headers.task_assignment_id%type;
1912: l_user_id fnd_user.user_id%type;
1913: l_resource_id jtf_rs_resource_extns.resource_id%type;
1914:
1915: CURSOR l_csm_debrfdel_csr (p_debrief_header_id csf_debrief_headers.debrief_header_id%type) IS
1916: SELECT dhdr.task_assignment_id, jtrs.user_id, jta.resource_id
2281: l_organization_id csp_inv_loc_assignments.organization_id%TYPE;
2282: l_subinventory_code csp_inv_loc_assignments.subinventory_code%TYPE;
2283: l_eff_date_start DATE;
2284: l_eff_date_end DATE;
2285: l_user_id fnd_user.user_id%TYPE;
2286: l_resource_id csp_inv_loc_assignments.resource_id%TYPE;
2287: l_default_code csp_inv_loc_assignments.default_code%TYPE;
2288: l_sqlerrno VARCHAR2(20);
2289: l_sqlerrmsg VARCHAR2(2000);