DBA Data[Home] [Help]

APPS.CSP_TASK_PART_PVT dependencies on DUAL

Line 803: FROM DUAL;

799: -- cursors to check if wildcard values '%' and '_' have been passed
800: -- as item values
801: CURSOR c_chk_str1(p_rec_item VARCHAR2) IS
802: SELECT INSTR(p_rec_item, '%', 1, 1)
803: FROM DUAL;
804: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
805: SELECT INSTR(p_rec_item, '_', 1, 1)
806: FROM DUAL;
807: -- return values from cursors

Line 806: FROM DUAL;

802: SELECT INSTR(p_rec_item, '%', 1, 1)
803: FROM DUAL;
804: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
805: SELECT INSTR(p_rec_item, '_', 1, 1)
806: FROM DUAL;
807: -- return values from cursors
808: str_csr1 NUMBER;
809: str_csr2 NUMBER;
810: l_operator VARCHAR2(10);