273: -- cursors to check if wildcard values '%' and '_' have been passed
274: -- as item values
275: CURSOR c_chk_str1(p_rec_item VARCHAR2) IS
276: SELECT instr(p_rec_item, '%', 1, 1)
277: FROM dual;
278: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
279: SELECT instr(p_rec_item, '_', 1, 1)
280: FROM dual;
281:
276: SELECT instr(p_rec_item, '%', 1, 1)
277: FROM dual;
278: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
279: SELECT instr(p_rec_item, '_', 1, 1)
280: FROM dual;
281:
282: -- return values from cursors
283: str_csr1 NUMBER;
284: str_csr2 NUMBER;
1142:
1143:
1144: SELECT SYSDATE
1145: INTO l_transaction_date
1146: FROM dual;
1147:
1148: IF p_transaction_rec.transaction_date=fnd_api.g_miss_date THEN
1149: l_transaction_date:=l_transaction_date;
1150: END IF;