DBA Data[Home] [Help]

APPS.AHL_PRD_WO_PUB dependencies on AHL_PRD_WORKORDER_PVT

Line 1464: l_trunover_notes_tbl AHL_PRD_WORKORDER_PVT.turnover_notes_tbl_type;

1460: x_return_status OUT NOCOPY VARCHAR2,
1461: x_msg_count OUT NOCOPY NUMBER,
1462: x_msg_data OUT NOCOPY VARCHAR2
1463: )IS
1464: l_trunover_notes_tbl AHL_PRD_WORKORDER_PVT.turnover_notes_tbl_type;
1465: j INTEGER;
1466: BEGIN
1467: x_return_status := FND_API.G_RET_STS_SUCCESS;
1468: IF(p_TurnoverNotes IS NULL OR p_TurnoverNotes.COUNT < 1)THEN

Line 1492: AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES

1488: FND_MSG_PUB.ADD;
1489: RAISE FND_API.G_EXC_ERROR;
1490: END IF;
1491:
1492: AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES
1493: (
1494: p_api_version => 1.0 ,
1495: p_init_msg_list => FND_API.G_TRUE,
1496: p_commit => FND_API.G_FALSE,

Line 1520: l_prd_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;

1516: x_msg_count OUT NOCOPY NUMBER,
1517: x_msg_data OUT NOCOPY VARCHAR2
1518: )IS
1519:
1520: l_prd_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;
1521: l_prd_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;
1522: BEGIN
1523: x_return_status := FND_API.G_RET_STS_SUCCESS;
1524: IF(p_WO_DETAILS_REC.StatusCode IS NULL OR p_WO_DETAILS_REC.StatusCode = p_CURR_WO_DETAILS_REC.StatusCode)THEN

Line 1521: l_prd_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;

1517: x_msg_data OUT NOCOPY VARCHAR2
1518: )IS
1519:
1520: l_prd_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;
1521: l_prd_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;
1522: BEGIN
1523: x_return_status := FND_API.G_RET_STS_SUCCESS;
1524: IF(p_WO_DETAILS_REC.StatusCode IS NULL OR p_WO_DETAILS_REC.StatusCode = p_CURR_WO_DETAILS_REC.StatusCode)THEN
1525: RETURN;--Nothing to do

Line 1534: AHL_PRD_WORKORDER_PVT.release_visit_jobs

1530: RAISE FND_API.G_EXC_ERROR;
1531: END IF;
1532: IF(p_WO_DETAILS_REC.StatusCode = '3' AND p_CURR_WO_DETAILS_REC.StatusCode = '1')THEN
1533: --release Job
1534: AHL_PRD_WORKORDER_PVT.release_visit_jobs
1535: (
1536: p_api_version => 1.0 ,
1537: p_init_msg_list => FND_API.G_TRUE,
1538: p_commit => FND_API.G_FALSE,

Line 1551: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs

1547: p_workorder_id => p_CURR_WO_DETAILS_REC.WorkorderId
1548: );
1549: ELSIF(p_WO_DETAILS_REC.StatusCode = '7')THEN
1550: --cancel job
1551: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs
1552: (
1553: p_api_version => 1.0 ,
1554: p_init_msg_list => FND_API.G_TRUE,
1555: p_commit => FND_API.G_FALSE,

Line 1594: AHL_PRD_WORKORDER_PVT.update_job

1590: l_prd_workorder_rec.OBJECT_VERSION_NUMBER := p_CURR_WO_DETAILS_REC.ObjectVersionNumber;
1591: l_prd_workorder_rec.dml_operation := 'U';
1592: l_prd_workorder_rec.STATUS_CODE := p_WO_DETAILS_REC.StatusCode;
1593: l_prd_workorder_rec.STATUS_MEANING := p_WO_DETAILS_REC.Status;
1594: AHL_PRD_WORKORDER_PVT.update_job
1595: (
1596: p_api_version => 1.0 ,
1597: p_init_msg_list => FND_API.G_TRUE,
1598: p_commit => FND_API.G_FALSE,