101: creation_date, created_by, cc_number_hash1,
102: cc_number_hash2)
103: values ( l_payeeid, l_instrtype,
104: null,
105: 1, sysdate, fnd_global.user_id,
106: sysdate, fnd_global.user_id, l_cc_hash1, l_cc_hash2);
107: o_results(i).success := 1;
108: if ( SQL%ROWCOUNT = 0 ) then
109: -- raise application error for the range it has failed.
102: cc_number_hash2)
103: values ( l_payeeid, l_instrtype,
104: null,
105: 1, sysdate, fnd_global.user_id,
106: sysdate, fnd_global.user_id, l_cc_hash1, l_cc_hash2);
107: o_results(i).success := 1;
108: if ( SQL%ROWCOUNT = 0 ) then
109: -- raise application error for the range it has failed.
110: o_results(i).success := 0;
139: acct_number_hash2)
140: values ( l_payeeid, l_instrtype,
141: i_riskyinstr(i).Routing_Num,
142: null,
143: 1, sysdate, fnd_global.user_id,
144: sysdate, fnd_global.user_id,l_account_no_hash1,
145: l_account_no_hash2);
146: o_results(i).success := 1;
147: if ( SQL%ROWCOUNT = 0 ) then
140: values ( l_payeeid, l_instrtype,
141: i_riskyinstr(i).Routing_Num,
142: null,
143: 1, sysdate, fnd_global.user_id,
144: sysdate, fnd_global.user_id,l_account_no_hash1,
145: l_account_no_hash2);
146: o_results(i).success := 1;
147: if ( SQL%ROWCOUNT = 0 ) then
148: -- raise application error for the range it has failed.