DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_COMPLETIONS_PVT

Line 9661: l_mwo_return_status := AHL_COMPLETIONS_PVT.complete_master_wo(

9657: 'completing mwo->'||l_master_workorder_tbl(l_count).workorder_id
9658: );
9659: END IF;
9660:
9661: l_mwo_return_status := AHL_COMPLETIONS_PVT.complete_master_wo(
9662: p_visit_id => null,
9663: p_workorder_id => l_master_workorder_tbl(l_count).workorder_id,
9664: p_ue_id => null
9665: );

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

9698:
9699: -- Get all the Unplanned Top UEs in the Visit
9700: FOR mr_csr IN get_visit_mrs( p_visit_id ) LOOP
9701:
9702: l_status_code := AHL_COMPLETIONS_PVT.get_mr_status( mr_csr.unit_effectivity_id );
9703: -- UEs can be cancelled only if all it's WOs are cancelled
9704: IF ( l_status_code = G_MR_STATUS_JOBS_CANCELLED ) THEN
9705: l_ue_count := l_ue_count + 1;
9706: l_unit_effectivity_tbl(l_ue_count).unit_effectivity_id := mr_csr.unit_effectivity_id;

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

9720:
9721: IF ( get_ue_details%FOUND ) THEN
9722: CLOSE get_ue_details;
9723:
9724: l_status_code := AHL_COMPLETIONS_PVT.get_mr_status( p_unit_effectivity_id );
9725: -- UEs can be cancelled only if all it's WOs are cancelled
9726: IF ( l_status_code = G_MR_STATUS_JOBS_CANCELLED ) THEN
9727: l_ue_count := l_ue_count + 1;
9728: l_unit_effectivity_tbl(l_ue_count).unit_effectivity_id := p_unit_effectivity_id;

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

9735: OPEN get_ue_details(parent_csr.ue_id);
9736: FETCH get_ue_details INTO l_ovn;
9737: CLOSE get_ue_details;
9738:
9739: l_status_code := AHL_COMPLETIONS_PVT.get_mr_status( parent_csr.ue_id );
9740:
9741: -- UEs can be cancelled only if all it's WOs are cancelled
9742: IF ( l_status_code = G_MR_STATUS_JOBS_CANCELLED ) THEN
9743: l_ue_count := l_ue_count + 1;

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

9761: INTO l_unit_effectivity_id,
9762: l_object_version_number;
9763:
9764: IF ( get_ue_details_for_wo%FOUND ) THEN
9765: l_status_code := AHL_COMPLETIONS_PVT.get_mr_status( l_unit_effectivity_id );
9766: -- UEs can be cancelled only if all it's WOs are cancelled
9767: IF ( l_status_code = G_MR_STATUS_JOBS_CANCELLED ) THEN
9768: l_ue_count := l_ue_count + 1;
9769: l_unit_effectivity_tbl(l_ue_count).unit_effectivity_id := l_unit_effectivity_id;

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

9776: OPEN get_ue_details(parent_csr.ue_id);
9777: FETCH get_ue_details INTO l_ovn;
9778: CLOSE get_ue_details;
9779:
9780: l_status_code := AHL_COMPLETIONS_PVT.get_mr_status( parent_csr.ue_id );
9781:
9782: -- UEs can be cancelled only if all it's WOs are cancelled
9783: IF ( l_status_code = G_MR_STATUS_JOBS_CANCELLED ) THEN
9784: l_ue_count := l_ue_count + 1;