1016: l_rel_party_number NUMBER(15);
1017: l_bch_code_assignment_id NUMBER(15);
1018: l_typ_code_assignment_id NUMBER(15);
1019: l_rfc_code_assignment_id NUMBER(15);
1020: l_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
1021: l_eft_rec hz_contact_point_v2pub.eft_rec_type;
1022: l_contact_point_id NUMBER(15);
1023: l_country VARCHAR2(60);
1024: l_branch_number VARCHAR2(30);
1017: l_bch_code_assignment_id NUMBER(15);
1018: l_typ_code_assignment_id NUMBER(15);
1019: l_rfc_code_assignment_id NUMBER(15);
1020: l_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
1021: l_eft_rec hz_contact_point_v2pub.eft_rec_type;
1022: l_contact_point_id NUMBER(15);
1023: l_country VARCHAR2(60);
1024: l_branch_number VARCHAR2(30);
1025: l_bank_name VARCHAR2(360);
1180:
1181: l_eft_rec.eft_swift_code := p_bic;
1182: l_eft_rec.eft_user_number := p_eft_number;
1183:
1184: hz_contact_point_v2pub.create_eft_contact_point
1185: (fnd_api.g_false, l_contact_point_rec, l_eft_rec,
1186: l_contact_point_id,
1187: x_return_status, x_msg_count, x_msg_data);
1188:
1343: l_profile_id NUMBER(15);
1344: l_rel_id NUMBER(15);
1345: l_rel_party_id NUMBER(15);
1346: l_rel_party_number NUMBER(15);
1347: l_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
1348: l_eft_rec hz_contact_point_v2pub.eft_rec_type;
1349: l_contact_point_id NUMBER(15);
1350: l_bank_id NUMBER(15);
1351: l_bank_name VARCHAR2(360);
1344: l_rel_id NUMBER(15);
1345: l_rel_party_id NUMBER(15);
1346: l_rel_party_number NUMBER(15);
1347: l_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
1348: l_eft_rec hz_contact_point_v2pub.eft_rec_type;
1349: l_contact_point_id NUMBER(15);
1350: l_bank_id NUMBER(15);
1351: l_bank_name VARCHAR2(360);
1352: l_bank_number VARCHAR2(30);
1492:
1493: l_eft_rec.eft_swift_code := p_bic;
1494: l_eft_rec.eft_user_number := p_eft_number;
1495:
1496: hz_contact_point_v2pub.create_eft_contact_point
1497: (fnd_api.g_false, l_contact_point_rec, l_eft_rec,
1498: l_contact_point_id,
1499: x_return_status, x_msg_count, x_msg_data);
1500: END IF;
1503:
1504: l_eft_rec.eft_swift_code := p_bic;
1505: l_eft_rec.eft_user_number := p_eft_number;
1506:
1507: hz_contact_point_v2pub.update_eft_contact_point
1508: (fnd_api.g_false, l_contact_point_rec, l_eft_rec,
1509: p_eft_object_version_number,
1510: x_return_status, x_msg_count, x_msg_data);
1511: END IF;