eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.HZ_ORIG_SYSTEM_REF_PVT dependencies on HZ_ORIG_SYS_REFERENCES

Line 99: from hz_orig_sys_references

95: is
96:
97: cursor get_pps_ssc_csr is
98: select count(*)
99: from hz_orig_sys_references
100: where Owner_table_name = p_owner_table_name
101: and owner_table_id = p_owner_table_id
102: and status = 'A';
103:

Line 106: from hz_orig_sys_references os,hz_org_contacts org

102: and status = 'A';
103:
104: cursor get_rel_ssc_csr is
105: select count(*)
106: from hz_orig_sys_references os,hz_org_contacts org
107: where os.owner_table_id = org.org_contact_id
108: and os.owner_table_name = p_owner_table_name
109: and org.org_contact_id = p_owner_table_id
110: and os.status = 'A';

Line 710: FROM HZ_ORIG_SYS_REFERENCES

706: p_orig_system_reference in varchar2, p_owner_table_name in varchar2) return varchar2
707: is
708: cursor get_orig_sys_ref_id_csr is
709: SELECT ORIG_SYSTEM_REF_ID
710: FROM HZ_ORIG_SYS_REFERENCES
711: WHERE ORIG_SYSTEM = p_orig_system
712: and ORIG_SYSTEM_REFERENCE = p_orig_system_reference
713: and owner_table_name = p_owner_table_name
714: and status = 'A';

Line 728: FROM HZ_ORIG_SYS_REFERENCES

724: p_orig_system_reference in varchar2, p_owner_table_name in varchar2) return date
725: is
726: cursor get_start_date_csr is
727: SELECT start_date_active
728: FROM HZ_ORIG_SYS_REFERENCES
729: WHERE ORIG_SYSTEM = p_orig_system
730: and ORIG_SYSTEM_REFERENCE = p_orig_system_reference
731: and owner_table_name = p_owner_table_name
732: and rownum = 1; -- start/end_date_active only used in update and

Line 753: FROM HZ_ORIG_SYS_REFERENCES

749: x_return_status IN OUT NOCOPY VARCHAR2
750: ) is
751: cursor get_pk_by_owner_id is
752: SELECT ORIG_SYSTEM_REF_ID
753: FROM HZ_ORIG_SYS_REFERENCES
754: WHERE ORIG_SYSTEM = p_orig_sys_reference_rec.orig_system
755: and ORIG_SYSTEM_REFERENCE = p_orig_sys_reference_rec.orig_system_reference
756: and owner_table_name = p_orig_sys_reference_rec.owner_table_name
757: and owner_table_id = p_orig_sys_reference_rec.owner_table_id

Line 784: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');

780: if l_orig_system_ref_id is null
781: then
782: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
783: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_id');
784: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
785: FND_MSG_PUB.ADD;
786: x_return_status := FND_API.G_RET_STS_ERROR;
787: RAISE FND_API.G_EXC_ERROR;
788: end if;

Line 797: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');

793: if nvl(l_orig_system_ref_id,p_orig_sys_reference_rec.orig_system_ref_id)<>p_orig_sys_reference_rec.orig_system_ref_id
794: then
795: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
796: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_id+orig_system_ref_id');
797: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
798: FND_MSG_PUB.ADD;
799: x_return_status := FND_API.G_RET_STS_ERROR;
800: RAISE FND_API.G_EXC_ERROR;
801: end if;

Line 820: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');

816: elsif l_count = 0
817: then
818: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
819: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference');
820: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
821: FND_MSG_PUB.ADD;
822: x_return_status := FND_API.G_RET_STS_ERROR;
823: RAISE FND_API.G_EXC_ERROR;
824: elsif l_count = 1

Line 840: FROM HZ_ORIG_SYS_REFERENCES

836: ORIG_SYSTEM_REFERENCE
837: INTO l_object_version_number,
838: l_orig_system,
839: l_orig_system_reference
840: FROM HZ_ORIG_SYS_REFERENCES
841: WHERE orig_system_ref_id = l_orig_system_ref_id
842: FOR UPDATE OF ORIG_SYSTEM NOWAIT;
843:
844: IF NOT ((p_object_version_number is null and l_object_version_number is null)

Line 848: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');

844: IF NOT ((p_object_version_number is null and l_object_version_number is null)
845: OR (p_object_version_number = l_object_version_number))
846: THEN
847: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
848: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
849: FND_MSG_PUB.ADD;
850: x_return_status := FND_API.G_RET_STS_ERROR;
851: RAISE FND_API.G_EXC_ERROR;
852: END IF;

Line 858: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_ORIG_SYS_REFERENCES');

854: p_object_version_number := nvl(l_object_version_number, 1) + 1;
855:
856: EXCEPTION WHEN NO_DATA_FOUND THEN
857: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
858: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_ORIG_SYS_REFERENCES');
859: FND_MESSAGE.SET_TOKEN('VALUE', l_orig_system_ref_id);
860: FND_MSG_PUB.ADD;
861: RAISE FND_API.G_EXC_ERROR;
862: END;

Line 961: from hz_orig_sys_references

957: -- WE BASICALLY WANT TO ENSURE THAT SYNC GETS CALLED ONLY WHEN OWNER_TABLE_ID IS A VALID
958: -- NON-EMPTY STRING IE., IT IS NEITHER FND_G_MISS_CHAR NOR NULL.
959: -- THEREFORE , WE FETCH IT FROM DB.
960: select owner_table_id into l_temp
961: from hz_orig_sys_references
962: where orig_system_ref_id = l_orig_system_ref_id;
963:
964:
965:

Line 1080: from hz_orig_sys_references

1076: /*and status ='A'*/;
1077:
1078: cursor get_orig_system_new is
1079: select 'Y'
1080: from hz_orig_sys_references
1081: where owner_table_id = l_orig_sys_reference_rec.owner_table_id
1082: and owner_table_name = l_orig_sys_reference_rec.owner_table_name
1083: and orig_system = l_orig_sys_reference_rec.orig_system
1084: and status = 'A';

Line 1213: FROM HZ_ORIG_SYS_REFERENCES

1209: p_orig_system_reference in varchar2, p_owner_table_name in varchar2,p_owner_table_id in number) return varchar2
1210: is
1211: cursor inactive_mosr_exist_csr is
1212: SELECT 'Y'
1213: FROM HZ_ORIG_SYS_REFERENCES
1214: WHERE ORIG_SYSTEM = p_orig_system
1215: and ORIG_SYSTEM_REFERENCE = p_orig_system_reference
1216: and owner_table_name = p_owner_table_name
1217: and owner_table_id = p_owner_table_id

Line 1257: from hz_orig_sys_references

1253: /*and status='A'*/;
1254:
1255: cursor get_orig_system_new is
1256: select 'Y'
1257: from hz_orig_sys_references
1258: where owner_table_id = l_orig_sys_reference_rec.owner_table_id
1259: and owner_table_name = l_orig_sys_reference_rec.owner_table_name
1260: and orig_system = l_orig_sys_reference_rec.orig_system
1261: and status = 'A';

Line 1579: from hz_orig_sys_references

1575: x_msg_data OUT NOCOPY VARCHAR2
1576: ) is
1577: cursor get_orig_system_csr is
1578: select orig_system, orig_system_reference,orig_system_ref_id
1579: from hz_orig_sys_references
1580: where owner_table_id = p_old_owner_table_id
1581: and owner_table_name = p_owner_table_name
1582: and status = 'A'; /* Bug 3235877 */
1583:

Line 1596: and orig_system = (select orig_system from hz_orig_sys_references

1592: cursor get_multi_mosr_flag is
1593: select multi_osr_flag
1594: from hz_orig_sys_mapping
1595: where owner_table_name = p_owner_table_name
1596: and orig_system = (select orig_system from hz_orig_sys_references
1597: where owner_table_id = p_old_owner_table_id
1598: and owner_table_name = p_owner_table_name
1599: and status ='A'
1600: and rownum =1

Line 1605: from hz_orig_sys_references

1601: );
1602:
1603: cursor get_orig_system_new is
1604: select 'Y'
1605: from hz_orig_sys_references
1606: where owner_table_id = p_new_owner_table_id
1607: and owner_table_name = p_owner_table_name
1608: -- Bug 3863486
1609: and orig_system = (select orig_system from hz_orig_sys_references

Line 1609: and orig_system = (select orig_system from hz_orig_sys_references

1605: from hz_orig_sys_references
1606: where owner_table_id = p_new_owner_table_id
1607: and owner_table_name = p_owner_table_name
1608: -- Bug 3863486
1609: and orig_system = (select orig_system from hz_orig_sys_references
1610: where owner_table_id = p_old_owner_table_id
1611: and owner_table_name = p_owner_table_name
1612: and status ='A'
1613: and rownum =1)

Line 1619: from hz_orig_sys_references

1615:
1616: --bug 4261242
1617: cursor check_duplicates is
1618: select 'Y'
1619: from hz_orig_sys_references
1620: where owner_table_id = p_new_owner_table_id
1621: and owner_table_name = p_owner_table_name
1622: and orig_system || orig_system_reference = l_orig_system||l_orig_system_reference
1623: and status = 'A';

Line 1816: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');

1812: IF l_party_merge_flag = FALSE THEN /*Bug 3235877*/
1813: if p_validation_level = FND_API.G_VALID_LEVEL_FULL then--YES
1814: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
1815: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_id');
1816: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
1817: FND_MSG_PUB.ADD;
1818: x_return_status := FND_API.G_RET_STS_ERROR;
1819: end if;
1820: END IF;

Line 1865: from hz_orig_sys_references

1861: x_msg_data OUT NOCOPY VARCHAR2
1862: ) is
1863: cursor get_orig_system_csr is
1864: select orig_system, orig_system_reference, created_by_module
1865: from hz_orig_sys_references
1866: WHERE owner_table_name = p_owner_table_name
1867: and owner_table_id = p_owner_table_id
1868: and status = 'A';
1869: l_created_by_module varchar2(150);

Line 1880: and orig_system = (select orig_system from hz_orig_sys_references

1876: cursor get_multi_mosr_flag(p_orig_system NUMBER) is
1877: select multi_osr_flag
1878: from hz_orig_sys_mapping
1879: where owner_table_name = p_owner_table_name
1880: and orig_system = (select orig_system from hz_orig_sys_references
1881: where owner_table_id = p_owner_table_id
1882: and owner_table_name = p_owner_table_name
1883: and status = 'A'
1884: and rownum=1