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 202: l_mohdr_rec.created_by := nvl(fnd_global.user_id,1);

198:
199: -- initialize move order header record type
200: l_mohdr_rec.header_id := nvl(px_header_id, FND_API.G_MISS_NUM);
201: l_mohdr_rec.request_number := nvl(p_request_number, FND_API.G_MISS_CHAR);
202: l_mohdr_rec.created_by := nvl(fnd_global.user_id,1);
203: l_mohdr_rec.creation_date := sysdate;
204: l_mohdr_rec.date_required := p_date_required;
205: l_mohdr_rec.from_subinventory_code:= p_from_subinventory_code;
206: l_mohdr_rec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;

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

203: l_mohdr_rec.creation_date := sysdate;
204: l_mohdr_rec.date_required := p_date_required;
205: l_mohdr_rec.from_subinventory_code:= p_from_subinventory_code;
206: l_mohdr_rec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
207: l_mohdr_rec.last_updated_by := nvl(fnd_global.user_id,1);
208: l_mohdr_rec.last_update_date := sysdate;
209: l_mohdr_rec.last_update_login := nvl(fnd_global.login_id,-1);
210: l_mohdr_rec.organization_id := p_organization_id;
211: l_mohdr_rec.status_date := sysdate;

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

205: l_mohdr_rec.from_subinventory_code:= p_from_subinventory_code;
206: l_mohdr_rec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
207: l_mohdr_rec.last_updated_by := nvl(fnd_global.user_id,1);
208: l_mohdr_rec.last_update_date := sysdate;
209: l_mohdr_rec.last_update_login := nvl(fnd_global.login_id,-1);
210: l_mohdr_rec.organization_id := p_organization_id;
211: l_mohdr_rec.status_date := sysdate;
212: l_mohdr_rec.to_subinventory_code := p_to_subinventory_code;
213: l_mohdr_rec.transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;

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

240: ,P_Commit => l_commit
241: ,p_validation_level => null
242: ,p_action_code => 0 -- 0 = insert, 1 = update, 2 = delete
243: ,p_header_id => l_mohdr_rec.header_id
244: ,p_created_by => nvl(fnd_global.user_id,1)
245: ,p_creation_date => sysdate
246: ,p_last_updated_by => nvl(fnd_global.user_id,1)
247: ,p_last_update_date => sysdate
248: ,p_last_update_login => nvl(fnd_global.login_id,-1)

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

242: ,p_action_code => 0 -- 0 = insert, 1 = update, 2 = delete
243: ,p_header_id => l_mohdr_rec.header_id
244: ,p_created_by => nvl(fnd_global.user_id,1)
245: ,p_creation_date => sysdate
246: ,p_last_updated_by => nvl(fnd_global.user_id,1)
247: ,p_last_update_date => sysdate
248: ,p_last_update_login => nvl(fnd_global.login_id,-1)
249: ,p_carrier => p_freight_carrier
250: ,p_shipment_method => p_shipment_method

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

244: ,p_created_by => nvl(fnd_global.user_id,1)
245: ,p_creation_date => sysdate
246: ,p_last_updated_by => nvl(fnd_global.user_id,1)
247: ,p_last_update_date => sysdate
248: ,p_last_update_login => nvl(fnd_global.login_id,-1)
249: ,p_carrier => p_freight_carrier
250: ,p_shipment_method => p_shipment_method
251: ,p_autoreceipt_flag => p_autoreceipt_flag
252: ,p_attribute_category => null

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

449: where header_id = p_header_id;
450:
451: l_line_num := l_line_num + 1;
452: l_trolin_tbl(l_order_count).header_id := p_header_id;
453: l_trolin_tbl(l_order_count).created_by := nvl(FND_GLOBAL.USER_ID,1);
454: l_trolin_tbl(l_order_count).creation_date := sysdate;
455: l_trolin_tbl(l_order_count).date_required := p_date_required;
456: l_trolin_tbl(l_order_count).from_subinventory_code:= p_from_subinventory_code;
457: l_trolin_tbl(l_order_count).from_locator_id := p_from_locator_id;

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

459: l_trolin_tbl(l_order_count).revision := p_revision;
460: l_trolin_tbl(l_order_count).lot_number := p_lot_number;
461: l_trolin_tbl(l_order_count).serial_number_start := p_serial_number_start;
462: l_trolin_tbl(l_order_count).serial_number_end := p_serial_number_end;
463: l_trolin_tbl(l_order_count).last_updated_by := nvl(FND_GLOBAL.USER_ID,1);
464: l_trolin_tbl(l_order_count).last_update_date := sysdate;
465: l_trolin_tbl(l_order_count).last_update_login := nvl(FND_GLOBAL.LOGIN_ID, -1);
466: l_trolin_tbl(l_order_count).line_id := nvl(px_line_id,FND_API.G_MISS_NUM);
467: l_trolin_tbl(l_order_count).line_number := l_line_num;

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

461: l_trolin_tbl(l_order_count).serial_number_start := p_serial_number_start;
462: l_trolin_tbl(l_order_count).serial_number_end := p_serial_number_end;
463: l_trolin_tbl(l_order_count).last_updated_by := nvl(FND_GLOBAL.USER_ID,1);
464: l_trolin_tbl(l_order_count).last_update_date := sysdate;
465: l_trolin_tbl(l_order_count).last_update_login := nvl(FND_GLOBAL.LOGIN_ID, -1);
466: l_trolin_tbl(l_order_count).line_id := nvl(px_line_id,FND_API.G_MISS_NUM);
467: l_trolin_tbl(l_order_count).line_number := l_line_num;
468: l_trolin_tbl(l_order_count).line_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
469: l_trolin_tbl(l_order_count).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;

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

504: ,P_Commit => l_commit
505: ,p_validation_level => null
506: ,p_action_code => 0
507: ,P_line_id => l_trolin_tbl(l_order_count).line_id
508: ,p_CREATED_BY => nvl(fnd_global.user_id,1)
509: ,p_CREATION_DATE => sysdate
510: ,p_LAST_UPDATED_BY => nvl(fnd_global.user_id,1)
511: ,p_LAST_UPDATE_DATE => sysdate
512: ,p_LAST_UPDATED_LOGIN => nvl(fnd_global.login_id,-1)

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

506: ,p_action_code => 0
507: ,P_line_id => l_trolin_tbl(l_order_count).line_id
508: ,p_CREATED_BY => nvl(fnd_global.user_id,1)
509: ,p_CREATION_DATE => sysdate
510: ,p_LAST_UPDATED_BY => nvl(fnd_global.user_id,1)
511: ,p_LAST_UPDATE_DATE => sysdate
512: ,p_LAST_UPDATED_LOGIN => nvl(fnd_global.login_id,-1)
513: ,p_HEADER_ID => p_header_id
514: ,p_CUSTOMER_PO => p_customer_po

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

508: ,p_CREATED_BY => nvl(fnd_global.user_id,1)
509: ,p_CREATION_DATE => sysdate
510: ,p_LAST_UPDATED_BY => nvl(fnd_global.user_id,1)
511: ,p_LAST_UPDATE_DATE => sysdate
512: ,p_LAST_UPDATED_LOGIN => nvl(fnd_global.login_id,-1)
513: ,p_HEADER_ID => p_header_id
514: ,p_CUSTOMER_PO => p_customer_po
515: ,p_INCIDENT_ID => p_service_request
516: ,p_TASK_ID => p_task_id

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

1025: , p_transfer_to_subinventory
1026: , p_transfer_to_locator
1027: , p_transfer_to_organization
1028: , sysdate --last_update_date
1029: , nvl(fnd_global.user_id,1) --last_updated_by
1030: , sysdate --creation_date
1031: , nvl(fnd_global.user_id,1) --created_by
1032: , nvl(fnd_global.login_id,-1)
1033: , 2

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

1027: , p_transfer_to_organization
1028: , sysdate --last_update_date
1029: , nvl(fnd_global.user_id,1) --last_updated_by
1030: , sysdate --creation_date
1031: , nvl(fnd_global.user_id,1) --created_by
1032: , nvl(fnd_global.login_id,-1)
1033: , 2
1034: , decode(sign(p_transaction_source_id-1000000000000),-1,
1035: p_transaction_source_id,null)

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

1028: , sysdate --last_update_date
1029: , nvl(fnd_global.user_id,1) --last_updated_by
1030: , sysdate --creation_date
1031: , nvl(fnd_global.user_id,1) --created_by
1032: , nvl(fnd_global.login_id,-1)
1033: , 2
1034: , decode(sign(p_transaction_source_id-1000000000000),-1,
1035: p_transaction_source_id,null)
1036: , decode(sign(greatest(p_transaction_source_id,p_trx_source_line_id)

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

1113: , p_lot_expiration_date
1114: , p_quantity
1115: , l_transaction_interface_id -- We will only have 1 serial number at a time
1116: , sysdate
1117: , nvl(fnd_global.user_id,-1)
1118: , sysdate
1119: , nvl(fnd_global.user_id,-1)
1120: , nvl(fnd_global.login_id,-1)
1121: );

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

1115: , l_transaction_interface_id -- We will only have 1 serial number at a time
1116: , sysdate
1117: , nvl(fnd_global.user_id,-1)
1118: , sysdate
1119: , nvl(fnd_global.user_id,-1)
1120: , nvl(fnd_global.login_id,-1)
1121: );
1122: END IF;
1123:

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

1116: , sysdate
1117: , nvl(fnd_global.user_id,-1)
1118: , sysdate
1119: , nvl(fnd_global.user_id,-1)
1120: , nvl(fnd_global.login_id,-1)
1121: );
1122: END IF;
1123:
1124: IF p_serial_number IS NOT NULL THEN

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

1135: ( l_transaction_interface_id
1136: , p_serial_number
1137: , nvl(p_to_serial_number, p_serial_number)
1138: , sysdate --last_update_date
1139: , nvl(fnd_global.user_id,1) --last_updated_by
1140: , sysdate --creation_date
1141: , nvl(fnd_global.user_id,1) --created_by
1142: , nvl(fnd_global.login_id,-1) --last_update_login
1143: );

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

1137: , nvl(p_to_serial_number, p_serial_number)
1138: , sysdate --last_update_date
1139: , nvl(fnd_global.user_id,1) --last_updated_by
1140: , sysdate --creation_date
1141: , nvl(fnd_global.user_id,1) --created_by
1142: , nvl(fnd_global.login_id,-1) --last_update_login
1143: );
1144: END IF;
1145:

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

1138: , sysdate --last_update_date
1139: , nvl(fnd_global.user_id,1) --last_updated_by
1140: , sysdate --creation_date
1141: , nvl(fnd_global.user_id,1) --created_by
1142: , nvl(fnd_global.login_id,-1) --last_update_login
1143: );
1144: END IF;
1145:
1146: /*l_transaction_header_id := 2034265;*/

Line 1156: l_prev_resp_id := fnd_global.resp_id;

1152:
1153: IF (p_online_process_flag) THEN
1154:
1155: --check to see if we need to do intiialization of responsibility
1156: l_prev_resp_id := fnd_global.resp_id;
1157:
1158: IF (l_prev_resp_id IS NULL OR l_prev_resp_id = -1) THEN
1159: l_prev_resp_appl_id := fnd_global.resp_appl_id;
1160: l_prev_user_id := fnd_global.user_id;

Line 1159: l_prev_resp_appl_id := fnd_global.resp_appl_id;

1155: --check to see if we need to do intiialization of responsibility
1156: l_prev_resp_id := fnd_global.resp_id;
1157:
1158: IF (l_prev_resp_id IS NULL OR l_prev_resp_id = -1) THEN
1159: l_prev_resp_appl_id := fnd_global.resp_appl_id;
1160: l_prev_user_id := fnd_global.user_id;
1161: l_resp_set_flag := TRUE;
1162:
1163: OPEN l_resp_csr;

Line 1160: l_prev_user_id := fnd_global.user_id;

1156: l_prev_resp_id := fnd_global.resp_id;
1157:
1158: IF (l_prev_resp_id IS NULL OR l_prev_resp_id = -1) THEN
1159: l_prev_resp_appl_id := fnd_global.resp_appl_id;
1160: l_prev_user_id := fnd_global.user_id;
1161: l_resp_set_flag := TRUE;
1162:
1163: OPEN l_resp_csr;
1164: FETCH l_resp_csr into l_resp_appl_id, l_resp_id;

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

1163: OPEN l_resp_csr;
1164: FETCH l_resp_csr into l_resp_appl_id, l_resp_id;
1165: CLOSE l_resp_csr;
1166:
1167: fnd_global.apps_initialize(user_id => nvl(fnd_global.user_id, -1),
1168: resp_id => l_resp_id,
1169: resp_appl_id => l_resp_appl_id
1170: );
1171: END IF;

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

1218: );
1219: */
1220:
1221: IF (l_resp_set_flag) THEN
1222: fnd_global.apps_initialize(user_id => l_prev_user_id,
1223: resp_id => l_prev_resp_id,
1224: resp_appl_id => l_prev_resp_appl_id);
1225: END IF;
1226: