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 AHL_PRD_WORKORDER_PVT

Line 957: AHL_PRD_WORKORDER_PVT.ADD_WO_OPER_TURNOVER_NOTES

953: l_transaction_type_code NUMBER := 1;
954: l_return_status VARCHAR2(1);
955: BEGIN
956: --sukhwsin::VEE Code Changes - start
957: AHL_PRD_WORKORDER_PVT.ADD_WO_OPER_TURNOVER_NOTES
958: (
959: p_workorder_id => p_workorder_rec.workorder_id,
960: p_new_status_code => p_status_code,
961: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1405: AHL_PRD_WORKORDER_PVT.ADD_WO_OPER_TURNOVER_NOTES

1401: IS
1402: l_return_status VARCHAR2(1);
1403: BEGIN
1404: --sukhwsin::VEE Code Changes - start
1405: AHL_PRD_WORKORDER_PVT.ADD_WO_OPER_TURNOVER_NOTES
1406: (
1407: p_workorder_id => p_operation_rec.workorder_id,
1408: p_workorder_op_id => p_operation_rec.workorder_operation_id,
1409: p_new_status_code => G_OP_STATUS_COMPLETE,

Line 2665: fnd_log.string(l_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.delete_serial_reservations.begin',

2661: BEGIN
2662:
2663:
2664: IF ( l_DEBUG_PROC >= l_DEBUG_LEVEL) THEN
2665: fnd_log.string(l_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.delete_serial_reservations.begin',
2666: 'At the start of procedure for workorder_id:' || p_workorder_id);
2667: END IF;
2668:
2669: -- Initialize return status.

Line 2688: fnd_log.string(l_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.delete_serial_reservations',

2684: p_scheduled_material_id => get_scheduled_mater_rec.scheduled_material_id );
2685:
2686: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2687: IF (l_DEBUG_STMT >= l_DEBUG_LEVEL) THEN
2688: fnd_log.string(l_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.delete_serial_reservations',
2689: 'AHL_RSV_RESERVATIONS_PVT.Delete_Reservation failed for schedule material ID: '
2690: || get_scheduled_mater_rec.scheduled_material_id);
2691: END IF; -- x_return_status
2692:

Line 3180: l_prd_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;

3176: l_mr_rec mr_rec_type;
3177: l_counter_tbl counter_tbl_type;
3178:
3179: l_child_wos_complete BOOLEAN := TRUE;
3180: l_prd_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;
3181: l_prd_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;
3182:
3183: l_mr_status VARCHAR2(30);
3184:

Line 3181: l_prd_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;

3177: l_counter_tbl counter_tbl_type;
3178:
3179: l_child_wos_complete BOOLEAN := TRUE;
3180: l_prd_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;
3181: l_prd_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;
3182:
3183: l_mr_status VARCHAR2(30);
3184:
3185: CURSOR get_parent_master_wos( c_child_wip_entity_id NUMBER )

Line 3276: l_up_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;

3272:
3273: l_employee_id NUMBER;
3274: l_operation_seq_num NUMBER;
3275: l_resource_seq_num NUMBER;
3276: l_up_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;
3277: l_up_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;
3278: l_object_version_number NUMBER := NULL;
3279:
3280:

Line 3277: l_up_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;

3273: l_employee_id NUMBER;
3274: l_operation_seq_num NUMBER;
3275: l_resource_seq_num NUMBER;
3276: l_up_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;
3277: l_up_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;
3278: l_object_version_number NUMBER := NULL;
3279:
3280:
3281: BEGIN

Line 3356: AHL_PRD_WORKORDER_PVT.update_job

3352: l_up_workorder_rec.ACTUAL_END_HR := TO_NUMBER(TO_CHAR(l_up_workorder_rec.ACTUAL_END_DATE, 'HH24'));
3353: l_up_workorder_rec.ACTUAL_END_MI := TO_NUMBER(TO_CHAR(l_up_workorder_rec.ACTUAL_END_DATE, 'MI'));
3354: END IF;
3355:
3356: AHL_PRD_WORKORDER_PVT.update_job
3357: (
3358: p_api_version => 1.0 ,
3359: p_init_msg_list => FND_API.G_TRUE ,
3360: p_commit => FND_API.G_FALSE ,

Line 11021: l_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;

11017: l_return_status VARCHAR2(1);
11018: l_msg_count NUMBER;
11019: l_msg_data VARCHAR2(2000);
11020:
11021: l_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;
11022: l_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REL_TBL;
11023: l_wo_count NUMBER;
11024:
11025: -- cursor to retrieve the visit master workorder

Line 11022: l_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REL_TBL;

11018: l_msg_count NUMBER;
11019: l_msg_data VARCHAR2(2000);
11020:
11021: l_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;
11022: l_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REL_TBL;
11023: l_wo_count NUMBER;
11024:
11025: -- cursor to retrieve the visit master workorder
11026: CURSOR get_visit_master_wo(c_visit_id NUMBER )

Line 11135: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs

11131: CLOSE chk_cmplt_wo_exists;
11132: -- all jobs cancelled.
11133: -- cancel master workorder.
11134: IF (p_visit_id IS NOT NULL) THEN
11135: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs
11136: (
11137: p_api_version => 1.0,
11138: p_init_msg_list => FND_API.G_TRUE,
11139: p_commit => FND_API.G_FALSE,

Line 11151: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs

11147: p_unit_effectivity_id => NULL,
11148: p_workorder_id => NULL
11149: );
11150: ELSIF (p_ue_id IS NOT NULL) THEN
11151: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs
11152: (
11153: p_api_version => 1.0,
11154: p_init_msg_list => FND_API.G_TRUE,
11155: p_commit => FND_API.G_FALSE,

Line 11167: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs

11163: p_unit_effectivity_id => p_ue_id,
11164: p_workorder_id => NULL
11165: );
11166: ELSIF (p_workorder_id IS NOT NULL) THEN
11167: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs
11168: (
11169: p_api_version => 1.0,
11170: p_init_msg_list => FND_API.G_TRUE,
11171: p_commit => FND_API.G_FALSE,

Line 11523: AHL_PRD_WORKORDER_PVT.ADD_WO_OPER_TURNOVER_NOTES

11519:
11520: END IF; --l_master_workorder_flag_tbl(l_index) = 'N'
11521: --sukhwsin::VEE Code Changes - start
11522: IF l_valid_for_close_tbl(l_index) IS NULL OR l_valid_for_close_tbl(l_index) <> 'N' THEN
11523: AHL_PRD_WORKORDER_PVT.ADD_WO_OPER_TURNOVER_NOTES
11524: (
11525: p_workorder_id => l_workorder_id_tbl(l_index),
11526: p_new_status_code => '12',
11527: p_validation_level => FND_API.G_VALID_LEVEL_FULL,