APPS.HZ_ORIG_SYSTEM_REF_PKG dependencies on HZ_ORIG_SYS_REFERENCES

Line 49: INSERT INTO HZ_ORIG_SYS_REFERENCES (

45: IF x_orig_system_ref_id = FND_API.G_MISS_NUM THEN
46: x_orig_system_ref_id := NULL;
47: END IF;
48:
49: INSERT INTO HZ_ORIG_SYS_REFERENCES (
50: orig_system_ref_id,
51: orig_system,
52: orig_system_reference,
53: owner_table_name,

Line 248: UPDATE HZ_ORIG_SYS_REFERENCES

244: x_attribute20 IN VARCHAR2
245: ) IS
246: BEGIN
247:
248: UPDATE HZ_ORIG_SYS_REFERENCES
249: SET
250: orig_system_ref_id =
251: DECODE(x_orig_system_ref_id,
252: NULL, orig_system_ref_id,

Line 481: SELECT * FROM HZ_ORIG_SYS_REFERENCES

477: x_attribute20 IN VARCHAR2
478: ) IS
479:
480: CURSOR c IS
481: SELECT * FROM HZ_ORIG_SYS_REFERENCES
482: WHERE rowid = x_rowid
483: FOR UPDATE NOWAIT;
484: Recinfo c%ROWTYPE;
485:

Line 740: FROM HZ_ORIG_SYS_REFERENCES

736: x_attribute17,
737: x_attribute18,
738: x_attribute19,
739: x_attribute20
740: FROM HZ_ORIG_SYS_REFERENCES
741: WHERE orig_system_ref_id = x_orig_system_ref_id;
742:
743: EXCEPTION
744: WHEN NO_DATA_FOUND THEN

Line 758: DELETE FROM HZ_ORIG_SYS_REFERENCES

754: x_orig_system_ref_id IN NUMBER
755: ) IS
756: BEGIN
757:
758: DELETE FROM HZ_ORIG_SYS_REFERENCES
759: WHERE orig_system_ref_id = x_orig_system_ref_id;
760:
761: IF ( SQL%NOTFOUND ) THEN
762: RAISE NO_DATA_FOUND;