[Home] [Help]
5: p_owner_table_name in varchar2/*,p_status in varchar2*/) return varchar2 is
6:
7: cursor orig_sys_entity_map_exist_csr is
8: select 'Y'
9: from hz_orig_sys_mapping
10: where orig_system = p_orig_system
11: and owner_table_name = p_owner_table_name/*
12: and status = nvl(p_status,status)*/;
13:
95: -- Added multi_osr_flag in cursor get_orig_sys_entity_map_csr
96:
97: cursor get_orig_sys_entity_map_csr is
98: select multiple_flag, multi_osr_flag,created_by_module, application_id
99: from hz_orig_sys_mapping
100: where orig_system = p_orig_sys_entity_map_rec.orig_system
101: and owner_table_name = p_orig_sys_entity_map_rec.owner_table_name
102: /*and status = 'A'*/;
103:
102: /*and status = 'A'*/;
103:
104: cursor seed_orig_system_exist_csr is
105: select 'Y'
106: from hz_orig_sys_mapping
107: where created_by = 1
108: and orig_system = p_orig_sys_entity_map_rec.orig_system
109: and owner_table_name = p_orig_sys_entity_map_rec.owner_table_name
110: /*and status = 'A'*/
152: if p_create_update_flag = 'U'
153: then
154: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
155: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system+owner_table_name');
156: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_MAPPING');
157: FND_MSG_PUB.ADD;
158: x_return_status := FND_API.G_RET_STS_ERROR;
159: end if;
160: end if;
295: function get_multiple_flag(p_orig_system in varchar2, p_owner_table_name in
296: varchar2) return varchar2 is
297: cursor get_multiple_flag_csr is
298: select multiple_flag
299: from hz_orig_sys_mapping
300: where orig_system = p_orig_system
301: and owner_table_name = p_owner_table_name
302: /* and status = 'A'*/;
303: l_multiple_flag varchar2(1);
382:
383:
384: -- SSM SST Integration and Extension
385: -- Instead of checking if the combination of orig_system and owner_table_name
386: -- exists in HZ_ORIG_SYS_MAPPING, check if the orig_system is a valid value from
387: -- HZ_ORIG_SYSTEMS_B and owner_table_name is a valid value from lookup TCA_OWNER_TABLE.
388: -- If these validations are satisfied, then an record will be there in HZ_ORIG_SYS_MAPPING
389: -- anyway.
390: -- Logic behind this change: The status field in HZ_ORIG_SYS_MAPPING should not be considered.
384: -- SSM SST Integration and Extension
385: -- Instead of checking if the combination of orig_system and owner_table_name
386: -- exists in HZ_ORIG_SYS_MAPPING, check if the orig_system is a valid value from
387: -- HZ_ORIG_SYSTEMS_B and owner_table_name is a valid value from lookup TCA_OWNER_TABLE.
388: -- If these validations are satisfied, then an record will be there in HZ_ORIG_SYS_MAPPING
389: -- anyway.
390: -- Logic behind this change: The status field in HZ_ORIG_SYS_MAPPING should not be considered.
391: -- However the status in HZ_ORIG_SYSTEMS_B has to be checked.
392:
386: -- exists in HZ_ORIG_SYS_MAPPING, check if the orig_system is a valid value from
387: -- HZ_ORIG_SYSTEMS_B and owner_table_name is a valid value from lookup TCA_OWNER_TABLE.
388: -- If these validations are satisfied, then an record will be there in HZ_ORIG_SYS_MAPPING
389: -- anyway.
390: -- Logic behind this change: The status field in HZ_ORIG_SYS_MAPPING should not be considered.
391: -- However the status in HZ_ORIG_SYSTEMS_B has to be checked.
392:
393: /* -- Make sure passing in orig_system and owner_table_name are validate
394: if orig_sys_entity_map_exist(p_orig_sys_reference_rec.orig_system,
395: p_orig_sys_reference_rec.owner_table_name/*,'A'*//*) = 'N'
396: then
397: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
398: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system+owner_table_name');
399: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_MAPPING');
400: FND_MSG_PUB.ADD;
401: x_return_status := FND_API.G_RET_STS_ERROR;
402: end if;
403: */