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 252: l_dummy := asg_download.mark_dirty(

248: sysdate, 1, sysdate, 1, l_tab_datatype_id(i),
249: l_tab_document_id(i),l_tab_title(i));
250:
251: --do markdiry for all the selected records
252: l_dummy := asg_download.mark_dirty(
253: P_PUB_ITEM => l_publicationitemname
254: , P_ACCESSLIST => l_tab_access_id
255: , P_USERID_LIST => l_tab_user_id
256: , P_DML_TYPE => 'I'

Line 314: l_dummy := asg_download.mark_dirty(

310: sysdate, 1, sysdate, 1, l_tab_datatype_id(i),
311: l_tab_document_id(i),l_tab_title(i));
312:
313:
314: l_dummy := asg_download.mark_dirty(
315: P_PUB_ITEM => l_publicationitemname
316: , P_ACCESSLIST => l_tab_access_id
317: , P_USERID_LIST => l_tab_user_id
318: , P_DML_TYPE => 'I'

Line 377: l_dummy := asg_download.mark_dirty(

373: sysdate, 1, sysdate, 1, l_tab_datatype_id(i),
374: l_tab_document_id(i),l_tab_title(i));
375:
376:
377: l_dummy := asg_download.mark_dirty(
378: P_PUB_ITEM => l_publicationitemname
379: , P_ACCESSLIST => l_tab_access_id
380: , P_USERID_LIST => l_tab_user_id
381: , P_DML_TYPE => 'I'

Line 504: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

500: AND acc.user_id = asg.user_id;
501:
502: l_dummy BOOLEAN;
503: l_publicationitemname VARCHAR2(50):= 'CSF_M_LOBS';
504: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
505: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
506:
507: l_tab_file_id Number_TAB;
508: l_tab_seq_num Number_TAB;

Line 505: l_tab_user_id ASG_DOWNLOAD.USER_LIST;

501:
502: l_dummy BOOLEAN;
503: l_publicationitemname VARCHAR2(50):= 'CSF_M_LOBS';
504: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
505: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
506:
507: l_tab_file_id Number_TAB;
508: l_tab_seq_num Number_TAB;
509: l_tab_name Varchar2_TAB;

Line 590: l_dummy := asg_download.mark_dirty(

586: sysdate, 1, sysdate, 1, l_tab_datatype_id(i),
587: l_tab_document_id(i),l_tab_title(i));
588:
589:
590: l_dummy := asg_download.mark_dirty(
591: P_PUB_ITEM => l_publicationitemname
592: , P_ACCESSLIST => l_tab_access_id
593: , P_USERID_LIST => l_tab_user_id
594: , P_DML_TYPE => 'I'

Line 673: l_dummy := asg_download.mark_dirty(

669: sysdate, 1, sysdate, 1, l_tab_datatype_id(i),
670: l_tab_document_id(i),l_tab_title(i));
671:
672:
673: l_dummy := asg_download.mark_dirty(
674: P_PUB_ITEM => l_publicationitemname
675: , P_ACCESSLIST => l_tab_access_id
676: , P_USERID_LIST => l_tab_user_id
677: , P_DML_TYPE => 'I'

Line 741: l_dummy := asg_download.mark_dirty(

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

Line 913: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

909: l_sqlerrmsg VARCHAR2(4000);
910: l_error_msg VARCHAR2(4000);
911: l_return_status VARCHAR2(2000);
912:
913: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
914: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
915: l_publicationitemname VARCHAR2(50):= 'CSF_M_LOBS';
916: l_tab_file_id Number_TAB;
917: l_tab_seq_num Number_TAB;

Line 914: l_tab_user_id ASG_DOWNLOAD.USER_LIST;

910: l_error_msg VARCHAR2(4000);
911: l_return_status VARCHAR2(2000);
912:
913: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
914: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
915: l_publicationitemname VARCHAR2(50):= 'CSF_M_LOBS';
916: l_tab_file_id Number_TAB;
917: l_tab_seq_num Number_TAB;
918: l_tab_name Varchar2_TAB;

Line 1011: l_dummy := asg_download.mark_dirty(

1007: l_tab_upd_user(i), l_tab_category(i), l_tab_usage_type(i),l_tab_data_type(i), 1,
1008: sysdate, 1, sysdate, 1, l_tab_datatype_id(i),
1009: l_tab_document_id(i),l_tab_title(i));
1010:
1011: l_dummy := asg_download.mark_dirty(
1012: P_PUB_ITEM => l_publicationitemname
1013: , P_ACCESSLIST => l_tab_access_id
1014: , P_USERID_LIST => l_tab_user_id
1015: , P_DML_TYPE => 'I'

Line 1097: l_dummy := asg_download.mark_dirty(

1093: sysdate, 1, sysdate, 1, l_tab_datatype_id(i),
1094: l_tab_document_id(i),l_tab_title(i));
1095:
1096:
1097: l_dummy := asg_download.mark_dirty(
1098: P_PUB_ITEM => l_publicationitemname
1099: , P_ACCESSLIST => l_tab_access_id
1100: , P_USERID_LIST => l_tab_user_id
1101: , P_DML_TYPE => 'I'

Line 1159: l_dummy := asg_download.mark_dirty(

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

Line 1241: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

1237: l_resourcelist number;
1238: l_publicationitemname VARCHAR2(50) := 'CSF_M_LOBS';
1239: l_excep_markdirty_failed EXCEPTION;
1240: g_debug_level NUMBER;
1241: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
1242: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
1243: l_dummy BOOLEAN;
1244: l_userid NUMBER;
1245:

Line 1242: l_tab_user_id ASG_DOWNLOAD.USER_LIST;

1238: l_publicationitemname VARCHAR2(50) := 'CSF_M_LOBS';
1239: l_excep_markdirty_failed EXCEPTION;
1240: g_debug_level NUMBER;
1241: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
1242: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
1243: l_dummy BOOLEAN;
1244: l_userid NUMBER;
1245:
1246: BEGIN

Line 1290: l_dummy := asg_download.mark_dirty(

1286:
1287: FORALL i in l_tab_access_id.FIRST .. l_tab_access_id.LAST
1288: DELETE FROM CSM_FND_LOBS_ACC WHERE ACCESS_ID = l_tab_access_id(i);
1289:
1290: l_dummy := asg_download.mark_dirty(
1291: P_PUB_ITEM => l_publicationitemname
1292: , P_ACCESSLIST => l_tab_access_id
1293: , P_USERID_LIST => l_tab_user_id
1294: , P_DML_TYPE => 'D'

Line 1327: l_dummy := asg_download.mark_dirty(

1323:
1324: FORALL i in l_tab_access_id.FIRST .. l_tab_access_id.LAST
1325: DELETE FROM CSM_FND_LOBS_ACC WHERE ACCESS_ID = l_tab_access_id(i);
1326:
1327: l_dummy := asg_download.mark_dirty(
1328: P_PUB_ITEM => l_publicationitemname
1329: , P_ACCESSLIST => l_tab_access_id
1330: , P_USERID_LIST => l_tab_user_id
1331: , P_DML_TYPE => 'D'

Line 1366: l_dummy := asg_download.mark_dirty(

1362:
1363: FORALL i in l_tab_access_id.FIRST .. l_tab_access_id.LAST
1364: DELETE FROM CSM_FND_LOBS_ACC WHERE ACCESS_ID = l_tab_access_id(i);
1365:
1366: l_dummy := asg_download.mark_dirty(
1367: P_PUB_ITEM => l_publicationitemname
1368: , P_ACCESSLIST => l_tab_access_id
1369: , P_USERID_LIST => l_tab_user_id
1370: , P_DML_TYPE => 'D'

Line 1520: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

1516: l_sqlerrmsg VARCHAR2(4000);
1517: l_error_msg VARCHAR2(4000);
1518: l_return_status VARCHAR2(2000);
1519:
1520: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
1521: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
1522:
1523: l_publicationitemname VARCHAR2(50):= 'CSF_M_LOBS';
1524: l_tab_file_id Number_TAB;

Line 1521: l_tab_user_id ASG_DOWNLOAD.USER_LIST;

1517: l_error_msg VARCHAR2(4000);
1518: l_return_status VARCHAR2(2000);
1519:
1520: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
1521: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
1522:
1523: l_publicationitemname VARCHAR2(50):= 'CSF_M_LOBS';
1524: l_tab_file_id Number_TAB;
1525: l_tab_seq_num Number_TAB;

Line 1662: l_dummy := asg_download.mark_dirty(

1658:
1659:
1660: IF p_data_typeid =5 OR p_data_typeid =1 OR (p_data_typeid=6 AND p_dodirty = TRUE) THEN
1661: --do mark dirly only for URL and Short Text
1662: l_dummy := asg_download.mark_dirty(
1663: P_PUB_ITEM => l_publicationitemname
1664: , P_ACCESSLIST => l_tab_access_id
1665: , P_USERID_LIST => l_tab_user_id
1666: , P_DML_TYPE => 'I'