eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_QUERY_PKG dependencies on ASG_DOWNLOAD

Line 58: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qins,

54: RETURNING ACCESS_ID INTO l_access_id;
55:
56: IF csm_util_pkg.is_palm_user(p_USER_ID) AND l_access_id IS NOT NULL THEN
57:
58: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qins,
59: p_accessid => l_access_id,
60: p_userid => p_USER_ID,
61: p_dml => asg_download.upd,
62: p_timestamp => sysdate);

Line 61: p_dml => asg_download.upd,

57:
58: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qins,
59: p_accessid => l_access_id,
60: p_userid => p_USER_ID,
61: p_dml => asg_download.upd,
62: p_timestamp => sysdate);
63: END IF;
64:
65: CSM_UTIL_PKG.LOG

Line 1059: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qres,

1055: END IF;
1056:
1057: IF csm_util_pkg.is_palm_user(p_USER_ID) THEN
1058: IF l_rs_access_id IS NULL THEN
1059: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qres,
1060: p_accessid => l_access_id,
1061: p_userid => p_USER_ID,
1062: p_dml => asg_download.ins,
1063: p_timestamp => sysdate);

Line 1062: p_dml => asg_download.ins,

1058: IF l_rs_access_id IS NULL THEN
1059: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qres,
1060: p_accessid => l_access_id,
1061: p_userid => p_USER_ID,
1062: p_dml => asg_download.ins,
1063: p_timestamp => sysdate);
1064: ELSE
1065: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qres,
1066: p_accessid => l_access_id,

Line 1065: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qres,

1061: p_userid => p_USER_ID,
1062: p_dml => asg_download.ins,
1063: p_timestamp => sysdate);
1064: ELSE
1065: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qres,
1066: p_accessid => l_access_id,
1067: p_userid => p_USER_ID,
1068: p_dml => asg_download.upd,
1069: p_timestamp => sysdate);

Line 1068: p_dml => asg_download.upd,

1064: ELSE
1065: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qres,
1066: p_accessid => l_access_id,
1067: p_userid => p_USER_ID,
1068: p_dml => asg_download.upd,
1069: p_timestamp => sysdate);
1070:
1071: END IF;
1072: END IF;

Line 1318: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qins,

1314: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.login_id);
1315:
1316:
1317: IF csm_util_pkg.is_palm_user(p_USER_ID) THEN
1318: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qins,
1319: p_accessid => l_instance_id, --same as access id
1320: p_userid => p_USER_ID,
1321: p_dml => asg_download.ins,
1322: p_timestamp => sysdate);

Line 1321: p_dml => asg_download.ins,

1317: IF csm_util_pkg.is_palm_user(p_USER_ID) THEN
1318: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qins,
1319: p_accessid => l_instance_id, --same as access id
1320: p_userid => p_USER_ID,
1321: p_dml => asg_download.ins,
1322: p_timestamp => sysdate);
1323: END IF;
1324:
1325: --set the newly created instance id

Line 1402: l_mark_dirty := asg_Download.mark_dirty(p_pub_item => g_pub_item_qval,

1398: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.login_id,l_qvariable_id)
1399: RETURNING ACCESS_ID into l_access_id;
1400:
1401: IF csm_util_pkg.is_palm_user(p_USER_ID) THEN
1402: l_mark_dirty := asg_Download.mark_dirty(p_pub_item => g_pub_item_qval,
1403: p_accessid => l_access_id,
1404: p_userid => p_USER_ID,
1405: p_dml => asg_download.ins,
1406: p_timestamp => sysdate);

Line 1405: p_dml => asg_download.ins,

1401: IF csm_util_pkg.is_palm_user(p_USER_ID) THEN
1402: l_mark_dirty := asg_Download.mark_dirty(p_pub_item => g_pub_item_qval,
1403: p_accessid => l_access_id,
1404: p_userid => p_USER_ID,
1405: p_dml => asg_download.ins,
1406: p_timestamp => sysdate);
1407: END IF;
1408: END LOOP;
1409:

Line 1637: l_access_id_list ASG_DOWNLOAD.ACCESS_LIST;

1633: WHERE QUERY_ID = c_QUERY_ID
1634: AND USER_ID = c_USER_ID
1635: AND INSTANCE_ID = c_INSTANCE_ID;
1636:
1637: l_access_id_list ASG_DOWNLOAD.ACCESS_LIST;
1638: l_instance_name VARCHAR2(255);
1639: l_access_id NUMBER;
1640: l_mark_dirty BOOLEAN;
1641: BEGIN

Line 1664: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qins,

1660:
1661: DELETE FROM CSM_QUERY_INSTANCES_ACC WHERE ACCESS_ID = l_access_id;
1662:
1663: IF csm_util_pkg.is_palm_user(p_USER_ID) THEN
1664: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qins,
1665: p_accessid => l_access_id, --same as access id
1666: p_userid => p_USER_ID,
1667: p_dml => asg_download.del,
1668: p_timestamp => sysdate);

Line 1667: p_dml => asg_download.del,

1663: IF csm_util_pkg.is_palm_user(p_USER_ID) THEN
1664: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qins,
1665: p_accessid => l_access_id, --same as access id
1666: p_userid => p_USER_ID,
1667: p_dml => asg_download.del,
1668: p_timestamp => sysdate);
1669: END IF;
1670:
1671: --Delete the Variable Values attached to the instance

Line 1681: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qval,

1677: DELETE FROM CSM_QUERY_VARIABLE_VALUES_ACC WHERE ACCESS_ID = l_access_id_list(i);
1678:
1679: IF csm_util_pkg.is_palm_user(p_USER_ID) THEN
1680: FOR i in 1..l_access_id_list.COUNT LOOP
1681: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qval,
1682: p_accessid => l_access_id_list(i), --same as access id
1683: p_userid => p_USER_ID,
1684: p_dml => asg_download.del,
1685: p_timestamp => sysdate);

Line 1684: p_dml => asg_download.del,

1680: FOR i in 1..l_access_id_list.COUNT LOOP
1681: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qval,
1682: p_accessid => l_access_id_list(i), --same as access id
1683: p_userid => p_USER_ID,
1684: p_dml => asg_download.del,
1685: p_timestamp => sysdate);
1686: END LOOP;
1687: END IF;
1688:

Line 1702: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qres,

1698: DELETE FROM CSM_QUERY_RESULTS_ACC WHERE ACCESS_ID = l_access_id_list(i);
1699:
1700: IF csm_util_pkg.is_palm_user(p_USER_ID) THEN
1701: FOR i in 1..l_access_id_list.COUNT LOOP
1702: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qres,
1703: p_accessid => l_access_id_list(i), --same as access id
1704: p_userid => p_USER_ID,
1705: p_dml => asg_download.del,
1706: p_timestamp => sysdate);

Line 1705: p_dml => asg_download.del,

1701: FOR i in 1..l_access_id_list.COUNT LOOP
1702: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qres,
1703: p_accessid => l_access_id_list(i), --same as access id
1704: p_userid => p_USER_ID,
1705: p_dml => asg_download.del,
1706: p_timestamp => sysdate);
1707: END LOOP;
1708: END IF;
1709:

Line 1999: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qres,

1995: END IF;
1996:
1997: IF csm_util_pkg.is_palm_user(p_USER_ID) THEN
1998: IF l_rs_access_id IS NULL THEN
1999: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qres,
2000: p_accessid => l_access_id,
2001: p_userid => p_USER_ID,
2002: p_dml => asg_download.ins,
2003: p_timestamp => sysdate);

Line 2002: p_dml => asg_download.ins,

1998: IF l_rs_access_id IS NULL THEN
1999: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qres,
2000: p_accessid => l_access_id,
2001: p_userid => p_USER_ID,
2002: p_dml => asg_download.ins,
2003: p_timestamp => sysdate);
2004: ELSE
2005: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qres,
2006: p_accessid => l_access_id,

Line 2005: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qres,

2001: p_userid => p_USER_ID,
2002: p_dml => asg_download.ins,
2003: p_timestamp => sysdate);
2004: ELSE
2005: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qres,
2006: p_accessid => l_access_id,
2007: p_userid => p_USER_ID,
2008: p_dml => asg_download.upd,
2009: p_timestamp => sysdate);

Line 2008: p_dml => asg_download.upd,

2004: ELSE
2005: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qres,
2006: p_accessid => l_access_id,
2007: p_userid => p_USER_ID,
2008: p_dml => asg_download.upd,
2009: p_timestamp => sysdate);
2010:
2011: END IF;
2012: END IF;