DBA Data[Home] [Help]

APPS.JTF_IH_MERGE_PKG dependencies on STANDARD

Line 116: , last_updated_by=arp_standard.profile.user_id

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

Line 117: , last_update_login=arp_standard.profile.last_update_login

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

Line 119: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

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: ;

Line 120: , PROGRAM_ID=arp_standard.profile.program_id

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;