APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on ASG_BASE

Line 1677: asg_base.get_user_id(substr(l_role,5,length(l_role)-9)),l_resp_id,l_app_id));

1673: l_count := l_try;
1674: end if;
1675:
1676: l_timeout := to_number(fnd_profile.value_specific('CSM_ALERT_TIMEOUT_'||l_count,
1677: asg_base.get_user_id(substr(l_role,5,length(l_role)-9)),l_resp_id,l_app_id));
1678:
1679: --try sending Email again
1680: wf_notification.forward(l_nid,l_role);
1681:

Line 2076: VALUES(asg_base.get_user_id(p_user_name),l_notification_id,'DEFERRED_TRANSACTION',l_tracking_id,'NEW',0,sysdate,1,sysdate,1);

2072: IF(l_notification_id <> -1) THEN
2073: -- insert into auto sync table
2074: INSERT INTO csm_auto_sync_nfn(USER_ID,NOTIFICATION_ID,OBJECT_NAME,OBJECT_ID,DML,REMINDERS_SENT,CREATION_DATE,CREATED_BY
2075: ,LAST_UPDATE_DATE,LAST_UPDATED_BY)
2076: VALUES(asg_base.get_user_id(p_user_name),l_notification_id,'DEFERRED_TRANSACTION',l_tracking_id,'NEW',0,sysdate,1,sysdate,1);
2077:
2078: CSM_ACC_PKG.Insert_Acc
2079: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_AUTO_SYNC_NFN')
2080: ,P_ACC_TABLE_NAME => 'CSM_AUTO_SYNC_NFN_ACC'

Line 2084: ,P_USER_ID => asg_base.get_user_id(p_user_name)

2080: ,P_ACC_TABLE_NAME => 'CSM_AUTO_SYNC_NFN_ACC'
2081: ,P_SEQ_NAME => 'CSM_AUTO_SYNC_NFN_ACC_S'
2082: ,P_PK1_NAME => 'NOTIFICATION_ID'
2083: ,P_PK1_NUM_VALUE => l_notification_id
2084: ,P_USER_ID => asg_base.get_user_id(p_user_name)
2085: );
2086:
2087: CSM_UTIL_PKG.LOG('Invoke timer for '||l_notification_id,
2088: 'CSM_NOTIFICATION_EVENT_PKG.notify_deferred',FND_LOG.LEVEL_PROCEDURE);

Line 2095: l_timeout := to_number(fnd_profile.value_specific('CSM_ALERT_TIMEOUT_1',asg_base.get_user_id(p_user_name),l_resp_id,l_app_id));

2091: OPEN c_get_resp_id(p_user_name);
2092: FETCH c_get_resp_id INTO l_app_id,l_resp_id;
2093: CLOSE c_get_resp_id;
2094:
2095: l_timeout := to_number(fnd_profile.value_specific('CSM_ALERT_TIMEOUT_1',asg_base.get_user_id(p_user_name),l_resp_id,l_app_id));
2096:
2097: IF l_timeout > 0 THEN
2098: --timer logic - Fixed 3 tries + 1 original email
2099: wf_event_t.initialize(l_wftimer);

Line 2134: ,P_USER_ID => asg_base.get_user_id(p_user_name)

2130: ,P_ACC_TABLE_NAME => 'CSM_DEFERRED_TRANSACTIONS_ACC'
2131: ,P_SEQ_NAME => 'CSM_DEFERRED_TXNS_ACC_S'
2132: ,P_PK1_NAME => 'TRACKING_ID'
2133: ,P_PK1_NUM_VALUE => l_tracking_id
2134: ,P_USER_ID => asg_base.get_user_id(p_user_name)
2135: );
2136:
2137: --Email even if l_notification_id is -1
2138: IF isROOT THEN

Line 2219: ||' from '||asg_base.G_OLITE_SCHEMA||'.dm$all_devices a, '||asg_base.G_OLITE_SCHEMA||'.dm$user_device b, '||asg_base.G_OLITE_SCHEMA||'.users c '

2215: l_dev_type := p_event.GetValueForParameter('DEVICE_TYPE');
2216:
2217: BEGIN
2218: l_sql:= 'select upper(device_name) from (select a.NAME as DEVICE_NAME '
2219: ||' from '||asg_base.G_OLITE_SCHEMA||'.dm$all_devices a, '||asg_base.G_OLITE_SCHEMA||'.dm$user_device b, '||asg_base.G_OLITE_SCHEMA||'.users c '
2220: ||' where a.ID=b.DEVICE_ID and b.USER_ID=c.id and c.DISPLAY_NAME =:1 order by A.ACCESS_TIME desc ) where rownum < 2';
2221:
2222: EXECUTE IMMEDIATE l_sql INTO l_dev_name USING l_client_id;
2223: EXCEPTION

Line 2345: FROM '||asg_base.G_OLITE_SCHEMA||'.c$sync_history HIST , ASG_USER au

2341:
2342:
2343: OPEN cur FOR 'SELECT SESSION_ID,client_id,DECODE(DEVICE_PLATFORM,''WCE'',''WINCE'',''LAPTOP'') as DEVICE_TYPE,
2344: dbms_lob.substr(message,1990,1)||''...'' as ERROR_MSG, START_TIME AS SYNC_DATE
2345: FROM '||asg_base.G_OLITE_SCHEMA||'.c$sync_history HIST , ASG_USER au
2346: WHERE RESULT<>''SUCCESS''
2347: AND trim(CLIENT_ID) IS NOT NULL
2348: AND CLIENT_ID = AU.USER_NAME
2349: AND START_TIME > AU.CREATION_DATE

Line 2367: ||' from '||asg_base.G_OLITE_SCHEMA||'.dm$all_devices a, '||asg_base.G_OLITE_SCHEMA||'.dm$user_device b, '||asg_base.G_OLITE_SCHEMA||'.users c '

2363:
2364: l_curr_client_id := l_client_id;
2365: BEGIN
2366: l_sql:= 'select upper(device_name) from (select a.NAME as DEVICE_NAME '
2367: ||' from '||asg_base.G_OLITE_SCHEMA||'.dm$all_devices a, '||asg_base.G_OLITE_SCHEMA||'.dm$user_device b, '||asg_base.G_OLITE_SCHEMA||'.users c '
2368: ||' where a.ID=b.DEVICE_ID and b.USER_ID=c.id and c.DISPLAY_NAME =:1 order by A.ACCESS_TIME desc ) where rownum < 2';
2369:
2370: EXECUTE IMMEDIATE l_sql INTO l_dev_name USING l_client_id;
2371: EXCEPTION