APPS.HZ_MOSR_VALIDATE_PKG dependencies on HZ_ORIG_SYS_REFERENCES

Line 29: FROM HZ_ORIG_SYS_REFERENCES

25: function get_orig_system_ref_count(p_orig_system in varchar2,p_orig_system_reference in varchar2, p_owner_table_name in varchar2) return varchar2
26: is
27: cursor get_orig_sys_ref_count_csr is
28: SELECT count(*)
29: FROM HZ_ORIG_SYS_REFERENCES
30: WHERE ORIG_SYSTEM = p_orig_system
31: and ORIG_SYSTEM_REFERENCE = p_orig_system_reference
32: and owner_table_name = p_owner_table_name
33: and status = 'A';

Line 48: from hz_orig_sys_references

44: varchar2) return varchar2 is
45:
46: cursor orig_sys_reference_exist_csr is
47: select 'Y'
48: from hz_orig_sys_references
49: where orig_system = p_orig_system
50: and orig_system_reference = p_orig_system_ref
51: and owner_table_name = p_owner_table_name
52: and status = 'A'

Line 72: from hz_orig_sys_references

68: varchar2) return varchar2 is
69:
70: cursor orig_sys_reference_exist_csr is
71: select 'Y'
72: from hz_orig_sys_references
73: where orig_system = p_orig_system
74: and orig_system_reference = p_orig_system_ref
75: and owner_table_name = p_owner_table_name
76: and rownum = 1; -- allow update case: update status from 'I' to 'A'

Line 116: from hz_orig_sys_references

112:
113: --MOSR phase 2 modifications
114: cursor mosr_rec_exists is
115: select 'Y'
116: from hz_orig_sys_references
117: where orig_system = p_orig_sys_entity_map_rec.orig_system
118: and owner_table_name = p_orig_sys_entity_map_rec.owner_table_name
119: -- Bug 4956761 : Corrected to get result if there are multiple MOSR for single entity
120: and status = 'A'

Line 319: from hz_orig_sys_references

315:
316: ) is
317: cursor get_orig_sys_reference_csr is
318: select start_date_active,end_date_active
319: from hz_orig_sys_references
320: where orig_system = p_orig_sys_reference_rec.orig_system
321: and orig_system_reference =nvl(p_orig_sys_reference_rec.old_orig_system_reference,
322: p_orig_sys_reference_rec.orig_system_reference)
323: and owner_table_name = p_orig_sys_reference_rec.owner_table_name

Line 329: from hz_orig_sys_references

325: -- only if unique, we allow update.
326:
327: cursor get_dup_orig_sys_ref_csr is
328: select 'Y'
329: from hz_orig_sys_references
330: where orig_system = p_orig_sys_reference_rec.orig_system
331: and orig_system_reference = p_orig_sys_reference_rec.orig_system_reference
332: and owner_table_name = p_orig_sys_reference_rec.owner_table_name
333: and owner_table_id = p_orig_sys_reference_rec.owner_table_id

Line 338: from hz_orig_sys_references

334: and status = 'A';
335:
336: cursor get_nonupdateable_columns1 is
337: select created_by_module, application_id
338: from hz_orig_sys_references
339: where orig_system = p_orig_sys_reference_rec.orig_system
340: and orig_system_reference = p_orig_sys_reference_rec.orig_system_reference
341: and owner_table_name = p_orig_sys_reference_rec.owner_table_name
342: and owner_table_id = p_orig_sys_reference_rec.owner_table_id

Line 347: from hz_orig_sys_references

343: and status = 'A';
344: /* Bug Fix: 4869208 */
345: cursor get_nonupdateable_columns2 is
346: select created_by_module, application_id
347: from hz_orig_sys_references
348: where orig_system_ref_id = p_orig_sys_reference_rec.orig_system_ref_id;
349:
350: l_multiple_flag varchar2(1);
351: l_created_by_module varchar2(150);

Line 826: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system+orig_system_reference+owner_table_name'); FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');

822: (p_orig_sys_reference_rec.old_orig_system_reference is null
823: or p_orig_sys_reference_rec.old_orig_system_reference = fnd_api.g_miss_char)
824: then
825: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
826: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system+orig_system_reference+owner_table_name'); FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
827: FND_MSG_PUB.ADD;
828: x_return_status := FND_API.G_RET_STS_ERROR;
829: end if;
830:

Line 839: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system+old_orig_system_reference+owner_table_name'); FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');

835: p_orig_sys_reference_rec.old_orig_system_reference,
836: p_orig_sys_reference_rec.owner_table_name) = 'N'
837: then
838: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
839: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system+old_orig_system_reference+owner_table_name'); FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
840: FND_MSG_PUB.ADD;
841: x_return_status := FND_API.G_RET_STS_ERROR;
842: end if;
843: end if;