APPS.AHL_UMP_FORECAST_REQ_PVT dependencies on CSI_ITEM_INSTANCES

Line 585: CURSOR csi_item_instances_csr(p_csi_item_instance_id IN NUMBER) IS

581: p_item_instance_id IN NUMBER)
582: IS
583:
584: -- To validate instance.
585: CURSOR csi_item_instances_csr(p_csi_item_instance_id IN NUMBER) IS
586: SELECT instance_number, active_end_date
587: FROM csi_item_instances
588: WHERE instance_id = p_csi_item_instance_id;
589:

Line 587: FROM csi_item_instances

583:
584: -- To validate instance.
585: CURSOR csi_item_instances_csr(p_csi_item_instance_id IN NUMBER) IS
586: SELECT instance_number, active_end_date
587: FROM csi_item_instances
588: WHERE instance_id = p_csi_item_instance_id;
589:
590: -- To validate unit.
591: CURSOR ahl_unit_config_headers_csr (p_uc_header_id IN NUMBER) IS

Line 635: l_instance_number csi_item_instances.instance_number%TYPE;

631: l_debug_module VARCHAR2(400) := 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Build_Mat_Forecast_Stream';
632:
633: l_csi_item_instance_id NUMBER;
634: l_name ahl_unit_config_headers.name%TYPE;
635: l_instance_number csi_item_instances.instance_number%TYPE;
636: l_active_end_date DATE;
637:
638: l_config_node_tbl AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type;
639: l_master_config_id NUMBER;

Line 679: OPEN csi_item_instances_csr (p_item_instance_id);

675:
676: IF (p_unit_config_hdr_id IS NOT NULL OR p_item_instance_id IS NOT NULL) THEN
677: IF (p_item_instance_id IS NOT NULL) THEN
678: -- validate item instance.
679: OPEN csi_item_instances_csr (p_item_instance_id);
680: FETCH csi_item_instances_csr INTO l_instance_number, l_active_end_date;
681: IF (csi_item_instances_csr%NOTFOUND) THEN
682: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');
683: FND_MESSAGE.Set_Token('INST_ID', p_item_instance_id);

Line 680: FETCH csi_item_instances_csr INTO l_instance_number, l_active_end_date;

676: IF (p_unit_config_hdr_id IS NOT NULL OR p_item_instance_id IS NOT NULL) THEN
677: IF (p_item_instance_id IS NOT NULL) THEN
678: -- validate item instance.
679: OPEN csi_item_instances_csr (p_item_instance_id);
680: FETCH csi_item_instances_csr INTO l_instance_number, l_active_end_date;
681: IF (csi_item_instances_csr%NOTFOUND) THEN
682: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');
683: FND_MESSAGE.Set_Token('INST_ID', p_item_instance_id);
684: FND_MSG_PUB.ADD;

Line 681: IF (csi_item_instances_csr%NOTFOUND) THEN

677: IF (p_item_instance_id IS NOT NULL) THEN
678: -- validate item instance.
679: OPEN csi_item_instances_csr (p_item_instance_id);
680: FETCH csi_item_instances_csr INTO l_instance_number, l_active_end_date;
681: IF (csi_item_instances_csr%NOTFOUND) THEN
682: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');
683: FND_MESSAGE.Set_Token('INST_ID', p_item_instance_id);
684: FND_MSG_PUB.ADD;
685: CLOSE csi_item_instances_csr;

Line 685: CLOSE csi_item_instances_csr;

681: IF (csi_item_instances_csr%NOTFOUND) THEN
682: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');
683: FND_MESSAGE.Set_Token('INST_ID', p_item_instance_id);
684: FND_MSG_PUB.ADD;
685: CLOSE csi_item_instances_csr;
686: --dbms_output.put_line('Instance not found');
687: errbuf := FND_MSG_PUB.GET;
688: retcode := 2;
689: ELSIF (trunc(l_active_end_date) < trunc(sysdate)) THEN

Line 718: END IF; -- csi_item_instances_csr%NOTFOUND

714: l_master_config_id := NULL;
715: END IF; -- ahl_unit_config_header_csr%FOUND
716: CLOSE ahl_unit_config_header_csr;
717:
718: END IF; -- csi_item_instances_csr%NOTFOUND
719: CLOSE csi_item_instances_csr;
720:
721: END IF; -- p_item_instance_id
722:

Line 719: CLOSE csi_item_instances_csr;

715: END IF; -- ahl_unit_config_header_csr%FOUND
716: CLOSE ahl_unit_config_header_csr;
717:
718: END IF; -- csi_item_instances_csr%NOTFOUND
719: CLOSE csi_item_instances_csr;
720:
721: END IF; -- p_item_instance_id
722:
723: IF (p_unit_config_hdr_id IS NOT NULL) THEN