APPS.CN_UPGRADE_UTL_PKG dependencies on CN_COMM_LINES_API_ALL

Line 419: l_table_name VARCHAR2(30) := 'CN_COMM_LINES_API_ALL';

415: p_batch_size IN NUMBER,
416: p_num_workers IN NUMBER,
417: p_worker_id IN NUMBER) IS
418:
419: l_table_name VARCHAR2(30) := 'CN_COMM_LINES_API_ALL';
420: -- l_update_name VARCHAR2(30) := 'CNGSICNCMAUPD1212';
421: l_update_name VARCHAR2(30) := 'CNSCNUPD12.0.9';
422:
423: l_product VARCHAR2(30) := 'CN' ;

Line 495: UPDATE /*+ ROWID (clp) */ cn_comm_lines_api_all clp

491: WHILE (l_any_rows_to_process = TRUE) LOOP
492:
493: BEGIN
494:
495: UPDATE /*+ ROWID (clp) */ cn_comm_lines_api_all clp
496: SET clp.preserve_credit_override_flag = NVL(clp.preserve_credit_override_flag,'N'),
497: clp.adjust_status = NVL(clp.adjust_status,'NEW')
498: WHERE ROWID BETWEEN l_start_rowid AND l_end_rowid
499: AND ( CLP.PRESERVE_CREDIT_OVERRIDE_FLAG IS NULL