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.CSI_DIAGNOSTICS_PKG dependencies on FND_GLOBAL

Line 1427: l_user_id NUMBER := fnd_global.user_id;

1423: --
1424: l_owner_src_table VARCHAR2(30);
1425: l_owner_party NUMBER;
1426: l_owner_account NUMBER;
1427: l_user_id NUMBER := fnd_global.user_id;
1428: l_txn_id NUMBER;
1429: v_txn_type_id NUMBER;
1430: l_char_ins_id VARCHAR2(50);
1431: --

Line 4119: last_update_login = fnd_global.login_id,

4115:
4116: UPDATE csi_txn_errors
4117: SET processed_flag = 'D',
4118: error_text = 'Transaction prior to freeze_date in install parameter',
4119: last_update_login = fnd_global.login_id,
4120: last_update_date = sysdate,
4121: last_updated_by = fnd_global.user_id
4122: WHERE transaction_error_id = l_txn_error_id_tab(ind);
4123:

Line 4121: last_updated_by = fnd_global.user_id

4117: SET processed_flag = 'D',
4118: error_text = 'Transaction prior to freeze_date in install parameter',
4119: last_update_login = fnd_global.login_id,
4120: last_update_date = sysdate,
4121: last_updated_by = fnd_global.user_id
4122: WHERE transaction_error_id = l_txn_error_id_tab(ind);
4123:
4124: RAISE skip_error;
4125: END IF;

Line 4513: last_update_login = fnd_global.login_id,

4509: UPDATE csi_txn_errors
4510: SET processed_flag = 'D',
4511: error_text = 'Serial control is now inappropriate for this txn. Knocking this',
4512: last_update_date = sysdate,
4513: last_update_login = fnd_global.login_id,
4514: last_updated_by = fnd_global.user_id
4515: WHERE inv_material_transaction_id = l_mtl_txn_id_tab(ind)
4516: AND processed_flag in ('E', 'R');
4517:

Line 4514: last_updated_by = fnd_global.user_id

4510: SET processed_flag = 'D',
4511: error_text = 'Serial control is now inappropriate for this txn. Knocking this',
4512: last_update_date = sysdate,
4513: last_update_login = fnd_global.login_id,
4514: last_updated_by = fnd_global.user_id
4515: WHERE inv_material_transaction_id = l_mtl_txn_id_tab(ind)
4516: AND processed_flag in ('E', 'R');
4517:
4518: DELETE FROM csi_diagnostics_temp

Line 6025: last_update_login = fnd_global.login_id,

6021: UPDATE csi_txn_errors
6022: SET processed_flag = 'D',
6023: error_text = 'A future transaction is processed. So not processing this.',
6024: last_update_date = sysdate,
6025: last_update_login = fnd_global.login_id,
6026: last_updated_by = fnd_global.user_id
6027: WHERE inv_material_transaction_id = knock_rec.mtl_txn_id
6028: AND processed_flag in ('E', 'R');
6029:

Line 6026: last_updated_by = fnd_global.user_id

6022: SET processed_flag = 'D',
6023: error_text = 'A future transaction is processed. So not processing this.',
6024: last_update_date = sysdate,
6025: last_update_login = fnd_global.login_id,
6026: last_updated_by = fnd_global.user_id
6027: WHERE inv_material_transaction_id = knock_rec.mtl_txn_id
6028: AND processed_flag in ('E', 'R');
6029:
6030: BEGIN

Line 6750: last_update_login = fnd_global.login_id,

6746:
6747: UPDATE csi_txn_errors
6748: SET processed_flag = 'R',
6749: last_update_date = sysdate,
6750: last_update_login = fnd_global.login_id,
6751: last_updated_by = fnd_global.user_id
6752: WHERE inv_material_transaction_id = txn_rec.mtl_txn_id
6753: AND processed_flag = 'E';
6754:

Line 6751: last_updated_by = fnd_global.user_id

6747: UPDATE csi_txn_errors
6748: SET processed_flag = 'R',
6749: last_update_date = sysdate,
6750: last_update_login = fnd_global.login_id,
6751: last_updated_by = fnd_global.user_id
6752: WHERE inv_material_transaction_id = txn_rec.mtl_txn_id
6753: AND processed_flag = 'E';
6754:
6755: EXCEPTION

Line 8606: last_update_login = fnd_global.login_id,

8602:
8603: UPDATE csi_txn_errors
8604: SET processed_flag = 'R',
8605: last_update_date = sysdate,
8606: last_update_login = fnd_global.login_id,
8607: last_updated_by = fnd_global.user_id
8608: WHERE inv_material_transaction_id = p_diag_txn_rec.mtl_txn_id
8609: AND processed_flag = 'E';
8610: ELSE

Line 8607: last_updated_by = fnd_global.user_id

8603: UPDATE csi_txn_errors
8604: SET processed_flag = 'R',
8605: last_update_date = sysdate,
8606: last_update_login = fnd_global.login_id,
8607: last_updated_by = fnd_global.user_id
8608: WHERE inv_material_transaction_id = p_diag_txn_rec.mtl_txn_id
8609: AND processed_flag = 'E';
8610: ELSE
8611: UPDATE csi_diagnostics_temp

Line 8689: last_update_login = fnd_global.login_id,

8685: LOOP
8686: update csi_txn_errors
8687: SET processed_flag = 'R',
8688: last_update_date = sysdate,
8689: last_update_login = fnd_global.login_id,
8690: last_updated_by = fnd_global.user_id
8691: WHERE inv_material_transaction_id = reprocess_rec.mtl_txn_id
8692: AND processed_flag = 'E';
8693: END LOOP;

Line 8690: last_updated_by = fnd_global.user_id

8686: update csi_txn_errors
8687: SET processed_flag = 'R',
8688: last_update_date = sysdate,
8689: last_update_login = fnd_global.login_id,
8690: last_updated_by = fnd_global.user_id
8691: WHERE inv_material_transaction_id = reprocess_rec.mtl_txn_id
8692: AND processed_flag = 'E';
8693: END LOOP;
8694:

Line 9827: ,last_updated_by = fnd_global.user_id

9823:
9824: update csi_item_instances_h
9825: set old_serial_number = i.serial_number
9826: ,new_serial_number = new_serial_number||'-DUP'||to_char(v_duplicate_count)
9827: ,last_updated_by = fnd_global.user_id
9828: ,last_update_date = sysdate
9829: ,old_instance_status_id = j.instance_status_id
9830: ,new_instance_status_id = v_instance_status_id
9831: where instance_history_id = (select max(instance_history_id)

Line 9839: ,last_updated_by = fnd_global.user_id

9835: update csi_item_instances
9836: set serial_number = serial_number||'-DUP'||to_char(v_duplicate_count)
9837: ,active_end_date = sysdate
9838: ,instance_status_id = v_instance_status_id
9839: ,last_updated_by = fnd_global.user_id
9840: ,last_update_date = sysdate
9841: where instance_id = j.instance_id;
9842: end if;
9843: end loop;

Line 10384: ,last_updated_by = fnd_global.user_id

10380: set external_reference = serial_number
10381: , serial_number = to_char(j.instance_id)||'-DUP'||to_char(v_duplicate_count)
10382: ,active_end_date = sysdate
10383: ,instance_status_id = v_instance_status_id
10384: ,last_updated_by = fnd_global.user_id
10385: ,last_update_date = sysdate
10386: where instance_id = j.instance_id;
10387: --
10388: if v_txn_id is null then

Line 10394: ,last_updated_by = fnd_global.user_id

10390: set instance_id = v_instance_id
10391: ,new_external_reference = i.serial_number
10392: ,old_serial_number = nvl(new_serial_number,i.serial_number)
10393: ,new_serial_number = to_char(j.instance_id)||'-DUP'||to_char(v_duplicate_count)
10394: ,last_updated_by = fnd_global.user_id
10395: ,last_update_date = sysdate
10396: where instance_id = j.instance_id;
10397: else -- common txn found
10398: update csi_item_instances_h

Line 10402: ,last_updated_by = fnd_global.user_id

10398: update csi_item_instances_h
10399: set new_external_reference = i.serial_number
10400: ,old_serial_number = nvl(new_serial_number,i.serial_number)
10401: ,new_serial_number = to_char(j.instance_id)||'-DUP'||to_char(v_duplicate_count)
10402: ,last_updated_by = fnd_global.user_id
10403: ,last_update_date = sysdate
10404: where instance_history_id = (select max(instance_history_id)
10405: from csi_item_instances_h
10406: where instance_id = j.instance_id

Line 10704: l_user_id NUMBER := FND_GLOBAL.user_id;

10700: x_msg_data VARCHAR2(2000);
10701: x_msg_count NUMBER;
10702: x_return_status VARCHAR2(1);
10703: l_txn_id NUMBER;
10704: l_user_id NUMBER := FND_GLOBAL.user_id;
10705: l_ins_flag VARCHAR2(1) := 'N';
10706: v_txn_type_id NUMBER;
10707: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
10708: --

Line 11266: v_user_id NUMBER := fnd_global.user_id;

11262: v_commit_count NUMBER := 0;
11263: v_err_msg VARCHAR2(2000);
11264: v_txn_type_id NUMBER;
11265: v_txn_id NUMBER;
11266: v_user_id NUMBER := fnd_global.user_id;
11267: l_nl VARCHAR2(1);
11268: l_item_id NUMBER;
11269: l_org_id NUMBER;
11270: l_organization_id NUMBER;

Line 11715: v_user_id NUMBER := fnd_global.user_id;

11711: v_err_msg VARCHAR2(2000);
11712: v_txn_type_id NUMBER;
11713: v_srl_txn_id NUMBER;
11714: v_lot_txn_id NUMBER;
11715: v_user_id NUMBER := fnd_global.user_id;
11716: v_srl_ctl NUMBER;
11717: v_lot_ctl NUMBER;
11718: --
11719: TYPE NUMLIST IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 12190: v_created_by NUMBER := fnd_global.user_id;

12186: v_mfg_srl_flag VARCHAR2(1);
12187: v_ins_status_id NUMBER;
12188: v_instance_id NUMBER;
12189: v_ins_history_id NUMBER;
12190: v_created_by NUMBER := fnd_global.user_id;
12191: v_last_updated_by NUMBER := fnd_global.user_id;
12192: v_ins_ou_id NUMBER;
12193: v_ins_ou_history_id NUMBER;
12194: v_ins_party_id NUMBER;

Line 12191: v_last_updated_by NUMBER := fnd_global.user_id;

12187: v_ins_status_id NUMBER;
12188: v_instance_id NUMBER;
12189: v_ins_history_id NUMBER;
12190: v_created_by NUMBER := fnd_global.user_id;
12191: v_last_updated_by NUMBER := fnd_global.user_id;
12192: v_ins_ou_id NUMBER;
12193: v_ins_ou_history_id NUMBER;
12194: v_ins_party_id NUMBER;
12195: v_ins_party_history_id NUMBER;

Line 13611: v_created_by NUMBER := fnd_global.user_id;

13607: v_ins_status_id NUMBER;
13608: v_instance_id NUMBER;
13609: v_end_date DATE;
13610: v_ins_history_id NUMBER;
13611: v_created_by NUMBER := fnd_global.user_id;
13612: v_last_updated_by NUMBER := fnd_global.user_id;
13613: v_ins_ou_id NUMBER;
13614: v_ins_ou_history_id NUMBER;
13615: v_ins_party_id NUMBER;

Line 13612: v_last_updated_by NUMBER := fnd_global.user_id;

13608: v_instance_id NUMBER;
13609: v_end_date DATE;
13610: v_ins_history_id NUMBER;
13611: v_created_by NUMBER := fnd_global.user_id;
13612: v_last_updated_by NUMBER := fnd_global.user_id;
13613: v_ins_ou_id NUMBER;
13614: v_ins_ou_history_id NUMBER;
13615: v_ins_party_id NUMBER;
13616: v_ins_party_history_id NUMBER;

Line 14418: l_user_id number := fnd_global.user_id;

14414: mat_txn_id NumTabType;
14415: --
14416: max_buffer_size number := 1000;
14417: --
14418: l_user_id number := fnd_global.user_id;
14419: v_srl_ctl number;
14420: v_txn_type_id number;
14421: v_lot_ctl number;
14422: l_ctr number := 0;

Line 14556: l_user_id NUMBER := fnd_global.user_id;

14552: and nvl(msi.comms_nl_trackable_flag,'N') = 'Y';
14553: --
14554: v_qty NUMBER;
14555: l_txn_id NUMBER;
14556: l_user_id NUMBER := fnd_global.user_id;
14557: l_error_count NUMBER;
14558: l_ins_flag VARCHAR2(1) := 'N';
14559: v_txn_type_id NUMBER;
14560: v_err_msg VARCHAR2(2000);