[Home] [Help]
69: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
70: | |
71: | ARGUMENTS |
72: | IN: |
73: | p_temp_id in HZ_ORG_PROFILE_VAL_GT table |
74: +=======================================================================*/
75: PROCEDURE validate_bank (p_temp_id IN NUMBER,
76: x_return_status IN OUT NOCOPY VARCHAR2) IS
77: l_bank_name_rowid VARCHAR2(1000);
86: l_short_name VARCHAR2(240) := NULL;
87: l_short_name_null VARCHAR2(1) := 'N';
88: l_bank_number VARCHAR2(60) := NULL;
89:
90: /* records in HZ_BANK_VAL_GT and hz_org_profile_val_gt share the same temp_id */
91:
92: CURSOR c_country IS
93: SELECT country
94: FROM HZ_BANK_VAL_GT
100: WHERE temp_id = p_temp_id;
101:
102: CURSOR c_bank_name IS
103: SELECT organization_name
104: FROM hz_org_profile_val_gt
105: WHERE temp_id = p_temp_id;
106:
107: -- Cursor to check for duplicate of combination of name-number-country.
108: CURSOR c_bank_name_number_uk IS
149: OPEN c_bank_name;
150: FETCH c_bank_name INTO l_bank_name;
151: IF c_bank_name%NOTFOUND THEN
152: -- Close the cursor and raise an error if the org_name could not be
153: -- found in the temp table hz_org_profile_val_gt.
154: CLOSE c_bank_name;
155:
156: fnd_message.set_name('CE', 'CE_TEMP_NOT_FOUND');
157: fnd_message.set_token('COLUMN', 'Organization_name');
154: CLOSE c_bank_name;
155:
156: fnd_message.set_name('CE', 'CE_TEMP_NOT_FOUND');
157: fnd_message.set_token('COLUMN', 'Organization_name');
158: fnd_message.set_token('TABLE', 'HZ_ORG_PROFILE_VAL_GT');
159: fnd_msg_pub.add;
160: RAISE NO_DATA_FOUND;
161: END IF;
162: CLOSE c_bank_name;
215: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
216: | |
217: | ARGUMENTS |
218: | IN: |
219: | p_temp_org_profile_id temp_id in HZ_ORG_PROFILE_VAL_GT table |
220: +=======================================================================*/
221: PROCEDURE validate_branch (p_temp_org_profile_id IN NUMBER,
222: x_return_status IN OUT NOCOPY VARCHAR2)
223: IS