APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 1793: l_user_list asg_download.pk_list;

1789: FROM ASG_USER
1790: WHERE USER_NAME=b_user_name;
1791:
1792: l_user_string VARCHAR2(4000);
1793: l_user_list asg_download.pk_list;
1794: l_resp_id NUMBER;
1795: l_app_id NUMBER;
1796: l_notification_id NUMBER;
1797:

Line 1827: l_user_list := asg_download.get_listfrom_string(upper(l_user_string));

1823: IF l_user_string IS NULL THEN
1824: RAISE NO_DATA_FOUND;
1825: END IF;
1826:
1827: l_user_list := asg_download.get_listfrom_string(upper(l_user_string));
1828:
1829: wf_event_t.initialize(l_wf_param);
1830: l_wf_param.AddParameterToList('TEMPLATE','DEFERRED_ERROR_REPORT');
1831:

Line 2199: l_user_list asg_download.pk_list;

2195: FROM ASG_USER
2196: WHERE USER_NAME=b_user_name;
2197:
2198: l_user_string VARCHAR2(4000);
2199: l_user_list asg_download.pk_list;
2200: l_resp_id NUMBER;
2201: l_app_id NUMBER;
2202: l_notification_id NUMBER;
2203:

Line 2251: l_user_list := asg_download.get_listfrom_string(upper(l_user_string));

2247:
2248: l_user_string :=l_client_id;
2249: END;
2250:
2251: l_user_list := asg_download.get_listfrom_string(upper(l_user_string));
2252:
2253: wf_event_t.initialize(l_wf_param);
2254: l_wf_param.AddParameterToList('TEMPLATE','SYNC_ERROR_REPORT');
2255:

Line 2318: l_user_list asg_download.pk_list;

2314: FROM ASG_USER
2315: WHERE USER_NAME=b_user_name;
2316:
2317: l_user_string VARCHAR2(4000);
2318: l_user_list asg_download.pk_list;
2319: l_resp_id NUMBER;
2320: l_app_id NUMBER;
2321: l_notification_id NUMBER;
2322: l_curr_client_id VARCHAR2(100);

Line 2402: l_user_list := asg_download.get_listfrom_string(upper(l_user_string));

2398: IF(l_user_list.COUNT>0) THEN
2399: l_user_list.DELETE;
2400: END IF;
2401:
2402: l_user_list := asg_download.get_listfrom_string(upper(l_user_string));
2403:
2404: END IF;
2405:
2406: wf_event_t.initialize(l_wf_param);