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

Line 561: l_dmllist asg_download.dml_list;

557: PROCEDURE DELETE_OKS_NOTES_ACC(p_contract_service_id IN varchar2,
558: p_user_id IN number)
559: IS
560: l_markdirty BOOLEAN;
561: l_dmllist asg_download.dml_list;
562: l_dml varchar2(1);
563: l_timestamp DATE;
564: l_accesslist asg_download.access_list;
565: l_null_accesslist asg_download.access_list;

Line 564: l_accesslist asg_download.access_list;

560: l_markdirty BOOLEAN;
561: l_dmllist asg_download.dml_list;
562: l_dml varchar2(1);
563: l_timestamp DATE;
564: l_accesslist asg_download.access_list;
565: l_null_accesslist asg_download.access_list;
566: l_resourcelist asg_download.user_list;
567: l_null_resourcelist asg_download.user_list;
568: l_user_id NUMBER;

Line 565: l_null_accesslist asg_download.access_list;

561: l_dmllist asg_download.dml_list;
562: l_dml varchar2(1);
563: l_timestamp DATE;
564: l_accesslist asg_download.access_list;
565: l_null_accesslist asg_download.access_list;
566: l_resourcelist asg_download.user_list;
567: l_null_resourcelist asg_download.user_list;
568: l_user_id NUMBER;
569: l_sourceobjectid NUMBER;

Line 566: l_resourcelist asg_download.user_list;

562: l_dml varchar2(1);
563: l_timestamp DATE;
564: l_accesslist asg_download.access_list;
565: l_null_accesslist asg_download.access_list;
566: l_resourcelist asg_download.user_list;
567: l_null_resourcelist asg_download.user_list;
568: l_user_id NUMBER;
569: l_sourceobjectid NUMBER;
570: l_sourceobjectcode VARCHAR2(240);

Line 567: l_null_resourcelist asg_download.user_list;

563: l_timestamp DATE;
564: l_accesslist asg_download.access_list;
565: l_null_accesslist asg_download.access_list;
566: l_resourcelist asg_download.user_list;
567: l_null_resourcelist asg_download.user_list;
568: l_user_id NUMBER;
569: l_sourceobjectid NUMBER;
570: l_sourceobjectcode VARCHAR2(240);
571: l_publicationitemname VARCHAR2(30);

Line 573: l_pkvalueslist asg_download.pk_list;

569: l_sourceobjectid NUMBER;
570: l_sourceobjectcode VARCHAR2(240);
571: l_publicationitemname VARCHAR2(30);
572: l_access_count NUMBER;
573: l_pkvalueslist asg_download.pk_list;
574: l_notes_found boolean;
575:
576: CURSOR l_oks_notes_csr (p_sourceobjectcode VARCHAR2,
577: p_sourceobjectid NUMBER,

Line 617: l_dmllist asg_download.dml_list;

613: PROCEDURE INSERT_OKS_NOTES_ACC(p_contract_service_id IN VARCHAR2,
614: p_user_id IN number)
615: IS
616: l_markdirty BOOLEAN;
617: l_dmllist asg_download.dml_list;
618: l_dml varchar2(1);
619: l_timestamp DATE;
620: l_accesslist asg_download.access_list;
621: l_resourcelist asg_download.user_list;

Line 620: l_accesslist asg_download.access_list;

616: l_markdirty BOOLEAN;
617: l_dmllist asg_download.dml_list;
618: l_dml varchar2(1);
619: l_timestamp DATE;
620: l_accesslist asg_download.access_list;
621: l_resourcelist asg_download.user_list;
622: l_user_id NUMBER;
623: l_sourceobjectid NUMBER;
624: l_sourceobjectcode VARCHAR2(240);

Line 621: l_resourcelist asg_download.user_list;

617: l_dmllist asg_download.dml_list;
618: l_dml varchar2(1);
619: l_timestamp DATE;
620: l_accesslist asg_download.access_list;
621: l_resourcelist asg_download.user_list;
622: l_user_id NUMBER;
623: l_sourceobjectid NUMBER;
624: l_sourceobjectcode VARCHAR2(240);
625: l_publicationitemname VARCHAR2(30);