APPS.AHL_PRD_WO_PUB dependencies on AHL_PRD_WORKORDER_PVT

Line 1489: l_trunover_notes_tbl AHL_PRD_WORKORDER_PVT.turnover_notes_tbl_type;

1485: x_return_status OUT NOCOPY VARCHAR2,
1486: x_msg_count OUT NOCOPY NUMBER,
1487: x_msg_data OUT NOCOPY VARCHAR2
1488: )IS
1489: l_trunover_notes_tbl AHL_PRD_WORKORDER_PVT.turnover_notes_tbl_type;
1490: j INTEGER;
1491: BEGIN
1492: x_return_status := FND_API.G_RET_STS_SUCCESS;
1493: IF(p_TurnoverNotes IS NULL OR p_TurnoverNotes.COUNT < 1)THEN

Line 1517: AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES

1513: FND_MSG_PUB.ADD;
1514: RAISE FND_API.G_EXC_ERROR;
1515: END IF;
1516:
1517: AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES
1518: (
1519: p_api_version => 1.0 ,
1520: p_init_msg_list => FND_API.G_TRUE,
1521: p_commit => FND_API.G_FALSE,

Line 1545: l_prd_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;

1541: x_msg_count OUT NOCOPY NUMBER,
1542: x_msg_data OUT NOCOPY VARCHAR2
1543: )IS
1544:
1545: l_prd_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;
1546: l_prd_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;
1547:
1548: CURSOR get_status_csr(status VARCHAR)
1549: IS

Line 1546: l_prd_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;

1542: x_msg_data OUT NOCOPY VARCHAR2
1543: )IS
1544:
1545: l_prd_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;
1546: l_prd_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;
1547:
1548: CURSOR get_status_csr(status VARCHAR)
1549: IS
1550: SELECT lookup_code

Line 1608: AHL_PRD_WORKORDER_PVT.release_visit_jobs

1604: END IF;
1605:
1606: IF(l_status_code = '3' AND p_CURR_WO_DETAILS_REC.StatusCode = '1')THEN
1607: --release Job
1608: AHL_PRD_WORKORDER_PVT.release_visit_jobs
1609: (
1610: p_api_version => 1.0 ,
1611: p_init_msg_list => FND_API.G_TRUE,
1612: p_commit => FND_API.G_FALSE,

Line 1625: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs

1621: p_workorder_id => p_CURR_WO_DETAILS_REC.WorkorderId
1622: );
1623: ELSIF(l_status_code = '7')THEN
1624: --cancel job
1625: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs
1626: (
1627: p_api_version => 1.0 ,
1628: p_init_msg_list => FND_API.G_TRUE,
1629: p_commit => FND_API.G_FALSE,

Line 1678: AHL_PRD_WORKORDER_PVT.update_job

1674: l_prd_workorder_rec.ACTUAL_START_DATE := p_WO_DETAILS_REC.ActualStartDate;
1675: l_prd_workorder_rec.ACTUAL_END_DATE := p_WO_DETAILS_REC.ActualEndDate;
1676: --AHL_DEBUG_PUB.debug( 'l_prd_workorder_rec.ACTUAL_START_DATE : '||l_prd_workorder_rec.ACTUAL_START_DATE);
1677: --AHL_DEBUG_PUB.debug( 'l_prd_workorder_rec.ACTUAL_END_DATE : '||l_prd_workorder_rec.ACTUAL_END_DATE);
1678: AHL_PRD_WORKORDER_PVT.update_job
1679: (
1680: p_api_version => 1.0 ,
1681: p_init_msg_list => FND_API.G_TRUE,
1682: p_commit => FND_API.G_FALSE,