APPS.CSM_USER_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 986: l_tab_user_id asg_download.user_list;

982: l_owner_id NUMBER;
983: l_group_id NUMBER;
984: l_access_id NUMBER;
985: l_markdirty BOOLEAN;
986: l_tab_user_id asg_download.user_list;
987: l_tab_owner_id asg_download.user_list;
988: l_tab_access_id asg_download.access_list;
989: g_pub_item varchar2(30) := 'CSF_M_USER';
990:

Line 987: l_tab_owner_id asg_download.user_list;

983: l_group_id NUMBER;
984: l_access_id NUMBER;
985: l_markdirty BOOLEAN;
986: l_tab_user_id asg_download.user_list;
987: l_tab_owner_id asg_download.user_list;
988: l_tab_access_id asg_download.access_list;
989: g_pub_item varchar2(30) := 'CSF_M_USER';
990:
991: CURSOR c_asg_user(l_user_id NUMBER)

Line 988: l_tab_access_id asg_download.access_list;

984: l_access_id NUMBER;
985: l_markdirty BOOLEAN;
986: l_tab_user_id asg_download.user_list;
987: l_tab_owner_id asg_download.user_list;
988: l_tab_access_id asg_download.access_list;
989: g_pub_item varchar2(30) := 'CSF_M_USER';
990:
991: CURSOR c_asg_user(l_user_id NUMBER)
992: IS

Line 1032: l_markdirty := asg_download.mark_dirty(

1028: 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)
1029: VALUES (l_access_id,l_user_id,l_owner_id,1,sysdate,1,sysdate,1,1);
1030: CLOSE c_user_acc;
1031:
1032: l_markdirty := asg_download.mark_dirty(
1033: p_pub_item => g_pub_item
1034: , p_accessid => l_access_id
1035: , p_userid => l_owner_id
1036: , p_dml => 'I'

Line 1064: l_markdirty := asg_download.mark_dirty(

1060: SET OWNER_ID = l_tab_owner_id(i),
1061: LAST_UPDATE_DATE = SYSDATE
1062: WHERE USER_ID = l_tab_user_id(i);
1063:
1064: l_markdirty := asg_download.mark_dirty(
1065: p_pub_item => g_pub_item
1066: , p_accessid => l_tab_access_id(i)
1067: , p_userid => l_tab_owner_id(i)
1068: , p_dml => 'U'

Line 1121: l_markdirty := asg_download.mark_dirty(

1117: FETCH c_user_acc INTO l_access_id,l_user_id,l_owner_id;
1118: --Do mark dirty only for the User
1119: IF c_user_acc%FOUND THEN
1120: IF l_user_id <> l_owner_id THEN --Do not do mark dirty for individual users and owners
1121: l_markdirty := asg_download.mark_dirty(
1122: p_pub_item => g_pub_item
1123: , p_accessid => l_access_id
1124: , p_userid => l_owner_id
1125: , p_dml => 'D'

Line 1197: l_markdirty := asg_download.mark_dirty(

1193:
1194: CSM_UTIL_PKG.LOG('Record inserted into the Access table: (User_id,owner_id) : (' || p_user_id||','||p_owner_id||') and Marking dirty',
1195: 'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);
1196:
1197: l_markdirty := asg_download.mark_dirty(
1198: p_pub_item => g_pub_item
1199: , p_accessid => l_access_id
1200: , p_userid => p_owner_id
1201: , p_dml => 'I'

Line 1244: l_markdirty := asg_download.mark_dirty(

1240: FETCH c_user_acc INTO l_access_id,l_counter;
1241:
1242: IF c_user_acc%FOUND THEN
1243: IF l_counter=1 THEN
1244: l_markdirty := asg_download.mark_dirty(
1245: p_pub_item => g_pub_item
1246: , p_accessid => l_access_id
1247: , p_userid => p_owner_id
1248: , p_dml => 'D'