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

Line 20: l_pkvalueslist asg_download.pk_list;

16: l_resource_id jtf_task_assignments.resource_id%type;
17: l_user_id fnd_user.user_id%TYPE;
18: l_item_key varchar2(50);
19: l_seq_val number(15);
20: l_pkvalueslist asg_download.pk_list;
21: l_null_pkvalueslist asg_download.pk_list;
22: l_accessid number;
23: l_markdirty_rc BOOLEAN;
24: l_dmllist varchar2(1);

Line 21: l_null_pkvalueslist asg_download.pk_list;

17: l_user_id fnd_user.user_id%TYPE;
18: l_item_key varchar2(50);
19: l_seq_val number(15);
20: l_pkvalueslist asg_download.pk_list;
21: l_null_pkvalueslist asg_download.pk_list;
22: l_accessid number;
23: l_markdirty_rc BOOLEAN;
24: l_dmllist varchar2(1);
25: l_dml varchar2(1);

Line 66: l_dmllist := ASG_DOWNLOAD.INS;

62: l_resource_id := p_resource_id;
63: l_publicationitemname := 'CSL_LOBS';
64: l_timestamp := SYSDATE;
65:
66: l_dmllist := ASG_DOWNLOAD.INS;
67:
68: FOR l_signature_rec IN l_signature_csr(l_task_assignment_id, l_resource_id)
69: LOOP
70: -- initialize l_pkvalueslist

Line 81: l_markdirty_rc := asg_download.MarkDirty (

77: fetch l_rs_resource_extns_csr into l_resourcelist;
78: close l_rs_resource_extns_csr;
79:
80: -- make the markdirty call
81: l_markdirty_rc := asg_download.MarkDirty (
82: l_publicationitemname
83: , l_accessid
84: , l_resourcelist
85: , l_dmllist

Line 131: l_pkvalueslist asg_download.pk_list;

127: l_resource_id jtf_task_assignments.resource_id%type;
128: l_user_id fnd_user.user_id%TYPE;
129: l_item_key varchar2(50);
130: l_seq_val number(15);
131: l_pkvalueslist asg_download.pk_list;
132: l_null_pkvalueslist asg_download.pk_list;
133: l_accessid number;
134: l_markdirty_rc BOOLEAN;
135: l_dmllist varchar2(1);

Line 132: l_null_pkvalueslist asg_download.pk_list;

128: l_user_id fnd_user.user_id%TYPE;
129: l_item_key varchar2(50);
130: l_seq_val number(15);
131: l_pkvalueslist asg_download.pk_list;
132: l_null_pkvalueslist asg_download.pk_list;
133: l_accessid number;
134: l_markdirty_rc BOOLEAN;
135: l_dmllist varchar2(1);
136: l_dml varchar2(1);

Line 175: l_dmllist := ASG_DOWNLOAD.DEL;

171: l_task_assignment_id := p_task_assignment_id;
172: l_resource_id := p_resource_id;
173: l_publicationitemname := 'CSL_LOBS';
174: l_timestamp := SYSDATE;
175: l_dmllist := ASG_DOWNLOAD.DEL;
176:
177: FOR l_signature_rec IN l_signature_csr(l_task_assignment_id, l_resource_id)
178: LOOP
179: -- initialize l_pkvalueslist

Line 190: l_markdirty_rc := asg_download.MarkDirty (

186: close l_rs_resource_extns_csr;
187:
188: -- make the markdirty call
189:
190: l_markdirty_rc := asg_download.MarkDirty (
191: l_publicationitemname
192: , l_accessid
193: , l_resourcelist
194: , l_dmllist

Line 347: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

343: r_LastRundate c_LastRundate%ROWTYPE;
344: l_current_run_date DATE;
345: l_dummy BOOLEAN;
346:
347: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
348:
349: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
350:
351: BEGIN

Line 349: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;

345: l_dummy BOOLEAN;
346:
347: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
348:
349: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
350:
351: BEGIN
352:
353: /*** get debug level ***/

Line 415: l_dummy := asg_download.markdirty(

411: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
412: );
413: END IF;
414:
415: l_dummy := asg_download.markdirty(
416: P_PUB_ITEM => g_publication_item_name(1)
417: , P_ACCESSLIST => l_tab_access_id
418: , P_RESOURCELIST => l_tab_resource_id
419: , P_DML_TYPE => 'I'

Line 443: l_dummy := asg_download.markdirty(

439: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
440: );
441: END IF;
442:
443: l_dummy := asg_download.markdirty(
444: P_PUB_ITEM => g_publication_item_name(1)
445: , P_ACCESSLIST => l_tab_access_id
446: , P_RESOURCELIST => l_tab_resource_id
447: , P_DML_TYPE => 'I'

Line 471: l_dummy := asg_download.markdirty(

467: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
468: );
469: END IF;
470:
471: l_dummy := asg_download.markdirty(
472: P_PUB_ITEM => g_publication_item_name(1)
473: , P_ACCESSLIST => l_tab_access_id
474: , P_RESOURCELIST => l_tab_resource_id
475: , P_DML_TYPE => 'I'

Line 498: l_dummy := asg_download.markdirty(

494: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
495: );
496: END IF;
497:
498: l_dummy := asg_download.markdirty(
499: P_PUB_ITEM => g_publication_item_name(1)
500: , P_ACCESSLIST => l_tab_access_id
501: , P_RESOURCELIST => l_tab_resource_id
502: , P_DML_TYPE => 'I'

Line 526: l_dummy := asg_download.markdirty(

522: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
523: );
524: END IF;
525:
526: l_dummy := asg_download.markdirty(
527: P_PUB_ITEM => g_publication_item_name(1)
528: , P_ACCESSLIST => l_tab_access_id
529: , P_RESOURCELIST => l_tab_resource_id
530: , P_DML_TYPE => 'I'

Line 604: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

600: AND fnddoc.datatype_id=6
601: AND acc.incident_id = b_incident_id;
602:
603: l_dummy BOOLEAN;
604: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
605: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
606:
607: BEGIN
608:

Line 605: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;

601: AND acc.incident_id = b_incident_id;
602:
603: l_dummy BOOLEAN;
604: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
605: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
606:
607: BEGIN
608:
609: /*** get debug level ***/

Line 655: l_dummy := asg_download.markdirty(

651: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
652: );
653: END IF;
654:
655: l_dummy := asg_download.markdirty(
656: P_PUB_ITEM => g_publication_item_name(1)
657: , P_ACCESSLIST => l_tab_access_id
658: , P_RESOURCELIST => l_tab_resource_id
659: , P_DML_TYPE => 'I'

Line 717: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

713: AND fnddoc.datatype_id=6
714: AND acc.task_id = b_task_id;
715:
716: l_dummy BOOLEAN;
717: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
718: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
719:
720: BEGIN
721:

Line 718: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;

714: AND acc.task_id = b_task_id;
715:
716: l_dummy BOOLEAN;
717: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
718: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
719:
720: BEGIN
721:
722: /*** get debug level ***/

Line 766: l_dummy := asg_download.markdirty(

762: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
763: );
764: END IF;
765:
766: l_dummy := asg_download.markdirty(
767: P_PUB_ITEM => g_publication_item_name(1)
768: , P_ACCESSLIST => l_tab_access_id
769: , P_RESOURCELIST => l_tab_resource_id
770: , P_DML_TYPE => 'I'

Line 849: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

845: r_SRAtt c_SRAtt%ROWTYPE;
846: r_TaskAtt c_TaskAtt%ROWTYPE;
847:
848: l_dummy BOOLEAN;
849: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
850: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
851:
852: l_err_mesg VARCHAR2(1000);
853: BEGIN

Line 850: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;

846: r_TaskAtt c_TaskAtt%ROWTYPE;
847:
848: l_dummy BOOLEAN;
849: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
850: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
851:
852: l_err_mesg VARCHAR2(1000);
853: BEGIN
854:

Line 889: l_dummy := asg_download.markdirty(

885: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
886: );
887: END IF;
888:
889: l_dummy := asg_download.markdirty(
890: P_PUB_ITEM => g_publication_item_name(1)
891: , P_ACCESSLIST => l_tab_access_id
892: , P_RESOURCELIST => l_tab_resource_id
893: , P_DML_TYPE => 'D'

Line 925: l_dummy := asg_download.markdirty(

921: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
922: );
923: END IF;
924:
925: l_dummy := asg_download.markdirty(
926: P_PUB_ITEM => g_publication_item_name(1)
927: , P_ACCESSLIST => l_tab_access_id
928: , P_RESOURCELIST => l_tab_resource_id
929: , P_DML_TYPE => 'D'