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_TRANSACTIONS_PUB dependencies on FND_GLOBAL

Line 257: l_mohdr_rec.created_by := nvl(fnd_global.user_id,1);

253:
254: -- initialize move order header record type
255: l_mohdr_rec.header_id := nvl(px_header_id, FND_API.G_MISS_NUM);
256: l_mohdr_rec.request_number := nvl(p_request_number, FND_API.G_MISS_CHAR);
257: l_mohdr_rec.created_by := nvl(fnd_global.user_id,1);
258: l_mohdr_rec.creation_date := sysdate;
259: l_mohdr_rec.date_required := p_date_required;
260: l_mohdr_rec.from_subinventory_code:= p_from_subinventory_code;
261: l_mohdr_rec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;

Line 262: l_mohdr_rec.last_updated_by := nvl(fnd_global.user_id,1);

258: l_mohdr_rec.creation_date := sysdate;
259: l_mohdr_rec.date_required := p_date_required;
260: l_mohdr_rec.from_subinventory_code:= p_from_subinventory_code;
261: l_mohdr_rec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
262: l_mohdr_rec.last_updated_by := nvl(fnd_global.user_id,1);
263: l_mohdr_rec.last_update_date := sysdate;
264: l_mohdr_rec.last_update_login := nvl(fnd_global.login_id,-1);
265: l_mohdr_rec.organization_id := p_organization_id;
266: l_mohdr_rec.status_date := sysdate;

Line 264: l_mohdr_rec.last_update_login := nvl(fnd_global.login_id,-1);

260: l_mohdr_rec.from_subinventory_code:= p_from_subinventory_code;
261: l_mohdr_rec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
262: l_mohdr_rec.last_updated_by := nvl(fnd_global.user_id,1);
263: l_mohdr_rec.last_update_date := sysdate;
264: l_mohdr_rec.last_update_login := nvl(fnd_global.login_id,-1);
265: l_mohdr_rec.organization_id := p_organization_id;
266: l_mohdr_rec.status_date := sysdate;
267: l_mohdr_rec.to_subinventory_code := p_to_subinventory_code;
268: l_mohdr_rec.transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;

Line 299: ,p_created_by => nvl(fnd_global.user_id,1)

295: ,P_Commit => l_commit
296: ,p_validation_level => null
297: ,p_action_code => 0 -- 0 = insert, 1 = update, 2 = delete
298: ,p_header_id => l_mohdr_rec.header_id
299: ,p_created_by => nvl(fnd_global.user_id,1)
300: ,p_creation_date => sysdate
301: ,p_last_updated_by => nvl(fnd_global.user_id,1)
302: ,p_last_update_date => sysdate
303: ,p_last_update_login => nvl(fnd_global.login_id,-1)

Line 301: ,p_last_updated_by => nvl(fnd_global.user_id,1)

297: ,p_action_code => 0 -- 0 = insert, 1 = update, 2 = delete
298: ,p_header_id => l_mohdr_rec.header_id
299: ,p_created_by => nvl(fnd_global.user_id,1)
300: ,p_creation_date => sysdate
301: ,p_last_updated_by => nvl(fnd_global.user_id,1)
302: ,p_last_update_date => sysdate
303: ,p_last_update_login => nvl(fnd_global.login_id,-1)
304: ,p_carrier => p_freight_carrier
305: ,p_shipment_method => p_shipment_method

Line 303: ,p_last_update_login => nvl(fnd_global.login_id,-1)

299: ,p_created_by => nvl(fnd_global.user_id,1)
300: ,p_creation_date => sysdate
301: ,p_last_updated_by => nvl(fnd_global.user_id,1)
302: ,p_last_update_date => sysdate
303: ,p_last_update_login => nvl(fnd_global.login_id,-1)
304: ,p_carrier => p_freight_carrier
305: ,p_shipment_method => p_shipment_method
306: ,p_autoreceipt_flag => p_autoreceipt_flag
307: ,p_attribute_category => null

Line 508: l_trolin_tbl(l_order_count).created_by := nvl(FND_GLOBAL.USER_ID,1);

504: where header_id = p_header_id;
505:
506: l_line_num := l_line_num + 1;
507: l_trolin_tbl(l_order_count).header_id := p_header_id;
508: l_trolin_tbl(l_order_count).created_by := nvl(FND_GLOBAL.USER_ID,1);
509: l_trolin_tbl(l_order_count).creation_date := sysdate;
510: l_trolin_tbl(l_order_count).date_required := p_date_required;
511: l_trolin_tbl(l_order_count).from_subinventory_code:= p_from_subinventory_code;
512: l_trolin_tbl(l_order_count).from_locator_id := p_from_locator_id;

Line 518: l_trolin_tbl(l_order_count).last_updated_by := nvl(FND_GLOBAL.USER_ID,1);

514: l_trolin_tbl(l_order_count).revision := p_revision;
515: l_trolin_tbl(l_order_count).lot_number := p_lot_number;
516: l_trolin_tbl(l_order_count).serial_number_start := p_serial_number_start;
517: l_trolin_tbl(l_order_count).serial_number_end := p_serial_number_end;
518: l_trolin_tbl(l_order_count).last_updated_by := nvl(FND_GLOBAL.USER_ID,1);
519: l_trolin_tbl(l_order_count).last_update_date := sysdate;
520: l_trolin_tbl(l_order_count).last_update_login := nvl(FND_GLOBAL.LOGIN_ID, -1);
521: l_trolin_tbl(l_order_count).line_id := nvl(px_line_id,FND_API.G_MISS_NUM);
522: l_trolin_tbl(l_order_count).line_number := l_line_num;

Line 520: l_trolin_tbl(l_order_count).last_update_login := nvl(FND_GLOBAL.LOGIN_ID, -1);

516: l_trolin_tbl(l_order_count).serial_number_start := p_serial_number_start;
517: l_trolin_tbl(l_order_count).serial_number_end := p_serial_number_end;
518: l_trolin_tbl(l_order_count).last_updated_by := nvl(FND_GLOBAL.USER_ID,1);
519: l_trolin_tbl(l_order_count).last_update_date := sysdate;
520: l_trolin_tbl(l_order_count).last_update_login := nvl(FND_GLOBAL.LOGIN_ID, -1);
521: l_trolin_tbl(l_order_count).line_id := nvl(px_line_id,FND_API.G_MISS_NUM);
522: l_trolin_tbl(l_order_count).line_number := l_line_num;
523: l_trolin_tbl(l_order_count).line_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
524: l_trolin_tbl(l_order_count).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;

Line 563: ,p_CREATED_BY => nvl(fnd_global.user_id,1)

559: ,P_Commit => l_commit
560: ,p_validation_level => null
561: ,p_action_code => 0
562: ,P_line_id => l_trolin_tbl(l_order_count).line_id
563: ,p_CREATED_BY => nvl(fnd_global.user_id,1)
564: ,p_CREATION_DATE => sysdate
565: ,p_LAST_UPDATED_BY => nvl(fnd_global.user_id,1)
566: ,p_LAST_UPDATE_DATE => sysdate
567: ,p_LAST_UPDATED_LOGIN => nvl(fnd_global.login_id,-1)

Line 565: ,p_LAST_UPDATED_BY => nvl(fnd_global.user_id,1)

561: ,p_action_code => 0
562: ,P_line_id => l_trolin_tbl(l_order_count).line_id
563: ,p_CREATED_BY => nvl(fnd_global.user_id,1)
564: ,p_CREATION_DATE => sysdate
565: ,p_LAST_UPDATED_BY => nvl(fnd_global.user_id,1)
566: ,p_LAST_UPDATE_DATE => sysdate
567: ,p_LAST_UPDATED_LOGIN => nvl(fnd_global.login_id,-1)
568: ,p_HEADER_ID => p_header_id
569: ,p_CUSTOMER_PO => p_customer_po

Line 567: ,p_LAST_UPDATED_LOGIN => nvl(fnd_global.login_id,-1)

563: ,p_CREATED_BY => nvl(fnd_global.user_id,1)
564: ,p_CREATION_DATE => sysdate
565: ,p_LAST_UPDATED_BY => nvl(fnd_global.user_id,1)
566: ,p_LAST_UPDATE_DATE => sysdate
567: ,p_LAST_UPDATED_LOGIN => nvl(fnd_global.login_id,-1)
568: ,p_HEADER_ID => p_header_id
569: ,p_CUSTOMER_PO => p_customer_po
570: ,p_INCIDENT_ID => p_service_request
571: ,p_TASK_ID => p_task_id

Line 1154: , nvl(fnd_global.user_id,1) --last_updated_by

1150: , p_transfer_to_subinventory
1151: , p_transfer_to_locator
1152: , p_transfer_to_organization
1153: , sysdate --last_update_date
1154: , nvl(fnd_global.user_id,1) --last_updated_by
1155: , sysdate --creation_date
1156: , nvl(fnd_global.user_id,1) --created_by
1157: , nvl(fnd_global.login_id,-1)
1158: , 2

Line 1156: , nvl(fnd_global.user_id,1) --created_by

1152: , p_transfer_to_organization
1153: , sysdate --last_update_date
1154: , nvl(fnd_global.user_id,1) --last_updated_by
1155: , sysdate --creation_date
1156: , nvl(fnd_global.user_id,1) --created_by
1157: , nvl(fnd_global.login_id,-1)
1158: , 2
1159: , decode(sign(p_transaction_source_id-1000000000000),-1,
1160: p_transaction_source_id,null)

Line 1157: , nvl(fnd_global.login_id,-1)

1153: , sysdate --last_update_date
1154: , nvl(fnd_global.user_id,1) --last_updated_by
1155: , sysdate --creation_date
1156: , nvl(fnd_global.user_id,1) --created_by
1157: , nvl(fnd_global.login_id,-1)
1158: , 2
1159: , decode(sign(p_transaction_source_id-1000000000000),-1,
1160: p_transaction_source_id,null)
1161: , decode(sign(greatest(p_transaction_source_id,p_trx_source_line_id)

Line 1242: , nvl(fnd_global.user_id,-1)

1238: , p_lot_expiration_date
1239: , p_quantity
1240: , l_transaction_interface_id -- We will only have 1 serial number at a time
1241: , sysdate
1242: , nvl(fnd_global.user_id,-1)
1243: , sysdate
1244: , nvl(fnd_global.user_id,-1)
1245: , nvl(fnd_global.login_id,-1)
1246: );

Line 1244: , nvl(fnd_global.user_id,-1)

1240: , l_transaction_interface_id -- We will only have 1 serial number at a time
1241: , sysdate
1242: , nvl(fnd_global.user_id,-1)
1243: , sysdate
1244: , nvl(fnd_global.user_id,-1)
1245: , nvl(fnd_global.login_id,-1)
1246: );
1247: END IF;
1248:

Line 1245: , nvl(fnd_global.login_id,-1)

1241: , sysdate
1242: , nvl(fnd_global.user_id,-1)
1243: , sysdate
1244: , nvl(fnd_global.user_id,-1)
1245: , nvl(fnd_global.login_id,-1)
1246: );
1247: END IF;
1248:
1249: IF p_serial_number IS NOT NULL THEN

Line 1264: , nvl(fnd_global.user_id,1) --last_updated_by

1260: ( l_transaction_interface_id
1261: , p_serial_number
1262: , nvl(p_to_serial_number, p_serial_number)
1263: , sysdate --last_update_date
1264: , nvl(fnd_global.user_id,1) --last_updated_by
1265: , sysdate --creation_date
1266: , nvl(fnd_global.user_id,1) --created_by
1267: , nvl(fnd_global.login_id,-1) --last_update_login
1268: );

Line 1266: , nvl(fnd_global.user_id,1) --created_by

1262: , nvl(p_to_serial_number, p_serial_number)
1263: , sysdate --last_update_date
1264: , nvl(fnd_global.user_id,1) --last_updated_by
1265: , sysdate --creation_date
1266: , nvl(fnd_global.user_id,1) --created_by
1267: , nvl(fnd_global.login_id,-1) --last_update_login
1268: );
1269: END IF;
1270:

Line 1267: , nvl(fnd_global.login_id,-1) --last_update_login

1263: , sysdate --last_update_date
1264: , nvl(fnd_global.user_id,1) --last_updated_by
1265: , sysdate --creation_date
1266: , nvl(fnd_global.user_id,1) --created_by
1267: , nvl(fnd_global.login_id,-1) --last_update_login
1268: );
1269: END IF;
1270:
1271: /*l_transaction_header_id := 2034265;*/

Line 1281: l_prev_resp_id := fnd_global.resp_id;

1277:
1278: IF (p_online_process_flag) THEN
1279:
1280: --check to see if we need to do intiialization of responsibility
1281: l_prev_resp_id := fnd_global.resp_id;
1282:
1283: IF (l_prev_resp_id IS NULL OR l_prev_resp_id = -1) THEN
1284: l_prev_resp_appl_id := fnd_global.resp_appl_id;
1285: l_prev_user_id := fnd_global.user_id;

Line 1284: l_prev_resp_appl_id := fnd_global.resp_appl_id;

1280: --check to see if we need to do intiialization of responsibility
1281: l_prev_resp_id := fnd_global.resp_id;
1282:
1283: IF (l_prev_resp_id IS NULL OR l_prev_resp_id = -1) THEN
1284: l_prev_resp_appl_id := fnd_global.resp_appl_id;
1285: l_prev_user_id := fnd_global.user_id;
1286: l_resp_set_flag := TRUE;
1287:
1288: OPEN l_resp_csr;

Line 1285: l_prev_user_id := fnd_global.user_id;

1281: l_prev_resp_id := fnd_global.resp_id;
1282:
1283: IF (l_prev_resp_id IS NULL OR l_prev_resp_id = -1) THEN
1284: l_prev_resp_appl_id := fnd_global.resp_appl_id;
1285: l_prev_user_id := fnd_global.user_id;
1286: l_resp_set_flag := TRUE;
1287:
1288: OPEN l_resp_csr;
1289: FETCH l_resp_csr into l_resp_appl_id, l_resp_id;

Line 1292: fnd_global.apps_initialize(user_id => nvl(fnd_global.user_id, -1),

1288: OPEN l_resp_csr;
1289: FETCH l_resp_csr into l_resp_appl_id, l_resp_id;
1290: CLOSE l_resp_csr;
1291:
1292: fnd_global.apps_initialize(user_id => nvl(fnd_global.user_id, -1),
1293: resp_id => l_resp_id,
1294: resp_appl_id => l_resp_appl_id
1295: );
1296: END IF;

Line 1347: fnd_global.apps_initialize(user_id => l_prev_user_id,

1343: );
1344: */
1345:
1346: IF (l_resp_set_flag) THEN
1347: fnd_global.apps_initialize(user_id => l_prev_user_id,
1348: resp_id => l_prev_resp_id,
1349: resp_appl_id => l_prev_resp_appl_id);
1350: END IF;
1351:

Line 2774: p_CREATED_BY => FND_GLOBAL.user_id,

2770: end if;
2771:
2772: csp_req_line_details_pkg.Update_Row(px_REQ_LINE_DETAIL_ID => l_req_line_detail_id,
2773: p_REQUIREMENT_LINE_ID => l_requirement_line_id,
2774: p_CREATED_BY => FND_GLOBAL.user_id,
2775: p_CREATION_DATE => sysdate,
2776: p_LAST_UPDATED_BY => FND_GLOBAL.user_id,
2777: p_LAST_UPDATE_DATE => sysdate,
2778: p_LAST_UPDATE_LOGIN => FND_GLOBAL.user_id,

Line 2776: p_LAST_UPDATED_BY => FND_GLOBAL.user_id,

2772: csp_req_line_details_pkg.Update_Row(px_REQ_LINE_DETAIL_ID => l_req_line_detail_id,
2773: p_REQUIREMENT_LINE_ID => l_requirement_line_id,
2774: p_CREATED_BY => FND_GLOBAL.user_id,
2775: p_CREATION_DATE => sysdate,
2776: p_LAST_UPDATED_BY => FND_GLOBAL.user_id,
2777: p_LAST_UPDATE_DATE => sysdate,
2778: p_LAST_UPDATE_LOGIN => FND_GLOBAL.user_id,
2779: p_SOURCE_TYPE => 'RES',
2780: p_SOURCE_ID => l_new_reservation_id);

Line 2778: p_LAST_UPDATE_LOGIN => FND_GLOBAL.user_id,

2774: p_CREATED_BY => FND_GLOBAL.user_id,
2775: p_CREATION_DATE => sysdate,
2776: p_LAST_UPDATED_BY => FND_GLOBAL.user_id,
2777: p_LAST_UPDATE_DATE => sysdate,
2778: p_LAST_UPDATE_LOGIN => FND_GLOBAL.user_id,
2779: p_SOURCE_TYPE => 'RES',
2780: p_SOURCE_ID => l_new_reservation_id);
2781: else
2782:

Line 2792: p_CREATED_BY => FND_GLOBAL.user_id,

2788:
2789: csp_req_line_details_pkg.Insert_Row(
2790: px_REQ_LINE_DETAIL_ID => l_req_line_detail_id,
2791: p_REQUIREMENT_LINE_ID => l_requirement_line_id,
2792: p_CREATED_BY => FND_GLOBAL.user_id,
2793: p_CREATION_DATE => sysdate,
2794: p_LAST_UPDATED_BY => FND_GLOBAL.user_id,
2795: p_LAST_UPDATE_DATE => sysdate,
2796: p_LAST_UPDATE_LOGIN => FND_GLOBAL.user_id,

Line 2794: p_LAST_UPDATED_BY => FND_GLOBAL.user_id,

2790: px_REQ_LINE_DETAIL_ID => l_req_line_detail_id,
2791: p_REQUIREMENT_LINE_ID => l_requirement_line_id,
2792: p_CREATED_BY => FND_GLOBAL.user_id,
2793: p_CREATION_DATE => sysdate,
2794: p_LAST_UPDATED_BY => FND_GLOBAL.user_id,
2795: p_LAST_UPDATE_DATE => sysdate,
2796: p_LAST_UPDATE_LOGIN => FND_GLOBAL.user_id,
2797: p_SOURCE_TYPE => 'RES',
2798: p_SOURCE_ID => l_new_reservation_id);

Line 2796: p_LAST_UPDATE_LOGIN => FND_GLOBAL.user_id,

2792: p_CREATED_BY => FND_GLOBAL.user_id,
2793: p_CREATION_DATE => sysdate,
2794: p_LAST_UPDATED_BY => FND_GLOBAL.user_id,
2795: p_LAST_UPDATE_DATE => sysdate,
2796: p_LAST_UPDATE_LOGIN => FND_GLOBAL.user_id,
2797: p_SOURCE_TYPE => 'RES',
2798: p_SOURCE_ID => l_new_reservation_id);
2799: end if;
2800: commit;

Line 3049: p_CREATED_BY => FND_GLOBAL.user_id,

3045:
3046: l_req_line_detail_id := null;
3047: csp_req_line_details_pkg.Insert_Row(px_REQ_LINE_DETAIL_ID => l_req_line_detail_id,
3048: p_REQUIREMENT_LINE_ID => l_requirement_line_id,
3049: p_CREATED_BY => FND_GLOBAL.user_id,
3050: p_CREATION_DATE => sysdate,
3051: p_LAST_UPDATED_BY => FND_GLOBAL.user_id,
3052: p_LAST_UPDATE_DATE => sysdate,
3053: p_LAST_UPDATE_LOGIN => FND_GLOBAL.user_id,

Line 3051: p_LAST_UPDATED_BY => FND_GLOBAL.user_id,

3047: csp_req_line_details_pkg.Insert_Row(px_REQ_LINE_DETAIL_ID => l_req_line_detail_id,
3048: p_REQUIREMENT_LINE_ID => l_requirement_line_id,
3049: p_CREATED_BY => FND_GLOBAL.user_id,
3050: p_CREATION_DATE => sysdate,
3051: p_LAST_UPDATED_BY => FND_GLOBAL.user_id,
3052: p_LAST_UPDATE_DATE => sysdate,
3053: p_LAST_UPDATE_LOGIN => FND_GLOBAL.user_id,
3054: p_SOURCE_TYPE => 'RES',
3055: p_SOURCE_ID => l_new_reservation_id);

Line 3053: p_LAST_UPDATE_LOGIN => FND_GLOBAL.user_id,

3049: p_CREATED_BY => FND_GLOBAL.user_id,
3050: p_CREATION_DATE => sysdate,
3051: p_LAST_UPDATED_BY => FND_GLOBAL.user_id,
3052: p_LAST_UPDATE_DATE => sysdate,
3053: p_LAST_UPDATE_LOGIN => FND_GLOBAL.user_id,
3054: p_SOURCE_TYPE => 'RES',
3055: p_SOURCE_ID => l_new_reservation_id);
3056: else
3057: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 3077: p_CREATED_BY => FND_GLOBAL.user_id,

3073: l_req_line_detail_id := null;
3074: csp_req_line_details_pkg.Insert_Row(
3075: px_REQ_LINE_DETAIL_ID => l_req_line_detail_id,
3076: p_REQUIREMENT_LINE_ID => l_requirement_line_id,
3077: p_CREATED_BY => FND_GLOBAL.user_id,
3078: p_CREATION_DATE => sysdate,
3079: p_LAST_UPDATED_BY => FND_GLOBAL.user_id,
3080: p_LAST_UPDATE_DATE => sysdate,
3081: p_LAST_UPDATE_LOGIN => FND_GLOBAL.user_id,

Line 3079: p_LAST_UPDATED_BY => FND_GLOBAL.user_id,

3075: px_REQ_LINE_DETAIL_ID => l_req_line_detail_id,
3076: p_REQUIREMENT_LINE_ID => l_requirement_line_id,
3077: p_CREATED_BY => FND_GLOBAL.user_id,
3078: p_CREATION_DATE => sysdate,
3079: p_LAST_UPDATED_BY => FND_GLOBAL.user_id,
3080: p_LAST_UPDATE_DATE => sysdate,
3081: p_LAST_UPDATE_LOGIN => FND_GLOBAL.user_id,
3082: p_SOURCE_TYPE => 'RES',
3083: p_SOURCE_ID => l_new_reservation_id);

Line 3081: p_LAST_UPDATE_LOGIN => FND_GLOBAL.user_id,

3077: p_CREATED_BY => FND_GLOBAL.user_id,
3078: p_CREATION_DATE => sysdate,
3079: p_LAST_UPDATED_BY => FND_GLOBAL.user_id,
3080: p_LAST_UPDATE_DATE => sysdate,
3081: p_LAST_UPDATE_LOGIN => FND_GLOBAL.user_id,
3082: p_SOURCE_TYPE => 'RES',
3083: p_SOURCE_ID => l_new_reservation_id);
3084: end if;
3085:

Line 3336: ,p_created_by => FND_GLOBAL.user_id

3332:
3333: if l_res_exists = 0 then
3334: csp_req_line_details_pkg.insert_row(px_req_line_detail_id => l_req_line_detali_id
3335: ,p_requirement_line_id => grd.requirement_line_id
3336: ,p_created_by => FND_GLOBAL.user_id
3337: ,p_creation_date => sysdate
3338: ,p_last_updated_by => FND_GLOBAL.user_id
3339: ,p_last_update_date => sysdate
3340: ,p_last_update_login => FND_GLOBAL.login_id

Line 3338: ,p_last_updated_by => FND_GLOBAL.user_id

3334: csp_req_line_details_pkg.insert_row(px_req_line_detail_id => l_req_line_detali_id
3335: ,p_requirement_line_id => grd.requirement_line_id
3336: ,p_created_by => FND_GLOBAL.user_id
3337: ,p_creation_date => sysdate
3338: ,p_last_updated_by => FND_GLOBAL.user_id
3339: ,p_last_update_date => sysdate
3340: ,p_last_update_login => FND_GLOBAL.login_id
3341: ,p_source_type => 'RES'
3342: ,p_source_id => l_reservation_id );

Line 3340: ,p_last_update_login => FND_GLOBAL.login_id

3336: ,p_created_by => FND_GLOBAL.user_id
3337: ,p_creation_date => sysdate
3338: ,p_last_updated_by => FND_GLOBAL.user_id
3339: ,p_last_update_date => sysdate
3340: ,p_last_update_login => FND_GLOBAL.login_id
3341: ,p_source_type => 'RES'
3342: ,p_source_id => l_reservation_id );
3343: end if;
3344: