459: c_mr_header_id number
460: )
461: IS
462: SELECT 'x'
463: FROM ahl_mr_headers_b
464: WHERE mr_header_id = c_mr_header_id AND
465: program_type_code = 'MO_PROC';
466:
467: l_dummy_char VARCHAR2(1);
475: CURSOR Check_Visit_Type(c_mr_header_id NUMBER)
476: IS
477: SELECT 'x'
478: FROM AHL_MR_VISIT_TYPES vt,
479: AHL_MR_HEADERS_B mrh
480: WHERE vt.mr_header_id = mrh.mr_header_id
481: AND mrh.implement_status_code IN ('MANDATORY','OPTIONAL_IMPLEMENT')
482: AND mrh.mr_header_id = c_mr_header_id;
483: -- pdoki added for Auto Visit Forecasting Project, End.
491:
492: CURSOR Get_Plan_MR_title(c_mr_header_id NUMBER)
493: IS
494: SELECT title
495: FROM AHL_MR_HEADERS_B
496: WHERE mr_header_id = c_mr_header_id
497: AND implement_status_code IN ('MANDATORY','OPTIONAL_IMPLEMENT');
498:
499: -- pdoki modified for bug 16505562
496: WHERE mr_header_id = c_mr_header_id
497: AND implement_status_code IN ('MANDATORY','OPTIONAL_IMPLEMENT');
498:
499: -- pdoki modified for bug 16505562
500: l_mr_title AHL_MR_HEADERS_B.TITLE%TYPE;
501:
502: -- Kasridha: Changes for Bug#13741458 Ends
503:
504: BEGIN