APPS.POS_BANK_ACCOUNT_BO_PKG dependencies on POS_BANK_ACCOUNT_BO_TBL

Line 8: * @param x_pos_bank_account_bo_tbl The bank account bo

4: * Use this routine to get bank accont bo
5: * @param p_api_version The version of API
6: * @param p_init_msg_list The Initialization message list
7: * @param p_party_id The party_id
8: * @param x_pos_bank_account_bo_tbl The bank account bo
9: * @param x_return_status The return status
10: * @param x_msg_count The message count
11: * @param x_msg_data The message data
12: * @rep:scope public

Line 17: PROCEDURE get_pos_bank_account_bo_tbl(p_api_version IN NUMBER DEFAULT NULL,

13: * @rep:lifecycle active
14: * @rep:displayname Get POS Bank Account BO Table
15: * @rep:catagory BUSSINESS_ENTITY AP_SUPPLIER
16: */
17: PROCEDURE get_pos_bank_account_bo_tbl(p_api_version IN NUMBER DEFAULT NULL,
18: p_init_msg_list IN VARCHAR2 DEFAULT NULL,
19: p_party_id IN NUMBER,
20: p_orig_system IN VARCHAR2,
21: p_orig_system_reference IN VARCHAR2,

Line 22: x_pos_bank_account_bo_tbl OUT NOCOPY pos_bank_account_bo_tbl,

18: p_init_msg_list IN VARCHAR2 DEFAULT NULL,
19: p_party_id IN NUMBER,
20: p_orig_system IN VARCHAR2,
21: p_orig_system_reference IN VARCHAR2,
22: x_pos_bank_account_bo_tbl OUT NOCOPY pos_bank_account_bo_tbl,
23: x_return_status OUT NOCOPY VARCHAR2,
24: x_msg_count OUT NOCOPY NUMBER,
25: x_msg_data OUT NOCOPY VARCHAR2) IS
26:

Line 27: l_pos_bank_account_bo_tbl pos_bank_account_bo_tbl := pos_bank_account_bo_tbl();

23: x_return_status OUT NOCOPY VARCHAR2,
24: x_msg_count OUT NOCOPY NUMBER,
25: x_msg_data OUT NOCOPY VARCHAR2) IS
26:
27: l_pos_bank_account_bo_tbl pos_bank_account_bo_tbl := pos_bank_account_bo_tbl();
28: l_party_id NUMBER := 0;
29:
30: BEGIN
31:

Line 102: INTO l_pos_bank_account_bo_tbl

98: brpr.bank_code,
99: eb.encrypted*/)
100:
101: BULK COLLECT
102: INTO l_pos_bank_account_bo_tbl
103: FROM hz_organization_profiles bapr,
104: hz_organization_profiles brpr,
105: hz_parties bp,
106: hz_party_sites s,

Line 155: x_pos_bank_account_bo_tbl := l_pos_bank_account_bo_tbl;

151: AND op.party_id = supp.account_owner_party_id -- Bug 13096283 Part 2: Join to get primary owner info for the bank account
152: AND eb.ext_bank_account_id = supp.ext_bank_account_id -- Bug 13586778: only select account that belongs to the current supplier.
153: AND branchca.primary_flag = 'Y'; -- Bug 16205262: Check primary_flag to prevent publishing duplicated bank account info.
154:
155: x_pos_bank_account_bo_tbl := l_pos_bank_account_bo_tbl;
156: EXCEPTION
157: WHEN fnd_api.g_exc_error THEN
158: x_return_status := fnd_api.g_ret_sts_error;
159: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 170: END get_pos_bank_account_bo_tbl;

166: x_return_status := fnd_api.g_ret_sts_unexp_error;
167: fnd_msg_pub.count_and_get(p_count => x_msg_count,
168: p_data => x_msg_data);
169:
170: END get_pos_bank_account_bo_tbl;
171:
172: /*#
173: * Use this routine to create bank account bo
174: * @param p_api_version The version of API

Line 194: p_pos_bank_account_bo IN pos_bank_account_bo_tbl,

190: p_party_id IN NUMBER,
191: p_orig_system IN VARCHAR2,
192: p_orig_system_reference IN VARCHAR2,
193: p_create_update_flag IN VARCHAR2,
194: p_pos_bank_account_bo IN pos_bank_account_bo_tbl,
195: x_acct_id OUT NOCOPY NUMBER,
196: x_return_status OUT NOCOPY VARCHAR2,
197: x_msg_count OUT NOCOPY NUMBER,
198: x_msg_data OUT NOCOPY VARCHAR2)