179: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
180: UPDATE JTF_TASKS_B yt SET
181: cust_account_id=NUM_COL1_NEW_LIST(I)
182: , LAST_UPDATE_DATE=SYSDATE
183: , last_updated_by=arp_standard.profile.user_id
184: , last_update_login=arp_standard.profile.last_update_login
185: WHERE task_id=PRIMARY_KEY_ID_LIST(I);
186:
187: l_count := l_count + SQL%ROWCOUNT;
180: UPDATE JTF_TASKS_B yt SET
181: cust_account_id=NUM_COL1_NEW_LIST(I)
182: , LAST_UPDATE_DATE=SYSDATE
183: , last_updated_by=arp_standard.profile.user_id
184: , last_update_login=arp_standard.profile.last_update_login
185: WHERE task_id=PRIMARY_KEY_ID_LIST(I);
186:
187: l_count := l_count + SQL%ROWCOUNT;
188: IF l_last_fetch THEN
319: UPDATE JTF_TASK_AUDITS_B yt SET
320: old_cust_account_id=NUM_COL1_NEW_LIST(I)
321: , new_cust_account_id=NUM_COL2_NEW_LIST(I)
322: , LAST_UPDATE_DATE=SYSDATE
323: , last_updated_by=arp_standard.profile.user_id
324: , last_update_login=arp_standard.profile.last_update_login
325: WHERE task_audit_id=PRIMARY_KEY_ID_LIST(I)
326: ;
327: l_count := l_count + SQL%ROWCOUNT;
320: old_cust_account_id=NUM_COL1_NEW_LIST(I)
321: , new_cust_account_id=NUM_COL2_NEW_LIST(I)
322: , LAST_UPDATE_DATE=SYSDATE
323: , last_updated_by=arp_standard.profile.user_id
324: , last_update_login=arp_standard.profile.last_update_login
325: WHERE task_audit_id=PRIMARY_KEY_ID_LIST(I)
326: ;
327: l_count := l_count + SQL%ROWCOUNT;
328: IF l_last_fetch THEN
496: -- Update account id
497: UPDATE JTF_PERZ_QUERY_PARAM yt SET
498: PARAMETER_VALUE=VCHAR_COL1_NEW_LIST(I)
499: , LAST_UPDATE_DATE=SYSDATE
500: , last_updated_by=arp_standard.profile.user_id
501: , last_update_login=arp_standard.profile.last_update_login
502: WHERE QUERY_PARAM_ID=PRIMARY_KEY_ID1_LIST(I);
503: l_count := l_count + SQL%ROWCOUNT;
504:
497: UPDATE JTF_PERZ_QUERY_PARAM yt SET
498: PARAMETER_VALUE=VCHAR_COL1_NEW_LIST(I)
499: , LAST_UPDATE_DATE=SYSDATE
500: , last_updated_by=arp_standard.profile.user_id
501: , last_update_login=arp_standard.profile.last_update_login
502: WHERE QUERY_PARAM_ID=PRIMARY_KEY_ID1_LIST(I);
503: l_count := l_count + SQL%ROWCOUNT;
504:
505: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
506: -- Update account number
507: UPDATE JTF_PERZ_QUERY_PARAM yt SET
508: PARAMETER_VALUE=VCHAR_CN_NEW_LIST(I)
509: , LAST_UPDATE_DATE=SYSDATE
510: , last_updated_by=arp_standard.profile.user_id
511: , last_update_login=arp_standard.profile.last_update_login
512: WHERE QUERY_PARAM_ID=PRIMARY_KEY_ID2_LIST(I);
513: l_count := l_count + SQL%ROWCOUNT;
514:
507: UPDATE JTF_PERZ_QUERY_PARAM yt SET
508: PARAMETER_VALUE=VCHAR_CN_NEW_LIST(I)
509: , LAST_UPDATE_DATE=SYSDATE
510: , last_updated_by=arp_standard.profile.user_id
511: , last_update_login=arp_standard.profile.last_update_login
512: WHERE QUERY_PARAM_ID=PRIMARY_KEY_ID2_LIST(I);
513: l_count := l_count + SQL%ROWCOUNT;
514:
515: IF l_last_fetch THEN