DBA Data[Home] [Help]

APPS.CSM_MTL_SYSTEM_ITEMS_EVENT_PKG dependencies on FND_GLOBAL

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

272: FORALL i IN 1..l_tab_access_id.COUNT
273: INSERT INTO csm_mtl_system_items_acc(access_id, user_id, inventory_item_id, organization_id, counter,
274: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
275: VALUES (l_tab_access_id(i), p_user_id, l_inventory_item_id_tbl(i), l_organization_id_tbl(i), 1,
276: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
277:
278: /*** push to oLite using asg_download ***/
279: -- do bulk makedirty
280: l_markdirty := asg_download.mark_dirty(

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

313: FORALL i IN 1..l_tab_access_id.COUNT
314: INSERT INTO csm_mtl_system_items_acc(access_id, user_id, inventory_item_id, organization_id, counter,
315: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
316: VALUES (l_tab_access_id(i), p_user_id, l_inventory_item_id_tbl(i), l_organization_id_tbl(i), 1,
317: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
318:
319: /*** push to oLite using asg_download ***/
320: -- do bulk makedirty
321: l_markdirty := asg_download.mark_dirty(

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

354: FORALL i IN 1..l_tab_access_id.COUNT
355: INSERT INTO csm_mtl_system_items_acc(access_id, user_id, inventory_item_id, organization_id, counter,
356: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
357: VALUES (l_tab_access_id(i), p_user_id, l_inventory_item_id_tbl(i), l_organization_id_tbl(i), 1,
358: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
359:
360: /*** push to oLite using asg_download ***/
361: -- do bulk makedirty
362: l_markdirty := asg_download.mark_dirty(

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

395: FORALL i IN 1..l_tab_access_id.COUNT
396: INSERT INTO csm_mtl_system_items_acc(access_id, user_id, inventory_item_id, organization_id, counter,
397: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
398: VALUES (l_tab_access_id(i), p_user_id, l_inventory_item_id_tbl(i), l_organization_id_tbl(i), 1,
399: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
400:
401: /*** push to oLite using asg_download ***/
402: -- do bulk makedirty
403: l_markdirty := asg_download.mark_dirty(

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

531:
532: l_stmt := 'UPDATE csm_mtl_system_items_acc acc';
533: l_stmt := l_stmt || ' SET COUNTER = COUNTER - 1';
534: l_stmt := l_stmt || ' , LAST_UPDATE_DATE = SYSDATE';
535: l_stmt := l_stmt || ' , last_updated_by = nvl(fnd_global.user_id, 1)';
536: l_stmt := l_stmt || ' WHERE USER_ID = :1';
537: l_stmt := l_stmt || ' AND organization_id = :2';
538:
539: IF (p_category_id IS NOT NULL) THEN