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_LOBS_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 31: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

27: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
28: l_run_date date;
29: l_sqlerrno varchar2(20);
30: l_sqlerrmsg varchar2(2000);
31: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
32: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
33: l_publicationitemname VARCHAR2(50):= 'CSF_M_LOBS';
34: l_tab_file_id Number_TAB;
35: l_tab_seq_num Number_TAB;

Line 32: l_tab_user_id ASG_DOWNLOAD.USER_LIST;

28: l_run_date date;
29: l_sqlerrno varchar2(20);
30: l_sqlerrmsg varchar2(2000);
31: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
32: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
33: l_publicationitemname VARCHAR2(50):= 'CSF_M_LOBS';
34: l_tab_file_id Number_TAB;
35: l_tab_seq_num Number_TAB;
36: l_tab_name Varchar2_TAB;

Line 276: l_dummy := asg_download.mark_dirty(

272: FETCH c_ha_parent_pld_id INTO l_ha_pld_id;
273: CLOSE c_ha_parent_pld_id;
274: CSM_HA_EVENT_PKG.G_CURRENT_PAYLOAD_ID:=l_ha_pld_id;
275:
276: l_dummy := asg_download.mark_dirty(
277: P_PUB_ITEM => l_publicationitemname
278: , P_ACCESSID => l_tab_access_id(I)
279: , P_USERID => l_tab_user_id(I)
280: , P_DML => 'I'

Line 285: l_dummy := asg_download.mark_dirty(

281: , P_TIMESTAMP => SYSDATE);
282: END LOOP;
283: ELSE
284: --do markdiry for all the selected records
285: l_dummy := asg_download.mark_dirty(
286: P_PUB_ITEM => l_publicationitemname
287: , P_ACCESSLIST => l_tab_access_id
288: , P_USERID_LIST => l_tab_user_id
289: , P_DML_TYPE => 'I'

Line 356: l_dummy := asg_download.mark_dirty(

352: CLOSE c_ha_parent_pld_id;
353:
354: CSM_HA_EVENT_PKG.G_CURRENT_PAYLOAD_ID:=l_ha_pld_id;
355:
356: l_dummy := asg_download.mark_dirty(
357: P_PUB_ITEM => l_publicationitemname
358: , P_ACCESSID => l_tab_access_id(I)
359: , P_USERID => l_tab_user_id(I)
360: , P_DML => 'I'

Line 364: l_dummy := asg_download.mark_dirty(

360: , P_DML => 'I'
361: , P_TIMESTAMP => SYSDATE);
362: END LOOP;
363: ELSE
364: l_dummy := asg_download.mark_dirty(
365: P_PUB_ITEM => l_publicationitemname
366: , P_ACCESSLIST => l_tab_access_id
367: , P_USERID_LIST => l_tab_user_id
368: , P_DML_TYPE => 'I'

Line 435: l_dummy := asg_download.mark_dirty(

431: FETCH c_ha_parent_pld_id INTO l_ha_pld_id;
432: CLOSE c_ha_parent_pld_id;
433: CSM_HA_EVENT_PKG.G_CURRENT_PAYLOAD_ID:=l_ha_pld_id;
434:
435: l_dummy := asg_download.mark_dirty(
436: P_PUB_ITEM => l_publicationitemname
437: , P_ACCESSID => l_tab_access_id(I)
438: , P_USERID => l_tab_user_id(I)
439: , P_DML => 'I'

Line 443: l_dummy := asg_download.mark_dirty(

439: , P_DML => 'I'
440: , P_TIMESTAMP => SYSDATE);
441: END LOOP;
442: ELSE
443: l_dummy := asg_download.mark_dirty(
444: P_PUB_ITEM => l_publicationitemname
445: , P_ACCESSLIST => l_tab_access_id
446: , P_USERID_LIST => l_tab_user_id
447: , P_DML_TYPE => 'I'

Line 569: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

565: AND acc.user_id = asg.user_id;
566:
567: l_dummy BOOLEAN;
568: l_publicationitemname VARCHAR2(50):= 'CSF_M_LOBS';
569: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
570: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
571:
572: l_tab_file_id Number_TAB;
573: l_tab_seq_num Number_TAB;

Line 570: l_tab_user_id ASG_DOWNLOAD.USER_LIST;

566:
567: l_dummy BOOLEAN;
568: l_publicationitemname VARCHAR2(50):= 'CSF_M_LOBS';
569: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
570: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
571:
572: l_tab_file_id Number_TAB;
573: l_tab_seq_num Number_TAB;
574: l_tab_name Varchar2_TAB;

Line 655: l_dummy := asg_download.mark_dirty(

651: sysdate, 1, sysdate, 1, l_tab_datatype_id(i),
652: l_tab_document_id(i),l_tab_title(i));
653:
654:
655: l_dummy := asg_download.mark_dirty(
656: P_PUB_ITEM => l_publicationitemname
657: , P_ACCESSLIST => l_tab_access_id
658: , P_USERID_LIST => l_tab_user_id
659: , P_DML_TYPE => 'I'

Line 738: l_dummy := asg_download.mark_dirty(

734: sysdate, 1, sysdate, 1, l_tab_datatype_id(i),
735: l_tab_document_id(i),l_tab_title(i));
736:
737:
738: l_dummy := asg_download.mark_dirty(
739: P_PUB_ITEM => l_publicationitemname
740: , P_ACCESSLIST => l_tab_access_id
741: , P_USERID_LIST => l_tab_user_id
742: , P_DML_TYPE => 'I'

Line 806: l_dummy := asg_download.mark_dirty(

802: sysdate, 1, sysdate, 1, l_tab_datatype_id(i),
803: l_tab_document_id(i),l_tab_title(i));
804:
805:
806: l_dummy := asg_download.mark_dirty(
807: P_PUB_ITEM => l_publicationitemname
808: , P_ACCESSLIST => l_tab_access_id
809: , P_USERID_LIST => l_tab_user_id
810: , P_DML_TYPE => 'I'

Line 978: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

974: l_sqlerrmsg VARCHAR2(4000);
975: l_error_msg VARCHAR2(4000);
976: l_return_status VARCHAR2(2000);
977:
978: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
979: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
980: l_publicationitemname VARCHAR2(50):= 'CSF_M_LOBS';
981: l_tab_file_id Number_TAB;
982: l_tab_seq_num Number_TAB;

Line 979: l_tab_user_id ASG_DOWNLOAD.USER_LIST;

975: l_error_msg VARCHAR2(4000);
976: l_return_status VARCHAR2(2000);
977:
978: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
979: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
980: l_publicationitemname VARCHAR2(50):= 'CSF_M_LOBS';
981: l_tab_file_id Number_TAB;
982: l_tab_seq_num Number_TAB;
983: l_tab_name Varchar2_TAB;

Line 1076: l_dummy := asg_download.mark_dirty(

1072: l_tab_upd_user(i), l_tab_category(i), l_tab_usage_type(i),l_tab_data_type(i), 1,
1073: sysdate, 1, sysdate, 1, l_tab_datatype_id(i),
1074: l_tab_document_id(i),l_tab_title(i));
1075:
1076: l_dummy := asg_download.mark_dirty(
1077: P_PUB_ITEM => l_publicationitemname
1078: , P_ACCESSLIST => l_tab_access_id
1079: , P_USERID_LIST => l_tab_user_id
1080: , P_DML_TYPE => 'I'

Line 1162: l_dummy := asg_download.mark_dirty(

1158: sysdate, 1, sysdate, 1, l_tab_datatype_id(i),
1159: l_tab_document_id(i),l_tab_title(i));
1160:
1161:
1162: l_dummy := asg_download.mark_dirty(
1163: P_PUB_ITEM => l_publicationitemname
1164: , P_ACCESSLIST => l_tab_access_id
1165: , P_USERID_LIST => l_tab_user_id
1166: , P_DML_TYPE => 'I'

Line 1224: l_dummy := asg_download.mark_dirty(

1220: sysdate, 1, sysdate, 1, l_tab_datatype_id(i),
1221: l_tab_document_id(i),l_tab_title(i));
1222:
1223:
1224: l_dummy := asg_download.mark_dirty(
1225: P_PUB_ITEM => l_publicationitemname
1226: , P_ACCESSLIST => l_tab_access_id
1227: , P_USERID_LIST => l_tab_user_id
1228: , P_DML_TYPE => 'I'

Line 1306: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

1302: l_resourcelist number;
1303: l_publicationitemname VARCHAR2(50) := 'CSF_M_LOBS';
1304: l_excep_markdirty_failed EXCEPTION;
1305: g_debug_level NUMBER;
1306: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
1307: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
1308: l_dummy BOOLEAN;
1309: l_userid NUMBER;
1310:

Line 1307: l_tab_user_id ASG_DOWNLOAD.USER_LIST;

1303: l_publicationitemname VARCHAR2(50) := 'CSF_M_LOBS';
1304: l_excep_markdirty_failed EXCEPTION;
1305: g_debug_level NUMBER;
1306: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
1307: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
1308: l_dummy BOOLEAN;
1309: l_userid NUMBER;
1310:
1311: BEGIN

Line 1355: l_dummy := asg_download.mark_dirty(

1351:
1352: FORALL i in l_tab_access_id.FIRST .. l_tab_access_id.LAST
1353: DELETE FROM CSM_FND_LOBS_ACC WHERE ACCESS_ID = l_tab_access_id(i);
1354:
1355: l_dummy := asg_download.mark_dirty(
1356: P_PUB_ITEM => l_publicationitemname
1357: , P_ACCESSLIST => l_tab_access_id
1358: , P_USERID_LIST => l_tab_user_id
1359: , P_DML_TYPE => 'D'

Line 1392: l_dummy := asg_download.mark_dirty(

1388:
1389: FORALL i in l_tab_access_id.FIRST .. l_tab_access_id.LAST
1390: DELETE FROM CSM_FND_LOBS_ACC WHERE ACCESS_ID = l_tab_access_id(i);
1391:
1392: l_dummy := asg_download.mark_dirty(
1393: P_PUB_ITEM => l_publicationitemname
1394: , P_ACCESSLIST => l_tab_access_id
1395: , P_USERID_LIST => l_tab_user_id
1396: , P_DML_TYPE => 'D'

Line 1431: l_dummy := asg_download.mark_dirty(

1427:
1428: FORALL i in l_tab_access_id.FIRST .. l_tab_access_id.LAST
1429: DELETE FROM CSM_FND_LOBS_ACC WHERE ACCESS_ID = l_tab_access_id(i);
1430:
1431: l_dummy := asg_download.mark_dirty(
1432: P_PUB_ITEM => l_publicationitemname
1433: , P_ACCESSLIST => l_tab_access_id
1434: , P_USERID_LIST => l_tab_user_id
1435: , P_DML_TYPE => 'D'

Line 1585: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

1581: l_sqlerrmsg VARCHAR2(4000);
1582: l_error_msg VARCHAR2(4000);
1583: l_return_status VARCHAR2(2000);
1584:
1585: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
1586: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
1587:
1588: l_publicationitemname VARCHAR2(50):= 'CSF_M_LOBS';
1589: l_tab_file_id Number_TAB;

Line 1586: l_tab_user_id ASG_DOWNLOAD.USER_LIST;

1582: l_error_msg VARCHAR2(4000);
1583: l_return_status VARCHAR2(2000);
1584:
1585: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
1586: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
1587:
1588: l_publicationitemname VARCHAR2(50):= 'CSF_M_LOBS';
1589: l_tab_file_id Number_TAB;
1590: l_tab_seq_num Number_TAB;

Line 1727: l_dummy := asg_download.mark_dirty(

1723:
1724:
1725: IF p_data_typeid =5 OR p_data_typeid =1 OR (p_data_typeid=6 AND p_dodirty = TRUE) THEN
1726: --do mark dirly only for URL and Short Text
1727: l_dummy := asg_download.mark_dirty(
1728: P_PUB_ITEM => l_publicationitemname
1729: , P_ACCESSLIST => l_tab_access_id
1730: , P_USERID_LIST => l_tab_user_id
1731: , P_DML_TYPE => 'I'