605:
606: -- Bug 4622645
607: CURSOR csr_reason_code IS
608: SELECT lookup_code
609: FROM fnd_lookups
610: WHERE lookup_type='OKC_STS_CHG_REASON'
611: AND enabled_flag='Y'
612: AND SYSDATE BETWEEN NVL(start_date_active,SYSDATE) AND NVL(end_date_active,SYSDATE+1)
613: AND lookup_code = p_reason_code
612: AND SYSDATE BETWEEN NVL(start_date_active,SYSDATE) AND NVL(end_date_active,SYSDATE+1)
613: AND lookup_code = p_reason_code
614: UNION ALL
615: SELECT lookup_code
616: FROM fnd_lookups
617: WHERE lookup_type='OKS_CANCEL_REASON'
618: AND enabled_flag='Y'
619: AND SYSDATE BETWEEN NVL(start_date_active,SYSDATE) AND NVL(end_date_active,SYSDATE+1)
620: AND lookup_code = p_reason_code;
618: AND enabled_flag='Y'
619: AND SYSDATE BETWEEN NVL(start_date_active,SYSDATE) AND NVL(end_date_active,SYSDATE+1)
620: AND lookup_code = p_reason_code;
621:
622: l_lookup_code fnd_lookups.lookup_code%TYPE;
623:
624: BEGIN
625: x_return_status := OKC_API.G_RET_STS_SUCCESS;
626:
873: l_hstv_stsv_fk1 hstv_stsv_fk1_csr%ROWTYPE;
874:
875: --CURSOR hstv_fndv_fk1_csr (p_lookup_code IN VARCHAR2) IS
876: --SELECT 'x'
877: --FROM Fnd_Lookups
878: --WHERE fnd_lookups.lookup_code = p_lookup_code;
879: --l_hstv_fndv_fk1 hstv_fndv_fk1_csr%ROWTYPE;
880:
881: CURSOR okc_clev_pk_csr (p_id IN NUMBER) IS
874:
875: --CURSOR hstv_fndv_fk1_csr (p_lookup_code IN VARCHAR2) IS
876: --SELECT 'x'
877: --FROM Fnd_Lookups
878: --WHERE fnd_lookups.lookup_code = p_lookup_code;
879: --l_hstv_fndv_fk1 hstv_fndv_fk1_csr%ROWTYPE;
880:
881: CURSOR okc_clev_pk_csr (p_id IN NUMBER) IS
882: SELECT 'x'