[Home] [Help]
785: -- END IF; -- techinician user role check.
786:
787: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
788: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login',
789: 'Inserting into ahl_work_login_times.');
790: END IF;
791:
792: -- insert login date and time.
793: insert into ahl_work_login_times(
789: 'Inserting into ahl_work_login_times.');
790: END IF;
791:
792: -- insert login date and time.
793: insert into ahl_work_login_times(
794: work_login_time_id,
795: workorder_id,
796: operation_seq_num,
797: resource_seq_num,
805: CREATION_DATE,
806: CREATED_BY,
807: LAST_UPDATE_LOGIN)
808: values (
809: ahl_work_login_times_s.nextval,
810: p_workorder_id,
811: p_operation_seq_num,
812: p_resource_seq_num,
813: l_operation_resource_id,
1108:
1109: -- insert login date and time.
1110: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1111: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login',
1112: 'Before inserting into ahl_work_login_times');
1113: END IF;
1114: insert into ahl_work_login_times(
1115: work_login_time_id,
1116: workorder_id,
1110: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1111: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login',
1112: 'Before inserting into ahl_work_login_times');
1113: END IF;
1114: insert into ahl_work_login_times(
1115: work_login_time_id,
1116: workorder_id,
1117: operation_seq_num,
1118: resource_seq_num,
1126: CREATION_DATE,
1127: CREATED_BY,
1128: LAST_UPDATE_LOGIN)
1129: values (
1130: ahl_work_login_times_s.nextval,
1131: p_workorder_id,
1132: p_operation_seq_num,
1133: null,
1134: null,
1398: -- END IF; -- p_user_role.
1399:
1400: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1401: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login',
1402: 'Before inserting into ahl_work_login_times');
1403: END IF;
1404:
1405: -- insert login date and time.
1406: insert into ahl_work_login_times(
1402: 'Before inserting into ahl_work_login_times');
1403: END IF;
1404:
1405: -- insert login date and time.
1406: insert into ahl_work_login_times(
1407: work_login_time_id,
1408: workorder_id,
1409: operation_seq_num,
1410: resource_seq_num,
1418: CREATION_DATE,
1419: CREATED_BY,
1420: LAST_UPDATE_LOGIN)
1421: values (
1422: ahl_work_login_times_s.nextval,
1423: p_workorder_id,
1424: null,
1425: null,
1426: null,
1731: WLGN.login_date,
1732: WLGN.work_login_time_id,
1733: WLGN.object_version_number
1734: FROM AHL_Operation_Resources AOR, AHL_WORKORDERS AW,
1735: AHL_WORK_LOGIN_TIMES WLGN
1736: WHERE WLGN.workorder_id(+) = AW.workorder_id
1737: AND WLGN.operation_resource_id = AOR.operation_resource_id(+)
1738: AND WLGN.employee_id(+) = c_employee_id
1739: AND WLGN.login_date(+) IS NOT NULL
1921: l_operation_seq_num NUMBER;
1922: l_resource_seq_num NUMBER;
1923: l_workorder_name ahl_workorders.workorder_name%TYPE;
1924: l_login_date DATE;
1925: l_login_level ahl_work_login_times.login_level%TYPE;
1926: l_work_login_time_id NUMBER;
1927:
1928: i NUMBER;
1929: l_prd_res_txn_tbl AHL_PRD_RESOURCE_TRANX_PVT.PRD_RESOURCE_TXNS_TBL;
2292:
2293: END IF; -- l_prd_res_txn_tbl.COUNT > 0
2294:
2295: -- update logout time.
2296: UPDATE ahl_work_login_times
2297: SET logout_date = sysdate,
2298: object_version_number = l_object_version_number + 1
2299: WHERE work_login_time_id = l_work_login_time_id;
2300:
2468: WLGN.operation_seq_num,
2469: AOR.resource_id,
2470: WLGN.resource_seq_num
2471: FROM AHL_Operation_Resources AOR, AHL_WORKORDERS AW,
2472: AHL_WORK_LOGIN_TIMES WLGN
2473: WHERE WLGN.workorder_id = AW.workorder_id
2474: AND WLGN.operation_resource_id = AOR.operation_resource_id(+)
2475: AND WLGN.employee_id = c_employee_id
2476: AND WLGN.logout_date IS NULL; -- employee logged in.