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.WMS_DEPLOY dependencies on MTL_CLIENT_PARAMETERS

Line 13: g_client_code mtl_client_parameters.client_code%TYPE;

9: g_item_segment_count NUMBER;
10: --g_item_id caches the item_id passed to function get_client_code
11: g_item_id NUMBER;
12: --g_client_code caches the ct code of g_item_id.
13: g_client_code mtl_client_parameters.client_code%TYPE;
14:
15:
16: /* function returns the deployment mode based on the profile WMS_DEPLOYMENT_MODE
17: * 'I' - Integrated Deployment

Line 232: l_client_code mtl_client_parameters.client_code%TYPE := NULL;

228: ( p_item_id NUMBER)
229: RETURN VARCHAR2
230: as
231: l_delimiter VARCHAR2(1);
232: l_client_code mtl_client_parameters.client_code%TYPE := NULL;
233: l_item_name mtl_system_items_b_kfv.concatenated_segments%TYPE;
234: begin
235: IF wms_deployment_mode = 'L' THEN
236: IF g_item_id = p_item_id THEN

Line 290: x_client_id IN OUT NOCOPY MTL_CLIENT_PARAMETERS.CLIENT_ID%TYPE

286:
287:
288: PROCEDURE get_client_details
289: (
290: x_client_id IN OUT NOCOPY MTL_CLIENT_PARAMETERS.CLIENT_ID%TYPE
291: , x_client_code IN OUT NOCOPY MTL_CLIENT_PARAMETERS.CLIENT_CODE%TYPE
292: , x_client_name OUT NOCOPY HZ_PARTIES.PARTY_NAME%TYPE
293: , x_return_status OUT NOCOPY VARCHAR2
294: )as

Line 291: , x_client_code IN OUT NOCOPY MTL_CLIENT_PARAMETERS.CLIENT_CODE%TYPE

287:
288: PROCEDURE get_client_details
289: (
290: x_client_id IN OUT NOCOPY MTL_CLIENT_PARAMETERS.CLIENT_ID%TYPE
291: , x_client_code IN OUT NOCOPY MTL_CLIENT_PARAMETERS.CLIENT_CODE%TYPE
292: , x_client_name OUT NOCOPY HZ_PARTIES.PARTY_NAME%TYPE
293: , x_return_status OUT NOCOPY VARCHAR2
294: )as
295:

Line 306: FROM mtl_client_parameters

302: THEN
303: BEGIN
304: SELECT client_id , client_code
305: INTO x_client_id , x_client_code
306: FROM mtl_client_parameters
307: WHERE client_id = x_client_id;
308: END;
309: ELSIF x_client_code <> FND_API.G_MISS_CHAR
310: THEN

Line 314: FROM mtl_client_parameters

310: THEN
311: BEGIN
312: SELECT client_id , client_code
313: INTO x_client_id , x_client_code
314: FROM mtl_client_parameters
315: WHERE client_code = x_client_code;
316: END;
317: ELSE
318: RAISE fnd_api.g_exc_error;

Line 367: l_client_id mtl_client_parameters.client_id%TYPE;

363: END get_client_item;
364:
365: FUNCTION get_item_client_name( p_item_id NUMBER)
366: RETURN VARCHAR2 AS
367: l_client_id mtl_client_parameters.client_id%TYPE;
368: l_client_code mtl_client_parameters.client_code%TYPE;
369: l_client_name varchar2(360);
370: l_return_status VARCHAR2(1);
371: BEGIN

Line 368: l_client_code mtl_client_parameters.client_code%TYPE;

364:
365: FUNCTION get_item_client_name( p_item_id NUMBER)
366: RETURN VARCHAR2 AS
367: l_client_id mtl_client_parameters.client_id%TYPE;
368: l_client_code mtl_client_parameters.client_code%TYPE;
369: l_client_name varchar2(360);
370: l_return_status VARCHAR2(1);
371: BEGIN
372: IF wms_deployment_mode='L' THEN

Line 402: l_client_code mtl_client_parameters.client_code%TYPE := NULL;

398:
399: FUNCTION get_po_client_code(p_po_header_id NUMBER)
400: RETURN VARCHAR2 AS
401: l_po_name po_headers_all.segment1%TYPE;
402: l_client_code mtl_client_parameters.client_code%TYPE := NULL;
403: l_delimiter VARCHAR2(1) := '-' ;
404: l_item_name VARCHAR2(800);
405: BEGIN
406: BEGIN

Line 436: l_client_id mtl_client_parameters.client_id%TYPE;

432:
433:
434: FUNCTION get_po_client_name(p_po_header_id number)
435: RETURN VARCHAR2 AS
436: l_client_id mtl_client_parameters.client_id%TYPE;
437: l_client_code mtl_client_parameters.client_code%TYPE;
438: l_client_name VARCHAR2(360):='';
439: l_return_status VARCHAR2(1);
440: BEGIN

Line 437: l_client_code mtl_client_parameters.client_code%TYPE;

433:
434: FUNCTION get_po_client_name(p_po_header_id number)
435: RETURN VARCHAR2 AS
436: l_client_id mtl_client_parameters.client_id%TYPE;
437: l_client_code mtl_client_parameters.client_code%TYPE;
438: l_client_name VARCHAR2(360):='';
439: l_return_status VARCHAR2(1);
440: BEGIN
441: IF wms_deployment_mode='L' THEN

Line 531: l_client_code mtl_client_parameters.client_code%TYPE;

527:
528: FUNCTION get_po_number (p_segment1 VARCHAR2) RETURN NUMBER
529: IS
530: l_delimiter VARCHAR2(1);
531: l_client_code mtl_client_parameters.client_code%TYPE;
532: l_po_number NUMBER;
533: BEGIN
534: IF wms_deployment_mode = 'L' THEN
535: