eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_PAYMENT_DATA_MIGRATION_UTIL dependencies on OE_ORDER_HEADER_HISTORY

Line 1122: -- cursor to select from oe_order_header_history

1118: FROM oe_order_headers_all ooh
1119: WHERE (ooh.payment_type_code = 'CREDIT_CARD' AND ooh.credit_card_number IS NOT NULL)
1120: AND ooh.rowid BETWEEN p_start_rowid AND p_end_rowid ;
1121:
1122: -- cursor to select from oe_order_header_history
1123: CURSOR hist_payments_cur (p_start_rowid ROWID, p_end_rowid ROWID) is
1124: SELECT oohh.header_id, oohh.rowid
1125: FROM oe_order_header_history oohh
1126: WHERE oohh.payment_type_code = 'CREDIT_CARD'

Line 1125: FROM oe_order_header_history oohh

1121:
1122: -- cursor to select from oe_order_header_history
1123: CURSOR hist_payments_cur (p_start_rowid ROWID, p_end_rowid ROWID) is
1124: SELECT oohh.header_id, oohh.rowid
1125: FROM oe_order_header_history oohh
1126: WHERE oohh.payment_type_code = 'CREDIT_CARD'
1127: AND oohh.credit_card_number is not null
1128: AND oohh.credit_card_number <> '****'
1129: AND oohh.instrument_id is not null

Line 1225: FROM oe_order_header_history

1221:
1222: BEGIN
1223: SELECT 'Y'
1224: INTO l_exists_history
1225: FROM oe_order_header_history
1226: WHERE payment_type_code = 'CREDIT_CARD'
1227: AND instrument_id IS NULL
1228: AND ROWNUM = 1 ;
1229: EXCEPTION

Line 1233: oe_debug_pub.add('No record found from OE_ORDER_HEADER_HISTORY table for Worker Id : ' || X_worker_id) ;

1229: EXCEPTION
1230: WHEN NO_DATA_FOUND THEN
1231: IF l_debug_level > 0 THEN
1232: oe_debug_pub.add('') ;
1233: oe_debug_pub.add('No record found from OE_ORDER_HEADER_HISTORY table for Worker Id : ' || X_worker_id) ;
1234: END IF;
1235:
1236: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_ORDER_HEADER_HISTORY table for Worker Id : ' || X_worker_id) ;
1237: END;

Line 1236: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_ORDER_HEADER_HISTORY table for Worker Id : ' || X_worker_id) ;

1232: oe_debug_pub.add('') ;
1233: oe_debug_pub.add('No record found from OE_ORDER_HEADER_HISTORY table for Worker Id : ' || X_worker_id) ;
1234: END IF;
1235:
1236: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_ORDER_HEADER_HISTORY table for Worker Id : ' || X_worker_id) ;
1237: END;
1238:
1239: IF l_exists_header = 'Y' OR l_exists_payment = 'Y' OR l_exists_history = 'Y' THEN
1240: IF l_debug_level > 0 THEN

Line 1244: oe_debug_pub.add('Data NOT migrated from OE_ORDER_HEADER_HISTORY table (Y/N) : ' || l_exists_history) ;

1240: IF l_debug_level > 0 THEN
1241: oe_debug_pub.add('') ;
1242: oe_debug_pub.add('Data NOT migrated from OE_ORDER_HEADERS_ALL table (Y/N) : ' || l_exists_header) ;
1243: oe_debug_pub.add('Data NOT migrated from OE_PAYMENTS table (Y/N) : ' || l_exists_payment) ;
1244: oe_debug_pub.add('Data NOT migrated from OE_ORDER_HEADER_HISTORY table (Y/N) : ' || l_exists_history) ;
1245: oe_debug_pub.add('Please migrate the data before proceeding to purge secured payment data') ;
1246: END IF;
1247:
1248: fnd_file.put_line(FND_FILE.OUTPUT, 'Data NOT migrated from OE_ORDER_HEADERS_ALL table (Y/N) : ' || l_exists_header) ;

Line 1250: fnd_file.put_line(FND_FILE.OUTPUT, 'Data NOT migrated from OE_ORDER_HEADER_HISTORY table (Y/N) : ' || l_exists_history) ;

1246: END IF;
1247:
1248: fnd_file.put_line(FND_FILE.OUTPUT, 'Data NOT migrated from OE_ORDER_HEADERS_ALL table (Y/N) : ' || l_exists_header) ;
1249: fnd_file.put_line(FND_FILE.OUTPUT, 'Data NOT migrated from OE_PAYMENTS table (Y/N) : ' || l_exists_payment) ;
1250: fnd_file.put_line(FND_FILE.OUTPUT, 'Data NOT migrated from OE_ORDER_HEADER_HISTORY table (Y/N) : ' || l_exists_history) ;
1251: fnd_file.put_line(FND_FILE.OUTPUT, 'Please migrate the data before proceeding to purge secured payment data') ;
1252:
1253: RETURN ;
1254: END IF ;

Line 1485: -- start processing oe_order_header_history

1481: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_ORDER_HEADERS_ALL table for Worker Id : ' || X_worker_id) ;
1482: END ;
1483:
1484:
1485: -- start processing oe_order_header_history
1486: BEGIN
1487: -----------------------------------------------------------
1488: -- Fetching records from OE_ORDER_HEADERS_HISTORY table
1489: -----------------------------------------------------------

Line 1490: l_table_name := 'OE_ORDER_HEADER_HISTORY' ;

1486: BEGIN
1487: -----------------------------------------------------------
1488: -- Fetching records from OE_ORDER_HEADERS_HISTORY table
1489: -----------------------------------------------------------
1490: l_table_name := 'OE_ORDER_HEADER_HISTORY' ;
1491:
1492: ad_parallel_updates_pkg.delete_update_information(
1493: 0,
1494: l_table_owner,

Line 1515: fnd_file.put_line(FND_FILE.OUTPUT, 'Process starting from OE_ORDER_HEADER_HISTORY table');

1511: X_batch_size,
1512: TRUE) ;
1513:
1514: fnd_file.put_line(FND_FILE.OUTPUT, '');
1515: fnd_file.put_line(FND_FILE.OUTPUT, 'Process starting from OE_ORDER_HEADER_HISTORY table');
1516:
1517: IF l_debug_level > 0 THEN
1518: oe_debug_pub.add('') ;
1519: oe_debug_pub.add('AD parallel details : ') ;

Line 1549: UPDATE oe_order_header_history

1545:
1546: IF row_id_tab.count > 0 THEN
1547: BEGIN
1548: FORALL i in row_id_tab.FIRST..row_id_tab.LAST SAVE EXCEPTIONS
1549: UPDATE oe_order_header_history
1550: SET credit_card_number = '****',
1551: credit_card_holder_name = '****',
1552: credit_card_expiration_date = sysdate,
1553: credit_card_code = '****',

Line 1570: 'Update failing at OE_ORDER_HEADER_HISTORY from HIST_PAYMENTS_CUR ' ||

1566: ' Oracle error is ' ||
1567: SQL%BULK_EXCEPTIONS(j).ERROR_CODE );
1568:
1569: fnd_file.put_line(FND_FILE.OUTPUT,
1570: 'Update failing at OE_ORDER_HEADER_HISTORY from HIST_PAYMENTS_CUR ' ||
1571: header_id_tab(j));
1572: END LOOP;
1573: END;
1574:

Line 1596: oe_debug_pub.add('Total No of records errored in OE_ORDER_HEADER_HISTORY : ' || l_error_total1) ;

1592: END LOOP ;
1593:
1594: IF l_debug_level > 0 THEN
1595: oe_debug_pub.add('Total No of records processed successfully : ' || l_process_total1) ;
1596: oe_debug_pub.add('Total No of records errored in OE_ORDER_HEADER_HISTORY : ' || l_error_total1) ;
1597: END IF;
1598:
1599: fnd_file.put_line(FND_FILE.OUTPUT, 'Process ending from OE_ORDER_HEADER_HISTORY table');
1600:

Line 1599: fnd_file.put_line(FND_FILE.OUTPUT, 'Process ending from OE_ORDER_HEADER_HISTORY table');

1595: oe_debug_pub.add('Total No of records processed successfully : ' || l_process_total1) ;
1596: oe_debug_pub.add('Total No of records errored in OE_ORDER_HEADER_HISTORY : ' || l_error_total1) ;
1597: END IF;
1598:
1599: fnd_file.put_line(FND_FILE.OUTPUT, 'Process ending from OE_ORDER_HEADER_HISTORY table');
1600:
1601: EXCEPTION
1602: WHEN NO_DATA_FOUND THEN
1603: IF l_debug_level > 0 THEN

Line 1605: oe_debug_pub.add('No record found from OE_ORDER_HEADER_HISTORY table for Worker Id : ' || X_worker_id) ;

1601: EXCEPTION
1602: WHEN NO_DATA_FOUND THEN
1603: IF l_debug_level > 0 THEN
1604: oe_debug_pub.add('') ;
1605: oe_debug_pub.add('No record found from OE_ORDER_HEADER_HISTORY table for Worker Id : ' || X_worker_id) ;
1606: END IF;
1607:
1608: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_ORDER_HEADER_HISTORY table for Worker Id : ' || X_worker_id) ;
1609: END ;

Line 1608: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_ORDER_HEADER_HISTORY table for Worker Id : ' || X_worker_id) ;

1604: oe_debug_pub.add('') ;
1605: oe_debug_pub.add('No record found from OE_ORDER_HEADER_HISTORY table for Worker Id : ' || X_worker_id) ;
1606: END IF;
1607:
1608: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_ORDER_HEADER_HISTORY table for Worker Id : ' || X_worker_id) ;
1609: END ;
1610: -- end of processsing oe_order_header_history
1611:
1612: COMMIT ;

Line 1610: -- end of processsing oe_order_header_history

1606: END IF;
1607:
1608: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_ORDER_HEADER_HISTORY table for Worker Id : ' || X_worker_id) ;
1609: END ;
1610: -- end of processsing oe_order_header_history
1611:
1612: COMMIT ;
1613:
1614: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;