APPS.CSP_ORDERHEADERS_PVT dependencies on DUAL

Line 934: FROM DUAL;

930: -- cursors to check if wildcard values '%' and '_' have been passed
931: -- as item values
932: CURSOR c_chk_str1(p_rec_item VARCHAR2) IS
933: SELECT INSTR(p_rec_item, '%', 1, 1)
934: FROM DUAL;
935: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
936: SELECT INSTR(p_rec_item, '_', 1, 1)
937: FROM DUAL;
938:

Line 937: FROM DUAL;

933: SELECT INSTR(p_rec_item, '%', 1, 1)
934: FROM DUAL;
935: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
936: SELECT INSTR(p_rec_item, '_', 1, 1)
937: FROM DUAL;
938:
939: -- return values from cursors
940: str_csr1 NUMBER;
941: str_csr2 NUMBER;