APPS.BNE_CONTENT_UTILS dependencies on DUAL

Line 518: FROM SYS.DUAL;

514: -- determine the length of the comma delimited list of columns
515:
516: SELECT LENGTH(P_COL_LIST)
517: INTO VN_LIST_LENGTH
518: FROM SYS.DUAL;
519:
520: WHILE VN_START_POS <= VN_LIST_LENGTH LOOP
521:
522: -- find the position of the next comma delimiter in the column list

Line 526: FROM SYS.DUAL;

522: -- find the position of the next comma delimiter in the column list
523:
524: SELECT INSTR(P_COL_LIST, ',', VN_START_POS)
525: INTO VN_CURR_POS
526: FROM SYS.DUAL;
527:
528: -- If there are no more comma delimiters, set the current position
529: -- to be the greater than the list length - so the loop will terminate
530:

Line 539: FROM SYS.DUAL;

535: -- get the column name and trim all spaces from the left and right of the string
536:
537: SELECT TRIM(' ' FROM (SUBSTR(P_COL_LIST, VN_START_POS, (VN_CURR_POS - VN_PREV_POS - 1))))
538: INTO VV_COL_NAME
539: FROM SYS.DUAL;
540:
541: -- insert the column into BNE_CONTENT_COLS_B and BNE_CONTENT_COLS_TL
542:
543: UPSERT_CONTENT_COL(P_APPLICATION_ID,