APPS.CSM_USER_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 1043: l_tab_user_id asg_download.user_list;

1039: l_owner_id NUMBER;
1040: l_group_id NUMBER;
1041: l_access_id NUMBER;
1042: l_markdirty BOOLEAN;
1043: l_tab_user_id asg_download.user_list;
1044: l_tab_owner_id asg_download.user_list;
1045: l_tab_access_id asg_download.access_list;
1046: g_pub_item varchar2(30) := 'CSF_M_USER';
1047:

Line 1044: l_tab_owner_id asg_download.user_list;

1040: l_group_id NUMBER;
1041: l_access_id NUMBER;
1042: l_markdirty BOOLEAN;
1043: l_tab_user_id asg_download.user_list;
1044: l_tab_owner_id asg_download.user_list;
1045: l_tab_access_id asg_download.access_list;
1046: g_pub_item varchar2(30) := 'CSF_M_USER';
1047:
1048: CURSOR c_asg_user(l_user_id NUMBER)

Line 1045: l_tab_access_id asg_download.access_list;

1041: l_access_id NUMBER;
1042: l_markdirty BOOLEAN;
1043: l_tab_user_id asg_download.user_list;
1044: l_tab_owner_id asg_download.user_list;
1045: l_tab_access_id asg_download.access_list;
1046: g_pub_item varchar2(30) := 'CSF_M_USER';
1047:
1048: CURSOR c_asg_user(l_user_id NUMBER)
1049: IS

Line 1089: l_markdirty := asg_download.mark_dirty(

1085: INSERT INTO CSM_USER_ACC(ACCESS_ID,USER_ID,OWNER_ID,COUNTER,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN)
1086: VALUES (l_access_id,l_user_id,l_owner_id,1,sysdate,1,sysdate,1,1);
1087: CLOSE c_user_acc;
1088:
1089: l_markdirty := asg_download.mark_dirty(
1090: p_pub_item => g_pub_item
1091: , p_accessid => l_access_id
1092: , p_userid => l_owner_id
1093: , p_dml => 'I'

Line 1121: l_markdirty := asg_download.mark_dirty(

1117: SET OWNER_ID = l_tab_owner_id(i),
1118: LAST_UPDATE_DATE = SYSDATE
1119: WHERE USER_ID = l_tab_user_id(i);
1120:
1121: l_markdirty := asg_download.mark_dirty(
1122: p_pub_item => g_pub_item
1123: , p_accessid => l_tab_access_id(i)
1124: , p_userid => l_tab_owner_id(i)
1125: , p_dml => 'U'

Line 1178: l_markdirty := asg_download.mark_dirty(

1174: FETCH c_user_acc INTO l_access_id,l_user_id,l_owner_id;
1175: --Do mark dirty only for the User
1176: IF c_user_acc%FOUND THEN
1177: IF l_user_id <> l_owner_id THEN --Do not do mark dirty for individual users and owners
1178: l_markdirty := asg_download.mark_dirty(
1179: p_pub_item => g_pub_item
1180: , p_accessid => l_access_id
1181: , p_userid => l_owner_id
1182: , p_dml => 'D'

Line 1254: l_markdirty := asg_download.mark_dirty(

1250:
1251: CSM_UTIL_PKG.LOG('Record inserted into the Access table: (User_id,owner_id) : (' || p_user_id||','||p_owner_id||') and Marking dirty',
1252: 'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);
1253:
1254: l_markdirty := asg_download.mark_dirty(
1255: p_pub_item => g_pub_item
1256: , p_accessid => l_access_id
1257: , p_userid => p_owner_id
1258: , p_dml => 'I'

Line 1301: l_markdirty := asg_download.mark_dirty(

1297: FETCH c_user_acc INTO l_access_id,l_counter;
1298:
1299: IF c_user_acc%FOUND THEN
1300: IF l_counter=1 THEN
1301: l_markdirty := asg_download.mark_dirty(
1302: p_pub_item => g_pub_item
1303: , p_accessid => l_access_id
1304: , p_userid => p_owner_id
1305: , p_dml => 'D'