76: l_short_name VARCHAR2(240) := NULL;
77: l_short_name_null VARCHAR2(1) := 'N';
78: l_bank_number VARCHAR2(60) := NULL;
79:
80: /* records in HZ_BANK_VAL_GT and hz_org_profile_val_gt share the same temp_id */
81:
82: CURSOR c_country IS
83: SELECT country
84: FROM HZ_BANK_VAL_GT
80: /* records in HZ_BANK_VAL_GT and hz_org_profile_val_gt share the same temp_id */
81:
82: CURSOR c_country IS
83: SELECT country
84: FROM HZ_BANK_VAL_GT
85: WHERE temp_id = p_temp_id;
86:
87: CURSOR c_bank_number IS
88: SELECT bank_or_branch_number
85: WHERE temp_id = p_temp_id;
86:
87: CURSOR c_bank_number IS
88: SELECT bank_or_branch_number
89: FROM HZ_BANK_VAL_GT
90: WHERE temp_id = p_temp_id;
91:
92: CURSOR c_bank_name IS
93: SELECT organization_name
189: FETCH c_country INTO l_country;
190:
191: IF c_country%NOTFOUND THEN
192: -- Close the cursor and raise an error if the country could not be
193: -- found in the temp table HZ_BANK_VAL_GT.
194: CLOSE c_country;
195:
196: fnd_message.set_name('CE', 'CE_TEMP_NOT_FOUND');
197: fnd_message.set_token('COLUMN', 'Country');
194: CLOSE c_country;
195:
196: fnd_message.set_name('CE', 'CE_TEMP_NOT_FOUND');
197: fnd_message.set_token('COLUMN', 'Country');
198: fnd_message.set_token('TABLE', 'HZ_BANK_VAL_GT');
199: fnd_msg_pub.add;
200: RAISE NO_DATA_FOUND;
201: END IF;
202: CLOSE c_country;