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.

[Home] [Help]

APPS.CSM_MTL_SYSTEM_ITEMS_EVENT_PKG dependencies on FND_GLOBAL

Line 192: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id

188: --Do a direct into into the ACC table for user -1
189: INSERT INTO csm_mtl_system_items_acc(access_id, user_id, inventory_item_id, organization_id, counter,
190: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
191: SELECT csm_mtl_system_items_acc_s.NEXTVAL,l_number, b.inventory_item_id, b.organization_id, 1,
192: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id
193: FROM MTL_SYSTEM_ITEMS_B b
194: WHERE b.ORGANIZATION_ID = p_organization_id
195: AND b.enabled_flag = 'Y'
196: AND SYSDATE BETWEEN nvl(b.start_date_active, SYSDATE)

Line 371: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);

367: FORALL i IN 1..l_tab_access_id.COUNT
368: INSERT INTO csm_mtl_system_items_acc(access_id, user_id, inventory_item_id, organization_id, counter,
369: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
370: VALUES (l_tab_access_id(i), l_number, l_inventory_item_id_tbl(i), l_organization_id_tbl(i), 1,
371: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
372:
373: /*** push to oLite using asg_download ***/
374: -- do bulk makedirty
375: l_markdirty := asg_download.mark_dirty(

Line 412: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);

408: FORALL i IN 1..l_tab_access_id.COUNT
409: INSERT INTO csm_mtl_system_items_acc(access_id, user_id, inventory_item_id, organization_id, counter,
410: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
411: VALUES (l_tab_access_id(i), l_number, l_inventory_item_id_tbl(i), l_organization_id_tbl(i), 1,
412: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
413:
414: /*** push to oLite using asg_download ***/
415: -- do bulk makedirty
416: l_markdirty := asg_download.mark_dirty(

Line 453: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);

449: FORALL i IN 1..l_tab_access_id.COUNT
450: INSERT INTO csm_mtl_system_items_acc(access_id, user_id, inventory_item_id, organization_id, counter,
451: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
452: VALUES (l_tab_access_id(i), l_number, l_inventory_item_id_tbl(i), l_organization_id_tbl(i), 1,
453: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
454:
455: /*** push to oLite using asg_download ***/
456: -- do bulk makedirty
457: l_markdirty := asg_download.mark_dirty(

Line 494: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);

490: FORALL i IN 1..l_tab_access_id.COUNT
491: INSERT INTO csm_mtl_system_items_acc(access_id, user_id, inventory_item_id, organization_id, counter,
492: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
493: VALUES (l_tab_access_id(i), l_number, l_inventory_item_id_tbl(i), l_organization_id_tbl(i), 1,
494: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
495:
496: /*** push to oLite using asg_download ***/
497: -- do bulk makedirty
498: l_markdirty := asg_download.mark_dirty(

Line 705: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id

701: --Do a direct into into the ACC table for user -2
702: INSERT INTO csm_mtl_system_items_acc(access_id, user_id, inventory_item_id, organization_id, counter,
703: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
704: SELECT csm_mtl_system_items_acc_s.NEXTVAL, -2, msi.inventory_item_id, msi.organization_id, 1,
705: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id
706: FROM MTL_SYSTEM_ITEMS_B msi
707: WHERE msi.enabled_flag = 'Y'
708: AND SYSDATE BETWEEN nvl(msi.start_date_active, SYSDATE) AND nvl(msi.end_date_active, SYSDATE)
709: AND msi.ORGANIZATION_ID

Line 871: l_stmt := l_stmt || ' , last_updated_by = nvl(fnd_global.user_id, 1)';

867:
868: l_stmt := 'UPDATE csm_mtl_system_items_acc acc';
869: l_stmt := l_stmt || ' SET COUNTER = COUNTER - 1';
870: l_stmt := l_stmt || ' , LAST_UPDATE_DATE = SYSDATE';
871: l_stmt := l_stmt || ' , last_updated_by = nvl(fnd_global.user_id, 1)';
872: l_stmt := l_stmt || ' WHERE USER_ID = :1';
873: l_stmt := l_stmt || ' AND organization_id = :2';
874:
875: IF (p_category_id IS NOT NULL) THEN

Line 1140: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id);

1136: FORALL i IN 1..l_tab_access_id.COUNT
1137: INSERT INTO csm_mtl_system_items_acc(access_id, user_id, inventory_item_id, organization_id, counter,
1138: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
1139: VALUES (l_tab_access_id(i), l_tab_user_id(i), l_inventory_item_id_tbl(i), l_organization_id_tbl(i), 1,
1140: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id);
1141:
1142: /*** push to oLite using asg_download ***/
1143: -- do bulk makedirty
1144: l_markdirty := asg_download.mark_dirty(

Line 1309: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id);

1305: FORALL i IN 1..l_tab_access_id.COUNT
1306: INSERT INTO csm_mtl_system_items_acc(access_id, user_id, inventory_item_id, organization_id, counter,
1307: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
1308: VALUES (l_tab_access_id(i), l_tab_user_id(i), l_inventory_item_id_tbl(i), l_organization_id_tbl(i), 1,
1309: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id);
1310:
1311: /*** push to oLite using asg_download ***/
1312: -- do bulk makedirty
1313: l_markdirty := asg_download.mark_dirty(