DBA Data[Home] [Help]

APPS.CSD_REPAIR_HISTORY_PVT dependencies on DUAL

Line 1185: FROM DUAL;

1181: -- cursors to check if wildcard values '%' and '_' have been passed
1182: -- as item values
1183: CURSOR c_chk_str1(p_rec_item VARCHAR2) IS
1184: SELECT INSTR(p_rec_item, '%', 1, 1)
1185: FROM DUAL;
1186: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
1187: SELECT INSTR(p_rec_item, '_', 1, 1)
1188: FROM DUAL;
1189:

Line 1188: FROM DUAL;

1184: SELECT INSTR(p_rec_item, '%', 1, 1)
1185: FROM DUAL;
1186: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
1187: SELECT INSTR(p_rec_item, '_', 1, 1)
1188: FROM DUAL;
1189:
1190: -- return values from cursors
1191: str_csr1 NUMBER;
1192: str_csr2 NUMBER;