APPS.AHL_PRD_BLK_PARTS_CHANGE_PVT dependencies on AHL_UC_INSTANCE_PVT

Line 677: l_available_instance_tbl AHL_UC_INSTANCE_PVT.Available_Instance_Tbl_Type;

673: l_plan_id NUMBER;
674: l_coll_plan_id NUMBER;
675: l_quality_setup VARCHAR2(1) := 'N';
676:
677: l_available_instance_tbl AHL_UC_INSTANCE_PVT.Available_Instance_Tbl_Type;
678: l_total_available_instances NUMBER;
679: l_avai_inst_row NUMBER;
680:
681: /* Following Record Type will be used to store PL/SQL table of UC Positions' row indexes (i.e. row indexes of

Line 1185: -- Call API AHL_UC_INSTANCE_PVT.Get_Available_Instances to find all available instances that

1181: (UC_NODE AND
1182: NVL(l_uc_details_tbl(l_curr_row).curr_quantity, 0) < l_uc_details_tbl(l_curr_row).qty_per_position) AND
1183: l_uc_details_tbl(l_curr_row).is_controlled_position = 'N') THEN
1184:
1185: -- Call API AHL_UC_INSTANCE_PVT.Get_Available_Instances to find all available instances that
1186: -- can be installed at the current position.
1187: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1188: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Invoking API AHL_UC_INSTANCE_PVT.Get_Available_Instances for parameters: ');
1189: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Parent Instance Id = ' || l_uc_details_tbl(l_curr_row).parent_instance_id);

Line 1188: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Invoking API AHL_UC_INSTANCE_PVT.Get_Available_Instances for parameters: ');

1184:
1185: -- Call API AHL_UC_INSTANCE_PVT.Get_Available_Instances to find all available instances that
1186: -- can be installed at the current position.
1187: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1188: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Invoking API AHL_UC_INSTANCE_PVT.Get_Available_Instances for parameters: ');
1189: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Parent Instance Id = ' || l_uc_details_tbl(l_curr_row).parent_instance_id);
1190: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Relationship Id = ' || l_uc_details_tbl(l_curr_row).relationship_id);
1191: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Workorder Id = ' || p_workorder_id);
1192: END IF;

Line 1194: AHL_UC_INSTANCE_PVT.Get_Available_Instances

1190: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Relationship Id = ' || l_uc_details_tbl(l_curr_row).relationship_id);
1191: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'Workorder Id = ' || p_workorder_id);
1192: END IF;
1193:
1194: AHL_UC_INSTANCE_PVT.Get_Available_Instances
1195: (
1196: p_api_version => 1.0,
1197: p_init_msg_list => FND_API.G_FALSE,
1198: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1213: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'After call to API AHL_UC_INSTANCE_PVT.Get_Available_Instances. Return Status=' || l_return_status

1209: x_tbl_count => l_total_available_instances
1210: );
1211:
1212: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1213: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'After call to API AHL_UC_INSTANCE_PVT.Get_Available_Instances. Return Status=' || l_return_status
1214: || ' Total Available Instances=' || l_total_available_instances);
1215: END IF;
1216:
1217: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN