APPS.EDW_SOURCE_INST_PKG dependencies on EDW_SOURCE_INSTANCES_TL

Line 48: UPDATE edw_source_instances_tl

44:
45: l_login_id := fnd_global.LOGIN_ID;
46:
47:
48: UPDATE edw_source_instances_tl
49: SET DESCRIPTION = p_src_inst_rec.description
50: ,NAME = p_src_inst_rec.name
51: , LAST_UPDATE_DATE = SYSDATE
52: , LAST_UPDATED_BY = l_user_id

Line 101: UPDATE edw_source_instances_tl

97: , LAST_UPDATED_BY = l_user_id
98: , LAST_UPDATE_LOGIN = l_login_id
99: where instance_code = p_src_inst_rec.instance_code;
100:
101: UPDATE edw_source_instances_tl
102: SET DESCRIPTION = p_src_inst_rec.description
103: ,NAME = p_src_inst_rec.name
104: , LAST_UPDATE_DATE = SYSDATE
105: , LAST_UPDATED_BY = l_user_id

Line 125: INSERT INTO EDW_SOURCE_INSTANCES_TL(

121: p_src_inst_rec.link, sysdate,
122: l_user_id, sysdate,
123: l_user_id, l_login_id);
124:
125: INSERT INTO EDW_SOURCE_INSTANCES_TL(
126: INSTANCE_CODE, LANGUAGE,
127: TRANSLATED, SOURCE_LANG,
128: NAME, DESCRIPTION,
129: CREATION_DATE, CREATED_BY,

Line 141: (SELECT 'EXISTS' FROM edw_source_instances e, edw_source_instances_tl tl

137: edw_source_instances e
138: where l.installed_flag in ('I', 'B')
139: and e.instance_code = p_src_inst_rec.instance_code
140: and NOT EXISTS
141: (SELECT 'EXISTS' FROM edw_source_instances e, edw_source_instances_tl tl
142: WHERE tl.instance_code = e.instance_code
143: and tl.language = l.language_code);
144:
145: WHEN OTHERS THEN