DBA Data[Home] [Help]

APPS.AHL_OSP_ORDERS_PVT dependencies on AHL_OSP_ORDERS_PKG

Line 3690: AHL_OSP_ORDERS_PKG.delete_row(x_osp_order_id => p_x_osp_order_rec.osp_order_id);

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);
3691: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3692: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
3693: G_LOG_PREFIX||l_api_name,
3694: 'After deleting header.');

Line 4166: AHL_OSP_ORDERS_PKG.insert_row(

4162:
4163: --In Create mode, assume that UI will never pass G_MISS value(if it is null in UI, then just pass
4164: --Null to the API). Thus in this Create procedure, there are only three attributes probably need
4165: --validation: customer_id, contract_id and contract_terms
4166: AHL_OSP_ORDERS_PKG.insert_row(
4167: x_rowid => l_rowid_dummy,
4168: x_osp_order_id => l_osp_order_id,
4169: x_object_version_number => 1,
4170: x_created_by => FND_GLOBAL.user_id,

Line 4281: AHL_OSP_ORDERS_PKG.update_row(

4277: FETCH get_old_vendor_attrs INTO l_vendor_id, l_vendor_site_id, l_oe_header_id;
4278: CLOSE get_old_vendor_attrs;
4279:
4280: --Call table handler to update
4281: AHL_OSP_ORDERS_PKG.update_row(
4282: x_osp_order_id => p_x_osp_order_rec.osp_order_id,
4283: x_object_version_number => p_x_osp_order_rec.object_version_number + 1,
4284: x_osp_order_number => p_x_osp_order_rec.osp_order_number,
4285: x_order_type_code => p_x_osp_order_rec.order_type_code,