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

Line 8: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

4: --
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_PICK_UTILS';
7: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cspgtpub.pls';
8: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
9: G_LOGIN_ID NUMBER := FND_GLOBAL.LOGIN_ID;
10: G_MIN_QUANTITY NUMBER := 0;
11: G_MAX_QUANTITY NUMBER := 0;
12: G_SAFETY_FACTOR NUMBER := 0;

Line 9: G_LOGIN_ID NUMBER := FND_GLOBAL.LOGIN_ID;

5:
6: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_PICK_UTILS';
7: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cspgtpub.pls';
8: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
9: G_LOGIN_ID NUMBER := FND_GLOBAL.LOGIN_ID;
10: G_MIN_QUANTITY NUMBER := 0;
11: G_MAX_QUANTITY NUMBER := 0;
12: G_SAFETY_FACTOR NUMBER := 0;
13: G_SAFETY_STOCK NUMBER := 0;

Line 351: l_user_id := fnd_global.user_id;

347:
348: x_return_status := FND_API.G_RET_STS_SUCCESS;
349:
350: SELECT Sysdate INTO l_today FROM dual;
351: l_user_id := fnd_global.user_id;
352: l_login_id := fnd_global.login_id;
353:
354: -- If p_move_order_type = 2 or 3 (include replenishment move orders) then
355: -- create records in spares move order tables

Line 352: l_login_id := fnd_global.login_id;

348: x_return_status := FND_API.G_RET_STS_SUCCESS;
349:
350: SELECT Sysdate INTO l_today FROM dual;
351: l_user_id := fnd_global.user_id;
352: l_login_id := fnd_global.login_id;
353:
354: -- If p_move_order_type = 2 or 3 (include replenishment move orders) then
355: -- create records in spares move order tables
356: IF (p_move_order_type = 2 OR p_move_order_type = 3) THEN

Line 579: x_msg_data := x_msg_data || fnd_global.local_chr(10);

575:
576: x_msg_data := x_msg_data || t_msg_data;
577:
578: IF mod(l_return_count, 2) = 0 THEN
579: x_msg_data := x_msg_data || fnd_global.local_chr(10);
580: END IF;
581: l_return_count := l_return_count + 1;
582: end loop;
583: l_return_status := fnd_api.g_ret_sts_success;

Line 593: l_trolin_rec.last_updated_by := FND_GLOBAL.USER_ID;

589: -- update mtl_txn_request_lines with the detailed quantity
590: l_trolin_rec := INV_Trolin_util.Query_Row( mo_line_rec.line_id );
591: l_trolin_rec.quantity_detailed := l_detailed_qty;
592: l_trolin_rec.last_update_date := SYSDATE;
593: l_trolin_rec.last_updated_by := FND_GLOBAL.USER_ID;
594: l_trolin_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
595:
596: INV_Trolin_Util.Update_Row(l_trolin_rec);
597:

Line 594: l_trolin_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

590: l_trolin_rec := INV_Trolin_util.Query_Row( mo_line_rec.line_id );
591: l_trolin_rec.quantity_detailed := l_detailed_qty;
592: l_trolin_rec.last_update_date := SYSDATE;
593: l_trolin_rec.last_updated_by := FND_GLOBAL.USER_ID;
594: l_trolin_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
595:
596: INV_Trolin_Util.Update_Row(l_trolin_rec);
597:
598: /* update mtl_txn_request_lines

Line 1790: l_trolin_rec.last_updated_by := FND_GLOBAL.USER_ID;

1786:
1787: l_trolin_rec := INV_Trolin_util.Query_Row( pickline_rec.line_id );
1788: l_trolin_rec.quantity_detailed := pickline_rec.qty_det;
1789: l_trolin_rec.last_update_date := SYSDATE;
1790: l_trolin_rec.last_updated_by := FND_GLOBAL.USER_ID;
1791: l_trolin_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1792:
1793: INV_Trolin_Util.Update_Row(l_trolin_rec);
1794: commit;

Line 1791: l_trolin_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

1787: l_trolin_rec := INV_Trolin_util.Query_Row( pickline_rec.line_id );
1788: l_trolin_rec.quantity_detailed := pickline_rec.qty_det;
1789: l_trolin_rec.last_update_date := SYSDATE;
1790: l_trolin_rec.last_updated_by := FND_GLOBAL.USER_ID;
1791: l_trolin_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1792:
1793: INV_Trolin_Util.Update_Row(l_trolin_rec);
1794: commit;
1795:

Line 2419: G_RESOURCE_CODE := G_RESOURCE_CODE||fnd_global.local_chr(127)||

2415: if G_TASK_ASSIGNMENT_ID is null then
2416: G_TASK_ASSIGNMENT_ID := cr.task_assignment_id;
2417: end if;
2418: if G_RESOURCE_NAME is not null then
2419: G_RESOURCE_CODE := G_RESOURCE_CODE||fnd_global.local_chr(127)||
2420: cr.resource_type_code||cr.resource_id;
2421: G_RESOURCE_NAME :=
2422: G_RESOURCE_NAME||fnd_global.local_chr(127)||
2423: csp_pick_utils.get_object_name(cr.resource_type_code,cr.resource_id);

Line 2422: G_RESOURCE_NAME||fnd_global.local_chr(127)||

2418: if G_RESOURCE_NAME is not null then
2419: G_RESOURCE_CODE := G_RESOURCE_CODE||fnd_global.local_chr(127)||
2420: cr.resource_type_code||cr.resource_id;
2421: G_RESOURCE_NAME :=
2422: G_RESOURCE_NAME||fnd_global.local_chr(127)||
2423: csp_pick_utils.get_object_name(cr.resource_type_code,cr.resource_id);
2424: else
2425: G_RESOURCE_CODE := cr.resource_type_code||cr.resource_id;
2426: G_RESOURCE_NAME :=

Line 2560: AND SECURITY_GROUP_ID = fnd_global.lookup_security_group(LV.LOOKUP_TYPE,

2556: WHERE lookup_type = 'SHIPMENT LINE STATUS'
2557: AND lookup_code = l_status
2558: AND LANGUAGE = USERENV('LANG')
2559: AND VIEW_APPLICATION_ID = 201
2560: AND SECURITY_GROUP_ID = fnd_global.lookup_security_group(LV.LOOKUP_TYPE,
2561: LV.VIEW_APPLICATION_ID);
2562:
2563: EXCEPTION
2564: WHEN NO_DATA_FOUND THEN

Line 2573: AND SECURITY_GROUP_ID = fnd_global.Lookup_Security_Group(lv.lookup_type,

2569: WHERE lookup_type = 'LINE_FLOW_STATUS'
2570: AND lookup_code = p_flow_status_code
2571: AND LANGUAGE = userenv('LANG')
2572: AND VIEW_APPLICATION_ID = 660
2573: AND SECURITY_GROUP_ID = fnd_global.Lookup_Security_Group(lv.lookup_type,
2574: lv.view_application_id);
2575: WHEN OTHERS THEN
2576: null;
2577: END;

Line 2591: AND SECURITY_GROUP_ID = fnd_global.Lookup_Security_Group(lv.lookup_type,

2587: WHERE lookup_type = 'LINE_FLOW_STATUS'
2588: AND lookup_code = p_flow_status_code
2589: AND LANGUAGE = userenv('LANG')
2590: AND VIEW_APPLICATION_ID = 660
2591: AND SECURITY_GROUP_ID = fnd_global.Lookup_Security_Group(lv.lookup_type,
2592: lv.view_application_id);
2593: /* status is AWAITING_SHIPPING or PRODUCTION_COMPLETE, get value from
2594: * shipping table */
2595: ELSE

Line 2613: AND SECURITY_GROUP_ID = fnd_global.Lookup_Security_Group(lv.lookup_type,

2609: WHERE lookup_type = 'LINE_FLOW_STATUS'
2610: AND lookup_code = 'PICKED'
2611: AND LANGUAGE = userenv('LANG')
2612: AND VIEW_APPLICATION_ID = 660
2613: AND SECURITY_GROUP_ID = fnd_global.Lookup_Security_Group(lv.lookup_type,
2614: lv.view_application_id);
2615: ELSIF l_released_count < l_total_count and l_released_count <> 0 THEN
2616: l_status := 'PICKED_PARTIAL';
2617: SELECT meaning

Line 2624: AND SECURITY_GROUP_ID = fnd_global.Lookup_Security_Group(lv.lookup_type,

2620: WHERE lookup_type = 'LINE_FLOW_STATUS'
2621: AND lookup_code = 'PICKED_PARTIAL'
2622: AND LANGUAGE = userenv('LANG')
2623: AND VIEW_APPLICATION_ID = 660
2624: AND SECURITY_GROUP_ID = fnd_global.Lookup_Security_Group(lv.lookup_type,
2625: lv.view_application_id);
2626: ELSE
2627: SELECT meaning
2628: INTO G_STATUS_MEANING

Line 2634: AND SECURITY_GROUP_ID = fnd_global.Lookup_Security_Group(lv.lookup_type,

2630: WHERE lookup_type = 'LINE_FLOW_STATUS'
2631: AND lookup_code = l_status
2632: AND LANGUAGE = userenv('LANG')
2633: AND VIEW_APPLICATION_ID = 660
2634: AND SECURITY_GROUP_ID = fnd_global.Lookup_Security_Group(lv.lookup_type,
2635: lv.view_application_id);
2636: END IF;
2637: END IF;
2638: RETURN(l_status);