DBA Data[Home] [Help]

APPS.WMS_DEVICE_INTEGRATION_PVT dependencies on FND_GLOBAL

Line 99: FND_GLOBAL.USER_ID);

95: l_uom,
96: l_lpn_id,
97: l_qty,
98: Sysdate,
99: FND_GLOBAL.USER_ID);
100:
101: x_return_status := 'S';
102:
103: EXCEPTION

Line 236: FND_GLOBAL.USER_ID);

232: l_uom,
233: l_lpn_id,
234: l_qty,
235: Sysdate,
236: FND_GLOBAL.USER_ID);
237:
238:
239: x_return_status := 'S';
240:

Line 352: FND_GLOBAL.USER_ID);

348: p_uom,
349: p_lpn_id,
350: p_qty,
351: Sysdate,
352: FND_GLOBAL.USER_ID);
353:
354: x_return_status := 'S';
355:
356: EXCEPTION

Line 469: FND_GLOBAL.USER_ID);

465: p_lpn_id,
466: p_device_id,
467: p_qty,
468: Sysdate,
469: FND_GLOBAL.USER_ID);
470:
471: x_return_status := 'S';
472:
473: EXCEPTION

Line 624: trace(wdrrec.organization_id ||','||wdrrec.subinventory_code||','||FND_GLOBAL.USER_ID||',' || p_autoenable || ',' || wdrrec.business_event_id || ',' || p_parent_request_id);

620:
621: BEGIN
622: IF (l_debug = 1) THEN
623: trace('in select device, org, sub, user, autoenable, bus, parent req:');
624: trace(wdrrec.organization_id ||','||wdrrec.subinventory_code||','||FND_GLOBAL.USER_ID||',' || p_autoenable || ',' || wdrrec.business_event_id || ',' || p_parent_request_id);
625: END IF;
626: -- Try to get the device id from history if the
627: -- event id is task complete and the parent request id is not null
628: IF wdrrec.business_event_id in (wms_be_task_complete, wms_be_task_skip, wms_be_task_cancel) AND

Line 672: DEVICE_LEVEL_USER,FND_GLOBAL.USER_ID,level_value)

668: and wbed.ENABLED_FLAG = 'Y'
669: AND decode(level_type,DEVICE_LEVEL_SUB,wbed.subinventory_code,level_value) =
670: decode(level_type,DEVICE_LEVEL_SUB,wdrrec.transfer_sub_code,DEVICE_LEVEL_ORG,
671: wdrrec.organization_id,DEVICE_LEVEL_LOCATOR,wdrrec.transfer_loc_id,
672: DEVICE_LEVEL_USER,FND_GLOBAL.USER_ID,level_value)
673: AND Nvl(wbed.organization_id,-1) = Nvl(wdrrec.organization_id,Nvl(wbed.organization_id,-1))
674: AND wbed.AUTO_ENABLED_FLAG = decode(p_autoenable,'Y','Y',wbed.AUTO_ENABLED_FLAG)
675: AND wbed.business_event_id = wdrrec.business_event_id
676: ORDER BY level_type desc)

Line 693: AND CREATED_BY = FND_GLOBAL.USER_ID;

689: SELECT device_id
690: INTO l_dev_id
691: FROM wms_device_assignment_temp
692: WHERE device_id = dev_id
693: AND CREATED_BY = FND_GLOBAL.USER_ID;
694: EXCEPTION
695: WHEN NO_DATA_FOUND THEN
696: dev_id :=0;
697: END;

Line 736: DEVICE_LEVEL_USER,FND_GLOBAL.USER_ID,level_value)

732: and wbed.ENABLED_FLAG = 'Y'
733: AND decode(level_type,DEVICE_LEVEL_SUB,wbed.subinventory_code,level_value) =
734: decode(level_type,DEVICE_LEVEL_SUB,wdrrec.subinventory_code,DEVICE_LEVEL_ORG,
735: wdrrec.organization_id,DEVICE_LEVEL_LOCATOR,wdrrec.locator_id,
736: DEVICE_LEVEL_USER,FND_GLOBAL.USER_ID,level_value)
737: AND Nvl(wbed.organization_id,-1) = Nvl(wdrrec.organization_id,Nvl(wbed.organization_id,-1))
738: AND wbed.AUTO_ENABLED_FLAG = decode(p_autoenable,'Y','Y',wbed.AUTO_ENABLED_FLAG)
739: AND wbed.business_event_id = wdrrec.business_event_id
740: ORDER BY level_type desc)

Line 757: AND CREATED_BY = FND_GLOBAL.USER_ID;

753: SELECT device_id
754: INTO l_dev_id
755: FROM wms_device_assignment_temp
756: WHERE device_id = dev_id
757: AND CREATED_BY = FND_GLOBAL.USER_ID;
758: EXCEPTION
759: WHEN NO_DATA_FOUND THEN
760: dev_id :=0;
761: END;

Line 874: l_line := substr(l_xmlstr, 1, instr(l_xmlstr, fnd_global.local_chr(10))-1);

870: l_file := utl_file.fopen(rtrim(p_file_dir,'/'), p_file_name, 'w');
871: l_xmlstr := dbms_lob.substr(p_xml, 32767);
872: loop
873: exit when l_xmlstr is null;
874: l_line := substr(l_xmlstr, 1, instr(l_xmlstr, fnd_global.local_chr(10))-1);
875: utl_file.put_line(l_file, l_line);
876: l_xmlstr := substr(l_xmlstr, instr(l_xmlstr, fnd_global.local_chr(10))+1);
877: end loop;
878: utl_file.fclose(l_file);

Line 876: l_xmlstr := substr(l_xmlstr, instr(l_xmlstr, fnd_global.local_chr(10))+1);

872: loop
873: exit when l_xmlstr is null;
874: l_line := substr(l_xmlstr, 1, instr(l_xmlstr, fnd_global.local_chr(10))-1);
875: utl_file.put_line(l_file, l_line);
876: l_xmlstr := substr(l_xmlstr, instr(l_xmlstr, fnd_global.local_chr(10))+1);
877: end loop;
878: utl_file.fclose(l_file);
879: EXCEPTION
880: WHEN utl_file.invalid_path THEN

Line 1328: FND_GLOBAL.RESP_APPL_ID,

1324: l_rec.outfile_name,
1325: l_rec.last_update_date,
1326: NULL,
1327: l_rec.last_updated_by,
1328: FND_GLOBAL.RESP_APPL_ID,
1329: FND_GLOBAL.RESP_ID,
1330: null,
1331: null,
1332: null,

Line 1329: FND_GLOBAL.RESP_ID,

1325: l_rec.last_update_date,
1326: NULL,
1327: l_rec.last_updated_by,
1328: FND_GLOBAL.RESP_APPL_ID,
1329: FND_GLOBAL.RESP_ID,
1330: null,
1331: null,
1332: null,
1333: null,

Line 2812: FND_GLOBAL.user_id,

2808: organization_id)
2809: VALUES (
2810: mtl_material_transactions_s.NEXTVAL,
2811: Sysdate,
2812: FND_GLOBAL.user_id,
2813: fnd_global.user_id,
2814: Sysdate,
2815: FND_GLOBAL.user_id,
2816: p_purge_date,

Line 2813: fnd_global.user_id,

2809: VALUES (
2810: mtl_material_transactions_s.NEXTVAL,
2811: Sysdate,
2812: FND_GLOBAL.user_id,
2813: fnd_global.user_id,
2814: Sysdate,
2815: FND_GLOBAL.user_id,
2816: p_purge_date,
2817: NULL,

Line 2815: FND_GLOBAL.user_id,

2811: Sysdate,
2812: FND_GLOBAL.user_id,
2813: fnd_global.user_id,
2814: Sysdate,
2815: FND_GLOBAL.user_id,
2816: p_purge_date,
2817: NULL,
2818: p_purge_name,
2819: p_orgid );