APPS.CSM_QUERY_INSTANCE_PKG dependencies on ASG_DOWNLOAD

Line 174: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_name,

170: VALUES (l_instance_id, l_user_id, l_query_id, l_instance_id,l_instance_name,'OPEN',
171: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.login_id);
172:
173: IF csm_util_pkg.is_palm_user(l_user_id) THEN
174: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_name,
175: p_accessid => l_instance_id, --same as access id
176: p_userid => l_user_id,
177: p_dml => asg_download.ins,
178: p_timestamp => sysdate);

Line 177: p_dml => asg_download.ins,

173: IF csm_util_pkg.is_palm_user(l_user_id) THEN
174: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_name,
175: p_accessid => l_instance_id, --same as access id
176: p_userid => l_user_id,
177: p_dml => asg_download.ins,
178: p_timestamp => sysdate);
179: END IF;
180:
181: OPEN c_get_variables (l_query_id);

Line 267: l_mark_dirty := asg_Download.mark_dirty(p_pub_item => g_pub_qvv_name,

263: l_user_id, SYSDATE, l_user_id, SYSDATE, l_user_id,l_qvariable_id)
264: RETURNING ACCESS_ID into l_access_id;
265:
266: IF csm_util_pkg.is_palm_user(l_user_id) THEN
267: l_mark_dirty := asg_Download.mark_dirty(p_pub_item => g_pub_qvv_name,
268: p_accessid => l_access_id,
269: p_userid => l_user_id,
270: p_dml => asg_download.ins,
271: p_timestamp => sysdate);

Line 270: p_dml => asg_download.ins,

266: IF csm_util_pkg.is_palm_user(l_user_id) THEN
267: l_mark_dirty := asg_Download.mark_dirty(p_pub_item => g_pub_qvv_name,
268: p_accessid => l_access_id,
269: p_userid => l_user_id,
270: p_dml => asg_download.ins,
271: p_timestamp => sysdate);
272: END IF;
273: END LOOP;
274: