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_PRD_WO_LOGIN_PVT dependencies on AHL_WORK_LOGIN_TIMES

Line 792: 'Inserting into ahl_work_login_times.');

788: -- END IF; -- techinician user role check.
789:
790: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
791: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login',
792: 'Inserting into ahl_work_login_times.');
793: END IF;
794:
795: -- insert login date and time.
796: insert into ahl_work_login_times(

Line 796: insert into ahl_work_login_times(

792: 'Inserting into ahl_work_login_times.');
793: END IF;
794:
795: -- insert login date and time.
796: insert into ahl_work_login_times(
797: work_login_time_id,
798: workorder_id,
799: operation_seq_num,
800: resource_seq_num,

Line 812: ahl_work_login_times_s.nextval,

808: CREATION_DATE,
809: CREATED_BY,
810: LAST_UPDATE_LOGIN)
811: values (
812: ahl_work_login_times_s.nextval,
813: p_workorder_id,
814: p_operation_seq_num,
815: p_resource_seq_num,
816: l_operation_resource_id,

Line 1115: 'Before inserting into ahl_work_login_times');

1111:
1112: -- insert login date and time.
1113: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1114: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login',
1115: 'Before inserting into ahl_work_login_times');
1116: END IF;
1117: insert into ahl_work_login_times(
1118: work_login_time_id,
1119: workorder_id,

Line 1117: insert into ahl_work_login_times(

1113: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1114: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login',
1115: 'Before inserting into ahl_work_login_times');
1116: END IF;
1117: insert into ahl_work_login_times(
1118: work_login_time_id,
1119: workorder_id,
1120: operation_seq_num,
1121: resource_seq_num,

Line 1133: ahl_work_login_times_s.nextval,

1129: CREATION_DATE,
1130: CREATED_BY,
1131: LAST_UPDATE_LOGIN)
1132: values (
1133: ahl_work_login_times_s.nextval,
1134: p_workorder_id,
1135: p_operation_seq_num,
1136: null,
1137: null,

Line 1405: 'Before inserting into ahl_work_login_times');

1401: -- END IF; -- p_user_role.
1402:
1403: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1404: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login',
1405: 'Before inserting into ahl_work_login_times');
1406: END IF;
1407:
1408: -- insert login date and time.
1409: insert into ahl_work_login_times(

Line 1409: insert into ahl_work_login_times(

1405: 'Before inserting into ahl_work_login_times');
1406: END IF;
1407:
1408: -- insert login date and time.
1409: insert into ahl_work_login_times(
1410: work_login_time_id,
1411: workorder_id,
1412: operation_seq_num,
1413: resource_seq_num,

Line 1425: ahl_work_login_times_s.nextval,

1421: CREATION_DATE,
1422: CREATED_BY,
1423: LAST_UPDATE_LOGIN)
1424: values (
1425: ahl_work_login_times_s.nextval,
1426: p_workorder_id,
1427: null,
1428: null,
1429: null,

Line 1738: AHL_WORK_LOGIN_TIMES WLGN

1734: WLGN.login_date,
1735: WLGN.work_login_time_id,
1736: WLGN.object_version_number
1737: FROM AHL_Operation_Resources AOR, AHL_WORKORDERS AW,
1738: AHL_WORK_LOGIN_TIMES WLGN
1739: WHERE WLGN.workorder_id(+) = AW.workorder_id
1740: AND WLGN.operation_resource_id = AOR.operation_resource_id(+)
1741: AND WLGN.employee_id(+) = c_employee_id
1742: AND WLGN.login_date(+) IS NOT NULL

Line 1928: l_login_level ahl_work_login_times.login_level%TYPE;

1924: l_operation_seq_num NUMBER;
1925: l_resource_seq_num NUMBER;
1926: l_workorder_name ahl_workorders.workorder_name%TYPE;
1927: l_login_date DATE;
1928: l_login_level ahl_work_login_times.login_level%TYPE;
1929: l_work_login_time_id NUMBER;
1930:
1931: i NUMBER;
1932: l_prd_res_txn_tbl AHL_PRD_RESOURCE_TRANX_PVT.PRD_RESOURCE_TXNS_TBL;

Line 2302: UPDATE ahl_work_login_times

2298:
2299: END IF; -- l_prd_res_txn_tbl.COUNT > 0
2300:
2301: -- update logout time.
2302: UPDATE ahl_work_login_times
2303: SET logout_date = sysdate,
2304: object_version_number = l_object_version_number + 1
2305: WHERE work_login_time_id = l_work_login_time_id;
2306:

Line 2480: AHL_WORK_LOGIN_TIMES WLGN

2476: WLGN.operation_seq_num,
2477: AOR.resource_id,
2478: WLGN.resource_seq_num
2479: FROM AHL_Operation_Resources AOR, AHL_WORKORDERS AW,
2480: AHL_WORK_LOGIN_TIMES WLGN
2481: WHERE WLGN.workorder_id = AW.workorder_id
2482: AND WLGN.operation_resource_id = AOR.operation_resource_id(+)
2483: AND WLGN.employee_id = c_employee_id
2484: AND WLGN.logout_date IS NULL; -- employee logged in.

Line 3548: FROM AHL_Operation_Resources AOR, AHL_WORK_LOGIN_TIMES WLGN

3544: SELECT WLGN.workorder_id,
3545: WLGN.operation_seq_num,
3546: AOR.resource_id,
3547: WLGN.resource_seq_num
3548: FROM AHL_Operation_Resources AOR, AHL_WORK_LOGIN_TIMES WLGN
3549: WHERE WLGN.operation_resource_id = AOR.operation_resource_id(+)
3550: AND WLGN.employee_id = c_employee_id
3551: AND WLGN.logout_date IS NULL;
3552:

Line 3766: FROM AHL_Operation_Resources AOR, AHL_WORK_LOGIN_TIMES WLGN

3762: SELECT WLGN.workorder_id,
3763: WLGN.operation_seq_num,
3764: AOR.resource_id,
3765: WLGN.resource_seq_num
3766: FROM AHL_Operation_Resources AOR, AHL_WORK_LOGIN_TIMES WLGN
3767: WHERE WLGN.operation_resource_id = AOR.operation_resource_id(+)
3768: AND WLGN.employee_id = c_employee_id
3769: AND WLGN.logout_date IS NULL; -- employee logged in.
3770: BEGIN