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

Line 18: g_null_user_list asg_download.user_list;

14: --either thru concurrent job or workflow activities.
15: g_acc_refresh_desc_tbl Acc_Refresh_Desc_Tbl_Type := Acc_Refresh_Desc_Tbl_Type();
16:
17: --a null list
18: g_null_user_list asg_download.user_list;
19:
20: --g_buffer varchar(1024);
21:
22: /***

Line 157: FUNCTION get_all_omfs_palm_user_list RETURN asg_download.user_list

153:
154: END get_Acc_Refresh_Desc_Rec;
155:
156:
157: FUNCTION get_all_omfs_palm_user_list RETURN asg_download.user_list
158: IS
159: i NUMBER;
160: l_all_omfs_palm_users_list asg_download.user_list;
161:

Line 160: l_all_omfs_palm_users_list asg_download.user_list;

156:
157: FUNCTION get_all_omfs_palm_user_list RETURN asg_download.user_list
158: IS
159: i NUMBER;
160: l_all_omfs_palm_users_list asg_download.user_list;
161:
162: CURSOR l_omfs_palm_users_csr
163: IS
164: SELECT usr.USER_ID

Line 201: FUNCTION get_all_omfs_palm_res_list RETURN asg_download.user_list

197:
198: /**
199: Returns the list containing the RESOURCE_ID of all the OMFS Palm Users
200: */
201: FUNCTION get_all_omfs_palm_res_list RETURN asg_download.user_list
202: IS
203: i NUMBER;
204: l_all_omfs_palm_resource_list asg_download.user_list;
205:

Line 204: l_all_omfs_palm_resource_list asg_download.user_list;

200: */
201: FUNCTION get_all_omfs_palm_res_list RETURN asg_download.user_list
202: IS
203: i NUMBER;
204: l_all_omfs_palm_resource_list asg_download.user_list;
205:
206: CURSOR l_omfs_palm_resources_csr
207: IS
208: SELECT usr.resource_id

Line 494: l_markdirty := asg_download.MarkDirty(p_publication_item,

490: -- getthe resource_id, since make dirty requires resource_id
491: open l_rs_resource_extns_csr(p_resourcelist);
492: fetch l_rs_resource_extns_csr into l_resourcelist;
493: close l_rs_resource_extns_csr;
494: l_markdirty := asg_download.MarkDirty(p_publication_item,
495: p_accesslist,
496: l_resourcelist,
497: p_dmllist,
498: p_timestamp);

Line 503: p_accessList in asg_download.access_list,

499: return l_markdirty;
500: end;
501:
502: Function MakeDirtyForUser ( p_publication_item in varchar2,
503: p_accessList in asg_download.access_list,
504: p_resourceList in asg_download.user_list,
505: p_dmlList in asg_download.dml_list,
506: p_timestamp in date)
507: return boolean

Line 504: p_resourceList in asg_download.user_list,

500: end;
501:
502: Function MakeDirtyForUser ( p_publication_item in varchar2,
503: p_accessList in asg_download.access_list,
504: p_resourceList in asg_download.user_list,
505: p_dmlList in asg_download.dml_list,
506: p_timestamp in date)
507: return boolean
508: is

Line 505: p_dmlList in asg_download.dml_list,

501:
502: Function MakeDirtyForUser ( p_publication_item in varchar2,
503: p_accessList in asg_download.access_list,
504: p_resourceList in asg_download.user_list,
505: p_dmlList in asg_download.dml_list,
506: p_timestamp in date)
507: return boolean
508: is
509: l_markdirty boolean;

Line 510: l_resourcelist asg_download.user_list;

506: p_timestamp in date)
507: return boolean
508: is
509: l_markdirty boolean;
510: l_resourcelist asg_download.user_list;
511:
512: cursor l_rs_resource_extns_csr (p_user_id fnd_user.user_id%type) is
513: select resource_id
514: from jtf_rs_resource_extns

Line 532: l_markdirty := asg_download.MarkDirty(p_publication_item,

528: close l_rs_resource_extns_csr;
529: end loop;
530: end if;
531:
532: l_markdirty := asg_download.MarkDirty(p_publication_item,
533: p_accesslist,
534: l_resourcelist,
535: p_dmllist,
536: p_timestamp);

Line 544: p_accessList in asg_download.access_list,

540: end;
541:
542:
543: Function MakeDirtyForUser ( p_publication_item in varchar2,
544: p_accessList in asg_download.access_list,
545: p_resourceList in asg_download.user_list,
546: p_dmlList in char,
547: p_timestamp in date)
548: return boolean

Line 545: p_resourceList in asg_download.user_list,

541:
542:
543: Function MakeDirtyForUser ( p_publication_item in varchar2,
544: p_accessList in asg_download.access_list,
545: p_resourceList in asg_download.user_list,
546: p_dmlList in char,
547: p_timestamp in date)
548: return boolean
549: is

Line 551: l_resourcelist asg_download.user_list;

547: p_timestamp in date)
548: return boolean
549: is
550: l_markdirty boolean;
551: l_resourcelist asg_download.user_list;
552:
553: cursor l_rs_resource_extns_csr (p_user_id fnd_user.user_id%type) is
554: select resource_id
555: from jtf_rs_resource_extns

Line 574: l_markdirty := asg_download.MarkDirty(p_publication_item,

570:
571: --logm('Before markdirty:' || 'pub:' || p_publication_item || 'access_id:' || p_accesslist(0) || ' ' || l_resourcelist(0) );
572:
573: IF p_accesslist.count > 0 THEN
574: l_markdirty := asg_download.MarkDirty(p_publication_item,
575: p_accesslist,
576: l_resourcelist,
577: p_dmllist,
578: p_timestamp);

Line 589: p_pkvalueslist IN asg_download.pk_list)

585: p_accessList in number,
586: p_resourceList in number,
587: p_dmlList in char,
588: p_timestamp in date,
589: p_pkvalueslist IN asg_download.pk_list)
590: RETURN BOOLEAN
591: IS
592: l_markdirty boolean;
593: l_resourcelist number;

Line 608: l_markdirty := asg_download.MarkDirty(p_publication_item,

604: open l_rs_resource_extns_csr(p_resourcelist);
605: fetch l_rs_resource_extns_csr into l_resourcelist;
606: close l_rs_resource_extns_csr;
607:
608: l_markdirty := asg_download.MarkDirty(p_publication_item,
609: p_accesslist,
610: l_resourcelist,
611: p_dmllist,
612: p_timestamp,

Line 620: p_accessList in asg_download.access_list,

616: END MakeDirtyForUser;
617:
618:
619: Function MakeDirtyForResource ( p_publication_item in varchar2,
620: p_accessList in asg_download.access_list,
621: p_resourceList in asg_download.user_list,
622: p_dmlList in char,
623: p_timestamp in date)
624: return boolean

Line 621: p_resourceList in asg_download.user_list,

617:
618:
619: Function MakeDirtyForResource ( p_publication_item in varchar2,
620: p_accessList in asg_download.access_list,
621: p_resourceList in asg_download.user_list,
622: p_dmlList in char,
623: p_timestamp in date)
624: return boolean
625: is

Line 630: l_markdirty := asg_download.MarkDirty(p_publication_item,

626: l_markdirty boolean;
627:
628: begin
629:
630: l_markdirty := asg_download.MarkDirty(p_publication_item,
631: p_accesslist,
632: p_resourcelist,
633: p_dmllist,
634: p_timestamp);

Line 650: l_markdirty := asg_download.MarkDirty(p_publication_item,

646: l_markdirty boolean;
647:
648: begin
649:
650: l_markdirty := asg_download.MarkDirty(p_publication_item,
651: p_accesslist,
652: p_resourcelist,
653: p_dmllist,
654: p_timestamp);

Line 664: p_pkvalueslist IN asg_download.pk_list)

660: p_accessList in number,
661: p_resourceList in number,
662: p_dmlList in char,
663: p_timestamp in date,
664: p_pkvalueslist IN asg_download.pk_list)
665: RETURN BOOLEAN
666: IS
667: l_markdirty boolean;
668:

Line 670: l_markdirty := asg_download.MarkDirty(p_publication_item,

666: IS
667: l_markdirty boolean;
668:
669: BEGIN
670: l_markdirty := asg_download.MarkDirty(p_publication_item,
671: p_accesslist,
672: p_resourcelist,
673: p_dmllist,
674: p_timestamp,

Line 707: return ASG_DOWNLOAD.INS;

703: *********************************************************/
704: begin
705: --convert the passed parameter to one of the ASG constants
706: if (p_dml = 'I') then
707: return ASG_DOWNLOAD.INS;
708: elsif (p_dml = 'U') then
709: return ASG_DOWNLOAD.UPD;
710: elsif (p_dml = 'D') then
711: return ASG_DOWNLOAD.DEL;

Line 709: return ASG_DOWNLOAD.UPD;

705: --convert the passed parameter to one of the ASG constants
706: if (p_dml = 'I') then
707: return ASG_DOWNLOAD.INS;
708: elsif (p_dml = 'U') then
709: return ASG_DOWNLOAD.UPD;
710: elsif (p_dml = 'D') then
711: return ASG_DOWNLOAD.DEL;
712: --In case the passed parameter dml type is not in ('I', 'U', 'D')
713: --throw invalid argument exception

Line 711: return ASG_DOWNLOAD.DEL;

707: return ASG_DOWNLOAD.INS;
708: elsif (p_dml = 'U') then
709: return ASG_DOWNLOAD.UPD;
710: elsif (p_dml = 'D') then
711: return ASG_DOWNLOAD.DEL;
712: --In case the passed parameter dml type is not in ('I', 'U', 'D')
713: --throw invalid argument exception
714: else raise g_invalid_argument_exception;
715: end if;

Line 823: return asg_download.user_list

819: RAISE;
820: END is_palm_user;
821:
822: function get_tl_omfs_palm_users(p_language varchar2)
823: return asg_download.user_list
824: AS
825:
826: l_tl_omfs_palm_users_list asg_download.user_list;
827: i NUMBER;

Line 826: l_tl_omfs_palm_users_list asg_download.user_list;

822: function get_tl_omfs_palm_users(p_language varchar2)
823: return asg_download.user_list
824: AS
825:
826: l_tl_omfs_palm_users_list asg_download.user_list;
827: i NUMBER;
828:
829: CURSOR l_tl_omfs_palm_users_csr is
830: --R12 For multiple responsibility

Line 867: return asg_download.user_list

863:
864: END get_tl_omfs_palm_users;
865:
866: function get_tl_omfs_palm_resources(p_language varchar2)
867: return asg_download.user_list
868: AS
869:
870: l_tl_omfs_palm_resource_list asg_download.user_list;
871: i NUMBER;

Line 870: l_tl_omfs_palm_resource_list asg_download.user_list;

866: function get_tl_omfs_palm_resources(p_language varchar2)
867: return asg_download.user_list
868: AS
869:
870: l_tl_omfs_palm_resource_list asg_download.user_list;
871: i NUMBER;
872:
873: CURSOR l_tl_omfs_palm_resources_csr is
874: --R12 For multiple responsibility

Line 990: l_tl_omfs_palm_resource_list asg_download.user_list;

986: l_result NUMBER;
987:
988: l_changed_records_cur Changed_Records_Cur_Type;
989:
990: l_tl_omfs_palm_resource_list asg_download.user_list;
991: l_all_omfs_palm_resource_list asg_download.user_list;
992: --contains the same access ID n times (where n = number of users for which
993: --to insert into SDQ)
994: l_single_access_id_list asg_download.access_list;

Line 991: l_all_omfs_palm_resource_list asg_download.user_list;

987:
988: l_changed_records_cur Changed_Records_Cur_Type;
989:
990: l_tl_omfs_palm_resource_list asg_download.user_list;
991: l_all_omfs_palm_resource_list asg_download.user_list;
992: --contains the same access ID n times (where n = number of users for which
993: --to insert into SDQ)
994: l_single_access_id_list asg_download.access_list;
995: --a null list

Line 994: l_single_access_id_list asg_download.access_list;

990: l_tl_omfs_palm_resource_list asg_download.user_list;
991: l_all_omfs_palm_resource_list asg_download.user_list;
992: --contains the same access ID n times (where n = number of users for which
993: --to insert into SDQ)
994: l_single_access_id_list asg_download.access_list;
995: --a null list
996: l_null_access_list asg_download.access_list;
997:
998: i NUMBER;

Line 996: l_null_access_list asg_download.access_list;

992: --contains the same access ID n times (where n = number of users for which
993: --to insert into SDQ)
994: l_single_access_id_list asg_download.access_list;
995: --a null list
996: l_null_access_list asg_download.access_list;
997:
998: i NUMBER;
999: l_mark_dirty BOOLEAN;
1000:

Line 1048: ASG_DOWNLOAD.DEL,

1044: --mark dirty the SDQ
1045: l_mark_dirty := MakeDirtyForResource(l_publication_item_name,
1046: l_single_access_id_list,
1047: l_all_omfs_palm_resource_list,
1048: ASG_DOWNLOAD.DEL,
1049: sysdate);
1050: END LOOP;
1051:
1052:

Line 1123: ASG_DOWNLOAD.UPD,

1119: --mark dirty the SDQ
1120: l_mark_dirty := MakeDirtyForResource(l_publication_item_name,
1121: l_single_access_id_list,
1122: l_all_omfs_palm_resource_list,
1123: ASG_DOWNLOAD.UPD,
1124: sysdate);
1125:
1126: --update the ACC table
1127: l_upd_dsql := 'UPDATE ' || l_acc_table_name

Line 1190: ASG_DOWNLOAD.UPD,

1186: --mark dirty the SDQ
1187: l_mark_dirty := MakeDirtyForResource(l_publication_item_name,
1188: l_single_access_id_list,
1189: l_tl_omfs_palm_resource_list,
1190: ASG_DOWNLOAD.UPD,
1191: sysdate);
1192:
1193: --update the ACC table
1194: l_upd_dsql := 'UPDATE ' || l_acc_table_name

Line 1262: p_dmlList => ASG_DOWNLOAD.INS,

1258: l_mark_dirty := MakeDirtyForResource(
1259: p_publication_item => l_publication_item_name,
1260: p_accessList => l_single_access_id_list,
1261: p_resourceList => l_all_omfs_palm_resource_list,
1262: p_dmlList => ASG_DOWNLOAD.INS,
1263: p_timestamp => sysdate);
1264:
1265: --generate the sql for inserting new values into ACC table
1266: l_dsql :=