DBA Data[Home] [Help]

APPS.AST_RS_CAMP_PVT dependencies on DUAL

Line 831: FROM DUAL;

827: -- cursors to check if wildcard values '%' and '_' have been passed
828: -- as item values
829: CURSOR c_chk_str1(p_rec_item VARCHAR2) IS
830: SELECT INSTR(p_rec_item, '%', 1, 1)
831: FROM DUAL;
832: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
833: SELECT INSTR(p_rec_item, '_', 1, 1)
834: FROM DUAL;
835:

Line 834: FROM DUAL;

830: SELECT INSTR(p_rec_item, '%', 1, 1)
831: FROM DUAL;
832: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
833: SELECT INSTR(p_rec_item, '_', 1, 1)
834: FROM DUAL;
835:
836: -- return values from cursors
837: str_csr1 NUMBER;
838: str_csr2 NUMBER;