DBA Data[Home] [Help]

APPS.CE_BANK_PUB dependencies on HZ_BANK_PUB

Line 153: | hz_bank_pub.create_bank |

149: | DESCRIPTION |
150: | Create a bank as a TCA organization party. |
151: | |
152: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
153: | hz_bank_pub.create_bank |
154: | |
155: | ARGUMENTS |
156: | IN: |
157: | p_init_msg_list Initialize message stack if it is set to |

Line 220: l_bank_rec hz_bank_pub.bank_rec_type;

216: x_return_status OUT NOCOPY VARCHAR2,
217: x_msg_count OUT NOCOPY NUMBER,
218: x_msg_data OUT NOCOPY VARCHAR2
219: ) IS
220: l_bank_rec hz_bank_pub.bank_rec_type;
221: l_org_rec hz_party_v2pub.organization_rec_type;
222: l_party_rec hz_party_v2pub.party_rec_type;
223: l_party_number VARCHAR2(30);
224: l_profile_id NUMBER(15);

Line 311: hz_bank_pub.create_bank(fnd_api.g_false, l_bank_rec, x_bank_id, l_party_number,

307: if (l_gen_party_num = 'N') then
308: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'Y');
309: end if;
310:
311: hz_bank_pub.create_bank(fnd_api.g_false, l_bank_rec, x_bank_id, l_party_number,
312: l_profile_id, l_code_assignment_id,
313: x_return_status, x_msg_count, x_msg_data);
314:
315: if (l_gen_party_num = 'N') then

Line 380: | hz_bank_pub.update_bank |

376: | DESCRIPTION |
377: | Update a bank organization. |
378: | |
379: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
380: | hz_bank_pub.update_bank |
381: | |
382: | ARGUMENTS |
383: | IN: |
384: | p_init_msg_list Initialize message stack if it is set to |

Line 451: l_bank_rec hz_bank_pub.bank_rec_type;

447: x_return_status OUT NOCOPY VARCHAR2,
448: x_msg_count OUT NOCOPY NUMBER,
449: x_msg_data OUT NOCOPY VARCHAR2
450: ) IS
451: l_bank_rec hz_bank_pub.bank_rec_type;
452: l_org_rec hz_party_v2pub.organization_rec_type;
453: l_party_rec hz_party_v2pub.party_rec_type;
454: l_profile_id NUMBER(15);
455: l_ca_object_version_number NUMBER(15);

Line 553: hz_bank_pub.update_bank(fnd_api.g_false, l_bank_rec,

549: AND owner_table_name = 'HZ_PARTIES'
550: AND owner_table_id = p_bank_id
551: AND status = 'A';
552:
553: hz_bank_pub.update_bank(fnd_api.g_false, l_bank_rec,
554: p_object_version_number, l_ca_object_version_number,
555: l_profile_id, x_return_status, x_msg_count, x_msg_data);
556:
557: -- raise an exception if error updating a bank

Line 618: | hz_bank_pub.update_bank |

614: | DESCRIPTION |
615: | Set the end date of a bank. |
616: | |
617: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
618: | hz_bank_pub.update_bank |
619: | |
620: | ARGUMENTS |
621: | IN: |
622: | p_init_msg_list Initialize message stack if it is set to |

Line 682: l_bank_rec hz_bank_pub.bank_rec_type;

678: l_bank_end DATE;
679: l_branch_end DATE;
680: l_bank_ovn NUMBER(15);
681: l_branch_ovn NUMBER(15);
682: l_bank_rec hz_bank_pub.bank_rec_type;
683: l_org_rec hz_party_v2pub.organization_rec_type;
684: l_party_rec hz_party_v2pub.party_rec_type;
685: l_profile_id NUMBER(15);
686: BEGIN

Line 765: hz_bank_pub.update_bank(fnd_api.g_false, l_bank_rec,

761: RAISE fnd_api.g_exc_error;
762: END IF;
763: CLOSE c_bank_ovn;
764:
765: hz_bank_pub.update_bank(fnd_api.g_false, l_bank_rec,
766: l_bank_ovn, p_object_version_number,
767: l_profile_id, x_return_status, x_msg_count, x_msg_data);
768:
769: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 930: | hz_bank_pub.create_bank_branch |

926: | DESCRIPTION |
927: | Create a bank branch as a TCA organization party. |
928: | |
929: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
930: | hz_bank_pub.create_bank_branch |
931: | |
932: | ARGUMENTS |
933: | IN: |
934: | p_init_msg_list Initialize message stack if it is set to |

Line 1009: l_branch_rec hz_bank_pub.bank_rec_type;

1005: AND SYSDATE between TRUNC(hz_org.effective_start_date)
1006: and NVL(TRUNC(hz_org.effective_end_date), SYSDATE+1)
1007: AND hz_p.party_id = p_bank_id;
1008:
1009: l_branch_rec hz_bank_pub.bank_rec_type;
1010: l_org_rec hz_party_v2pub.organization_rec_type;
1011: l_party_rec hz_party_v2pub.party_rec_type;
1012: l_party_number VARCHAR2(30);
1013: l_profile_id NUMBER(15);

Line 1158: hz_bank_pub.create_bank_branch(fnd_api.g_false, l_branch_rec, p_bank_id,

1154: if (l_gen_party_num = 'N') then
1155: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'Y');
1156: end if;
1157:
1158: hz_bank_pub.create_bank_branch(fnd_api.g_false, l_branch_rec, p_bank_id,
1159: x_branch_id, l_party_number,
1160: l_profile_id, l_rel_id,
1161: l_rel_party_id, l_rel_party_number,
1162: l_bch_code_assignment_id, l_typ_code_assignment_id,

Line 1251: | hz_bank_pub.update_bank_branch |

1247: | DESCRIPTION |
1248: | Update a bank branch organization party in TCA. |
1249: | |
1250: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1251: | hz_bank_pub.update_bank_branch |
1252: | |
1253: | ARGUMENTS |
1254: | IN: |
1255: | p_init_msg_list Initialize message stack if it is set to |

Line 1339: l_branch_rec hz_bank_pub.bank_rec_type;

1335: WHERE contact_point_type = 'EFT'
1336: AND owner_table_name = 'HZ_PARTIES'
1337: AND owner_table_id = p_branch_id;
1338:
1339: l_branch_rec hz_bank_pub.bank_rec_type;
1340: l_org_rec hz_party_v2pub.organization_rec_type;
1341: l_party_rec hz_party_v2pub.party_rec_type;
1342: l_party_number VARCHAR2(30);
1343: l_profile_id NUMBER(15);

Line 1470: hz_bank_pub.update_bank_branch(fnd_api.g_false, l_branch_rec, null,

1466: l_branch_rec.branch_type := p_branch_type;
1467: l_branch_rec.rfc_code := p_rfc_identifier;
1468: l_branch_rec.organization_rec := l_org_rec;
1469:
1470: hz_bank_pub.update_bank_branch(fnd_api.g_false, l_branch_rec, null,
1471: l_rel_id,
1472: p_bch_object_version_number, p_typ_object_version_number,
1473: p_rfc_object_version_number,
1474: l_profile_id, l_rel_party_id, l_rel_party_number,

Line 1574: | hz_bank_pub.update_bank |

1570: | DESCRIPTION |
1571: | Set the end date of a bank branch. |
1572: | |
1573: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1574: | hz_bank_pub.update_bank |
1575: | |
1576: | ARGUMENTS |
1577: | IN: |
1578: | p_init_msg_list Initialize message stack if it is set to |

Line 1666: l_branch_rec hz_bank_pub.bank_rec_type;

1662: l_branch_end DATE;
1663: l_bank_ovn NUMBER(15);
1664: l_branch_party_ovn NUMBER(15);
1665: l_rfc_ovn NUMBER(15);
1666: l_branch_rec hz_bank_pub.bank_rec_type;
1667: l_org_rec hz_party_v2pub.organization_rec_type;
1668: l_party_rec hz_party_v2pub.party_rec_type;
1669: l_profile_id NUMBER(15);
1670: l_rel_id NUMBER(15);

Line 1832: HZ_BANK_PUB.update_bank_branch(

1828: l_rfc_ovn := NULL;
1829: END IF;
1830: CLOSE c_rfc_ovn;
1831:
1832: HZ_BANK_PUB.update_bank_branch(
1833: p_init_msg_list => fnd_api.g_false,
1834: p_bank_rec => l_branch_rec,
1835: p_bank_party_id => NULL,
1836: p_relationship_id => l_rel_id,