APPS.OE_ORDER_PURGE_PVT dependencies on OE_PURGE_ORDERS

Line 1462: INSERT INTO OE_PURGE_ORDERS

1458: OE_DEBUG_PUB.Add(l_error_message);
1459: l_is_purgable := 'N';
1460: END IF;
1461:
1462: INSERT INTO OE_PURGE_ORDERS
1463: ( PURGE_SET_ID,
1464: HEADER_ID,
1465: ORDER_NUMBER,
1466: QUOTE_NUMBER,

Line 1537: FROM oe_purge_orders

1533: l_savepoint_est VARCHAR2(1) := 'N';
1534:
1535: CURSOR c_purge_orders IS
1536: SELECT header_id
1537: FROM oe_purge_orders
1538: Where purge_set_id = p_purge_set_id
1539: AND NVL(is_purgable,'N') = 'Y'
1540: AND NVL(is_purged,'N') = 'N';
1541:

Line 1544: FROM oe_purge_orders

1540: AND NVL(is_purged,'N') = 'N';
1541:
1542: CURSOR cur_logged_in_user IS
1543: SELECT created_by
1544: FROM oe_purge_orders
1545: WHERE purge_set_id = p_purge_set_id;
1546:
1547: l_created_by oe_purge_sets.created_by%type;
1548: BEGIN

Line 1603: FROM oe_purge_orders

1599:
1600: --added for bug 3680441
1601: SELECT count(*)
1602: INTO l_number_of_orders
1603: FROM oe_purge_orders
1604: where purge_set_id = p_purge_set_id;
1605:
1606: OPEN c_purge_orders;
1607:

Line 1627: oe_debug_pub.add('Returned from oe_purge_orders : '||l_return_status);

1623: (p_purge_set_id,
1624: l_header_id,
1625: l_return_status);
1626:
1627: oe_debug_pub.add('Returned from oe_purge_orders : '||l_return_status);
1628:
1629: EXCEPTION
1630: WHEN OTHERS THEN
1631: NULL;

Line 1654: UPDATE OE_PURGE_ORDERS

1650: END;
1651:
1652: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1653:
1654: UPDATE OE_PURGE_ORDERS
1655: SET IS_PURGED = 'Y'
1656: WHERE purge_set_id = p_purge_set_id
1657: AND header_id = l_header_id
1658: AND created_by = fnd_global.user_id;

Line 1742: FROM OE_PURGE_ORDERS

1738: WHERE purge_set_id = p_purge_set_id;
1739:
1740: Cursor c_purge_orders IS
1741: SELECT IS_PURGED
1742: FROM OE_PURGE_ORDERS
1743: WHERE PURGE_SET_ID = p_purge_set_id
1744: AND NVL(IS_PURGED,'N') = 'Y';
1745:
1746: l_purge_set_purged VARCHAR2(1) := NULL;

Line 1778: DELETE FROM OE_PURGE_ORDERS

1774: RETURN;
1775:
1776: END LOOP;
1777:
1778: DELETE FROM OE_PURGE_ORDERS
1779: WHERE purge_set_id = p_purge_set_id;
1780:
1781: IF SQLCODE = 0 THEN
1782: DELETE FROM OE_PURGE_SETS

Line 3531: UPDATE oe_purge_orders

3527:
3528: BEGIN
3529:
3530: oe_debug_pub.add('Error Message : '||p_error_message);
3531: UPDATE oe_purge_orders
3532: SET ERROR_TEXT = p_error_message
3533: ,IS_PURGED = 'N'
3534: WHERE purge_set_id = p_purge_set_id
3535: AND header_id = p_header_id;