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.OE_ORDER_PURGE_PVT dependencies on FND_GLOBAL

Line 429: p_created_by => FND_GLOBAL.USER_ID,

425: p_purge_set_submit_datetime => SYSDATE,
426: p_selected_ids => l_selected_ids,
427: p_count_selected => 0,
428: p_where_condition => l_where_condition,
429: p_created_by => FND_GLOBAL.USER_ID,
430: p_last_updated_by => FND_GLOBAL.USER_ID,
431: x_purge_set_id => l_purge_set_id
432: );
433:

Line 430: p_last_updated_by => FND_GLOBAL.USER_ID,

426: p_selected_ids => l_selected_ids,
427: p_count_selected => 0,
428: p_where_condition => l_where_condition,
429: p_created_by => FND_GLOBAL.USER_ID,
430: p_last_updated_by => FND_GLOBAL.USER_ID,
431: x_purge_set_id => l_purge_set_id
432: );
433:
434:

Line 946: p_created_by => FND_GLOBAL.USER_ID,

942: p_purge_set_submit_datetime => SYSDATE,
943: p_selected_ids => l_selected_ids,
944: p_count_selected => 0,
945: p_where_condition => l_where_condition,
946: p_created_by => FND_GLOBAL.USER_ID,
947: p_last_updated_by => FND_GLOBAL.USER_ID,
948: x_purge_set_id => l_purge_set_id
949: );
950:

Line 947: p_last_updated_by => FND_GLOBAL.USER_ID,

943: p_selected_ids => l_selected_ids,
944: p_count_selected => 0,
945: p_where_condition => l_where_condition,
946: p_created_by => FND_GLOBAL.USER_ID,
947: p_last_updated_by => FND_GLOBAL.USER_ID,
948: x_purge_set_id => l_purge_set_id
949: );
950:
951:

Line 1338: fnd_global.Lookup_Security_Group(lv.lookup_type,

1334: AND lookup_type='LINE_FLOW_STATUS'
1335: AND LANGUAGE = userenv('LANG')
1336: AND VIEW_APPLICATION_ID = 660
1337: AND SECURITY_GROUP_ID =
1338: fnd_global.Lookup_Security_Group(lv.lookup_type,
1339: lv.view_application_id);
1340: END IF;
1341:
1342: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510'

Line 1498: , FND_GLOBAL.USER_ID

1494: , l_flow_status
1495: , p_expiration_date
1496: , p_upgraded_flag
1497: , sysdate
1498: , FND_GLOBAL.USER_ID
1499: , sysdate
1500: , FND_GLOBAL.LOGIN_ID
1501: , NULL
1502: , NULL

Line 1500: , FND_GLOBAL.LOGIN_ID

1496: , p_upgraded_flag
1497: , sysdate
1498: , FND_GLOBAL.USER_ID
1499: , sysdate
1500: , FND_GLOBAL.LOGIN_ID
1501: , NULL
1502: , NULL
1503: , 0
1504: ,660);

Line 1559: IF l_created_by <> FND_GLOBAL.USER_ID THEN

1555: FETCH cur_logged_in_user INTO l_created_by;
1556: CLOSE cur_logged_in_user;
1557:
1558:
1559: IF l_created_by <> FND_GLOBAL.USER_ID THEN
1560:
1561: FND_MESSAGE.SET_NAME ('ONT', 'ONT_ONLY_CREATOR_CAN_PURGE');
1562: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
1563: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1572: AND created_by = fnd_global.user_id;

1568: SELECT orders_per_commit, purge_set_name
1569: INTO l_orders_per_commit, l_purge_set_name
1570: FROM OE_PURGE_SETS
1571: WHERE purge_set_id = p_purge_set_id
1572: AND created_by = fnd_global.user_id;
1573:
1574: IF nvl(l_orders_per_commit,0) = 0 THEN
1575: l_orders_per_commit := 1;
1576: oe_debug_pub.add('Orders per commit is not defined ');

Line 1658: AND created_by = fnd_global.user_id;

1654: UPDATE OE_PURGE_ORDERS
1655: SET IS_PURGED = 'Y'
1656: WHERE purge_set_id = p_purge_set_id
1657: AND header_id = l_header_id
1658: AND created_by = fnd_global.user_id;
1659:
1660: l_number_of_rec := l_number_of_rec + 1;
1661: l_purged_success := l_purged_success + 1; --added for bug 3680441
1662:

Line 1681: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1677:
1678: UPDATE OE_PURGE_SETS
1679: SET PURGE_SET_PURGED = 'Y',
1680: LAST_UPDATE_DATE = SYSDATE,
1681: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1682: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1683: WHERE PURGE_SET_ID = p_purge_set_id
1684: AND CREATED_BY = fnd_global.user_id;
1685: COMMIT;

Line 1682: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

1678: UPDATE OE_PURGE_SETS
1679: SET PURGE_SET_PURGED = 'Y',
1680: LAST_UPDATE_DATE = SYSDATE,
1681: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1682: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1683: WHERE PURGE_SET_ID = p_purge_set_id
1684: AND CREATED_BY = fnd_global.user_id;
1685: COMMIT;
1686: --added for bug 3680441

Line 1684: AND CREATED_BY = fnd_global.user_id;

1680: LAST_UPDATE_DATE = SYSDATE,
1681: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1682: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1683: WHERE PURGE_SET_ID = p_purge_set_id
1684: AND CREATED_BY = fnd_global.user_id;
1685: COMMIT;
1686: --added for bug 3680441
1687: l_purge_failure := l_number_of_orders - l_purged_success;
1688: