APPS.AHL_OSP_PO_PVT dependencies on DUAL

Line 1032: -- No need of a Savepoint: Individual procedures commit or rollback

1028: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1029: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure. Operating Unit = ' || MO_GLOBAL.get_current_org_id());
1030: END IF;
1031:
1032: -- No need of a Savepoint: Individual procedures commit or rollback
1033: -- within themselves.
1034: -- Standard start of API savepoint
1035: --SAVEPOINT PO_Synch_All_OSPs_pvt;
1036:

Line 1182: -- No need to commit: Individual procedures commit or rollback

1178: RAISE FND_API.G_EXC_ERROR; --Note that commit might already have taken place
1179: END IF;
1180:
1181: -- Standard check of p_commit
1182: -- No need to commit: Individual procedures commit or rollback
1183: -- within themselves.
1184: -- IF FND_API.TO_BOOLEAN(p_commit) THEN
1185: -- COMMIT WORK; --Note that commit might already have taken place
1186: -- END IF;

Line 1201: -- No need to rollback: Individual procedures commit or rollback

1197: END IF;
1198:
1199: EXCEPTION
1200: WHEN FND_API.G_EXC_ERROR THEN
1201: -- No need to rollback: Individual procedures commit or rollback
1202: -- within themselves.
1203: -- ROLLBACK TO PO_Synch_All_OSPs_pvt; --Note that commit might already have taken place
1204: x_return_status := FND_API.G_RET_STS_ERROR;
1205: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 1216: -- No need to rollback: Individual procedures commit or rollback

1212: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Caught Execution Exception: ' || x_msg_data);
1213: END IF;
1214:
1215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1216: -- No need to rollback: Individual procedures commit or rollback
1217: -- within themselves.
1218: -- ROLLBACK TO PO_Synch_All_OSPs_pvt; --Note that commit might already have taken place
1219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1220: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 1231: -- No need to rollback: Individual procedures commit or rollback

1227: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Caught Unexpected Exception: ' || x_msg_data);
1228: END IF;
1229:
1230: WHEN OTHERS THEN
1231: -- No need to rollback: Individual procedures commit or rollback
1232: -- within themselves.
1233: -- ROLLBACK TO PO_Synch_All_OSPs_pvt; --Note that commit might already have taken place
1234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1235: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1720: SELECT PO_HEADERS_INTERFACE_S.NEXTVAL INTO l_intf_hdr_id FROM sys.dual;

1716: -- Instead, hard code it to the OSP Order Id
1717: l_batch_id := p_po_header_rec.OSP_ORDER_ID;
1718:
1719: -- Generate PO Header Id
1720: SELECT PO_HEADERS_INTERFACE_S.NEXTVAL INTO l_intf_hdr_id FROM sys.dual;
1721:
1722: -- Description
1723: OPEN l_get_osp_order_dtls_csr(p_po_header_rec.OSP_ORDER_ID);
1724: FETCH l_get_osp_order_dtls_csr INTO l_temp_n, l_OSP_description;

Line 1894: SELECT PO_LINES_INTERFACE_S.NEXTVAL INTO l_intf_line_id FROM sys.dual;

1890: END IF;
1891:
1892: -- Added by jaramana on Nov 28, 2005 for ER 4736326
1893: -- Generate PO Line Interface Id
1894: SELECT PO_LINES_INTERFACE_S.NEXTVAL INTO l_intf_line_id FROM sys.dual;
1895: -- Insert row into PO_LINES_INTERFACE
1896: INSERT INTO PO_LINES_INTERFACE (
1897: INTERFACE_LINE_ID,
1898: INTERFACE_HEADER_ID,