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
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
114: * @param x_ext_payee_status_tab The external payee status table - iby_disbursement_setup_pub.ext_payee_create_tab_type
115: * @rep:scope public
116: * @rep:lifecycle active
117: * @rep:displayname Create POS Bank Payee BO Table
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
114: * @param x_ext_payee_status_tab The external payee status table - iby_disbursement_setup_pub.ext_payee_create_tab_type
115: * @rep:scope public
116: * @rep:lifecycle active
117: * @rep:displayname Create POS Bank Payee BO Table
118: * @rep:catagory BUSSINESS_ENTITY AP_SUPPLIER
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,
129: x_msg_data OUT NOCOPY VARCHAR2) IS
130: v_row_exists NUMBER := 0;
131: p_ext_payee_tab iby_disbursement_setup_pub.external_payee_tab_type;
132: x_ext_payee_id_tab iby_disbursement_setup_pub.ext_payee_id_tab_type;
133: x_ext_payee_status_tab iby_disbursement_setup_pub.ext_payee_create_tab_type;
134: x_ext_payee_update_status_tab iby_disbursement_setup_pub.Ext_Payee_Update_Tab_Type;
135: l_party_id NUMBER;
128: x_msg_count OUT NOCOPY NUMBER,
129: x_msg_data OUT NOCOPY VARCHAR2) IS
130: v_row_exists NUMBER := 0;
131: p_ext_payee_tab iby_disbursement_setup_pub.external_payee_tab_type;
132: x_ext_payee_id_tab iby_disbursement_setup_pub.ext_payee_id_tab_type;
133: x_ext_payee_status_tab iby_disbursement_setup_pub.ext_payee_create_tab_type;
134: x_ext_payee_update_status_tab iby_disbursement_setup_pub.Ext_Payee_Update_Tab_Type;
135: l_party_id NUMBER;
136: p_ext_payee_id_tab iby_disbursement_setup_pub.Ext_Payee_ID_Tab_Type;
129: x_msg_data OUT NOCOPY VARCHAR2) IS
130: v_row_exists NUMBER := 0;
131: p_ext_payee_tab iby_disbursement_setup_pub.external_payee_tab_type;
132: x_ext_payee_id_tab iby_disbursement_setup_pub.ext_payee_id_tab_type;
133: x_ext_payee_status_tab iby_disbursement_setup_pub.ext_payee_create_tab_type;
134: x_ext_payee_update_status_tab iby_disbursement_setup_pub.Ext_Payee_Update_Tab_Type;
135: l_party_id NUMBER;
136: p_ext_payee_id_tab iby_disbursement_setup_pub.Ext_Payee_ID_Tab_Type;
137: -- x_ext_payee_status_tab iby_disbursement_setup_pub.ext_payee_update_tab_type;
130: v_row_exists NUMBER := 0;
131: p_ext_payee_tab iby_disbursement_setup_pub.external_payee_tab_type;
132: x_ext_payee_id_tab iby_disbursement_setup_pub.ext_payee_id_tab_type;
133: x_ext_payee_status_tab iby_disbursement_setup_pub.ext_payee_create_tab_type;
134: x_ext_payee_update_status_tab iby_disbursement_setup_pub.Ext_Payee_Update_Tab_Type;
135: l_party_id NUMBER;
136: p_ext_payee_id_tab iby_disbursement_setup_pub.Ext_Payee_ID_Tab_Type;
137: -- x_ext_payee_status_tab iby_disbursement_setup_pub.ext_payee_update_tab_type;
138: BEGIN
132: x_ext_payee_id_tab iby_disbursement_setup_pub.ext_payee_id_tab_type;
133: x_ext_payee_status_tab iby_disbursement_setup_pub.ext_payee_create_tab_type;
134: x_ext_payee_update_status_tab iby_disbursement_setup_pub.Ext_Payee_Update_Tab_Type;
135: l_party_id NUMBER;
136: p_ext_payee_id_tab iby_disbursement_setup_pub.Ext_Payee_ID_Tab_Type;
137: -- x_ext_payee_status_tab iby_disbursement_setup_pub.ext_payee_update_tab_type;
138: BEGIN
139:
140: IF p_party_id IS NULL OR p_party_id = 0 THEN
133: x_ext_payee_status_tab iby_disbursement_setup_pub.ext_payee_create_tab_type;
134: x_ext_payee_update_status_tab iby_disbursement_setup_pub.Ext_Payee_Update_Tab_Type;
135: l_party_id NUMBER;
136: p_ext_payee_id_tab iby_disbursement_setup_pub.Ext_Payee_ID_Tab_Type;
137: -- x_ext_payee_status_tab iby_disbursement_setup_pub.ext_payee_update_tab_type;
138: BEGIN
139:
140: IF p_party_id IS NULL OR p_party_id = 0 THEN
141: l_party_id := pos_supplier_bo_dep_pkg.get_party_id(p_orig_system,
206: .ext_payee_id;
207: END LOOP;
208: IF p_create_update_flag = 'U' THEN
209:
210: iby_disbursement_setup_pub.update_external_payee(p_api_version,
211: p_init_msg_list,
212: p_ext_payee_tab,
213: p_ext_payee_id_tab,
214: x_return_status,
216: x_msg_data,
217: x_ext_payee_update_status_tab);
218: ELSIF p_create_update_flag = 'C' THEN
219:
220: iby_disbursement_setup_pub.create_external_payee(p_api_version,
221: p_init_msg_list,
222: p_ext_payee_tab,
223: x_return_status,
224: x_msg_count,