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_ACC_PKG dependencies on ASG_USER

Line 15: CURSOR c_asg_user (c_user_id NUMBER)

11: -- Person Date Comments
12: -- Anurag 09/16/02 Created
13: -- --------- ------ ------------------------------------------
14: -- Enter procedure, function bodies as shown below
15: CURSOR c_asg_user (c_user_id NUMBER)
16: IS
17: SELECT resource_id
18: FROM ASG_USER
19: WHERE user_id = c_user_id

Line 18: FROM ASG_USER

14: -- Enter procedure, function bodies as shown below
15: CURSOR c_asg_user (c_user_id NUMBER)
16: IS
17: SELECT resource_id
18: FROM ASG_USER
19: WHERE user_id = c_user_id
20: AND Enabled ='Y';
21:
22:

Line 320: OPEN c_asg_user (l_user_id);

316: RETURNING INTO l_access_id;
317: END IF;
318: -- insert record in outqueue ASG call here *****************************************
319: --get the resource id
320: OPEN c_asg_user (l_user_id);
321: FETCH c_asg_user INTO l_resource_id;
322: CLOSE c_asg_user;
323:
324: IF l_resource_id IS NOT NULL THEN --do mark diry only for valid MFS user

Line 321: FETCH c_asg_user INTO l_resource_id;

317: END IF;
318: -- insert record in outqueue ASG call here *****************************************
319: --get the resource id
320: OPEN c_asg_user (l_user_id);
321: FETCH c_asg_user INTO l_resource_id;
322: CLOSE c_asg_user;
323:
324: IF l_resource_id IS NOT NULL THEN --do mark diry only for valid MFS user
325: FOR i IN 1 .. p_publication_item_names.LAST LOOP

Line 322: CLOSE c_asg_user;

318: -- insert record in outqueue ASG call here *****************************************
319: --get the resource id
320: OPEN c_asg_user (l_user_id);
321: FETCH c_asg_user INTO l_resource_id;
322: CLOSE c_asg_user;
323:
324: IF l_resource_id IS NOT NULL THEN --do mark diry only for valid MFS user
325: FOR i IN 1 .. p_publication_item_names.LAST LOOP
326: l_rc := asg_download.markDirty(p_publication_item_names(i), l_access_id, l_resource_id, 'I', sysdate );

Line 475: OPEN c_asg_user (l_tab_mobile_user_id(i));

471: /*** yes -> loop over arrays containing mobile_user_id and access_id and notify oLite ***/
472: FOR i IN l_tab_mobile_user_id.FIRST .. l_tab_mobile_user_id.LAST LOOP
473: -- notify oLite of deletion ***
474: --get the resource id
475: OPEN c_asg_user (l_tab_mobile_user_id(i));
476: FETCH c_asg_user INTO l_resource_id;
477: CLOSE c_asg_user;
478:
479: IF l_resource_id IS NOT NULL THEN --do mark diry only for valid MFS user

Line 476: FETCH c_asg_user INTO l_resource_id;

472: FOR i IN l_tab_mobile_user_id.FIRST .. l_tab_mobile_user_id.LAST LOOP
473: -- notify oLite of deletion ***
474: --get the resource id
475: OPEN c_asg_user (l_tab_mobile_user_id(i));
476: FETCH c_asg_user INTO l_resource_id;
477: CLOSE c_asg_user;
478:
479: IF l_resource_id IS NOT NULL THEN --do mark diry only for valid MFS user
480: FOR j IN 1 .. p_publication_item_names.LAST LOOP

Line 477: CLOSE c_asg_user;

473: -- notify oLite of deletion ***
474: --get the resource id
475: OPEN c_asg_user (l_tab_mobile_user_id(i));
476: FETCH c_asg_user INTO l_resource_id;
477: CLOSE c_asg_user;
478:
479: IF l_resource_id IS NOT NULL THEN --do mark diry only for valid MFS user
480: FOR j IN 1 .. p_publication_item_names.LAST LOOP
481: l_rc := asg_download.markDirty( p_publication_item_names(j), l_tab_access_id(i)

Line 573: OPEN c_asg_user (l_user_id);

569: --Function replaces owner if data routed to owner is set
570: l_user_id := Check_for_owner(p_user_id);
571:
572: --get the resource id
573: OPEN c_asg_user (l_user_id);
574: FETCH c_asg_user INTO l_resource_id;
575: CLOSE c_asg_user;
576:
577: IF l_resource_id IS NOT NULL THEN --do mark diry only for valid MFS user

Line 574: FETCH c_asg_user INTO l_resource_id;

570: l_user_id := Check_for_owner(p_user_id);
571:
572: --get the resource id
573: OPEN c_asg_user (l_user_id);
574: FETCH c_asg_user INTO l_resource_id;
575: CLOSE c_asg_user;
576:
577: IF l_resource_id IS NOT NULL THEN --do mark diry only for valid MFS user
578: --call update outqueue ASG call *****************************************

Line 575: CLOSE c_asg_user;

571:
572: --get the resource id
573: OPEN c_asg_user (l_user_id);
574: FETCH c_asg_user INTO l_resource_id;
575: CLOSE c_asg_user;
576:
577: IF l_resource_id IS NOT NULL THEN --do mark diry only for valid MFS user
578: --call update outqueue ASG call *****************************************
579: FOR i IN 1 .. p_publication_item_names.LAST LOOP