112: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
113: UPDATE JTF_IH_ACTIVITIES yt SET
114: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
115: , LAST_UPDATE_DATE=SYSDATE
116: , last_updated_by=arp_standard.profile.user_id
117: , last_update_login=arp_standard.profile.last_update_login
118: , REQUEST_ID=req_id
119: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
120: , PROGRAM_ID=arp_standard.profile.program_id
113: UPDATE JTF_IH_ACTIVITIES yt SET
114: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
115: , LAST_UPDATE_DATE=SYSDATE
116: , last_updated_by=arp_standard.profile.user_id
117: , last_update_login=arp_standard.profile.last_update_login
118: , REQUEST_ID=req_id
119: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
120: , PROGRAM_ID=arp_standard.profile.program_id
121: , PROGRAM_UPDATE_DATE=SYSDATE
115: , LAST_UPDATE_DATE=SYSDATE
116: , last_updated_by=arp_standard.profile.user_id
117: , last_update_login=arp_standard.profile.last_update_login
118: , REQUEST_ID=req_id
119: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
120: , PROGRAM_ID=arp_standard.profile.program_id
121: , PROGRAM_UPDATE_DATE=SYSDATE
122: WHERE ACTIVITY_ID=PRIMARY_KEY_ID_LIST(I)
123: ;
116: , last_updated_by=arp_standard.profile.user_id
117: , last_update_login=arp_standard.profile.last_update_login
118: , REQUEST_ID=req_id
119: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
120: , PROGRAM_ID=arp_standard.profile.program_id
121: , PROGRAM_UPDATE_DATE=SYSDATE
122: WHERE ACTIVITY_ID=PRIMARY_KEY_ID_LIST(I)
123: ;
124: l_count := l_count + SQL%ROWCOUNT;