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

Line 848: p_user_id => FND_GLOBAL.user_id,

844: p_wip_entity_id => p_workorder_rec.wip_entity_id,
845: p_transaction_type => 1,
846: p_transaction_date => SYSDATE,
847: p_instance_id => p_workorder_rec.item_instance_id,
848: p_user_id => FND_GLOBAL.user_id,
849: p_request_id => NULL,
850: p_application_id => NULL,
851: p_program_id => NULL,
852: p_reconciliation_code => NULL,

Line 926: FND_GLOBAL.user_id,

922: ) VALUES (
923: l_workorder_txn_id,
924: 1,
925: SYSDATE,
926: FND_GLOBAL.user_id,
927: SYSDATE,
928: FND_GLOBAL.user_id,
929: FND_GLOBAL.login_id,
930: p_workorder_rec.workorder_id,

Line 928: FND_GLOBAL.user_id,

924: 1,
925: SYSDATE,
926: FND_GLOBAL.user_id,
927: SYSDATE,
928: FND_GLOBAL.user_id,
929: FND_GLOBAL.login_id,
930: p_workorder_rec.workorder_id,
931: p_transaction_type_code,
932: p_workorder_rec.status_code,

Line 929: FND_GLOBAL.login_id,

925: SYSDATE,
926: FND_GLOBAL.user_id,
927: SYSDATE,
928: FND_GLOBAL.user_id,
929: FND_GLOBAL.login_id,
930: p_workorder_rec.workorder_id,
931: p_transaction_type_code,
932: p_workorder_rec.status_code,
933: p_workorder_rec.actual_start_date,

Line 974: last_updated_by = FND_GLOBAL.user_id,

970: UPDATE AHL_WORKORDERS
971: SET status_code = p_status_code,
972: object_version_number = object_version_number + 1,
973: last_update_date = SYSDATE,
974: last_updated_by = FND_GLOBAL.user_id,
975: last_update_login = FND_GLOBAL.login_id
976: WHERE workorder_id = p_workorder_rec.workorder_id
977: AND object_version_number = p_workorder_rec.object_version_number;
978:

Line 975: last_update_login = FND_GLOBAL.login_id

971: SET status_code = p_status_code,
972: object_version_number = object_version_number + 1,
973: last_update_date = SYSDATE,
974: last_updated_by = FND_GLOBAL.user_id,
975: last_update_login = FND_GLOBAL.login_id
976: WHERE workorder_id = p_workorder_rec.workorder_id
977: AND object_version_number = p_workorder_rec.object_version_number;
978:
979: IF ( SQL%ROWCOUNT = 0 ) THEN

Line 1382: FND_GLOBAL.user_id,

1378: ) VALUES (
1379: l_wo_operation_txn_id,
1380: 1,
1381: SYSDATE,
1382: FND_GLOBAL.user_id,
1383: SYSDATE,
1384: FND_GLOBAL.user_id,
1385: FND_GLOBAL.login_id,
1386: p_operation_rec.workorder_operation_id,

Line 1384: FND_GLOBAL.user_id,

1380: 1,
1381: SYSDATE,
1382: FND_GLOBAL.user_id,
1383: SYSDATE,
1384: FND_GLOBAL.user_id,
1385: FND_GLOBAL.login_id,
1386: p_operation_rec.workorder_operation_id,
1387: l_transaction_type_code,
1388: l_load_type_code,

Line 1385: FND_GLOBAL.login_id,

1381: SYSDATE,
1382: FND_GLOBAL.user_id,
1383: SYSDATE,
1384: FND_GLOBAL.user_id,
1385: FND_GLOBAL.login_id,
1386: p_operation_rec.workorder_operation_id,
1387: l_transaction_type_code,
1388: l_load_type_code,
1389: p_operation_rec.actual_start_date,

Line 1423: last_updated_by = FND_GLOBAL.user_id,

1419: UPDATE AHL_WORKORDER_OPERATIONS
1420: SET status_code = G_OP_STATUS_COMPLETE,
1421: object_version_number = object_version_number + 1,
1422: last_update_date = SYSDATE,
1423: last_updated_by = FND_GLOBAL.user_id,
1424: last_update_login = FND_GLOBAL.login_id
1425: WHERE workorder_operation_id = p_operation_rec.workorder_operation_id
1426: AND object_version_number = p_operation_rec.object_version_number;
1427:

Line 1424: last_update_login = FND_GLOBAL.login_id

1420: SET status_code = G_OP_STATUS_COMPLETE,
1421: object_version_number = object_version_number + 1,
1422: last_update_date = SYSDATE,
1423: last_updated_by = FND_GLOBAL.user_id,
1424: last_update_login = FND_GLOBAL.login_id
1425: WHERE workorder_operation_id = p_operation_rec.workorder_operation_id
1426: AND object_version_number = p_operation_rec.object_version_number;
1427:
1428: IF ( SQL%ROWCOUNT = 0 ) THEN

Line 2924: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

2920: IF l_actual_start_date IS NULL THEN
2921: UPDATE AHL_WORKORDER_OPERATIONS
2922: SET ACTUAL_START_DATE = l_operation_tbl(1).actual_start_date,
2923: LAST_UPDATE_DATE = SYSDATE,
2924: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2925: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
2926: WHERE WORKORDER_OPERATION_ID = p_workorder_operation_id;
2927: IF SQL%ROWCOUNT = 0 THEN
2928: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_OP_DEF_ERROR' );

Line 2925: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

2921: UPDATE AHL_WORKORDER_OPERATIONS
2922: SET ACTUAL_START_DATE = l_operation_tbl(1).actual_start_date,
2923: LAST_UPDATE_DATE = SYSDATE,
2924: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2925: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
2926: WHERE WORKORDER_OPERATION_ID = p_workorder_operation_id;
2927: IF SQL%ROWCOUNT = 0 THEN
2928: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_OP_DEF_ERROR' );
2929: FND_MSG_PUB.add;

Line 2937: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

2933: IF l_actual_end_date IS NULL THEN
2934: UPDATE AHL_WORKORDER_OPERATIONS
2935: SET ACTUAL_END_DATE = l_operation_tbl(1).actual_end_date,
2936: LAST_UPDATE_DATE = SYSDATE,
2937: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2938: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
2939: WHERE WORKORDER_OPERATION_ID = p_workorder_operation_id;
2940: IF SQL%ROWCOUNT = 0 THEN
2941: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_OP_DEF_ERROR' );

Line 2938: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

2934: UPDATE AHL_WORKORDER_OPERATIONS
2935: SET ACTUAL_END_DATE = l_operation_tbl(1).actual_end_date,
2936: LAST_UPDATE_DATE = SYSDATE,
2937: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2938: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
2939: WHERE WORKORDER_OPERATION_ID = p_workorder_operation_id;
2940: IF SQL%ROWCOUNT = 0 THEN
2941: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_OP_DEF_ERROR' );
2942: FND_MSG_PUB.add;

Line 3384: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

3380: IF l_actual_start_date IS NULL THEN
3381: UPDATE AHL_WORKORDERS
3382: SET ACTUAL_START_DATE = l_def_actual_start_date,
3383: LAST_UPDATE_DATE = SYSDATE,
3384: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3385: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
3386: WHERE WORKORDER_ID = p_workorder_id;
3387: IF SQL%ROWCOUNT = 0 THEN
3388: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_WO_DEF_ERROR' );

Line 3385: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

3381: UPDATE AHL_WORKORDERS
3382: SET ACTUAL_START_DATE = l_def_actual_start_date,
3383: LAST_UPDATE_DATE = SYSDATE,
3384: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3385: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
3386: WHERE WORKORDER_ID = p_workorder_id;
3387: IF SQL%ROWCOUNT = 0 THEN
3388: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_WO_DEF_ERROR' );
3389: FND_MSG_PUB.add;

Line 3399: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

3395: IF l_actual_end_date IS NULL THEN
3396: UPDATE AHL_WORKORDERS
3397: SET ACTUAL_END_DATE = l_def_actual_end_date,
3398: LAST_UPDATE_DATE = SYSDATE,
3399: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3400: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
3401: WHERE WORKORDER_ID = p_workorder_id;
3402: IF SQL%ROWCOUNT = 0 THEN
3403: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_WO_DEF_ERROR' );

Line 3400: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

3396: UPDATE AHL_WORKORDERS
3397: SET ACTUAL_END_DATE = l_def_actual_end_date,
3398: LAST_UPDATE_DATE = SYSDATE,
3399: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3400: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
3401: WHERE WORKORDER_ID = p_workorder_id;
3402: IF SQL%ROWCOUNT = 0 THEN
3403: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_WO_DEF_ERROR' );
3404: FND_MSG_PUB.add;

Line 7583: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

7579: SET object_version_number = object_version_number + 1,
7580: actual_start_date = l_operation_tbl(i).actual_start_date,
7581: actual_end_date = l_operation_tbl(i).actual_end_date,
7582: LAST_UPDATE_DATE = SYSDATE,
7583: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
7584: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
7585: WHERE workorder_operation_id = l_operation_tbl(i).workorder_operation_id
7586: AND object_version_number = l_operation_tbl(i).object_version_number;
7587:

Line 7584: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

7580: actual_start_date = l_operation_tbl(i).actual_start_date,
7581: actual_end_date = l_operation_tbl(i).actual_end_date,
7582: LAST_UPDATE_DATE = SYSDATE,
7583: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
7584: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
7585: WHERE workorder_operation_id = l_operation_tbl(i).workorder_operation_id
7586: AND object_version_number = l_operation_tbl(i).object_version_number;
7587:
7588: IF ( SQL%ROWCOUNT = 0 ) THEN

Line 7702: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

7698: UPDATE AHL_WORKORDERS
7699: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
7700: ACTUAL_START_DATE = l_def_actual_start_date,
7701: LAST_UPDATE_DATE = SYSDATE,
7702: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
7703: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
7704: WHERE WORKORDER_ID = l_workorder_tbl(i).workorder_id
7705: AND OBJECT_VERSION_NUMBER = l_workorder_tbl(i).object_version_number;
7706: IF SQL%ROWCOUNT = 0 THEN

Line 7703: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

7699: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
7700: ACTUAL_START_DATE = l_def_actual_start_date,
7701: LAST_UPDATE_DATE = SYSDATE,
7702: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
7703: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
7704: WHERE WORKORDER_ID = l_workorder_tbl(i).workorder_id
7705: AND OBJECT_VERSION_NUMBER = l_workorder_tbl(i).object_version_number;
7706: IF SQL%ROWCOUNT = 0 THEN
7707: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );

Line 7721: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

7717: UPDATE AHL_WORKORDERS
7718: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
7719: ACTUAL_END_DATE = l_def_actual_end_date,
7720: LAST_UPDATE_DATE = SYSDATE,
7721: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
7722: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
7723: WHERE WORKORDER_ID = l_workorder_tbl(i).workorder_id
7724: AND OBJECT_VERSION_NUMBER = l_workorder_tbl(i).object_version_number;
7725: IF SQL%ROWCOUNT = 0 THEN

Line 7722: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

7718: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
7719: ACTUAL_END_DATE = l_def_actual_end_date,
7720: LAST_UPDATE_DATE = SYSDATE,
7721: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
7722: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
7723: WHERE WORKORDER_ID = l_workorder_tbl(i).workorder_id
7724: AND OBJECT_VERSION_NUMBER = l_workorder_tbl(i).object_version_number;
7725: IF SQL%ROWCOUNT = 0 THEN
7726: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );

Line 7740: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

7736: SET object_version_number = object_version_number + 1,
7737: actual_start_date = l_workorder_tbl(i).actual_start_date,
7738: actual_end_date = l_workorder_tbl(i).actual_end_date,
7739: LAST_UPDATE_DATE = SYSDATE,
7740: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
7741: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
7742: WHERE workorder_id = l_workorder_tbl(i).workorder_id
7743: AND object_version_number = l_workorder_tbl(i).object_version_number;
7744:

Line 7741: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

7737: actual_start_date = l_workorder_tbl(i).actual_start_date,
7738: actual_end_date = l_workorder_tbl(i).actual_end_date,
7739: LAST_UPDATE_DATE = SYSDATE,
7740: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
7741: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
7742: WHERE workorder_id = l_workorder_tbl(i).workorder_id
7743: AND object_version_number = l_workorder_tbl(i).object_version_number;
7744:
7745: IF ( SQL%ROWCOUNT = 0 ) THEN

Line 9716: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

9712: SET object_version_number = object_version_number + 1,
9713: actual_start_date = l_operation_tbl(i).actual_start_date,
9714: actual_end_date = l_operation_tbl(i).actual_end_date,
9715: LAST_UPDATE_DATE = SYSDATE,
9716: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
9717: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
9718: WHERE workorder_operation_id = l_operation_tbl(i).workorder_operation_id
9719: AND object_version_number = l_operation_tbl(i).object_version_number;
9720:

Line 9717: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

9713: actual_start_date = l_operation_tbl(i).actual_start_date,
9714: actual_end_date = l_operation_tbl(i).actual_end_date,
9715: LAST_UPDATE_DATE = SYSDATE,
9716: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
9717: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
9718: WHERE workorder_operation_id = l_operation_tbl(i).workorder_operation_id
9719: AND object_version_number = l_operation_tbl(i).object_version_number;
9720:
9721: IF ( SQL%ROWCOUNT = 0 ) THEN

Line 9795: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

9791: UPDATE AHL_WORKORDERS
9792: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
9793: ACTUAL_START_DATE = l_def_actual_start_date,
9794: LAST_UPDATE_DATE = SYSDATE,
9795: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
9796: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
9797: WHERE WORKORDER_ID = l_workorder_tbl(i).workorder_id
9798: AND OBJECT_VERSION_NUMBER = l_workorder_tbl(i).object_version_number;
9799: IF SQL%ROWCOUNT = 0 THEN

Line 9796: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

9792: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
9793: ACTUAL_START_DATE = l_def_actual_start_date,
9794: LAST_UPDATE_DATE = SYSDATE,
9795: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
9796: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
9797: WHERE WORKORDER_ID = l_workorder_tbl(i).workorder_id
9798: AND OBJECT_VERSION_NUMBER = l_workorder_tbl(i).object_version_number;
9799: IF SQL%ROWCOUNT = 0 THEN
9800: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );

Line 9814: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

9810: UPDATE AHL_WORKORDERS
9811: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
9812: ACTUAL_END_DATE = l_def_actual_end_date,
9813: LAST_UPDATE_DATE = SYSDATE,
9814: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
9815: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
9816: WHERE WORKORDER_ID = l_workorder_tbl(i).workorder_id
9817: AND OBJECT_VERSION_NUMBER = l_workorder_tbl(i).object_version_number;
9818: IF SQL%ROWCOUNT = 0 THEN

Line 9815: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

9811: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
9812: ACTUAL_END_DATE = l_def_actual_end_date,
9813: LAST_UPDATE_DATE = SYSDATE,
9814: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
9815: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
9816: WHERE WORKORDER_ID = l_workorder_tbl(i).workorder_id
9817: AND OBJECT_VERSION_NUMBER = l_workorder_tbl(i).object_version_number;
9818: IF SQL%ROWCOUNT = 0 THEN
9819: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );

Line 11564: last_updated_by = fnd_global.user_id,

11560: AHL_WORKORDERS
11561: SET
11562: status_code = 12,
11563: last_update_date = sysdate,
11564: last_updated_by = fnd_global.user_id,
11565: last_update_login = fnd_global.login_id,
11566: object_version_number = object_version_number + 1
11567: WHERE
11568: workorder_id = l_workorder_id_tbl(l_count)

Line 11565: last_update_login = fnd_global.login_id,

11561: SET
11562: status_code = 12,
11563: last_update_date = sysdate,
11564: last_updated_by = fnd_global.user_id,
11565: last_update_login = fnd_global.login_id,
11566: object_version_number = object_version_number + 1
11567: WHERE
11568: workorder_id = l_workorder_id_tbl(l_count)
11569: AND object_version_number = l_object_version_number_tbl(l_count)

Line 11648: fnd_global.user_id,

11644: (
11645: AHL_WORKORDER_TXNS_S.NEXTVAL,
11646: l_object_version_number_tbl(l_txn_count) + 1,
11647: sysdate,
11648: fnd_global.user_id,
11649: sysdate,
11650: fnd_global.user_id,
11651: fnd_global.login_id,
11652: l_workorder_id_tbl(l_txn_count),

Line 11650: fnd_global.user_id,

11646: l_object_version_number_tbl(l_txn_count) + 1,
11647: sysdate,
11648: fnd_global.user_id,
11649: sysdate,
11650: fnd_global.user_id,
11651: fnd_global.login_id,
11652: l_workorder_id_tbl(l_txn_count),
11653: 0,
11654: 12, -- this is close workorder. On successful update the Workorder will be in status 12.

Line 11651: fnd_global.login_id,

11647: sysdate,
11648: fnd_global.user_id,
11649: sysdate,
11650: fnd_global.user_id,
11651: fnd_global.login_id,
11652: l_workorder_id_tbl(l_txn_count),
11653: 0,
11654: 12, -- this is close workorder. On successful update the Workorder will be in status 12.
11655: l_wo_sch_str_tbl(l_txn_count),