[Home] [Help]
634: FOR I IN 1..P_RQL_TBL.COUNT LOOP
635: BEGIN
636: SELECT count(requirement_line_id)
637: INTO l_count
638: FROM csp_Req_line_details
639: where requirement_line_id = P_RQL_Tbl(I).requirement_line_id;
640:
641: IF l_count > 0 THEN
642: FND_MESSAGE.SET_NAME ('CSP', 'CSP_RQMT_LINE_DELETE_ERROR');