DBA Data[Home] [Help]

APPS.ICX_POR_MAP_CATEGORIES dependencies on ICX_POR_BATCH_JOBS_S

Line 158: SELECT icx_por_batch_jobs_s.nextval

154: p_message := p_message ||'; No: of rows updated in icx_cat_ext_items_tlp:' ||SQL%ROWCOUNT;
155:
156: xErrLoc := 900;
157: --Get the jobNum to update in icx_cat_items_tlp for the rebuild of intermedia index
158: SELECT icx_por_batch_jobs_s.nextval
159: INTO v_jobNum
160: FROM dual;
161: xErrLoc := 810;
162: p_message := p_message ||'; jobNum:' ||v_jobNum;