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 1083: -- cursor to select from oe_order_header_history

1079: FROM oe_order_headers_all ooh
1080: WHERE (ooh.payment_type_code = 'CREDIT_CARD' AND ooh.credit_card_number IS NOT NULL)
1081: AND ooh.rowid BETWEEN p_start_rowid AND p_end_rowid ;
1082:
1083: -- cursor to select from oe_order_header_history
1084: CURSOR hist_payments_cur (p_start_rowid ROWID, p_end_rowid ROWID) is
1085: SELECT oohh.header_id, oohh.rowid
1086: FROM oe_order_header_history oohh
1087: WHERE oohh.payment_type_code = 'CREDIT_CARD'

Line 1086: FROM oe_order_header_history oohh

1082:
1083: -- cursor to select from oe_order_header_history
1084: CURSOR hist_payments_cur (p_start_rowid ROWID, p_end_rowid ROWID) is
1085: SELECT oohh.header_id, oohh.rowid
1086: FROM oe_order_header_history oohh
1087: WHERE oohh.payment_type_code = 'CREDIT_CARD'
1088: AND oohh.credit_card_number is not null
1089: AND oohh.credit_card_number <> '****'
1090: AND oohh.instrument_id is not null

Line 1186: FROM oe_order_header_history

1182:
1183: BEGIN
1184: SELECT 'Y'
1185: INTO l_exists_history
1186: FROM oe_order_header_history
1187: WHERE payment_type_code = 'CREDIT_CARD'
1188: AND instrument_id IS NULL
1189: AND ROWNUM = 1 ;
1190: EXCEPTION

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

1190: EXCEPTION
1191: WHEN NO_DATA_FOUND THEN
1192: IF l_debug_level > 0 THEN
1193: oe_debug_pub.add('') ;
1194: oe_debug_pub.add('No record found from OE_ORDER_HEADER_HISTORY table for Worker Id : ' || X_worker_id) ;
1195: END IF;
1196:
1197: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_ORDER_HEADER_HISTORY table for Worker Id : ' || X_worker_id) ;
1198: END;

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

1193: oe_debug_pub.add('') ;
1194: oe_debug_pub.add('No record found from OE_ORDER_HEADER_HISTORY table for Worker Id : ' || X_worker_id) ;
1195: END IF;
1196:
1197: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_ORDER_HEADER_HISTORY table for Worker Id : ' || X_worker_id) ;
1198: END;
1199:
1200: IF l_exists_header = 'Y' OR l_exists_payment = 'Y' OR l_exists_history = 'Y' THEN
1201: IF l_debug_level > 0 THEN

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

1201: IF l_debug_level > 0 THEN
1202: oe_debug_pub.add('') ;
1203: oe_debug_pub.add('Data NOT migrated from OE_ORDER_HEADERS_ALL table (Y/N) : ' || l_exists_header) ;
1204: oe_debug_pub.add('Data NOT migrated from OE_PAYMENTS table (Y/N) : ' || l_exists_payment) ;
1205: oe_debug_pub.add('Data NOT migrated from OE_ORDER_HEADER_HISTORY table (Y/N) : ' || l_exists_history) ;
1206: oe_debug_pub.add('Please migrate the data before proceeding to purge secured payment data') ;
1207: END IF;
1208:
1209: fnd_file.put_line(FND_FILE.OUTPUT, 'Data NOT migrated from OE_ORDER_HEADERS_ALL table (Y/N) : ' || l_exists_header) ;

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

1207: END IF;
1208:
1209: fnd_file.put_line(FND_FILE.OUTPUT, 'Data NOT migrated from OE_ORDER_HEADERS_ALL table (Y/N) : ' || l_exists_header) ;
1210: fnd_file.put_line(FND_FILE.OUTPUT, 'Data NOT migrated from OE_PAYMENTS table (Y/N) : ' || l_exists_payment) ;
1211: fnd_file.put_line(FND_FILE.OUTPUT, 'Data NOT migrated from OE_ORDER_HEADER_HISTORY table (Y/N) : ' || l_exists_history) ;
1212: fnd_file.put_line(FND_FILE.OUTPUT, 'Please migrate the data before proceeding to purge secured payment data') ;
1213:
1214: RETURN ;
1215: END IF ;

Line 1446: -- start processing oe_order_header_history

1442: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_ORDER_HEADERS_ALL table for Worker Id : ' || X_worker_id) ;
1443: END ;
1444:
1445:
1446: -- start processing oe_order_header_history
1447: BEGIN
1448: -----------------------------------------------------------
1449: -- Fetching records from OE_ORDER_HEADERS_HISTORY table
1450: -----------------------------------------------------------

Line 1451: l_table_name := 'OE_ORDER_HEADER_HISTORY' ;

1447: BEGIN
1448: -----------------------------------------------------------
1449: -- Fetching records from OE_ORDER_HEADERS_HISTORY table
1450: -----------------------------------------------------------
1451: l_table_name := 'OE_ORDER_HEADER_HISTORY' ;
1452:
1453: ad_parallel_updates_pkg.delete_update_information(
1454: 0,
1455: l_table_owner,

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

1472: X_batch_size,
1473: TRUE) ;
1474:
1475: fnd_file.put_line(FND_FILE.OUTPUT, '');
1476: fnd_file.put_line(FND_FILE.OUTPUT, 'Process starting from OE_ORDER_HEADER_HISTORY table');
1477:
1478: IF l_debug_level > 0 THEN
1479: oe_debug_pub.add('') ;
1480: oe_debug_pub.add('AD parallel details : ') ;

Line 1510: UPDATE oe_order_header_history

1506:
1507: IF row_id_tab.count > 0 THEN
1508: BEGIN
1509: FORALL i in row_id_tab.FIRST..row_id_tab.LAST SAVE EXCEPTIONS
1510: UPDATE oe_order_header_history
1511: SET credit_card_number = '****',
1512: credit_card_holder_name = '****',
1513: credit_card_expiration_date = sysdate,
1514: credit_card_code = '****',

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

1527: ' Oracle error is ' ||
1528: SQL%BULK_EXCEPTIONS(j).ERROR_CODE );
1529:
1530: fnd_file.put_line(FND_FILE.OUTPUT,
1531: 'Update failing at OE_ORDER_HEADER_HISTORY from HIST_PAYMENTS_CUR ' ||
1532: header_id_tab(j));
1533: END LOOP;
1534: END;
1535:

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

1553: END LOOP ;
1554:
1555: IF l_debug_level > 0 THEN
1556: oe_debug_pub.add('Total No of records processed successfully : ' || l_process_total1) ;
1557: oe_debug_pub.add('Total No of records errored in OE_ORDER_HEADER_HISTORY : ' || l_error_total1) ;
1558: END IF;
1559:
1560: fnd_file.put_line(FND_FILE.OUTPUT, 'Process ending from OE_ORDER_HEADER_HISTORY table');
1561:

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

1556: oe_debug_pub.add('Total No of records processed successfully : ' || l_process_total1) ;
1557: oe_debug_pub.add('Total No of records errored in OE_ORDER_HEADER_HISTORY : ' || l_error_total1) ;
1558: END IF;
1559:
1560: fnd_file.put_line(FND_FILE.OUTPUT, 'Process ending from OE_ORDER_HEADER_HISTORY table');
1561:
1562: EXCEPTION
1563: WHEN NO_DATA_FOUND THEN
1564: IF l_debug_level > 0 THEN

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

1562: EXCEPTION
1563: WHEN NO_DATA_FOUND THEN
1564: IF l_debug_level > 0 THEN
1565: oe_debug_pub.add('') ;
1566: oe_debug_pub.add('No record found from OE_ORDER_HEADER_HISTORY table for Worker Id : ' || X_worker_id) ;
1567: END IF;
1568:
1569: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_ORDER_HEADER_HISTORY table for Worker Id : ' || X_worker_id) ;
1570: END ;

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

1565: oe_debug_pub.add('') ;
1566: oe_debug_pub.add('No record found from OE_ORDER_HEADER_HISTORY table for Worker Id : ' || X_worker_id) ;
1567: END IF;
1568:
1569: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_ORDER_HEADER_HISTORY table for Worker Id : ' || X_worker_id) ;
1570: END ;
1571: -- end of processsing oe_order_header_history
1572:
1573: COMMIT ;

Line 1571: -- end of processsing oe_order_header_history

1567: END IF;
1568:
1569: fnd_file.put_line(FND_FILE.OUTPUT, 'No record found from OE_ORDER_HEADER_HISTORY table for Worker Id : ' || X_worker_id) ;
1570: END ;
1571: -- end of processsing oe_order_header_history
1572:
1573: COMMIT ;
1574:
1575: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;