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.JTM_CON_QUERY_REQUEST_PKG dependencies on ASG_DOWNLOAD

Line 105: l_csl_tab_user ASG_DOWNLOAD.USER_LIST;

101: AND bas.descriptive_flexfield_name = p_dff_name
102: );
103: L_API_NAME constant varchar2(30) := 'FIX_DFF_ACC';
104:
105: l_csl_tab_user ASG_DOWNLOAD.USER_LIST;
106: l_csm_tab_user ASG_DOWNLOAD.USER_LIST;
107: l_tab_user ASG_DOWNLOAD.USER_LIST;
108: l_pub_item varchar2(30);
109: l_dummy BOOLEAN;

Line 106: l_csm_tab_user ASG_DOWNLOAD.USER_LIST;

102: );
103: L_API_NAME constant varchar2(30) := 'FIX_DFF_ACC';
104:
105: l_csl_tab_user ASG_DOWNLOAD.USER_LIST;
106: l_csm_tab_user ASG_DOWNLOAD.USER_LIST;
107: l_tab_user ASG_DOWNLOAD.USER_LIST;
108: l_pub_item varchar2(30);
109: l_dummy BOOLEAN;
110: BEGIN

Line 107: l_tab_user ASG_DOWNLOAD.USER_LIST;

103: L_API_NAME constant varchar2(30) := 'FIX_DFF_ACC';
104:
105: l_csl_tab_user ASG_DOWNLOAD.USER_LIST;
106: l_csm_tab_user ASG_DOWNLOAD.USER_LIST;
107: l_tab_user ASG_DOWNLOAD.USER_LIST;
108: l_pub_item varchar2(30);
109: l_dummy BOOLEAN;
110: BEGIN
111:

Line 182: l_dummy := asg_download.mark_dirty (

178: l_pub_item := 'FND_DESC_FLEX_CONTEXTS';
179: END IF;
180:
181: FOR i IN l_tab_user.FIRST..l_tab_user.LAST LOOP
182: l_dummy := asg_download.mark_dirty (
183: p_pub_item => l_pub_item,
184: p_accessid => c_old_context_acc.access_id,
185: p_userid => l_tab_user(i),
186: p_dml => 'I',

Line 251: l_dummy := asg_download.mark_dirty (

247: l_pub_item := 'FND_DESC_FLEX_COL_USGS';
248: END IF;
249:
250: FOR i IN l_tab_user.FIRST..l_tab_user.LAST LOOP
251: l_dummy := asg_download.mark_dirty (
252: p_pub_item => l_pub_item,
253: p_accessid => c_old_col_usg_acc.access_id,
254: p_userid => l_tab_user(i),
255: p_dml => 'I',

Line 320: l_dummy := asg_download.mark_dirty (

316: l_pub_item := 'FND_FLEX_VALUES';
317: END IF;
318:
319: FOR i IN l_tab_user.FIRST..l_tab_user.LAST LOOP
320: l_dummy := asg_download.mark_dirty (
321: p_pub_item => l_pub_item,
322: p_accessid => c_old_value_acc.access_id,
323: p_userid => l_tab_user(i),
324: p_dml => 'I',

Line 389: l_dummy := asg_download.mark_dirty (

385: l_pub_item := 'FND_FLEX_VALUE_SETS';
386: END IF;
387:
388: FOR i IN l_tab_user.FIRST..l_tab_user.LAST LOOP
389: l_dummy := asg_download.mark_dirty (
390: p_pub_item => l_pub_item,
391: p_accessid => c_old_value_set_acc.access_id,
392: p_userid => l_tab_user(i),
393: p_dml => 'I',

Line 506: ,p_accessList IN ASG_DOWNLOAD.ACCESS_LIST

502: END;
503:
504: FUNCTION markdirty_helper(
505: p_con_query_id IN NUMBER
506: ,p_accessList IN ASG_DOWNLOAD.ACCESS_LIST
507: ,p_dml_type IN CHAR
508: ) RETURN BOOLEAN IS
509:
510: TYPE pitnameTab IS TABLE OF JTM_PUB_ACC.PUBLICATION_ITEM_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 514: local_tab_resource ASG_DOWNLOAD.USER_LIST;

510: TYPE pitnameTab IS TABLE OF JTM_PUB_ACC.PUBLICATION_ITEM_NAME%TYPE INDEX BY BINARY_INTEGER;
511: l_publication_item_name pitnameTab;
512:
513: local_item_resources c_item_resources%ROWTYPE;
514: local_tab_resource ASG_DOWNLOAD.USER_LIST;
515: l_dummy BOOLEAN;
516: j BINARY_INTEGER;
517:
518: BEGIN

Line 529: l_dummy := asg_download.markDirty (

525: OPEN c_item_resources(l_publication_item_name(j));
526: FETCH c_item_resources BULK COLLECT INTO local_tab_resource;
527:
528: IF c_item_resources%ROWCOUNT > 0 THEN
529: l_dummy := asg_download.markDirty (
530: p_pub_item => l_publication_item_name(j)
531: ,p_accessList => p_accessList
532: ,p_resourceList => local_tab_resource
533: ,p_dml_type => p_dml_type

Line 571: m_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

567:
568: l_primary_key VARCHAR2(4000);
569: l_original_primary_key VARCHAR2(4000);
570: l_tab_access_id dbms_sql.Number_Table;
571: m_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
572:
573: l_cursor INTEGER;
574: l_count INTEGER;
575: l_index NUMBER;

Line 817: /* push to oLite using asg_download */

813: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
814: , v_module => 'jtm_message_log_pkg');
815: END IF;
816:
817: /*** push to oLite using asg_download ***/
818:
819: FOR i IN l_tab_access_id.FIRST..l_tab_access_id.LAST LOOP
820: m_tab_access_id(i) := l_tab_access_id(i);
821: END LOOP;

Line 898: /* push to oLite using asg_download */

894: , v_message => 'Pushing ' || l_tab_access_id.COUNT || ' deleted record(s) to subscribed resources.'
895: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
896: , v_module => 'jtm_message_log_pkg');
897: END IF;
898: /*** push to oLite using asg_download ***/
899:
900: FOR i IN l_tab_access_id.FIRST..l_tab_access_id.LAST LOOP
901: m_tab_access_id(i) := l_tab_access_id(i);
902: END LOOP;

Line 993: m_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

989: l_dynamic_stmt VARCHAR2(4000);
990:
991: l_primary_key VARCHAR2(2000);
992: l_tab_access_id dbms_sql.Number_Table;
993: m_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
994:
995: l_cursor INTEGER;
996: l_count INTEGER;
997: l_index NUMBER;

Line 1205: /* push to oLite using asg_download */

1201: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1202: , v_module => 'jtm_message_log_pkg');
1203: END IF;
1204:
1205: /*** push to oLite using asg_download ***/
1206:
1207: FOR i IN l_tab_access_id.FIRST..l_tab_access_id.LAST LOOP
1208: m_tab_access_id(i) := l_tab_access_id(i);
1209: END LOOP;

Line 1271: /* push to oLite using asg_download */

1267: , v_message => 'Pushing ' || l_tab_access_id.COUNT || ' deleted record(s) to subscribed resources.'
1268: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1269: , v_module => 'jtm_message_log_pkg');
1270: END IF;
1271: /*** push to oLite using asg_download ***/
1272:
1273: FOR i IN l_tab_access_id.FIRST..l_tab_access_id.LAST LOOP
1274: m_tab_access_id(i) := l_tab_access_id(i);
1275: END LOOP;