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 243: FND_GLOBAL.USER_ID);

239: l_lpn_id,
240: l_xfr_lpn_id, --Added for Bug#8512121
241: l_qty,
242: Sysdate,
243: FND_GLOBAL.USER_ID);
244:
245:
246: x_return_status := 'S';
247:

Line 372: FND_GLOBAL.USER_ID);

368: p_lpn_id,
369: p_xfer_lpn_id, --Added for Bug#8778050
370: p_qty,
371: Sysdate,
372: FND_GLOBAL.USER_ID);
373:
374: x_return_status := 'S';
375:
376: EXCEPTION

Line 489: FND_GLOBAL.USER_ID);

485: p_lpn_id,
486: p_device_id,
487: p_qty,
488: Sysdate,
489: FND_GLOBAL.USER_ID);
490:
491: x_return_status := 'S';
492:
493: EXCEPTION

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

640:
641: BEGIN
642: IF (l_debug = 1) THEN
643: trace('in select device, org, sub, user, autoenable, bus, parent req:');
644: trace(wdrrec.organization_id ||','||wdrrec.subinventory_code||','||FND_GLOBAL.USER_ID||',' || p_autoenable || ',' || wdrrec.business_event_id || ',' || p_parent_request_id);
645: END IF;
646: -- Try to get the device id from history if the
647: -- event id is task complete and the parent request id is not null
648: IF wdrrec.business_event_id in (wms_be_task_complete, wms_be_task_skip, wms_be_task_cancel) AND

Line 692: DEVICE_LEVEL_USER,FND_GLOBAL.USER_ID,level_value)

688: and wbed.ENABLED_FLAG = 'Y'
689: AND decode(level_type,DEVICE_LEVEL_SUB,wbed.subinventory_code,level_value) =
690: decode(level_type,DEVICE_LEVEL_SUB,wdrrec.transfer_sub_code,DEVICE_LEVEL_ORG,
691: wdrrec.organization_id,DEVICE_LEVEL_LOCATOR,wdrrec.transfer_loc_id,
692: DEVICE_LEVEL_USER,FND_GLOBAL.USER_ID,level_value)
693: AND Nvl(wbed.organization_id,-1) = Nvl(wdrrec.organization_id,Nvl(wbed.organization_id,-1))
694: AND wbed.AUTO_ENABLED_FLAG = decode(p_autoenable,'Y','Y',wbed.AUTO_ENABLED_FLAG)
695: AND wbed.business_event_id = wdrrec.business_event_id
696: ORDER BY level_type desc)

Line 713: AND CREATED_BY = FND_GLOBAL.USER_ID;

709: SELECT device_id
710: INTO l_dev_id
711: FROM wms_device_assignment_temp
712: WHERE device_id = dev_id
713: AND CREATED_BY = FND_GLOBAL.USER_ID;
714: EXCEPTION
715: WHEN NO_DATA_FOUND THEN
716: dev_id :=0;
717: END;

Line 756: DEVICE_LEVEL_USER,FND_GLOBAL.USER_ID,level_value)

752: and wbed.ENABLED_FLAG = 'Y'
753: AND decode(level_type,DEVICE_LEVEL_SUB,wbed.subinventory_code,level_value) =
754: decode(level_type,DEVICE_LEVEL_SUB,wdrrec.subinventory_code,DEVICE_LEVEL_ORG,
755: wdrrec.organization_id,DEVICE_LEVEL_LOCATOR,wdrrec.locator_id,
756: DEVICE_LEVEL_USER,FND_GLOBAL.USER_ID,level_value)
757: AND Nvl(wbed.organization_id,-1) = Nvl(wdrrec.organization_id,Nvl(wbed.organization_id,-1))
758: AND wbed.AUTO_ENABLED_FLAG = decode(p_autoenable,'Y','Y',wbed.AUTO_ENABLED_FLAG)
759: AND wbed.business_event_id = wdrrec.business_event_id
760: ORDER BY level_type desc)

Line 777: AND CREATED_BY = FND_GLOBAL.USER_ID;

773: SELECT device_id
774: INTO l_dev_id
775: FROM wms_device_assignment_temp
776: WHERE device_id = dev_id
777: AND CREATED_BY = FND_GLOBAL.USER_ID;
778: EXCEPTION
779: WHEN NO_DATA_FOUND THEN
780: dev_id :=0;
781: END;

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

890: l_file := utl_file.fopen(rtrim(p_file_dir,'/'), p_file_name, 'w');
891: l_xmlstr := dbms_lob.substr(p_xml, 32767);
892: loop
893: exit when l_xmlstr is null;
894: l_line := substr(l_xmlstr, 1, instr(l_xmlstr, fnd_global.local_chr(10))-1);
895: utl_file.put_line(l_file, l_line);
896: l_xmlstr := substr(l_xmlstr, instr(l_xmlstr, fnd_global.local_chr(10))+1);
897: end loop;
898: utl_file.fclose(l_file);

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

892: loop
893: exit when l_xmlstr is null;
894: l_line := substr(l_xmlstr, 1, instr(l_xmlstr, fnd_global.local_chr(10))-1);
895: utl_file.put_line(l_file, l_line);
896: l_xmlstr := substr(l_xmlstr, instr(l_xmlstr, fnd_global.local_chr(10))+1);
897: end loop;
898: utl_file.fclose(l_file);
899: EXCEPTION
900: WHEN utl_file.invalid_path THEN

Line 1352: FND_GLOBAL.RESP_APPL_ID,

1348: l_rec.outfile_name,
1349: l_rec.last_update_date,
1350: NULL,
1351: l_rec.last_updated_by,
1352: FND_GLOBAL.RESP_APPL_ID,
1353: FND_GLOBAL.RESP_ID,
1354: null,
1355: null,
1356: null,

Line 1353: FND_GLOBAL.RESP_ID,

1349: l_rec.last_update_date,
1350: NULL,
1351: l_rec.last_updated_by,
1352: FND_GLOBAL.RESP_APPL_ID,
1353: FND_GLOBAL.RESP_ID,
1354: null,
1355: null,
1356: null,
1357: null,

Line 2899: FND_GLOBAL.user_id,

2895: organization_id)
2896: VALUES (
2897: mtl_material_transactions_s.NEXTVAL,
2898: Sysdate,
2899: FND_GLOBAL.user_id,
2900: fnd_global.user_id,
2901: Sysdate,
2902: FND_GLOBAL.user_id,
2903: p_purge_date,

Line 2900: fnd_global.user_id,

2896: VALUES (
2897: mtl_material_transactions_s.NEXTVAL,
2898: Sysdate,
2899: FND_GLOBAL.user_id,
2900: fnd_global.user_id,
2901: Sysdate,
2902: FND_GLOBAL.user_id,
2903: p_purge_date,
2904: NULL,

Line 2902: FND_GLOBAL.user_id,

2898: Sysdate,
2899: FND_GLOBAL.user_id,
2900: fnd_global.user_id,
2901: Sysdate,
2902: FND_GLOBAL.user_id,
2903: p_purge_date,
2904: NULL,
2905: p_purge_name,
2906: p_orgid );