DBA Data[Home] [Help]

APPS.OKS_EXTWAR_UTIL_PVT dependencies on DUAL

Line 514: FROM DUAL;

510: l_cc_num_char character_tab_typ;
511: BEGIN
512: SELECT LENGTH (p_credit_card_num)
513: INTO len_credit_card_num
514: FROM DUAL;
515:
516: FOR i IN 1 .. len_credit_card_num
517: LOOP
518: SELECT SUBSTR (p_credit_card_num, i, 1)

Line 520: FROM DUAL;

516: FOR i IN 1 .. len_credit_card_num
517: LOOP
518: SELECT SUBSTR (p_credit_card_num, i, 1)
519: INTO l_cc_num_char (i)
520: FROM DUAL;
521:
522: IF ((l_cc_num_char (i) >= '0') AND (l_cc_num_char (i) <= '9'))
523: THEN
524: -- Numeric digit. Add to stripped_number and table.