DBA Data[Home] [Help]

APPS.CSP_RESOURCE_PVT dependencies on DUAL

Line 905: FROM DUAL;

901: -- cursors to check if wildcard values '%' and '_' have been passed
902: -- as item values
903: CURSOR c_chk_str1(p_rec_item VARCHAR2) IS
904: SELECT INSTR(p_rec_item, '%', 1, 1)
905: FROM DUAL;
906: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
907: SELECT INSTR(p_rec_item, '_', 1, 1)
908: FROM DUAL;
909:

Line 908: FROM DUAL;

904: SELECT INSTR(p_rec_item, '%', 1, 1)
905: FROM DUAL;
906: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
907: SELECT INSTR(p_rec_item, '_', 1, 1)
908: FROM DUAL;
909:
910: -- return values from cursors
911: str_csr1 NUMBER;
912: str_csr2 NUMBER;