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_WORKORDER_PVT dependencies on AHL_COMPLETIONS_PVT

Line 7205: l_mwo_return_status := AHL_COMPLETIONS_PVT.complete_master_wo(

7201: 'completing mwo->'||l_master_workorder_tbl(l_count).workorder_id
7202: );
7203: END IF;
7204:
7205: l_mwo_return_status := AHL_COMPLETIONS_PVT.complete_master_wo(
7206: p_visit_id => null,
7207: p_workorder_id => l_master_workorder_tbl(l_count).workorder_id,
7208: p_ue_id => null
7209: );

Line 7246: l_status_code := AHL_COMPLETIONS_PVT.get_mr_status( mr_csr.unit_effectivity_id );

7242:
7243: -- Get all the Unplanned Top UEs in the Visit
7244: FOR mr_csr IN get_visit_mrs( p_visit_id ) LOOP
7245:
7246: l_status_code := AHL_COMPLETIONS_PVT.get_mr_status( mr_csr.unit_effectivity_id );
7247: -- UEs can be cancelled only if all it's WOs are cancelled
7248: IF ( l_status_code = G_MR_STATUS_JOBS_CANCELLED ) THEN
7249: l_ue_count := l_ue_count + 1;
7250: l_unit_effectivity_tbl(l_ue_count).unit_effectivity_id := mr_csr.unit_effectivity_id;

Line 7268: l_status_code := AHL_COMPLETIONS_PVT.get_mr_status( p_unit_effectivity_id );

7264:
7265: IF ( get_ue_details%FOUND ) THEN
7266: CLOSE get_ue_details;
7267:
7268: l_status_code := AHL_COMPLETIONS_PVT.get_mr_status( p_unit_effectivity_id );
7269: -- UEs can be cancelled only if all it's WOs are cancelled
7270: IF ( l_status_code = G_MR_STATUS_JOBS_CANCELLED ) THEN
7271: l_ue_count := l_ue_count + 1;
7272: l_unit_effectivity_tbl(l_ue_count).unit_effectivity_id := p_unit_effectivity_id;

Line 7283: l_status_code := AHL_COMPLETIONS_PVT.get_mr_status( parent_csr.ue_id );

7279: OPEN get_ue_details(parent_csr.ue_id);
7280: FETCH get_ue_details INTO l_ovn;
7281: CLOSE get_ue_details;
7282:
7283: l_status_code := AHL_COMPLETIONS_PVT.get_mr_status( parent_csr.ue_id );
7284:
7285: -- UEs can be cancelled only if all it's WOs are cancelled
7286: IF ( l_status_code = G_MR_STATUS_JOBS_CANCELLED ) THEN
7287: l_ue_count := l_ue_count + 1;

Line 7309: l_status_code := AHL_COMPLETIONS_PVT.get_mr_status( l_unit_effectivity_id );

7305: INTO l_unit_effectivity_id,
7306: l_object_version_number;
7307:
7308: IF ( get_ue_details_for_wo%FOUND ) THEN
7309: l_status_code := AHL_COMPLETIONS_PVT.get_mr_status( l_unit_effectivity_id );
7310: -- UEs can be cancelled only if all it's WOs are cancelled
7311: IF ( l_status_code = G_MR_STATUS_JOBS_CANCELLED ) THEN
7312: l_ue_count := l_ue_count + 1;
7313: l_unit_effectivity_tbl(l_ue_count).unit_effectivity_id := l_unit_effectivity_id;

Line 7324: l_status_code := AHL_COMPLETIONS_PVT.get_mr_status( parent_csr.ue_id );

7320: OPEN get_ue_details(parent_csr.ue_id);
7321: FETCH get_ue_details INTO l_ovn;
7322: CLOSE get_ue_details;
7323:
7324: l_status_code := AHL_COMPLETIONS_PVT.get_mr_status( parent_csr.ue_id );
7325:
7326: -- UEs can be cancelled only if all it's WOs are cancelled
7327: IF ( l_status_code = G_MR_STATUS_JOBS_CANCELLED ) THEN
7328: l_ue_count := l_ue_count + 1;