DBA Data[Home] [Help]

APPS.RRS_PARTY_MERGE_PKG dependencies on FND_GLOBAL

Line 74: last_updated_by = FND_GLOBAL.user_id,

70: IF (c_sites%FOUND) THEN
71: UPDATE rrs_sites_b
72: SET site_party_id = p_to_fk_id,
73: last_update_date = SYSDATE,
74: last_updated_by = FND_GLOBAL.user_id,
75: last_update_login = FND_GLOBAL.user_id
76: WHERE site_party_id = p_from_fk_id;
77: END IF;
78: CLOSE c_sites;

Line 75: last_update_login = FND_GLOBAL.user_id

71: UPDATE rrs_sites_b
72: SET site_party_id = p_to_fk_id,
73: last_update_date = SYSDATE,
74: last_updated_by = FND_GLOBAL.user_id,
75: last_update_login = FND_GLOBAL.user_id
76: WHERE site_party_id = p_from_fk_id;
77: END IF;
78: CLOSE c_sites;
79:

Line 139: last_updated_by = FND_GLOBAL.user_id,

135: IF ( get_sites_for_update%FOUND ) THEN
136: UPDATE rrs_sites_b
137: SET le_party_id = p_to_fk_id,
138: last_update_date = SYSDATE,
139: last_updated_by = FND_GLOBAL.user_id,
140: last_update_login = FND_GLOBAL.user_id
141: WHERE le_party_id = p_from_fk_id;
142: END IF;
143: CLOSE get_sites_for_update;

Line 140: last_update_login = FND_GLOBAL.user_id

136: UPDATE rrs_sites_b
137: SET le_party_id = p_to_fk_id,
138: last_update_date = SYSDATE,
139: last_updated_by = FND_GLOBAL.user_id,
140: last_update_login = FND_GLOBAL.user_id
141: WHERE le_party_id = p_from_fk_id;
142: END IF;
143: CLOSE get_sites_for_update;
144: END IF;