DBA Data[Home] [Help]

APPS.WMS_CARTNZN_PUB dependencies on FND_GLOBAL

Line 2232: fnd_global.user_id,

2228: wms_cartnzn_pub.g_wms_pack_hist_seq,
2229: pack_level,
2230: l_item_id,
2231: Sysdate,
2232: fnd_global.user_id,
2233: Sysdate,
2234: fnd_global.user_id,
2235: fnd_global.login_id,
2236: l_rev,

Line 2234: fnd_global.user_id,

2230: l_item_id,
2231: Sysdate,
2232: fnd_global.user_id,
2233: Sysdate,
2234: fnd_global.user_id,
2235: fnd_global.login_id,
2236: l_rev,
2237: lot_table(counter),
2238: serial_table(counter),

Line 2235: fnd_global.login_id,

2231: Sysdate,
2232: fnd_global.user_id,
2233: Sysdate,
2234: fnd_global.user_id,
2235: fnd_global.login_id,
2236: l_rev,
2237: lot_table(counter),
2238: serial_table(counter),
2239: serial_table(counter),

Line 2309: fnd_global.user_id,

2305: wms_cartnzn_pub.g_wms_pack_hist_seq,
2306: pack_level,
2307: NULL,
2308: Sysdate,
2309: fnd_global.user_id,
2310: Sysdate,
2311: fnd_global.user_id,
2312: fnd_global.login_id,
2313: null,

Line 2311: fnd_global.user_id,

2307: NULL,
2308: Sysdate,
2309: fnd_global.user_id,
2310: Sysdate,
2311: fnd_global.user_id,
2312: fnd_global.login_id,
2313: null,
2314: null,
2315: null,

Line 2312: fnd_global.login_id,

2308: Sysdate,
2309: fnd_global.user_id,
2310: Sysdate,
2311: fnd_global.user_id,
2312: fnd_global.login_id,
2313: null,
2314: null,
2315: null,
2316: NULL,

Line 2387: fnd_global.user_id,

2383: wms_cartnzn_pub.g_wms_pack_hist_seq,
2384: pack_level,
2385: l_cont_item_id,
2386: Sysdate,
2387: fnd_global.user_id,
2388: Sysdate,
2389: fnd_global.user_id,
2390: fnd_global.login_id,
2391: null,

Line 2389: fnd_global.user_id,

2385: l_cont_item_id,
2386: Sysdate,
2387: fnd_global.user_id,
2388: Sysdate,
2389: fnd_global.user_id,
2390: fnd_global.login_id,
2391: null,
2392: null,
2393: null,

Line 2390: fnd_global.login_id,

2386: Sysdate,
2387: fnd_global.user_id,
2388: Sysdate,
2389: fnd_global.user_id,
2390: fnd_global.login_id,
2391: null,
2392: null,
2393: null,
2394: NULL,

Line 5074: last_updated_by = fnd_global.user_id

5070: cartonization_id = l_LPN,
5071: container_item_id = p_container_item_id,
5072: parent_line_id = par_line_id,
5073: last_update_date = Sysdate,
5074: last_updated_by = fnd_global.user_id
5075: WHERE
5076: transaction_temp_id = p_transaction_temp_id;
5077: ELSE
5078: UPDATE mtl_material_transactions_temp SET

Line 5083: last_updated_by = fnd_global.user_id

5079: cartonization_id = l_LPN,
5080: container_item_id = p_container_item_id,
5081: parent_line_id = par_line_id,
5082: last_update_date = Sysdate,
5083: last_updated_by = fnd_global.user_id
5084: WHERE
5085: transaction_temp_id = p_transaction_temp_id;
5086: END IF;
5087:

Line 5114: last_updated_by = fnd_global.user_id

5110: cartonization_id = l_LPN,
5111: parent_line_id = par_line_id,
5112: container_item_id = p_container_item_id,
5113: last_update_date = Sysdate,
5114: last_updated_by = fnd_global.user_id
5115: WHERE
5116: transaction_temp_id = p_transaction_temp_id;
5117: ELSE
5118: UPDATE wms_cartonization_temp SET

Line 5123: last_updated_by = fnd_global.user_id

5119: cartonization_id = l_LPN,
5120: parent_line_id = par_line_id,
5121: container_item_id = p_container_item_id,
5122: last_update_date = Sysdate,
5123: last_updated_by = fnd_global.user_id
5124: WHERE
5125: transaction_temp_id = p_transaction_temp_id;
5126: END IF;
5127:

Line 5159: last_updated_by = fnd_global.user_id

5155: UPDATE wms_cartonization_temp SET
5156: primary_quantity = primary_quantity - NVL(p_primary_quantity,0),
5157: transaction_quantity = transaction_quantity - NVL(p_transaction_quantity,0),
5158: last_update_date = Sysdate,
5159: last_updated_by = fnd_global.user_id
5160: WHERE
5161: transaction_temp_id = p_transaction_temp_id;
5162:
5163:

Line 5238: v1.last_updated_by := fnd_global.user_id;

5234: v1.secondary_transaction_quantity := p_secondary_quantity; --invconv kkillams
5235: v1.cartonization_id := l_LPN;
5236: v1.container_item_id := p_container_item_id;
5237: v1.last_update_date := Sysdate;
5238: v1.last_updated_by := fnd_global.user_id;
5239: v1.creation_date := Sysdate;
5240: v1.created_by := fnd_global.user_id;
5241:
5242:

Line 5240: v1.created_by := fnd_global.user_id;

5236: v1.container_item_id := p_container_item_id;
5237: v1.last_update_date := Sysdate;
5238: v1.last_updated_by := fnd_global.user_id;
5239: v1.creation_date := Sysdate;
5240: v1.created_by := fnd_global.user_id;
5241:
5242:
5243: IF p_new_txn_hdr_id IS NOT NULL THEN
5244: v1.transaction_header_id := p_new_txn_hdr_id;

Line 5493: FND_GLOBAL.USER_ID);

5489: p_mmtt_row.allocated_lpn_id,
5490: p_mmtt_row.cartonization_id,
5491: p_mmtt_row.transaction_quantity,
5492: Sysdate,
5493: FND_GLOBAL.USER_ID);
5494:
5495:
5496: --insert another line for drop
5497: INSERT INTO wms_device_requests (request_id,

Line 5535: FND_GLOBAL.USER_ID);

5531: p_mmtt_row.allocated_lpn_id,
5532: p_mmtt_row.cartonization_id,
5533: p_mmtt_row.transaction_quantity,
5534: Sysdate,
5535: FND_GLOBAL.USER_ID);
5536:
5537: wdrdata.request_id := WMS_Device_Integration_PVT.wms_pkrel_dev_req_id;
5538: wdrData.organization_id := p_mmtt_row.organization_id;
5539: wdrData.subinventory_code := p_mmtt_row.subinventory_code ;