DBA Data[Home] [Help]

APPS.POS_BANK_PAYEE_BO_PKG dependencies on POS_BANK_PAYEE_BO_TBL

Line 8: * @param x_pos_bank_payee_bo_tbl The bank payee bo table

4: * Use this routine to get bank payee 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_payee_bo_tbl The bank payee bo table
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 18: PROCEDURE get_pos_bank_payee_bo_tbl(p_api_version IN NUMBER DEFAULT NULL,

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

Line 23: x_pos_bank_payee_bo_tbl OUT NOCOPY pos_bank_payee_bo_tbl,

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

Line 28: l_pos_bank_payee_bo_tbl pos_bank_payee_bo_tbl := pos_bank_payee_bo_tbl();

24: x_return_status OUT NOCOPY VARCHAR2,
25: x_msg_count OUT NOCOPY NUMBER,
26: x_msg_data OUT NOCOPY VARCHAR2) IS
27:
28: l_pos_bank_payee_bo_tbl pos_bank_payee_bo_tbl := pos_bank_payee_bo_tbl();
29: l_party_id NUMBER;
30: BEGIN
31:
32: IF p_party_id IS NULL OR p_party_id = 0 THEN

Line 80: INTO l_pos_bank_payee_bo_tbl

76: instr.instrument_id, -- Bug 12903268: add bank account id into the object
77: instr.order_of_preference, -- Bug 13529064: add account details
78: instr.start_date,
79: instr.end_date) BULK COLLECT
80: INTO l_pos_bank_payee_bo_tbl
81: FROM iby_external_payees_all payee, iby_pmt_instr_uses_all instr
82: WHERE payee_party_id = l_party_id
83: AND payee.ext_payee_id = instr.ext_pmt_party_id (+); -- Bug 12903268: Associate bank account id with payee.
84:

Line 85: x_pos_bank_payee_bo_tbl := l_pos_bank_payee_bo_tbl;

81: FROM iby_external_payees_all payee, iby_pmt_instr_uses_all instr
82: WHERE payee_party_id = l_party_id
83: AND payee.ext_payee_id = instr.ext_pmt_party_id (+); -- Bug 12903268: Associate bank account id with payee.
84:
85: x_pos_bank_payee_bo_tbl := l_pos_bank_payee_bo_tbl;
86: EXCEPTION
87: WHEN fnd_api.g_exc_error THEN
88:
89: x_return_status := fnd_api.g_ret_sts_error;

Line 103: END get_pos_bank_payee_bo_tbl;

99: x_return_status := fnd_api.g_ret_sts_unexp_error;
100:
101: x_msg_count := 1;
102: x_msg_data := SQLCODE || SQLERRM;
103: END get_pos_bank_payee_bo_tbl;
104: /*#
105: * Use this routine to create bank payee bo
106: * @param p_api_version The version of API
107: * @param p_init_msg_list The Initialization message list

Line 109: * @param x_pos_bank_payee_bo_tbl The bank payee bo table - iby_disbursement_setup_pub.external_payee_tab_type

105: * Use this routine to create bank payee bo
106: * @param p_api_version The version of API
107: * @param p_init_msg_list The Initialization message list
108: * @param p_ext_payee_tab The external payee table
109: * @param x_pos_bank_payee_bo_tbl The bank payee bo table - iby_disbursement_setup_pub.external_payee_tab_type
110: * @param x_return_status The return status
111: * @param x_msg_count The message count
112: * @param x_msg_data The message data
113: * @param x_ext_payee_id_tab The external payee id table -iby_disbursement_setup_pub.ext_payee_id_tab_type

Line 120: PROCEDURE create_pos_bank_payee_bo_tbl(p_api_version IN NUMBER,

116: * @rep:lifecycle active
117: * @rep:displayname Create POS Bank Payee BO Table
118: * @rep:catagory BUSSINESS_ENTITY AP_SUPPLIER
119: */
120: PROCEDURE create_pos_bank_payee_bo_tbl(p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
122: p_pos_bank_payee_bo_tbl IN pos_bank_payee_bo_tbl,
123: p_party_id IN NUMBER,
124: p_orig_system IN VARCHAR2,

Line 122: p_pos_bank_payee_bo_tbl IN pos_bank_payee_bo_tbl,

118: * @rep:catagory BUSSINESS_ENTITY AP_SUPPLIER
119: */
120: PROCEDURE create_pos_bank_payee_bo_tbl(p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
122: p_pos_bank_payee_bo_tbl IN pos_bank_payee_bo_tbl,
123: p_party_id IN NUMBER,
124: p_orig_system IN VARCHAR2,
125: p_orig_system_reference IN VARCHAR2,
126: p_create_update_flag IN VARCHAR2,

Line 147: FOR i IN p_pos_bank_payee_bo_tbl.first .. p_pos_bank_payee_bo_tbl.last LOOP

143: ELSE
144: l_party_id := p_party_id;
145: END IF;
146:
147: FOR i IN p_pos_bank_payee_bo_tbl.first .. p_pos_bank_payee_bo_tbl.last LOOP
148: p_ext_payee_tab(i).payee_party_id := l_party_id; -- p_pos_bank_payee_bo_tbl.payee_party_id;
149: p_ext_payee_tab(i).payment_function := p_pos_bank_payee_bo_tbl(i)
150: .payment_function;
151: p_ext_payee_tab(i).exclusive_pay_flag := p_pos_bank_payee_bo_tbl(i)

Line 148: p_ext_payee_tab(i).payee_party_id := l_party_id; -- p_pos_bank_payee_bo_tbl.payee_party_id;

144: l_party_id := p_party_id;
145: END IF;
146:
147: FOR i IN p_pos_bank_payee_bo_tbl.first .. p_pos_bank_payee_bo_tbl.last LOOP
148: p_ext_payee_tab(i).payee_party_id := l_party_id; -- p_pos_bank_payee_bo_tbl.payee_party_id;
149: p_ext_payee_tab(i).payment_function := p_pos_bank_payee_bo_tbl(i)
150: .payment_function;
151: p_ext_payee_tab(i).exclusive_pay_flag := p_pos_bank_payee_bo_tbl(i)
152: .exclusive_payment_flag;

Line 149: p_ext_payee_tab(i).payment_function := p_pos_bank_payee_bo_tbl(i)

145: END IF;
146:
147: FOR i IN p_pos_bank_payee_bo_tbl.first .. p_pos_bank_payee_bo_tbl.last LOOP
148: p_ext_payee_tab(i).payee_party_id := l_party_id; -- p_pos_bank_payee_bo_tbl.payee_party_id;
149: p_ext_payee_tab(i).payment_function := p_pos_bank_payee_bo_tbl(i)
150: .payment_function;
151: p_ext_payee_tab(i).exclusive_pay_flag := p_pos_bank_payee_bo_tbl(i)
152: .exclusive_payment_flag;
153: p_ext_payee_tab(i).payee_party_site_id := p_pos_bank_payee_bo_tbl(i)

Line 151: p_ext_payee_tab(i).exclusive_pay_flag := p_pos_bank_payee_bo_tbl(i)

147: FOR i IN p_pos_bank_payee_bo_tbl.first .. p_pos_bank_payee_bo_tbl.last LOOP
148: p_ext_payee_tab(i).payee_party_id := l_party_id; -- p_pos_bank_payee_bo_tbl.payee_party_id;
149: p_ext_payee_tab(i).payment_function := p_pos_bank_payee_bo_tbl(i)
150: .payment_function;
151: p_ext_payee_tab(i).exclusive_pay_flag := p_pos_bank_payee_bo_tbl(i)
152: .exclusive_payment_flag;
153: p_ext_payee_tab(i).payee_party_site_id := p_pos_bank_payee_bo_tbl(i)
154: .party_site_id;
155: p_ext_payee_tab(i).supplier_site_id := p_pos_bank_payee_bo_tbl(i)

Line 153: p_ext_payee_tab(i).payee_party_site_id := p_pos_bank_payee_bo_tbl(i)

149: p_ext_payee_tab(i).payment_function := p_pos_bank_payee_bo_tbl(i)
150: .payment_function;
151: p_ext_payee_tab(i).exclusive_pay_flag := p_pos_bank_payee_bo_tbl(i)
152: .exclusive_payment_flag;
153: p_ext_payee_tab(i).payee_party_site_id := p_pos_bank_payee_bo_tbl(i)
154: .party_site_id;
155: p_ext_payee_tab(i).supplier_site_id := p_pos_bank_payee_bo_tbl(i)
156: .supplier_site_id;
157: p_ext_payee_tab(i).payer_org_id := p_pos_bank_payee_bo_tbl(i)

Line 155: p_ext_payee_tab(i).supplier_site_id := p_pos_bank_payee_bo_tbl(i)

151: p_ext_payee_tab(i).exclusive_pay_flag := p_pos_bank_payee_bo_tbl(i)
152: .exclusive_payment_flag;
153: p_ext_payee_tab(i).payee_party_site_id := p_pos_bank_payee_bo_tbl(i)
154: .party_site_id;
155: p_ext_payee_tab(i).supplier_site_id := p_pos_bank_payee_bo_tbl(i)
156: .supplier_site_id;
157: p_ext_payee_tab(i).payer_org_id := p_pos_bank_payee_bo_tbl(i)
158: .org_id;
159: p_ext_payee_tab(i).payer_org_type := p_pos_bank_payee_bo_tbl(i)

Line 157: p_ext_payee_tab(i).payer_org_id := p_pos_bank_payee_bo_tbl(i)

153: p_ext_payee_tab(i).payee_party_site_id := p_pos_bank_payee_bo_tbl(i)
154: .party_site_id;
155: p_ext_payee_tab(i).supplier_site_id := p_pos_bank_payee_bo_tbl(i)
156: .supplier_site_id;
157: p_ext_payee_tab(i).payer_org_id := p_pos_bank_payee_bo_tbl(i)
158: .org_id;
159: p_ext_payee_tab(i).payer_org_type := p_pos_bank_payee_bo_tbl(i)
160: .org_type;
161: p_ext_payee_tab(i).default_pmt_method := p_pos_bank_payee_bo_tbl(i)

Line 159: p_ext_payee_tab(i).payer_org_type := p_pos_bank_payee_bo_tbl(i)

155: p_ext_payee_tab(i).supplier_site_id := p_pos_bank_payee_bo_tbl(i)
156: .supplier_site_id;
157: p_ext_payee_tab(i).payer_org_id := p_pos_bank_payee_bo_tbl(i)
158: .org_id;
159: p_ext_payee_tab(i).payer_org_type := p_pos_bank_payee_bo_tbl(i)
160: .org_type;
161: p_ext_payee_tab(i).default_pmt_method := p_pos_bank_payee_bo_tbl(i)
162: .default_payment_method_code;
163: p_ext_payee_tab(i).ece_tp_loc_code := p_pos_bank_payee_bo_tbl(i)

Line 161: p_ext_payee_tab(i).default_pmt_method := p_pos_bank_payee_bo_tbl(i)

157: p_ext_payee_tab(i).payer_org_id := p_pos_bank_payee_bo_tbl(i)
158: .org_id;
159: p_ext_payee_tab(i).payer_org_type := p_pos_bank_payee_bo_tbl(i)
160: .org_type;
161: p_ext_payee_tab(i).default_pmt_method := p_pos_bank_payee_bo_tbl(i)
162: .default_payment_method_code;
163: p_ext_payee_tab(i).ece_tp_loc_code := p_pos_bank_payee_bo_tbl(i)
164: .ece_tp_location_code;
165: p_ext_payee_tab(i).bank_charge_bearer := p_pos_bank_payee_bo_tbl(i)

Line 163: p_ext_payee_tab(i).ece_tp_loc_code := p_pos_bank_payee_bo_tbl(i)

159: p_ext_payee_tab(i).payer_org_type := p_pos_bank_payee_bo_tbl(i)
160: .org_type;
161: p_ext_payee_tab(i).default_pmt_method := p_pos_bank_payee_bo_tbl(i)
162: .default_payment_method_code;
163: p_ext_payee_tab(i).ece_tp_loc_code := p_pos_bank_payee_bo_tbl(i)
164: .ece_tp_location_code;
165: p_ext_payee_tab(i).bank_charge_bearer := p_pos_bank_payee_bo_tbl(i)
166: .bank_charge_bearer;
167: p_ext_payee_tab(i).bank_instr1_code := p_pos_bank_payee_bo_tbl(i)

Line 165: p_ext_payee_tab(i).bank_charge_bearer := p_pos_bank_payee_bo_tbl(i)

161: p_ext_payee_tab(i).default_pmt_method := p_pos_bank_payee_bo_tbl(i)
162: .default_payment_method_code;
163: p_ext_payee_tab(i).ece_tp_loc_code := p_pos_bank_payee_bo_tbl(i)
164: .ece_tp_location_code;
165: p_ext_payee_tab(i).bank_charge_bearer := p_pos_bank_payee_bo_tbl(i)
166: .bank_charge_bearer;
167: p_ext_payee_tab(i).bank_instr1_code := p_pos_bank_payee_bo_tbl(i)
168: .bank_instruction1_code;
169: p_ext_payee_tab(i).bank_instr2_code := p_pos_bank_payee_bo_tbl(i)

Line 167: p_ext_payee_tab(i).bank_instr1_code := p_pos_bank_payee_bo_tbl(i)

163: p_ext_payee_tab(i).ece_tp_loc_code := p_pos_bank_payee_bo_tbl(i)
164: .ece_tp_location_code;
165: p_ext_payee_tab(i).bank_charge_bearer := p_pos_bank_payee_bo_tbl(i)
166: .bank_charge_bearer;
167: p_ext_payee_tab(i).bank_instr1_code := p_pos_bank_payee_bo_tbl(i)
168: .bank_instruction1_code;
169: p_ext_payee_tab(i).bank_instr2_code := p_pos_bank_payee_bo_tbl(i)
170: .bank_instruction2_code;
171: p_ext_payee_tab(i).bank_instr_detail := p_pos_bank_payee_bo_tbl(i)

Line 169: p_ext_payee_tab(i).bank_instr2_code := p_pos_bank_payee_bo_tbl(i)

165: p_ext_payee_tab(i).bank_charge_bearer := p_pos_bank_payee_bo_tbl(i)
166: .bank_charge_bearer;
167: p_ext_payee_tab(i).bank_instr1_code := p_pos_bank_payee_bo_tbl(i)
168: .bank_instruction1_code;
169: p_ext_payee_tab(i).bank_instr2_code := p_pos_bank_payee_bo_tbl(i)
170: .bank_instruction2_code;
171: p_ext_payee_tab(i).bank_instr_detail := p_pos_bank_payee_bo_tbl(i)
172: .bank_instruction_details;
173: p_ext_payee_tab(i).pay_reason_code := p_pos_bank_payee_bo_tbl(i)

Line 171: p_ext_payee_tab(i).bank_instr_detail := p_pos_bank_payee_bo_tbl(i)

167: p_ext_payee_tab(i).bank_instr1_code := p_pos_bank_payee_bo_tbl(i)
168: .bank_instruction1_code;
169: p_ext_payee_tab(i).bank_instr2_code := p_pos_bank_payee_bo_tbl(i)
170: .bank_instruction2_code;
171: p_ext_payee_tab(i).bank_instr_detail := p_pos_bank_payee_bo_tbl(i)
172: .bank_instruction_details;
173: p_ext_payee_tab(i).pay_reason_code := p_pos_bank_payee_bo_tbl(i)
174: .payment_reason_code;
175: p_ext_payee_tab(i).pay_reason_com := p_pos_bank_payee_bo_tbl(i)

Line 173: p_ext_payee_tab(i).pay_reason_code := p_pos_bank_payee_bo_tbl(i)

169: p_ext_payee_tab(i).bank_instr2_code := p_pos_bank_payee_bo_tbl(i)
170: .bank_instruction2_code;
171: p_ext_payee_tab(i).bank_instr_detail := p_pos_bank_payee_bo_tbl(i)
172: .bank_instruction_details;
173: p_ext_payee_tab(i).pay_reason_code := p_pos_bank_payee_bo_tbl(i)
174: .payment_reason_code;
175: p_ext_payee_tab(i).pay_reason_com := p_pos_bank_payee_bo_tbl(i)
176: .payment_reason_comments;
177: p_ext_payee_tab(i).inactive_date := p_pos_bank_payee_bo_tbl(i)

Line 175: p_ext_payee_tab(i).pay_reason_com := p_pos_bank_payee_bo_tbl(i)

171: p_ext_payee_tab(i).bank_instr_detail := p_pos_bank_payee_bo_tbl(i)
172: .bank_instruction_details;
173: p_ext_payee_tab(i).pay_reason_code := p_pos_bank_payee_bo_tbl(i)
174: .payment_reason_code;
175: p_ext_payee_tab(i).pay_reason_com := p_pos_bank_payee_bo_tbl(i)
176: .payment_reason_comments;
177: p_ext_payee_tab(i).inactive_date := p_pos_bank_payee_bo_tbl(i)
178: .inactive_date;
179: p_ext_payee_tab(i).pay_message1 := p_pos_bank_payee_bo_tbl(i)

Line 177: p_ext_payee_tab(i).inactive_date := p_pos_bank_payee_bo_tbl(i)

173: p_ext_payee_tab(i).pay_reason_code := p_pos_bank_payee_bo_tbl(i)
174: .payment_reason_code;
175: p_ext_payee_tab(i).pay_reason_com := p_pos_bank_payee_bo_tbl(i)
176: .payment_reason_comments;
177: p_ext_payee_tab(i).inactive_date := p_pos_bank_payee_bo_tbl(i)
178: .inactive_date;
179: p_ext_payee_tab(i).pay_message1 := p_pos_bank_payee_bo_tbl(i)
180: .payment_text_message1;
181: p_ext_payee_tab(i).pay_message2 := p_pos_bank_payee_bo_tbl(i)

Line 179: p_ext_payee_tab(i).pay_message1 := p_pos_bank_payee_bo_tbl(i)

175: p_ext_payee_tab(i).pay_reason_com := p_pos_bank_payee_bo_tbl(i)
176: .payment_reason_comments;
177: p_ext_payee_tab(i).inactive_date := p_pos_bank_payee_bo_tbl(i)
178: .inactive_date;
179: p_ext_payee_tab(i).pay_message1 := p_pos_bank_payee_bo_tbl(i)
180: .payment_text_message1;
181: p_ext_payee_tab(i).pay_message2 := p_pos_bank_payee_bo_tbl(i)
182: .payment_text_message2;
183: p_ext_payee_tab(i).pay_message3 := p_pos_bank_payee_bo_tbl(i)

Line 181: p_ext_payee_tab(i).pay_message2 := p_pos_bank_payee_bo_tbl(i)

177: p_ext_payee_tab(i).inactive_date := p_pos_bank_payee_bo_tbl(i)
178: .inactive_date;
179: p_ext_payee_tab(i).pay_message1 := p_pos_bank_payee_bo_tbl(i)
180: .payment_text_message1;
181: p_ext_payee_tab(i).pay_message2 := p_pos_bank_payee_bo_tbl(i)
182: .payment_text_message2;
183: p_ext_payee_tab(i).pay_message3 := p_pos_bank_payee_bo_tbl(i)
184: .payment_text_message3;
185: p_ext_payee_tab(i).delivery_channel := p_pos_bank_payee_bo_tbl(i)

Line 183: p_ext_payee_tab(i).pay_message3 := p_pos_bank_payee_bo_tbl(i)

179: p_ext_payee_tab(i).pay_message1 := p_pos_bank_payee_bo_tbl(i)
180: .payment_text_message1;
181: p_ext_payee_tab(i).pay_message2 := p_pos_bank_payee_bo_tbl(i)
182: .payment_text_message2;
183: p_ext_payee_tab(i).pay_message3 := p_pos_bank_payee_bo_tbl(i)
184: .payment_text_message3;
185: p_ext_payee_tab(i).delivery_channel := p_pos_bank_payee_bo_tbl(i)
186: .delivery_channel_code;
187: p_ext_payee_tab(i).pmt_format := p_pos_bank_payee_bo_tbl(i)

Line 185: p_ext_payee_tab(i).delivery_channel := p_pos_bank_payee_bo_tbl(i)

181: p_ext_payee_tab(i).pay_message2 := p_pos_bank_payee_bo_tbl(i)
182: .payment_text_message2;
183: p_ext_payee_tab(i).pay_message3 := p_pos_bank_payee_bo_tbl(i)
184: .payment_text_message3;
185: p_ext_payee_tab(i).delivery_channel := p_pos_bank_payee_bo_tbl(i)
186: .delivery_channel_code;
187: p_ext_payee_tab(i).pmt_format := p_pos_bank_payee_bo_tbl(i)
188: .payment_format_code;
189: p_ext_payee_tab(i).settlement_priority := p_pos_bank_payee_bo_tbl(i)

Line 187: p_ext_payee_tab(i).pmt_format := p_pos_bank_payee_bo_tbl(i)

183: p_ext_payee_tab(i).pay_message3 := p_pos_bank_payee_bo_tbl(i)
184: .payment_text_message3;
185: p_ext_payee_tab(i).delivery_channel := p_pos_bank_payee_bo_tbl(i)
186: .delivery_channel_code;
187: p_ext_payee_tab(i).pmt_format := p_pos_bank_payee_bo_tbl(i)
188: .payment_format_code;
189: p_ext_payee_tab(i).settlement_priority := p_pos_bank_payee_bo_tbl(i)
190: .settlement_priority;
191: p_ext_payee_tab(i).remit_advice_delivery_method := p_pos_bank_payee_bo_tbl(i)

Line 189: p_ext_payee_tab(i).settlement_priority := p_pos_bank_payee_bo_tbl(i)

185: p_ext_payee_tab(i).delivery_channel := p_pos_bank_payee_bo_tbl(i)
186: .delivery_channel_code;
187: p_ext_payee_tab(i).pmt_format := p_pos_bank_payee_bo_tbl(i)
188: .payment_format_code;
189: p_ext_payee_tab(i).settlement_priority := p_pos_bank_payee_bo_tbl(i)
190: .settlement_priority;
191: p_ext_payee_tab(i).remit_advice_delivery_method := p_pos_bank_payee_bo_tbl(i)
192: .remit_advice_delivery_method;
193: p_ext_payee_tab(i).remit_advice_email := p_pos_bank_payee_bo_tbl(i)

Line 191: p_ext_payee_tab(i).remit_advice_delivery_method := p_pos_bank_payee_bo_tbl(i)

187: p_ext_payee_tab(i).pmt_format := p_pos_bank_payee_bo_tbl(i)
188: .payment_format_code;
189: p_ext_payee_tab(i).settlement_priority := p_pos_bank_payee_bo_tbl(i)
190: .settlement_priority;
191: p_ext_payee_tab(i).remit_advice_delivery_method := p_pos_bank_payee_bo_tbl(i)
192: .remit_advice_delivery_method;
193: p_ext_payee_tab(i).remit_advice_email := p_pos_bank_payee_bo_tbl(i)
194: .remit_advice_email;
195: p_ext_payee_tab(i).edi_payment_format := p_pos_bank_payee_bo_tbl(i)

Line 193: p_ext_payee_tab(i).remit_advice_email := p_pos_bank_payee_bo_tbl(i)

189: p_ext_payee_tab(i).settlement_priority := p_pos_bank_payee_bo_tbl(i)
190: .settlement_priority;
191: p_ext_payee_tab(i).remit_advice_delivery_method := p_pos_bank_payee_bo_tbl(i)
192: .remit_advice_delivery_method;
193: p_ext_payee_tab(i).remit_advice_email := p_pos_bank_payee_bo_tbl(i)
194: .remit_advice_email;
195: p_ext_payee_tab(i).edi_payment_format := p_pos_bank_payee_bo_tbl(i)
196: .payment_format_code;
197: p_ext_payee_tab(i).edi_transaction_handling := p_pos_bank_payee_bo_tbl(i)

Line 195: p_ext_payee_tab(i).edi_payment_format := p_pos_bank_payee_bo_tbl(i)

191: p_ext_payee_tab(i).remit_advice_delivery_method := p_pos_bank_payee_bo_tbl(i)
192: .remit_advice_delivery_method;
193: p_ext_payee_tab(i).remit_advice_email := p_pos_bank_payee_bo_tbl(i)
194: .remit_advice_email;
195: p_ext_payee_tab(i).edi_payment_format := p_pos_bank_payee_bo_tbl(i)
196: .payment_format_code;
197: p_ext_payee_tab(i).edi_transaction_handling := p_pos_bank_payee_bo_tbl(i)
198: .edi_transaction_handling;
199: p_ext_payee_tab(i).edi_payment_method := p_pos_bank_payee_bo_tbl(i)

Line 197: p_ext_payee_tab(i).edi_transaction_handling := p_pos_bank_payee_bo_tbl(i)

193: p_ext_payee_tab(i).remit_advice_email := p_pos_bank_payee_bo_tbl(i)
194: .remit_advice_email;
195: p_ext_payee_tab(i).edi_payment_format := p_pos_bank_payee_bo_tbl(i)
196: .payment_format_code;
197: p_ext_payee_tab(i).edi_transaction_handling := p_pos_bank_payee_bo_tbl(i)
198: .edi_transaction_handling;
199: p_ext_payee_tab(i).edi_payment_method := p_pos_bank_payee_bo_tbl(i)
200: .edi_payment_method;
201: p_ext_payee_tab(i).edi_remittance_method := p_pos_bank_payee_bo_tbl(i)

Line 199: p_ext_payee_tab(i).edi_payment_method := p_pos_bank_payee_bo_tbl(i)

195: p_ext_payee_tab(i).edi_payment_format := p_pos_bank_payee_bo_tbl(i)
196: .payment_format_code;
197: p_ext_payee_tab(i).edi_transaction_handling := p_pos_bank_payee_bo_tbl(i)
198: .edi_transaction_handling;
199: p_ext_payee_tab(i).edi_payment_method := p_pos_bank_payee_bo_tbl(i)
200: .edi_payment_method;
201: p_ext_payee_tab(i).edi_remittance_method := p_pos_bank_payee_bo_tbl(i)
202: .edi_remittance_method;
203: p_ext_payee_tab(i).edi_remittance_instruction := p_pos_bank_payee_bo_tbl(i)

Line 201: p_ext_payee_tab(i).edi_remittance_method := p_pos_bank_payee_bo_tbl(i)

197: p_ext_payee_tab(i).edi_transaction_handling := p_pos_bank_payee_bo_tbl(i)
198: .edi_transaction_handling;
199: p_ext_payee_tab(i).edi_payment_method := p_pos_bank_payee_bo_tbl(i)
200: .edi_payment_method;
201: p_ext_payee_tab(i).edi_remittance_method := p_pos_bank_payee_bo_tbl(i)
202: .edi_remittance_method;
203: p_ext_payee_tab(i).edi_remittance_instruction := p_pos_bank_payee_bo_tbl(i)
204: .edi_remittance_instruction;
205: p_ext_payee_id_tab(i).ext_payee_id := p_pos_bank_payee_bo_tbl(i)

Line 203: p_ext_payee_tab(i).edi_remittance_instruction := p_pos_bank_payee_bo_tbl(i)

199: p_ext_payee_tab(i).edi_payment_method := p_pos_bank_payee_bo_tbl(i)
200: .edi_payment_method;
201: p_ext_payee_tab(i).edi_remittance_method := p_pos_bank_payee_bo_tbl(i)
202: .edi_remittance_method;
203: p_ext_payee_tab(i).edi_remittance_instruction := p_pos_bank_payee_bo_tbl(i)
204: .edi_remittance_instruction;
205: p_ext_payee_id_tab(i).ext_payee_id := p_pos_bank_payee_bo_tbl(i)
206: .ext_payee_id;
207: END LOOP;

Line 205: p_ext_payee_id_tab(i).ext_payee_id := p_pos_bank_payee_bo_tbl(i)

201: p_ext_payee_tab(i).edi_remittance_method := p_pos_bank_payee_bo_tbl(i)
202: .edi_remittance_method;
203: p_ext_payee_tab(i).edi_remittance_instruction := p_pos_bank_payee_bo_tbl(i)
204: .edi_remittance_instruction;
205: p_ext_payee_id_tab(i).ext_payee_id := p_pos_bank_payee_bo_tbl(i)
206: .ext_payee_id;
207: END LOOP;
208: IF p_create_update_flag = 'U' THEN
209: