APPS.ASO_PAYMENT_DATA_MIGRATION_PVT dependencies on ASO_PAYMENTS

Line 96: l_table_name VARCHAR2(30) := 'ASO_PAYMENTS';

92: l_industry VARCHAR2(30) ;
93: l_retstatus BOOLEAN ;
94: l_product VARCHAR2(30) := 'ASO' ;
95:
96: l_table_name VARCHAR2(30) := 'ASO_PAYMENTS';
97: l_script_name VARCHAR2(100) := 'asovpdmb'||to_char(sysdate,'ddmonyyyyhhmiss')||'.pls';
98:
99: l_start_rowid ROWID;
100: l_end_rowid ROWID;

Line 166: FROM aso_payments pmt,

162: sec.cc_number_length,
163: sec.cc_unmask_digits,
164: lpad(sec.cc_unmask_digits, nvl(range.card_number_length, length(pmt.payment_ref_number)), 'X') masked_cc_number
165:
166: FROM aso_payments pmt,
167: iby_external_payers_all payer,
168: aso_quote_headers_all hdr,
169: iby_security_segments sec,
170: iby_cc_issuer_ranges range

Line 210: FROM aso_payments pmt,

206: decode(iby_cc_validate.get_cc_issuer_range(pmt.payment_ref_number), null,length(pmt.payment_ref_number), null) cc_number_length,
207: substr(pmt.payment_ref_number,greatest(-4,-length(pmt.payment_ref_number))) cc_unmask_digits,
208: lpad(substr(pmt.payment_ref_number, greatest(-4,-length(pmt.payment_ref_number))), length(pmt.payment_ref_number), 'X' ) masked_cc_number
209:
210: FROM aso_payments pmt,
211: iby_external_payers_all payer,
212: aso_quote_headers_all hdr
213:
214: WHERE pmt.quote_header_id = hdr.quote_header_id

Line 866: fnd_file.put_line(FND_FILE.OUTPUT, 'Before updating the aso_payments table');

862: BEGIN -- begin7
863:
864: IF (l_error_flag = 'N' and payment_id_tab.count > 0 ) THEN
865:
866: fnd_file.put_line(FND_FILE.OUTPUT, 'Before updating the aso_payments table');
867:
868: FORALL i IN payment_id_tab.first..payment_id_tab.last SAVE EXCEPTIONS
869:
870: UPDATE aso_payments a

Line 870: UPDATE aso_payments a

866: fnd_file.put_line(FND_FILE.OUTPUT, 'Before updating the aso_payments table');
867:
868: FORALL i IN payment_id_tab.first..payment_id_tab.last SAVE EXCEPTIONS
869:
870: UPDATE aso_payments a
871: SET a.TRXN_EXTENSION_ID = TRXN_EXTENSION_ID_TAB(i),
872: a.CREDIT_CARD_APPROVAL_CODE = NULL,
873: a.CREDIT_CARD_APPROVAL_DATE = NULL,
874: a.CREDIT_CARD_CODE = NULL,

Line 880: fnd_file.put_line(FND_FILE.OUTPUT, 'After updating the aso_payments table');

876: a.CREDIT_CARD_HOLDER_NAME = NULL,
877: a.PAYMENT_REF_NUMBER = NULL
878: WHERE a.payment_id = payment_id_tab(i);
879:
880: fnd_file.put_line(FND_FILE.OUTPUT, 'After updating the aso_payments table');
881:
882: ELSE
883: IF payment_id_tab.count = 0 THEN
884: fnd_file.put_line(FND_FILE.OUTPUT,'No payment tbl records to update');

Line 886: fnd_file.put_line(FND_FILE.OUTPUT,'Did not update aso_payments table because of errors');

882: ELSE
883: IF payment_id_tab.count = 0 THEN
884: fnd_file.put_line(FND_FILE.OUTPUT,'No payment tbl records to update');
885: elsif l_error_flag = 'Y' then
886: fnd_file.put_line(FND_FILE.OUTPUT,'Did not update aso_payments table because of errors');
887: end if;
888: END IF;
889:
890: