APPS.BNE_CONTENT_UTILS dependencies on DUAL

Line 511: FROM SYS.DUAL;

507: -- determine the length of the comma delimited list of columns
508:
509: SELECT LENGTH(P_COL_LIST)
510: INTO VN_LIST_LENGTH
511: FROM SYS.DUAL;
512:
513: WHILE VN_START_POS <= VN_LIST_LENGTH LOOP
514:
515: -- find the position of the next comma delimiter in the column list

Line 519: FROM SYS.DUAL;

515: -- find the position of the next comma delimiter in the column list
516:
517: SELECT INSTR(P_COL_LIST, ',', VN_START_POS)
518: INTO VN_CURR_POS
519: FROM SYS.DUAL;
520:
521: -- If there are no more comma delimiters, set the current position
522: -- to be the greater than the list length - so the loop will terminate
523:

Line 532: FROM SYS.DUAL;

528: -- get the column name and trim all spaces from the left and right of the string
529:
530: SELECT TRIM(' ' FROM (SUBSTR(P_COL_LIST, VN_START_POS, (VN_CURR_POS - VN_PREV_POS - 1))))
531: INTO VV_COL_NAME
532: FROM SYS.DUAL;
533:
534: -- insert the column into BNE_CONTENT_COLS_B and BNE_CONTENT_COLS_TL
535:
536: UPSERT_CONTENT_COL(P_APPLICATION_ID,