DBA Data[Home] [Help]

APPS.AHL_OSP_ORDERS_PVT dependencies on AHL_OSP_ORDER_LINES_PKG

Line 3540: AHL_OSP_ORDER_LINES_PKG.delete_row(p_x_osp_order_lines_tbl(i).osp_order_line_id);

3536: END IF;
3537:
3538: --Delete OSP line record first (it makes more sense to delete shipment lines first, but
3539: --here just keep it the same as the old logic).
3540: AHL_OSP_ORDER_LINES_PKG.delete_row(p_x_osp_order_lines_tbl(i).osp_order_line_id);
3541:
3542: --Delete or cancel shipment lines
3543: delete_cancel_so(
3544: p_oe_header_id => NULL,

Line 3686: AHL_OSP_ORDER_LINES_PKG.delete_row(l_get_order_lines.osp_order_line_id);

3682: END IF;
3683:
3684: --Delete OSP order lines
3685: FOR l_get_order_lines IN get_order_lines(p_x_osp_order_rec.osp_order_id) LOOP
3686: AHL_OSP_ORDER_LINES_PKG.delete_row(l_get_order_lines.osp_order_line_id);
3687: END LOOP;
3688:
3689: --Delete OSP order header record
3690: AHL_OSP_ORDERS_PKG.delete_row(x_osp_order_id => p_x_osp_order_rec.osp_order_id);

Line 3746: AHL_OSP_ORDER_LINES_PKG.delete_row(p_x_osp_order_lines_tbl(i).osp_order_line_id);

3742: END IF;
3743:
3744: --Delete line record first (it makes more sense to delete shipment lines first, but
3745: --here just keep it the same as the old logic.
3746: AHL_OSP_ORDER_LINES_PKG.delete_row(p_x_osp_order_lines_tbl(i).osp_order_line_id);
3747: --Delete or cancel Shipment lines
3748: delete_cancel_so(
3749: p_oe_header_id => NULL,
3750: p_del_cancel_so_lines_tbl => l_del_cancel_so_lines_tbl);

Line 3756: --AHL_OSP_ORDER_LINES_PKG.delete_row(p_x_osp_order_lines_tbl(i).osp_order_line_id);

3752: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_ORD_INVOP');
3753: FND_MSG_PUB.ADD;
3754: RAISE FND_API.G_EXC_ERROR;
3755: END IF;
3756: --AHL_OSP_ORDER_LINES_PKG.delete_row(p_x_osp_order_lines_tbl(i).osp_order_line_id);
3757: ELSIF (p_x_osp_order_lines_tbl(i).operation_flag = G_OP_UPDATE) THEN
3758: --update osp order line
3759: update_osp_order_line(p_x_osp_order_lines_tbl(i));
3760: ELSIF (p_x_osp_order_lines_tbl(i).operation_flag = G_OP_CREATE) THEN

Line 4626: AHL_OSP_ORDER_LINES_PKG.insert_row(

4622: -- bug fix#5376907
4623: -- Service item qty should be the same as physical item qty at the time of creation
4624:
4625: --Call table handler to insert the line
4626: AHL_OSP_ORDER_LINES_PKG.insert_row(
4627: p_x_osp_order_line_id => l_osp_line_id,
4628: p_object_version_number => 1,
4629: p_created_by => fnd_global.user_id,
4630: p_creation_date => SYSDATE,

Line 4693: AHL_OSP_ORDER_LINES_PKG.insert_row(

4689: p_x_osp_order_line_rec.ship_by_date := SYSDATE;
4690: END IF;
4691:
4692: --Call table handler to insert the line
4693: AHL_OSP_ORDER_LINES_PKG.insert_row(
4694: p_x_osp_order_line_id => l_osp_line_id,
4695: p_object_version_number => 1,
4696: p_created_by => fnd_global.user_id,
4697: p_creation_date => SYSDATE,

Line 5523: AHL_OSP_ORDER_LINES_PKG.update_row(

5519: l_service_duration NUMBER;
5520: BEGIN
5521: validate_order_line_update(p_x_osp_order_line_rec);
5522: --call table handler to update the record
5523: AHL_OSP_ORDER_LINES_PKG.update_row(
5524: p_osp_order_line_id => p_x_osp_order_line_rec.osp_order_line_id,
5525: p_object_version_number => p_x_osp_order_line_rec.object_version_number +1,
5526: p_osp_order_id => p_x_osp_order_line_rec.osp_order_id,
5527: p_osp_line_number => p_x_osp_order_line_rec.osp_line_number,

Line 7370: AHL_OSP_ORDER_LINES_PKG.update_row(

7366: l_osp_order_lines_rec.attribute15 ;
7367: IF(l_order_lines_csr %NOTFOUND) THEN
7368: EXIT;
7369: END IF;
7370: AHL_OSP_ORDER_LINES_PKG.update_row(
7371: p_osp_order_line_id => l_osp_order_lines_rec.osp_order_line_id,
7372: p_object_version_number => l_osp_order_lines_rec.object_version_number + 1,
7373: p_last_update_date => l_osp_order_lines_rec.last_update_date,
7374: p_last_updated_by => l_osp_order_lines_rec.last_updated_by,