APPS.AHL_UC_INSTANCE_PVT dependencies on MTL_ITEM_REVISIONS

Line 163: CURSOR mtl_item_revisions_csr(c_inventory_id IN NUMBER,

159: p_organization_id IN NUMBER,
160: p_revision_qty_control_code IN NUMBER,
161: p_Revision IN VARCHAR2,
162: p_concatenated_segments IN VARCHAR2) IS
163: CURSOR mtl_item_revisions_csr(c_inventory_id IN NUMBER,
164: c_organization_id IN NUMBER,
165: c_revision IN VARCHAR2) IS
166: SELECT 'X'
167: FROM mtl_item_revisions

Line 167: FROM mtl_item_revisions

163: CURSOR mtl_item_revisions_csr(c_inventory_id IN NUMBER,
164: c_organization_id IN NUMBER,
165: c_revision IN VARCHAR2) IS
166: SELECT 'X'
167: FROM mtl_item_revisions
168: WHERE inventory_item_id = c_inventory_id
169: AND organization_id = c_organization_id
170: AND revision = c_revision;
171: l_junk VARCHAR2(1);

Line 181: OPEN mtl_item_revisions_csr(p_inventory_id,p_organization_id, p_revision);

177: FND_MESSAGE.set_token('INV_ITEM',p_concatenated_segments);
178: FND_MSG_PUB.add;
179: --dbms_output.put_line('Revision is null');
180: ELSE
181: OPEN mtl_item_revisions_csr(p_inventory_id,p_organization_id, p_revision);
182: FETCH mtl_item_revisions_csr INTO l_junk;
183: IF (mtl_item_revisions_csr%NOTFOUND) THEN
184: FND_MESSAGE.set_name('AHL','AHL_UC_REV_INVALID');
185: FND_MESSAGE.set_token('REV',p_revision);

Line 182: FETCH mtl_item_revisions_csr INTO l_junk;

178: FND_MSG_PUB.add;
179: --dbms_output.put_line('Revision is null');
180: ELSE
181: OPEN mtl_item_revisions_csr(p_inventory_id,p_organization_id, p_revision);
182: FETCH mtl_item_revisions_csr INTO l_junk;
183: IF (mtl_item_revisions_csr%NOTFOUND) THEN
184: FND_MESSAGE.set_name('AHL','AHL_UC_REV_INVALID');
185: FND_MESSAGE.set_token('REV',p_revision);
186: FND_MESSAGE.set_token('INV_ITEM',p_concatenated_segments);

Line 183: IF (mtl_item_revisions_csr%NOTFOUND) THEN

179: --dbms_output.put_line('Revision is null');
180: ELSE
181: OPEN mtl_item_revisions_csr(p_inventory_id,p_organization_id, p_revision);
182: FETCH mtl_item_revisions_csr INTO l_junk;
183: IF (mtl_item_revisions_csr%NOTFOUND) THEN
184: FND_MESSAGE.set_name('AHL','AHL_UC_REV_INVALID');
185: FND_MESSAGE.set_token('REV',p_revision);
186: FND_MESSAGE.set_token('INV_ITEM',p_concatenated_segments);
187: FND_MSG_PUB.add;

Line 190: CLOSE mtl_item_revisions_csr;

186: FND_MESSAGE.set_token('INV_ITEM',p_concatenated_segments);
187: FND_MSG_PUB.add;
188: --dbms_output.put_line('Revision does not exist in master');
189: END IF;
190: CLOSE mtl_item_revisions_csr;
191: END IF;
192: ELSIF (p_revision IS NOT NULL) AND (p_revision <> FND_API.G_MISS_CHAR) THEN
193: FND_MESSAGE.set_name('AHL','AHL_UC_REV_NOTNULL');
194: --FND_MESSAGE.set_token('REV',p_revision);