APPS.AHL_OSP_PO_PVT dependencies on DUAL

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

1036: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1037: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure. Operating Unit = ' || MO_GLOBAL.get_current_org_id());
1038: END IF;
1039:
1040: -- No need of a Savepoint: Individual procedures commit or rollback
1041: -- within themselves.
1042: -- Standard start of API savepoint
1043: --SAVEPOINT PO_Synch_All_OSPs_pvt;
1044:

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

1186: RAISE FND_API.G_EXC_ERROR; --Note that commit might already have taken place
1187: END IF;
1188:
1189: -- Standard check of p_commit
1190: -- No need to commit: Individual procedures commit or rollback
1191: -- within themselves.
1192: -- IF FND_API.TO_BOOLEAN(p_commit) THEN
1193: -- COMMIT WORK; --Note that commit might already have taken place
1194: -- END IF;

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

1205: END IF;
1206:
1207: EXCEPTION
1208: WHEN FND_API.G_EXC_ERROR THEN
1209: -- No need to rollback: Individual procedures commit or rollback
1210: -- within themselves.
1211: -- ROLLBACK TO PO_Synch_All_OSPs_pvt; --Note that commit might already have taken place
1212: x_return_status := FND_API.G_RET_STS_ERROR;
1213: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

1220: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Caught Execution Exception: ' || x_msg_data);
1221: END IF;
1222:
1223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1224: -- No need to rollback: Individual procedures commit or rollback
1225: -- within themselves.
1226: -- ROLLBACK TO PO_Synch_All_OSPs_pvt; --Note that commit might already have taken place
1227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1228: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

1235: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Caught Unexpected Exception: ' || x_msg_data);
1236: END IF;
1237:
1238: WHEN OTHERS THEN
1239: -- No need to rollback: Individual procedures commit or rollback
1240: -- within themselves.
1241: -- ROLLBACK TO PO_Synch_All_OSPs_pvt; --Note that commit might already have taken place
1242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1243: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

1725: -- Instead, hard code it to the OSP Order Id
1726: l_batch_id := p_po_header_rec.OSP_ORDER_ID;
1727:
1728: -- Generate PO Header Id
1729: SELECT PO_HEADERS_INTERFACE_S.NEXTVAL INTO l_intf_hdr_id FROM sys.dual;
1730:
1731: -- Description
1732: OPEN l_get_osp_order_dtls_csr(p_po_header_rec.OSP_ORDER_ID);
1733: FETCH l_get_osp_order_dtls_csr INTO l_temp_n, l_OSP_description;

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

1904: END IF;
1905:
1906: -- Added by jaramana on Nov 28, 2005 for ER 4736326
1907: -- Generate PO Line Interface Id
1908: SELECT PO_LINES_INTERFACE_S.NEXTVAL INTO l_intf_line_id FROM sys.dual;
1909: -- Insert row into PO_LINES_INTERFACE
1910: INSERT INTO PO_LINES_INTERFACE (
1911: INTERFACE_LINE_ID,
1912: INTERFACE_HEADER_ID,