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.

APPS.AHL_MC_ITEM_COMP_PUB dependencies on MTL_PARAMETERS

Line 24: CURSOR mtl_parameters_csr (p_org_code IN VARCHAR2) IS

20:
21: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;
22:
23:
24: CURSOR mtl_parameters_csr (p_org_code IN VARCHAR2) IS
25: SELECT organization_id
26: FROM mtl_parameters
27: WHERE organization_code = p_org_code;
28:

Line 26: FROM mtl_parameters

22:
23:
24: CURSOR mtl_parameters_csr (p_org_code IN VARCHAR2) IS
25: SELECT organization_id
26: FROM mtl_parameters
27: WHERE organization_code = p_org_code;
28:
29:
30: CURSOR mtl_system_items_csr(p_inventory_item_name IN VARCHAR2,

Line 76: OPEN mtl_parameters_csr (p_x_ic_header_rec.inventory_org_code);

72:
73: IF p_x_ic_header_rec.inventory_org_id IS NULL THEN
74:
75: IF p_x_ic_header_rec.inventory_org_code IS NOT NULL THEN
76: OPEN mtl_parameters_csr (p_x_ic_header_rec.inventory_org_code);
77: FETCH mtl_parameters_csr INTO l_inv_org_id;
78: IF (mtl_parameters_csr%FOUND) THEN
79: p_x_ic_header_rec.inventory_org_id := l_inv_org_id;
80: ELSE

Line 77: FETCH mtl_parameters_csr INTO l_inv_org_id;

73: IF p_x_ic_header_rec.inventory_org_id IS NULL THEN
74:
75: IF p_x_ic_header_rec.inventory_org_code IS NOT NULL THEN
76: OPEN mtl_parameters_csr (p_x_ic_header_rec.inventory_org_code);
77: FETCH mtl_parameters_csr INTO l_inv_org_id;
78: IF (mtl_parameters_csr%FOUND) THEN
79: p_x_ic_header_rec.inventory_org_id := l_inv_org_id;
80: ELSE
81: FND_MESSAGE.Set_Name('AHL','AHL_MC_ORG_INVALID');

Line 78: IF (mtl_parameters_csr%FOUND) THEN

74:
75: IF p_x_ic_header_rec.inventory_org_code IS NOT NULL THEN
76: OPEN mtl_parameters_csr (p_x_ic_header_rec.inventory_org_code);
77: FETCH mtl_parameters_csr INTO l_inv_org_id;
78: IF (mtl_parameters_csr%FOUND) THEN
79: p_x_ic_header_rec.inventory_org_id := l_inv_org_id;
80: ELSE
81: FND_MESSAGE.Set_Name('AHL','AHL_MC_ORG_INVALID');
82: FND_MESSAGE.Set_Token('ORG',p_x_ic_header_rec.inventory_org_code);

Line 269: CURSOR mtl_parameters_csr (p_org_code IN VARCHAR2) IS

265: AND status_code = 'COMPLETE'
266: AND type_code = 'NON-TRACKED';
267:
268: -- For organization id.
269: CURSOR mtl_parameters_csr (p_org_code IN VARCHAR2) IS
270: SELECT organization_id
271: FROM mtl_parameters
272: WHERE organization_code = p_org_code;
273:

Line 271: FROM mtl_parameters

267:
268: -- For organization id.
269: CURSOR mtl_parameters_csr (p_org_code IN VARCHAR2) IS
270: SELECT organization_id
271: FROM mtl_parameters
272: WHERE organization_code = p_org_code;
273:
274: -- For inventory_item_id.
275: CURSOR mtl_system_items_csr(p_inventory_item_name IN VARCHAR2,

Line 334: OPEN mtl_parameters_csr (l_item_comp_rec.inventory_org_code);

330: THEN
331: -- if code is present.
332: IF (l_item_comp_rec.inventory_org_code IS NOT NULL) AND
333: (l_item_comp_rec.inventory_org_code <> FND_API.G_MISS_CHAR) THEN
334: OPEN mtl_parameters_csr (l_item_comp_rec.inventory_org_code);
335: FETCH mtl_parameters_csr INTO l_inventory_org_id;
336: IF (mtl_parameters_csr%FOUND) THEN
337: l_item_comp_rec.inventory_org_id := l_inventory_org_id;
338: ELSE

Line 335: FETCH mtl_parameters_csr INTO l_inventory_org_id;

331: -- if code is present.
332: IF (l_item_comp_rec.inventory_org_code IS NOT NULL) AND
333: (l_item_comp_rec.inventory_org_code <> FND_API.G_MISS_CHAR) THEN
334: OPEN mtl_parameters_csr (l_item_comp_rec.inventory_org_code);
335: FETCH mtl_parameters_csr INTO l_inventory_org_id;
336: IF (mtl_parameters_csr%FOUND) THEN
337: l_item_comp_rec.inventory_org_id := l_inventory_org_id;
338: ELSE
339: FND_MESSAGE.Set_Name('AHL','AHL_MC_ORG_INVALID');

Line 336: IF (mtl_parameters_csr%FOUND) THEN

332: IF (l_item_comp_rec.inventory_org_code IS NOT NULL) AND
333: (l_item_comp_rec.inventory_org_code <> FND_API.G_MISS_CHAR) THEN
334: OPEN mtl_parameters_csr (l_item_comp_rec.inventory_org_code);
335: FETCH mtl_parameters_csr INTO l_inventory_org_id;
336: IF (mtl_parameters_csr%FOUND) THEN
337: l_item_comp_rec.inventory_org_id := l_inventory_org_id;
338: ELSE
339: FND_MESSAGE.Set_Name('AHL','AHL_MC_ORG_INVALID');
340: FND_MESSAGE.Set_Token('ORG',l_item_comp_rec.inventory_org_code);

Line 343: CLOSE mtl_parameters_csr;

339: FND_MESSAGE.Set_Name('AHL','AHL_MC_ORG_INVALID');
340: FND_MESSAGE.Set_Token('ORG',l_item_comp_rec.inventory_org_code);
341: FND_MSG_PUB.ADD;
342: END IF;
343: CLOSE mtl_parameters_csr;
344: ELSIF (l_item_comp_rec.operation_flag = 'C') THEN
345: -- Both ID and code are missing.
346: FND_MESSAGE.Set_Name('AHL','AHL_MC_ORG_NULL');
347: FND_MSG_PUB.ADD;