APPS.HZ_IMP_BATCH_SUMMARY_V2PUB dependencies on HZ_ORIG_SYSTEMS_B

Line 99: -- HZ_ORIG_SYSTEMS_B instead of the lookup.

95: x_return_status => x_return_status
96: );
97:
98: -- Bug 4179322. Modified code to validate ORIG_SYSTEM from the table
99: -- HZ_ORIG_SYSTEMS_B instead of the lookup.
100:
101: -- validate original_system against lookup ORIG_SYSTEM
102: /*
103: hz_utility_v2pub.validate_lookup (

Line 112: FROM hz_orig_systems_b

108: */
109:
110: BEGIN
111: SELECT 'Y' INTO os_exists_flag
112: FROM hz_orig_systems_b
113: WHERE
114: orig_system= p_original_system
115: AND orig_system<>'SST'
116: AND status='A';

Line 122: FND_MESSAGE.SET_TOKEN('TABLE','HZ_ORIG_SYSTEMS_B');

118: WHEN NO_DATA_FOUND THEN
119: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_FK');
120: FND_MESSAGE.SET_TOKEN('FK','orig_system');
121: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system');
122: FND_MESSAGE.SET_TOKEN('TABLE','HZ_ORIG_SYSTEMS_B');
123: FND_MSG_PUB.ADD;
124: x_return_status := FND_API.G_RET_STS_ERROR;
125: END;
126: