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 822: p_user_id => FND_GLOBAL.user_id,

818: p_wip_entity_id => p_workorder_rec.wip_entity_id,
819: p_transaction_type => 1,
820: p_transaction_date => SYSDATE,
821: p_instance_id => p_workorder_rec.item_instance_id,
822: p_user_id => FND_GLOBAL.user_id,
823: p_request_id => NULL,
824: p_application_id => NULL,
825: p_program_id => NULL,
826: p_reconciliation_code => NULL,

Line 900: FND_GLOBAL.user_id,

896: ) VALUES (
897: l_workorder_txn_id,
898: 1,
899: SYSDATE,
900: FND_GLOBAL.user_id,
901: SYSDATE,
902: FND_GLOBAL.user_id,
903: FND_GLOBAL.login_id,
904: p_workorder_rec.workorder_id,

Line 902: FND_GLOBAL.user_id,

898: 1,
899: SYSDATE,
900: FND_GLOBAL.user_id,
901: SYSDATE,
902: FND_GLOBAL.user_id,
903: FND_GLOBAL.login_id,
904: p_workorder_rec.workorder_id,
905: p_transaction_type_code,
906: p_workorder_rec.status_code,

Line 903: FND_GLOBAL.login_id,

899: SYSDATE,
900: FND_GLOBAL.user_id,
901: SYSDATE,
902: FND_GLOBAL.user_id,
903: FND_GLOBAL.login_id,
904: p_workorder_rec.workorder_id,
905: p_transaction_type_code,
906: p_workorder_rec.status_code,
907: p_workorder_rec.actual_start_date,

Line 935: last_updated_by = FND_GLOBAL.user_id,

931: UPDATE AHL_WORKORDERS
932: SET status_code = p_status_code,
933: object_version_number = object_version_number + 1,
934: last_update_date = SYSDATE,
935: last_updated_by = FND_GLOBAL.user_id,
936: last_update_login = FND_GLOBAL.login_id
937: WHERE workorder_id = p_workorder_rec.workorder_id
938: AND object_version_number = p_workorder_rec.object_version_number;
939:

Line 936: last_update_login = FND_GLOBAL.login_id

932: SET status_code = p_status_code,
933: object_version_number = object_version_number + 1,
934: last_update_date = SYSDATE,
935: last_updated_by = FND_GLOBAL.user_id,
936: last_update_login = FND_GLOBAL.login_id
937: WHERE workorder_id = p_workorder_rec.workorder_id
938: AND object_version_number = p_workorder_rec.object_version_number;
939:
940: IF ( SQL%ROWCOUNT = 0 ) THEN

Line 1335: FND_GLOBAL.user_id,

1331: ) VALUES (
1332: l_wo_operation_txn_id,
1333: 1,
1334: SYSDATE,
1335: FND_GLOBAL.user_id,
1336: SYSDATE,
1337: FND_GLOBAL.user_id,
1338: FND_GLOBAL.login_id,
1339: p_operation_rec.workorder_operation_id,

Line 1337: FND_GLOBAL.user_id,

1333: 1,
1334: SYSDATE,
1335: FND_GLOBAL.user_id,
1336: SYSDATE,
1337: FND_GLOBAL.user_id,
1338: FND_GLOBAL.login_id,
1339: p_operation_rec.workorder_operation_id,
1340: l_transaction_type_code,
1341: l_load_type_code,

Line 1338: FND_GLOBAL.login_id,

1334: SYSDATE,
1335: FND_GLOBAL.user_id,
1336: SYSDATE,
1337: FND_GLOBAL.user_id,
1338: FND_GLOBAL.login_id,
1339: p_operation_rec.workorder_operation_id,
1340: l_transaction_type_code,
1341: l_load_type_code,
1342: p_operation_rec.actual_start_date,

Line 1362: last_updated_by = FND_GLOBAL.user_id,

1358: UPDATE AHL_WORKORDER_OPERATIONS
1359: SET status_code = G_OP_STATUS_COMPLETE,
1360: object_version_number = object_version_number + 1,
1361: last_update_date = SYSDATE,
1362: last_updated_by = FND_GLOBAL.user_id,
1363: last_update_login = FND_GLOBAL.login_id
1364: WHERE workorder_operation_id = p_operation_rec.workorder_operation_id
1365: AND object_version_number = p_operation_rec.object_version_number;
1366:

Line 1363: last_update_login = FND_GLOBAL.login_id

1359: SET status_code = G_OP_STATUS_COMPLETE,
1360: object_version_number = object_version_number + 1,
1361: last_update_date = SYSDATE,
1362: last_updated_by = FND_GLOBAL.user_id,
1363: last_update_login = FND_GLOBAL.login_id
1364: WHERE workorder_operation_id = p_operation_rec.workorder_operation_id
1365: AND object_version_number = p_operation_rec.object_version_number;
1366:
1367: IF ( SQL%ROWCOUNT = 0 ) THEN

Line 2811: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

2807: IF l_actual_start_date IS NULL THEN
2808: UPDATE AHL_WORKORDER_OPERATIONS
2809: SET ACTUAL_START_DATE = l_operation_tbl(1).actual_start_date,
2810: LAST_UPDATE_DATE = SYSDATE,
2811: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2812: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
2813: WHERE WORKORDER_OPERATION_ID = p_workorder_operation_id;
2814: IF SQL%ROWCOUNT = 0 THEN
2815: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_OP_DEF_ERROR' );

Line 2812: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

2808: UPDATE AHL_WORKORDER_OPERATIONS
2809: SET ACTUAL_START_DATE = l_operation_tbl(1).actual_start_date,
2810: LAST_UPDATE_DATE = SYSDATE,
2811: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2812: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
2813: WHERE WORKORDER_OPERATION_ID = p_workorder_operation_id;
2814: IF SQL%ROWCOUNT = 0 THEN
2815: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_OP_DEF_ERROR' );
2816: FND_MSG_PUB.add;

Line 2824: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

2820: IF l_actual_end_date IS NULL THEN
2821: UPDATE AHL_WORKORDER_OPERATIONS
2822: SET ACTUAL_END_DATE = l_operation_tbl(1).actual_end_date,
2823: LAST_UPDATE_DATE = SYSDATE,
2824: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2825: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
2826: WHERE WORKORDER_OPERATION_ID = p_workorder_operation_id;
2827: IF SQL%ROWCOUNT = 0 THEN
2828: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_OP_DEF_ERROR' );

Line 2825: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

2821: UPDATE AHL_WORKORDER_OPERATIONS
2822: SET ACTUAL_END_DATE = l_operation_tbl(1).actual_end_date,
2823: LAST_UPDATE_DATE = SYSDATE,
2824: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2825: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
2826: WHERE WORKORDER_OPERATION_ID = p_workorder_operation_id;
2827: IF SQL%ROWCOUNT = 0 THEN
2828: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_OP_DEF_ERROR' );
2829: FND_MSG_PUB.add;

Line 3271: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

3267: IF l_actual_start_date IS NULL THEN
3268: UPDATE AHL_WORKORDERS
3269: SET ACTUAL_START_DATE = l_def_actual_start_date,
3270: LAST_UPDATE_DATE = SYSDATE,
3271: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3272: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
3273: WHERE WORKORDER_ID = p_workorder_id;
3274: IF SQL%ROWCOUNT = 0 THEN
3275: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_WO_DEF_ERROR' );

Line 3272: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

3268: UPDATE AHL_WORKORDERS
3269: SET ACTUAL_START_DATE = l_def_actual_start_date,
3270: LAST_UPDATE_DATE = SYSDATE,
3271: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3272: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
3273: WHERE WORKORDER_ID = p_workorder_id;
3274: IF SQL%ROWCOUNT = 0 THEN
3275: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_WO_DEF_ERROR' );
3276: FND_MSG_PUB.add;

Line 3286: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

3282: IF l_actual_end_date IS NULL THEN
3283: UPDATE AHL_WORKORDERS
3284: SET ACTUAL_END_DATE = l_def_actual_end_date,
3285: LAST_UPDATE_DATE = SYSDATE,
3286: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3287: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
3288: WHERE WORKORDER_ID = p_workorder_id;
3289: IF SQL%ROWCOUNT = 0 THEN
3290: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_WO_DEF_ERROR' );

Line 3287: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

3283: UPDATE AHL_WORKORDERS
3284: SET ACTUAL_END_DATE = l_def_actual_end_date,
3285: LAST_UPDATE_DATE = SYSDATE,
3286: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3287: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
3288: WHERE WORKORDER_ID = p_workorder_id;
3289: IF SQL%ROWCOUNT = 0 THEN
3290: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_WO_DEF_ERROR' );
3291: FND_MSG_PUB.add;

Line 7198: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

7194: SET object_version_number = object_version_number + 1,
7195: actual_start_date = l_operation_tbl(i).actual_start_date,
7196: actual_end_date = l_operation_tbl(i).actual_end_date,
7197: LAST_UPDATE_DATE = SYSDATE,
7198: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
7199: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
7200: WHERE workorder_operation_id = l_operation_tbl(i).workorder_operation_id
7201: AND object_version_number = l_operation_tbl(i).object_version_number;
7202:

Line 7199: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

7195: actual_start_date = l_operation_tbl(i).actual_start_date,
7196: actual_end_date = l_operation_tbl(i).actual_end_date,
7197: LAST_UPDATE_DATE = SYSDATE,
7198: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
7199: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
7200: WHERE workorder_operation_id = l_operation_tbl(i).workorder_operation_id
7201: AND object_version_number = l_operation_tbl(i).object_version_number;
7202:
7203: IF ( SQL%ROWCOUNT = 0 ) THEN

Line 7317: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

7313: UPDATE AHL_WORKORDERS
7314: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
7315: ACTUAL_START_DATE = l_def_actual_start_date,
7316: LAST_UPDATE_DATE = SYSDATE,
7317: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
7318: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
7319: WHERE WORKORDER_ID = l_workorder_tbl(i).workorder_id
7320: AND OBJECT_VERSION_NUMBER = l_workorder_tbl(i).object_version_number;
7321: IF SQL%ROWCOUNT = 0 THEN

Line 7318: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

7314: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
7315: ACTUAL_START_DATE = l_def_actual_start_date,
7316: LAST_UPDATE_DATE = SYSDATE,
7317: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
7318: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
7319: WHERE WORKORDER_ID = l_workorder_tbl(i).workorder_id
7320: AND OBJECT_VERSION_NUMBER = l_workorder_tbl(i).object_version_number;
7321: IF SQL%ROWCOUNT = 0 THEN
7322: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );

Line 7336: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

7332: UPDATE AHL_WORKORDERS
7333: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
7334: ACTUAL_END_DATE = l_def_actual_end_date,
7335: LAST_UPDATE_DATE = SYSDATE,
7336: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
7337: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
7338: WHERE WORKORDER_ID = l_workorder_tbl(i).workorder_id
7339: AND OBJECT_VERSION_NUMBER = l_workorder_tbl(i).object_version_number;
7340: IF SQL%ROWCOUNT = 0 THEN

Line 7337: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

7333: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
7334: ACTUAL_END_DATE = l_def_actual_end_date,
7335: LAST_UPDATE_DATE = SYSDATE,
7336: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
7337: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
7338: WHERE WORKORDER_ID = l_workorder_tbl(i).workorder_id
7339: AND OBJECT_VERSION_NUMBER = l_workorder_tbl(i).object_version_number;
7340: IF SQL%ROWCOUNT = 0 THEN
7341: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );

Line 7355: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

7351: SET object_version_number = object_version_number + 1,
7352: actual_start_date = l_workorder_tbl(i).actual_start_date,
7353: actual_end_date = l_workorder_tbl(i).actual_end_date,
7354: LAST_UPDATE_DATE = SYSDATE,
7355: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
7356: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
7357: WHERE workorder_id = l_workorder_tbl(i).workorder_id
7358: AND object_version_number = l_workorder_tbl(i).object_version_number;
7359:

Line 7356: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

7352: actual_start_date = l_workorder_tbl(i).actual_start_date,
7353: actual_end_date = l_workorder_tbl(i).actual_end_date,
7354: LAST_UPDATE_DATE = SYSDATE,
7355: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
7356: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
7357: WHERE workorder_id = l_workorder_tbl(i).workorder_id
7358: AND object_version_number = l_workorder_tbl(i).object_version_number;
7359:
7360: IF ( SQL%ROWCOUNT = 0 ) THEN

Line 9047: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

9043: SET object_version_number = object_version_number + 1,
9044: actual_start_date = l_operation_tbl(i).actual_start_date,
9045: actual_end_date = l_operation_tbl(i).actual_end_date,
9046: LAST_UPDATE_DATE = SYSDATE,
9047: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
9048: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
9049: WHERE workorder_operation_id = l_operation_tbl(i).workorder_operation_id
9050: AND object_version_number = l_operation_tbl(i).object_version_number;
9051:

Line 9048: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

9044: actual_start_date = l_operation_tbl(i).actual_start_date,
9045: actual_end_date = l_operation_tbl(i).actual_end_date,
9046: LAST_UPDATE_DATE = SYSDATE,
9047: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
9048: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
9049: WHERE workorder_operation_id = l_operation_tbl(i).workorder_operation_id
9050: AND object_version_number = l_operation_tbl(i).object_version_number;
9051:
9052: IF ( SQL%ROWCOUNT = 0 ) THEN

Line 9121: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

9117: UPDATE AHL_WORKORDERS
9118: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
9119: ACTUAL_START_DATE = l_def_actual_start_date,
9120: LAST_UPDATE_DATE = SYSDATE,
9121: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
9122: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
9123: WHERE WORKORDER_ID = l_workorder_tbl(i).workorder_id
9124: AND OBJECT_VERSION_NUMBER = l_workorder_tbl(i).object_version_number;
9125: IF SQL%ROWCOUNT = 0 THEN

Line 9122: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

9118: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
9119: ACTUAL_START_DATE = l_def_actual_start_date,
9120: LAST_UPDATE_DATE = SYSDATE,
9121: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
9122: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
9123: WHERE WORKORDER_ID = l_workorder_tbl(i).workorder_id
9124: AND OBJECT_VERSION_NUMBER = l_workorder_tbl(i).object_version_number;
9125: IF SQL%ROWCOUNT = 0 THEN
9126: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );

Line 9140: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

9136: UPDATE AHL_WORKORDERS
9137: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
9138: ACTUAL_END_DATE = l_def_actual_end_date,
9139: LAST_UPDATE_DATE = SYSDATE,
9140: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
9141: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
9142: WHERE WORKORDER_ID = l_workorder_tbl(i).workorder_id
9143: AND OBJECT_VERSION_NUMBER = l_workorder_tbl(i).object_version_number;
9144: IF SQL%ROWCOUNT = 0 THEN

Line 9141: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

9137: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
9138: ACTUAL_END_DATE = l_def_actual_end_date,
9139: LAST_UPDATE_DATE = SYSDATE,
9140: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
9141: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
9142: WHERE WORKORDER_ID = l_workorder_tbl(i).workorder_id
9143: AND OBJECT_VERSION_NUMBER = l_workorder_tbl(i).object_version_number;
9144: IF SQL%ROWCOUNT = 0 THEN
9145: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );

Line 10709: last_updated_by = fnd_global.user_id,

10705: AHL_WORKORDERS
10706: SET
10707: status_code = 12,
10708: last_update_date = sysdate,
10709: last_updated_by = fnd_global.user_id,
10710: last_update_login = fnd_global.login_id,
10711: object_version_number = object_version_number + 1
10712: WHERE
10713: workorder_id = l_workorder_id_tbl(l_count)

Line 10710: last_update_login = fnd_global.login_id,

10706: SET
10707: status_code = 12,
10708: last_update_date = sysdate,
10709: last_updated_by = fnd_global.user_id,
10710: last_update_login = fnd_global.login_id,
10711: object_version_number = object_version_number + 1
10712: WHERE
10713: workorder_id = l_workorder_id_tbl(l_count)
10714: AND object_version_number = l_object_version_number_tbl(l_count)

Line 10793: fnd_global.user_id,

10789: (
10790: AHL_WORKORDER_TXNS_S.NEXTVAL,
10791: l_object_version_number_tbl(l_txn_count) + 1,
10792: sysdate,
10793: fnd_global.user_id,
10794: sysdate,
10795: fnd_global.user_id,
10796: fnd_global.login_id,
10797: l_workorder_id_tbl(l_txn_count),

Line 10795: fnd_global.user_id,

10791: l_object_version_number_tbl(l_txn_count) + 1,
10792: sysdate,
10793: fnd_global.user_id,
10794: sysdate,
10795: fnd_global.user_id,
10796: fnd_global.login_id,
10797: l_workorder_id_tbl(l_txn_count),
10798: 0,
10799: 12, -- this is close workorder. On successful update the Workorder will be in status 12.

Line 10796: fnd_global.login_id,

10792: sysdate,
10793: fnd_global.user_id,
10794: sysdate,
10795: fnd_global.user_id,
10796: fnd_global.login_id,
10797: l_workorder_id_tbl(l_txn_count),
10798: 0,
10799: 12, -- this is close workorder. On successful update the Workorder will be in status 12.
10800: l_wo_sch_str_tbl(l_txn_count),