APPS.OE_ORDER_PURGE_PVT dependencies on OE_PURGE_SETS

Line 33: From OE_PURGE_SETS

29: Select selected_ids
30: , Count_Selected
31: ,purge_set_submit_datetime
32: , orders_per_commit
33: From OE_PURGE_SETS
34: Where Purge_set_id = p_purge_set_id;
35:
36: BEGIN
37:

Line 566: UPDATE OE_PURGE_SETS

562:
563: DBMS_SQL.CLOSE_CURSOR(l_sql_cursor);
564: OE_DEBUG_PUB.Add('before update='|| l_purge_set_id);
565:
566: UPDATE OE_PURGE_SETS
567: SET purge_processed = 'Y'
568: WHERE purge_set_id = l_purge_set_id;
569:
570: COMMIT;

Line 1043: UPDATE OE_PURGE_SETS

1039: IF l_debug_level > 0 THEN
1040: OE_DEBUG_PUB.Add('before update='|| l_purge_set_id);
1041: END IF;
1042:
1043: UPDATE OE_PURGE_SETS
1044: SET purge_processed = 'Y'
1045: WHERE purge_set_id = l_purge_set_id;
1046:
1047: COMMIT;

Line 1164: UPDATE OE_PURGE_SETS

1160:
1161:
1162: OE_DEBUG_PUB.Add('before update='|| p_purge_set_id);
1163:
1164: UPDATE OE_PURGE_SETS
1165: SET purge_processed = 'Y'
1166: WHERE purge_set_id = p_purge_set_id;
1167:
1168: COMMIT;

Line 1206: SELECT OE_PURGE_SETS_S.NEXTVAL

1202: BEGIN
1203:
1204: oe_debug_pub.add('Entering OE_Order_Purge_PVT.Insert_Purge_Set : '||p_purge_set_name,1);
1205:
1206: SELECT OE_PURGE_SETS_S.NEXTVAL
1207: INTO l_purge_set_id
1208: FROM DUAL;
1209:
1210: l_orders_per_commit := FND_PROFILE.VALUE('OM_ORDERS_PURGE_PER_COMMIT');

Line 1212: INSERT INTO OE_PURGE_SETS

1208: FROM DUAL;
1209:
1210: l_orders_per_commit := FND_PROFILE.VALUE('OM_ORDERS_PURGE_PER_COMMIT');
1211:
1212: INSERT INTO OE_PURGE_SETS
1213: ( PURGE_SET_ID
1214: , PURGE_SET_NAME
1215: , PURGE_SET_DESCRIPTION
1216: , PURGE_SET_REQUEST_ID

Line 1254: FROM OE_PURGE_SETS

1250: IF p_count_selected <> 0 THEN
1251:
1252: SELECT SELECTED_IDS
1253: INTO l_selected_ids
1254: FROM OE_PURGE_SETS
1255: WHERE PURGE_SET_ID = l_purge_set_id;
1256:
1257: DBMS_LOB.OPEN(l_selected_ids,DBMS_LOB.LOB_READWRITE);
1258:

Line 1532: l_purge_set_name OE_PURGE_SETS.PURGE_SET_NAME%TYPE;

1528: l_orders_per_commit NUMBER;
1529: l_number_of_orders NUMBER := 0; --added for bug 3680441
1530: l_purged_success NUMBER := 0; --added for bug 3680441
1531: l_purge_failure NUMBER := 0; --added for bug 3680441
1532: l_purge_set_name OE_PURGE_SETS.PURGE_SET_NAME%TYPE;
1533: l_savepoint_est VARCHAR2(1) := 'N';
1534:
1535: CURSOR c_purge_orders IS
1536: SELECT header_id

Line 1547: l_created_by oe_purge_sets.created_by%type;

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
1549:
1550: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.Submit_Purge : '||to_char(p_purge_set_id));
1551: fnd_file.put_line(FND_FILE.LOG,'Parameters :');

Line 1570: FROM OE_PURGE_SETS

1566:
1567:
1568: SELECT orders_per_commit, purge_set_name
1569: INTO l_orders_per_commit, l_purge_set_name
1570: FROM OE_PURGE_SETS
1571: WHERE purge_set_id = p_purge_set_id
1572: AND created_by = fnd_global.user_id;
1573:
1574: IF nvl(l_orders_per_commit,0) = 0 THEN

Line 1678: UPDATE OE_PURGE_SETS

1674:
1675: CLOSE c_purge_orders;
1676: oe_debug_pub.add('before setting purge_Set_purge');
1677:
1678: UPDATE OE_PURGE_SETS
1679: SET PURGE_SET_PURGED = 'Y',
1680: LAST_UPDATE_DATE = SYSDATE,
1681: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1682: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 1737: FROM OE_PURGE_SETS

1733:
1734: Cursor c_purge_set is
1735: SELECT PURGE_SET_NAME,
1736: PURGE_SET_PURGED
1737: FROM OE_PURGE_SETS
1738: WHERE purge_set_id = p_purge_set_id;
1739:
1740: Cursor c_purge_orders IS
1741: SELECT IS_PURGED

Line 1782: DELETE FROM OE_PURGE_SETS

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
1783: WHERE purge_set_id = p_purge_set_id;
1784: END IF;
1785:
1786: END IF;