APPS.CSM_CONTRACT_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 725: l_dmllist asg_download.dml_list;

721: PROCEDURE DELETE_OKS_NOTES_ACC(p_contract_service_id IN varchar2,
722: p_user_id IN number)
723: IS
724: l_markdirty BOOLEAN;
725: l_dmllist asg_download.dml_list;
726: l_dml varchar2(1);
727: l_timestamp DATE;
728: l_accesslist asg_download.access_list;
729: l_null_accesslist asg_download.access_list;

Line 728: l_accesslist asg_download.access_list;

724: l_markdirty BOOLEAN;
725: l_dmllist asg_download.dml_list;
726: l_dml varchar2(1);
727: l_timestamp DATE;
728: l_accesslist asg_download.access_list;
729: l_null_accesslist asg_download.access_list;
730: l_resourcelist asg_download.user_list;
731: l_null_resourcelist asg_download.user_list;
732: l_user_id NUMBER;

Line 729: l_null_accesslist asg_download.access_list;

725: l_dmllist asg_download.dml_list;
726: l_dml varchar2(1);
727: l_timestamp DATE;
728: l_accesslist asg_download.access_list;
729: l_null_accesslist asg_download.access_list;
730: l_resourcelist asg_download.user_list;
731: l_null_resourcelist asg_download.user_list;
732: l_user_id NUMBER;
733: l_sourceobjectid NUMBER;

Line 730: l_resourcelist asg_download.user_list;

726: l_dml varchar2(1);
727: l_timestamp DATE;
728: l_accesslist asg_download.access_list;
729: l_null_accesslist asg_download.access_list;
730: l_resourcelist asg_download.user_list;
731: l_null_resourcelist asg_download.user_list;
732: l_user_id NUMBER;
733: l_sourceobjectid NUMBER;
734: l_sourceobjectcode VARCHAR2(240);

Line 731: l_null_resourcelist asg_download.user_list;

727: l_timestamp DATE;
728: l_accesslist asg_download.access_list;
729: l_null_accesslist asg_download.access_list;
730: l_resourcelist asg_download.user_list;
731: l_null_resourcelist asg_download.user_list;
732: l_user_id NUMBER;
733: l_sourceobjectid NUMBER;
734: l_sourceobjectcode VARCHAR2(240);
735: l_publicationitemname VARCHAR2(30);

Line 737: l_pkvalueslist asg_download.pk_list;

733: l_sourceobjectid NUMBER;
734: l_sourceobjectcode VARCHAR2(240);
735: l_publicationitemname VARCHAR2(30);
736: l_access_count NUMBER;
737: l_pkvalueslist asg_download.pk_list;
738: l_notes_found boolean;
739:
740: CURSOR l_oks_notes_csr (p_sourceobjectcode VARCHAR2,
741: p_sourceobjectid NUMBER,

Line 781: l_dmllist asg_download.dml_list;

777: PROCEDURE INSERT_OKS_NOTES_ACC(p_contract_service_id IN VARCHAR2,
778: p_user_id IN number)
779: IS
780: l_markdirty BOOLEAN;
781: l_dmllist asg_download.dml_list;
782: l_dml varchar2(1);
783: l_timestamp DATE;
784: l_accesslist asg_download.access_list;
785: l_resourcelist asg_download.user_list;

Line 784: l_accesslist asg_download.access_list;

780: l_markdirty BOOLEAN;
781: l_dmllist asg_download.dml_list;
782: l_dml varchar2(1);
783: l_timestamp DATE;
784: l_accesslist asg_download.access_list;
785: l_resourcelist asg_download.user_list;
786: l_user_id NUMBER;
787: l_sourceobjectid NUMBER;
788: l_sourceobjectcode VARCHAR2(240);

Line 785: l_resourcelist asg_download.user_list;

781: l_dmllist asg_download.dml_list;
782: l_dml varchar2(1);
783: l_timestamp DATE;
784: l_accesslist asg_download.access_list;
785: l_resourcelist asg_download.user_list;
786: l_user_id NUMBER;
787: l_sourceobjectid NUMBER;
788: l_sourceobjectcode VARCHAR2(240);
789: l_publicationitemname VARCHAR2(30);